APPS.BSC_BIS_DIMENSION_PUB SQL Statements

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

Line: 22

REM | 22-JUL-2003 ADRAO    Bug #3034094  - Fixed in Update_Dimension        |
REM | 30-JUL-2003 PAJOHRI  Bug #3075316, 3073486                            |
REM | 09-SEP-2003 ASHANKAR Bug #3129610                                     |
REM | 13-SEP-2003 MAHRAO   Fix for bug# 3099977, added p_create_view flag   |
REM | 20-OCT-2003 PAJOHRI  Bug #3179995                                     |
REM | 20-OCT-2003 PAJOHRI  Bug #3179995                                     |
REM | 04-NOV-2003 PAJOHRI  Bug #3152258                                     |
REM | 04-NOV-2003 PAJOHRI  Bug #3220613                                     |
REM | 04-NOV-2003 PAJOHRI  Bug #3232366                                     |
REM | 04-NOV-2003 PAJOHRI  Bug #3269384                                     |
REM | 08-DEC-2003 KYADAMAK Bug #3225685                                     |
REM | 02-MAR-2004 ankgoel  Bug #3464470                                     |
REM | 30-MAR-2004 KYADAMAK BUG #3516466 Passing default appid as 271        |
REM | 12-APR-2004 PAJOHRI  Bug #3426566, modified the logic to use dimension|
REM |                      'UNASSIGNED' always if there if no Dimension/    |
REM |                      Dimension Object association for PMF and retain  |
REM |                      'All Enable' flag                                |
REM | 19-APR-2004 PAJOHRI  Bug #3541933, fix for filter buttons             |
REM | 23-APR-2004 ASHANKAR  Bug #3518610,Added the fucntion Validate        |
REM |                       listbutton                                      |
REM | 05-MAY-2004 PAJOHRI  Bug #3590436, fixed Sync_Dimensions_In_Bis       |
REM | 16-JUN-2004 PAJOHRI   Bug #3659486, to support 'All Enable' flag in   |
REM |                       Dimension/Dimension Object Association Page     |
REM | 09-AUG-2004 sawu      Used c_BSC_DIM constant in create_dimension     |
REM | 11-AUG-2004 sawu     Added create_dimension() for bug#3819855 with    |
REM |                      p_is_default_short_name                          |
REM | 17-AUG-2004 wleung   modified Bug#3784852 on Assign_Unassign_Dim_Objs |
REM | 08-SEP-2004 visuri   Added Dim_With_Single_Dim_Obj() and              |
REM |                      Is_Dim_Empty() for bug #3784852                  |
REM | 09-SEP-2004 visuri   Shifted Remove_Empty_Dims_For_DimSet() from      |
REM |                      BSC_BIS_KPI_MEAS_PUB  for bug #3784852           |
REM | 08-OCT-2004 rpenneru added Modified for bug#3939995                   |
REM | 27-OCT-2004 sawu     Bug#3947903: added Is_Objective_Assigned()       |
REM | 08-Feb-05   ankgoel  Enh#4172034 DD Seeding by Product Teams          |
REM | 02-Mar-05   ppandey  Bug#4211876 Prmary Dim provided for              |
REM |                      Update_Dimension_Level should not be accepte.    |
REM | 29-Mar-05   ankagarw bug# 4218260 Unable to save comparison source    |
REM |                      label lov value                                  |
REM | 31-MAR-05   adrao     Modified API check_sametype_dims to remove      |
REM |                       disctinction betweem BSC and BIS Dimesion Objs  |
REM | 11-APR-2005 kyadamak bug#4290070 Not recreating views for rolling dims|
REM | 06-JUN-2005 mdamle   Enh#4403547 Set default p_commit to false for    |
REM |                      dim. group apis called from EOs                  |
REM |  18-Jul-2005 ppandey  Enh #4417483, Restrict Internal/Calendar Dims   |
REM |  20-Jul-2005 ppandey  Bug #4495539, MIXED Dim Obj not allowed from DD |
REM |  11-AUG-2005 ppandey  Bug #4324947 Validation for Dim,Dim Obj in Rpt  |
REM |  06-Jan-2006 akoduri  Enh#4739401 - Hide Dimensions/Dim Objects       |
REM |  10-FEB-2006 akoduri  Bug#4997042 Cascade 'All' property from dim     |
REM |                       designer to dim groups of Reports               |
REM |  15-JUN-2006 ashankar Bug#5254737 Made changes to Create_Dimension    |
REM |                       Method.Removed the parameter value 'TRUE' in    |
REM |                       FND_MESSAGE.SET_TOKEN API                       |
REM |   27-Jun-07 ashankar  Bug#6134149 synching up the dim obj props to    |
REM |                       BSC_KPI_MEASURE_PROPS table                     |
REM |  02-AUG-07 psomesul  B#6168487-Handling dim. object comparison settings |
REM +=======================================================================+
*/
CONFIG_LIMIT_DIM              CONSTANT        NUMBER := 8;

Line: 180

    SELECT  Dimension_ID
    FROM    BIS_DIMENSIONS
    WHERE   Short_Name  = p_Short_Name;

Line: 209

    SELECT  Dim_Group_ID
    FROM    BSC_SYS_DIM_GROUPS_VL
    WHERE   Short_Name  = p_Short_Name;

Line: 239

SELECT COUNT(1) INTO l_Count
    FROM   BSC_KPI_DIM_GROUPS
    WHERE DIM_GROUP_ID= p_dim_group_id;

Line: 261

    SELECT  Name
    FROM    BSC_SYS_DIM_GROUPS_VL
    WHERE   Short_Name  = p_Short_Name;

Line: 290

    SELECT COUNT(1) INTO l_Count
    FROM   BSC_SYS_DIM_LEVELS_BY_GROUP
    WHERE  Dim_Level_Id = p_Dim_Level_Id
    AND    Dim_Group_Id = p_Dim_Grp_Id;

Line: 314

    SELECT  B.Short_Name
    FROM    BIS_LEVELS     A
         ,  BIS_DIMENSIONS B
    WHERE   A.Short_Name   = p_Dim_Obj_Short_Name
    AND     A.Dimension_Id = B.Dimension_Id;

Line: 321

    SELECT Total_Flag
    FROM   BSC_SYS_DIM_LEVELS_BY_GROUP
    WHERE  Dim_Level_Id =  l_Bsc_Dim_Obj_ID
    AND    Dim_Group_Id =  l_Bsc_Group_ID;

