eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_UPDATE_COLOR dependencies on BSC_COLOR_CALC_UTIL

Line 1492: threshold_Prop_Table BSC_COLOR_CALC_UTIL.Threshold_Prop_Table;

1488: x_color_level2 NUMBER;
1489: x_color_level3 NUMBER;
1490: x_color_level4 NUMBER;
1491:
1492: threshold_Prop_Table BSC_COLOR_CALC_UTIL.Threshold_Prop_Table;
1493:
1494: min_perf BSC_SYS_COLORS_B.PERF_SEQUENCE%TYPE;
1495: max_perf BSC_SYS_COLORS_B.PERF_SEQUENCE%TYPE;
1496: min_perf_color_id BSC_SYS_COLORS_B.COLOR_ID%TYPE;

Line 1578: threshold_Prop_Table := BSC_COLOR_CALC_UTIL.Get_Kpi_Measure_Threshold (p_objective_id, p_kpi_measure_id);

1574:
1575: -- Calculate the color
1576: IF p_calc_color_flag THEN
1577:
1578: threshold_Prop_Table := BSC_COLOR_CALC_UTIL.Get_Kpi_Measure_Threshold (p_objective_id, p_kpi_measure_id);
1579:
1580: l_comp_op := '<=';
1581:
1582: IF l_color_method = 1 THEN

Line 3051: l_rollup_type := BSC_COLOR_CALC_UTIL.Get_Obj_Color_Rollup_Type(p_objective_color_rec.objective_id);

