OLAPSYS.OLAPFACTVIEW dependencies on ALL_OLAP_LEVEL_KEY_COLUMN_USES

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

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:
144:
145: CURSOR curDimName IS SELECT DIMENSION_NAME

Line 167: FROM ALL_OLAP_LEVEL_KEY_COLUMN_USES

163: OWNER= eOwnerName AND
164: DIMENSION_NAME= eDimName;
165:
166: CURSOR curColName IS SELECT COLUMN_NAME, POSITION
167: FROM ALL_OLAP_LEVEL_KEY_COLUMN_USES
168: WHERE OWNER= eOwnerName AND LEVEL_NAME= eLevelName
169: AND DIMENSION_NAME= eDimName ;
170:
171: CURSOR curTabName IS SELECT LEVEL_TABLE_NAME

Line 224: FROM ALL_OLAP_LEVEL_KEY_COLUMN_USES

220: and QUERY_LEN= query_length;
221:
222:
223: CURSOR curLevDimName IS SELECT LEVEL_NAME
224: FROM ALL_OLAP_LEVEL_KEY_COLUMN_USES
225: WHERE OWNER= eOwnerName AND DIMENSION_NAME= eDimName;
226:
227: CURSOR curColDimName IS SELECT COLUMN_NAME, POSITION
228: FROM ALL_OLAP_LEVEL_KEY_COLUMN_USES

Line 228: FROM ALL_OLAP_LEVEL_KEY_COLUMN_USES

224: FROM ALL_OLAP_LEVEL_KEY_COLUMN_USES
225: WHERE OWNER= eOwnerName AND DIMENSION_NAME= eDimName;
226:
227: CURSOR curColDimName IS SELECT COLUMN_NAME, POSITION
228: FROM ALL_OLAP_LEVEL_KEY_COLUMN_USES
229: WHERE OWNER= eOwnerName AND DIMENSION_NAME= eDimName;
230:
231: dimHierList dimhierList_t:= dimhierList_t();
232: hierLevelList hierLevelList_t:= hierLevelList_t();

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

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:
1902:
1903: CURSOR curDimName IS SELECT DIMENSION_NAME

Line 1925: FROM ALL_OLAP_LEVEL_KEY_COLUMN_USES

1921: OWNER= eOwnerName AND
1922: DIMENSION_NAME= eDimName;
1923:
1924: CURSOR curColName IS SELECT COLUMN_NAME, POSITION
1925: FROM ALL_OLAP_LEVEL_KEY_COLUMN_USES
1926: WHERE OWNER= eOwnerName AND LEVEL_NAME= eLevelName
1927: AND DIMENSION_NAME= eDimName ;
1928:
1929: CURSOR curTabName IS SELECT LEVEL_TABLE_NAME

Line 1982: FROM ALL_OLAP_LEVEL_KEY_COLUMN_USES

1978: and QUERY_LEN= query_length;
1979:
1980:
1981: CURSOR curLevDimName IS SELECT LEVEL_NAME
1982: FROM ALL_OLAP_LEVEL_KEY_COLUMN_USES
1983: WHERE OWNER= eOwnerName AND DIMENSION_NAME= eDimName;
1984:
1985: CURSOR curColDimName IS SELECT COLUMN_NAME, POSITION
1986: FROM ALL_OLAP_LEVEL_KEY_COLUMN_USES

Line 1986: FROM ALL_OLAP_LEVEL_KEY_COLUMN_USES

1982: FROM ALL_OLAP_LEVEL_KEY_COLUMN_USES
1983: WHERE OWNER= eOwnerName AND DIMENSION_NAME= eDimName;
1984:
1985: CURSOR curColDimName IS SELECT COLUMN_NAME, POSITION
1986: FROM ALL_OLAP_LEVEL_KEY_COLUMN_USES
1987: WHERE OWNER= eOwnerName AND DIMENSION_NAME= eDimName;
1988:
1989: dimHierList dimhierList_t:= dimhierList_t();
1990: hierLevelList hierLevelList_t:= hierLevelList_t();