Line: 358

    SELECT COUNT(Dim_Group_ID) INTO l_Count
    FROM   BSC_SYS_DIM_LEVELS_BY_GROUP
    WHERE  Dim_Level_Id = p_Dim_Level_Id;

Line: 380

    SELECT  B.Short_Name
    FROM    BIS_LEVELS     A
         ,  BIS_DIMENSIONS B
    WHERE   A.Short_Name   = p_Dim_Obj_Short_Name
    AND     A.Dimension_Id = B.Dimension_Id;

Line: 387

    SELECT  Total_Flag
    FROM    BSC_SYS_DIM_LEVELS_BY_GROUP
    WHERE   Dim_Group_Id  =  l_Bsc_Group_ID
    AND     Dim_Level_Id  =  l_Bsc_Level_ID;

Line: 414

            UPDATE BSC_SYS_DIM_LEVELS_BY_GROUP
            SET    Total_Flag   =  l_Total_Flag
            WHERE  Dim_Level_Id =  l_Bsc_Level_ID;

Line: 460

    SELECT   B.Short_Name
    FROM     BIS_LEVELS       A
          ,  BIS_DIMENSIONS   B
    WHERE    A.Short_Name   = p_Dim_Obj_Short_Name
    AND      A.Dimension_Id = B.Dimension_Id;

Line: 467

    SELECT   Dim_Group_Id
    FROM     BSC_SYS_DIM_LEVELS_BY_GROUP
    WHERE    Dim_Level_Id  =  l_Bsc_Level_ID
    ORDER BY Dim_Level_Index DESC;

Line: 473

    SELECT   Short_Name
    FROM     BSC_SYS_DIM_GROUPS_VL
    WHERE    Dim_Group_Id = l_Bsc_Group_ID;

Line: 478

    SELECT   LEVEL_ID
           , SHORT_NAME
           , DIMENSION_ID
           , LEVEL_VALUES_VIEW_NAME
           , WHERE_CLAUSE
           , CREATION_DATE
           , CREATED_BY
           , LAST_UPDATE_DATE
           , LAST_UPDATED_BY
           , LAST_UPDATE_LOGIN
           , SOURCE
           , COMPARISON_LABEL_CODE
           , ATTRIBUTE_CODE
           , APPLICATION_ID
           , VIEW_OBJECT_NAME
           , DEFAULT_VALUES_API
           , DEFAULT_SEARCH
           , LONG_LOV
           , MASTER_LEVEL
           , ENABLED
           , DRILL_TO_FORM_FUNCTION
           , HIDE_IN_DESIGN
    FROM     BIS_LEVELS  A
    WHERE    A.Short_Name   = p_Dim_Obj_Short_Name;

Line: 579

        BIS_DIMENSION_LEVEL_PUB.Update_Dimension_Level
        (       p_api_version           =>  1.0
            ,   p_commit                =>  FND_API.G_FALSE
            ,   p_validation_level      =>  FND_API.G_VALID_LEVEL_FULL
            ,   p_Dimension_Level_Rec   =>  l_bis_dimension_level_rec
            ,   x_return_status         =>  x_return_status
            ,   x_error_Tbl             =>  l_error_tbl
        );

Line: 615

PROCEDURE Delete_Dim_Objs_In_DSet
(       p_MTab_Tbl              IN              BSC_BIS_DIMENSION_PUB.KPI_Dim_Set_Table_Type
    ,   x_return_status         OUT    NOCOPY   VARCHAR2
    ,   x_msg_count             OUT    NOCOPY   NUMBER
    ,   x_msg_data              OUT    NOCOPY   VARCHAR2
) IS
BEGIN
    FOR i IN 0..(p_MTab_Tbl.COUNT-1) LOOP
        BSC_BIS_KPI_MEAS_PUB.Delete_Dim_Objs_In_DSet
        (       p_commit             =>   FND_API.G_FALSE
            ,   p_kpi_id             =>   p_MTab_Tbl(i).p_kpi_id
            ,   p_dim_set_id         =>   p_MTab_Tbl(i).p_dim_set_id
            ,   x_return_status      =>   x_return_status
            ,   x_msg_count          =>   x_msg_count
            ,   x_msg_data           =>   x_msg_data
        );

Line: 635

END Delete_Dim_Objs_In_DSet;

Line: 640

    ,   p_delete                IN              BOOLEAN  := FALSE
    ,   x_return_status         OUT    NOCOPY   VARCHAR2
    ,   x_msg_count             OUT    NOCOPY   NUMBER
    ,   x_msg_data              OUT    NOCOPY   VARCHAR2
) IS
BEGIN
    FOR i IN 0..(p_MTab_Tbl.COUNT-1) LOOP
        BSC_BIS_KPI_MEAS_PUB.Create_Dim_Objs_In_DSet
        (       p_commit             =>   FND_API.G_FALSE
            ,   p_kpi_id             =>   p_MTab_Tbl(i).p_kpi_id
            ,   p_dim_set_id         =>   p_MTab_Tbl(i).p_dim_set_id
            ,   p_kpi_flag_change    =>   p_kpi_flag_change
            ,   p_delete             =>   p_delete
            ,   x_return_status      =>   x_return_status
            ,   x_msg_count          =>   x_msg_count
            ,   x_msg_data           =>   x_msg_data
        );

Line: 672

    ,   p_delete                IN              BOOLEAN  := FALSE
    ,   p_old_default           IN              VARCHAR2
    ,   p_new_default           IN              VARCHAR2
    ,   p_dim_obj_short_name    IN              VARCHAR2
    ,   p_dim_obj_objs_tbl      IN OUT NOCOPY   BSC_BIS_DIMENSION_PUB.dimobj_obj_kpis_tbl_type
    ,   x_return_status         OUT    NOCOPY   VARCHAR2
    ,   x_msg_count             OUT    NOCOPY   NUMBER
    ,   x_msg_data              OUT    NOCOPY   VARCHAR2
) IS
l_kpi_flag_change      VARCHAR2(1);

Line: 700

            ,   p_delete             =>   p_delete
            ,   x_return_status      =>   x_return_status
            ,   x_msg_count          =>   x_msg_count
            ,   x_msg_data           =>   x_msg_data
        );

