1250: return(v_flex_value);
1251: else
1252: select flex_value_set_name
1253: into vsname
1254: from fnd_flex_value_sets
1255: where flex_value_set_id = v_flex_value_set_id;
1256:
1257: vsid := v_flex_value_set_id;
1258:
1261: if (v_flex_value_set_id is null)
1262: then
1263: select flex_value_set_id
1264: into vsid
1265: from fnd_flex_value_sets
1266: where flex_value_set_name = v_flex_value_set_name;
1267:
1268: else
1269: vsid := v_flex_value_set_id;
1414: return(v_flex_value);
1415: else
1416: select flex_value_set_name
1417: into vsname
1418: from fnd_flex_value_sets
1419: where flex_value_set_id = v_flex_value_set_id;
1420:
1421: vsid := v_flex_value_set_id;
1422:
1425: if (v_flex_value_set_id is null)
1426: then
1427: select flex_value_set_id
1428: into vsid
1429: from fnd_flex_value_sets
1430: where flex_value_set_name = v_flex_value_set_name;
1431:
1432: else
1433: vsid := v_flex_value_set_id;