1 PACKAGE BIS_PMF_GET_DIMLEVELS_PUB AS
2 /* $Header: BISPGDLS.pls 120.2 2005/06/27 04:46:37 arhegde noship $ */
3 /*
4 REM dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=pls \
5 REM dbdrv: checkfile(115.13=120.2):~PROD:~PATH:~FILE
6 REM +=======================================================================+
7 REM | Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA |
8 REM | All rights reserved. |
9 REM +=======================================================================+
10 REM | FILENAME |
11 REM | BISVGDLS.pls |
12 REM | |
13 REM | DESCRIPTION |
14 REM | Public API for getting the Select String for DimensionLevelValues|
15 REM | This API will get the Select String from either EDW or BIS
16 REM | depending on the profile option BIS_SOURCE
17 REM | |
18 REM | HISTORY |
19 REM | December-2000 amkulkar Creation |
20 REM | 09-MAY-2003 arhegde Added record and table types for child and |
21 REM | parent dim level info , enh 2819971 |
22 REM | 27-JUN-2005 arhegde bug# 4456833 Added ri_attribute_code to dimlvl & |
23 REM | dim rel rec |
24 REM +=======================================================================+
25 */
26 --
27 TYPE dimlvl_rec_type IS RECORD (
28 dimension_short_name VARCHAR2(80) := NULL
29 ,dimension_level_short_name VARCHAR2(80) := NULL
30 ,dimension_level_value_id VARCHAR2(32000) := NULL
31 ,ri_attribute_code VARCHAR2(2000) := NULL
32 );
33
34 TYPE dimlvl_tbl_type IS TABLE OF dimlvl_rec_type INDEX BY BINARY_INTEGER;
35
36 TYPE dim_rel_info_rec IS RECORD (
37 dimension_short_name VARCHAR2(80) := NULL
38 ,dimension_level_short_name VARCHAR2(80) := NULL
39 ,parent_dimension_short_name VARCHAR2(80) := NULL
40 ,parent_level_short_name VARCHAR2(80) := NULL
41 ,parent_dim_level_value_id VARCHAR2(32000) := NULL
42 ,relation_col VARCHAR2(80) := NULL
43 ,relation_type NUMBER := NULL
44 ,parent_ri_attribute_code VARCHAR2(2000) := NULL
45 );
46
47
48 PROCEDURE GET_DIMLEVEL_SELECT_STRING
49 (
50 p_DimLevelShortName IN VARCHAR2
51 ,p_bis_source IN VARCHAR2
52 ,x_Select_String OUT NOCOPY VARCHAR2
53 ,x_table_name OUT NOCOPY VARCHAR2
54 ,x_id_name OUT NOCOPY VARCHAR2
55 ,x_value_name OUT NOCOPY VARCHAR2
56 ,x_return_status OUT NOCOPY VARCHAR2
57 ,x_msg_count OUT NOCOPY NUMBER
58 ,x_msg_data OUT NOCOPY VARCHAR2
59 );
60 --
61 PROCEDURE GET_SORTED_SELECT_STRING
62 (
63 p_DimLevelShortName IN VARCHAR2
64 ,p_bis_source IN VARCHAR2
65 ,x_Select_String OUT NOCOPY VARCHAR2
66 ,x_table_name OUT NOCOPY VARCHAR2
67 ,x_id_name OUT NOCOPY VARCHAR2
68 ,x_value_name OUT NOCOPY VARCHAR2
69 ,x_return_status OUT NOCOPY VARCHAR2
70 ,x_msg_count OUT NOCOPY NUMBER
71 ,x_msg_data OUT NOCOPY VARCHAR2
72 );
73
74 END BIS_PMF_GET_DIMLEVELS_PUB;