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.ISC_DBI_BOOK_SUM2_REF_PKG dependencies on FII_UTIL

Line 24: FII_UTIL.Start_Timer;

20:
21: BIS_COLLECTION_UTILITIES.put_line(' ');
22: BIS_COLLECTION_UTILITIES.put_line('Start to Refresh '|| p_mview_name);
23:
24: FII_UTIL.Start_Timer;
25:
26: DBMS_MVIEW.REFRESH(
27: list => p_mview_name,
28: method => '?',

Line 32: FII_UTIL.Stop_Timer;

28: method => '?',
29: parallelism => l_degree
30: );
31:
32: FII_UTIL.Stop_Timer;
33: FII_UTIL.Print_Timer(p_mview_name || ' has been refreshed in ');
34:
35: l_sql_stmt := 'SELECT count(*) FROM ' || p_mview_name ;
36: EXECUTE IMMEDIATE l_sql_stmt INTO l_row_count;

Line 33: FII_UTIL.Print_Timer(p_mview_name || ' has been refreshed in ');

29: parallelism => l_degree
30: );
31:
32: FII_UTIL.Stop_Timer;
33: FII_UTIL.Print_Timer(p_mview_name || ' has been refreshed in ');
34:
35: l_sql_stmt := 'SELECT count(*) FROM ' || p_mview_name ;
36: EXECUTE IMMEDIATE l_sql_stmt INTO l_row_count;
37:

Line 76: FII_UTIL.Start_Timer;

72: l_to_date := sysdate;
73:
74: BIS_COLLECTION_UTILITIES.put_line('Updating ISC_BOOK_SUM2_PDUE_F');
75:
76: FII_UTIL.Start_Timer;
77:
78: UPDATE isc_book_sum2_pdue_f
79: SET time_snapshot_date_id = to_date('1000/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS')
80: WHERE time_snapshot_date_id = trunc(sysdate);

Line 82: FII_UTIL.Stop_Timer;

78: UPDATE isc_book_sum2_pdue_f
79: SET time_snapshot_date_id = to_date('1000/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS')
80: WHERE time_snapshot_date_id = trunc(sysdate);
81:
82: FII_UTIL.Stop_Timer;
83: FII_UTIL.Print_Timer('Obsoleted ' || sql%rowcount || ' rows in ISC_BOOK_SUM2_PDUE_F in');
84:
85: BIS_COLLECTION_UTILITIES.put_line(' ');
86: BIS_COLLECTION_UTILITIES.put_line('Inserting data into ISC_BOOK_SUM2_PDUE_F');

Line 83: FII_UTIL.Print_Timer('Obsoleted ' || sql%rowcount || ' rows in ISC_BOOK_SUM2_PDUE_F in');

79: SET time_snapshot_date_id = to_date('1000/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS')
80: WHERE time_snapshot_date_id = trunc(sysdate);
81:
82: FII_UTIL.Stop_Timer;
83: FII_UTIL.Print_Timer('Obsoleted ' || sql%rowcount || ' rows in ISC_BOOK_SUM2_PDUE_F in');
84:
85: BIS_COLLECTION_UTILITIES.put_line(' ');
86: BIS_COLLECTION_UTILITIES.put_line('Inserting data into ISC_BOOK_SUM2_PDUE_F');
87:

Line 88: FII_UTIL.Start_Timer;

84:
85: BIS_COLLECTION_UTILITIES.put_line(' ');
86: BIS_COLLECTION_UTILITIES.put_line('Inserting data into ISC_BOOK_SUM2_PDUE_F');
87:
88: FII_UTIL.Start_Timer;
89:
90: INSERT INTO isc_book_sum2_pdue_f(
91: INV_ORG_ID,
92: INVENTORY_ITEM_ID,

Line 129: FII_UTIL.Stop_Timer;

125: WHERE time_schedule_date_id < trunc(sysdate);
126:
127: l_row_count := l_row_count + sql%rowcount;
128:
129: FII_UTIL.Stop_Timer;
130: FII_UTIL.Print_Timer('Inserted ' || l_row_count || ' rows into ISC_BOOK_SUM2_PDUE_F in');
131:
132: BIS_COLLECTION_UTILITIES.WRAPUP(
133: TRUE,

Line 130: FII_UTIL.Print_Timer('Inserted ' || l_row_count || ' rows into ISC_BOOK_SUM2_PDUE_F in');

126:
127: l_row_count := l_row_count + sql%rowcount;
128:
129: FII_UTIL.Stop_Timer;
130: FII_UTIL.Print_Timer('Inserted ' || l_row_count || ' rows into ISC_BOOK_SUM2_PDUE_F in');
131:
132: BIS_COLLECTION_UTILITIES.WRAPUP(
133: TRUE,
134: l_row_count,

Line 196: FII_UTIL.Start_Timer;

192: l_to_date := sysdate;
193:
194: BIS_COLLECTION_UTILITIES.put_line('Updating ISC_BOOK_SUM2_PDUE2_F');
195:
196: FII_UTIL.Start_Timer;
197:
198: UPDATE isc_book_sum2_pdue2_f
199: SET time_snapshot_date_id = to_date('1000/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS')
200: WHERE time_snapshot_date_id = trunc(sysdate);

Line 202: FII_UTIL.Stop_Timer;

198: UPDATE isc_book_sum2_pdue2_f
199: SET time_snapshot_date_id = to_date('1000/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS')
200: WHERE time_snapshot_date_id = trunc(sysdate);
201:
202: FII_UTIL.Stop_Timer;
203: FII_UTIL.Print_Timer('Obsoleted ' || sql%rowcount || ' rows in ISC_BOOK_SUM2_PDUE2_F in');
204:
205: BIS_COLLECTION_UTILITIES.put_line(' ');
206: BIS_COLLECTION_UTILITIES.put_line('Inserting data into ISC_BOOK_SUM2_PDUE2_F');

Line 203: FII_UTIL.Print_Timer('Obsoleted ' || sql%rowcount || ' rows in ISC_BOOK_SUM2_PDUE2_F in');

199: SET time_snapshot_date_id = to_date('1000/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS')
200: WHERE time_snapshot_date_id = trunc(sysdate);
201:
202: FII_UTIL.Stop_Timer;
203: FII_UTIL.Print_Timer('Obsoleted ' || sql%rowcount || ' rows in ISC_BOOK_SUM2_PDUE2_F in');
204:
205: BIS_COLLECTION_UTILITIES.put_line(' ');
206: BIS_COLLECTION_UTILITIES.put_line('Inserting data into ISC_BOOK_SUM2_PDUE2_F');
207:

Line 208: FII_UTIL.Start_Timer;

204:
205: BIS_COLLECTION_UTILITIES.put_line(' ');
206: BIS_COLLECTION_UTILITIES.put_line('Inserting data into ISC_BOOK_SUM2_PDUE2_F');
207:
208: FII_UTIL.Start_Timer;
209:
210: INSERT INTO isc_book_sum2_pdue2_f(
211: INV_ORG_ID,
212: INVENTORY_ITEM_ID,

Line 265: FII_UTIL.Stop_Timer;

261: WHERE (time_schedule_date_id < trunc(sysdate) OR time_promise_date_id < trunc(sysdate));
262:
263: l_row_count := l_row_count + sql%rowcount;
264:
265: FII_UTIL.Stop_Timer;
266: FII_UTIL.Print_Timer('Inserted ' || l_row_count || ' rows into ISC_BOOK_SUM2_PDUE2_F in');
267:
268: BIS_COLLECTION_UTILITIES.WRAPUP(
269: TRUE,

Line 266: FII_UTIL.Print_Timer('Inserted ' || l_row_count || ' rows into ISC_BOOK_SUM2_PDUE2_F in');

262:
263: l_row_count := l_row_count + sql%rowcount;
264:
265: FII_UTIL.Stop_Timer;
266: FII_UTIL.Print_Timer('Inserted ' || l_row_count || ' rows into ISC_BOOK_SUM2_PDUE2_F in');
267:
268: BIS_COLLECTION_UTILITIES.WRAPUP(
269: TRUE,
270: l_row_count,

Line 332: FII_UTIL.Start_Timer;

328: l_to_date := sysdate;
329:
330: BIS_COLLECTION_UTILITIES.put_line('Updating ISC_BOOK_SUM2_BKORD_F');
331:
332: FII_UTIL.Start_Timer;
333:
334: UPDATE isc_book_sum2_bkord_f
335: SET time_snapshot_date_id = to_date('1000/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS')
336: WHERE time_snapshot_date_id = trunc(sysdate);

Line 338: FII_UTIL.Stop_Timer;

334: UPDATE isc_book_sum2_bkord_f
335: SET time_snapshot_date_id = to_date('1000/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS')
336: WHERE time_snapshot_date_id = trunc(sysdate);
337:
338: FII_UTIL.Stop_Timer;
339: FII_UTIL.Print_Timer('Obsoleted ' || sql%rowcount || ' rows in ISC_BOOK_SUM2_BKORD_F in');
340:
341: BIS_COLLECTION_UTILITIES.put_line(' ');
342: BIS_COLLECTION_UTILITIES.put_line('Inserting data into ISC_BOOK_SUM2_BKORD_F');

Line 339: FII_UTIL.Print_Timer('Obsoleted ' || sql%rowcount || ' rows in ISC_BOOK_SUM2_BKORD_F in');

335: SET time_snapshot_date_id = to_date('1000/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS')
336: WHERE time_snapshot_date_id = trunc(sysdate);
337:
338: FII_UTIL.Stop_Timer;
339: FII_UTIL.Print_Timer('Obsoleted ' || sql%rowcount || ' rows in ISC_BOOK_SUM2_BKORD_F in');
340:
341: BIS_COLLECTION_UTILITIES.put_line(' ');
342: BIS_COLLECTION_UTILITIES.put_line('Inserting data into ISC_BOOK_SUM2_BKORD_F');
343:

Line 344: FII_UTIL.Start_Timer;

340:
341: BIS_COLLECTION_UTILITIES.put_line(' ');
342: BIS_COLLECTION_UTILITIES.put_line('Inserting data into ISC_BOOK_SUM2_BKORD_F');
343:
344: FII_UTIL.Start_Timer;
345:
346: INSERT INTO isc_book_sum2_bkord_f(
347: INV_ORG_ID,
348: INVENTORY_ITEM_ID,

Line 398: FII_UTIL.Stop_Timer;

394: AND fact.charge_periodicity_code is NULL;
395:
396: l_row_count := l_row_count + sql%rowcount;
397:
398: FII_UTIL.Stop_Timer;
399: FII_UTIL.Print_Timer('Inserted ' || l_row_count || ' rows into ISC_BOOK_SUM2_BKORD_F in');
400:
401: BIS_COLLECTION_UTILITIES.WRAPUP(
402: TRUE,

Line 399: FII_UTIL.Print_Timer('Inserted ' || l_row_count || ' rows into ISC_BOOK_SUM2_BKORD_F in');

395:
396: l_row_count := l_row_count + sql%rowcount;
397:
398: FII_UTIL.Stop_Timer;
399: FII_UTIL.Print_Timer('Inserted ' || l_row_count || ' rows into ISC_BOOK_SUM2_BKORD_F in');
400:
401: BIS_COLLECTION_UTILITIES.WRAPUP(
402: TRUE,
403: l_row_count,