[Home] [Help]
PACKAGE: APPS.BSC_KPI_PVT
Source
1 package BSC_KPI_PVT as
2 /* $Header: BSCVKPPS.pls 120.3 2007/02/09 09:18:28 ashankar ship $ */
3
4
5 c_SIM_TAB_ID CONSTANT NUMBER := -999;
6
7 procedure Create_Kpi(
8 p_commit IN varchar2 := FND_API.G_FALSE
9 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
10 ,x_return_status OUT NOCOPY varchar2
11 ,x_msg_count OUT NOCOPY number
12 ,x_msg_data OUT NOCOPY varchar2
13 );
14
15 procedure Retrieve_Kpi(
16 p_commit IN varchar2 := FND_API.G_FALSE
17 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
18 ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
19 ,x_return_status OUT NOCOPY varchar2
20 ,x_msg_count OUT NOCOPY number
21 ,x_msg_data OUT NOCOPY varchar2
22 );
23
24 procedure Update_Kpi(
25 p_commit IN varchar2 := FND_API.G_FALSE
26 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
27 ,x_return_status OUT NOCOPY varchar2
28 ,x_msg_count OUT NOCOPY number
29 ,x_msg_data OUT NOCOPY varchar2
30 );
31
32 procedure Delete_Kpi(
33 p_commit IN varchar2 := FND_API.G_FALSE
34 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
35 ,x_return_status OUT NOCOPY varchar2
36 ,x_msg_count OUT NOCOPY number
37 ,x_msg_data OUT NOCOPY varchar2
38 );
39
40 procedure Create_Kpi_Defaults(
41 p_commit IN varchar2 := FND_API.G_FALSE
42 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
43 ,x_return_status OUT NOCOPY varchar2
44 ,x_msg_count OUT NOCOPY number
45 ,x_msg_data OUT NOCOPY varchar2
46 );
47
48 procedure Retrieve_Kpi_Defaults(
49 p_commit IN varchar2 := FND_API.G_FALSE
50 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
51 ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
52 ,x_return_status OUT NOCOPY varchar2
53 ,x_msg_count OUT NOCOPY number
54 ,x_msg_data OUT NOCOPY varchar2
55 );
56
57 procedure Update_Kpi_Defaults(
58 p_commit IN varchar2 := FND_API.G_FALSE
59 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
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 Delete_Kpi_Defaults(
66 p_commit IN varchar2 := FND_API.G_FALSE
67 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
68 ,x_return_status OUT NOCOPY varchar2
69 ,x_msg_count OUT NOCOPY number
70 ,x_msg_data OUT NOCOPY varchar2
71 );
72
73 procedure Create_Kpi_Properties(
74 p_commit IN varchar2 := FND_API.G_FALSE
75 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
76 ,x_return_status OUT NOCOPY varchar2
77 ,x_msg_count OUT NOCOPY number
78 ,x_msg_data OUT NOCOPY varchar2
79 );
80
81 procedure Retrieve_Kpi_Properties(
82 p_commit IN varchar2 := FND_API.G_FALSE
83 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
84 ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
85 ,x_return_status OUT NOCOPY varchar2
86 ,x_msg_count OUT NOCOPY number
87 ,x_msg_data OUT NOCOPY varchar2
88 );
89
90 procedure Update_Kpi_Properties(
91 p_commit IN varchar2 := FND_API.G_FALSE
92 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
93 ,x_return_status OUT NOCOPY varchar2
94 ,x_msg_count OUT NOCOPY number
95 ,x_msg_data OUT NOCOPY varchar2
96 );
97
98 procedure Delete_Kpi_Properties(
99 p_commit IN varchar2 := FND_API.G_FALSE
100 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
101 ,x_return_status OUT NOCOPY varchar2
102 ,x_msg_count OUT NOCOPY number
103 ,x_msg_data OUT NOCOPY varchar2
104 );
105
106 procedure Create_Kpi_Analysis(
107 p_commit IN varchar2 := FND_API.G_FALSE
108 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
109 ,x_return_status OUT NOCOPY varchar2
110 ,x_msg_count OUT NOCOPY number
111 ,x_msg_data OUT NOCOPY varchar2
112 );
113
114 procedure Retrieve_Kpi_Analysis(
115 p_commit IN varchar2 := FND_API.G_FALSE
116 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
117 ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
118 ,x_return_status OUT NOCOPY varchar2
119 ,x_msg_count OUT NOCOPY number
120 ,x_msg_data OUT NOCOPY varchar2
121 );
122
123 procedure Update_Kpi_Analysis(
124 p_commit IN varchar2 := FND_API.G_FALSE
125 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
126 ,x_return_status OUT NOCOPY varchar2
127 ,x_msg_count OUT NOCOPY number
128 ,x_msg_data OUT NOCOPY varchar2
129 );
130
131 procedure Delete_Kpi_Analysis(
132 p_commit IN varchar2 := FND_API.G_FALSE
133 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
134 ,x_return_status OUT NOCOPY varchar2
135 ,x_msg_count OUT NOCOPY number
136 ,x_msg_data OUT NOCOPY varchar2
137 );
138
139 procedure Delete_Objective_Color_Data(
140 p_commit IN varchar2 := FND_API.G_FALSE
141 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
142 ,x_return_status OUT NOCOPY varchar2
143 ,x_msg_count OUT NOCOPY number
144 ,x_msg_data OUT NOCOPY varchar2
145 );
146
147 procedure Create_Kpi_Periodicity(
148 p_commit IN varchar2 := FND_API.G_FALSE
149 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
150 ,x_return_status OUT NOCOPY varchar2
151 ,x_msg_count OUT NOCOPY number
152 ,x_msg_data OUT NOCOPY varchar2
153 );
154
155 procedure Retrieve_Kpi_Periodicity(
156 p_commit IN varchar2 := FND_API.G_FALSE
157 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
158 ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
159 ,x_return_status OUT NOCOPY varchar2
160 ,x_msg_count OUT NOCOPY number
161 ,x_msg_data OUT NOCOPY varchar2
162 );
163
164 procedure Update_Kpi_Periodicity(
165 p_commit IN varchar2 := FND_API.G_FALSE
166 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
167 ,x_return_status OUT NOCOPY varchar2
168 ,x_msg_count OUT NOCOPY number
169 ,x_msg_data OUT NOCOPY varchar2
170 );
171
172 procedure Delete_Kpi_Periodicity(
173 p_commit IN varchar2 := FND_API.G_FALSE
174 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
175 ,x_return_status OUT NOCOPY varchar2
176 ,x_msg_count OUT NOCOPY number
177 ,x_msg_data OUT NOCOPY varchar2
178 );
179
180 procedure Create_Kpi_Data_Tables(
181 p_commit IN varchar2 := FND_API.G_FALSE
182 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
183 ,x_return_status OUT NOCOPY varchar2
184 ,x_msg_count OUT NOCOPY number
185 ,x_msg_data OUT NOCOPY varchar2
186 );
187
188 procedure Retrieve_Kpi_Data_Tables(
189 p_commit IN varchar2 := FND_API.G_FALSE
190 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
191 ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
192 ,x_return_status OUT NOCOPY varchar2
193 ,x_msg_count OUT NOCOPY number
194 ,x_msg_data OUT NOCOPY varchar2
195 );
196
197 procedure Update_Kpi_Data_Tables(
198 p_commit IN varchar2 := FND_API.G_FALSE
199 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
200 ,x_return_status OUT NOCOPY varchar2
201 ,x_msg_count OUT NOCOPY number
202 ,x_msg_data OUT NOCOPY varchar2
203 );
204
205 procedure Delete_Kpi_Data_Tables(
206 p_commit IN varchar2 := FND_API.G_FALSE
207 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
208 ,x_return_status OUT NOCOPY varchar2
209 ,x_msg_count OUT NOCOPY number
210 ,x_msg_data OUT NOCOPY varchar2
211 );
212
213 procedure Create_Kpi_Calculations(
214 p_commit IN varchar2 := FND_API.G_FALSE
215 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
216 ,x_return_status OUT NOCOPY varchar2
217 ,x_msg_count OUT NOCOPY number
218 ,x_msg_data OUT NOCOPY varchar2
219 );
220
221 procedure Retrieve_Kpi_Calculations(
222 p_commit IN varchar2 := FND_API.G_FALSE
223 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
224 ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
225 ,x_return_status OUT NOCOPY varchar2
226 ,x_msg_count OUT NOCOPY number
227 ,x_msg_data OUT NOCOPY varchar2
228 );
229
230 procedure Update_Kpi_Calculations(
231 p_commit IN varchar2 := FND_API.G_FALSE
232 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
233 ,x_return_status OUT NOCOPY varchar2
234 ,x_msg_count OUT NOCOPY number
235 ,x_msg_data OUT NOCOPY varchar2
236 );
237
238 procedure Delete_Kpi_Calculations(
239 p_commit IN varchar2 := FND_API.G_FALSE
240 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
241 ,x_return_status OUT NOCOPY varchar2
242 ,x_msg_count OUT NOCOPY number
243 ,x_msg_data OUT NOCOPY varchar2
244 );
245
246 procedure Create_Kpi_User_Access(
247 p_commit IN varchar2 := FND_API.G_FALSE
248 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
249 ,x_return_status OUT NOCOPY varchar2
250 ,x_msg_count OUT NOCOPY number
251 ,x_msg_data OUT NOCOPY varchar2
252 );
253
254 procedure Retrieve_Kpi_User_Access(
255 p_commit IN varchar2 := FND_API.G_FALSE
256 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
257 ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
258 ,x_return_status OUT NOCOPY varchar2
259 ,x_msg_count OUT NOCOPY number
260 ,x_msg_data OUT NOCOPY varchar2
261 );
262
263 procedure Update_Kpi_User_Access(
264 p_commit IN varchar2 := FND_API.G_FALSE
265 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
266 ,x_return_status OUT NOCOPY varchar2
267 ,x_msg_count OUT NOCOPY number
268 ,x_msg_data OUT NOCOPY varchar2
269 );
270
271 procedure Delete_Kpi_User_Access(
272 p_commit IN varchar2 := FND_API.G_FALSE
273 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
274 ,x_return_status OUT NOCOPY varchar2
275 ,x_msg_count OUT NOCOPY number
276 ,x_msg_data OUT NOCOPY varchar2
277 );
278
279 procedure Create_Kpi_Default_Values(
280 p_commit IN varchar2 := FND_API.G_FALSE
281 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
282 ,x_return_status OUT NOCOPY varchar2
283 ,x_msg_count OUT NOCOPY number
284 ,x_msg_data OUT NOCOPY varchar2
285 );
286
287 procedure Retrieve_Kpi_Default_Values(
288 p_commit IN varchar2 := FND_API.G_FALSE
289 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
290 ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
291 ,x_return_status OUT NOCOPY varchar2
292 ,x_msg_count OUT NOCOPY number
293 ,x_msg_data OUT NOCOPY varchar2
294 );
295
296 procedure Update_Kpi_Default_Values(
297 p_commit IN varchar2 := FND_API.G_FALSE
298 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
299 ,x_return_status OUT NOCOPY varchar2
300 ,x_msg_count OUT NOCOPY number
301 ,x_msg_data OUT NOCOPY varchar2
302 );
303
304 procedure Delete_Kpi_Default_Values(
305 p_commit IN varchar2 := FND_API.G_FALSE
306 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
307 ,x_return_status OUT NOCOPY varchar2
308 ,x_msg_count OUT NOCOPY number
309 ,x_msg_data OUT NOCOPY varchar2
310 );
311
312 procedure Create_Kpi_In_Tab(
313 p_commit IN varchar2 := FND_API.G_FALSE
314 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
315 ,x_return_status OUT NOCOPY varchar2
316 ,x_msg_count OUT NOCOPY number
317 ,x_msg_data OUT NOCOPY varchar2
318 );
319
320 procedure Retrieve_Kpi_In_Tab(
321 p_commit IN varchar2 := FND_API.G_FALSE
322 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
323 ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
324 ,x_return_status OUT NOCOPY varchar2
325 ,x_msg_count OUT NOCOPY number
326 ,x_msg_data OUT NOCOPY varchar2
327 );
328
329 procedure Update_Kpi_In_Tab(
330 p_commit IN varchar2 := FND_API.G_FALSE
331 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
332 ,x_return_status OUT NOCOPY varchar2
333 ,x_msg_count OUT NOCOPY number
334 ,x_msg_data OUT NOCOPY varchar2
335 );
336
337 procedure Delete_Kpi_In_Tab(
338 p_commit IN varchar2 := FND_API.G_FALSE
342 ,x_msg_data OUT NOCOPY varchar2
339 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
340 ,x_return_status OUT NOCOPY varchar2
341 ,x_msg_count OUT NOCOPY number
343 );
344
345 procedure Update_Kpi_Time_Stamp(
346 p_commit IN varchar2 := FND_API.G_FALSE
347 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
348 ,x_return_status OUT NOCOPY varchar2
349 ,x_msg_count OUT NOCOPY number
350 ,x_msg_data OUT NOCOPY varchar2
351 );
352
353 procedure Create_Shared_Kpi(
354 p_commit IN varchar2 := FND_API.G_FALSE
355 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
356 ,x_return_status OUT NOCOPY varchar2
357 ,x_msg_count OUT NOCOPY number
358 ,x_msg_data OUT NOCOPY varchar2
359 );
360
361 procedure Create_Master_Kpi(
362 p_commit IN varchar2 := FND_API.G_FALSE
363 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
364 ,x_return_status OUT NOCOPY varchar2
365 ,x_msg_count OUT NOCOPY number
366 ,x_msg_data OUT NOCOPY varchar2
367 );
368
369 procedure Move_Tab(
370 p_tab_id number
371 ,p_tab_index number
372 ,x_return_status OUT NOCOPY varchar2
373 ,x_msg_count OUT NOCOPY number
374 ,x_msg_data OUT NOCOPY varchar2
375 );
376
377 procedure Set_Default_Option(
378 p_commit IN varchar2 := FND_API.G_FALSE
379 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
380 ,x_return_status OUT NOCOPY varchar2
381 ,x_msg_count OUT NOCOPY number
382 ,x_msg_data OUT NOCOPY varchar2
383 );
384
385 procedure Set_Default_Option_MG(
386 p_commit IN varchar2 := FND_API.G_FALSE
387 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
388 ,x_return_status OUT NOCOPY varchar2
389 ,x_msg_count OUT NOCOPY number
390 ,x_msg_data OUT NOCOPY varchar2
391 );
392
393 PROCEDURE Set_Default_Value_By_Option_ID
394 ( p_Kpi_Id NUMBER
395 , p_group_Id NUMBER
396 , p_parent_option_Id NUMBER
397 , p_grand_parent_option_Id NUMBER
398 , p_option_Id NUMBER
399 );
400
401 function Validate_Kpi(
402 p_Kpi_Name IN varchar2
403 ) return number;
404
405
406 procedure Assign_Analysis_Option(
407 p_Bsc_kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_kpi_Entity_Rec
408 ,x_return_status OUT NOCOPY varchar2
409 ,x_msg_count OUT NOCOPY number
410 ,x_msg_data OUT NOCOPY varchar2
411 );
412
413 procedure Unassign_Analysis_Option(
414 p_Bsc_kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_kpi_Entity_Rec
415 ,x_return_status OUT NOCOPY varchar2
416 ,x_msg_count OUT NOCOPY number
417 ,x_msg_data OUT NOCOPY varchar2
418 );
419
420 function Is_Analysis_Option_Selected(
421 p_Bsc_kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_kpi_Entity_Rec
422 ,x_return_status OUT NOCOPY varchar2
423 ,x_msg_count OUT NOCOPY number
424 ,x_msg_data OUT NOCOPY varchar2
425 ) return varchar2;
426
427 function Is_Leaf_Analysis_Option(
428 p_Bsc_kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_kpi_Entity_Rec
429 ,x_return_status OUT NOCOPY varchar2
430 ,x_msg_count OUT NOCOPY number
431 ,x_msg_data OUT NOCOPY varchar2
432 ) return varchar2;
433
434 /******************************************************************
435 DELETE APIS FOR OBJECTIVES
436 /*****************************************************************/
437
438 PROCEDURE Delete_Ind_User_Access
439 (
440 p_commit IN VARCHAR2 := FND_API.G_FALSE
441 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC
442 ,x_return_status OUT NOCOPY VARCHAR2
443 ,x_msg_count OUT NOCOPY NUMBER
444 ,x_msg_data OUT NOCOPY VARCHAR2
445 );
446
447
448 PROCEDURE Delete_Ind_Tree_Nodes
449 (
450 p_commit IN VARCHAR2 := FND_API.G_FALSE
451 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC
452 ,x_return_status OUT NOCOPY VARCHAR2
453 ,x_msg_count OUT NOCOPY NUMBER
454 ,x_msg_data OUT NOCOPY VARCHAR2
455 );
456
457 PROCEDURE Delete_Ind_Comments
458 (
459 p_commit IN VARCHAR2 := FND_API.G_FALSE
460 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC
461 ,x_return_status OUT NOCOPY VARCHAR2
462 ,x_msg_count OUT NOCOPY NUMBER
463 ,x_msg_data OUT NOCOPY VARCHAR2
464 );
465
466 PROCEDURE Delete_Ind_Sys_Prop
467 (
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 Delete_Ind_Images
476 (
477 p_commit IN VARCHAR2 := FND_API.G_FALSE
478 ,p_Bsc_Kpi_Entity_Rec IN 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 Delete_Ind_SeriesColors
485 (
486 p_commit IN VARCHAR2 := FND_API.G_FALSE
487 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC
488 ,x_return_status OUT NOCOPY VARCHAR2
489 ,x_msg_count OUT NOCOPY NUMBER
490 ,x_msg_data OUT NOCOPY VARCHAR2
491 );
492
493 PROCEDURE Delete_Ind_Subtitles
494 (
498 ,x_msg_count OUT NOCOPY NUMBER
499 ,x_msg_data OUT NOCOPY VARCHAR2
500 );
501
502 PROCEDURE Delete_Ind_MM_Controls
503 (
504 p_commit IN VARCHAR2 := FND_API.G_FALSE
505 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC
506 ,x_return_status OUT NOCOPY VARCHAR2
507 ,x_msg_count OUT NOCOPY NUMBER
508 ,x_msg_data OUT NOCOPY VARCHAR2
509 );
510
511 PROCEDURE Delete_Ind_Shell_Cmds
512 (
513 p_commit IN VARCHAR2 := FND_API.G_FALSE
514 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC
515 ,x_return_status OUT NOCOPY VARCHAR2
516 ,x_msg_count OUT NOCOPY NUMBER
517 ,x_msg_data OUT NOCOPY VARCHAR2
518 );
519
520 PROCEDURE Delete_Ind_Cause_Effect_Rels(
521 p_commit IN VARCHAR2 := FND_API.G_FALSE
522 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC
523 ,x_return_status OUT NOCOPY VARCHAR2
524 ,x_msg_count OUT NOCOPY NUMBER
525 ,x_msg_data OUT NOCOPY VARCHAR2
526 );
527
528 PROCEDURE Delete_Sim_Tree_Data
529 (
530 p_commit IN VARCHAR2 := FND_API.G_FALSE
531 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC
532 ,x_return_status OUT NOCOPY VARCHAR2
533 ,x_msg_count OUT NOCOPY NUMBER
534 ,x_msg_data OUT NOCOPY VARCHAR2
535 );
536
537 END BSC_KPI_PVT;
497 ,x_return_status OUT NOCOPY VARCHAR2
495 p_commit IN VARCHAR2 := FND_API.G_FALSE
496 ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC