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