DBA Data[Home] [Help]

APPS.IOT_DIAGNOSTICS dependencies on INV_DIAG_RCV_PO_COMMON

Line 5: NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list) IS

1: PACKAGE BODY iot_diagnostics AS
2: /* $Header: INVDIOT1B.pls 120.0.12000000.1 2007/08/09 06:49:17 ssadasiv noship $ */
3:
4: PROCEDURE shipment_num_sql(p_org_id IN NUMBER, p_shipment_num IN VARCHAR2, p_receipt_num IN VARCHAR2, p_sql IN OUT
5: NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list) IS
6: l_shipment_num rcv_shipment_headers.shipment_num%TYPE := p_shipment_num;
7: l_receipt_num rcv_shipment_headers.receipt_num%TYPE := p_receipt_num;
8: l_org_id rcv_shipment_headers.organization_id%TYPE := p_org_id;
9: l_line_num rcv_shipment_lines.line_num%TYPE := NULL;

Line 482: INV_DIAG_RCV_PO_COMMON.sqls_list) IS

478:
479:
480: PROCEDURE shipment_line_num_sql(p_org_id IN NUMBER,p_shipment_num IN VARCHAR2,
481: p_shipment_line_num IN NUMBER, p_receipt_num IN VARCHAR2, p_sql IN OUT NOCOPY
482: INV_DIAG_RCV_PO_COMMON.sqls_list) IS
483:
484: l_line_num rcv_shipment_lines.line_num%TYPE := p_shipment_line_num;
485: l_shipment_num rcv_shipment_headers.shipment_num%TYPE := p_shipment_num;
486: l_receipt_num rcv_shipment_headers.receipt_num%TYPE := p_receipt_num;