68: ELSE
69:
70: SELECT flex_value_set_name
71: INTO g_flex_value_set_name
72: FROM fnd_flex_value_sets
73: WHERE flex_value_set_id = p_flex_value_set_id
74: ;
75:
76: g_flex_value_set_id := p_flex_value_set_id;
255: ELSE
256:
257: SELECT validation_type
258: INTO l_validation_type
259: FROM fnd_flex_value_sets
260: WHERE flex_value_set_id = p_flex_value_set_id;
261:
262: IF l_validation_type in ('I','X') THEN
263: