APPS.FND_FLEX_XML_PUBLISHER_APIS dependencies on FND_FLEX_VALUE_SETS

Line 1010: l_parent_value_set_id fnd_flex_value_sets.parent_flex_value_set_id%TYPE;

1006: l_column_names varchar2_30_array_type;
1007: l_nsegments NUMBER;
1008: l_tmp_number NUMBER;
1009: l_display_index NUMBER;
1010: l_parent_value_set_id fnd_flex_value_sets.parent_flex_value_set_id%TYPE;
1011: l_value fnd_plsql_cache.generic_cache_value_type;
1012: l_key VARCHAR2(2000);
1013: l_values fnd_plsql_cache.generic_cache_values_type;
1014: l_numof_values NUMBER;

Line 1365: FROM fnd_flex_value_sets

1361: --
1362: -- Entity is not in the cache, get it from DB.
1363: --
1364: SELECT parent_flex_value_set_id INTO l_parent_value_set_id
1365: FROM fnd_flex_value_sets
1366: WHERE flex_value_set_id = l_segment_info_array(i).flex_value_set_id;
1367: --
1368: -- Create the cache value, and populate it with values came from DB.
1369: --

Line 2477: FROM fnd_flex_value_sets ffvs

2473:
2474: ELSIF (l_datatype = 'D' AND l_flex_value_set_id is NOT NULL) THEN
2475: SELECT format_type, maximum_size
2476: INTO l_format_type, l_maximum_size
2477: FROM fnd_flex_value_sets ffvs
2478: WHERE ffvs.flex_value_set_id = l_flex_value_set_id;
2479:
2480: IF (l_format_type = 'D') THEN -- Date type
2481: