OLAPSYS.OLAPDIMVIEW dependencies on ALL_OLAP_LEVEL_KEY_COLUMN_USES

Line 146: TYPE colLvlList_t IS TABLE OF ALL_OLAP_LEVEL_KEY_COLUMN_USES.COLUMN_NAME%TYPE;

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;
147:
148: CURSOR curDispName IS SELECT DISPLAY_NAME
149: FROM ALL_OLAP_DIMENSIONS WHERE DIMENSION_NAME = eDimName AND
150: OWNER= eOwnerName;

Line 174: FROM ALL_OLAP_LEVEL_KEY_COLUMN_USES

170: OWNER= eOwnerName AND
171: DIMENSION_NAME= eDimName;
172:
173: CURSOR curColName IS SELECT COLUMN_NAME, POSITION
174: FROM ALL_OLAP_LEVEL_KEY_COLUMN_USES
175: WHERE OWNER= eOwnerName AND LEVEL_NAME= eLevelName
176: AND DIMENSION_NAME= eDimName;
177:
178: CURSOR curTabName IS SELECT LEVEL_TABLE_NAME

Line 230: FROM ALL_OLAP_LEVEL_KEY_COLUMN_USES

226: and QUERY_LEN= query_length;
227:
228:
229: CURSOR curLevDimName IS SELECT COLUMN_NAME
230: FROM ALL_OLAP_LEVEL_KEY_COLUMN_USES
231: WHERE OWNER= eOwnerName AND DIMENSION_NAME= eDimName;
232:
233:
234: CURSOR curAttrName IS SELECT COLUMN_NAME, ATTRIBUTE_NAME, LEVEL_NAME

Line 246: FROM ALL_OLAP_LEVEL_KEY_COLUMN_USES

242: WHERE OWNER= eOwnerName AND DIMENSION_NAME= eDimName
243: AND LEVEL_NAME= eLevelName;
244:
245: CURSOR curColDimName IS SELECT COLUMN_NAME, POSITION
246: FROM ALL_OLAP_LEVEL_KEY_COLUMN_USES
247: WHERE OWNER= eOwnerName AND DIMENSION_NAME= eDimName;
248:
249: dimHierList dimhierList_t:= dimhierList_t();
250: hierLevelList hierLevelList_t:= hierLevelList_t();

Line 1843: TYPE colLvlList_t IS TABLE OF ALL_OLAP_LEVEL_KEY_COLUMN_USES.COLUMN_NAME%TYPE;

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;
1844:
1845: CURSOR curDispName IS SELECT DISPLAY_NAME
1846: FROM ALL_OLAP_DIMENSIONS WHERE DIMENSION_NAME = eDimName AND
1847: OWNER= eOwnerName;

Line 1871: FROM ALL_OLAP_LEVEL_KEY_COLUMN_USES

1867: OWNER= eOwnerName AND
1868: DIMENSION_NAME= eDimName;
1869:
1870: CURSOR curColName IS SELECT COLUMN_NAME, POSITION
1871: FROM ALL_OLAP_LEVEL_KEY_COLUMN_USES
1872: WHERE OWNER= eOwnerName AND LEVEL_NAME= eLevelName
1873: AND DIMENSION_NAME= eDimName;
1874:
1875: CURSOR curTabName IS SELECT LEVEL_TABLE_NAME

Line 1927: FROM ALL_OLAP_LEVEL_KEY_COLUMN_USES

1923: and QUERY_LEN= query_length;
1924:
1925:
1926: CURSOR curLevDimName IS SELECT LEVEL_NAME
1927: FROM ALL_OLAP_LEVEL_KEY_COLUMN_USES
1928: WHERE OWNER= eOwnerName AND DIMENSION_NAME= eDimName;
1929:
1930:
1931: CURSOR curAttrName IS SELECT COLUMN_NAME,ATTRIBUTE_NAME, LEVEL_NAME

Line 1943: FROM ALL_OLAP_LEVEL_KEY_COLUMN_USES

1939: WHERE OWNER= eOwnerName AND DIMENSION_NAME= eDimName
1940: AND LEVEL_NAME= eLevelName;
1941:
1942: CURSOR curColDimName IS SELECT COLUMN_NAME, POSITION
1943: FROM ALL_OLAP_LEVEL_KEY_COLUMN_USES
1944: WHERE OWNER= eOwnerName AND DIMENSION_NAME= eDimName;
1945:
1946:
1947: dimHierList dimhierList_t:= dimhierList_t();