Database Software

Hi

I need to have attachment sent my the workflow mailer...

i followed the below steps.

In the standard oracle workflow - APINV

created a attribute 'XXX_TEST_ATTR'
created a message and attached the attribute "XXX_TEST_ATTR" to it...

i have created a custom pkg XXX_AP_WFAPPROVAL_PKG which is the copy of AP_WFAPPROVAL_PKG

and added the below code in the procedure notification_handler
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));

In the workflow i have replaced the AP_WFAPPROVAL_PKG.notification_handler --> XXX_AP_WFAPPROVAL_PKG.notification_handler

i am getting the mailer notification... the standard functionality, but i am not getting the attachment document(word doc) for which the workflow is modified..

can you pls help me out... where i went wrong...

Regards
Yram