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.BIS_MV_REFRESH dependencies on BIS_BIA_RSG_CUSTOM_API_MGMNT

Line 165: l_rtnbuf:=BIS_BIA_RSG_CUSTOM_API_MGMNT.METHOD_FAST;--added for enhancement 4423644

161: L_CUSTOM_API:= GET_CUSTOMAPI (p_mvname);
162: IF (L_CUSTOM_API is NOT NULL) THEN
163: BIS_COLLECTION_UTILITIES.put_line('Before invoke custom API for MV threshold management: (' || p_mvname || ')');
164: -- Now call the stored program
165: l_rtnbuf:=BIS_BIA_RSG_CUSTOM_API_MGMNT.METHOD_FAST;--added for enhancement 4423644
166: BIS_BIA_RSG_CUSTOM_API_MGMNT.INVOKE_CUSTOM_API(
167: l_rtnbuf, l_retcode,
168: L_CUSTOM_API, BIS_BIA_RSG_CUSTOM_API_MGMNT.TYPE_MV_THRESHOLD,
169: p_mvname, 'MV', BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_BEFORE);

Line 166: BIS_BIA_RSG_CUSTOM_API_MGMNT.INVOKE_CUSTOM_API(

162: IF (L_CUSTOM_API is NOT NULL) THEN
163: BIS_COLLECTION_UTILITIES.put_line('Before invoke custom API for MV threshold management: (' || p_mvname || ')');
164: -- Now call the stored program
165: l_rtnbuf:=BIS_BIA_RSG_CUSTOM_API_MGMNT.METHOD_FAST;--added for enhancement 4423644
166: BIS_BIA_RSG_CUSTOM_API_MGMNT.INVOKE_CUSTOM_API(
167: l_rtnbuf, l_retcode,
168: L_CUSTOM_API, BIS_BIA_RSG_CUSTOM_API_MGMNT.TYPE_MV_THRESHOLD,
169: p_mvname, 'MV', BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_BEFORE);
170: --- BIS_BIA_RSG_CUSTOM_API_MGMNT.log( 'Got refresh threshold for ' || p_mvname || ': '|| l_rtnbuf);

Line 168: L_CUSTOM_API, BIS_BIA_RSG_CUSTOM_API_MGMNT.TYPE_MV_THRESHOLD,

164: -- Now call the stored program
165: l_rtnbuf:=BIS_BIA_RSG_CUSTOM_API_MGMNT.METHOD_FAST;--added for enhancement 4423644
166: BIS_BIA_RSG_CUSTOM_API_MGMNT.INVOKE_CUSTOM_API(
167: l_rtnbuf, l_retcode,
168: L_CUSTOM_API, BIS_BIA_RSG_CUSTOM_API_MGMNT.TYPE_MV_THRESHOLD,
169: p_mvname, 'MV', BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_BEFORE);
170: --- BIS_BIA_RSG_CUSTOM_API_MGMNT.log( 'Got refresh threshold for ' || p_mvname || ': '|| l_rtnbuf);
171: BIS_COLLECTION_UTILITIES.put_line('After invoke custom API for MV threshold management : (' || p_mvname ||','||l_rtnbuf|| ')');
172:

Line 169: p_mvname, 'MV', BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_BEFORE);

165: l_rtnbuf:=BIS_BIA_RSG_CUSTOM_API_MGMNT.METHOD_FAST;--added for enhancement 4423644
166: BIS_BIA_RSG_CUSTOM_API_MGMNT.INVOKE_CUSTOM_API(
167: l_rtnbuf, l_retcode,
168: L_CUSTOM_API, BIS_BIA_RSG_CUSTOM_API_MGMNT.TYPE_MV_THRESHOLD,
169: p_mvname, 'MV', BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_BEFORE);
170: --- BIS_BIA_RSG_CUSTOM_API_MGMNT.log( 'Got refresh threshold for ' || p_mvname || ': '|| l_rtnbuf);
171: BIS_COLLECTION_UTILITIES.put_line('After invoke custom API for MV threshold management : (' || p_mvname ||','||l_rtnbuf|| ')');
172:
173: IF ( l_rtnbuf = BIS_BIA_RSG_CUSTOM_API_MGMNT.METHOD_COMPLETE) THEN

Line 170: --- BIS_BIA_RSG_CUSTOM_API_MGMNT.log( 'Got refresh threshold for ' || p_mvname || ': '|| l_rtnbuf);

166: BIS_BIA_RSG_CUSTOM_API_MGMNT.INVOKE_CUSTOM_API(
167: l_rtnbuf, l_retcode,
168: L_CUSTOM_API, BIS_BIA_RSG_CUSTOM_API_MGMNT.TYPE_MV_THRESHOLD,
169: p_mvname, 'MV', BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_BEFORE);
170: --- BIS_BIA_RSG_CUSTOM_API_MGMNT.log( 'Got refresh threshold for ' || p_mvname || ': '|| l_rtnbuf);
171: BIS_COLLECTION_UTILITIES.put_line('After invoke custom API for MV threshold management : (' || p_mvname ||','||l_rtnbuf|| ')');
172:
173: IF ( l_rtnbuf = BIS_BIA_RSG_CUSTOM_API_MGMNT.METHOD_COMPLETE) THEN
174: RETURN 'INIT';

Line 173: IF ( l_rtnbuf = BIS_BIA_RSG_CUSTOM_API_MGMNT.METHOD_COMPLETE) THEN

169: p_mvname, 'MV', BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_BEFORE);
170: --- BIS_BIA_RSG_CUSTOM_API_MGMNT.log( 'Got refresh threshold for ' || p_mvname || ': '|| l_rtnbuf);
171: BIS_COLLECTION_UTILITIES.put_line('After invoke custom API for MV threshold management : (' || p_mvname ||','||l_rtnbuf|| ')');
172:
173: IF ( l_rtnbuf = BIS_BIA_RSG_CUSTOM_API_MGMNT.METHOD_COMPLETE) THEN
174: RETURN 'INIT';
175: ELSIF ( l_rtnbuf = BIS_BIA_RSG_CUSTOM_API_MGMNT.METHOD_FAST) THEN
176: RETURN 'INCR';
177: END IF;

Line 175: ELSIF ( l_rtnbuf = BIS_BIA_RSG_CUSTOM_API_MGMNT.METHOD_FAST) THEN

171: BIS_COLLECTION_UTILITIES.put_line('After invoke custom API for MV threshold management : (' || p_mvname ||','||l_rtnbuf|| ')');
172:
173: IF ( l_rtnbuf = BIS_BIA_RSG_CUSTOM_API_MGMNT.METHOD_COMPLETE) THEN
174: RETURN 'INIT';
175: ELSIF ( l_rtnbuf = BIS_BIA_RSG_CUSTOM_API_MGMNT.METHOD_FAST) THEN
176: RETURN 'INCR';
177: END IF;
178: RETURN l_rtnbuf;
179: ELSE

Line 198: l_rtnbuf:= BIS_BIA_RSG_CUSTOM_API_MGMNT.METHOD_COMPLETE;

194: L_CUSTOM_API:= GET_CUSTOMAPI (p_mvname);
195: IF (L_CUSTOM_API is NOT NULL) THEN
196: -- Now call the stored program
197: BIS_COLLECTION_UTILITIES.put_line('Before invoke custom API for MV index management : (' || p_mvname || ', ' || p_mode || ')');
198: l_rtnbuf:= BIS_BIA_RSG_CUSTOM_API_MGMNT.METHOD_COMPLETE;
199: BIS_BIA_RSG_CUSTOM_API_MGMNT.INVOKE_CUSTOM_API(
200: l_rtnbuf, l_retcode,
201: L_CUSTOM_API, BIS_BIA_RSG_CUSTOM_API_MGMNT.TYPE_MV_INDEX_MGT,
202: p_mvname, 'MV', p_mode);

