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_RECEIVABLE_APPLICATIONS

Line 617: ar_receivable_applications.acctd_amount_applied_to%TYPE;

613: l_nao_flag ra_cust_trx_types.natural_application_only_flag%TYPE;
614: l_creation_sign ra_cust_trx_types.creation_sign%TYPE;
615:
616: l_acctd_app_amount_to
617: ar_receivable_applications.acctd_amount_applied_to%TYPE;
618: l_acctd_app_amount_from
619: ar_receivable_applications.acctd_amount_applied_from%TYPE;
620:
621: l_ae_doc_rec ae_doc_rec_type;

Line 619: ar_receivable_applications.acctd_amount_applied_from%TYPE;

615:
616: l_acctd_app_amount_to
617: ar_receivable_applications.acctd_amount_applied_to%TYPE;
618: l_acctd_app_amount_from
619: ar_receivable_applications.acctd_amount_applied_from%TYPE;
620:
621: l_ae_doc_rec ae_doc_rec_type;
622:
623: l_app_id ar_receivable_applications.receivable_application_id%TYPE;

Line 623: l_app_id ar_receivable_applications.receivable_application_id%TYPE;

619: ar_receivable_applications.acctd_amount_applied_from%TYPE;
620:
621: l_ae_doc_rec ae_doc_rec_type;
622:
623: l_app_id ar_receivable_applications.receivable_application_id%TYPE;
624:
625:
626: -- Following two parametes and the currency cursor is introduced By
627: -- RAM-C (ORASHID)

Line 641: CURSOR ar_receivable_applications_C (

637:
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

Line 645: FROM ar_receivable_applications

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
647: AND status = 'APP'
648: AND reversal_gl_date IS NULL;
649:

Line 665: FOR l_ra_rec IN ar_receivable_applications_C(p_cr_rec.cash_receipt_id)

661: l_max_dates.max_ra_gl_date := p_confirm_gl_date;
662:
663: -- process every application record for the given cash receipt:
664:
665: FOR l_ra_rec IN ar_receivable_applications_C(p_cr_rec.cash_receipt_id)
666: LOOP
667:
668: -- Bug 768935: initially set l_acctd_app_amount_from to NULL,
669: -- let calc_acctd_amount calculate.

Line 790: UPDATE ar_receivable_applications

786: -- Update receivable applications record. Use the return values
787: -- of the previous function call to fill the line, tax, freight,
788: -- and charges applied columns.
789:
790: UPDATE ar_receivable_applications
791: SET confirmed_flag = 'Y',
792: postable = 'Y',
793: gl_date = l_max_dates.max_ra_gl_date,
794: apply_date = l_max_dates.max_ra_apply_date,

Line 887: -- update UNAPP record of the cash receipt in ar_receivable_applications:

883: l_ra_rec.receivable_application_id);
884: END LOOP;
885:
886:
887: -- update UNAPP record of the cash receipt in ar_receivable_applications:
888:
889: modify_update_ra_rec( p_cr_rec.cash_receipt_id,
890: p_cr_rec.amount,
891: p_acctd_amount,

Line 904: -- ar_receivable_applications (negative amounts).

900: l_max_dates.max_gl_date);
901:
902:
903: -- create matching UNAPP records for APP records in
904: -- ar_receivable_applications (negative amounts).
905: -- as part of 11.5 changes, the APP id also needs to be passed
906: -- as UNAPP records are paired with their APP records
907:
908: create_matching_unapp_records(p_cr_rec.cash_receipt_id, l_app_id);

Line 973: CURSOR ar_receivable_applications_C (

969: ) IS
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

Line 977: FROM ar_receivable_applications

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
979: AND status = 'APP'
980: AND reversal_gl_date IS NULL;
981:

Line 986: FOR l_app_rec IN ar_receivable_applications_C(p_cr_rec.cash_receipt_id)

982: BEGIN
983:
984: -- process every application record for the given cash receipt:
985:
986: FOR l_app_rec IN ar_receivable_applications_C(p_cr_rec.cash_receipt_id)
987: LOOP
988:
989: -- Update invoice payment schedule to which this application record
990: -- is applied. This step basically reverses the application of the

Line 1003: -- create reversing records in ar_receivable_applications

999:
1000: END LOOP;
1001:
1002:
1003: -- create reversing records in ar_receivable_applications
1004:
1005: reverse_ra_recs( p_cr_rec,
1006: p_confirm_gl_date,
1007: p_confirm_date);

Line 1286: | in ar_receivable_applications. |

