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:
75: BEGIN
76:
77: IF PG_DEBUG in ('Y', 'C') THEN

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

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

Line 220: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

216:
217:
218:
219: PROCEDURE unconfirm(
220: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
221: p_confirm_gl_date IN DATE,
222: p_confirm_date IN DATE,
223: p_module_name IN VARCHAR2,
224: p_module_version IN VARCHAR2 ) IS

Line 228: l_cr_rec ar_cash_receipts%ROWTYPE;

224: p_module_version IN VARCHAR2 ) IS
225:
226: -- local variables:
227:
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;

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

247: p_confirm_gl_date,
248: p_confirm_date,
249: p_module_name);
250:
251: -- populate the ar_cash_receipts record from ar_cash_receipts table.
252: -- use ar_cash_receipt_id for selection.
253:
254: l_cr_rec.cash_receipt_id := p_cr_id;
255: arp_cash_receipts_pkg.fetch_p(l_cr_rec);

Line 397: UPDATE AR_CASH_RECEIPTS

393: BEGIN
394:
395: SAVEPOINT ar_confirm_batch_sp;
396:
397: UPDATE AR_CASH_RECEIPTS
398: SET confirmed_flag = 'Y'
399: WHERE cash_receipt_id = l_cash_receipt_rec.cash_receipt_id;
400:
401: arp_confirmation.confirm(

Line 479: FROM AR_CASH_RECEIPTS cr,

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

Line 485: UPDATE AR_CASH_RECEIPTS

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
485: UPDATE AR_CASH_RECEIPTS
486: SET confirmed_flag = 'Y'
487: WHERE cash_receipt_id = p_cr_id;
488:
489: arp_confirmation.confirm(

Line 563: p_cr_rec IN ar_cash_receipts%ROWTYPE,

559: | |
560: +===========================================================================*/
561:
562: PROCEDURE do_confirm(
563: p_cr_rec IN ar_cash_receipts%ROWTYPE,
564: p_confirm_gl_date IN DATE,
565: p_confirm_date IN DATE,
566: p_acctd_amount IN NUMBER
567: ) IS

Line 625: p_cr_id ar_cash_receipts.cash_receipt_id%TYPE

621:
622: -- Define cursor for applications:
623:
624: CURSOR ar_receivable_applications_C (
625: p_cr_id ar_cash_receipts.cash_receipt_id%TYPE
626: ) IS
627: SELECT *
628: FROM ar_receivable_applications
629: WHERE cash_receipt_id = p_cr_id

Line 946: p_cr_rec IN ar_cash_receipts%ROWTYPE,

942:
943:
944:
945: PROCEDURE do_unconfirm(
946: p_cr_rec IN ar_cash_receipts%ROWTYPE,
947: p_confirm_gl_date IN DATE,
948: p_confirm_date IN DATE,
949: p_acctd_amount IN NUMBER,
950: p_batch_id

Line 957: p_cr_id ar_cash_receipts.cash_receipt_id%TYPE

953:
954: -- Define cursor for applications:
955:
956: CURSOR ar_receivable_applications_C (
957: p_cr_id ar_cash_receipts.cash_receipt_id%TYPE
958: ) IS
959: SELECT *
960: FROM ar_receivable_applications
961: WHERE cash_receipt_id = p_cr_id

Line 1044: p_cr_rec IN ar_cash_receipts%ROWTYPE,

1040: +===========================================================================*/
1041:
1042:
1043: PROCEDURE update_cr_history_confirm(
1044: p_cr_rec IN ar_cash_receipts%ROWTYPE,
1045: p_confirm_gl_date IN DATE,
1046: p_confirm_date IN DATE,
1047: p_acctd_amount IN NUMBER,
1048: p_receipt_clearing_ccid IN

Line 1054: l_crh_id_new ar_cash_receipts.cash_receipt_id%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:
1058: --

Line 1217: p_cr_rec ar_cash_receipts%ROWTYPE,

1213: | |
1214: +===========================================================================*/
1215:
1216: PROCEDURE confirm_update_ps_rec(
1217: p_cr_rec ar_cash_receipts%ROWTYPE,
1218: p_closed_date DATE,
1219: p_closed_gl_date DATE
1220: ) IS
1221:

Line 1298: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

1294: | |
1295: +===========================================================================*/
1296:
1297: PROCEDURE modify_update_ra_rec(
1298: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1299: p_amount_applied IN NUMBER,
1300: p_acctd_amount_applied IN NUMBER,
1301: p_confirm_gl_date IN DATE,
1302: p_confirm_date IN DATE

Line 1408: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

1404: | receivable apps data |
1405: +===========================================================================*/
1406:
1407: PROCEDURE create_matching_unapp_records(
1408: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1409: p_app_id IN ar_receivable_applications.receivable_application_id%TYPE
1410: ) IS
1411:
1412: l_unapp_id ar_receivable_applications.receivable_application_id%TYPE;

Line 1668: p_cr_rec IN ar_cash_receipts%ROWTYPE,

1664: | |
1665: +===========================================================================*/
1666:
1667: PROCEDURE get_receipt_clearing_ccid(
1668: p_cr_rec IN ar_cash_receipts%ROWTYPE,
1669: p_receipt_clearing_ccid OUT NOCOPY
1670: ar_receipt_method_accounts.receipt_clearing_ccid%TYPE
1671: ) IS
1672:

Line 1733: p_cr_rec IN ar_cash_receipts%ROWTYPE,

1729: +===========================================================================*/
1730:
1731:
1732: PROCEDURE update_cr_history_unconfirm(
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,

Line 2069: p_cr_rec IN ar_cash_receipts%ROWTYPE,

2065: | receivable applications. |
2066: +===========================================================================*/
2067:
2068: PROCEDURE reverse_ra_recs(
2069: p_cr_rec IN ar_cash_receipts%ROWTYPE,
2070: p_confirm_gl_date IN DATE,
2071: p_confirm_date IN DATE
2072: ) IS
2073: CURSOR get_app IS

Line 2650: p_cr_rec ar_cash_receipts%ROWTYPE,

2646: | |
2647: +===========================================================================*/
2648:
2649: PROCEDURE unconfirm_update_ps_rec(
2650: p_cr_rec ar_cash_receipts%ROWTYPE,
2651: p_closed_date DATE,
2652: p_closed_gl_date DATE
2653: ) IS
2654:

Line 2731: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

2727: | |
2728: +===========================================================================*/
2729:
2730: PROCEDURE validate_in_parameters(
2731: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
2732: p_confirm_gl_date IN DATE,
2733: p_confirm_date IN DATE,
2734: p_module_name IN VARCHAR2
2735: ) IS