[Home] [Help]
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 ;
1174:
1175: RETURN l_uom_column_name;
1864: BEGIN
1865:
1866: SELECT FT.TABLE_ID
1867: INTO l_ext_table_id
1868: FROM FND_TABLES FT
1869: ,EGO_ATTR_GROUP_TYPES_V EAGTV
1870: WHERE FT.TABLE_NAME = EAGTV.EXT_TABLE_NAME
1871: AND EAGTV.APPLICATION_ID = p_application_id
1872: AND EAGTV.ATTR_GROUP_TYPE = p_attr_group_type;
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);
5043:
5044: IF (((p_data_type = G_CHAR_DATA_TYPE OR
5045: p_data_type = G_TRANS_TEXT_DATA_TYPE) AND
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);
5945:
5946: IF ( ((SUBSTR(p_column,1,11) = 'TL_EXT_ATTR') OR
5947: (SUBSTR(p_column,1,10) = 'C_EXT_ATTR')) AND