DBA Data[Home] [Help]

PACKAGE: APPS.INV_DIAG_RCV_PO_COMMON

Source


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;