[Home] [Help]
PACKAGE: APPS.BSC_KPI_COLOR_PROPERTIES_PUB
Source
1 PACKAGE BSC_KPI_COLOR_PROPERTIES_PUB AS
2 /* $Header: BSCPKCPS.pls 120.1.12000000.1 2007/07/17 07:44:04 appldev noship $ */
3
4
5 /************************************************************************************
6 ************************************************************************************/
7
8 PROCEDURE Update_Kpi_Color_Properties (
9 p_commit IN VARCHAR2 := FND_API.G_FALSE
10 , p_objective_id IN BSC_KPIS_B.indicator%TYPE
11 , p_kpi_measure_id IN BSC_KPI_ANALYSIS_MEASURES_B.kpi_measure_id%TYPE
12 , p_disable_color IN BSC_KPI_MEASURE_PROPS.disable_color%TYPE
13 , p_kpi_prototype_color IN BSC_KPI_MEASURE_PROPS.prototype_color_id%TYPE
14 , p_kpi_prototype_trend IN BSC_KPI_MEASURE_PROPS.prototype_trend_id%TYPE
15 , p_color_by_total IN BSC_KPI_MEASURE_PROPS.color_by_total%TYPE
16 , p_disable_trend IN BSC_KPI_MEASURE_PROPS.disable_trend%TYPE
17 , p_need_color_recalc IN VARCHAR2 := 'N'
18 , x_return_status OUT NOCOPY VARCHAR2
19 , x_msg_count OUT NOCOPY NUMBER
20 , x_msg_data OUT NOCOPY VARCHAR2
21 );
22
23
24
25 /************************************************************************************
26 ************************************************************************************/
27
28 PROCEDURE Update_Obj_Color_Properties (
29 p_commit IN VARCHAR2 := FND_API.G_FALSE
30 , p_objective_id IN BSC_KPIS_B.indicator%TYPE
31 , p_obj_prototype_color_id IN BSC_KPIS_B.prototype_color_id%TYPE
32 , p_obj_prototype_trend_id IN BSC_KPIS_B.prototype_trend_id%TYPE
33 , p_color_rollup_type IN BSC_KPIS_B.color_rollup_type%TYPE
34 , p_weighted_color_method IN BSC_KPIS_B.weighted_color_method%TYPE
35 , p_need_color_recalc IN VARCHAR2 := 'Y'
36 , x_return_status OUT NOCOPY VARCHAR2
37 , x_msg_count OUT NOCOPY NUMBER
38 , x_msg_data OUT NOCOPY VARCHAR2
39 );
40
41
42 /************************************************************************************
43 ************************************************************************************/
44
45 PROCEDURE Create_Update_Kpi_Mes_Weights (
46 p_commit IN VARCHAR2 := FND_API.G_FALSE
47 , p_objective_id IN BSC_KPIS_B.indicator%TYPE
48 , p_kpi_measure_id IN BSC_KPI_ANALYSIS_MEASURES_B.kpi_measure_id%TYPE
49 , p_kpi_weight IN BSC_KPI_MEASURE_WEIGHTS.weight%TYPE
50 , x_return_status OUT NOCOPY VARCHAR2
51 , x_msg_count OUT NOCOPY NUMBER
52 , x_msg_data OUT NOCOPY VARCHAR2
53 );
54
55
56 /************************************************************************************
57 ************************************************************************************/
58
59 PROCEDURE Obj_Prototype_Flag_Change (
60 p_objective_id IN BSC_KPIS_B.indicator%TYPE
61 , p_prototype_flag IN NUMBER
62 , x_return_status OUT NOCOPY VARCHAR2
63 , x_msg_count OUT NOCOPY NUMBER
64 , x_msg_data OUT NOCOPY VARCHAR2
65 );
66
67 /************************************************************************************
68 ************************************************************************************/
69
70 PROCEDURE Kpi_Prototype_Flag_Change (
71 p_objective_id IN BSC_KPIS_B.indicator%TYPE
72 , p_kpi_measure_id IN BSC_KPI_ANALYSIS_MEASURES_B.kpi_measure_id%TYPE
73 , p_prototype_flag IN NUMBER
74 , x_return_status OUT NOCOPY VARCHAR2
75 , x_msg_count OUT NOCOPY NUMBER
76 , x_msg_data OUT NOCOPY VARCHAR2
77 );
78
79 /************************************************************************************
80 ************************************************************************************/
81
82 PROCEDURE Change_Prototype_Flag (
83 p_objective_id IN BSC_KPIS_B.indicator%TYPE
84 , p_kpi_measure_id IN BSC_KPI_ANALYSIS_MEASURES_B.kpi_measure_id%TYPE
85 , p_prototype_flag IN NUMBER
86 , x_return_status OUT NOCOPY VARCHAR2
87 , x_msg_count OUT NOCOPY NUMBER
88 , x_msg_data OUT NOCOPY VARCHAR2
89 );
90
91
92 /************************************************************************************
93 ************************************************************************************/
94
95 PROCEDURE Save_Disable_Color_Of_Kpi (
96 p_commit IN VARCHAR2 := FND_API.G_FALSE
97 , p_objective_id IN BSC_KPIS_B.indicator%TYPE
98 , p_kpi_measure_id IN BSC_KPI_ANALYSIS_MEASURES_B.kpi_measure_id%TYPE
99 , p_disable_color IN BSC_KPI_MEASURE_PROPS.disable_color%TYPE
100 , p_need_color_recalc IN VARCHAR2 := 'N'
101 , x_return_status OUT NOCOPY VARCHAR2
102 , x_msg_count OUT NOCOPY NUMBER
103 , x_msg_data OUT NOCOPY VARCHAR2
104 );
105
106 END BSC_KPI_COLOR_PROPERTIES_PUB;