eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_KPI_MEASURE_PROPS_PVT SQL Statements

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

Line: 31


    SELECT COUNT(1) INTO l_count
      FROM  bsc_kpi_measure_props
      WHERE indicator = p_kpi_measure_rec.objective_id
      AND   kpi_measure_id = p_kpi_measure_rec.kpi_measure_id;

Line: 44


  INSERT INTO bsc_kpi_measure_props
  ( indicator
  , kpi_measure_id
  , prototype_color_id
  , prototype_trend_id
  , color_by_total
  , disable_color
  , disable_trend
  , apply_color_flag
  , default_calculation
  , creation_date
  , created_by
  , last_update_date
  , last_updated_by
  , last_update_login
  )
  VALUES
  ( p_kpi_measure_rec.objective_id
  , p_kpi_measure_rec.kpi_measure_id
  , p_kpi_measure_rec.prototype_color
  , p_kpi_measure_rec.prototype_trend
  , p_kpi_measure_rec.color_by_total
  , p_kpi_measure_rec.disable_color
  , p_kpi_measure_rec.disable_trend
  , p_kpi_measure_rec.apply_color_flag
  , p_kpi_measure_rec.default_calculation
  , NVL(p_kpi_measure_rec.creation_date, SYSDATE)
  , NVL(p_kpi_measure_rec.created_by, FND_GLOBAL.USER_ID)
  , NVL(p_kpi_measure_rec.last_update_date, SYSDATE)
  , NVL(p_kpi_measure_rec.last_updated_by, FND_GLOBAL.USER_ID)
  , NVL(p_kpi_measure_rec.last_update_login, FND_GLOBAL.LOGIN_ID)
  );

Line: 122


PROCEDURE Update_Kpi_Measure_Props (
  p_commit              IN             VARCHAR2 := FND_API.G_FALSE
, p_kpi_measure_rec     IN             BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec
, x_return_status       OUT NOCOPY     VARCHAR2
, x_msg_count           OUT NOCOPY     NUMBER
, x_msg_data            OUT NOCOPY     VARCHAR2
)
IS
  l_kpi_measure_rec  BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec;

Line: 135


  SAVEPOINT BscKpiMeasurePvt_Update;

Line: 178


  IF(p_kpi_measure_rec.last_update_date IS NULL) THEN
    l_kpi_measure_rec.last_update_date := SYSDATE;

Line: 181


    l_kpi_measure_rec.last_update_date := p_kpi_measure_rec.last_update_date;

Line: 183


  IF (p_kpi_measure_rec.last_updated_by IS NULL) THEN
    l_kpi_measure_rec.last_updated_by := FND_GLOBAL.USER_ID;

Line: 186


    l_kpi_measure_rec.last_updated_by := p_kpi_measure_rec.last_updated_by;

Line: 188


  IF (p_kpi_measure_rec.last_update_login IS NULL) THEN
    l_kpi_measure_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 191


    l_kpi_measure_rec.last_update_login := p_kpi_measure_rec.last_update_login;

Line: 194


  UPDATE bsc_kpi_measure_props
    SET prototype_color_id  = l_kpi_measure_rec.prototype_color
      , prototype_trend_id  = l_kpi_measure_rec.prototype_trend
      , color_by_total      = l_kpi_measure_rec.color_by_total
      , disable_color       = l_kpi_measure_rec.disable_color
      , disable_trend       = l_kpi_measure_rec.disable_trend
      , apply_color_flag    = l_kpi_measure_rec.apply_color_flag
      , default_calculation = l_kpi_measure_rec.default_calculation
      , last_updated_by     = l_kpi_measure_rec.last_updated_by
      , last_update_date    = l_kpi_measure_rec.last_update_date
      , last_update_login   = l_kpi_measure_rec.last_update_login
    WHERE indicator = l_kpi_measure_rec.objective_id
    AND   kpi_measure_id = l_kpi_measure_rec.kpi_measure_id;

Line: 214


    ROLLBACK TO BscKpiMeasurePvt_Update;

Line: 224


    ROLLBACK TO BscKpiMeasurePvt_Update;

Line: 234


    ROLLBACK TO BscKpiMeasurePvt_Update;

Line: 237


      x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Update_Kpi_Measure_Props ';

