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.BIS_WEIGHTED_MEASURE_PUB SQL Statements

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

Line: 21


 |  08-AUG-05 ashankar Bug#4517812 Modified the method Delete_WM_Dependency             |
 |  15-SEP-05 jxyu   Modified Set_Weights_Data API for bug#4427932                      |
 |  11-JAN-07 akoduri  Bug# 5594225: Performance issue in Mass Update UI                |
 +======================================================================================*/

-- Abbreviation Used"
--   WM -> Weighted Measure
--   SN -> Short Name

/************************************************************************************
--      API name        : Delete_Bulk_Weights_Scores
--      Type            : Private
--      Deletes the scores and weights data for given the parameter combinations
--      Restricts the criteria to one dependent measure if p_dependent_measure_id
--      is non - null value

--      Logic :
--         1. Fetch the weight ids corresponding to the p_Param_Ids
--         2. Delete the entries from weights and scores tables using the
--            entries in Step1
************************************************************************************/
PROCEDURE Delete_Bulk_Weights_Scores(
  p_commit         IN VARCHAR2 --:= FND_API.G_FALSE
 ,p_Param_Ids      IN FND_TABLE_OF_NUMBER
 ,p_dependent_measure_id  IN NUMBER := NULL
 ,x_return_status  OUT NOCOPY VARCHAR2
 ,x_msg_count      OUT NOCOPY NUMBER
 ,x_msg_data       OUT NOCOPY VARCHAR2
) IS
  l_Weight_Ids  FND_TABLE_OF_NUMBER;

Line: 52


  SAVEPOINT BisDeleteBulkWeightsScores;

Line: 57


       SELECT
         weights.weight_id
       BULK COLLECT INTO
         l_Weight_Ids
       FROM
         bis_weighted_measure_weights weights
       WHERE
         weights.weighted_parameter_id IN (SELECT column_value FROM TABLE(CAST(p_Param_Ids AS FND_TABLE_OF_NUMBER)));

Line: 66


       SELECT
         weights.weight_id
       BULK COLLECT INTO
         l_Weight_Ids
       FROM
         bis_weighted_measure_weights weights
       WHERE
         weights.weighted_parameter_id IN (SELECT column_value FROM TABLE(CAST(p_Param_Ids AS FND_TABLE_OF_NUMBER))) AND
         dependent_measure_id = p_dependent_measure_id;

Line: 78


      DELETE FROM
        bis_weighted_measure_scores
      WHERE
        weight_id = l_Weight_Ids(i);

Line: 84


      DELETE FROM
        bis_weighted_measure_weights
      WHERE
        weight_id = l_Weight_Ids(i);

Line: 96


        ROLLBACK TO BisDeleteBulkWeightsScores;

Line: 107


        ROLLBACK TO BisDeleteBulkWeightsScores;

Line: 118


        ROLLBACK TO BisDeleteBulkWeightsScores;

Line: 121


            x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_Bulk_Weights_Scores ';

Line: 123


            x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_Bulk_Weights_Scores ';

Line: 126


END Delete_Bulk_Weights_Scores;

Line: 144


PROCEDURE Delete_Cascade_WM_Parameters(
  p_commit                 IN VARCHAR2 --:= FND_API.G_FALSE
 ,p_weighted_definition_id IN NUMBER
 ,x_return_status          OUT NOCOPY VARCHAR2
 ,x_msg_count              OUT NOCOPY NUMBER
 ,x_msg_data                OUT NOCOPY VARCHAR2
) IS
  l_Param_Ids   FND_TABLE_OF_NUMBER;

Line: 154


   SAVEPOINT BisDeleteCascadeWMParameters;

Line: 157


  SELECT
    params.weighted_parameter_id
  BULK COLLECT INTO
    l_Param_Ids
  FROM
    bis_weighted_measure_params params
  WHERE
    params.weighted_definition_id = p_weighted_definition_id;

Line: 167


    SELECT
      weights.weight_id
    BULK COLLECT INTO
      l_Weight_Ids
    FROM
      bis_weighted_measure_weights weights
    WHERE
      weights.weighted_parameter_id IN (SELECT column_value FROM TABLE(CAST(l_Param_Ids AS FND_TABLE_OF_NUMBER)));

Line: 176


    Delete_Bulk_Weights_Scores (
       p_commit         => FND_API.G_FALSE
      ,p_Param_Ids      => l_Param_Ids
      ,x_return_status  => x_return_status
      ,x_msg_count      => x_msg_count
      ,x_msg_data       => x_msg_data
    );

Line: 188


      DELETE FROM
        bis_weighted_measure_params
      WHERE
        weighted_parameter_id = l_Param_Ids(i);

Line: 201


        ROLLBACK TO BisDeleteCascadeWMParameters;

Line: 213


        ROLLBACK TO BisDeleteCascadeWMParameters;

Line: 225


        ROLLBACK TO BisDeleteCascadeWMParameters;

Line: 228


            x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_Cascade_WM_Parameters ';

Line: 230


            x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_Cascade_WM_Parameters ';

Line: 234


END Delete_Cascade_WM_Parameters;

Line: 302


  l_Bis_WM_Rec.Last_Update_Date := sysdate;

Line: 303


  l_Bis_WM_Rec.Last_Updated_By := FND_GLOBAL.USER_ID;

Line: 304


  IF l_Bis_WM_Rec.Last_Update_Login IS NULL THEN
    l_Bis_WM_Rec.Last_Update_Login := 0;

Line: 421


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
 l_Bis_WM_Rec      BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

Line: 431


    SAVEPOINT bis_Update_WM_Dependency_pub;

Line: 449


  BIS_WEIGHTED_MEASURE_PVT.Update_WM_Dependency(
     p_commit         => p_commit
    ,p_Bis_WM_Rec     => l_Bis_WM_Rec
    ,x_Bis_WM_Rec     => x_Bis_WM_Rec
    ,x_return_status  => x_return_status
    ,x_msg_count      => x_msg_count
    ,x_msg_data       => x_msg_data
  );

Line: 460


        ROLLBACK TO bis_Update_WM_Dependency_pub;

Line: 472


        ROLLBACK TO bis_Update_WM_Dependency_pub;

Line: 484


        ROLLBACK TO bis_Update_WM_Dependency_pub;

Line: 487


            x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Update_WM_Dependency ';

Line: 489


            x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Update_WM_Dependency ';

Line: 493


END Update_WM_Dependency;

Line: 497


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
 l_Bis_WM_Rec      BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

Line: 509


 SELECT V.name
 FROM   bis_display_measures_v V,
        bis_indicators         B
 WHERE  B.short_name =V.short_name
 AND    B.indicator_id = p_Bis_WM_Rec.dependent_measure_id;

