APPS.BSC_ANALYSIS_OPTION_PVT dependencies on BSC_KPI_PUB

Line 1308: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

1304: , x_msg_data OUT NOCOPY VARCHAR2
1305: ) IS
1306: l_Group_ID BSC_KPI_ANALYSIS_OPTIONS_B.Analysis_Group_Id%TYPE;
1307: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
1308: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
1309:
1310: l_AnaOpt_Delete BOOLEAN := TRUE;
1311: l_delete VARCHAR2(1);
1312: l_count NUMBER;

Line 1326: AND Prototype_Flag <> BSC_KPI_PUB.Delete_Kpi_Flag;

1322: CURSOR c_kpi_ids IS
1323: SELECT indicator
1324: FROM BSC_KPIS_B
1325: WHERE Source_Indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
1326: AND Prototype_Flag <> BSC_KPI_PUB.Delete_Kpi_Flag;
1327: BEGIN
1328: FND_MSG_PUB.Initialize;
1329: x_return_status := FND_API.G_RET_STS_SUCCESS;
1330: SAVEPOINT DeleteBSCAnaOptPVT;

Line 2629: AND Prototype_Flag <> BSC_KPI_PUB.Delete_Kpi_Flag;

2625: WHERE Source_Indicator = p_kpi_id
2626: AND A.Indicator = B.Indicator
2627: AND B.analysis_group_id = p_anal_group_id
2628: AND B.option_id = p_anal_option_id
2629: AND Prototype_Flag <> BSC_KPI_PUB.Delete_Kpi_Flag;
2630: BEGIN
2631: FND_MSG_PUB.Initialize;
2632: x_return_status := FND_API.G_RET_STS_SUCCESS;
2633: -- First check if it is a Shared Kpi. If it is then no deletion.

Line 2657: AND Prototype_Flag <> BSC_KPI_PUB.Delete_Kpi_Flag;

2653: SELECT COUNT(indicator)
2654: INTO l_value
2655: FROM BSC_KPIS_B
2656: WHERE source_indicator = p_kpi_id
2657: AND Prototype_Flag <> BSC_KPI_PUB.Delete_Kpi_Flag;
2658: IF (l_value = 0) then
2659: RETURN 'Y';
2660: END IF;
2661:

Line 3947: AND K.PROTOTYPE_FLAG <> BSC_KPI_PUB.DELETE_KPI_FLAG;

3943: CURSOR c_Shared_Objectives IS
3944: SELECT K.INDICATOR
3945: FROM BSC_KPIS_B K
3946: WHERE K.SOURCE_INDICATOR = p_Kpi_Id
3947: AND K.PROTOTYPE_FLAG <> BSC_KPI_PUB.DELETE_KPI_FLAG;
3948:
3949:
3950: l_Default_Value BSC_KPI_ANALYSIS_MEASURES_B.DEFAULT_VALUE%TYPE;
3951: l_Count NUMBER;