DBA Data[Home] [Help]

APPS.BSC_ANALYSIS_OPTION_PUB SQL Statements

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

Line: 34

 |         03-jan-2006 rpenneru bug#4899020 comparison source is not updated properly   |
 |                       while Rearrange_Data_Series                                    |
 |         05-jan-2006 rpenneru bug#4683354 Modified to reset datasource both for BSC   |
 |                     and PMF type measures                                            |
 |         22-may-2006 akoduri bug#5104402 data source is getting updated wrongly for   |
 |                      PMF type measures                                               |
 |         12-Sep-2006 akoduri  Bug#5526265 Issues iwth actual_data_source and          |
 |                     function name updation                                           |
 |         11-OCT-2006 akoduri  Bug #5554168 Issue with Measures having different short |
 |                     names in bis_indicators & bsc_sys_measures                       |
 |         31-Jan-2007 akoduri  Enh #5679096 Migration of multibar functionality from   |
 |                               VB to Html                                             |
+======================================================================================+
*/

G_PKG_NAME              CONSTANT        varchar2(30) := 'BSC_ANALYSIS_OPTION_PVT';
Line: 68

    SELECT  indicator
    FROM    BSC_KPIS_B
    WHERE   Source_Indicator  =  l_Anal_Opt_Rec.Bsc_Kpi_Id
    AND     Prototype_Flag   <>  2;
Line: 136

    select share_flag
      into l_share_flag
      from BSC_KPIS_B
     where indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id;
Line: 150

    select max(option_id) + 1
      into l_Anal_Opt_Rec.Bsc_Analysis_Option_Id
      from BSC_KPI_ANALYSIS_OPTIONS_B
     where indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
       and analysis_group_id = l_Anal_Opt_Rec.Bsc_Analysis_Group_Id;
Line: 167

    select name
      into l_Anal_Opt_Rec.Bsc_Measure_Long_Name
      from BSC_SYS_DATASETS_TL
     where dataset_id = l_Anal_Opt_Rec.Bsc_Dataset_Id
       and language = USERENV('LANG');
Line: 392

procedure Update_Analysis_Options
(       p_commit              IN            varchar2 -- :=  FND_API.G_FALSE
    ,   p_Anal_Opt_Rec        IN            BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
    ,   p_data_Source         IN            VARCHAR2
    ,   x_return_status       OUT NOCOPY    VARCHAR2
    ,   x_msg_count           OUT NOCOPY    NUMBER
    ,   x_msg_data            OUT NOCOPY    VARCHAR2
) IS
    l_Anal_Opt_Rec      BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
Line: 405

    SELECT  indicator
    FROM    BSC_KPIS_B
    WHERE   Source_Indicator  =  p_Anal_Opt_Rec.Bsc_Kpi_Id
    AND     Prototype_Flag   <>  2;
Line: 414

  BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Options( p_commit
                                                  ,p_Anal_Opt_Rec
                                                  ,p_data_source
                                                  ,x_return_status
                                                  ,x_msg_count
                                                  ,x_msg_data);
Line: 421

  Update_Analysis_Measures( p_commit
                           ,p_Anal_Opt_Rec
                           ,x_return_status
                           ,x_msg_count
                           ,x_msg_data);
Line: 432

        BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Options( p_commit
                                                        ,l_Anal_Opt_Rec
                                                        ,p_data_source
                                                        ,x_return_status
                                                        ,x_msg_count
                                                        ,x_msg_data);
Line: 439

        Update_Analysis_Measures( p_commit
                                 ,l_Anal_Opt_Rec
                                 ,x_return_status
                                 ,x_msg_count
                                 ,x_msg_data);
Line: 472

            x_msg_data      :=  x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';
Line: 474

            x_msg_data      :=  SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';
Line: 480

            x_msg_data      :=  x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';
Line: 482

            x_msg_data      :=  SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';
Line: 485

end Update_Analysis_Options;
Line: 490

procedure Update_Analysis_Options(
  p_commit              IN      varchar2 -- :=  FND_API.G_FALSE
 ,p_Anal_Opt_Rec        IN      BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) is
begin
  x_return_status := FND_API.G_RET_STS_SUCCESS;
