OLAPSYS.OLAPDIMVIEW dependencies on ALL_OLAP_DIM_HIERARCHIES

Line 144: TYPE hierarchyList_t IS TABLE OF ALL_OLAP_DIM_HIERARCHIES.DIMENSION_NAME%TYPE;

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;
147:
148: CURSOR curDispName IS SELECT DISPLAY_NAME

Line 169: FROM ALL_OLAP_DIM_HIERARCHIES WHERE

165: AND HIERARCHY_NAME= eHierName) V
166: ORDER BY V.P DESC;
167:
168: CURSOR curHierarchyName IS SELECT HIERARCHY_NAME
169: FROM ALL_OLAP_DIM_HIERARCHIES WHERE
170: OWNER= eOwnerName AND
171: DIMENSION_NAME= eDimName;
172:
173: CURSOR curColName IS SELECT COLUMN_NAME, POSITION

Line 1841: TYPE hierarchyList_t IS TABLE OF ALL_OLAP_DIM_HIERARCHIES.DIMENSION_NAME%TYPE;

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;
1844:
1845: CURSOR curDispName IS SELECT DISPLAY_NAME

Line 1866: FROM ALL_OLAP_DIM_HIERARCHIES WHERE

1862: AND HIERARCHY_NAME= eHierName) V
1863: ORDER BY V.P DESC;
1864:
1865: CURSOR curHierarchyName IS SELECT HIERARCHY_NAME
1866: FROM ALL_OLAP_DIM_HIERARCHIES WHERE
1867: OWNER= eOwnerName AND
1868: DIMENSION_NAME= eDimName;
1869:
1870: CURSOR curColName IS SELECT COLUMN_NAME, POSITION