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.IEX_DELINQUENCY_PUB dependencies on IEX_DELINQUENCIES

Line 194: from iex_delinquencies

190: FOR i in 1..l_num_payments LOOP
191:
192: IEX_DEBUG_PUB.LogMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'before open del cursor');
193: select delinquency_id into l_del_id
194: from iex_delinquencies
195: where payment_schedule_id = p_payments_tbl(i);
196:
197: l_del_tbl(i) := l_del_id;
198:

Line 230: UPDATE IEX_DELINQUENCIES_ALL

226: nCount := l_del_tbl.count;
227:
228: if nCount >= 1 then
229: FORALL j in 1..nCount
230: UPDATE IEX_DELINQUENCIES_ALL
231: SET STATUS='CLOSE',
232: DUNN_YN='N',
233: LAST_UPDATE_DATE=sysdate
234: WHERE DELINQUENCY_ID = l_del_tbl(j);

Line 422: v_org_id iex_delinquencies_all.org_id%TYPE;

418:
419: -- 0 Indicates non existence of range and 1 indicates the existence
420: v_score_range Number := 0 ;
421:
422: v_org_id iex_delinquencies_all.org_id%TYPE;
423: v_user_id Number;
424: v_count Number := 1;
425:
426: -- Debug Variables. Remove after unit testing

Line 463: from iex_delinquencies

