DBA Data[Home] [Help]

APPS.BIS_WEIGHTED_MEASURE_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 22

 |       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;
Line: 45

   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
   );
Line: 119

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;
Line: 180

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;
Line: 192

   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;
Line: 206

        ROLLBACK TO bis_Update_WM_Dependency_PVT;
Line: 218

        ROLLBACK TO bis_Update_WM_Dependency_PVT;
Line: 230

        ROLLBACK TO bis_Update_WM_Dependency_PVT;
Line: 233

            x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PVT.Update_WM_Dependency ';
Line: 235

            x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PVT.Update_WM_Dependency ';
Line: 239

END Update_WM_Dependency;
Line: 243

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;
Line: 255

     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;
Line: 267

        ROLLBACK TO Delete_WM_Dependency_PVT;
Line: 279

        ROLLBACK TO Delete_WM_Dependency_PVT;
Line: 291

        ROLLBACK TO Delete_WM_Dependency_PVT;
Line: 294

            x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PVT.Delete_WM_Dependency ';
Line: 296

            x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PVT.Delete_WM_Dependency ';
Line: 300

END Delete_WM_Dependency;
Line: 319

   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
   );
Line: 405

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;
Line: 484

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;
Line: 496

   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;
Line: 517

        ROLLBACK TO bis_Update_WM_Definition_PVT;
Line: 529

        ROLLBACK TO bis_Update_WM_Definition_PVT;
Line: 541

        ROLLBACK TO bis_Update_WM_Definition_PVT;
Line: 544

            x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PVT.Update_WM_Definition ';
Line: 546

            x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PVT.Update_WM_Definition ';
Line: 550

END Update_WM_Definition;
Line: 554

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;
Line: 566

   DELETE BIS_WEIGHTED_MEASURE_DEFNS
   WHERE WEIGHTED_DEFINITION_ID = p_Bis_WM_Rec.weighted_definition_id;
Line: 576

        ROLLBACK TO Delete_WM_Definition_PVT;
Line: 588

        ROLLBACK TO Delete_WM_Definition_PVT;
Line: 600

        ROLLBACK TO Delete_WM_Definition_PVT;
Line: 603

            x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PVT.Delete_WM_Definition ';
Line: 605

            x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PVT.Delete_WM_Definition ';
Line: 609

END Delete_WM_Definition;
Line: 628

   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
   );
Line: 706

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;
Line: 770

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;
Line: 782

   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;
Line: 802

        ROLLBACK TO bis_Update_WM_Parameter_PVT;
Line: 814

        ROLLBACK TO bis_Update_WM_Parameter_PVT;
Line: 826

        ROLLBACK TO bis_Update_WM_Parameter_PVT;
Line: 829

            x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PVT.Update_WM_Parameter ';
Line: 831

            x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PVT.Update_WM_Parameter ';
Line: 835

END Update_WM_Parameter;
Line: 839

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;
Line: 851

   DELETE  BIS_WEIGHTED_MEASURE_PARAMS
   WHERE WEIGHTED_PARAMETER_ID = p_Bis_WM_Rec.weighted_parameter_id;
Line: 861

        ROLLBACK TO Delete_WM_Parameter_PVT;
Line: 873

        ROLLBACK TO Delete_WM_Parameter_PVT;
Line: 885

        ROLLBACK TO Delete_WM_Parameter_PVT;
Line: 888

            x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PVT.Delete_WM_Parameter ';
Line: 890

            x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PVT.Delete_WM_Parameter ';
Line: 894

END Delete_WM_Parameter;
Line: 912

   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
   );
Line: 989

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;
Line: 1058

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;
Line: 1071

 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;
Line: 1088

        ROLLBACK TO bis_Update_WM_Weight_PVT;
Line: 1100

        ROLLBACK TO bis_Update_WM_Weight_PVT;
Line: 1112

        ROLLBACK TO bis_Update_WM_Weight_PVT;
Line: 1115

            x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PVT.Update_WM_Weight ';
Line: 1117

            x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PVT.Update_WM_Weight ';
Line: 1121

END Update_WM_Weight;
Line: 1125

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;
Line: 1137

  DELETE BIS_WEIGHTED_MEASURE_WEIGHTS
  WHERE WEIGHT_ID = p_Bis_WM_Rec.weight_id;
Line: 1147

        ROLLBACK TO Delete_WM_Weight_PVT;
Line: 1159

        ROLLBACK TO Delete_WM_Weight_PVT;
Line: 1171

        ROLLBACK TO Delete_WM_Weight_PVT;
Line: 1174

            x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PVT.Delete_WM_Weight ';
Line: 1176

            x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PVT.Delete_WM_Weight ';
Line: 1180

END Delete_WM_Weight;
Line: 1197

   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
   );
Line: 1274

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;
Line: 1348

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;
Line: 1360

   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;
Line: 1379

        ROLLBACK TO bis_Update_WM_Score_PVT;
Line: 1391

        ROLLBACK TO bis_Update_WM_Score_PVT;
Line: 1403

        ROLLBACK TO bis_Update_WM_Score_PVT;
Line: 1406

            x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PVT.Update_WM_Score ';
Line: 1408

            x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PVT.Update_WM_Score ';
Line: 1412

END Update_WM_Score;
Line: 1416

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;
Line: 1431

   DELETE BIS_WEIGHTED_MEASURE_SCORES
   WHERE WEIGHT_ID = p_Bis_WM_Rec.weight_id;
Line: 1435

   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;
Line: 1449

        ROLLBACK TO Delete_WM_Score_PVT;
Line: 1461

        ROLLBACK TO Delete_WM_Score_PVT;
Line: 1473

        ROLLBACK TO Delete_WM_Score_PVT;
Line: 1476

            x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PVT.Delete_WM_Score ';
Line: 1478

            x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PVT.Delete_WM_Score ';
Line: 1482

    END Delete_WM_Score;
Line: 1494

    SELECT COUNT(INDICATOR_ID)
    INTO l_count
    FROM BIS_INDICATORS
    WHERE INDICATOR_ID = measure_id;
Line: 1519

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;
Line: 1531

   SAVEPOINT Update_WM_Last_Update_Info;
Line: 1537

    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;
Line: 1544

    SELECT dataset_id
    INTO l_dataset_id
    FROM bis_indicators
    WHERE indicator_id = p_weighted_measure_id;
Line: 1549

    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;
Line: 1562

        ROLLBACK TO Update_WM_Last_Update_Info;
Line: 1574

        ROLLBACK TO Update_WM_Last_Update_Info;
Line: 1586

        ROLLBACK TO Update_WM_Last_Update_Info;
Line: 1589

            x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PVT.Update_WM_Last_Update_Info ';
Line: 1591

            x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PVT.Update_WM_Last_Update_Info ';
Line: 1595

END Update_WM_Last_Update_Info;