Line: 499

  Update_Analysis_Options(
    p_commit              =>  p_commit
   ,p_Anal_Opt_Rec        =>  p_Anal_Opt_Rec
   ,p_data_Source         =>  NULL
   ,x_return_status       =>  x_return_status
   ,x_msg_count           =>  x_msg_count
   ,x_msg_data            =>  x_msg_data
  );
Line: 537

            x_msg_data      :=  x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';
Line: 539

            x_msg_data      :=  SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';
Line: 545

            x_msg_data      :=  x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';
Line: 547

            x_msg_data      :=  SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';
Line: 550

end Update_Analysis_Options;
Line: 556

procedure Delete_Analysis_Options(
  p_commit              IN      varchar2 -- :=  FND_API.G_FALSE
 ,p_Anal_Opt_Rec        IN      BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) is

begin
  x_return_status := FND_API.G_RET_STS_SUCCESS;
Line: 566

  BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Options( p_commit
                                                  ,p_Anal_Opt_Rec
                                                  ,x_return_status
                                                  ,x_msg_count
                                                  ,x_msg_data);
Line: 596

            x_msg_data      :=  x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Options ';
Line: 598

            x_msg_data      :=  SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Options ';
Line: 604

            x_msg_data      :=  x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Options ';
Line: 606

            x_msg_data      :=  SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Options ';
Line: 609

end Delete_Analysis_Options;
Line: 635

  SELECT BSC_KPI_MEASURE_S.nextval
  INTO   l_Kpi_Measure_Id
  FROM   SYS.DUAL;
Line: 812

procedure Update_Analysis_Measures(
  p_commit              IN      varchar2 -- :=  FND_API.G_FALSE
 ,p_Anal_Opt_Rec        IN      BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) is

l_Anal_Opt_Rec          BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
Line: 830

        , p_Api_Mode      => BSC_ANALYSIS_OPTION_PVT.C_API_UPDATE
        , p_Kpi_Id        => l_Anal_Opt_Rec.Bsc_Kpi_Id
        , p_Option0       => NVL(l_Anal_Opt_Rec.Bsc_Option_Group0, 0)
        , p_Option1       => NVL(l_Anal_Opt_Rec.Bsc_Option_Group1, 0)
        , p_Option2       => NVL(l_Anal_Opt_Rec.Bsc_Option_Group2, 0)
        , p_Series_Id     => NVL(l_Anal_Opt_Rec.Bsc_Dataset_Series_Id, 0)
        , p_Default_Value => NVL(l_Anal_Opt_Rec.Bsc_Dataset_Default_Value, 0)
        , x_Default_Value => l_Default_Value
        , x_Return_Status => x_Return_Status
        , x_Msg_Count     => x_Msg_Count
        , x_Msg_Data      => x_Msg_Data
    );
Line: 846

    BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Measures( p_commit
                                                     ,l_Anal_Opt_Rec
                                                     ,x_return_status
                                                     ,x_msg_count
                                                     ,x_msg_data);
Line: 875

            x_msg_data      :=  x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Measures ';
Line: 877

            x_msg_data      :=  SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Measures ';
Line: 883

            x_msg_data      :=  x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Measures ';
Line: 885

            x_msg_data      :=  SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Measures ';
Line: 888

end Update_Analysis_Measures;
Line: 905

  SELECT
    kpi_measure_id
  FROM
    bsc_kpi_measure_props
  WHERE
    indicator = p_Anal_Opt_Rec.Bsc_Kpi_id
  MINUS
  SELECT
    kpi_measure_id
  FROM
    bsc_kpi_analysis_measures_b
  WHERE
    indicator = p_Anal_Opt_Rec.Bsc_Kpi_id;
Line: 921

    BSC_KPI_MEASURE_PROPS_PUB.Delete_Kpi_Measure_Props (
       p_commit          =>   FND_API.G_FALSE
      ,p_objective_id    =>   p_Anal_Opt_Rec.Bsc_Kpi_Id
      ,p_kpi_measure_id  =>   cd.kpi_measure_id
      ,p_cascade_shared  =>   FALSE
      ,x_return_status   =>   x_return_status
      ,x_msg_count       =>   x_msg_count
      ,x_msg_data        =>   x_Msg_Data
    );
