OLAPSYS.OLAPDIMVIEW dependencies on ALL_OLAP_DIM_LEVELS

Line 142: TYPE levList_t IS TABLE OF ALL_OLAP_DIM_LEVELS.LEVEL_NAME%TYPE;

138:
139: TYPE dimList_t IS TABLE OF dimType;
140: -- TYPE dimList IS TABLE OF ALL_OLAP_FACT_LEVEL_USES.DIMENSION_NAME%TYPE
141:
142: TYPE levList_t IS TABLE OF ALL_OLAP_DIM_LEVELS.LEVEL_NAME%TYPE;
143:
144: TYPE hierarchyList_t IS TABLE OF ALL_OLAP_DIM_HIERARCHIES.DIMENSION_NAME%TYPE;
145:
146: TYPE colLvlList_t IS TABLE OF ALL_OLAP_LEVEL_KEY_COLUMN_USES.COLUMN_NAME%TYPE;

Line 179: FROM ALL_OLAP_DIM_LEVELS

175: WHERE OWNER= eOwnerName AND LEVEL_NAME= eLevelName
176: AND DIMENSION_NAME= eDimName;
177:
178: CURSOR curTabName IS SELECT LEVEL_TABLE_NAME
179: FROM ALL_OLAP_DIM_LEVELS
180: WHERE OWNER= eOwnerName AND LEVEL_NAME= eLevelName
181: AND DIMENSION_NAME= eDimName;
182:
183: CURSOR curParentName IS SELECT TABLE_NAME || '.' || COLUMN_NAME, TABLE_NAME

Line 241: FROM ALL_OLAP_DIM_LEVELS

237: AND LEVEL_NAME= eeLevelName;
238:
239:
240: CURSOR curAttrTabName IS SELECT LEVEL_TABLE_NAME
241: FROM ALL_OLAP_DIM_LEVELS
242: WHERE OWNER= eOwnerName AND DIMENSION_NAME= eDimName
243: AND LEVEL_NAME= eLevelName;
244:
245: CURSOR curColDimName IS SELECT COLUMN_NAME, POSITION

Line 1839: TYPE levList_t IS TABLE OF ALL_OLAP_DIM_LEVELS.LEVEL_NAME%TYPE;

1835:
1836: TYPE dimList_t IS TABLE OF dimType;
1837: -- TYPE dimList IS TABLE OF ALL_OLAP_FACT_LEVEL_USES.DIMENSION_NAME%TYPE
1838:
1839: TYPE levList_t IS TABLE OF ALL_OLAP_DIM_LEVELS.LEVEL_NAME%TYPE;
1840:
1841: TYPE hierarchyList_t IS TABLE OF ALL_OLAP_DIM_HIERARCHIES.DIMENSION_NAME%TYPE;
1842:
1843: TYPE colLvlList_t IS TABLE OF ALL_OLAP_LEVEL_KEY_COLUMN_USES.COLUMN_NAME%TYPE;

Line 1876: FROM ALL_OLAP_DIM_LEVELS

1872: WHERE OWNER= eOwnerName AND LEVEL_NAME= eLevelName
1873: AND DIMENSION_NAME= eDimName;
1874:
1875: CURSOR curTabName IS SELECT LEVEL_TABLE_NAME
1876: FROM ALL_OLAP_DIM_LEVELS
1877: WHERE OWNER= eOwnerName AND LEVEL_NAME= eLevelName
1878: AND DIMENSION_NAME= eDimName;
1879:
1880: CURSOR curParentName IS SELECT TABLE_NAME || '.' || COLUMN_NAME, TABLE_NAME

Line 1938: FROM ALL_OLAP_DIM_LEVELS

1934: AND LEVEL_NAME= eeLevelName;
1935:
1936:
1937: CURSOR curAttrTabName IS SELECT LEVEL_TABLE_NAME
1938: FROM ALL_OLAP_DIM_LEVELS
1939: WHERE OWNER= eOwnerName AND DIMENSION_NAME= eDimName
1940: AND LEVEL_NAME= eLevelName;
1941:
1942: CURSOR curColDimName IS SELECT COLUMN_NAME, POSITION