APPS.ARP_PROC_RECEIPTS1 dependencies on ARP_PROC_RCT_UTIL

Line 420: arp_proc_rct_util.get_ps_rec(l_cr_rec.cash_receipt_id,

416: arp_cash_receipts_pkg.nowaitlock_fetch_p(l_cr_rec);
417:
418: -- get payment schedule record for receipt:
419:
420: arp_proc_rct_util.get_ps_rec(l_cr_rec.cash_receipt_id,
421: l_ps_rec);
422:
423: --apandit
424: --Bug 2641517, populating the history rec.

Line 553: arp_proc_rct_util.get_ccids(

549: -- -------------------------------------------------------------
550: -- determine account code combination ids
551: -- -------------------------------------------------------------
552:
553: arp_proc_rct_util.get_ccids(
554: p_receipt_method_id,
555: p_remittance_bank_account_id,
556: l_unidentified_ccid,
557: l_unapplied_ccid,

Line 705: arp_proc_rct_util.insert_ra_rec_cash(

701: AND status = 'UNID';
702:
703: -- now create matching UNID record with negative amount
704:
705: arp_proc_rct_util.insert_ra_rec_cash(
706: p_cash_receipt_id,
707: -l_cr_rec.amount,
708: p_receipt_date,
709: 'UNID',

Line 733: arp_proc_rct_util.insert_ra_rec_cash(

729: arp_acct_main.Create_Acct_Entry(l_ae_doc_rec);
730:
731: -- now create new UNAPP record for this receipt:
732:
733: arp_proc_rct_util.insert_ra_rec_cash(
734: p_cash_receipt_id,
735: l_cr_rec.amount,
736: p_receipt_date,
737: 'UNAPP',

Line 793: arp_proc_rct_util.insert_ra_rec_cash(

789: AND status = 'UNAPP';
790:
791: -- now create matching UNAPP record with negative amount
792:
793: arp_proc_rct_util.insert_ra_rec_cash(
794: p_cash_receipt_id,
795: -l_cr_rec.amount,
796: p_receipt_date,
797: 'UNAPP',

Line 808: arp_proc_rct_util.insert_ra_rec_cash(

804: l_ra_id_unapp);
805:
806: -- now create new UNID record for this receipt:
807:
808: arp_proc_rct_util.insert_ra_rec_cash(
809: p_cash_receipt_id,
810: l_cr_rec.amount,
811: p_receipt_date,
812: 'UNID',

Line 987: arp_proc_rct_util.update_dist_rec(

983: IF PG_DEBUG in ('Y', 'C') THEN
984: arp_standard.debug('update_cash_receipt: '||'l_dist_row_on_current_crh : '||l_dist_row_on_current_crh);
985: END IF;
986: IF l_dist_row_on_current_crh = 'Y' THEN
987: arp_proc_rct_util.update_dist_rec(
988: l_crh_rec.cash_receipt_history_id,
989: l_source_type,
990: l_crh_amount_new - l_crh_rec.amount,
991: l_crh_acctd_amount_new - l_crh_rec.acctd_amount);

Line 1001: arp_proc_rct_util.insert_dist_rec(l_crh_amount_delta,

997: arp_standard.debug('update_cash_receipt: ' || 'l_source_type : ' || l_source_type);
998: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_crh_ccid);
999: END IF;
1000:
1001: arp_proc_rct_util.insert_dist_rec(l_crh_amount_delta,
1002: l_crh_acctd_amount_delta,
1003: l_crh_rec.cash_receipt_history_id,
1004: l_source_type,
1005: l_crh_ccid);

Line 1115: arp_proc_rct_util.update_dist_rec(

1111: -- Positive result will create a DR entry, negative a CR entry.
1112:
1113: /* Bug fix 3677912 */
1114: IF l_bcharge_row_on_current_crh = 'Y' THEN
1115: arp_proc_rct_util.update_dist_rec(
1116: l_crh_rec.cash_receipt_history_id,
1117: 'BANK_CHARGES',
1118: nvl(p_factor_discount_amount,0) - (l_sum_fda_debits - l_sum_fda_credits),
1119: nvl(l_crh_acctd_fda_new,0) - (l_sum_acctd_fda_debits - l_sum_acctd_fda_credits) );

Line 1121: arp_proc_rct_util.insert_dist_rec(

1117: 'BANK_CHARGES',
1118: nvl(p_factor_discount_amount,0) - (l_sum_fda_debits - l_sum_fda_credits),
1119: nvl(l_crh_acctd_fda_new,0) - (l_sum_acctd_fda_debits - l_sum_acctd_fda_credits) );
1120: ELSE
1121: arp_proc_rct_util.insert_dist_rec(
1122: nvl(p_factor_discount_amount,0) - (l_sum_fda_debits - l_sum_fda_credits),
1123: nvl(l_crh_acctd_fda_new,0) - (l_sum_acctd_fda_debits - l_sum_acctd_fda_credits),
1124: l_crh_rec.cash_receipt_history_id,
1125: 'BANK_CHARGES',

Line 1135: arp_proc_rct_util.insert_dist_rec(

1131: --
1132: -- If no bank charge record existed before, we need to create one.
1133: --
1134:
1135: arp_proc_rct_util.insert_dist_rec(
1136: p_factor_discount_amount,
1137: l_crh_acctd_fda_new,
1138: l_crh_rec.cash_receipt_history_id,
1139: 'BANK_CHARGES',

Line 1220: arp_proc_rct_util.insert_dist_rec(l_crh_amount_delta,

1216: arp_standard.debug('update_cash_receipt: ' || 'l_source_type : ' || l_source_type);
1217: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_crh_ccid);
1218: END IF;
1219:
1220: arp_proc_rct_util.insert_dist_rec(l_crh_amount_delta,
1221: l_crh_acctd_amount_delta,
1222: l_crh_rec.cash_receipt_history_id,
1223: l_source_type,
1224: l_crh_ccid);

Line 1241: arp_proc_rct_util.insert_dist_rec(

1237: arp_standard.debug('update_cash_receipt: ' || 'cash_receipt_history_id : ' || to_char(l_crh_rec.cash_receipt_history_id));
1238: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_bank_charges_ccid);
1239: END IF;
1240:
1241: arp_proc_rct_util.insert_dist_rec(
1242: l_crh_fda_delta,
1243: l_crh_acctd_fda_delta,
1244: l_crh_rec.cash_receipt_history_id,
1245: 'BANK_CHARGES',

Line 1259: arp_proc_rct_util.insert_ra_rec_cash(

1255:
1256: -- receipt is unidentified; create UNID record in
1257: -- AR_RECEIVABLE_APPLICATIONS
1258:
1259: arp_proc_rct_util.insert_ra_rec_cash(
1260: p_cash_receipt_id,
1261: l_cr_amount_delta,
1262: p_receipt_date,
1263: 'UNID',

Line 1299: arp_proc_rct_util.insert_ra_rec_cash(

1295:
1296: -- receipt is identified; create UNAPP record in
1297: -- AR_RECEIVABLE_APPLICATIONS
1298:
1299: arp_proc_rct_util.insert_ra_rec_cash(
1300: p_cash_receipt_id,
1301: l_cr_amount_delta,
1302: p_receipt_date,
1303: 'UNAPP',

Line 1656: arp_proc_rct_util.rate_adjust(

1652:
1653: -- check if receipt needs to be rate-adjusted:
1654:
1655: IF (p_rate_adjust_gl_date IS NOT NULL) THEN
1656: arp_proc_rct_util.rate_adjust(
1657: p_cash_receipt_id,
1658: p_rate_adjust_gl_date,
1659: p_new_exchange_date,
1660: p_new_exchange_rate,