Line: 239


      x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Update_Kpi_Measure_Props ';

Line: 242


    ROLLBACK TO BscKpiMeasurePvt_Update;

Line: 245


      x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Update_Kpi_Measure_Props ';

Line: 247


      x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Update_Kpi_Measure_Props ';

Line: 249


END Update_Kpi_Measure_Props;

Line: 253


PROCEDURE Delete_Kpi_Measure_Props (
  p_commit              IN             VARCHAR2:= FND_API.G_FALSE
, p_objective_id        IN             NUMBER
, p_kpi_measure_id      IN             NUMBER
, x_return_status       OUT NOCOPY     VARCHAR2
, x_msg_count           OUT NOCOPY     NUMBER
, x_msg_data            OUT NOCOPY     VARCHAR2
)
IS
BEGIN
  FND_MSG_PUB.Initialize;

Line: 266


  SAVEPOINT BscKpiMeasurePvt_Delete;

Line: 278


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

Line: 288


    ROLLBACK TO BscKpiMeasurePvt_Delete;

Line: 298


    ROLLBACK TO BscKpiMeasurePvt_Delete;

Line: 308


    ROLLBACK TO BscKpiMeasurePvt_Delete;

Line: 311


      x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Delete_Kpi_Measure_Props ';

Line: 313


      x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Delete_Kpi_Measure_Props ';

Line: 316


    ROLLBACK TO BscKpiMeasurePvt_Delete;

Line: 319


      x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Delete_Kpi_Measure_Props ';

Line: 321


      x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Delete_Kpi_Measure_Props ';

Line: 323


END Delete_Kpi_Measure_Props;

Line: 327


PROCEDURE Delete_Obj_Kpi_Measure_Props (
  p_commit              IN             VARCHAR2:= FND_API.G_FALSE
, p_objective_id        IN             NUMBER
, x_return_status       OUT NOCOPY     VARCHAR2
, x_msg_count           OUT NOCOPY     NUMBER
, x_msg_data            OUT NOCOPY     VARCHAR2
)
IS
BEGIN
  FND_MSG_PUB.Initialize;

Line: 339


  SAVEPOINT BscKpiMeasurePvt_DeleteAll;

Line: 347


  DELETE FROM bsc_kpi_measure_props
    WHERE indicator = p_objective_id;

Line: 356


    ROLLBACK TO BscKpiMeasurePvt_DeleteAll;

Line: 366


    ROLLBACK TO BscKpiMeasurePvt_DeleteAll;

Line: 376


    ROLLBACK TO BscKpiMeasurePvt_DeleteAll;

Line: 379


      x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Delete_Obj_Kpi_Measure_Props ';

Line: 381


      x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Delete_Obj_Kpi_Measure_Props ';

Line: 384


    ROLLBACK TO BscKpiMeasurePvt_DeleteAll;

Line: 387


      x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Delete_Obj_Kpi_Measure_Props ';

Line: 389


      x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Delete_Obj_Kpi_Measure_Props ';

Line: 391


END Delete_Obj_Kpi_Measure_Props;

Line: 418


  SELECT
    indicator
  , kpi_measure_id
  , prototype_color_id
  , prototype_trend_id
  , color_by_total
  , disable_color
  , disable_trend
  , apply_color_flag
  , default_calculation
  , creation_date
  , created_by
  , last_update_date
  , last_updated_by
  , last_update_login
  INTO
    x_kpi_measure_rec.objective_id
  , x_kpi_measure_rec.kpi_measure_id
  , x_kpi_measure_rec.prototype_color
  , x_kpi_measure_rec.prototype_trend
  , x_kpi_measure_rec.color_by_total
  , x_kpi_measure_rec.disable_color
  , x_kpi_measure_rec.disable_trend
  , x_kpi_measure_rec.apply_color_flag
  , x_kpi_measure_rec.default_calculation
  , x_kpi_measure_rec.creation_date
  , x_kpi_measure_rec.created_by
  , x_kpi_measure_rec.last_update_date
  , x_kpi_measure_rec.last_updated_by
  , x_kpi_measure_rec.last_update_login
  FROM bsc_kpi_measure_props
  WHERE indicator = p_objective_id
  AND   kpi_measure_id = p_kpi_measure_id;