Core Workflow - EBS (MOSC)

MOSC Banner

Multiple attachment to PO workflow

edited May 27, 2020 5:07AM in Core Workflow - EBS (MOSC) 1 commentAnswered

I am trying to attach multiple documents attached to the PO to PO workflow notification. The documents always get overwritten and only the last document gets attached to the notification. Can this be achieved? I am using 'PLSQLBLOB:XX_AME_APPR_PKG.set_po_attachment/'||l_document_id);

PROCEDURE set_po_attachment (
    document_id IN VARCHAR2
  , display_type IN VARCHAR2
  , document IN OUT BLOB
  , document_type IN OUT VARCHAR2)
IS
    c_module CONSTANT VARCHAR2(100) := 'XX_AME_APPR_PKG.set_po_attachment';
   
    l_invoice_id   VARCHAR2(100) := document_id;
    l_lob_id       NUMBER;
    l_bdoc         BLOB;
    l_content_type VARCHAR2(100);
    l_filename     VARCHAR2(300);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center