APPS.BSC_KPI_PUB dependencies on BSC_KPI_PVT

Line 144: BSC_KPI_PVT.Create_Kpi(

140: END IF;
141:
142:
143: -- Call private version of procedure.
144: BSC_KPI_PVT.Create_Kpi(
145: p_commit => FND_API.G_FALSE
146: , p_Bsc_Kpi_Entity_Rec => l_Bsc_Kpi_Entity_Rec
147: , x_return_status => x_return_status
148: , x_msg_count => x_msg_count

Line 362: BSC_KPI_PVT.Retrieve_Kpi( p_commit

358:
359: begin
360: FND_MSG_PUB.Initialize;
361: x_return_status := FND_API.G_RET_STS_SUCCESS;
362: BSC_KPI_PVT.Retrieve_Kpi( p_commit
363: ,p_Bsc_Kpi_Entity_Rec
364: ,x_Bsc_Kpi_Entity_Rec
365: ,x_return_status
366: ,x_msg_count

Line 449: BSC_KPI_PVT.Update_Kpi( p_commit

445: begin
446: FND_MSG_PUB.Initialize;
447: x_return_status := FND_API.G_RET_STS_SUCCESS;
448:
449: BSC_KPI_PVT.Update_Kpi( p_commit
450: ,p_Bsc_Kpi_Entity_Rec
451: ,x_return_status
452: ,x_msg_count
453: ,x_msg_data);

Line 484: BSC_KPI_PVT.Update_Kpi(

480:
481: FOR SrcInd IN c_Select_Indicator LOOP
482: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id := SrcInd.INDICATOR;
483:
484: BSC_KPI_PVT.Update_Kpi(
485: p_commit
486: , l_Bsc_Kpi_Entity_Rec
487: , x_return_status
488: , x_msg_count

Line 756: BSC_KPI_PVT.Delete_Kpi( p_commit

752:
753:
754: END IF;
755:
756: BSC_KPI_PVT.Delete_Kpi( p_commit
757: ,l_Bsc_Kpi_Entity_Rec
758: ,x_return_status
759: ,x_msg_count
760: ,x_msg_data);

Line 831: BSC_KPI_PVT.Delete_Kpi( p_commit

827: END IF;
828:
829:
830:
831: BSC_KPI_PVT.Delete_Kpi( p_commit
832: , l_Bsc_Kpi_Entity_Rec
833: , x_return_status
834: , x_msg_count
835: , x_msg_data);

Line 916: BSC_KPI_PVT.Create_Kpi_Defaults( p_commit

912: -- l_Bsc_Dim_Rec.Bsc_Dim_Set_Id := 0;
913: -- l_Bsc_Dim_Rec.Language := p_Bsc_Kpi_Entity_Rec.Bsc_Language;
914: -- l_Bsc_Dim_Rec.Source_Language := p_Bsc_Kpi_Entity_Rec.Bsc_Source_Language;
915:
916: BSC_KPI_PVT.Create_Kpi_Defaults( p_commit
917: ,l_Bsc_Kpi_Entity_Rec
918: ,x_return_status
919: ,x_msg_count
920: ,x_msg_data);

Line 1058: BSC_KPI_PVT.Retrieve_Kpi_Defaults( p_commit

1054:
1055: begin
1056: FND_MSG_PUB.Initialize;
1057: x_return_status := FND_API.G_RET_STS_SUCCESS;
1058: BSC_KPI_PVT.Retrieve_Kpi_Defaults( p_commit
1059: ,p_Bsc_Kpi_Entity_Rec
1060: ,x_Bsc_Kpi_Entity_Rec
1061: ,x_return_status
1062: ,x_msg_count

Line 1180: BSC_KPI_PVT.Create_Kpi_Properties( p_commit

1176: ,x_msg_count
1177: ,x_msg_data);
1178: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1179: -- if updation fails, create it
1180: BSC_KPI_PVT.Create_Kpi_Properties( p_commit
1181: ,p_Bsc_Kpi_Entity_Rec
1182: ,x_return_status
1183: ,x_msg_count
1184: ,x_msg_data);

Line 1395: BSC_KPI_PVT.Delete_Objective_Color_Data( p_commit

1391:
1392: begin
1393: FND_MSG_PUB.Initialize;
1394: x_return_status := FND_API.G_RET_STS_SUCCESS;
1395: BSC_KPI_PVT.Delete_Objective_Color_Data( p_commit
1396: ,p_Bsc_Kpi_Entity_Rec
1397: ,x_return_status
1398: ,x_msg_count
1399: ,x_msg_data);

Line 1663: BSC_KPI_PVT.Create_Kpi_Properties( p_commit

1659: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Code := 'LOCK_INDICATOR';
1660: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Value := 0;
1661: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Secondary_Value := '';
1662:
1663: BSC_KPI_PVT.Create_Kpi_Properties( p_commit
1664: ,l_Bsc_Kpi_Entity_Rec
1665: ,x_return_status
1666: ,x_msg_count
1667: ,x_msg_data);

Line 1673: BSC_KPI_PVT.Create_Kpi_Properties( p_commit

1669: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Code := BSC_KPI_PUB.Benchmark_Kpi_Property;
1670: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Value := BSC_KPI_PUB.Benchmark_Kpi_Line_Graph;
1671: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Secondary_Value := '';
1672:
1673: BSC_KPI_PVT.Create_Kpi_Properties( p_commit
1674: ,l_Bsc_Kpi_Entity_Rec
1675: ,x_return_status
1676: ,x_msg_count
1677: ,x_msg_data);

Line 1694: BSC_KPI_PVT.Create_Kpi_Properties( p_commit

1690: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Code := BSC_SIMULATION_VIEW_PUB.c_SIM_NODE_ID;
1691: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Value := BSC_SIMULATION_VIEW_PUB.c_DEFAULT_DATASET_ID;
1692: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Secondary_Value := '';
1693:
1694: BSC_KPI_PVT.Create_Kpi_Properties( p_commit
1695: ,l_Bsc_Kpi_Entity_Rec
1696: ,x_return_status
1697: ,x_msg_count
1698: ,x_msg_data);

Line 1758: BSC_KPI_PVT.Retrieve_Kpi_Properties( p_commit

1754:
1755: begin
1756: FND_MSG_PUB.Initialize;
1757: x_return_status := FND_API.G_RET_STS_SUCCESS;
1758: BSC_KPI_PVT.Retrieve_Kpi_Properties( p_commit
1759: ,p_Bsc_Kpi_Entity_Rec
1760: ,x_Bsc_Kpi_Entity_Rec
1761: ,x_return_status
1762: ,x_msg_count

Line 1818: BSC_KPI_PVT.Update_Kpi_Properties( p_commit

1814:
1815: begin
1816: FND_MSG_PUB.Initialize;
1817: x_return_status := FND_API.G_RET_STS_SUCCESS;
1818: BSC_KPI_PVT.Update_Kpi_Properties( p_commit
1819: ,p_Bsc_Kpi_Entity_Rec
1820: ,x_return_status
1821: ,x_msg_count
1822: ,x_msg_data);

Line 1879: BSC_KPI_PVT.Delete_Kpi_Properties( p_commit

1875:
1876: begin
1877: FND_MSG_PUB.Initialize;
1878: x_return_status := FND_API.G_RET_STS_SUCCESS;
1879: BSC_KPI_PVT.Delete_Kpi_Properties( p_commit
1880: ,p_Bsc_Kpi_Entity_Rec
1881: ,x_return_status
1882: ,x_msg_count
1883: ,x_msg_data);

Line 1940: BSC_KPI_PVT.Create_Kpi_Analysis( p_commit

1936: begin
1937: FND_MSG_PUB.Initialize;
1938: x_return_status := FND_API.G_RET_STS_SUCCESS;
1939: -- Call private version of procedure.
1940: BSC_KPI_PVT.Create_Kpi_Analysis( p_commit
1941: ,p_Bsc_Kpi_Entity_Rec
1942: ,x_return_status
1943: ,x_msg_count
1944: ,x_msg_data);

Line 2000: BSC_KPI_PVT.Retrieve_Kpi_Analysis( p_commit

1996:
1997: begin
1998: FND_MSG_PUB.Initialize;
1999: x_return_status := FND_API.G_RET_STS_SUCCESS;
2000: BSC_KPI_PVT.Retrieve_Kpi_Analysis( p_commit
2001: ,p_Bsc_Kpi_Entity_Rec
2002: ,x_Bsc_Kpi_Entity_Rec
2003: ,x_return_status
2004: ,x_msg_count

Line 2060: BSC_KPI_PVT.Update_Kpi_Analysis( p_commit

2056:
2057: begin
2058: FND_MSG_PUB.Initialize;
2059: x_return_status := FND_API.G_RET_STS_SUCCESS;
2060: BSC_KPI_PVT.Update_Kpi_Analysis( p_commit
2061: ,p_Bsc_Kpi_Entity_Rec
2062: ,x_return_status
2063: ,x_msg_count
2064: ,x_msg_data);

Line 2134: BSC_KPI_PVT.Delete_Kpi_Analysis( p_commit

2130: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2132: END IF;
2133:
2134: BSC_KPI_PVT.Delete_Kpi_Analysis( p_commit
2135: ,p_Bsc_Kpi_Entity_Rec
2136: ,x_return_status
2137: ,x_msg_count
2138: ,x_msg_data);

Line 2194: BSC_KPI_PVT.Create_Kpi_Periodicity( p_commit

2190:
2191: begin
2192: FND_MSG_PUB.Initialize;
2193: x_return_status := FND_API.G_RET_STS_SUCCESS;
2194: BSC_KPI_PVT.Create_Kpi_Periodicity( p_commit
2195: ,p_Bsc_Kpi_Entity_Rec
2196: ,x_return_status
2197: ,x_msg_count
2198: ,x_msg_data);

Line 2254: BSC_KPI_PVT.Retrieve_Kpi_Periodicity( p_commit

2250:
2251: begin
2252: FND_MSG_PUB.Initialize;
2253: x_return_status := FND_API.G_RET_STS_SUCCESS;
2254: BSC_KPI_PVT.Retrieve_Kpi_Periodicity( p_commit
2255: ,p_Bsc_Kpi_Entity_Rec
2256: ,x_Bsc_Kpi_Entity_Rec
2257: ,x_return_status
2258: ,x_msg_count

Line 2314: BSC_KPI_PVT.Update_Kpi_Periodicity( p_commit

2310:
2311: begin
2312: FND_MSG_PUB.Initialize;
2313: x_return_status := FND_API.G_RET_STS_SUCCESS;
2314: BSC_KPI_PVT.Update_Kpi_Periodicity( p_commit
2315: ,p_Bsc_Kpi_Entity_Rec
2316: ,x_return_status
2317: ,x_msg_count
2318: ,x_msg_data);

Line 2373: BSC_KPI_PVT.Delete_Kpi_Periodicity( p_commit

2369:
2370: begin
2371: FND_MSG_PUB.Initialize;
2372: x_return_status := FND_API.G_RET_STS_SUCCESS;
2373: BSC_KPI_PVT.Delete_Kpi_Periodicity( p_commit
2374: ,p_Bsc_Kpi_Entity_Rec
2375: ,x_return_status
2376: ,x_msg_count
2377: ,x_msg_data);

Line 2432: BSC_KPI_PVT.Create_Kpi_Data_Tables( p_commit

2428:
2429: begin
2430: FND_MSG_PUB.Initialize;
2431: x_return_status := FND_API.G_RET_STS_SUCCESS;
2432: BSC_KPI_PVT.Create_Kpi_Data_Tables( p_commit
2433: ,p_Bsc_Kpi_Entity_Rec
2434: ,x_return_status
2435: ,x_msg_count
2436: ,x_msg_data);

Line 2492: BSC_KPI_PVT.Retrieve_Kpi_Data_Tables( p_commit

2488:
2489: begin
2490: FND_MSG_PUB.Initialize;
2491: x_return_status := FND_API.G_RET_STS_SUCCESS;
2492: BSC_KPI_PVT.Retrieve_Kpi_Data_Tables( p_commit
2493: ,p_Bsc_Kpi_Entity_Rec
2494: ,x_Bsc_Kpi_Entity_Rec
2495: ,x_return_status
2496: ,x_msg_count

Line 2552: BSC_KPI_PVT.Update_Kpi_Data_Tables( p_commit

2548:
2549: begin
2550: FND_MSG_PUB.Initialize;
2551: x_return_status := FND_API.G_RET_STS_SUCCESS;
2552: BSC_KPI_PVT.Update_Kpi_Data_Tables( p_commit
2553: ,p_Bsc_Kpi_Entity_Rec
2554: ,x_return_status
2555: ,x_msg_count
2556: ,x_msg_data);

Line 2611: BSC_KPI_PVT.Delete_Kpi_Data_Tables( p_commit

2607:
2608: begin
2609: FND_MSG_PUB.Initialize;
2610: x_return_status := FND_API.G_RET_STS_SUCCESS;
2611: BSC_KPI_PVT.Delete_Kpi_Data_Tables( p_commit
2612: ,p_Bsc_Kpi_Entity_Rec
2613: ,x_return_status
2614: ,x_msg_count
2615: ,x_msg_data);

Line 2682: BSC_KPI_PVT.Create_Kpi_Calculations( p_commit

2678: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level0 := 2;
2679: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level1 := 2;
2680: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value := 0;
2681:
2682: BSC_KPI_PVT.Create_Kpi_Calculations( p_commit
2683: ,l_Bsc_Kpi_Entity_Rec
2684: ,x_return_status
2685: ,x_msg_count
2686: ,x_msg_data);

Line 2693: BSC_KPI_PVT.Create_Kpi_Calculations( p_commit

2689: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level0 := 2;
2690: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level1 := 2;
2691: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value := 0;
2692:
2693: BSC_KPI_PVT.Create_Kpi_Calculations( p_commit
2694: ,l_Bsc_Kpi_Entity_Rec
2695: ,x_return_status
2696: ,x_msg_count
2697: ,x_msg_data);

Line 2704: BSC_KPI_PVT.Create_Kpi_Calculations( p_commit

2700: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level0 := 2;
2701: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level1 := 2;
2702: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value := 0;
2703:
2704: BSC_KPI_PVT.Create_Kpi_Calculations( p_commit
2705: ,l_Bsc_Kpi_Entity_Rec
2706: ,x_return_status
2707: ,x_msg_count
2708: ,x_msg_data);

Line 2715: BSC_KPI_PVT.Create_Kpi_Calculations( p_commit

2711: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level0 := 0;
2712: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level1 := 0;
2713: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value := 0;
2714:
2715: BSC_KPI_PVT.Create_Kpi_Calculations( p_commit
2716: ,l_Bsc_Kpi_Entity_Rec
2717: ,x_return_status
2718: ,x_msg_count
2719: ,x_msg_data);

Line 2726: BSC_KPI_PVT.Create_Kpi_Calculations( p_commit

2722: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level0 := 0;
2723: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level1 := 0;
2724: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value := 0;
2725:
2726: BSC_KPI_PVT.Create_Kpi_Calculations( p_commit
2727: ,l_Bsc_Kpi_Entity_Rec
2728: ,x_return_status
2729: ,x_msg_count
2730: ,x_msg_data);

Line 2737: BSC_KPI_PVT.Create_Kpi_Calculations( p_commit

2733: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level0 := 2;
2734: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level1 := 2;
2735: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value := 0;
2736:
2737: BSC_KPI_PVT.Create_Kpi_Calculations( p_commit
2738: ,l_Bsc_Kpi_Entity_Rec
2739: ,x_return_status
2740: ,x_msg_count
2741: ,x_msg_data);

Line 2748: BSC_KPI_PVT.Create_Kpi_Calculations( p_commit

2744: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level0 := 0;
2745: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level1 := 0;
2746: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value := 0;
2747:
2748: BSC_KPI_PVT.Create_Kpi_Calculations( p_commit
2749: ,l_Bsc_Kpi_Entity_Rec
2750: ,x_return_status
2751: ,x_msg_count
2752: ,x_msg_data);

Line 2759: BSC_KPI_PVT.Create_Kpi_Calculations( p_commit

2755: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level0 := 0;
2756: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level1 := 0;
2757: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value := 0;
2758:
2759: BSC_KPI_PVT.Create_Kpi_Calculations( p_commit
2760: ,l_Bsc_Kpi_Entity_Rec
2761: ,x_return_status
2762: ,x_msg_count
2763: ,x_msg_data);

Line 2770: BSC_KPI_PVT.Create_Kpi_Calculations( p_commit

2766: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level0 := 0;
2767: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level1 := 0;
2768: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value := 0;
2769:
2770: BSC_KPI_PVT.Create_Kpi_Calculations( p_commit
2771: ,l_Bsc_Kpi_Entity_Rec
2772: ,x_return_status
2773: ,x_msg_count
2774: ,x_msg_data);

Line 2781: BSC_KPI_PVT.Create_Kpi_Calculations( p_commit

2777: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level0 := 0;
2778: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level1 := 0;
2779: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value := 0;
2780:
2781: BSC_KPI_PVT.Create_Kpi_Calculations( p_commit
2782: ,l_Bsc_Kpi_Entity_Rec
2783: ,x_return_status
2784: ,x_msg_count
2785: ,x_msg_data);

Line 2792: BSC_KPI_PVT.Create_Kpi_Calculations( p_commit

2788: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level0 := 0;
2789: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level1 := 0;
2790: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value := 0;
2791:
2792: BSC_KPI_PVT.Create_Kpi_Calculations( p_commit
2793: ,l_Bsc_Kpi_Entity_Rec
2794: ,x_return_status
2795: ,x_msg_count
2796: ,x_msg_data);

Line 2803: BSC_KPI_PVT.Create_Kpi_Calculations( p_commit

2799: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level0 := 0;
2800: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level1 := 0;
2801: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value := 0;
2802:
2803: BSC_KPI_PVT.Create_Kpi_Calculations( p_commit
2804: ,l_Bsc_Kpi_Entity_Rec
2805: ,x_return_status
2806: ,x_msg_count
2807: ,x_msg_data);

Line 2816: BSC_KPI_PVT.Create_Kpi_Calculations( p_commit

2812: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level0 := 0;
2813: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level1 := 0;
2814: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value := 0;
2815:
2816: BSC_KPI_PVT.Create_Kpi_Calculations( p_commit
2817: ,l_Bsc_Kpi_Entity_Rec
2818: ,x_return_status
2819: ,x_msg_count
2820: ,x_msg_data);

Line 2828: BSC_KPI_PVT.Create_Kpi_Calculations( p_commit

2824: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level0 := 0;
2825: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level1 := 0;
2826: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value := 0;
2827:
2828: BSC_KPI_PVT.Create_Kpi_Calculations( p_commit
2829: ,l_Bsc_Kpi_Entity_Rec
2830: ,x_return_status
2831: ,x_msg_count
2832: ,x_msg_data);

Line 2888: BSC_KPI_PVT.Retrieve_Kpi_Calculations( p_commit

2884:
2885: begin
2886: FND_MSG_PUB.Initialize;
2887: x_return_status := FND_API.G_RET_STS_SUCCESS;
2888: BSC_KPI_PVT.Retrieve_Kpi_Calculations( p_commit
2889: ,p_Bsc_Kpi_Entity_Rec
2890: ,x_Bsc_Kpi_Entity_Rec
2891: ,x_return_status
2892: ,x_msg_count

Line 2961: BSC_KPI_PVT.Update_Kpi_Calculations( p_commit

2957: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level0 := 2;
2958: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level1 := 2;
2959: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value := 0;
2960:
2961: BSC_KPI_PVT.Update_Kpi_Calculations( p_commit
2962: ,l_Bsc_Kpi_Entity_Rec
2963: ,x_return_status
2964: ,x_msg_count
2965: ,x_msg_data);

Line 2971: BSC_KPI_PVT.Update_Kpi_Calculations( p_commit

2967: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Calculation_Id := 1;
2968: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level0 := 2;
2969: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level1 := 2;
2970: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value := 0;
2971: BSC_KPI_PVT.Update_Kpi_Calculations( p_commit
2972: ,l_Bsc_Kpi_Entity_Rec
2973: ,x_return_status
2974: ,x_msg_count
2975: ,x_msg_data);

Line 2983: BSC_KPI_PVT.Update_Kpi_Calculations( p_commit

2979: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level0 := 2;
2980: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level1 := 2;
2981: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value := 0;
2982:
2983: BSC_KPI_PVT.Update_Kpi_Calculations( p_commit
2984: ,l_Bsc_Kpi_Entity_Rec
2985: ,x_return_status
2986: ,x_msg_count
2987: ,x_msg_data);

Line 2994: BSC_KPI_PVT.Update_Kpi_Calculations( p_commit

2990: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level0 := 0;
2991: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level1 := 0;
2992: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value := 0;
2993:
2994: BSC_KPI_PVT.Update_Kpi_Calculations( p_commit
2995: ,l_Bsc_Kpi_Entity_Rec
2996: ,x_return_status
2997: ,x_msg_count
2998: ,x_msg_data);

Line 3005: BSC_KPI_PVT.Update_Kpi_Calculations( p_commit

3001: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level0 := 0;
3002: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level1 := 0;
3003: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value := 0;
3004:
3005: BSC_KPI_PVT.Update_Kpi_Calculations( p_commit
3006: ,l_Bsc_Kpi_Entity_Rec
3007: ,x_return_status
3008: ,x_msg_count
3009: ,x_msg_data);

Line 3016: BSC_KPI_PVT.Update_Kpi_Calculations( p_commit

3012: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level0 := 2;
3013: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level1 := 2;
3014: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value := 0;
3015:
3016: BSC_KPI_PVT.Update_Kpi_Calculations( p_commit
3017: ,l_Bsc_Kpi_Entity_Rec
3018: ,x_return_status
3019: ,x_msg_count
3020: ,x_msg_data);

Line 3027: BSC_KPI_PVT.Update_Kpi_Calculations( p_commit

3023: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level0 := 0;
3024: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level1 := 0;
3025: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value := 0;
3026:
3027: BSC_KPI_PVT.Update_Kpi_Calculations( p_commit
3028: ,l_Bsc_Kpi_Entity_Rec
3029: ,x_return_status
3030: ,x_msg_count
3031: ,x_msg_data);

Line 3038: BSC_KPI_PVT.Update_Kpi_Calculations( p_commit

3034: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level0 := 0;
3035: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level1 := 0;
3036: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value := 0;
3037:
3038: BSC_KPI_PVT.Update_Kpi_Calculations( p_commit
3039: ,l_Bsc_Kpi_Entity_Rec
3040: ,x_return_status
3041: ,x_msg_count
3042: ,x_msg_data);

Line 3049: BSC_KPI_PVT.Update_Kpi_Calculations( p_commit

3045: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level0 := 0;
3046: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level1 := 0;
3047: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value := 0;
3048:
3049: BSC_KPI_PVT.Update_Kpi_Calculations( p_commit
3050: ,l_Bsc_Kpi_Entity_Rec
3051: ,x_return_status
3052: ,x_msg_count
3053: ,x_msg_data);

Line 3060: BSC_KPI_PVT.Update_Kpi_Calculations( p_commit

3056: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level0 := 0;
3057: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level1 := 0;
3058: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value := 0;
3059:
3060: BSC_KPI_PVT.Update_Kpi_Calculations( p_commit
3061: ,l_Bsc_Kpi_Entity_Rec
3062: ,x_return_status
3063: ,x_msg_count
3064: ,x_msg_data);

Line 3071: BSC_KPI_PVT.Update_Kpi_Calculations( p_commit

3067: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level0 := 0;
3068: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level1 := 0;
3069: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value := 0;
3070:
3071: BSC_KPI_PVT.Update_Kpi_Calculations( p_commit
3072: ,l_Bsc_Kpi_Entity_Rec
3073: ,x_return_status
3074: ,x_msg_count
3075: ,x_msg_data);

Line 3082: BSC_KPI_PVT.Update_Kpi_Calculations( p_commit

3078: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level0 := 0;
3079: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level1 := 0;
3080: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value := 0;
3081:
3082: BSC_KPI_PVT.Update_Kpi_Calculations( p_commit
3083: ,l_Bsc_Kpi_Entity_Rec
3084: ,x_return_status
3085: ,x_msg_count
3086: ,x_msg_data);

Line 3148: BSC_KPI_PVT.Delete_Kpi_Calculations( p_commit

3144:
3145: begin
3146: FND_MSG_PUB.Initialize;
3147: x_return_status := FND_API.G_RET_STS_SUCCESS;
3148: BSC_KPI_PVT.Delete_Kpi_Calculations( p_commit
3149: ,p_Bsc_Kpi_Entity_Rec
3150: ,x_return_status
3151: ,x_msg_count
3152: ,x_msg_data);

Line 3231: BSC_KPI_PVT.Create_Kpi_User_Access

3227:
3228: l_Bsc_Kpi_Entity_Rec.Bsc_Responsibility_Id := CD.responsibility_id;
3229:
3230: IF(l_Count = 0) THEN
3231: BSC_KPI_PVT.Create_Kpi_User_Access
3232: ( p_commit => p_commit
3233: , p_Bsc_Kpi_Entity_Rec => l_Bsc_Kpi_Entity_Rec
3234: , x_return_status => x_return_status
3235: , x_msg_count => x_msg_count

Line 3398: BSC_KPI_PVT.Retrieve_Kpi_User_Access( p_commit

3394:
3395: begin
3396: FND_MSG_PUB.Initialize;
3397: x_return_status := FND_API.G_RET_STS_SUCCESS;
3398: BSC_KPI_PVT.Retrieve_Kpi_User_Access( p_commit
3399: ,p_Bsc_Kpi_Entity_Rec
3400: ,x_Bsc_Kpi_Entity_Rec
3401: ,x_return_status
3402: ,x_msg_count

Line 3458: BSC_KPI_PVT.Update_Kpi_User_Access( p_commit

3454:
3455: begin
3456: FND_MSG_PUB.Initialize;
3457: x_return_status := FND_API.G_RET_STS_SUCCESS;
3458: BSC_KPI_PVT.Update_Kpi_User_Access( p_commit
3459: ,p_Bsc_Kpi_Entity_Rec
3460: ,x_return_status
3461: ,x_msg_count
3462: ,x_msg_data);

Line 3517: BSC_KPI_PVT.Delete_Kpi_User_Access( p_commit

3513:
3514: begin
3515: FND_MSG_PUB.Initialize;
3516: x_return_status := FND_API.G_RET_STS_SUCCESS;
3517: BSC_KPI_PVT.Delete_Kpi_User_Access( p_commit
3518: ,p_Bsc_Kpi_Entity_Rec
3519: ,x_return_status
3520: ,x_msg_count
3521: ,x_msg_data);

Line 3623: BSC_KPI_PVT.Create_Kpi_Default_Values( p_commit

3619: a.dataset_id = b.dataset_id and
3620: b.measure_id1 = c.measure_id;
3621:
3622:
3623: BSC_KPI_PVT.Create_Kpi_Default_Values( p_commit
3624: ,l_Bsc_Kpi_Entity_Rec
3625: ,x_return_status
3626: ,x_msg_count
3627: ,x_msg_data);

Line 3683: BSC_KPI_PVT.Retrieve_Kpi_Default_Values( p_commit

3679:
3680: begin
3681: FND_MSG_PUB.Initialize;
3682: x_return_status := FND_API.G_RET_STS_SUCCESS;
3683: BSC_KPI_PVT.Retrieve_Kpi_Default_Values( p_commit
3684: ,p_Bsc_Kpi_Entity_Rec
3685: ,x_Bsc_Kpi_Entity_Rec
3686: ,x_return_status
3687: ,x_msg_count

Line 3744: BSC_KPI_PVT.Update_Kpi_Default_Values( p_commit

3740:
3741: begin
3742: FND_MSG_PUB.Initialize;
3743: x_return_status := FND_API.G_RET_STS_SUCCESS;
3744: BSC_KPI_PVT.Update_Kpi_Default_Values( p_commit
3745: ,p_Bsc_Kpi_Entity_Rec
3746: ,x_return_status
3747: ,x_msg_count
3748: ,x_msg_data);

Line 3804: BSC_KPI_PVT.Delete_Kpi_Default_Values( p_commit

3800:
3801: begin
3802: FND_MSG_PUB.Initialize;
3803: x_return_status := FND_API.G_RET_STS_SUCCESS;
3804: BSC_KPI_PVT.Delete_Kpi_Default_Values( p_commit
3805: ,p_Bsc_Kpi_Entity_Rec
3806: ,x_return_status
3807: ,x_msg_count
3808: ,x_msg_data);

Line 3869: BSC_KPI_PVT.Create_Kpi_In_Tab( p_commit

3865:
3866: begin
3867: FND_MSG_PUB.Initialize;
3868: x_return_status := FND_API.G_RET_STS_SUCCESS;
3869: BSC_KPI_PVT.Create_Kpi_In_Tab( p_commit
3870: ,p_Bsc_Kpi_Entity_Rec
3871: ,x_return_status
3872: ,x_msg_count
3873: ,x_msg_data);

Line 3931: BSC_KPI_PVT.Retrieve_Kpi_In_Tab( p_commit

3927:
3928: begin
3929: FND_MSG_PUB.Initialize;
3930: x_return_status := FND_API.G_RET_STS_SUCCESS;
3931: BSC_KPI_PVT.Retrieve_Kpi_In_Tab( p_commit
3932: ,p_Bsc_Kpi_Entity_Rec
3933: ,x_Bsc_Kpi_Entity_Rec
3934: ,x_return_status
3935: ,x_msg_count

Line 4002: BSC_KPI_PVT.Update_Kpi_In_Tab( p_commit

3998: end if;
3999: */
4000: FND_MSG_PUB.Initialize;
4001: x_return_status := FND_API.G_RET_STS_SUCCESS;
4002: BSC_KPI_PVT.Update_Kpi_In_Tab( p_commit
4003: ,p_Bsc_Kpi_Entity_Rec
4004: ,x_return_status
4005: ,x_msg_count
4006: ,x_msg_data);

Line 4062: BSC_KPI_PVT.Delete_Kpi_In_Tab( p_commit

4058:
4059: begin
4060: FND_MSG_PUB.Initialize;
4061: x_return_status := FND_API.G_RET_STS_SUCCESS;
4062: BSC_KPI_PVT.Delete_Kpi_In_Tab( p_commit
4063: ,p_Bsc_Kpi_Entity_Rec
4064: ,x_return_status
4065: ,x_msg_count
4066: ,x_msg_data);

Line 4123: BSC_KPI_PVT.Update_Kpi_Time_Stamp( p_commit

4119:
4120: begin
4121: FND_MSG_PUB.Initialize;
4122: x_return_status := FND_API.G_RET_STS_SUCCESS;
4123: BSC_KPI_PVT.Update_Kpi_Time_Stamp( p_commit
4124: ,p_Bsc_Kpi_Entity_Rec
4125: ,x_return_status
4126: ,x_msg_count
4127: ,x_msg_data);

Line 4183: BSC_KPI_PVT.Create_Master_Kpi( p_commit

4179:
4180: begin
4181: FND_MSG_PUB.Initialize;
4182: x_return_status := FND_API.G_RET_STS_SUCCESS;
4183: BSC_KPI_PVT.Create_Master_Kpi( p_commit
4184: ,p_Bsc_Kpi_Entity_Rec
4185: ,x_return_status
4186: ,x_msg_count
4187: ,x_msg_data);

Line 4258: BSC_KPI_PVT.Create_Shared_Kpi( p_commit

4254: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Periodicity_Id := 5;
4255: end if;
4256:
4257:
4258: BSC_KPI_PVT.Create_Shared_Kpi( p_commit
4259: ,l_Bsc_Kpi_Entity_Rec
4260: ,x_return_status
4261: ,x_msg_count
4262: ,x_msg_data);

Line 4318: BSC_KPI_PVT.Set_Default_Option( p_commit

4314:
4315: begin
4316: FND_MSG_PUB.Initialize;
4317: x_return_status := FND_API.G_RET_STS_SUCCESS;
4318: BSC_KPI_PVT.Set_Default_Option( p_commit
4319: ,p_Bsc_Kpi_Entity_Rec
4320: ,x_return_status
4321: ,x_msg_count
4322: ,x_msg_data);

Line 4437: BSC_KPI_PVT.Assign_Analysis_Option(

4433:
4434: Begin
4435: FND_MSG_PUB.Initialize;
4436: x_return_status := FND_API.G_RET_STS_SUCCESS;
4437: BSC_KPI_PVT.Assign_Analysis_Option(
4438: p_Bsc_kpi_Entity_Rec
4439: ,x_return_status
4440: ,x_msg_count
4441: ,x_msg_data );

Line 4496: BSC_KPI_PVT.Unassign_Analysis_Option(

4492:
4493: Begin
4494: FND_MSG_PUB.Initialize;
4495: x_return_status := FND_API.G_RET_STS_SUCCESS;
4496: BSC_KPI_PVT.Unassign_Analysis_Option(
4497: p_Bsc_kpi_Entity_Rec
4498: ,x_return_status
4499: ,x_msg_count
4500: ,x_msg_data );

Line 4556: l_temp := BSC_KPI_PVT.Is_Analysis_Option_Selected(

4552: l_temp varchar2(5);
4553: Begin
4554: FND_MSG_PUB.Initialize;
4555: x_return_status := FND_API.G_RET_STS_SUCCESS;
4556: l_temp := BSC_KPI_PVT.Is_Analysis_Option_Selected(
4557: p_Bsc_kpi_Entity_Rec
4558: ,x_return_status
4559: ,x_msg_count
4560: ,x_msg_data );

Line 4618: l_temp := BSC_KPI_PVT.Is_Leaf_Analysis_Option(

4614: FND_MSG_PUB.Initialize;
4615: x_return_status := FND_API.G_RET_STS_SUCCESS;
4616: --DBMS_OUTPUT.PUT_LINE('Begin BSC_KPI_PUB.Is_Leaf_Analysis_Option ');
4617:
4618: l_temp := BSC_KPI_PVT.Is_Leaf_Analysis_Option(
4619: p_Bsc_kpi_Entity_Rec
4620: ,x_return_status
4621: ,x_msg_count
4622: ,x_msg_data );

Line 5036: BSC_KPI_PVT.Delete_Ind_Cause_Effect_Rels

5032: BEGIN
5033: FND_MSG_PUB.Initialize;
5034: x_return_status := FND_API.G_RET_STS_SUCCESS;
5035:
5036: BSC_KPI_PVT.Delete_Ind_Cause_Effect_Rels
5037: (
5038: p_commit => p_commit
5039: , p_Bsc_Kpi_Entity_Rec => p_Bsc_Kpi_Entity_Rec
5040: , x_return_status => x_return_status

Line 5104: BSC_KPI_PVT.Delete_Ind_Shell_Cmds

5100: BEGIN
5101: FND_MSG_PUB.Initialize;
5102: x_return_status := FND_API.G_RET_STS_SUCCESS;
5103:
5104: BSC_KPI_PVT.Delete_Ind_Shell_Cmds
5105: (
5106: p_commit => p_commit
5107: , p_Bsc_Kpi_Entity_Rec => p_Bsc_Kpi_Entity_Rec
5108: , x_return_status => x_return_status

Line 5172: BSC_KPI_PVT.Delete_Ind_MM_Controls

5168: BEGIN
5169: FND_MSG_PUB.Initialize;
5170: x_return_status := FND_API.G_RET_STS_SUCCESS;
5171:
5172: BSC_KPI_PVT.Delete_Ind_MM_Controls
5173: (
5174: p_commit => p_commit
5175: , p_Bsc_Kpi_Entity_Rec => p_Bsc_Kpi_Entity_Rec
5176: , x_return_status => x_return_status

Line 5239: BSC_KPI_PVT.Delete_Ind_Subtitles

5235: BEGIN
5236: FND_MSG_PUB.Initialize;
5237: x_return_status := FND_API.G_RET_STS_SUCCESS;
5238:
5239: BSC_KPI_PVT.Delete_Ind_Subtitles
5240: (
5241: p_commit => p_commit
5242: , p_Bsc_Kpi_Entity_Rec => p_Bsc_Kpi_Entity_Rec
5243: , x_return_status => x_return_status

Line 5306: BSC_KPI_PVT.Delete_Ind_SeriesColors

5302: BEGIN
5303: FND_MSG_PUB.Initialize;
5304: x_return_status := FND_API.G_RET_STS_SUCCESS;
5305:
5306: BSC_KPI_PVT.Delete_Ind_SeriesColors
5307: (
5308: p_commit => p_commit
5309: , p_Bsc_Kpi_Entity_Rec => p_Bsc_Kpi_Entity_Rec
5310: , x_return_status => x_return_status

Line 5374: BSC_KPI_PVT.Delete_Ind_Images

5370: BEGIN
5371: FND_MSG_PUB.Initialize;
5372: x_return_status := FND_API.G_RET_STS_SUCCESS;
5373:
5374: BSC_KPI_PVT.Delete_Ind_Images
5375: (
5376: p_commit => p_commit
5377: , p_Bsc_Kpi_Entity_Rec => p_Bsc_Kpi_Entity_Rec
5378: , x_return_status => x_return_status

Line 5441: BSC_KPI_PVT.Delete_Ind_Sys_Prop

5437: BEGIN
5438: FND_MSG_PUB.Initialize;
5439: x_return_status := FND_API.G_RET_STS_SUCCESS;
5440:
5441: BSC_KPI_PVT.Delete_Ind_Sys_Prop
5442: (
5443: p_commit => p_commit
5444: , p_Bsc_Kpi_Entity_Rec => p_Bsc_Kpi_Entity_Rec
5445: , x_return_status => x_return_status

Line 5509: BSC_KPI_PVT.Delete_Ind_Comments

5505: BEGIN
5506: FND_MSG_PUB.Initialize;
5507: x_return_status := FND_API.G_RET_STS_SUCCESS;
5508:
5509: BSC_KPI_PVT.Delete_Ind_Comments
5510: (
5511: p_commit => p_commit
5512: , p_Bsc_Kpi_Entity_Rec => p_Bsc_Kpi_Entity_Rec
5513: , x_return_status => x_return_status

Line 5577: BSC_KPI_PVT.Delete_Ind_Tree_Nodes

5573: BEGIN
5574: FND_MSG_PUB.Initialize;
5575: x_return_status := FND_API.G_RET_STS_SUCCESS;
5576:
5577: BSC_KPI_PVT.Delete_Ind_Tree_Nodes
5578: (
5579: p_commit => p_commit
5580: , p_Bsc_Kpi_Entity_Rec => p_Bsc_Kpi_Entity_Rec
5581: , x_return_status => x_return_status

Line 5645: BSC_KPI_PVT.Delete_Ind_User_Access

5641: BEGIN
5642: FND_MSG_PUB.Initialize;
5643: x_return_status := FND_API.G_RET_STS_SUCCESS;
5644:
5645: BSC_KPI_PVT.Delete_Ind_User_Access
5646: (
5647: p_commit => p_commit
5648: , p_Bsc_Kpi_Entity_Rec => p_Bsc_Kpi_Entity_Rec
5649: , x_return_status => x_return_status

Line 5709: BSC_KPI_PVT.Delete_Sim_Tree_Data

5705: x_return_status := FND_API.G_RET_STS_SUCCESS;
5706:
5707:
5708:
5709: BSC_KPI_PVT.Delete_Sim_Tree_Data
5710: (
5711: p_commit => p_commit
5712: , p_Bsc_Kpi_Entity_Rec => p_Bsc_Kpi_Entity_Rec
5713: , x_return_status => x_return_status