The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_last_update_date In Varchar2 Default Null,
p_enabled_flag In Varchar2,
p_summary_flag In Varchar2,
p_start_date_active In Varchar2,
p_end_date_active In Varchar2,
p_parent_flex_value_high In Varchar2,
p_rollup_hierarchy_code In Varchar2,
p_hierarchy_level In Varchar2,
p_compiled_value_attributes In Varchar2,
p_value_category In Varchar2,
p_attribute1 In Varchar2,
p_attribute2 In Varchar2,
p_attribute3 In Varchar2,
p_attribute4 In Varchar2,
p_attribute5 In Varchar2,
p_attribute6 In Varchar2,
p_attribute7 In Varchar2,
p_attribute8 In Varchar2,
p_attribute9 In Varchar2,
p_attribute10 In Varchar2,
p_attribute11 In Varchar2,
p_attribute12 In Varchar2,
p_attribute13 In Varchar2,
p_attribute14 In Varchar2,
p_attribute15 In Varchar2,
p_attribute16 In Varchar2,
p_attribute17 In Varchar2,
p_attribute18 In Varchar2,
p_attribute19 In Varchar2,
p_attribute20 In Varchar2,
p_attribute21 In Varchar2,
p_attribute22 In Varchar2,
p_attribute23 In Varchar2,
p_attribute24 In Varchar2,
p_attribute25 In Varchar2,
p_attribute26 In Varchar2,
p_attribute27 In Varchar2,
p_attribute28 In Varchar2,
p_attribute29 In Varchar2,
p_attribute30 In Varchar2,
p_attribute31 In Varchar2,
p_attribute32 In Varchar2,
p_attribute33 In Varchar2,
p_attribute34 In Varchar2,
p_attribute35 In Varchar2,
p_attribute36 In Varchar2,
p_attribute37 In Varchar2,
p_attribute38 In Varchar2,
p_attribute39 In Varchar2,
p_attribute40 In Varchar2,
p_attribute41 In Varchar2,
p_attribute42 In Varchar2,
p_attribute43 In Varchar2,
p_attribute44 In Varchar2,
p_attribute45 In Varchar2,
p_attribute46 In Varchar2,
p_attribute47 In Varchar2,
p_attribute48 In Varchar2,
p_attribute49 In Varchar2,
p_attribute50 In Varchar2,
p_flex_value_meaning In Varchar2,
p_description In Varchar2) Is
Cursor csr_value_set_info Is
Select format_type, maximum_size, number_precision,alphanumeric_allowed_flag,
uppercase_only_flag, numeric_mode_enabled_flag,
minimum_value, maximum_value
From fnd_flex_value_sets
Where flex_value_set_name = p_flex_value_set_name ;
,p_last_update_date => p_last_update_date
,p_enabled_flag => p_enabled_flag
,p_summary_flag => p_summary_flag
,p_start_date_active => p_start_date_active
,p_end_date_active => p_end_date_active
,p_parent_flex_value_high => p_parent_flex_value_high
,p_rollup_hierarchy_code => p_rollup_hierarchy_code
,p_hierarchy_level => p_hierarchy_level
,p_compiled_value_attributes => p_compiled_value_attributes
,p_value_category => p_value_category
,p_attribute1 => p_attribute1
,p_attribute2 => p_attribute2
,p_attribute3 => p_attribute3
,p_attribute4 => p_attribute4
,p_attribute5 => p_attribute5
,p_attribute6 => p_attribute6
,p_attribute7 => p_attribute7
,p_attribute8 => p_attribute8
,p_attribute9 => p_attribute9
,p_attribute10 => p_attribute10
,p_attribute11 => p_attribute11
,p_attribute12 => p_attribute12
,p_attribute13 => p_attribute13
,p_attribute14 => p_attribute14
,p_attribute15 => p_attribute15
,p_attribute16 => p_attribute16
,p_attribute17 => p_attribute17
,p_attribute18 => p_attribute18
,p_attribute19 => p_attribute19
,p_attribute20 => p_attribute20
,p_attribute21 => p_attribute21
,p_attribute22 => p_attribute22
,p_attribute23 => p_attribute23
,p_attribute24 => p_attribute24
,p_attribute25 => p_attribute25
,p_attribute26 => p_attribute26
,p_attribute27 => p_attribute27
,p_attribute28 => p_attribute28
,p_attribute29 => p_attribute29
,p_attribute30 => p_attribute30
,p_attribute31 => p_attribute31
,p_attribute32 => p_attribute32
,p_attribute33 => p_attribute33
,p_attribute34 => p_attribute34
,p_attribute35 => p_attribute35
,p_attribute36 => p_attribute36
,p_attribute37 => p_attribute37
,p_attribute38 => p_attribute38
,p_attribute39 => p_attribute39
,p_attribute40 => p_attribute40
,p_attribute41 => p_attribute41
,p_attribute42 => p_attribute42
,p_attribute43 => p_attribute43
,p_attribute44 => p_attribute44
,p_attribute45 => p_attribute45
,p_attribute46 => p_attribute46
,p_attribute47 => p_attribute47
,p_attribute48 => p_attribute48
,p_attribute49 => p_attribute49
,p_attribute50 => p_attribute50
,p_flex_value_meaning => l_display_value
,p_description => p_description
);
hrdpp_create_organization.insert_batch_lines(p_batch_id => p_batch_id
,p_data_pump_batch_line_id => p_data_pump_batch_line_id
,p_user_sequence => p_user_sequence
,p_link_value => p_link_value
,p_effective_date => p_effective_date
,p_language_code => p_language_code
,p_date_from => p_date_from
,p_name => p_name
,p_date_to => p_date_to
,p_internal_external_flag => p_internal_external_flag
,p_internal_address_line => p_internal_address_line
,p_type => p_type
,p_attribute_category => p_attribute_category
,p_attribute1 => p_attribute1
,p_attribute2 => p_attribute2
,p_attribute3 => p_attribute3
,p_attribute4 => p_attribute4
,p_attribute5 => p_attribute5
,p_attribute6 => p_attribute6
,p_attribute7 => p_attribute7
,p_attribute8 => p_attribute8
,p_attribute9 => p_attribute9
,p_attribute10 => p_attribute10
,p_attribute11 => p_attribute11
,p_attribute12 => p_attribute12
,p_attribute13 => p_attribute13
,p_attribute14 => p_attribute14
,p_attribute15 => p_attribute15
,p_attribute16 => p_attribute16
,p_attribute17 => p_attribute17
,p_attribute18 => p_attribute18
,p_attribute19 => p_attribute19
,p_attribute20 => p_attribute20
,p_org_user_key => p_org_user_key
,p_location_code => p_location_code
);
hrdpp_create_org_classificatio.insert_batch_lines(
p_batch_id => p_batch_id
,p_data_pump_batch_line_id => p_data_pump_batch_line_id
,p_user_sequence => p_user_sequence
,p_link_value => p_link_value
,p_effective_date => p_effective_date
,p_org_classif_code => l_org_class(x)
,p_organization_name => p_name
,p_language_code => p_language_code
);