4: --
5: -- Global Types
6: --
7: TYPE t_segment IS RECORD
8: (column_name fnd_id_flex_segments.application_column_name%TYPE
9: ,sequence fnd_id_flex_segments.segment_num%TYPE
10: ,additional_column1_title VARCHAR2(2000)
11: ,additional_column1_width VARCHAR2(2000)
12: ,additional_column2_title VARCHAR2(2000)
5: -- Global Types
6: --
7: TYPE t_segment IS RECORD
8: (column_name fnd_id_flex_segments.application_column_name%TYPE
9: ,sequence fnd_id_flex_segments.segment_num%TYPE
10: ,additional_column1_title VARCHAR2(2000)
11: ,additional_column1_width VARCHAR2(2000)
12: ,additional_column2_title VARCHAR2(2000)
13: ,additional_column2_width VARCHAR2(2000)
13: ,additional_column2_width VARCHAR2(2000)
14: ,additional_column3_title VARCHAR2(2000)
15: ,additional_column3_width VARCHAR2(2000)
16: ,alphanumeric_allowed_flag fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE
17: ,concatenation_description_len fnd_id_flex_segments.concatenation_description_len%TYPE
18: ,default_type fnd_id_flex_segments.default_type%TYPE
19: ,default_value fnd_id_flex_segments.default_value%TYPE
20: ,display_flag fnd_id_flex_segments.display_flag%TYPE
21: ,display_size fnd_id_flex_segments.display_size%TYPE
14: ,additional_column3_title VARCHAR2(2000)
15: ,additional_column3_width VARCHAR2(2000)
16: ,alphanumeric_allowed_flag fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE
17: ,concatenation_description_len fnd_id_flex_segments.concatenation_description_len%TYPE
18: ,default_type fnd_id_flex_segments.default_type%TYPE
19: ,default_value fnd_id_flex_segments.default_value%TYPE
20: ,display_flag fnd_id_flex_segments.display_flag%TYPE
21: ,display_size fnd_id_flex_segments.display_size%TYPE
22: ,enabled_flag fnd_id_flex_segments.enabled_flag%TYPE
15: ,additional_column3_width VARCHAR2(2000)
16: ,alphanumeric_allowed_flag fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE
17: ,concatenation_description_len fnd_id_flex_segments.concatenation_description_len%TYPE
18: ,default_type fnd_id_flex_segments.default_type%TYPE
19: ,default_value fnd_id_flex_segments.default_value%TYPE
20: ,display_flag fnd_id_flex_segments.display_flag%TYPE
21: ,display_size fnd_id_flex_segments.display_size%TYPE
22: ,enabled_flag fnd_id_flex_segments.enabled_flag%TYPE
23: ,flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE
16: ,alphanumeric_allowed_flag fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE
17: ,concatenation_description_len fnd_id_flex_segments.concatenation_description_len%TYPE
18: ,default_type fnd_id_flex_segments.default_type%TYPE
19: ,default_value fnd_id_flex_segments.default_value%TYPE
20: ,display_flag fnd_id_flex_segments.display_flag%TYPE
21: ,display_size fnd_id_flex_segments.display_size%TYPE
22: ,enabled_flag fnd_id_flex_segments.enabled_flag%TYPE
23: ,flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE
24: ,flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE
17: ,concatenation_description_len fnd_id_flex_segments.concatenation_description_len%TYPE
18: ,default_type fnd_id_flex_segments.default_type%TYPE
19: ,default_value fnd_id_flex_segments.default_value%TYPE
20: ,display_flag fnd_id_flex_segments.display_flag%TYPE
21: ,display_size fnd_id_flex_segments.display_size%TYPE
22: ,enabled_flag fnd_id_flex_segments.enabled_flag%TYPE
23: ,flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE
24: ,flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE
25: ,format_type fnd_flex_value_sets.format_type%TYPE
18: ,default_type fnd_id_flex_segments.default_type%TYPE
19: ,default_value fnd_id_flex_segments.default_value%TYPE
20: ,display_flag fnd_id_flex_segments.display_flag%TYPE
21: ,display_size fnd_id_flex_segments.display_size%TYPE
22: ,enabled_flag fnd_id_flex_segments.enabled_flag%TYPE
23: ,flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE
24: ,flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE
25: ,format_type fnd_flex_value_sets.format_type%TYPE
26: ,form_above_prompt fnd_id_flex_segments_tl.form_above_prompt%TYPE
22: ,enabled_flag fnd_id_flex_segments.enabled_flag%TYPE
23: ,flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE
24: ,flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE
25: ,format_type fnd_flex_value_sets.format_type%TYPE
26: ,form_above_prompt fnd_id_flex_segments_tl.form_above_prompt%TYPE
27: ,form_left_prompt fnd_id_flex_segments_tl.form_left_prompt%TYPE
28: ,identification_sql VARCHAR2(32767)
29: ,id_column_type VARCHAR2(1)
30: ,has_meaning BOOLEAN
23: ,flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE
24: ,flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE
25: ,format_type fnd_flex_value_sets.format_type%TYPE
26: ,form_above_prompt fnd_id_flex_segments_tl.form_above_prompt%TYPE
27: ,form_left_prompt fnd_id_flex_segments_tl.form_left_prompt%TYPE
28: ,identification_sql VARCHAR2(32767)
29: ,id_column_type VARCHAR2(1)
30: ,has_meaning BOOLEAN
31: ,longlist_flag fnd_flex_value_sets.longlist_flag%TYPE
28: ,identification_sql VARCHAR2(32767)
29: ,id_column_type VARCHAR2(1)
30: ,has_meaning BOOLEAN
31: ,longlist_flag fnd_flex_value_sets.longlist_flag%TYPE
32: ,maximum_description_len fnd_id_flex_segments.maximum_description_len%TYPE
33: ,maximum_size fnd_flex_value_sets.maximum_size%TYPE
34: ,maximum_value fnd_flex_value_sets.maximum_value%TYPE
35: ,minimum_value fnd_flex_value_sets.minimum_value%TYPE
36: ,number_precision fnd_flex_value_sets.number_precision%TYPE
34: ,maximum_value fnd_flex_value_sets.maximum_value%TYPE
35: ,minimum_value fnd_flex_value_sets.minimum_value%TYPE
36: ,number_precision fnd_flex_value_sets.number_precision%TYPE
37: ,numeric_mode_enabled_flag fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE
38: ,required_flag fnd_id_flex_segments.required_flag%TYPE
39: ,segment_name fnd_id_flex_segments.segment_name%TYPE
40: ,uppercase_only_flag fnd_flex_value_sets.uppercase_only_flag%TYPE
41: ,validation_sql VARCHAR2(32767)
42: ,validation_type fnd_flex_value_sets.validation_type%TYPE
35: ,minimum_value fnd_flex_value_sets.minimum_value%TYPE
36: ,number_precision fnd_flex_value_sets.number_precision%TYPE
37: ,numeric_mode_enabled_flag fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE
38: ,required_flag fnd_id_flex_segments.required_flag%TYPE
39: ,segment_name fnd_id_flex_segments.segment_name%TYPE
40: ,uppercase_only_flag fnd_flex_value_sets.uppercase_only_flag%TYPE
41: ,validation_sql VARCHAR2(32767)
42: ,validation_type fnd_flex_value_sets.validation_type%TYPE
43: );