1282: | modify_update_ra_rec |
1283: | |
1284: | DESCRIPTION |
1285: | This function updates the original UNAPP record for the cash receipt |
1286: | in ar_receivable_applications. |
1287: | It also determines the payment schedule id for the receipt, which is |
1288: | returned for future use. |
1289: | |
1290: | SCOPE - PRIVATE |

Line 1322: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;

1318: p_confirm_gl_date IN DATE,
1319: p_confirm_date IN DATE
1320: ) IS
1321:
1322: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
1323: l_ae_doc_rec ae_doc_rec_type;
1324:
1325: BEGIN
1326:

Line 1334: FROM ar_receivable_applications app

1330: --moved where clause from update to select
1331:
1332: SELECT app.receivable_application_id
1333: INTO l_receivable_application_id
1334: FROM ar_receivable_applications app
1335: WHERE app.cash_receipt_id = p_cr_id
1336: AND app.status = 'UNAPP'
1337: AND app.confirmed_flag = 'N'
1338: AND app.reversal_gl_date IS NULL

Line 1345: UPDATE ar_receivable_applications

1341: -- update record
1342:
1343: arp_standard.debug('arp_confirmation.modify_update_ra_rec()+');
1344:
1345: UPDATE ar_receivable_applications
1346: SET gl_date = p_confirm_gl_date,
1347: apply_date = p_confirm_date,
1348: amount_applied = p_amount_applied,
1349: acctd_amount_applied_from = p_acctd_amount_applied,

Line 1426: p_app_id IN ar_receivable_applications.receivable_application_id%TYPE

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;
1430: l_ae_doc_rec ae_doc_rec_type;

Line 1429: l_unapp_id ar_receivable_applications.receivable_application_id%TYPE;

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;
1430: l_ae_doc_rec ae_doc_rec_type;
1431:
1432: /* Bug Fix 1640890. Fix invloves creating the following cursor
1433: and inserting the UNAPP record and calling the accounting package

Line 1457: FROM ar_receivable_applications app,

1453: app.cash_receipt_id app_cr_id,
1454: app.comments app_comments,
1455: app.days_late app_days_late,
1456: app.org_id app_org_id
1457: FROM ar_receivable_applications app,
1458: ar_receivable_applications unapp
1459: WHERE app.cash_receipt_id = p_cr_id
1460: AND app.status||'' = 'APP'
1461: AND app.reversal_gl_date IS NULL

Line 1458: ar_receivable_applications unapp

1454: app.comments app_comments,
1455: app.days_late app_days_late,
1456: app.org_id app_org_id
1457: FROM ar_receivable_applications app,
1458: ar_receivable_applications unapp
1459: WHERE app.cash_receipt_id = p_cr_id
1460: AND app.status||'' = 'APP'
1461: AND app.reversal_gl_date IS NULL
1462: AND app.cash_receipt_id = unapp.cash_receipt_id

Line 1477: SELECT ar_receivable_applications_s.nextval

1473: --Retrieve sequence id for receivable application id of UNAPP record
1474: --Note as this procedure creates a single UNAPP record hence this kind
1475: --of select from dual for sequence id is done
1476:
1477: SELECT ar_receivable_applications_s.nextval
1478: INTO l_unapp_id
1479: FROM dual;
1480:
1481: --Insert negative UNAPP record for confirmed APP record

Line 1482: INSERT INTO ar_receivable_applications (

1478: INTO l_unapp_id
1479: FROM dual;
1480:
1481: --Insert negative UNAPP record for confirmed APP record
1482: INSERT INTO ar_receivable_applications (
1483: receivable_application_id,
1484: acctd_amount_applied_from,
1485: amount_applied,
1486: application_rule,

Line 1929: ar_receivable_applications.receivable_application_id%TYPE,

1925:
1926:
1927: PROCEDURE reverse_application_to_ps(
1928: p_ra_id IN
1929: ar_receivable_applications.receivable_application_id%TYPE,
1930: p_confirm_gl_date IN DATE,
1931: p_confirm_date IN DATE,
1932: p_batch_id IN
1933: ar_payment_schedules.selected_for_receipt_batch_id%TYPE

Line 1995: ar_receivable_applications ra,

1991: FND_GLOBAL.user_id,
1992: trunc(sysdate),
1993: FND_GLOBAL.user_id
1994: FROM
1995: ar_receivable_applications ra,
1996: ar_payment_schedules ps2,
1997: ar_adjustments adj2,
1998: ar_receivable_applications ra2
1999: WHERE

Line 1998: ar_receivable_applications ra2

1994: FROM
1995: ar_receivable_applications ra,
1996: ar_payment_schedules ps2,
1997: ar_adjustments adj2,
1998: ar_receivable_applications ra2
1999: WHERE
2000: ra.receivable_application_id = p_ra_id
2001: AND ra.applied_payment_schedule_id = ps2.payment_schedule_id
2002: AND ps2.payment_schedule_id =ps.payment_schedule_id

Line 2028: ar_receivable_applications ra3

2024: ra.receivables_charges_applied)
2025: WHERE ps.payment_schedule_id in ( SELECT
2026: ra3.applied_payment_schedule_id
2027: FROM
2028: ar_receivable_applications ra3
2029: WHERE
2030: ra3.receivable_application_id =
2031: p_ra_id)
2032: RETURNING ps.payment_schedule_id

Line 2092: FROM ar_receivable_applications app

2088: p_confirm_date IN DATE
2089: ) IS
2090: CURSOR get_app IS
2091: SELECT app.receivable_application_id old_app_id
2092: FROM ar_receivable_applications app
2093: WHERE app.cash_receipt_id = p_cr_rec.cash_receipt_id
2094: AND app.reversal_gl_date IS NULL
2095: ORDER BY decode(app.status,
2096: 'APP' ,1,

Line 2102: l_new_app_id ar_receivable_applications.receivable_application_id%TYPE;

2098: 'UNID' ,3,
2099: 'UNAPP',4); --This ordering is required for pairing UNAPP with APP record
2100:
2101: l_app_rec get_app%ROWTYPE;
2102: l_new_app_id ar_receivable_applications.receivable_application_id%TYPE;
2103: l_ae_doc_rec ae_doc_rec_type;
2104:
2105: n_new_con_data new_con_data; /* to store values retrieved from bulk collect */
2106:

