APPS.BSC_COLOR_CALC_UTIL dependencies on BSC_KPIS_B

Line 12: p_rollup_type IN bsc_kpis_b.color_rollup_type%TYPE

8: )
9: RETURN NUMBER;
10:
11: PROCEDURE get_rollup_obj_color (
12: p_rollup_type IN bsc_kpis_b.color_rollup_type%TYPE
13: , p_colors IN BSC_UPDATE_UTIL.t_array_of_number
14: , p_num_colors IN NUMBER
15: , x_color OUT NOCOPY NUMBER
16: , x_kpi_index OUT NOCOPY NUMBER

Line 65: FROM bsc_kpis_b

61:
62: BEGIN
63: SELECT config_type
64: INTO l_config_type
65: FROM bsc_kpis_b
66: WHERE indicator = p_indicator;
67: IF (l_config_type = 3 ) THEN
68: FOR c_pl_color_range IN c_pl_color LOOP
69: l_color_range_id := c_pl_color_range.color_range_id;

Line 134: FROM bsc_kpis_b

130: )
131: RETURN NUMBER IS
132: CURSOR c_obj_color_prop IS
133: SELECT weighted_color_method
134: FROM bsc_kpis_b
135: WHERE indicator = p_pbjective_id;
136:
137: l_color_method NUMBER;
138:

Line 166: p_objective_id IN bsc_kpis_b.indicator%TYPE

162: END get_objective_color_method;
163:
164:
165: FUNCTION get_kpi_measure_weight (
166: p_objective_id IN bsc_kpis_b.indicator%TYPE
167: , p_kpi_measure_id IN bsc_kpi_measure_props.kpi_measure_id%TYPE
168: )
169: RETURN NUMBER IS
170: CURSOR c_kpi_measure_weight IS

Line 533: ,p_rollup_type IN bsc_kpis_b.color_rollup_type%TYPE

529:
530:
531: PROCEDURE Calc_Obj_Color_By_Single_Kpi (
532: p_objective_color_rec IN BSC_UPDATE_COLOR.t_objective_color_rec
533: ,p_rollup_type IN bsc_kpis_b.color_rollup_type%TYPE
534: ,x_kpi_measure_id OUT NOCOPY NUMBER
535: ,x_color_flag OUT NOCOPY BOOLEAN
536:
537: ) IS

Line 908: p_rollup_type IN bsc_kpis_b.color_rollup_type%TYPE

904: END get_most_frequent_color;
905:
906:
907: PROCEDURE get_rollup_obj_color (
908: p_rollup_type IN bsc_kpis_b.color_rollup_type%TYPE
909: , p_colors IN BSC_UPDATE_UTIL.t_array_of_number
910: , p_num_colors IN NUMBER
911: , x_color OUT NOCOPY NUMBER
912: , x_kpi_index OUT NOCOPY NUMBER

Line 1027: FROM bsc_kpis_b

1023: RETURN VARCHAR2 IS
1024:
1025: CURSOR c_rollup_type(p_indicator NUMBER) IS
1026: SELECT color_rollup_type
1027: FROM bsc_kpis_b
1028: WHERE indicator = p_indicator;
1029:
1030: l_rollup_type bsc_kpis_b.color_rollup_type%TYPE;
1031:

Line 1030: l_rollup_type bsc_kpis_b.color_rollup_type%TYPE;

1026: SELECT color_rollup_type
1027: FROM bsc_kpis_b
1028: WHERE indicator = p_indicator;
1029:
1030: l_rollup_type bsc_kpis_b.color_rollup_type%TYPE;
1031:
1032: BEGIN
1033:
1034: l_rollup_type := NULL;