1 PACKAGE BIS_PMF_DEFINER_WRAPPER_PVT AS
2 /* $Header: BISVPFJS.pls 120.0 2005/06/01 15:29:24 appldev noship $ */
3 --
4 /*
5 REM +=======================================================================+
6 REM | Copyright (c) 2000 Oracle Corporation, Redwood Shores, CA, USA |
7 REM | All rights reserved. |
8 REM +=======================================================================+
9 REM | FILENAME |
10 REM | BISVPFJS.pls |
11 REM | |
12 REM | DESCRIPTION |
13 REM | Private API which can be called from Java Program for the |
14 REM | PMF definer. |
15 REM | |
16 REM | NOTES |
17 REM | |
18 REM | HISTORY |
19 REM | |
20 REM | JUL2000 jradhakr Creation |
21 REM | AUG2000 amkulkar Added wrapper for Targets CRUD |
22 REM | and Error Handling using the FND way!! |
23 REM | |
24 REM | 26-JUL-2002 rchandra Fixed for enh 2440739 |
25 REM | 30-JAN-03 sugopal FND_API.G_MISS_xxx should not be used in |
26 REM | initialization or declaration (bug#2774644) |
27 REM | 22-APR-2005 akoduri Enhancement#3865711 -- Obsolete Seeded Objects |
28 REM | 03-MAY-2005 akoduri Enh #4268374 -- Weighted Average Measures |
29 REM +=======================================================================+
30 */
31
32 --2440739
33 c_show_url CONSTANT VARCHAR2(1) := 'Y';
34 c_hide_url CONSTANT VARCHAR2(1) := 'N';
35 --2440739
36 c_default_appl NUMBER := -1; --2465354
37
38 Procedure Delete_Performance_Measure
39 (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
40 ,p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
41 ,x_return_status OUT NOCOPY VARCHAR2
42 ,x_msg_count OUT NOCOPY VARCHAR2
43 ,x_msg_data OUT NOCOPY VARCHAR2
44 );
45
46 Procedure Update_Performance_Measure
47 (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
48 ,p_Measure_Short_Name IN VARCHAR2
49 ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
50 ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
51 ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
52 ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
53 ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
54 ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
55 ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
56 ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
57 ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
58 ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
59 -- Fix for 1850860 starts here
60 ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
61 ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
62 ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
63 ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
64 ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
65 -- Fix for 1850860 ends here
66 ,p_enable_link IN VARCHAR2 := c_hide_url -- 2440739
67 ,p_obsolete IN VARCHAR2 := FND_API.G_FALSE --3865711
68 ,p_measure_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
69 ,p_application_id IN NUMBER := c_default_appl -- 2465354
70 ,x_return_status OUT NOCOPY VARCHAR2
71 ,x_msg_count OUT NOCOPY VARCHAR2
72 ,x_msg_data OUT NOCOPY VARCHAR2
73 );
74
75
76 Procedure Create_Performance_Measure
77 (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
78 ,p_Measure_Short_Name IN VARCHAR2
79 ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
80 ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
81 ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
82 ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
83 ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
84 ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
85 ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
86 ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
87 ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
88 ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
89 --Fix for 1850860 starts here
90 ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
91 ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
92 ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
93 ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
94 ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
95 -- Fix for 1850860 ends here
96 ,p_enable_link IN VARCHAR2 := c_hide_url -- 2440739
97 ,p_obsolete IN VARCHAR2 := FND_API.G_FALSE --3865711
98 ,p_measure_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
99 ,p_application_id IN NUMBER := c_default_appl --2465354
100 ,x_return_status OUT NOCOPY VARCHAR2
101 ,x_msg_count OUT NOCOPY VARCHAR2
102 ,x_msg_data OUT NOCOPY VARCHAR2
103 );
104 --
105 Procedure Delete_target_levels
106 (P_TARGET_LEVEL_ID IN NUMBER
107 ,p_force_delete IN NUMBER := 0 --gbhaloti #3148615
108 ,P_TARGET_LEVEL_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
109 ,x_return_status OUT NOCOPY VARCHAR2
110 ,x_msg_count OUT NOCOPY VARCHAR2
111 ,x_msg_data OUT NOCOPY VARCHAR2
112 );
113
114 Procedure Update_target_levels
115 (P_TARGET_LEVEL_ID IN NUMBER
116 ,P_TARGET_LEVEL_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
117 ,P_TARGET_LEVEL_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
118 ,P_DESCRIPTION IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
119 ,P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
120 ,P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
121 ,P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
122 ,P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
123 ,P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
124 ,P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
125 ,P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
126 ,P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
127 ,P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
128 ,P_WORKFLOW_PROCESS_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
129 ,P_DEFAULT_NOTIFY_RESP_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
130 ,P_DEFAULT_NOT_RESP_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
131 ,P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
132 ,P_COMPUTING_FUNCTION_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
133 ,P_REPORT_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
134 ,P_UNIT_OF_MEASURE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
135 ,p_SOURCE IN VARCHAR2
136 ,p_IS_SEED_USER IN VARCHAR2 := 'N' --2465354
137 ,x_return_status OUT NOCOPY VARCHAR2
138 ,x_msg_count OUT NOCOPY VARCHAR2
139 ,x_msg_data OUT NOCOPY VARCHAR2
140 );
141 --
142 Procedure Create_target_levels
143 (P_TARGET_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
144 ,P_TARGET_LEVEL_SHORT_NAME IN VARCHAR2
145 ,P_TARGET_LEVEL_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
146 ,P_DESCRIPTION IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
147 ,P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
148 ,P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
149 ,P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
150 ,P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
151 ,P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
152 ,P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
153 ,P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
154 ,P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
155 ,P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
156 ,P_WORKFLOW_PROCESS_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
157 ,P_DEFAULT_NOTIFY_RESP_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
158 ,P_DEFAULT_NOT_RESP_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
159 ,P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
160 ,P_COMPUTING_FUNCTION_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
161 ,P_REPORT_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
162 ,P_UNIT_OF_MEASURE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
163 ,p_SOURCE IN VARCHAR2
164 ,p_IS_SEED_USER IN VARCHAR2 := 'N' --2465354
165 ,x_return_status OUT NOCOPY VARCHAR2
166 ,x_msg_count OUT NOCOPY VARCHAR2
167 ,x_msg_data OUT NOCOPY VARCHAR2
168 );
169 --
170 Procedure Create_Measure_Security
171 (P_Target_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
172 ,P_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
173 ,P_Responsibility_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
174 ,P_Responsibility_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
175 ,P_Is_Seed_User IN VARCHAR2 := 'N' --2465354
176 ,x_return_status OUT NOCOPY VARCHAR2
177 ,x_msg_count OUT NOCOPY VARCHAR2
178 ,x_msg_data OUT NOCOPY VARCHAR2
179 );
180 --
181 Procedure Delete_Measure_Security
182 (P_Target_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
183 ,P_Responsibility_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
184 ,x_return_status OUT NOCOPY VARCHAR2
185 ,x_msg_count OUT NOCOPY VARCHAR2
186 ,x_msg_data OUT NOCOPY VARCHAR2
187 );
188 --
189 PROCEDURE CREATE_TARGET
190 (p_target_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
191 ,p_is_dbimeasure IN NUMBER := 0 --gbhaloti #3148615
192 ,p_target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
193 ,p_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
194 ,p_Target_Level_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
195 ,p_plan_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
196 ,p_plan_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
197 ,p_dim1_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
198 ,p_dim1_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
199 ,p_dim2_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
200 ,p_dim2_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
201 ,p_dim3_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
202 ,p_dim3_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
203 ,p_dim4_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
204 ,p_dim4_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
205 ,p_dim5_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
206 ,p_dim5_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
207 ,p_dim6_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
208 ,p_dim6_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
209 ,p_dim7_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
210 ,p_dim7_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
211 ,p_target IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
212 ,p_range1_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
213 ,p_range1_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
214 ,p_range2_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
215 ,p_range2_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
216 ,p_range3_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
217 ,p_range3_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
218 ,p_notify_resp1_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
219 ,p_notify_resp1_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
220 ,p_notify_resp1_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
224 ,p_notify_resp3_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
221 ,p_notify_resp2_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
222 ,p_notify_resp2_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
223 ,p_notify_resp2_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
225 ,p_notify_resp3_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
226 ,p_notify_resp3_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
227 ,x_return_status OUT NOCOPY VARCHAR2
228 ,x_msg_count OUt NOCOPY NUMBER
229 ,x_msg_data OUT NOCOPY VARCHAR2
230 );
231 --
232
233 --
234 PROCEDURE DELETE_TARGET
235 (p_target_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
236 ,p_Target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
237 ,p_target_level_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
238 ,x_return_Status OUT NOCOPY VARCHAR2
239 ,x_msg_count OUT NOCOPY NUMBER
240 ,x_msg_Data OUT NOCOPY VARCHAR2
241 );
242 --
243 PROCEDURE GET_TIME_LEVEL_ID
244 (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
245 ,p_target_level_id IN NUMBER
246 ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
247 ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
248 ,p_source IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
249 ,x_Sequence_no OUT NOCOPY NUMBER
250 ,x_dim_level_id OUT NOCOPY NUMBER
251 ,x_dim_level_short_name OUT NOCOPY VARCHAR2
252 ,x_dim_level_name OUT NOCOPY VARCHAR2
253 ,x_return_status OUT NOCOPY VARCHAR2
254 ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.ERROR_TBL_TYPE
255 );
256 --
257 PROCEDURE GET_TIME_LEVEL_ID
258 (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
259 ,p_target_level_id IN NUMBER
260 ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
261 ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
262 ,x_Sequence_no OUT NOCOPY NUMBER
263 ,x_dim_level_id OUT NOCOPY NUMBER
264 ,x_dim_level_short_name OUT NOCOPY VARCHAR2
265 ,x_dim_level_name OUT NOCOPY VARCHAR2
266 ,x_return_status OUT NOCOPY VARCHAR2
267 );
268 --
269 PROCEDURE GET_ORG_LEVEL_ID
270 (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
271 ,p_target_level_id IN NUMBER
272 ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
273 ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
274 ,p_source IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
275 ,x_Sequence_no OUT NOCOPY NUMBER
276 ,x_dim_level_id OUT NOCOPY NUMBER
277 ,x_dim_level_short_name OUT NOCOPY VARCHAR2
278 ,x_dim_level_name OUT NOCOPY VARCHAR2
279 ,x_return_status OUT NOCOPY VARCHAR2
280 ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.ERROR_TBL_TYPE
281 );
282 --
283 PROCEDURE GET_ORG_LEVEL_ID
284 (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
285 ,p_target_level_id IN NUMBER
286 ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
287 ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
288 ,x_sequence_no OUT NOCOPY NUMBER
289 ,x_dim_level_id OUT NOCOPY NUMBER
290 ,x_dim_level_short_name OUT NOCOPY VARCHAR2
291 ,x_dim_level_name OUT NOCOPY VARCHAR2
292 ,x_return_status OUT NOCOPY VARCHAR2
293 );
294 --
295 PROCEDURE ADD_TO_FND_MSG_STACK
296 (p_error_tbl IN BIS_UTILITIES_PUB.ERROR_TBL_TYPE
297 ,x_msg_count OUT NOCOPY NUMBER
298 ,x_msg_data OUT NOCOPY VARCHAR2
299 ,x_return_status OUT NOCOPY VARCHAR2
300 );
301 --added target level_id, changed name
302 FUNCTION BuildAlertRegURLTL
303 (p_measure_id IN NUMBER
304 ,p_target_level_id IN NUMBER
305 ,p_dim1_level_id IN NUMBER
306 ,p_dim2_level_id IN NUMBER
307 ,p_dim3_level_id IN NUMBER
308 ,p_dim4_level_id IN NUMBER
309 ,p_dim5_level_id IN NUMBER
310 ,p_dim6_level_id IN NUMBER
311 ,p_dim7_level_id IN NUMBER
312 )
313 RETURN VARCHAR2
314 ;
315 --changed name
316 --added this function for targets schedulealert
317 FUNCTION BuildAlertRegURLTarget
318 (p_measure_id IN NUMBER := NULL
319 ,p_plan_id IN VARCHAR2 := NULL
320 ,p_target_level_id IN NUMBER := NULL
321 ,p_parameter1levelId IN VARCHAR2 := NULL
322 ,p_parameter1ValueId IN VARCHAR2 := NULL
323 ,p_parameter2levelId IN VARCHAR2 := NULL
324 ,p_parameter2ValueId IN VARCHAR2 := NULL
325 ,p_parameter3levelId IN VARCHAR2 := NULL
326 ,p_parameter3ValueId IN VARCHAR2 := NULL
327 ,p_parameter4levelId IN VARCHAR2 := NULL
328 ,p_parameter4ValueId IN VARCHAR2 := NULL
329 ,p_parameter5levelId IN VARCHAR2 := NULL
330 ,p_parameter5ValueId IN VARCHAR2 := NULL
331 ,p_parameter6levelId IN VARCHAR2 := NULL
335 )
332 ,p_parameter6ValueId IN VARCHAR2 := NULL
333 ,p_parameter7levelId IN VARCHAR2 := NULL
334 ,p_parameter7ValueId IN VARCHAR2 := NULL
336 RETURN VARCHAR2
337 ;
338 PROCEDURE GET_TARGET_DETAILS
339 (p_measure_id IN NUMBER
340 ,p_measure_short_name IN VARCHAR2 DEFAULT NULL
341 ,p_user_id IN VARCHAR2
342 ,p_responsibility_id IN VARCHAR2
343 ,p_dim1_level_short_name IN VARCHAR2
344 ,p_dim2_level_short_name IN VARCHAR2
345 ,p_dim3_level_short_name IN VARCHAR2
346 ,p_Dim4_level_short_name IN VARCHAR2
347 ,p_dim5_level_short_name IN VARCHAR2
348 ,p_dim6_level_short_name IN VARCHAR2
349 ,p_dim7_level_short_name IN VARCHAR2
350 ,p_dim1_level_value_id IN VARCHAR2
351 ,P_dim2_level_value_id IN VARCHAR2
352 ,p_dim3_level_Value_id IN VARCHAR2
353 ,p_dim4_level_Value_id IN VARCHAR2
354 ,p_dim5_level_Value_id IN VARCHAR2
355 ,p_Dim6_level_value_id IN VARCHAR2
356 ,p_dim7_level_Value_id IN VARCHAR2
357 ,p_plan_id IN NUMBER
358 ,x_target_level_id OUT NOCOPY NUMBER
359 ,x_target_level_short_name OUT NOCOPY VARCHAR2
360 ,x_target_id OUT NOCOPY NUMBER
361 ,x_target_value OUT NOCOPY VARCHAR2
362 ,x_dim1_level_name OUT NOCOPY VARCHAR2
363 ,x_dim2_level_name OUT NOCOPY VARCHAR2
364 ,x_dim3_level_name OUT NOCOPY VARCHAR2
365 ,x_dim4_level_name OUT NOCOPY VARCHAR2
366 ,x_dim5_level_name OUT NOCOPY VARCHAR2
367 ,x_dim6_level_name OUT NOCOPY VARCHAR2
368 ,x_dim7_level_name OUT NOCOPY VARCHAR2
369 ,x_dim1_level_value_name OUT NOCOPY VARCHAR2
370 ,x_dim2_level_value_name OUT NOCOPY VARCHAR2
371 ,x_dim3_level_value_name OUT NOCOPY VARCHAR2
372 ,x_dim4_level_value_name OUT NOCOPY VARCHAR2
373 ,x_dim5_level_value_name OUT NOCOPY VARCHAR2
374 ,x_dim6_level_value_name OUT NOCOPY VARCHAR2
375 ,x_dim7_level_value_name OUT NOCOPY VARCHAR2
376 ,x_dim1_level_id OUT NOCOPY NUMBER
377 ,x_dim2_level_id OUT NOCOPY NUMBER
378 ,x_dim3_level_id OUT NOCOPY NUMBER
379 ,x_dim4_level_id OUT NOCOPY NUMBER
380 ,x_dim5_level_id OUT NOCOPY NUMBER
381 ,x_dim6_level_id OUT NOCOPY NUMBER
382 ,x_dim7_level_id OUT NOCOPY NUMBER
383 ,x_range1_low OUT NOCOPY NUMBER
384 ,x_range2_low OUT NOCOPY NUMBER
385 ,x_range3_low OUT NOCOPY NUMBER
386 ,x_range1_high OUT NOCOPY NUMBER
387 ,x_range2_high OUT NOCOPY NUMBER
388 ,x_range3_high OUT NOCOPY NUMBER
389 ,x_notify_resp1_id OUT NOCOPY NUMBER
390 ,x_notify_resp2_id OUT NOCOPY NUMBER
391 ,x_notify_resp3_id OUT NOCOPY NUMBER
392 ,x_notify_resp1_short_name OUT NOCOPY VARCHAR2
393 ,x_notify_resp2_short_name OUT NOCOPY VARCHAR2
394 ,x_notify_resp3_short_name OUT NOCOPY VARCHAR2
395 ,x_notify_resp1_name OUT NOCOPY VARCHAR2
396 ,x_notify_resp2_name OUT NOCOPY VARCHAR2
397 ,x_notify_resp3_name OUT NOCOPY VARCHAR2
398 ,x_show_subscribe_screen OUT NOCOPY VARCHAR2
399 ,x_msg_count OUT NOCOPY NUMBER
400 ,x_return_status OUT NOCOPY VARCHAR2
401 ,x_msg_data OUT NOCOPY VARCHAR2
402 ,x_measure_name OUT NOCOPY VARCHAR2
403 ,x_plan_name OUT NOCOPY VARCHAR2
404 ,x_measure_id OUT NOCOPY NUMBER
405 ,x_unit_of_measure OUT NOCOPY VARCHAR2
406 ,x_dim1_level_value_id OUT NOCOPY VARCHAR2
407 ,x_dim2_level_value_id OUT NOCOPY VARCHAR2
408 ,x_dim3_level_Value_id OUT NOCOPY VARCHAR2
409 ,x_dim4_level_Value_id OUT NOCOPY VARCHAR2
410 ,x_dim5_level_Value_id OUT NOCOPY VARCHAR2
411 ,x_Dim6_level_value_id OUT NOCOPY VARCHAR2
412 ,x_dim7_level_Value_id OUT NOCOPY VARCHAR2
413 ,x_dim1_level_short_name OUT NOCOPY VARCHAR2
414 ,x_dim2_level_short_name OUT NOCOPY VARCHAR2
415 ,x_dim3_level_short_name OUT NOCOPY VARCHAR2
416 ,x_Dim4_level_short_name OUT NOCOPY VARCHAR2
417 ,x_dim5_level_short_name OUT NOCOPY VARCHAR2
418 ,x_dim6_level_short_name OUT NOCOPY VARCHAR2
419 ,x_dim7_level_short_name OUT NOCOPY VARCHAR2
420 ,x_time_sequence_number OUT NOCOPY NUMBER
421 ,x_org_sequence_number OUT NOCOPY NUMBER
422 );
423 PROCEDURE UPDATE_MEASURE_SECURITY
424 (
425 p_target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM,
426 p_responsibilities IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR,
427 x_return_status OUT NOCOPY VARCHAR2,
428 x_msg_count OUT NOCOPY VARCHAR2,
429 x_msg_data OUT NOCOPY VARCHAR2
430 );
431 PROCEDURE GET_TARGET_LEVEL_NAMES
432 (
433 p_target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM,
434 x_measure_name OUT NOCOPY VARCHAR2,
435 x_dim_names OUT NOCOPY VARCHAR2,
436 x_return_status OUT NOCOPY VARCHAR2,
437 x_msg_count OUT NOCOPY VARCHAR2,
438 x_msg_data OUT NOCOPY VARCHAR2
439 );
440
441 FUNCTION HAS_TARGET_ACCESS
442 (
443 p_user_id IN NUMBER
444 ,p_measure_id IN NUMBER
445 ,p_target_level_id IN NUMBER
446 )
447 RETURN NUMBER;
448
449 -- Fix for 2126074 starts here
450
451 Procedure Retrieve_Performance_Measure
452 (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
453 ,p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
454 ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
455 ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
456 ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
457 ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
458 ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
459 ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
460 ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
461 ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
462 ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
463 ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
464 ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
465 ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
466 ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
467 ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
468 ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
469 ,x_return_status OUT NOCOPY VARCHAR2
470 ,x_msg_count OUT NOCOPY VARCHAR2
471 ,x_msg_data OUT NOCOPY VARCHAR2
472 ,x_Measure_ID OUT NOCOPY NUMBER
473 ,x_Measure_Short_Name OUT NOCOPY VARCHAR2
474 ,x_Measure_Name OUT NOCOPY VARCHAR2
475 ,x_Description OUT NOCOPY VARCHAR2
476 ,x_Dimension1_ID OUT NOCOPY NUMBER
477 ,x_Dimension2_ID OUT NOCOPY NUMBER
478 ,x_Dimension3_ID OUT NOCOPY NUMBER
479 ,x_Dimension4_ID OUT NOCOPY NUMBER
480 ,x_Dimension5_ID OUT NOCOPY NUMBER
481 ,x_Dimension6_ID OUT NOCOPY NUMBER
482 ,x_Dimension7_ID OUT NOCOPY NUMBER
483 ,x_Unit_Of_Measure_Class OUT NOCOPY VARCHAR2
484 ,x_actual_data_source_type OUT NOCOPY VARCHAR2
485 ,x_actual_data_source OUT NOCOPY VARCHAR2
486 --
487 ,x_region_code OUT NOCOPY VARCHAR2
488 ,x_attribute_code OUT NOCOPY VARCHAR2
489 --
490 ,x_function_name OUT NOCOPY VARCHAR2
491 ,x_comparison_source OUT NOCOPY VARCHAR2
492 ,x_increase_in_measure OUT NOCOPY VARCHAR2);
493
494 -- Fix for 2126074 ends here
495
496 -- overloaded with enable_link param for bug 2440739
497 Procedure Retrieve_Performance_Measure
498 (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
499 ,p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
500 ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
501 ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
502 ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
503 ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
504 ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
505 ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
506 ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
507 ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
508 ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
509 ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
510 ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
511 ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
512 ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
513 ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
514 ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
515 ,p_enable_link IN VARCHAR2 := c_hide_url
516 ,x_return_status OUT NOCOPY VARCHAR2
517 ,x_msg_count OUT NOCOPY VARCHAR2
518 ,x_msg_data OUT NOCOPY VARCHAR2
519 ,x_Measure_ID OUT NOCOPY NUMBER
520 ,x_Measure_Short_Name OUT NOCOPY VARCHAR2
521 ,x_Measure_Name OUT NOCOPY VARCHAR2
522 ,x_Description OUT NOCOPY VARCHAR2
523 ,x_Dimension1_ID OUT NOCOPY NUMBER
524 ,x_Dimension2_ID OUT NOCOPY NUMBER
525 ,x_Dimension3_ID OUT NOCOPY NUMBER
526 ,x_Dimension4_ID OUT NOCOPY NUMBER
527 ,x_Dimension5_ID OUT NOCOPY NUMBER
528 ,x_Dimension6_ID OUT NOCOPY NUMBER
529 ,x_Dimension7_ID OUT NOCOPY NUMBER
530 ,x_Unit_Of_Measure_Class OUT NOCOPY VARCHAR2
531 ,x_actual_data_source_type OUT NOCOPY VARCHAR2
532 ,x_actual_data_source OUT NOCOPY VARCHAR2
533 --
534 ,x_region_code OUT NOCOPY VARCHAR2
535 ,x_attribute_code OUT NOCOPY VARCHAR2
536 --
537 ,x_function_name OUT NOCOPY VARCHAR2
538 ,x_comparison_source OUT NOCOPY VARCHAR2
539 ,x_increase_in_measure OUT NOCOPY VARCHAR2
540 ,x_enable_link OUT NOCOPY VARCHAR2
541 );
542
543 END BIS_PMF_DEFINER_WRAPPER_PVT;
[Home] [Help]