[Home] [Help]
PACKAGE: APPS.BSC_KPI_PUB
Source
1 package BSC_KPI_PUB as
2 /* $Header: BSCPKPPS.pls 120.10 2007/04/02 18:06:51 akoduri ship $ */
3 /*
4 +======================================================================================+
5 | Copyright (c) 2001 Oracle Corporation, Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +======================================================================================+
8 | FILENAME |
9 | BSCPKKPS.pls |
10 | |
11 | Creation Date: |
12 | October 22, 2001 |
13 | |
14 | Creator: |
15 | Mario-Jair Campos |
16 | |
17 | Description: |
18 | Public Spec version. |
19 | This package Creates, Retrieve, Update, Delete |
20 | for BSC KPI information. |
21 | 31-JUl-2003 mahrao Changed the record Bsc_Kpi_Entity_Rec for bug# 3030788 |
22 | 14-NOV-2003 ADRAO Modified for Bug #3248729, |
23 | 11-MAR-04 jxyu Modified for enhancement #3493589 |
24 | 18-MAY-04 adrao Modified PL/SQL records and CRUD to accept SHORT_NAME |
25 | 18-JUN-04 adrao Modified PL/SQL record Bsc_Kpi_Entity_Rec to add |
26 | Bsc_Kpi_Ana_Group_Short_Name for BSC_KPI_ANALYSIS_GROUPS |
27 | 15-DEC-04 adrao moved here the API Delete_Kpi_AT to be public to all |
28 | fixed for Bug#4064587 |
29 | 21-FEB-2005 ankagarw enh#3862703 |
30 | 21-JUL-2005 ashankar Bug#4314386 |
31 | 22-AUG-2005 ashankar Bug#4220400 added Bsc_Anal_Opt_Comb_Tbl to |
32 | Bsc_Kpi_Entity_Rec |
33 | 03-AUG-2006 ashankar bug#5400575 modified move_master_kpi |
34 | 16-NOV-2006 ankgoel Color By KPI enh#5244136 |
35 | 16-NOV-2006 vtulasi Color By KPI enh#5244136 |
36 | 31-Jan-2007 akoduri Enh #5679096 Migration of multibar functionality from |
37 | VB to Html |
38 | 21-MAR-2007 akoduri Copy Indicator Enh#5943238 |
39 +======================================================================================+
40 */
41 -- Added for Bug #3248729
42 DELETE_KPI_FLAG CONSTANT NUMBER := 2; -- BSC_KPIS_B.PROTOTYPE_FLAG to indicate DELETED KPI
43
44 BENCHMARK_KPI_PROPERTY CONSTANT VARCHAR(20) := 'BENCHMARK_GRAPH_TYPE';
45 BENCHMARK_KPI_LINE_GRAPH CONSTANT NUMBER := 0; --this is the default graph type
46 BENCHMARK_KPI_BAR_GRAPH CONSTANT NUMBER := 1;
47 c_IND_LEVEL CONSTANT VARCHAR2(3) := 'KPI';
48 c_IND_TYPE CONSTANT NUMBER := 2;
49
50 /* Record Type for Kpi Entities. */
51
52 TYPE Bsc_Kpi_Entity_Rec is RECORD(
53 Bsc_Anal_Group_Id number -- Kpi
54 ,Bsc_Calendar_Id number -- Kpi
55 ,Bsc_Change_Dim_Set number -- Kpi
56 ,Bsc_Csf_Id number -- Tab, Group
57 -- ,Bsc_Default_Value number -- Kpi
58 ,Bsc_Dependency_Flag number -- Kpi
59 ,Bsc_gp_Dependency_Flag number -- Kpi grand parent dependency flag
60 ,Bsc_Dim_Set_Id number
61 ,Bsc_Edw_Flag number -- Kpi
62 ,Bsc_Group_Height number -- Group
63 ,Bsc_Group_Width number -- Group
64 ,Bsc_Kpi_Analysis_Option0 number
65 ,Bsc_Kpi_Analysis_Option1 number
66 ,Bsc_Kpi_Analysis_Option2 number
67 ,Bsc_Kpi_Anal_Disp_Flag number
68 ,Bsc_Kpi_Anal_Opt0_Name Bsc_kpi_defaults_tl.ANALYSIS_OPTION0_NAME%TYPE -- Kpi
69 ,Bsc_Kpi_Anal_Opt1_Name Bsc_kpi_defaults_tl.ANALYSIS_OPTION1_NAME%TYPE -- Kpi
70 ,Bsc_Kpi_Anal_Opt2_Name Bsc_kpi_defaults_tl.ANALYSIS_OPTION2_NAME%TYPE -- Kpi
71 ,Bsc_Kpi_Anal_Opt_Id number
72 ,Bsc_Kpi_Backcolor number -- Kpi
73 ,Bsc_Kpi_Bm_Group_Id number -- Kpi
74 ,Bsc_Kpi_Calculation_Id number -- Kpi
75 ,Bsc_Kpi_Color_Flag number -- Kpi
76 --,Bsc_Kpi_Color_Level1 number -- Kpi
77 --,Bsc_Kpi_Color_Level2 number -- Kpi
78 --,Bsc_Kpi_Color_Level3 number -- Kpi
79 --,Bsc_Kpi_Color_Level4 number -- Kpi
80 ,Bsc_Kpi_Color_Method number -- Kpi
81 ,Bsc_Kpi_Config_Type number -- Kpi
82 ,Bsc_Kpi_Current_Period number -- Kpi
83 ,Bsc_Kpi_Default_Value number -- Kpi
84 ,Bsc_Kpi_Dim_Level1_Name BSC_KPI_DEFAULTS_TL.DIM_LEVEL1_NAME%TYPE -- Kpi
85 ,Bsc_Kpi_Dim_Level2_Name BSC_KPI_DEFAULTS_TL.DIM_LEVEL2_NAME%TYPE -- Kpi
86 ,Bsc_Kpi_Dim_Level3_Name BSC_KPI_DEFAULTS_TL.DIM_LEVEL3_NAME%TYPE -- Kpi
87 ,Bsc_Kpi_Dim_Level4_Name BSC_KPI_DEFAULTS_TL.DIM_LEVEL4_NAME%TYPE -- Kpi
88 ,Bsc_Kpi_Dim_Level5_Name BSC_KPI_DEFAULTS_TL.DIM_LEVEL5_NAME%TYPE -- Kpi
89 ,Bsc_Kpi_Dim_Level6_Name BSC_KPI_DEFAULTS_TL.DIM_LEVEL6_NAME%TYPE -- Kpi
90 ,Bsc_Kpi_Dim_Level7_Name BSC_KPI_DEFAULTS_TL.DIM_LEVEL7_NAME%TYPE -- Kpi
91 ,Bsc_Kpi_Dim_Level8_Name BSC_KPI_DEFAULTS_TL.DIM_LEVEL8_NAME%TYPE -- Kpi
92 ,Bsc_Kpi_Dim_Level1_Text varchar2(240) -- Kpi
93 ,Bsc_Kpi_Dim_Level2_Text varchar2(240) -- Kpi
94 ,Bsc_Kpi_Dim_Level3_Text varchar2(240) -- Kpi
95 ,Bsc_Kpi_Dim_Level4_Text varchar2(240) -- Kpi
96 ,Bsc_Kpi_Dim_Level5_Text varchar2(240) -- Kpi
97 ,Bsc_Kpi_Dim_Level6_Text varchar2(240) -- Kpi
98 ,Bsc_Kpi_Dim_Level7_Text varchar2(240) -- Kpi
99 ,Bsc_Kpi_Dim_Level8_Text varchar2(240) -- Kpi
100 ,Bsc_Kpi_Dim_Level1_Value number -- Kpi
101 ,Bsc_Kpi_Dim_Level2_Value number -- Kpi
102 ,Bsc_Kpi_Dim_Level3_Value number -- Kpi
103 ,Bsc_Kpi_Dim_Level4_Value number -- Kpi
104 ,Bsc_Kpi_Dim_Level5_Value number -- Kpi
105 ,Bsc_Kpi_Dim_Level6_Value number -- Kpi
106 ,Bsc_Kpi_Dim_Level7_Value number -- Kpi
107 ,Bsc_Kpi_Dim_Level8_Value number -- Kpi
108 ,Bsc_Kpi_Dim_Set_Id number -- Kpi
109 -- ,Bsc_Kpi_Disp_Order number -- Kpi
110 ,Bsc_Kpi_Display_Order number -- Kpi
111 ,Bsc_Kpi_Group_Help varchar2(150) -- Group
112 ,Bsc_Kpi_Group_Id number -- Tab, Group
113 ,Bsc_Kpi_Group_Name varchar2(150) -- Group
114 ,Bsc_Kpi_Group_Type number -- Group
115 ,Bsc_Kpi_Help varchar2(150) -- Kpi
116 ,Bsc_Kpi_Filter_Condition varchar2(240) -- Kpi
117 ,Bsc_Kpi_Format_Mask varchar2(20) -- Kpi
118 ,Bsc_Kpi_Id number -- Kpi
119 ,Bsc_Kpi_Indicator_Type number -- Kpi
120 ,Bsc_Kpi_Level_Comb varchar2(30) -- Kpi
121 ,Bsc_Kpi_Model_Flag number -- Kpi
122 ,Bsc_Kpi_Name varchar2(150) -- Kpi
123 ,Bsc_Kpi_Num_Years number -- Kpi
124 ,Bsc_Kpi_Options_Displayed varchar2(300)
125 ,Bsc_Kpi_Periodicity_Display number -- Kpi
126 ,Bsc_Kpi_Periodicity_Id number -- Kpi
127 ,Bsc_Kpi_Period_Name varchar2(90) -- Kpi
128 ,Bsc_Kpi_Previous_Years number -- Kpi
129 ,Bsc_Kpi_Property_Code varchar2(20) -- Kpi
130 ,Bsc_Kpi_Property_Value number -- Kpi
131 ,Bsc_Kpi_Prototype_Color varchar2(5) -- Kpi
132 ,Bsc_Kpi_Prototype_Flag number -- Kpi
133 ,Bsc_Kpi_Publish_Flag number -- Kpi
134 ,Bsc_Kpi_Secondary_Value varchar2(200) -- Kpi
135 ,Bsc_Kpi_Series_Name Bsc_kpi_defaults_tl.SERIES_NAME%TYPE -- Kpi
136 ,Bsc_Kpi_Share_Flag number -- Kpi
137 ,Bsc_Kpi_Source_Ind number -- Kpi
138 ,Bsc_Kpi_Table_Name varchar2(30) -- Kpi
139 ,Bsc_Kpi_User_Level0 number -- Kpi
140 ,Bsc_Kpi_User_Level1 number -- Kpi
141 ,Bsc_Kpi_User_Level1_Default number -- Kpi
142 ,Bsc_Kpi_User_Level2 number -- Kpi
143 ,Bsc_Kpi_User_Level2_Default number -- Kpi
144 ,Bsc_Kpi_Viewport_Default_Size number -- Kpi
145 ,Bsc_Kpi_Viewport_Flag number -- Kpi
146 ,Bsc_Language varchar2(5)
147 ,Bsc_Left_Position_In_Tab number -- Group
148 ,Bsc_Measure_Source varchar2(10)
149 ,Bsc_Name_Justif_In_Tab number -- Group
150 ,Bsc_Name_Pos_In_Tab number -- Group
151 ,Bsc_Num_Options number -- Kpi
152 ,Bsc_Parent_Anal_Id number -- Kpi
153 ,Bsc_Responsibility_Id number -- Tab, Kpi
154 ,Bsc_Resp_End_Date date -- Tab
155 ,Bsc_Resp_Start_Date date -- Tab
156 ,Bsc_Source_Language varchar2(5)
157 ,Bsc_Tab_Id number -- Tab, Group
158 ,Bsc_Top_Position_In_Tab number -- Group
159 ,Created_By number -- Tab, Kpi
160 ,Creation_Date date -- Tab, Kpi
161 ,Last_Updated_By number -- Tab, Kpi
162 ,Last_Update_Date date -- Tab, Kpi
163 ,Last_Update_Login number -- Tab, Kpi
164 ,Bsc_Kpi_Short_Name BSC_KPIS_B.SHORT_NAME%TYPE
165 ,Bsc_Kpi_Ana_Group_Short_Name BSC_KPI_ANALYSIS_GROUPS.SHORT_NAME%TYPE
166 ,Bsc_Kpi_Dim_Set_Short_Name BSC_KPI_DIM_SETS_TL.SHORT_NAME%TYPE
167 ,Bsc_Anal_Opt_Comb_Tbl BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
168 ,Bsc_Color_Rollup_Type BSC_KPIS_B.COLOR_ROLLUP_TYPE%TYPE
169 ,Bsc_Prototype_Color_Id BSC_KPIS_B.PROTOTYPE_COLOR_ID%TYPE
170 ,Bsc_Weighted_Color_Method BSC_KPIS_B.WEIGHTED_COLOR_METHOD%TYPE
171 ,Bsc_Prototype_Trend_Id BSC_KPIS_B.PROTOTYPE_TREND_ID%TYPE
172 );
173
174 TYPE Bsc_Kpi_Entity_Tbl IS TABLE OF Bsc_Kpi_Entity_Rec
175 INDEX BY BINARY_INTEGER;
176
177 procedure Initialize_Kpi_Entity_Rec(
178 p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
179 ,x_Bsc_Kpi_Entity_Rec OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
180 ,x_return_status OUT NOCOPY varchar2
181 ,x_msg_count OUT NOCOPY number
182 ,x_msg_data OUT NOCOPY varchar2
183 );
184
185 procedure Create_Kpi(
186 p_commit IN varchar2 := FND_API.G_FALSE
187 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
188 ,x_return_status OUT NOCOPY varchar2
189 ,x_msg_count OUT NOCOPY number
190 ,x_msg_data OUT NOCOPY varchar2
191 );
192
193 procedure Create_Kpi(
194 p_commit IN varchar2 := FND_API.G_FALSE
195 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
196 ,x_Bsc_Kpi_Entity_Rec OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
197 ,x_return_status OUT NOCOPY varchar2
198 ,x_msg_count OUT NOCOPY number
199 ,x_msg_data OUT NOCOPY varchar2
200 );
201
202 procedure Retrieve_Kpi(
203 p_commit IN varchar2 := FND_API.G_FALSE
204 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
205 ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
206 ,x_return_status OUT NOCOPY varchar2
207 ,x_msg_count OUT NOCOPY number
208 ,x_msg_data OUT NOCOPY varchar2
209 );
210
211 procedure Update_Kpi(
212 p_commit IN varchar2 := FND_API.G_FALSE
213 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
214 ,x_return_status OUT NOCOPY varchar2
215 ,x_msg_count OUT NOCOPY number
216 ,x_msg_data OUT NOCOPY varchar2
217 );
218
219 procedure Delete_Kpi(
220 p_commit IN varchar2 := FND_API.G_FALSE
221 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
222 ,x_return_status OUT NOCOPY varchar2
223 ,x_msg_count OUT NOCOPY number
224 ,x_msg_data OUT NOCOPY varchar2
225 );
226
227 procedure Create_Kpi_Defaults(
228 p_commit IN varchar2 := FND_API.G_FALSE
229 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
230 ,x_return_status OUT NOCOPY varchar2
231 ,x_msg_count OUT NOCOPY number
232 ,x_msg_data OUT NOCOPY varchar2
233 );
234
235 procedure Retrieve_Kpi_Defaults(
236 p_commit IN varchar2 := FND_API.G_FALSE
237 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
238 ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
239 ,x_return_status OUT NOCOPY varchar2
240 ,x_msg_count OUT NOCOPY number
241 ,x_msg_data OUT NOCOPY varchar2
242 );
243
244 procedure Update_Kpi_Defaults(
245 p_commit IN varchar2 := FND_API.G_FALSE
246 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
247 ,x_return_status OUT NOCOPY varchar2
248 ,x_msg_count OUT NOCOPY number
249 ,x_msg_data OUT NOCOPY varchar2
250 );
251
252 procedure Delete_Kpi_Defaults(
253 p_commit IN varchar2 := FND_API.G_FALSE
254 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
255 ,x_return_status OUT NOCOPY varchar2
256 ,x_msg_count OUT NOCOPY number
257 ,x_msg_data OUT NOCOPY varchar2
258 );
259
260 procedure Create_Kpi_Properties(
261 p_commit IN varchar2 := FND_API.G_FALSE
262 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
263 ,x_return_status OUT NOCOPY varchar2
264 ,x_msg_count OUT NOCOPY number
265 ,x_msg_data OUT NOCOPY varchar2
266 );
267
268 procedure Retrieve_Kpi_Properties(
269 p_commit IN varchar2 := FND_API.G_FALSE
270 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
271 ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
272 ,x_return_status OUT NOCOPY varchar2
273 ,x_msg_count OUT NOCOPY number
274 ,x_msg_data OUT NOCOPY varchar2
275 );
276
277 procedure Update_Kpi_Properties(
278 p_commit IN varchar2 := FND_API.G_FALSE
279 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
280 ,x_return_status OUT NOCOPY varchar2
281 ,x_msg_count OUT NOCOPY number
282 ,x_msg_data OUT NOCOPY varchar2
283 );
284
285 procedure Delete_Kpi_Properties(
286 p_commit IN varchar2 := FND_API.G_FALSE
287 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
288 ,x_return_status OUT NOCOPY varchar2
289 ,x_msg_count OUT NOCOPY number
290 ,x_msg_data OUT NOCOPY varchar2
291 );
292
293 procedure Create_Kpi_Analysis(
294 p_commit IN varchar2 := FND_API.G_FALSE
295 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
296 ,x_return_status OUT NOCOPY varchar2
297 ,x_msg_count OUT NOCOPY number
298 ,x_msg_data OUT NOCOPY varchar2
299 );
300
301 procedure Retrieve_Kpi_Analysis(
302 p_commit IN varchar2 := FND_API.G_FALSE
303 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
304 ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
305 ,x_return_status OUT NOCOPY varchar2
306 ,x_msg_count OUT NOCOPY number
307 ,x_msg_data OUT NOCOPY varchar2
308 );
309
310 procedure Update_Kpi_Analysis(
311 p_commit IN varchar2 := FND_API.G_FALSE
312 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
316 );
313 ,x_return_status OUT NOCOPY varchar2
314 ,x_msg_count OUT NOCOPY number
315 ,x_msg_data OUT NOCOPY varchar2
317
318 procedure Delete_Kpi_Analysis(
319 p_commit IN varchar2 := FND_API.G_FALSE
320 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
321 ,x_return_status OUT NOCOPY varchar2
322 ,x_msg_count OUT NOCOPY number
323 ,x_msg_data OUT NOCOPY varchar2
324 );
325
326 procedure Create_Kpi_Periodicity(
327 p_commit IN varchar2 := FND_API.G_FALSE
328 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
329 ,x_return_status OUT NOCOPY varchar2
330 ,x_msg_count OUT NOCOPY number
331 ,x_msg_data OUT NOCOPY varchar2
332 );
333
334 procedure Retrieve_Kpi_Periodicity(
335 p_commit IN varchar2 := FND_API.G_FALSE
336 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
337 ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
338 ,x_return_status OUT NOCOPY varchar2
339 ,x_msg_count OUT NOCOPY number
340 ,x_msg_data OUT NOCOPY varchar2
341 );
342
343 procedure Update_Kpi_Periodicity(
344 p_commit IN varchar2 := FND_API.G_FALSE
345 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
346 ,x_return_status OUT NOCOPY varchar2
347 ,x_msg_count OUT NOCOPY number
348 ,x_msg_data OUT NOCOPY varchar2
349 );
350
351 procedure Delete_Kpi_Periodicity(
352 p_commit IN varchar2 := FND_API.G_FALSE
353 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
354 ,x_return_status OUT NOCOPY varchar2
355 ,x_msg_count OUT NOCOPY number
356 ,x_msg_data OUT NOCOPY varchar2
357 );
358
359 procedure Create_Kpi_Data_Tables(
360 p_commit IN varchar2 := FND_API.G_FALSE
361 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
362 ,x_return_status OUT NOCOPY varchar2
363 ,x_msg_count OUT NOCOPY number
364 ,x_msg_data OUT NOCOPY varchar2
365 );
366
367 procedure Retrieve_Kpi_Data_Tables(
368 p_commit IN varchar2 := FND_API.G_FALSE
369 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
370 ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
371 ,x_return_status OUT NOCOPY varchar2
372 ,x_msg_count OUT NOCOPY number
373 ,x_msg_data OUT NOCOPY varchar2
374 );
375
376 procedure Update_Kpi_Data_Tables(
377 p_commit IN varchar2 := FND_API.G_FALSE
378 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
379 ,x_return_status OUT NOCOPY varchar2
380 ,x_msg_count OUT NOCOPY number
381 ,x_msg_data OUT NOCOPY varchar2
382 );
383
384 procedure Delete_Kpi_Data_Tables(
385 p_commit IN varchar2 := FND_API.G_FALSE
386 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
387 ,x_return_status OUT NOCOPY varchar2
388 ,x_msg_count OUT NOCOPY number
389 ,x_msg_data OUT NOCOPY varchar2
390 );
391
392 procedure Create_Kpi_Calculations(
393 p_commit IN varchar2 := FND_API.G_FALSE
394 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
395 ,x_return_status OUT NOCOPY varchar2
396 ,x_msg_count OUT NOCOPY number
397 ,x_msg_data OUT NOCOPY varchar2
398 );
399
400 procedure Retrieve_Kpi_Calculations(
401 p_commit IN varchar2 := FND_API.G_FALSE
402 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
403 ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
404 ,x_return_status OUT NOCOPY varchar2
405 ,x_msg_count OUT NOCOPY number
406 ,x_msg_data OUT NOCOPY varchar2
407 );
408
409 procedure Update_Kpi_Calculations(
410 p_commit IN varchar2 := FND_API.G_FALSE
411 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
412 ,x_return_status OUT NOCOPY varchar2
413 ,x_msg_count OUT NOCOPY number
414 ,x_msg_data OUT NOCOPY varchar2
415 );
416
417 procedure Delete_Kpi_Calculations(
418 p_commit IN varchar2 := FND_API.G_FALSE
419 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
420 ,x_return_status OUT NOCOPY varchar2
421 ,x_msg_count OUT NOCOPY number
422 ,x_msg_data OUT NOCOPY varchar2
423 );
424
425 procedure Create_Kpi_User_Access(
426 p_commit IN varchar2 := FND_API.G_FALSE
427 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
428 ,x_return_status OUT NOCOPY varchar2
429 ,x_msg_count OUT NOCOPY number
430 ,x_msg_data OUT NOCOPY varchar2
431 );
432
433 PROCEDURE Create_Kpi_Access_For_Resp(
434 p_commit IN VARCHAR2 := FND_API.G_FALSE
435 ,p_Comma_Sep_Resposibility_Key IN VARCHAR2
436 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
440 );
437 ,x_return_status OUT NOCOPY VARCHAR2
438 ,x_msg_count OUT NOCOPY NUMBER
439 ,x_msg_data OUT NOCOPY VARCHAR2
441
442 procedure Retrieve_Kpi_User_Access(
443 p_commit IN varchar2 := FND_API.G_FALSE
444 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
445 ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
446 ,x_return_status OUT NOCOPY varchar2
447 ,x_msg_count OUT NOCOPY number
448 ,x_msg_data OUT NOCOPY varchar2
449 );
450
451 procedure Update_Kpi_User_Access(
452 p_commit IN varchar2 := FND_API.G_FALSE
453 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
454 ,x_return_status OUT NOCOPY varchar2
455 ,x_msg_count OUT NOCOPY number
456 ,x_msg_data OUT NOCOPY varchar2
457 );
458
459 procedure Delete_Kpi_User_Access(
460 p_commit IN varchar2 := FND_API.G_FALSE
461 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
462 ,x_return_status OUT NOCOPY varchar2
463 ,x_msg_count OUT NOCOPY number
464 ,x_msg_data OUT NOCOPY varchar2
465 );
466
467 procedure Create_Kpi_Default_Values(
468 p_commit IN varchar2 := FND_API.G_FALSE
469 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
470 ,x_return_status OUT NOCOPY varchar2
471 ,x_msg_count OUT NOCOPY number
472 ,x_msg_data OUT NOCOPY varchar2
473 );
474
475 procedure Retrieve_Kpi_Default_Values(
476 p_commit IN varchar2 := FND_API.G_FALSE
477 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
478 ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
479 ,x_return_status OUT NOCOPY varchar2
480 ,x_msg_count OUT NOCOPY number
481 ,x_msg_data OUT NOCOPY varchar2
482 );
483
484 procedure Update_Kpi_Default_Values(
485 p_commit IN varchar2 := FND_API.G_FALSE
486 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
487 ,x_return_status OUT NOCOPY varchar2
488 ,x_msg_count OUT NOCOPY number
489 ,x_msg_data OUT NOCOPY varchar2
490 );
491
492 procedure Delete_Kpi_Default_Values(
493 p_commit IN varchar2 := FND_API.G_FALSE
494 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
495 ,x_return_status OUT NOCOPY varchar2
496 ,x_msg_count OUT NOCOPY number
497 ,x_msg_data OUT NOCOPY varchar2
498 );
499
500 procedure Create_Kpi_In_Tab(
501 p_commit IN varchar2 := FND_API.G_FALSE
502 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
503 ,x_return_status OUT NOCOPY varchar2
504 ,x_msg_count OUT NOCOPY number
505 ,x_msg_data OUT NOCOPY varchar2
506 );
507
508 procedure Retrieve_Kpi_In_Tab(
509 p_commit IN varchar2 := FND_API.G_FALSE
510 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
511 ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
512 ,x_return_status OUT NOCOPY varchar2
513 ,x_msg_count OUT NOCOPY number
514 ,x_msg_data OUT NOCOPY varchar2
515 );
516
517 procedure Update_Kpi_In_Tab(
518 p_commit IN varchar2 := FND_API.G_FALSE
519 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
520 ,x_return_status OUT NOCOPY varchar2
521 ,x_msg_count OUT NOCOPY number
522 ,x_msg_data OUT NOCOPY varchar2
523 );
524
525 procedure Delete_Kpi_In_Tab(
526 p_commit IN varchar2 := FND_API.G_FALSE
527 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
528 ,x_return_status OUT NOCOPY varchar2
529 ,x_msg_count OUT NOCOPY number
530 ,x_msg_data OUT NOCOPY varchar2
531 );
532
533 procedure Update_Kpi_Time_Stamp(
534 p_commit IN varchar2 := FND_API.G_FALSE
535 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
536 ,x_return_status OUT NOCOPY varchar2
537 ,x_msg_count OUT NOCOPY number
538 ,x_msg_data OUT NOCOPY varchar2
539 );
540
541 procedure Create_Shared_Kpi(
542 p_commit IN varchar2 := FND_API.G_FALSE
543 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
544 ,x_return_status OUT NOCOPY varchar2
545 ,x_msg_count OUT NOCOPY number
546 ,x_msg_data OUT NOCOPY varchar2
547 );
548
549 procedure Create_Master_Kpi(
550 p_commit IN varchar2 := FND_API.G_FALSE
551 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
552 ,x_return_status OUT NOCOPY varchar2
553 ,x_msg_count OUT NOCOPY number
554 ,x_msg_data OUT NOCOPY varchar2
555 );
556
557 procedure Set_Default_Option(
558 p_commit IN varchar2 := FND_API.G_FALSE
559 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
560 ,x_return_status OUT NOCOPY varchar2
561 ,x_msg_count OUT NOCOPY number
562 ,x_msg_data OUT NOCOPY varchar2
563 );
567 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
564
565 procedure Set_Default_Option_MG(
566 p_commit IN varchar2 := FND_API.G_FALSE
568 ,x_return_status OUT NOCOPY varchar2
569 ,x_msg_count OUT NOCOPY number
570 ,x_msg_data OUT NOCOPY varchar2
571 );
572
573
574 procedure Assign_Analysis_Option(
575 p_Bsc_kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_kpi_Entity_Rec
576 ,x_return_status OUT NOCOPY varchar2
577 ,x_msg_count OUT NOCOPY number
578 ,x_msg_data OUT NOCOPY varchar2
579 );
580
581 procedure Unassign_Analysis_Option(
582 p_Bsc_kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_kpi_Entity_Rec
583 ,x_return_status OUT NOCOPY varchar2
584 ,x_msg_count OUT NOCOPY number
585 ,x_msg_data OUT NOCOPY varchar2
586 );
587
588 function Is_Analysis_Option_Selected(
589 p_Bsc_kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_kpi_Entity_Rec
590 ,x_return_status OUT NOCOPY varchar2
591 ,x_msg_count OUT NOCOPY number
592 ,x_msg_data OUT NOCOPY varchar2
593 ) return varchar2;
594
595 function Is_Leaf_Analysis_Option(
596 p_Bsc_kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_kpi_Entity_Rec
597 ,x_return_status OUT NOCOPY varchar2
598 ,x_msg_count OUT NOCOPY number
599 ,x_msg_data OUT NOCOPY varchar2
600 ) return varchar2;
601
602 function get_KPI_Time_Stamp(
603 p_kpi_id IN number
604 ) return date;
605
606 procedure move_master_kpi(
607 p_master_kpi IN NUMBER
608 ,x_return_status OUT NOCOPY varchar2
609 ,x_msg_count OUT NOCOPY number
610 ,x_msg_data OUT NOCOPY varchar2
611 );
612
613 /******************************************************************
614 DELETE APIS FOR OBJECTIVES
615 /*****************************************************************/
616
617 PROCEDURE Delete_Ind_User_Access
618 (
619 p_commit IN VARCHAR2 := FND_API.G_FALSE
620 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC
621 ,x_return_status OUT NOCOPY VARCHAR2
622 ,x_msg_count OUT NOCOPY NUMBER
623 ,x_msg_data OUT NOCOPY VARCHAR2
624 );
625
626
627 PROCEDURE Delete_Ind_Tree_Nodes
628 (
629 p_commit IN VARCHAR2 := FND_API.G_FALSE
630 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC
631 ,x_return_status OUT NOCOPY VARCHAR2
632 ,x_msg_count OUT NOCOPY NUMBER
633 ,x_msg_data OUT NOCOPY VARCHAR2
634 );
635
636 PROCEDURE Delete_Ind_Comments
637 (
638 p_commit IN VARCHAR2 := FND_API.G_FALSE
639 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC
640 ,x_return_status OUT NOCOPY VARCHAR2
641 ,x_msg_count OUT NOCOPY NUMBER
642 ,x_msg_data OUT NOCOPY VARCHAR2
643 );
644
645 PROCEDURE Delete_Ind_Sys_Prop
646 (
647 p_commit IN VARCHAR2 := FND_API.G_FALSE
648 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC
649 ,x_return_status OUT NOCOPY VARCHAR2
650 ,x_msg_count OUT NOCOPY NUMBER
651 ,x_msg_data OUT NOCOPY VARCHAR2
652 );
653
654 PROCEDURE Delete_Ind_Images
655 (
656 p_commit IN VARCHAR2 := FND_API.G_FALSE
657 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC
658 ,x_return_status OUT NOCOPY VARCHAR2
659 ,x_msg_count OUT NOCOPY NUMBER
660 ,x_msg_data OUT NOCOPY VARCHAR2
661 );
662
663 PROCEDURE Delete_Ind_SeriesColors
664 (
668 ,x_msg_count OUT NOCOPY NUMBER
665 p_commit IN VARCHAR2 := FND_API.G_FALSE
666 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC
667 ,x_return_status OUT NOCOPY VARCHAR2
669 ,x_msg_data OUT NOCOPY VARCHAR2
670 );
671
672 PROCEDURE Delete_Ind_Subtitles
673 (
674 p_commit IN VARCHAR2 := FND_API.G_FALSE
675 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC
676 ,x_return_status OUT NOCOPY VARCHAR2
677 ,x_msg_count OUT NOCOPY NUMBER
678 ,x_msg_data OUT NOCOPY VARCHAR2
679 );
680
681 PROCEDURE Delete_Ind_MM_Controls
682 (
683 p_commit IN VARCHAR2 := FND_API.G_FALSE
684 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC
685 ,x_return_status OUT NOCOPY VARCHAR2
686 ,x_msg_count OUT NOCOPY NUMBER
687 ,x_msg_data OUT NOCOPY VARCHAR2
688 );
689
690 PROCEDURE Delete_Ind_Shell_Cmds
691 (
692 p_commit IN VARCHAR2 := FND_API.G_FALSE
693 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC
694 ,x_return_status OUT NOCOPY VARCHAR2
695 ,x_msg_count OUT NOCOPY NUMBER
696 ,x_msg_data OUT NOCOPY VARCHAR2
697 );
698
699 PROCEDURE Delete_Ind_Cause_Effect_Rels(
700 p_commit IN VARCHAR2 := FND_API.G_FALSE
701 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC
702 ,x_return_status OUT NOCOPY VARCHAR2
703 ,x_msg_count OUT NOCOPY NUMBER
704 ,x_msg_data OUT NOCOPY VARCHAR2
705 );
706
707
708 PROCEDURE Delete_Ind_Extra_Tables
709 (
710 p_commit IN VARCHAR2 := FND_API.G_FALSE
711 , p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC
712 , x_return_status OUT NOCOPY VARCHAR2
713 , x_msg_count OUT NOCOPY NUMBER
714 , x_msg_data OUT NOCOPY VARCHAR2
715
716 );
717
718 PROCEDURE Delete_Sim_Tree_Data
719 (
720 p_commit IN VARCHAR2 := FND_API.G_FALSE
721 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC
722 ,x_return_status OUT NOCOPY VARCHAR2
723 ,x_msg_count OUT NOCOPY NUMBER
724 ,x_msg_data OUT NOCOPY VARCHAR2
725 );
726
727 PROCEDURE Get_KPI_Dim_ShortNames (
728 p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
729 ,x_dim_list OUT NOCOPY BSC_UTILITY.t_array_of_varchar2
730 ,x_return_status OUT NOCOPY varchar2
731 ,x_msg_count OUT NOCOPY number
732 ,x_msg_data OUT NOCOPY varchar2
733 );
734
735 PROCEDURE Delete_Unused_Imported_Dims(
736 p_commit IN VARCHAR2 := FND_API.G_FALSE
737 ,p_dim_short_names IN BSC_UTILITY.t_array_of_varchar2
738 ,x_return_status OUT NOCOPY varchar2
739 ,x_msg_count OUT NOCOPY number
740 ,x_msg_data OUT NOCOPY varchar2
741 );
742
743 procedure Delete_Objective_Color_Data(
744 p_commit IN varchar2 := FND_API.G_FALSE
745 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
746 ,x_return_status OUT NOCOPY varchar2
747 ,x_msg_count OUT NOCOPY number
748 ,x_msg_data OUT NOCOPY varchar2
749 );
750
751 end BSC_KPI_PUB;