PACKAGE: APPS.PA_INVOICE_DETAIL_PKG

Source

1 PACKAGE PA_INVOICE_DETAIL_PKG AUTHID CURRENT_USER as
2 /* $Header: PAICIDTS.pls 115.3 2002/11/23 12:26:16 prajaram ship $*/
3 
4 TYPE INV_REC_TAB IS TABLE OF pa_draft_invoice_details%rowtype
5                     INDEX BY BINARY_INTEGER;
6 
7 /* Global Variable */
8 G_REQUEST_ID           NUMBER;
9 G_LAST_UPDATE_DATE     DATE;
10 G_LAST_UPDATED_BY      NUMBER;
11 G_CREATION_DATE        DATE;
12 G_CREATED_BY           NUMBER;
13 G_LAST_UPDATE_LOGIN    NUMBER;
14 
15 --Global Counter
16 G_Ins_count     Number;
17 G_Del_count     Number;
18 G_Upd_count     Number;
19 
20 
21 -- Procedure            : Insert_rows
22 -- Purpose              : Create Rows in PA_DRAFT_INVOICE_DETAILS in
23 --                        array processing.
24 -- Parameters           :
25 --                        P_inv_rec_tab - Table of Invoice details Records
26 
27 PROCEDURE insert_rows
28            ( P_inv_rec_tab                IN OUT NOCOPY  inv_rec_tab);
29 
30 -- Procedure            : Delete_rows
31 -- Purpose              : Delete Rows from PA_DRAFT_INVOICE_DETAILS in
32 --                        array .
33 -- Parameters           :
34 --                        P_inv_rec_tab - Table of Invoice details Records
35 
36 PROCEDURE Delete_rows
37            ( P_inv_rec_tab      IN OUT NOCOPY  inv_rec_tab);
38 
39 -- Procedure            : Update_rows
40 -- Purpose              : Update Rows from PA_DRAFT_INVOICE_DETAILS in
41 --                        array .
42 -- Parameters           :
43 --                        P_inv_rec_tab - Table of Invoice details Records
44 
45 PROCEDURE Update_rows
46            ( P_inv_rec_tab      IN OUT NOCOPY  inv_rec_tab,
47              p_mrc_reqd_flag        IN   PA_PLSQL_DATATYPES.Char1tabtyp);
48 
49 END PA_INVOICE_DETAIL_PKG;