Tag: PL-SQL

PO Update needs to be done? Programmatically? Well, Oracle has provided an API to do just that. API Name is po_document_update_grp.update_document. Below is a sample PO Update Script which we can use to delete the shipments. Alter the cursor for your requirement. Set Serveroutput on;/ --PO Update ScriptDECLARELV_PO_HEADER_ID NUMBER := 11551815; CURSOR GET_rECORDS(p_in_n_po_header_id IN NUMBER… Continue reading PO Update Script in Oracle R12