1: PACKAGE BSC_KPI_MEASURE_WEIGHTS_PUB AS
2: /* $Header: BSCPKMWS.pls 120.0.12000000.1 2007/07/17 07:44:11 appldev noship $ */
3:
4: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_KPI_MEASURE_WEIGHTS_PUB';
5:
1: PACKAGE BSC_KPI_MEASURE_WEIGHTS_PUB AS
2: /* $Header: BSCPKMWS.pls 120.0.12000000.1 2007/07/17 07:44:11 appldev noship $ */
3:
4: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_KPI_MEASURE_WEIGHTS_PUB';
5:
6: TYPE kpi_measure_weights_rec IS RECORD (
7: objective_id BSC_KPI_MEASURE_WEIGHTS.indicator%TYPE
8: , kpi_measure_id BSC_KPI_MEASURE_WEIGHTS.kpi_measure_id%TYPE
3:
4: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_KPI_MEASURE_WEIGHTS_PUB';
5:
6: TYPE kpi_measure_weights_rec IS RECORD (
7: objective_id BSC_KPI_MEASURE_WEIGHTS.indicator%TYPE
8: , kpi_measure_id BSC_KPI_MEASURE_WEIGHTS.kpi_measure_id%TYPE
9: , weight BSC_KPI_MEASURE_WEIGHTS.weight%TYPE
10: , created_by BSC_KPI_MEASURE_WEIGHTS.created_by%TYPE
11: , creation_date BSC_KPI_MEASURE_WEIGHTS.creation_date%TYPE
4: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_KPI_MEASURE_WEIGHTS_PUB';
5:
6: TYPE kpi_measure_weights_rec IS RECORD (
7: objective_id BSC_KPI_MEASURE_WEIGHTS.indicator%TYPE
8: , kpi_measure_id BSC_KPI_MEASURE_WEIGHTS.kpi_measure_id%TYPE
9: , weight BSC_KPI_MEASURE_WEIGHTS.weight%TYPE
10: , created_by BSC_KPI_MEASURE_WEIGHTS.created_by%TYPE
11: , creation_date BSC_KPI_MEASURE_WEIGHTS.creation_date%TYPE
12: , last_updated_by BSC_KPI_MEASURE_WEIGHTS.last_updated_by%TYPE
5:
6: TYPE kpi_measure_weights_rec IS RECORD (
7: objective_id BSC_KPI_MEASURE_WEIGHTS.indicator%TYPE
8: , kpi_measure_id BSC_KPI_MEASURE_WEIGHTS.kpi_measure_id%TYPE
9: , weight BSC_KPI_MEASURE_WEIGHTS.weight%TYPE
10: , created_by BSC_KPI_MEASURE_WEIGHTS.created_by%TYPE
11: , creation_date BSC_KPI_MEASURE_WEIGHTS.creation_date%TYPE
12: , last_updated_by BSC_KPI_MEASURE_WEIGHTS.last_updated_by%TYPE
13: , last_update_date BSC_KPI_MEASURE_WEIGHTS.last_update_date%TYPE
6: TYPE kpi_measure_weights_rec IS RECORD (
7: objective_id BSC_KPI_MEASURE_WEIGHTS.indicator%TYPE
8: , kpi_measure_id BSC_KPI_MEASURE_WEIGHTS.kpi_measure_id%TYPE
9: , weight BSC_KPI_MEASURE_WEIGHTS.weight%TYPE
10: , created_by BSC_KPI_MEASURE_WEIGHTS.created_by%TYPE
11: , creation_date BSC_KPI_MEASURE_WEIGHTS.creation_date%TYPE
12: , last_updated_by BSC_KPI_MEASURE_WEIGHTS.last_updated_by%TYPE
13: , last_update_date BSC_KPI_MEASURE_WEIGHTS.last_update_date%TYPE
14: , last_update_login BSC_KPI_MEASURE_WEIGHTS.last_update_login%TYPE
7: objective_id BSC_KPI_MEASURE_WEIGHTS.indicator%TYPE
8: , kpi_measure_id BSC_KPI_MEASURE_WEIGHTS.kpi_measure_id%TYPE
9: , weight BSC_KPI_MEASURE_WEIGHTS.weight%TYPE
10: , created_by BSC_KPI_MEASURE_WEIGHTS.created_by%TYPE
11: , creation_date BSC_KPI_MEASURE_WEIGHTS.creation_date%TYPE
12: , last_updated_by BSC_KPI_MEASURE_WEIGHTS.last_updated_by%TYPE
13: , last_update_date BSC_KPI_MEASURE_WEIGHTS.last_update_date%TYPE
14: , last_update_login BSC_KPI_MEASURE_WEIGHTS.last_update_login%TYPE
15: );
8: , kpi_measure_id BSC_KPI_MEASURE_WEIGHTS.kpi_measure_id%TYPE
9: , weight BSC_KPI_MEASURE_WEIGHTS.weight%TYPE
10: , created_by BSC_KPI_MEASURE_WEIGHTS.created_by%TYPE
11: , creation_date BSC_KPI_MEASURE_WEIGHTS.creation_date%TYPE
12: , last_updated_by BSC_KPI_MEASURE_WEIGHTS.last_updated_by%TYPE
13: , last_update_date BSC_KPI_MEASURE_WEIGHTS.last_update_date%TYPE
14: , last_update_login BSC_KPI_MEASURE_WEIGHTS.last_update_login%TYPE
15: );
16:
9: , weight BSC_KPI_MEASURE_WEIGHTS.weight%TYPE
10: , created_by BSC_KPI_MEASURE_WEIGHTS.created_by%TYPE
11: , creation_date BSC_KPI_MEASURE_WEIGHTS.creation_date%TYPE
12: , last_updated_by BSC_KPI_MEASURE_WEIGHTS.last_updated_by%TYPE
13: , last_update_date BSC_KPI_MEASURE_WEIGHTS.last_update_date%TYPE
14: , last_update_login BSC_KPI_MEASURE_WEIGHTS.last_update_login%TYPE
15: );
16:
17: /************************************************************************************
10: , created_by BSC_KPI_MEASURE_WEIGHTS.created_by%TYPE
11: , creation_date BSC_KPI_MEASURE_WEIGHTS.creation_date%TYPE
12: , last_updated_by BSC_KPI_MEASURE_WEIGHTS.last_updated_by%TYPE
13: , last_update_date BSC_KPI_MEASURE_WEIGHTS.last_update_date%TYPE
14: , last_update_login BSC_KPI_MEASURE_WEIGHTS.last_update_login%TYPE
15: );
16:
17: /************************************************************************************
18: ************************************************************************************/
17: /************************************************************************************
18: ************************************************************************************/
19: PROCEDURE Create_Kpi_Measure_Weights (
20: p_commit IN VARCHAR2 := FND_API.G_FALSE
21: , p_kpi_measure_weights_rec IN BSC_KPI_MEASURE_WEIGHTS_PUB.kpi_measure_weights_rec
22: , p_cascade_shared IN BOOLEAN := TRUE
23: , x_return_status OUT NOCOPY VARCHAR2
24: , x_msg_count OUT NOCOPY NUMBER
25: , x_msg_data OUT NOCOPY VARCHAR2
28: /************************************************************************************
29: ************************************************************************************/
30: PROCEDURE Update_Kpi_Measure_Weights (
31: p_commit IN VARCHAR2 := FND_API.G_FALSE
32: , p_kpi_measure_weights_rec IN BSC_KPI_MEASURE_WEIGHTS_PUB.kpi_measure_weights_rec
33: , p_cascade_shared IN BOOLEAN := TRUE
34: , x_return_status OUT NOCOPY VARCHAR2
35: , x_msg_count OUT NOCOPY NUMBER
36: , x_msg_data OUT NOCOPY VARCHAR2
63: ************************************************************************************/
64: PROCEDURE Retrieve_Kpi_Measure_Weights (
65: p_objective_id IN NUMBER
66: , p_kpi_measure_id IN NUMBER
67: , x_kpi_measure_weights_rec OUT NOCOPY BSC_KPI_MEASURE_WEIGHTS_PUB.kpi_measure_weights_rec
68: , x_return_status OUT NOCOPY VARCHAR2
69: , x_msg_count OUT NOCOPY NUMBER
70: , x_msg_data OUT NOCOPY VARCHAR2
71: ) ;
70: , x_msg_data OUT NOCOPY VARCHAR2
71: ) ;
72:
73:
74: END BSC_KPI_MEASURE_WEIGHTS_PUB;