The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_location_rec.LAST_UPDATE_DATE := hr_api.g_date;
l_location_rec.LAST_UPDATED_BY := hr_api.g_number;
l_location_rec.LAST_UPDATE_LOGIN := hr_api.g_number;
select lower(bic.interface_col_name) interface_col_name
from bne_interface_cols_b bic
where bic.interface_code = c_interface_code
and bic.display_flag ='Y';
select lower(bic.interface_col_name) interface_col_name
from bne_interface_cols_b bic
where bic.interface_code = c_interface_code
and bic.display_flag ='N';
select location_id from hr_locations_all where location_code = c_location_code
and business_group_id = c_business_group_id;
e_crt_not_allowed exception; -- when mode is 'Update Only'
raise e_crt_not_allowed; -- Update only flag is enabled but Trying to Create
select style into g_style from hr_locations_all where location_id = l_location_id;
select object_version_number into l_object_version_number from
hr_locations_all where location_id = l_location_id;
hr_location_api.update_location(
p_validate => false
,p_effective_date => p_effective_date
,p_location_id => l_location_id
,p_language_code => p_language_code
,p_location_code => temp_rec.location_code
,p_description => temp_rec.description
,p_timezone_code => temp_rec.timezone_code
,p_tp_header_id => temp_rec.tp_header_id
,p_ece_tp_location_code => temp_rec.ece_tp_location_code
,p_address_line_1 => temp_rec.address_line_1
,p_address_line_2 => temp_rec.address_line_2
,p_address_line_3 => temp_rec.address_line_3
,p_bill_to_site_flag => temp_rec.bill_to_site_flag
,p_country => temp_rec.country
,p_designated_receiver_id => temp_rec.designated_receiver_id
,p_in_organization_flag => temp_rec.in_organization_flag
,p_inactive_date => temp_rec.inactive_date
,p_operating_unit_id => p_operating_unit_id
,p_inventory_organization_id => temp_rec.inventory_organization_id
,p_office_site_flag => temp_rec.office_site_flag
,p_postal_code => temp_rec.postal_code
,p_receiving_site_flag => temp_rec.receiving_site_flag
,p_region_1 => temp_rec.region_1
,p_region_2 => temp_rec.region_2
,p_region_3 => temp_rec.region_3
,p_ship_to_location_id => temp_rec.ship_to_location_id
,p_ship_to_site_flag => temp_rec.ship_to_site_flag
,p_style => temp_rec.style
,p_tax_name => temp_rec.tax_name
,p_telephone_number_1 => temp_rec.telephone_number_1
,p_telephone_number_2 => temp_rec.telephone_number_2
,p_telephone_number_3 => temp_rec.telephone_number_3
,p_town_or_city => temp_rec.town_or_city
,p_loc_information13 => temp_rec.loc_information13
,p_loc_information14 => temp_rec.loc_information14
,p_loc_information15 => temp_rec.loc_information15
,p_loc_information16 => temp_rec.loc_information16
,p_loc_information17 => temp_rec.loc_information17
,p_loc_information18 => temp_rec.loc_information18
,p_loc_information19 => temp_rec.loc_information19
,p_loc_information20 => temp_rec.loc_information20
,p_attribute_category => temp_rec.attribute_category
,p_attribute1 => temp_rec.attribute1
,p_attribute2 => temp_rec.attribute2
,p_attribute3 => temp_rec.attribute3
,p_attribute4 => temp_rec.attribute4
,p_attribute5 => temp_rec.attribute5
,p_attribute6 => temp_rec.attribute6
,p_attribute7 => temp_rec.attribute7
,p_attribute8 => temp_rec.attribute8
,p_attribute9 => temp_rec.attribute9
,p_attribute10 => temp_rec.attribute10
,p_attribute11 => temp_rec.attribute11
,p_attribute12 => temp_rec.attribute12
,p_attribute13 => temp_rec.attribute13
,p_attribute14 => temp_rec.attribute14
,p_attribute15 => temp_rec.attribute15
,p_attribute16 => temp_rec.attribute16
,p_attribute17 => temp_rec.attribute17
,p_attribute18 => temp_rec.attribute18
,p_attribute19 => temp_rec.attribute19
,p_attribute20 => temp_rec.attribute20
,p_global_attribute_category => temp_rec.global_attribute_category
,p_global_attribute1 => temp_rec.global_attribute1
,p_global_attribute2 => temp_rec.global_attribute2
,p_global_attribute3 => temp_rec.global_attribute3
,p_global_attribute4 => temp_rec.global_attribute4
,p_global_attribute5 => temp_rec.global_attribute5
,p_global_attribute6 => temp_rec.global_attribute6
,p_global_attribute7 => temp_rec.global_attribute7
,p_global_attribute8 => temp_rec.global_attribute8
,p_global_attribute9 => temp_rec.global_attribute9
,p_global_attribute10 => temp_rec.global_attribute10
,p_global_attribute11 => temp_rec.global_attribute11
,p_global_attribute12 => temp_rec.global_attribute12
,p_global_attribute13 => temp_rec.global_attribute13
,p_global_attribute14 => temp_rec.global_attribute14
,p_global_attribute15 => temp_rec.global_attribute15
,p_global_attribute16 => temp_rec.global_attribute16
,p_global_attribute17 => temp_rec.global_attribute17
,p_global_attribute18 => temp_rec.global_attribute18
,p_global_attribute19 => temp_rec.global_attribute19
,p_global_attribute20 => temp_rec.global_attribute20
,p_object_version_number => l_object_version_number
);