DBA Data[Home] [Help]

APPS.BSC_UPDATE_SUM dependencies on BSC_BIA_WRAPPER

Line 684: h_mv_name := BSC_BIA_WRAPPER.Get_Sum_Table_MV_Name(x_sum_table);

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:

Line 689: IF NOT BSC_BIA_WRAPPER.Refresh_Summary_MV(h_mv_name, h_error_refresh) THEN

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:

Line 1072: BSC_MESSAGE.Add(x_message => 'BSC_BIA_WRAPPER.Refresh_Summary_MV '||h_mv_name||' '||h_error_refresh,

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

Line 2319: IF NOT BSC_BIA_WRAPPER.Refresh_Summary_MV(h_zero_mv, x_error_message) 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: