APPS.BSC_COLOR_UPGRADE dependencies on BSC_KPIS_B

Line 59: UPDATE bsc_kpis_b

55: ) RETURN BOOLEAN
56: IS
57: BEGIN
58:
59: UPDATE bsc_kpis_b
60: SET color_rollup_type = 'DEFAULT_KPI',
61: last_update_date = SYSDATE,
62: last_updated_by = FND_GLOBAL.USER_ID
63: WHERE color_rollup_type IS NULL;

Line 82: UPDATE bsc_kpis_b

78: x_error_msg OUT NOCOPY VARCHAR2
79: ) RETURN BOOLEAN
80: IS
81: BEGIN
82: UPDATE bsc_kpis_b
83: SET prototype_color_id = DECODE(prototype_color,
84: 'G', 24865,
85: 'Y', 49919,
86: 'R', 192,

Line 118: FROM bsc_kpis_b

114:
115: IF (p_kpi_measure_id = p_default_kpi_measure_id) THEN
116: SELECT prototype_color_id
117: INTO l_prototype_color_id
118: FROM bsc_kpis_b
119: WHERE indicator = p_objective_id;
120: END IF;
121:
122: RETURN l_prototype_color_id;

Line 167: l_obj_sh_name BSC_KPIS_B.short_name%TYPE;

163: ) RETURN VARCHAR2
164: IS
165: l_disable_color VARCHAR2(1);
166: l_source VARCHAR2(10);
167: l_obj_sh_name BSC_KPIS_B.short_name%TYPE;
168:
169: CURSOR c_measure_source(pkpi_measure_id NUMBER) IS
170: SELECT source
171: FROM bsc_sys_datasets_b dts,

Line 178: FROM bsc_kpis_b

174: AND am.kpi_measure_id = pkpi_measure_id;
175:
176: CURSOR c_objective_short_name(pIndicator NUMBER) IS
177: SELECT short_name
178: FROM bsc_kpis_b
179: WHERE indicator = pIndicator;
180: BEGIN
181:
182: l_disable_color := 'T'; -- default to TRUE

Line 236: FROM bsc_kpis_b

232: ) RETURN NUMBER
233: IS
234: CURSOR c_objective_type(p_indicator NUMBER) IS
235: SELECT indicator_type
236: FROM bsc_kpis_b
237: WHERE indicator = p_indicator;
238: l_apply_color_flag NUMBER;
239: l_multi_series NUMBER;
240: BEGIN

Line 261: FROM bsc_kpis_b

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
260: SELECT apply_color_flag INTO l_apply_color_flag
261: FROM bsc_kpis_b
262: WHERE indicator = p_objective_id;
263: END IF;
264:
265: RETURN l_apply_color_flag;

Line 411: FROM bsc_kpis_b

407: IS
408: CURSOR c_obj_prototype_flag IS
409: SELECT DISTINCT indicator objective_id
410: , prototype_flag prototype_flag
411: FROM bsc_kpis_b
412: WHERE prototype_flag <> 2;
413: l_obj_prototype_flag_rec c_obj_prototype_flag%ROWTYPE;
414: l_default_kpi_measure_id bsc_kpi_measure_props.kpi_measure_id%TYPE;
415: l_update_flag BOOLEAN;

Line 757: -- Set BSC_KPIS_B.COLOR_ROLLUP_TYPE as DEFAULT_KPI for all existing Objectives

753: IS
754:
755: BEGIN
756:
757: -- Set BSC_KPIS_B.COLOR_ROLLUP_TYPE as DEFAULT_KPI for all existing Objectives
758: IF NOT set_default_color_rollup(x_error_msg) THEN
759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
760: END IF;
761:

Line 762: -- Set BSC_KPIS_B.PROTOTYPE_COLOR to BSC_SYS_COLORS_B.COLOR_ID instead of G,Y,R,X

758: IF NOT set_default_color_rollup(x_error_msg) THEN
759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
760: END IF;
761:
762: -- Set BSC_KPIS_B.PROTOTYPE_COLOR to BSC_SYS_COLORS_B.COLOR_ID instead of G,Y,R,X
763: IF NOT set_obj_prototype_color(x_error_msg) THEN
764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
765: END IF;
766:

Line 1104: FROM bsc_kpis_b

1100: x_msg_data VARCHAR2(2000);
1101:
1102: CURSOR c_objectives IS
1103: SELECT indicator, config_type
1104: FROM bsc_kpis_b
1105: WHERE prototype_flag <> 2;
1106:
1107: CURSOR c_anal_measures IS
1108: SELECT an.kpi_measure_id

Line 1211: FROM bsc_kpis_b

1207: ) RETURN BOOLEAN
1208: IS
1209: CURSOR c_old_sims IS
1210: SELECT indicator
1211: FROM bsc_kpis_b
1212: WHERE config_type = 7
1213: AND prototype_flag <> 2
1214: AND short_name IS NULL;
1215: