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_COLOR_UPGRADE dependencies on BSC_KPI_ANALYSIS_MEASURES_B

Line 12: FROM bsc_kpi_analysis_measures_b

8: IS
9:
10: CURSOR c_kpi_measure IS
11: SELECT DISTINCT indicator, analysis_option0, analysis_option1, analysis_option2, series_id
12: FROM bsc_kpi_analysis_measures_b
13: WHERE kpi_measure_id IS NULL
14: ORDER BY indicator, analysis_option0, analysis_option1, analysis_option2, series_id;
15: l_kpi_measure_rec c_kpi_measure%ROWTYPE;
16:

Line 24: UPDATE bsc_kpi_analysis_measures_b

20:
21: FOR l_kpi_measure_rec IN c_kpi_measure LOOP
22: BEGIN
23: SELECT bsc_kpi_measure_s.NEXTVAL INTO l_id from dual;
24: UPDATE bsc_kpi_analysis_measures_b
25: SET kpi_measure_id = l_id
26: WHERE indicator = l_kpi_measure_rec.indicator
27: AND analysis_option0 = l_kpi_measure_rec.analysis_option0
28: AND analysis_option1 = l_kpi_measure_rec.analysis_option1

Line 172: bsc_kpi_analysis_measures_b am

168:
169: CURSOR c_measure_source(pkpi_measure_id NUMBER) IS
170: SELECT source
171: FROM bsc_sys_datasets_b dts,
172: bsc_kpi_analysis_measures_b am
173: WHERE dts.dataset_id = am.dataset_id
174: AND am.kpi_measure_id = pkpi_measure_id;
175:
176: CURSOR c_objective_short_name(pIndicator NUMBER) IS

Line 253: -- For multi-series, get the budget_flag from bsc_kpi_analysis_measures_b and push to KPI level

249: FETCH c_objective_type INTO l_multi_series;
250: CLOSE c_objective_type;
251:
252: IF (l_multi_series = 10) THEN
253: -- For multi-series, get the budget_flag from bsc_kpi_analysis_measures_b and push to KPI level
254: SELECT budget_flag INTO l_apply_color_flag
255: FROM bsc_kpi_analysis_measures_b
256: WHERE indicator = p_objective_id
257: AND kpi_measure_id = p_kpi_measure_id;

Line 255: FROM bsc_kpi_analysis_measures_b

251:
252: IF (l_multi_series = 10) THEN
253: -- For multi-series, get the budget_flag from bsc_kpi_analysis_measures_b and push to KPI level
254: SELECT budget_flag INTO l_apply_color_flag
255: FROM bsc_kpi_analysis_measures_b
256: WHERE indicator = p_objective_id
257: AND kpi_measure_id = p_kpi_measure_id;
258: ELSE
259: -- For single-bar Objective, get the apply_color_flag from Objective and push to KPI level

Line 283: FROM bsc_kpi_analysis_measures_b

279: ) RETURN BOOLEAN
280: IS
281: CURSOR c_kpi_measure IS
282: SELECT indicator, kpi_measure_id
283: FROM bsc_kpi_analysis_measures_b
284: ORDER BY kpi_measure_id;
285: l_kpi_measure_rec c_kpi_measure%ROWTYPE;
286:
287: CURSOR c_kpi_measure_props_exist(p_indicator NUMBER, p_kpi_measure_id NUMBER) IS

Line 444: -- We will update bsc_kpi_analysis_measures_b.prototype_flag always irrespective of the fact

440: x_error_msg := 'l_default_kpi_measure_id is NULL for Objective = ' || l_obj_prototype_flag_rec.objective_id || ' ;';
441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
442: END IF;
443:
444: -- We will update bsc_kpi_analysis_measures_b.prototype_flag always irrespective of the fact
445: -- that whether this script has run before or not. We cannot check for prototype_flag = NULL
446: -- before updating this column, since this column will not be NULL because of a generic UPDATE
447: -- in bscup.sql to value 0. Anyway, updating this column everytime will not affect since we
448: -- are updating it to 7 (color re-calculate). Only for default KPI, we are picking the flag

Line 452: UPDATE bsc_kpi_analysis_measures_b

448: -- are updating it to 7 (color re-calculate). Only for default KPI, we are picking the flag
449: -- from the Objective level value when it is 0.
450: IF l_default_kpi_measure_id IS NOT NULL THEN
451:
452: UPDATE bsc_kpi_analysis_measures_b
453: SET prototype_flag = DECODE(l_obj_prototype_flag_rec.prototype_flag,
454: 0, 0,
455: 7)
456: WHERE indicator = l_obj_prototype_flag_rec.objective_id

Line 459: UPDATE bsc_kpi_analysis_measures_b

455: 7)
456: WHERE indicator = l_obj_prototype_flag_rec.objective_id
457: AND kpi_measure_id = l_default_kpi_measure_id;
458:
459: UPDATE bsc_kpi_analysis_measures_b
460: SET prototype_flag = 7
461: WHERE indicator = l_obj_prototype_flag_rec.objective_id
462: AND kpi_measure_id <> l_default_kpi_measure_id;
463:

Line 466: UPDATE bsc_kpi_analysis_measures_b

462: AND kpi_measure_id <> l_default_kpi_measure_id;
463:
464: ELSE
465:
466: UPDATE bsc_kpi_analysis_measures_b
467: SET prototype_flag = 7
468: WHERE indicator = l_obj_prototype_flag_rec.objective_id;
469:
470: END IF;

Line 719: -- Set KPI_Measure_Ids in BSC_KPI_ANALYSIS_MEASURES_B based on sequence

715: IS
716:
717: BEGIN
718:
719: -- Set KPI_Measure_Ids in BSC_KPI_ANALYSIS_MEASURES_B based on sequence
720: IF NOT set_kpi_measure_ids(x_error_msg) THEN
721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
722: END IF;
723:

Line 1110: FROM bsc_kpi_analysis_measures_b an

1106:
1107: CURSOR c_anal_measures IS
1108: SELECT an.kpi_measure_id
1109: ,ds.color_method
1110: FROM bsc_kpi_analysis_measures_b an
1111: ,bsc_sys_datasets_b ds
1112: WHERE an.dataset_id = ds.dataset_id
1113: AND an.indicator = l_indicator
1114: AND NOT EXISTS (SELECT