1: PACKAGE BSC_KPI_MEASURE_PROPS_PUB AS
2: /* $Header: BSCPKMPS.pls 120.1.12000000.1 2007/07/17 07:44:07 appldev noship $ */
3:
4: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_KPI_MEASURE_PROPS_PUB';
5:
1: PACKAGE BSC_KPI_MEASURE_PROPS_PUB AS
2: /* $Header: BSCPKMPS.pls 120.1.12000000.1 2007/07/17 07:44:07 appldev noship $ */
3:
4: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_KPI_MEASURE_PROPS_PUB';
5:
6: C_TREND_UNACC_DECREASE CONSTANT NUMBER := 3;
7: TYPE kpi_measure_props_rec IS RECORD (
8: objective_id BSC_KPI_MEASURE_PROPS.indicator%TYPE
4: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_KPI_MEASURE_PROPS_PUB';
5:
6: C_TREND_UNACC_DECREASE CONSTANT NUMBER := 3;
7: TYPE kpi_measure_props_rec IS RECORD (
8: objective_id BSC_KPI_MEASURE_PROPS.indicator%TYPE
9: , kpi_measure_id BSC_KPI_MEASURE_PROPS.kpi_measure_id%TYPE
10: , prototype_color BSC_KPI_MEASURE_PROPS.prototype_color_id%TYPE
11: , prototype_trend BSC_KPI_MEASURE_PROPS.prototype_trend_id%TYPE
12: , color_by_total BSC_KPI_MEASURE_PROPS.color_by_total%TYPE
5:
6: C_TREND_UNACC_DECREASE CONSTANT NUMBER := 3;
7: TYPE kpi_measure_props_rec IS RECORD (
8: objective_id BSC_KPI_MEASURE_PROPS.indicator%TYPE
9: , kpi_measure_id BSC_KPI_MEASURE_PROPS.kpi_measure_id%TYPE
10: , prototype_color BSC_KPI_MEASURE_PROPS.prototype_color_id%TYPE
11: , prototype_trend BSC_KPI_MEASURE_PROPS.prototype_trend_id%TYPE
12: , color_by_total BSC_KPI_MEASURE_PROPS.color_by_total%TYPE
13: , disable_color BSC_KPI_MEASURE_PROPS.disable_color%TYPE
6: C_TREND_UNACC_DECREASE CONSTANT NUMBER := 3;
7: TYPE kpi_measure_props_rec IS RECORD (
8: objective_id BSC_KPI_MEASURE_PROPS.indicator%TYPE
9: , kpi_measure_id BSC_KPI_MEASURE_PROPS.kpi_measure_id%TYPE
10: , prototype_color BSC_KPI_MEASURE_PROPS.prototype_color_id%TYPE
11: , prototype_trend BSC_KPI_MEASURE_PROPS.prototype_trend_id%TYPE
12: , color_by_total BSC_KPI_MEASURE_PROPS.color_by_total%TYPE
13: , disable_color BSC_KPI_MEASURE_PROPS.disable_color%TYPE
14: , disable_trend BSC_KPI_MEASURE_PROPS.disable_trend%TYPE
7: TYPE kpi_measure_props_rec IS RECORD (
8: objective_id BSC_KPI_MEASURE_PROPS.indicator%TYPE
9: , kpi_measure_id BSC_KPI_MEASURE_PROPS.kpi_measure_id%TYPE
10: , prototype_color BSC_KPI_MEASURE_PROPS.prototype_color_id%TYPE
11: , prototype_trend BSC_KPI_MEASURE_PROPS.prototype_trend_id%TYPE
12: , color_by_total BSC_KPI_MEASURE_PROPS.color_by_total%TYPE
13: , disable_color BSC_KPI_MEASURE_PROPS.disable_color%TYPE
14: , disable_trend BSC_KPI_MEASURE_PROPS.disable_trend%TYPE
15: , apply_color_flag BSC_KPI_MEASURE_PROPS.apply_color_flag%TYPE
8: objective_id BSC_KPI_MEASURE_PROPS.indicator%TYPE
9: , kpi_measure_id BSC_KPI_MEASURE_PROPS.kpi_measure_id%TYPE
10: , prototype_color BSC_KPI_MEASURE_PROPS.prototype_color_id%TYPE
11: , prototype_trend BSC_KPI_MEASURE_PROPS.prototype_trend_id%TYPE
12: , color_by_total BSC_KPI_MEASURE_PROPS.color_by_total%TYPE
13: , disable_color BSC_KPI_MEASURE_PROPS.disable_color%TYPE
14: , disable_trend BSC_KPI_MEASURE_PROPS.disable_trend%TYPE
15: , apply_color_flag BSC_KPI_MEASURE_PROPS.apply_color_flag%TYPE
16: , default_calculation BSC_KPI_MEASURE_PROPS.default_calculation%TYPE
9: , kpi_measure_id BSC_KPI_MEASURE_PROPS.kpi_measure_id%TYPE
10: , prototype_color BSC_KPI_MEASURE_PROPS.prototype_color_id%TYPE
11: , prototype_trend BSC_KPI_MEASURE_PROPS.prototype_trend_id%TYPE
12: , color_by_total BSC_KPI_MEASURE_PROPS.color_by_total%TYPE
13: , disable_color BSC_KPI_MEASURE_PROPS.disable_color%TYPE
14: , disable_trend BSC_KPI_MEASURE_PROPS.disable_trend%TYPE
15: , apply_color_flag BSC_KPI_MEASURE_PROPS.apply_color_flag%TYPE
16: , default_calculation BSC_KPI_MEASURE_PROPS.default_calculation%TYPE
17: , created_by BSC_KPI_MEASURE_PROPS.created_by%TYPE
10: , prototype_color BSC_KPI_MEASURE_PROPS.prototype_color_id%TYPE
11: , prototype_trend BSC_KPI_MEASURE_PROPS.prototype_trend_id%TYPE
12: , color_by_total BSC_KPI_MEASURE_PROPS.color_by_total%TYPE
13: , disable_color BSC_KPI_MEASURE_PROPS.disable_color%TYPE
14: , disable_trend BSC_KPI_MEASURE_PROPS.disable_trend%TYPE
15: , apply_color_flag BSC_KPI_MEASURE_PROPS.apply_color_flag%TYPE
16: , default_calculation BSC_KPI_MEASURE_PROPS.default_calculation%TYPE
17: , created_by BSC_KPI_MEASURE_PROPS.created_by%TYPE
18: , creation_date BSC_KPI_MEASURE_PROPS.creation_date%TYPE
11: , prototype_trend BSC_KPI_MEASURE_PROPS.prototype_trend_id%TYPE
12: , color_by_total BSC_KPI_MEASURE_PROPS.color_by_total%TYPE
13: , disable_color BSC_KPI_MEASURE_PROPS.disable_color%TYPE
14: , disable_trend BSC_KPI_MEASURE_PROPS.disable_trend%TYPE
15: , apply_color_flag BSC_KPI_MEASURE_PROPS.apply_color_flag%TYPE
16: , default_calculation BSC_KPI_MEASURE_PROPS.default_calculation%TYPE
17: , created_by BSC_KPI_MEASURE_PROPS.created_by%TYPE
18: , creation_date BSC_KPI_MEASURE_PROPS.creation_date%TYPE
19: , last_updated_by BSC_KPI_MEASURE_PROPS.last_updated_by%TYPE
12: , color_by_total BSC_KPI_MEASURE_PROPS.color_by_total%TYPE
13: , disable_color BSC_KPI_MEASURE_PROPS.disable_color%TYPE
14: , disable_trend BSC_KPI_MEASURE_PROPS.disable_trend%TYPE
15: , apply_color_flag BSC_KPI_MEASURE_PROPS.apply_color_flag%TYPE
16: , default_calculation BSC_KPI_MEASURE_PROPS.default_calculation%TYPE
17: , created_by BSC_KPI_MEASURE_PROPS.created_by%TYPE
18: , creation_date BSC_KPI_MEASURE_PROPS.creation_date%TYPE
19: , last_updated_by BSC_KPI_MEASURE_PROPS.last_updated_by%TYPE
20: , last_update_date BSC_KPI_MEASURE_PROPS.last_update_date%TYPE
13: , disable_color BSC_KPI_MEASURE_PROPS.disable_color%TYPE
14: , disable_trend BSC_KPI_MEASURE_PROPS.disable_trend%TYPE
15: , apply_color_flag BSC_KPI_MEASURE_PROPS.apply_color_flag%TYPE
16: , default_calculation BSC_KPI_MEASURE_PROPS.default_calculation%TYPE
17: , created_by BSC_KPI_MEASURE_PROPS.created_by%TYPE
18: , creation_date BSC_KPI_MEASURE_PROPS.creation_date%TYPE
19: , last_updated_by BSC_KPI_MEASURE_PROPS.last_updated_by%TYPE
20: , last_update_date BSC_KPI_MEASURE_PROPS.last_update_date%TYPE
21: , last_update_login BSC_KPI_MEASURE_PROPS.last_update_login%TYPE
14: , disable_trend BSC_KPI_MEASURE_PROPS.disable_trend%TYPE
15: , apply_color_flag BSC_KPI_MEASURE_PROPS.apply_color_flag%TYPE
16: , default_calculation BSC_KPI_MEASURE_PROPS.default_calculation%TYPE
17: , created_by BSC_KPI_MEASURE_PROPS.created_by%TYPE
18: , creation_date BSC_KPI_MEASURE_PROPS.creation_date%TYPE
19: , last_updated_by BSC_KPI_MEASURE_PROPS.last_updated_by%TYPE
20: , last_update_date BSC_KPI_MEASURE_PROPS.last_update_date%TYPE
21: , last_update_login BSC_KPI_MEASURE_PROPS.last_update_login%TYPE
22: );
15: , apply_color_flag BSC_KPI_MEASURE_PROPS.apply_color_flag%TYPE
16: , default_calculation BSC_KPI_MEASURE_PROPS.default_calculation%TYPE
17: , created_by BSC_KPI_MEASURE_PROPS.created_by%TYPE
18: , creation_date BSC_KPI_MEASURE_PROPS.creation_date%TYPE
19: , last_updated_by BSC_KPI_MEASURE_PROPS.last_updated_by%TYPE
20: , last_update_date BSC_KPI_MEASURE_PROPS.last_update_date%TYPE
21: , last_update_login BSC_KPI_MEASURE_PROPS.last_update_login%TYPE
22: );
23:
16: , default_calculation BSC_KPI_MEASURE_PROPS.default_calculation%TYPE
17: , created_by BSC_KPI_MEASURE_PROPS.created_by%TYPE
18: , creation_date BSC_KPI_MEASURE_PROPS.creation_date%TYPE
19: , last_updated_by BSC_KPI_MEASURE_PROPS.last_updated_by%TYPE
20: , last_update_date BSC_KPI_MEASURE_PROPS.last_update_date%TYPE
21: , last_update_login BSC_KPI_MEASURE_PROPS.last_update_login%TYPE
22: );
23:
24: /************************************************************************************
17: , created_by BSC_KPI_MEASURE_PROPS.created_by%TYPE
18: , creation_date BSC_KPI_MEASURE_PROPS.creation_date%TYPE
19: , last_updated_by BSC_KPI_MEASURE_PROPS.last_updated_by%TYPE
20: , last_update_date BSC_KPI_MEASURE_PROPS.last_update_date%TYPE
21: , last_update_login BSC_KPI_MEASURE_PROPS.last_update_login%TYPE
22: );
23:
24: /************************************************************************************
25: ************************************************************************************/
24: /************************************************************************************
25: ************************************************************************************/
26: PROCEDURE Create_Kpi_Measure_Props (
27: p_commit IN VARCHAR2 := FND_API.G_FALSE
28: , p_kpi_measure_rec IN BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec
29: , p_cascade_shared IN BOOLEAN := TRUE
30: , x_return_status OUT NOCOPY VARCHAR2
31: , x_msg_count OUT NOCOPY NUMBER
32: , x_msg_data OUT NOCOPY VARCHAR2
45: /************************************************************************************
46: ************************************************************************************/
47: PROCEDURE Update_Kpi_Measure_Props (
48: p_commit IN VARCHAR2 := FND_API.G_FALSE
49: , p_kpi_measure_rec IN BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec
50: , p_cascade_shared IN BOOLEAN := TRUE
51: , x_return_status OUT NOCOPY VARCHAR2
52: , x_msg_count OUT NOCOPY NUMBER
53: , x_msg_data OUT NOCOPY VARCHAR2
80: ************************************************************************************/
81: PROCEDURE Retrieve_Kpi_Measure_Props (
82: p_objective_id IN NUMBER
83: , p_kpi_measure_id IN NUMBER
84: , x_kpi_measure_rec OUT NOCOPY BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec
85: , x_return_status OUT NOCOPY VARCHAR2
86: , x_msg_count OUT NOCOPY NUMBER
87: , x_msg_data OUT NOCOPY VARCHAR2
88: ) ;
95: , p_shared_objective_id IN NUMBER
96: ) RETURN NUMBER;
97:
98:
99: END BSC_KPI_MEASURE_PROPS_PUB;