注意 更新采购订单行上字段,除了弹性域字段,会默认升版本
DECLARE
l_result NUMBER;
l_progress NUMBER;
l_errors PO_API_ERRORS_REC_TYPE;
l_chg PO_CHANGES_REC_TYPE;
l_shipment_changes PO_SHIPMENTS_REC_TYPE;
l_return_status VARCHAR2(30);
BEGIN
--to set org context in a R12 env
mo_global.set_policy_context ('S', &org_id);
-- Create an Object for Changes
-- po_changes_rec_type constructor takes either po_header_id OR po_release_id to construct the object. In case of purchase order pass po_release_id as NULL.
l_chg := po_changes_rec_type.Create_object(p_po_header_id => <header id>, p_po_release_id => <release id>);
-- Add a Line Changes to the Change Object
l_chg.line_changes.add_change(p_po_line_id => <po line id>