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_ALL

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