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: -- start bug 9794774 sunagesh 11 jul 2011
995: /* AND NOT EXISTS

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