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_CUST_OVERVIEW_PVT dependencies on IEX_UTILITIES

Line 112: iex_utilities.get_lookup_meaning('IEX_DELINQUENCY_STATUS', rl.delinquency_status) meaning

108: l_delinquency_status VARCHAR(80);
109:
110: CURSOR c_rule IS
111: SELECT rl.delinquency_status, rl.priority,
112: iex_utilities.get_lookup_meaning('IEX_DELINQUENCY_STATUS', rl.delinquency_status) meaning
113: FROM iex_cu_sts_rl_lines rl, iex_cust_status_rules r
114: WHERE rl.status_rule_id = l_status_rule_id
115: AND r.status_rule_id = rl.status_rule_id
116: AND trunc(sysdate) BETWEEN trunc(nvl(r.start_date,sysdate)) AND trunc(nvl(r.end_date,sysdate))

Line 246: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||

242: ' SELECT litigation_id ' ||
243: ' FROM iex_litigations ' ||
244: ' WHERE party_id= :party_id ' ||
245: ' AND contract_number IS NOT NULL ' ||
246: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||
247: ' AND disposition_code IS NULL )';
248: ELSIF l_delinquency_status = 'REPOSSESSION' THEN
249: l_sql_stmt_lsd := ' select count(1) from (' ||
250: ' SELECT repossession_id' ||

Line 261: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||

257: ' SELECT repossession_id ' ||
258: ' FROM iex_repossessions ' ||
259: ' WHERE party_id= :party_id ' ||
260: ' AND contract_number IS NOT NULL ' ||
261: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||
262: ' AND (disposition_code IS NULL or disposition_code = ''A'' or disposition_code = ''W''))' ;
263: --' AND disposition_code IS NULL )';
264: ELSIF l_delinquency_status = 'WRITEOFF' THEN
265: l_sql_stmt_lsd := ' select count(1) from (' ||

Line 278: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||

274: ' SELECT writeoff_id ' ||
275: ' FROM iex_writeoffs ' ||
276: ' WHERE party_id= :party_id ' ||
277: ' AND contract_number IS NOT NULL ' ||
278: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||
279: ' AND (disposition_code IS NULL or disposition_code = ''A'' or disposition_code = ''W''))' ;
280: --' AND disposition_code IS NULL )';
281: ELSIF l_delinquency_status = 'PREDELINQUENT' THEN
282: l_sql_stmt := 'SELECT count(1)' ||

Line 349: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||

345: ' SELECT litigation_id ' ||
346: ' FROM iex_litigations ' ||
347: ' WHERE party_id= :party_id ' ||
348: ' AND contract_number IS NOT NULL ' ||
349: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||
350: ' AND disposition_code IS NULL )';
351: ELSIF l_delinquency_status = 'REPOSSESSION' THEN
352: l_sql_stmt_lsd := ' select count(1) from (' ||
353: ' SELECT repossession_id' ||

Line 365: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||

361: ' SELECT repossession_id ' ||
362: ' FROM iex_repossessions ' ||
363: ' WHERE party_id= :party_id ' ||
364: ' AND contract_number IS NOT NULL ' ||
365: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||
366: ' AND (disposition_code IS NULL or disposition_code = ''A'' or disposition_code = ''W''))' ;
367: --' AND disposition_code IS NULL )';
368: ELSIF l_delinquency_status = 'WRITEOFF' THEN
369: l_sql_stmt_lsd := ' select count(1) from (' ||

Line 382: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||

378: ' SELECT writeoff_id ' ||
379: ' FROM iex_writeoffs ' ||
380: ' WHERE party_id= :party_id ' ||
381: ' AND contract_number IS NOT NULL ' ||
382: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||
383: ' AND (disposition_code IS NULL or disposition_code = ''A'' or disposition_code = ''W''))' ;
384: --' AND disposition_code IS NULL )';
385: ELSIF l_delinquency_status = 'PREDELINQUENT' THEN
386: l_sql_stmt := 'SELECT count(1)' ||

Line 421: x_customer_info_rec.status := iex_utilities.get_lookup_meaning('IEX_DELINQUENCY_STATUS', 'BANKRUPTCY');

417: WHERE party_id = x_customer_info_rec.party_id
418: AND close_date IS NULL
419: AND NVL(DISPOSITION_CODE, ' ') NOT IN ('DISMISSED','WITHDRAWN' );
420: IF l_bkr_count > 0 then
421: x_customer_info_rec.status := iex_utilities.get_lookup_meaning('IEX_DELINQUENCY_STATUS', 'BANKRUPTCY');
422: ELSE
423: x_customer_info_rec.status := iex_utilities.get_lookup_meaning('IEX_CUSTOMER_STATUS_TYPE', 'CURRENT');
424: END IF;
425: END IF;

Line 423: x_customer_info_rec.status := iex_utilities.get_lookup_meaning('IEX_CUSTOMER_STATUS_TYPE', 'CURRENT');

