[Home] [Help]
PACKAGE: APPS.BSC_KPI_MEASURE_WEIGHTS_PUB
Source
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
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 /************************************************************************************
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
26 ) ;
27
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
37 );
38
39 /************************************************************************************
40 ************************************************************************************/
41 PROCEDURE Del_Kpi_Measure_Weights (
42 p_commit IN VARCHAR2:= FND_API.G_FALSE
43 , p_objective_id IN NUMBER
44 , p_kpi_measure_id IN NUMBER
45 , p_cascade_shared IN BOOLEAN := TRUE
46 , x_return_status OUT NOCOPY VARCHAR2
47 , x_msg_count OUT NOCOPY NUMBER
48 , x_msg_data OUT NOCOPY VARCHAR2
49 ) ;
50
51 /************************************************************************************
52 ************************************************************************************/
53 PROCEDURE Del_Obj_Kpi_Measure_Weights (
54 p_commit IN VARCHAR2:= FND_API.G_FALSE
55 , p_objective_id IN NUMBER
56 , p_cascade_shared IN BOOLEAN := TRUE
57 , x_return_status OUT NOCOPY VARCHAR2
58 , x_msg_count OUT NOCOPY NUMBER
59 , x_msg_data OUT NOCOPY VARCHAR2
60 ) ;
61
62 /************************************************************************************
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 ) ;
72
73
74 END BSC_KPI_MEASURE_WEIGHTS_PUB;