1 PACKAGE BIS_WEIGHTED_MEASURE_PUB AS
2 /* $Header: BISPWMES.pls 120.2.12000000.2 2007/01/31 11:09:58 akoduri ship $ */
3 /*======================================================================================+
4 | Copyright (c) 2001 Oracle Corporation, Redwood Shores, CA, USA |
5 | All rights reserved. |
6 +======================================================================================+
7 | FILENAME |
8 | BISPWMES.pls |
9 | |
10 | Creation Date: |
11 | April 11, 2005 |
12 | Creator: |
13 | William Cano |
14 | |
15 | Description: |
16 | Public spec version. |
17 | This package creates a BSC Scorecard |
18 | |
19 | 05/12/05 jxyu added Set_Weights_Data API. |
20 | 07/12/05 sawu Bug#4482736: added Get_Dep_KPI_Format_Mask |
21 | 09/15/05 jxyu Bug# 4427932: added Update_WM_Last_Update_Info API |
22 | 01/11/07 akoduri Bug# 5594225: Performance issue in Mass Update UI |
23 +======================================================================================*/
24
25 -- Abbreviation Used"
26 -- WM -> Weighted Measure
27 -- SN -> Short Name
28
29 TYPE Bis_WM_Rec is RECORD(
30 ---------------------- BIS_WEIGHTED_MEASURE_DEPENDENCIES
31 weighted_measure_id BIS_WEIGHTED_MEASURE_DEPENDS.weighted_measure_id%TYPE
32 ,dependent_measure_id BIS_WEIGHTED_MEASURE_DEPENDS.dependent_measure_id%TYPE
33 ------------------------ BIS_WEIGHTED_MEASURE_DEFINITIONS
34 ,weighted_definition_id BIS_WEIGHTED_MEASURE_DEFNS.weighted_definition_id%TYPE
35 --weighted_measure_id BIS_WEIGHTED_MEASURE_DEPENDS.weighted_measure_id%TYPE
36 ,viewby_dimension_sn BIS_WEIGHTED_MEASURE_DEFNS.viewby_dimension_short_name%TYPE
37 ,viewby_dim_level_sn BIS_WEIGHTED_MEASURE_DEFNS.viewby_dim_level_short_name%TYPE
38 ,filter_dimension_sn BIS_WEIGHTED_MEASURE_DEFNS.filter_dimension_short_name%TYPE
39 ,filter_dim_level_sn BIS_WEIGHTED_MEASURE_DEFNS.filter_dim_level_short_name%TYPE
40 ,time_dimension_short_name BIS_WEIGHTED_MEASURE_DEFNS.time_dimension_short_name%TYPE
41 ,time_dim_level_short_name BIS_WEIGHTED_MEASURE_DEFNS.time_dim_level_short_name%TYPE
42 ---------------------------- BIS_WEIGHTED_MEASURE_PARAMETERS
43 ,weighted_parameter_id BIS_WEIGHTED_MEASURE_PARAMS.weighted_parameter_id%TYPE
44 --,weighted_definition_id BIS_WEIGHTED_MEASURE_DEFNS.weighted_definition_id%TYPE
45 ,time_level_value_id BIS_WEIGHTED_MEASURE_PARAMS.time_level_value_id%TYPE
46 ,filter_level_value_id BIS_WEIGHTED_MEASURE_PARAMS.filter_level_value_id%TYPE
47 ----------------------------- BIS_WEIGHTED_MEASURE_WEIGHTS
48 ,weight_id bis_weighted_measure_weights.weight_id%TYPE
49 --,weighted_parameter_id BIS_WEIGHTED_MEASURE_PARAMS.weighted_parameter_id%TYPE
50 --,dependent_measure_id bis_weighted_measure_weights.dependent_measure_id%TYPE
51 ,weight bis_weighted_measure_weights.weight%TYPE
52 -------------------------- BIS_WEIGHTED_MEASURE_SCORES
53 --,weight_id bis_weighted_measure_weights.weight_id%TYPE
54 ,low_range bis_weighted_measure_scores.low_range%TYPE
55 ,high_range bis_weighted_measure_scores.high_range%TYPE
56 ,score bis_weighted_measure_scores.score%TYPE
57 --------------------------- Who Columns
58 , Creation_Date DATE -- WHO COLUMN
59 , Created_By NUMBER -- WHO COLUMN
60 , Last_Update_Date DATE -- WHO COLUMN
61 , Last_Updated_By NUMBER -- WHO COLUMN
62 , Last_Update_Login NUMBER -- WHO COLUMN
63
64 );
65
66 TYPE Bis_WM_Rec_Tbl IS TABLE OF Bis_WM_Rec
67 INDEX BY BINARY_INTEGER;
68
69 DEFAULT_TIME_LEVEL_VALUE VARCHAR2(30) := 'DEFAULT';
70 DEFAULT_FILTER_LEVEL_VALUE VARCHAR2(30) := 'DEFAULT';
71
72 G_POSITIVE_WEIGHTS VARCHAR2(1) := 'P';
73 G_ZERO_WEIGHTS VARCHAR2(1) := 'Z';
74 G_NO_WEIGHTS VARCHAR2(1) := 'N';
75
76 /*
77 -- This is tempporal whil it is tested
78 PROCEDURE Delete_Cascade_WM_Parameters(
79 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
80 ,p_weighted_definition_id IN NUMBER
81 ,x_return_status OUT NOCOPY VARCHAR2
82 ,x_msg_count OUT NOCOPY NUMBER
83 ,x_msg_data OUT NOCOPY VARCHAR2
84 ) ;
85 */
86
87 ------- APIs for tables BIS_WEIGHTED_MEASURE_DEPENDS
88
89 PROCEDURE Create_WM_Dependency(
90 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
91 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
92 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
93 ,x_return_status OUT NOCOPY VARCHAR2
94 ,x_msg_count OUT NOCOPY NUMBER
95 ,x_msg_data OUT NOCOPY VARCHAR2
96 );
97
98 PROCEDURE Retrieve_WM_Dependency(
99 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
100 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
101 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
102 ,x_return_status OUT NOCOPY VARCHAR2
103 ,x_msg_count OUT NOCOPY NUMBER
104 ,x_msg_data OUT NOCOPY VARCHAR2
105 );
106
107 PROCEDURE Update_WM_Dependency(
108 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
109 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
110 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
111 ,x_return_status OUT NOCOPY VARCHAR2
112 ,x_msg_count OUT NOCOPY NUMBER
113 ,x_msg_data OUT NOCOPY VARCHAR2
114 );
115
116 PROCEDURE Delete_WM_Dependency(
117 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
118 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
119 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
120 ,x_return_status OUT NOCOPY VARCHAR2
121 ,x_msg_count OUT NOCOPY NUMBER
122 ,x_msg_data OUT NOCOPY VARCHAR2
123 );
124
125 ------- APIs for table BIS_WEIGHTED_MEASURE_DEFNS
126
127 PROCEDURE Create_WM_Definition(
128 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
129 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
130 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
131 ,x_return_status OUT NOCOPY VARCHAR2
132 ,x_msg_count OUT NOCOPY NUMBER
133 ,x_msg_data OUT NOCOPY VARCHAR2
134 );
135
136 PROCEDURE Retrieve_WM_Definition(
137 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
138 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
139 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
140 ,x_return_status OUT NOCOPY VARCHAR2
141 ,x_msg_count OUT NOCOPY NUMBER
142 ,x_msg_data OUT NOCOPY VARCHAR2
143 );
144
145 PROCEDURE Update_WM_Definition(
146 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
147 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
148 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
149 ,x_return_status OUT NOCOPY VARCHAR2
150 ,x_msg_count OUT NOCOPY NUMBER
151 ,x_msg_data OUT NOCOPY VARCHAR2
152 );
153
154 PROCEDURE Delete_WM_Definition(
155 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
156 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
157 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
158 ,x_return_status OUT NOCOPY VARCHAR2
159 ,x_msg_count OUT NOCOPY NUMBER
160 ,x_msg_data OUT NOCOPY VARCHAR2
161 );
162
163 ------- APIs for table BIS_WEIGHTED_MEASURE_PARAMS
164
165 PROCEDURE Create_WM_Parameter(
166 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
167 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
168 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
169 ,x_return_status OUT NOCOPY VARCHAR2
170 ,x_msg_count OUT NOCOPY NUMBER
171 ,x_msg_data OUT NOCOPY VARCHAR2
172 );
173
174 PROCEDURE Retrieve_WM_Parameter(
175 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
176 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
177 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
178 ,x_return_status OUT NOCOPY VARCHAR2
179 ,x_msg_count OUT NOCOPY NUMBER
180 ,x_msg_data OUT NOCOPY VARCHAR2
181 );
182
183 PROCEDURE Update_WM_Parameter(
184 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
185 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
186 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
187 ,x_return_status OUT NOCOPY VARCHAR2
188 ,x_msg_count OUT NOCOPY NUMBER
189 ,x_msg_data OUT NOCOPY VARCHAR2
190 );
191
192 PROCEDURE Delete_WM_Parameter(
193 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
194 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
195 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
196 ,x_return_status OUT NOCOPY VARCHAR2
197 ,x_msg_count OUT NOCOPY NUMBER
198 ,x_msg_data OUT NOCOPY VARCHAR2
199 );
200
201 ------- APIs for table BIS_WEIGHTED_MEASURE_WEIGHTS
202
203 PROCEDURE Create_WM_Weight(
204 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
205 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
206 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
207 ,x_return_status OUT NOCOPY VARCHAR2
208 ,x_msg_count OUT NOCOPY NUMBER
209 ,x_msg_data OUT NOCOPY VARCHAR2
210 );
211
212 PROCEDURE Retrieve_WM_Weight(
213 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
214 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
215 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
216 ,x_return_status OUT NOCOPY VARCHAR2
217 ,x_msg_count OUT NOCOPY NUMBER
218 ,x_msg_data OUT NOCOPY VARCHAR2
219 );
220
221 PROCEDURE Update_WM_Weight(
222 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
223 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
224 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
225 ,x_return_status OUT NOCOPY VARCHAR2
226 ,x_msg_count OUT NOCOPY NUMBER
227 ,x_msg_data OUT NOCOPY VARCHAR2
228 );
229
230 PROCEDURE Delete_WM_Weight(
231 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
232 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
233 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
234 ,x_return_status OUT NOCOPY VARCHAR2
235 ,x_msg_count OUT NOCOPY NUMBER
236 ,x_msg_data OUT NOCOPY VARCHAR2
237 );
238
239 ------- APIs for table BIS_WEIGHTED_MEASURE_SCORES
240 PROCEDURE Create_WM_Score(
241 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
242 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
243 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
244 ,x_return_status OUT NOCOPY VARCHAR2
245 ,x_msg_count OUT NOCOPY NUMBER
246 ,x_msg_data OUT NOCOPY VARCHAR2
247 );
248
249 PROCEDURE Retrieve_WM_Score(
250 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
251 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
252 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
253 ,x_return_status OUT NOCOPY VARCHAR2
254 ,x_msg_count OUT NOCOPY NUMBER
255 ,x_msg_data OUT NOCOPY VARCHAR2
256 );
257
258 PROCEDURE Update_WM_Score(
259 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
260 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
261 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
262 ,x_return_status OUT NOCOPY VARCHAR2
263 ,x_msg_count OUT NOCOPY NUMBER
264 ,x_msg_data OUT NOCOPY VARCHAR2
265 );
266
267 PROCEDURE Delete_WM_Score(
268 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
269 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
270 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
271 ,x_return_status OUT NOCOPY VARCHAR2
272 ,x_msg_count OUT NOCOPY NUMBER
273 ,x_msg_data OUT NOCOPY VARCHAR2
274 );
275 /**************************************************************************
276
277 ********* WRAPPER APIS FOR RECORD APIS *****************
278
279 ***************************************************************************/
280 ------- APIs for table BIS_WEIGHTED_MEASURE_DEFNS
281
282 PROCEDURE Create_WM_Definition(
283 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
284 ,p_weighted_definition_id IN NUMBER
285 ,p_weighted_measure_id IN NUMBER
286 ,p_viewby_dimension_sn IN VARCHAR2
287 ,p_viewby_dim_level_sn IN VARCHAR2
288 ,p_filter_dimension_sn IN VARCHAR2
289 ,p_filter_dim_level_sn IN VARCHAR2
290 ,p_time_dimension_sn IN VARCHAR2
291 ,p_time_dim_level_sn IN VARCHAR2
292 ,x_weighted_definition_id OUT NOCOPY NUMBER
293 ,x_return_status OUT NOCOPY VARCHAR2
294 ,x_msg_count OUT NOCOPY NUMBER
295 ,x_msg_data OUT NOCOPY VARCHAR2
296 );
297
298 PROCEDURE Retrieve_WM_Definition(
299 p_weighted_definition_id IN NUMBER
300 ,x_weighted_measure_id OUT NOCOPY NUMBER
301 ,x_viewby_dimension_sn OUT NOCOPY VARCHAR2
302 ,x_viewby_dim_level_sn OUT NOCOPY VARCHAR2
303 ,x_filter_dimension_sn OUT NOCOPY VARCHAR2
304 ,x_filter_dim_level_sn OUT NOCOPY VARCHAR2
305 ,x_time_dimension_sn OUT NOCOPY VARCHAR2
306 ,x_time_dim_level_sn OUT NOCOPY VARCHAR2
307 ,x_return_status OUT NOCOPY VARCHAR2
308 ,x_msg_count OUT NOCOPY NUMBER
309 ,x_msg_data OUT NOCOPY VARCHAR2
310 );
311
312 PROCEDURE Update_WM_Definition(
313 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
314 ,p_weighted_definition_id IN NUMBER
315 ,p_weighted_measure_id IN NUMBER
316 ,p_viewby_dimension_sn IN VARCHAR2
317 ,p_viewby_dim_level_sn IN VARCHAR2
318 ,p_filter_dimension_sn IN VARCHAR2
319 ,p_filter_dim_level_sn IN VARCHAR2
320 ,p_time_dimension_sn IN VARCHAR2
321 ,p_time_dim_level_sn IN VARCHAR2
322 ,x_return_status OUT NOCOPY VARCHAR2
323 ,x_msg_count OUT NOCOPY NUMBER
324 ,x_msg_data OUT NOCOPY VARCHAR2
325 );
326
327 PROCEDURE Delete_WM_Definition(
328 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
329 ,p_weighted_definition_id IN NUMBER
330 ,x_return_status OUT NOCOPY VARCHAR2
331 ,x_msg_count OUT NOCOPY NUMBER
332 ,x_msg_data OUT NOCOPY VARCHAR2
333 );
334
335 PROCEDURE Create_WM_Dependency(
336 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
337 ,p_weighted_measure_id IN NUMBER
338 ,p_dependent_measure_id IN NUMBER
339 ,x_return_status OUT NOCOPY VARCHAR2
340 ,x_msg_count OUT NOCOPY NUMBER
341 ,x_msg_data OUT NOCOPY VARCHAR2
342 );
343
344 PROCEDURE Delete_WM_Dependency(
345 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
346 ,p_weighted_measure_id IN NUMBER
347 ,p_dependent_measure_id IN NUMBER
348 ,x_return_status OUT NOCOPY VARCHAR2
349 ,x_msg_count OUT NOCOPY NUMBER
350 ,x_msg_data OUT NOCOPY VARCHAR2
351 );
352
356 ,p_weighted_definition_id IN NUMBER
353 PROCEDURE Create_WM_Parameter(
354 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
355 ,p_weighted_parameter_id IN NUMBER
357 ,p_time_level_value_id IN VARCHAR2
358 ,p_filter_level_value_id IN VARCHAR2
359 ,x_weighted_parameter_id OUT NOCOPY NUMBER
360 ,x_return_status OUT NOCOPY VARCHAR2
361 ,x_msg_count OUT NOCOPY NUMBER
362 ,x_msg_data OUT NOCOPY VARCHAR2
363 );
364
365 PROCEDURE Delete_WM_Parameter(
366 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
367 ,p_weighted_parameter_id IN NUMBER
368 ,x_return_status OUT NOCOPY VARCHAR2
369 ,x_msg_count OUT NOCOPY NUMBER
370 ,x_msg_data OUT NOCOPY VARCHAR2
371 );
372
373 PROCEDURE Create_WM_Weight(
374 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
375 ,P_weight_id IN NUMBER
376 ,p_weighted_parameter_id IN NUMBER
377 ,p_dependent_measure_id IN NUMBER
378 ,p_weight IN NUMBER
379 ,x_weight_id OUT NOCOPY NUMBER
380 ,x_return_status OUT NOCOPY VARCHAR2
381 ,x_msg_count OUT NOCOPY NUMBER
382 ,x_msg_data OUT NOCOPY VARCHAR2
383 );
384
385 PROCEDURE Update_WM_Weight(
386 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
387 ,p_weight_id IN NUMBER
388 ,p_weight IN NUMBER
389 ,x_return_status OUT NOCOPY VARCHAR2
390 ,x_msg_count OUT NOCOPY NUMBER
391 ,x_msg_data OUT NOCOPY VARCHAR2
392 );
393
394 PROCEDURE Delete_WM_Weight(
395 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
396 ,p_weight_id IN NUMBER
397 ,x_return_status OUT NOCOPY VARCHAR2
398 ,x_msg_count OUT NOCOPY NUMBER
399 ,x_msg_data OUT NOCOPY VARCHAR2
400 );
401
402 PROCEDURE Create_WM_Score(
403 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
404 ,p_weight_id IN NUMBER
405 ,p_low_range IN NUMBER
406 ,p_high_range IN NUMBER
407 ,p_score IN NUMBER
408 ,x_return_status OUT NOCOPY VARCHAR2
409 ,x_msg_count OUT NOCOPY NUMBER
410 ,x_msg_data OUT NOCOPY VARCHAR2
411 );
412
413 PROCEDURE Delete_WM_Score(
414 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
415 ,p_weight_id IN NUMBER
416 ,x_return_status OUT NOCOPY VARCHAR2
417 ,x_msg_count OUT NOCOPY NUMBER
418 ,x_msg_data OUT NOCOPY VARCHAR2
419 );
420
421
422 /**************************************************************************
423 WRAPPER APIS TO BE CALL FROM JAVA:
424 ***************************************************************************/
425
426 /*******************************************************************
427 Check_Defined_Weights
428 Check if some weight hadbeen defined for the Weighted Measure
429 or for a scpecific dependint Measure.
430
431 Input Parameters:
432
433 p_weighted_measure_id -> This is the Weighted Measure Id
434 p_dependent_measure_Id -> if null is passed it check for the whole
435 Weighted Measure
436 Return
437 P -> Positive Weights Defined
438 Z -> Zero Wheioghts Defined
439 N -> No Weights Defined
440 NULL -> It is returned when and error happen or p_weighted_measure_id
441 is passed as null
442
443 *******************************************************************/
444 FUNCTION get_Defined_Weights_Status (
445 p_weighted_measure_id IN NUMBER
446 ,p_dependent_measure_Id IN NUMBER
447 ) RETURN VARCHAR;
448
449 PROCEDURE Delete_Weighted_Measure_data(
450 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
451 ,p_weighted_measure_id IN NUMBER
452 ,x_return_status OUT NOCOPY VARCHAR2
453 ,x_msg_count OUT NOCOPY NUMBER
454 ,x_msg_data OUT NOCOPY VARCHAR2
455 );
456
457 PROCEDURE Create_Weighted_Measure_data(
458 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
459 ,p_weighted_measure_id IN NUMBER
460 ,p_dependent_measure_ids IN VARCHAR2
461 ,p_viewby_dimension_short_name IN VARCHAR2
462 ,p_viewby_dim_level_short_name IN VARCHAR2
463 ,p_filter_dimension_short_name IN VARCHAR2
464 ,p_filter_dim_level_short_name IN VARCHAR2
465 ,p_time_dimension_short_name IN VARCHAR2
466 ,p_time_dim_level_short_names IN VARCHAR2
467 ,x_return_status OUT NOCOPY VARCHAR2
468 ,x_msg_count OUT NOCOPY NUMBER
469 ,x_msg_data OUT NOCOPY VARCHAR2
470 );
471
472 PROCEDURE Set_Weight_Data(
473 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
474 ,p_weighted_measure_id NUMBER
475 ,p_dependent_measure_id NUMBER
476 ,p_weight NUMBER
477 ,x_return_status OUT NOCOPY VARCHAR2
478 ,x_msg_count OUT NOCOPY NUMBER
479 ,x_msg_data OUT NOCOPY VARCHAR2
480 );
481
482 Procedure Set_Weights_Data(
483 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
484 ,p_weighted_measure_id IN NUMBER
485 ,p_depend_measure_short_names IN FND_TABLE_OF_VARCHAR2_30
486 ,p_weights IN FND_TABLE_OF_NUMBER
487 ,x_return_status OUT NOCOPY VARCHAR2
488 ,x_msg_count OUT NOCOPY NUMBER
492 FUNCTION Get_Dep_KPI_Format_Mask (
489 ,x_msg_data OUT NOCOPY VARCHAR2
490 );
491
493 p_wkpi_id IN BIS_INDICATORS.INDICATOR_ID%TYPE,
494 p_dep_kpi_id IN BIS_INDICATORS.INDICATOR_ID%TYPE
495 ) RETURN AK_REGION_ITEMS_VL.ATTRIBUTE7%TYPE;
496
497 PROCEDURE Update_WM_Last_Update_Info(
498 p_commit IN VARCHAR2 := FND_API.G_FALSE
499 ,p_Weighted_Measure_Id IN NUMBER
500 ,x_return_status OUT NOCOPY VARCHAR2
501 ,x_msg_count OUT NOCOPY NUMBER
502 ,x_msg_data OUT NOCOPY VARCHAR2
503 );
504
505 PROCEDURE Save_Mass_Update_Values(
506 p_commit IN VARCHAR2 := FND_API.G_FALSE
507 ,p_weighted_measure_id IN NUMBER
508 ,p_dependent_measure_id IN NUMBER
509 ,p_Time_Level IN VARCHAR2
510 ,p_Filter_Level IN VARCHAR2
511 ,p_Selected_Period_Ids IN BIS_TABLE_OF_VARCHAR
512 ,p_Selected_DimObj_Ids IN BIS_TABLE_OF_VARCHAR
513 ,p_Score_Values IN FND_TABLE_OF_NUMBER
514 ,p_Lower_Ranges IN FND_TABLE_OF_NUMBER
515 ,p_Upper_Ranges IN FND_TABLE_OF_NUMBER
516 ,x_return_status OUT NOCOPY VARCHAR2
517 ,x_msg_count OUT NOCOPY NUMBER
518 ,x_msg_data OUT NOCOPY VARCHAR2
519 );
520
521 PROCEDURE Validate_Overwrite_Scores(
522 p_weighted_measure_id IN NUMBER
523 ,p_dependent_measure_id IN NUMBER
524 ,p_Selected_Period_Ids IN BIS_TABLE_OF_VARCHAR
525 ,p_Selected_DimObj_Ids IN BIS_TABLE_OF_VARCHAR
526 ,x_Param_Count OUT NOCOPY NUMBER
527 );
528
529
530 END BIS_WEIGHTED_MEASURE_PUB;