1 package INV_DIAG_RCV_IPROC_COMMON AUTHID CURRENT_USER AS
2 /* $Header: INVREQ2S.pls 120.0.12000000.1 2007/08/09 06:53:21 ssadasiv noship $ */
3 PROCEDURE build_req_sql(p_operating_id IN NUMBER,
4 p_req_number IN VARCHAR2,
5 p_line_num IN NUMBER,
6 p_sql IN OUT NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list);
7 PROCEDURE build_req_rcv_sql(p_receipt_num IN VARCHAR2,
8 p_org_id IN NUMBER,
9 p_sql IN OUT NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list);
10 PROCEDURE build_req_all_sql(p_operating_id IN NUMBER,
11 p_req_number IN VARCHAR2,
12 p_line_num IN NUMBER,
13 p_receipt_number IN VARCHAR2,
14 p_org_id IN NUMBER,
15 p_sql IN OUT NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list);
16
17 END;