59: -- but pl/sql doesn't support it, so require the flexfield_type
60: -- to be passed all the time.
61: TYPE structure_type IS RECORD
62: (instantiated VARCHAR2(1),
63: structure_number fnd_id_flex_structures_vl.id_flex_num%TYPE,
64: structure_code fnd_id_flex_structures_vl.id_flex_structure_code%TYPE,
65: structure_name fnd_id_flex_structures_vl.id_flex_structure_name%TYPE,
66: description fnd_id_flex_structures_vl.description%TYPE,
67: view_name fnd_id_flex_structures_vl.structure_view_name%TYPE,
60: -- to be passed all the time.
61: TYPE structure_type IS RECORD
62: (instantiated VARCHAR2(1),
63: structure_number fnd_id_flex_structures_vl.id_flex_num%TYPE,
64: structure_code fnd_id_flex_structures_vl.id_flex_structure_code%TYPE,
65: structure_name fnd_id_flex_structures_vl.id_flex_structure_name%TYPE,
66: description fnd_id_flex_structures_vl.description%TYPE,
67: view_name fnd_id_flex_structures_vl.structure_view_name%TYPE,
68: freeze_flag fnd_id_flex_structures_vl.freeze_flex_definition_flag%TYPE,
61: TYPE structure_type IS RECORD
62: (instantiated VARCHAR2(1),
63: structure_number fnd_id_flex_structures_vl.id_flex_num%TYPE,
64: structure_code fnd_id_flex_structures_vl.id_flex_structure_code%TYPE,
65: structure_name fnd_id_flex_structures_vl.id_flex_structure_name%TYPE,
66: description fnd_id_flex_structures_vl.description%TYPE,
67: view_name fnd_id_flex_structures_vl.structure_view_name%TYPE,
68: freeze_flag fnd_id_flex_structures_vl.freeze_flex_definition_flag%TYPE,
69: enabled_flag fnd_id_flex_structures_vl.enabled_flag%TYPE,
62: (instantiated VARCHAR2(1),
63: structure_number fnd_id_flex_structures_vl.id_flex_num%TYPE,
64: structure_code fnd_id_flex_structures_vl.id_flex_structure_code%TYPE,
65: structure_name fnd_id_flex_structures_vl.id_flex_structure_name%TYPE,
66: description fnd_id_flex_structures_vl.description%TYPE,
67: view_name fnd_id_flex_structures_vl.structure_view_name%TYPE,
68: freeze_flag fnd_id_flex_structures_vl.freeze_flex_definition_flag%TYPE,
69: enabled_flag fnd_id_flex_structures_vl.enabled_flag%TYPE,
70: segment_separator fnd_id_flex_structures_vl.concatenated_segment_delimiter%TYPE,
63: structure_number fnd_id_flex_structures_vl.id_flex_num%TYPE,
64: structure_code fnd_id_flex_structures_vl.id_flex_structure_code%TYPE,
65: structure_name fnd_id_flex_structures_vl.id_flex_structure_name%TYPE,
66: description fnd_id_flex_structures_vl.description%TYPE,
67: view_name fnd_id_flex_structures_vl.structure_view_name%TYPE,
68: freeze_flag fnd_id_flex_structures_vl.freeze_flex_definition_flag%TYPE,
69: enabled_flag fnd_id_flex_structures_vl.enabled_flag%TYPE,
70: segment_separator fnd_id_flex_structures_vl.concatenated_segment_delimiter%TYPE,
71: cross_val_flag fnd_id_flex_structures_vl.cross_segment_validation_flag%TYPE,
64: structure_code fnd_id_flex_structures_vl.id_flex_structure_code%TYPE,
65: structure_name fnd_id_flex_structures_vl.id_flex_structure_name%TYPE,
66: description fnd_id_flex_structures_vl.description%TYPE,
67: view_name fnd_id_flex_structures_vl.structure_view_name%TYPE,
68: freeze_flag fnd_id_flex_structures_vl.freeze_flex_definition_flag%TYPE,
69: enabled_flag fnd_id_flex_structures_vl.enabled_flag%TYPE,
70: segment_separator fnd_id_flex_structures_vl.concatenated_segment_delimiter%TYPE,
71: cross_val_flag fnd_id_flex_structures_vl.cross_segment_validation_flag%TYPE,
72: freeze_rollup_flag fnd_id_flex_structures_vl.freeze_structured_hier_flag%TYPE,
65: structure_name fnd_id_flex_structures_vl.id_flex_structure_name%TYPE,
66: description fnd_id_flex_structures_vl.description%TYPE,
67: view_name fnd_id_flex_structures_vl.structure_view_name%TYPE,
68: freeze_flag fnd_id_flex_structures_vl.freeze_flex_definition_flag%TYPE,
69: enabled_flag fnd_id_flex_structures_vl.enabled_flag%TYPE,
70: segment_separator fnd_id_flex_structures_vl.concatenated_segment_delimiter%TYPE,
71: cross_val_flag fnd_id_flex_structures_vl.cross_segment_validation_flag%TYPE,
72: freeze_rollup_flag fnd_id_flex_structures_vl.freeze_structured_hier_flag%TYPE,
73: dynamic_insert_flag fnd_id_flex_structures_vl.dynamic_inserts_allowed_flag%TYPE,
66: description fnd_id_flex_structures_vl.description%TYPE,
67: view_name fnd_id_flex_structures_vl.structure_view_name%TYPE,
68: freeze_flag fnd_id_flex_structures_vl.freeze_flex_definition_flag%TYPE,
69: enabled_flag fnd_id_flex_structures_vl.enabled_flag%TYPE,
70: segment_separator fnd_id_flex_structures_vl.concatenated_segment_delimiter%TYPE,
71: cross_val_flag fnd_id_flex_structures_vl.cross_segment_validation_flag%TYPE,
72: freeze_rollup_flag fnd_id_flex_structures_vl.freeze_structured_hier_flag%TYPE,
73: dynamic_insert_flag fnd_id_flex_structures_vl.dynamic_inserts_allowed_flag%TYPE,
74: shorthand_enabled_flag fnd_id_flex_structures_vl.shorthand_enabled_flag%TYPE,
67: view_name fnd_id_flex_structures_vl.structure_view_name%TYPE,
68: freeze_flag fnd_id_flex_structures_vl.freeze_flex_definition_flag%TYPE,
69: enabled_flag fnd_id_flex_structures_vl.enabled_flag%TYPE,
70: segment_separator fnd_id_flex_structures_vl.concatenated_segment_delimiter%TYPE,
71: cross_val_flag fnd_id_flex_structures_vl.cross_segment_validation_flag%TYPE,
72: freeze_rollup_flag fnd_id_flex_structures_vl.freeze_structured_hier_flag%TYPE,
73: dynamic_insert_flag fnd_id_flex_structures_vl.dynamic_inserts_allowed_flag%TYPE,
74: shorthand_enabled_flag fnd_id_flex_structures_vl.shorthand_enabled_flag%TYPE,
75: shorthand_prompt fnd_id_flex_structures_vl.shorthand_prompt%TYPE,
68: freeze_flag fnd_id_flex_structures_vl.freeze_flex_definition_flag%TYPE,
69: enabled_flag fnd_id_flex_structures_vl.enabled_flag%TYPE,
70: segment_separator fnd_id_flex_structures_vl.concatenated_segment_delimiter%TYPE,
71: cross_val_flag fnd_id_flex_structures_vl.cross_segment_validation_flag%TYPE,
72: freeze_rollup_flag fnd_id_flex_structures_vl.freeze_structured_hier_flag%TYPE,
73: dynamic_insert_flag fnd_id_flex_structures_vl.dynamic_inserts_allowed_flag%TYPE,
74: shorthand_enabled_flag fnd_id_flex_structures_vl.shorthand_enabled_flag%TYPE,
75: shorthand_prompt fnd_id_flex_structures_vl.shorthand_prompt%TYPE,
76: shorthand_length fnd_id_flex_structures_vl.shorthand_length%TYPE);
69: enabled_flag fnd_id_flex_structures_vl.enabled_flag%TYPE,
70: segment_separator fnd_id_flex_structures_vl.concatenated_segment_delimiter%TYPE,
71: cross_val_flag fnd_id_flex_structures_vl.cross_segment_validation_flag%TYPE,
72: freeze_rollup_flag fnd_id_flex_structures_vl.freeze_structured_hier_flag%TYPE,
73: dynamic_insert_flag fnd_id_flex_structures_vl.dynamic_inserts_allowed_flag%TYPE,
74: shorthand_enabled_flag fnd_id_flex_structures_vl.shorthand_enabled_flag%TYPE,
75: shorthand_prompt fnd_id_flex_structures_vl.shorthand_prompt%TYPE,
76: shorthand_length fnd_id_flex_structures_vl.shorthand_length%TYPE);
77:
70: segment_separator fnd_id_flex_structures_vl.concatenated_segment_delimiter%TYPE,
71: cross_val_flag fnd_id_flex_structures_vl.cross_segment_validation_flag%TYPE,
72: freeze_rollup_flag fnd_id_flex_structures_vl.freeze_structured_hier_flag%TYPE,
73: dynamic_insert_flag fnd_id_flex_structures_vl.dynamic_inserts_allowed_flag%TYPE,
74: shorthand_enabled_flag fnd_id_flex_structures_vl.shorthand_enabled_flag%TYPE,
75: shorthand_prompt fnd_id_flex_structures_vl.shorthand_prompt%TYPE,
76: shorthand_length fnd_id_flex_structures_vl.shorthand_length%TYPE);
77:
78: TYPE segment_type IS RECORD
71: cross_val_flag fnd_id_flex_structures_vl.cross_segment_validation_flag%TYPE,
72: freeze_rollup_flag fnd_id_flex_structures_vl.freeze_structured_hier_flag%TYPE,
73: dynamic_insert_flag fnd_id_flex_structures_vl.dynamic_inserts_allowed_flag%TYPE,
74: shorthand_enabled_flag fnd_id_flex_structures_vl.shorthand_enabled_flag%TYPE,
75: shorthand_prompt fnd_id_flex_structures_vl.shorthand_prompt%TYPE,
76: shorthand_length fnd_id_flex_structures_vl.shorthand_length%TYPE);
77:
78: TYPE segment_type IS RECORD
79: (instantiated VARCHAR2(1),
72: freeze_rollup_flag fnd_id_flex_structures_vl.freeze_structured_hier_flag%TYPE,
73: dynamic_insert_flag fnd_id_flex_structures_vl.dynamic_inserts_allowed_flag%TYPE,
74: shorthand_enabled_flag fnd_id_flex_structures_vl.shorthand_enabled_flag%TYPE,
75: shorthand_prompt fnd_id_flex_structures_vl.shorthand_prompt%TYPE,
76: shorthand_length fnd_id_flex_structures_vl.shorthand_length%TYPE);
77:
78: TYPE segment_type IS RECORD
79: (instantiated VARCHAR2(1),
80: segment_name fnd_id_flex_segments_vl.segment_name%TYPE,