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_COLOR_PROPERTIES_PUB SQL Statements

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

Line: 8


PROCEDURE Update_Kpi_Color_Properties (
  p_commit              IN              VARCHAR2 := FND_API.G_FALSE
, p_objective_id	IN		BSC_KPIS_B.indicator%TYPE
, p_kpi_measure_id      IN      	BSC_KPI_ANALYSIS_MEASURES_B.kpi_measure_id%TYPE
, p_disable_color	IN		BSC_KPI_MEASURE_PROPS.disable_color%TYPE
, p_kpi_prototype_color	IN		BSC_KPI_MEASURE_PROPS.prototype_color_id%TYPE
, p_kpi_prototype_trend	IN		BSC_KPI_MEASURE_PROPS.prototype_trend_id%TYPE
, p_color_by_total	IN		BSC_KPI_MEASURE_PROPS.color_by_total%TYPE
, p_disable_trend	IN		BSC_KPI_MEASURE_PROPS.disable_trend%TYPE
, p_need_color_recalc	IN		VARCHAR2 := 'N'
, 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: 52


  BSC_KPI_MEASURE_PROPS_PUB.Update_Kpi_Measure_Props
  ( p_commit           => p_commit
  , p_kpi_measure_rec  => l_kpi_measure_rec
  , x_return_status    => x_return_status
  , x_msg_count        => x_msg_count
  , x_msg_data         => x_msg_data
  );

Line: 102


      x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Update_Kpi_Color_Properties ';

Line: 104


      x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Update_Kpi_Color_Properties ';

Line: 109


      x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Update_Kpi_Color_Properties ';

Line: 111


      x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Update_Kpi_Color_Properties ';

Line: 114


END Update_Kpi_Color_Properties;

Line: 121


PROCEDURE Update_Obj_Color_Properties (
  p_commit              	IN              VARCHAR2 := FND_API.G_FALSE
, p_objective_id		IN		BSC_KPIS_B.indicator%TYPE
, p_obj_prototype_color_id	IN		BSC_KPIS_B.prototype_color_id%TYPE
, p_obj_prototype_trend_id	IN		BSC_KPIS_B.prototype_trend_id%TYPE
, p_color_rollup_type		IN		BSC_KPIS_B.color_rollup_type%TYPE
, p_weighted_color_method	IN		BSC_KPIS_B.weighted_color_method%TYPE
, p_need_color_recalc		IN		VARCHAR2 := 'Y'
, x_return_status       	OUT NOCOPY     	VARCHAR2
, x_msg_count           	OUT NOCOPY     	NUMBER
, x_msg_data            	OUT NOCOPY     	VARCHAR2
)
IS
  l_objective_rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

Line: 137


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

Line: 169


  BSC_KPI_PVT.Update_Kpi
  ( p_commit               => p_commit
  , p_Bsc_Kpi_Entity_Rec   => l_objective_rec
  , x_return_status        => x_return_status
  , x_msg_count            => x_msg_count
  , x_msg_data             => x_msg_data
  );

Line: 183


    BSC_KPI_PVT.Update_Kpi
    ( p_commit               => p_commit
    , p_Bsc_Kpi_Entity_Rec   => l_objective_rec
    , x_return_status        => x_return_status
    , x_msg_count            => x_msg_count
    , x_msg_data             => x_msg_data
    );

Line: 228


      x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Update_Obj_Color_Properties ';

Line: 230


      x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Update_Obj_Color_Properties ';

Line: 235


      x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Update_Obj_Color_Properties ';

Line: 237


      x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Update_Obj_Color_Properties ';

Line: 241


END Update_Obj_Color_Properties;

Line: 248


PROCEDURE Create_Update_Kpi_Mes_Weights (
  p_commit              IN              VARCHAR2 := FND_API.G_FALSE
, p_objective_id	IN		BSC_KPIS_B.indicator%TYPE
, p_kpi_measure_id      IN      	BSC_KPI_ANALYSIS_MEASURES_B.kpi_measure_id%TYPE
, p_kpi_weight		IN		BSC_KPI_MEASURE_WEIGHTS.weight%TYPE
, 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: 273


  SELECT count(1) INTO l_num FROM bsc_kpi_measure_weights WHERE indicator = p_objective_id AND kpi_measure_id = p_kpi_measure_id;

Line: 292


    BSC_KPI_MEASURE_WEIGHTS_PUB.Update_Kpi_Measure_Weights
    ( p_commit               	  => p_commit
    , p_kpi_measure_weights_rec   => l_kpi_measure_weights_rec
    , p_cascade_shared		  => TRUE
    , x_return_status        	  => x_return_status
    , x_msg_count           	  => x_msg_count
    , x_msg_data             	  => x_msg_data
    );

Line: 307


  /*SELECT prototype_flag INTO l_obj_prototype_flag
  FROM bsc_kpis_b
  WHERE indicator = p_objective_id;*/

Line: 311


  SELECT bk.color_rollup_type, bk.prototype_flag
  INTO   l_color_rollup_type, l_obj_prototype_flag
  FROM bsc_db_color_ao_defaults_v dd, bsc_kpi_analysis_measures_vl km, bsc_kpis_b bk
  WHERE km.indicator = p_objective_id AND
        bk.indicator = km.indicator AND
        km.indicator = dd.indicator AND
        dd.a0_default = km.analysis_option0 AND
        dd.a1_default = km.analysis_option1 AND
        dd.a2_default = km.analysis_option2 AND
        km.default_value = 1;

Line: 359


      x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Create_Update_Kpi_Measure_Weights ';

Line: 361


      x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Create_Update_Kpi_Measure_Weights ';

Line: 366


      x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Create_Update_Kpi_Measure_Weights ';

Line: 368


      x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Create_Update_Kpi_Measure_Weights ';

Line: 371


END Create_Update_Kpi_Mes_Weights;

Line: 387


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

Line: 468


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

Line: 481


  BSC_DESIGNER_PVT.Update_Kpi_Prototype_Flag
  ( p_objective_id   => p_objective_id
  , p_kpi_measure_id => p_kpi_measure_id
  , p_flag           => p_prototype_flag
  );

Line: 499


    BSC_DESIGNER_PVT.Update_Kpi_Prototype_Flag
    ( p_objective_id   => c_shared.indicator
    , p_kpi_measure_id => l_kpi_measure_id
    , p_flag           => p_prototype_flag
    );

Line: 577


  /*SELECT prototype_flag INTO l_obj_prototype_flag
  FROM bsc_kpis_b
  WHERE indicator = p_objective_id;*/

Line: 581


  SELECT bk.color_rollup_type, km.kpi_measure_id, bk.prototype_flag
  INTO   l_color_rollup_type, l_def_kpi_measure_id, l_obj_prototype_flag
  FROM bsc_db_color_ao_defaults_v dd, bsc_kpi_analysis_measures_vl km, bsc_kpis_b bk
  WHERE km.indicator = p_objective_id AND
        bk.indicator = km.indicator AND
        km.indicator = dd.indicator AND
        dd.a0_default = km.analysis_option0 AND
        dd.a1_default = km.analysis_option1 AND
        dd.a2_default = km.analysis_option2 AND
        km.default_value = 1;

Line: 683


  BSC_KPI_MEASURE_PROPS_PUB.Update_Kpi_Measure_Props
  ( p_commit           => p_commit
  , p_kpi_measure_rec  => l_kpi_measure_rec
  , x_return_status    => x_return_status
  , x_msg_count        => x_msg_count
  , x_msg_data         => x_msg_data
  );