eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_KPI_PVT dependencies on BSC_KPIS_B

Line 83: FROM BSC_KPIS_B

79: -- Check that KPI Id does not exist yet.
80: IF l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id IS NOT NULL THEN
81:
82: SELECT COUNT(1) INTO l_Count
83: FROM BSC_KPIS_B
84: WHERE INDICATOR = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
85:
86: IF l_count <> 0 THEN
87: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_ID_EXISTS');

Line 108: FROM BSC_KPIS_B

104:
105: -- Fixed for Bug#3781764 added PROTOTYPE_FLAG
106: IF l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Short_Name IS NOT NULL THEN
107: SELECT COUNT(1) INTO l_Count
108: FROM BSC_KPIS_B
109: WHERE SHORT_NAME = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Short_Name
110: AND PROTOTYPE_FLAG <> BSC_KPI_PUB.DELETE_KPI_FLAG;
111:
112: IF l_Count <> 0 THEN

Line 126: from BSC_KPIS_B

122: -- If display order value for KPI is null assign next value within Kpi group.
123: -- if l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Display_Order is null then
124: select count(1) + 1
125: into l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Display_Order
126: from BSC_KPIS_B
127: where ind_group_id = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Group_Id;
128: -- end if;
129:
130: -- Set some null values to defaults, such as dates.

Line 139: l_db_object := 'BSC_KPIS_B';

135: if l_Bsc_Kpi_Entity_Rec.Last_Update_Date is null then
136: l_Bsc_Kpi_Entity_Rec.Last_Update_Date := sysdate;
137: end if;
138:
139: l_db_object := 'BSC_KPIS_B';
140: l_Bsc_Kpi_Entity_Rec.Bsc_Color_Rollup_Type := BSC_COLOR_CALC_UTIL.DEFAULT_KPI;
141: l_Bsc_Kpi_Entity_Rec.Bsc_Prototype_Color_Id := BSC_COLOR_REPOSITORY.EXCELLENT_COLOR;
142: l_Bsc_Kpi_Entity_Rec.Bsc_Prototype_Trend_Id := 0;
143: l_Bsc_Kpi_Entity_Rec.Bsc_Weighted_Color_Method := 1;

