declare l_entity_name varchar2(20):= 'PO_LINES'; -- PO_LINES entity for the package l_pk1_value varchar2 (20) := '200487'; -- PO_LINE_ID attachments are attached to l_delete_document_flag varchar2 (1) := 'Y'; -- Delete document begin fnd_global.apps_initialize(0,20420,1); -- SYSADMIN, System Administrator 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;Nice, but use with caution!
Thursday, October 11, 2007
Deleting Document Attachments via fnd_attached_documents2_pkg - PO Lines
A quick correspondence with reader Mark L came up with the following to delete PO Line attachments. This is in relation to my blog on document attachments.
Another way of deleting document Attachments via fnd_attached_documents correspondence with reader is good.
ReplyDeletesap upgrade
i have a question about this excel output format.
ReplyDeletei saw the picture you posted, the excel file show within the browser, how could i make the excel export to an "really" .xls file, that i can edit directly ?
Hi 蔡佩君,
ReplyDeleteIn the browser choose file > Save as, and save the file then open it in Excel.
Regards,
Gareth