DBA Data[Home] [Help]

APPS.BSC_KPI_MEASURE_PROPS_PUB dependencies on BSC_KPI_MEASURE_PROPS

Line 1: PACKAGE BSC_KPI_MEASURE_PROPS_PUB AS

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:

Line 4: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_KPI_MEASURE_PROPS_PUB';

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

Line 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

Line 9: , kpi_measure_id BSC_KPI_MEASURE_PROPS.kpi_measure_id%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

Line 10: , prototype_color BSC_KPI_MEASURE_PROPS.prototype_color_id%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

Line 11: , prototype_trend BSC_KPI_MEASURE_PROPS.prototype_trend_id%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

Line 12: , color_by_total BSC_KPI_MEASURE_PROPS.color_by_total%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

Line 13: , disable_color BSC_KPI_MEASURE_PROPS.disable_color%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

Line 14: , disable_trend BSC_KPI_MEASURE_PROPS.disable_trend%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

Line 15: , apply_color_flag BSC_KPI_MEASURE_PROPS.apply_color_flag%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

Line 16: , default_calculation BSC_KPI_MEASURE_PROPS.default_calculation%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

Line 17: , created_by BSC_KPI_MEASURE_PROPS.created_by%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

Line 18: , creation_date BSC_KPI_MEASURE_PROPS.creation_date%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: );

Line 19: , last_updated_by BSC_KPI_MEASURE_PROPS.last_updated_by%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: );
23:

Line 20: , last_update_date BSC_KPI_MEASURE_PROPS.last_update_date%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:
24: /************************************************************************************

Line 21: , last_update_login BSC_KPI_MEASURE_PROPS.last_update_login%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: /************************************************************************************
25: ************************************************************************************/

Line 28: , p_kpi_measure_rec IN BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec

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

Line 49: , p_kpi_measure_rec IN BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec

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

Line 84: , x_kpi_measure_rec OUT NOCOPY BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec

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

Line 99: END BSC_KPI_MEASURE_PROPS_PUB;

95: , p_shared_objective_id IN NUMBER
96: ) RETURN NUMBER;
97:
98:
99: END BSC_KPI_MEASURE_PROPS_PUB;