2: /* $Header: perricts.pkh 120.1.12000000.2 2007/09/21 11:07:22 vdabgar noship $ */
3:
4: -- Keyflex Value Set Record
5: TYPE tech_summary_keyflex_value_set IS RECORD
6: (value_set_name fnd_flex_value_sets.flex_value_set_name%type
7: ,description fnd_flex_value_sets.description%type
8: ,security_available fnd_flex_value_sets.security_enabled_flag%type
9: ,enable_longlist fnd_flex_value_sets.longlist_flag%type
10: ,format_type fnd_flex_value_sets.format_type%type
3:
4: -- Keyflex Value Set Record
5: TYPE tech_summary_keyflex_value_set IS RECORD
6: (value_set_name fnd_flex_value_sets.flex_value_set_name%type
7: ,description fnd_flex_value_sets.description%type
8: ,security_available fnd_flex_value_sets.security_enabled_flag%type
9: ,enable_longlist fnd_flex_value_sets.longlist_flag%type
10: ,format_type fnd_flex_value_sets.format_type%type
11: ,maximum_size fnd_flex_value_sets.maximum_size%type
4: -- Keyflex Value Set Record
5: TYPE tech_summary_keyflex_value_set IS RECORD
6: (value_set_name fnd_flex_value_sets.flex_value_set_name%type
7: ,description fnd_flex_value_sets.description%type
8: ,security_available fnd_flex_value_sets.security_enabled_flag%type
9: ,enable_longlist fnd_flex_value_sets.longlist_flag%type
10: ,format_type fnd_flex_value_sets.format_type%type
11: ,maximum_size fnd_flex_value_sets.maximum_size%type
12: ,precision fnd_flex_value_sets.number_precision%type
5: TYPE tech_summary_keyflex_value_set IS RECORD
6: (value_set_name fnd_flex_value_sets.flex_value_set_name%type
7: ,description fnd_flex_value_sets.description%type
8: ,security_available fnd_flex_value_sets.security_enabled_flag%type
9: ,enable_longlist fnd_flex_value_sets.longlist_flag%type
10: ,format_type fnd_flex_value_sets.format_type%type
11: ,maximum_size fnd_flex_value_sets.maximum_size%type
12: ,precision fnd_flex_value_sets.number_precision%type
13: ,numbers_only fnd_flex_value_sets.numeric_mode_enabled_flag%type
6: (value_set_name fnd_flex_value_sets.flex_value_set_name%type
7: ,description fnd_flex_value_sets.description%type
8: ,security_available fnd_flex_value_sets.security_enabled_flag%type
9: ,enable_longlist fnd_flex_value_sets.longlist_flag%type
10: ,format_type fnd_flex_value_sets.format_type%type
11: ,maximum_size fnd_flex_value_sets.maximum_size%type
12: ,precision fnd_flex_value_sets.number_precision%type
13: ,numbers_only fnd_flex_value_sets.numeric_mode_enabled_flag%type
14: ,uppercase_only fnd_flex_value_sets.uppercase_only_flag%type
7: ,description fnd_flex_value_sets.description%type
8: ,security_available fnd_flex_value_sets.security_enabled_flag%type
9: ,enable_longlist fnd_flex_value_sets.longlist_flag%type
10: ,format_type fnd_flex_value_sets.format_type%type
11: ,maximum_size fnd_flex_value_sets.maximum_size%type
12: ,precision fnd_flex_value_sets.number_precision%type
13: ,numbers_only fnd_flex_value_sets.numeric_mode_enabled_flag%type
14: ,uppercase_only fnd_flex_value_sets.uppercase_only_flag%type
15: ,right_justify_zero_fill fnd_flex_value_sets.numeric_mode_enabled_flag%type
8: ,security_available fnd_flex_value_sets.security_enabled_flag%type
9: ,enable_longlist fnd_flex_value_sets.longlist_flag%type
10: ,format_type fnd_flex_value_sets.format_type%type
11: ,maximum_size fnd_flex_value_sets.maximum_size%type
12: ,precision fnd_flex_value_sets.number_precision%type
13: ,numbers_only fnd_flex_value_sets.numeric_mode_enabled_flag%type
14: ,uppercase_only fnd_flex_value_sets.uppercase_only_flag%type
15: ,right_justify_zero_fill fnd_flex_value_sets.numeric_mode_enabled_flag%type
16: ,min_value fnd_flex_value_sets.minimum_value%type
9: ,enable_longlist fnd_flex_value_sets.longlist_flag%type
10: ,format_type fnd_flex_value_sets.format_type%type
11: ,maximum_size fnd_flex_value_sets.maximum_size%type
12: ,precision fnd_flex_value_sets.number_precision%type
13: ,numbers_only fnd_flex_value_sets.numeric_mode_enabled_flag%type
14: ,uppercase_only fnd_flex_value_sets.uppercase_only_flag%type
15: ,right_justify_zero_fill fnd_flex_value_sets.numeric_mode_enabled_flag%type
16: ,min_value fnd_flex_value_sets.minimum_value%type
17: ,max_value fnd_flex_value_sets.maximum_value%type);
10: ,format_type fnd_flex_value_sets.format_type%type
11: ,maximum_size fnd_flex_value_sets.maximum_size%type
12: ,precision fnd_flex_value_sets.number_precision%type
13: ,numbers_only fnd_flex_value_sets.numeric_mode_enabled_flag%type
14: ,uppercase_only fnd_flex_value_sets.uppercase_only_flag%type
15: ,right_justify_zero_fill fnd_flex_value_sets.numeric_mode_enabled_flag%type
16: ,min_value fnd_flex_value_sets.minimum_value%type
17: ,max_value fnd_flex_value_sets.maximum_value%type);
18:
11: ,maximum_size fnd_flex_value_sets.maximum_size%type
12: ,precision fnd_flex_value_sets.number_precision%type
13: ,numbers_only fnd_flex_value_sets.numeric_mode_enabled_flag%type
14: ,uppercase_only fnd_flex_value_sets.uppercase_only_flag%type
15: ,right_justify_zero_fill fnd_flex_value_sets.numeric_mode_enabled_flag%type
16: ,min_value fnd_flex_value_sets.minimum_value%type
17: ,max_value fnd_flex_value_sets.maximum_value%type);
18:
19: TYPE valueset_tab IS TABLE OF
12: ,precision fnd_flex_value_sets.number_precision%type
13: ,numbers_only fnd_flex_value_sets.numeric_mode_enabled_flag%type
14: ,uppercase_only fnd_flex_value_sets.uppercase_only_flag%type
15: ,right_justify_zero_fill fnd_flex_value_sets.numeric_mode_enabled_flag%type
16: ,min_value fnd_flex_value_sets.minimum_value%type
17: ,max_value fnd_flex_value_sets.maximum_value%type);
18:
19: TYPE valueset_tab IS TABLE OF
20: tech_summary_keyflex_value_set
13: ,numbers_only fnd_flex_value_sets.numeric_mode_enabled_flag%type
14: ,uppercase_only fnd_flex_value_sets.uppercase_only_flag%type
15: ,right_justify_zero_fill fnd_flex_value_sets.numeric_mode_enabled_flag%type
16: ,min_value fnd_flex_value_sets.minimum_value%type
17: ,max_value fnd_flex_value_sets.maximum_value%type);
18:
19: TYPE valueset_tab IS TABLE OF
20: tech_summary_keyflex_value_set
21: INDEX BY BINARY_INTEGER;
27: ,structure_code fnd_id_flex_structures_vl.id_flex_structure_name%type
28: ,segment_name fnd_id_flex_segments_vl.segment_name%type
29: ,column_name fnd_id_flex_segments_vl.application_column_name%type
30: ,segment_number number(8)
31: ,value_set fnd_flex_value_sets.flex_value_set_name%type
32: ,lov_prompt fnd_id_flex_segments_vl.segment_name%type
33: ,segment_type varchar2(80)
34: ,window_prompt fnd_id_flex_segments_vl.segment_name%type
35: --
32: ,lov_prompt fnd_id_flex_segments_vl.segment_name%type
33: ,segment_type varchar2(80)
34: ,window_prompt fnd_id_flex_segments_vl.segment_name%type
35: --
36: ,vs_value_set_name fnd_flex_value_sets.flex_value_set_name%type
37: ,vs_description fnd_flex_value_sets.description%type
38: ,vs_security_available fnd_flex_value_sets.security_enabled_flag%type
39: ,vs_enable_longlist fnd_flex_value_sets.longlist_flag%type
40: ,vs_format_type fnd_flex_value_sets.format_type%type
33: ,segment_type varchar2(80)
34: ,window_prompt fnd_id_flex_segments_vl.segment_name%type
35: --
36: ,vs_value_set_name fnd_flex_value_sets.flex_value_set_name%type
37: ,vs_description fnd_flex_value_sets.description%type
38: ,vs_security_available fnd_flex_value_sets.security_enabled_flag%type
39: ,vs_enable_longlist fnd_flex_value_sets.longlist_flag%type
40: ,vs_format_type fnd_flex_value_sets.format_type%type
41: ,vs_maximum_size fnd_flex_value_sets.maximum_size%type
34: ,window_prompt fnd_id_flex_segments_vl.segment_name%type
35: --
36: ,vs_value_set_name fnd_flex_value_sets.flex_value_set_name%type
37: ,vs_description fnd_flex_value_sets.description%type
38: ,vs_security_available fnd_flex_value_sets.security_enabled_flag%type
39: ,vs_enable_longlist fnd_flex_value_sets.longlist_flag%type
40: ,vs_format_type fnd_flex_value_sets.format_type%type
41: ,vs_maximum_size fnd_flex_value_sets.maximum_size%type
42: ,vs_precision fnd_flex_value_sets.number_precision%type
35: --
36: ,vs_value_set_name fnd_flex_value_sets.flex_value_set_name%type
37: ,vs_description fnd_flex_value_sets.description%type
38: ,vs_security_available fnd_flex_value_sets.security_enabled_flag%type
39: ,vs_enable_longlist fnd_flex_value_sets.longlist_flag%type
40: ,vs_format_type fnd_flex_value_sets.format_type%type
41: ,vs_maximum_size fnd_flex_value_sets.maximum_size%type
42: ,vs_precision fnd_flex_value_sets.number_precision%type
43: ,vs_numbers_only fnd_flex_value_sets.numeric_mode_enabled_flag%type
36: ,vs_value_set_name fnd_flex_value_sets.flex_value_set_name%type
37: ,vs_description fnd_flex_value_sets.description%type
38: ,vs_security_available fnd_flex_value_sets.security_enabled_flag%type
39: ,vs_enable_longlist fnd_flex_value_sets.longlist_flag%type
40: ,vs_format_type fnd_flex_value_sets.format_type%type
41: ,vs_maximum_size fnd_flex_value_sets.maximum_size%type
42: ,vs_precision fnd_flex_value_sets.number_precision%type
43: ,vs_numbers_only fnd_flex_value_sets.numeric_mode_enabled_flag%type
44: ,vs_uppercase_only fnd_flex_value_sets.uppercase_only_flag%type
37: ,vs_description fnd_flex_value_sets.description%type
38: ,vs_security_available fnd_flex_value_sets.security_enabled_flag%type
39: ,vs_enable_longlist fnd_flex_value_sets.longlist_flag%type
40: ,vs_format_type fnd_flex_value_sets.format_type%type
41: ,vs_maximum_size fnd_flex_value_sets.maximum_size%type
42: ,vs_precision fnd_flex_value_sets.number_precision%type
43: ,vs_numbers_only fnd_flex_value_sets.numeric_mode_enabled_flag%type
44: ,vs_uppercase_only fnd_flex_value_sets.uppercase_only_flag%type
45: ,vs_right_justify_zero_fill fnd_flex_value_sets.numeric_mode_enabled_flag%type
38: ,vs_security_available fnd_flex_value_sets.security_enabled_flag%type
39: ,vs_enable_longlist fnd_flex_value_sets.longlist_flag%type
40: ,vs_format_type fnd_flex_value_sets.format_type%type
41: ,vs_maximum_size fnd_flex_value_sets.maximum_size%type
42: ,vs_precision fnd_flex_value_sets.number_precision%type
43: ,vs_numbers_only fnd_flex_value_sets.numeric_mode_enabled_flag%type
44: ,vs_uppercase_only fnd_flex_value_sets.uppercase_only_flag%type
45: ,vs_right_justify_zero_fill fnd_flex_value_sets.numeric_mode_enabled_flag%type
46: ,vs_min_value fnd_flex_value_sets.minimum_value%type
39: ,vs_enable_longlist fnd_flex_value_sets.longlist_flag%type
40: ,vs_format_type fnd_flex_value_sets.format_type%type
41: ,vs_maximum_size fnd_flex_value_sets.maximum_size%type
42: ,vs_precision fnd_flex_value_sets.number_precision%type
43: ,vs_numbers_only fnd_flex_value_sets.numeric_mode_enabled_flag%type
44: ,vs_uppercase_only fnd_flex_value_sets.uppercase_only_flag%type
45: ,vs_right_justify_zero_fill fnd_flex_value_sets.numeric_mode_enabled_flag%type
46: ,vs_min_value fnd_flex_value_sets.minimum_value%type
47: ,vs_max_value fnd_flex_value_sets.maximum_value%type
40: ,vs_format_type fnd_flex_value_sets.format_type%type
41: ,vs_maximum_size fnd_flex_value_sets.maximum_size%type
42: ,vs_precision fnd_flex_value_sets.number_precision%type
43: ,vs_numbers_only fnd_flex_value_sets.numeric_mode_enabled_flag%type
44: ,vs_uppercase_only fnd_flex_value_sets.uppercase_only_flag%type
45: ,vs_right_justify_zero_fill fnd_flex_value_sets.numeric_mode_enabled_flag%type
46: ,vs_min_value fnd_flex_value_sets.minimum_value%type
47: ,vs_max_value fnd_flex_value_sets.maximum_value%type
48: );
41: ,vs_maximum_size fnd_flex_value_sets.maximum_size%type
42: ,vs_precision fnd_flex_value_sets.number_precision%type
43: ,vs_numbers_only fnd_flex_value_sets.numeric_mode_enabled_flag%type
44: ,vs_uppercase_only fnd_flex_value_sets.uppercase_only_flag%type
45: ,vs_right_justify_zero_fill fnd_flex_value_sets.numeric_mode_enabled_flag%type
46: ,vs_min_value fnd_flex_value_sets.minimum_value%type
47: ,vs_max_value fnd_flex_value_sets.maximum_value%type
48: );
49:
42: ,vs_precision fnd_flex_value_sets.number_precision%type
43: ,vs_numbers_only fnd_flex_value_sets.numeric_mode_enabled_flag%type
44: ,vs_uppercase_only fnd_flex_value_sets.uppercase_only_flag%type
45: ,vs_right_justify_zero_fill fnd_flex_value_sets.numeric_mode_enabled_flag%type
46: ,vs_min_value fnd_flex_value_sets.minimum_value%type
47: ,vs_max_value fnd_flex_value_sets.maximum_value%type
48: );
49:
50: TYPE kf_segment_tab IS TABLE OF
43: ,vs_numbers_only fnd_flex_value_sets.numeric_mode_enabled_flag%type
44: ,vs_uppercase_only fnd_flex_value_sets.uppercase_only_flag%type
45: ,vs_right_justify_zero_fill fnd_flex_value_sets.numeric_mode_enabled_flag%type
46: ,vs_min_value fnd_flex_value_sets.minimum_value%type
47: ,vs_max_value fnd_flex_value_sets.maximum_value%type
48: );
49:
50: TYPE kf_segment_tab IS TABLE OF
51: tech_summary_keyflex_segment