The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT analysis_option0, analysis_option1, analysis_option2, series_id
FROM bsc_kpi_analysis_measures_b
WHERE indicator = p_indicator
AND kpi_measure_id = p_kpi_measure_id;
SELECT kpi_measure_id
FROM bsc_kpi_analysis_measures_b
WHERE indicator = p_indicator
AND analysis_option0 = p_analysis_option0
AND analysis_option1 = p_analysis_option1
AND analysis_option2 = p_analysis_option2
AND series_id = p_series_id;
SELECT indicator
FROM bsc_kpis_b
WHERE source_indicator = p_indicator
AND share_flag = 2 -- shared objective.
AND prototype_flag <> 2;
SELECT indicator
FROM bsc_kpis_b
WHERE source_indicator = p_indicator
AND share_flag = 2 -- shared objective.
AND prototype_flag <> 2;
l_kpi_measure_rec.last_updated_by := FND_GLOBAL.USER_ID;
l_kpi_measure_rec.last_update_date := SYSDATE;
l_kpi_measure_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
SELECT short_name,config_type into l_short_name,l_config_type
FROM bsc_kpis_b
WHERE indicator = p_objective_id;
PROCEDURE Update_Kpi_Measure_Props (
p_commit IN VARCHAR2 := FND_API.G_FALSE
, p_kpi_measure_rec IN BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec
, p_cascade_shared IN BOOLEAN := TRUE
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
)
IS
CURSOR c_shared_obj(p_indicator NUMBER) IS
SELECT indicator
FROM bsc_kpis_b
WHERE source_indicator = p_indicator
AND share_flag = 2 -- shared objective.
AND prototype_flag <> 2;
SAVEPOINT BscKpiMeasurePub_Update;
BSC_KPI_MEASURE_PROPS_PVT.Update_Kpi_Measure_Props
( p_commit => p_commit
, p_kpi_measure_rec => p_kpi_measure_rec
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
BSC_KPI_MEASURE_PROPS_PVT.Update_Kpi_Measure_Props
( p_commit => p_commit
, p_kpi_measure_rec => l_kpi_measure_rec
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
ROLLBACK TO BscKpiMeasurePub_Update;
ROLLBACK TO BscKpiMeasurePub_Update;
ROLLBACK TO BscKpiMeasurePub_Update;
x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Update_Kpi_Measure_Props ';
x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Update_Kpi_Measure_Props ';
ROLLBACK TO BscKpiMeasurePub_Update;
x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Update_Kpi_Measure_Props ';
x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Update_Kpi_Measure_Props ';
END Update_Kpi_Measure_Props;
PROCEDURE Delete_Kpi_Measure_Props (
p_commit IN VARCHAR2:= FND_API.G_FALSE
, p_objective_id IN NUMBER
, p_kpi_measure_id IN NUMBER
, p_cascade_shared IN BOOLEAN := TRUE
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
)
IS
CURSOR c_shared_obj(p_indicator NUMBER) IS
SELECT indicator
FROM bsc_kpis_b
WHERE source_indicator = p_indicator
AND share_flag = 2 -- shared objective.
AND prototype_flag <> 2;
SAVEPOINT BscKpiMeasurePub_Delete;
BSC_KPI_MEASURE_PROPS_PVT.Delete_Kpi_Measure_Props
( p_commit => p_commit
, p_objective_id => p_objective_id
, p_kpi_measure_id => p_kpi_measure_id
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
BSC_KPI_MEASURE_PROPS_PVT.Delete_Kpi_Measure_Props
( p_commit => p_commit
, p_objective_id => c_shared.indicator
, p_kpi_measure_id => l_kpi_measure_id
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
ROLLBACK TO BscKpiMeasurePub_Delete;
ROLLBACK TO BscKpiMeasurePub_Delete;
ROLLBACK TO BscKpiMeasurePub_Delete;
x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Delete_Kpi_Measure_Props ';
x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Kpi_Measure_Props ';
ROLLBACK TO BscKpiMeasurePub_Delete;
x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Delete_Kpi_Measure_Props ';
x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Kpi_Measure_Props ';
END Delete_Kpi_Measure_Props;
PROCEDURE Delete_Obj_Kpi_Measure_Props (
p_commit IN VARCHAR2:= FND_API.G_FALSE
, p_objective_id IN NUMBER
, p_cascade_shared IN BOOLEAN := TRUE
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
)
IS
CURSOR c_shared_obj(p_indicator NUMBER) IS
SELECT indicator
FROM bsc_kpis_b
WHERE source_indicator = p_indicator
AND share_flag = 2 -- shared objective.
AND prototype_flag <> 2;
SAVEPOINT BscKpiMeasurePub_DeleteAll;
BSC_KPI_MEASURE_PROPS_PVT.Delete_Obj_Kpi_Measure_Props
( p_commit => p_commit
, p_objective_id => p_objective_id
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
BSC_KPI_MEASURE_PROPS_PVT.Delete_Obj_Kpi_Measure_Props
( p_commit => p_commit
, p_objective_id => c_shared.indicator
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
ROLLBACK TO BscKpiMeasurePub_DeleteAll;
ROLLBACK TO BscKpiMeasurePub_DeleteAll;
ROLLBACK TO BscKpiMeasurePub_DeleteAll;
x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';
x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';
ROLLBACK TO BscKpiMeasurePub_DeleteAll;
x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';
x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';
END Delete_Obj_Kpi_Measure_Props;
x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';
x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';
x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';
x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';