DBA Data[Home] [Help]

APPS.BIS_MV_REFRESH dependencies on BIS_CREATE_REQUESTSET

Line 246: l_schema := BIS_CREATE_REQUESTSET.get_object_owner(p_mvname, 'MV');

242: open c_force_full(l_root_request_id);
243: fetch c_force_full into l_rs_name, l_is_force_full;
244: close c_force_full;
245: BIS_COLLECTION_UTILITIES.put_line('Request Set: ' || l_rs_name || ', ' || 'FORCE_FULL option: ' || l_is_force_full);
246: l_schema := BIS_CREATE_REQUESTSET.get_object_owner(p_mvname, 'MV');
247:
248: if( p_mode = 'INIT' and l_is_force_full='Y' ) then
249: BIS_BIA_RSG_LOG_MGMNT.create_mv_log(p_mvname, l_schema, 'MV');
250: else

Line 342: l_schema := BIS_CREATE_REQUESTSET.get_object_owner(mvname, 'MV'); --Bug 3999642

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

Line 848: IF (BIS_CREATE_REQUESTSET.is_history_collect_on(l_root_req_id)) then

844: -- logmsg('l_root_req_id '||l_root_req_id);
845:
846: if (p_prog_req_id is not null and l_root_req_id is not null )then
847: --Enh#4418520-aguwalan
848: IF (BIS_CREATE_REQUESTSET.is_history_collect_on(l_root_req_id)) then
849: BIS_COLL_RS_HISTORY.insert_program_object_data
850: (
851: x_request_id => p_prog_req_id,
852: x_stage_req_id => null,

Line 1403: IF (BIS_CREATE_REQUESTSET.is_history_collect_on(FND_GLOBAL.CONC_PRIORITY_REQUEST)) THEN

1399: -----For MVs processed by "BIS Materialized View Batch Refresh Program for MVs not to implement",
1400: -----we will record them to history table in procedure CONSIDER_REFRESH
1401:
1402: -- Enh#4418520-aguwalan
1403: IF (BIS_CREATE_REQUESTSET.is_history_collect_on(FND_GLOBAL.CONC_PRIORITY_REQUEST)) THEN
1404: BIS_COLL_RS_HISTORY.insert_program_object_data
1405: (
1406: x_request_id => prog_request_id,
1407: x_stage_req_id => null,