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_DEL_BUFFERS

Line 34: || Target Tables: IEX_DEL_BUFFERS

30: || Parameter: None
31: ||
32: || Source Tables: None
33: ||
34: || Target Tables: IEX_DEL_BUFFERS
35: ||
36: || Creation date: 03/15/02 3:29:PM
37: ||
38: || Major Modifications: when who what

Line 83: -- from IEX_DEL_BUFFERS;

79: -- Begin - 01/25/2005 - Andre Araujo - This will cause the temp tables space to blow up changing it...
80: --
81: CLEAR_BUFFERS2(-1);
82: --Delete
83: -- from IEX_DEL_BUFFERS;
84: --
85: -- End - 01/25/2005 - Andre Araujo - This will cause the temp tables space to blow up changing it...
86: --
87:

Line 416: v_object IEX_DEL_BUFFERS.SCORE_OBJECT_CODE%TYPE;

412: vt_contract_id IEX_UTILITIES.t_numbers ;
413: vt_wf_del_id IEX_UTILITIES.t_del_id;
414:
415: v_today date;
416: v_object IEX_DEL_BUFFERS.SCORE_OBJECT_CODE%TYPE;
417: v_score Number;
418:
419: -- 0 Indicates non existence of range and 1 indicates the existence
420: v_score_range Number := 0 ;

Line 457: IEX_DEL_BUFFERS IDB,

453: ARPS.customer_trx_id,
454: IDB.score_object_id,
455: IDS.del_status
456: FROM HZ_CUST_ACCOUNTS HZCA,
457: IEX_DEL_BUFFERS IDB,
458: AR_PAYMENT_SCHEDULES ARPS,
459: IEX_DEL_STATUSES IDS
460: WHERE
461: NOT EXISTS

Line 492: iex_del_buffers idb,

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
496: from dual

Line 587: FROM iex_del_buffers

583: SELECT score_object_code,
584: score_id
585: INTO v_object,
586: v_score
587: FROM iex_del_buffers
588: WHERE request_id = p_request_id
589: AND rownum = 1 ;
590:
591: -- IF PG_DEBUG < 10 THEN

Line 606: ERRBUF := ' No Data Found on IEX_DEL_BUFFERS Table for the Passed Request Id...> '

602: IEX_DEBUG_PUB.LOGMESSAGE('MANAGE_DELINQUENCIES: ' || v_line);
603: END IF;
604: Exception
605: WHEN NO_DATA_FOUND then
606: ERRBUF := ' No Data Found on IEX_DEL_BUFFERS Table for the Passed Request Id...> '
607: || to_char(p_Request_id) ;
608: RETCODE := 1;
609: -- IF PG_DEBUG < 10 THEN
610: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 699: iex_del_buffers idb,

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
703: from dual

Line 772: --DELETE FROM IEX_DEL_BUFFERS

768: --
769: -- Begin - 01/24/2005 - Andre Araujo - This procedure uses a memory schema uses up all memory available for the session, changing it to chunks
770: --
771: CLEAR_BUFFERS2(p_request_id);
772: --DELETE FROM IEX_DEL_BUFFERS
773: --WHERE request_id = p_request_id;
774:
775: --IEX_CONC_REQUEST_MSG_PKG.LOG_ERROR(p_request_id, 'MANAGE_DELINQUENCIES',ERRBUF);
776: --

Line 868: --DELETE FROM IEX_DEL_BUFFERS

864: --
865:
866: CLEAR_BUFFERS2(p_request_id);
867:
868: --DELETE FROM IEX_DEL_BUFFERS
869: --WHERE request_id = p_request_id ;
870:
871: --IEX_CONC_REQUEST_MSG_PKG.LOG_ERROR(p_request_id, 'MANAGE_DELINQUENCIES',ERRBUF) ;
872: --

Line 985: IEX_DEL_BUFFERS IDB ,

981: IDB.score_id ,
982: IDB.score_value ,
983: p_Request_id
984: FROM HZ_CUST_ACCOUNTS HZCA ,
985: IEX_DEL_BUFFERS IDB ,
986: AR_PAYMENT_SCHEDULES ARPS ,
987: IEX_DEL_STATUSES IDS
988: WHERE
989: NOT EXISTS

Line 1049: --DELETE FROM IEX_DEL_BUFFERS

1045: --
1046:
1047: CLEAR_BUFFERS2(p_request_id);
1048:
1049: --DELETE FROM IEX_DEL_BUFFERS
1050: --WHERE request_id = p_request_id ;
1051: --
1052: -- End - 01/24/2005 - Andre Araujo - This procedure uses a memory schema uses up all memory available for the session, changing it to chunks
1053: --

Line 1086: iex_del_buffers idb,

1082:
1083: SELECT ico.object_id, ids.del_status, ico.delinquency_status
1084: BULK COLLECT INTO vt_contract_id, vt_buf_status, vt_del_status
1085: FROM iex_case_objects ico,
1086: iex_del_buffers idb,
1087: iex_del_statuses ids
1088: WHERE idb.score_id = ids.score_id
1089: AND idb.score_value BETWEEN ids.score_value_low and ids.score_value_high
1090: AND idb.score_object_id = ico.object_id

Line 1217: iex_del_buffers idb,

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
1221: (select 1

Line 1234: iex_del_buffers idb,

1230: */
1231: SELECT ic.cas_id, ids.del_status, ic.status_code
1232: BULK COLLECT INTO vt_case_id, vt_buf_status, vt_del_status
1233: FROM iex_cases_all_b ic,
1234: iex_del_buffers idb,
1235: iex_del_statuses ids
1236: WHERE idb.score_id = ids.score_id
1237: AND idb.score_value BETWEEN ids.score_value_low and ids.score_value_high
1238: AND idb.score_object_id = ic.cas_id

Line 1288: --DELETE FROM IEX_DEL_BUFFERS

1284: --
1285:
1286: CLEAR_BUFFERS2(p_request_id);
1287:
1288: --DELETE FROM IEX_DEL_BUFFERS
1289: --WHERE request_id = p_request_id ;
1290: --
1291: -- End - 01/24/2005 - Andre Araujo - This procedure uses a memory schema uses up all memory available for the session, changing it to chunks
1292: --

Line 1379: --DELETE FROM IEX_DEL_BUFFERS

1375: --
1376:
1377: CLEAR_BUFFERS2(p_request_id);
1378:
1379: --DELETE FROM IEX_DEL_BUFFERS
1380: --WHERE request_id = p_request_id ;
1381: --
1382: -- End - 01/24/2005 - Andre Araujo - This procedure uses a memory schema uses up all memory available for the session, changing it to chunks
1383: --

Line 1439: FROM IEX_DEL_BUFFERS IDB,

1435: l_source_module,
1436: IDB.Score_id,
1437: IDB.score_value ,
1438: p_REQUEST_ID
1439: FROM IEX_DEL_BUFFERS IDB,
1440: IEX_CASES_VL ICV,
1441: IEX_CASE_DEFINITIONS ICD,
1442: IEX_CASES_VL ICV2,
1443: IEX_CASE_DEFINITIONS ICD2,

Line 1506: --DELETE FROM IEX_DEL_BUFFERS

1502: --
1503:
1504: CLEAR_BUFFERS2(p_request_id);
1505:
1506: --DELETE FROM IEX_DEL_BUFFERS
1507: --WHERE request_id = p_request_id ;
1508: --
1509: -- End - 01/24/2005 - Andre Araujo - This procedure uses a memory schema uses up all memory available for the session, changing it to chunks
1510: --

Line 1627: --DELETE FROM IEX_DEL_BUFFERS WHERE request_id = p_request_id ;

1623: --
1624: -- Begin - 01/24/2005 - Andre Araujo - This procedure uses a memory schema uses up all memory available for the session, changing it to chunks
1625: --
1626: CLEAR_BUFFERS2(p_request_id);
1627: --DELETE FROM IEX_DEL_BUFFERS WHERE request_id = p_request_id ;
1628: --
1629: -- End - 01/24/2005 - Andre Araujo - This procedure uses a memory schema uses up all memory available for the session, changing it to chunks
1630: --
1631: -- IF PG_DEBUG < 10 THEN

Line 1864: --DELETE FROM IEX_DEL_BUFFERS WHERE request_id = p_request_id ;

1860: --
1861: -- Begin - 01/24/2005 - Andre Araujo - This procedure uses a memory schema uses up all memory available for the session, changing it to chunks
1862: --
1863: CLEAR_BUFFERS2(p_request_id);
1864: --DELETE FROM IEX_DEL_BUFFERS WHERE request_id = p_request_id ;
1865: --
1866: -- End - 01/24/2005 - Andre Araujo - This procedure uses a memory schema uses up all memory available for the session, changing it to chunks
1867: --
1868:

Line 2114: || Source Tables: IEX_DEL_BUFFERS

2110: || scoring engine for delinquencies is run
2111: ||
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

Line 2139: from iex_del_buffers

2135: cursor c_scores(p_request_id in number)
2136: is
2137: select score_object_id,
2138: score_value
2139: from iex_del_buffers
2140: where request_id = p_request_id;
2141: BEGIN
2142:
2143: RETCODE := 0;

Line 2155: from iex_del_buffers

2151: iex_debug_pub.logMessage('SCORE_DELINQUENCIES: ' || 'StartTime: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
2152: END IF;
2153: -- get the score id for the engine
2154: Select score_id into l_score_id
2155: from iex_del_buffers
2156: Where request_id = p_request_id and
2157: rownum = 1;
2158:
2159: -- IF PG_DEBUG < 10 THEN

Line 2211: FROM iex_del_buffers

2207: SELECT score_object_id,
2208: score_value
2209: BULK COLLECT INTO
2210: LIMIT NVL(FND_PROFILE.VALUE('IEX_BATCH_SIZE'), 1000)
2211: FROM iex_del_buffers
2212: WHERE request_id = p_request_id;
2213: */
2214: -- IF PG_DEBUG < 10 THEN
2215: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2222: --Delete From IEX_DEL_BUFFERS

2218: --
2219: -- Begin - 01/24/2005 - Andre Araujo - This procedure uses a memory schema uses up all memory available for the session, changing it to chunks
2220: --
2221: CLEAR_BUFFERS2(p_request_id);
2222: --Delete From IEX_DEL_BUFFERS
2223: -- Where request_id = p_request_id;
2224: --
2225: -- End - 01/24/2005 - Andre Araujo - This procedure uses a memory schema uses up all memory available for the session, changing it to chunks
2226: --

Line 2835: || Target Tables: IEX_DEL_BUFFERS

2831: || Parameter: P_REQUEST is the request Id we need to delete, if it is -1 we delete the whole table
2832: ||
2833: || Source Tables: None
2834: ||
2835: || Target Tables: IEX_DEL_BUFFERS
2836: ||
2837: || Creation date: 01/25/05 3:29:PM
2838: ||
2839: || Major Modifications: when who what

Line 2849: --For big customers delete from IEX_DEL_BUFFERS process takes hours

2845: iSize number;
2846: i number;
2847:
2848: --Begin base bug 6902192 barathsr 13-Nov-2008
2849: --For big customers delete from IEX_DEL_BUFFERS process takes hours
2850:
2851: l_del_count number;
2852: l_truncate_table VARCHAR2(60);
2853:

Line 2876: IEX_DEBUG_PUB.logMessage('IEX: Clear Delinquency Buffers Table cp is running and IEX: Scoring Engine Harness cp is not running, so truncating IEX_DEL_BUFFERS table...');

2872: FND_FILE.PUT_LINE(FND_FILE.LOG,'Running IEXDLMGB count = ' || l_del_count);
2873:
2874: if (((p_request = -1) and (l_del_count = 0)) OR ((p_request <> -1) and (l_del_count <= 2))) then
2875: if ((p_request = -1) and (l_del_count = 0)) then
2876: IEX_DEBUG_PUB.logMessage('IEX: Clear Delinquency Buffers Table cp is running and IEX: Scoring Engine Harness cp is not running, so truncating IEX_DEL_BUFFERS table...');
2877: FND_FILE.PUT_LINE(FND_FILE.LOG,'IEX: Clear Delinquency Buffers Table cp is running and IEX: Scoring Engine Harness cp is not running, so truncating IEX_DEL_BUFFERS table...');
2878: else
2879: IEX_DEBUG_PUB.logMessage('This is the last running instance of IEXDLMGB - truncating IEX_DEL_BUFFERS table...');
2880: FND_FILE.PUT_LINE(FND_FILE.LOG,'This is the last running instance of IEXDLMGB - truncating IEX_DEL_BUFFERS table...');

Line 2877: FND_FILE.PUT_LINE(FND_FILE.LOG,'IEX: Clear Delinquency Buffers Table cp is running and IEX: Scoring Engine Harness cp is not running, so truncating IEX_DEL_BUFFERS table...');

2873:
2874: if (((p_request = -1) and (l_del_count = 0)) OR ((p_request <> -1) and (l_del_count <= 2))) then
2875: if ((p_request = -1) and (l_del_count = 0)) then
2876: IEX_DEBUG_PUB.logMessage('IEX: Clear Delinquency Buffers Table cp is running and IEX: Scoring Engine Harness cp is not running, so truncating IEX_DEL_BUFFERS table...');
2877: FND_FILE.PUT_LINE(FND_FILE.LOG,'IEX: Clear Delinquency Buffers Table cp is running and IEX: Scoring Engine Harness cp is not running, so truncating IEX_DEL_BUFFERS table...');
2878: else
2879: IEX_DEBUG_PUB.logMessage('This is the last running instance of IEXDLMGB - truncating IEX_DEL_BUFFERS table...');
2880: FND_FILE.PUT_LINE(FND_FILE.LOG,'This is the last running instance of IEXDLMGB - truncating IEX_DEL_BUFFERS table...');
2881: end if;

Line 2879: IEX_DEBUG_PUB.logMessage('This is the last running instance of IEXDLMGB - truncating IEX_DEL_BUFFERS table...');

2875: if ((p_request = -1) and (l_del_count = 0)) then
2876: IEX_DEBUG_PUB.logMessage('IEX: Clear Delinquency Buffers Table cp is running and IEX: Scoring Engine Harness cp is not running, so truncating IEX_DEL_BUFFERS table...');
2877: FND_FILE.PUT_LINE(FND_FILE.LOG,'IEX: Clear Delinquency Buffers Table cp is running and IEX: Scoring Engine Harness cp is not running, so truncating IEX_DEL_BUFFERS table...');
2878: else
2879: IEX_DEBUG_PUB.logMessage('This is the last running instance of IEXDLMGB - truncating IEX_DEL_BUFFERS table...');
2880: FND_FILE.PUT_LINE(FND_FILE.LOG,'This is the last running instance of IEXDLMGB - truncating IEX_DEL_BUFFERS table...');
2881: end if;
2882: --select OWNER || '.' || TABLE_NAME into l_truncate_table from sys.all_tables where table_name = 'IEX_DEL_BUFFERS';
2883: --EXECUTE IMMEDIATE 'truncate table ' || l_truncate_table;

Line 2880: FND_FILE.PUT_LINE(FND_FILE.LOG,'This is the last running instance of IEXDLMGB - truncating IEX_DEL_BUFFERS table...');

2876: IEX_DEBUG_PUB.logMessage('IEX: Clear Delinquency Buffers Table cp is running and IEX: Scoring Engine Harness cp is not running, so truncating IEX_DEL_BUFFERS table...');
2877: FND_FILE.PUT_LINE(FND_FILE.LOG,'IEX: Clear Delinquency Buffers Table cp is running and IEX: Scoring Engine Harness cp is not running, so truncating IEX_DEL_BUFFERS table...');
2878: else
2879: IEX_DEBUG_PUB.logMessage('This is the last running instance of IEXDLMGB - truncating IEX_DEL_BUFFERS table...');
2880: FND_FILE.PUT_LINE(FND_FILE.LOG,'This is the last running instance of IEXDLMGB - truncating IEX_DEL_BUFFERS table...');
2881: end if;
2882: --select OWNER || '.' || TABLE_NAME into l_truncate_table from sys.all_tables where table_name = 'IEX_DEL_BUFFERS';
2883: --EXECUTE IMMEDIATE 'truncate table ' || l_truncate_table;
2884: x := fnd_installation.get_app_info ('FND',l_out_status,l_out_industry,l_out_oracle_schema);

Line 2882: --select OWNER || '.' || TABLE_NAME into l_truncate_table from sys.all_tables where table_name = 'IEX_DEL_BUFFERS';

2878: else
2879: IEX_DEBUG_PUB.logMessage('This is the last running instance of IEXDLMGB - truncating IEX_DEL_BUFFERS table...');
2880: FND_FILE.PUT_LINE(FND_FILE.LOG,'This is the last running instance of IEXDLMGB - truncating IEX_DEL_BUFFERS table...');
2881: end if;
2882: --select OWNER || '.' || TABLE_NAME into l_truncate_table from sys.all_tables where table_name = 'IEX_DEL_BUFFERS';
2883: --EXECUTE IMMEDIATE 'truncate table ' || l_truncate_table;
2884: x := fnd_installation.get_app_info ('FND',l_out_status,l_out_industry,l_out_oracle_schema);
2885:
2886: IEX_DEBUG_PUB.logMessage('IEX Schema:'||l_out_oracle_schema);

Line 2888: IEX_DEBUG_PUB.LogMessage('Truncating IEX_DEL_BUFFERS');

2884: x := fnd_installation.get_app_info ('FND',l_out_status,l_out_industry,l_out_oracle_schema);
2885:
2886: IEX_DEBUG_PUB.logMessage('IEX Schema:'||l_out_oracle_schema);
2887:
2888: IEX_DEBUG_PUB.LogMessage('Truncating IEX_DEL_BUFFERS');
2889:
2890: ad_ddl.do_ddl( l_out_oracle_schema,
2891: 'IEX',
2892: AD_DDL.TRUNCATE_TABLE,

Line 2893: 'TRUNCATE TABLE IEX_DEL_BUFFERS',

2889:
2890: ad_ddl.do_ddl( l_out_oracle_schema,
2891: 'IEX',
2892: AD_DDL.TRUNCATE_TABLE,
2893: 'TRUNCATE TABLE IEX_DEL_BUFFERS',
2894: 'IEX_DEL_BUFFERS' );
2895:
2896: IEX_DEBUG_PUB.LogMessage('Truncated IEX_DEL_BUFFERS');
2897: IEX_DEBUG_PUB.logMessage('Done');

Line 2894: 'IEX_DEL_BUFFERS' );

2890: ad_ddl.do_ddl( l_out_oracle_schema,
2891: 'IEX',
2892: AD_DDL.TRUNCATE_TABLE,
2893: 'TRUNCATE TABLE IEX_DEL_BUFFERS',
2894: 'IEX_DEL_BUFFERS' );
2895:
2896: IEX_DEBUG_PUB.LogMessage('Truncated IEX_DEL_BUFFERS');
2897: IEX_DEBUG_PUB.logMessage('Done');
2898: else

Line 2896: IEX_DEBUG_PUB.LogMessage('Truncated IEX_DEL_BUFFERS');

2892: AD_DDL.TRUNCATE_TABLE,
2893: 'TRUNCATE TABLE IEX_DEL_BUFFERS',
2894: 'IEX_DEL_BUFFERS' );
2895:
2896: IEX_DEBUG_PUB.LogMessage('Truncated IEX_DEL_BUFFERS');
2897: IEX_DEBUG_PUB.logMessage('Done');
2898: else
2899: IEX_DEBUG_PUB.logMessage('There are other running instances of IEXDLMGB - quiting');
2900: FND_FILE.PUT_LINE(FND_FILE.LOG,'There are other running instances of IEXDLMGB - quiting');