DBA Data[Home] [Help]

APPS.RMA_DIAGNOSTICS dependencies on INV_DIAG_RCV_PO_COMMON

Line 4: PROCEDURE rma_sql(p_operating_id IN NUMBER, p_rma_number IN NUMBER, p_sql IN OUT NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list

1: PACKAGE BODY RMA_DIAGNOSTICS AS
2: /* $Header: INVDRMA1B.pls 120.0.12000000.1 2007/08/09 06:51:43 ssadasiv noship $ */
3:
4: PROCEDURE rma_sql(p_operating_id IN NUMBER, p_rma_number IN NUMBER, p_sql IN OUT NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list
5: ) IS
6: l_rma_number rcv_shipment_headers.receipt_num%TYPE := p_rma_number;
7: l_operating_id rcv_shipment_headers.organization_id%TYPE := p_operating_id;
8:

Line 435: p_line_num IN NUMBER, p_sql IN OUT NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list) IS

431: RETURN;
432: END;
433:
434: PROCEDURE rma_line_sql(p_operating_id IN NUMBER,p_rma_number IN VARCHAR2,
435: p_line_num IN NUMBER, p_sql IN OUT NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list) IS
436:
437: l_operating_id rcv_shipment_headers.receipt_num%TYPE := p_operating_id;
438: l_rma_number rcv_shipment_headers.organization_id%TYPE := p_rma_number;
439: l_line_num oe_order_lines_all.line_number%TYPE := p_line_num ;

Line 906: INV_DIAG_RCV_PO_COMMON.sqls_list) IS

902: END;
903:
904: PROCEDURE rma_receipt_sql(p_operating_id IN NUMBER,p_rma_number IN VARCHAR2,
905: p_receipt_number IN NUMBER, p_org_id IN NUMBER, p_sql IN OUT NOCOPY
906: INV_DIAG_RCV_PO_COMMON.sqls_list) IS
907:
908: l_operating_id rcv_shipment_headers.receipt_num%TYPE := p_operating_id;
909: l_rma_number rcv_shipment_headers.organization_id%TYPE := p_rma_number;
910: l_receipt_number rcv_shipment_headers.receipt_num%TYPE := p_receipt_number;