680: -- Make sure to refresh the MV only one time. Remember that same MV
681: -- has data for different periodicities.
682: -- Note: The api to refresh the MV does not fail if the MV does not exists
683: -- or if the MV is actually a normal view
684: h_mv_name := BSC_BIA_WRAPPER.Get_Sum_Table_MV_Name(x_sum_table);
685: IF NOT BSC_UPDATE_UTIL.Item_Belong_To_Array_Varchar2(h_mv_name,
686: g_refreshed_mvs,
687: g_num_refreshed_mvs) THEN
688:
685: IF NOT BSC_UPDATE_UTIL.Item_Belong_To_Array_Varchar2(h_mv_name,
686: g_refreshed_mvs,
687: g_num_refreshed_mvs) THEN
688:
689: IF NOT BSC_BIA_WRAPPER.Refresh_Summary_MV(h_mv_name, h_error_refresh) THEN
690: RAISE e_error_refresh;
691: END IF;
692: COMMIT;
693:
1068: RETURN FALSE;
1069:
1070: WHEN e_error_refresh THEN
1071: ROLLBACK;
1072: BSC_MESSAGE.Add(x_message => 'BSC_BIA_WRAPPER.Refresh_Summary_MV '||h_mv_name||' '||h_error_refresh,
1073: x_source => 'BSC_UPDATE_SUM.Calculate_Sum_Table_MV');
1074: RETURN FALSE;
1075:
1076: WHEN e_error_refresh_zero THEN
2315: LOOP
2316: FETCH h_cursor INTO h_zero_mv;
2317: EXIT WHEN h_cursor%NOTFOUND;
2318:
2319: IF NOT BSC_BIA_WRAPPER.Refresh_Summary_MV(h_zero_mv, x_error_message) THEN
2320: RAISE e_error_refresh;
2321: END IF;
2322: COMMIT;
2323: