APPS.BSC_COLOR_CALC_UTIL dependencies on BSC_SYS_COLORS_B

Line 98: p_color_id IN bsc_sys_colors_b.color_id%TYPE

94: END Get_Kpi_Measure_Threshold;
95:
96:
97: FUNCTION get_color_perf_seq (
98: p_color_id IN bsc_sys_colors_b.color_id%TYPE
99: )
100: RETURN NUMBER IS
101:
102: l_index NUMBER;

Line 645: * Worst color is based on BSC_SYS_COLORS_B.PERF_SEQUENCE.

641: END Calc_Obj_Color_By_Single_Kpi;
642:
643:
644: /* Returns the worst color out of all the colors in the input array.
645: * Worst color is based on BSC_SYS_COLORS_B.PERF_SEQUENCE.
646: * If any of the KPI colors passed in is GRAY or NO_COLOR, color that
647: * will be returned will also be GRAY.
648: */
649: PROCEDURE get_worst_color (

Line 659: l_worst_color BSC_SYS_COLORS_B.color_id%TYPE;

655:
656: l_index NUMBER;
657: l_max_perf_seq NUMBER;
658: l_perf_seq NUMBER;
659: l_worst_color BSC_SYS_COLORS_B.color_id%TYPE;
660:
661: BEGIN
662:
663: IF p_num_colors = 0 THEN

Line 710: * Best color is based on BSC_SYS_COLORS_B.PERF_SEQUENCE.

706: --RETURN NULL;
707: END get_worst_color;
708:
709: /* Returns the best color out of all the colors in the input array.
710: * Best color is based on BSC_SYS_COLORS_B.PERF_SEQUENCE.
711: * If any of the KPI colors passed in is GRAY or NO_COLOR, color that
712: * will be returned will also be GRAY.
713: */
714: PROCEDURE get_best_color (

Line 724: l_best_color BSC_SYS_COLORS_B.color_id%TYPE;

720:
721: l_index NUMBER;
722: l_min_perf_seq NUMBER;
723: l_perf_seq NUMBER;
724: l_best_color BSC_SYS_COLORS_B.color_id%TYPE;
725:
726: BEGIN
727:
728: IF p_num_colors = 0 THEN

Line 825: l_most_freq_color BSC_SYS_COLORS_B.color_id%TYPE;

821:
822: l_index NUMBER;
823: l_min_perf_seq NUMBER;
824: l_perf_seq NUMBER;
825: l_most_freq_color BSC_SYS_COLORS_B.color_id%TYPE;
826: l_array_of_number BSC_UPDATE_UTIL.t_array_of_number;
827: l_colors_array BSC_UPDATE_UTIL.t_array_of_number;
828: l_color_count NUMBER;
829: l_max_count NUMBER;