APPS.PO_UDA_TEMPLATES_UTIL dependencies on FND_FLEX_VALUES_VL

Line 4228: FROM FND_FLEX_VALUES_VL

4224: where flex_value_set_id = p_value_set_id;
4225:
4226: CURSOR c_flex_values(p_value_set_id NUMBER, p_attr_value VARCHAR2) IS
4227: SELECT FLEX_VALUE_MEANING
4228: FROM FND_FLEX_VALUES_VL
4229: WHERE flex_value_set_id = p_value_set_id
4230: AND FLEX_VALUE = p_attr_value;
4231:
4232: TYPE ref_cursor IS REF CURSOR;

Line 4258: independent or validation dependent fetch the meaning from FND_FLEX_VALUES_VL

4254: END IF;
4255:
4256: /*If value set is of table type fetch the query, execute it
4257: and find the meaning. Else if the value set is of type validation
4258: independent or validation dependent fetch the meaning from FND_FLEX_VALUES_VL
4259: If not of these 3 types display error invalid value set.*/
4260: IF (l_validation_type = 'F') THEN
4261: d_progress := 20;
4262:

Line 4358: FROM FND_FLEX_VALUES_VL

4354: where flex_value_set_id = p_value_set_id;
4355:
4356: CURSOR c_flex_values(p_value_set_id NUMBER, p_attr_value VARCHAR2) IS
4357: SELECT FLEX_VALUE_MEANING
4358: FROM FND_FLEX_VALUES_VL
4359: WHERE flex_value_set_id = p_value_set_id
4360: AND FLEX_VALUE = p_attr_value;
4361:
4362: TYPE ref_cursor IS REF CURSOR;

Line 4392: independent or validation dependent fetch the meaning from FND_FLEX_VALUES_VL

4388: END IF;
4389:
4390: /*If value set is of table type fetch the query, execute it
4391: and find the meaning. Else if the value set is of type validation
4392: independent or validation dependent fetch the meaning from FND_FLEX_VALUES_VL
4393: If not of these 3 types display error invalid value set.*/
4394:
4395: IF (l_validation_type = 'F') THEN
4396: d_progress := 20;