Procurement - EBS (MOSC)

MOSC Banner

12.1.3 PO_REQ_DOCUMENT_CANCEL_PVT.cancel_requisition API error wrong types OR wrong no of arguments

edited Mar 25, 2021 10:45PM in Procurement - EBS (MOSC) Question

DECLARE

  l_api_version  CONSTANT NUMBER := 1.0;

  x_return_status     VARCHAR2 (2000);

  x_msg_count       NUMBER;

  x_msg_data        VARCHAR2 (2000);

  v_req_header_id     po_requisition_headers_all.requisition_header_id%TYPE;

  v_req_line_id      po_requisition_lines_all.requisition_line_id%TYPE;

  v_source         po_requisition_headers_all.apps_source_code%TYPE;


  CURSOR c_reqs_cur

  IS

    SELECT prha.requisition_header_id,

        prla.requisition_line_id,

        prha.apps_source_code

     FROM po.po_requisition_headers_all prha,

        po.po_requisition_lines_all  prla

     WHERE   prha.requisition_header_id = prla.requisition_header_id

        AND EXISTS

            (SELECT 1

             FROM po_requisition_headers_all cr

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center