The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE delete_dml(p_rec IN hr_loc_shd.g_rec_type) IS
--
l_proc VARCHAR2(72) := g_package||'delete_dml';
DELETE FROM hr_locations_all
WHERE location_id = p_rec.location_id;
END delete_dml;
PROCEDURE pre_delete(p_rec IN hr_loc_shd.g_rec_type) IS
--
l_proc VARCHAR2(72) := g_package||'pre_delete';
END pre_delete;
PROCEDURE post_delete(p_rec IN hr_loc_shd.g_rec_type) IS
--
l_proc VARCHAR2(72) := g_package||'post_delete';
hr_loc_rkd.after_delete
( p_location_id => p_rec.location_id
--
,p_location_code_o => hr_loc_shd.g_old_rec.location_code
,p_address_line_1_o => hr_loc_shd.g_old_rec.address_line_1
,p_address_line_2_o => hr_loc_shd.g_old_rec.address_line_2
,p_address_line_3_o => hr_loc_shd.g_old_rec.address_line_3
,p_bill_to_site_flag_o => hr_loc_shd.g_old_rec.bill_to_site_flag
,p_country_o => hr_loc_shd.g_old_rec.country
,p_description_o => hr_loc_shd.g_old_rec.description
,p_designated_receiver_id_o => hr_loc_shd.g_old_rec.designated_receiver_id
,p_in_organization_flag_o => hr_loc_shd.g_old_rec.in_organization_flag
,p_inactive_date_o => hr_loc_shd.g_old_rec.inactive_date
,p_inventory_organization_id_o => hr_loc_shd.g_old_rec.inventory_organization_id
,p_office_site_flag_o => hr_loc_shd.g_old_rec.office_site_flag
,p_postal_code_o => hr_loc_shd.g_old_rec.postal_code
,p_receiving_site_flag_o => hr_loc_shd.g_old_rec.receiving_site_flag
,p_region_1_o => hr_loc_shd.g_old_rec.region_1
,p_region_2_o => hr_loc_shd.g_old_rec.region_2
,p_region_3_o => hr_loc_shd.g_old_rec.region_3
,p_ship_to_location_id_o => hr_loc_shd.g_old_rec.ship_to_location_id
,p_ship_to_site_flag_o => hr_loc_shd.g_old_rec.ship_to_site_flag
,p_style_o => hr_loc_shd.g_old_rec.style
,p_tax_name_o => hr_loc_shd.g_old_rec.tax_name
,p_telephone_number_1_o => hr_loc_shd.g_old_rec.telephone_number_1
,p_telephone_number_2_o => hr_loc_shd.g_old_rec.telephone_number_2
,p_telephone_number_3_o => hr_loc_shd.g_old_rec.telephone_number_3
,p_town_or_city_o => hr_loc_shd.g_old_rec.town_or_city
,p_loc_information13_o => hr_loc_shd.g_old_rec.loc_information13
,p_loc_information14_o => hr_loc_shd.g_old_rec.loc_information14
,p_loc_information15_o => hr_loc_shd.g_old_rec.loc_information15
,p_loc_information16_o => hr_loc_shd.g_old_rec.loc_information16
,p_loc_information17_o => hr_loc_shd.g_old_rec.loc_information17
,p_loc_information18_o => hr_loc_shd.g_old_rec.loc_information18
,p_loc_information19_o => hr_loc_shd.g_old_rec.loc_information19
,p_loc_information20_o => hr_loc_shd.g_old_rec.loc_information20
,p_attribute_category_o => hr_loc_shd.g_old_rec.attribute_category
,p_attribute1_o => hr_loc_shd.g_old_rec.attribute1
,p_attribute2_o => hr_loc_shd.g_old_rec.attribute2
,p_attribute3_o => hr_loc_shd.g_old_rec.attribute3
,p_attribute4_o => hr_loc_shd.g_old_rec.attribute4
,p_attribute5_o => hr_loc_shd.g_old_rec.attribute5
,p_attribute6_o => hr_loc_shd.g_old_rec.attribute6
,p_attribute7_o => hr_loc_shd.g_old_rec.attribute7
,p_attribute8_o => hr_loc_shd.g_old_rec.attribute8
,p_attribute9_o => hr_loc_shd.g_old_rec.attribute9
,p_attribute10_o => hr_loc_shd.g_old_rec.attribute10
,p_attribute11_o => hr_loc_shd.g_old_rec.attribute11
,p_attribute12_o => hr_loc_shd.g_old_rec.attribute12
,p_attribute13_o => hr_loc_shd.g_old_rec.attribute13
,p_attribute14_o => hr_loc_shd.g_old_rec.attribute14
,p_attribute15_o => hr_loc_shd.g_old_rec.attribute15
,p_attribute16_o => hr_loc_shd.g_old_rec.attribute16
,p_attribute17_o => hr_loc_shd.g_old_rec.attribute17
,p_attribute18_o => hr_loc_shd.g_old_rec.attribute18
,p_attribute19_o => hr_loc_shd.g_old_rec.attribute19
,p_attribute20_o => hr_loc_shd.g_old_rec.attribute20
,p_global_attribute_category_o => hr_loc_shd.g_old_rec.global_attribute_category
,p_global_attribute1_o => hr_loc_shd.g_old_rec.global_attribute1
,p_global_attribute2_o => hr_loc_shd.g_old_rec.global_attribute2
,p_global_attribute3_o => hr_loc_shd.g_old_rec.global_attribute3
,p_global_attribute4_o => hr_loc_shd.g_old_rec.global_attribute4
,p_global_attribute5_o => hr_loc_shd.g_old_rec.global_attribute5
,p_global_attribute6_o => hr_loc_shd.g_old_rec.global_attribute6
,p_global_attribute7_o => hr_loc_shd.g_old_rec.global_attribute7
,p_global_attribute8_o => hr_loc_shd.g_old_rec.global_attribute8
,p_global_attribute9_o => hr_loc_shd.g_old_rec.global_attribute9
,p_global_attribute10_o => hr_loc_shd.g_old_rec.global_attribute10
,p_global_attribute11_o => hr_loc_shd.g_old_rec.global_attribute11
,p_global_attribute12_o => hr_loc_shd.g_old_rec.global_attribute12
,p_global_attribute13_o => hr_loc_shd.g_old_rec.global_attribute13
,p_global_attribute14_o => hr_loc_shd.g_old_rec.global_attribute14
,p_global_attribute15_o => hr_loc_shd.g_old_rec.global_attribute15
,p_global_attribute16_o => hr_loc_shd.g_old_rec.global_attribute16
,p_global_attribute17_o => hr_loc_shd.g_old_rec.global_attribute17
,p_global_attribute18_o => hr_loc_shd.g_old_rec.global_attribute18
,p_global_attribute19_o => hr_loc_shd.g_old_rec.global_attribute19
,p_global_attribute20_o => hr_loc_shd.g_old_rec.global_attribute20
,p_legal_address_flag_o => hr_loc_shd.g_old_rec.legal_address_flag
,p_tp_header_id_o => hr_loc_shd.g_old_rec.tp_header_id
,p_ece_tp_location_code_o => hr_loc_shd.g_old_rec.ece_tp_location_code
,p_object_version_number_o => hr_loc_shd.g_old_rec.object_version_number
,p_business_group_id_o => hr_loc_shd.g_old_rec.business_group_id
);
END post_delete;
hr_loc_bus.delete_validate( p_rec => p_rec );
pre_delete(p_rec);
delete_dml(p_rec);
post_delete(p_rec);