Line: 720

    SELECT   DISTINCT A.indicator  INDICATOR
          ,  A.dim_set_id          DIM_SET_ID
          ,  A.Dim_Group_Index
    FROM     BSC_KPI_DIM_GROUPS A
          ,  BSC_KPIS_B         B
    WHERE    A.INDICATOR    =  B.INDICATOR
    AND      B.share_flag  <>  2
    AND      A.dim_group_id =  p_dim_group_id
    ORDER BY A.Dim_Group_Index;

Line: 748

     SELECT a.indicator indicator, a.kpi_measure_id
     FROM   BSC_DB_DATASET_DIM_SETS_V a, bsc_kpi_dim_levels_vl b
     WHERE  a.indicator = b.indicator
      AND   a.dim_set_id = b.dim_set_id
      AND   b.level_shortname = p_dim_obj_short_name;

Line: 922

        SELECT  NVL(MAX(dim_group_id) + 1, 0)
        INTO    l_count
        FROM    BSC_SYS_DIM_GROUPS_TL;

Line: 934

            SELECT COUNT(1) INTO l_count
            FROM (SELECT COUNT(1) rec_count
                  FROM   BSC_SYS_DIM_GROUPS_VL
                  WHERE  UPPER(Short_Name) = UPPER(l_temp_var)
                  UNION
                  SELECT COUNT(1) rec_count
                  FROM   BIS_DIMENSIONS_VL
                  WHERE  UPPER(Short_Name) = UPPER(l_temp_var))
            WHERE rec_count > 0;

Line: 984

    SELECT  COUNT(1) INTO l_count
    FROM    BSC_SYS_DIM_GROUPS_TL
    WHERE   UPPER(short_name) = UPPER(l_dim_short_name);

Line: 995

    SELECT  COUNT(1) INTO l_count
    FROM    BIS_DIMENSIONS_VL
    WHERE   UPPER(short_name) = UPPER(l_dim_short_name);

Line: 1029

      SELECT  COUNT(1) INTO l_count
        FROM    BIS_DIMENSIONS_VL
        WHERE   UPPER(name)  = UPPER(p_display_name);

Line: 1036

        SELECT  COUNT(1) INTO l_count
        FROM    BIS_DIMENSIONS_VL
        WHERE   UPPER(name)       = UPPER(l_pmf_disp_name);

Line: 1044

      SELECT  COUNT(1) INTO l_count
        FROM    BSC_SYS_DIM_GROUPS_VL
        WHERE   UPPER(name) = UPPER(p_display_name);

Line: 1055

      SELECT  COUNT(1) INTO l_count
        FROM    BIS_DIMENSIONS_VL
        WHERE   UPPER(name) = UPPER(p_display_name);

Line: 1096

        (    p_selected_dim_objets   =>  l_Dim_Obj_Tab
          ,  x_return_status         =>  x_return_status
          ,  x_msg_count             =>  x_msg_count
          ,  x_msg_data              =>  x_msg_data
        );

Line: 1118

    SELECT  dim_group_id
    INTO    l_bis_dimension_rec.Dim_Grp_Id
    FROM    BSC_SYS_DIM_GROUPS_VL
    WHERE   Short_Name = l_bsc_dimension_rec.Bsc_Dim_Level_Group_short_name;

Line: 1249

    SELECT   B.Short_Name
          ,  B.Dim_Level_ID
    FROM     BSC_SYS_DIM_LEVELS_B        B
          ,  BSC_SYS_DIM_LEVELS_BY_GROUP A
    WHERE    A.dim_group_id =
             (  SELECT dim_group_id
                FROM   BSC_SYS_DIM_GROUPS_VL
                WHERE  Short_Name  = p_dim_short_name
             )
    AND      A.Dim_Level_Id = B.Dim_Level_Id
    ORDER BY A.Dim_Level_Index;

Line: 1262

    SELECT  dim_group_id
    FROM    BSC_SYS_DIM_GROUPS_VL
    WHERE   short_name     = p_dim_short_name;

Line: 1267

    SELECT  Dim_Level_Id
          , Source
    FROM    BSC_SYS_DIM_LEVELS_B
    WHERE   Short_Name     = l_dim_obj_name;

Line: 1290

            FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');

Line: 1313

        BSC_BIS_DIMENSION_PUB.Delete_Dim_Objs_In_DSet
        (       p_MTab_Tbl          =>  l_MTab_Tbl
            ,   x_return_status     =>  x_return_status
            ,   x_msg_count         =>  x_msg_count
            ,   x_msg_data          =>  x_msg_data
        );

Line: 1332

                FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');

Line: 1392

            SELECT Dim_Level_Index INTO l_original_tab_index
            FROM   BSC_SYS_DIM_LEVELS_BY_GROUP
            WHERE  Dim_Group_Id = l_dim_group_id
            AND    Dim_Level_ID = l_MTab_DimRels1(i).p_dim_obj_id;

Line: 1402

                BSC_DIMENSION_GROUPS_PUB.Update_Dim_Levels_In_Group
                (       p_commit                =>  FND_API.G_FALSE
                    ,   p_Dim_Grp_Rec           =>  l_bsc_dimension_rec
                    ,   x_return_status         =>  x_return_status
                    ,   x_msg_count             =>  x_msg_count
                    ,   x_msg_data              =>  x_msg_data
                );

Line: 1419

                SELECT Dim_Level_Index
                INTO   l_original_tab_index
                FROM   BSC_SYS_DIM_LEVELS_BY_GROUP
                WHERE  Dim_Group_Id = l_dim_group_id
                AND    Dim_Level_ID = l_MTab_DimRels2(l_tab_index).p_dim_obj_id;

Line: 1430

                    BSC_DIMENSION_GROUPS_PUB.Update_Dim_Levels_In_Group
                    (       p_commit                =>  FND_API.G_FALSE
                        ,   p_Dim_Grp_Rec           =>  l_bsc_dimension_rec
                        ,   x_return_status         =>  x_return_status
                        ,   x_msg_count             =>  x_msg_count
                        ,   x_msg_data              =>  x_msg_data
                    );

Line: 1507

                      ASSIGN OR UPDATE A DIMENSION OBJECT TO DIMENSION
