Friday, May 22, 2020

API to create Purchase order Acknowledgement (po_change_api1_s.record_acceptance)

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

Instance: R12

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;

0 Responses to “API to create Purchase order Acknowledgement (po_change_api1_s.record_acceptance)”

Post a Comment


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.