[Home] [Help]
PACKAGE: APPS.AR_AUTOREC_API
Source
1 PACKAGE AR_AUTOREC_API AUTHID CURRENT_USER AS
2 /* $Header: ARATRECS.pls 120.17.12020000.2 2012/07/28 06:39:00 aghoraka ship $ */
3
4 TYPE rcpt_creation_info IS RECORD (
5 party_id NUMBER,
6 pmt_channel_code VARCHAR2(30),
7 assignment_id NUMBER );
8
9
10 TYPE receipt_info_rec IS RECORD (
11 customer_id NUMBER,
12 cr_gl_date DATE,
13 cr_amount NUMBER,
14 cust_site_use_id NUMBER,
15 receipt_date DATE,
16 cr_currency_code VARCHAR2(30),
17 cr_exchange_rate NUMBER,
18 cr_payment_schedule_id NUMBER,
19 remittance_bank_account_id NUMBER,
20 receipt_method_id NUMBER,
21 cash_receipt_id NUMBER,
22 inv_bal_amount NUMBER,
23 inv_orig_amount NUMBER,
24 allow_over_app ra_cust_trx_types.allow_overapplication_flag%type,
25 unapplied_ccid NUMBER,
26 ed_disc_ccid NUMBER,
27 uned_disc_ccid NUMBER,
28 batch_id NUMBER,
29 customer_trx_id NUMBER,
30 rev_rec_flag VARCHAR2(30),
31 def_tax_flag VARCHAR2(30),
32 cust_trx_type_id NUMBER,
33 trx_due_date DATE,
34 trx_currency_code VARCHAR2(30),
35 trx_exchange_rate NUMBER,
36 trx_date DATE,
37 trx_gl_date DATE,
38 calc_discount_on_lines_flag VARCHAR2(30),
39 partial_discount_flag VARCHAR2(30),
40 allow_overappln_flag VARCHAR2(30),
41 natural_appln_only_flag VARCHAR2(30),
42 creation_sign VARCHAR2(30),
43 applied_payment_schedule_id NUMBER,
44 ot_gl_date DATE,
45 term_id NUMBER,
46 amount_due_original NUMBER,
47 amount_line_items_original NUMBER,
48 amount_due_remaining NUMBER,
49 discount_taken_earned NUMBER,
50 discount_taken_unearned NUMBER,
51 line_items_original NUMBER,
52 line_items_remaining NUMBER,
53 tax_original NUMBER,
54 tax_remaining NUMBER,
55 freight_original NUMBER,
56 freight_remaining NUMBER,
57 rec_charges_charged NUMBER,
58 rec_charges_remaining NUMBER,
59 location hz_cust_site_uses.location%type,
60 amount_apply NUMBER
61 );
62
63
64 /*========================================================================+
65 | PUBLIC PROCEDURE GET_DETAIL_ACCOUNTS |
66 | |
67 | DESCRIPTION |
68 | |
69 | This procedure is used to get the parameters from the Conc program |
70 | and convert them to the type reqd for processing. |
71 | |
72 | PSEUDO CODE/LOGIC |
73 | |
74 | PARAMETERS |
75 | |
76 | |
77 | KNOWN ISSUES |
78 | |
79 | NOTES |
80 | |
81 | |
82 | MODIFICATION HISTORY |
83 | Date Author Description of Changes |
84 | 16-JUL-2005 bichatte Created |
85 *=========================================================================*/
86
87
88
89 PROCEDURE get_parameters(
90 P_ERRBUF OUT NOCOPY VARCHAR2,
91 P_RETCODE OUT NOCOPY NUMBER,
92 p_process_type IN VARCHAR2,
93 p_batch_date IN VARCHAR2,
94 p_batch_gl_date IN VARCHAR2,
95 p_create_flag IN VARCHAR2,
96 p_approve_flag IN VARCHAR2,
97 p_format_flag IN VARCHAR2,
98 p_batch_id IN VARCHAR2,
99 p_debug_mode_on IN VARCHAR2,
100 p_batch_currency IN VARCHAR2,
101 p_exchange_date IN VARCHAR2,
102 p_exchange_rate IN VARCHAR2,
103 p_exchange_rate_type IN VARCHAR2,
104 p_remit_method_code IN VARCHAR2,
105 p_receipt_class_id IN VARCHAR2,
106 p_payment_method_id IN VARCHAR2,
107 p_media_reference IN VARCHAR2,
108 p_remit_bank_branch_id IN VARCHAR2,
109 p_remit_bank_account_id IN VARCHAR2,
110 p_remit_bank_deposit_number IN VARCHAR2,
111 p_comments IN VARCHAR2,
112 p_trx_date_l IN VARCHAR2,
113 p_trx_date_h IN VARCHAR2,
114 p_due_date_l IN VARCHAR2,
115 p_due_date_h IN VARCHAR2,
116 p_trx_num_l IN VARCHAR2,
117 p_trx_num_h IN VARCHAR2,
118 p_doc_num_l IN VARCHAR2,
119 p_doc_num_h IN VARCHAR2,
120 p_customer_number_l IN VARCHAR2,
121 p_customer_number_h IN VARCHAR2,
122 p_customer_name_l IN VARCHAR2,
123 p_customer_name_h IN VARCHAR2,
124 p_customer_id IN VARCHAR2,
125 p_site_l IN VARCHAR2,
126 p_site_h IN VARCHAR2,
127 p_site_id IN VARCHAR2,
128 p_remittance_total_from IN VARCHAR2,
129 p_Remittance_total_to IN VARCHAR2,
130 p_billing_number_l IN VARCHAR2,
131 p_billing_number_h IN VARCHAR2,
132 p_customer_bank_acc_num_l IN VARCHAR2,
133 p_customer_bank_acc_num_h IN VARCHAR2,
134 p_current_worker_number IN VARCHAR2 DEFAULT '0',
135 p_total_workers IN VARCHAR2 DEFAULT '0'
136 );
137
138
139 /*========================================================================+
140 | PROCEDURE submit_autorec_parallel |
141 | |
142 | DESCRIPTION |
143 | |
144 | Wraper to parallelize the Automatic Receipts creation program |
145 | PSEUDO CODE/LOGIC |
146 | |
147 | PARAMETERS |
148 | |
149 | |
150 | KNOWN ISSUES |
151 | |
152 | NOTES |
153 | |
154 | |
155 | MODIFICATION HISTORY |
156 | Date Author Description of Changes |
157 | 30-NOV-2007 nproddut Created |
158 *=========================================================================*/
159 PROCEDURE submit_autorec_parallel(
160 p_errbuf OUT NOCOPY VARCHAR2,
161 p_retcode OUT NOCOPY NUMBER,
162 p_process_type IN VARCHAR2,
163 p_batch_date IN VARCHAR2,
164 p_batch_gl_date IN VARCHAR2,
165 p_create_flag IN VARCHAR2,
166 p_approve_flag IN VARCHAR2,
167 p_format_flag IN VARCHAR2,
168 p_batch_id IN VARCHAR2,
169 p_debug_mode_on IN VARCHAR2,
170 p_batch_currency IN VARCHAR2,
171 p_exchange_date IN VARCHAR2,
172 p_exchange_rate IN VARCHAR2,
173 p_exchange_rate_type IN VARCHAR2,
174 p_remit_method_code IN VARCHAR2,
175 p_receipt_class_id IN VARCHAR2,
176 p_payment_method_id IN VARCHAR2,
177 p_media_reference IN VARCHAR2,
178 p_remit_bank_branch_id IN VARCHAR2,
179 p_remit_bank_account_id IN VARCHAR2,
180 p_remit_bank_deposit_number IN VARCHAR2,
181 p_comments IN VARCHAR2,
182 p_trx_date_l IN VARCHAR2,
183 p_trx_date_h IN VARCHAR2,
184 p_due_date_l IN VARCHAR2,
185 p_due_date_h IN VARCHAR2,
186 p_trx_num_l IN VARCHAR2,
187 p_trx_num_h IN VARCHAR2,
188 p_doc_num_l IN VARCHAR2,
189 p_doc_num_h IN VARCHAR2,
190 p_customer_number_l IN VARCHAR2,
191 p_customer_number_h IN VARCHAR2,
192 p_customer_name_l IN VARCHAR2,
193 p_customer_name_h IN VARCHAR2,
194 p_customer_id IN VARCHAR2,
195 p_site_l IN VARCHAR2,
196 p_site_h IN VARCHAR2,
197 p_site_id IN VARCHAR2,
198 p_remittance_total_from IN VARCHAR2,
199 p_Remittance_total_to IN VARCHAR2,
200 p_billing_number_l IN VARCHAR2,
201 p_billing_number_h IN VARCHAR2,
202 p_customer_bank_acc_num_l IN VARCHAR2,
203 p_customer_bank_acc_num_h IN VARCHAR2,
204 p_total_workers IN NUMBER default 1);
205
206 /*========================================================================+
207 | PROCEDURE insert_batch |
208 | |
209 | DESCRIPTION |
210 | |
211 | This procedure is used to insert the batch record when called from |
212 | srs. It also gets the other required parameters from sysparm |
213 | and conc program |
214 | PSEUDO CODE/LOGIC |
215 | |
216 | PARAMETERS |
217 | |
218 | |
219 | KNOWN ISSUES |
220 | |
221 | NOTES |
222 | |
223 | |
224 | MODIFICATION HISTORY |
225 | Date Author Description of Changes |
226 | 16-JUL-2005 bichatte Created |
227 *=========================================================================*/
228
229
230 PROCEDURE insert_batch(
231 p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
232 p_batch_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
233 p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE DEFAULT NULL,
234 p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
235 p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
236 p_approve_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
237 p_format_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
238 p_create_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
239 p_exchange_date IN ar_batches.exchange_date%TYPE DEFAULT NULL,
240 p_exchange_rate IN ar_batches.exchange_rate%TYPE DEFAULT NULL,
241 p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE DEFAULT NULL,
242 p_batch_id OUT NOCOPY NUMBER
243 );
244
245
246
250 | DESCRIPTION |
247 /*========================================================================+
248 | PUBLIC PROCEDURE GET_DETAIL_ACCOUNTS |
249 | |
251 | |
252 | This procedure is used to select the valied invoices and insert them |
253 | into the GT table rec_gt |
254 | PSEUDO CODE/LOGIC |
255 | |
256 | PARAMETERS |
257 | |
258 | |
259 | KNOWN ISSUES |
260 | |
261 | NOTES |
262 | |
263 | |
264 | MODIFICATION HISTORY |
265 | Date Author Description of Changes |
266 | 16-JUL-2005 bichatte Created |
267 *=========================================================================*/
268
269 PROCEDURE select_valid_invoices(
270 p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
271 p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
272 p_due_date_l IN ar_payment_schedules.due_date%TYPE,
273 p_due_date_h IN ar_payment_schedules.due_date%TYPE,
274 p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
275 p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
276 p_doc_num_l IN ra_customer_trx.doc_sequence_value%TYPE,
277 p_doc_num_h IN ra_customer_trx.doc_sequence_value%TYPE,
278 p_customer_number_l IN hz_cust_accounts.account_number%TYPE, --Bug6734688
279 p_customer_number_h IN hz_cust_accounts.account_number%TYPE, --Bug6734688
280 p_customer_name_l IN hz_parties.party_name%TYPE, --Bug6734688
281 p_customer_name_h IN hz_parties.party_name%TYPE, --Bug6734688
282 p_batch_id IN ar_batches.batch_id%TYPE,
283 p_approve_only_flag IN VARCHAR2 DEFAULT NULL,--Bug 5344405
284 p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
285 p_total_workers IN NUMBER DEFAULT 1
286 );
287
288
289
290
291
292
293
294 /*========================================================================+
295 | PROCEDURE insert_exceptions |
296 | |
297 | DESCRIPTION |
298 | |
299 | This procedure is used to insert the exception record when |
300 | |
301 | PSEUDO CODE/LOGIC |
302 | |
303 | PARAMETERS |
304 | |
305 | |
306 | KNOWN ISSUES |
307 | |
308 | NOTES |
309 | |
310 | |
311 | MODIFICATION HISTORY |
312 | Date Author Description of Changes |
313 | 16-JUL-2005 bichatte Created |
314 *=========================================================================*/
315 PROCEDURE insert_exceptions(
316 p_batch_id IN ar_batches.batch_id%TYPE DEFAULT NULL,
317 p_request_id IN ar_cash_receipts.request_id%TYPE DEFAULT NULL,
318 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
319 p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
320 p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
321 p_paying_site_use_id IN ar_cash_receipts.customer_site_use_id%TYPE DEFAULT NULL,
322 p_due_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,
323 p_cust_min_rec_amount IN NUMBER DEFAULT NULL,
324 p_bank_min_rec_amount IN NUMBER DEFAULT NULL,
325 p_exception_code IN VARCHAR2,
326 p_additional_message IN VARCHAR2
327 );
328
329
330 /*========================================================================+
331 | PUBLIC PROCEDURE SUBMIT_REPORT |
332 | |
333 | DESCRIPTION |
334 | |
335 | This procedure is used to get the parameters from the Conc program |
336 | and convert them to the type reqd for processing. |
337 | |
338 | PSEUDO CODE/LOGIC |
339 | |
340 | PARAMETERS |
341 | |
342 | |
343 | KNOWN ISSUES |
344 | |
345 | NOTES |
346 | |
347 | |
348 | MODIFICATION HISTORY |
349 | Date Author Description of Changes |
350 | 16-JUL-2005 bichatte Created |
351 *=========================================================================*/
352
353 PROCEDURE SUBMIT_REPORT (
354 p_batch_id ar_batches.batch_id%TYPE,
355 p_request_id ar_cash_receipts.request_id%TYPE
356 );
357
358
359
360
361 PROCEDURE rec_reset( p_apply_fail IN VARCHAR2,
362 p_pay_process_fail IN VARCHAR2,
363 p_gt_id IN NUMBER
364 );
365
366
367 FUNCTION Get_Invoice_Bal_After_Disc(
368 p_applied_payment_schedule_id IN NUMBER,
369 p_apply_date IN DATE ) RETURN NUMBER;
370
371
372
373 /*========================================================================+
374 | PROCEDURE populate_cached_data |
375 | |
376 | DESCRIPTION |
377 | |
378 | This procedure is to access the cached receipt_info_rec |
379 | |
380 | PARAMETERS |
381 | |
382 | |
383 | KNOWN ISSUES |
384 | |
385 | NOTES |
386 | |
387 | |
388 | MODIFICATION HISTORY |
389 | Date Author Description of Changes |
390 | 30-NOV-2007 nproddut Created |
391 *=========================================================================*/
392 PROCEDURE populate_cached_data(p_receipt_info_rec OUT NOCOPY receipt_info_rec);
393
394
395 /*========================================================================+
396 | PROCEDURE populate_cached_data |
397 | |
398 | DESCRIPTION |
399 | |
400 | This procedure is to access the cached rcpt_creation_info |
401 | |
402 | PARAMETERS |
403 | |
404 | |
405 | KNOWN ISSUES |
406 | |
407 | NOTES |
408 | |
409 | |
410 | MODIFICATION HISTORY |
411 | Date Author Description of Changes |
412 | 30-NOV-2007 nproddut Created |
413 *=========================================================================*/
414 PROCEDURE populate_cached_data(p_rcpt_creation_rec OUT NOCOPY rcpt_creation_info);
415
416
417 END AR_AUTOREC_API;