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_RECEIPTS

Line 61: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

57:
58: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
59:
60: PROCEDURE confirm(
61: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
62: p_confirm_gl_date IN DATE,
63: p_confirm_date IN DATE,
64: p_module_name IN VARCHAR2,
65: p_module_version IN VARCHAR2 ) IS

Line 73: l_cr_rec ar_cash_receipts%ROWTYPE;

69: l_acctd_amount NUMBER;
70: l_receipt_clearing_ccid
71: ar_receipt_method_accounts.receipt_clearing_ccid%TYPE;
72: l_dummy NUMBER;
73: l_cr_rec ar_cash_receipts%ROWTYPE;
74: l_xla_ev_rec arp_xla_events.xla_events_type;
75:
76: BEGIN
77:

Line 96: -- populate the ar_cash_receipts record from ar_cash_receipts table.

92: IF PG_DEBUG in ('Y', 'C') THEN
93: arp_standard.debug('confirm: ' || '-- Parameters validated.');
94: END IF;
95:
96: -- populate the ar_cash_receipts record from ar_cash_receipts table.
97: -- use ar_cash_receipt_id for selection.
98:
99: l_cr_rec.cash_receipt_id := p_cr_id;
100: arp_cash_receipts_pkg.fetch_p(l_cr_rec);

Line 237: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

233:
234:
235:
236: PROCEDURE unconfirm(
237: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
238: p_confirm_gl_date IN DATE,
239: p_confirm_date IN DATE,
240: p_module_name IN VARCHAR2,
241: p_module_version IN VARCHAR2 ) IS

Line 245: l_cr_rec ar_cash_receipts%ROWTYPE;

241: p_module_version IN VARCHAR2 ) IS
242:
243: -- local variables:
244:
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;

Line 268: -- populate the ar_cash_receipts record from ar_cash_receipts table.

264: p_confirm_gl_date,
265: p_confirm_date,
266: p_module_name);
267:
268: -- populate the ar_cash_receipts record from ar_cash_receipts table.
269: -- use ar_cash_receipt_id for selection.
270:
271: l_cr_rec.cash_receipt_id := p_cr_id;
272: arp_cash_receipts_pkg.fetch_p(l_cr_rec);

Line 414: UPDATE AR_CASH_RECEIPTS

