31: desc_flex_context FND_DESCR_FLEX_CONTEXTS.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE
32: );
33:
34: TYPE DescFlexInfo IS RECORD
35: (application_id FND_DESCRIPTIVE_FLEXS.APPLICATION_ID%TYPE,
36: name FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE,
37: description FND_DESCRIPTIVE_FLEXS_TL.DESCRIPTION%TYPE,
38: table_appl_id FND_DESCRIPTIVE_FLEXS.TABLE_APPLICATION_ID%TYPE,
39: table_name FND_DESCRIPTIVE_FLEXS.APPLICATION_TABLE_NAME%TYPE,
32: );
33:
34: TYPE DescFlexInfo IS RECORD
35: (application_id FND_DESCRIPTIVE_FLEXS.APPLICATION_ID%TYPE,
36: name FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE,
37: description FND_DESCRIPTIVE_FLEXS_TL.DESCRIPTION%TYPE,
38: table_appl_id FND_DESCRIPTIVE_FLEXS.TABLE_APPLICATION_ID%TYPE,
39: table_name FND_DESCRIPTIVE_FLEXS.APPLICATION_TABLE_NAME%TYPE,
40: table_id FND_TABLES.TABLE_ID%TYPE,
33:
34: TYPE DescFlexInfo IS RECORD
35: (application_id FND_DESCRIPTIVE_FLEXS.APPLICATION_ID%TYPE,
36: name FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE,
37: description FND_DESCRIPTIVE_FLEXS_TL.DESCRIPTION%TYPE,
38: table_appl_id FND_DESCRIPTIVE_FLEXS.TABLE_APPLICATION_ID%TYPE,
39: table_name FND_DESCRIPTIVE_FLEXS.APPLICATION_TABLE_NAME%TYPE,
40: table_id FND_TABLES.TABLE_ID%TYPE,
41: context_required FND_DESCRIPTIVE_FLEXS.CONTEXT_REQUIRED_FLAG%TYPE,
34: TYPE DescFlexInfo IS RECORD
35: (application_id FND_DESCRIPTIVE_FLEXS.APPLICATION_ID%TYPE,
36: name FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE,
37: description FND_DESCRIPTIVE_FLEXS_TL.DESCRIPTION%TYPE,
38: table_appl_id FND_DESCRIPTIVE_FLEXS.TABLE_APPLICATION_ID%TYPE,
39: table_name FND_DESCRIPTIVE_FLEXS.APPLICATION_TABLE_NAME%TYPE,
40: table_id FND_TABLES.TABLE_ID%TYPE,
41: context_required FND_DESCRIPTIVE_FLEXS.CONTEXT_REQUIRED_FLAG%TYPE,
42: context_column FND_DESCRIPTIVE_FLEXS.CONTEXT_COLUMN_NAME%TYPE,
35: (application_id FND_DESCRIPTIVE_FLEXS.APPLICATION_ID%TYPE,
36: name FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE,
37: description FND_DESCRIPTIVE_FLEXS_TL.DESCRIPTION%TYPE,
38: table_appl_id FND_DESCRIPTIVE_FLEXS.TABLE_APPLICATION_ID%TYPE,
39: table_name FND_DESCRIPTIVE_FLEXS.APPLICATION_TABLE_NAME%TYPE,
40: table_id FND_TABLES.TABLE_ID%TYPE,
41: context_required FND_DESCRIPTIVE_FLEXS.CONTEXT_REQUIRED_FLAG%TYPE,
42: context_column FND_DESCRIPTIVE_FLEXS.CONTEXT_COLUMN_NAME%TYPE,
43: context_override FND_DESCRIPTIVE_FLEXS.CONTEXT_USER_OVERRIDE_FLAG%TYPE,
37: description FND_DESCRIPTIVE_FLEXS_TL.DESCRIPTION%TYPE,
38: table_appl_id FND_DESCRIPTIVE_FLEXS.TABLE_APPLICATION_ID%TYPE,
39: table_name FND_DESCRIPTIVE_FLEXS.APPLICATION_TABLE_NAME%TYPE,
40: table_id FND_TABLES.TABLE_ID%TYPE,
41: context_required FND_DESCRIPTIVE_FLEXS.CONTEXT_REQUIRED_FLAG%TYPE,
42: context_column FND_DESCRIPTIVE_FLEXS.CONTEXT_COLUMN_NAME%TYPE,
43: context_override FND_DESCRIPTIVE_FLEXS.CONTEXT_USER_OVERRIDE_FLAG%TYPE,
44: segment_delimiter FND_DESCRIPTIVE_FLEXS.CONCATENATED_SEGMENT_DELIMITER%TYPE,
45: protected_flag FND_DESCRIPTIVE_FLEXS.PROTECTED_FLAG%TYPE,
38: table_appl_id FND_DESCRIPTIVE_FLEXS.TABLE_APPLICATION_ID%TYPE,
39: table_name FND_DESCRIPTIVE_FLEXS.APPLICATION_TABLE_NAME%TYPE,
40: table_id FND_TABLES.TABLE_ID%TYPE,
41: context_required FND_DESCRIPTIVE_FLEXS.CONTEXT_REQUIRED_FLAG%TYPE,
42: context_column FND_DESCRIPTIVE_FLEXS.CONTEXT_COLUMN_NAME%TYPE,
43: context_override FND_DESCRIPTIVE_FLEXS.CONTEXT_USER_OVERRIDE_FLAG%TYPE,
44: segment_delimiter FND_DESCRIPTIVE_FLEXS.CONCATENATED_SEGMENT_DELIMITER%TYPE,
45: protected_flag FND_DESCRIPTIVE_FLEXS.PROTECTED_FLAG%TYPE,
46: default_context FND_DESCRIPTIVE_FLEXS.DEFAULT_CONTEXT_VALUE%TYPE,
39: table_name FND_DESCRIPTIVE_FLEXS.APPLICATION_TABLE_NAME%TYPE,
40: table_id FND_TABLES.TABLE_ID%TYPE,
41: context_required FND_DESCRIPTIVE_FLEXS.CONTEXT_REQUIRED_FLAG%TYPE,
42: context_column FND_DESCRIPTIVE_FLEXS.CONTEXT_COLUMN_NAME%TYPE,
43: context_override FND_DESCRIPTIVE_FLEXS.CONTEXT_USER_OVERRIDE_FLAG%TYPE,
44: segment_delimiter FND_DESCRIPTIVE_FLEXS.CONCATENATED_SEGMENT_DELIMITER%TYPE,
45: protected_flag FND_DESCRIPTIVE_FLEXS.PROTECTED_FLAG%TYPE,
46: default_context FND_DESCRIPTIVE_FLEXS.DEFAULT_CONTEXT_VALUE%TYPE,
47: reference_field FND_DESCRIPTIVE_FLEXS.DEFAULT_CONTEXT_FIELD_NAME%TYPE,
40: table_id FND_TABLES.TABLE_ID%TYPE,
41: context_required FND_DESCRIPTIVE_FLEXS.CONTEXT_REQUIRED_FLAG%TYPE,
42: context_column FND_DESCRIPTIVE_FLEXS.CONTEXT_COLUMN_NAME%TYPE,
43: context_override FND_DESCRIPTIVE_FLEXS.CONTEXT_USER_OVERRIDE_FLAG%TYPE,
44: segment_delimiter FND_DESCRIPTIVE_FLEXS.CONCATENATED_SEGMENT_DELIMITER%TYPE,
45: protected_flag FND_DESCRIPTIVE_FLEXS.PROTECTED_FLAG%TYPE,
46: default_context FND_DESCRIPTIVE_FLEXS.DEFAULT_CONTEXT_VALUE%TYPE,
47: reference_field FND_DESCRIPTIVE_FLEXS.DEFAULT_CONTEXT_FIELD_NAME%TYPE,
48: context_override_value_set_id FND_DESCRIPTIVE_FLEXS.context_override_value_set_id%TYPE,
41: context_required FND_DESCRIPTIVE_FLEXS.CONTEXT_REQUIRED_FLAG%TYPE,
42: context_column FND_DESCRIPTIVE_FLEXS.CONTEXT_COLUMN_NAME%TYPE,
43: context_override FND_DESCRIPTIVE_FLEXS.CONTEXT_USER_OVERRIDE_FLAG%TYPE,
44: segment_delimiter FND_DESCRIPTIVE_FLEXS.CONCATENATED_SEGMENT_DELIMITER%TYPE,
45: protected_flag FND_DESCRIPTIVE_FLEXS.PROTECTED_FLAG%TYPE,
46: default_context FND_DESCRIPTIVE_FLEXS.DEFAULT_CONTEXT_VALUE%TYPE,
47: reference_field FND_DESCRIPTIVE_FLEXS.DEFAULT_CONTEXT_FIELD_NAME%TYPE,
48: context_override_value_set_id FND_DESCRIPTIVE_FLEXS.context_override_value_set_id%TYPE,
49: context_default_type FND_DESCRIPTIVE_FLEXS.context_default_type%TYPE,
42: context_column FND_DESCRIPTIVE_FLEXS.CONTEXT_COLUMN_NAME%TYPE,
43: context_override FND_DESCRIPTIVE_FLEXS.CONTEXT_USER_OVERRIDE_FLAG%TYPE,
44: segment_delimiter FND_DESCRIPTIVE_FLEXS.CONCATENATED_SEGMENT_DELIMITER%TYPE,
45: protected_flag FND_DESCRIPTIVE_FLEXS.PROTECTED_FLAG%TYPE,
46: default_context FND_DESCRIPTIVE_FLEXS.DEFAULT_CONTEXT_VALUE%TYPE,
47: reference_field FND_DESCRIPTIVE_FLEXS.DEFAULT_CONTEXT_FIELD_NAME%TYPE,
48: context_override_value_set_id FND_DESCRIPTIVE_FLEXS.context_override_value_set_id%TYPE,
49: context_default_type FND_DESCRIPTIVE_FLEXS.context_default_type%TYPE,
50: context_default_value FND_DESCRIPTIVE_FLEXS.context_default_value%TYPE,
43: context_override FND_DESCRIPTIVE_FLEXS.CONTEXT_USER_OVERRIDE_FLAG%TYPE,
44: segment_delimiter FND_DESCRIPTIVE_FLEXS.CONCATENATED_SEGMENT_DELIMITER%TYPE,
45: protected_flag FND_DESCRIPTIVE_FLEXS.PROTECTED_FLAG%TYPE,
46: default_context FND_DESCRIPTIVE_FLEXS.DEFAULT_CONTEXT_VALUE%TYPE,
47: reference_field FND_DESCRIPTIVE_FLEXS.DEFAULT_CONTEXT_FIELD_NAME%TYPE,
48: context_override_value_set_id FND_DESCRIPTIVE_FLEXS.context_override_value_set_id%TYPE,
49: context_default_type FND_DESCRIPTIVE_FLEXS.context_default_type%TYPE,
50: context_default_value FND_DESCRIPTIVE_FLEXS.context_default_value%TYPE,
51: context_runtime_property_funct FND_DESCRIPTIVE_FLEXS.context_runtime_property_funct%TYPE);
44: segment_delimiter FND_DESCRIPTIVE_FLEXS.CONCATENATED_SEGMENT_DELIMITER%TYPE,
45: protected_flag FND_DESCRIPTIVE_FLEXS.PROTECTED_FLAG%TYPE,
46: default_context FND_DESCRIPTIVE_FLEXS.DEFAULT_CONTEXT_VALUE%TYPE,
47: reference_field FND_DESCRIPTIVE_FLEXS.DEFAULT_CONTEXT_FIELD_NAME%TYPE,
48: context_override_value_set_id FND_DESCRIPTIVE_FLEXS.context_override_value_set_id%TYPE,
49: context_default_type FND_DESCRIPTIVE_FLEXS.context_default_type%TYPE,
50: context_default_value FND_DESCRIPTIVE_FLEXS.context_default_value%TYPE,
51: context_runtime_property_funct FND_DESCRIPTIVE_FLEXS.context_runtime_property_funct%TYPE);
52:
45: protected_flag FND_DESCRIPTIVE_FLEXS.PROTECTED_FLAG%TYPE,
46: default_context FND_DESCRIPTIVE_FLEXS.DEFAULT_CONTEXT_VALUE%TYPE,
47: reference_field FND_DESCRIPTIVE_FLEXS.DEFAULT_CONTEXT_FIELD_NAME%TYPE,
48: context_override_value_set_id FND_DESCRIPTIVE_FLEXS.context_override_value_set_id%TYPE,
49: context_default_type FND_DESCRIPTIVE_FLEXS.context_default_type%TYPE,
50: context_default_value FND_DESCRIPTIVE_FLEXS.context_default_value%TYPE,
51: context_runtime_property_funct FND_DESCRIPTIVE_FLEXS.context_runtime_property_funct%TYPE);
52:
53: TYPE CombTblInfo IS RECORD
46: default_context FND_DESCRIPTIVE_FLEXS.DEFAULT_CONTEXT_VALUE%TYPE,
47: reference_field FND_DESCRIPTIVE_FLEXS.DEFAULT_CONTEXT_FIELD_NAME%TYPE,
48: context_override_value_set_id FND_DESCRIPTIVE_FLEXS.context_override_value_set_id%TYPE,
49: context_default_type FND_DESCRIPTIVE_FLEXS.context_default_type%TYPE,
50: context_default_value FND_DESCRIPTIVE_FLEXS.context_default_value%TYPE,
51: context_runtime_property_funct FND_DESCRIPTIVE_FLEXS.context_runtime_property_funct%TYPE);
52:
53: TYPE CombTblInfo IS RECORD
54: (table_application_id NUMBER,
47: reference_field FND_DESCRIPTIVE_FLEXS.DEFAULT_CONTEXT_FIELD_NAME%TYPE,
48: context_override_value_set_id FND_DESCRIPTIVE_FLEXS.context_override_value_set_id%TYPE,
49: context_default_type FND_DESCRIPTIVE_FLEXS.context_default_type%TYPE,
50: context_default_value FND_DESCRIPTIVE_FLEXS.context_default_value%TYPE,
51: context_runtime_property_funct FND_DESCRIPTIVE_FLEXS.context_runtime_property_funct%TYPE);
52:
53: TYPE CombTblInfo IS RECORD
54: (table_application_id NUMBER,
55: combination_table_id NUMBER,