Line: 516


   SAVEPOINT Delete_WM_Dependency_pub;

Line: 539


  BIS_WEIGHTED_MEASURE_PVT.Delete_WM_Dependency(
     p_commit         => p_commit
    ,p_Bis_WM_Rec     => p_Bis_WM_Rec
    ,x_Bis_WM_Rec     => x_Bis_WM_Rec
    ,x_return_status  => x_return_status
    ,x_msg_count      => x_msg_count
    ,x_msg_data       => x_msg_data
  );

Line: 554


        ROLLBACK TO Delete_WM_Dependency_pub;

Line: 570


        ROLLBACK TO Delete_WM_Dependency_pub;

Line: 586


        ROLLBACK TO Delete_WM_Dependency_pub;

Line: 589


            x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Dependency ';

Line: 591


            x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Dependency ';

Line: 595


END Delete_WM_Dependency;

Line: 633


  SELECT BIS_WEIGHTED_MEASURE_DEFNS_S.NEXTVAL
  INTO l_Bis_WM_Rec.weighted_definition_id
  FROM DUAL;

Line: 641


  l_Bis_WM_Rec.Last_Update_Date := sysdate;

Line: 642


  l_Bis_WM_Rec.Last_Updated_By := FND_GLOBAL.USER_ID;

Line: 643


  IF l_Bis_WM_Rec.Last_Update_Login IS NULL THEN
    l_Bis_WM_Rec.Last_Update_Login := 0;

Line: 772


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
 l_Bis_WM_Rec      BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

Line: 781


 l_cascade_delete_flag boolean ;

Line: 784


  SAVEPOINT bis_Update_WM_Definition_pub;

Line: 786


  l_cascade_delete_flag := FALSE;

Line: 820


    l_cascade_delete_flag := TRUE;

Line: 826


    l_cascade_delete_flag := TRUE;

Line: 832


    l_cascade_delete_flag := TRUE;

Line: 838


    l_cascade_delete_flag := TRUE;

Line: 844


  l_Bis_WM_Rec.Last_Update_Date := sysdate;

Line: 845


  l_Bis_WM_Rec.Last_Updated_By := FND_GLOBAL.USER_ID;

Line: 848


 IF l_cascade_delete_flag = TRUE THEN
    Delete_Cascade_WM_Parameters(
      p_commit                 => p_commit
     ,p_weighted_definition_id => l_Bis_WM_Rec.weighted_definition_id
     ,x_return_status          => x_return_status
     ,x_msg_count              => x_msg_count
     ,x_msg_data               => x_msg_data
    );

Line: 859


 BIS_WEIGHTED_MEASURE_PVT.Update_WM_Definition(
     p_commit         => p_commit
    ,p_Bis_WM_Rec     => l_Bis_WM_Rec
    ,x_Bis_WM_Rec     => x_Bis_WM_Rec
    ,x_return_status  => x_return_status
    ,x_msg_count      => x_msg_count
    ,x_msg_data       => x_msg_data
 );

Line: 868


 IF l_cascade_delete_flag = TRUE THEN
-- Create tbe Default Parameter Again
     l_Bis_WM_Rec.time_level_value_id := BIS_WEIGHTED_MEASURE_PUB.DEFAULT_TIME_LEVEL_VALUE;

Line: 884


        ROLLBACK TO bis_Update_WM_Definition_pub;

Line: 896


        ROLLBACK TO bis_Update_WM_Definition_pub;

Line: 908


        ROLLBACK TO bis_Update_WM_Definition_pub;

Line: 911


            x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Update_WM_Definition ';

Line: 913


            x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Update_WM_Definition ';

Line: 917


END Update_WM_Definition;

Line: 921


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
 l_Bis_WM_Rec      BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

Line: 932


   SAVEPOINT Delete_WM_Definition_pub;

Line: 936


    Delete_Cascade_WM_Parameters(
      p_commit                 => p_commit
     ,p_weighted_definition_id => p_Bis_WM_Rec.weighted_definition_id
     ,x_return_status          => x_return_status
     ,x_msg_count              => x_msg_count
     ,x_msg_data               => x_msg_data
    );

Line: 945


  BIS_WEIGHTED_MEASURE_PVT.Delete_WM_Definition(
     p_commit         => p_commit
    ,p_Bis_WM_Rec     => p_Bis_WM_Rec
    ,x_Bis_WM_Rec     => x_Bis_WM_Rec
    ,x_return_status  => x_return_status
    ,x_msg_count      => x_msg_count
    ,x_msg_data       => x_msg_data
  );

Line: 956


        ROLLBACK TO Delete_WM_Definition_pub;

Line: 968


        ROLLBACK TO Delete_WM_Definition_pub;

Line: 980


        ROLLBACK TO Delete_WM_Definition_pub;

Line: 983


            x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Definition ';

Line: 985


            x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Definition ';

Line: 989


END Delete_WM_Definition;

Line: 1015


  SELECT COUNT(1)
  INTO l_count
  FROM BIS_WEIGHTED_MEASURE_DEFNS
  WHERE WEIGHTED_DEFINITION_ID = p_Bis_WM_Rec.weighted_definition_id;

Line: 1028


    SELECT BIS_WEIGHTED_MEASURE_PARAMS_S.NEXTVAL
    INTO l_Bis_WM_Rec.weighted_parameter_id
    FROM DUAL;

Line: 1036


  l_Bis_WM_Rec.Last_Update_Date := sysdate;

Line: 1037


  l_Bis_WM_Rec.Last_Updated_By := FND_GLOBAL.USER_ID;

Line: 1038


  IF l_Bis_WM_Rec.Last_Update_Login IS NULL THEN
    l_Bis_WM_Rec.Last_Update_Login := 0;

Line: 1150


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
 l_Bis_WM_Rec      BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

Line: 1160


    SAVEPOINT bis_Update_WM_Parameter_pub;

Line: 1180


  l_Bis_WM_Rec.Last_Update_Date := sysdate;

Line: 1181


  l_Bis_WM_Rec.Last_Updated_By := FND_GLOBAL.USER_ID;

Line: 1183


 BIS_WEIGHTED_MEASURE_PVT.Update_WM_Parameter(
     p_commit         => p_commit
    ,p_Bis_WM_Rec     => l_Bis_WM_Rec
    ,x_Bis_WM_Rec     => x_Bis_WM_Rec
    ,x_return_status  => x_return_status
    ,x_msg_count      => x_msg_count
    ,x_msg_data       => x_msg_data
  );

Line: 1194


        ROLLBACK TO bis_Update_WM_Parameter_pub;

