APPS.BSC_COMMON_DIMENSIONS_PUB SQL Statements

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

Line: 45

    BSC_COMMON_DIMENSIONS_PVT.delete_common_dimensions(
        p_tab_id            =>   p_tab_id
       ,p_commit            =>   FND_API.G_FALSE
       ,x_return_status     =>   x_return_status
       ,x_msg_count         =>   x_msg_count
       ,x_msg_data          =>   x_msg_data
    );

Line: 54

      BSC_COMMON_DIMENSIONS_PVT.insert_common_dimensions(
         p_tab_id            =>   p_tab_id
        ,p_new_list_config   =>   p_new_list_config
        ,p_commit            =>   FND_API.G_FALSE
        ,x_return_status     =>   x_return_status
        ,x_msg_count         =>   x_msg_count
        ,x_msg_data          =>   x_msg_data
    );

Line: 65

    BSC_COMMON_DIMENSIONS_PUB.update_user_list_access(
         p_tab_id            =>   p_tab_id
        ,p_new_list_config   =>   p_new_list_config
        ,p_old_list_config   =>   p_old_list_config
        ,p_commit            =>   FND_API.G_FALSE
        ,x_return_status     =>   x_return_status
        ,x_msg_count         =>   x_msg_count
        ,x_msg_data          =>   x_msg_data
    );

Line: 143

PROCEDURE update_user_list_access
(
 p_tab_id                 IN               NUMBER
,p_new_list_config        IN               VARCHAR2
,p_old_list_config        IN               VARCHAR2
,p_commit                 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

CURSOR c_new_list_config IS
   SELECT *
   FROM bsc_sys_com_dim_levels
   WHERE tab_id = p_tab_id
   ORDER BY dim_level_index;

Line: 161

   SELECT responsibility_id
   FROM BSC_USER_TAB_ACCESS
   WHERE tab_id = p_tab_id
     AND (end_date IS NULL OR end_date >= SYSDATE);

Line: 167

   SELECT DISTINCT kpi_measure_id, indicator
   FROM bsc_kpi_analysis_measures_b
   WHERE indicator IN (SELECT DISTINCT ti.indicator
                       FROM bsc_tab_indicators ti
                       WHERE ti.tab_id = p_tab_id);

Line: 247

    BSC_COMMON_DIMENSIONS_PVT.delete_user_list_access (
                  p_tab_id               => p_tab_id
                 ,p_dim_level_index      => l_index
                 ,p_commit               => FND_API.G_FALSE
                 ,x_return_status        => x_return_status
                 ,x_msg_count            => x_msg_count
     ,x_msg_data             => x_msg_data
    );

Line: 275

              BSC_COMMON_DIMENSIONS_PVT.insert_user_list_access(
               p_responsibility_id  =>  cd.responsibility_id
              ,p_tab_id             =>  p_tab_id
              ,p_dim_level_index    =>  l_dim_level_index
              ,p_dim_level_value    =>  0
              ,p_creation_date      =>  SYSDATE
              ,p_created_by         =>  l_user_id
              ,p_last_update_date   =>  SYSDATE
              ,p_last_updated_by    =>  l_login_id
              ,p_last_update_login  =>  NULL
              ,p_commit             =>  FND_API.G_FALSE
              ,x_return_status      =>  x_return_status
              ,x_msg_count          =>  x_msg_count
              ,x_msg_data           =>  x_msg_data
              );

Line: 322

            x_msg_data      :=  x_msg_data||' -> BSC_COMMON_DIMENSIONS_PUB.update_user_list_access ';

Line: 324

            x_msg_data      :=  SQLERRM||' at BSC_COMMON_DIMENSIONS_PUB.update_user_list_access ';

Line: 331

            x_msg_data      :=  x_msg_data||' -> BSC_COMMON_DIMENSIONS_PUB.update_user_list_access ';

Line: 333

            x_msg_data      :=  SQLERRM||' at BSC_COMMON_DIMENSIONS_PUB.update_user_list_access ';

Line: 337

END update_user_list_access;

Line: 360

  SELECT DISTINCT ti.indicator
  FROM bsc_tab_indicators ti
  WHERE ti.tab_id = p_tab_id;

Line: 365

  SELECT DISTINCT ti.indicator
  FROM bsc_tab_indicators ti, bsc_sys_dim_levels_b sd, bsc_kpi_dim_levels_b kd
  WHERE ti.tab_id = p_tab_id AND sd.dim_level_id = p_dim_level_id AND
        kd.indicator = ti.indicator AND kd.level_table_name = sd.level_table_name;