[Home] [Help]
1905:
1906: -- Delete the colors of the indicator for this tab
1907: DELETE FROM bsc_sys_kpi_colors
1908: WHERE tab_id = l_objective_color_props.tab_id AND indicator = x_indic_code;
1909: DELETE FROM bsc_sys_objective_colors
1910: WHERE tab_id = l_objective_color_props.tab_id AND indicator = x_indic_code;
1911: COMMIT;
1912:
1913: l_objective_color_rec.tab_id := l_objective_color_props.tab_id;
3031:
3032:
3033: /* Once the KPI colors are calculated and stored in BSC_SYS_KPI_COLORS,
3034: * this API will calculate the Objective color based on the rollup type.
3035: * The objective color will be stored in BSC_SYS_OBJECTIVE_COLORS.
3036: * Rollup type can be one of: BEST, WORST, MOST_FREQUENT, WEIGHTED_AVERAGE,
3037: * DEFAULT_KPI. For Simulation Objective, the color will be based on the
3038: * default (color) node as of today.
3039: */
3110: CURSOR c_obj_dim_comb(cp_dim_comb VARCHAR2, cp_period_id NUMBER) IS
3111: SELECT DISTINCT
3112: dim_level1 || dim_level2 || dim_level3 || dim_level4 || dim_level5 || dim_level6 || dim_level7 || dim_level8 dim_comb,
3113: period_id, obj_color, obj_trend
3114: FROM bsc_sys_objective_colors
3115: WHERE indicator = x_indicator
3116: AND tab_id = x_tab_id
3117: AND dim_level1 || dim_level2 || dim_level3 || dim_level4 || dim_level5 || dim_level6 || dim_level7 || dim_level8 = cp_dim_comb
3118: AND period_id = cp_period_id
3238: END IF;
3239:
3240: IF l_calc_trend THEN
3241:
3242: h_obj_sql := 'UPDATE bsc_sys_objective_colors'||
3243: ' SET obj_trend = '||l_trendflag||
3244: ' WHERE indicator =:1 '||
3245: ' AND tab_id = :2 '||
3246: ' AND period_id = :3 '||