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_CONFIRMATION dependencies on AR_CASH_RECEIPT_HISTORY

Line 145: -- update the ar_cash_receipt_history_table with a new record for

141: arp_standard.debug('confirm: ' || '-- Receipt Amount: ' || to_char(l_cr_rec.amount));
142: arp_standard.debug('confirm: ' || '-- Acctd Amount: ' || to_char(l_acctd_amount));
143: END IF;
144:
145: -- update the ar_cash_receipt_history_table with a new record for
146: -- this receipt. This call will also create a new ar_distributions
147: -- record.
148:
149: update_cr_history_confirm( l_cr_rec,

Line 232: l_batch_id ar_cash_receipt_history.batch_id%TYPE;

228: l_cr_rec ar_cash_receipts%ROWTYPE;
229: l_acctd_amount NUMBER;
230: l_receipt_clearing_ccid
231: ar_receipt_method_accounts.receipt_clearing_ccid%TYPE;
232: l_batch_id ar_cash_receipt_history.batch_id%TYPE;
233: l_crh_id_rev
234: ar_cash_receipt_history.cash_receipt_history_id%TYPE;
235: l_dummy NUMBER; -- dummy variable
236:

Line 234: ar_cash_receipt_history.cash_receipt_history_id%TYPE;

230: l_receipt_clearing_ccid
231: ar_receipt_method_accounts.receipt_clearing_ccid%TYPE;
232: l_batch_id ar_cash_receipt_history.batch_id%TYPE;
233: l_crh_id_rev
234: ar_cash_receipt_history.cash_receipt_history_id%TYPE;
235: l_dummy NUMBER; -- dummy variable
236:
237: BEGIN
238:

Line 288: -- update the ar_cash_receipt_history_table with a new record for

284: arp_standard.debug('confirm: ' || '-- Receipt Amount: ' || to_char(l_cr_rec.amount));
285: arp_standard.debug('confirm: ' || '-- Acctd Amount: ' || to_char(l_acctd_amount));
286: END IF;
287:
288: -- update the ar_cash_receipt_history_table with a new record for
289: -- this receipt. This call will also create a new ar_distributions
290: -- record to reverse the 'confirm' record.
291:
292: update_cr_history_unconfirm( l_cr_rec,

Line 380: FROM AR_CASH_RECEIPT_HISTORY

376:
377: DECLARE
378: CURSOR confirmCursor (auto_batch_id IN NUMBER) IS
379: SELECT cash_receipt_id
380: FROM AR_CASH_RECEIPT_HISTORY
381: WHERE current_record_flag = 'Y'
382: AND status='APPROVED'
383: AND batch_id = auto_batch_id;
384:

Line 480: AR_CASH_RECEIPT_HISTORY crh

476:
477: SELECT crh.status, cr.confirmed_flag
478: INTO l_status, l_confirmed_flag
479: FROM AR_CASH_RECEIPTS cr,
480: AR_CASH_RECEIPT_HISTORY crh
481: WHERE cr.cash_receipt_id = crh.cash_receipt_id
482: AND cr.cash_receipt_id = p_cr_id;
483:
484: IF (l_status = 'APPROVED') and (l_confirmed_flag = 'N') THEN

Line 1052: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;

1048: p_receipt_clearing_ccid IN
1049: ar_receipt_method_accounts.receipt_clearing_ccid%TYPE
1050: ) IS
1051: --
1052: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1053: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1054: l_crh_id_new ar_cash_receipts.cash_receipt_id%TYPE;
1055: l_dist_rec ar_distributions%ROWTYPE;
1056: l_dist_line_id ar_distributions.line_id%TYPE;

Line 1053: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;

1049: ar_receipt_method_accounts.receipt_clearing_ccid%TYPE
1050: ) IS
1051: --
1052: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1053: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1054: l_crh_id_new ar_cash_receipts.cash_receipt_id%TYPE;
1055: l_dist_rec ar_distributions%ROWTYPE;
1056: l_dist_line_id ar_distributions.line_id%TYPE;
1057:

Line 1063: -- fetch current record from ar_cash_receipt_history

1059: BEGIN
1060:
1061: arp_standard.debug('arp_confirmation.update_cr_history_confirm()+');
1062:
1063: -- fetch current record from ar_cash_receipt_history
1064:
1065: arp_cr_history_pkg.fetch_f_crid(p_cr_rec.cash_receipt_id, l_crh_rec_old);
1066:
1067: arp_standard.debug('-- current history record fetched. crh_id = '||

Line 1737: p_batch_id OUT NOCOPY ar_cash_receipt_history.batch_id%TYPE,

1733: p_cr_rec IN ar_cash_receipts%ROWTYPE,
1734: p_confirm_gl_date IN DATE,
1735: p_confirm_date IN DATE,
1736: p_acctd_amount IN NUMBER,
1737: p_batch_id OUT NOCOPY ar_cash_receipt_history.batch_id%TYPE,
1738: p_crh_id_rev OUT NOCOPY
1739: ar_cash_receipt_history.cash_receipt_history_id%TYPE
1740: ) IS
1741:

