Friday 7 September 2012

API to Update Standard Purchase Order in Oracle Apps

Po_Change_Api1_S.update_po

-- Call the update_po API
          l_result := Po_Change_Api1_S.update_po (
           x_po_number               =>      v_spphi_document_number,
           x_release_number         =>      c_release_num,
           x_revision_number        =>      c_revision_num,
           x_line_number               =>      v_sppli_line_number,
           x_shipment_number      =>      c_shipment_number,
           new_quantity                =>      v_sppli_quantity,
           new_price                    =>      v_sppli_unit_price,
           new_promised_date     =>      v_spphi_effective_date,
           launch_approvals_flag  =>      c_launch_approvals_flag,
           update_source             =>      c_update_source,
           version                        =>      '1.0',
           x_api_errors                =>      l_api_errors,
                                 -- <INVCONV R12 START>
                                p_secondary_quantity     =>     null,
                                p_preferred_grade        =>     null,
                                -- <INVCONV R12 END>
                                p_org_id                 =>      P_OrgId
                   );
                   

2 comments:

  1. Need to update PO Shipment Status to 'Closed to Receive', Is there any API available.?

    ReplyDelete
  2. Need to update GL date in PO Distributions. Any API available.

    ReplyDelete