APPS.BSC_COLOR_UPGRADE dependencies on BSC_SYS_KPI_COLORS

Line 428: FROM bsc_sys_kpi_colors

424: l_update_flag := FALSE;
425:
426: SELECT COUNT(1)
427: INTO l_count
428: FROM bsc_sys_kpi_colors
429: WHERE kpi_measure_id IS NOT NULL
430: AND indicator = l_obj_prototype_flag_rec.objective_id;
431:
432: IF l_count = 0 THEN

Line 559: FROM bsc_sys_kpi_colors

555: ) RETURN BOOLEAN
556: IS
557: CURSOR c_default_kpi_color IS
558: SELECT DISTINCT indicator
559: FROM bsc_sys_kpi_colors
560: ORDER BY indicator;
561: l_default_kpi_color c_default_kpi_color%ROWTYPE;
562:
563: l_default_kpi_measure_id NUMBER;

Line 575: UPDATE bsc_sys_kpi_colors

571: x_error_msg := 'l_default_kpi_measure_id is NULL for Objective = ' || l_default_kpi_color.indicator || ' ;';
572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
573: END IF;
574: IF l_default_kpi_measure_id IS NOT NULL THEN
575: UPDATE bsc_sys_kpi_colors
576: SET kpi_measure_id = l_default_kpi_measure_id
577: WHERE indicator = l_default_kpi_color.indicator
578: AND kpi_measure_id IS NULL;
579: END IF;

Line 614: FROM bsc_sys_kpi_colors;

610: FROM bsc_sys_objective_colors;
611:
612: CURSOR c_kpi_colors_count IS
613: SELECT COUNT(1)
614: FROM bsc_sys_kpi_colors;
615:
616: l_obj_color_count NUMBER := 0;
617: l_kpi_color_count NUMBER := 0;
618: BEGIN

Line 677: FROM bsc_sys_kpi_colors

673: , period_id
674: , kpi_color
675: , kpi_trend
676: , kpi_measure_id
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

Line 785: -- We need to populate BSC_SYS_KPI_COLORS.KPI_MEASURE_ID with the default KPI for the

781: IS
782:
783: BEGIN
784:
785: -- We need to populate BSC_SYS_KPI_COLORS.KPI_MEASURE_ID with the default KPI for the
786: -- corresponding Objective.
787: IF NOT set_default_kpi_measure_id(x_error_msg) THEN
788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
789: END IF;

Line 791: -- From BSC_SYS_KPI_COLORS, we need to move all the colors to BSC_SYS_OBJECTIVE_COLORS

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;

Line 793: -- Just simply moving all rows from BSC_SYS_KPI_COLORS to BSC_SYS_OBJECTIVE_COLORS will do.

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: