Requisition api.api to update po_requisition_headers_all.api to update po_requisition_headers_all

Requisition api.api to update po_requisition_headers_all

In this post , we will share how to update Purchase Order Requisitions in Oracle apps. Oracle has provided the API to update the Purchase requisitions information's. Here below the Requisition api detail information. api to update po_requisition_headers_all

 

 

 

 

api to update po_requisition_headers_all

api to update po_req_distributions_all

requisition api

 

 

 

 

DECLARE

  l_req_hdr      PO_REQUISITION_UPDATE_PUB.req_hdr;

  l_req_line_tbl PO_REQUISITION_UPDATE_PUB.req_line_tbl;

  l_req_dist_dtl PO_REQUISITION_UPDATE_PUB.req_dist_tbl;

  l_return_status  VARCHAR2(1);

  l_msg_count      NUMBER;

  l_msg_data       VARCHAR2(2000);

 BEGIN

   l_req_hdr.requisition_header_id             := 35554;

  l_req_hdr.org_id                            := 85;

  l_req_line_tbl(1).requisition_header_id     := 35554;

  l_req_line_tbl(1).requisition_line_id       := 6778995;

  l_req_line_tbl(1).suggested_vendor_name     := ‘TPT';

  l_req_line_tbl(1).suggested_vendor_location :=’DELHI’;

 

  PO_REQUISITION_UPDATE_PUB.update_requisition

  (p_init_msg_list   => 'T',

   p_commit          => 'F',

   x_return_status   => l_return_status,

   x_msg_count       => l_msg_count,

   x_msg_data        => l_msg_data,

   p_submit_approval => 'N',

   p_req_hdr         => l_req_hdr,

   p_req_line_tbl    => l_req_line_tbl,

   p_req_dist_tbl    => l_req_dist_dtl

   );

  DBMS_OUTPUT.PUT_LINE('Return Status :' || l_return_status);

  DBMS_OUTPUT.PUT_LINE('Msg Count :' || l_msg_count);

  DBMS_OUTPUT.PUT_LINE('Msg Data :' || l_msg_data);

 

END;

 

Requisition api.api to update po_requisition_headers_all.api to update po_requisition_headers_all