DBA Data[Home] [Help]

APPS.IO_DIAGNOSTICS2 dependencies on INV_DIAG_RCV_PO_COMMON

Line 5: NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list) IS

1: PACKAGE BODY io_diagnostics2 AS
2: /* $Header: INVDIO2B.pls 120.0.12000000.1 2007/08/09 06:48:29 ssadasiv noship $ */
3:
4: PROCEDURE receipt_shipment_sql(p_shipment_num IN VARCHAR2, p_receipt_num IN VARCHAR2, p_org_id IN NUMBER, p_sql IN OUT
5: NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list) IS
6: l_ou_id po_requisition_headers_all.org_id%TYPE := NULL;
7: l_req_num po_requisition_headers_all.segment1%TYPE := NULL;
8: l_line_num po_requisition_lines_all.line_num%TYPE := NULL;
9: l_shipment_num rcv_shipment_headers.shipment_num%TYPE := p_shipment_num;

Line 1037: IN VARCHAR2, p_receipt_num IN VARCHAR2, p_org_id IN NUMBER, p_sql IN OUT NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list) IS

1033: END;
1034:
1035:
1036: PROCEDURE req_line_receipt_shipment_sql(p_ou_id IN NUMBER, p_req_num IN VARCHAR2, p_line_num IN NUMBER, p_shipment_num
1037: IN VARCHAR2, p_receipt_num IN VARCHAR2, p_org_id IN NUMBER, p_sql IN OUT NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list) IS
1038: l_ou_id po_requisition_headers_all.org_id%TYPE := p_ou_id;
1039: l_req_num po_requisition_headers_all.segment1%TYPE := p_req_num;
1040: l_line_num po_requisition_lines_all.line_num%TYPE := Nvl(p_line_num,-99);
1041: l_shipment_num rcv_shipment_headers.shipment_num%TYPE := p_shipment_num;