APPS.FND_FLEX_VAL_API dependencies on FND_FLEX_VALUES_VL

Line 8: SUBTYPE value_type IS fnd_flex_values_vl%ROWTYPE;

4:
5: chr_newline CONSTANT VARCHAR2(8) := fnd_global.newline;
6:
7: SUBTYPE vset_type IS fnd_flex_value_sets%ROWTYPE;
8: SUBTYPE value_type IS fnd_flex_values_vl%ROWTYPE;
9:
10: TYPE bind_record_type IS RECORD
11: (pos number,
12: type VARCHAR2(1));

Line 2139: l_tvset.application_table_name := 'FND_FLEX_VALUES_VL';

2135: x_success := g_ret_others;
2136: RETURN;
2137: END;
2138: ELSIF (l_vset.validation_type IN ('I','D')) THEN
2139: l_tvset.application_table_name := 'FND_FLEX_VALUES_VL';
2140:
2141: l_tvset.value_column_name := 'FLEX_VALUE';
2142: l_tvset.value_column_type := 'V';
2143: l_tvset.value_column_size := 150;

Line 2800: FROM fnd_flex_values_vl

2796: IF (p_vset.validation_type = 'I') THEN
2797: BEGIN
2798: SELECT *
2799: INTO px_value
2800: FROM fnd_flex_values_vl
2801: WHERE flex_value_set_id = p_vset.flex_value_set_id
2802: AND flex_value = p_flex_value;
2803: EXCEPTION
2804: WHEN OTHERS THEN

Line 2813: FROM fnd_flex_values_vl

2809: ELSIF (p_vset.validation_type = 'D') THEN
2810: BEGIN
2811: SELECT *
2812: INTO px_value
2813: FROM fnd_flex_values_vl
2814: WHERE flex_value_set_id = p_vset.flex_value_set_id
2815: AND parent_flex_value_low = p_parent_value
2816: AND flex_value = p_flex_value;
2817: EXCEPTION