APPS.AR_MRC_ENGINE3 dependencies on AR_RECEIVABLE_APPLICATIONS

Line 19: | p_rec_app_record IN ar_receivable_applications%ROWTYPE

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: |

Line 36: p_rec_app_record IN ar_receivable_applications%ROWTYPE,

32: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
33:
34: PROCEDURE insert_ra_rec_cash(
35: p_rec_app_id IN NUMBER,
36: p_rec_app_record IN ar_receivable_applications%ROWTYPE,
37: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
38: p_amount IN ar_cash_receipts.amount%TYPE,
39: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE
40: ) IS

Line 205: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,

201: *============================================================================*/
202: PROCEDURE receipt_application(
203: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
204: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
205: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
206: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
207: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
208: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
209: p_rec_ra_rec IN ar_receivable_applications %ROWTYPE,

Line 206: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,

202: PROCEDURE receipt_application(
203: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
204: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
205: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
206: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
207: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
208: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
209: p_rec_ra_rec IN ar_receivable_applications %ROWTYPE,
210: p_inv_ra_rec IN ar_receivable_applications %ROWTYPE

Line 209: p_rec_ra_rec IN ar_receivable_applications %ROWTYPE,

205: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
206: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
207: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
208: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
209: p_rec_ra_rec IN ar_receivable_applications %ROWTYPE,
210: p_inv_ra_rec IN ar_receivable_applications %ROWTYPE
211: ) IS
212: BEGIN
213: NULL;

Line 210: p_inv_ra_rec IN ar_receivable_applications %ROWTYPE

206: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
207: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
208: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
209: p_rec_ra_rec IN ar_receivable_applications %ROWTYPE,
210: p_inv_ra_rec IN ar_receivable_applications %ROWTYPE
211: ) IS
212: BEGIN
213: NULL;
214: -- IF PG_DEBUG in ('Y', 'C') THEN

Line 301: p_inv_ra_rec IN ar_receivable_applications %ROWTYPE,

297: *============================================================================*/
298: PROCEDURE cm_application(
299: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
300: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
301: p_inv_ra_rec IN ar_receivable_applications %ROWTYPE,
302: p_ra_id IN NUMBER
303: ) IS
304:
305: l_ra_rec ar_receivable_applications%ROWTYPE;

Line 305: l_ra_rec ar_receivable_applications%ROWTYPE;

301: p_inv_ra_rec IN ar_receivable_applications %ROWTYPE,
302: p_ra_id IN NUMBER
303: ) IS
304:
305: l_ra_rec ar_receivable_applications%ROWTYPE;
306:
307: BEGIN
308: NULl;
309: -- IF PG_DEBUG in ('Y', 'C') THEN

Line 341: -- from ar_receivable_applications

337:
338: -- IF (p_inv_ra_rec.receivable_application_id IS NULL) THEN
339: -- select *
340: -- INTO l_ra_rec
341: -- from ar_receivable_applications
342: -- where receivable_application_id = p_ra_id;
343: -- ELSE
344: -- l_ra_rec := p_inv_ra_rec;
345: -- END IF;

Line 394: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,

390: | 09/04/02 Debbie Sue Jancis Created
391: *============================================================================*/
392: PROCEDURE on_account_receipts(
393: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
394: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
395: p_acc_ra_rec IN ar_receivable_applications %ROWTYPE,
396: p_unapp_rec_app_id IN NUMBER
397: ) IS
398: BEGIN

Line 395: p_acc_ra_rec IN ar_receivable_applications %ROWTYPE,

391: *============================================================================*/
392: PROCEDURE on_account_receipts(
393: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
394: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
395: p_acc_ra_rec IN ar_receivable_applications %ROWTYPE,
396: p_unapp_rec_app_id IN NUMBER
397: ) IS
398: BEGIN
399: NULL;

Line 478: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,

