293: l_rowid VARCHAR2(64);
294: BEGIN
295: SELECT flex_value_set_id
296: INTO l_flex_value_set_id
297: FROM fnd_flex_value_sets
298: WHERE flex_value_set_name = x_flex_value_set_name;
299:
300: BEGIN
301: SELECT hierarchy_id
353: (SELECT flex_value_set_id, hierarchy_id
354: FROM fnd_flex_hierarchies
355: WHERE (flex_value_set_id =
356: (SELECT flex_value_set_id
357: FROM fnd_flex_value_sets
358: WHERE flex_value_set_name = x_flex_value_set_name))
359: AND hierarchy_code = x_hierarchy_code))
360: AND userenv('LANG') in (language, source_lang);
361: END translate_row;