APPS.BSC_KPI_MEASURE_WEIGHTS_PUB SQL Statements

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

Line: 16

    SELECT indicator
    FROM   bsc_kpis_b
    WHERE  source_indicator = p_indicator
    AND    share_flag = 2 -- shared objective.
    AND    prototype_flag <> 2;

Line: 116

PROCEDURE Update_Kpi_Measure_Weights (
  p_commit                   IN             VARCHAR2 := FND_API.G_FALSE
, p_kpi_measure_weights_rec  IN             BSC_KPI_MEASURE_WEIGHTS_PUB.kpi_measure_weights_rec
, p_cascade_shared           IN             BOOLEAN := TRUE
, x_return_status            OUT NOCOPY     VARCHAR2
, x_msg_count                OUT NOCOPY     NUMBER
, x_msg_data                 OUT NOCOPY     VARCHAR2
)
IS
  CURSOR c_shared_obj(p_indicator NUMBER) IS
    SELECT indicator
    FROM   bsc_kpis_b
    WHERE  source_indicator = p_indicator
    AND    share_flag = 2 -- shared objective.
    AND    prototype_flag <> 2;

Line: 139

  SAVEPOINT BscKpiMeasureWeightPub_Update;

Line: 143

  BSC_KPI_MEASURE_WEIGHTS_PVT.Update_Kpi_Measure_Weights
  ( p_commit                   => p_commit
  , p_kpi_measure_weights_rec  => p_kpi_measure_weights_rec
  , x_return_status            => x_return_status
  , x_msg_count                => x_msg_count
  , x_msg_data                 => x_msg_data
  );

Line: 170

      BSC_KPI_MEASURE_WEIGHTS_PVT.Update_Kpi_Measure_Weights
      ( p_commit                   => p_commit
      , p_kpi_measure_weights_rec  => l_kpi_measure_weights_rec
      , x_return_status            => x_return_status
      , x_msg_count                => x_msg_count
      , x_msg_data                 => x_msg_data
      );

Line: 186

    ROLLBACK TO BscKpiMeasureWeightPub_Update;

Line: 196

    ROLLBACK TO BscKpiMeasureWeightPub_Update;

Line: 206

    ROLLBACK TO BscKpiMeasureWeightPub_Update;

Line: 209

      x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PUB.Update_Kpi_Measure_Weights ';

Line: 211

      x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PUB.Update_Kpi_Measure_Weights ';

Line: 214

    ROLLBACK TO BscKpiMeasureWeightPub_Update;

Line: 217

      x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PUB.Update_Kpi_Measure_Weights ';

Line: 219

      x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PUB.Update_Kpi_Measure_Weights ';

Line: 221

END Update_Kpi_Measure_Weights;

Line: 236

    SELECT indicator
    FROM   bsc_kpis_b
    WHERE  source_indicator = p_indicator
    AND    share_flag = 2 -- shared objective.
    AND    prototype_flag <> 2;

Line: 249

  SAVEPOINT BscKpiMeasureWeightPub_Delete;

Line: 296

    ROLLBACK TO BscKpiMeasureWeightPub_Delete;

Line: 306

    ROLLBACK TO BscKpiMeasureWeightPub_Delete;

Line: 316

    ROLLBACK TO BscKpiMeasureWeightPub_Delete;

Line: 324

    ROLLBACK TO BscKpiMeasureWeightPub_Delete;

Line: 345

    SELECT indicator
    FROM   bsc_kpis_b
    WHERE  source_indicator = p_indicator
    AND    share_flag = 2 -- shared objective.
    AND    prototype_flag <> 2;