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 dependencies on BSC_KPIS_B

Line 10: , p_objective_id IN BSC_KPIS_B.indicator%TYPE

6: ************************************************************************************/
7:
8: PROCEDURE Update_Kpi_Color_Properties (
9: p_commit IN VARCHAR2 := FND_API.G_FALSE
10: , p_objective_id IN BSC_KPIS_B.indicator%TYPE
11: , p_kpi_measure_id IN BSC_KPI_ANALYSIS_MEASURES_B.kpi_measure_id%TYPE
12: , p_disable_color IN BSC_KPI_MEASURE_PROPS.disable_color%TYPE
13: , p_kpi_prototype_color IN BSC_KPI_MEASURE_PROPS.prototype_color_id%TYPE
14: , p_kpi_prototype_trend IN BSC_KPI_MEASURE_PROPS.prototype_trend_id%TYPE

Line 24: l_obj_prototype_flag BSC_KPIS_B.prototype_flag%TYPE;

20: , x_msg_data OUT NOCOPY VARCHAR2
21: )
22: IS
23: l_kpi_measure_rec BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec;
24: l_obj_prototype_flag BSC_KPIS_B.prototype_flag%TYPE;
25:
26: BEGIN
27:
28: FND_MSG_PUB.Initialize;

Line 123: , p_objective_id IN BSC_KPIS_B.indicator%TYPE

