APPS.HR_FLEX_VALUE_SET_INFO dependencies on FND_FLEX_VALUE_SETS

Line 8: (flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE

4: --
5: -- Global types
6: --
7: TYPE t_value_set IS RECORD
8: (flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE
9: ,additional_column1_title VARCHAR2(2000)
10: ,additional_column1_width VARCHAR2(2000)
11: ,additional_column2_title VARCHAR2(2000)
12: ,additional_column2_width VARCHAR2(2000)

Line 15: ,alphanumeric_allowed_flag fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE

11: ,additional_column2_title VARCHAR2(2000)
12: ,additional_column2_width VARCHAR2(2000)
13: ,additional_column3_title VARCHAR2(2000)
14: ,additional_column3_width VARCHAR2(2000)
15: ,alphanumeric_allowed_flag fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE
16: ,flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE
17: ,format_type fnd_flex_value_sets.format_type%TYPE
18: ,identification_sql VARCHAR2(32767)
19: ,id_column_type VARCHAR2(1)

Line 16: ,flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE

12: ,additional_column2_width VARCHAR2(2000)
13: ,additional_column3_title VARCHAR2(2000)
14: ,additional_column3_width VARCHAR2(2000)
15: ,alphanumeric_allowed_flag fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE
16: ,flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE
17: ,format_type fnd_flex_value_sets.format_type%TYPE
18: ,identification_sql VARCHAR2(32767)
19: ,id_column_type VARCHAR2(1)
20: ,has_meaning BOOLEAN

Line 17: ,format_type fnd_flex_value_sets.format_type%TYPE

13: ,additional_column3_title VARCHAR2(2000)
14: ,additional_column3_width VARCHAR2(2000)
15: ,alphanumeric_allowed_flag fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE
16: ,flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE
17: ,format_type fnd_flex_value_sets.format_type%TYPE
18: ,identification_sql VARCHAR2(32767)
19: ,id_column_type VARCHAR2(1)
20: ,has_meaning BOOLEAN
21: ,longlist_flag fnd_flex_value_sets.longlist_flag%TYPE

Line 21: ,longlist_flag fnd_flex_value_sets.longlist_flag%TYPE

17: ,format_type fnd_flex_value_sets.format_type%TYPE
18: ,identification_sql VARCHAR2(32767)
19: ,id_column_type VARCHAR2(1)
20: ,has_meaning BOOLEAN
21: ,longlist_flag fnd_flex_value_sets.longlist_flag%TYPE
22: ,maximum_size fnd_flex_value_sets.maximum_size%TYPE
23: ,maximum_value fnd_flex_value_sets.maximum_value%TYPE
24: ,minimum_value fnd_flex_value_sets.minimum_value%TYPE
25: ,number_precision fnd_flex_value_sets.number_precision%TYPE

Line 22: ,maximum_size fnd_flex_value_sets.maximum_size%TYPE

18: ,identification_sql VARCHAR2(32767)
19: ,id_column_type VARCHAR2(1)
20: ,has_meaning BOOLEAN
21: ,longlist_flag fnd_flex_value_sets.longlist_flag%TYPE
22: ,maximum_size fnd_flex_value_sets.maximum_size%TYPE
23: ,maximum_value fnd_flex_value_sets.maximum_value%TYPE
24: ,minimum_value fnd_flex_value_sets.minimum_value%TYPE
25: ,number_precision fnd_flex_value_sets.number_precision%TYPE
26: ,numeric_mode_enabled_flag fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE

Line 23: ,maximum_value fnd_flex_value_sets.maximum_value%TYPE

19: ,id_column_type VARCHAR2(1)
20: ,has_meaning BOOLEAN
21: ,longlist_flag fnd_flex_value_sets.longlist_flag%TYPE
22: ,maximum_size fnd_flex_value_sets.maximum_size%TYPE
23: ,maximum_value fnd_flex_value_sets.maximum_value%TYPE
24: ,minimum_value fnd_flex_value_sets.minimum_value%TYPE
25: ,number_precision fnd_flex_value_sets.number_precision%TYPE
26: ,numeric_mode_enabled_flag fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE
27: ,uppercase_only_flag fnd_flex_value_sets.uppercase_only_flag%TYPE

Line 24: ,minimum_value fnd_flex_value_sets.minimum_value%TYPE

20: ,has_meaning BOOLEAN
21: ,longlist_flag fnd_flex_value_sets.longlist_flag%TYPE
22: ,maximum_size fnd_flex_value_sets.maximum_size%TYPE
23: ,maximum_value fnd_flex_value_sets.maximum_value%TYPE
24: ,minimum_value fnd_flex_value_sets.minimum_value%TYPE
25: ,number_precision fnd_flex_value_sets.number_precision%TYPE
26: ,numeric_mode_enabled_flag fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE
27: ,uppercase_only_flag fnd_flex_value_sets.uppercase_only_flag%TYPE
28: ,validation_sql VARCHAR2(32767)

Line 25: ,number_precision fnd_flex_value_sets.number_precision%TYPE

21: ,longlist_flag fnd_flex_value_sets.longlist_flag%TYPE
22: ,maximum_size fnd_flex_value_sets.maximum_size%TYPE
23: ,maximum_value fnd_flex_value_sets.maximum_value%TYPE
24: ,minimum_value fnd_flex_value_sets.minimum_value%TYPE
25: ,number_precision fnd_flex_value_sets.number_precision%TYPE
26: ,numeric_mode_enabled_flag fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE
27: ,uppercase_only_flag fnd_flex_value_sets.uppercase_only_flag%TYPE
28: ,validation_sql VARCHAR2(32767)
29: ,validation_type fnd_flex_value_sets.validation_type%TYPE

Line 26: ,numeric_mode_enabled_flag fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE

22: ,maximum_size fnd_flex_value_sets.maximum_size%TYPE
23: ,maximum_value fnd_flex_value_sets.maximum_value%TYPE
24: ,minimum_value fnd_flex_value_sets.minimum_value%TYPE
25: ,number_precision fnd_flex_value_sets.number_precision%TYPE
26: ,numeric_mode_enabled_flag fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE
27: ,uppercase_only_flag fnd_flex_value_sets.uppercase_only_flag%TYPE
28: ,validation_sql VARCHAR2(32767)
29: ,validation_type fnd_flex_value_sets.validation_type%TYPE
30: );

Line 27: ,uppercase_only_flag fnd_flex_value_sets.uppercase_only_flag%TYPE

23: ,maximum_value fnd_flex_value_sets.maximum_value%TYPE
24: ,minimum_value fnd_flex_value_sets.minimum_value%TYPE
25: ,number_precision fnd_flex_value_sets.number_precision%TYPE
26: ,numeric_mode_enabled_flag fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE
27: ,uppercase_only_flag fnd_flex_value_sets.uppercase_only_flag%TYPE
28: ,validation_sql VARCHAR2(32767)
29: ,validation_type fnd_flex_value_sets.validation_type%TYPE
30: );
31: --

Line 29: ,validation_type fnd_flex_value_sets.validation_type%TYPE

25: ,number_precision fnd_flex_value_sets.number_precision%TYPE
26: ,numeric_mode_enabled_flag fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE
27: ,uppercase_only_flag fnd_flex_value_sets.uppercase_only_flag%TYPE
28: ,validation_sql VARCHAR2(32767)
29: ,validation_type fnd_flex_value_sets.validation_type%TYPE
30: );
31: --
32: -- -----------------------------------------------------------------------------
33: -- |-------------------------------< value_set >-------------------------------|

Line 61: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE

57: --
58: -- {End of Comments}
59: -- -----------------------------------------------------------------------------
60: FUNCTION value_set
61: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
62: ,p_effective_date IN DATE
63: )
64: RETURN t_value_set;
65: --