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 146: -- update the ar_cash_receipt_history_table with a new record for

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

Line 249: l_batch_id ar_cash_receipt_history.batch_id%TYPE;

245: l_cr_rec ar_cash_receipts%ROWTYPE;
246: l_acctd_amount NUMBER;
247: l_receipt_clearing_ccid
248: ar_receipt_method_accounts.receipt_clearing_ccid%TYPE;
249: l_batch_id ar_cash_receipt_history.batch_id%TYPE;
250: l_crh_id_rev
251: ar_cash_receipt_history.cash_receipt_history_id%TYPE;
252: l_dummy NUMBER; -- dummy variable
253:

Line 251: ar_cash_receipt_history.cash_receipt_history_id%TYPE;

247: l_receipt_clearing_ccid
248: ar_receipt_method_accounts.receipt_clearing_ccid%TYPE;
249: l_batch_id ar_cash_receipt_history.batch_id%TYPE;
250: l_crh_id_rev
251: ar_cash_receipt_history.cash_receipt_history_id%TYPE;
252: l_dummy NUMBER; -- dummy variable
253:
254: BEGIN
255:

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

301: arp_standard.debug('confirm: ' || '-- Receipt Amount: ' || to_char(l_cr_rec.amount));
302: arp_standard.debug('confirm: ' || '-- Acctd Amount: ' || to_char(l_acctd_amount));
303: END IF;
304:
305: -- update the ar_cash_receipt_history_table with a new record for
306: -- this receipt. This call will also create a new ar_distributions
307: -- record to reverse the 'confirm' record.
308:
309: update_cr_history_unconfirm( l_cr_rec,

Line 397: FROM AR_CASH_RECEIPT_HISTORY

393:
394: DECLARE
395: CURSOR confirmCursor (auto_batch_id IN NUMBER) IS
396: SELECT cash_receipt_id
397: FROM AR_CASH_RECEIPT_HISTORY
398: WHERE current_record_flag = 'Y'
399: AND status='APPROVED'
400: AND batch_id = auto_batch_id;
401:

Line 497: AR_CASH_RECEIPT_HISTORY crh

493:
494: SELECT crh.status, cr.confirmed_flag
495: INTO l_status, l_confirmed_flag
496: FROM AR_CASH_RECEIPTS cr,
497: AR_CASH_RECEIPT_HISTORY crh
498: WHERE cr.cash_receipt_id = crh.cash_receipt_id
499: AND cr.cash_receipt_id = p_cr_id;
500:
501: IF (l_status = 'APPROVED') and (l_confirmed_flag = 'N') THEN

Line 1069: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;

1065: p_receipt_clearing_ccid IN
1066: ar_receipt_method_accounts.receipt_clearing_ccid%TYPE
1067: ) IS
1068: --
1069: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1070: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1071: l_crh_id_new ar_cash_receipts.cash_receipt_id%TYPE;
1072: l_dist_rec ar_distributions%ROWTYPE;
1073: l_dist_line_id ar_distributions.line_id%TYPE;

Line 1070: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;

1066: ar_receipt_method_accounts.receipt_clearing_ccid%TYPE
1067: ) IS
1068: --
1069: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1070: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1071: l_crh_id_new ar_cash_receipts.cash_receipt_id%TYPE;
1072: l_dist_rec ar_distributions%ROWTYPE;
1073: l_dist_line_id ar_distributions.line_id%TYPE;
1074:

Line 1080: -- fetch current record from ar_cash_receipt_history

1076: BEGIN
1077:
1078: arp_standard.debug('arp_confirmation.update_cr_history_confirm()+');
1079:
1080: -- fetch current record from ar_cash_receipt_history
1081:
1082: arp_cr_history_pkg.fetch_f_crid(p_cr_rec.cash_receipt_id, l_crh_rec_old);
1083:
1084: arp_standard.debug('-- current history record fetched. crh_id = '||

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

1750: p_cr_rec IN ar_cash_receipts%ROWTYPE,
1751: p_confirm_gl_date IN DATE,
1752: p_confirm_date IN DATE,
1753: p_acctd_amount IN NUMBER,
1754: p_batch_id OUT NOCOPY ar_cash_receipt_history.batch_id%TYPE,
1755: p_crh_id_rev OUT NOCOPY
1756: ar_cash_receipt_history.cash_receipt_history_id%TYPE
1757: ) IS
1758:

Line 1756: ar_cash_receipt_history.cash_receipt_history_id%TYPE

1752: p_confirm_date IN DATE,
1753: p_acctd_amount IN NUMBER,
1754: p_batch_id OUT NOCOPY ar_cash_receipt_history.batch_id%TYPE,
1755: p_crh_id_rev OUT NOCOPY
1756: ar_cash_receipt_history.cash_receipt_history_id%TYPE
1757: ) IS
1758:
1759: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1760: l_crh_rec_prev_stat ar_cash_receipt_history%ROWTYPE;

Line 1759: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;

1755: p_crh_id_rev OUT NOCOPY
1756: ar_cash_receipt_history.cash_receipt_history_id%TYPE
1757: ) IS
1758:
1759: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1760: l_crh_rec_prev_stat ar_cash_receipt_history%ROWTYPE;
1761: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1762: l_dist_rec ar_distributions%ROWTYPE;
1763: l_dist_line_id ar_distributions.line_id%TYPE;

Line 1760: l_crh_rec_prev_stat ar_cash_receipt_history%ROWTYPE;

1756: ar_cash_receipt_history.cash_receipt_history_id%TYPE
1757: ) IS
1758:
1759: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1760: l_crh_rec_prev_stat ar_cash_receipt_history%ROWTYPE;
1761: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1762: l_dist_rec ar_distributions%ROWTYPE;
1763: l_dist_line_id ar_distributions.line_id%TYPE;
1764: l_batch_id ar_cash_receipt_history.batch_id%TYPE;

Line 1761: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;

1757: ) IS
1758:
1759: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1760: l_crh_rec_prev_stat ar_cash_receipt_history%ROWTYPE;
1761: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1762: l_dist_rec ar_distributions%ROWTYPE;
1763: l_dist_line_id ar_distributions.line_id%TYPE;
1764: l_batch_id ar_cash_receipt_history.batch_id%TYPE;
1765: l_crh_id_rev ar_cash_receipt_history.cash_receipt_history_id%TYPE;

Line 1764: l_batch_id ar_cash_receipt_history.batch_id%TYPE;

1760: l_crh_rec_prev_stat ar_cash_receipt_history%ROWTYPE;
1761: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1762: l_dist_rec ar_distributions%ROWTYPE;
1763: l_dist_line_id ar_distributions.line_id%TYPE;
1764: l_batch_id ar_cash_receipt_history.batch_id%TYPE;
1765: l_crh_id_rev ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1766: l_crh_id_new ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1767:
1768: BEGIN

Line 1765: l_crh_id_rev ar_cash_receipt_history.cash_receipt_history_id%TYPE;

1761: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1762: l_dist_rec ar_distributions%ROWTYPE;
1763: l_dist_line_id ar_distributions.line_id%TYPE;
1764: l_batch_id ar_cash_receipt_history.batch_id%TYPE;
1765: l_crh_id_rev ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1766: l_crh_id_new ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1767:
1768: BEGIN
1769:

Line 1766: l_crh_id_new ar_cash_receipt_history.cash_receipt_history_id%TYPE;

1762: l_dist_rec ar_distributions%ROWTYPE;
1763: l_dist_line_id ar_distributions.line_id%TYPE;
1764: l_batch_id ar_cash_receipt_history.batch_id%TYPE;
1765: l_crh_id_rev ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1766: l_crh_id_new ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1767:
1768: BEGIN
1769:
1770: arp_standard.debug('arp_confirmation.update_cr_history_unconfirm()+');

Line 1772: -- fetch current record from ar_cash_receipt_history

1768: BEGIN
1769:
1770: arp_standard.debug('arp_confirmation.update_cr_history_unconfirm()+');
1771:
1772: -- fetch current record from ar_cash_receipt_history
1773:
1774: arp_cr_history_pkg.fetch_f_crid(p_cr_rec.cash_receipt_id, l_crh_rec_old);
1775:
1776: -- update columns in existing record

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

1781: l_crh_rec_old.current_record_flag := NULL;
1782: l_crh_rec_old.first_posted_record_flag := 'N';
1783: l_crh_rec_old.current_record_flag := NULL;
1784:
1785: -- Fetch previous state record from ar_cash_receipt_history:
1786: -- The current record is not necessarily the one created by
1787: -- the confirm operation, because rate adjustments could have
1788: -- occured between confirmation and unconfirmation. In order
1789: -- to get the correct batch_id, we have to get it from the record