[Home] [Help]
43: l_user_level0 NUMBER;
44:
45: CURSOR c_def_val IS
46: SELECT default_value
47: FROM bsc_kpi_calculations
48: WHERE indicator = p_obj_id
49: AND calculation_id = l_calc_id;
50:
51: CURSOR c_shared_objectives IS
92: l_cnt := 0;
93: l_user_level0 := 2;
94:
95: SELECT count(0) INTO l_cnt
96: FROM bsc_kpi_calculations
97: WHERE indicator = p_obj_id
98: AND calculation_id = l_calc_id;
99:
100:
134: ,x_return_status => x_return_status
135: ,x_msg_count => x_msg_count
136: ,x_msg_data => x_msg_data
137: );
138: --DELETE bsc_kpi_calculations WHERE indicator = p_obj_id AND calculation_id = l_calc_id;
139:
140: BSC_CALCULATIONS_PVT.insert_objective_calculation (
141: p_indicator => p_obj_id
142: ,p_calculation_id => l_calc_id
149: ,x_return_status => x_return_status
150: ,x_msg_count => x_msg_count
151: ,x_msg_data => x_msg_data
152: );
153: -- INSERT INTO bsc_kpi_calculations(INDICATOR,CALCULATION_ID,USER_LEVEL0,USER_LEVEL1,USER_LEVEL1_DEFAULT,USER_LEVEL2,USER_LEVEL2_DEFAULT,DEFAULT_VALUE)
154: -- VALUES(p_obj_id,l_calc_id, l_user_level0,l_user_level0,NULL,NULL,NULL,l_def_val);
155:
156: -- Cascade the changes to shared objectives also.
157: FOR shared_ind_cd IN c_shared_objectives LOOP
276: l_user_level0 := 1;
277: l_user_level1 := 1;
278: l_def_value := 1;
279:
280: UPDATE bsc_kpi_calculations
281: SET USER_LEVEL0 = l_user_level0,
282: USER_LEVEL1 = l_user_level1,
283: DEFAULT_VALUE = l_def_value
284: WHERE indicator = p_obj_id AND calculation_id = 2;
284: WHERE indicator = p_obj_id AND calculation_id = 2;
285:
286: ELSE
287: l_def_value := 0;
288: UPDATE bsc_kpi_calculations
289: SET DEFAULT_VALUE = l_def_value
290: WHERE indicator = p_obj_id AND calculation_id = 2;
291:
292: END IF;
299: IF (cd.indicator IS NOT NULL) THEN
300: IF (p_ytd_as_default = 'Y') THEN
301: l_def_value := 1;
302:
303: UPDATE bsc_kpi_calculations
304: SET DEFAULT_VALUE = l_def_value
305: WHERE indicator = cd.indicator AND calculation_id = 2;
306:
307: ELSE
306:
307: ELSE
308: l_def_value := 0;
309:
310: UPDATE bsc_kpi_calculations
311: SET DEFAULT_VALUE = l_def_value
312: WHERE indicator = cd.indicator AND calculation_id = 2;
313:
314: END IF;
385: l_calc_enabled VARCHAR2(10);
386:
387:
388: CURSOR c_calcs (cp_calc_id NUMBER) IS
389: SELECT * FROM bsc_kpi_calculations where indicator = p_obj_id AND calculation_id = cp_calc_id;
390:
391: CURSOR c_all_calcs IS
392: SELECT * FROM bsc_kpi_calculations where indicator = p_obj_id;
393:
388: CURSOR c_calcs (cp_calc_id NUMBER) IS
389: SELECT * FROM bsc_kpi_calculations where indicator = p_obj_id AND calculation_id = cp_calc_id;
390:
391: CURSOR c_all_calcs IS
392: SELECT * FROM bsc_kpi_calculations where indicator = p_obj_id;
393:
394:
395: BEGIN
396:
455: END IF;
456:
457: ulvd2 := ulv1;
458:
459: UPDATE bsc_kpi_calculations
460: SET
461: user_level1 = ulv1,
462: user_level1_default = ulvd1,
463: user_level2_default = ulvd2
496: END IF;
497:
498: ulvd2 := ulv1;
499:
500: UPDATE bsc_kpi_calculations
501: SET
502: user_level1 = ulv1,
503: user_level1_default = ulvd1,
504: user_level2_default = ulvd2
569: l_default NUMBER;
570: l_result VARCHAR2(1);
571: CURSOR c_cal_def IS
572: SELECT default_value INTO l_default
573: FROM bsc_kpi_calculations
574: WHERE indicator = p_obj_id
575: AND calculation_id = p_cal_id;
576: BEGIN
577: l_result := 'N';