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: |
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: );
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,
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
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: /*=============================================================================
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
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: /*=============================================================================
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: /*=============================================================================
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
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:
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: /*=============================================================================
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:
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: |
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:
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: /*=============================================================================
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
407: | p_amount_applied IN NUMBER
408: | p_application_ref_id IN NUMBER
409: | p_misc_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: |
408: | p_application_ref_id IN NUMBER
409: | p_misc_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:
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: /*=============================================================================
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
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
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
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,
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);