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
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
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
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
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
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
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
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
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
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
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
313: ,x_return_status OUT NOCOPY varchar2
314: ,x_msg_count OUT NOCOPY number
315: ,x_msg_data OUT NOCOPY varchar2
315: ,x_msg_data OUT NOCOPY varchar2
316: );
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
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
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
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
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
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
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
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
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
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
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
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
437: ,x_return_status OUT NOCOPY VARCHAR2
438: ,x_msg_count OUT NOCOPY NUMBER
439: ,x_msg_data OUT NOCOPY VARCHAR2
440: );
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
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
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
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
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
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
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
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
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
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
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
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
562: ,x_msg_data OUT NOCOPY varchar2
563: );
564:
565: procedure Set_Default_Option_MG(
566: p_commit IN varchar2 := FND_API.G_FALSE
567: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
568: ,x_return_status OUT NOCOPY varchar2
569: ,x_msg_count OUT NOCOPY number
570: ,x_msg_data OUT NOCOPY varchar2
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
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: (
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
668: ,x_msg_count OUT NOCOPY NUMBER
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
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
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
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
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
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