DBA Data[Home] [Help]

APPS.ARP_CASHBOOK dependencies on ARP_CR_UTIL

Line 374: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,

370: l_dist_rec.code_combination_id := l_rma_rec.cash_ccid;
371: l_cash_amt := l_crh_rec_new.amount;
372: l_acctd_cash_amt := l_crh_rec_new.acctd_amount;
373: ELSE
374: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,
375: 'CRH', 'CASH', l_rma_rec,
376: l_dist_rec.code_combination_id);
377:
378: l_cash_amt := l_crh_rec_new.amount - L_crh_rec_old.amount;

Line 452: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,

448: THEN
449: l_dist_rec.source_id := l_crh_rec_new.cash_receipt_history_id;
450: l_dist_rec.source_table := 'CRH';
451: l_dist_rec.source_type := 'REMITTANCE';
452: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,
453: 'CRH', 'REMITTANCE', l_rma_rec,
454: l_dist_rec.code_combination_id);
455: -- Fix 1119979, assign acctd_amount_dr and acctd_amount_cr in above condn
456: IF ( l_cr_rec.amount < 0 )

Line 560: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,

556: THEN
557: l_dist_rec.source_id := l_crh_rec_new.cash_receipt_history_id;
558: l_dist_rec.source_table := 'CRH';
559: l_dist_rec.source_type := 'FACTOR';
560: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,
561: 'CRH', 'FACTOR', l_rma_rec,
562: l_dist_rec.code_combination_id);
563: -- Fix 1119979, assign acctd_amount_dr and acctd_amount_cr in above condn
564: IF ( (l_acctd_receipt_amt_new - l_acctd_receipt_amt_old) < 0 )

Line 612: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,

608: THEN
609: l_dist_rec.source_id := l_crh_rec_new.cash_receipt_history_id;
610: l_dist_rec.source_table := 'CRH';
611: l_dist_rec.source_type := 'SHORT_TERM_DEBT';
612: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,
613: 'CRH', 'SHORT_TERM_DEBT', l_rma_rec,
614: l_dist_rec.code_combination_id);
615: -- Fix 1119979, assign acctd_amount_dr and acctd_amount_cr in above condn
616: IF ( (l_acctd_receipt_amt_new - l_acctd_receipt_amt_old) < 0 )

Line 667: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,

663: l_dist_rec.code_combination_id := l_crh_rec_new.bank_charge_account_ccid;
664: l_bank_amt := nvl(l_crh_rec_new.factor_discount_amount,0);
665: l_acctd_bank_amt := nvl(l_crh_rec_new.acctd_factor_discount_amount,0);
666: ELSE
667: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,
668: 'CRH', 'BANK_CHARGES', l_rma_rec,
669: l_dist_rec.code_combination_id);
670: l_bank_amt := nvl(l_crh_rec_new.factor_discount_amount,0) - nvl(L_crh_rec_old.factor_discount_amount,0);
671: l_acctd_bank_amt := nvl(l_crh_rec_new.acctd_factor_discount_amount,0) - nvl(L_crh_rec_old.acctd_factor_discount_amount,0);

