DBA Data[Home] [Help]

PACKAGE: APPS.IGI_SIA

Source


1 PACKAGE IGI_SIA AUTHID CURRENT_USER AS
2 -- $Header: igisiaas.pls 120.2.12010000.2 2010/04/08 12:17:13 schakkin ship $
3 TYPE InvoiceTabType is table of number(15)
4 	index by binary_integer;
5 TYPE PRTableType is table of varchar2(1)
6 	index by binary_integer;
7 --
8 l_TableRow		NUMBER(15) := 0;
9 l_InvoiceIdTable	InvoiceTabType;
10 l_UpdatedByTable	InvoiceTabType;
11 l_StatusTable           InvoiceTabType;
12 l_PRTable		PRTableType;
13 G_QTY_REC_HOLD_RELEASED varchar2(1);
14 G_MATCH_PO_HOLD_RELEASED varchar2(1);
15 
16 --
17 PROCEDURE SET_INVOICE_ID
18 		( p_inv_id		NUMBER
19 		, p_upd_by		NUMBER
20                 , p_status              NUMBER
21 		);
22 
23 PROCEDURE PROCESS_INVOICE_HOLDS(p_inv_id NUMBER,
24                         p_upd_by NUMBER
25                        );
26 
27 PROCEDURE REVERSE_HOLDS(p_inv_id NUMBER,
28                         p_upd_by NUMBER
29                        );
30 
31 PROCEDURE PROCESS_HOLDS
32 		;
33 
34 PROCEDURE RELEASE_HOLDS
35 		;
36 --
37 END;