PACKAGE: APPS.BSC_COLOR_CALC_UTIL

Source

1 PACKAGE BSC_COLOR_CALC_UTIL AS
2 /* $Header: BSCCUTLS.pls 120.1.12000000.1 2007/07/17 07:43:39 appldev noship $ */
3 
4 DEFAULT_KPI       CONSTANT  VARCHAR2(11) := 'DEFAULT_KPI';
5 BEST              CONSTANT  VARCHAR2(5)  := 'BEST';
6 WORST             CONSTANT  VARCHAR2(5)  := 'WORST';
7 MOST_FREQUENT     CONSTANT  VARCHAR2(13) := 'MOST_FREQUENT';
8 WEIGHTED_AVERAGE  CONSTANT  VARCHAR2(16) := 'WEIGHTED_AVERAGE';
9 
10 TYPE Threshold_Prop IS RECORD (
11   threshold  NUMBER
12 , color_id   bsc_color_ranges.color_id%TYPE
13 );
14 
15 TYPE Threshold_Prop_Table IS TABLE OF Threshold_Prop
16   INDEX BY BINARY_INTEGER;
17 
18 PROCEDURE Calc_Obj_Color_By_Default_Kpi (
19   p_objective_color_rec  IN BSC_UPDATE_COLOR.t_objective_color_rec
20  ,x_kpi_measure_id       OUT NOCOPY NUMBER
21  ,x_color_flag           OUT NOCOPY BOOLEAN
22 );
23 
24 PROCEDURE Calc_Obj_Color_By_Single_Kpi (
25   p_objective_color_rec  IN BSC_UPDATE_COLOR.t_objective_color_rec
26  ,p_rollup_type          IN bsc_kpis_b.color_rollup_type%TYPE
27  ,x_kpi_measure_id       OUT NOCOPY NUMBER
28  ,x_color_flag           OUT NOCOPY BOOLEAN
29 );
30 
31 FUNCTION Calc_Obj_Color_By_Weights (
32   p_objective_color_rec  IN BSC_UPDATE_COLOR.t_objective_color_rec
33 )
34 RETURN BOOLEAN;
35 
36 FUNCTION Get_Kpi_Measure_Threshold (
37   p_indicator       IN NUMBER
38 , p_kpi_measure_id  IN NUMBER
39 )
40 RETURN Threshold_Prop_Table;
41 
42 FUNCTION Get_Obj_Color_Rollup_Type (
43   p_objective_id  IN NUMBER
44 )
45 RETURN VARCHAR2;
46 
47 FUNCTION Get_Default_Kpi_Measure_Id (
48   p_objective_id  IN NUMBER
49 )
50 RETURN NUMBER;
51 
52 END BSC_COLOR_CALC_UTIL;