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: AND NOT EXISTS
995: (select 1

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: AND NOT EXISTS
995: (select 1
996: from dual

Line 1213: FROM iex_delinquencies id,

1209: vt_del_id,
1210: vt_buf_status,
1211: vt_del_status,
1212: vt_case_id
1213: FROM iex_delinquencies id,
1214: iex_del_buffers idb,
1215: iex_del_statuses ids
1216: where
1217: NOT EXISTS

Line 1309: UPDATE IEX_DELINQUENCIES

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

Line 1399: INSERT INTO IEX_DELINQUENCIES_ALL

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

Line 1418: IEX_DELINQUENCIES_S.NEXTVAL,

1414: SCORE_ID ,
1415: SCORE_VALUE ,
1416: REQUEST_ID )
1417: SELECT
1418: IEX_DELINQUENCIES_S.NEXTVAL,
1419: v_today ,
1420: v_user_id ,
1421: v_today ,
1422: v_user_id ,

Line 1445: from iex_delinquencies

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

Line 1892: Select IEX_DELINQUENCIES_S.NEXTVAL

1888: IF p_object_code = 'IEX_CASE' then
1889: FOR cnt IN v_first..v_last
1890: LOOP
1891:
1892: Select IEX_DELINQUENCIES_S.NEXTVAL
1893: into x_del_id_tbl(v_count)
1894: From dual ;
1895:
1896: INSERT INTO IEX_DELINQUENCIES_ALL

Line 1896: INSERT INTO IEX_DELINQUENCIES_ALL

1892: Select IEX_DELINQUENCIES_S.NEXTVAL
1893: into x_del_id_tbl(v_count)
1894: From dual ;
1895:
1896: INSERT INTO IEX_DELINQUENCIES_ALL
1897: (DELINQUENCY_ID ,
1898: LAST_UPDATE_DATE ,
1899: LAST_UPDATED_BY ,
1900: CREATION_DATE ,

Line 1932: select IEX_DELINQUENCIES_S.NEXTVAL

1928: else
1929:
1930: IEX_DEBUG_PUB.LOGMESSAGE('In for Current invoice insertion....');
1931:
1932: select IEX_DELINQUENCIES_S.NEXTVAL
1933: into l_deln_id
1934: from dual;
1935:
1936: if p_object_id_tbl.count = 1 then

Line 1948: INSERT INTO IEX_DELINQUENCIES_ALL

1944:
1945: IEX_DEBUG_PUB.LOGMESSAGE('Org_id--->'||l_org_id);
1946: IEX_DEBUG_PUB.LOGMESSAGE('Cust_account_id-->'||l_cust_acct_id);
1947: IEX_DEBUG_PUB.LOGMESSAGE('Customer_site_use_id-->'||l_cust_site_use_id);
1948: INSERT INTO IEX_DELINQUENCIES_ALL
1949: (DELINQUENCY_ID ,
1950: LAST_UPDATE_DATE ,
1951: LAST_UPDATED_BY ,
1952: CREATION_DATE ,

Line 2039: || Target Tables: IEX_DELINQUENCIES_ALL

2035: || Parameter: p_request_id => request_id of score engine run
2036: ||
2037: || Source Tables: IEX_DEL_BUFFERS
2038: ||
2039: || Target Tables: IEX_DELINQUENCIES_ALL
2040: ||
2041: || Creation date: 03/19/02 10:04:AM
2042: ||
2043: || Major Modifications: when who what

Line 2119: UPDATE IEX_DELINQUENCIES_ALL

2115: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2116: iex_debug_pub.logMessage('SCORE_DELINQUENCIES: ' || 'Count is ' || nCount);
2117: END IF;
2118: FORALL r in 1..nCount
2119: UPDATE IEX_DELINQUENCIES_ALL
2120: SET SCORE_ID = l_score_id,
2121: Score_value = v_score_values(r),
2122: last_update_date = sysdate,
2123: request_id = FND_GLOBAL.CONC_REQUEST_ID

Line 2326: update iex_delinquencies_all

2322: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': l_uwq_complete_date: ' || l_uwq_complete_date);
2323: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': updating promise details...');
2324: END IF;
2325: FORALL i in 1..nCount
2326: update iex_delinquencies_all
2327: set UWQ_STATUS = P_UWQ_STATUS,
2328: UWQ_ACTIVE_DATE = l_uwq_active_date,
2329: UWQ_COMPLETE_DATE = l_uwq_complete_date,
2330: last_update_date = sysdate,

Line 2351: FROM iex_delinquencies_all

2347: (SELECT 1
2348: FROM dual
2349: WHERE EXISTS
2350: (SELECT 1
2351: FROM iex_delinquencies_all
2352: WHERE party_cust_id = sum.party_id
2353: AND status IN('DELINQUENT', 'PREDELINQUENT')
2354: AND(uwq_status IS NULL OR uwq_status = 'ACTIVE' OR(TRUNC(uwq_active_date) <= TRUNC(sysdate)
2355: AND uwq_status = 'PENDING'))

Line 2363: FROM iex_delinquencies_all

2359: (SELECT 1
2360: FROM dual
2361: WHERE EXISTS
2362: (SELECT 1
2363: FROM iex_delinquencies_all
2364: WHERE party_cust_id = sum.party_id
2365: AND status IN('DELINQUENT', 'PREDELINQUENT')
2366: AND(uwq_status = 'COMPLETE'
2367: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))

Line 2374: FROM iex_delinquencies_all

2370: (SELECT 1
2371: FROM dual
2372: WHERE EXISTS
2373: (SELECT 1
2374: FROM iex_delinquencies_all
2375: WHERE party_cust_id = sum.party_id
2376: AND status IN('DELINQUENT', 'PREDELINQUENT')
2377: AND(uwq_status = 'PENDING'
2378: AND(TRUNC(uwq_active_date) > TRUNC(sysdate))))

Line 2381: from iex_delinquencies_all

2377: AND(uwq_status = 'PENDING'
2378: AND(TRUNC(uwq_active_date) > TRUNC(sysdate))))
2379: )
2380: WHERE sum.party_id = (select party_cust_id
2381: from iex_delinquencies_all
2382: where delinquency_id = p_delinquency_id_tbl(i));
2383:
2384: ELSIF l_level = 'ACCOUNT' THEN
2385:

Line 2394: FROM iex_delinquencies_all

2390: (SELECT 1
2391: FROM dual
2392: WHERE EXISTS
2393: (SELECT 1
2394: FROM iex_delinquencies_all
2395: WHERE party_cust_id = party_id
2396: AND status IN('DELINQUENT', 'PREDELINQUENT')
2397: AND(uwq_status IS NULL OR uwq_status = 'ACTIVE' OR(TRUNC(uwq_active_date) <= TRUNC(sysdate)
2398: AND uwq_status = 'PENDING'))

Line 2406: FROM iex_delinquencies_all

2402: (SELECT 1
2403: FROM dual
2404: WHERE EXISTS
2405: (SELECT 1
2406: FROM iex_delinquencies_all
2407: WHERE cust_account_id = sum.cust_account_id
2408: AND status IN('DELINQUENT', 'PREDELINQUENT')
2409: AND(uwq_status = 'COMPLETE'
2410: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))

Line 2417: FROM iex_delinquencies_all

2413: (SELECT 1
2414: FROM dual
2415: WHERE EXISTS
2416: (SELECT 1
2417: FROM iex_delinquencies_all
2418: WHERE cust_account_id = sum.cust_account_id
2419: AND status IN('DELINQUENT', 'PREDELINQUENT')
2420: AND(uwq_status = 'PENDING'
2421: AND(TRUNC(uwq_active_date) > TRUNC(sysdate))))

Line 2424: from iex_delinquencies_all

2420: AND(uwq_status = 'PENDING'
2421: AND(TRUNC(uwq_active_date) > TRUNC(sysdate))))
2422: )
2423: WHERE sum.cust_account_id = (select cust_account_id
2424: from iex_delinquencies_all
2425: where delinquency_id = p_delinquency_id_tbl(i));
2426:
2427: ELSIF l_level = 'BILL_TO' THEN
2428:

Line 2437: FROM iex_delinquencies_all

2433: (SELECT 1
2434: FROM dual
2435: WHERE EXISTS
2436: (SELECT 1
2437: FROM iex_delinquencies_all
2438: WHERE customer_site_use_id = sum.site_use_id
2439: AND status IN('DELINQUENT', 'PREDELINQUENT')
2440: AND(uwq_status IS NULL OR uwq_status = 'ACTIVE' OR(TRUNC(uwq_active_date) <= TRUNC(sysdate)
2441: AND uwq_status = 'PENDING'))

Line 2449: FROM iex_delinquencies_all

2445: (SELECT 1
2446: FROM dual
2447: WHERE EXISTS
2448: (SELECT 1
2449: FROM iex_delinquencies_all
2450: WHERE customer_site_use_id = sum.site_use_id
2451: AND status IN('DELINQUENT', 'PREDELINQUENT')
2452: AND(uwq_status = 'COMPLETE'
2453: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))

Line 2460: FROM iex_delinquencies_all

2456: (SELECT 1
2457: FROM dual
2458: WHERE EXISTS
2459: (SELECT 1
2460: FROM iex_delinquencies_all
2461: WHERE customer_site_use_id = sum.site_use_id
2462: AND status IN('DELINQUENT', 'PREDELINQUENT')
2463: AND(uwq_status = 'PENDING'
2464: AND(TRUNC(uwq_active_date) > TRUNC(sysdate))))

Line 2467: from iex_delinquencies_all

2463: AND(uwq_status = 'PENDING'
2464: AND(TRUNC(uwq_active_date) > TRUNC(sysdate))))
2465: )
2466: WHERE sum.site_use_id = (select customer_site_use_id
2467: from iex_delinquencies_all
2468: where delinquency_id = p_delinquency_id_tbl(i));
2469:
2470: END IF;
2471:

Line 2550: from iex_delinquencies id

2546: where idun.dunning_level = 'DELINQUENCY'
2547: and idun.status = 'OPEN'
2548: and EXISTS
2549: (select delinquency_id
2550: from iex_delinquencies id
2551: where status = 'CURRENT'
2552: and id.delinquency_id = dunning_object_id) ;
2553:
2554: FND_FILE.PUT_LINE(FND_FILE.LOG, ' <<< DELINQUENCY >>>

Line 2590: from iex_delinquencies id

2586: where idun.dunning_level = 'BILL_TO'
2587: and idun.status = 'OPEN'
2588: and dunning_object_id IN
2589: (select DISTINCT id.customer_site_use_id
2590: from iex_delinquencies id
2591: where NOT EXISTS
2592: (SELECT customer_site_use_id
2593: FROM IEX_DELINQUENCIES id2
2594: where id2.status IN ('PREDELINQUENT', 'DELINQUENT')

Line 2593: FROM IEX_DELINQUENCIES id2

2589: (select DISTINCT id.customer_site_use_id
2590: from iex_delinquencies id
2591: where NOT EXISTS
2592: (SELECT customer_site_use_id
2593: FROM IEX_DELINQUENCIES id2
2594: where id2.status IN ('PREDELINQUENT', 'DELINQUENT')
2595: and id2.customer_site_use_id = id.customer_site_use_id)) ;
2596:
2597:

Line 2635: from iex_delinquencies id

2631: where idun.dunning_level = 'ACCOUNT'
2632: and idun.status = 'OPEN'
2633: and dunning_object_id IN
2634: (select DISTINCT id.cust_account_id
2635: from iex_delinquencies id
2636: where NOT EXISTS
2637: (SELECT CUST_ACCOUNT_ID
2638: FROM IEX_DELINQUENCIES id2
2639: where id2.status IN ('PREDELINQUENT', 'DELINQUENT')

Line 2638: FROM IEX_DELINQUENCIES id2

2634: (select DISTINCT id.cust_account_id
2635: from iex_delinquencies id
2636: where NOT EXISTS
2637: (SELECT CUST_ACCOUNT_ID
2638: FROM IEX_DELINQUENCIES id2
2639: where id2.status IN ('PREDELINQUENT', 'DELINQUENT')
2640: and id2.cust_account_id = id.cust_account_id)) ;
2641:
2642: FND_FILE.PUT_LINE(FND_FILE.LOG, ' <<< ACCOUNT >>>

Line 2677: from iex_delinquencies id

2673: where idun.dunning_level = 'CUSTOMER'
2674: and idun.status = 'OPEN'
2675: and dunning_object_id IN
2676: (select DISTINCT id.party_cust_id
2677: from iex_delinquencies id
2678: where NOT EXISTS
2679: (SELECT PARTY_CUST_ID
2680: FROM IEX_DELINQUENCIES id2
2681: where id2.status IN ('PREDELINQUENT', 'DELINQUENT')

Line 2680: FROM IEX_DELINQUENCIES id2

2676: (select DISTINCT id.party_cust_id
2677: from iex_delinquencies id
2678: where NOT EXISTS
2679: (SELECT PARTY_CUST_ID
2680: FROM IEX_DELINQUENCIES id2
2681: where id2.status IN ('PREDELINQUENT', 'DELINQUENT')
2682: and id2.party_cust_id = id.party_cust_id)) ;
2683: */
2684: UPDATE IEX_DUNNINGS IDUN

Line 2689: FROM IEX_DELINQUENCIES ID

2685: SET STATUS = 'CLOSE'
2686: WHERE IDUN.DUNNING_LEVEL = 'CUSTOMER'
2687: AND IDUN.STATUS = 'OPEN'
2688: and not exists (SELECT 'x'
2689: FROM IEX_DELINQUENCIES ID
2690: where ID.PARTY_CUST_ID = idun.DUNNING_OBJECT_ID
2691: and ID.STATUS IN ('PREDELINQUENT', 'DELINQUENT'));
2692:
2693: --END jsanju for 4505461 -change sql stmt