*********************************************************************************/
PROCEDURE Assign_Dimension_Object
(       p_commit                IN              VARCHAR2  := FND_API.G_FALSE -- mdamle 06/06/2005 - Set default p_commit to false for dim. group apis called from EO
    ,   p_dim_short_name        IN              VARCHAR2
    ,   p_dim_obj_short_name    IN              VARCHAR2
    ,   p_comp_flag             IN              NUMBER
    ,   p_no_items              IN              NUMBER
    ,   p_parent_in_tot         IN              NUMBER
    ,   p_total_flag            IN              NUMBER
    ,   p_default_value         IN              VARCHAR2
    ,   p_time_stamp            IN              VARCHAR2  :=   NULL    -- Granular Locking
    ,   p_create_view           IN              NUMBER    :=   0
    ,   p_where_clause          IN              VARCHAR2  :=   NULL
    ,   x_return_status         OUT    NOCOPY   VARCHAR2
    ,   x_msg_count             OUT    NOCOPY   NUMBER
    ,   x_msg_data              OUT    NOCOPY   VARCHAR2
) IS
    l_Dim_Grp_Id                BSC_SYS_DIM_GROUPS_TL.Dim_Group_Id%TYPE;

Line: 1543

    SELECT dim_level_id   FROM BSC_SYS_DIM_LEVELS_B
    WHERE  short_name     = p_dim_obj_short_name;

Line: 1547

    SELECT dim_group_id   FROM BSC_SYS_DIM_GROUPS_VL
    WHERE  short_name     = p_dim_short_name;

Line: 1552

    SELECT  B.Default_Value
          , C.Short_Name
          , C.Source
          , C.Name
    FROM    BSC_SYS_DIM_LEVELS_BY_GROUP B,
            BSC_SYS_DIM_GROUPS_VL       V,
            BSC_SYS_DIM_LEVELS_VL       C
    WHERE   V.Dim_Group_Id  =   B.Dim_Group_Id
    AND     B.Dim_Level_Id  =   C.Dim_Level_Id
    AND     V.Short_Name    =   p_Dim_Short_Name;

Line: 1564

    SELECT Default_Value
    FROM   BSC_SYS_DIM_LEVELS_BY_GROUP
    WHERE  Dim_Group_Id =  l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id;

Line: 1571

    SELECT a.indicator,
           a.kpi_measure_id
    FROM   bsc_db_dataset_dim_sets_v a,
           bsc_kpi_dim_levels_vl b
    WHERE  a.indicator =b.indicator
    AND    a.dim_set_id =b.dim_set_id
    AND    b.level_shortname =p_dim_obj_short_name;

Line: 1598

        FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');

Line: 1610

    SELECT  COUNT(B.DEFAULT_VALUE)
    INTO    l_count
    FROM    BSC_SYS_DIM_LEVELS_BY_GROUP B
    WHERE   B.DIM_GROUP_ID = l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id;

Line: 1688

            FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');

Line: 1706

        BSC_BIS_LOCKS_PUB.Lock_Update_Dim_Obj_In_Dim
        (     p_dim_object_id         =>  l_bsc_dimension_rec.Bsc_Level_Id
           ,  p_dimension_id          =>  l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id
           ,  p_time_stamp            =>  p_time_stamp     -- Granular Locking
           ,  x_return_status         =>  x_return_status
           ,  x_msg_count             =>  x_msg_count
           ,  x_msg_data              =>  x_msg_data
        );

Line: 1735

            BSC_BIS_DIMENSION_PUB.Delete_Dim_Objs_In_DSet
            (       p_MTab_Tbl          =>  l_MTab_Tbl
                ,   x_return_status     =>  x_return_status
                ,   x_msg_count         =>  x_msg_count
                ,   x_msg_data          =>  x_msg_data
            );

Line: 1756

            BSC_DIMENSION_GROUPS_PUB.Update_Dim_Levels_In_Group
            (       p_commit                =>  FND_API.G_FALSE
                ,   p_Dim_Grp_Rec           =>  l_bsc_dimension_rec
                ,   x_return_status         =>  x_return_status
                ,   x_msg_count             =>  x_msg_count
                ,   x_msg_data              =>  x_msg_data
            );

Line: 1805

                UPDATE BSC_SYS_DIM_LEVELS_BY_GROUP
                SET    Dim_Group_ID  =  l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id
                WHERE  Dim_Level_ID  =  l_bsc_dimension_rec.Bsc_Level_Id
                AND    Dim_Group_ID  =  l_Dim_Grp_Id;

Line: 1912

        BSC_KPI_MEASURE_PROPS_PUB.Update_Kpi_Measure_Props
        (
            p_commit           => FND_API.G_FALSE
          , p_kpi_measure_rec  => l_kpi_measure_props_rec
          , p_cascade_shared   => TRUE
          , x_return_status    =>  x_return_status
          , x_msg_count        =>  x_msg_count
          , x_msg_data         =>  x_msg_data
        );

Line: 2041

    SELECT  Dim_Group_Id
    FROM    BSC_SYS_DIM_GROUPS_VL
    WHERE   Short_Name = p_dim_short_name;

Line: 2046

    SELECT  Dim_Level_Id
          , Source
    FROM    BSC_SYS_DIM_LEVELS_B
    WHERE   Short_Name     = l_dim_obj_name;

Line: 2052

    SELECT  Short_Name
    FROM    BIS_LEVELS
    WHERE   Dimension_Id = l_Bis_Group_ID;

Line: 2075

            FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');

Line: 2091

            BSC_BIS_LOCKS_PUB.Lock_Update_Dimension
            (       p_dimension_id          =>  l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id
                ,   p_selected_dim_objets   =>  l_Dim_Obj_Tab
                ,   p_time_stamp            =>  p_time_stamp     -- Granular Locking
                ,   x_return_status         =>  x_return_status
                ,   x_msg_count             =>  x_msg_count
                ,   x_msg_data              =>  x_msg_data
            );

Line: 2122

            BSC_BIS_DIMENSION_PUB.Delete_Dim_Objs_In_DSet
            (       p_MTab_Tbl              =>  l_MTab_Tbl
                ,   x_return_status         =>  x_return_status
                ,   x_msg_count             =>  x_msg_count
                ,   x_msg_data              =>  x_msg_data
            );

Line: 2140

                    FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');

Line: 2151

                            UPDATE BSC_SYS_DIM_LEVELS_BY_GROUP
                            SET    Dim_Group_Id = l_Dim_Grp_ID
                            WHERE  Dim_Group_Id = l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id
                            AND    Dim_Level_Id = l_bsc_dimension_rec.Bsc_Level_Id;

Line: 2159

                        BSC_DIMENSION_GROUPS_PUB.Delete_Dim_Levels_In_Group
                        (       p_commit            =>  FND_API.G_FALSE
                            ,   p_Dim_Grp_Rec       =>  l_bsc_dimension_rec
                            ,   x_return_status     =>  x_return_status
                            ,   x_msg_count         =>  x_msg_count
                            ,   x_msg_data          =>  x_msg_data
                        );