Line 918: arp_cr_util.get_dist_ccid( l_crh_rec_prv_stat.cash_receipt_id,

914: l_crh_rec_new.current_record_flag := 'Y';
915: l_crh_rec_new.batch_id := l_crh_rec_prv_stat.batch_id;
916: IF ( l_crh_rec_old.factor_flag = 'Y' )
917: THEN
918: arp_cr_util.get_dist_ccid( l_crh_rec_prv_stat.cash_receipt_id,
919: 'CRH', 'FACTOR', l_rma_rec,
920: l_crh_rec_new.account_code_combination_id);
921: ELSE
922: arp_cr_util.get_dist_ccid( l_crh_rec_prv_stat.cash_receipt_id,

Line 922: arp_cr_util.get_dist_ccid( l_crh_rec_prv_stat.cash_receipt_id,

918: arp_cr_util.get_dist_ccid( l_crh_rec_prv_stat.cash_receipt_id,
919: 'CRH', 'FACTOR', l_rma_rec,
920: l_crh_rec_new.account_code_combination_id);
921: ELSE
922: arp_cr_util.get_dist_ccid( l_crh_rec_prv_stat.cash_receipt_id,
923: 'CRH', 'REMITTANCE', l_rma_rec,
924: l_crh_rec_new.account_code_combination_id);
925: END IF;
926: l_crh_rec_new.reversal_gl_date := NULL;

Line 928: arp_cr_util.get_dist_ccid( l_crh_rec_prv_stat.cash_receipt_id,

924: l_crh_rec_new.account_code_combination_id);
925: END IF;
926: l_crh_rec_new.reversal_gl_date := NULL;
927: l_crh_rec_new.reversal_cash_receipt_hist_id := NULL;
928: arp_cr_util.get_dist_ccid( l_crh_rec_prv_stat.cash_receipt_id,
929: 'CRH', 'BANK_CHARGES', l_rma_rec,
930: l_crh_rec_new.bank_charge_account_ccid);
931: l_crh_rec_new.posting_control_id := -3;
932: l_crh_rec_new.reversal_posting_control_id := NULL;

Line 969: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,

965: l_dist_rec.source_table := 'CRH';
966: IF ( l_crh_rec_old.factor_flag = 'Y' )
967: THEN
968: l_dist_rec.source_type := 'SHORT_TERM_DEBT';
969: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,
970: 'CRH', 'SHORT_TERM_DEBT', l_rma_rec,
971: l_dist_rec.code_combination_id);
972: ELSE
973: l_dist_rec.source_type := 'REMITTANCE';

Line 974: arp_cr_util.get_dist_ccid( l_crh_rec_prv_stat.cash_receipt_id,

970: 'CRH', 'SHORT_TERM_DEBT', l_rma_rec,
971: l_dist_rec.code_combination_id);
972: ELSE
973: l_dist_rec.source_type := 'REMITTANCE';
974: arp_cr_util.get_dist_ccid( l_crh_rec_prv_stat.cash_receipt_id,
975: 'CRH', 'REMITTANCE', l_rma_rec,
976: l_dist_rec.code_combination_id);
977: END IF;
978:

Line 1015: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,

1011: */
1012: l_dist_rec.source_id := l_crh_rec_new.cash_receipt_history_id;
1013: l_dist_rec.source_table := 'CRH';
1014: l_dist_rec.source_type := 'CASH';
1015: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,
1016: 'CRH', 'CASH', l_rma_rec,
1017: l_dist_rec.code_combination_id);
1018: -- Fix 1119979, assign acctd_amount_dr and acctd_amount_cr in above condn
1019: IF ( l_crh_rec_old.amount < 0 )

Line 1053: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,

1049: THEN
1050: l_dist_rec.source_id := l_crh_rec_new.cash_receipt_history_id;
1051: l_dist_rec.source_table := 'CRH';
1052: l_dist_rec.source_type := 'BANK_CHARGES';
1053: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,
1054: 'CRH', 'BANK_CHARGES', l_rma_rec,
1055: l_dist_rec.code_combination_id);
1056:
1057: -- Fix 1119979, assign acctd_amount_dr and acctd_amount_cr in above condn

Line 1233: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,

1229: l_crh_rec_new.postable_flag := 'Y';
1230: l_crh_rec_new.factor_flag := l_crh_rec_old.factor_flag;
1231: l_crh_rec_new.gl_date := p_gl_date;
1232: l_crh_rec_new.current_record_flag := 'Y';
1233: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,
1234: 'CRH','SHORT_TERM_DEBT', NULL_VAR,
1235: l_crh_rec_new.account_code_combination_id);
1236: l_crh_rec_new.reversal_gl_date := NULL;
1237: l_crh_rec_new.reversal_cash_receipt_hist_id := NULL;

Line 1238: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,

1234: 'CRH','SHORT_TERM_DEBT', NULL_VAR,
1235: l_crh_rec_new.account_code_combination_id);
1236: l_crh_rec_new.reversal_gl_date := NULL;
1237: l_crh_rec_new.reversal_cash_receipt_hist_id := NULL;
1238: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,
1239: 'CRH', 'BANK_CHARGES', NULL_VAR,
1240: l_crh_rec_new.bank_charge_account_ccid);
1241: l_crh_rec_new.posting_control_id := -3;
1242: l_crh_rec_new.reversal_posting_control_id := NULL;

Line 1275: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,

1271: */
1272: l_dist_rec.source_id := l_crh_rec_new.cash_receipt_history_id;
1273: l_dist_rec.source_table := 'CRH';
1274: l_dist_rec.source_type := 'SHORT_TERM_DEBT';
1275: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,
1276: 'CRH', 'SHORT_TERM_DEBT', NULL_VAR,
1277: l_dist_rec.code_combination_id);
1278: -- Fix 1119979, assign acctd_amount_dr and acctd_amount_cr in above condn
1279: IF ( l_receipt_amt < 0 )

Line 1324: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,

1320: */
1321: l_dist_rec.source_id := l_crh_rec_new.cash_receipt_history_id;
1322: l_dist_rec.source_table := 'CRH';
1323: l_dist_rec.source_type := 'FACTOR';
1324: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,
1325: 'CRH', 'FACTOR', NULL_VAR,
1326: l_dist_rec.code_combination_id);
1327: -- Fix 1119979, assign acctd_amount_dr and acctd_amount_cr in above condn
1328: IF ( l_receipt_amt < 0 )

Line 1449: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,

1445: l_crh_rec_new.postable_flag := 'Y';
1446: l_crh_rec_new.factor_flag := l_crh_rec_old.factor_flag;
1447: l_crh_rec_new.gl_date := p_gl_date;
1448: l_crh_rec_new.current_record_flag := 'Y';
1449: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,
1450: 'CRH','FACTOR', NULL_VAR,
1451: l_crh_rec_new.account_code_combination_id);
1452: l_crh_rec_new.reversal_gl_date := NULL;
1453: l_crh_rec_new.reversal_cash_receipt_hist_id := NULL;

Line 1454: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,

1450: 'CRH','FACTOR', NULL_VAR,
1451: l_crh_rec_new.account_code_combination_id);
1452: l_crh_rec_new.reversal_gl_date := NULL;
1453: l_crh_rec_new.reversal_cash_receipt_hist_id := NULL;
1454: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,
1455: 'CRH', 'BANK_CHARGES', NULL_VAR,
1456: l_crh_rec_new.bank_charge_account_ccid);
1457: l_crh_rec_new.posting_control_id := -3;
1458: l_crh_rec_new.reversal_posting_control_id := NULL;

Line 1483: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,

1479: */
1480: l_dist_rec.source_id := l_crh_rec_new.cash_receipt_history_id;
1481: l_dist_rec.source_table := 'CRH';
1482: l_dist_rec.source_type := 'SHORT_TERM_DEBT';
1483: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,
1484: 'CRH', 'SHORT_TERM_DEBT', NULL_VAR,
1485: l_dist_rec.code_combination_id);
1486: -- Fix 1119979, assign acctd_amount_dr and acctd_amount_cr in above condn
1487: IF ( l_receipt_amt < 0 )

Line 1533: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,

1529: */
1530: l_dist_rec.source_id := l_crh_rec_new.cash_receipt_history_id;
1531: l_dist_rec.source_table := 'CRH';
1532: l_dist_rec.source_type := 'FACTOR';
1533: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,
1534: 'CRH', 'FACTOR', NULL_VAR,
1535: l_dist_rec.code_combination_id);
1536: -- Fix 1119979, assign acctd_amount_dr and acctd_amount_cr in above condn
1537: IF ( l_receipt_amt < 0 )