DBA Data[Home] [Help]

APPS.ARP_CASHBOOK dependencies on ARP_CR_UTIL

Line 573: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,

569: l_dist_rec.code_combination_id := l_rma_rec.cash_ccid;
570: l_cash_amt := l_crh_rec_new.amount;
571: l_acctd_cash_amt := l_crh_rec_new.acctd_amount;
572: ELSE
573: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,
574: 'CRH', 'CASH', l_rma_rec,
575: l_dist_rec.code_combination_id);
576:
577: l_cash_amt := l_crh_rec_new.amount - L_crh_rec_old.amount;

Line 651: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,

647: THEN
648: l_dist_rec.source_id := l_crh_rec_new.cash_receipt_history_id;
649: l_dist_rec.source_table := 'CRH';
650: l_dist_rec.source_type := 'REMITTANCE';
651: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,
652: 'CRH', 'REMITTANCE', l_rma_rec,
653: l_dist_rec.code_combination_id);
654: -- Fix 1119979, assign acctd_amount_dr and acctd_amount_cr in above condn
655: IF ( l_cr_rec.amount < 0 )

Line 759: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,

755: THEN
756: l_dist_rec.source_id := l_crh_rec_new.cash_receipt_history_id;
757: l_dist_rec.source_table := 'CRH';
758: l_dist_rec.source_type := 'FACTOR';
759: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,
760: 'CRH', 'FACTOR', l_rma_rec,
761: l_dist_rec.code_combination_id);
762: -- Fix 1119979, assign acctd_amount_dr and acctd_amount_cr in above condn
763: IF ( (l_acctd_receipt_amt_new - l_acctd_receipt_amt_old) < 0 )

Line 811: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,

807: THEN
808: l_dist_rec.source_id := l_crh_rec_new.cash_receipt_history_id;
809: l_dist_rec.source_table := 'CRH';
810: l_dist_rec.source_type := 'SHORT_TERM_DEBT';
811: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,
812: 'CRH', 'SHORT_TERM_DEBT', l_rma_rec,
813: l_dist_rec.code_combination_id);
814: -- Fix 1119979, assign acctd_amount_dr and acctd_amount_cr in above condn
815: IF ( (l_acctd_receipt_amt_new - l_acctd_receipt_amt_old) < 0 )

Line 866: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,