Line: 1206


        ROLLBACK TO bis_Update_WM_Parameter_pub;

Line: 1218


        ROLLBACK TO bis_Update_WM_Parameter_pub;

Line: 1221


            x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Update_WM_Parameter ';

Line: 1223


            x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Update_WM_Parameter ';

Line: 1227


END Update_WM_Parameter;

Line: 1231


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

 l_Bis_WM_Rec      BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

Line: 1244


    SELECT WEIGHT_ID
    FROM BIS_WEIGHTED_MEASURE_WEIGHTS
    WHERE WEIGHTED_PARAMETER_ID = p_Bis_WM_Rec.weighted_parameter_id;

Line: 1248


  SAVEPOINT Delete_WM_Parameter_pub;

Line: 1254


     BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Weight(
       p_commit         => p_commit
      ,p_Bis_WM_Rec     => l_Bis_WM_Rec
      ,x_Bis_WM_Rec     => x_Bis_WM_Rec
      ,x_return_status  => x_return_status
      ,x_msg_count      => x_msg_count
      ,x_msg_data       => x_msg_data
    );

Line: 1265


  BIS_WEIGHTED_MEASURE_PVT.Delete_WM_Parameter(
     p_commit         => p_commit
    ,p_Bis_WM_Rec     => p_Bis_WM_Rec
    ,x_Bis_WM_Rec     => x_Bis_WM_Rec
    ,x_return_status  => x_return_status
    ,x_msg_count      => x_msg_count
    ,x_msg_data       => x_msg_data
  );

Line: 1276


        ROLLBACK TO Delete_WM_Parameter_pub;

Line: 1288


        ROLLBACK TO Delete_WM_Parameter_pub;

Line: 1300


        ROLLBACK TO Delete_WM_Parameter_pub;

Line: 1303


            x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Parameter ';

Line: 1305


            x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Parameter ';

Line: 1309


END Delete_WM_Parameter;

Line: 1336


  SELECT COUNT(1)
  INTO l_count
  FROM BIS_WEIGHTED_MEASURE_PARAMS
  WHERE WEIGHTED_PARAMETER_ID = p_Bis_WM_Rec.weighted_parameter_id;

Line: 1350


    SELECT BIS_WEIGHTED_MEASURE_WEIGHTS_S.NEXTVAL
    INTO l_Bis_WM_Rec.weight_id
    FROM DUAL;

Line: 1358


  l_Bis_WM_Rec.Last_Update_Date := sysdate;

Line: 1359


  l_Bis_WM_Rec.Last_Updated_By := FND_GLOBAL.USER_ID;

Line: 1360


  IF l_Bis_WM_Rec.Last_Update_Login IS NULL THEN
    l_Bis_WM_Rec.Last_Update_Login := 0;

Line: 1473


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
 l_Bis_WM_Rec      BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

Line: 1484


  SAVEPOINT bis_Update_WM_Weight_pub;

Line: 1497


