[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE update_dml(p_rec IN OUT NOCOPY hr_loc_shd.g_rec_type) IS
--
l_proc VARCHAR2(72) := g_package||'update_dml';
UPDATE hr_locations_all
SET
location_id = p_rec.location_id,
entered_by = p_rec.entered_by,
location_code = p_rec.location_code,
timezone_code = p_rec.timezone_code,
address_line_1 = p_rec.address_line_1,
address_line_2 = p_rec.address_line_2,
address_line_3 = p_rec.address_line_3,
bill_to_site_flag = p_rec.bill_to_site_flag,
country = p_rec.country,
description = p_rec.description,
designated_receiver_id = p_rec.designated_receiver_id,
in_organization_flag = p_rec.in_organization_flag,
inactive_date = p_rec.inactive_date,
inventory_organization_id = p_rec.inventory_organization_id,
office_site_flag = p_rec.office_site_flag,
postal_code = p_rec.postal_code,
receiving_site_flag = p_rec.receiving_site_flag,
region_1 = p_rec.region_1,
region_2 = p_rec.region_2,
region_3 = p_rec.region_3,
ship_to_location_id = p_rec.ship_to_location_id,
ship_to_site_flag = p_rec.ship_to_site_flag,
derived_locale = p_rec.derived_locale,
style = p_rec.style,
-- tax_name = p_rec.tax_name,
telephone_number_1 = p_rec.telephone_number_1,
telephone_number_2 = p_rec.telephone_number_2,
telephone_number_3 = p_rec.telephone_number_3,
town_or_city = p_rec.town_or_city,
loc_information13 = p_rec.loc_information13,
loc_information14 = p_rec.loc_information14,
loc_information15 = p_rec.loc_information15,
loc_information16 = p_rec.loc_information16,
loc_information17 = p_rec.loc_information17,
loc_information18 = p_rec.loc_information18,
loc_information19 = p_rec.loc_information19,
loc_information20 = p_rec.loc_information20,
attribute_category = p_rec.attribute_category,
attribute1 = p_rec.attribute1,
attribute2 = p_rec.attribute2,
attribute3 = p_rec.attribute3,
attribute4 = p_rec.attribute4,
attribute5 = p_rec.attribute5,
attribute6 = p_rec.attribute6,
attribute7 = p_rec.attribute7,
attribute8 = p_rec.attribute8,
attribute9 = p_rec.attribute9,
attribute10 = p_rec.attribute10,
attribute11 = p_rec.attribute11,
attribute12 = p_rec.attribute12,
attribute13 = p_rec.attribute13,
attribute14 = p_rec.attribute14,
attribute15 = p_rec.attribute15,
attribute16 = p_rec.attribute16,
attribute17 = p_rec.attribute17,
attribute18 = p_rec.attribute18,
attribute19 = p_rec.attribute19,
attribute20 = p_rec.attribute20,
object_version_number = p_rec.object_version_number,
global_attribute_category = p_rec.global_attribute_category,
global_attribute1 = p_rec.global_attribute1,
global_attribute2 = p_rec.global_attribute2,
global_attribute3 = p_rec.global_attribute3,
global_attribute4 = p_rec.global_attribute4,
global_attribute5 = p_rec.global_attribute5,
global_attribute6 = p_rec.global_attribute6,
global_attribute7 = p_rec.global_attribute7,
global_attribute8 = p_rec.global_attribute8,
global_attribute9 = p_rec.global_attribute9,
global_attribute10 = p_rec.global_attribute10,
global_attribute11 = p_rec.global_attribute11,
global_attribute12 = p_rec.global_attribute12,
global_attribute13 = p_rec.global_attribute13,
global_attribute14 = p_rec.global_attribute14,
global_attribute15 = p_rec.global_attribute15,
global_attribute16 = p_rec.global_attribute16,
global_attribute17 = p_rec.global_attribute17,
global_attribute18 = p_rec.global_attribute18,
global_attribute19 = p_rec.global_attribute19,
global_attribute20 = p_rec.global_attribute20,
legal_address_flag = p_rec.legal_address_flag,
tp_header_id = p_rec.tp_header_id,
ece_tp_location_code = p_rec.ece_tp_location_code,
geometry = p_rec.geometry
WHERE location_id = p_rec.location_id;
END update_dml;
PROCEDURE pre_update(p_rec IN OUT NOCOPY hr_loc_shd.g_rec_type
) IS
--
l_proc VARCHAR2(72) := g_package||'pre_update';
END pre_update;
PROCEDURE post_update(p_rec IN hr_loc_shd.g_rec_type,
p_effective_date IN DATE) IS
--
l_proc VARCHAR2(72) := g_package||'post_update';
hr_loc_rku.after_update
(p_effective_date => p_effective_date
,p_location_id => p_rec.location_id
,p_location_code => p_rec.location_code
,p_timezone_code => p_rec.timezone_code
,p_address_line_1 => p_rec.address_line_1
,p_address_line_2 => p_rec.address_line_2
,p_address_line_3 => p_rec.address_line_3
,p_bill_to_site_flag => p_rec.bill_to_site_flag
,p_country => p_rec.country
,p_description => p_rec.description
,p_designated_receiver_id => p_rec.designated_receiver_id
,p_in_organization_flag => p_rec.in_organization_flag
,p_inactive_date => p_rec.inactive_date
,p_inventory_organization_id => p_rec.inventory_organization_id
,p_office_site_flag => p_rec.office_site_flag
,p_postal_code => p_rec.postal_code
,p_receiving_site_flag => p_rec.receiving_site_flag
,p_region_1 => p_rec.region_1
,p_region_2 => p_rec.region_2
,p_region_3 => p_rec.region_3
,p_ship_to_location_id => p_rec.ship_to_location_id
,p_ship_to_site_flag => p_rec.ship_to_site_flag
,p_tax_name => p_rec.tax_name
,p_telephone_number_1 => p_rec.telephone_number_1
,p_telephone_number_2 => p_rec.telephone_number_2
,p_telephone_number_3 => p_rec.telephone_number_3
,p_town_or_city => p_rec.town_or_city
,p_loc_information13 => p_rec.loc_information13
,p_loc_information14 => p_rec.loc_information14
,p_loc_information15 => p_rec.loc_information15
,p_loc_information16 => p_rec.loc_information16
,p_loc_information17 => p_rec.loc_information17
,p_loc_information18 => p_rec.loc_information18
,p_loc_information19 => p_rec.loc_information19
,p_loc_information20 => p_rec.loc_information20
,p_attribute_category => p_rec.attribute_category
,p_attribute1 => p_rec.attribute1
,p_attribute2 => p_rec.attribute2
,p_attribute3 => p_rec.attribute3
,p_attribute4 => p_rec.attribute4
,p_attribute5 => p_rec.attribute5
,p_attribute6 => p_rec.attribute6
,p_attribute7 => p_rec.attribute7
,p_attribute8 => p_rec.attribute8
,p_attribute9 => p_rec.attribute9
,p_attribute10 => p_rec.attribute10
,p_attribute11 => p_rec.attribute11
,p_attribute12 => p_rec.attribute12
,p_attribute13 => p_rec.attribute13
,p_attribute14 => p_rec.attribute14
,p_attribute15 => p_rec.attribute15
,p_attribute16 => p_rec.attribute16
,p_attribute17 => p_rec.attribute17
,p_attribute18 => p_rec.attribute18
,p_attribute19 => p_rec.attribute19
,p_attribute20 => p_rec.attribute20
,p_global_attribute_category => p_rec.global_attribute_category
,p_global_attribute1 => p_rec.global_attribute1
,p_global_attribute2 => p_rec.global_attribute2
,p_global_attribute3 => p_rec.global_attribute3
,p_global_attribute4 => p_rec.global_attribute4
,p_global_attribute5 => p_rec.global_attribute5
,p_global_attribute6 => p_rec.global_attribute6
,p_global_attribute7 => p_rec.global_attribute7
,p_global_attribute8 => p_rec.global_attribute8
,p_global_attribute9 => p_rec.global_attribute9
,p_global_attribute10 => p_rec.global_attribute10
,p_global_attribute11 => p_rec.global_attribute11
,p_global_attribute12 => p_rec.global_attribute12
,p_global_attribute13 => p_rec.global_attribute13
,p_global_attribute14 => p_rec.global_attribute14
,p_global_attribute15 => p_rec.global_attribute15
,p_global_attribute16 => p_rec.global_attribute16
,p_global_attribute17 => p_rec.global_attribute17
,p_global_attribute18 => p_rec.global_attribute18
,p_global_attribute19 => p_rec.global_attribute19
,p_global_attribute20 => p_rec.global_attribute20
,p_legal_address_flag => p_rec.legal_address_flag
,p_tp_header_id => p_rec.tp_header_id
,p_ece_tp_location_code => p_rec.ece_tp_location_code
,p_object_version_number => p_rec.object_version_number
,p_business_group_id => p_rec.business_group_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_update;
hr_loc_bus.update_validate(p_rec
,p_effective_date
,p_operating_unit_id);
pre_update(p_rec);
update_dml(p_rec);
post_update(p_rec,
p_effective_date);
hr_api.g_number -- business_group_id is not updateable
);