Loading

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;

1 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 :)


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.