APPS.BSC_KPI_MEASURE_WEIGHTS_PVT SQL Statements

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

Line: 32

  INSERT INTO bsc_kpi_measure_weights
  ( indicator
  , kpi_measure_id
  , weight
  , creation_date
  , created_by
  , last_update_date
  , last_updated_by
  , last_update_login
  )
  VALUES
  ( p_kpi_measure_weights_rec.objective_id
  , p_kpi_measure_weights_rec.kpi_measure_id
  , p_kpi_measure_weights_rec.weight
  , NVL(p_kpi_measure_weights_rec.creation_date, SYSDATE)
  , NVL(p_kpi_measure_weights_rec.created_by, FND_GLOBAL.USER_ID)
  , NVL(p_kpi_measure_weights_rec.last_update_date, SYSDATE)
  , NVL(p_kpi_measure_weights_rec.last_updated_by, FND_GLOBAL.USER_ID)
  , NVL(p_kpi_measure_weights_rec.last_update_login, FND_GLOBAL.LOGIN_ID)
  );

Line: 98

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
, x_return_status            OUT NOCOPY     VARCHAR2
, x_msg_count                OUT NOCOPY     NUMBER
, x_msg_data                 OUT NOCOPY     VARCHAR2
)
IS
  l_kpi_measure_weights_rec  BSC_KPI_MEASURE_WEIGHTS_PUB.kpi_measure_weights_rec;

Line: 111

  SAVEPOINT BscKpiMeasureWeightPvt_Update;

Line: 138

  IF(p_kpi_measure_weights_rec.last_update_date IS NULL) THEN
    l_kpi_measure_weights_rec.last_update_date := SYSDATE;

Line: 141

    l_kpi_measure_weights_rec.last_update_date := p_kpi_measure_weights_rec.last_update_date;

Line: 143

  IF (p_kpi_measure_weights_rec.last_updated_by IS NULL) THEN
    l_kpi_measure_weights_rec.last_updated_by := FND_GLOBAL.USER_ID;

Line: 146

    l_kpi_measure_weights_rec.last_updated_by := p_kpi_measure_weights_rec.last_updated_by;

Line: 148

  IF (p_kpi_measure_weights_rec.last_update_login IS NULL) THEN
    l_kpi_measure_weights_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 151

    l_kpi_measure_weights_rec.last_update_login := p_kpi_measure_weights_rec.last_update_login;

Line: 154

  UPDATE bsc_kpi_measure_weights
    SET weight            = l_kpi_measure_weights_rec.weight
      , last_updated_by   = l_kpi_measure_weights_rec.last_updated_by
      , last_update_date  = l_kpi_measure_weights_rec.last_update_date
      , last_update_login = l_kpi_measure_weights_rec.last_update_login
    WHERE indicator = l_kpi_measure_weights_rec.objective_id
    AND   kpi_measure_id = l_kpi_measure_weights_rec.kpi_measure_id;

Line: 168

    ROLLBACK TO BscKpiMeasureWeightPvt_Update;

Line: 178

    ROLLBACK TO BscKpiMeasureWeightPvt_Update;

Line: 188

    ROLLBACK TO BscKpiMeasureWeightPvt_Update;

Line: 191

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

Line: 193

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

Line: 196

    ROLLBACK TO BscKpiMeasureWeightPvt_Update;

Line: 199

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

Line: 201

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

Line: 203

END Update_Kpi_Measure_Weights;

Line: 220

  SAVEPOINT BscKpiMeasureWeightPvt_Delete;

Line: 232

  DELETE FROM bsc_kpi_measure_weights
    WHERE indicator = p_objective_id
    AND   kpi_measure_id = p_kpi_measure_id;

Line: 242

    ROLLBACK TO BscKpiMeasureWeightPvt_Delete;

Line: 252

    ROLLBACK TO BscKpiMeasureWeightPvt_Delete;

Line: 262

    ROLLBACK TO BscKpiMeasureWeightPvt_Delete;

Line: 270

    ROLLBACK TO BscKpiMeasureWeightPvt_Delete;

Line: 301

  DELETE FROM bsc_kpi_measure_weights
    WHERE indicator = p_objective_id;

Line: 372

  SELECT
    indicator
  , kpi_measure_id
  , weight
  , creation_date
  , created_by
  , last_update_date
  , last_updated_by
  , last_update_login
  INTO
    x_kpi_measure_weights_rec.objective_id
  , x_kpi_measure_weights_rec.kpi_measure_id
  , x_kpi_measure_weights_rec.weight
  , x_kpi_measure_weights_rec.creation_date
  , x_kpi_measure_weights_rec.created_by
  , x_kpi_measure_weights_rec.last_update_date
  , x_kpi_measure_weights_rec.last_updated_by
  , x_kpi_measure_weights_rec.last_update_login
  FROM bsc_kpi_measure_weights
  WHERE indicator = p_objective_id
  AND   kpi_measure_id = p_kpi_measure_id;