APPS.BSC_BIS_CUSTOM_KPI_UTIL_PUB SQL Statements

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

Line: 39

REM |                 DashBord for End to End Kpi should update BSC MetaData|
REM +=======================================================================+
*/

-- changed to use BSC_KPI_ANALYSIS_OPTIONS_B
-- BSC_KPIS_B.SHORT_NAME and BSC_TABS_B.SHORT_NAME have existed before Start-to-End KPI.


PROCEDURE SetGlobalFlag
IS

 TYPE Ref_Cur IS REF CURSOR;

Line: 60

  sql_query := 'select count(1) from sys.all_tab_columns where table_name = ''BSC_DB_MEASURE_GROUPS_TL'' and COLUMN_NAME  = ''SHORT_NAME'' ';

Line: 104

    SELECT COUNT(1) INTO l_Count
    FROM   bis_indicators
    WHERE  short_name         = p_Short_Name
    AND    actual_data_source IS NOT NULL
    AND    actual_data_source_type = 'AK';

Line: 120

procedure update_kpi_End_To_End_Name(
  p_Commit                       IN         VARCHAR2 := FND_API.G_FALSE
  ,p_Name                        IN         VARCHAR2
  ,p_Short_Name                  IN         VARCHAR2
  ,x_Return_Status               OUT NOCOPY VARCHAR2
  ,x_Msg_Count                   OUT NOCOPY NUMBER
  ,x_Msg_Data                    OUT NOCOPY VARCHAR2
) IS

  l_tab_id                       BSC_TABS_B.TAB_ID%TYPE;

Line: 137

  SAVEPOINT UpdateEndToEndKPIName;

Line: 147

      BSC_PMF_UI_WRAPPER.Update_Tab(
      p_commit          =>  p_Commit
      ,p_tab_id         =>  l_tab_id
      ,p_tab_name       =>  l_tab_name
      ,p_tab_help       =>  l_tab_name
      ,x_return_status  =>  x_Return_Status
      ,x_msg_count      =>  x_Msg_Count
      ,x_msg_data       =>  x_Msg_Data
    );

Line: 166

    BSC_PMF_UI_WRAPPER.Update_Kpi_Group(
      p_commit          =>  p_Commit
      ,p_kpi_group_id   =>  l_kpi_group_id
      ,p_kpi_group_name =>  l_tab_ind_group_name
      ,p_kpi_group_help =>  l_tab_ind_group_name
      ,x_return_status  =>  x_Return_Status
      ,x_msg_count      =>  x_Msg_Count
      ,x_msg_data       =>  x_Msg_Data
    );

Line: 183

    BSC_PMF_UI_WRAPPER.Update_Kpi(
      p_commit          =>  p_Commit
      ,p_kpi_id         =>  l_kpi_id
      ,p_kpi_name       =>  p_Name
      ,p_kpi_help       =>  p_Name
      ,x_return_status  =>  x_Return_Status
      ,x_msg_count      =>  x_Msg_Count
      ,x_msg_data       =>  x_Msg_Data
    );

Line: 206

    ROLLBACK TO UpdateEndToEndKPIName;

Line: 209

    ROLLBACK TO UpdateEndToEndKPIName;

Line: 211

      x_msg_data      :=  x_msg_data||' -> BSC_BIS_CUSTOM_KPI_UTIL_PUB.update_kpi_End_To_End_Name ';

Line: 213

      x_msg_data      :=  SQLERRM||' at BSC_BIS_CUSTOM_KPI_UTIL_PUB.update_kpi_End_To_End_Name ';

Line: 215

END update_kpi_End_To_End_Name;

Line: 233

    sql_query := 'SELECT count(1) FROM  BSC_SYS_MEASURES a,BSC_DB_MEASURE_COLS_VL b '
                 ||'  , BSC_DB_MEASURE_GROUPS_VL c '
                 ||'  WHERE a.measure_col = b.measure_col '
                 ||' AND a.measure_id = :p_measure_id'
                         ||' AND b.measure_group_id = c.measure_group_id '
                 ||' AND c.short_name IS NOT NULL ';