Line 1739: ar_cash_receipt_history.cash_receipt_history_id%TYPE

1735: p_confirm_date IN DATE,
1736: p_acctd_amount IN NUMBER,
1737: p_batch_id OUT NOCOPY ar_cash_receipt_history.batch_id%TYPE,
1738: p_crh_id_rev OUT NOCOPY
1739: ar_cash_receipt_history.cash_receipt_history_id%TYPE
1740: ) IS
1741:
1742: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1743: l_crh_rec_prev_stat ar_cash_receipt_history%ROWTYPE;

Line 1742: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;

1738: p_crh_id_rev OUT NOCOPY
1739: ar_cash_receipt_history.cash_receipt_history_id%TYPE
1740: ) IS
1741:
1742: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1743: l_crh_rec_prev_stat ar_cash_receipt_history%ROWTYPE;
1744: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1745: l_dist_rec ar_distributions%ROWTYPE;
1746: l_dist_line_id ar_distributions.line_id%TYPE;

Line 1743: l_crh_rec_prev_stat ar_cash_receipt_history%ROWTYPE;

1739: ar_cash_receipt_history.cash_receipt_history_id%TYPE
1740: ) IS
1741:
1742: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1743: l_crh_rec_prev_stat ar_cash_receipt_history%ROWTYPE;
1744: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1745: l_dist_rec ar_distributions%ROWTYPE;
1746: l_dist_line_id ar_distributions.line_id%TYPE;
1747: l_batch_id ar_cash_receipt_history.batch_id%TYPE;

Line 1744: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;

1740: ) IS
1741:
1742: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1743: l_crh_rec_prev_stat ar_cash_receipt_history%ROWTYPE;
1744: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1745: l_dist_rec ar_distributions%ROWTYPE;
1746: l_dist_line_id ar_distributions.line_id%TYPE;
1747: l_batch_id ar_cash_receipt_history.batch_id%TYPE;
1748: l_crh_id_rev ar_cash_receipt_history.cash_receipt_history_id%TYPE;

Line 1747: l_batch_id ar_cash_receipt_history.batch_id%TYPE;

1743: l_crh_rec_prev_stat ar_cash_receipt_history%ROWTYPE;
1744: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1745: l_dist_rec ar_distributions%ROWTYPE;
1746: l_dist_line_id ar_distributions.line_id%TYPE;
1747: l_batch_id ar_cash_receipt_history.batch_id%TYPE;
1748: l_crh_id_rev ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1749: l_crh_id_new ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1750:
1751: BEGIN

Line 1748: l_crh_id_rev ar_cash_receipt_history.cash_receipt_history_id%TYPE;

1744: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1745: l_dist_rec ar_distributions%ROWTYPE;
1746: l_dist_line_id ar_distributions.line_id%TYPE;
1747: l_batch_id ar_cash_receipt_history.batch_id%TYPE;
1748: l_crh_id_rev ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1749: l_crh_id_new ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1750:
1751: BEGIN
1752:

Line 1749: l_crh_id_new ar_cash_receipt_history.cash_receipt_history_id%TYPE;

1745: l_dist_rec ar_distributions%ROWTYPE;
1746: l_dist_line_id ar_distributions.line_id%TYPE;
1747: l_batch_id ar_cash_receipt_history.batch_id%TYPE;
1748: l_crh_id_rev ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1749: l_crh_id_new ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1750:
1751: BEGIN
1752:
1753: arp_standard.debug('arp_confirmation.update_cr_history_unconfirm()+');

Line 1755: -- fetch current record from ar_cash_receipt_history

1751: BEGIN
1752:
1753: arp_standard.debug('arp_confirmation.update_cr_history_unconfirm()+');
1754:
1755: -- fetch current record from ar_cash_receipt_history
1756:
1757: arp_cr_history_pkg.fetch_f_crid(p_cr_rec.cash_receipt_id, l_crh_rec_old);
1758:
1759: -- update columns in existing record

Line 1768: -- Fetch previous state record from ar_cash_receipt_history:

1764: l_crh_rec_old.current_record_flag := NULL;
1765: l_crh_rec_old.first_posted_record_flag := 'N';
1766: l_crh_rec_old.current_record_flag := NULL;
1767:
1768: -- Fetch previous state record from ar_cash_receipt_history:
1769: -- The current record is not necessarily the one created by
1770: -- the confirm operation, because rate adjustments could have
1771: -- occured between confirmation and unconfirmation. In order
1772: -- to get the correct batch_id, we have to get it from the record