The following lines contain the word 'select', 'insert', 'update' or 'delete':
| 09/15/05 jxyu Added Update_WM_Last_Update_Info API for bug#4427932. |
| |
+======================================================================================*/
-- Abbreviation Used"
-- WM -> Weighted Measure
-- SN -> Short Name
------- APIs for tables BIS_WEIGHTED_MEASURE_DEPENDS
/*******************************************************************
*******************************************************************/
PROCEDURE Create_WM_Dependency(
p_commit IN VARCHAR2 --:= FND_API.G_FALSE
,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) IS
BEGIN
SAVEPOINT CreateWMDependencyPVT;
INSERT INTO BIS_WEIGHTED_MEASURE_DEPENDS(
WEIGHTED_MEASURE_ID
,DEPENDENT_MEASURE_ID
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
) VALUES (
p_Bis_WM_Rec.weighted_measure_id
,p_Bis_WM_Rec.dependent_measure_id
,p_Bis_WM_Rec.Creation_Date
,p_Bis_WM_Rec.Created_By
,p_Bis_WM_Rec.Last_Update_Date
,p_Bis_WM_Rec.Last_Updated_By
,p_Bis_WM_Rec.Last_Update_Login
);
SELECT
WEIGHTED_MEASURE_ID
,DEPENDENT_MEASURE_ID
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
INTO
x_Bis_WM_Rec.weighted_measure_id
,x_Bis_WM_Rec.dependent_measure_id
,x_Bis_WM_Rec.Creation_Date
,x_Bis_WM_Rec.Created_By
,x_Bis_WM_Rec.Last_Update_Date
,x_Bis_WM_Rec.Last_Updated_By
,x_Bis_WM_Rec.Last_Update_Login
FROM BIS_WEIGHTED_MEASURE_DEPENDS
WHERE WEIGHTED_MEASURE_ID = p_Bis_WM_Rec.weighted_measure_id
AND DEPENDENT_MEASURE_ID = p_Bis_WM_Rec.dependent_measure_id;
PROCEDURE Update_WM_Dependency(
p_commit IN VARCHAR2 --:= FND_API.G_FALSE
,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) IS
BEGIN
SAVEPOINT bis_Update_WM_Dependency_PVT;
UPDATE BIS_WEIGHTED_MEASURE_DEPENDS SET
LAST_UPDATE_DATE = p_Bis_WM_Rec.Last_Update_Date
,LAST_UPDATED_BY = p_Bis_WM_Rec.Last_Updated_By
,LAST_UPDATE_LOGIN = p_Bis_WM_Rec.Last_Update_Login
WHERE WEIGHTED_MEASURE_ID = p_Bis_WM_Rec.weighted_measure_id
AND DEPENDENT_MEASURE_ID = p_Bis_WM_Rec.dependent_measure_id;
ROLLBACK TO bis_Update_WM_Dependency_PVT;
ROLLBACK TO bis_Update_WM_Dependency_PVT;
ROLLBACK TO bis_Update_WM_Dependency_PVT;
x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PVT.Update_WM_Dependency ';
x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PVT.Update_WM_Dependency ';
END Update_WM_Dependency;
PROCEDURE Delete_WM_Dependency(
p_commit IN VARCHAR2 --:= FND_API.G_FALSE
,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) IS
BEGIN
SAVEPOINT Delete_WM_Dependency_PVT;
DELETE BIS_WEIGHTED_MEASURE_DEPENDS
WHERE WEIGHTED_MEASURE_ID = p_Bis_WM_Rec.weighted_measure_id
AND DEPENDENT_MEASURE_ID = p_Bis_WM_Rec.dependent_measure_id;
ROLLBACK TO Delete_WM_Dependency_PVT;
ROLLBACK TO Delete_WM_Dependency_PVT;
ROLLBACK TO Delete_WM_Dependency_PVT;
x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PVT.Delete_WM_Dependency ';
x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PVT.Delete_WM_Dependency ';
END Delete_WM_Dependency;
INSERT INTO BIS_WEIGHTED_MEASURE_DEFNS(
WEIGHTED_DEFINITION_ID
,WEIGHTED_MEASURE_ID
,VIEWBY_DIMENSION_SHORT_NAME
,VIEWBY_DIM_LEVEL_SHORT_NAME
,FILTER_DIMENSION_SHORT_NAME
,FILTER_DIM_LEVEL_SHORT_NAME
,TIME_DIMENSION_SHORT_NAME
,TIME_DIM_LEVEL_SHORT_NAME
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
) VALUES (
p_Bis_WM_Rec.weighted_definition_id
,p_Bis_WM_Rec.weighted_measure_id
,p_Bis_WM_Rec.VIEWBY_dimension_SN
,p_Bis_WM_Rec.VIEWBY_dim_level_SN
,p_Bis_WM_Rec.FILTER_dimension_SN
,p_Bis_WM_Rec.FILTER_dim_level_SN
,p_Bis_WM_Rec.time_dimension_short_name
,p_Bis_WM_Rec.time_dim_level_short_name
,p_Bis_WM_Rec.Creation_Date
,p_Bis_WM_Rec.Created_By
,p_Bis_WM_Rec.Last_Update_Date
,p_Bis_WM_Rec.Last_Updated_By
,p_Bis_WM_Rec.Last_Update_Login
);
SELECT
WEIGHTED_DEFINITION_ID
,WEIGHTED_MEASURE_ID
,VIEWBY_DIMENSION_SHORT_NAME
,VIEWBY_DIM_LEVEL_SHORT_NAME
,FILTER_DIMENSION_SHORT_NAME
,FILTER_DIM_LEVEL_SHORT_NAME
,TIME_DIMENSION_SHORT_NAME
,TIME_DIM_LEVEL_SHORT_NAME
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
INTO
x_Bis_WM_Rec.weighted_definition_id
,x_Bis_WM_Rec.weighted_measure_id
,x_Bis_WM_Rec.VIEWBY_dimension_SN
,x_Bis_WM_Rec.VIEWBY_dim_level_SN
,x_Bis_WM_Rec.FILTER_dimension_SN
,x_Bis_WM_Rec.FILTER_dim_level_SN
,x_Bis_WM_Rec.time_dimension_short_name
,x_Bis_WM_Rec.time_dim_level_short_name
,x_Bis_WM_Rec.Creation_Date
,x_Bis_WM_Rec.Created_By
,x_Bis_WM_Rec.Last_Update_Date
,x_Bis_WM_Rec.Last_Updated_By
,x_Bis_WM_Rec.Last_Update_Login
FROM BIS_WEIGHTED_MEASURE_DEFNS
WHERE WEIGHTED_DEFINITION_ID = p_Bis_WM_Rec.weighted_definition_id;
PROCEDURE Update_WM_Definition(
p_commit IN VARCHAR2 --:= FND_API.G_FALSE
,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) IS
BEGIN
SAVEPOINT bis_Update_WM_Definition_PVT;
UPDATE BIS_WEIGHTED_MEASURE_DEFNS SET
WEIGHTED_MEASURE_ID = p_Bis_WM_Rec.weighted_measure_id
,VIEWBY_DIMENSION_SHORT_NAME = p_Bis_WM_Rec.VIEWBY_dimension_SN
,VIEWBY_DIM_LEVEL_SHORT_NAME = p_Bis_WM_Rec.VIEWBY_dim_level_SN
,FILTER_DIMENSION_SHORT_NAME = p_Bis_WM_Rec.FILTER_dimension_SN
,FILTER_DIM_LEVEL_SHORT_NAME = p_Bis_WM_Rec.FILTER_dim_level_SN
,TIME_DIMENSION_SHORT_NAME = p_Bis_WM_Rec.time_dimension_short_name
,TIME_DIM_LEVEL_SHORT_NAME = p_Bis_WM_Rec.time_dim_level_short_name
,LAST_UPDATE_DATE = p_Bis_WM_Rec.Last_Update_Date
,LAST_UPDATED_BY = p_Bis_WM_Rec.Last_Updated_By
,LAST_UPDATE_LOGIN = p_Bis_WM_Rec.Last_Update_Login
WHERE
WEIGHTED_DEFINITION_ID = p_Bis_WM_Rec.weighted_definition_id;
ROLLBACK TO bis_Update_WM_Definition_PVT;
ROLLBACK TO bis_Update_WM_Definition_PVT;
ROLLBACK TO bis_Update_WM_Definition_PVT;
x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PVT.Update_WM_Definition ';
x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PVT.Update_WM_Definition ';
END Update_WM_Definition;
PROCEDURE Delete_WM_Definition(
p_commit IN VARCHAR2 --:= FND_API.G_FALSE
,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) IS
BEGIN
SAVEPOINT Delete_WM_Definition_PVT;
DELETE BIS_WEIGHTED_MEASURE_DEFNS
WHERE WEIGHTED_DEFINITION_ID = p_Bis_WM_Rec.weighted_definition_id;
ROLLBACK TO Delete_WM_Definition_PVT;
ROLLBACK TO Delete_WM_Definition_PVT;
ROLLBACK TO Delete_WM_Definition_PVT;
x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PVT.Delete_WM_Definition ';
x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PVT.Delete_WM_Definition ';
END Delete_WM_Definition;
INSERT INTO BIS_WEIGHTED_MEASURE_PARAMS(
WEIGHTED_PARAMETER_ID
,WEIGHTED_DEFINITION_ID
,TIME_LEVEL_VALUE_ID
,FILTER_LEVEL_VALUE_ID
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
) VALUES (
p_Bis_WM_Rec.weighted_parameter_id
,p_Bis_WM_Rec.weighted_definition_id
,p_Bis_WM_Rec.time_level_value_id
,p_Bis_WM_Rec.filter_level_value_id
,p_Bis_WM_Rec.Creation_Date
,p_Bis_WM_Rec.Created_By
,p_Bis_WM_Rec.Last_Update_Date
,p_Bis_WM_Rec.Last_Updated_By
,p_Bis_WM_Rec.Last_Update_Login
);
SELECT
WEIGHTED_PARAMETER_ID
,WEIGHTED_DEFINITION_ID
,time_level_value_id
,FILTER_LEVEL_VALUE_ID
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
INTO
x_Bis_WM_Rec.weighted_parameter_id
,x_Bis_WM_Rec.weighted_definition_id
,x_Bis_WM_Rec.time_level_value_id
,x_Bis_WM_Rec.FILTER_level_value_id
,x_Bis_WM_Rec.Creation_Date
,x_Bis_WM_Rec.Created_By
,x_Bis_WM_Rec.Last_Update_Date
,x_Bis_WM_Rec.Last_Updated_By
,x_Bis_WM_Rec.Last_Update_Login
FROM BIS_WEIGHTED_MEASURE_PARAMS
WHERE WEIGHTED_PARAMETER_ID = p_Bis_WM_Rec.weighted_parameter_id;
PROCEDURE Update_WM_Parameter(
p_commit IN VARCHAR2 --:= FND_API.G_FALSE
,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) IS
BEGIN
SAVEPOINT bis_Update_WM_Parameter_PVT;
UPDATE BIS_WEIGHTED_MEASURE_PARAMS SET
WEIGHTED_DEFINITION_ID = p_Bis_WM_Rec.weighted_definition_id
,TIME_LEVEL_VALUE_ID = p_Bis_WM_Rec.time_level_value_id
,FILTER_LEVEL_VALUE_ID = p_Bis_WM_Rec.filter_level_value_id
,LAST_UPDATE_DATE = p_Bis_WM_Rec.Last_Update_Date
,LAST_UPDATED_BY = p_Bis_WM_Rec.Last_Updated_By
,LAST_UPDATE_LOGIN = p_Bis_WM_Rec.Last_Update_Login
WHERE WEIGHTED_PARAMETER_ID = p_Bis_WM_Rec.weighted_parameter_id;
ROLLBACK TO bis_Update_WM_Parameter_PVT;
ROLLBACK TO bis_Update_WM_Parameter_PVT;
ROLLBACK TO bis_Update_WM_Parameter_PVT;
x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PVT.Update_WM_Parameter ';
x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PVT.Update_WM_Parameter ';
END Update_WM_Parameter;
PROCEDURE Delete_WM_Parameter(
p_commit IN VARCHAR2 --:= FND_API.G_FALSE
,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) IS
BEGIN
SAVEPOINT Delete_WM_Parameter_PVT;
DELETE BIS_WEIGHTED_MEASURE_PARAMS
WHERE WEIGHTED_PARAMETER_ID = p_Bis_WM_Rec.weighted_parameter_id;
ROLLBACK TO Delete_WM_Parameter_PVT;
ROLLBACK TO Delete_WM_Parameter_PVT;
ROLLBACK TO Delete_WM_Parameter_PVT;
x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PVT.Delete_WM_Parameter ';
x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PVT.Delete_WM_Parameter ';
END Delete_WM_Parameter;
INSERT INTO BIS_WEIGHTED_MEASURE_WEIGHTS(
WEIGHT_ID
,WEIGHTED_PARAMETER_ID
,DEPENDENT_MEASURE_ID
,WEIGHT
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
) VALUES (
p_Bis_WM_Rec.weight_id
,p_Bis_WM_Rec.weighted_parameter_id
,p_Bis_WM_Rec.dependent_measure_id
,p_Bis_WM_Rec.weight
,p_Bis_WM_Rec.Creation_Date
,p_Bis_WM_Rec.Created_By
,p_Bis_WM_Rec.Last_Update_Date
,p_Bis_WM_Rec.Last_Updated_By
,p_Bis_WM_Rec.Last_Update_Login
);
SELECT
WEIGHT_ID
,WEIGHTED_PARAMETER_ID
,DEPENDENT_MEASURE_ID
,WEIGHT
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
INTO
x_Bis_WM_Rec.weight_id
,x_Bis_WM_Rec.weighted_parameter_id
,x_Bis_WM_Rec.dependent_measure_id
,x_Bis_WM_Rec.weight
,x_Bis_WM_Rec.Creation_Date
,x_Bis_WM_Rec.Created_By
,x_Bis_WM_Rec.Last_Update_Date
,x_Bis_WM_Rec.Last_Updated_By
,x_Bis_WM_Rec.Last_Update_Login
FROM BIS_WEIGHTED_MEASURE_WEIGHTS
WHERE WEIGHT_ID = p_Bis_WM_Rec.weight_id;
PROCEDURE Update_WM_Weight(
p_commit IN VARCHAR2 --:= FND_API.G_FALSE
,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) IS
BEGIN
SAVEPOINT bis_Update_WM_Weight_PVT;
UPDATE BIS_WEIGHTED_MEASURE_WEIGHTS SET
WEIGHT_ID = p_Bis_WM_Rec.weight_id
,WEIGHTED_PARAMETER_ID = p_Bis_WM_Rec.weighted_parameter_id
,DEPENDENT_MEASURE_ID = p_Bis_WM_Rec.dependent_measure_id
,WEIGHT = p_Bis_WM_Rec.weight
,LAST_UPDATE_DATE = p_Bis_WM_Rec.Last_Update_Date
,LAST_UPDATED_BY = p_Bis_WM_Rec.Last_Updated_By
,LAST_UPDATE_LOGIN = p_Bis_WM_Rec.Last_Update_Login
WHERE WEIGHT_ID = p_Bis_WM_Rec.weight_id;
ROLLBACK TO bis_Update_WM_Weight_PVT;
ROLLBACK TO bis_Update_WM_Weight_PVT;
ROLLBACK TO bis_Update_WM_Weight_PVT;
x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PVT.Update_WM_Weight ';
x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PVT.Update_WM_Weight ';
END Update_WM_Weight;
PROCEDURE Delete_WM_Weight(
p_commit IN VARCHAR2 --:= FND_API.G_FALSE
,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) IS
BEGIN
SAVEPOINT Delete_WM_Weight_PVT;
DELETE BIS_WEIGHTED_MEASURE_WEIGHTS
WHERE WEIGHT_ID = p_Bis_WM_Rec.weight_id;
ROLLBACK TO Delete_WM_Weight_PVT;
ROLLBACK TO Delete_WM_Weight_PVT;
ROLLBACK TO Delete_WM_Weight_PVT;
x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PVT.Delete_WM_Weight ';
x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PVT.Delete_WM_Weight ';
END Delete_WM_Weight;
INSERT INTO BIS_WEIGHTED_MEASURE_SCORES(
WEIGHT_ID
,LOW_RANGE
,HIGH_RANGE
,SCORE
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
) VALUES (
p_Bis_WM_Rec.weight_id
,p_Bis_WM_Rec.low_range
,p_Bis_WM_Rec.high_range
,p_Bis_WM_Rec.score
,p_Bis_WM_Rec.Creation_Date
,p_Bis_WM_Rec.Created_By
,p_Bis_WM_Rec.Last_Update_Date
,p_Bis_WM_Rec.Last_Updated_By
,p_Bis_WM_Rec.Last_Update_Login
);
SELECT
WEIGHT_ID
,LOW_RANGE
,HIGH_RANGE
,SCORE
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
INTO
x_Bis_WM_Rec.weight_id
,x_Bis_WM_Rec.low_range
,x_Bis_WM_Rec.high_range
,x_Bis_WM_Rec.score
,x_Bis_WM_Rec.Creation_Date
,x_Bis_WM_Rec.Created_By
,x_Bis_WM_Rec.Last_Update_Date
,x_Bis_WM_Rec.Last_Updated_By
,x_Bis_WM_Rec.Last_Update_Login
FROM BIS_WEIGHTED_MEASURE_SCORES
WHERE WEIGHT_ID = p_Bis_WM_Rec.weight_id
AND LOW_RANGE = p_Bis_WM_Rec.low_range
AND HIGH_RANGE = p_Bis_WM_Rec.high_range;
PROCEDURE Update_WM_Score(
p_commit IN VARCHAR2 --:= FND_API.G_FALSE
,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) IS
BEGIN
SAVEPOINT bis_Update_WM_Score_PVT;
UPDATE BIS_WEIGHTED_MEASURE_SCORES SET
WEIGHT_ID = p_Bis_WM_Rec.weight_id
,LOW_RANGE = p_Bis_WM_Rec.low_range
,HIGH_RANGE = p_Bis_WM_Rec.high_range
,SCORE = p_Bis_WM_Rec.score
,LAST_UPDATE_DATE = p_Bis_WM_Rec.Last_Update_Date
,LAST_UPDATED_BY = p_Bis_WM_Rec.Last_Updated_By
,LAST_UPDATE_LOGIN = p_Bis_WM_Rec.Last_Update_Login
WHERE WEIGHT_ID = p_Bis_WM_Rec.weight_id
AND LOW_RANGE = p_Bis_WM_Rec.low_range
AND HIGH_RANGE = p_Bis_WM_Rec.high_range;
ROLLBACK TO bis_Update_WM_Score_PVT;
ROLLBACK TO bis_Update_WM_Score_PVT;
ROLLBACK TO bis_Update_WM_Score_PVT;
x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PVT.Update_WM_Score ';
x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PVT.Update_WM_Score ';
END Update_WM_Score;
PROCEDURE Delete_WM_Score(
p_commit IN VARCHAR2 --:= FND_API.G_FALSE
,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) IS
BEGIN
SAVEPOINT Delete_WM_Score_PVT;
DELETE BIS_WEIGHTED_MEASURE_SCORES
WHERE WEIGHT_ID = p_Bis_WM_Rec.weight_id;
DELETE BIS_WEIGHTED_MEASURE_SCORES
WHERE WEIGHT_ID = p_Bis_WM_Rec.weight_id
AND LOW_RANGE = p_Bis_WM_Rec.low_range
AND HIGH_RANGE = p_Bis_WM_Rec.high_range;
ROLLBACK TO Delete_WM_Score_PVT;
ROLLBACK TO Delete_WM_Score_PVT;
ROLLBACK TO Delete_WM_Score_PVT;
x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PVT.Delete_WM_Score ';
x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PVT.Delete_WM_Score ';
END Delete_WM_Score;
SELECT COUNT(INDICATOR_ID)
INTO l_count
FROM BIS_INDICATORS
WHERE INDICATOR_ID = measure_id;
PROCEDURE Update_WM_Last_Update_Info(
p_commit IN VARCHAR2 := FND_API.G_FALSE
,p_weighted_measure_id IN NUMBER
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) IS
l_user_id NUMBER;
SAVEPOINT Update_WM_Last_Update_Info;
UPDATE bis_indicators
SET
last_update_date = sysdate
,last_updated_by = l_user_id
,last_update_login = l_login_id
WHERE indicator_id = p_weighted_measure_id;
SELECT dataset_id
INTO l_dataset_id
FROM bis_indicators
WHERE indicator_id = p_weighted_measure_id;
UPDATE bsc_sys_datasets_b
SET
last_update_date = sysdate
,last_updated_by = l_user_id
,last_update_login = l_login_id
WHERE dataset_id = l_dataset_id;
ROLLBACK TO Update_WM_Last_Update_Info;
ROLLBACK TO Update_WM_Last_Update_Info;
ROLLBACK TO Update_WM_Last_Update_Info;
x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PVT.Update_WM_Last_Update_Info ';
x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PVT.Update_WM_Last_Update_Info ';
END Update_WM_Last_Update_Info;