APPS.ARP_PROC_RECEIPTS1 dependencies on ARP_PROC_RCT_UTIL

Line 405: arp_proc_rct_util.get_ps_rec(l_cr_rec.cash_receipt_id,

401: arp_cash_receipts_pkg.nowaitlock_fetch_p(l_cr_rec);
402:
403: -- get payment schedule record for receipt:
404:
405: arp_proc_rct_util.get_ps_rec(l_cr_rec.cash_receipt_id,
406: l_ps_rec);
407:
408: --apandit
409: --Bug 2641517, populating the history rec.

Line 538: arp_proc_rct_util.get_ccids(

534: -- -------------------------------------------------------------
535: -- determine account code combination ids
536: -- -------------------------------------------------------------
537:
538: arp_proc_rct_util.get_ccids(
539: p_receipt_method_id,
540: p_remittance_bank_account_id,
541: l_unidentified_ccid,
542: l_unapplied_ccid,

Line 690: arp_proc_rct_util.insert_ra_rec_cash(

686: AND status = 'UNID';
687:
688: -- now create matching UNID record with negative amount
689:
690: arp_proc_rct_util.insert_ra_rec_cash(
691: p_cash_receipt_id,
692: -l_cr_rec.amount,
693: p_receipt_date,
694: 'UNID',

Line 718: arp_proc_rct_util.insert_ra_rec_cash(

714: arp_acct_main.Create_Acct_Entry(l_ae_doc_rec);
715:
716: -- now create new UNAPP record for this receipt:
717:
718: arp_proc_rct_util.insert_ra_rec_cash(
719: p_cash_receipt_id,
720: l_cr_rec.amount,
721: p_receipt_date,
722: 'UNAPP',

Line 771: arp_proc_rct_util.insert_ra_rec_cash(

767: AND status = 'UNAPP';
768:
769: -- now create matching UNAPP record with negative amount
770:
771: arp_proc_rct_util.insert_ra_rec_cash(
772: p_cash_receipt_id,
773: -l_cr_rec.amount,
774: p_receipt_date,
775: 'UNAPP',

Line 786: arp_proc_rct_util.insert_ra_rec_cash(

782: l_ra_id_unapp);
783:
784: -- now create new UNID record for this receipt:
785:
786: arp_proc_rct_util.insert_ra_rec_cash(
787: p_cash_receipt_id,
788: l_cr_rec.amount,
789: p_receipt_date,
790: 'UNID',

Line 957: arp_proc_rct_util.update_dist_rec(

953: IF PG_DEBUG in ('Y', 'C') THEN
954: arp_standard.debug('update_cash_receipt: '||'l_dist_row_on_current_crh : '||l_dist_row_on_current_crh);
955: END IF;
956: IF l_dist_row_on_current_crh = 'Y' THEN
957: arp_proc_rct_util.update_dist_rec(
958: l_crh_rec.cash_receipt_history_id,
959: l_source_type,
960: l_crh_amount_new - l_crh_rec.amount,
961: l_crh_acctd_amount_new - l_crh_rec.acctd_amount);

Line 971: arp_proc_rct_util.insert_dist_rec(l_crh_amount_delta,

967: arp_standard.debug('update_cash_receipt: ' || 'l_source_type : ' || l_source_type);
968: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_crh_ccid);
969: END IF;
970:
971: arp_proc_rct_util.insert_dist_rec(l_crh_amount_delta,
972: l_crh_acctd_amount_delta,
973: l_crh_rec.cash_receipt_history_id,
974: l_source_type,
975: l_crh_ccid);

Line 1085: arp_proc_rct_util.update_dist_rec(

1081: -- Positive result will create a DR entry, negative a CR entry.
1082:
1083: /* Bug fix 3677912 */
1084: IF l_bcharge_row_on_current_crh = 'Y' THEN
1085: arp_proc_rct_util.update_dist_rec(
1086: l_crh_rec.cash_receipt_history_id,
1087: 'BANK_CHARGES',
1088: nvl(p_factor_discount_amount,0) - (l_sum_fda_debits - l_sum_fda_credits),
1089: nvl(l_crh_acctd_fda_new,0) - (l_sum_acctd_fda_debits - l_sum_acctd_fda_credits) );

Line 1091: arp_proc_rct_util.insert_dist_rec(

1087: 'BANK_CHARGES',
1088: nvl(p_factor_discount_amount,0) - (l_sum_fda_debits - l_sum_fda_credits),
1089: nvl(l_crh_acctd_fda_new,0) - (l_sum_acctd_fda_debits - l_sum_acctd_fda_credits) );
1090: ELSE
1091: arp_proc_rct_util.insert_dist_rec(
1092: nvl(p_factor_discount_amount,0) - (l_sum_fda_debits - l_sum_fda_credits),
1093: nvl(l_crh_acctd_fda_new,0) - (l_sum_acctd_fda_debits - l_sum_acctd_fda_credits),
1094: l_crh_rec.cash_receipt_history_id,
1095: 'BANK_CHARGES',

Line 1105: arp_proc_rct_util.insert_dist_rec(

1101: --
1102: -- If no bank charge record existed before, we need to create one.
1103: --
1104:
1105: arp_proc_rct_util.insert_dist_rec(
1106: p_factor_discount_amount,
1107: l_crh_acctd_fda_new,
1108: l_crh_rec.cash_receipt_history_id,
1109: 'BANK_CHARGES',

Line 1190: arp_proc_rct_util.insert_dist_rec(l_crh_amount_delta,

1186: arp_standard.debug('update_cash_receipt: ' || 'l_source_type : ' || l_source_type);
1187: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_crh_ccid);
1188: END IF;
1189:
1190: arp_proc_rct_util.insert_dist_rec(l_crh_amount_delta,
1191: l_crh_acctd_amount_delta,
1192: l_crh_rec.cash_receipt_history_id,
1193: l_source_type,
1194: l_crh_ccid);

Line 1211: arp_proc_rct_util.insert_dist_rec(

1207: arp_standard.debug('update_cash_receipt: ' || 'cash_receipt_history_id : ' || to_char(l_crh_rec.cash_receipt_history_id));
1208: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_bank_charges_ccid);
1209: END IF;
1210:
1211: arp_proc_rct_util.insert_dist_rec(
1212: l_crh_fda_delta,
1213: l_crh_acctd_fda_delta,
1214: l_crh_rec.cash_receipt_history_id,
1215: 'BANK_CHARGES',

Line 1229: arp_proc_rct_util.insert_ra_rec_cash(

1225:
1226: -- receipt is unidentified; create UNID record in
1227: -- AR_RECEIVABLE_APPLICATIONS
1228:
1229: arp_proc_rct_util.insert_ra_rec_cash(
1230: p_cash_receipt_id,
1231: l_cr_amount_delta,
1232: p_receipt_date,
1233: 'UNID',

Line 1269: arp_proc_rct_util.insert_ra_rec_cash(

1265:
1266: -- receipt is identified; create UNAPP record in
1267: -- AR_RECEIVABLE_APPLICATIONS
1268:
1269: arp_proc_rct_util.insert_ra_rec_cash(
1270: p_cash_receipt_id,
1271: l_cr_amount_delta,
1272: p_receipt_date,
1273: 'UNAPP',

Line 1616: arp_proc_rct_util.rate_adjust(

1612:
1613: -- check if receipt needs to be rate-adjusted:
1614:
1615: IF (p_rate_adjust_gl_date IS NOT NULL) THEN
1616: arp_proc_rct_util.rate_adjust(
1617: p_cash_receipt_id,
1618: p_rate_adjust_gl_date,
1619: p_new_exchange_date,
1620: p_new_exchange_rate,