[Home] [Help]
PACKAGE: APPS.BSC_ANALYSIS_OPTION_PVT
Source
1 package BSC_ANALYSIS_OPTION_PVT as
2 /* $Header: BSCVANOS.pls 120.2 2005/10/03 07:00:17 adrao noship $ */
3 /*
4 +======================================================================================+
5 | Copyright (c) 2001 Oracle Corporation, Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +======================================================================================+
8 | FILENAME |
9 | BSCVANOS.pls |
10 | |
11 | Creation Date: |
12 | October 10, 2001 |
13 | |
14 | Creator: |
15 | Mario-Jair Campos |
16 | |
17 | Description: |
18 | |
19 | 14-JUN-2004 ADRAO Added API Refresh_Short_Names, to refresh short_names |
20 | when an Analysis Option is deleted for Enh#3691035 |
21 | |
22 | 02-jul-2004 rpenneru Modified for Enhancement#3532517 |
23 | 20-APR-2005 adrao added API Cascade_Series_Default_Value |
24 | 22-AUG-2005 Bug #4220400 ashankar added Set_Default_Analysis_Option and made |
25 | public the following APIs Initialize_Anal_Opt_Tbl and |
26 | Validate_If_single_Anal_Opt |
27 +======================================================================================+
28 */
29
30 C_API_UPDATE CONSTANT VARCHAR2(6) := 'UPDATE';
31 C_API_CREATE CONSTANT VARCHAR2(6) := 'CREATE';
32
33 procedure Create_Analysis_Options(
34 p_commit IN varchar2 -- := FND_API.G_FALSE
35 ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
36 ,x_return_status OUT NOCOPY varchar2
37 ,x_msg_count OUT NOCOPY number
38 ,x_msg_data OUT NOCOPY varchar2
39 );
40
41 procedure Retrieve_Analysis_Options
42 (
43 p_commit IN varchar2 -- := FND_API.G_FALSE
44 , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
45 , x_Anal_Opt_Rec IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
46 , p_data_source IN VARCHAR2
47 , x_return_status OUT NOCOPY varchar2
48 , x_msg_count OUT NOCOPY number
49 , x_msg_data OUT NOCOPY varchar2
50 );
51
52 procedure Update_Analysis_Options
53 (
54 p_commit IN varchar2 -- := FND_API.G_FALSE
55 , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
56 , p_data_source IN VARCHAR2
57 , x_return_status OUT NOCOPY VARCHAR2
58 , x_msg_count OUT NOCOPY NUMBER
59 , x_msg_data OUT NOCOPY VARCHAR2
60 );
61
62 procedure Delete_Analysis_Options(
63 p_commit IN varchar2 -- := FND_API.G_FALSE
64 ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
65 ,x_return_status OUT NOCOPY varchar2
66 ,x_msg_count OUT NOCOPY number
67 ,x_msg_data OUT NOCOPY varchar2
68 );
69
70 procedure Create_Analysis_Measures(
71 p_commit IN varchar2 -- := FND_API.G_FALSE
72 ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
73 ,x_return_status OUT NOCOPY varchar2
74 ,x_msg_count OUT NOCOPY number
75 ,x_msg_data OUT NOCOPY varchar2
76 );
77
78 procedure Retrieve_Analysis_Measures(
79 p_commit IN varchar2 -- := FND_API.G_FALSE
80 ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
81 ,x_Anal_Opt_Rec IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
82 ,x_return_status OUT NOCOPY varchar2
83 ,x_msg_count OUT NOCOPY number
84 ,x_msg_data OUT NOCOPY varchar2
85 );
86
87 procedure Update_Analysis_Measures(
88 p_commit IN varchar2 -- := FND_API.G_FALSE
89 ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
90 ,x_return_status OUT NOCOPY varchar2
91 ,x_msg_count OUT NOCOPY number
92 ,x_msg_data OUT NOCOPY varchar2
93 );
94
95 procedure Delete_Data_Series(
96 p_commit IN varchar2 -- := FND_API.G_FALSE
97 ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
98 ,x_return_status OUT NOCOPY varchar2
99 ,x_msg_count OUT NOCOPY number
100 ,x_msg_data OUT NOCOPY varchar2
101 );
102
103 procedure Delete_Analysis_Measures(
104 p_commit IN varchar2 -- := FND_API.G_FALSE
105 ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
106 ,x_return_status OUT NOCOPY varchar2
107 ,x_msg_count OUT NOCOPY number
108 ,x_msg_data OUT NOCOPY varchar2
109 );
110
111 function Delete_Analysis_Option(
112 p_kpi_id IN number
113 ,p_anal_option_id IN number
114 ,x_return_status OUT NOCOPY varchar2
115 ,x_msg_count OUT NOCOPY number
116 ,x_msg_data OUT NOCOPY varchar2
117 ,p_anal_group_id IN number DEFAULT 0
118 ) return varchar2;
119
120 /*********************************************************
121
122 /***********************************************************/
123 PROCEDURE Delete_Ana_Opt_Mult_Groups
124 ( p_commit IN VARCHAR2:=FND_API.G_FALSE
125 , p_Kpi_id IN BSC_KPIS_B.indicator%TYPE
126 , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
127 , p_max_group_count IN NUMBER
128 , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
129 , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
130 , x_return_status OUT NOCOPY VARCHAR2
131 , x_msg_count OUT NOCOPY NUMBER
132 , x_msg_data OUT NOCOPY VARCHAR2
133 );
134
135 PROCEDURE Synch_Kpi_Anal_Group
136 (
137 p_commit IN VARCHAR2:=FND_API.G_FALSE
138 , p_Kpi_Id IN BSC_KPIS_B.indicator%TYPE
139 , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
140 , x_return_status OUT NOCOPY VARCHAR2
141 , x_msg_count OUT NOCOPY NUMBER
142 , x_msg_data OUT NOCOPY VARCHAR2
143 );
144
145
146 PROCEDURE store_anal_opt_grp_count
147 ( p_kpi_id IN NUMBER
148 , x_Anal_Opt_Tbl IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
149 ) ;
150
151
152 -- Added for Start-to-End KPI Project, Bug#3691035
153 PROCEDURE Refresh_Short_Names (
154 p_Commit IN VARCHAR2
155 , p_Kpi_Id IN NUMBER
156 , x_Return_Status OUT NOCOPY VARCHAR2
157 , x_Msg_Count OUT NOCOPY NUMBER
158 , x_Msg_Data OUT NOCOPY VARCHAR2
159 );
160
161 PROCEDURE Validate_Custom_Measure
162 ( p_kpi_id IN BSC_OAF_ANALYSYS_OPT_COMB_V.INDICATOR%TYPE
163 , p_option0 IN BSC_OAF_ANALYSYS_OPT_COMB_V.ANALYSIS_OPTION0%TYPE
164 , p_option1 IN BSC_OAF_ANALYSYS_OPT_COMB_V.ANALYSIS_OPTION1%TYPE
165 , p_option2 IN BSC_OAF_ANALYSYS_OPT_COMB_V.ANALYSIS_OPTION2%TYPE
166 , p_series_id IN BSC_OAF_ANALYSYS_OPT_COMB_V.SERIES_ID%TYPE
167 , x_return_status OUT NOCOPY VARCHAR2
168 , x_msg_count OUT NOCOPY NUMBER
169 , x_msg_data OUT NOCOPY VARCHAR2
170 );
171 PROCEDURE delete_extra_series(
172 p_Bsc_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
173 , x_return_status OUT NOCOPY VARCHAR2
174 , x_msg_count OUT NOCOPY NUMBER
175 , x_msg_data OUT NOCOPY VARCHAR2
176 );
177
178 procedure Swap_Data_Series_Id(
179 p_commit IN varchar2 -- := FND_API.G_FALSE
180 ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
181 ,x_return_status OUT NOCOPY varchar2
182 ,x_msg_count OUT NOCOPY number
183 ,x_msg_data OUT NOCOPY varchar2
184 ) ;
185
186
187 -- added for Bug#4298940
188 PROCEDURE Cascade_Series_Default_Value (
189 p_Commit IN VARCHAR2
190 , p_Api_Mode IN VARCHAR2
191 , p_Kpi_Id IN NUMBER
192 , p_Option0 IN NUMBER
193 , p_Option1 IN NUMBER
194 , p_Option2 IN NUMBER
195 , p_Series_Id IN NUMBER
196 , p_Default_Value IN NUMBER
197 , x_Default_Value OUT NOCOPY NUMBER
198 , x_Return_Status OUT NOCOPY VARCHAR2
199 , x_Msg_Count OUT NOCOPY NUMBER
200 , x_Msg_Data OUT NOCOPY VARCHAR2
201 );
202
203
204 -- added for Bug#4324947
205 -- Returns the short_name of next associated Objective
206 -- of type AG only.
207 FUNCTION Get_Next_Associated_Obj_SN (
208 p_Dataset_ID IN NUMBER
209 ) RETURN VARCHAR2;
210
211 -- Modified API for Bug#4638384 - changed signature to add p_Comparison_Source
212 -- added for Bug#4324947
213 PROCEDURE Cascade_Data_Src_Values (
214 p_Commit IN VARCHAR2
215 , p_Measure_Short_Name IN VARCHAR2
216 , p_Empty_Source IN VARCHAR2
217 , p_Actual_Data_Source_Type IN VARCHAR2
218 , p_Actual_Data_Source IN VARCHAR2
219 , p_Function_Name IN VARCHAR2
220 , p_Enable_Link IN VARCHAR2
221 , p_Comparison_Source IN VARCHAR2
222 , x_Return_Status OUT NOCOPY VARCHAR2
223 , x_Msg_Count OUT NOCOPY NUMBER
224 , x_Msg_Data OUT NOCOPY VARCHAR2
225 );
226
227 FUNCTION Validate_If_single_Anal_Opt
228 (
229 p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
230
231 )RETURN BOOLEAN;
232
233 PROCEDURE Initialize_Anal_Opt_Tbl
234 (
235 p_Kpi_id IN BSC_KPIS_B.indicator%TYPE
236 , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
237 , p_max_group_count IN NUMBER
238 , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
239 , p_Anal_Det_Opt_Tbl IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Det_Tbl_Type
240 );
241
242 PROCEDURE Set_Default_Analysis_Option
243 (
244 p_commit IN VARCHAR2
245 , p_obj_id IN BSC_KPIS_B.indicator%TYPE
246 , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
247 , p_Anal_Grp_Id IN BSC_KPIS_B.ind_group_id%TYPE
248 , x_return_status OUT NOCOPY VARCHAR2
249 , x_msg_count OUT NOCOPY NUMBER
250 , x_msg_data OUT NOCOPY VARCHAR2
251 );
252
253
254
255 end BSC_ANALYSIS_OPTION_PVT;
256
257
258