APPS.BSC_COLOR_CALC_UTIL dependencies on BSC_KPI_MEASURE_PROPS

Line 167: , p_kpi_measure_id IN bsc_kpi_measure_props.kpi_measure_id%TYPE

163:
164:
165: FUNCTION get_kpi_measure_weight (
166: p_objective_id IN bsc_kpis_b.indicator%TYPE
167: , p_kpi_measure_id IN bsc_kpi_measure_props.kpi_measure_id%TYPE
168: )
169: RETURN NUMBER IS
170: CURSOR c_kpi_measure_weight IS
171: SELECT weight

Line 303: FROM bsc_kpi_measure_props

299: AND indicator = p_indicator
300: AND tab_id = p_tab_id
301: UNION -- bsc_sys_kpi_colors may not contain a color entry for 'color enabled' KPIs for which data has not been loaded
302: SELECT kpi_measure_id, BSC_COLOR_REPOSITORY.NO_COLOR kpi_color
303: FROM bsc_kpi_measure_props
304: WHERE indicator = p_indicator
305: AND disable_color = 'F'
306: AND kpi_measure_id NOT IN
307: ( SELECT kpi_measure_id FROM bsc_sys_kpi_colors

Line 497: l_default_kpi_measure_id bsc_kpi_measure_props.kpi_measure_id%TYPE;

493: WHERE anal_meas.dataset_id = p_dataset_id
494: AND anal_meas.indicator = p_indicator;
495: l_default_kpi_rec c_default_kpi%ROWTYPE;
496:
497: l_default_kpi_measure_id bsc_kpi_measure_props.kpi_measure_id%TYPE;
498:
499: BEGIN
500:
501: l_default_kpi_measure_id := NULL;

Line 557: FROM bsc_kpi_measure_props

553: AND indicator = p_indicator
554: AND tab_id = p_tab_id
555: UNION -- bsc_sys_kpi_colors may not contain a color entry for 'color enabled' KPIs for which data has not been loaded
556: SELECT BSC_COLOR_REPOSITORY.NO_COLOR kpi_color, kpi_measure_id
557: FROM bsc_kpi_measure_props
558: WHERE indicator = p_indicator
559: AND disable_color = 'F'
560: AND kpi_measure_id NOT IN
561: ( SELECT kpi_measure_id FROM bsc_sys_kpi_colors

Line 568: l_default_kpi_measure_id bsc_kpi_measure_props.kpi_measure_id%TYPE;

564: );
565: l_kpi_colors c_kpi_colors%ROWTYPE;
566:
567: e_unexpected_error EXCEPTION;
568: l_default_kpi_measure_id bsc_kpi_measure_props.kpi_measure_id%TYPE;
569: l_colors BSC_UPDATE_UTIL.t_array_of_number;
570: l_kpi_measures BSC_UPDATE_UTIL.t_array_of_number;
571: l_color_index NUMBER;
572: l_obj_color NUMBER;

Line 946: l_default_kpi_measure_id bsc_kpi_measure_props.kpi_measure_id%TYPE;

942: AND m.a2 = d.a2_default
943: AND m.default_value = 1
944: AND m.indicator = p_indicator;
945:
946: l_default_kpi_measure_id bsc_kpi_measure_props.kpi_measure_id%TYPE;
947:
948: BEGIN
949:
950: l_default_kpi_measure_id := NULL;

Line 981: l_default_kpi_measure_id bsc_kpi_measure_props.kpi_measure_id%TYPE;

977: ,x_kpi_measure_id OUT NOCOPY NUMBER
978: ,x_color_flag OUT NOCOPY BOOLEAN
979: ) IS
980:
981: l_default_kpi_measure_id bsc_kpi_measure_props.kpi_measure_id%TYPE;
982:
983: BEGIN
984:
985: IF p_objective_color_rec.sim_flag THEN -- Simulation Objective