eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_CASHBOOK dependencies on ARP_CR_HISTORY_PKG

Line 216: arp_cr_history_pkg.fetch_f_crid( p_cr_id, l_crh_rec_old );

212: -- Validate the amt_clr +bank_charge = receipt amt
213: -- receipt amt * rate = accnt amount
214:
215: -- Fetch the history record
216: arp_cr_history_pkg.fetch_f_crid( p_cr_id, l_crh_rec_old );
217:
218: --Bug8866537
219: l_exchange_rate_type := NVL(p_exchange_rate_type,l_crh_rec_old.exchange_rate_type);
220: l_exchange_date := trunc(NVL(p_exchange_date,SYSDATE));

Line 531: arp_cr_history_pkg.insert_p( l_crh_rec_new, l_crh_rec_new.cash_receipt_history_id );

527: l_crh_rec_new.prv_stat_cash_receipt_hist_id := l_crh_rec_old.cash_receipt_history_id;
528: END IF;
529: l_crh_rec_new.created_from := substrb(p_module_name||'ARP_CASHBOOK.CLEAR',1,30);
530: l_crh_rec_new.reversal_created_from := NULL;
531: arp_cr_history_pkg.insert_p( l_crh_rec_new, l_crh_rec_new.cash_receipt_history_id );
532:
533: -- Update the old history record
534: l_crh_rec_old.current_record_flag := NULL;
535: l_crh_rec_old.reversal_gl_date := p_gl_date;

Line 539: arp_cr_history_pkg.update_p( l_crh_rec_old );

