APPS.EGO_EXT_FWK_PUB dependencies on FND_COLUMNS

Line 1209: FROM FND_COLUMNS

1205: IF ( INSTR (p_column, 'N_EXT_ATTR' ) = 0) THEN
1206:
1207: SELECT COLUMN_NAME
1208: INTO l_uom_column_name
1209: FROM FND_COLUMNS
1210: WHERE TABLE_ID =
1211: (SELECT TABLE_ID FROM FND_TABLES
1212: WHERE TABLE_NAME = p_table_name)
1213: AND COLUMN_NAME = 'UOM_'||p_column ;

Line 1914: FROM FND_COLUMNS

1910: ,cp_column_type IN VARCHAR2
1911: ,cp_column_prefix IN VARCHAR2
1912: ) IS
1913: SELECT COLUMN_NAME
1914: FROM FND_COLUMNS
1915: WHERE APPLICATION_ID = cp_application_id
1916: AND TABLE_ID = cp_table_id
1917: AND COLUMN_TYPE = cp_column_type
1918: AND COLUMN_NAME LIKE cp_column_prefix

Line 1934: FROM FND_COLUMNS FC

1930: ,cp_table_id IN NUMBER
1931: ,cp_column_type IN VARCHAR2
1932: ) IS
1933: SELECT FC.COLUMN_NAME
1934: FROM FND_COLUMNS FC
1935: ,EGO_FND_DF_COL_USGS_EXT EXT
1936: WHERE EXT.APPLICATION_ID = cp_application_id
1937: AND EXT.DESCRIPTIVE_FLEXFIELD_NAME = cp_attr_group_type
1938: AND EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = cp_attr_group_name

Line 5245: FROM FND_COLUMNS

5241: BEGIN
5242:
5243: SELECT COLUMN_TYPE , WIDTH
5244: INTO l_col_data_type, l_col_width
5245: FROM FND_COLUMNS
5246: WHERE COLUMN_NAME = p_column
5247: AND TABLE_ID = (SELECT TABLE_ID
5248: FROM FND_TABLES
5249: WHERE TABLE_NAME = l_table_name);

Line 5262: using FND_COLUMNS's TRANSLATE_FLAG column yet; but we should be, and we should

5258:
5259: /***
5260: TO DO: right now we can't verify that TransText Attributes use TL-type columns,
5261: because we can't rely on the column being named 'TL_EXT_ATTR%' and we aren't
5262: using FND_COLUMNS's TRANSLATE_FLAG column yet; but we should be, and we should
5263: add to the IF check above that if the data type is TransText and the column's
5264: TRANSLATE_FLAG isn't 'Y' then we should error out.
5265: ***/
5266:

Line 6168: TO DO: right now we aren't using FND_COLUMNS's TRANSLATE_FLAG column, but we

6164: IF (p_searchable = 'Y') THEN
6165:
6166: -- l_data_type_is_trans_text := (SUBSTR(p_column,1,11) = 'TL_EXT_ATTR');
6167: /***
6168: TO DO: right now we aren't using FND_COLUMNS's TRANSLATE_FLAG column, but we
6169: should be, and we should use that flag to determine if the Attr is TransText
6170: ...or else we should see which table this column's in, but that's an
6171: expensive query, I'd guess
6172: ***/

Line 6236: FROM FND_COLUMNS

6232: END IF ;
6233:
6234: SELECT WIDTH
6235: INTO l_col_width
6236: FROM FND_COLUMNS
6237: WHERE COLUMN_NAME = p_column
6238: AND TABLE_ID = (SELECT TABLE_ID
6239: FROM FND_TABLES
6240: WHERE TABLE_NAME = l_table_name);