DBA Data[Home] [Help]

APPS.BIS_MV_REFRESH dependencies on BIS_BIA_RSG_INDEX_MGMT

Line 343: l_index_flag := BIS_BIA_RSG_INDEX_MGMT.is_Index_Mgmt_Enabled(mvname, l_schema); --Bug 3999642

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);
346: end if;
347: end if;

Line 345: BIS_BIA_RSG_INDEX_MGMT.Capture_and_drop_index_by_mv(mvname, l_schema);

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);
346: end if;
347: end if;
348: l_stmt := 'alter session force parallel query';
349: execute immediate l_stmt;

Line 413: BIS_BIA_RSG_INDEX_MGMT.recreate_indexes_by_mv_wrapper(mvname, l_schema);

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;
416: ELSE
417: IF (method = 'F') THEN

Line 438: BIS_BIA_RSG_INDEX_MGMT.recreate_indexes_by_mv_wrapper(mvname, l_schema);

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;
441: ELSE
442: IF (method = 'F') THEN