[Home] [Help]
606: ) RETURN BOOLEAN
607: IS
608: CURSOR c_obj_colors_count IS
609: SELECT COUNT(1)
610: FROM bsc_sys_objective_colors;
611:
612: CURSOR c_kpi_colors_count IS
613: SELECT COUNT(1)
614: FROM bsc_sys_kpi_colors;
642: IF l_kpi_color_count > 0 THEN
643: BEGIN
644:
645: INSERT INTO
646: bsc_sys_objective_colors
647: ( tab_id
648: , indicator
649: , dim_level1
650: , dim_level2
677: FROM bsc_sys_kpi_colors
678: ORDER BY tab_id, indicator;
679: EXCEPTION
680: WHEN OTHERS THEN
681: BSC_MESSAGE.Add( x_message => 'set_objective_color() failed upgrade data to bsc_sys_objective_colors' ||SQLERRM
682: , x_source => 'BSCCOLUB.pls'
683: , x_mode => 'I'
684: );
685: END;
787: IF NOT set_default_kpi_measure_id(x_error_msg) THEN
788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
789: END IF;
790:
791: -- From BSC_SYS_KPI_COLORS, we need to move all the colors to BSC_SYS_OBJECTIVE_COLORS
792: -- (based on DEFAULT_KPI rollup). We dont actually need to find the default KPI for an Objective.
793: -- Just simply moving all rows from BSC_SYS_KPI_COLORS to BSC_SYS_OBJECTIVE_COLORS will do.
794: IF NOT set_objective_color(x_error_msg) THEN
795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
789: END IF;
790:
791: -- From BSC_SYS_KPI_COLORS, we need to move all the colors to BSC_SYS_OBJECTIVE_COLORS
792: -- (based on DEFAULT_KPI rollup). We dont actually need to find the default KPI for an Objective.
793: -- Just simply moving all rows from BSC_SYS_KPI_COLORS to BSC_SYS_OBJECTIVE_COLORS will do.
794: IF NOT set_objective_color(x_error_msg) THEN
795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
796: END IF;
797: