4: --
5: -- Global Types
6: --
7: TYPE t_segment IS RECORD
8: (column_name fnd_descr_flex_column_usages.application_column_name%TYPE
9: ,sequence fnd_descr_flex_column_usages.column_seq_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_descr_flex_column_usages.application_column_name%TYPE
9: ,sequence fnd_descr_flex_column_usages.column_seq_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_descr_flex_column_usages.concatenation_description_len%TYPE
18: ,default_type fnd_descr_flex_column_usages.default_type%TYPE
19: ,default_value fnd_descr_flex_column_usages.default_value%TYPE
20: ,display_flag fnd_descr_flex_column_usages.display_flag%TYPE
21: ,display_size fnd_descr_flex_column_usages.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_descr_flex_column_usages.concatenation_description_len%TYPE
18: ,default_type fnd_descr_flex_column_usages.default_type%TYPE
19: ,default_value fnd_descr_flex_column_usages.default_value%TYPE
20: ,display_flag fnd_descr_flex_column_usages.display_flag%TYPE
21: ,display_size fnd_descr_flex_column_usages.display_size%TYPE
22: ,enabled_flag fnd_descr_flex_column_usages.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_descr_flex_column_usages.concatenation_description_len%TYPE
18: ,default_type fnd_descr_flex_column_usages.default_type%TYPE
19: ,default_value fnd_descr_flex_column_usages.default_value%TYPE
20: ,display_flag fnd_descr_flex_column_usages.display_flag%TYPE
21: ,display_size fnd_descr_flex_column_usages.display_size%TYPE
22: ,enabled_flag fnd_descr_flex_column_usages.enabled_flag%TYPE
23: ,end_user_column_name fnd_descr_flex_column_usages.end_user_column_name%TYPE
16: ,alphanumeric_allowed_flag fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE
17: ,concatenation_description_len fnd_descr_flex_column_usages.concatenation_description_len%TYPE
18: ,default_type fnd_descr_flex_column_usages.default_type%TYPE
19: ,default_value fnd_descr_flex_column_usages.default_value%TYPE
20: ,display_flag fnd_descr_flex_column_usages.display_flag%TYPE
21: ,display_size fnd_descr_flex_column_usages.display_size%TYPE
22: ,enabled_flag fnd_descr_flex_column_usages.enabled_flag%TYPE
23: ,end_user_column_name fnd_descr_flex_column_usages.end_user_column_name%TYPE
24: ,flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE
17: ,concatenation_description_len fnd_descr_flex_column_usages.concatenation_description_len%TYPE
18: ,default_type fnd_descr_flex_column_usages.default_type%TYPE
19: ,default_value fnd_descr_flex_column_usages.default_value%TYPE
20: ,display_flag fnd_descr_flex_column_usages.display_flag%TYPE
21: ,display_size fnd_descr_flex_column_usages.display_size%TYPE
22: ,enabled_flag fnd_descr_flex_column_usages.enabled_flag%TYPE
23: ,end_user_column_name fnd_descr_flex_column_usages.end_user_column_name%TYPE
24: ,flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE
25: ,flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE
18: ,default_type fnd_descr_flex_column_usages.default_type%TYPE
19: ,default_value fnd_descr_flex_column_usages.default_value%TYPE
20: ,display_flag fnd_descr_flex_column_usages.display_flag%TYPE
21: ,display_size fnd_descr_flex_column_usages.display_size%TYPE
22: ,enabled_flag fnd_descr_flex_column_usages.enabled_flag%TYPE
23: ,end_user_column_name fnd_descr_flex_column_usages.end_user_column_name%TYPE
24: ,flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE
25: ,flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE
26: ,format_type fnd_flex_value_sets.format_type%TYPE
19: ,default_value fnd_descr_flex_column_usages.default_value%TYPE
20: ,display_flag fnd_descr_flex_column_usages.display_flag%TYPE
21: ,display_size fnd_descr_flex_column_usages.display_size%TYPE
22: ,enabled_flag fnd_descr_flex_column_usages.enabled_flag%TYPE
23: ,end_user_column_name fnd_descr_flex_column_usages.end_user_column_name%TYPE
24: ,flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE
25: ,flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE
26: ,format_type fnd_flex_value_sets.format_type%TYPE
27: ,form_above_prompt fnd_descr_flex_col_usage_tl.form_above_prompt%TYPE
29: ,identification_sql VARCHAR2(32767)
30: ,id_column_type VARCHAR2(1)
31: ,has_meaning BOOLEAN
32: ,longlist_flag fnd_flex_value_sets.longlist_flag%TYPE
33: ,maximum_description_len fnd_descr_flex_column_usages.maximum_description_len%TYPE
34: ,maximum_size fnd_flex_value_sets.maximum_size%TYPE
35: ,maximum_value fnd_flex_value_sets.maximum_value%TYPE
36: ,minimum_value fnd_flex_value_sets.minimum_value%TYPE
37: ,number_precision fnd_flex_value_sets.number_precision%TYPE
35: ,maximum_value fnd_flex_value_sets.maximum_value%TYPE
36: ,minimum_value fnd_flex_value_sets.minimum_value%TYPE
37: ,number_precision fnd_flex_value_sets.number_precision%TYPE
38: ,numeric_mode_enabled_flag fnd_flex_value_sets.numeric_mode_enabled_flag%TYPE
39: ,required_flag fnd_descr_flex_column_usages.required_flag%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: );