PACKAGE: APPS.IGI_EXP_HOLDS

Source

1 PACKAGE igi_exp_holds AS
2 --  $Header: igiexprs.pls 120.5.12000000.1 2007/09/13 04:24:29 mbremkum ship $
3 
4    PROCEDURE Place_Release_Hold ( p_invoice_id       IN NUMBER
5                                   -- Bug 2469158
6                                 , p_invoice_amt      IN NUMBER
7                                 , p_source           IN VARCHAR2
8                                 , p_cancelled_date   IN DATE
9                 , p_place_release    IN VARCHAR2
10                                 , p_hold_lookup_code IN VARCHAR2
11                                 , p_calling_sequence IN VARCHAR2
12                                 -- Bug 3595853
13                                 , p_temp_cancelled_amount IN NUMBER default NULL);
14 
15    PROCEDURE Igi_Exp_Ap_Holds_T2(p_calling_sequence IN VARCHAR2);
16 
17    -- Bug 2438858
18    PROCEDURE Igi_Exp_Ap_Inv_Dist_T2(p_calling_sequence IN VARCHAR2);
19 
20    -- Bug 5905190
21    PROCEDURE Igi_Exp_Ap_Inv_Line_T2(p_calling_sequence IN VARCHAR2);
22 
23    -- Variables to be used from triggers on AP_HOLDS_ALL table
24    TYPE InvoiceTabType IS TABLE OF NUMBER(15)
25    INDEX BY BINARY_INTEGER;
26 
27    l_TableRow        NUMBER(15) := 0;
28    l_InvoiceIdTable  InvoiceTabType;
29    l_UpdatedByTable  InvoiceTabType;
30 
31    -- Bug 2438858
32    -- Variables to be used from triggers on AP_INVOICE_DISTRIBUTIONS_ALL table
33    l_DistTableRow        NUMBER(15) := 0;
34    l_InvoiceIdDistTable  InvoiceTabType;
35    l_UpdatedByDistTable  InvoiceTabType;
36 
37 
38    -- Bug 5905190
39    -- Variables to be used from triggers on AP_INVOICE_LINES_ALL table
40    l_LineTableRow        NUMBER(15) := 0;
41    l_InvoiceIdLineTable  InvoiceTabType;
42    l_UpdatedByLineTable  InvoiceTabType;
43 
44 END igi_exp_holds;