862: l_dist_rec.code_combination_id := l_crh_rec_new.bank_charge_account_ccid;
863: l_bank_amt := nvl(l_crh_rec_new.factor_discount_amount,0);
864: l_acctd_bank_amt := nvl(l_crh_rec_new.acctd_factor_discount_amount,0);
865: ELSE
866: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,
867: 'CRH', 'BANK_CHARGES', l_rma_rec,
868: l_dist_rec.code_combination_id);
869: l_bank_amt := nvl(l_crh_rec_new.factor_discount_amount,0) - nvl(L_crh_rec_old.factor_discount_amount,0);
870: 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 1251: arp_cr_util.get_dist_ccid( l_crh_rec_prv_stat.cash_receipt_id,

1247: l_crh_rec_new.current_record_flag := 'Y';
1248: l_crh_rec_new.batch_id := l_crh_rec_prv_stat.batch_id;
1249: IF ( l_crh_rec_old.factor_flag = 'Y' )
1250: THEN
1251: arp_cr_util.get_dist_ccid( l_crh_rec_prv_stat.cash_receipt_id,
1252: 'CRH', 'FACTOR', l_rma_rec,
1253: l_crh_rec_new.account_code_combination_id);
1254: ELSE
1255: arp_cr_util.get_dist_ccid( l_crh_rec_prv_stat.cash_receipt_id,

Line 1255: arp_cr_util.get_dist_ccid( l_crh_rec_prv_stat.cash_receipt_id,

1251: arp_cr_util.get_dist_ccid( l_crh_rec_prv_stat.cash_receipt_id,
1252: 'CRH', 'FACTOR', l_rma_rec,
1253: l_crh_rec_new.account_code_combination_id);
1254: ELSE
1255: arp_cr_util.get_dist_ccid( l_crh_rec_prv_stat.cash_receipt_id,
1256: 'CRH', 'REMITTANCE', l_rma_rec,
1257: l_crh_rec_new.account_code_combination_id);
1258: END IF;
1259: l_crh_rec_new.reversal_gl_date := NULL;

Line 1261: arp_cr_util.get_dist_ccid( l_crh_rec_prv_stat.cash_receipt_id,

1257: l_crh_rec_new.account_code_combination_id);
1258: END IF;
1259: l_crh_rec_new.reversal_gl_date := NULL;
1260: l_crh_rec_new.reversal_cash_receipt_hist_id := NULL;
1261: arp_cr_util.get_dist_ccid( l_crh_rec_prv_stat.cash_receipt_id,
1262: 'CRH', 'BANK_CHARGES', l_rma_rec,
1263: l_crh_rec_new.bank_charge_account_ccid);
1264: l_crh_rec_new.posting_control_id := -3;
1265: l_crh_rec_new.reversal_posting_control_id := NULL;

Line 1324: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,

1320: l_dist_rec.source_table := 'CRH';
1321: IF ( l_crh_rec_old.factor_flag = 'Y' )
1322: THEN
1323: l_dist_rec.source_type := 'SHORT_TERM_DEBT';
1324: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,
1325: 'CRH', 'SHORT_TERM_DEBT', l_rma_rec,
1326: l_dist_rec.code_combination_id);
1327: ELSE
1328: l_dist_rec.source_type := 'REMITTANCE';

Line 1329: arp_cr_util.get_dist_ccid( l_crh_rec_prv_stat.cash_receipt_id,

1325: 'CRH', 'SHORT_TERM_DEBT', l_rma_rec,
1326: l_dist_rec.code_combination_id);
1327: ELSE
1328: l_dist_rec.source_type := 'REMITTANCE';
1329: arp_cr_util.get_dist_ccid( l_crh_rec_prv_stat.cash_receipt_id,
1330: 'CRH', 'REMITTANCE', l_rma_rec,
1331: l_dist_rec.code_combination_id);
1332: END IF;
1333:

Line 1383: arp_cr_util.get_dist_ccid( l_crh_rec_prv_stat_cash.cash_receipt_id,

1379:
1380: l_dist_rec.source_id := l_crh_rec_new.cash_receipt_history_id;
1381: l_dist_rec.source_table := 'CRH';
1382: l_dist_rec.source_type := 'CASH';
1383: arp_cr_util.get_dist_ccid( l_crh_rec_prv_stat_cash.cash_receipt_id,
1384: 'CRH', 'CASH', l_rma_rec,
1385: l_dist_rec.code_combination_id);
1386:
1387: IF l_crh_rec_old.created_from <> 'RATE ADJUSTMENT TRIGGER' and l_crh_rec_old.status = 'CLEAR'

Line 1447: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,

1443: THEN
1444: l_dist_rec.source_id := l_crh_rec_new.cash_receipt_history_id;
1445: l_dist_rec.source_table := 'CRH';
1446: l_dist_rec.source_type := 'BANK_CHARGES';
1447: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,
1448: 'CRH', 'BANK_CHARGES', l_rma_rec,
1449: l_dist_rec.code_combination_id);
1450:
1451: -- Fix 1119979, assign acctd_amount_dr and acctd_amount_cr in above condn

Line 1588: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,

1584: l_crh_rec_new.postable_flag := 'Y';
1585: l_crh_rec_new.factor_flag := l_crh_rec_old.factor_flag;
1586: l_crh_rec_new.gl_date := p_gl_date;
1587: l_crh_rec_new.current_record_flag := 'Y';
1588: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,
1589: 'CRH','SHORT_TERM_DEBT', NULL_VAR,
1590: l_crh_rec_new.account_code_combination_id);
1591: l_crh_rec_new.reversal_gl_date := NULL;
1592: l_crh_rec_new.reversal_cash_receipt_hist_id := NULL;

Line 1593: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,

1589: 'CRH','SHORT_TERM_DEBT', NULL_VAR,
1590: l_crh_rec_new.account_code_combination_id);
1591: l_crh_rec_new.reversal_gl_date := NULL;
1592: l_crh_rec_new.reversal_cash_receipt_hist_id := NULL;
1593: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,
1594: 'CRH', 'BANK_CHARGES', NULL_VAR,
1595: l_crh_rec_new.bank_charge_account_ccid);
1596: l_crh_rec_new.posting_control_id := -3;
1597: l_crh_rec_new.reversal_posting_control_id := NULL;

