1 package INV_DIAG_RCV_PO_COMMON AS
2 /* $Header: INVDPO2S.pls 120.0.12000000.1 2007/08/09 06:50:02 ssadasiv noship $ */
3
4 -- Table of Varchar2
5 TYPE sqls_list IS TABLE OF VARCHAR2(6000) INDEX BY BINARY_INTEGER;
6
7 PROCEDURE build_po_all_sql(p_operating_id IN NUMBER,
8 p_po_number IN VARCHAR2,
9 p_line_num IN NUMBER,
10 p_line_loc_num IN NUMBER,
11 p_sql IN OUT NOCOPY sqls_list);
12 PROCEDURE build_all_sql(p_operating_id IN NUMBER,
13 p_po_number IN VARCHAR2,
14 p_line_num IN NUMBER,
15 p_line_loc_num IN NUMBER,
16 p_org_id IN NUMBER,
17 p_receipt_num IN VARCHAR2,
18 p_sql IN OUT NOCOPY sqls_list);
19 END;