[Home] [Help]
PACKAGE: APPS.BSC_KPI_MEASURE_PROPS_PUB
Source
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
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
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 ************************************************************************************/
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
33 ) ;
34
35 PROCEDURE Create_Default_Kpi_Meas_Props (
36 p_commit IN VARCHAR2 := FND_API.G_FALSE
37 , p_objective_id IN NUMBER
38 , p_kpi_measure_id IN NUMBER
39 , p_cascade_shared IN BOOLEAN := TRUE
40 , x_return_status OUT NOCOPY VARCHAR2
41 , x_msg_count OUT NOCOPY NUMBER
42 , x_msg_data OUT NOCOPY VARCHAR2
43 );
44
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
54 );
55
56 /************************************************************************************
57 ************************************************************************************/
58 PROCEDURE Delete_Kpi_Measure_Props (
59 p_commit IN VARCHAR2:= FND_API.G_FALSE
60 , p_objective_id IN NUMBER
61 , p_kpi_measure_id IN NUMBER
62 , p_cascade_shared IN BOOLEAN := TRUE
63 , x_return_status OUT NOCOPY VARCHAR2
64 , x_msg_count OUT NOCOPY NUMBER
65 , x_msg_data OUT NOCOPY VARCHAR2
66 ) ;
67
68 /************************************************************************************
69 ************************************************************************************/
70 PROCEDURE Delete_Obj_Kpi_Measure_Props (
71 p_commit IN VARCHAR2:= FND_API.G_FALSE
72 , p_objective_id IN NUMBER
73 , p_cascade_shared IN BOOLEAN := TRUE
74 , x_return_status OUT NOCOPY VARCHAR2
75 , x_msg_count OUT NOCOPY NUMBER
76 , x_msg_data OUT NOCOPY VARCHAR2
77 ) ;
78
79 /************************************************************************************
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 ) ;
89
90 /************************************************************************************
91 ************************************************************************************/
92 FUNCTION get_shared_obj_kpi_measure (
93 p_objective_id IN NUMBER
94 , p_kpi_measure_id IN NUMBER
95 , p_shared_objective_id IN NUMBER
96 ) RETURN NUMBER;
97
98
99 END BSC_KPI_MEASURE_PROPS_PUB;