/* it is not posible to update this to coluns are really primary key
IF p_Bis_WM_Rec.weighted_parameter_id IS NOT NULL THEN
 l_Bis_WM_Rec.weighted_parameter_id := p_Bis_WM_Rec.weighted_parameter_id;

Line: 1510


  l_Bis_WM_Rec.Last_Update_Date := sysdate;

Line: 1511


  l_Bis_WM_Rec.Last_Updated_By := FND_GLOBAL.USER_ID;

Line: 1513


  BIS_WEIGHTED_MEASURE_PVT.Update_WM_Weight(
     p_commit         => p_commit
    ,p_Bis_WM_Rec     => l_Bis_WM_Rec
    ,x_Bis_WM_Rec     => x_Bis_WM_Rec
    ,x_return_status  => x_return_status
    ,x_msg_count      => x_msg_count
    ,x_msg_data       => x_msg_data
  );

Line: 1524


        ROLLBACK TO bis_Update_WM_Weight_pub;

Line: 1536


        ROLLBACK TO bis_Update_WM_Weight_pub;

Line: 1548


        ROLLBACK TO bis_Update_WM_Weight_pub;

Line: 1551


            x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Update_WM_Weight ';

Line: 1553


            x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Update_WM_Weight ';

Line: 1557


END Update_WM_Weight;

Line: 1561


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
 l_Bis_WM_Rec      BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

Line: 1571


   SAVEPOINT Delete_WM_Weight_pub;

Line: 1579


  BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Score(
     p_commit         => p_commit
    ,p_Bis_WM_Rec     => l_Bis_WM_Rec
    ,x_Bis_WM_Rec     => x_Bis_WM_Rec
    ,x_return_status  => x_return_status
    ,x_msg_count      => x_msg_count
    ,x_msg_data       => x_msg_data
  );

Line: 1589


  BIS_WEIGHTED_MEASURE_PVT.Delete_WM_Weight(
     p_commit         => p_commit
    ,p_Bis_WM_Rec     => p_Bis_WM_Rec
    ,x_Bis_WM_Rec     => x_Bis_WM_Rec
    ,x_return_status  => x_return_status
    ,x_msg_count      => x_msg_count
    ,x_msg_data       => x_msg_data
  );

Line: 1601


        ROLLBACK TO Delete_WM_Weight_pub;

Line: 1613


        ROLLBACK TO Delete_WM_Weight_pub;

Line: 1625


        ROLLBACK TO Delete_WM_Weight_pub;

Line: 1628


            x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Weight ';

Line: 1630


            x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Weight ';

Line: 1634


END Delete_WM_Weight;

Line: 1654


  SELECT COUNT(1)
  INTO l_count
  FROM BIS_WEIGHTED_MEASURE_WEIGHTS
  WHERE WEIGHT_ID = p_Bis_WM_Rec.weight_id;

Line: 1668


  l_Bis_WM_Rec.Last_Update_Date := sysdate;

Line: 1669


  l_Bis_WM_Rec.Last_Updated_By := FND_GLOBAL.USER_ID;

Line: 1670


  IF l_Bis_WM_Rec.Last_Update_Login IS NULL THEN
    l_Bis_WM_Rec.Last_Update_Login := 0;

Line: 1783


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
 l_Bis_WM_Rec      BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

Line: 1793


    SAVEPOINT bis_Update_WM_Score_pub;

Line: 1818


 l_Bis_WM_Rec.Last_Update_Date := sysdate;

Line: 1819


 l_Bis_WM_Rec.Last_Updated_By := FND_GLOBAL.USER_ID;

Line: 1821


  BIS_WEIGHTED_MEASURE_PVT.Update_WM_Score(
     p_commit         => p_commit
    ,p_Bis_WM_Rec     => l_Bis_WM_Rec
    ,x_Bis_WM_Rec     => x_Bis_WM_Rec
    ,x_return_status  => x_return_status
    ,x_msg_count      => x_msg_count
    ,x_msg_data       => x_msg_data
  );

Line: 1833


        ROLLBACK TO bis_Update_WM_Score_pub;

Line: 1845


        ROLLBACK TO bis_Update_WM_Score_pub;

Line: 1857


        ROLLBACK TO bis_Update_WM_Score_pub;

Line: 1860


            x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Update_WM_Score ';

Line: 1862


            x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Update_WM_Score ';

Line: 1866


END Update_WM_Score;

Line: 1870


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
 l_Bis_WM_Rec      BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

Line: 1880


    SAVEPOINT Delete_WM_Score_pub;

Line: 1882


  BIS_WEIGHTED_MEASURE_PVT.Delete_WM_Score(
     p_commit         => p_commit
    ,p_Bis_WM_Rec     => p_Bis_WM_Rec
    ,x_Bis_WM_Rec     => x_Bis_WM_Rec
    ,x_return_status  => x_return_status
    ,x_msg_count      => x_msg_count
    ,x_msg_data       => x_msg_data
  );

Line: 1893


        ROLLBACK TO Delete_WM_Score_pub;

Line: 1905


        ROLLBACK TO Delete_WM_Score_pub;

Line: 1917


        ROLLBACK TO Delete_WM_Score_pub;

Line: 1920


            x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Score ';

Line: 1922


            x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Score ';

Line: 1926


    END Delete_WM_Score;

Line: 2077


PROCEDURE Update_WM_Definition(
 p_commit                      IN VARCHAR2 --:= FND_API.G_FALSE
 ,p_weighted_definition_id     IN NUMBER
 ,p_weighted_measure_id        IN NUMBER
 ,p_viewby_dimension_sn        IN VARCHAR2
 ,p_viewby_dim_level_sn        IN VARCHAR2
 ,p_filter_dimension_sn        IN VARCHAR2
 ,p_filter_dim_level_sn        IN VARCHAR2
 ,p_time_dimension_sn          IN VARCHAR2
 ,p_time_dim_level_sn          IN VARCHAR2
 ,x_return_status              OUT NOCOPY VARCHAR2
 ,x_msg_count                  OUT NOCOPY NUMBER
 ,x_msg_data                   OUT NOCOPY VARCHAR2

) IS
 l_Bis_WM_Rec      BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

Line: 2108


 BIS_WEIGHTED_MEASURE_PUB.Update_WM_Definition(
     p_commit         => p_commit
    ,p_Bis_WM_Rec     => l_Bis_WM_Rec
    ,x_Bis_WM_Rec     => x_Bis_WM_Rec
    ,x_return_status  => x_return_status
    ,x_msg_count      => x_msg_count
    ,x_msg_data       => x_msg_data
 );

Line: 2119


        ROLLBACK TO bis_Update_WM_Definition_pub;

Line: 2131


        ROLLBACK TO bis_Update_WM_Definition_pub;

Line: 2143


        ROLLBACK TO bis_Update_WM_Definition_pub;

Line: 2146


            x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Update_WM_Definition ';

Line: 2148


            x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Update_WM_Definition ';

Line: 2152


END Update_WM_Definition;

Line: 2156


PROCEDURE Delete_WM_Definition(
  p_commit                     IN VARCHAR2 --:= FND_API.G_FALSE
 ,p_weighted_definition_id     IN NUMBER
 ,x_return_status              OUT NOCOPY VARCHAR2
 ,x_msg_count                  OUT NOCOPY NUMBER
 ,x_msg_data                   OUT NOCOPY VARCHAR2
) IS
 l_Bis_WM_Rec      BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

Line: 2172


  BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Definition(
     p_commit         => p_commit
    ,p_Bis_WM_Rec     => l_Bis_WM_Rec
    ,x_Bis_WM_Rec     => x_Bis_WM_Rec
    ,x_return_status  => x_return_status
    ,x_msg_count      => x_msg_count
    ,x_msg_data       => x_msg_data
  );

Line: 2205


            x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Definition ';

Line: 2207


            x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Definition ';

Line: 2210


END Delete_WM_Definition;

Line: 2277


PROCEDURE Delete_WM_Dependency(
  p_commit                     IN VARCHAR2 --:= FND_API.G_FALSE
 ,p_weighted_measure_id        IN NUMBER
 ,p_dependent_measure_id       IN NUMBER
 ,x_return_status              OUT NOCOPY VARCHAR2
 ,x_msg_count                  OUT NOCOPY NUMBER
 ,x_msg_data                   OUT NOCOPY VARCHAR2
) IS
 l_Bis_WM_Rec      BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

Line: 2294


  BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Dependency(
     p_commit         => p_commit
    ,p_Bis_WM_Rec     => l_Bis_WM_Rec
    ,x_Bis_WM_Rec     => x_Bis_WM_Rec
    ,x_return_status  => x_return_status
    ,x_msg_count      => x_msg_count
    ,x_msg_data       => x_msg_data
  );

Line: 2327


            x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Dependency ';

Line: 2329


            x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Dependency ';

Line: 2332


END Delete_WM_Dependency;

Line: 2400


PROCEDURE Delete_WM_Parameter(
  p_commit                     IN VARCHAR2 --:= FND_API.G_FALSE
 ,p_weighted_parameter_id      IN NUMBER
 ,x_return_status              OUT NOCOPY VARCHAR2
 ,x_msg_count                  OUT NOCOPY NUMBER
 ,x_msg_data                   OUT NOCOPY VARCHAR2
) IS

 l_Bis_WM_Rec      BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

Line: 2417


  BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Parameter(
     p_commit         => p_commit
    ,p_Bis_WM_Rec     => l_Bis_WM_Rec
    ,x_Bis_WM_Rec     => x_Bis_WM_Rec
    ,x_return_status  => x_return_status
    ,x_msg_count      => x_msg_count
    ,x_msg_data       => x_msg_data
  );

Line: 2428


        ROLLBACK TO Delete_WM_Parameter_pub;

Line: 2440


        ROLLBACK TO Delete_WM_Parameter_pub;

Line: 2452


        ROLLBACK TO Delete_WM_Parameter_pub;

Line: 2455


            x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Parameter ';

Line: 2457


            x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Parameter ';

Line: 2461


END Delete_WM_Parameter;

Line: 2532


PROCEDURE Update_WM_Weight(
  p_commit                     IN VARCHAR2 --:= FND_API.G_FALSE
 ,p_weight_id                  IN NUMBER
 ,p_weight                     IN NUMBER
 ,x_return_status              OUT NOCOPY VARCHAR2
 ,x_msg_count                  OUT NOCOPY NUMBER
 ,x_msg_data                   OUT NOCOPY VARCHAR2
) IS
 l_Bis_WM_Rec      BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

Line: 2548


  BIS_WEIGHTED_MEASURE_PUB.Update_WM_Weight(
     p_commit         => p_commit
    ,p_Bis_WM_Rec     => l_Bis_WM_Rec
    ,x_Bis_WM_Rec     => x_Bis_WM_Rec
    ,x_return_status  => x_return_status
    ,x_msg_count      => x_msg_count
    ,x_msg_data       => x_msg_data
  );

Line: 2559


        ROLLBACK TO bis_Update_WM_Weight_pub;

Line: 2571


        ROLLBACK TO bis_Update_WM_Weight_pub;

Line: 2583


        ROLLBACK TO bis_Update_WM_Weight_pub;

Line: 2586


            x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Update_WM_Weight ';

Line: 2588


            x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Update_WM_Weight ';

Line: 2592


END Update_WM_Weight;

Line: 2596


PROCEDURE Delete_WM_Weight(
  p_commit                     IN VARCHAR2 --:= FND_API.G_FALSE
 ,p_weight_id                  IN NUMBER
 ,x_return_status              OUT NOCOPY VARCHAR2
 ,x_msg_count                  OUT NOCOPY NUMBER
 ,x_msg_data                   OUT NOCOPY VARCHAR2
) IS
 l_Bis_WM_Rec      BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

Line: 2606


   SAVEPOINT Delete_WM_Weight_pub;

Line: 2611


  BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Weight(
     p_commit         => p_commit
    ,p_Bis_WM_Rec     => l_Bis_WM_Rec
    ,x_Bis_WM_Rec     => x_Bis_WM_Rec
    ,x_return_status  => x_return_status
    ,x_msg_count      => x_msg_count
    ,x_msg_data       => x_msg_data
  );

Line: 2644


            x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Weight ';

Line: 2646


            x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Weight ';

Line: 2649


END Delete_WM_Weight;

Line: 2714


PROCEDURE Delete_WM_Score(
  p_commit                     IN VARCHAR2 --:= FND_API.G_FALSE
 ,p_weight_id                  IN NUMBER
 ,x_return_status              OUT NOCOPY VARCHAR2
 ,x_msg_count                  OUT NOCOPY NUMBER
 ,x_msg_data                   OUT NOCOPY VARCHAR2
) IS
 l_Bis_WM_Rec      BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

Line: 2728


  BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Score(
     p_commit         => p_commit
    ,p_Bis_WM_Rec     => l_Bis_WM_Rec
    ,x_Bis_WM_Rec     => x_Bis_WM_Rec
    ,x_return_status  => x_return_status
    ,x_msg_count      => x_msg_count
    ,x_msg_data       => x_msg_data
  );

Line: 2761


            x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Score ';

Line: 2763


            x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Score ';

Line: 2766


    END Delete_WM_Score;

Line: 2793


    SELECT COUNT(C.WEIGHT_ID) C1
    FROM BIS_WEIGHTED_MEASURE_DEFNS A
         ,BIS_WEIGHTED_MEASURE_PARAMS B
         ,BIS_WEIGHTED_MEASURE_WEIGHTS C
    WHERE A.weighted_measure_id = p_weighted_measure_id
      AND A.weighted_definition_id = B.weighted_definition_id
      AND B.weighted_parameter_id = C.weighted_parameter_id
      AND C.DEPENDENT_MEASURE_ID = p_dependent_measure_Id
      AND C.WEIGHT <> 0 ;

Line: 2805


    SELECT COUNT(WEIGHT_ID) C1
    FROM BIS_WEIGHTED_MEASURE_DEFNS A
         ,BIS_WEIGHTED_MEASURE_PARAMS B
         ,BIS_WEIGHTED_MEASURE_WEIGHTS C
    WHERE A.weighted_measure_id = p_weighted_measure_id
      AND A.weighted_definition_id = B.weighted_definition_id
      AND B.weighted_parameter_id = C.weighted_parameter_id
      AND C.DEPENDENT_MEASURE_ID = p_dependent_measure_Id
      AND C.WEIGHT = 0 ;

Line: 2817


    SELECT COUNT(WEIGHT_ID) C1
    FROM BIS_WEIGHTED_MEASURE_DEFNS A
         ,BIS_WEIGHTED_MEASURE_PARAMS B
         ,BIS_WEIGHTED_MEASURE_WEIGHTS C
    WHERE A.weighted_measure_id = p_weighted_measure_id
      AND A.weighted_definition_id = B.weighted_definition_id
      AND B.weighted_parameter_id = C.weighted_parameter_id
      AND C.WEIGHT <> 0 ;

Line: 2828


    SELECT COUNT(WEIGHT_ID) C1
    FROM BIS_WEIGHTED_MEASURE_DEFNS A
         ,BIS_WEIGHTED_MEASURE_PARAMS B
         ,BIS_WEIGHTED_MEASURE_WEIGHTS C
    WHERE A.weighted_measure_id = p_weighted_measure_id
      AND A.weighted_definition_id = B.weighted_definition_id
      AND B.weighted_parameter_id = C.weighted_parameter_id
      AND C.WEIGHT = 0 ;

Line: 2893


PROCEDURE Delete_Weighted_Measure_data(
  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_Bis_WM_Rec      BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

Line: 2905


    SELECT WEIGHTED_DEFINITION_ID
    FROM BIS_WEIGHTED_MEASURE_DEFNS
    WHERE WEIGHTED_MEASURE_ID = p_weighted_measure_id;

Line: 2911


    SELECT DEPENDENT_MEASURE_ID
    FROM BIS_WEIGHTED_MEASURE_DEPENDS
    WHERE WEIGHTED_MEASURE_ID = p_weighted_measure_id;

Line: 2922


     BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Dependency(
       p_commit         => FND_API.G_FALSE
      ,p_Bis_WM_Rec     => l_Bis_WM_Rec
      ,x_Bis_WM_Rec     => x_Bis_WM_Rec
      ,x_return_status  => x_return_status
      ,x_msg_count      => x_msg_count
      ,x_msg_data       => x_msg_data
    );

Line: 2936


     BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Definition(
       p_commit         => FND_API.G_FALSE
      ,p_Bis_WM_Rec     => l_Bis_WM_Rec
      ,x_Bis_WM_Rec     => x_Bis_WM_Rec
      ,x_return_status  => x_return_status
      ,x_msg_count      => x_msg_count
      ,x_msg_data       => x_msg_data
    );

Line: 2952


        ROLLBACK TO Delete_WM_Definition_pub;

Line: 2964


        ROLLBACK TO Delete_WM_Definition_pub;

Line: 2976


        ROLLBACK TO Delete_WM_Definition_pub;

Line: 2979


            x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_Weighted_Measure_data ';

Line: 2981


            x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_Weighted_Measure_data ';

Line: 2985


END Delete_Weighted_Measure_data;

Line: 3018


 SELECT COUNT(1)
   INTO l_count
 FROM BIS_WEIGHTED_MEASURE_DEFNS
 WHERE WEIGHTED_MEASURE_ID = p_weighted_measure_id;

Line: 3084


  Update_Weighted_Measure_data(
      p_commit                       => p_commit
     ,p_weighted_measure_id          => p_weighted_measure_id
     ,p_dependent_measure_ids        => p_dependent_measure_ids
     ,p_viewby_dimension_short_name  => p_viewby_dimension_short_name
     ,p_viewby_dim_level_short_name  => p_viewby_dim_level_short_name
     ,p_filter_dimension_short_name  => p_filter_dimension_short_name
     ,p_filter_dim_level_short_name  => p_filter_dim_level_short_name
     ,p_time_dimension_short_name    => p_time_dimension_short_name
     ,p_time_dim_level_short_names   => p_time_dim_level_short_names
     ,x_return_status  => x_return_status
     ,x_msg_count      => x_msg_count
     ,x_msg_data       => x_msg_data
  );

Line: 3173


  l_Insert_Param_Ids  FND_TABLE_OF_NUMBER;

Line: 3174


  l_Update_Param_Ids  FND_TABLE_OF_NUMBER;

Line: 3185


  SELECT COUNT(WEIGHTED_MEASURE_ID)
   INTO l_count
   FROM BIS_WEIGHTED_MEASURE_DEPENDS
   WHERE WEIGHTED_MEASURE_ID = p_weighted_measure_id
    AND DEPENDENT_MEASURE_ID = p_dependent_measure_id;

Line: 3203


  SELECT
    defns.weighted_definition_id
  BULK COLLECT INTO
    l_Definition_Ids
  FROM
    bis_weighted_measure_defns defns
  WHERE
    defns.weighted_measure_id = p_weighted_measure_id;

Line: 3213


    SELECT
      params.weighted_parameter_id
    BULK COLLECT INTO
      l_Param_Ids
    FROM
      bis_weighted_measure_params params
    WHERE
      params.weighted_definition_id in (SELECT column_value FROM TABLE(CAST(l_Definition_Ids AS FND_TABLE_OF_NUMBER)));

Line: 3223


      SELECT
        column_value
      BULK COLLECT INTO
        l_Insert_Param_Ids
      FROM
        (SELECT column_value FROM TABLE(CAST(l_Param_Ids AS FND_TABLE_OF_NUMBER))
        MINUS
        SELECT
          weights.weighted_parameter_id
        FROM
          bis_weighted_measure_weights weights
        WHERE
          weights.weighted_parameter_id IN (SELECT column_value FROM TABLE(CAST(l_Param_Ids AS FND_TABLE_OF_NUMBER))) AND
          weights.dependent_measure_id = p_dependent_measure_id);

Line: 3238


       SELECT
         weights.weighted_parameter_id
       BULK COLLECT INTO
         l_Update_Param_Ids
       FROM
         bis_weighted_measure_weights weights
       WHERE
         weights.weighted_parameter_id IN (SELECT column_value FROM TABLE(CAST(l_Param_Ids AS FND_TABLE_OF_NUMBER))) AND
         weights.dependent_measure_id = p_dependent_measure_id;

Line: 3248


       IF l_Update_Param_Ids.COUNT > 0 THEN
         IF p_Weight IS NOT NULL THEN
           FORALL i in 1..l_Update_Param_Ids.COUNT
             UPDATE bis_weighted_measure_weights SET
               weight = p_weight
               ,last_update_date = SYSDATE
	       ,last_updated_by = l_User_Id
               ,last_update_login = l_Login_Id
             WHERE
               weighted_parameter_id = l_Update_Param_Ids(i) AND
               dependent_measure_id = p_dependent_measure_id;

Line: 3260


            Delete_Bulk_Weights_Scores (
               p_commit         => FND_API.G_FALSE
              ,p_Param_Ids      => l_Update_Param_Ids
              ,p_dependent_measure_id => p_dependent_measure_id
              ,x_return_status  => x_return_status
              ,x_msg_count      => x_msg_count
              ,x_msg_data       => x_msg_data
            );

Line: 3274


       IF p_Weight IS NOT NULL AND l_Insert_Param_Ids.COUNT > 0  THEN
         FORALL i in 1..l_Insert_Param_Ids.COUNT
           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 (
	     bis_weighted_measure_weights_s.nextval
	    ,l_Insert_Param_Ids(i)
	    ,p_dependent_measure_id
	    ,p_weight
	    ,SYSDATE
	    ,l_User_Id
	    ,SYSDATE
	    ,l_User_Id
	    ,l_Login_Id
           );

Line: 3375


    BIS_WEIGHTED_MEASURE_PUB.Update_WM_Last_Update_Info(
       p_commit         => p_commit
      ,p_Weighted_Measure_Id     => p_weighted_measure_id
      ,x_return_status  => x_return_status
      ,x_msg_count      => x_msg_count
      ,x_msg_data       => x_msg_data
    );

Line: 3411


    SELECT attribute7
    FROM bis_indicators wkpi, bis_indicators dkpi, ak_region_items_vl r
    WHERE wkpi.indicator_id = p_wkpi_id
    AND dkpi.indicator_id = p_dep_kpi_id
    AND BSC_BIS_MEASURE_PUB.Get_Primary_Data_Source(p_wkpi_id) = r.region_code
    AND dkpi.short_name = r.attribute2
    AND r.attribute1 IN ('MEASURE', 'MEASURE_NOTARGET');

Line: 3440


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
BEGIN
    SAVEPOINT Update_WM_LU_Info_pub;

Line: 3452


    BIS_WEIGHTED_MEASURE_PVT.Update_WM_Last_Update_Info(
       p_commit         => p_commit
      ,p_weighted_measure_id     => p_weighted_measure_id
      ,x_return_status  => x_return_status
      ,x_msg_count      => x_msg_count
      ,x_msg_data       => x_msg_data
    );

Line: 3462


        ROLLBACK TO Update_WM_LU_Info_pub;

Line: 3474


        ROLLBACK TO Update_WM_LU_Info_pub;

Line: 3486


        ROLLBACK TO Update_WM_LU_Info_pub;

Line: 3489


            x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Update_WM_Last_Update_Info ';

Line: 3491


            x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Update_WM_Last_Update_Info ';

Line: 3495


END Update_WM_Last_Update_Info;

Line: 3508


PROCEDURE Delete_Mass_Update_Data(
  p_commit                 IN VARCHAR2 := FND_API.G_FALSE
 ,p_weighted_definition_id IN NUMBER
 ,p_dependent_measure_id   IN NUMBER
 ,p_Selected_Period_Ids    IN BIS_TABLE_OF_VARCHAR
 ,p_Selected_DimObj_Ids    IN BIS_TABLE_OF_VARCHAR
 ,x_return_status          OUT NOCOPY VARCHAR2
 ,x_msg_count              OUT NOCOPY NUMBER
 ,x_msg_data               OUT NOCOPY VARCHAR2
)
IS
  l_Param_Ids     FND_TABLE_OF_NUMBER;

Line: 3523


  SAVEPOINT Bis_Delete_Mass_Update_Data;

Line: 3525


  SELECT
    params.weighted_parameter_id
  BULK COLLECT INTO
    l_Param_Ids
  FROM
    bis_weighted_measure_params params,
    (SELECT
       a.column_value filter_level_value_id,
       b.column_value time_level_value_id
     FROM
       (SELECT column_value FROM TABLE(CAST(p_Selected_DimObj_Ids AS BIS_TABLE_OF_VARCHAR))) A,
       (SELECT column_value FROM TABLE(CAST(p_Selected_Period_Ids AS BIS_TABLE_OF_VARCHAR))) B) curParams
  WHERE
    params.weighted_definition_id = p_weighted_definition_id AND
    params.time_level_value_id    <>  'DEFAULT' AND
    params.filter_level_value_id  <> 'DEFAULT' AND
    params.time_level_value_id    = curParams.time_level_value_id AND
    params.filter_level_value_id  = curParams.filter_level_value_id;

Line: 3545


    SELECT
      weights.weight_id
    BULK COLLECT INTO
      l_Weight_Ids
    FROM
      bis_weighted_measure_weights weights
    WHERE
      weights.dependent_measure_id = p_dependent_measure_id AND
      weights.weighted_parameter_id IN (SELECT column_value FROM TABLE(CAST(l_Param_Ids AS FND_TABLE_OF_NUMBER)));

Line: 3556


      Delete_Bulk_Weights_Scores (
         p_commit         => FND_API.G_FALSE
        ,p_Param_Ids      => l_Param_Ids
        ,p_dependent_measure_id  => p_dependent_measure_id
        ,x_return_status  => x_return_status
        ,x_msg_count      => x_msg_count
        ,x_msg_data       => x_msg_data
      );

Line: 3576


    ROLLBACK TO Bis_Delete_Mass_Update_Data;

Line: 3579


        x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_Mass_Update_Data ';

Line: 3581


        x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_Mass_Update_Data ';

Line: 3583


END Delete_Mass_Update_Data;

Line: 3602


PROCEDURE Insert_Mass_Update_Data(
  p_commit                 IN VARCHAR2 := FND_API.G_FALSE
 ,p_weighted_measure_id    IN NUMBER
 ,p_weighted_definition_id IN NUMBER
 ,p_dependent_measure_id   IN NUMBER
 ,p_Time_Level             IN VARCHAR2
 ,p_Filter_Level           IN VARCHAR2
 ,p_Selected_Period_Ids    IN BIS_TABLE_OF_VARCHAR
 ,p_Selected_DimObj_Ids    IN BIS_TABLE_OF_VARCHAR
 ,p_Score_Values           IN FND_TABLE_OF_NUMBER
 ,p_Lower_Ranges           IN FND_TABLE_OF_NUMBER
 ,p_Upper_Ranges           IN FND_TABLE_OF_NUMBER
 ,x_return_status          OUT NOCOPY VARCHAR2
 ,x_msg_count              OUT NOCOPY NUMBER
 ,x_msg_data               OUT NOCOPY VARCHAR2
)
IS
  l_Create_Time_Values   BIS_TABLE_OF_VARCHAR;

Line: 3626


  l_Is_Update            BOOLEAN;

Line: 3633


  SAVEPOINT SAVE_Insert_Mass_Update_Data;

Line: 3642


  SELECT
    *
  BULK COLLECT INTO
    l_Create_Filter_Values,
    l_Create_Time_Values
  FROM
    ( SELECT
        a.column_value filter_level_value_id,
        b.column_value time_level_value_id
      FROM
        (SELECT column_value FROM TABLE(CAST(p_Selected_DimObj_Ids AS BIS_TABLE_OF_VARCHAR))) A,
        (SELECT column_value FROM TABLE(CAST(p_Selected_Period_Ids AS BIS_TABLE_OF_VARCHAR))) B
      MINUS
      SELECT
        params.filter_level_value_id ,
        params.time_level_value_id
      FROM
        bis_weighted_measure_params params
      WHERE
        params.weighted_definition_id = p_weighted_definition_id AND
        params.time_level_value_id    <>  'DEFAULT' AND
        params.filter_level_value_id  <> 'DEFAULT') insertedParams;

Line: 3667


   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 (
      bis_weighted_measure_params_s.nextval
     ,p_weighted_definition_id
     ,l_Create_Time_Values(i)
     ,l_Create_Filter_Values(i)
     ,SYSDATE
     ,l_User_Id
     ,SYSDATE
     ,l_User_Id
     ,l_Login_Id
   );

Line: 3689


  SELECT
    params.weighted_parameter_id
  BULK COLLECT INTO
    l_Param_Ids
  FROM
    bis_weighted_measure_params params,
    (SELECT
       a.column_value filter_level_value_id,
       b.column_value time_level_value_id
     FROM
       (SELECT column_value FROM TABLE(CAST(p_Selected_DimObj_Ids AS BIS_TABLE_OF_VARCHAR))) A,
       (SELECT column_value FROM TABLE(CAST(p_Selected_Period_Ids AS BIS_TABLE_OF_VARCHAR))) B) curParams
  WHERE
    params.weighted_definition_id = p_weighted_definition_id  AND
    params.time_level_value_id <>  'DEFAULT' AND
    params.filter_level_value_id <> 'DEFAULT' AND
    params.time_level_value_id    = curParams.time_level_value_id AND
    params.filter_level_value_id  = curParams.filter_level_value_id;

Line: 3708


  SELECT
    w.weight
  INTO
    l_Default_Weight
  FROM
    bis_weighted_measure_params p,
    bis_weighted_measure_weights w
  WHERE
    p.weighted_parameter_id = w.weighted_parameter_id AND
    p.time_level_value_id = 'DEFAULT' AND
    p.filter_level_value_id = 'DEFAULT' AND
    p.weighted_definition_id = p_weighted_definition_id AND
    w.dependent_measure_id = p_dependent_measure_id;

Line: 3724


    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 (
      bis_weighted_measure_weights_s.nextval
      , l_Param_Ids(i)
      , p_dependent_measure_id
      , l_Default_Weight
      , SYSDATE
      , l_User_Id
      , SYSDATE
      , l_User_Id
      , l_Login_Id
    );

Line: 3746


  SELECT
    weights.weight_id
  BULK COLLECT INTO
    l_Weight_Ids
  FROM
    bis_weighted_measure_weights weights
  WHERE
    weights.weighted_parameter_id IN (SELECT column_value FROM TABLE(CAST(l_Param_Ids AS FND_TABLE_OF_NUMBER))) AND
    weights.dependent_measure_id = p_dependent_measure_id;

Line: 3760


        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 (
           l_Weight_Ids(j)
          ,p_Lower_Ranges(i)
          ,p_Upper_Ranges(i)
          ,p_Score_Values(i)
          ,SYSDATE
          ,l_User_Id
          ,SYSDATE
          ,l_User_Id
          ,l_Login_Id
        );

Line: 3790


    ROLLBACK TO SAVE_Insert_Mass_Update_Data;

Line: 3793


        x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Insert_Mass_Update_Data ';

Line: 3795


        x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Insert_Mass_Update_Data';

Line: 3797


END Insert_Mass_Update_Data;

Line: 3810


PROCEDURE Save_Mass_Update_Values(
  p_commit                 IN VARCHAR2
 ,p_weighted_measure_id    IN NUMBER
 ,p_dependent_measure_id   IN NUMBER
 ,p_Time_Level             IN VARCHAR2
 ,p_Filter_Level           IN VARCHAR2
 ,p_Selected_Period_Ids    IN BIS_TABLE_OF_VARCHAR
 ,p_Selected_DimObj_Ids    IN BIS_TABLE_OF_VARCHAR
 ,p_Score_Values           IN FND_TABLE_OF_NUMBER
 ,p_Lower_Ranges           IN FND_TABLE_OF_NUMBER
 ,p_Upper_Ranges           IN FND_TABLE_OF_NUMBER
 ,x_return_status          OUT NOCOPY VARCHAR2
 ,x_msg_count              OUT NOCOPY NUMBER
 ,x_msg_data               OUT NOCOPY VARCHAR2
)
IS
  l_Weighted_Definition_Id bis_weighted_measure_params.weighted_definition_id%type;

Line: 3829


  SAVEPOINT BisSave_Mass_Update_Values_Pub;

Line: 3832


  SELECT
    defns.weighted_definition_id
  INTO
    l_Weighted_Definition_Id
  FROM
    bis_weighted_measure_defns defns
  WHERE
    defns.weighted_measure_id = p_weighted_measure_id AND
    defns.time_dimension_short_name || '+' || defns.time_dim_level_short_name = p_Time_Level;

Line: 3842


  Delete_Mass_Update_Data(
      p_commit                 =>  FND_API.G_FALSE
    , p_weighted_definition_id =>  l_Weighted_Definition_Id
    , p_dependent_measure_id   =>  p_dependent_measure_id
    , p_Selected_Period_Ids    =>  p_Selected_Period_Ids
    , p_Selected_DimObj_Ids    =>  p_Selected_DimObj_Ids
    , x_return_status          =>  x_return_status
    , x_msg_count              =>  x_msg_count
    , x_msg_data               =>  x_msg_data
  );

Line: 3856


  Insert_Mass_Update_Data (
      p_commit                 =>  FND_API.G_FALSE
    , p_weighted_measure_id    =>  p_weighted_measure_id
    , p_dependent_measure_id   =>  p_dependent_measure_id
    , p_weighted_definition_id =>  l_Weighted_Definition_Id
    , p_Time_Level             =>  p_Time_Level
    , p_Filter_Level           =>  p_Filter_Level
    , p_Selected_Period_Ids    =>  p_Selected_Period_Ids
    , p_Selected_DimObj_Ids    =>  p_Selected_DimObj_Ids
    , p_Score_Values           =>  p_Score_Values
    , p_Lower_Ranges           =>  p_Lower_Ranges
    , p_Upper_Ranges           =>  p_Upper_Ranges
    , x_return_status          =>  x_return_status
    , x_msg_count              =>  x_msg_count
    , x_msg_data               =>  x_msg_data
  );

Line: 3882


      ROLLBACK TO BisSave_Mass_Update_Values_Pub;

Line: 3892


      ROLLBACK TO BisSave_Mass_Update_Values_Pub;

Line: 3895


          x_msg_data      :=  x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Save_Mass_Update_Values ';

Line: 3897


          x_msg_data      :=  SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Save_Mass_Update_Values ';

Line: 3899


END Save_Mass_Update_Values;

Line: 3915


 ,p_Selected_Period_Ids    IN BIS_TABLE_OF_VARCHAR
 ,p_Selected_DimObj_Ids    IN BIS_TABLE_OF_VARCHAR
 ,x_Param_Count            OUT NOCOPY NUMBER
) IS

  l_Param_Ids FND_TABLE_OF_NUMBER;

Line: 3923


  SELECT
    params.weighted_parameter_id
  BULK COLLECT INTO
    l_Param_Ids
  FROM
    bis_weighted_measure_params params,
    bis_weighted_measure_defns  defns,
    (SELECT
       a.column_value filter_level_value_id,
       b.column_value time_level_value_id
     FROM
       (SELECT column_value FROM TABLE(CAST(p_Selected_DimObj_Ids AS BIS_TABLE_OF_VARCHAR))) A,
       (SELECT column_value FROM TABLE(CAST(p_Selected_Period_Ids AS BIS_TABLE_OF_VARCHAR))) B) curParams
  WHERE
    defns.weighted_measure_id = p_weighted_measure_id AND
    params.weighted_definition_id = defns.weighted_definition_id  AND
    params.time_level_value_id <>  'DEFAULT' AND
    params.filter_level_value_id <> 'DEFAULT' AND
    params.time_level_value_id    = curParams.time_level_value_id AND
    params.filter_level_value_id  = curParams.filter_level_value_id;

Line: 3945


   SELECT
     COUNT(1)
   INTO
     x_Param_Count
   FROM
     bis_weighted_measure_scores a,
     bis_weighted_measure_weights b
   WHERE
     a.weight_id = b.weight_id AND
     b.weighted_parameter_id in (SELECT column_value FROM TABLE(CAST(l_Param_Ids AS FND_TABLE_OF_NUMBER))) AND
     b.dependent_measure_id = p_dependent_measure_id;