APPS.EGO_EXT_FWK_PUB dependencies on FND_COLUMNS

Line 1169: FROM FND_COLUMNS

1165: IF ( INSTR (p_column, 'N_EXT_ATTR' ) = 0) THEN
1166:
1167: SELECT COLUMN_NAME
1168: INTO l_uom_column_name
1169: FROM FND_COLUMNS
1170: WHERE TABLE_ID =
1171: (SELECT TABLE_ID FROM FND_TABLES
1172: WHERE TABLE_NAME = p_table_name)
1173: AND COLUMN_NAME = 'UOM_'||p_column ;

Line 1832: FROM FND_COLUMNS

1828: ,cp_column_type IN VARCHAR2
1829: ,cp_column_prefix IN VARCHAR2
1830: ) IS
1831: SELECT COLUMN_NAME
1832: FROM FND_COLUMNS
1833: WHERE APPLICATION_ID = cp_application_id
1834: AND TABLE_ID = cp_table_id
1835: AND COLUMN_TYPE = cp_column_type
1836: AND COLUMN_NAME LIKE cp_column_prefix

Line 1852: FROM FND_COLUMNS FC

1848: ,cp_table_id IN NUMBER
1849: ,cp_column_type IN VARCHAR2
1850: ) IS
1851: SELECT FC.COLUMN_NAME
1852: FROM FND_COLUMNS FC
1853: ,EGO_FND_DF_COL_USGS_EXT EXT
1854: WHERE EXT.APPLICATION_ID = cp_application_id
1855: AND EXT.DESCRIPTIVE_FLEXFIELD_NAME = cp_attr_group_type
1856: AND EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = cp_attr_group_name

Line 5038: FROM FND_COLUMNS

5034: BEGIN
5035:
5036: SELECT COLUMN_TYPE , WIDTH
5037: INTO l_col_data_type, l_col_width
5038: FROM FND_COLUMNS
5039: WHERE COLUMN_NAME = p_column
5040: AND TABLE_ID = (SELECT TABLE_ID
5041: FROM FND_TABLES
5042: WHERE TABLE_NAME = l_table_name);

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

5051:
5052: /***
5053: TO DO: right now we can't verify that TransText Attributes use TL-type columns,
5054: because we can't rely on the column being named 'TL_EXT_ATTR%' and we aren't
5055: using FND_COLUMNS's TRANSLATE_FLAG column yet; but we should be, and we should
5056: add to the IF check above that if the data type is TransText and the column's
5057: TRANSLATE_FLAG isn't 'Y' then we should error out.
5058: ***/
5059:

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

5868: IF (p_searchable = 'Y') THEN
5869:
5870: -- l_data_type_is_trans_text := (SUBSTR(p_column,1,11) = 'TL_EXT_ATTR');
5871: /***
5872: TO DO: right now we aren't using FND_COLUMNS's TRANSLATE_FLAG column, but we
5873: should be, and we should use that flag to determine if the Attr is TransText
5874: ...or else we should see which table this column's in, but that's an
5875: expensive query, I'd guess
5876: ***/

Line 5940: FROM FND_COLUMNS

5936: END IF ;
5937:
5938: SELECT WIDTH
5939: INTO l_col_width
5940: FROM FND_COLUMNS
5941: WHERE COLUMN_NAME = p_column
5942: AND TABLE_ID = (SELECT TABLE_ID
5943: FROM FND_TABLES
5944: WHERE TABLE_NAME = l_table_name);