119: ************************************************************************************/
120:
121: PROCEDURE Update_Obj_Color_Properties (
122: p_commit IN VARCHAR2 := FND_API.G_FALSE
123: , p_objective_id IN BSC_KPIS_B.indicator%TYPE
124: , p_obj_prototype_color_id IN BSC_KPIS_B.prototype_color_id%TYPE
125: , p_obj_prototype_trend_id IN BSC_KPIS_B.prototype_trend_id%TYPE
126: , p_color_rollup_type IN BSC_KPIS_B.color_rollup_type%TYPE
127: , p_weighted_color_method IN BSC_KPIS_B.weighted_color_method%TYPE

Line 124: , p_obj_prototype_color_id IN BSC_KPIS_B.prototype_color_id%TYPE

120:
121: PROCEDURE Update_Obj_Color_Properties (
122: p_commit IN VARCHAR2 := FND_API.G_FALSE
123: , p_objective_id IN BSC_KPIS_B.indicator%TYPE
124: , p_obj_prototype_color_id IN BSC_KPIS_B.prototype_color_id%TYPE
125: , p_obj_prototype_trend_id IN BSC_KPIS_B.prototype_trend_id%TYPE
126: , p_color_rollup_type IN BSC_KPIS_B.color_rollup_type%TYPE
127: , p_weighted_color_method IN BSC_KPIS_B.weighted_color_method%TYPE
128: , p_need_color_recalc IN VARCHAR2 := 'Y'

Line 125: , p_obj_prototype_trend_id IN BSC_KPIS_B.prototype_trend_id%TYPE

121: PROCEDURE Update_Obj_Color_Properties (
122: p_commit IN VARCHAR2 := FND_API.G_FALSE
123: , p_objective_id IN BSC_KPIS_B.indicator%TYPE
124: , p_obj_prototype_color_id IN BSC_KPIS_B.prototype_color_id%TYPE
125: , p_obj_prototype_trend_id IN BSC_KPIS_B.prototype_trend_id%TYPE
126: , p_color_rollup_type IN BSC_KPIS_B.color_rollup_type%TYPE
127: , p_weighted_color_method IN BSC_KPIS_B.weighted_color_method%TYPE
128: , p_need_color_recalc IN VARCHAR2 := 'Y'
129: , x_return_status OUT NOCOPY VARCHAR2

Line 126: , p_color_rollup_type IN BSC_KPIS_B.color_rollup_type%TYPE

122: p_commit IN VARCHAR2 := FND_API.G_FALSE
123: , p_objective_id IN BSC_KPIS_B.indicator%TYPE
124: , p_obj_prototype_color_id IN BSC_KPIS_B.prototype_color_id%TYPE
125: , p_obj_prototype_trend_id IN BSC_KPIS_B.prototype_trend_id%TYPE
126: , p_color_rollup_type IN BSC_KPIS_B.color_rollup_type%TYPE
127: , p_weighted_color_method IN BSC_KPIS_B.weighted_color_method%TYPE
128: , p_need_color_recalc IN VARCHAR2 := 'Y'
129: , x_return_status OUT NOCOPY VARCHAR2
130: , x_msg_count OUT NOCOPY NUMBER

Line 127: , p_weighted_color_method IN BSC_KPIS_B.weighted_color_method%TYPE

123: , p_objective_id IN BSC_KPIS_B.indicator%TYPE
124: , p_obj_prototype_color_id IN BSC_KPIS_B.prototype_color_id%TYPE
125: , p_obj_prototype_trend_id IN BSC_KPIS_B.prototype_trend_id%TYPE
126: , p_color_rollup_type IN BSC_KPIS_B.color_rollup_type%TYPE
127: , p_weighted_color_method IN BSC_KPIS_B.weighted_color_method%TYPE
128: , p_need_color_recalc IN VARCHAR2 := 'Y'
129: , x_return_status OUT NOCOPY VARCHAR2
130: , x_msg_count OUT NOCOPY NUMBER
131: , x_msg_data OUT NOCOPY VARCHAR2

Line 138: FROM bsc_kpis_b

134: l_objective_rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
135:
136: CURSOR c_shared_obj(p_indicator NUMBER) IS
137: SELECT indicator
138: FROM bsc_kpis_b
139: WHERE source_indicator = p_indicator
140: AND share_flag = 2 -- shared objective.
141: AND prototype_flag <> 2;
142:

Line 250: , p_objective_id IN BSC_KPIS_B.indicator%TYPE

246: ************************************************************************************/
247:
248: PROCEDURE Create_Update_Kpi_Mes_Weights (
249: p_commit IN VARCHAR2 := FND_API.G_FALSE
250: , p_objective_id IN BSC_KPIS_B.indicator%TYPE
251: , p_kpi_measure_id IN BSC_KPI_ANALYSIS_MEASURES_B.kpi_measure_id%TYPE
252: , p_kpi_weight IN BSC_KPI_MEASURE_WEIGHTS.weight%TYPE
253: , x_return_status OUT NOCOPY VARCHAR2
254: , x_msg_count OUT NOCOPY NUMBER

Line 260: l_obj_prototype_flag BSC_KPIS_B.prototype_flag%TYPE;

256: )
257: IS
258: l_kpi_measure_weights_rec BSC_KPI_MEASURE_WEIGHTS_PUB.kpi_measure_weights_rec;
259: l_num VARCHAR(2);
260: l_obj_prototype_flag BSC_KPIS_B.prototype_flag%TYPE;
261: l_color_rollup_type BSC_KPIS_B.color_rollup_type%TYPE;
262: BEGIN
263:
264: FND_MSG_PUB.Initialize;

Line 261: l_color_rollup_type BSC_KPIS_B.color_rollup_type%TYPE;

257: IS
258: l_kpi_measure_weights_rec BSC_KPI_MEASURE_WEIGHTS_PUB.kpi_measure_weights_rec;
259: l_num VARCHAR(2);
260: l_obj_prototype_flag BSC_KPIS_B.prototype_flag%TYPE;
261: l_color_rollup_type BSC_KPIS_B.color_rollup_type%TYPE;
262: BEGIN
263:
264: FND_MSG_PUB.Initialize;
265: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 308: FROM bsc_kpis_b

304:
305: END IF;
306:
307: /*SELECT prototype_flag INTO l_obj_prototype_flag
308: FROM bsc_kpis_b
309: WHERE indicator = p_objective_id;*/
310:
311: SELECT bk.color_rollup_type, bk.prototype_flag
312: INTO l_color_rollup_type, l_obj_prototype_flag

Line 313: FROM bsc_db_color_ao_defaults_v dd, bsc_kpi_analysis_measures_vl km, bsc_kpis_b bk

309: WHERE indicator = p_objective_id;*/
310:
311: SELECT bk.color_rollup_type, bk.prototype_flag
312: INTO l_color_rollup_type, l_obj_prototype_flag
313: FROM bsc_db_color_ao_defaults_v dd, bsc_kpi_analysis_measures_vl km, bsc_kpis_b bk
314: WHERE km.indicator = p_objective_id AND
315: bk.indicator = km.indicator AND
316: km.indicator = dd.indicator AND
317: dd.a0_default = km.analysis_option0 AND

Line 378: p_objective_id IN BSC_KPIS_B.indicator%TYPE

374: /************************************************************************************
375: ************************************************************************************/
376:
377: PROCEDURE Obj_Prototype_Flag_Change (
378: p_objective_id IN BSC_KPIS_B.indicator%TYPE
379: , p_prototype_flag IN NUMBER
380: , x_return_status OUT NOCOPY VARCHAR2
381: , x_msg_count OUT NOCOPY NUMBER
382: , x_msg_data OUT NOCOPY VARCHAR2

Line 388: FROM bsc_kpis_b

384: IS
385:
386: CURSOR c_shared_obj(p_indicator NUMBER) IS
387: SELECT indicator
388: FROM bsc_kpis_b
389: WHERE source_indicator = p_indicator
390: AND share_flag = 2 -- shared objective.
391: AND prototype_flag <> 2;
392:

Line 457: p_objective_id IN BSC_KPIS_B.indicator%TYPE

453: /************************************************************************************
454: ************************************************************************************/
455:
456: PROCEDURE Kpi_Prototype_Flag_Change (
457: p_objective_id IN BSC_KPIS_B.indicator%TYPE
458: , p_kpi_measure_id IN BSC_KPI_ANALYSIS_MEASURES_B.kpi_measure_id%TYPE
459: , p_prototype_flag IN NUMBER
460: , x_return_status OUT NOCOPY VARCHAR2
461: , x_msg_count OUT NOCOPY NUMBER

Line 469: FROM bsc_kpis_b

465: l_kpi_measure_id NUMBER;
466:
467: CURSOR c_shared_obj(p_indicator NUMBER) IS
468: SELECT indicator
469: FROM bsc_kpis_b
470: WHERE source_indicator = p_indicator
471: AND share_flag = 2 -- shared objective.
472: AND prototype_flag <> 2;
473:

Line 550: p_objective_id IN BSC_KPIS_B.indicator%TYPE

546: /************************************************************************************
547: ************************************************************************************/
548:
549: PROCEDURE Change_Prototype_Flag (
550: p_objective_id IN BSC_KPIS_B.indicator%TYPE
551: , p_kpi_measure_id IN BSC_KPI_ANALYSIS_MEASURES_B.kpi_measure_id%TYPE
552: , p_prototype_flag IN NUMBER
553: , x_return_status OUT NOCOPY VARCHAR2
554: , x_msg_count OUT NOCOPY NUMBER

Line 558: l_obj_prototype_flag BSC_KPIS_B.prototype_flag%TYPE;

554: , x_msg_count OUT NOCOPY NUMBER
555: , x_msg_data OUT NOCOPY VARCHAR2
556: )
557: IS
558: l_obj_prototype_flag BSC_KPIS_B.prototype_flag%TYPE;
559: l_color_rollup_type BSC_KPIS_B.color_rollup_type%TYPE;
560: l_def_kpi_measure_id BSC_KPI_ANALYSIS_MEASURES_VL.kpi_measure_id%TYPE;
561: BEGIN
562:

Line 559: l_color_rollup_type BSC_KPIS_B.color_rollup_type%TYPE;

555: , x_msg_data OUT NOCOPY VARCHAR2
556: )
557: IS
558: l_obj_prototype_flag BSC_KPIS_B.prototype_flag%TYPE;
559: l_color_rollup_type BSC_KPIS_B.color_rollup_type%TYPE;
560: l_def_kpi_measure_id BSC_KPI_ANALYSIS_MEASURES_VL.kpi_measure_id%TYPE;
561: BEGIN
562:
563: FND_MSG_PUB.Initialize;

Line 578: FROM bsc_kpis_b

574: , x_msg_data => x_msg_data
575: );
576:
577: /*SELECT prototype_flag INTO l_obj_prototype_flag
578: FROM bsc_kpis_b
579: WHERE indicator = p_objective_id;*/
580:
581: SELECT bk.color_rollup_type, km.kpi_measure_id, bk.prototype_flag
582: INTO l_color_rollup_type, l_def_kpi_measure_id, l_obj_prototype_flag

Line 583: FROM bsc_db_color_ao_defaults_v dd, bsc_kpi_analysis_measures_vl km, bsc_kpis_b bk

579: WHERE indicator = p_objective_id;*/
580:
581: SELECT bk.color_rollup_type, km.kpi_measure_id, bk.prototype_flag
582: INTO l_color_rollup_type, l_def_kpi_measure_id, l_obj_prototype_flag
583: FROM bsc_db_color_ao_defaults_v dd, bsc_kpi_analysis_measures_vl km, bsc_kpis_b bk
584: WHERE km.indicator = p_objective_id AND
585: bk.indicator = km.indicator AND
586: km.indicator = dd.indicator AND
587: dd.a0_default = km.analysis_option0 AND

Line 649: , p_objective_id IN BSC_KPIS_B.indicator%TYPE

645: ************************************************************************************/
646:
647: PROCEDURE Save_Disable_Color_Of_Kpi (
648: p_commit IN VARCHAR2 := FND_API.G_FALSE
649: , p_objective_id IN BSC_KPIS_B.indicator%TYPE
650: , p_kpi_measure_id IN BSC_KPI_ANALYSIS_MEASURES_B.kpi_measure_id%TYPE
651: , p_disable_color IN BSC_KPI_MEASURE_PROPS.disable_color%TYPE
652: , p_need_color_recalc IN VARCHAR2 := 'N'
653: , x_return_status OUT NOCOPY VARCHAR2

Line 659: l_obj_prototype_flag BSC_KPIS_B.prototype_flag%TYPE;

655: , x_msg_data OUT NOCOPY VARCHAR2
656: )
657: IS
658: l_kpi_measure_rec BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec;
659: l_obj_prototype_flag BSC_KPIS_B.prototype_flag%TYPE;
660:
661: BEGIN
662:
663: FND_MSG_PUB.Initialize;