APPS.BSC_CALCULATIONS_PUB SQL Statements

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

Line: 46

  SELECT default_value
  FROM bsc_kpi_calculations
  WHERE indicator = p_obj_id
    AND calculation_id = l_calc_id;

Line: 52

   SELECT indicator
   FROM bsc_kpis_b
   WHERE source_indicator = p_obj_id
     AND share_flag  = 2
     AND prototype_flag <> 2;

Line: 95

         SELECT count(0) INTO l_cnt
         FROM bsc_kpi_calculations
         WHERE indicator = p_obj_id
           AND calculation_id = l_calc_id;

Line: 131

           BSC_CALCULATIONS_PVT.delete_objective_calculation (
               p_indicator       =>   p_obj_id
              ,p_calculation_id  =>   l_calc_id
              ,x_return_status   =>   x_return_status
              ,x_msg_count       =>   x_msg_count
              ,x_msg_data        =>   x_msg_data
           );

Line: 140

           BSC_CALCULATIONS_PVT.insert_objective_calculation (
                p_indicator            =>   p_obj_id
               ,p_calculation_id       =>   l_calc_id
               ,p_user_level0          =>   l_user_level0
               ,p_user_level1          =>   l_user_level0
               ,p_user_level1_default  =>   l_user_level0
               ,p_user_level2          =>   NULL
               ,p_user_level2_default  =>   NULL
               ,p_default_value        =>   l_def_val
               ,x_return_status        =>   x_return_status
               ,x_msg_count            =>   x_msg_count
               ,x_msg_data             =>   x_msg_data
               );

Line: 158

             BSC_CALCULATIONS_PVT.delete_objective_calculation (
               p_indicator       =>   shared_ind_cd.indicator
              ,p_calculation_id  =>   l_calc_id
              ,x_return_status   =>   x_return_status
              ,x_msg_count       =>   x_msg_count
              ,x_msg_data        =>   x_msg_data
             );

Line: 166

             BSC_CALCULATIONS_PVT.insert_objective_calculation (
                p_indicator            =>   shared_ind_cd.indicator
               ,p_calculation_id       =>   l_calc_id
               ,p_user_level0          =>   l_user_level0
               ,p_user_level1          =>   l_user_level0
               ,p_user_level1_default  =>   l_user_level0
               ,p_user_level2          =>   NULL
               ,p_user_level2_default  =>   NULL
               ,p_default_value        =>   l_def_val
               ,x_return_status        =>   x_return_status
               ,x_msg_count            =>   x_msg_count
               ,x_msg_data             =>   x_msg_data
               );

Line: 262

   SELECT indicator
   FROM bsc_kpis_b
   WHERE source_indicator = p_obj_id
     AND share_flag       = 2
     AND prototype_flag   <> 2;

Line: 280

      UPDATE bsc_kpi_calculations
      SET USER_LEVEL0   = l_user_level0,
          USER_LEVEL1   = l_user_level1,
          DEFAULT_VALUE = l_def_value
      WHERE indicator = p_obj_id AND calculation_id = 2;

Line: 288

      UPDATE bsc_kpi_calculations
      SET DEFAULT_VALUE = l_def_value
      WHERE indicator = p_obj_id AND calculation_id = 2;

Line: 303

          UPDATE bsc_kpi_calculations
          SET DEFAULT_VALUE = l_def_value
          WHERE indicator = cd.indicator AND calculation_id = 2;

Line: 310

          UPDATE bsc_kpi_calculations
          SET DEFAULT_VALUE = l_def_value
          WHERE indicator = cd.indicator AND calculation_id = 2;

Line: 389

   SELECT * FROM bsc_kpi_calculations where indicator = p_obj_id AND calculation_id = cp_calc_id;

Line: 392

   SELECT * FROM bsc_kpi_calculations where indicator = p_obj_id;

Line: 459

            UPDATE bsc_kpi_calculations
            SET
              user_level1 = ulv1,
              user_level1_default = ulvd1,
              user_level2_default = ulvd2
            WHERE
              indicator = p_obj_id
              AND calculation_id = l_calc_id;

Line: 500

        UPDATE bsc_kpi_calculations
        SET
           user_level1 = ulv1,
           user_level1_default = ulvd1,
           user_level2_default = ulvd2
        WHERE
           indicator = p_obj_id
           AND calculation_id = cd.calculation_id;

Line: 572

    SELECT default_value INTO l_default
    FROM bsc_kpi_calculations
    WHERE indicator = p_obj_id
      AND calculation_id = p_cal_id;

Line: 611

    SELECT count(0) INTO l_cnt
    FROM bsc_sys_dataset_calc
    WHERE dataset_id = l_def_meas_id
      AND disabled_calc_id = 2;

Line: 640

    SELECT dataset_id
    INTO
      l_dataset_id
    FROM
      bsc_kpi_analysis_measures_b
    WHERE
      kpi_measure_id = p_kpi_measure_id;

Line: 669

   SELECT measure_col FROM bsc_sys_measures
   WHERE measure_id IN (SELECT measure_id1 FROM bsc_sys_datasets_b
                        WHERE dataset_id = p_dataset_id
                        UNION
                        SELECT measure_id2 FROM bsc_sys_datasets_b
                        WHERE dataset_id = p_dataset_id);

Line: 677

   SELECT measure_type
   FROM bsc_db_measure_cols_vl
   WHERE measure_col = p_measure_col;

Line: 732

  SELECT COUNT(1)
  INTO
    l_Count
  FROM
    bsc_sys_dataset_calc
  WHERE
    dataset_id = p_dataset_id AND
    disabled_calc_id = p_calculation_id;