[Home] [Help]
13: /* TABLES TO BE COPIED BASED ON OBJECTIVE AND KPI_MEASURE_ID */
14: g_num_obj_kpi_metadata_tables := 0;
15:
16: g_num_obj_kpi_metadata_tables := g_num_obj_kpi_metadata_tables + 1;
17: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_name := 'BSC_KPI_ANALYSIS_MEASURES_B';
18: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_type := C_KPI_MEAS_TABLE;
19: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_column := C_INDICATOR;
20: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
21: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).mls_table := bsc_utility.NO;
80: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
81: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
82:
83: /*g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
84: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_ANALYSIS_MEASURES_B';
85: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
86: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
87: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;*/
88:
1154: WHERE INDICATOR = l_indicator;
1155:
1156: CURSOR c_analisys_measure IS
1157: SELECT B.SERIES_ID,F.FORMAT,DS.COLOR_METHOD
1158: FROM BSC_KPI_ANALYSIS_MEASURES_B B,BSC_SYS_FORMATS F,BSC_SYS_DATASETS_B DS
1159: WHERE INDICATOR = l_indicator
1160: AND B.ANALYSIS_OPTION0= h_a0
1161: AND B.ANALYSIS_OPTION1= h_a1
1162: AND B.ANALYSIS_OPTION2= h_a2
1277: SELECT NVL(SOURCE,'BSC')
1278: INTO h_Kpi_Measure_Source
1279: FROM BSC_SYS_DATASETS_B A,
1280: (SELECT DATASET_ID
1281: FROM BSC_KPI_ANALYSIS_MEASURES_B MS,
1282: BSC_DB_COLOR_AO_DEFAULTS_V DF
1283: WHERE ANALYSIS_OPTION0 = DF.A0_DEFAULT
1284: AND ANALYSIS_OPTION1 = DF.A1_DEFAULT
1285: AND ANALYSIS_OPTION2= DF.A2_DEFAULT
2064:
2065: END IF;
2066: END LOOP;
2067:
2068: l_ao_comb_sql := BSC_DESIGNER_PVT.Format_DbLink_String('SELECT distinct kpi_measure_id FROM bsc_kpi_analysis_measures_b');
2069: l_ao_comb_sql := l_ao_comb_sql || 'WHERE indicator = :1';
2070: OPEN c_src_ao_comb FOR l_ao_comb_sql USING p_src_kpi;
2071: LOOP
2072: FETCH c_src_ao_comb INTO l_src_kpi_measure_id;
2114: );
2115: END IF;
2116:
2117: -- Update Prototype flag for all KPIs for the Shared objective to re-calculate color (non-production)
2118: UPDATE bsc_kpi_analysis_measures_b
2119: SET prototype_flag = 7
2120: WHERE indicator = p_trg_kpi;
2121:
2122: EXCEPTION
2458:
2459: BEGIN
2460:
2461: IF p_objective_id IS NOT NULL AND p_kpi_measure_id IS NOT NULL THEN
2462: UPDATE bsc_kpi_analysis_measures_b
2463: SET prototype_flag = p_flag
2464: WHERE indicator = p_objective_id
2465: AND kpi_measure_id = p_kpi_measure_id;
2466: ELSIF p_objective_id IS NOT NULL THEN
2463: SET prototype_flag = p_flag
2464: WHERE indicator = p_objective_id
2465: AND kpi_measure_id = p_kpi_measure_id;
2466: ELSIF p_objective_id IS NOT NULL THEN
2467: UPDATE bsc_kpi_analysis_measures_b
2468: SET prototype_flag = p_flag
2469: WHERE indicator = p_objective_id;
2470: END IF;
2471: