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 BIS_COLLECTION_UTILITIES

Line 19: BIS_COLLECTION_UTILITIES.put_line('The degree of parallelism is '|| l_degree);

15:
16: BEGIN
17:
18: l_degree := bis_common_parameters.get_degree_of_parallelism;
19: BIS_COLLECTION_UTILITIES.put_line('The degree of parallelism is '|| l_degree);
20:
21: BIS_COLLECTION_UTILITIES.put_line(' ');
22: BIS_COLLECTION_UTILITIES.put_line('Start to Refresh '|| p_mview_name);
23:

Line 21: BIS_COLLECTION_UTILITIES.put_line(' ');

17:
18: l_degree := bis_common_parameters.get_degree_of_parallelism;
19: BIS_COLLECTION_UTILITIES.put_line('The degree of parallelism is '|| l_degree);
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:

Line 22: BIS_COLLECTION_UTILITIES.put_line('Start to Refresh '|| p_mview_name);

18: l_degree := bis_common_parameters.get_degree_of_parallelism;
19: BIS_COLLECTION_UTILITIES.put_line('The degree of parallelism is '|| l_degree);
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(

Line 38: BIS_COLLECTION_UTILITIES.put_line(p_mview_name ||' has '||l_row_count||' rows.');

34:
35: l_sql_stmt := 'SELECT count(*) FROM ' || p_mview_name ;
36: EXECUTE IMMEDIATE l_sql_stmt INTO l_row_count;
37:
38: BIS_COLLECTION_UTILITIES.put_line(p_mview_name ||' has '||l_row_count||' rows.');
39:
40: RETURN(l_row_count);
41:
42: EXCEPTION

Line 45: BIS_COLLECTION_UTILITIES.put_line('Errored while refreshing '|| p_mview_name);

41:
42: EXCEPTION
43:
44: WHEN OTHERS THEN
45: BIS_COLLECTION_UTILITIES.put_line('Errored while refreshing '|| p_mview_name);
46: g_errbuf := sqlerrm ||' - '||sqlcode;
47: RETURN(-1);
48:
49: END refresh_mv;

Line 66: IF (Not BIS_COLLECTION_UTILITIES.setup('ISC_BOOK_SUM2_PDUE_F')) THEN

62: BEGIN
63: errbuf := NULL;
64: retcode := '0';
65:
66: IF (Not BIS_COLLECTION_UTILITIES.setup('ISC_BOOK_SUM2_PDUE_F')) THEN
67: RAISE_APPLICATION_ERROR (-20000,'Error in SETUP: ' || errbuf);
68: return;
69: END IF;
70:

Line 71: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('ISC_BOOK_SUM2_PDUE_F', l_start, l_end, l_period_from, l_from_date);

67: RAISE_APPLICATION_ERROR (-20000,'Error in SETUP: ' || errbuf);
68: return;
69: END IF;
70:
71: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('ISC_BOOK_SUM2_PDUE_F', l_start, l_end, l_period_from, l_from_date);
72: l_to_date := sysdate;
73:
74: BIS_COLLECTION_UTILITIES.put_line('Updating ISC_BOOK_SUM2_PDUE_F');
75:

Line 74: BIS_COLLECTION_UTILITIES.put_line('Updating ISC_BOOK_SUM2_PDUE_F');

70:
71: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('ISC_BOOK_SUM2_PDUE_F', l_start, l_end, l_period_from, l_from_date);
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

Line 85: BIS_COLLECTION_UTILITIES.put_line(' ');

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:
88: FII_UTIL.Start_Timer;
89:

Line 86: BIS_COLLECTION_UTILITIES.put_line('Inserting data into ISC_BOOK_SUM2_PDUE_F');

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:
88: FII_UTIL.Start_Timer;
89:
90: INSERT INTO isc_book_sum2_pdue_f(

Line 132: BIS_COLLECTION_UTILITIES.WRAPUP(

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,
135: NULL,
136: l_from_date,

Line 144: BIS_COLLECTION_UTILITIES.put_line(g_errbuf);

140: EXCEPTION
141:
142: WHEN L_FAILURE THEN
143: ROLLBACK;
144: BIS_COLLECTION_UTILITIES.put_line(g_errbuf);
145: retcode := -1;
146:
147: BIS_COLLECTION_UTILITIES.WRAPUP(
148: FALSE,

Line 147: BIS_COLLECTION_UTILITIES.WRAPUP(

143: ROLLBACK;
144: BIS_COLLECTION_UTILITIES.put_line(g_errbuf);
145: retcode := -1;
146:
147: BIS_COLLECTION_UTILITIES.WRAPUP(
148: FALSE,
149: l_row_count,
150: g_errbuf,
151: l_from_date,

Line 158: BIS_COLLECTION_UTILITIES.put_line('Other errors : '|| errbuf);

154:
155: WHEN OTHERS THEN
156: ROLLBACK;
157: errbuf := sqlerrm ||' - '||sqlcode;
158: BIS_COLLECTION_UTILITIES.put_line('Other errors : '|| errbuf);
159: retcode := -1;
160:
161: BIS_COLLECTION_UTILITIES.WRAPUP(
162: FALSE,

Line 161: BIS_COLLECTION_UTILITIES.WRAPUP(

157: errbuf := sqlerrm ||' - '||sqlcode;
158: BIS_COLLECTION_UTILITIES.put_line('Other errors : '|| errbuf);
159: retcode := -1;
160:
161: BIS_COLLECTION_UTILITIES.WRAPUP(
162: FALSE,
163: l_row_count,
164: errbuf,
165: l_from_date,

Line 186: IF (Not BIS_COLLECTION_UTILITIES.setup('ISC_BOOK_SUM2_PDUE2_F')) THEN

182: BEGIN
183: errbuf := NULL;
184: retcode := '0';
185:
186: IF (Not BIS_COLLECTION_UTILITIES.setup('ISC_BOOK_SUM2_PDUE2_F')) THEN
187: RAISE_APPLICATION_ERROR (-20000,'Error in SETUP: ' || errbuf);
188: return;
189: END IF;
190:

Line 191: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('ISC_BOOK_SUM2_PDUE2_F', l_start, l_end, l_period_from, l_from_date);

187: RAISE_APPLICATION_ERROR (-20000,'Error in SETUP: ' || errbuf);
188: return;
189: END IF;
190:
191: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('ISC_BOOK_SUM2_PDUE2_F', l_start, l_end, l_period_from, l_from_date);
192: l_to_date := sysdate;
193:
194: BIS_COLLECTION_UTILITIES.put_line('Updating ISC_BOOK_SUM2_PDUE2_F');
195:

Line 194: BIS_COLLECTION_UTILITIES.put_line('Updating ISC_BOOK_SUM2_PDUE2_F');

190:
191: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('ISC_BOOK_SUM2_PDUE2_F', l_start, l_end, l_period_from, l_from_date);
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

Line 205: BIS_COLLECTION_UTILITIES.put_line(' ');

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:
208: FII_UTIL.Start_Timer;
209:

Line 206: BIS_COLLECTION_UTILITIES.put_line('Inserting data into ISC_BOOK_SUM2_PDUE2_F');

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:
208: FII_UTIL.Start_Timer;
209:
210: INSERT INTO isc_book_sum2_pdue2_f(

Line 268: BIS_COLLECTION_UTILITIES.WRAPUP(

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,
271: NULL,
272: l_from_date,

Line 280: BIS_COLLECTION_UTILITIES.put_line(g_errbuf);

276: EXCEPTION
277:
278: WHEN L_FAILURE THEN
279: ROLLBACK;
280: BIS_COLLECTION_UTILITIES.put_line(g_errbuf);
281: retcode := -1;
282:
283: BIS_COLLECTION_UTILITIES.WRAPUP(
284: FALSE,

Line 283: BIS_COLLECTION_UTILITIES.WRAPUP(

279: ROLLBACK;
280: BIS_COLLECTION_UTILITIES.put_line(g_errbuf);
281: retcode := -1;
282:
283: BIS_COLLECTION_UTILITIES.WRAPUP(
284: FALSE,
285: l_row_count,
286: g_errbuf,
287: l_from_date,

Line 294: BIS_COLLECTION_UTILITIES.put_line('Other errors : '|| errbuf);

290:
291: WHEN OTHERS THEN
292: ROLLBACK;
293: errbuf := sqlerrm ||' - '||sqlcode;
294: BIS_COLLECTION_UTILITIES.put_line('Other errors : '|| errbuf);
295: retcode := -1;
296:
297: BIS_COLLECTION_UTILITIES.WRAPUP(
298: FALSE,

Line 297: BIS_COLLECTION_UTILITIES.WRAPUP(

293: errbuf := sqlerrm ||' - '||sqlcode;
294: BIS_COLLECTION_UTILITIES.put_line('Other errors : '|| errbuf);
295: retcode := -1;
296:
297: BIS_COLLECTION_UTILITIES.WRAPUP(
298: FALSE,
299: l_row_count,
300: errbuf,
301: l_from_date,

Line 322: IF (Not BIS_COLLECTION_UTILITIES.setup('ISC_BOOK_SUM2_BKORD_F')) THEN

318: BEGIN
319: errbuf := NULL;
320: retcode := '0';
321:
322: IF (Not BIS_COLLECTION_UTILITIES.setup('ISC_BOOK_SUM2_BKORD_F')) THEN
323: RAISE_APPLICATION_ERROR (-20000,'Error in SETUP: ' || errbuf);
324: return;
325: END IF;
326:

Line 327: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('ISC_BOOK_SUM2_BKORD_F', l_start, l_end, l_period_from, l_from_date);

323: RAISE_APPLICATION_ERROR (-20000,'Error in SETUP: ' || errbuf);
324: return;
325: END IF;
326:
327: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('ISC_BOOK_SUM2_BKORD_F', l_start, l_end, l_period_from, l_from_date);
328: l_to_date := sysdate;
329:
330: BIS_COLLECTION_UTILITIES.put_line('Updating ISC_BOOK_SUM2_BKORD_F');
331:

Line 330: BIS_COLLECTION_UTILITIES.put_line('Updating ISC_BOOK_SUM2_BKORD_F');

326:
327: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('ISC_BOOK_SUM2_BKORD_F', l_start, l_end, l_period_from, l_from_date);
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

Line 341: BIS_COLLECTION_UTILITIES.put_line(' ');

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:
344: FII_UTIL.Start_Timer;
345:

Line 342: BIS_COLLECTION_UTILITIES.put_line('Inserting data into ISC_BOOK_SUM2_BKORD_F');

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:
344: FII_UTIL.Start_Timer;
345:
346: INSERT INTO isc_book_sum2_bkord_f(

Line 401: BIS_COLLECTION_UTILITIES.WRAPUP(

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,
404: NULL,
405: l_from_date,

Line 413: BIS_COLLECTION_UTILITIES.put_line(g_errbuf);

409: EXCEPTION
410:
411: WHEN L_FAILURE THEN
412: ROLLBACK;
413: BIS_COLLECTION_UTILITIES.put_line(g_errbuf);
414: retcode := -1;
415:
416: BIS_COLLECTION_UTILITIES.WRAPUP(
417: FALSE,

Line 416: BIS_COLLECTION_UTILITIES.WRAPUP(

412: ROLLBACK;
413: BIS_COLLECTION_UTILITIES.put_line(g_errbuf);
414: retcode := -1;
415:
416: BIS_COLLECTION_UTILITIES.WRAPUP(
417: FALSE,
418: l_row_count,
419: g_errbuf,
420: l_from_date,

Line 427: BIS_COLLECTION_UTILITIES.put_line('Other errors : '|| errbuf);

423:
424: WHEN OTHERS THEN
425: ROLLBACK;
426: errbuf := sqlerrm ||' - '||sqlcode;
427: BIS_COLLECTION_UTILITIES.put_line('Other errors : '|| errbuf);
428: retcode := -1;
429:
430: BIS_COLLECTION_UTILITIES.WRAPUP(
431: FALSE,

Line 430: BIS_COLLECTION_UTILITIES.WRAPUP(

426: errbuf := sqlerrm ||' - '||sqlcode;
427: BIS_COLLECTION_UTILITIES.put_line('Other errors : '|| errbuf);
428: retcode := -1;
429:
430: BIS_COLLECTION_UTILITIES.WRAPUP(
431: FALSE,
432: l_row_count,
433: errbuf,
434: l_from_date,