APPS.BSC_COLOR_CALC_UTIL dependencies on BSC_SYS_OBJECTIVE_COLORS

Line 356: INSERT INTO bsc_sys_objective_colors

352: RAISE e_unexpected_error;
353: END IF;
354: END IF;
355:
356: INSERT INTO bsc_sys_objective_colors
357: (tab_id, indicator, dim_level1, dim_level2, dim_level3, dim_level4, dim_level5, dim_level6, dim_level7, dim_level8, period_id, obj_color, driving_kpi_measure_id)
358: VALUES
359: (p_objective_color_rec.tab_id, p_objective_color_rec.objective_id,
360: l_dim_comb.dim_level1, l_dim_comb.dim_level2, l_dim_comb.dim_level3, l_dim_comb.dim_level4,

Line 609: INSERT INTO bsc_sys_objective_colors

605: ELSE
606: x_kpi_measure_id := -1;
607: END IF;
608:
609: INSERT INTO bsc_sys_objective_colors
610: (tab_id, indicator, dim_level1, dim_level2, dim_level3, dim_level4, dim_level5, dim_level6, dim_level7, dim_level8, period_id, obj_color, driving_kpi_measure_id)
611: VALUES
612: (p_objective_color_rec.tab_id, p_objective_color_rec.objective_id,
613: l_dim_comb.dim_level1, l_dim_comb.dim_level2, l_dim_comb.dim_level3, l_dim_comb.dim_level4,

Line 996: INTO bsc_sys_objective_colors

992: RAISE FND_API.G_EXC_ERROR;
993: END IF;
994:
995: INSERT /*+ append */
996: INTO bsc_sys_objective_colors
997: (tab_id, indicator, dim_level1, dim_level2, dim_level3, dim_level4, dim_level5, dim_level6, dim_level7, dim_level8, period_id, obj_color, driving_kpi_measure_id)
998: SELECT tab_id, indicator, dim_level1, dim_level2, dim_level3, dim_level4, dim_level5, dim_level6, dim_level7, dim_level8, period_id, kpi_color, kpi_measure_id
999: FROM bsc_sys_kpi_colors
1000: WHERE kpi_measure_id = l_default_kpi_measure_id