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_COLOR_CALC_UTIL dependencies on BSC_UPDATE_UTIL

Line 13: , p_colors IN BSC_UPDATE_UTIL.t_array_of_number

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
17: );

Line 233: p_array_of_number IN BSC_UPDATE_UTIL.t_array_of_number

229: END get_color_numeric_equivalent;
230:
231:
232: FUNCTION get_max_count (
233: p_array_of_number IN BSC_UPDATE_UTIL.t_array_of_number
234: )
235: RETURN NUMBER IS
236: l_counter NUMBER;
237: l_max_count NUMBER;

Line 260: p_array_of_number IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_number

256:
257:
258:
259: PROCEDURE initialize_color_array (
260: p_array_of_number IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_number
261: )
262: IS
263: l_index NUMBER;
264: l_array_colors BSC_COLOR_REPOSITORY.t_array_colors;

Line 375: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_KPICOLOR_FAILED'),

371:
372: EXCEPTION
373: WHEN e_unexpected_error THEN
374: ROLLBACK;
375: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_KPICOLOR_FAILED'),
376: x_source => 'BSC_COLOR_CALC_UTIL.Calc_Obj_Color_By_Weights');
377: RETURN FALSE;
378: WHEN OTHERS THEN
379: ROLLBACK;

Line 569: l_colors BSC_UPDATE_UTIL.t_array_of_number;

565: l_kpi_colors c_kpi_colors%ROWTYPE;
566:
567: e_unexpected_error EXCEPTION;
568: l_default_kpi_measure_id bsc_kpi_measure_props.kpi_measure_id%TYPE;
569: l_colors BSC_UPDATE_UTIL.t_array_of_number;
570: l_kpi_measures BSC_UPDATE_UTIL.t_array_of_number;
571: l_color_index NUMBER;
572: l_obj_color NUMBER;
573: l_kpi_index NUMBER := -1;

Line 570: l_kpi_measures BSC_UPDATE_UTIL.t_array_of_number;

566:
567: e_unexpected_error EXCEPTION;
568: l_default_kpi_measure_id bsc_kpi_measure_props.kpi_measure_id%TYPE;
569: l_colors BSC_UPDATE_UTIL.t_array_of_number;
570: l_kpi_measures BSC_UPDATE_UTIL.t_array_of_number;
571: l_color_index NUMBER;
572: l_obj_color NUMBER;
573: l_kpi_index NUMBER := -1;
574:

Line 629: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_KPICOLOR_FAILED'),

625:
626: EXCEPTION
627: WHEN e_unexpected_error THEN
628: ROLLBACK;
629: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_KPICOLOR_FAILED'),
630: x_source => 'BSC_COLOR_CALC_UTIL.Calc_Obj_Color_By_Single_Kpi');
631: x_kpi_measure_id := -1;
632: x_color_flag := false;
633: --RETURN FALSE;

Line 650: p_colors IN BSC_UPDATE_UTIL.t_array_of_number

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 (
650: p_colors IN BSC_UPDATE_UTIL.t_array_of_number
651: , p_num_colors IN NUMBER
652: , x_color OUT NOCOPY NUMBER
653: , x_kpi_index OUT NOCOPY NUMBER
654: ) IS

Line 715: p_colors IN BSC_UPDATE_UTIL.t_array_of_number

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 (
715: p_colors IN BSC_UPDATE_UTIL.t_array_of_number
716: , p_num_colors IN NUMBER
717: , x_color OUT NOCOPY NUMBER
718: , x_kpi_index OUT NOCOPY NUMBER
719: ) IS

Line 779: p_array_of_number IN BSC_UPDATE_UTIL.t_array_of_number

775: END get_best_color;
776:
777:
778: PROCEDURE get_colors_with_max_count (
779: p_array_of_number IN BSC_UPDATE_UTIL.t_array_of_number
780: , p_max_count IN NUMBER
781: , p_colors_array OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_number
782: , p_color_count OUT NOCOPY NUMBER
783: )

Line 781: , p_colors_array OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_number

777:
778: PROCEDURE get_colors_with_max_count (
779: p_array_of_number IN BSC_UPDATE_UTIL.t_array_of_number
780: , p_max_count IN NUMBER
781: , p_colors_array OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_number
782: , p_color_count OUT NOCOPY NUMBER
783: )
784: IS
785: l_index NUMBER;

Line 816: p_colors IN BSC_UPDATE_UTIL.t_array_of_number

812: * If any of the KPI colors passed in is GRAY or NO_COLOR, color that
813: * will be returned will also be GRAY.
814: */
815: PROCEDURE get_most_frequent_color (
816: p_colors IN BSC_UPDATE_UTIL.t_array_of_number
817: , p_num_colors IN NUMBER
818: , x_color OUT NOCOPY NUMBER
819: , x_kpi_index OUT NOCOPY NUMBER
820: ) IS

Line 826: l_array_of_number BSC_UPDATE_UTIL.t_array_of_number;

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;
830: i NUMBER;

Line 827: l_colors_array BSC_UPDATE_UTIL.t_array_of_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;
830: i NUMBER;
831: BEGIN

Line 909: , p_colors IN BSC_UPDATE_UTIL.t_array_of_number

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
913: ) IS