419: AND NVL(DISPOSITION_CODE, ' ') NOT IN ('DISMISSED','WITHDRAWN' );
420: IF l_bkr_count > 0 then
421: x_customer_info_rec.status := iex_utilities.get_lookup_meaning('IEX_DELINQUENCY_STATUS', 'BANKRUPTCY');
422: ELSE
423: x_customer_info_rec.status := iex_utilities.get_lookup_meaning('IEX_CUSTOMER_STATUS_TYPE', 'CURRENT');
424: END IF;
425: END IF;
426:
427: -- End for bug#7830847

Line 1936: iex_utilities.get_lookup_meaning('IEX_DELINQUENCY_STATUS', rl.delinquency_status) meaning

1932: l_delinquency_status VARCHAR(80);
1933:
1934: CURSOR c_rule IS
1935: SELECT rl.delinquency_status, rl.priority,
1936: iex_utilities.get_lookup_meaning('IEX_DELINQUENCY_STATUS', rl.delinquency_status) meaning
1937: FROM iex_cu_sts_rl_lines rl, iex_cust_status_rules r
1938: WHERE rl.status_rule_id = l_status_rule_id
1939: AND r.status_rule_id = rl.status_rule_id
1940: AND trunc(sysdate) BETWEEN trunc(nvl(r.start_date,sysdate)) AND trunc(nvl(r.end_date,sysdate))

Line 2103: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||

2099: ' SELECT litigation_id ' ||
2100: ' FROM iex_litigations ' ||
2101: ' WHERE party_id= :party_id ' ||
2102: ' AND contract_number IS NOT NULL ' ||
2103: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||
2104: ' AND disposition_code IS NULL )';
2105: ELSIF l_delinquency_status = 'REPOSSESSION' THEN
2106: l_sql_stmt_lsd := ' select count(1) from (' ||
2107: ' SELECT repossession_id' ||

Line 2119: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||

2115: ' SELECT repossession_id ' ||
2116: ' FROM iex_repossessions ' ||
2117: ' WHERE party_id= :party_id ' ||
2118: ' AND contract_number IS NOT NULL ' ||
2119: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||
2120: ' AND (disposition_code IS NULL or disposition_code = ''A'' or disposition_code = ''W'')) ' ;
2121: -- Bug 766183 ' AND disposition_code IS NULL )';
2122: ELSIF l_delinquency_status = 'WRITEOFF' THEN
2123: l_sql_stmt_lsd := ' select count(1) from (' ||

Line 2136: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||

2132: ' SELECT writeoff_id ' ||
2133: ' FROM iex_writeoffs ' ||
2134: ' WHERE party_id= :party_id ' ||
2135: ' AND contract_number IS NOT NULL ' ||
2136: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||
2137: ' AND (disposition_code IS NULL or disposition_code = ''A'' or disposition_code = ''W''))' ;
2138: -- ' AND disposition_code IS NULL )';
2139: ELSIF l_delinquency_status = 'PREDELINQUENT' THEN
2140: l_sql_stmt := 'SELECT count(1)' ||

Line 2207: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||

2203: ' SELECT litigation_id ' ||
2204: ' FROM iex_litigations ' ||
2205: ' WHERE party_id= :party_id ' ||
2206: ' AND contract_number IS NOT NULL ' ||
2207: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||
2208: ' AND disposition_code IS NULL )';
2209: ELSIF l_delinquency_status = 'REPOSSESSION' THEN
2210: l_sql_stmt_lsd := ' select count(1) from (' ||
2211: ' SELECT repossession_id' ||

Line 2223: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||

2219: ' SELECT repossession_id ' ||
2220: ' FROM iex_repossessions ' ||
2221: ' WHERE party_id= :party_id ' ||
2222: ' AND contract_number IS NOT NULL ' ||
2223: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||
2224: ' AND (disposition_code IS NULL or disposition_code = ''A'' or disposition_code = ''W'')) ' ;
2225: -- Bug 766183 ' AND disposition_code IS NULL )';
2226: ELSIF l_delinquency_status = 'WRITEOFF' THEN
2227: l_sql_stmt_lsd := ' select count(1) from (' ||

Line 2240: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||

2236: ' SELECT writeoff_id ' ||
2237: ' FROM iex_writeoffs ' ||
2238: ' WHERE party_id= :party_id ' ||
2239: ' AND contract_number IS NOT NULL ' ||
2240: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||
2241: ' AND (disposition_code IS NULL or disposition_code = ''A'' or disposition_code = ''W''))' ;
2242: -- ' AND disposition_code IS NULL )';
2243: -- fix bug #4157131
2244: ELSIF l_delinquency_status = 'PREDELINQUENT' THEN

Line 2272: x_customer_info_rec.status := iex_utilities.get_lookup_meaning('IEX_CUSTOMER_STATUS_TYPE', 'CURRENT');

2268: END LOOP;
2269: END IF;
2270:
2271: IF x_customer_info_rec.status IS NULL THEN
2272: x_customer_info_rec.status := iex_utilities.get_lookup_meaning('IEX_CUSTOMER_STATUS_TYPE', 'CURRENT');
2273: END IF;
2274:
2275: get_last_payment_info(
2276: p_api_version => p_api_version,