1402: return(v_flex_value);
1403: else
1404: select flex_value_set_name
1405: into vsname
1406: from fnd_flex_value_sets
1407: where flex_value_set_id = v_flex_value_set_id;
1408:
1409: vsid := v_flex_value_set_id;
1410:
1413: if (v_flex_value_set_id is null)
1414: then
1415: select flex_value_set_id
1416: into vsid
1417: from fnd_flex_value_sets
1418: where flex_value_set_name = v_flex_value_set_name;
1419:
1420: else
1421: vsid := v_flex_value_set_id;
1566: return(v_flex_value);
1567: else
1568: select flex_value_set_name
1569: into vsname
1570: from fnd_flex_value_sets
1571: where flex_value_set_id = v_flex_value_set_id;
1572:
1573: vsid := v_flex_value_set_id;
1574:
1577: if (v_flex_value_set_id is null)
1578: then
1579: select flex_value_set_id
1580: into vsid
1581: from fnd_flex_value_sets
1582: where flex_value_set_name = v_flex_value_set_name;
1583:
1584: else
1585: vsid := v_flex_value_set_id;