Line 199: BIS_BIA_RSG_CUSTOM_API_MGMNT.INVOKE_CUSTOM_API(

195: IF (L_CUSTOM_API is NOT NULL) THEN
196: -- Now call the stored program
197: BIS_COLLECTION_UTILITIES.put_line('Before invoke custom API for MV index management : (' || p_mvname || ', ' || p_mode || ')');
198: l_rtnbuf:= BIS_BIA_RSG_CUSTOM_API_MGMNT.METHOD_COMPLETE;
199: BIS_BIA_RSG_CUSTOM_API_MGMNT.INVOKE_CUSTOM_API(
200: l_rtnbuf, l_retcode,
201: L_CUSTOM_API, BIS_BIA_RSG_CUSTOM_API_MGMNT.TYPE_MV_INDEX_MGT,
202: p_mvname, 'MV', p_mode);
203: BIS_COLLECTION_UTILITIES.put_line('After invoke custom API for MV index management: (' || p_mvname || ', ' || p_mode || ')');

Line 201: L_CUSTOM_API, BIS_BIA_RSG_CUSTOM_API_MGMNT.TYPE_MV_INDEX_MGT,

197: BIS_COLLECTION_UTILITIES.put_line('Before invoke custom API for MV index management : (' || p_mvname || ', ' || p_mode || ')');
198: l_rtnbuf:= BIS_BIA_RSG_CUSTOM_API_MGMNT.METHOD_COMPLETE;
199: BIS_BIA_RSG_CUSTOM_API_MGMNT.INVOKE_CUSTOM_API(
200: l_rtnbuf, l_retcode,
201: L_CUSTOM_API, BIS_BIA_RSG_CUSTOM_API_MGMNT.TYPE_MV_INDEX_MGT,
202: p_mvname, 'MV', p_mode);
203: BIS_COLLECTION_UTILITIES.put_line('After invoke custom API for MV index management: (' || p_mvname || ', ' || p_mode || ')');
204: END IF;
205: EXCEPTION WHEN OTHERS THEN

Line 302: l_rtnbuf:=BIS_BIA_RSG_CUSTOM_API_MGMNT.METHOD_FAST;

298: L_CUSTOM_API:= GET_CUSTOMAPI (p_mvname);
299: IF (L_CUSTOM_API is NOT NULL) THEN
300: -- Now call the stored program
301: if p_mv_refresh_method='F' then
302: l_rtnbuf:=BIS_BIA_RSG_CUSTOM_API_MGMNT.METHOD_FAST;
303: else
304: l_rtnbuf:=BIS_BIA_RSG_CUSTOM_API_MGMNT.METHOD_COMPLETE;
305: end if;
306: BIS_COLLECTION_UTILITIES.put_line('Before INVOKE_CUSTOM_API for other custom logic : (' || p_mvname || ', ' || p_mode || ','||l_rtnbuf||')');

Line 304: l_rtnbuf:=BIS_BIA_RSG_CUSTOM_API_MGMNT.METHOD_COMPLETE;

300: -- Now call the stored program
301: if p_mv_refresh_method='F' then
302: l_rtnbuf:=BIS_BIA_RSG_CUSTOM_API_MGMNT.METHOD_FAST;
303: else
304: l_rtnbuf:=BIS_BIA_RSG_CUSTOM_API_MGMNT.METHOD_COMPLETE;
305: end if;
306: BIS_COLLECTION_UTILITIES.put_line('Before INVOKE_CUSTOM_API for other custom logic : (' || p_mvname || ', ' || p_mode || ','||l_rtnbuf||')');
307: BIS_BIA_RSG_CUSTOM_API_MGMNT.INVOKE_CUSTOM_API(
308: l_rtnbuf, l_retcode,

Line 307: BIS_BIA_RSG_CUSTOM_API_MGMNT.INVOKE_CUSTOM_API(

303: else
304: l_rtnbuf:=BIS_BIA_RSG_CUSTOM_API_MGMNT.METHOD_COMPLETE;
305: end if;
306: BIS_COLLECTION_UTILITIES.put_line('Before INVOKE_CUSTOM_API for other custom logic : (' || p_mvname || ', ' || p_mode || ','||l_rtnbuf||')');
307: BIS_BIA_RSG_CUSTOM_API_MGMNT.INVOKE_CUSTOM_API(
308: l_rtnbuf, l_retcode,
309: L_CUSTOM_API, BIS_BIA_RSG_CUSTOM_API_MGMNT.TYPE_MV_OTHER_CUSTOM,
310: p_mvname, 'MV', p_mode);
311: BIS_COLLECTION_UTILITIES.put_line('After INVOKE_CUSTOM_API for other custom logic: (' || p_mvname || ', ' || p_mode ||','||l_rtnbuf||')');

Line 309: L_CUSTOM_API, BIS_BIA_RSG_CUSTOM_API_MGMNT.TYPE_MV_OTHER_CUSTOM,

305: end if;
306: BIS_COLLECTION_UTILITIES.put_line('Before INVOKE_CUSTOM_API for other custom logic : (' || p_mvname || ', ' || p_mode || ','||l_rtnbuf||')');
307: BIS_BIA_RSG_CUSTOM_API_MGMNT.INVOKE_CUSTOM_API(
308: l_rtnbuf, l_retcode,
309: L_CUSTOM_API, BIS_BIA_RSG_CUSTOM_API_MGMNT.TYPE_MV_OTHER_CUSTOM,
310: p_mvname, 'MV', p_mode);
311: BIS_COLLECTION_UTILITIES.put_line('After INVOKE_CUSTOM_API for other custom logic: (' || p_mvname || ', ' || p_mode ||','||l_rtnbuf||')');
312: END IF;
313: EXCEPTION WHEN OTHERS THEN

Line 341: MV_INDEX_MANAGE(mvname, BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_BEFORE);

337: IF (method = 'C') THEN
338: l_atomic_refresh := IS_ATOMIC_REFRESH_BY_DBVERSION;
339:
340: if (l_atomic_refresh) then -- NOT TO INVOKE MV_INDEX_MANAGE IN 10G
341: MV_INDEX_MANAGE(mvname, BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_BEFORE);
342: l_schema := BIS_CREATE_REQUESTSET.get_object_owner(mvname, 'MV'); --Bug 3999642
343: l_index_flag := BIS_BIA_RSG_INDEX_MGMT.is_Index_Mgmt_Enabled(mvname, l_schema); --Bug 3999642
344: if (l_index_flag = 'Y' or l_index_flag = 'y') then --Bug 3999642
345: BIS_BIA_RSG_INDEX_MGMT.Capture_and_drop_index_by_mv(mvname, l_schema);

Line 359: -- MV_INDEX_MANAGE(mvname, BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_BEFORE);

355: BIS_COLLECTION_UTILITIES.put_line(mvname||' was altered to parallel');
356: ----end of bug 4149264
357:
358: -- for bug 3668562, move before the alter session calls
359: -- MV_INDEX_MANAGE(mvname, BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_BEFORE);
360:
361: l_method := 'INITIAL'; --BUG 3626375
362: ELSE
363: IF (method = 'F') THEN

Line 371: custom_api_other(mvname, BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_BEFORE,method);

367: END IF;
368: END IF;
369:
370: ---added for enhancement 4423644
371: custom_api_other(mvname, BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_BEFORE,method);
372:
373: -- for bug3404338, never use the parallelism param for now.
374: -- for bug3617762, SET ATOMIC_REFRESH TO FALSE ONLY FOR COMPLETE REFRESH
375:

Line 394: custom_api_other(mvname, BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_AFTER,method);

390: BIS_COLLECTION_UTILITIES.put_line(mvname||' was refreshed using '|| l_method || ' refresh method');
391: -- code end for bug 3626375
392:
393: ------added for enhancement 4423644
394: custom_api_other(mvname, BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_AFTER,method);
395:
396: IF (method = 'C') THEN
397:
398: ---bug 4149264

Line 411: MV_INDEX_MANAGE(mvname, BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_AFTER);

407: l_stmt := 'alter session disable parallel dml';
408: execute immediate l_stmt;
409: MV_LOG_MANAGE(mvname, 'INIT');
410: if (l_atomic_refresh) then -- NOT TO INVOKE MV_INDEX_MANAGE IN 10G
411: MV_INDEX_MANAGE(mvname, BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_AFTER);
412: if (l_index_flag = 'Y' or l_index_flag = 'y') then --Bug 3999642
413: BIS_BIA_RSG_INDEX_MGMT.recreate_indexes_by_mv_wrapper(mvname, l_schema);
414: end if;
415: end if;

Line 436: MV_INDEX_MANAGE(mvname, BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_AFTER);

432: commit;
433: l_stmt := 'alter session disable parallel dml';
434: execute immediate l_stmt;
435: if (l_atomic_refresh) then -- NOT TO INVOKE MV_INDEX_MANAGE IN 10G
436: MV_INDEX_MANAGE(mvname, BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_AFTER);
437: if (l_index_flag = 'Y' or l_index_flag = 'y') then
438: BIS_BIA_RSG_INDEX_MGMT.recreate_indexes_by_mv_wrapper(mvname, l_schema);
439: end if;
440: end if;