Line 145: insert into BSC_KPIS_B( INDICATOR

141: l_Bsc_Kpi_Entity_Rec.Bsc_Prototype_Color_Id := BSC_COLOR_REPOSITORY.EXCELLENT_COLOR;
142: l_Bsc_Kpi_Entity_Rec.Bsc_Prototype_Trend_Id := 0;
143: l_Bsc_Kpi_Entity_Rec.Bsc_Weighted_Color_Method := 1;
144:
145: insert into BSC_KPIS_B( INDICATOR
146: ,CSF_ID
147: ,IND_GROUP_ID
148: ,DISP_ORDER
149: ,PROTOTYPE_FLAG

Line 227: from bsc_kpis_b

223: end if;
224:
225: select count(indicator)
226: into l_count
227: from bsc_kpis_b
228: where indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id ;
229:
230:
231: EXCEPTION

Line 359: FROM BSC_KPIS_B A

355: ,x_Bsc_Kpi_Entity_Rec.Bsc_Weighted_Color_Method
356: ,x_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Name
357: ,x_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Help
358: ,x_Bsc_Kpi_Entity_Rec.Bsc_Source_Language
359: FROM BSC_KPIS_B A
360: ,BSC_KPIS_TL B
361: WHERE A.INDICATOR = B.INDICATOR
362: AND A.INDICATOR = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
363: AND B.LANGUAGE = USERENV('LANG');

Line 427: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

423: x_return_status := FND_API.G_RET_STS_SUCCESS;
424: SAVEPOINT BscKpiPvt_UptKPI;
425: -- Check that valid id was entered.
426: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
427: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
428: ,'indicator'
429: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
430: if l_count = 0 then
431: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 540: update BSC_KPIS_B

536: l_Bsc_Kpi_Entity_Rec.Bsc_Weighted_Color_Method := p_Bsc_Kpi_Entity_Rec.Bsc_Weighted_Color_Method;
537: end if;
538:
539:
540: update BSC_KPIS_B
541: set csf_id = l_Bsc_Kpi_Entity_Rec.Bsc_Csf_Id
542: ,ind_group_id = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Group_Id
543: ,disp_order = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Display_Order
544: ,prototype_flag = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Prototype_Flag

Line 642: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

638: x_return_status := FND_API.G_RET_STS_SUCCESS;
639: SAVEPOINT BscKpiPvt_DelKPI;
640: -- Check that valid id was entered.
641: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
642: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
643: ,'indicator'
644: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
645: if l_count = 0 then
646: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 673: DELETE FROM BSC_KPIS_B

669: l_Delete_Kpi_b := FALSE;
670: END IF;
671: END IF;
672: IF l_Delete_Kpi_b THEN
673: DELETE FROM BSC_KPIS_B
674: WHERE INDICATOR = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
675:
676: DELETE FROM BSC_KPIS_TL
677: WHERE INDICATOR = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;

Line 679: UPDATE BSC_KPIS_B

675:
676: DELETE FROM BSC_KPIS_TL
677: WHERE INDICATOR = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
678: ELSE
679: UPDATE BSC_KPIS_B
680: SET PROTOTYPE_FLAG = BSC_KPI_PUB.DELETE_KPI_FLAG
681: WHERE INDICATOR = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
682: END IF;
683:

Line 767: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

763:
764: -- Check that valid id was entered.
765: if l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
766:
767: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
768: ,'indicator'
769: ,l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
770: if l_count = 0 then
771:

Line 1122: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

1118: x_return_status := FND_API.G_RET_STS_SUCCESS;
1119: SAVEPOINT BscKpiPvt_CrtKPIProp;
1120: -- Check that valid id was entered.
1121: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
1122: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
1123: ,'indicator'
1124: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1125: if l_count = 0 then
1126: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 1294: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

1290: x_return_status := FND_API.G_RET_STS_SUCCESS;
1291: SAVEPOINT BscKpiPvt_UptKPIProp;
1292: -- Check that valid id was entered.
1293: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
1294: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
1295: ,'indicator'
1296: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1297: if l_count = 0 then
1298: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 1405: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

1401: FND_MSG_PUB.Initialize;
1402: x_return_status := FND_API.G_RET_STS_SUCCESS;
1403: SAVEPOINT BscKpiPvt_DelKPIProp;
1404: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
1405: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
1406: ,'indicator'
1407: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1408: if l_count = 0 then
1409: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 1497: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

1493: x_return_status := FND_API.G_RET_STS_SUCCESS;
1494: SAVEPOINT BscKpiPvt_CrtKPIAnal;
1495: -- Check that valid id was entered.
1496: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
1497: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
1498: ,'indicator'
1499: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1500: if l_count = 0 then
1501: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 1752: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

1748: x_return_status := FND_API.G_RET_STS_SUCCESS;
1749: SAVEPOINT BscKpiPvt_UpdKPIAnal;
1750: -- Check that valid id was entered.
1751: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
1752: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
1753: ,'indicator'
1754: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1755: if l_count = 0 then
1756: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 1906: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

1902: x_return_status := FND_API.G_RET_STS_SUCCESS;
1903: SAVEPOINT BscKpiPvt_DelKPIAnal;
1904: -- Check that valid id was entered.
1905: IF (p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id IS NOT NULL) THEN
1906: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
1907: ,'indicator'
1908: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1909: IF(l_count = 0 )THEN
1910: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 2013: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

2009: x_return_status := FND_API.G_RET_STS_SUCCESS;
2010: SAVEPOINT BscKpiPvt_DelObjColo;
2011: -- Check that valid id was entered.
2012: IF (p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id IS NOT NULL) THEN
2013: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
2014: ,'indicator'
2015: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2016: IF(l_count = 0 )THEN
2017: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 2135: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

2131: l_Bsc_Kpi_Entity_Rec := p_Bsc_Kpi_Entity_Rec;
2132:
2133: -- Check that valid id was entered.
2134: if l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
2135: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
2136: ,'indicator'
2137: ,l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2138: if l_count = 0 then
2139: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 2368: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

2364: x_return_status := FND_API.G_RET_STS_SUCCESS;
2365: SAVEPOINT BscKpiPvt_UptKPIPerid;
2366: -- Check that valid id was entered.
2367: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
2368: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
2369: ,'indicator'
2370: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2371: if l_count = 0 then
2372: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 2520: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

2516: x_return_status := FND_API.G_RET_STS_SUCCESS;
2517: SAVEPOINT BscKpiPvt_DelKPIPerid;
2518: -- Check that valid id was entered.
2519: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
2520: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
2521: ,'indicator'
2522: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2523: if l_count = 0 then
2524: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 2608: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

2604: x_return_status := FND_API.G_RET_STS_SUCCESS;
2605: SAVEPOINT BscKpiPvt_CrtKPIDaTab;
2606: -- Check that valid id was entered.
2607: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
2608: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
2609: ,'indicator'
2610: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2611: if l_count = 0 then
2612: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 2786: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

2782: x_return_status := FND_API.G_RET_STS_SUCCESS;
2783: SAVEPOINT BscKpiPvt_UptKPIDaTab;
2784: -- Check that valid id was entered.
2785: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
2786: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
2787: ,'indicator'
2788: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2789: if l_count = 0 then
2790: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 2904: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

2900: x_return_status := FND_API.G_RET_STS_SUCCESS;
2901: SAVEPOINT BscKpiPvt_DelKPIDaTab;
2902: -- Check that valid id was entered.
2903: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
2904: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
2905: ,'indicator'
2906: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2907: if l_count = 0 then
2908: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 3012: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

3008: x_return_status := FND_API.G_RET_STS_SUCCESS;
3009: SAVEPOINT BscKpiPvt_CrtKPICalc;
3010: -- Check that valid id was entered.
3011: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
3012: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
3013: ,'indicator'
3014: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3015: if l_count = 0 then
3016: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 3197: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

3193: x_return_status := FND_API.G_RET_STS_SUCCESS;
3194: SAVEPOINT BscKpiPvt_UptKPICalc;
3195: -- Check that valid id was entered.
3196: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
3197: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
3198: ,'indicator'
3199: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3200: if l_count = 0 then
3201: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 3341: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

3337: x_return_status := FND_API.G_RET_STS_SUCCESS;
3338: SAVEPOINT BscKpiPvt_DelKPICalc;
3339: -- Check that valid id was entered.
3340: IF(p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id IS NOT NULL) THEN
3341: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
3342: ,'indicator'
3343: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3344: IF (l_count = 0) THEN
3345: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 3433: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

3429: x_return_status := FND_API.G_RET_STS_SUCCESS;
3430: SAVEPOINT BscKpiPvt_CrtKPIUsrAcc;
3431: -- Check that valid id was entered.
3432: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
3433: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
3434: ,'indicator'
3435: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3436: if l_count = 0 then
3437: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 3631: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

3627: x_return_status := FND_API.G_RET_STS_SUCCESS;
3628: SAVEPOINT BscKpiPvt_UptKPIUsrAcc;
3629: -- Check that valid id was entered.
3630: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
3631: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
3632: ,'indicator'
3633: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3634: if l_count = 0 then
3635: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 3763: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

3759: x_return_status := FND_API.G_RET_STS_SUCCESS;
3760: SAVEPOINT BscKpiPvt_DelKPIUsrAcc;
3761: -- Check that valid id was entered.
3762: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
3763: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
3764: ,'indicator'
3765: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3766: if l_count = 0 then
3767: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 3855: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

3851: l_Bsc_Kpi_Entity_Rec := p_Bsc_Kpi_Entity_Rec;
3852:
3853: -- Check that valid id was entered.
3854: if l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
3855: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
3856: ,'indicator'
3857: ,l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3858: if l_count = 0 then
3859: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 4197: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

4193: x_return_status := FND_API.G_RET_STS_SUCCESS;
4194: SAVEPOINT BscKpiPvt_UpdKPIDefVals;
4195: -- Check that valid id was entered.
4196: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
4197: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
4198: ,'indicator'
4199: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4200: if l_count = 0 then
4201: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 4460: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

4456: x_return_status := FND_API.G_RET_STS_SUCCESS;
4457: SAVEPOINT BscKpiPvt_DelKPIDefVals;
4458: -- Check that valid id was entered.
4459: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
4460: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
4461: ,'indicator'
4462: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4463: if l_count = 0 then
4464: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 4558: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

4554: --DBMS_OUTPUT.PUT_LINE('l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Prototype_Flag = ' || l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Prototype_Flag);
4555:
4556: -- Check that valid id was entered.
4557: if l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
4558: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
4559: ,'indicator'
4560: ,l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4561: if l_count = 0 then
4562: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 4848: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

4844: --DBMS_OUTPUT.PUT_LINE(' -- Begin BSC_KPI_PVT.Update_Kpi_In_Tab');
4845:
4846: -- Check that valid id was entered.
4847: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
4848: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
4849: ,'indicator'
4850: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4851: if l_count = 0 then
4852: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 4869: update BSC_KPIS_B

4865: --DBMS_OUTPUT.PUT_LINE(' p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Prototype_Flag = ' || p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Prototype_Flag);
4866:
4867: -- Update prototype flag.
4868:
4869: update BSC_KPIS_B
4870: set prototype_flag = nvl(p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Prototype_Flag,7)
4871: where indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
4872: and decode(prototype_flag, 0, 8, prototype_flag) > 7;
4873:

Line 4964: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

4960: x_return_status := FND_API.G_RET_STS_SUCCESS;
4961: SAVEPOINT BscKpiPvt_DelKPIInTab;
4962: -- Check that valid id was entered.
4963: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
4964: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
4965: ,'indicator'
4966: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4967: if l_count = 0 then
4968: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 5048: update BSC_KPIS_B

5044: begin
5045: FND_MSG_PUB.Initialize;
5046: x_return_status := FND_API.G_RET_STS_SUCCESS;
5047: SAVEPOINT BscKpiPvt_UptKPITimSta;
5048: update BSC_KPIS_B
5049: set last_update_date = sysdate
5050: where indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
5051:
5052: if (p_commit = FND_API.G_TRUE) then

Line 5130: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

5126: --DBMS_OUTPUT.PUT_LINE('-- Begin BSC_KPI_PVT.Create_Master_Kpi');
5127:
5128: -- Check that valid id was entered.
5129: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
5130: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
5131: ,'indicator'
5132: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
5133: if l_count = 0 then
5134: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 5306: l_config_type BSC_KPIS_B.config_type%TYPE;

5302: l_master_opt_default NUMBER;
5303: l_def_opt NUMBER;
5304: l_prototype_flag NUMBER;
5305: l_temp VARCHAR2(2000);
5306: l_config_type BSC_KPIS_B.config_type%TYPE;
5307: l_short_name BSC_KPIS_B.short_name%TYPE;
5308:
5309:
5310: begin

Line 5307: l_short_name BSC_KPIS_B.short_name%TYPE;

5303: l_def_opt NUMBER;
5304: l_prototype_flag NUMBER;
5305: l_temp VARCHAR2(2000);
5306: l_config_type BSC_KPIS_B.config_type%TYPE;
5307: l_short_name BSC_KPIS_B.short_name%TYPE;
5308:
5309:
5310: begin
5311: FND_MSG_PUB.Initialize;

Line 5325: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id := BSC_DIMENSION_LEVELS_PVT.Get_Next_Value( 'BSC_KPIS_B'

5321: -- After we will change necessary values to make the new Indicator a shared
5322: -- Indicator.
5323:
5324: -- Get the next id available for the current Kpi.
5325: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id := BSC_DIMENSION_LEVELS_PVT.Get_Next_Value( 'BSC_KPIS_B'
5326: ,'indicator');
5327: --DBMS_OUTPUT.PUT_LINE(' BSC_KPI_PVT.Create_Shared_Kpi - Flag 1');
5328: --DBMS_OUTPUT.PUT_LINE(' New KPI code := ' || l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
5329:

Line 5456: update BSC_KPIS_B

5452:
5453: --DBMS_OUTPUT.PUT_LINE(' BSC_KPI_PVT.Create_Shared_Kpi - Flag 9');
5454:
5455: -- Set shared flag values.
5456: update BSC_KPIS_B
5457: set share_flag = 2
5458: ,prototype_flag = l_prototype_flag
5459: ,source_indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
5460: where indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;

Line 5779: FROM BSC_KPIS_B

5775: l_def_option number;
5776:
5777: CURSOR c_Select_Indicator IS
5778: SELECT INDICATOR
5779: FROM BSC_KPIS_B
5780: WHERE SOURCE_INDICATOR = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_id
5781: AND PROTOTYPE_FLAG <> BSC_KPI_PUB.Delete_Kpi_Flag;
5782:
5783: begin

Line 5803: FROM BSC_KPIS_B

5799:
5800: -- Check if this is the Master KPI.
5801: SELECT SHARE_FLAG, PROTOTYPE_FLAG
5802: INTO l_share_flag, l_proto_flag
5803: FROM BSC_KPIS_B
5804: WHERE INDICATOR = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_id;
5805:
5806: if ((l_share_flag = 1) and (l_proto_flag <> BSC_KPI_PUB.DELETE_KPI_FLAG)) then
5807:

Line 5864: from BSC_KPIS_B

5860:
5861: -- Get the source indicator for this shared indicator.
5862: select source_indicator
5863: into l_shared_kpi
5864: from BSC_KPIS_B
5865: where indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_id;
5866:
5867: -- Get the default analysis option id.
5868: select default_value

Line 6125: FROM BSC_KPIS_B

6121: SAVEPOINT BscKpiPvt_SetDefOptionMG;
6122: -- Get the source indicator for this shared kpi.
6123: SELECT Source_Indicator, Prototype_Flag
6124: INTO l_source_kpi, l_proto_flag
6125: FROM BSC_KPIS_B
6126: WHERE INDICATOR = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
6127:
6128: IF (l_proto_flag <> BSC_KPI_PUB.Delete_Kpi_Flag) THEN
6129: -- Get the number of analysis groups in this or in source kpi.

Line 6850: FROM bsc_kpis_b

6846: -- Check that valid id was entered.
6847: IF (p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id IS NOT NULL)THEN
6848: SELECT COUNT(0)
6849: INTO l_count
6850: FROM bsc_kpis_b
6851: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
6852:
6853: IF (l_count = 0) THEN
6854: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 6953: FROM bsc_kpis_b

6949:
6950: IF (p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id IS NOT NULL)THEN
6951: SELECT COUNT(0)
6952: INTO l_count
6953: FROM bsc_kpis_b
6954: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
6955:
6956: IF (l_count = 0) THEN
6957: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 7052: FROM bsc_kpis_b

7048:
7049: IF (p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id IS NOT NULL)THEN
7050: SELECT COUNT(0)
7051: INTO l_count
7052: FROM bsc_kpis_b
7053: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7054:
7055: IF (l_count = 0) THEN
7056: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 7145: FROM bsc_kpis_b

7141:
7142: IF (p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id IS NOT NULL)THEN
7143: SELECT COUNT(0)
7144: INTO l_count
7145: FROM bsc_kpis_b
7146: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7147:
7148: IF (l_count = 0) THEN
7149: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 7239: FROM bsc_kpis_b

7235:
7236: IF (p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id IS NOT NULL)THEN
7237: SELECT COUNT(0)
7238: INTO l_count
7239: FROM bsc_kpis_b
7240: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7241:
7242: IF (l_count = 0) THEN
7243: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 7333: FROM bsc_kpis_b

7329:
7330: IF (p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id IS NOT NULL)THEN
7331: SELECT COUNT(0)
7332: INTO l_count
7333: FROM bsc_kpis_b
7334: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7335:
7336: IF (l_count = 0) THEN
7337: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 7438: FROM bsc_kpis_b

7434:
7435: IF (p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id IS NOT NULL)THEN
7436: SELECT COUNT(0)
7437: INTO l_count
7438: FROM bsc_kpis_b
7439: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7440:
7441: IF (l_count = 0) THEN
7442: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 7560: FROM bsc_kpis_b

7556:
7557: IF (p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id IS NOT NULL)THEN
7558: SELECT COUNT(0)
7559: INTO l_count
7560: FROM bsc_kpis_b
7561: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7562:
7563: IF (l_count = 0) THEN
7564: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 7653: FROM bsc_kpis_b

7649:
7650: IF (p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id IS NOT NULL)THEN
7651: SELECT COUNT(0)
7652: INTO l_count
7653: FROM bsc_kpis_b
7654: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7655:
7656: IF (l_count = 0) THEN
7657: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 7751: FROM bsc_kpis_b

7747:
7748: IF (p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id IS NOT NULL)THEN
7749: SELECT COUNT(0)
7750: INTO l_count
7751: FROM bsc_kpis_b
7752: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7753:
7754: IF (l_count = 0) THEN
7755: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 7856: FROM bsc_kpis_b

7852:
7853: IF (p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id IS NOT NULL)THEN
7854: SELECT COUNT(0)
7855: INTO l_count
7856: FROM bsc_kpis_b
7857: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7858:
7859: IF (l_count = 0) THEN
7860: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');