[Home] [Help]
97: -- and approved amount
98: --Parameter :
99: --IN : p_po_header_id IN NUMBER Required
100: -- corresponds to the columne PO_HEADER_ID in the table
101: -- PO_HEADERS_ALL, and identifies the PO for which the
102: -- information should be retrieved.
103: --
104: --OUT : x_ordered OUT NUMBER
105: -- total ordered amount for the PO
165: -- p_wc_stage IN VARCHAR2 Required
166: -- specifies the stage of the WC (INTERFACE or SHIPMENT)
167: -- p_po_header_id IN NUMBER Required
168: -- corresponds to the columne PO_HEADER_ID in the table
169: -- PO_HEADERS_ALL, and identifies the PO for which the
170: -- information should be retrieved.
171: -- p_wc_request_date IN DATE Required
172: -- provides date information for time-sensitive info
173: -- p_vendor_id IN NUMBER Required
345: --Function : Retrieve PO related info of a WC
346: --Parameter :
347: --IN : p_po_header_id IN NUMBER Required
348: -- corresponds to the columne PO_HEADER_ID in the table
349: -- PO_HEADERS_ALL, and identifies the PO for which the
350: -- information should be retrieved.
351: --OUT : x_po_ordered OUT NUMBER
352: -- PO total of MILESTONE, LUMPSUM, RATE and DELIVERY
353: -- pay items
401: INTO
402: l_po_header_id, x_po_num, x_po_currency_code
403: FROM
404: RCV_TRANSACTIONS_INTERFACE RTI,
405: PO_HEADERS_ALL POH
406: WHERE
407: POH.PO_HEADER_ID = RTI.PO_HEADER_ID AND
408: RTI.HEADER_INTERFACE_ID = p_wc_header_id;
409:
416: INTO
417: l_po_header_id, x_po_num, x_po_currency_code
418: FROM
419: RCV_SHIPMENT_LINES RSL,
420: PO_HEADERS_ALL POH
421: WHERE
422: POH.PO_HEADER_ID = RSL.PO_HEADER_ID AND
423: RSL.SHIPMENT_HEADER_ID = p_wc_header_id;
424:
482: --Function : A Wrapper to PO API to retrieve PO numerical information
483: --Parameter :
484: --IN : p_po_header_id IN NUMBER Required
485: -- corresponds to the column PO_HEADER_ID in the table
486: -- PO_HEADERS_ALL, and identifies the PO for which the
487: -- information should be retrieved.
488: --
489: --OUT : x_po_ordered OUT NUMBER
490: -- total ordered amount for the PO
531: BEGIN
532:
533: SELECT org_id
534: INTO l_org_id
535: FROM po_headers_all
536: WHERE po_header_id = p_po_header_id;
537:
538: po_moac_utils_pvt.set_org_context(l_org_id);
539:
595: --Function : Retrieve Previously submitted amount/qty for a WC
596: --Parameter :
597: --IN : p_po_header_id IN NUMBER Required
598: -- corresponds to the column PO_HEADER_ID in the table
599: -- PO_HEADERS_ALL, and identifies the PO for which the
600: -- information should be retrieved.
601: -- p_wc_request_date IN DATE Required
602: -- uses to establish a time of reference for the
603: -- the defintion of Previously Submitted.
1222: -- indicates if the information in the INTERFACE tables.
1223: -- or the SHIPMENT tables
1224: -- p_po_header_id IN NUMBER Required
1225: -- corresponds to the column PO_HEADER_ID in
1226: -- the table PO_HEADERS_ALL.
1227: --OUT : x_return_status OUT VARCHAR2
1228: -- return status of the procedure.
1229: -- x_return_msg OUT VARCHAR2
1230: -- return message of the procedure.
1320:
1321: --First get buyer id from PO Header
1322: SELECT POH.AGENT_ID
1323: INTO l_buyer_id
1324: FROM PO_HEADERS_ALL POH
1325: WHERE POH.PO_HEADER_ID = p_po_header_id;
1326:
1327: --Debug Information
1328: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','Cancellation Notif parameters:');
1968: BEGIN
1969: SELECT fc.precision
1970: INTO p_precision
1971: FROM FND_CURRENCIES fc,
1972: PO_HEADERS_ALL poh
1973: WHERE poh.po_header_id=p_po_header_id
1974: AND poh.currency_code= fc.currency_code;
1975:
1976: RETURN p_precision;