[Home] [Help]
21: +======================================================================================+
22: */
23:
24: PROCEDURE delete_objective_calculation (
25: p_indicator IN bsc_kpi_calculations.indicator%TYPE,
26: p_calculation_id IN bsc_kpi_calculations.calculation_id%TYPE,
27: x_return_status OUT NOCOPY VARCHAR2,
28: x_msg_count OUT NOCOPY NUMBER,
29: x_msg_data OUT NOCOPY VARCHAR2
22: */
23:
24: PROCEDURE delete_objective_calculation (
25: p_indicator IN bsc_kpi_calculations.indicator%TYPE,
26: p_calculation_id IN bsc_kpi_calculations.calculation_id%TYPE,
27: x_return_status OUT NOCOPY VARCHAR2,
28: x_msg_count OUT NOCOPY NUMBER,
29: x_msg_data OUT NOCOPY VARCHAR2
30: );
29: x_msg_data OUT NOCOPY VARCHAR2
30: );
31:
32: PROCEDURE insert_objective_calculation (
33: p_indicator IN bsc_kpi_calculations.indicator%TYPE,
34: p_calculation_id IN bsc_kpi_calculations.calculation_id%TYPE,
35: p_user_level0 IN bsc_kpi_calculations.user_level0%TYPE,
36: p_user_level1 IN bsc_kpi_calculations.user_level1%TYPE,
37: p_user_level1_default IN bsc_kpi_calculations.user_level1_default%TYPE,
30: );
31:
32: PROCEDURE insert_objective_calculation (
33: p_indicator IN bsc_kpi_calculations.indicator%TYPE,
34: p_calculation_id IN bsc_kpi_calculations.calculation_id%TYPE,
35: p_user_level0 IN bsc_kpi_calculations.user_level0%TYPE,
36: p_user_level1 IN bsc_kpi_calculations.user_level1%TYPE,
37: p_user_level1_default IN bsc_kpi_calculations.user_level1_default%TYPE,
38: p_user_level2 IN bsc_kpi_calculations.user_level2%TYPE,
31:
32: PROCEDURE insert_objective_calculation (
33: p_indicator IN bsc_kpi_calculations.indicator%TYPE,
34: p_calculation_id IN bsc_kpi_calculations.calculation_id%TYPE,
35: p_user_level0 IN bsc_kpi_calculations.user_level0%TYPE,
36: p_user_level1 IN bsc_kpi_calculations.user_level1%TYPE,
37: p_user_level1_default IN bsc_kpi_calculations.user_level1_default%TYPE,
38: p_user_level2 IN bsc_kpi_calculations.user_level2%TYPE,
39: p_user_level2_default IN bsc_kpi_calculations.user_level2_default%TYPE,
32: PROCEDURE insert_objective_calculation (
33: p_indicator IN bsc_kpi_calculations.indicator%TYPE,
34: p_calculation_id IN bsc_kpi_calculations.calculation_id%TYPE,
35: p_user_level0 IN bsc_kpi_calculations.user_level0%TYPE,
36: p_user_level1 IN bsc_kpi_calculations.user_level1%TYPE,
37: p_user_level1_default IN bsc_kpi_calculations.user_level1_default%TYPE,
38: p_user_level2 IN bsc_kpi_calculations.user_level2%TYPE,
39: p_user_level2_default IN bsc_kpi_calculations.user_level2_default%TYPE,
40: p_default_value IN bsc_kpi_calculations.default_value%TYPE,
33: p_indicator IN bsc_kpi_calculations.indicator%TYPE,
34: p_calculation_id IN bsc_kpi_calculations.calculation_id%TYPE,
35: p_user_level0 IN bsc_kpi_calculations.user_level0%TYPE,
36: p_user_level1 IN bsc_kpi_calculations.user_level1%TYPE,
37: p_user_level1_default IN bsc_kpi_calculations.user_level1_default%TYPE,
38: p_user_level2 IN bsc_kpi_calculations.user_level2%TYPE,
39: p_user_level2_default IN bsc_kpi_calculations.user_level2_default%TYPE,
40: p_default_value IN bsc_kpi_calculations.default_value%TYPE,
41: x_return_status OUT NOCOPY VARCHAR2,
34: p_calculation_id IN bsc_kpi_calculations.calculation_id%TYPE,
35: p_user_level0 IN bsc_kpi_calculations.user_level0%TYPE,
36: p_user_level1 IN bsc_kpi_calculations.user_level1%TYPE,
37: p_user_level1_default IN bsc_kpi_calculations.user_level1_default%TYPE,
38: p_user_level2 IN bsc_kpi_calculations.user_level2%TYPE,
39: p_user_level2_default IN bsc_kpi_calculations.user_level2_default%TYPE,
40: p_default_value IN bsc_kpi_calculations.default_value%TYPE,
41: x_return_status OUT NOCOPY VARCHAR2,
42: x_msg_count OUT NOCOPY NUMBER,
35: p_user_level0 IN bsc_kpi_calculations.user_level0%TYPE,
36: p_user_level1 IN bsc_kpi_calculations.user_level1%TYPE,
37: p_user_level1_default IN bsc_kpi_calculations.user_level1_default%TYPE,
38: p_user_level2 IN bsc_kpi_calculations.user_level2%TYPE,
39: p_user_level2_default IN bsc_kpi_calculations.user_level2_default%TYPE,
40: p_default_value IN bsc_kpi_calculations.default_value%TYPE,
41: x_return_status OUT NOCOPY VARCHAR2,
42: x_msg_count OUT NOCOPY NUMBER,
43: x_msg_data OUT NOCOPY VARCHAR2
36: p_user_level1 IN bsc_kpi_calculations.user_level1%TYPE,
37: p_user_level1_default IN bsc_kpi_calculations.user_level1_default%TYPE,
38: p_user_level2 IN bsc_kpi_calculations.user_level2%TYPE,
39: p_user_level2_default IN bsc_kpi_calculations.user_level2_default%TYPE,
40: p_default_value IN bsc_kpi_calculations.default_value%TYPE,
41: x_return_status OUT NOCOPY VARCHAR2,
42: x_msg_count OUT NOCOPY NUMBER,
43: x_msg_data OUT NOCOPY VARCHAR2
44: );