1 PACKAGE AR_MRC_ENGINE3 AS
2 /* $Header: ARMCEN3S.pls 120.1 2004/12/03 01:45:52 orashid noship $ */
3
4 /*=============================================================================
5 | Public Functions / Procedures
6 *============================================================================*/
7
8 /*=============================================================================
9 | PUBLIC PROCEDURE Insert_ra_rec_cash
10 |
11 | DESCRIPTION:
12 | This procedure will be called from ARP_PROC_RCT_UTIL
13 | to process the mrc data for insert.
14 |
15 | CALLS PROCEDURES / FUNCTIONS (local to this package body)
16 |
17 | PARAMETERS
18 | p_rec_app_id IN NUMBER,
19 | p_rec_app_record IN ar_receivable_applications%ROWTYPE
20 | p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE
21 | p_amount IN ar_cash_receipts.amount%TYPE
22 | p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE
23 |
24 | KNOWN ISSUES:
25 |
26 | NOTES:
27 |
28 | MODIFICATION HISTORY
29 | Date Author Description of Change
30 | 09/03/02 Debbie Sue Jancis Created
31 *============================================================================*/
32 PROCEDURE insert_ra_rec_cash(
33 p_rec_app_id IN NUMBER,
34 p_rec_app_record IN ar_receivable_applications%ROWTYPE,
35 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
36 p_amount IN ar_cash_receipts.amount%TYPE,
37 p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE
38 );
39
40 /*=============================================================================
41 | PUBLIC PROCEDURE create_matching_unapp_records
42 |
43 | DESCRIPTION:
44 | This procedure will be called from ARP_CONFIRMATION
45 | to process the mrc data for insert.
46 |
47 | CALLS PROCEDURES / FUNCTIONS (local to this package body)
48 |
49 | PARAMETERS
50 | p_rec_app_id IN NUMBER,
51 | p_rec_unapp_id IN NUMBER,
52 |
53 | KNOWN ISSUES:
54 |
55 | NOTES:
56 |
57 | MODIFICATION HISTORY
58 | Date Author Description of Change
59 | 09/03/02 Debbie Sue Jancis Created
60 *============================================================================*/PROCEDURE create_matching_unapp_records(
61 p_rec_app_id IN NUMBER,
62 p_rec_unapp_id IN NUMBER
63 );
64
65 /*=============================================================================
66 | PUBLIC PROCEDURE receipt_application
67 |
68 | DESCRIPTION:
69 | This procedure will be called from ARP_PROCESS_APPLICATION
70 | to process the mrc data for insert.
71 |
72 | CALLS PROCEDURES / FUNCTIONS (local to this package body)
73 |
74 | PARAMETERS
75 | p_receipt_ps_id IN NUMBER - Receipt PS id
76 | p_invoice_ps_id IN NUMBER - Invoice PS id
77 | p_amount_applied IN NUMBER
78 | p_amount_applied_from IN NUMBER
79 | p_invoice_currency_code IN VARCHAR2
80 | p_receipt_currency_code IN VARCHAR2
81 | p_rec_ra_rec IN receivable apps rowtype
82 | p_inv_ra_rec IN receivable apps rowtype
83 |
84 | KNOWN ISSUES:
85 |
86 | NOTES:
87 |
88 | MODIFICATION HISTORY
89 | Date Author Description of Change
90 | 09/04/02 Debbie Sue Jancis Created
91 *============================================================================*/
92 PROCEDURE receipt_application(
93 p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
94 p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
95 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
96 p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
97 p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
98 p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
99 p_rec_ra_rec IN ar_receivable_applications %ROWTYPE,
100 p_inv_ra_rec IN ar_receivable_applications %ROWTYPE
101 );
102
103 /*=============================================================================
104 | PUBLIC PROCEDURE cm_application
105 |
106 | DESCRIPTION:
107 | This procedure will be called from ARP_PROCESS_APPLICATION
108 | to process the mrc data for insert.
109 |
110 | CALLS PROCEDURES / FUNCTIONS (local to this package body)
111 |
112 | PARAMETERS
113 | p_cm_ps_id IN NUMBER - credit memo PS id
114 | p_invoice_ps_id IN NUMBER - Invoice PS id
115 | p_inv_ra_rec IN receivable apps rowtype
116 | p_ra_id IN NUMBER
117 |
118 | KNOWN ISSUES:
119 |
120 | NOTES:
121 |
122 |
123 | MODIFICATION HISTORY
124 | Date Author Description of Change
125 | 09/04/02 Debbie Sue Jancis Created
126 *============================================================================*/PROCEDURE cm_application(
127 p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
128 p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
129 p_inv_ra_rec IN ar_receivable_applications %ROWTYPE,
130 p_ra_id IN NUMBER
131 );
132
133 /*=============================================================================
134 | PUBLIC PROCEDURE on_account_receipts
135 |
136 | DESCRIPTION:
137 | This procedure will be called from ARP_PROCESS_APPLICATION
138 | to process the mrc data for insert.
139 |
140 | CALLS PROCEDURES / FUNCTIONS (local to this package body)
141 |
142 | PARAMETERS
143 | p_receipt_ps_id IN NUMBER - receipt PS id
144 | p_amount_applied IN NUMBER
145 | p_acc_ra_rec IN receivables apps rowtype
146 | p_unapp_rec_app_id IN NUMBER
147 |
148 | KNOWN ISSUES:
149 |
150 | NOTES:
151 |
152 |
153 | MODIFICATION HISTORY
154 | Date Author Description of Change
155 | 09/04/02 Debbie Sue Jancis Created
156 *============================================================================*/
157 PROCEDURE on_account_receipts(
158 p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
159 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
160 p_acc_ra_rec IN ar_receivable_applications %ROWTYPE,
161 p_unapp_rec_app_id IN NUMBER
162 );
163 /*=============================================================================
164 | PUBLIC PROCEDURE other_account_application
165 |
166 | DESCRIPTION:
167 | This procedure will be called from ARP_PROCESS_APPLICATION
168 | to process the mrc data for insert.
169 |
170 | CALLS PROCEDURES / FUNCTIONS (local to this package body)
171 |
172 | PARAMETERS
173 | p_receipt_ps_id IN NUMBER - receipt PS id
174 | p_amount_applied IN NUMBER
175 | p_otheracc_ra_rec IN receivables apps rowtype
176 | p_unapp_rec_app_id IN NUMBER
177 |
178 | KNOWN ISSUES:
179 |
180 | NOTES:
181 |
182 |
183 | MODIFICATION HISTORY
184 | Date Author Description of Change
185 | 09/04/02 Debbie Sue Jancis Created
186 *============================================================================*/
187 PROCEDURE other_account_application(
188 p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
189 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
190 p_otheracc_ra_rec IN ar_receivable_applications %ROWTYPE,
191 p_unapp_rec_app_id IN NUMBER
192 );
193
194 /*=============================================================================
195 | PUBLIC PROCEDURE reversal_insert_oppos_ra_recs
196 |
197 | DESCRIPTION:
198 | This procedure will be called from ARP_PROCESS_APPLICATION
199 | to process the mrc data for insert.
200 |
201 | CALLS PROCEDURES / FUNCTIONS (local to this package body)
202 |
203 | PARAMETERS
204 | p_ra_rec IN receivables apps rowtype
205 | p_orig_rec_app_id IN NUMBER
206 | p_new_rec_app_id IN NUMBER
207 |
208 | KNOWN ISSUES:
209 |
210 | NOTES:
211 |
212 |
213 | MODIFICATION HISTORY
214 | Date Author Description of Change
215 | 09/04/02 Debbie Sue Jancis Created
216 *============================================================================*/
217 PROCEDURE reversal_insert_oppos_ra_recs(
218 p_ra_rec IN ar_receivable_applications %ROWTYPE,
219 p_orig_rec_app_id IN NUMBER,
220 p_new_rec_app_id IN NUMBER
221 );
222
223
224 /*=============================================================================
225 | PUBLIC PROCEDURE reverse_ra_recs
226 |
227 | DESCRIPTION:
228 | This procedure will be called from ARP_CONFIRMATION
229 | to process the mrc data for insert.
230 |
231 | CALLS PROCEDURES / FUNCTIONS (local to this package body)
232 |
233 | PARAMETERS
234 | p_orig_app_id IN NUMBER
235 | p_new_app_id IN NUMBER
236 |
237 | KNOWN ISSUES:
238 |
239 | NOTES:
240 |
241 |
242 | MODIFICATION HISTORY
243 | Date Author Description of Change
244 | 09/04/02 Debbie Sue Jancis Created
245 *============================================================================*/
246 PROCEDURE reverse_ra_recs(
247 p_orig_app_id IN NUMBER,
248 p_new_app_id IN NUMBER
249 );
250
251 /*=============================================================================
252 | PUBLIC PROCEDURE confirm_ra_rec_update
253 |
254 | DESCRIPTION:
255 | This procedure will be called from ARP_CONFIRMATION
256 | to process the mrc data for update.
257 |
258 | CALLS PROCEDURES / FUNCTIONS (local to this package body)
259 |
260 | PARAMETERS
261 | p_rec_app_id IN NUMBER
262 |
263 | KNOWN ISSUES:
264 |
265 | NOTES:
266 |
267 |
268 | MODIFICATION HISTORY
269 | Date Author Description of Change
270 | 09/04/02 Debbie Sue Jancis Created
271 *============================================================================*/
272 PROCEDURE confirm_ra_rec_update(
273 p_rec_app_id IN NUMBER
274 );
275
276
277 /*=============================================================================
278 | PUBLIC PROCEDURE update_cm_application
279 |
280 | DESCRIPTION:
281 | This procedure will be called from PRO*C files in the
282 | /src/paysched directory (araups.lpc and araupds.lpc)
283 | to process the mrc data for update.
284 |
285 | CALLS PROCEDURES / FUNCTIONS (local to this package body)
286 |
287 | PARAMETERS
288 | p_rec_app_id IN NUMBER
289 | p_app_ps_id IN NUMBER,
290 | p_ct_id IN NUMBER,
291 | p_amount_applied IN NUMBER
292 |
293 | KNOWN ISSUES:
294 |
295 | NOTES:
296 |
297 |
298 | MODIFICATION HISTORY
299 | Date Author Description of Change
300 | 09/04/02 Debbie Sue Jancis Created
301 *============================================================================*/
302 PROCEDURE update_cm_application(
303 p_rec_app_id IN NUMBER,
304 p_app_ps_id IN NUMBER,
305 p_ct_id IN NUMBER,
306 p_amount_applied IN NUMBER
307 );
308
309 /*=============================================================================
310 | PUBLIC PROCEDURE update_ra_rec_quickcash
311 |
312 | DESCRIPTION:
313 | This procedure will be called from PRO*C files in the
314 | /src/cash directory
315 | to process the mrc data for update.
316 |
317 | CALLS PROCEDURES / FUNCTIONS (local to this package body)
318 |
319 | PARAMETERS
320 | p_rec_app_id IN NUMBER
321 | p_cash_receipt_id IN NUMBER,
322 | p_amount_applied IN NUMBER
323 |
324 | KNOWN ISSUES:
325 |
326 | NOTES:
327 |
328 |
329 | MODIFICATION HISTORY
330 | Date Author Description of Change
331 | 09/04/02 Debbie Sue Jancis Created
332 *============================================================================*/
333 PROCEDURE update_ra_rec_quickcash(
334 p_rec_app_id IN NUMBER,
335 p_cash_receipt_id IN NUMBER,
336 p_amount_applied IN NUMBER
337 ) ;
338
339 /*=============================================================================
340 | PUBLIC PROCEDURE insert_ra_rec_quickcash
341 |
342 | DESCRIPTION:
343 | This procedure will be called from PRO*C files in the
344 | /src/cash directory
345 | to process the mrc data for insert.
346 |
347 | CALLS PROCEDURES / FUNCTIONS (local to this package body)
348 |
349 | PARAMETERS
350 | p_rec_app_id IN NUMBER
351 |
352 | KNOWN ISSUES:
353 |
354 | NOTES:
355 |
356 |
357 | MODIFICATION HISTORY
358 | Date Author Description of Change
359 | 09/04/02 Debbie Sue Jancis Created
360 *============================================================================*/
361 PROCEDURE insert_ra_rec_quickcash(
362 p_rec_app_id IN NUMBER
363 );
364
365 /*=============================================================================
366 | PUBLIC PROCEDURE update_selected_transaction
367 |
368 | DESCRIPTION:
369 | This procedure will be called from
370 | ARP_PROCESS_APPLICATION(ARCEAPPB.pls)
371 | to process the mrc data for insert.
372 |
373 | CALLS PROCEDURES / FUNCTIONS (local to this package body)
374 |
375 | PARAMETERS
376 | pn_amount_applied IN NUMBER
377 | p_app_ra_rec IN ar_receivable_applications%ROWTYPE
378 | p_unapp_ra_rec IN ar_receivable_applications%ROWTYPE
379 |
380 | KNOWN ISSUES:
381 |
382 | NOTES:
383 |
384 |
385 | MODIFICATION HISTORY
386 | Date Author Description of Change
387 | 09/09/02 Debbie Sue Jancis Created
388 *============================================================================*/
389 PROCEDURE update_selected_transaction(
390 pn_amount_applied IN NUMBER,
391 p_app_ra_rec IN ar_receivable_applications%ROWTYPE,
392 p_unapp_ra_rec IN ar_receivable_applications%ROWTYPE
393 );
394
395 /*=============================================================================
396 | PUBLIC PROCEDURE activity_application
397 |
398 | DESCRIPTION:
399 | This procedure will be called from
400 | ARP_PROCESS_APPLICATION(ARCEAPPB.pls)
401 | to process the mrc data for insert.
402 |
403 | CALLS PROCEDURES / FUNCTIONS (local to this package body)
404 |
405 | PARAMETERS
409 | p_misc_ref_id IN NUMBER
406 | p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE
407 | p_amount_applied IN NUMBER
408 | p_application_ref_id IN NUMBER
410 | p_application_ps_id IN NUMBER
411 | p_activity_ra_rec IN ar_receivable_applications%ROWTYPE
412 | p_unapp_ra_rec IN ar_receivable_applications%ROWTYPE
413 |
414 | KNOWN ISSUES:
415 |
416 | NOTES:
417 |
418 |
419 | MODIFICATION HISTORY
420 | Date Author Description of Change
421 | 09/09/02 Debbie Sue Jancis Created
422 *============================================================================*/
423 PROCEDURE activity_application(
424 p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
425 p_amount_applied IN NUMBER,
426 p_application_ref_id IN NUMBER,
427 p_misc_ref_id IN NUMBER,
428 p_application_ps_id IN NUMBER,
429 p_activity_ra_rec IN ar_receivable_applications%ROWTYPE,
430 p_unapp_ra_rec IN ar_receivable_applications%ROWTYPE
431 );
432
433 /*=============================================================================
434 | PUBLIC PROCEDURE rate_adj_insert_rec
435 |
436 | DESCRIPTION:
437 | This procedure will be called from
438 | ARP_RATE_ADJUSTMENT
439 | to process the mrc data for insert.
440 |
441 | CALLS PROCEDURES / FUNCTIONS (local to this package body)
442 |
443 | PARAMETERS
444 | p_app_ra_rec IN AR_RECEIVABLE_APPLICATIONS%ROWTYPE
445 | p_unapp_ra_rec IN AR_RECEIVABLE_APPLICATIONS%ROWTYPE
446 | p_rec_orig_app_id IN NUMBER
447 | p_rec_app_id IN NUMBER
448 | p_rec_unapp_id IN NUMBER
449 | p_amt_due_remaining IN NUMBER
450 |
451 |
452 | KNOWN ISSUES:
453 |
454 | NOTES:
455 |
456 | MODIFICATION HISTORY
457 | Date Author Description of Change
458 | 09/09/02 Debbie Sue Jancis Created
459 *============================================================================*/
460 PROCEDURE rate_adj_insert_rec (
461 p_app_ra_rec IN AR_RECEIVABLE_APPLICATIONS%ROWTYPE,
462 p_unapp_ra_rec IN AR_RECEIVABLE_APPLICATIONS%ROWTYPE,
463 p_rec_orig_app_id IN NUMBER,
464 p_rec_app_id IN NUMBER,
465 p_rec_unapp_id IN NUMBER,
466 p_amt_due_remaining IN NUMBER);
467
468 /*=============================================================================
469 | PUBLIC PROCEDURE confirm_ra_rec_create
470 |
471 | DESCRIPTION:
472 | This procedure will be called from
473 | ARP_confirmation
474 | to process the mrc data for insert.
475 |
476 | CALLS PROCEDURES / FUNCTIONS (local to this package body)
477 |
478 | PARAMETERS
479 | p_rec_record IN arp_confirmation.new_con_data
480 |
481 |
482 | KNOWN ISSUES:
483 |
484 | NOTES:
485 |
486 |
487 | MODIFICATION HISTORY
488 | Date Author Description of Change
489 | 09/16/02 Debbie Sue Jancis Created
490 *============================================================================*/
491 PROCEDURE confirm_ra_rec_create(
492 p_rec_record IN ARP_CONFIRMATION.NEW_CON_DATA
493 ) ;
494
495 /*=============================================================================
496 | PUBLIC PROCEDURE update_ra_rec_cash_diff
497 |
498 | DESCRIPTION:
499 | This procedure will be called from
500 | ARP_PROC_RECEIPTS1
501 | to process the mrc data for receivable applications
502 | this was created for bug 2576372.
503 |
504 | CALLS PROCEDURES / FUNCTIONS (local to this package body)
505 |
506 | PARAMETERS
507 | p_rec_app_id IN NUMBER,
508 | p_cash_Receipt_id IN ar_cash_Receipts.cash_Receipt_id%type
509 | p_diff_amount IN ar_cash_Receipts.amount%TYPE
510 | p_old_rcpt_amount IN ar_cash_Receipts.amount%TYPE
511 | p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE
512 |
513 |
514 | KNOWN ISSUES:
515 |
516 | NOTES:
517 |
518 |
519 | MODIFICATION HISTORY
520 | Date Author Description of Change
521 | 09/20/02 Debbie Sue Jancis Created for bug 2576372
522 *============================================================================*/
523 PROCEDURE update_ra_rec_cash_diff(
524 p_rec_app_id IN NUMBER,
525 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
526 p_diff_amount IN ar_cash_receipts.amount%TYPE,
527 p_old_rcpt_amount IN ar_cash_receipts.amount%TYPE,
528 p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE
529 );
530 END AR_MRC_ENGINE3;