535: l_crh_rec_old.reversal_gl_date := p_gl_date;
536: l_crh_rec_old.reversal_cash_receipt_hist_id := l_crh_rec_new.cash_receipt_history_id;
537: l_crh_rec_old.reversal_posting_control_id := -3;
538: l_crh_rec_old.reversal_created_from := substrb(p_module_name||'ARP_CASHBOOK.CLEAR',1,30);
539: arp_cr_history_pkg.update_p( l_crh_rec_old );
540:
541: --Bug#2750340
542: --{BUG#5051143 - the cash book call is document based not request based
543: -- l_event_rec.xla_req_id := arp_global.request_id;

Line 1099: arp_cr_history_pkg.fetch_f_crid( p_cr_id, l_crh_rec_old );

1095:
1096: -- Validate the GL Date is in open or future period
1097:
1098: -- Fetch the history record
1099: arp_cr_history_pkg.fetch_f_crid( p_cr_id, l_crh_rec_old );
1100:
1101: -- Check if this receipt has already been reversed or unclear, then
1102: -- fail and give an error message
1103: IF ( l_crh_rec_old.status = 'REVERSED')

Line 1122: arp_cr_history_pkg.fetch_p( l_crh_rec_old.prv_stat_cash_receipt_hist_id, l_crh_rec_prv_stat );

1118: IF ( l_crh_rec_old.prv_stat_cash_receipt_hist_id IS NOT NULL )
1119: THEN
1120:
1121: -- Fetch the history record of the prv status
1122: arp_cr_history_pkg.fetch_p( l_crh_rec_old.prv_stat_cash_receipt_hist_id, l_crh_rec_prv_stat );
1123:
1124: /*Bug 9761480 Fetch the CLEARED row that is reversal of the previous status REMITTED row */
1125: arp_cr_history_pkg.fetch_p( l_crh_rec_prv_stat.reversal_cash_receipt_hist_id, l_crh_rec_prv_stat_cash );
1126:

Line 1125: arp_cr_history_pkg.fetch_p( l_crh_rec_prv_stat.reversal_cash_receipt_hist_id, l_crh_rec_prv_stat_cash );

1121: -- Fetch the history record of the prv status
1122: arp_cr_history_pkg.fetch_p( l_crh_rec_old.prv_stat_cash_receipt_hist_id, l_crh_rec_prv_stat );
1123:
1124: /*Bug 9761480 Fetch the CLEARED row that is reversal of the previous status REMITTED row */
1125: arp_cr_history_pkg.fetch_p( l_crh_rec_prv_stat.reversal_cash_receipt_hist_id, l_crh_rec_prv_stat_cash );
1126:
1127: -- Fetch the cash receipt record
1128: l_cr_rec.cash_receipt_id := p_cr_id;
1129: arp_cash_receipts_pkg.fetch_p( l_cr_rec );

Line 1271: arp_cr_history_pkg.insert_p( l_crh_rec_new, l_crh_rec_new.cash_receipt_history_id );

1267: l_crh_rec_new.reversal_gl_posted_date := NULL;
1268: l_crh_rec_new.prv_stat_cash_receipt_hist_id := l_crh_rec_prv_stat.prv_stat_cash_receipt_hist_id;
1269: l_crh_rec_new.created_from := substrb(p_module_name||'ARP_CASHBOOK.UNCLEAR',1,30);
1270: l_crh_rec_new.reversal_created_from := NULL;
1271: arp_cr_history_pkg.insert_p( l_crh_rec_new, l_crh_rec_new.cash_receipt_history_id );
1272:
1273: /* Bug 9761480 : If rate adjustment is reversed, then update those CRH records also*/
1274: IF l_new_crh_id_fr_radj IS NOT NULL THEN
1275: -- Update the old history record

Line 1281: arp_cr_history_pkg.update_p( l_crh_rec_old );

1277: l_crh_rec_old.reversal_gl_date := p_gl_date;
1278: l_crh_rec_old.reversal_cash_receipt_hist_id := l_new_crh_id_fr_radj;
1279: l_crh_rec_old.reversal_posting_control_id := -3;
1280: l_crh_rec_old.reversal_created_from := substrb(p_module_name||'ARP_CASHBOOK.UNCLEAR',1,30);
1281: arp_cr_history_pkg.update_p( l_crh_rec_old );
1282:
1283: /* Fetch newly created Rate Adjustment records */
1284: arp_cr_history_pkg.fetch_p( l_new_crh_id_fr_radj, l_crh_rec_fr_radj );
1285:

Line 1284: arp_cr_history_pkg.fetch_p( l_new_crh_id_fr_radj, l_crh_rec_fr_radj );

1280: l_crh_rec_old.reversal_created_from := substrb(p_module_name||'ARP_CASHBOOK.UNCLEAR',1,30);
1281: arp_cr_history_pkg.update_p( l_crh_rec_old );
1282:
1283: /* Fetch newly created Rate Adjustment records */
1284: arp_cr_history_pkg.fetch_p( l_new_crh_id_fr_radj, l_crh_rec_fr_radj );
1285:
1286: l_crh_rec_fr_radj.current_record_flag := NULL;
1287: l_crh_rec_fr_radj.reversal_gl_date := p_gl_date;
1288: l_crh_rec_fr_radj.reversal_cash_receipt_hist_id := l_crh_rec_new.cash_receipt_history_id;

Line 1291: arp_cr_history_pkg.update_p( l_crh_rec_fr_radj );

1287: l_crh_rec_fr_radj.reversal_gl_date := p_gl_date;
1288: l_crh_rec_fr_radj.reversal_cash_receipt_hist_id := l_crh_rec_new.cash_receipt_history_id;
1289: l_crh_rec_fr_radj.reversal_posting_control_id := -3;
1290: l_crh_rec_fr_radj.reversal_created_from := substrb(p_module_name||'ARP_CASHBOOK.UNCLEAR',1,30);
1291: arp_cr_history_pkg.update_p( l_crh_rec_fr_radj );
1292:
1293: ELSE
1294: l_crh_rec_old.current_record_flag := NULL;
1295: l_crh_rec_old.reversal_gl_date := p_gl_date;

Line 1299: arp_cr_history_pkg.update_p( l_crh_rec_old );

1295: l_crh_rec_old.reversal_gl_date := p_gl_date;
1296: l_crh_rec_old.reversal_cash_receipt_hist_id := l_crh_rec_new.cash_receipt_history_id;
1297: l_crh_rec_old.reversal_posting_control_id := -3;
1298: l_crh_rec_old.reversal_created_from := substrb(p_module_name||'ARP_CASHBOOK.UNCLEAR',1,30);
1299: arp_cr_history_pkg.update_p( l_crh_rec_old );
1300:
1301: END IF;
1302:
1303: --BUG#5569338

Line 1549: arp_cr_history_pkg.fetch_f_crid( p_cr_id, l_crh_rec_old );

1545: l_cr_rec.cash_receipt_id := p_cr_id;
1546: arp_cash_receipts_pkg.fetch_p(l_cr_rec);
1547:
1548: -- Fetch the history record
1549: arp_cr_history_pkg.fetch_f_crid( p_cr_id, l_crh_rec_old );
1550:
1551: -- 11.5 VAT changes:
1552: l_dist_rec.currency_code := l_cr_rec.currency_code;
1553: l_dist_rec.currency_conversion_rate := l_crh_rec_old.exchange_rate;

Line 1603: arp_cr_history_pkg.insert_p( l_crh_rec_new, l_crh_rec_new.cash_receipt_history_id );

1599: l_crh_rec_new.reversal_gl_posted_date := NULL;
1600: l_crh_rec_new.prv_stat_cash_receipt_hist_id := l_crh_rec_old.cash_receipt_history_id;
1601: l_crh_rec_new.created_from := substrb(p_module_name||'ARP_CASHBOOK.RISK_ELIMINATE',1,30);
1602: l_crh_rec_new.reversal_created_from := NULL;
1603: arp_cr_history_pkg.insert_p( l_crh_rec_new, l_crh_rec_new.cash_receipt_history_id );
1604:
1605: -- Update the old history record
1606: l_crh_rec_old.current_record_flag := NULL;
1607: l_crh_rec_old.reversal_gl_date := p_gl_date;

Line 1611: arp_cr_history_pkg.update_p( l_crh_rec_old );

1607: l_crh_rec_old.reversal_gl_date := p_gl_date;
1608: l_crh_rec_old.reversal_cash_receipt_hist_id := l_crh_rec_new.cash_receipt_history_id;
1609: l_crh_rec_old.reversal_posting_control_id := -3;
1610: l_crh_rec_old.reversal_created_from := substrb(p_module_name||'ARP_CASHBOOK.RISK_ELIMINATE',1,30);
1611: arp_cr_history_pkg.update_p( l_crh_rec_old );
1612:
1613: /* Bug 6494186 */
1614: l_risk_event_rec.xla_from_doc_id := p_cr_id;
1615: l_risk_event_rec.xla_to_doc_id := p_cr_id;

Line 1818: arp_cr_history_pkg.fetch_f_crid( p_cr_id, l_crh_rec_old );

1814: l_cr_rec.cash_receipt_id := p_cr_id;
1815: arp_cash_receipts_pkg.fetch_p(l_cr_rec);
1816:
1817: -- Fetch the history record
1818: arp_cr_history_pkg.fetch_f_crid( p_cr_id, l_crh_rec_old );
1819:
1820: -- 11.5 VAT changes:
1821: l_dist_rec.currency_code := l_cr_rec.currency_code;
1822: l_dist_rec.currency_conversion_rate := l_crh_rec_old.exchange_rate;

Line 1873: arp_cr_history_pkg.insert_p( l_crh_rec_new, l_crh_rec_new.cash_receipt_history_id );

1869: l_crh_rec_new.reversal_gl_posted_date := NULL;
1870: l_crh_rec_new.prv_stat_cash_receipt_hist_id := l_crh_rec_old.cash_receipt_history_id;
1871: l_crh_rec_new.created_from := substrb(p_module_name||'ARP_CASHBOOK.UNDO_RISK_ELIMINATE',1,30);
1872: l_crh_rec_new.reversal_created_from := NULL;
1873: arp_cr_history_pkg.insert_p( l_crh_rec_new, l_crh_rec_new.cash_receipt_history_id );
1874:
1875: -- Update the old history record
1876: l_crh_rec_old.current_record_flag := NULL;
1877: l_crh_rec_old.reversal_gl_date := p_gl_date;

Line 1881: arp_cr_history_pkg.update_p( l_crh_rec_old );

1877: l_crh_rec_old.reversal_gl_date := p_gl_date;
1878: l_crh_rec_old.reversal_cash_receipt_hist_id := l_crh_rec_new.cash_receipt_history_id;
1879: l_crh_rec_old.reversal_posting_control_id := -3;
1880: l_crh_rec_old.reversal_created_from := substrb(p_module_name||'ARP_CASHBOOK.UNDO_RISK_ELIMINATE',1,30);
1881: arp_cr_history_pkg.update_p( l_crh_rec_old );
1882:
1883: -- Insert the short_term_debt account ar_distributions record
1884: /* skoukunt: comment to Fix bug 1198295
1885: IF ( l_receipt_amt <>0 ) OR