[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;