Line: 279

    sql_query := 'select count(1) from bsc_db_measure_groups_vl where short_name is not null and measure_group_id = :p_measure_group_id';

Line: 309

    SELECT measure_group_id FROM BSC_DB_MEASURE_COLS_VL
    WHERE measure_col = p_Measure_Col;

Line: 353

  SELECT a.user_function_name
  INTO l_user_function_name
  FROM fnd_form_functions_vl a
  WHERE a.function_name = p_function_name;

Line: 442

    SELECT indicator kpiId, analysis_option0 aoId
    FROM bsc_kpi_analysis_measures_b
    WHERE dataset_id = p_Dataset_Id;

Line: 502

  SELECT data_length INTO l_fnd_length
  FROM SYS.ALL_TAB_COLUMNS
  WHERE table_name = 'FND_FORM_FUNCTIONS_TL'
  AND column_name = 'USER_FUNCTION_NAME';

Line: 507

  SELECT data_length INTO l_tab_length
  FROM SYS.ALL_TAB_COLUMNS
  WHERE table_name = 'BSC_TABS_TL'
  AND column_name = 'NAME';

Line: 528

  SELECT data_length INTO l_fnd_length
  FROM SYS.ALL_TAB_COLUMNS
  WHERE table_name = 'FND_FORM_FUNCTIONS_TL'
  AND column_name = 'USER_FUNCTION_NAME';

Line: 533

  SELECT data_length INTO l_tab_group_length
  FROM SYS.ALL_TAB_COLUMNS
  WHERE table_name = 'BSC_TAB_IND_GROUPS_TL'
  AND column_name = 'NAME';

Line: 568

   SELECT count(1) INTO l_count
   FROM BSC_TABS_VL
   WHERE UPPER(trim(name)) = UPPER(l_tab_name);

Line: 615

   SELECT count(1) INTO l_count
   FROM BSC_TABS_VL
   WHERE UPPER(trim(name)) = UPPER(l_tab_name)
         AND tab_id <> p_tab_id;

Line: 662

   SELECT count(1) INTO l_count
   FROM BSC_TAB_IND_GROUPS_VL
   WHERE UPPER(trim(name)) = UPPER(l_tab_grp_name);

Line: 709

   SELECT count(1) INTO l_count
   FROM BSC_TAB_IND_GROUPS_VL
   WHERE UPPER(trim(name)) = UPPER(l_tab_grp_name)
         AND IND_GROUP_ID <> p_tab_grp_id;

Line: 747

  SELECT COUNT(1) INTO l_Count
  FROM   BSC_KPIS_B K
  WHERE  K.SHORT_NAME = p_Region_Function_Name;

Line: 776

    SELECT COUNT(1) INTO l_Count
    FROM   BIS_DISPLAY_FORM_FUNC_V B
    WHERE  B.FUNCTION_NAME = p_Short_Name
    AND    B.OBJECT_TYPE   = BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_OBJECT_TYPE_REPORT;

Line: 785

        SELECT COUNT(0)
        INTO   l_Count
        FROM   bsc_kpis_b
        WHERE  short_name = p_Short_Name
        AND    config_Type =7;

Line: 796

        SELECT COUNT(1) INTO l_Count
        FROM   BSC_KPIS_B
        WHERE  SHORT_NAME     = p_Short_Name
        AND    PROTOTYPE_FLAG = BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_DELETED_OBJECTIVE_FLAG; -- deleted flag

Line: 827

    SELECT COUNT(1) INTO l_Count
    FROM   BIS_DISPLAY_FORM_FUNC_V B
    WHERE  B.FUNCTION_NAME = p_Short_Name
    AND    B.OBJECT_TYPE   = BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_OBJECT_TYPE_PAGE;

Line: 861

    SELECT R.ATTRIBUTE10 INTO l_Source_Type
    FROM   AK_REGIONS R
    WHERE  R.REGION_CODE = l_Region_Code;

Line: 897

  SELECT REPLACE(FORMAT,'#','9') FORMAT
    INTO   l_Format_Mask
    FROM   BSC_SYS_FORMATS
    WHERE  FORMAT_ID = l_Format_Id;