DBA Data[Home] [Help]

APPS.BSC_UPDATE_CALC dependencies on BSC_INTEGRATION_MV_GEN

Line 2865: BSC_INTEGRATION_MV_GEN.Refresh_MVs(x_table_name, TO_CHAR(h_start_year)||'-'||TO_CHAR(h_end_year));

2861:
2862: h_start_year := x_current_fy - h_previous_years;
2863: h_end_year := h_start_year + h_num_of_years - 1;
2864:
2865: BSC_INTEGRATION_MV_GEN.Refresh_MVs(x_table_name, TO_CHAR(h_start_year)||'-'||TO_CHAR(h_end_year));
2866: IF BSC_APPS.CheckError('BSC_INTEGRATION_MV_GEN.Refresh_MVs') THEN
2867: RAISE e_unexpected_error;
2868: END IF;
2869:

Line 2866: IF BSC_APPS.CheckError('BSC_INTEGRATION_MV_GEN.Refresh_MVs') THEN

2862: h_start_year := x_current_fy - h_previous_years;
2863: h_end_year := h_start_year + h_num_of_years - 1;
2864:
2865: BSC_INTEGRATION_MV_GEN.Refresh_MVs(x_table_name, TO_CHAR(h_start_year)||'-'||TO_CHAR(h_end_year));
2866: IF BSC_APPS.CheckError('BSC_INTEGRATION_MV_GEN.Refresh_MVs') THEN
2867: RAISE e_unexpected_error;
2868: END IF;
2869:
2870: -- Delete from x_table all rows existing in the materialized view