1 PACKAGE BSC_COLOR_RANGES_PUB AS
2 /* $Header: BSCPCRNS.pls 120.2.12000000.1 2007/07/17 07:43:53 appldev noship $ */
3 /*
4 +======================================================================================+
5 | Copyright (c) 2001 Oracle Corporation, Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +======================================================================================+
8 | FILENAME |
9 | BSCPCRNS.pls |
10 | |
11 | Creation Date: |
12 | October 26, 2006 |
13 | |
14 | Creator: |
15 | Pradeep Pandey |
16 | |
17 | Description: Public Spec version. |
18 | This package is to manage System level Color properties |
19 | and provide CRUD APIs for BSC_COLOR_RANGES_B related table |
20 | |
21 | 26-JUN-2007 ankgoel Bug#6132361 - Handled PL objectives |
22 +======================================================================================+
23 */
24
25 G_PKG_NAME CONSTANT VARCHAR2(30) := 'BSC_COLOR_RANGES_PUB';
26
27 TYPE BSC_COLOR_RANGE_OBJ IS RECORD (
28 color_range_id bsc_color_ranges.color_range_id%TYPE
29 ,color_range_sequence bsc_color_ranges.color_range_sequence%TYPE
30 ,low bsc_color_ranges.low%TYPE
31 ,high bsc_color_ranges.high%TYPE
32 ,color_id bsc_color_ranges.color_id%TYPE
33 ,user_id NUMBER
34 );
35
36 TYPE BSC_COLOR_RANGE_REC IS TABLE OF BSC_COLOR_RANGE_OBJ
37 INDEX BY BINARY_INTEGER;
38 /************************************************************************************
39 ************************************************************************************/
40 PROCEDURE Create_Color_Prop_Ranges(
41 p_commit IN VARCHAR2 := FND_API.G_FALSE
42 ,p_objective_id IN NUMBER
43 ,p_kpi_measure_id IN NUMBER
44 ,p_color_type IN VARCHAR2 -- PERCENT_OF_TARGET, PERCENT_OF_KPI, CONSTANT
45 ,p_threshold_color IN THRESHOLD_ARRAY
46 ,p_property_value IN VARCHAR2 := NULL
47 ,x_return_status OUT NOCOPY VARCHAR2
48 ,x_msg_count OUT NOCOPY NUMBER
49 ,x_msg_data OUT NOCOPY VARCHAR2
50 ) ;
51
52 /************************************************************************************
53 ************************************************************************************/
54 PROCEDURE create_def_color_prop_ranges (
55 p_commit IN VARCHAR2 := FND_API.G_FALSE
56 ,p_objective_id IN NUMBER
57 ,p_kpi_measure_id IN NUMBER
58 ,p_property_value IN NUMBER := NULL
59 ,p_cascade_shared IN BOOLEAN
60 ,x_return_status OUT NOCOPY VARCHAR2
61 ,x_msg_count OUT NOCOPY NUMBER
62 ,x_msg_data OUT NOCOPY VARCHAR2
63 );
64
65 PROCEDURE create_pl_def_clr_prop_ranges (
66 p_commit IN VARCHAR2 := FND_API.G_FALSE
67 ,p_objective_id IN NUMBER
68 ,p_kpi_measure_id IN NUMBER
69 ,p_cascade_shared IN BOOLEAN
70 ,x_return_status OUT NOCOPY VARCHAR2
71 ,x_msg_count OUT NOCOPY NUMBER
72 ,x_msg_data OUT NOCOPY VARCHAR2
73 );
74
75 /************************************************************************************
76 ************************************************************************************/
77 PROCEDURE Create_Color_Prop_Ranges(
78 p_commit IN VARCHAR2 := FND_API.G_FALSE
79 ,p_objective_id IN NUMBER
80 ,p_kpi_measure_id IN NUMBER
81 ,p_color_type IN VARCHAR2 -- PERCENT_OF_TARGET, PERCENT_OF_KPI, CONSTANT
82 ,p_threshold_color IN VARCHAR2
83 ,x_return_status OUT NOCOPY VARCHAR2
84 ,x_msg_count OUT NOCOPY NUMBER
85 ,x_msg_data OUT NOCOPY VARCHAR2
86 ) ;
87
88 /************************************************************************************
89 ************************************************************************************/
90 PROCEDURE Create_Color_Ranges(
91 p_commit IN VARCHAR2 := FND_API.G_FALSE
92 ,p_color_range_id IN NUMBER
93 ,p_threshold_color IN VARCHAR2
94 ,x_return_status OUT NOCOPY VARCHAR2
95 ,x_msg_count OUT NOCOPY NUMBER
96 ,x_msg_data OUT NOCOPY VARCHAR2
97 );
98
99 /************************************************************************************
100 ************************************************************************************/
101 PROCEDURE Save_Color_Prop_Ranges(
102 p_commit IN VARCHAR2 := FND_API.G_FALSE
103 ,p_objective_id IN NUMBER
104 ,p_kpi_measure_id IN NUMBER
105 ,p_color_type IN VARCHAR2 -- PERCENT_OF_TARGET, PERCENT_OF_KPI, CONSTANT
106 ,p_threshold_color IN VARCHAR2
107 ,p_property_value IN NUMBER := NULL
108 ,p_cascade_shared IN BOOLEAN
109 ,p_time_stamp IN DATE := NULL -- Granular Locking
110 ,x_return_status OUT NOCOPY VARCHAR2
111 ,x_msg_count OUT NOCOPY NUMBER
112 ,x_msg_data OUT NOCOPY VARCHAR2
113 );
114
115 /************************************************************************************
116 ************************************************************************************/
117 PROCEDURE Save_Color_Prop_Ranges(
118 p_commit IN VARCHAR2 := FND_API.G_FALSE
119 ,p_objective_id IN NUMBER
120 ,p_kpi_measure_id IN NUMBER
121 ,p_color_type IN VARCHAR2 -- PERCENT_OF_TARGET, PERCENT_OF_KPI, CONSTANT
122 ,p_threshold_color IN THRESHOLD_ARRAY
123 ,p_property_value IN NUMBER := NULL
124 ,p_cascade_shared IN BOOLEAN
125 ,p_time_stamp IN DATE := NULL -- Granular Locking
126 ,x_return_status OUT NOCOPY VARCHAR2
127 ,x_msg_count OUT NOCOPY NUMBER
128 ,x_msg_data OUT NOCOPY VARCHAR2
129 );
130
131 /************************************************************************************
132 ************************************************************************************/
133 PROCEDURE Update_Color_Prop_Ranges(
134 p_commit IN VARCHAR2 := FND_API.G_FALSE
135 ,p_objective_id IN NUMBER
136 ,p_kpi_measure_id IN NUMBER
137 ,p_color_type IN VARCHAR2 -- PERCENT_OF_TARGET, PERCENT_OF_KPI, CONSTANT
138 ,p_threshold_color IN THRESHOLD_ARRAY
139 ,p_property_value IN NUMBER := NULL
140 ,p_time_stamp IN DATE := NULL -- Granular Locking
141 ,x_return_status OUT NOCOPY VARCHAR2
142 ,x_msg_count OUT NOCOPY NUMBER
143 ,x_msg_data OUT NOCOPY VARCHAR2
144 );
145
146 /************************************************************************************
147 ************************************************************************************/
148 PROCEDURE Delete_Color_Prop_Ranges (
149 p_commit IN VARCHAR2:= FND_API.G_FALSE
150 ,p_objective_id IN NUMBER
151 ,p_kpi_measure_id IN NUMBER := NULL
152 ,p_cascade_shared IN BOOLEAN
153 ,x_return_status OUT NOCOPY VARCHAR2
154 ,x_msg_count OUT NOCOPY NUMBER
155 ,x_msg_data OUT NOCOPY VARCHAR2
156 );
157
158 /************************************************************************************
159 ************************************************************************************/
160 PROCEDURE Delete_Color_Prop_Ranges (
161 p_commit IN VARCHAR2:= FND_API.G_FALSE
162 ,p_color_range_id IN NUMBER
163 ,x_return_status OUT NOCOPY VARCHAR2
164 ,x_msg_count OUT NOCOPY NUMBER
165 ,x_msg_data OUT NOCOPY VARCHAR2
166 );
167
168 /************************************************************************************
169 ************************************************************************************/
170 FUNCTION Get_Next_Token(
171 p_token_string IN OUT NOCOPY VARCHAR2
172 ,p_tokenizer IN VARCHAR2
173 ,x_value OUT NOCOPY VARCHAR2
174 ) RETURN BOOLEAN ;
175
176 FUNCTION Get_Color_Method(
177 p_objective_id IN NUMBER
178 ,p_kpi_measure_id IN NUMBER
179 ) RETURN NUMBER;
180
181 END BSC_COLOR_RANGES_PUB;