eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.BSC_CALCULATIONS_PVT dependencies on BSC_KPI_CALCULATIONS

Line 25: p_indicator IN bsc_kpi_calculations.indicator%TYPE,

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

Line 26: p_calculation_id IN bsc_kpi_calculations.calculation_id%TYPE,

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: )

Line 37: DELETE bsc_kpi_calculations

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;
40:
41: END IF;

Line 53: p_indicator IN bsc_kpi_calculations.indicator%TYPE,

49:
50:
51:
52: PROCEDURE insert_objective_calculation (
53: p_indicator IN bsc_kpi_calculations.indicator%TYPE,
54: p_calculation_id IN bsc_kpi_calculations.calculation_id%TYPE,
55: p_user_level0 IN bsc_kpi_calculations.user_level0%TYPE,
56: p_user_level1 IN bsc_kpi_calculations.user_level1%TYPE,
57: p_user_level1_default IN bsc_kpi_calculations.user_level1_default%TYPE,

Line 54: p_calculation_id IN bsc_kpi_calculations.calculation_id%TYPE,

50:
51:
52: PROCEDURE insert_objective_calculation (
53: p_indicator IN bsc_kpi_calculations.indicator%TYPE,
54: p_calculation_id IN bsc_kpi_calculations.calculation_id%TYPE,
55: p_user_level0 IN bsc_kpi_calculations.user_level0%TYPE,
56: p_user_level1 IN bsc_kpi_calculations.user_level1%TYPE,
57: p_user_level1_default IN bsc_kpi_calculations.user_level1_default%TYPE,
58: p_user_level2 IN bsc_kpi_calculations.user_level2%TYPE,

Line 55: p_user_level0 IN bsc_kpi_calculations.user_level0%TYPE,

51:
52: PROCEDURE insert_objective_calculation (
53: p_indicator IN bsc_kpi_calculations.indicator%TYPE,
54: p_calculation_id IN bsc_kpi_calculations.calculation_id%TYPE,
55: p_user_level0 IN bsc_kpi_calculations.user_level0%TYPE,
56: p_user_level1 IN bsc_kpi_calculations.user_level1%TYPE,
57: p_user_level1_default IN bsc_kpi_calculations.user_level1_default%TYPE,
58: p_user_level2 IN bsc_kpi_calculations.user_level2%TYPE,
59: p_user_level2_default IN bsc_kpi_calculations.user_level2_default%TYPE,

Line 56: p_user_level1 IN bsc_kpi_calculations.user_level1%TYPE,

52: PROCEDURE insert_objective_calculation (
53: p_indicator IN bsc_kpi_calculations.indicator%TYPE,
54: p_calculation_id IN bsc_kpi_calculations.calculation_id%TYPE,
55: p_user_level0 IN bsc_kpi_calculations.user_level0%TYPE,
56: p_user_level1 IN bsc_kpi_calculations.user_level1%TYPE,
57: p_user_level1_default IN bsc_kpi_calculations.user_level1_default%TYPE,
58: p_user_level2 IN bsc_kpi_calculations.user_level2%TYPE,
59: p_user_level2_default IN bsc_kpi_calculations.user_level2_default%TYPE,
60: p_default_value IN bsc_kpi_calculations.default_value%TYPE,

Line 57: p_user_level1_default IN bsc_kpi_calculations.user_level1_default%TYPE,

53: p_indicator IN bsc_kpi_calculations.indicator%TYPE,
54: p_calculation_id IN bsc_kpi_calculations.calculation_id%TYPE,
55: p_user_level0 IN bsc_kpi_calculations.user_level0%TYPE,
56: p_user_level1 IN bsc_kpi_calculations.user_level1%TYPE,
57: p_user_level1_default IN bsc_kpi_calculations.user_level1_default%TYPE,
58: p_user_level2 IN bsc_kpi_calculations.user_level2%TYPE,
59: p_user_level2_default IN bsc_kpi_calculations.user_level2_default%TYPE,
60: p_default_value IN bsc_kpi_calculations.default_value%TYPE,
61: x_return_status OUT NOCOPY VARCHAR2,

Line 58: p_user_level2 IN bsc_kpi_calculations.user_level2%TYPE,

54: p_calculation_id IN bsc_kpi_calculations.calculation_id%TYPE,
55: p_user_level0 IN bsc_kpi_calculations.user_level0%TYPE,
56: p_user_level1 IN bsc_kpi_calculations.user_level1%TYPE,
57: p_user_level1_default IN bsc_kpi_calculations.user_level1_default%TYPE,
58: p_user_level2 IN bsc_kpi_calculations.user_level2%TYPE,
59: p_user_level2_default IN bsc_kpi_calculations.user_level2_default%TYPE,
60: p_default_value IN bsc_kpi_calculations.default_value%TYPE,
61: x_return_status OUT NOCOPY VARCHAR2,
62: x_msg_count OUT NOCOPY NUMBER,

Line 59: p_user_level2_default IN bsc_kpi_calculations.user_level2_default%TYPE,

55: p_user_level0 IN bsc_kpi_calculations.user_level0%TYPE,
56: p_user_level1 IN bsc_kpi_calculations.user_level1%TYPE,
57: p_user_level1_default IN bsc_kpi_calculations.user_level1_default%TYPE,
58: p_user_level2 IN bsc_kpi_calculations.user_level2%TYPE,
59: p_user_level2_default IN bsc_kpi_calculations.user_level2_default%TYPE,
60: p_default_value IN bsc_kpi_calculations.default_value%TYPE,
61: x_return_status OUT NOCOPY VARCHAR2,
62: x_msg_count OUT NOCOPY NUMBER,
63: x_msg_data OUT NOCOPY VARCHAR2

Line 60: p_default_value IN bsc_kpi_calculations.default_value%TYPE,

56: p_user_level1 IN bsc_kpi_calculations.user_level1%TYPE,
57: p_user_level1_default IN bsc_kpi_calculations.user_level1_default%TYPE,
58: p_user_level2 IN bsc_kpi_calculations.user_level2%TYPE,
59: p_user_level2_default IN bsc_kpi_calculations.user_level2_default%TYPE,
60: p_default_value IN bsc_kpi_calculations.default_value%TYPE,
61: x_return_status OUT NOCOPY VARCHAR2,
62: x_msg_count OUT NOCOPY NUMBER,
63: x_msg_data OUT NOCOPY VARCHAR2
64: )

Line 72: INTO bsc_kpi_calculations(INDICATOR,

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,
74: USER_LEVEL0,
75: USER_LEVEL1,
76: USER_LEVEL1_DEFAULT,