Line: 2325

          SELECT DIM_NAME
          INTO   l_dim_name
          FROM   BSC_BIS_DIM_VL
          WHERE  SHORT_NAME = p_dim_short_name;

Line: 2330

          SELECT NAME
          INTO   l_dim_obj_name
          FROM   BSC_BIS_DIM_OBJS_VL
          WHERE  SHORT_NAME = l_unassign;

Line: 2355

      , p_Entity_Action_Type    => BSC_UTILITY.c_UPDATE
      , x_Return_Status         => x_return_status
      , x_Msg_Count             => x_msg_count
      , x_Msg_Data              => x_msg_data
    );

Line: 2389

    SELECT  B.SHORT_NAME
    FROM    BIS_LEVELS     A
         ,  BIS_DIMENSIONS B
    WHERE   B.DIMENSION_ID = A.DIMENSION_ID
    AND     A.SHORT_NAME   = l_dim_obj_sht_name;

Line: 2396

    SELECT  dim_short_name
    FROM    BSC_BIS_DIM_OBJ_BY_DIM_VL
    WHERE   obj_short_name = l_dim_obj_sht_name
    AND     dim_short_name <>p_dim_short_name;

Line: 2533

                        UPDATE DIMENSION
*********************************************************************************/
PROCEDURE Update_Dimension
(       p_commit                IN              VARCHAR2   := FND_API.G_FALSE -- mdamle 06/06/2005 - Set default p_commit to false for dim. group apis called from EO
    ,   p_dim_short_name        IN              VARCHAR2
    ,   p_display_name          IN              VARCHAR2
    ,   p_description           IN              VARCHAR2
    ,   p_application_id        IN              NUMBER
    ,   p_time_stamp            IN              VARCHAR2    :=   NULL    -- Granular Locking
    ,   p_hide                  IN              VARCHAR2   := FND_API.G_FALSE
    ,   x_return_status         OUT    NOCOPY   VARCHAR2
    ,   x_msg_count             OUT    NOCOPY   NUMBER
    ,   x_msg_data              OUT    NOCOPY   VARCHAR2
)IS
    l_bis_dimension_rec     BIS_DIMENSION_PUB.Dimension_Rec_Type;

Line: 2562

    SELECT  name, dim_group_id
    FROM    BSC_SYS_DIM_GROUPS_VL
    WHERE   short_name  = l_dim_short_name;

Line: 2567

    SELECT  name, description, dimension_id
    FROM    BIS_DIMENSIONS_VL
    WHERE   short_name  = l_dim_short_name;

Line: 2571

    SAVEPOINT UpdateBSCDimensionPMD;

Line: 2610

                FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');

Line: 2629

            SELECT  COUNT(1) INTO l_count
            FROM    BIS_DIMENSIONS_VL
            WHERE   UPPER(short_name) <> UPPER(l_dim_short_name)
            AND     UPPER(name)        = UPPER(p_display_name);

Line: 2635

                SELECT  COUNT(1) INTO l_count
                FROM    BIS_DIMENSIONS_VL
                WHERE   UPPER(name)        = UPPER(l_pmf_disp_name);

Line: 2688

        BIS_DIMENSION_PUB.Update_Dimension
        (       p_api_version           =>  1.0
            ,   p_commit                =>  FND_API.G_FALSE
            ,   p_validation_level      =>  FND_API.G_VALID_LEVEL_FULL
            ,   p_Dimension_Rec         =>  l_bis_dimension_rec
            ,   x_return_status         =>  x_return_status
            ,   x_error_Tbl             =>  l_error_tbl
        );

Line: 2741

        UPDATE BIS_DIMENSIONS
        SET    Dim_Grp_ID   =
        (   SELECT  dim_group_id
            FROM    BSC_SYS_DIM_GROUPS_VL
            WHERE   Short_Name = l_bsc_dimension_rec.Bsc_Dim_Level_Group_short_name
        );

Line: 2751

        BSC_DIMENSION_GROUPS_PUB.Update_Dimension_Group
        (       p_commit                =>  FND_API.G_FALSE
            ,   p_Dim_Grp_Rec           =>  l_bsc_dimension_rec
            ,   p_create_Dim_Levels     =>  FALSE
            ,   x_return_status         =>  x_return_status
            ,   x_msg_count             =>  x_msg_count
            ,   x_msg_data              =>  x_msg_data
        );

Line: 2779

        ROLLBACK TO UpdateBSCDimensionPMD;

Line: 2796

        ROLLBACK TO UpdateBSCDimensionPMD;

Line: 2813

        ROLLBACK TO UpdateBSCDimensionPMD;

Line: 2816

            x_msg_data      :=  x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Update_Dimension ';

Line: 2818

            x_msg_data      :=  SQLERRM||' at BSC_BIS_DIMENSION_PUB.Update_Dimension ';

Line: 2828

        ROLLBACK TO UpdateBSCDimensionPMD;

Line: 2831

            x_msg_data      :=  x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Update_Dimension ';

Line: 2833

            x_msg_data      :=  SQLERRM||' at BSC_BIS_DIMENSION_PUB.Update_Dimension ';

Line: 2836

END Update_Dimension;

Line: 2839

                        UPDATE DIMENSION
*********************************************************************************/
PROCEDURE Update_Dimension
(       p_commit                    IN              VARCHAR2   := FND_API.G_FALSE -- mdamle 06/06/2005 - Set default p_commit to false for dim. group apis called from EO
    ,   p_dim_short_name            IN              VARCHAR2
    ,   p_display_name              IN              VARCHAR2
    ,   p_description               IN              VARCHAR2
    ,   p_application_id            IN              NUMBER
    ,   p_assign_dim_obj_names      IN              VARCHAR2
    ,   p_unassign_dim_obj_names    IN              VARCHAR2
    ,   p_time_stamp                IN              VARCHAR2    :=   NULL    -- Granular Locking
    ,   p_hide                      IN              VARCHAR2   := FND_API.G_FALSE
    ,   p_Restrict_Dim_Validate     IN              VARCHAR2   := NULL
    ,   x_return_status             OUT    NOCOPY   VARCHAR2
    ,   x_msg_count                 OUT    NOCOPY   NUMBER
    ,   x_msg_data                  OUT    NOCOPY   VARCHAR2
)IS
    -- START Granular Locking Declaration added by Aditya
    l_bsc_dimension_rec     BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;

Line: 2860

    SELECT  dim_group_id
    FROM    BSC_SYS_DIM_GROUPS_VL
    WHERE   short_name = p_dim_short_name;

Line: 2874

    SELECT DISTINCT indicator
    FROM   BSC_KPI_DIM_GROUPS
    WHERE  dim_group_id = l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id;

Line: 2897

        FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');

Line: 2924

      SELECT  COUNT(1) INTO l_count
        FROM    BSC_SYS_DIM_GROUPS_VL
        WHERE   UPPER(short_name) <> UPPER(p_dim_short_name)
    AND     UPPER(name) = UPPER(p_display_name); -- already trimmed from JAVA

Line: 2936

      SELECT  COUNT(1) INTO l_count
        FROM    BIS_DIMENSIONS_VL
        WHERE   UPPER(short_name) <> UPPER(p_dim_short_name)
    AND     UPPER(name) = UPPER(p_display_name);

Line: 2976

    BSC_BIS_LOCKS_PUB.Lock_Update_Dimension
    (    p_dimension_id          =>  l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id
      ,  p_selected_dim_objets   =>  l_Dim_Obj_Tab
      ,  p_time_stamp            =>  p_time_stamp        -- Granular Locking
      ,  x_return_status         =>  x_return_status
      ,  x_msg_count             =>  x_msg_count
      ,  x_msg_data              =>  x_msg_data
    );

Line: 2988

    BSC_BIS_DIMENSION_PUB.Update_Dimension
    (       p_commit                =>  FND_API.G_FALSE
        ,   p_dim_short_name        =>  p_dim_short_name
        ,   p_display_name          =>  p_display_name
        ,   p_description           =>  p_description
        ,   p_application_id        =>  p_application_id
        ,   p_time_stamp            =>  NULL        -- Granular Locking
        ,   p_hide                  =>  p_hide
        ,   x_return_status         =>  x_return_status
        ,   x_msg_count             =>  x_msg_count
        ,   x_msg_data              =>  x_msg_data
    );

Line: 3077

            x_msg_data      :=  x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Update_Dimension ';

Line: 3079

            x_msg_data      :=  SQLERRM||' at BSC_BIS_DIMENSION_PUB.Update_Dimension ';

Line: 3088

            x_msg_data      :=  x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Update_Dimension ';

Line: 3090

            x_msg_data      :=  SQLERRM||' at BSC_BIS_DIMENSION_PUB.Update_Dimension ';

Line: 3093

END Update_Dimension;

Line: 3096

                        UPDATE DIMENSION
*********************************************************************************/
PROCEDURE Update_Dimension
(       p_commit                    IN              VARCHAR2   := FND_API.G_FALSE -- mdamle 06/06/2005 - Set default p_commit to false for dim. group apis called from EO
    ,   p_dim_short_name            IN              VARCHAR2
    ,   p_display_name              IN              VARCHAR2
    ,   p_description               IN              VARCHAR2
    ,   p_application_id            IN              NUMBER
    ,   p_dim_obj_short_names       IN              VARCHAR2
    ,   p_time_stamp                IN              VARCHAR2    :=   NULL    -- Granular Locking
    ,   p_hide                      IN              VARCHAR2   := FND_API.G_FALSE
    ,   p_Restrict_Dim_Validate     IN              VARCHAR2   := NULL
    ,   x_return_status             OUT    NOCOPY   VARCHAR2
    ,   x_msg_count                 OUT    NOCOPY   NUMBER
    ,   x_msg_data                  OUT    NOCOPY   VARCHAR2
)IS
    l_bsc_dimension_rec     BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;

Line: 3122

    SELECT  dim_group_id
    FROM    BSC_SYS_DIM_GROUPS_VL WHERE short_name = p_dim_short_name;

Line: 3126

    SELECT  short_name
    FROM    BSC_SYS_DIM_LEVELS_B
    WHERE   dim_level_id IN (SELECT dim_level_id
    FROM    BSC_SYS_DIM_LEVELS_BY_GROUP
    WHERE   dim_group_id = l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id);

Line: 3133

    SELECT   grp.indicator , grp.dim_set_id,count(kpi.dim_level_index)
    FROM     BSC_KPI_DIM_GROUPS grp,
             BSC_KPI_DIM_LEVELS_B kpi
    WHERE    kpi.indicator = grp.indicator
    AND      kpi.dim_set_id = grp.dim_set_id
    AND      grp.dim_group_id = l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id
    GROUP BY grp.indicator,grp.dim_set_id;

Line: 3173

        FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');

Line: 3185

    BSC_BIS_DIMENSION_PUB.Update_Dimension
    (       p_commit                    =>  FND_API.G_FALSE
        ,   p_dim_short_name            =>  p_dim_short_name
        ,   p_display_name              =>  p_display_name
        ,   p_description               =>  p_description
        ,   p_application_id            =>  p_application_id
        ,   p_assign_dim_obj_names      =>  p_dim_obj_short_names
        ,   p_unassign_dim_obj_names    =>  l_unassign_dim_obj_names
        ,   p_time_stamp                =>  p_time_stamp -- Need to add timestamp
        ,   p_hide                      =>  p_hide
        ,   p_Restrict_Dim_Validate =>  p_Restrict_Dim_Validate
        ,   x_return_status             =>  x_return_status
        ,   x_msg_count                 =>  x_msg_count
        ,   x_msg_data                  =>  x_msg_data
    );

Line: 3219

                    SELECT NAME INTO l_kpi_name
                    FROM   BSC_KPIS_VL
                    WHERE  INDICATOR = l_kpi_id;

Line: 3287

            x_msg_data      :=  x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Update_Dimension ';

Line: 3289

            x_msg_data      :=  SQLERRM||' at BSC_BIS_DIMENSION_PUB.Update_Dimension ';

Line: 3298

            x_msg_data      :=  x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Update_Dimension ';

Line: 3300

            x_msg_data      :=  SQLERRM||' at BSC_BIS_DIMENSION_PUB.Update_Dimension ';

Line: 3303

END Update_Dimension;

Line: 3305

                        DELETE DIMENSION