Line 2114: SELECT ar_receivable_applications_s.nextval

2110:
2111: FOR l_app_rec IN get_app LOOP
2112:
2113: --retrieve sequence
2114: SELECT ar_receivable_applications_s.nextval
2115: INTO l_new_app_id
2116: FROM dual;
2117:
2118: --Create actual reversing apps

Line 2119: INSERT INTO ar_receivable_applications

2115: INTO l_new_app_id
2116: FROM dual;
2117:
2118: --Create actual reversing apps
2119: INSERT INTO ar_receivable_applications
2120: (receivable_application_id,
2121: acctd_amount_applied_from,
2122: amount_applied,
2123: application_rule,

Line 2253: FROM ar_receivable_applications

2249: attribute15,
2250: ussgl_transaction_code_context,
2251: p_confirm_gl_date,
2252: org_id
2253: FROM ar_receivable_applications
2254: WHERE receivable_application_id = l_app_rec.old_app_id;
2255:
2256: -- Call mrc engine to create the data in mc tables
2257: ar_mrc_engine3.reverse_ra_recs(

Line 2291: ar_receivable_applications_s.nextval,

2287: -- create new unconfirmed records from old confirmed records:
2288:
2289: SELECT
2290: receivable_application_id,
2291: ar_receivable_applications_s.nextval,
2292: acctd_amount_applied_from,
2293: amount_applied,
2294: DECODE(status,
2295: 'UNAPP', '40.0',

Line 2449: FROM ar_receivable_applications

2445: n_new_con_data.l_attribute15,
2446: n_new_con_data.l_ussgl_transaction_code_cntxt,
2447: n_new_con_data.l_reversal_gl_date,
2448: n_new_con_data.l_org_id
2449: FROM ar_receivable_applications
2450: WHERE cash_receipt_id = p_cr_rec.cash_receipt_id
2451: AND ( status = 'APP'
2452: OR
2453: ( status = 'UNAPP'

Line 2463: INSERT INTO ar_receivable_applications

2459:
2460: -- MRC trigger replacement.. Do a bulk collect and pass
2461:
2462: FORALL i IN 1..n_new_con_data.l_reversal_gl_date.COUNT
2463: INSERT INTO ar_receivable_applications
2464: (receivable_application_id,
2465: acctd_amount_applied_from,
2466: amount_applied,
2467: application_rule,

Line 2610: UPDATE ar_receivable_applications

2606: --records are unconfirmed
2607:
2608: -- mark all old records as reversed
2609:
2610: UPDATE ar_receivable_applications
2611: SET reversal_gl_date = p_confirm_gl_date,
2612: display = 'N',
2613: last_update_date = TRUNC(SYSDATE),
2614: last_updated_by = FND_GLOBAL.user_id