[Home] [Help]
1126: arp_standard.debug('main: ' || 'old_misc gl_date ' ||old_misc.gl_date);
1127: arp_standard.debug('bal due remain ' ||l_bal_due_remaining);
1128: END IF;
1129:
1130: arp_process_application.reverse(
1131: l_rc_app.receivable_application_id,
1132: greatest(new_adj.gl_date, l_rc_app.gl_date),
1133: trunc(sysdate),
1134: 'RATE ADJUSTMENT TRIGGER',
1149:
1150:
1151: /* now that the old CCR has been unapplied; apply the new CCR with the new rate- pkt */
1152: BEGIN
1153: arp_process_application.activity_application (
1154: p_receipt_ps_id => l_rc_app.payment_schedule_id,
1155: p_application_ps_id =>l_rc_app.applied_payment_schedule_id ,
1156: p_link_to_customer_trx_id => NULL,
1157: p_amount_applied => l_rc_app.amount_applied,
1391: THEN
1392: l_claim_id := NULL;
1393: l_claim_amount := ps_remaining.amount_due_remaining +
1394: nvl(old_rec_app.amount_applied_from, old_rec_app.amount_applied);
1395: arp_process_application.update_claim(
1396: p_claim_id => l_claim_id
1397: , p_invoice_ps_id => old_rec_app.applied_payment_schedule_id
1398: , p_customer_trx_id => old_rec_app.customer_trx_id
1399: , p_amount => l_claim_amount
2043: , net_ra_rec);
2044:
2045:
2046:
2047: arp_process_application.reverse(
2048: p_ra_id => old_rec_app.applied_rec_app_id
2049: , p_reversal_gl_date => GREATEST(old_rec_app.gl_date, new_adj.gl_date)
2050: , p_reversal_date => TRUNC(SYSDATE)
2051: , p_module_name => 'ARPLRADB'
2052: , p_module_version => '1.0'
2053: , p_bal_due_remaining => l_bal_due_remaining
2054: , p_called_from => 'ARPLRADB');
2055:
2056: arp_process_application.activity_application (
2057: p_receipt_ps_id => net_ra_rec.payment_schedule_id,
2058: p_application_ps_id => net_ra_rec.applied_payment_schedule_id,
2059: p_link_to_customer_trx_id => net_ra_rec.link_to_customer_trx_id,
2060: p_amount_applied => net_ra_rec.amount_applied,