DBA Data[Home] [Help]

APPS.IO_DIAGNOSTICS1 dependencies on INV_DIAG_RCV_PO_COMMON

Line 4: PROCEDURE req_num_sql(p_ou_id IN NUMBER , p_req_num IN VARCHAR2, p_sql IN OUT NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list) IS

1: PACKAGE BODY io_diagnostics1 AS
2: /* $Header: INVDIO1B.pls 120.1.12000000.1 2007/08/09 06:43:33 ssadasiv noship $ */
3:
4: PROCEDURE req_num_sql(p_ou_id IN NUMBER , p_req_num IN VARCHAR2, p_sql IN OUT NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list) IS
5: l_ou_id po_requisition_headers_all.org_id%TYPE := p_ou_id;
6: l_req_num po_requisition_headers_all.segment1%TYPE := p_req_num;
7: l_line_num po_requisition_lines_all.line_num%TYPE := NULL;
8: l_shipment_num rcv_shipment_headers.shipment_num%TYPE := NULL;

Line 920: INV_DIAG_RCV_PO_COMMON.sqls_list) IS

916: END;
917:
918:
919: PROCEDURE req_line_sql(p_ou_id IN NUMBER, p_req_num IN VARCHAR2, p_line_num IN NUMBER, p_sql IN OUT NOCOPY
920: INV_DIAG_RCV_PO_COMMON.sqls_list) IS
921:
922: l_ou_id po_requisition_headers_all.org_id%TYPE := p_ou_id;
923: l_req_num po_requisition_headers_all.segment1%TYPE := p_req_num;
924: l_line_num po_requisition_lines_all.line_num%TYPE := p_line_num;