3047: e_unexpected_error EXCEPTION;
3048:
3049: BEGIN
3050:
3051: l_rollup_type := BSC_COLOR_CALC_UTIL.Get_Obj_Color_Rollup_Type(p_objective_color_rec.objective_id);
3052:
3053: IF l_rollup_type IS NOT NULL THEN
3054: IF l_rollup_type = BSC_COLOR_CALC_UTIL.DEFAULT_KPI THEN
3055: BSC_COLOR_CALC_UTIL.Calc_Obj_Color_By_Default_Kpi( p_objective_color_rec => p_objective_color_rec

Line 3054: IF l_rollup_type = BSC_COLOR_CALC_UTIL.DEFAULT_KPI THEN

3050:
3051: l_rollup_type := BSC_COLOR_CALC_UTIL.Get_Obj_Color_Rollup_Type(p_objective_color_rec.objective_id);
3052:
3053: IF l_rollup_type IS NOT NULL THEN
3054: IF l_rollup_type = BSC_COLOR_CALC_UTIL.DEFAULT_KPI THEN
3055: BSC_COLOR_CALC_UTIL.Calc_Obj_Color_By_Default_Kpi( p_objective_color_rec => p_objective_color_rec
3056: , x_kpi_measure_id => x_kpi_measure_id
3057: , x_color_flag => x_color_flag
3058: );

Line 3055: BSC_COLOR_CALC_UTIL.Calc_Obj_Color_By_Default_Kpi( p_objective_color_rec => p_objective_color_rec

3051: l_rollup_type := BSC_COLOR_CALC_UTIL.Get_Obj_Color_Rollup_Type(p_objective_color_rec.objective_id);
3052:
3053: IF l_rollup_type IS NOT NULL THEN
3054: IF l_rollup_type = BSC_COLOR_CALC_UTIL.DEFAULT_KPI THEN
3055: BSC_COLOR_CALC_UTIL.Calc_Obj_Color_By_Default_Kpi( p_objective_color_rec => p_objective_color_rec
3056: , x_kpi_measure_id => x_kpi_measure_id
3057: , x_color_flag => x_color_flag
3058: );
3059: ELSIF l_rollup_type = BSC_COLOR_CALC_UTIL.BEST OR l_rollup_type = BSC_COLOR_CALC_UTIL.WORST OR l_rollup_type = BSC_COLOR_CALC_UTIL.MOST_FREQUENT THEN

Line 3059: ELSIF l_rollup_type = BSC_COLOR_CALC_UTIL.BEST OR l_rollup_type = BSC_COLOR_CALC_UTIL.WORST OR l_rollup_type = BSC_COLOR_CALC_UTIL.MOST_FREQUENT THEN

3055: BSC_COLOR_CALC_UTIL.Calc_Obj_Color_By_Default_Kpi( p_objective_color_rec => p_objective_color_rec
3056: , x_kpi_measure_id => x_kpi_measure_id
3057: , x_color_flag => x_color_flag
3058: );
3059: ELSIF l_rollup_type = BSC_COLOR_CALC_UTIL.BEST OR l_rollup_type = BSC_COLOR_CALC_UTIL.WORST OR l_rollup_type = BSC_COLOR_CALC_UTIL.MOST_FREQUENT THEN
3060: BSC_COLOR_CALC_UTIL.Calc_Obj_Color_By_Single_Kpi( p_objective_color_rec => p_objective_color_rec
3061: , p_rollup_type => l_rollup_type
3062: , x_kpi_measure_id => x_kpi_measure_id
3063: , x_color_flag => x_color_flag

Line 3060: BSC_COLOR_CALC_UTIL.Calc_Obj_Color_By_Single_Kpi( p_objective_color_rec => p_objective_color_rec

3056: , x_kpi_measure_id => x_kpi_measure_id
3057: , x_color_flag => x_color_flag
3058: );
3059: ELSIF l_rollup_type = BSC_COLOR_CALC_UTIL.BEST OR l_rollup_type = BSC_COLOR_CALC_UTIL.WORST OR l_rollup_type = BSC_COLOR_CALC_UTIL.MOST_FREQUENT THEN
3060: BSC_COLOR_CALC_UTIL.Calc_Obj_Color_By_Single_Kpi( p_objective_color_rec => p_objective_color_rec
3061: , p_rollup_type => l_rollup_type
3062: , x_kpi_measure_id => x_kpi_measure_id
3063: , x_color_flag => x_color_flag
3064: );

Line 3065: ELSIF l_rollup_type = BSC_COLOR_CALC_UTIL.WEIGHTED_AVERAGE THEN

3061: , p_rollup_type => l_rollup_type
3062: , x_kpi_measure_id => x_kpi_measure_id
3063: , x_color_flag => x_color_flag
3064: );
3065: ELSIF l_rollup_type = BSC_COLOR_CALC_UTIL.WEIGHTED_AVERAGE THEN
3066: x_color_flag := BSC_COLOR_CALC_UTIL.Calc_Obj_Color_By_Weights( p_objective_color_rec => p_objective_color_rec
3067: );
3068: END IF;
3069: END IF;

Line 3066: x_color_flag := BSC_COLOR_CALC_UTIL.Calc_Obj_Color_By_Weights( p_objective_color_rec => p_objective_color_rec

3062: , x_kpi_measure_id => x_kpi_measure_id
3063: , x_color_flag => x_color_flag
3064: );
3065: ELSIF l_rollup_type = BSC_COLOR_CALC_UTIL.WEIGHTED_AVERAGE THEN
3066: x_color_flag := BSC_COLOR_CALC_UTIL.Calc_Obj_Color_By_Weights( p_objective_color_rec => p_objective_color_rec
3067: );
3068: END IF;
3069: END IF;
3070:

Line 3151: l_rollup_type := BSC_COLOR_CALC_UTIL.Get_Obj_Color_Rollup_Type(x_indicator);

3147: RETURN TRUE;
3148: END IF;
3149: l_prev_period := -999;
3150: l_prev_dim_levels :='xxxxxxxx';
3151: l_rollup_type := BSC_COLOR_CALC_UTIL.Get_Obj_Color_Rollup_Type(x_indicator);
3152: l_values_obtained := false;
3153:
3154: FOR l_dim_comb IN c_dim_comb LOOP
3155: IF( (l_prev_period=-999) OR (l_prev_dim_levels<>l_dim_comb.dim_comb)

Line 3209: IF l_rollup_type = BSC_COLOR_CALC_UTIL.DEFAULT_KPI THEN

3205: IF c_obj_dim_comb%ISOPEN THEN
3206: CLOSE c_obj_dim_comb;
3207: END IF;
3208:
3209: IF l_rollup_type = BSC_COLOR_CALC_UTIL.DEFAULT_KPI THEN
3210: l_calc_trend := x_calc_obj_trend;
3211:
3212: IF (l_comparison) THEN
3213: l_trendflag := l_dim_comb.kpi_trend;

Line 3236: IF l_rollup_type = BSC_COLOR_CALC_UTIL.WEIGHTED_AVERAGE THEN

3232: l_trendflag := l_dim_comb.kpi_trend;
3233: END IF;
3234: END IF;
3235: --BugFix 6137542
3236: IF l_rollup_type = BSC_COLOR_CALC_UTIL.WEIGHTED_AVERAGE THEN
3237: l_calc_trend := false;
3238: END IF;
3239:
3240: IF l_calc_trend THEN