474: | 09/04/02 Debbie Sue Jancis Created
475: *============================================================================*/
476: PROCEDURE other_account_application(
477: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
478: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
479: p_otheracc_ra_rec IN ar_receivable_applications %ROWTYPE,
480: p_unapp_rec_app_id IN NUMBER
481: ) IS
482: BEGIN

Line 479: p_otheracc_ra_rec IN ar_receivable_applications %ROWTYPE,

475: *============================================================================*/
476: PROCEDURE other_account_application(
477: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
478: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
479: p_otheracc_ra_rec IN ar_receivable_applications %ROWTYPE,
480: p_unapp_rec_app_id IN NUMBER
481: ) IS
482: BEGIN
483: NULL;

Line 561: p_ra_rec IN ar_receivable_applications %ROWTYPE,

557: | Date Author Description of Change
558: | 09/04/02 Debbie Sue Jancis Created
559: *============================================================================*/
560: PROCEDURE reversal_insert_oppos_ra_recs(
561: p_ra_rec IN ar_receivable_applications %ROWTYPE,
562: p_orig_rec_app_id IN NUMBER,
563: p_new_rec_app_id IN NUMBER
564: ) IS
565: BEGIN

Line 1015: | p_app_ra_rec IN ar_receivable_applications%ROWTYPE

1011: | CALLS PROCEDURES / FUNCTIONS (local to this package body)
1012: |
1013: | PARAMETERS
1014: | pn_amount_applied IN NUMBER
1015: | p_app_ra_rec IN ar_receivable_applications%ROWTYPE
1016: | p_unapp_ra_rec IN ar_receivable_applications%ROWTYPE
1017: |
1018: | KNOWN ISSUES:
1019: |

Line 1016: | p_unapp_ra_rec IN ar_receivable_applications%ROWTYPE

1012: |
1013: | PARAMETERS
1014: | pn_amount_applied IN NUMBER
1015: | p_app_ra_rec IN ar_receivable_applications%ROWTYPE
1016: | p_unapp_ra_rec IN ar_receivable_applications%ROWTYPE
1017: |
1018: | KNOWN ISSUES:
1019: |
1020: | NOTES:

Line 1029: p_app_ra_rec IN ar_receivable_applications%ROWTYPE,

1025: | 09/09/02 Debbie Sue Jancis Created
1026: *============================================================================*/
1027: PROCEDURE update_selected_transaction(
1028: pn_amount_applied IN NUMBER,
1029: p_app_ra_rec IN ar_receivable_applications%ROWTYPE,
1030: p_unapp_ra_rec IN ar_receivable_applications%ROWTYPE
1031: ) IS
1032: BEGIN
1033: NULL;

Line 1030: p_unapp_ra_rec IN ar_receivable_applications%ROWTYPE

1026: *============================================================================*/
1027: PROCEDURE update_selected_transaction(
1028: pn_amount_applied IN NUMBER,
1029: p_app_ra_rec IN ar_receivable_applications%ROWTYPE,
1030: p_unapp_ra_rec IN ar_receivable_applications%ROWTYPE
1031: ) IS
1032: BEGIN
1033: NULL;
1034: -- IF PG_DEBUG in ('Y', 'C') THEN

Line 1096: | p_activity_ra_rec IN ar_receivable_applications%ROWTYPE

1092: | p_amount_applied IN NUMBER
1093: | p_application_ref_id IN NUMBER
1094: | p_misc_ref_id IN NUMBER
1095: | p_application_ps_id IN NUMBER
1096: | p_activity_ra_rec IN ar_receivable_applications%ROWTYPE
1097: | p_unapp_ra_rec IN ar_receivable_applications%ROWTYPE
1098: |
1099: | KNOWN ISSUES:
1100: |

Line 1097: | p_unapp_ra_rec IN ar_receivable_applications%ROWTYPE

1093: | p_application_ref_id IN NUMBER
1094: | p_misc_ref_id IN NUMBER
1095: | p_application_ps_id IN NUMBER
1096: | p_activity_ra_rec IN ar_receivable_applications%ROWTYPE
1097: | p_unapp_ra_rec IN ar_receivable_applications%ROWTYPE
1098: |
1099: | KNOWN ISSUES:
1100: |
1101: | NOTES:

Line 1114: p_activity_ra_rec IN ar_receivable_applications%ROWTYPE,

1110: p_amount_applied IN NUMBER,
1111: p_application_ref_id IN NUMBER,
1112: p_misc_ref_id IN NUMBER,
1113: p_application_ps_id IN NUMBER,
1114: p_activity_ra_rec IN ar_receivable_applications%ROWTYPE,
1115: p_unapp_ra_rec IN ar_receivable_applications%ROWTYPE
1116: ) IS
1117: BEGIN
1118: NULL;

Line 1115: p_unapp_ra_rec IN ar_receivable_applications%ROWTYPE

1111: p_application_ref_id IN NUMBER,
1112: p_misc_ref_id IN NUMBER,
1113: p_application_ps_id IN NUMBER,
1114: p_activity_ra_rec IN ar_receivable_applications%ROWTYPE,
1115: p_unapp_ra_rec IN ar_receivable_applications%ROWTYPE
1116: ) IS
1117: BEGIN
1118: NULL;
1119: -- IF PG_DEBUG in ('Y', 'C') THEN

Line 1184: | p_app_ra_rec IN AR_RECEIVABLE_APPLICATIONS%ROWTYPE

1180: |
1181: | CALLS PROCEDURES / FUNCTIONS (local to this package body)
1182: |
1183: | PARAMETERS
1184: | p_app_ra_rec IN AR_RECEIVABLE_APPLICATIONS%ROWTYPE
1185: | p_unapp_ra_rec IN AR_RECEIVABLE_APPLICATIONS%ROWTYPE
1186: | p_rec_orig_app_id IN NUMBER
1187: | p_rec_app_id IN NUMBER
1188: | p_rec_unapp_id IN NUMBER

Line 1185: | p_unapp_ra_rec IN AR_RECEIVABLE_APPLICATIONS%ROWTYPE

1181: | CALLS PROCEDURES / FUNCTIONS (local to this package body)
1182: |
1183: | PARAMETERS
1184: | p_app_ra_rec IN AR_RECEIVABLE_APPLICATIONS%ROWTYPE
1185: | p_unapp_ra_rec IN AR_RECEIVABLE_APPLICATIONS%ROWTYPE
1186: | p_rec_orig_app_id IN NUMBER
1187: | p_rec_app_id IN NUMBER
1188: | p_rec_unapp_id IN NUMBER
1189: | p_amt_due_remaining IN NUMBER

Line 1201: p_app_ra_rec IN AR_RECEIVABLE_APPLICATIONS%ROWTYPE,

1197: | Date Author Description of Change
1198: | 09/09/02 Debbie Sue Jancis Created
1199: *============================================================================*/
1200: PROCEDURE rate_adj_insert_rec (
1201: p_app_ra_rec IN AR_RECEIVABLE_APPLICATIONS%ROWTYPE,
1202: p_unapp_ra_rec IN AR_RECEIVABLE_APPLICATIONS%ROWTYPE,
1203: p_rec_orig_app_id IN NUMBER,
1204: p_rec_app_id IN NUMBER,
1205: p_rec_unapp_id IN NUMBER,

Line 1202: p_unapp_ra_rec IN AR_RECEIVABLE_APPLICATIONS%ROWTYPE,

1198: | 09/09/02 Debbie Sue Jancis Created
1199: *============================================================================*/
1200: PROCEDURE rate_adj_insert_rec (
1201: p_app_ra_rec IN AR_RECEIVABLE_APPLICATIONS%ROWTYPE,
1202: p_unapp_ra_rec IN AR_RECEIVABLE_APPLICATIONS%ROWTYPE,
1203: p_rec_orig_app_id IN NUMBER,
1204: p_rec_app_id IN NUMBER,
1205: p_rec_unapp_id IN NUMBER,
1206: p_amt_due_remaining IN NUMBER) IS