12.1.3 PO_REQ_DOCUMENT_CANCEL_PVT.cancel_requisition API error wrong types OR wrong no of arguments
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