OLAPSYS.OLAPFACTVIEW dependencies on ALL_OLAP_DIM_HIERARCHIES

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

135: -- TYPE dimList IS TABLE OF ALL_OLAP_FACT_LEVEL_USES.DIMENSION_NAME%TYPE
136:
137: TYPE levList_t IS TABLE OF ALL_OLAP_DIM_LEVELS.LEVEL_NAME%TYPE;
138:
139: TYPE hierarchyList_t IS TABLE OF ALL_OLAP_DIM_HIERARCHIES.DIMENSION_NAME%TYPE;
140:
141: TYPE colLvlList_t IS TABLE OF ALL_OLAP_LEVEL_KEY_COLUMN_USES.COLUMN_NAME%TYPE;
142:
143:

Line 162: FROM ALL_OLAP_DIM_HIERARCHIES WHERE

158: AND HIERARCHY_NAME= eHierName) V
159: ORDER BY V.P DESC;
160:
161: CURSOR curHierarchyName IS SELECT HIERARCHY_NAME
162: FROM ALL_OLAP_DIM_HIERARCHIES WHERE
163: OWNER= eOwnerName AND
164: DIMENSION_NAME= eDimName;
165:
166: CURSOR curColName IS SELECT COLUMN_NAME, POSITION

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

1893: -- TYPE dimList IS TABLE OF ALL_OLAP_FACT_LEVEL_USES.DIMENSION_NAME%TYPE
1894:
1895: TYPE levList_t IS TABLE OF ALL_OLAP_DIM_LEVELS.LEVEL_NAME%TYPE;
1896:
1897: TYPE hierarchyList_t IS TABLE OF ALL_OLAP_DIM_HIERARCHIES.DIMENSION_NAME%TYPE;
1898:
1899: TYPE colLvlList_t IS TABLE OF ALL_OLAP_LEVEL_KEY_COLUMN_USES.COLUMN_NAME%TYPE;
1900:
1901:

Line 1920: FROM ALL_OLAP_DIM_HIERARCHIES WHERE

1916: AND HIERARCHY_NAME= eHierName) V
1917: ORDER BY V.P DESC;
1918:
1919: CURSOR curHierarchyName IS SELECT HIERARCHY_NAME
1920: FROM ALL_OLAP_DIM_HIERARCHIES WHERE
1921: OWNER= eOwnerName AND
1922: DIMENSION_NAME= eDimName;
1923:
1924: CURSOR curColName IS SELECT COLUMN_NAME, POSITION