410: BEGIN
411:
412: SAVEPOINT ar_confirm_batch_sp;
413:
414: UPDATE AR_CASH_RECEIPTS
415: SET confirmed_flag = 'Y'
416: WHERE cash_receipt_id = l_cash_receipt_rec.cash_receipt_id;
417:
418: arp_confirmation.confirm(

Line 496: FROM AR_CASH_RECEIPTS cr,

492: IF arp_util.is_gl_date_valid(p_confirm_gl_date) THEN
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:

Line 502: UPDATE AR_CASH_RECEIPTS

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
502: UPDATE AR_CASH_RECEIPTS
503: SET confirmed_flag = 'Y'
504: WHERE cash_receipt_id = p_cr_id;
505:
506: arp_confirmation.confirm(

Line 580: p_cr_rec IN ar_cash_receipts%ROWTYPE,

576: | |
577: +===========================================================================*/
578:
579: PROCEDURE do_confirm(
580: p_cr_rec IN ar_cash_receipts%ROWTYPE,
581: p_confirm_gl_date IN DATE,
582: p_confirm_date IN DATE,
583: p_acctd_amount IN NUMBER
584: ) IS

Line 642: p_cr_id ar_cash_receipts.cash_receipt_id%TYPE

638:
639: -- Define cursor for applications:
640:
641: CURSOR ar_receivable_applications_C (
642: p_cr_id ar_cash_receipts.cash_receipt_id%TYPE
643: ) IS
644: SELECT *
645: FROM ar_receivable_applications
646: WHERE cash_receipt_id = p_cr_id

Line 963: p_cr_rec IN ar_cash_receipts%ROWTYPE,

959:
960:
961:
962: PROCEDURE do_unconfirm(
963: p_cr_rec IN ar_cash_receipts%ROWTYPE,
964: p_confirm_gl_date IN DATE,
965: p_confirm_date IN DATE,
966: p_acctd_amount IN NUMBER,
967: p_batch_id

Line 974: p_cr_id ar_cash_receipts.cash_receipt_id%TYPE

970:
971: -- Define cursor for applications:
972:
973: CURSOR ar_receivable_applications_C (
974: p_cr_id ar_cash_receipts.cash_receipt_id%TYPE
975: ) IS
976: SELECT *
977: FROM ar_receivable_applications
978: WHERE cash_receipt_id = p_cr_id

Line 1061: p_cr_rec IN ar_cash_receipts%ROWTYPE,

1057: +===========================================================================*/
1058:
1059:
1060: PROCEDURE update_cr_history_confirm(
1061: p_cr_rec IN ar_cash_receipts%ROWTYPE,
1062: p_confirm_gl_date IN DATE,
1063: p_confirm_date IN DATE,
1064: p_acctd_amount IN NUMBER,
1065: p_receipt_clearing_ccid IN

Line 1071: l_crh_id_new ar_cash_receipts.cash_receipt_id%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:
1075: --

Line 1234: p_cr_rec ar_cash_receipts%ROWTYPE,

1230: | |
1231: +===========================================================================*/
1232:
1233: PROCEDURE confirm_update_ps_rec(
1234: p_cr_rec ar_cash_receipts%ROWTYPE,
1235: p_closed_date DATE,
1236: p_closed_gl_date DATE
1237: ) IS
1238:

Line 1315: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

1311: | |
1312: +===========================================================================*/
1313:
1314: PROCEDURE modify_update_ra_rec(
1315: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1316: p_amount_applied IN NUMBER,
1317: p_acctd_amount_applied IN NUMBER,
1318: p_confirm_gl_date IN DATE,
1319: p_confirm_date IN DATE

Line 1425: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

1421: | receivable apps data |
1422: +===========================================================================*/
1423:
1424: PROCEDURE create_matching_unapp_records(
1425: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1426: p_app_id IN ar_receivable_applications.receivable_application_id%TYPE
1427: ) IS
1428:
1429: l_unapp_id ar_receivable_applications.receivable_application_id%TYPE;

Line 1685: p_cr_rec IN ar_cash_receipts%ROWTYPE,

1681: | |
1682: +===========================================================================*/
1683:
1684: PROCEDURE get_receipt_clearing_ccid(
1685: p_cr_rec IN ar_cash_receipts%ROWTYPE,
1686: p_receipt_clearing_ccid OUT NOCOPY
1687: ar_receipt_method_accounts.receipt_clearing_ccid%TYPE
1688: ) IS
1689:

Line 1750: p_cr_rec IN ar_cash_receipts%ROWTYPE,

1746: +===========================================================================*/
1747:
1748:
1749: PROCEDURE update_cr_history_unconfirm(
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,

Line 2086: p_cr_rec IN ar_cash_receipts%ROWTYPE,

2082: | receivable applications. |
2083: +===========================================================================*/
2084:
2085: PROCEDURE reverse_ra_recs(
2086: p_cr_rec IN ar_cash_receipts%ROWTYPE,
2087: p_confirm_gl_date IN DATE,
2088: p_confirm_date IN DATE
2089: ) IS
2090: CURSOR get_app IS

Line 2667: p_cr_rec ar_cash_receipts%ROWTYPE,

2663: | |
2664: +===========================================================================*/
2665:
2666: PROCEDURE unconfirm_update_ps_rec(
2667: p_cr_rec ar_cash_receipts%ROWTYPE,
2668: p_closed_date DATE,
2669: p_closed_gl_date DATE
2670: ) IS
2671:

Line 2748: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

2744: | |
2745: +===========================================================================*/
2746:
2747: PROCEDURE validate_in_parameters(
2748: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
2749: p_confirm_gl_date IN DATE,
2750: p_confirm_date IN DATE,
2751: p_module_name IN VARCHAR2
2752: ) IS