APPS.BSC_UPDATE_COLOR dependencies on BSC_APPS

Line 894: IF BSC_APPS.bsc_mv THEN

890: --BSC-MV Note: In this architecture the data is in the MV.
891: --I will color only the periods existing in the MV
892: --If the summary table is used to store projections, I wont color
893: --projected periods. Currently, BSC does not use those colors.
894: IF BSC_APPS.bsc_mv THEN
895: h_condition := h_condition||'PERIODICITY_ID = :'||(h_num_bind_vars + 1);
896: h_num_bind_vars := h_num_bind_vars + 1;
897: h_bind_vars_values(h_num_bind_vars) := x_periodicity_id;
898:

Line 1123: IF BSC_APPS.bsc_mv THEN

1119:
1120: h_sql := 'INSERT /*+ append */ INTO BSC_TMP_DATA_COLOR ('||h_lst_keys_temp||'PERIOD, TYPE, TOTAL)'||
1121: ' SELECT '||h_lst_keys||'YEAR AS PERIOD, TYPE, '||x_measure_formula||' AS TOTAL';
1122:
1123: IF BSC_APPS.bsc_mv THEN
1124: h_sql := h_sql||
1125: ' FROM '||h_fact_table||' F';
1126: ELSE
1127: h_sql := h_sql||

Line 1138: IF BSC_APPS.bsc_mv THEN

1134:
1135: h_sql := 'INSERT /*+ append */ INTO BSC_TMP_DATA_COLOR ('||h_lst_keys_temp||'PERIOD, TYPE, TOTAL)'||
1136: ' SELECT '||h_lst_keys||'PERIOD, TYPE, '||x_measure_formula||' AS TOTAL';
1137:
1138: IF BSC_APPS.bsc_mv THEN
1139: h_sql := h_sql||
1140: ' FROM '||h_fact_table||' F';
1141: ELSE
1142: h_sql := h_sql||

Line 1176: IF BSC_APPS.bsc_mv THEN

1172:
1173: h_sql := 'UPDATE BSC_TMP_DATA_COLOR A'||
1174: ' SET TOTAL = ('||
1175: ' SELECT '||x_measure_formula;
1176: IF BSC_APPS.bsc_mv THEN
1177: h_sql := h_sql||
1178: ' FROM '||h_fact_table||' B';
1179: ELSE
1180: h_sql := h_sql||

Line 1886: IF BSC_APPS.CheckError('BSC_INTEGRATION_APIS.Get_Number_Of_Periods') THEN

1882: h_init_period := 1;
1883: h_end_period := BSC_INTEGRATION_APIS.Get_Number_Of_Periods(h_current_fy,
1884: l_objective_color_props.periodicity_id,
1885: h_calendar_id);
1886: IF BSC_APPS.CheckError('BSC_INTEGRATION_APIS.Get_Number_Of_Periods') THEN
1887: RAISE e_unexpected_error;
1888: END IF;
1889:
1890: FOR h_i IN h_init_period..h_end_period LOOP