*********************************************************************************/
PROCEDURE Delete_Dimension
(       p_commit                IN              VARCHAR2   := FND_API.G_FALSE -- mdamle 06/06/2005 - Set default p_commit to false for dim. group apis called from EO
    ,   p_dim_short_name        IN              VARCHAR2
    ,   x_return_status         OUT    NOCOPY   VARCHAR2
    ,   x_msg_count             OUT    NOCOPY   NUMBER
    ,   x_msg_data              OUT    NOCOPY   VARCHAR2
) IS

    l_delete                BOOLEAN := TRUE;

Line: 3321

    l_delete_count          NUMBER := 0;

Line: 3326

    SELECT  dimension_id
           ,name
    FROM    BIS_DIMENSIONS_VL
    WHERE   short_name = p_dim_short_name;

Line: 3332

    SELECT  dim_group_id
          , name
    FROM    BSC_SYS_DIM_GROUPS_VL
    WHERE   short_name = p_dim_short_name;

Line: 3338

    SELECT  Short_Name
    FROM    BIS_LEVELS
    WHERE   Dimension_Id = l_bis_dimension_rec.dimension_id;

Line: 3342

    SAVEPOINT DeleteBSCDimensionsPMD;

Line: 3354

        FND_MESSAGE.SET_NAME('BSC','BSC_B_CAN_NOT_DELETE_GROUP');

Line: 3367

            l_delete    :=  FALSE;

Line: 3390

    IF (l_delete) THEN
        SELECT COUNT(1) INTO l_count
        FROM   BIS_INDICATOR_DIMENSIONS
        WHERE  DIMENSION_ID = l_bis_dimension_rec.dimension_id;

Line: 3395

            FND_MESSAGE.SET_NAME('BSC','BSC_NOT_DELETE_DIM_IN_MEASURE');

Line: 3400

        BIS_DIMENSION_PUB.Delete_Dimension
        (       p_commit                =>  FND_API.G_FALSE
            ,   p_validation_level      =>  FND_API.G_VALID_LEVEL_FULL
            ,   p_Dimension_Rec         =>  l_bis_dimension_rec
            ,   x_return_status         =>  x_return_status
            ,   x_error_Tbl             =>  l_error_tbl
        );

Line: 3420

        l_delete_count  := l_delete_count + 1;

Line: 3422

        l_delete    :=  TRUE;

Line: 3433

            l_delete    :=  FALSE;

Line: 3450

    IF (l_delete) THEN
        -- START: Granular Locking to Lock Dimension Group when it is being deleted.
        SELECT COUNT(1) INTO l_count
        FROM   BSC_KPI_DIM_GROUPS
        WHERE  dim_group_id = l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id;

Line: 3456

            FND_MESSAGE.SET_NAME('BSC','BSC_NOT_DELETE_DIMENSIONS');

Line: 3478

        BSC_DIMENSION_GROUPS_PUB.Delete_Dimension_Group
        (       p_commit                =>  FND_API.G_FALSE
            ,   p_Dim_Grp_Rec           =>  l_bsc_dimension_rec
            ,   x_return_status         =>  x_return_status
            ,   x_msg_count             =>  x_msg_count
            ,   x_msg_data              =>  x_msg_data
        );

Line: 3489

        l_delete_count  := l_delete_count + 1;

Line: 3491

        l_delete    :=  TRUE;

Line: 3493

    IF (l_delete_count  = 0) THEN
        FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');

Line: 3513

        ROLLBACK TO DeleteBSCDimensionsPMD;

Line: 3530

        ROLLBACK TO DeleteBSCDimensionsPMD;

Line: 3547

        ROLLBACK TO DeleteBSCDimensionsPMD;

Line: 3550

            x_msg_data      :=  x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Delete_Dimension ';

Line: 3552

            x_msg_data      :=  SQLERRM||' at BSC_BIS_DIMENSION_PUB.Delete_Dimension ';

Line: 3562

        ROLLBACK TO DeleteBSCDimensionsPMD;

Line: 3565

            x_msg_data      :=  x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Delete_Dimension ';

Line: 3567

            x_msg_data      :=  SQLERRM||' at BSC_BIS_DIMENSION_PUB.Delete_Dimension ';

Line: 3570

END Delete_Dimension;

Line: 3608

    SELECT  VL.Source
    FROM    BSC_SYS_DIM_GROUPS_TL       TL
          , BSC_SYS_DIM_LEVELS_BY_GROUP GP
          , BSC_SYS_DIM_LEVELS_B        VL
    WHERE   TL.Dim_Group_Id =   GP.Dim_Group_Id
    AND     GP.Dim_Level_Id =   VL.Dim_Level_Id
    AND     TL.Short_Name   =   p_short_Name;

Line: 3681

        SELECT source, name, level_values_view_name, 'ID', 'value'
        INTO    x_source
            ,   x_dim_lvl_name
            ,   x_dim_lvl_view_name
            ,   x_dim_lvl_pk_key
            ,   x_dim_lvl_name_col
        FROM    bis_levels_vl
        WHERE   UPPER(short_name) = UPPER(p_dim_lvl_shrt_name);

Line: 3712

    l_dim_lvl_sql := 'SELECT dim.DIM_NAME dimshortname, lvl.LEVEL_PREFIX prefix '||
                     ' FROM '||
                     ' edw_dimensions_md_v dim, edw_levels_md_v lvl '||
                     ' WHERE '||
                     ' lvl.DIM_ID = dim.DIM_ID AND '||
                     ' lvl.LEVEL_NAME = :1 ';

Line: 3758

    l_edw_sql := ' select distinct level_table_col_name ' ||
                 '   from edw_level_Table_atts_md_v ' ||
                 '  where key_type=''UK'' and ' ||
                 '  upper(level_Table_name) = upper(:1) and ' ||
                 '  upper(level_table_col_name) like ''%PK_KEY%''';

Line: 3768

    l_edw_sql := 'select level_table_col_name ' ||
                 '  from edw_level_Table_atts_md_v ' ||
                 ' where upper(level_Table_name) = upper(:1) and ' ||
                 '  (upper(level_table_col_name) like ''%DESCRIPTION%'' or ' ||
                 '   upper(level_table_col_name) like ''NAME%'') ';

Line: 3817

    SELECT  A.Default_Value
         ,  A.Dim_Group_ID
         ,  C.Source
    FROM    BSC_SYS_DIM_LEVELS_BY_GROUP  A
         ,  BSC_SYS_DIM_GROUPS_VL        B
         ,  BSC_SYS_DIM_LEVELS_B         C
    WHERE   A.Dim_Group_Id     =    B.Dim_Group_Id
    AND     A.Dim_Level_Id     =    C.Dim_Level_Id
    AND     B.Short_Name       =    p_Dim_Short_Name
    AND     C.Short_Name       =    p_dim_Obj_Short_Name;

Line: 3829

    SELECT   a.indicator indicator,
             a.kpi_measure_id,
             c.color_by_total
      FROM   bsc_db_dataset_dim_sets_v a,
             bsc_kpi_dim_levels_vl b,
             bsc_kpi_measure_props c
     WHERE   a.indicator =b.indicator
       AND   a.dim_set_id =b.dim_set_id
       AND   c.indicator = a.indicator
       AND   c.kpi_measure_id = a.kpi_measure_id
       AND   b.level_shortname = p_dim_Obj_Short_Name;

Line: 3849

    SELECT  Property_Value INTO l_Prod_Mode
    FROM    BSC_SYS_INIT
    WHERE   PROPERTY_CODE ='SYSTEM_STAGE';

Line: 3892

      l_sql := 'SELECT name, indicator FROM bsc_kpis_vl WHERE indicator IN (' || l_indicator_list || ') AND prototype_flag = 0 AND source_indicator IS NULL';

Line: 3990

    SELECT   C.Short_Name
          ,  B.Dim_Level_Index
          ,  A.Dim_Group_Id
          ,  C.Source
    FROM     BSC_SYS_DIM_GROUPS_VL        A
          ,  BSC_SYS_DIM_LEVELS_BY_GROUP  B
          ,  BSC_SYS_DIM_LEVELS_B         C
    WHERE    A.Dim_Group_Id   =   B.Dim_Group_Id
    AND      C.Dim_Level_Id   =   B.Dim_Level_Id
    AND      A.Short_Name     =   p_Dim_Short_Name
    ORDER BY B.Dim_Level_Index;

Line: 4003

    SELECT   DISTINCT B.Name||'['||B.Indicator||']' INDICATOR
    FROM     BSC_KPI_DIM_GROUPS     A
          ,  BSC_KPIS_VL            B
          ,  BSC_SYS_DIM_GROUPS_VL  C
    WHERE    A.INDICATOR         =  B.INDICATOR
    AND      B.share_flag       <>  2
    AND      A.Dim_Group_Id      =  C.Dim_Group_Id
    AND      C.Short_Name        =  p_Dim_Short_Name;

Line: 4152

    SELECT   A. INDICATOR
           , A.DIM_SET_ID
    FROM     BSC_KPI_DIM_GROUPS A
           , BSC_SYS_DIM_GROUPS_VL B
    WHERE    A.DIM_GROUP_ID = B.DIM_GROUP_ID
    AND      B.SHORT_NAME =  p_Dim_Short_Name;

Line: 4160

    SELECT B.SHORT_NAME
    FROM   BSC_SYS_DIM_LEVELS_B B
          ,BSC_KPI_DIM_LEVEL_PROPERTIES KDL
    WHERE  B.DIM_LEVEL_ID = KDL.DIM_LEVEL_ID
    AND    KDL.indicator = l_kpi_id
    AND    KDL.dim_set_id = l_dim_set_id;

Line: 4168

    SELECT BL.SHORT_NAME
    FROM BSC_SYS_DIM_LEVELS_BY_GROUP B
          ,BSC_SYS_DIM_GROUPS_VL  VL
          ,BSC_SYS_DIM_LEVELS_B  BL
    WHERE VL.DIM_GROUP_ID = B.DIM_GROUP_ID
    AND   BL.DIM_LEVEL_ID = B.DIM_LEVEL_ID
    AND   VL.SHORT_NAME = p_Dim_Short_Name;

Line: 4197

    dim_objs_in_dim.delete;

Line: 4212

      kpi_dim_set_array.delete;

Line: 4235

        dim_objs_array.delete;

Line: 4350

   SELECT  count(dim_level_id) into l_count
   FROM    BSC_SYS_DIM_LEVELS_BY_GROUP
   WHERE   dim_group_id = l_dim_group_id;

Line: 4407

   SELECT  count(dim_level_id) into l_count
            FROM    BSC_SYS_DIM_LEVELS_BY_GROUP
            WHERE   dim_group_id = l_dim_group_id;

Line: 4446

    SELECT   DISTINCT A.indicator  INDICATOR
          ,  A.dim_set_id          DIM_SET_ID
          ,  A.Dim_Group_Index
    FROM     BSC_KPI_DIM_GROUPS A
          ,  BSC_KPIS_B         B
    WHERE    A.INDICATOR    =  B.INDICATOR
    AND      B.share_flag  <>  2
    AND      A.dim_group_id =  l_dim_group_id
    ORDER BY A.Dim_Group_Index;

Line: 4457

    SELECT  count(dim_level_id)
    FROM    BSC_SYS_DIM_LEVELS_BY_GROUP
    WHERE   dim_group_id = l_dim_group_id;

Line: 4480

            SELECT  count(dim_level_id) into l_count
            FROM    BSC_SYS_DIM_LEVELS_BY_GROUP
            WHERE   dim_group_id = l_dim_group_id;

Line: 4530

    SELECT source,name
    FROM   bsc_sys_dim_levels_vl
    WHERE  INSTR(','||p_dim_short_names ||',' , ','||short_name||',') > 0;

Line: 4547

        SELECT count(distinct(source))
        INTO   l_diff_source_cnt
        FROM   bsc_sys_dim_levels_vl
        WHERE  INSTR(','||p_dim_short_names ||',',','||short_name||',') > 0;

Line: 4579

            SELECT distinct(NVL(source, 'BSC'))
            INTO   x_dim_type
            FROM   bsc_sys_dim_levels_vl
            WHERE  INSTR(','||p_dim_short_names ||',',','||short_name||',') > 0;

Line: 4610

  SELECT COUNT(1) INTO l_count
  FROM   BSC_KPI_DIM_GROUPS    KG,
         BSC_SYS_DIM_GROUPS_VL G
  WHERE  KG.DIM_GROUP_ID = G.DIM_GROUP_ID
  AND    G.SHORT_NAME    = p_dim_short_name;

Line: 4643

    SELECT   c.color_by_total
      FROM   bsc_kpi_measure_props c
     WHERE   c.indicator = p_obj_id
       AND   c.kpi_measure_id = p_kpi_measure_id;

Line: 4695

  SELECT count(0) INTO l_count
  FROM bsc_kpis_b WHERE
  indicator = p_indicator;