Line: 934

    BSC_COLOR_RANGES_PUB.Delete_Color_Prop_Ranges (
       p_commit          =>   FND_API.G_FALSE
      ,p_objective_id    =>   p_Anal_Opt_Rec.Bsc_Kpi_Id
      ,p_kpi_measure_id  =>   cd.kpi_measure_id
      ,p_cascade_shared  =>   FALSE
      ,x_return_status   =>   x_return_status
      ,x_msg_count       =>   x_msg_count
      ,x_msg_data        =>   x_Msg_Data
    );
Line: 960

    DELETE FROM bsc_sys_kpi_colors
    WHERE indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id AND
    kpi_measure_id = cd.kpi_measure_id;
Line: 984

procedure Delete_Analysis_Measures(
  p_commit              IN      varchar2 -- :=  FND_API.G_FALSE
 ,p_Anal_Opt_Rec        IN      BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) is
begin

    x_return_status := FND_API.G_RET_STS_SUCCESS;
Line: 996

   BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Measures( p_commit
                                                     ,p_Anal_Opt_Rec
                                                     ,x_return_status
                                                     ,x_msg_count
                                                     ,x_msg_data);
Line: 1042

            x_msg_data      :=  x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Measures ';
Line: 1044

            x_msg_data      :=  SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Measures ';
Line: 1050

            x_msg_data      :=  x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Measures ';
Line: 1052

            x_msg_data      :=  SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Measures ';
Line: 1055

end Delete_Analysis_Measures;
Line: 1059

PROCEDURE Delete_Ana_Opt_Mult_Groups
(       p_commit              IN            VARCHAR2:=FND_API.G_FALSE
    ,   p_Kpi_id              IN            BSC_KPIS_B.indicator%TYPE
    ,   p_Anal_Opt_Tbl        IN            BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
    ,   p_max_group_count     IN            NUMBER
    ,   p_Anal_Opt_Comb_Tbl   IN            BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
    ,   p_Anal_Opt_Rec        IN            BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
    ,   x_return_status       OUT NOCOPY    VARCHAR2
    ,   x_msg_count           OUT NOCOPY    NUMBER
    ,   x_msg_data            OUT NOCOPY    VARCHAR2
)IS
BEGIN
    x_return_status := FND_API.G_RET_STS_SUCCESS;
Line: 1072

   BSC_ANALYSIS_OPTION_PVT.Delete_Ana_Opt_Mult_Groups
   (       p_commit              =>  FND_API.G_FALSE
       ,   p_Kpi_id              =>  p_Kpi_id
       ,   p_Anal_Opt_Tbl        =>  p_Anal_Opt_Tbl
       ,   p_max_group_count     =>  p_max_group_count
       ,   p_Anal_Opt_Comb_Tbl   =>  p_Anal_Opt_Comb_Tbl
       ,   p_Anal_Opt_Rec        =>  p_Anal_Opt_Rec
       ,   x_return_status       =>  x_return_status
       ,   x_msg_count           =>  x_msg_count
       ,   x_msg_data            =>  x_msg_data
 );
Line: 1107

          x_msg_data      :=  x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
Line: 1109

          x_msg_data      :=  SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
Line: 1115

           x_msg_data      :=  x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
Line: 1117

           x_msg_data      :=  SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
Line: 1120

END Delete_Ana_Opt_Mult_Groups;
Line: 1219

        SELECT OBJ.NAME OBJ_NAME,
               OBJ.SHORT_NAME SHORT_NAME,
               DS.NAME KPI_NAME
        FROM   BSC_KPIS_VL OBJ,
               BSC_KPI_ANALYSIS_MEASURES_VL DS
        WHERE  DS.INDICATOR        = p_kpi_id
        AND    DS.ANALYSIS_OPTION0 = p_option0
        AND    DS.ANALYSIS_OPTION1 = p_option1
        AND    DS.ANALYSIS_OPTION2 = p_option2
        AND    DS.SERIES_ID        = p_series_id
        AND    OBJ.INDICATOR       = DS.INDICATOR;
