1 package ZPB_METADATA_NAMES as
2 /* $Header: zpbmetanames.pls 120.0.12010.2 2005/12/23 08:20:15 appldev noship $ */
3
4 -------------------------------------------------------------------------------
5 -- GET_ALL_ANNOTATIONS_VIEW - Gets the all annotations view name
6 --
7 -- IN: p_aw - The AW
8 -- OUT: The view name for all annotations
9 -------------------------------------------------------------------------------
10 function GET_ALL_ANNOTATIONS_VIEW (p_aw in varchar2)
11 return varchar2;
12
13 -------------------------------------------------------------------------------
14 -- GET_ALL_ANNOT_PERS_VIEW - Gets the personal all annotations view name
15 --
16 -- IN: p_aw - The AW
17 -- OUT: The view name for all personal annotations
18 -------------------------------------------------------------------------------
19 function GET_ALL_ANNOT_PERS_VIEW (p_aw in varchar2)
20 return varchar2;
21
22 -------------------------------------------------------------------------------
23 -- GET_ATTRIBUTE_COLUMN - Gets the column name for an attribute
24 --
25 -- IN: p_dimID - The Dimension ID in the DimDim
26 -- p_attribute - The Attribute ID in the AttrDim
27 -- OUT: The column name for the attribute
28 -------------------------------------------------------------------------------
29 function GET_ATTRIBUTE_COLUMN (p_dimID in varchar2,
30 p_attribute in varchar2)
31 return varchar2;
32
33 -------------------------------------------------------------------------------
34 -- GET_ATTRIBUTE_CWM2_NAME - Gets the cwm2 name for an attribute
35 --
36 -- IN: p_aw - The AW which the contains the attribte
37 -- p_dimID - The Dimension ID in the DimDim
38 -- p_attribute - The Attribute ID in the AttrDim
39 -- OUT: The cwm2 name for the attribute
40 -------------------------------------------------------------------------------
41 function GET_ATTRIBUTE_CWM2_NAME (p_aw in varchar2,
42 p_dimID in varchar2,
43 p_attribute in varchar2)
44 return varchar2;
45
46 -------------------------------------------------------------------------------
47 -- GET_ATTRIBUTE_SCOPE_VIEW - Gets the attribute scope view name
48 --
49 -- IN: p_aw - The AW
50 -- OUT: The view name for attribute scoping
51 -------------------------------------------------------------------------------
52 function GET_ATTRIBUTE_SCOPE_VIEW (p_aw in varchar2)
53 return varchar2;
54
55 -------------------------------------------------------------------------------
56 -- GET_CATALOG_CWM2_NAME - Gets the cwm2 name for a catalog
57 --
58 -- IN: p_aw - The AW which the catalog contains
59 -- OUT: The column name for the catalog
60 -------------------------------------------------------------------------------
61 function GET_CATALOG_CWM2_NAME (p_aw in varchar2)
62 return varchar2;
63
64 -------------------------------------------------------------------------------
65 -- GET_DATA_EXCEPTION_VIEW - Gets the data exception view name
66 --
67 -- IN: p_aw - The AW
68 --
69 -- OUT: The data exception view name
70 -------------------------------------------------------------------------------
71 function GET_DATA_EXCEPTION_VIEW (p_aw in varchar2)
72 return varchar2;
73
74 -------------------------------------------------------------------------------
75 -- GET_DIMENSION_COLUMN - Gets the column name for a dimension
76 --
77 -- IN: p_dimID - The Dimension ID in the DimDim
78 -- OUT: The column name for the dimension
79 -------------------------------------------------------------------------------
80 function GET_DIMENSION_COLUMN (p_dimID in varchar2)
81 return varchar2;
82
83 -------------------------------------------------------------------------------
84 -- GET_DIMENSION_CWM2_NAME - Gets the cwm2 name for a dimension
85 --
86 -- IN: p_aw - The AW where the dimension exists
87 -- p_dimID - The Dimension ID in the DimDim
88 -- OUT: The cwm2 name for the dimension
89 -------------------------------------------------------------------------------
90 function GET_DIMENSION_CWM2_NAME (p_aw in varchar2,
91 p_dimID in varchar2)
92 return varchar2;
93
94 -------------------------------------------------------------------------------
95 -- GET_DIMENSION_VIEW - Gets the cwm2 name for a dimension
96 --
97 -- IN: p_aw - The AW where the dimension exists
98 -- p_type - PERSONAL or SHARED, the AW type
99 -- p_dimID - The Dimension ID in the DimDim
100 -- p_hierarchyID - The hierarchy ID in the HierDim
101 -- OUT: The view name for the dimension/hierarchy
102 -------------------------------------------------------------------------------
103 function GET_DIMENSION_VIEW (p_aw in varchar2,
104 p_type in varchar2,
105 p_dimID in varchar2,
106 p_hierarchyID in varchar2 default null)
107 return varchar2;
108
109 -------------------------------------------------------------------------------
110 -- GET_DIM_CODE_COLUMN - Gets the column name for the dimension code
111 --
112 -- IN: p_dimID - The Dimension ID in the DimDim
113 -- OUT: The column name for the code
114 -------------------------------------------------------------------------------
115 function GET_DIM_CODE_COLUMN (p_dimID in varchar2)
116 return varchar2;
117
118 -------------------------------------------------------------------------------
119 -- GET_DIM_ENDDATE_COLUMN - Gets the column name for the enddate attribute
120 -- for a dimension
121 --
122 -- IN: p_dimID - The Dimension ID in the DimDim
123 -- OUT: The column name for the enddate attribute
124 -------------------------------------------------------------------------------
125 function GET_DIM_ENDDATE_COLUMN (p_dimID in varchar2)
126 return varchar2;
127
128 -------------------------------------------------------------------------------
129 -- GET_DIM_AGGTIME_COLUMN - Gets the column name for the agg type by time attribute
130 -- for a dimension
131 --
132 -- IN: p_dimID - The Dimension ID in the DimDim
133 -- OUT: The column name for the agg type by time attribute
134 -------------------------------------------------------------------------------
135 function GET_DIM_AGGTIME_COLUMN (p_dimID in varchar2)
136 return varchar2;
137
138 -------------------------------------------------------------------------------
139 -- GET_DIM_AGGOTHER_COLUMN - Gets the column name for the agg type, by dimensions
140 -- other than time, attribute for a dimension
141 --
142 -- IN: p_dimID - The Dimension ID in the DimDim
143 -- OUT: The column name for the agg type by other dims attribute
144 -------------------------------------------------------------------------------
145 function GET_DIM_AGGOTHER_COLUMN (p_dimID in varchar2)
146 return varchar2;
147
148 -------------------------------------------------------------------------------
149 -- GET_DIM_CALENDAR_COLUMN - Gets the column name for the calendar id, used
150 -- for time dimension only
151 --
152 -- IN: p_dimID - The Dimension ID in the DimDim
153 -- OUT: The column name for the calendar id
154 -------------------------------------------------------------------------------
155 function GET_DIM_CALENDAR_COLUMN (p_dimID in varchar2)
156 return varchar2;
157
158 -------------------------------------------------------------------------------
159 -- GET_DIM_GID_COLUMN - Gets the column name for the GID attribute
160 -- for a dimension
161 --
162 -- IN: p_dimID - The Dimension ID in the DimDim, if null, the null GID col
163 -- p_hierID - The Hierarchy ID, for measure views. Null if dim view
164 -- OUT: The column name for the GID attribute
165 -------------------------------------------------------------------------------
166 function GET_DIM_GID_COLUMN (p_dimID in varchar2 := null,
167 p_hierID in varchar2 := null)
168 return varchar2;
169
170 -------------------------------------------------------------------------------
171 -- GET_DIM_LONG_NAME_COLUMN - Gets the column name for the long name attribute
172 -- for a dimension
173 --
174 -- IN: p_dimID - The Dimension ID in the DimDim
175 -- OUT: The column name for the long name attribute
176 -------------------------------------------------------------------------------
177 function GET_DIM_LONG_NAME_COLUMN (p_dimID in varchar2)
178 return varchar2;
179
180 -------------------------------------------------------------------------------
181 -- GET_DIM_LONG_NAME_CWM2 - Gets the cwm2 name for the long name attribute
182 -- for a dimension
183 --
184 -- IN: p_dimID - The Dimension ID in the DimDim
185 -- OUT: The cwm2 name for the long name attribute
186 -------------------------------------------------------------------------------
187 function GET_DIM_LONG_NAME_CWM2 (p_aw in varchar2,
188 p_dimID in varchar2)
189 return varchar2;
190
191 -------------------------------------------------------------------------------
192 -- GET_DIM_ORDER_COLUMN - Gets the column name for the dimension order
193 --
194 -- IN: p_dimID - The Dimension ID in the DimDim
195 -- OUT: The column name for the order
196 -------------------------------------------------------------------------------
197 function GET_DIM_ORDER_COLUMN (p_dimID in varchar2)
198 return varchar2;
199
200 -------------------------------------------------------------------------------
201 -- GET_DIM_PARENT_COLUMN - Gets the column name for the parent attribute
202 -- for a dimension
203 --
204 -- IN: p_dimID - The Dimension ID in the DimDim
205 -- OUT: The column name for the parent attribute
206 -------------------------------------------------------------------------------
207 function GET_DIM_PARENT_COLUMN (p_dimID in varchar2)
208 return varchar2;
209
210 -------------------------------------------------------------------------------
211 -- GET_DIM_PGID_COLUMN - Gets the column name for the PGID attribute
212 -- for a dimension
213 --
214 -- IN: p_dimID - The Dimension ID in the DimDim
215 -- OUT: The column name for the PGID attribute
216 -------------------------------------------------------------------------------
217 function GET_DIM_PGID_COLUMN (p_dimID in varchar2)
218 return varchar2;
219
220 -------------------------------------------------------------------------------
221 -- GET_DIM_SHORT_NAME_COLUMN - Gets the column name for the short name
222 -- attribute for a dimension
223 --
224 -- IN: p_dimID - The Dimension ID in the DimDim
225 -- OUT: The column name for the short name attribute
226 -------------------------------------------------------------------------------
227 function GET_DIM_SHORT_NAME_COLUMN (p_dimID in varchar2)
228 return varchar2;
229
230 -------------------------------------------------------------------------------
231 -- GET_DIM_SHORT_NAME_CWM2 - Gets the cwm2 name for the short name
232 -- attribute for a dimension
233 --
234 -- IN: p_dimID - The Dimension ID in the DimDim
235 -- OUT: The cwm2 name for the short name attribute
236 -------------------------------------------------------------------------------
237 function GET_DIM_SHORT_NAME_CWM2 (p_aw in varchar2,
238 p_dimID in varchar2)
239 return varchar2;
240
241 -------------------------------------------------------------------------------
242 -- GET_DIM_TIMESPAN_COLUMN - Gets the column name for the timespan attribute
243 -- for a dimension
244 --
245 -- IN: p_dimID - The Dimension ID in the DimDim
246 -- OUT: The column name for the timespan attribute
247 -------------------------------------------------------------------------------
248 function GET_DIM_TIMESPAN_COLUMN (p_dimID in varchar2)
249 return varchar2;
250
251 -------------------------------------------------------------------------------
252 -- GET_EXCEPTION_CHECK_TBL - Gets the generic exception check table
253 --
254 -- IN: p_aw - The AW
255 --
256 -- OUT: The exception check table
257 -------------------------------------------------------------------------------
258 function GET_EXCEPTION_CHECK_TBL (p_aw in varchar2)
259 return varchar2;
260
261 -------------------------------------------------------------------------------
262 -- GET_EXCEPTION_COLUMN - Gets the generic exception check column
263 --
264 -- OUT: The exception check column
265 -------------------------------------------------------------------------------
266 function GET_EXCEPTION_COLUMN
267 return varchar2;
268
269 -------------------------------------------------------------------------------
270 -- GET_EXCEPTION_MEAS_CWM2 - Gets the exception check measure cwm2 name
271 --
272 -- IN: p_aw - The AW
273 -- p_instance - The Instance ID
274 --
275 -- OUT: The exception check measure cwm2 name
276 -------------------------------------------------------------------------------
277 function GET_EXCEPTION_MEAS_CWM2 (p_aw in varchar2,
278 p_instance in varchar2)
279 return varchar2;
280
281 -------------------------------------------------------------------------------
282 -- GET_EXCEPTION_MEAS_CUBE - Gets the exception check measure cube name
283 --
284 -- IN: p_aw - The AW
285 -- p_instance - The Instance ID
286 --
287 -- OUT: The exception check measure cube name
288 -------------------------------------------------------------------------------
289 function GET_EXCEPTION_MEAS_CUBE (p_aw in varchar2,
290 p_instance in varchar2)
291 return varchar2;
292
293 ---------------------------------------------------------------------------
294 -- GET_EXCH_RATES_VIEW - Gets the exchange rates view name
295 --
296 -- IN: p_aw - The AW
297 --
298 -- OUT: The exchange rates view name
299 -------------------------------------------------------------------------------
300 function GET_EXCH_RATES_VIEW (p_aw in varchar2)
301 return varchar2;
302
303 ---------------------------------------------------------------------------
304 -- GET_EXCH_SCENARIO_VIEW - Gets the exchange scenario view name
305 --
306 -- IN: p_aw - The AW
310 function GET_EXCH_SCENARIO_VIEW (p_aw in varchar2)
307 --
308 -- OUT: The exchange scenario view name
309 -------------------------------------------------------------------------------
311 return varchar2;
312
313 -------------------------------------------------------------------------------
314 -- GET_FULL_SCOPE_COLUMN - Gets the full scope column
315 --
316 -- IN: p_aw - The AW
317 --
318 -- OUT: The full scope column
319 -------------------------------------------------------------------------------
320 function GET_FULL_SCOPE_COLUMN
321 return varchar2;
322
323 -------------------------------------------------------------------------------
324 -- GET_FULL_SCOPE_CWM2_NAME - Gets the full scope measure
325 --
326 -- IN: p_aw - The AW
327 --
328 -- OUT: The full scope cwm2 measure name
329 -------------------------------------------------------------------------------
330 function GET_FULL_SCOPE_CWM2_NAME (p_aw in varchar2)
331 return varchar2;
332
333 -------------------------------------------------------------------------------
334 -- GET_HIERARCHY_CWM2_NAME - Gets the cwm2 hierarchy name
335 --
336 -- IN: p_dimID - The Dimension ID in the DimDim
337 -- p_hierarchyID - The Hierarchy ID in the HierDim (null for
338 -- hierarchy-less dims)
339 -- OUT: The column name for the timespan attribute
340 -------------------------------------------------------------------------------
341 function GET_HIERARCHY_CWM2_NAME (p_aw in varchar2,
342 p_dimID in varchar2,
343 p_hierarchyID in varchar2 default null)
344 return varchar2;
345
346 -------------------------------------------------------------------------------
347 -- GET_HIERARCHY_SCOPE_VIEW - Gets the view name for the hierarchy scoping view
348 --
349 -- IN: p_aw - The AW where the dimension exists
350 -- p_dimID - The Dimension ID in the DimDim
351 -- OUT: The view name for the dimension/hierarchy
352 -------------------------------------------------------------------------------
353 function GET_HIERARCHY_SCOPE_VIEW (p_aw in varchar2,
354 p_dimID in varchar2)
355 return varchar2;
356
357 -------------------------------------------------------------------------------
358 -- GET_LEVEL_COLUMN - Gets the level column name
359 --
360 -- IN: p_dimID - The Dimension ID in the DimDim
361 -- p_levelID - The Level ID in the LevelDim
362 -- OUT: The column name for the level
363 -------------------------------------------------------------------------------
364 function GET_LEVEL_COLUMN (p_dimID in varchar2,
365 p_levelID in varchar2)
366 return varchar2;
367
368 -------------------------------------------------------------------------------
369 -- GET_LEVEL_CWM2_NAME - Gets the cwm2 level name
370 --
371 -- IN: p_dimID - The Dimension ID in the DimDim
372 -- p_levelID - The Level ID in the LevelDim (null for hierarchy-less dims)
373 -- OUT: The column name for the timespan attribute
374 -------------------------------------------------------------------------------
375 function GET_LEVEL_CWM2_NAME (p_aw in varchar2,
376 p_dimID in varchar2,
377 p_hierID in varchar2 default null,
378 p_levelID in varchar2 default null)
379 return varchar2;
380
381 -------------------------------------------------------------------------------
382 -- GET_LEVELREL_COLUMN - Gets the levelRel column name
383 --
384 -- IN: p_dimID - The Dimension ID in the DimDim
385 -- OUT: The column name for the levelRel
386 -------------------------------------------------------------------------------
387 function GET_LEVELREL_COLUMN (p_dimID in varchar2)
388 return varchar2;
389
390 -------------------------------------------------------------------------------
391 -- GET_LEVEL_SCOPE_VIEW - Gets the name of the view for level scoping
392 --
393 -- IN: p_aw - The AW where the dimension exists
394 -- p_dimID - The Dimension ID in the DimDim
395 -- OUT: The ID for the level
396 -------------------------------------------------------------------------------
397 function GET_LEVEL_SCOPE_VIEW (p_aw in varchar2,
398 p_dimID in varchar2)
399 return varchar2;
400
401 -------------------------------------------------------------------------------
402 -- GET_MEASURE_ANNOT_CWM2 - Gets the measure annotation cwm2 name
403 --
404 -- IN: p_aw - The AW
405 -- p_instance - The Instance ID
406 -- p_type - The measure type, one of ('CWM', 'SHARED', 'PERSONAL',
407 -- or 'APPROVAL')
408 -- OUT: The annotation measure cwm2 name
409 -------------------------------------------------------------------------------
410 function GET_MEASURE_ANNOT_CWM2 (p_aw in varchar2,
411 p_instance in varchar2,
412 p_type in varchar2,
413 p_template in varchar2 default null,
414 p_approvee in varchar2 default null,
415 p_currency in varchar2 default null)
416 return varchar2;
417
418 -------------------------------------------------------------------------------
422 -- p_instance - The Instance ID
419 -- GET_MEASURE_CWM2 - Gets the measure cwm2 name
420 --
421 -- IN: p_aw - The AW
423 -- p_type - The measure type, one of ('CWM', 'SHARED', 'PERSONAL',
424 -- or 'APPROVAL')
425 -- OUT: The measure cwm2 name
426 -------------------------------------------------------------------------------
427 function GET_MEASURE_CWM2 (p_aw in varchar2,
428 p_instance in varchar2,
429 p_type in varchar2,
430 p_template in varchar2 default null,
431 p_approvee in varchar2 default null,
432 p_currency in varchar2 default null)
433 return varchar2;
434
435 -------------------------------------------------------------------------------
436 -- GET_MEASURE_FORMAT_CWM2 - Gets the measure format cwm2 name
437 --
438 -- IN: p_aw - The AW
439 -- p_instance - The Instance ID
440 -- p_type - The measure type, one of ('CWM', 'SHARED', 'PERSONAL',
441 -- or 'APPROVAL')
442 -- OUT: The format measure cwm2 name
443 -------------------------------------------------------------------------------
444 function GET_MEASURE_FORMAT_CWM2 (p_aw in varchar2,
445 p_instance in varchar2,
446 p_type in varchar2,
447 p_template in varchar2 default null,
448 p_approvee in varchar2 default null,
449 p_currency in varchar2 default null)
450 return varchar2;
451
452 -------------------------------------------------------------------------------
453 -- GET_MEASURE_INPUT_LVL_CWM2 - Gets the measure input level cwm2 name
454 --
455 -- IN: p_aw - The AW
456 -- p_instance - The Instance ID
457 -- p_type - The measure type, one of ('CWM', 'SHARED', 'PERSONAL',
458 -- or 'APPROVAL')
459 -- OUT: The input level measure cwm2 name
460 -------------------------------------------------------------------------------
461 function GET_MEASURE_INPUT_LVL_CWM2 (p_aw in varchar2,
462 p_instance in varchar2,
463 p_type in varchar2,
464 p_template in varchar2 default null,
465 p_approvee in varchar2 default null)
466 return varchar2;
467
468 -------------------------------------------------------------------------------
469 -- GET_MEASURE_TARGET_CWM2 - Gets the measure target cwm2 name
470 --
471 -- IN: p_aw - The AW
472 -- p_instance - The Instance ID
473 -- p_type - The measure type, one of ('CWM', 'SHARED', 'PERSONAL',
474 -- or 'APPROVAL')
475 -- OUT: The target measure cwm2 name
476 -------------------------------------------------------------------------------
477 function GET_MEASURE_TARGET_CWM2 (p_aw in varchar2,
478 p_instance in varchar2,
479 p_type in varchar2,
480 p_template in varchar2 default null,
481 p_approvee in varchar2 default null)
482 return varchar2;
483
484 -------------------------------------------------------------------------------
485 -- GET_MEASURE_TARG_TYPE_CWM2 - Gets the measure target type cwm2 name
486 --
487 -- IN: p_aw - The AW
488 -- p_instance - The Instance ID
489 -- p_type - The measure type, one of ('CWM', 'SHARED', 'PERSONAL',
490 -- or 'APPROVAL')
491 -- OUT: The target type measure cwm2 name
492 -------------------------------------------------------------------------------
493 function GET_MEASURE_TARG_TYPE_CWM2 (p_aw in varchar2,
494 p_instance in varchar2,
495 p_type in varchar2,
496 p_template in varchar2 default null,
497 p_approvee in varchar2 default null)
498 return varchar2;
499
500 -------------------------------------------------------------------------------
501 -- GET_MEASURE_TYPE_ABBREV - Gets the measuure type shortname
502 --
503 -- IN: p_type - The measure type
504 -- OUT: The measure type shortname
505 -------------------------------------------------------------------------------
506 function GET_MEASURE_TYPE_ABBREV (p_type in varchar2)
507 return varchar2;
508
509 -------------------------------------------------------------------------------
510 -- GET_MEASURE_WRITE_SEC_CWM2 - Gets the measure write security cwm2 name
511 --
512 -- IN: p_aw - The AW
513 -- p_instance - The Instance ID
514 -- p_type - The measure type, one of ('CWM', 'SHARED', 'PERSONAL',
515 -- or 'APPROVAL')
516 -- OUT: The write security measure cwm2 name
517 -------------------------------------------------------------------------------
518 function GET_MEASURE_WRITE_SEC_CWM2 (p_aw in varchar2,
519 p_instance in varchar2,
520 p_type in varchar2,
521 p_template in varchar2 default null,
522 p_approvee in varchar2 default null)
523 return varchar2;
524
528 -- IN: p_aw - The AW
525 -------------------------------------------------------------------------------
526 -- GET_MEASURE_CUR_WRITE_SEC_CWM2 - Gets the measure currency write security cwm2 name
527 --
529 -- p_instance - The Instance ID
530 -- p_type - The measure type, one of ('CWM', 'SHARED', 'PERSONAL',
531 -- or 'APPROVAL')
532 -- OUT: The write security measure cwm2 name
533 -------------------------------------------------------------------------------
534 function GET_MEASURE_CUR_WRITE_SEC_CWM2 (p_aw in varchar2,
535 p_instance in varchar2,
536 p_type in varchar2,
537 p_template in varchar2 default null,
538 p_approvee in varchar2 default null)
539 return varchar2;
540
541 -------------------------------------------------------------------------------
542 -- GET_OWNERMAP_COLUMN - Gets the ownermap column
543 --
544 -- IN: p_aw - The AW
545 --
546 -- OUT: The ownermap column
547 -------------------------------------------------------------------------------
548 function GET_OWNERMAP_COLUMN
549 return varchar2;
550
551 -------------------------------------------------------------------------------
552 -- GET_OWNERMAP_CWM2_CUBE - Gets the ownermap cube
553 --
554 -- IN: p_aw - The AW
555 --
556 -- OUT: The ownermap cwm2 cube name
557 -------------------------------------------------------------------------------
558 function GET_OWNERMAP_CWM2_CUBE (p_aw in varchar2)
559 return varchar2;
560
561 -------------------------------------------------------------------------------
565 --
562 -- GET_OWNERMAP_CWM2_NAME - Gets the ownermap measure
563 --
564 -- IN: p_aw - The AW
566 -- OUT: The ownermap cwm2 measure name
567 -------------------------------------------------------------------------------
568 function GET_OWNERMAP_CWM2_NAME (p_aw in varchar2)
569 return varchar2;
570
571 -------------------------------------------------------------------
572 -- GET_OWNERMAP_VIEW - Gets the ownermap view
573 --
574 -- IN: p_aw - The AW
575 --
576 -- OUT: The ownermap view name
577 -------------------------------------------------------------------------------
578 function GET_OWNERMAP_VIEW (p_aw in varchar2)
579 return varchar2;
580
581 -------------------------------------------------------------------------------
582 -- GET_SCOPE_STATUS_VIEW - Gets the scope view name
583 --
584 -- IN: p_aw - The AW
585 --
586 -- OUT: The scope status view name
587 -------------------------------------------------------------------------------
588 function GET_SCOPE_STATUS_VIEW (p_aw in varchar2)
589 return varchar2;
590
591 ---------------------------------------------------------------------------
592 -- GET_SCOPING_VIEW - Gets the metadata scoping view
593 --
594 -- IN: p_aw - The AW
595 --
596 -- OUT: The metadata scoping view name
597 -------------------------------------------------------------------------------
598 function GET_SCOPING_VIEW (p_aw in varchar2)
599 return varchar2;
600
601 -------------------------------------------------------------------------------
602 -- GET_SECURITY_CWM2_CUBE - Gets the security (ownermap) cube
603 --
604 -- IN: p_aw - The AW
605 --
606 -- OUT: The security cwm2 cube name
607 -------------------------------------------------------------------------------
608 function GET_SECURITY_CWM2_CUBE (p_aw in varchar2)
609 return varchar2;
610
611 -------------------------------------------------------------------------------
612 -- GET_SECURITY_VIEW - Gets the security (ownermap) view
613 --
614 -- IN: p_aw - The AW
615 --
616 -- OUT: The security view name
617 -------------------------------------------------------------------------------
618 function GET_SECURITY_VIEW (p_aw in varchar2)
619 return varchar2;
620
621 ---------------------------------------------------------------------------
622 -- GET_SOLVE_LEVEL_TABLE - Gets the solve input/output level table name
623 --
624 -- IN: p_aw - The AW
625 --
626 -- OUT: The solve input/output level table name
627 -------------------------------------------------------------------------------
628 function GET_SOLVE_LEVEL_TABLE (p_aw in varchar2)
629 return varchar2;
630
631 ---------------------------------------------------------------------------
632 -- GET_TO_CURRENCY_VIEW - Gets the to currency view name
633 --
634 -- IN: p_aw - The AW
635 --
636 -- OUT: The to currency view name
637 -------------------------------------------------------------------------------
638 function GET_TO_CURRENCY_VIEW (p_aw in varchar2)
639 return varchar2;
640
641 -------------------------------------------------------------------------------
642 -- GET_VIEW_OBJECT - Gets the measure view object name
643 --
644 -- IN: p_view - The Measure or Dimension view
645 -- OUT: The view's object name
646 -------------------------------------------------------------------------------
647 function GET_VIEW_OBJECT(p_view in varchar2)
648 return varchar2;
649
650 -------------------------------------------------------------------------------
651 -- GET_VIEW_TABLE - Gets the measure view table name
652 --
653 -- IN: p_view - The Measure or Dimension view
654 -- OUT: The view's table name
655 -------------------------------------------------------------------------------
656 function GET_VIEW_TABLE(p_view in varchar2)
657 return varchar2;
658
659 -------------------------------------------------------------------------------
660 -- UPGRADE_REPOS_NAME - Upgrades the repository name for a business area
661 -- to the new name
662 --
663 -- IN: p_business_area - The Business Area ID
664 -- p_old_name - The old name
665 -- p_new_name - The new name
666 -------------------------------------------------------------------------------
667 procedure UPGRADE_REPOS_NAME(p_business_area IN VARCHAR2,
668 p_old_name IN VARCHAR2,
669 p_new_name IN VARCHAR2);
670
671 end ZPB_METADATA_NAMES;