Line 1630: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,

1626: */
1627: l_dist_rec.source_id := l_crh_rec_new.cash_receipt_history_id;
1628: l_dist_rec.source_table := 'CRH';
1629: l_dist_rec.source_type := 'SHORT_TERM_DEBT';
1630: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,
1631: 'CRH', 'SHORT_TERM_DEBT', NULL_VAR,
1632: l_dist_rec.code_combination_id);
1633: -- Fix 1119979, assign acctd_amount_dr and acctd_amount_cr in above condn
1634: IF ( l_receipt_amt < 0 )

Line 1679: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,

1675: */
1676: l_dist_rec.source_id := l_crh_rec_new.cash_receipt_history_id;
1677: l_dist_rec.source_table := 'CRH';
1678: l_dist_rec.source_type := 'FACTOR';
1679: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,
1680: 'CRH', 'FACTOR', NULL_VAR,
1681: l_dist_rec.code_combination_id);
1682: -- Fix 1119979, assign acctd_amount_dr and acctd_amount_cr in above condn
1683: IF ( l_receipt_amt < 0 )

Line 1858: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,

1854: l_crh_rec_new.postable_flag := 'Y';
1855: l_crh_rec_new.factor_flag := l_crh_rec_old.factor_flag;
1856: l_crh_rec_new.gl_date := p_gl_date;
1857: l_crh_rec_new.current_record_flag := 'Y';
1858: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,
1859: 'CRH','FACTOR', NULL_VAR,
1860: l_crh_rec_new.account_code_combination_id);
1861: l_crh_rec_new.reversal_gl_date := NULL;
1862: l_crh_rec_new.reversal_cash_receipt_hist_id := NULL;

Line 1863: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,

1859: 'CRH','FACTOR', NULL_VAR,
1860: l_crh_rec_new.account_code_combination_id);
1861: l_crh_rec_new.reversal_gl_date := NULL;
1862: l_crh_rec_new.reversal_cash_receipt_hist_id := NULL;
1863: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,
1864: 'CRH', 'BANK_CHARGES', NULL_VAR,
1865: l_crh_rec_new.bank_charge_account_ccid);
1866: l_crh_rec_new.posting_control_id := -3;
1867: l_crh_rec_new.reversal_posting_control_id := NULL;

Line 1892: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,

1888: */
1889: l_dist_rec.source_id := l_crh_rec_new.cash_receipt_history_id;
1890: l_dist_rec.source_table := 'CRH';
1891: l_dist_rec.source_type := 'SHORT_TERM_DEBT';
1892: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,
1893: 'CRH', 'SHORT_TERM_DEBT', NULL_VAR,
1894: l_dist_rec.code_combination_id);
1895: -- Fix 1119979, assign acctd_amount_dr and acctd_amount_cr in above condn
1896: IF ( l_receipt_amt < 0 )

Line 1942: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,

1938: */
1939: l_dist_rec.source_id := l_crh_rec_new.cash_receipt_history_id;
1940: l_dist_rec.source_table := 'CRH';
1941: l_dist_rec.source_type := 'FACTOR';
1942: arp_cr_util.get_dist_ccid( l_crh_rec_old.cash_receipt_id,
1943: 'CRH', 'FACTOR', NULL_VAR,
1944: l_dist_rec.code_combination_id);
1945: -- Fix 1119979, assign acctd_amount_dr and acctd_amount_cr in above condn
1946: IF ( l_receipt_amt < 0 )