Has this worked for anyone wanting to: AP Attachment code (EBS)
The below code is the part of the custom code in the PKG AP_WFAPPROVAL_PKG
i observed that "'PLSQLBLOB:xxx_workflow_pkg.xx_notif_attach_procedure/' || to_char(l_file_id));" is not working by adding debug msg, temp table.
Can you let me know how to use 'PLSQLBLOB:xxx_workflow_pkg.xx_notif_attach_procedure/' || to_char(l_file_id))
in the package (AP_WFAPPROVAL_PKG) ...
select fl.file_id
into l_file_id
from
ap_invoices_all ai,
FND_ATTACHED_DOCS_FORM_VL fad,
fnd_lobs fl
where ai.invoice_id= fad.pk1_value
and fad.MEDIA_ID = fl.file_id
and ai.invoice_id =substr(itemkey, 1, instr(itemkey,'_')-1)
group by fl.file_id;
wf_engine.setitemattrdocument
(itemtype=>itemtype
, itemkey=>itemkey
, aname=>XXX_TEST_ATTR'
, documentid =>'PLSQLBLOB:xxx_workflow_pkg.xx_notif_attach_procedure/' || to_char(l_file_id));