DBA Data[Home] [Help]

PACKAGE: APPS.ARRX_RC

Source


1 PACKAGE ARRX_RC AUTHID CURRENT_USER as
2 /* $Header: ARRXRCS.pls 120.8 2010/09/13 06:25:07 kknekkal ship $ */
3 
4 type var_t is record (
5         request_id                      number,
6         books_id                        number,
7         chart_of_accounts_id            number,
8         currency_code                   varchar2(15),
9         org_name                        varchar2(50),
10         p_reporting_level               VARCHAR2(30),
11         p_reporting_entity_id           NUMBER,
12         p_sob_id                        NUMBER,
13         p_coa_id                        number,
14         p_batch_name_low                varchar2(20),
15         p_batch_name_high               varchar2(20),
16         p_customer_name_low             varchar2(240),
17         p_customer_name_high            varchar2(240),
18         p_customer_number_low           varchar2(50),
19         p_customer_number_high          varchar2(50),
20         p_deposit_date_low              date,
21         p_deposit_date_high             date,
22         p_receipt_status_low            varchar2(30),
23         p_receipt_status_high           varchar2(30),
24         p_receipt_number_low            varchar2(30),
25         p_receipt_number_high           varchar2(30),
26         p_invoice_number_low            varchar2(30), --Bug 1579930
27         p_invoice_number_high           varchar2(30), --Bug 1579930
28 
29         p_invoice_type_low              varchar2(30), --Bug 1680159
30         p_invoice_type_high             varchar2(30), --Bug 1680159
31         p_receipt_date_low              date,
32         p_receipt_date_high             date,
33         p_gl_date_low                   date,
34         p_gl_date_high                  date,
35         p_receipt_gl_date_low           date,         -- Bug 1951727
36         p_receipt_gl_date_high          date,         -- Bug 1951727
37         p_apply_date_low                date,
38         p_apply_date_high               date,
39         p_currency_code                 varchar2(15),
40         p_bank_account_name             varchar2(80),
41         p_payment_method                varchar2(30),
42         p_confirmed_flag                varchar2(1),
43         p_co_seg_low                    varchar2(30),  -- Bug 2110698
44         p_co_seg_high                   varchar2(30),  -- Bug 2110698
45         p_doc_sequence_name             varchar2(30),
46         p_doc_sequence_number_from      number,
47         p_doc_sequence_number_to        number,
48         organization_name               varchar2(50),
49         functional_currency_code        varchar2(15),
50         cr_status                       varchar2(40),
51         crh_status                      varchar2(40),
52         batch_id                        number,
53         batch_name                      varchar2(20),
54         cash_receipt_id                 number,
55         receipt_number                  varchar2(30),
56         receipt_currency_code           varchar2(15),
57         exchange_rate                   number,
58         exchange_date                   date,
59         exchange_type                   varchar2(30),
60         doc_sequence_name               varchar2(30),
61         doc_sequence_value              number,
62         deposit_date                    date,
63         receipt_date                    date,
64         receipt_type                    varchar2(30),
65         receipt_status                  varchar2(40),
66         misc_payment_source             varchar2(30),
67         tax_code                        varchar2(50),
68         reference_type                  varchar2(30),
69         anticipated_clearing_date       date,
70         bank_name                       varchar2(60),
71         bank_name_alt                   varchar2(320),
72         bank_branch_name                varchar2(60),
73         bank_branch_name_alt            varchar2(320),
74         bank_number                     varchar2(30),
75         bank_branch_number              varchar2(25),
76         bank_account_name               varchar2(80),
77         bank_account_name_alt           varchar2(320),
78         bank_account_currency           varchar2(15),
79         receipt_method                  varchar2(30),
80         cash_receipt_history_id         number,
81         gl_date                         date,
82         receipt_amount                  number,
83         receipt_history_status          varchar2(40),
84         acctd_receipt_amount            number,
85         factor_discount_amount          number,
86         acctd_factor_discount_amount    number,
87         account_code_combination_id     number,
88         debit_account                   varchar2(240),
89         debit_account_desc              varchar2(240),
90         debit_balancing                 varchar2(240),
91         debit_balancing_desc            varchar2(240),
92         debit_natacct                   varchar2(240),
93         debit_natacct_desc              varchar2(240),
94         customer_id                     number,
95         customer_name                   varchar2(240),
96         customer_name_alt               varchar2(320),
97         customer_number                 varchar2(30),
98         related_customer                varchar2(30),
99         receivable_application_id       number,
100         apply_date                      date,
101         application_status              varchar2(30),
102         amount_applied_to               number,
103         amount_applied_from             number,
104         acctd_amount_applied_to         number,
105         acctd_amount_applied_from       number,
106         earned_discount_taken           number,
107         unearned_discount_taken         number,
108         acctd_earned_discount_taken     number,
109         acctd_unearned_discount_taken   number,
110         applied_customer_trx_id         number,
111         trx_number                      varchar2(30),--bug 5564359
112         trx_currency_code               varchar2(15),
113         trx_date                        date,
114         trx_amount                      number,
115         acctd_trx_amount                number,
116         l_app                           varchar2(80),
117         l_nsf                           varchar2(80),
118         l_rev                           varchar2(80),
119         l_stop                          varchar2(80),
120         l_unapp                         varchar2(80),
121         l_unid                          varchar2(80),
122         doc_sequence_number_from        number(15),
123         doc_sequence_number_to          number(15),
124         receipt_gain_loss               number,
125         misc_amount                     number,
126         percent                         number,
127         batch_source                    varchar2(50),
128         ca_sob_type                     varchar2(1),
129         ca_sob_id                       number,
130         calling_program                 varchar2(10),
131         len1                            number,
132         len2                            number,
133 	c_gl_date_low                   date
134 );
135 var var_t;
136 
137 procedure before_report;
138 procedure bind(c in integer);
139 procedure after_fetch;
140 procedure init_var;
141 
142 -- Receipt Register
143 procedure arrc_rep (
144    p_reporting_level           IN   VARCHAR2,
145    p_reporting_entity_id       IN   NUMBER,
146    p_sob_id                    IN   NUMBER,
147    p_coa_id                    IN   NUMBER,
148    p_co_seg_low                IN   VARCHAR2,
149    p_co_seg_high               IN   VARCHAR2,
150    p_gl_date_low               in   date,
151    p_gl_date_high              in   date,
152    p_currency_code             in   varchar2,
153    p_batch_name_low            in   varchar2,
154    p_batch_name_high           in   varchar2,
155    p_customer_name_low         in   varchar2,
156    p_customer_name_high        in   varchar2,
157    p_deposit_date_low          in   date,
158    p_deposit_date_high         in   date,
159    p_receipt_status_low        in   varchar2,
160    p_receipt_status_high       in   varchar2,
161    p_receipt_number_low        in   varchar2,
162    p_receipt_number_high       in   varchar2,
163    p_invoice_number_low        in   varchar2, --Bug 1579930
164    p_invoice_number_high       in   varchar2, --Bug 1579930
165    p_receipt_date_low          in   date,
166    p_receipt_date_high         in   date,
167    p_bank_account_name         in   varchar2,
168    p_payment_method            in   varchar2,
169    p_confirmed_flag            in   varchar2,
170    p_doc_sequence_name	       in   varchar2,
171    p_doc_sequence_number_from  in   number,
172    p_doc_sequence_number_to    in   number,
173    request_id                  in   number,
174    retcode                     out NOCOPY  number,
175    errbuf                      out NOCOPY  varchar2);
176 
177 -- Actual Register
178 procedure arrc_rep_actual (
179    p_reporting_level           IN   varchar2,
180    p_reporting_entity_id       IN   NUMBER,
181    p_sob_id                    IN   NUMBER,
182    p_coa_id                    IN   NUMBER,
183    p_batch_name_low            in   varchar2,
184    p_batch_name_high           in   varchar2,
185    p_customer_name_low         in   varchar2,
186    p_customer_name_high        in   varchar2,
187    p_deposit_date_low          in   date,
188    p_deposit_date_high         in   date,
189    p_receipt_status_low        in   varchar2,
190    p_receipt_status_high       in   varchar2,
191    p_receipt_number_low        in   varchar2,
192    p_receipt_number_high       in   varchar2,
193    p_receipt_date_low          in   date,
194    p_receipt_date_high         in   date,
195    p_gl_date_low               in   date,
196    p_gl_date_high              in   date,
197    p_currency_code             in   varchar2,
198    p_bank_account_name         in   varchar2,
199    p_payment_method            in   varchar2,
200    p_confirmed_flag            in   varchar2,
201    request_id                  in   number,
202    retcode                     out NOCOPY  number,
203    errbuf                      out NOCOPY  varchar2);
204 
205 -- Applied Register
206 procedure arar_rep (
207    p_reporting_level             IN     VARCHAR2,
208    p_reporting_entity_id         IN     NUMBER,
209    p_sob_id                      IN     NUMBER,
210    p_coa_id			 in	number,
211    p_co_seg_low                  in     varchar2,
212    p_co_seg_high                 in     varchar2,
213    p_gl_date_low                 in     date,
214    p_gl_date_high                in     date,
215    p_currency_code               in     varchar2,
216    p_batch_name_low              in	varchar2,
217    p_batch_name_high             in	varchar2,
218    p_customer_name_low           in	varchar2,
219    p_customer_name_high          in	varchar2,
220    p_customer_number_low	 in	varchar2,
221    p_customer_number_high	 in	varchar2,
222    p_apply_date_low              in	date,
223    p_apply_date_high             in	date,
224    p_receipt_number_low          in	varchar2,
225    p_receipt_number_high         in	varchar2,
226    p_invoice_number_low		 in	varchar2,
227    p_invoice_number_high	 in	varchar2,
228    p_invoice_type_low		 in	varchar2,
229    p_invoice_type_high		 in	varchar2,
230    request_id                    in	number,
231    retcode                       out NOCOPY 	number,
232    errbuf                        out NOCOPY  	varchar2);
233 
234 -- Miscellaneous Register
235 procedure armtr_rep (
236    p_reporting_level           IN   VARCHAR2,
237    p_reporting_entity_id       IN   NUMBER,
238    p_sob_id                    IN   NUMBER,
239    p_coa_id                    in   number,
240    p_co_seg_low                in   varchar2,
241    p_co_seg_high               in   varchar2,
242    p_gl_date_low               in   date,
243    p_gl_date_high              in   date,
244    p_currency_code             in   varchar2,
245    p_batch_name_low            in   varchar2,
246    p_batch_name_high           in   varchar2,
247    p_deposit_date_low          in   date,
248    p_deposit_date_high         in   date,
249    p_receipt_number_low        in   varchar2,
250    p_receipt_number_high       in   varchar2,
251    p_doc_sequence_name         in   varchar2,
252    p_doc_sequence_number_from  in   number,
253    p_doc_sequence_number_to    in   number,
254    request_id                  in   number,
255    retcode                     out NOCOPY  number,
256    errbuf                      out NOCOPY  varchar2);
257 END ARRX_RC;