Line: 1244

             FND_MESSAGE.SET_NAME('BSC','BSC_D_DELETE_RPT_KPI_OBJ');
Line: 1286

          x_msg_data      :=  x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
Line: 1288

          x_msg_data      :=  SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
Line: 1294

           x_msg_data      :=  x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
Line: 1296

           x_msg_data      :=  SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
Line: 1303

PROCEDURE delete_extra_series(
      p_Bsc_Anal_Opt_Rec    IN  BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
    , x_return_status       OUT NOCOPY    VARCHAR2
    , x_msg_count           OUT NOCOPY    NUMBER
    , x_msg_data            OUT NOCOPY    VARCHAR2
) IS
BEGIN
    x_return_status := FND_API.G_RET_STS_SUCCESS;
Line: 1313

    BSC_ANALYSIS_OPTION_PVT.delete_extra_series(
          p_Bsc_Anal_Opt_Rec    => p_Bsc_Anal_Opt_Rec
        , x_return_status       => x_return_status
        , x_msg_count           => x_msg_count
        , x_msg_data            => x_msg_data
    );
Line: 1348

          x_msg_data      :=  x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
Line: 1350

          x_msg_data      :=  SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
Line: 1356

           x_msg_data      :=  x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
Line: 1358

           x_msg_data      :=  SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
Line: 1361

END delete_extra_series;
Line: 1383

    SELECT  indicator
    FROM    BSC_KPIS_B
    WHERE   Source_Indicator  =  l_Anal_Opt_Rec.Bsc_Kpi_Id
    AND     Prototype_Flag   <>  2;
Line: 1389

    SELECT SERIES_COLOR, BM_COLOR
    FROM BSC_SYS_SERIES_COLORS
    WHERE SERIES_ID =  l_series_id;
Line: 1395

      SELECT SERIES_ID
      INTO l_count
      FROM BSC_KPI_ANALYSIS_MEASURES_B
      WHERE indicator           = l_Anal_Opt_Rec.Bsc_Kpi_Id
           AND analysis_option0 = l_Anal_Opt_Rec.Bsc_Option_Group0
           AND analysis_option1 = l_Anal_Opt_Rec.Bsc_Option_Group1
           AND analysis_option2 = l_Anal_Opt_Rec.Bsc_Option_Group2
           AND dataset_id = -1
     ORDER BY SERIES_ID DESC;
Line: 1415

     SELECT COUNT(0)
     INTO   l_count
     FROM   BSC_KPIS_B
     WHERE INDICATOR = p_Anal_Opt_Rec.Bsc_Kpi_Id;
Line: 1433

  select share_flag
      into l_share_flag
      from BSC_KPIS_B
     where indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id;
Line: 1471

         Delete_Data_Series(
                  p_commit            =>  p_commit
                  ,p_Anal_Opt_Rec     =>  l_Anal_Opt_Rec
                  ,x_return_status    =>  x_return_status
                  ,x_msg_count        =>  x_msg_count
                  ,x_msg_data         =>  x_msg_data
          );
Line: 1484

      SELECT COUNT (SERIES_ID)
      INTO l_count
      FROM BSC_KPI_ANALYSIS_MEASURES_B
      WHERE indicator        = l_Anal_Opt_Rec.Bsc_Kpi_Id
           AND analysis_option0 = l_Anal_Opt_Rec.Bsc_Option_Group0
           AND analysis_option1 = l_Anal_Opt_Rec.Bsc_Option_Group1
           AND analysis_option2 = l_Anal_Opt_Rec.Bsc_Option_Group2;
Line: 1492

          SELECT MAX(SERIES_ID) + 1
          into l_Anal_Opt_Rec.Bsc_Dataset_Series_Id
          from BSC_KPI_ANALYSIS_MEASURES_B
          WHERE indicator        = l_Anal_Opt_Rec.Bsc_Kpi_Id
               AND analysis_option0 = l_Anal_Opt_Rec.Bsc_Option_Group0
               AND analysis_option1 = l_Anal_Opt_Rec.Bsc_Option_Group1
               AND analysis_option2 = l_Anal_Opt_Rec.Bsc_Option_Group2;
Line: 1532

     SELECT MAX(SERIES_ID)
       INTO l_max_series_id
       FROM BSC_SYS_SERIES_COLORS;
Line: 1556

      select name
      into l_Anal_Opt_Rec.Bsc_Measure_Long_Name
      from BSC_SYS_DATASETS_VL
      where dataset_id = l_Anal_Opt_Rec.Bsc_Dataset_Id;
Line: 1652

procedure Update_Data_Series
(       p_commit              IN            VARCHAR2 -- FND_API.G_FALSE
    ,   p_Anal_Opt_Rec        IN            BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
    ,   x_return_status       OUT NOCOPY    VARCHAR2
    ,   x_msg_count           OUT NOCOPY    NUMBER
    ,   x_msg_data            OUT NOCOPY    VARCHAR2
) IS
    l_Anal_Opt_Rec      BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
Line: 1665

    SELECT  indicator
    FROM    BSC_KPIS_B
    WHERE   Source_Indicator  =  p_Anal_Opt_Rec.Bsc_Kpi_Id
    AND     Prototype_Flag   <>  2;
Line: 1675

     SELECT COUNT(0)
     INTO   l_count
     FROM   BSC_KPIS_B
     WHERE INDICATOR = p_Anal_Opt_Rec.Bsc_Kpi_Id;
Line: 1693

  select share_flag
      into l_share_flag
      from BSC_KPIS_B
     where indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id;
Line: 1720

  BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Measures( FND_API.G_FALSE
                           ,l_Anal_Opt_Rec
                           ,x_return_status
                           ,x_msg_count
                           ,x_msg_data);
Line: 1732

        BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Measures( FND_API.G_FALSE
                                 ,l_Anal_Opt_Rec
                                 ,x_return_status
                                 ,x_msg_count
                                 ,x_msg_data);
Line: 1770

            x_msg_data      :=  x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Data_Series ';
Line: 1772

            x_msg_data      :=  SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Data_Series ';
Line: 1778

            x_msg_data      :=  x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Data_Series ';
Line: 1780

            x_msg_data      :=  SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Data_Series ';
Line: 1783

end Update_Data_Series;
Line: 1785

procedure Delete_Data_Series(
  p_commit              IN      varchar2 -- :=  FND_API.G_FALSE
 ,p_Anal_Opt_Rec        IN      BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) is

l_Num_Series NUMBER;
Line: 1801

    SELECT  indicator
    FROM    BSC_KPIS_B
    WHERE   Source_Indicator  =  l_Anal_Opt_Rec.Bsc_Kpi_Id
    AND     Prototype_Flag   <>  2;
Line: 1809

    SAVEPOINT DeleteBSCDataSeriesPUB;
Line: 1816

     SELECT COUNT(0)
     INTO   l_count
     FROM   BSC_KPIS_B
     WHERE INDICATOR = p_Anal_Opt_Rec.Bsc_Kpi_Id;
Line: 1834

  select share_flag
      into l_share_flag
      from BSC_KPIS_B
     where indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id;
Line: 1858

    SELECT COUNT(SERIES_ID)
    INTO  l_Num_Series
    FROM BSC_KPI_ANALYSIS_MEASURES_B
    WHERE indicator        = p_Anal_Opt_Rec.Bsc_Kpi_Id
           AND analysis_option0 = p_Anal_Opt_Rec.Bsc_Option_Group0
           AND analysis_option1 = p_Anal_Opt_Rec.Bsc_Option_Group1
           AND analysis_option2 = p_Anal_Opt_Rec.Bsc_Option_Group2;
Line: 1867

     BSC_ANALYSIS_OPTION_PVT.delete_Data_Series(
             p_commit               => FND_API.G_FALSE
             ,p_Anal_Opt_Rec        => l_Anal_Opt_Rec
             ,x_return_status       => x_return_status
             ,x_msg_count           => x_msg_count
             ,x_msg_data            => x_msg_data
     );
Line: 1892

          BSC_ANALYSIS_OPTION_PVT.delete_Data_Series(
             p_commit               => FND_API.G_FALSE
             ,p_Anal_Opt_Rec        => l_Anal_Opt_Rec
             ,x_return_status       => x_return_status
             ,x_msg_count           => x_msg_count
             ,x_msg_data            => x_msg_data
         );
Line: 1923

      SELECT COUNT(SERIES_ID)
      INTO  l_Num_Series
      FROM BSC_KPI_ANALYSIS_MEASURES_B
      WHERE indicator        = p_Anal_Opt_Rec.Bsc_Kpi_Id
           AND analysis_option0 = p_Anal_Opt_Rec.Bsc_Option_Group0
           AND analysis_option1 = p_Anal_Opt_Rec.Bsc_Option_Group1
           AND analysis_option2 = p_Anal_Opt_Rec.Bsc_Option_Group2;
Line: 1957

        ROLLBACK TO DeleteBSCDataSeriesPUB;
Line: 1967

        ROLLBACK TO DeleteBSCDataSeriesPUB;
Line: 1977

        ROLLBACK TO DeleteBSCDataSeriesPUB;
Line: 1980

            x_msg_data      :=  x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Data_Series ';
Line: 1982

            x_msg_data      :=  SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Data_Series ';
Line: 1987

End Delete_Data_Series;
Line: 2036

    SELECT  indicator
    FROM    BSC_KPIS_B
    WHERE   Source_Indicator  =  l_Anal_Opt_Rec.Bsc_Kpi_Id
    AND     Prototype_Flag   <>  2;
Line: 2156

  SELECT
    i.dataset_id
  FROM
    bis_indicators i
  WHERE
    i.short_name = l_short_name;
Line: 2165

    SELECT SERIES_ID, DATASET_ID
    FROM BSC_KPI_ANALYSIS_MEASURES_B
    WHERE indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
           AND ANALYSIS_OPTION0 = l_Anal_Opt_Rec.Bsc_Option_Group0
           AND ANALYSIS_OPTION1 = l_Anal_Opt_Rec.Bsc_Option_Group1
           AND ANALYSIS_OPTION2 = l_Anal_Opt_Rec.Bsc_Option_Group2
           AND DATASET_ID =  l_Anal_Opt_Rec.Bsc_Dataset_Id;
Line: 2175

    SELECT SERIES_ID, DATASET_ID
    FROM BSC_KPI_ANALYSIS_MEASURES_B
    WHERE indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
           AND ANALYSIS_OPTION0 = l_Anal_Opt_Rec.Bsc_Option_Group0
           AND ANALYSIS_OPTION1 = l_Anal_Opt_Rec.Bsc_Option_Group1
           AND ANALYSIS_OPTION2 = l_Anal_Opt_Rec.Bsc_Option_Group2
           AND SERIES_ID >=  l_count
    ORDER BY SERIES_ID DESC;
Line: 2260

              Delete_Data_Series(
                 p_commit              =>  p_commit
                 ,p_Anal_Opt_Rec        =>  l_Anal_Opt_Rec
                 ,x_return_status       =>  x_return_status
                 ,x_msg_count           =>  x_msg_count
                 ,x_msg_data            =>  x_msg_data
              );
Line: 2330

   SELECT num_of_options
   INTO   l_count
   FROM   BSC_KPI_ANALYSIS_GROUPS
   WHERE  indicator =p_obj_id
   AND    analysis_group_id = p_anal_grp_Id;
Line: 2365

     SELECT COUNT(0)
     INTO   l_max_group_count
     FROM   bsc_kpi_analysis_groups
     WHERE  indicator = p_obj_id;
Line: 2532

              with the one selected by the user.If it has changed then it return
              True otherwise it returns false.
 Input      : p_Anal_Num_Tbl  --> New analysis option combination table.
              p_Old_Anal_Num_Tbl --> Old Analysis option combination table.
 Output     : True --> means changed.
              False --> means not changed.
 Created BY : ashankar For bug 4220400
/**********************************************************/
FUNCTION Default_Anal_Option_Changed
(
   p_Anal_Num_Tbl           IN   BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
 , p_Old_Anal_Num_Tbl       IN   BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
)RETURN BOOLEAN IS
  l_return     BOOLEAN;