Wednesday, March 17, 2010

How to delete a attachment from backend (fnd_attached_documents2_pkg.delete_attachments)

declare 
l_entity_name varchar2(20):= 'PO_LINES';   
l_pk1_value varchar2 (20) := '200487';     
l_delete_document_flag varchar2 (1):= 'Y';    
begin
fnd_global.apps_initialize ( user_id      => &v_user_id
                                                        ,resp_id      => &v_resp_id
                                                       ,resp_appl_id => &v_resp_appl_id);
fnd_attached_documents2_pkg.delete_attachments
( X_entity_name                             => l_entity_name
, X_pk1_value                                   => l_pk1_value
, X_delete_document_flag         => l_delete_document_flag);
end;
/
commit;

2 Responses to “How to delete a attachment from backend (fnd_attached_documents2_pkg.delete_attachments)”

Swapnil Dandgvhal said...
April 18, 2016 at 9:03 AM

thnx a lot :)


Muhammad Mohi Uddin said...
September 18, 2017 at 9:45 PM

Hi,

Any problem you faced after deletion of attachment by using mention API. Actually i want to used that in production environment.


Regards,


Post a Comment

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.