APPS.FEM_CONDITIONS_API dependencies on ALL_TAB_COLUMNS

Line 151: FROM ALL_TAB_COLUMNS

147: AND COLUMN_NAME = p_columnName;
148:
149: CURSOR getCompDimColumnName IS
150: SELECT COLUMN_NAME
151: FROM ALL_TAB_COLUMNS
152: WHERE TABLE_NAME = p_tableName
153: AND COLUMN_NAME = p_columnName
154: AND OWNER = FEM_APP;
155:

Line 288: l_dataType ALL_TAB_COLUMNS.DATA_TYPE%TYPE;

284:
285:
286: l_schemaName ALL_SYNONYMS.TABLE_OWNER%TYPE;
287: l_tableName ALL_SYNONYMS.TABLE_NAME%TYPE;
288: l_dataType ALL_TAB_COLUMNS.DATA_TYPE%TYPE;
289:
290: BEGIN
291:
292: IF (p_isDimension) THEN

Line 320: FROM ALL_TAB_COLUMNS

316:
317:
318: SELECT DECODE (DATA_TYPE, 'NUMBER', 'NUMBER', 'DATE', 'DATE', 'STRING')
319: INTO l_dataType
320: FROM ALL_TAB_COLUMNS
321: WHERE TABLE_NAME = l_tableName
322: AND COLUMN_NAME = p_columnName
323: AND OWNER = l_schemaName;
324:

Line 1117: l_dataType ALL_TAB_COLUMNS.DATA_TYPE%TYPE;

1113:
1114: l_criteriaSequence NUMBER(9,0);
1115: l_value VARCHAR2(255);
1116: l_maxRangeValue VARCHAR2(255);
1117: l_dataType ALL_TAB_COLUMNS.DATA_TYPE%TYPE;
1118: l_canonicalDTMask varchar2(26) := 'YYYY/MM/DD HH24:MI:SS';
1119: l_byDimensionValue VARCHAR2(40) := p_byDimensionValue;
1120: l_columnPrefix VARCHAR2(30);
1121:

Line 2362: l_dataType ALL_TAB_COLUMNS.DATA_TYPE%TYPE;

2358: l_byDimensionValue VARCHAR2(40) := p_byDimensionValue;
2359:
2360: l_stepSpecificString LONG;
2361:
2362: l_dataType ALL_TAB_COLUMNS.DATA_TYPE%TYPE;
2363: l_canonicalDTMask varchar2(26) := 'YYYY/MM/DD HH24:MI:SS';
2364: l_tokenValue VARCHAR2(30);
2365:
2366: