[Home] [Help]
88: -- Validate the amt_clr +bank_charge = receipt amt
89: -- receipt amt * rate = accnt amount
90:
91: -- Fetch the history record
92: arp_cr_history_pkg.fetch_f_crid( p_cr_id, l_crh_rec_old );
93:
94: -- check if receipt is reversed. If yes, raise exception.
95: -- (bug 376817)
96:
328: l_crh_rec_new.prv_stat_cash_receipt_hist_id := l_crh_rec_old.cash_receipt_history_id;
329: END IF;
330: l_crh_rec_new.created_from := substrb(p_module_name||'ARP_CASHBOOK.CLEAR',1,30);
331: l_crh_rec_new.reversal_created_from := NULL;
332: arp_cr_history_pkg.insert_p( l_crh_rec_new, l_crh_rec_new.cash_receipt_history_id );
333:
334: -- Update the old history record
335: l_crh_rec_old.current_record_flag := NULL;
336: l_crh_rec_old.reversal_gl_date := p_gl_date;
336: l_crh_rec_old.reversal_gl_date := p_gl_date;
337: l_crh_rec_old.reversal_cash_receipt_hist_id := l_crh_rec_new.cash_receipt_history_id;
338: l_crh_rec_old.reversal_posting_control_id := -3;
339: l_crh_rec_old.reversal_created_from := substrb(p_module_name||'ARP_CASHBOOK.CLEAR',1,30);
340: arp_cr_history_pkg.update_p( l_crh_rec_old );
341:
342: --Bug#2750340
343: --{BUG#5051143 - the cash book call is document based not request based
344: -- l_event_rec.xla_req_id := arp_global.request_id;
817:
818: -- Validate the GL Date is in open or future period
819:
820: -- Fetch the history record
821: arp_cr_history_pkg.fetch_f_crid( p_cr_id, l_crh_rec_old );
822:
823: -- Check if this receipt has already been reversed or unclear, then
824: -- fail and give an error message
825: IF ( l_crh_rec_old.status = 'REVERSED')
840: IF ( l_crh_rec_old.prv_stat_cash_receipt_hist_id IS NOT NULL )
841: THEN
842:
843: -- Fetch the history record of the prv status
844: arp_cr_history_pkg.fetch_p( l_crh_rec_old.prv_stat_cash_receipt_hist_id, l_crh_rec_prv_stat );
845:
846: -- Fetch the cash receipt record
847: l_cr_rec.cash_receipt_id := p_cr_id;
848: arp_cash_receipts_pkg.fetch_p( l_cr_rec );
934: l_crh_rec_new.reversal_gl_posted_date := NULL;
935: l_crh_rec_new.prv_stat_cash_receipt_hist_id := l_crh_rec_prv_stat.prv_stat_cash_receipt_hist_id;
936: l_crh_rec_new.created_from := substrb(p_module_name||'ARP_CASHBOOK.UNCLEAR',1,30);
937: l_crh_rec_new.reversal_created_from := NULL;
938: arp_cr_history_pkg.insert_p( l_crh_rec_new, l_crh_rec_new.cash_receipt_history_id );
939:
940: -- Update the old history record
941: l_crh_rec_old.current_record_flag := NULL;
942: l_crh_rec_old.reversal_gl_date := p_gl_date;
942: l_crh_rec_old.reversal_gl_date := p_gl_date;
943: l_crh_rec_old.reversal_cash_receipt_hist_id := l_crh_rec_new.cash_receipt_history_id;
944: l_crh_rec_old.reversal_posting_control_id := -3;
945: l_crh_rec_old.reversal_created_from := substrb(p_module_name||'ARP_CASHBOOK.UNCLEAR',1,30);
946: arp_cr_history_pkg.update_p( l_crh_rec_old );
947:
948: --BUG#5569338
949: l_xla_ev_rec.xla_from_doc_id := p_cr_id;
950: l_xla_ev_rec.xla_to_doc_id := p_cr_id;
1190: l_cr_rec.cash_receipt_id := p_cr_id;
1191: arp_cash_receipts_pkg.fetch_p(l_cr_rec);
1192:
1193: -- Fetch the history record
1194: arp_cr_history_pkg.fetch_f_crid( p_cr_id, l_crh_rec_old );
1195:
1196: -- 11.5 VAT changes:
1197: l_dist_rec.currency_code := l_cr_rec.currency_code;
1198: l_dist_rec.currency_conversion_rate := l_crh_rec_old.exchange_rate;
1244: l_crh_rec_new.reversal_gl_posted_date := NULL;
1245: l_crh_rec_new.prv_stat_cash_receipt_hist_id := l_crh_rec_old.cash_receipt_history_id;
1246: l_crh_rec_new.created_from := substrb(p_module_name||'ARP_CASHBOOK.RISK_ELIMINATE',1,30);
1247: l_crh_rec_new.reversal_created_from := NULL;
1248: arp_cr_history_pkg.insert_p( l_crh_rec_new, l_crh_rec_new.cash_receipt_history_id );
1249:
1250: -- Update the old history record
1251: l_crh_rec_old.current_record_flag := NULL;
1252: l_crh_rec_old.reversal_gl_date := p_gl_date;
1252: l_crh_rec_old.reversal_gl_date := p_gl_date;
1253: l_crh_rec_old.reversal_cash_receipt_hist_id := l_crh_rec_new.cash_receipt_history_id;
1254: l_crh_rec_old.reversal_posting_control_id := -3;
1255: l_crh_rec_old.reversal_created_from := substrb(p_module_name||'ARP_CASHBOOK.RISK_ELIMINATE',1,30);
1256: arp_cr_history_pkg.update_p( l_crh_rec_old );
1257:
1258: /* Bug 6494186 */
1259: l_risk_event_rec.xla_from_doc_id := p_cr_id;
1260: l_risk_event_rec.xla_to_doc_id := p_cr_id;
1405: l_cr_rec.cash_receipt_id := p_cr_id;
1406: arp_cash_receipts_pkg.fetch_p(l_cr_rec);
1407:
1408: -- Fetch the history record
1409: arp_cr_history_pkg.fetch_f_crid( p_cr_id, l_crh_rec_old );
1410:
1411: -- 11.5 VAT changes:
1412: l_dist_rec.currency_code := l_cr_rec.currency_code;
1413: l_dist_rec.currency_conversion_rate := l_crh_rec_old.exchange_rate;
1460: l_crh_rec_new.reversal_gl_posted_date := NULL;
1461: l_crh_rec_new.prv_stat_cash_receipt_hist_id := l_crh_rec_old.cash_receipt_history_id;
1462: l_crh_rec_new.created_from := substrb(p_module_name||'ARP_CASHBOOK.UNDO_RISK_ELIMINATE',1,30);
1463: l_crh_rec_new.reversal_created_from := NULL;
1464: arp_cr_history_pkg.insert_p( l_crh_rec_new, l_crh_rec_new.cash_receipt_history_id );
1465:
1466: -- Update the old history record
1467: l_crh_rec_old.current_record_flag := NULL;
1468: l_crh_rec_old.reversal_gl_date := p_gl_date;
1468: l_crh_rec_old.reversal_gl_date := p_gl_date;
1469: l_crh_rec_old.reversal_cash_receipt_hist_id := l_crh_rec_new.cash_receipt_history_id;
1470: l_crh_rec_old.reversal_posting_control_id := -3;
1471: l_crh_rec_old.reversal_created_from := substrb(p_module_name||'ARP_CASHBOOK.UNDO_RISK_ELIMINATE',1,30);
1472: arp_cr_history_pkg.update_p( l_crh_rec_old );
1473:
1474: -- Insert the short_term_debt account ar_distributions record
1475: /* skoukunt: comment to Fix bug 1198295
1476: IF ( l_receipt_amt <>0 ) OR