459: IEX_DEL_STATUSES IDS
460: WHERE
461: NOT EXISTS
462: (Select 1
463: from iex_delinquencies
464: where payment_schedule_id = idb.score_object_id)
465: AND NOT EXISTS
466: (select 1
467: from dual

Line 491: FROM iex_delinquencies id,

487: id.delinquency_id,
488: ids.del_status buf_status,
489: id.status del_status,
490: id.payment_schedule_id
491: FROM iex_delinquencies id,
492: iex_del_buffers idb,
493: iex_del_statuses ids
494: where NOT EXISTS
495: (select 1

Line 513: AND EXISTS (SELECT 1 FROM IEX_DELINQUENCIES_ALL IED WHERE

509: SELECT DISTINCT CUST_ACCOUNT_ID FROM AR_TRX_BAL_SUMMARY ARS,
510: AR_SYSTEM_PARAMETERS ARP
511: WHERE ARS.REFERENCE_1 IS Null
512: AND ARS.ORG_ID = ARP.ORG_ID
513: AND EXISTS (SELECT 1 FROM IEX_DELINQUENCIES_ALL IED WHERE
514: IED.STATUS IN ('DELINQUENT', 'PREDELINQUENT')
515: AND ARS.CUST_ACCOUNT_ID = IED.CUST_ACCOUNT_ID
516: AND ARS.ORG_ID = IED.ORG_ID);
517:

Line 523: AND NOT EXISTS (SELECT 1 FROM IEX_DELINQUENCIES_ALL IED WHERE

519: SELECT DISTINCT CUST_ACCOUNT_ID FROM AR_TRX_BAL_SUMMARY ARS,
520: AR_SYSTEM_PARAMETERS ARP
521: WHERE ARS.REFERENCE_1 = 1
522: AND ARS.ORG_ID = ARP.ORG_ID
523: AND NOT EXISTS (SELECT 1 FROM IEX_DELINQUENCIES_ALL IED WHERE
524: IED.STATUS IN ('DELINQUENT', 'PREDELINQUENT')
525: AND ARS.CUST_ACCOUNT_ID = IED.CUST_ACCOUNT_ID
526: AND ARS.ORG_ID = IED.ORG_ID);
527:

Line 698: FROM iex_delinquencies id,

694: vt_del_id,
695: vt_buf_status,
696: vt_del_status,
697: vt_pmt_schd_id
698: FROM iex_delinquencies id,
699: iex_del_buffers idb,
700: iex_del_statuses ids
701: where NOT EXISTS
702: (select 1

Line 811: UPDATE IEX_DELINQUENCIES

807: Begin
808: -- Once all the Existing PreDelinquent Rows are found then Update them
809: -- UPDATE Phase 1
810: FORALL v_count in 1..vt_del_id.count
811: UPDATE IEX_DELINQUENCIES
812: SET status = vt_buf_status(v_count),
813: last_update_date = v_today,
814: last_updated_by = v_user_id,
815: dunn_yn = decode(vt_buf_status(v_count), vf_current, 'N'),

Line 943: INSERT INTO IEX_DELINQUENCIES_ALL

939: -- get customer_site_use_id from ar_payment_schedules
940:
941: Begin
942: -- Simple Insert for Payment Schedule Id
943: INSERT INTO IEX_DELINQUENCIES_ALL
944: ( DELINQUENCY_ID ,
945: LAST_UPDATE_DATE ,
946: LAST_UPDATED_BY ,
947: CREATION_DATE ,

Line 963: IEX_DELINQUENCIES_S.NEXTVAL ,

959: SCORE_ID ,
960: SCORE_VALUE ,
961: REQUEST_ID )
962: SELECT
963: IEX_DELINQUENCIES_S.NEXTVAL ,
964: v_today,
965: v_user_id,
966: v_today,
967: v_user_id,

Line 991: from iex_delinquencies_all --added by barathsr for bug#7366451 10-Oct-08

987: IEX_DEL_STATUSES IDS
988: WHERE
989: NOT EXISTS
990: (Select 1
991: from iex_delinquencies_all --added by barathsr for bug#7366451 10-Oct-08
992: --iex_delinquencies
993: where payment_schedule_id = idb.score_object_id)
994: -- start bug 9794774 sunagesh 11 jul 2011
995: /* AND NOT EXISTS

Line 992: --iex_delinquencies

988: WHERE
989: NOT EXISTS
990: (Select 1
991: from iex_delinquencies_all --added by barathsr for bug#7366451 10-Oct-08
992: --iex_delinquencies
993: where payment_schedule_id = idb.score_object_id)
994: -- start bug 9794774 sunagesh 11 jul 2011
995: /* AND NOT EXISTS
996: (select 1

Line 1216: FROM iex_delinquencies id,

1212: vt_del_id,
1213: vt_buf_status,
1214: vt_del_status,
1215: vt_case_id
1216: FROM iex_delinquencies id,
1217: iex_del_buffers idb,
1218: iex_del_statuses ids
1219: where
1220: NOT EXISTS

Line 1312: UPDATE IEX_DELINQUENCIES

1308: -- Once all the Existing PreDelinquent Rows are found then
1309: -- Update them
1310: /* 6785378
1311: FORALL v_count in 1..vt_del_id.count
1312: UPDATE IEX_DELINQUENCIES
1313: SET status = vt_buf_status(v_count),
1314: last_update_date = v_today,
1315: last_updated_by = v_user_id,
1316: dunn_yn = decode(vt_buf_status(v_count), vf_current, 'N'),

Line 1402: INSERT INTO IEX_DELINQUENCIES_ALL

1398: -- by OKL, column_name = 'CUSTOMER_ACCOUNT' and 'BILL_TO_ADDRESS_ID'
1399: -- will be not null;
1400:
1401: -- Simple Insert for Payment Schedule Id
1402: INSERT INTO IEX_DELINQUENCIES_ALL
1403: ( DELINQUENCY_ID,
1404: LAST_UPDATE_DATE,
1405: LAST_UPDATED_BY,
1406: CREATION_DATE,

Line 1421: IEX_DELINQUENCIES_S.NEXTVAL,

1417: SCORE_ID ,
1418: SCORE_VALUE ,
1419: REQUEST_ID )
1420: SELECT
1421: IEX_DELINQUENCIES_S.NEXTVAL,
1422: v_today ,
1423: v_user_id ,
1424: v_today ,
1425: v_user_id ,

Line 1448: from iex_delinquencies

1444: IEX_DEL_STATUSES IDS
1445: WHERE
1446: NOT EXISTS
1447: (Select 1
1448: from iex_delinquencies
1449: where case_id = idb.score_object_id)
1450: AND NOT EXISTS
1451: (select 1
1452: from dual

Line 1965: Select IEX_DELINQUENCIES_S.NEXTVAL

1961: IF p_object_code = 'IEX_CASE' then
1962: FOR cnt IN v_first..v_last
1963: LOOP
1964:
1965: Select IEX_DELINQUENCIES_S.NEXTVAL
1966: into x_del_id_tbl(v_count)
1967: From dual ;
1968:
1969: INSERT INTO IEX_DELINQUENCIES_ALL

Line 1969: INSERT INTO IEX_DELINQUENCIES_ALL

1965: Select IEX_DELINQUENCIES_S.NEXTVAL
1966: into x_del_id_tbl(v_count)
1967: From dual ;
1968:
1969: INSERT INTO IEX_DELINQUENCIES_ALL
1970: (DELINQUENCY_ID ,
1971: LAST_UPDATE_DATE ,
1972: LAST_UPDATED_BY ,
1973: CREATION_DATE ,

Line 2005: select IEX_DELINQUENCIES_S.NEXTVAL

2001: else
2002:
2003: IEX_DEBUG_PUB.LOGMESSAGE('In for Current invoice insertion....');
2004:
2005: select IEX_DELINQUENCIES_S.NEXTVAL
2006: into l_deln_id
2007: from dual;
2008:
2009: if p_object_id_tbl.count = 1 then

Line 2023: INSERT INTO IEX_DELINQUENCIES_ALL

2019: IEX_DEBUG_PUB.LOGMESSAGE('Cust_account_id-->'||l_cust_acct_id);
2020: IEX_DEBUG_PUB.LOGMESSAGE('Customer_site_use_id-->'||l_cust_site_use_id);
2021: IEX_DEBUG_PUB.LOGMESSAGE('Customer_site_use_id-->'||l_cust_trx_id);
2022:
2023: INSERT INTO IEX_DELINQUENCIES_ALL
2024: (DELINQUENCY_ID ,
2025: LAST_UPDATE_DATE ,
2026: LAST_UPDATED_BY ,
2027: CREATION_DATE ,

Line 2116: || Target Tables: IEX_DELINQUENCIES_ALL

2112: || Parameter: p_request_id => request_id of score engine run
2113: ||
2114: || Source Tables: IEX_DEL_BUFFERS
2115: ||
2116: || Target Tables: IEX_DELINQUENCIES_ALL
2117: ||
2118: || Creation date: 03/19/02 10:04:AM
2119: ||
2120: || Major Modifications: when who what

Line 2196: UPDATE IEX_DELINQUENCIES_ALL

2192: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2193: iex_debug_pub.logMessage('SCORE_DELINQUENCIES: ' || 'Count is ' || nCount);
2194: END IF;
2195: FORALL r in 1..nCount
2196: UPDATE IEX_DELINQUENCIES_ALL
2197: SET SCORE_ID = l_score_id,
2198: Score_value = v_score_values(r),
2199: last_update_date = sysdate,
2200: request_id = FND_GLOBAL.CONC_REQUEST_ID

Line 2403: update iex_delinquencies_all

2399: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': l_uwq_complete_date: ' || l_uwq_complete_date);
2400: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': updating promise details...');
2401: END IF;
2402: FORALL i in 1..nCount
2403: update iex_delinquencies_all
2404: set UWQ_STATUS = P_UWQ_STATUS,
2405: UWQ_ACTIVE_DATE = l_uwq_active_date,
2406: UWQ_COMPLETE_DATE = l_uwq_complete_date,
2407: last_update_date = sysdate,

Line 2428: FROM iex_delinquencies_all

2424: (SELECT 1
2425: FROM dual
2426: WHERE EXISTS
2427: (SELECT 1
2428: FROM iex_delinquencies_all
2429: WHERE party_cust_id = sum.party_id
2430: AND status IN('DELINQUENT', 'PREDELINQUENT')
2431: AND(uwq_status IS NULL OR uwq_status = 'ACTIVE' OR(TRUNC(uwq_active_date) <= TRUNC(sysdate)
2432: AND uwq_status = 'PENDING'))

Line 2440: FROM iex_delinquencies_all

2436: (SELECT 1
2437: FROM dual
2438: WHERE EXISTS
2439: (SELECT 1
2440: FROM iex_delinquencies_all
2441: WHERE party_cust_id = sum.party_id
2442: AND status IN('DELINQUENT', 'PREDELINQUENT')
2443: AND(uwq_status = 'COMPLETE'
2444: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))

Line 2451: FROM iex_delinquencies_all

2447: (SELECT 1
2448: FROM dual
2449: WHERE EXISTS
2450: (SELECT 1
2451: FROM iex_delinquencies_all
2452: WHERE party_cust_id = sum.party_id
2453: AND status IN('DELINQUENT', 'PREDELINQUENT')
2454: AND(uwq_status = 'PENDING'
2455: AND(TRUNC(uwq_active_date) > TRUNC(sysdate))))

Line 2458: from iex_delinquencies_all

2454: AND(uwq_status = 'PENDING'
2455: AND(TRUNC(uwq_active_date) > TRUNC(sysdate))))
2456: )
2457: WHERE sum.party_id = (select party_cust_id
2458: from iex_delinquencies_all
2459: where delinquency_id = p_delinquency_id_tbl(i));
2460:
2461: ELSIF l_level = 'ACCOUNT' THEN
2462:

Line 2471: FROM iex_delinquencies_all

2467: (SELECT 1
2468: FROM dual
2469: WHERE EXISTS
2470: (SELECT 1
2471: FROM iex_delinquencies_all
2472: WHERE party_cust_id = party_id
2473: AND status IN('DELINQUENT', 'PREDELINQUENT')
2474: AND(uwq_status IS NULL OR uwq_status = 'ACTIVE' OR(TRUNC(uwq_active_date) <= TRUNC(sysdate)
2475: AND uwq_status = 'PENDING'))

Line 2483: FROM iex_delinquencies_all

2479: (SELECT 1
2480: FROM dual
2481: WHERE EXISTS
2482: (SELECT 1
2483: FROM iex_delinquencies_all
2484: WHERE cust_account_id = sum.cust_account_id
2485: AND status IN('DELINQUENT', 'PREDELINQUENT')
2486: AND(uwq_status = 'COMPLETE'
2487: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))

Line 2494: FROM iex_delinquencies_all

2490: (SELECT 1
2491: FROM dual
2492: WHERE EXISTS
2493: (SELECT 1
2494: FROM iex_delinquencies_all
2495: WHERE cust_account_id = sum.cust_account_id
2496: AND status IN('DELINQUENT', 'PREDELINQUENT')
2497: AND(uwq_status = 'PENDING'
2498: AND(TRUNC(uwq_active_date) > TRUNC(sysdate))))

Line 2501: from iex_delinquencies_all

2497: AND(uwq_status = 'PENDING'
2498: AND(TRUNC(uwq_active_date) > TRUNC(sysdate))))
2499: )
2500: WHERE sum.cust_account_id = (select cust_account_id
2501: from iex_delinquencies_all
2502: where delinquency_id = p_delinquency_id_tbl(i));
2503:
2504: ELSIF l_level = 'BILL_TO' THEN
2505:

Line 2514: FROM iex_delinquencies_all

2510: (SELECT 1
2511: FROM dual
2512: WHERE EXISTS
2513: (SELECT 1
2514: FROM iex_delinquencies_all
2515: WHERE customer_site_use_id = sum.site_use_id
2516: AND status IN('DELINQUENT', 'PREDELINQUENT')
2517: AND(uwq_status IS NULL OR uwq_status = 'ACTIVE' OR(TRUNC(uwq_active_date) <= TRUNC(sysdate)
2518: AND uwq_status = 'PENDING'))

Line 2526: FROM iex_delinquencies_all

2522: (SELECT 1
2523: FROM dual
2524: WHERE EXISTS
2525: (SELECT 1
2526: FROM iex_delinquencies_all
2527: WHERE customer_site_use_id = sum.site_use_id
2528: AND status IN('DELINQUENT', 'PREDELINQUENT')
2529: AND(uwq_status = 'COMPLETE'
2530: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))

Line 2537: FROM iex_delinquencies_all

2533: (SELECT 1
2534: FROM dual
2535: WHERE EXISTS
2536: (SELECT 1
2537: FROM iex_delinquencies_all
2538: WHERE customer_site_use_id = sum.site_use_id
2539: AND status IN('DELINQUENT', 'PREDELINQUENT')
2540: AND(uwq_status = 'PENDING'
2541: AND(TRUNC(uwq_active_date) > TRUNC(sysdate))))

Line 2544: from iex_delinquencies_all

2540: AND(uwq_status = 'PENDING'
2541: AND(TRUNC(uwq_active_date) > TRUNC(sysdate))))
2542: )
2543: WHERE sum.site_use_id = (select customer_site_use_id
2544: from iex_delinquencies_all
2545: where delinquency_id = p_delinquency_id_tbl(i));
2546:
2547: END IF;
2548:

Line 2627: from iex_delinquencies id

2623: where idun.dunning_level = 'DELINQUENCY'
2624: and idun.status = 'OPEN'
2625: and EXISTS
2626: (select delinquency_id
2627: from iex_delinquencies id
2628: where status = 'CURRENT'
2629: and id.delinquency_id = dunning_object_id) ;
2630:
2631: FND_FILE.PUT_LINE(FND_FILE.LOG, ' <<< DELINQUENCY >>>

Line 2667: from iex_delinquencies id

2663: where idun.dunning_level = 'BILL_TO'
2664: and idun.status = 'OPEN'
2665: and dunning_object_id IN
2666: (select DISTINCT id.customer_site_use_id
2667: from iex_delinquencies id
2668: where NOT EXISTS
2669: (SELECT customer_site_use_id
2670: FROM IEX_DELINQUENCIES id2
2671: where id2.status IN ('PREDELINQUENT', 'DELINQUENT')

Line 2670: FROM IEX_DELINQUENCIES id2

2666: (select DISTINCT id.customer_site_use_id
2667: from iex_delinquencies id
2668: where NOT EXISTS
2669: (SELECT customer_site_use_id
2670: FROM IEX_DELINQUENCIES id2
2671: where id2.status IN ('PREDELINQUENT', 'DELINQUENT')
2672: and id2.customer_site_use_id = id.customer_site_use_id)) ;
2673:
2674:

Line 2712: from iex_delinquencies id

2708: where idun.dunning_level = 'ACCOUNT'
2709: and idun.status = 'OPEN'
2710: and dunning_object_id IN
2711: (select DISTINCT id.cust_account_id
2712: from iex_delinquencies id
2713: where NOT EXISTS
2714: (SELECT CUST_ACCOUNT_ID
2715: FROM IEX_DELINQUENCIES id2
2716: where id2.status IN ('PREDELINQUENT', 'DELINQUENT')

Line 2715: FROM IEX_DELINQUENCIES id2

2711: (select DISTINCT id.cust_account_id
2712: from iex_delinquencies id
2713: where NOT EXISTS
2714: (SELECT CUST_ACCOUNT_ID
2715: FROM IEX_DELINQUENCIES id2
2716: where id2.status IN ('PREDELINQUENT', 'DELINQUENT')
2717: and id2.cust_account_id = id.cust_account_id)) ;
2718:
2719: FND_FILE.PUT_LINE(FND_FILE.LOG, ' <<< ACCOUNT >>>

Line 2754: from iex_delinquencies id

2750: where idun.dunning_level = 'CUSTOMER'
2751: and idun.status = 'OPEN'
2752: and dunning_object_id IN
2753: (select DISTINCT id.party_cust_id
2754: from iex_delinquencies id
2755: where NOT EXISTS
2756: (SELECT PARTY_CUST_ID
2757: FROM IEX_DELINQUENCIES id2
2758: where id2.status IN ('PREDELINQUENT', 'DELINQUENT')

Line 2757: FROM IEX_DELINQUENCIES id2

2753: (select DISTINCT id.party_cust_id
2754: from iex_delinquencies id
2755: where NOT EXISTS
2756: (SELECT PARTY_CUST_ID
2757: FROM IEX_DELINQUENCIES id2
2758: where id2.status IN ('PREDELINQUENT', 'DELINQUENT')
2759: and id2.party_cust_id = id.party_cust_id)) ;
2760: */
2761: UPDATE IEX_DUNNINGS IDUN

Line 2766: FROM IEX_DELINQUENCIES ID

2762: SET STATUS = 'CLOSE'
2763: WHERE IDUN.DUNNING_LEVEL = 'CUSTOMER'
2764: AND IDUN.STATUS = 'OPEN'
2765: and not exists (SELECT 'x'
2766: FROM IEX_DELINQUENCIES ID
2767: where ID.PARTY_CUST_ID = idun.DUNNING_OBJECT_ID
2768: and ID.STATUS IN ('PREDELINQUENT', 'DELINQUENT'));
2769:
2770: --END jsanju for 4505461 -change sql stmt