Oracle Apps Knowledge Sharing

                In this post, we have given a script to create Purchase Order acknowledgment from supplier in PO_ACCEPTANCES table.

SET SERVEROUTPUT ON;
DECLARE
 result NUMBER := NULL;
BEGIN
 -- Initialize the session as Buyer of the PO
 FND_GLOBAL.APPS_INITIALIZE (1234, 52649, 201);
 MO_GLOBAL.INIT('PO');
 MO_GLOBAL.set_policy_context('S',123);
 result :=
 po_change_api1_s.record_acceptance
 ('1031000324', --- PO Num
   NULL,        --- Release Num
   '0',         --- Revision Num
   'NEW',       --- Action
   SYSDATE,     --- Action Date
   105,         --- Buyer id
   'Y',         --- Acceptance flag 'Y’ or 'N’
   'Accepted Terms', --- Acceptance lookup code
   'Accepted from Backend', --- Note
   'CHANGEPO',  -- x_interface_type 
    PO_INTERFACE_ERRORS_S.nextval, --  x_transaction_id 
   '1.0',       -- Version Number
   123          -- org_id
 ); 
 COMMIT;
 
 DBMS_OUTPUT.PUT_LINE('Result:'||result);
END;