31: IS
32:
33: BEGIN
34: IF (p_indicator IS NOT NULL AND p_calculation_id IS NOT NULL) THEN
35: x_return_status := FND_API.G_RET_STS_SUCCESS;
36:
37: DELETE bsc_kpi_calculations
38: WHERE indicator = p_indicator
39: AND calculation_id = p_calculation_id;
41: END IF;
42:
43: EXCEPTION
44: WHEN OTHERS THEN
45: x_return_status := FND_API.G_RET_STS_ERROR;
46: RAISE;
47: END delete_objective_calculation;
48:
49:
65: IS
66:
67: BEGIN
68: IF (p_indicator IS NOT NULL AND p_calculation_id IS NOT NULL) THEN
69: x_return_status := FND_API.G_RET_STS_SUCCESS;
70:
71: INSERT
72: INTO bsc_kpi_calculations(INDICATOR,
73: CALCULATION_ID,
89: END IF;
90:
91: EXCEPTION
92: WHEN OTHERS THEN
93: x_return_status := FND_API.G_RET_STS_ERROR;
94: RAISE;
95: END insert_objective_calculation;
96:
97: