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.
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!

3 comments:

  1. Another way of deleting document Attachments via fnd_attached_documents correspondence with reader is good.

    sap upgrade

    ReplyDelete
  2. i have a question about this excel output format.
    i 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 ?

    ReplyDelete
  3. Hi 蔡佩君,

    In the browser choose file > Save as, and save the file then open it in Excel.

    Regards,
    Gareth

    ReplyDelete