[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_dml(p_rec IN OUT NOCOPY hr_loc_shd.g_rec_type) IS
--
l_proc VARCHAR2(72) := g_package||'insert_dml';
INSERT INTO hr_locations_all
( location_id,
entered_by,
location_code,
timezone_code,
address_line_1,
address_line_2,
address_line_3,
bill_to_site_flag,
country,
description,
designated_receiver_id,
in_organization_flag,
inactive_date,
inventory_organization_id,
office_site_flag,
postal_code,
receiving_site_flag,
region_1,
region_2,
region_3,
ship_to_location_id,
ship_to_site_flag,
derived_locale,
style,
tax_name,
telephone_number_1,
telephone_number_2,
telephone_number_3,
town_or_city,
loc_information13,
loc_information14,
loc_information15,
loc_information16,
loc_information17,
loc_information18,
loc_information19,
loc_information20,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
object_version_number,
global_attribute_category,
global_attribute1,
global_attribute2,
global_attribute3,
global_attribute4,
global_attribute5,
global_attribute6,
global_attribute7,
global_attribute8,
global_attribute9,
global_attribute10,
global_attribute11,
global_attribute12,
global_attribute13,
global_attribute14,
global_attribute15,
global_attribute16,
global_attribute17,
global_attribute18,
global_attribute19,
global_attribute20,
legal_address_flag,
tp_header_id,
ece_tp_location_code,
business_group_id,
geometry
)
VALUES
( p_rec.location_id,
p_rec.entered_by,
p_rec.location_code,
p_rec.timezone_code,
p_rec.address_line_1,
p_rec.address_line_2,
p_rec.address_line_3,
p_rec.bill_to_site_flag,
p_rec.country,
p_rec.description,
p_rec.designated_receiver_id,
p_rec.in_organization_flag,
p_rec.inactive_date,
p_rec.inventory_organization_id,
p_rec.office_site_flag,
p_rec.postal_code,
p_rec.receiving_site_flag,
p_rec.region_1,
p_rec.region_2,
p_rec.region_3,
p_rec.ship_to_location_id,
p_rec.ship_to_site_flag,
p_rec.derived_locale,
p_rec.style,
p_rec.tax_name,
p_rec.telephone_number_1,
p_rec.telephone_number_2,
p_rec.telephone_number_3,
p_rec.town_or_city,
p_rec.loc_information13,
p_rec.loc_information14,
p_rec.loc_information15,
p_rec.loc_information16,
p_rec.loc_information17,
p_rec.loc_information18,
p_rec.loc_information19,
p_rec.loc_information20,
p_rec.attribute_category,
p_rec.attribute1,
p_rec.attribute2,
p_rec.attribute3,
p_rec.attribute4,
p_rec.attribute5,
p_rec.attribute6,
p_rec.attribute7,
p_rec.attribute8,
p_rec.attribute9,
p_rec.attribute10,
p_rec.attribute11,
p_rec.attribute12,
p_rec.attribute13,
p_rec.attribute14,
p_rec.attribute15,
p_rec.attribute16,
p_rec.attribute17,
p_rec.attribute18,
p_rec.attribute19,
p_rec.attribute20,
p_rec.object_version_number,
p_rec.global_attribute_category,
p_rec.global_attribute1,
p_rec.global_attribute2,
p_rec.global_attribute3,
p_rec.global_attribute4,
p_rec.global_attribute5,
p_rec.global_attribute6,
p_rec.global_attribute7,
p_rec.global_attribute8,
p_rec.global_attribute9,
p_rec.global_attribute10,
p_rec.global_attribute11,
p_rec.global_attribute12,
p_rec.global_attribute13,
p_rec.global_attribute14,
p_rec.global_attribute15,
p_rec.global_attribute16,
p_rec.global_attribute17,
p_rec.global_attribute18,
p_rec.global_attribute19,
p_rec.global_attribute20,
p_rec.legal_address_flag,
p_rec.tp_header_id,
p_rec.ece_tp_location_code,
p_rec.business_group_id,
p_rec.geometry
);
END insert_dml;
PROCEDURE pre_insert(p_rec IN OUT NOCOPY hr_loc_shd.g_rec_type) IS
--
l_proc VARCHAR2(72) := g_package||'pre_insert';
SELECT hr_locations_s.nextval
FROM sys.dual;
END pre_insert;
PROCEDURE post_insert(p_rec IN hr_loc_shd.g_rec_type,
p_effective_date IN DATE) IS
--
l_proc VARCHAR2(72) := g_package||'post_insert';
hr_loc_rki.after_insert
(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_style => p_rec.style
,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
);
END post_insert;
hr_loc_bus.insert_validate(p_rec
,p_effective_date
,p_operating_unit_id);
pre_insert(p_rec);
insert_dml(p_rec);
post_insert(p_rec,
p_effective_date);