APPS.BSC_UPDATE_COLOR dependencies on BSC_KPI_MEASURE_PROPS

Line 43: FROM bsc_kpi_measure_props

39: ) RETURN BOOLEAN IS
40:
41: CURSOR c_default_calc IS
42: SELECT default_calculation
43: FROM bsc_kpi_measure_props
44: WHERE indicator = p_indicator
45: AND kpi_measure_id = p_kpi_measure_id;
46:
47: l_default_calc bsc_kpi_measure_props.default_calculation%TYPE;

Line 47: l_default_calc bsc_kpi_measure_props.default_calculation%TYPE;

43: FROM bsc_kpi_measure_props
44: WHERE indicator = p_indicator
45: AND kpi_measure_id = p_kpi_measure_id;
46:
47: l_default_calc bsc_kpi_measure_props.default_calculation%TYPE;
48: BEGIN
49: OPEN c_default_calc;
50: FETCH c_default_calc INTO l_default_calc;
51: CLOSE c_default_calc;

Line 83: FROM bsc_kpi_measure_props kpi_props,

79: CURSOR c_objective_kpis(p_indicator NUMBER) IS
80: SELECT kpi_props.kpi_measure_id,
81: kpi_props.disable_color,
82: sys_dset.source
83: FROM bsc_kpi_measure_props kpi_props,
84: bsc_kpi_analysis_measures_b kpi_meas,
85: bsc_sys_datasets_b sys_dset
86: WHERE kpi_props.indicator = p_indicator
87: AND kpi_props.kpi_measure_id = kpi_meas.kpi_measure_id

Line 209: l_color_by_total bsc_kpi_measure_props.color_by_total%TYPE;

205:
206: e_unexpected_error EXCEPTION;
207: l_kpi_dim_props BSC_UPDATE_UTIL.t_kpi_dim_props_rec;
208: l_measure_formula bsc_db_color_measures_v.measure_formula%TYPE;
209: l_color_by_total bsc_kpi_measure_props.color_by_total%TYPE;
210: l_apply_color_flag bsc_kpi_measure_props.apply_color_flag%TYPE;
211: l_calc_color_flag BOOLEAN;
212:
213: BEGIN

Line 210: l_apply_color_flag bsc_kpi_measure_props.apply_color_flag%TYPE;

206: e_unexpected_error EXCEPTION;
207: l_kpi_dim_props BSC_UPDATE_UTIL.t_kpi_dim_props_rec;
208: l_measure_formula bsc_db_color_measures_v.measure_formula%TYPE;
209: l_color_by_total bsc_kpi_measure_props.color_by_total%TYPE;
210: l_apply_color_flag bsc_kpi_measure_props.apply_color_flag%TYPE;
211: l_calc_color_flag BOOLEAN;
212:
213: BEGIN
214:

Line 1661: FROM bsc_kpi_measure_props kpi_meas

1657: ) RETURN BOOLEAN
1658: IS
1659: CURSOR c_objective_kpis(p_indicator NUMBER) IS
1660: SELECT kpi_measure_id
1661: FROM bsc_kpi_measure_props kpi_meas
1662: WHERE kpi_meas.indicator = p_indicator;
1663: l_objective_kpis c_objective_kpis%ROWTYPE;
1664:
1665: l_color_method NUMBER;

Line 3138: l_color_by_total bsc_kpi_measure_props.color_by_total%TYPE;

3134: h_obj_bind_vars_values_n BSC_UPDATE_UTIL.t_array_of_number;
3135: h_obj_num_bind_vars_n NUMBER;
3136: h_obj_sql VARCHAR2(3000);
3137: l_kpi_dim_props BSC_UPDATE_UTIL.t_kpi_dim_props_rec;
3138: l_color_by_total bsc_kpi_measure_props.color_by_total%TYPE;
3139: l_comparison BOOLEAN := false;
3140: l_values_obtained BOOLEAN := false;
3141:
3142: BEGIN