The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure update_dml(p_rec in out nocopy per_add_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'update_dml';
update per_addresses
set
address_id = p_rec.address_id,
business_group_id = p_rec.business_group_id,
person_id = p_rec.person_id,
-- 70.2 change a start.
date_from = p_rec.date_from,
-- 70.2 change a end.
derived_locale = p_rec.derived_locale,
address_line1 = p_rec.address_line1,
address_line2 = p_rec.address_line2,
address_line3 = p_rec.address_line3,
address_type = p_rec.address_type,
comments = p_rec.comments,
country = p_rec.country,
date_to = p_rec.date_to,
postal_code = p_rec.postal_code,
region_1 = p_rec.region_1,
region_2 = p_rec.region_2,
region_3 = p_rec.region_3,
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,
request_id = p_rec.request_id,
program_application_id = p_rec.program_application_id,
program_id = p_rec.program_id,
program_update_date = p_rec.program_update_date,
addr_attribute_category = p_rec.addr_attribute_category,
addr_attribute1 = p_rec.addr_attribute1,
addr_attribute2 = p_rec.addr_attribute2,
addr_attribute3 = p_rec.addr_attribute3,
addr_attribute4 = p_rec.addr_attribute4,
addr_attribute5 = p_rec.addr_attribute5,
addr_attribute6 = p_rec.addr_attribute6,
addr_attribute7 = p_rec.addr_attribute7,
addr_attribute8 = p_rec.addr_attribute8,
addr_attribute9 = p_rec.addr_attribute9,
addr_attribute10 = p_rec.addr_attribute10,
addr_attribute11 = p_rec.addr_attribute11,
addr_attribute12 = p_rec.addr_attribute12,
addr_attribute13 = p_rec.addr_attribute13,
addr_attribute14 = p_rec.addr_attribute14,
addr_attribute15 = p_rec.addr_attribute15,
addr_attribute16 = p_rec.addr_attribute16,
addr_attribute17 = p_rec.addr_attribute17,
addr_attribute18 = p_rec.addr_attribute18,
addr_attribute19 = p_rec.addr_attribute19,
addr_attribute20 = p_rec.addr_attribute20,
add_information13 = p_rec.add_information13,
add_information14 = p_rec.add_information14,
add_information15 = p_rec.add_information15,
add_information16 = p_rec.add_information16,
add_information17 = p_rec.add_information17,
add_information18 = p_rec.add_information18,
add_information19 = p_rec.add_information19,
add_information20 = p_rec.add_information20,
party_id = p_rec.party_id,
object_version_number = p_rec.object_version_number,
geometry = p_rec.geometry,
-- Start of fix for Bug #2431588
primary_flag = p_rec.primary_flag,
-- End of fix for Bug #2431588
style = p_rec.style
where address_id = p_rec.address_id;
End update_dml;
Procedure pre_update(p_rec in out nocopy per_add_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'pre_update';
End pre_update;
Procedure post_update
(p_rec in per_add_shd.g_rec_type
,p_effective_date in date
,p_prflagval_override in boolean
,p_validate_county in boolean
)
is
--
l_proc varchar2(72) := g_package||'post_update';
per_add_rku.after_update
(p_address_id => p_rec.address_id
,p_business_group_id => p_rec.business_group_id
,p_person_id => p_rec.person_id
,p_date_from => p_rec.date_from
,p_address_line1 => p_rec.address_line1
,p_address_line2 => p_rec.address_line2
,p_address_line3 => p_rec.address_line3
,p_address_type => p_rec.address_type
,p_comments => p_rec.comments
,p_country => p_rec.country
,p_date_to => p_rec.date_to
,p_postal_code => p_rec.postal_code
,p_region_1 => p_rec.region_1
,p_region_2 => p_rec.region_2
,p_region_3 => p_rec.region_3
,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_request_id => p_rec.request_id
,p_program_application_id => p_rec.program_application_id
,p_program_id => p_rec.program_id
,p_program_update_date => p_rec.program_update_date
,p_addr_attribute_category => p_rec.addr_attribute_category
,p_addr_attribute1 => p_rec.addr_attribute1
,p_addr_attribute2 => p_rec.addr_attribute2
,p_addr_attribute3 => p_rec.addr_attribute3
,p_addr_attribute4 => p_rec.addr_attribute4
,p_addr_attribute5 => p_rec.addr_attribute5
,p_addr_attribute6 => p_rec.addr_attribute6
,p_addr_attribute7 => p_rec.addr_attribute7
,p_addr_attribute8 => p_rec.addr_attribute8
,p_addr_attribute9 => p_rec.addr_attribute9
,p_addr_attribute10 => p_rec.addr_attribute10
,p_addr_attribute11 => p_rec.addr_attribute11
,p_addr_attribute12 => p_rec.addr_attribute12
,p_addr_attribute13 => p_rec.addr_attribute13
,p_addr_attribute14 => p_rec.addr_attribute14
,p_addr_attribute15 => p_rec.addr_attribute15
,p_addr_attribute16 => p_rec.addr_attribute16
,p_addr_attribute17 => p_rec.addr_attribute17
,p_addr_attribute18 => p_rec.addr_attribute18
,p_addr_attribute19 => p_rec.addr_attribute19
,p_addr_attribute20 => p_rec.addr_attribute20
,p_add_information13 => p_rec.add_information13
,p_add_information14 => p_rec.add_information14
,p_add_information15 => p_rec.add_information15
,p_add_information16 => p_rec.add_information16
,p_add_information17 => p_rec.add_information17
,p_add_information18 => p_rec.add_information18
,p_add_information19 => p_rec.add_information19
,p_add_information20 => p_rec.add_information20
,p_object_version_number => p_rec.object_version_number
,p_effective_date => p_effective_date
,p_prflagval_override => p_prflagval_override
,p_validate_county => p_validate_county
,p_business_group_id_o
=> per_add_shd.g_old_rec.business_group_id
,p_person_id_o
=> per_add_shd.g_old_rec.person_id
,p_date_from_o
=> per_add_shd.g_old_rec.date_from
,p_primary_flag_o
=> per_add_shd.g_old_rec.primary_flag
,p_style_o
=> per_add_shd.g_old_rec.style
,p_address_line1_o
=> per_add_shd.g_old_rec.address_line1
,p_address_line2_o
=> per_add_shd.g_old_rec.address_line2
,p_address_line3_o
=> per_add_shd.g_old_rec.address_line3
,p_address_type_o
=> per_add_shd.g_old_rec.address_type
,p_comments_o
=> per_add_shd.g_old_rec.comments
,p_country_o
=> per_add_shd.g_old_rec.country
,p_date_to_o
=> per_add_shd.g_old_rec.date_to
,p_postal_code_o
=> per_add_shd.g_old_rec.postal_code
,p_region_1_o
=> per_add_shd.g_old_rec.region_1
,p_region_2_o
=> per_add_shd.g_old_rec.region_2
,p_region_3_o
=> per_add_shd.g_old_rec.region_3
,p_telephone_number_1_o
=> per_add_shd.g_old_rec.telephone_number_1
,p_telephone_number_2_o
=> per_add_shd.g_old_rec.telephone_number_2
,p_telephone_number_3_o
=> per_add_shd.g_old_rec.telephone_number_3
,p_town_or_city_o
=> per_add_shd.g_old_rec.town_or_city
,p_request_id_o
=> per_add_shd.g_old_rec.request_id
,p_program_application_id_o
=> per_add_shd.g_old_rec.program_application_id
,p_program_id_o
=> per_add_shd.g_old_rec.program_id
,p_program_update_date_o
=> per_add_shd.g_old_rec.program_update_date
,p_addr_attribute_category_o
=> per_add_shd.g_old_rec.addr_attribute_category
,p_addr_attribute1_o
=> per_add_shd.g_old_rec.addr_attribute1
,p_addr_attribute2_o
=> per_add_shd.g_old_rec.addr_attribute2
,p_addr_attribute3_o
=> per_add_shd.g_old_rec.addr_attribute3
,p_addr_attribute4_o
=> per_add_shd.g_old_rec.addr_attribute4
,p_addr_attribute5_o
=> per_add_shd.g_old_rec.addr_attribute5
,p_addr_attribute6_o
=> per_add_shd.g_old_rec.addr_attribute6
,p_addr_attribute7_o
=> per_add_shd.g_old_rec.addr_attribute7
,p_addr_attribute8_o
=> per_add_shd.g_old_rec.addr_attribute8
,p_addr_attribute9_o
=> per_add_shd.g_old_rec.addr_attribute9
,p_addr_attribute10_o
=> per_add_shd.g_old_rec.addr_attribute10
,p_addr_attribute11_o
=> per_add_shd.g_old_rec.addr_attribute11
,p_addr_attribute12_o
=> per_add_shd.g_old_rec.addr_attribute12
,p_addr_attribute13_o
=> per_add_shd.g_old_rec.addr_attribute13
,p_addr_attribute14_o
=> per_add_shd.g_old_rec.addr_attribute14
,p_addr_attribute15_o
=> per_add_shd.g_old_rec.addr_attribute15
,p_addr_attribute16_o
=> per_add_shd.g_old_rec.addr_attribute16
,p_addr_attribute17_o
=> per_add_shd.g_old_rec.addr_attribute17
,p_addr_attribute18_o
=> per_add_shd.g_old_rec.addr_attribute18
,p_addr_attribute19_o
=> per_add_shd.g_old_rec.addr_attribute19
,p_addr_attribute20_o
=> per_add_shd.g_old_rec.addr_attribute20
,p_add_information13_o
=> per_add_shd.g_old_rec.add_information13
,p_add_information14_o
=> per_add_shd.g_old_rec.add_information14
,p_add_information15_o
=> per_add_shd.g_old_rec.add_information15
,p_add_information16_o
=> per_add_shd.g_old_rec.add_information16
,p_add_information17_o
=> per_add_shd.g_old_rec.add_information17
,p_add_information18_o
=> per_add_shd.g_old_rec.add_information18
,p_add_information19_o
=> per_add_shd.g_old_rec.add_information19
,p_add_information20_o
=> per_add_shd.g_old_rec.add_information20
,p_object_version_number_o
=> per_add_shd.g_old_rec.object_version_number
,p_party_id_o -- HR/TCA merge
=> per_add_shd.g_old_rec.party_id
);
End post_update;
If (p_rec.program_update_date = hr_api.g_date) then
p_rec.program_update_date :=
per_add_shd.g_old_rec.program_update_date;
per_add_bus.update_validate(l_convert
,p_effective_date
,p_prflagval_override
,p_validate_county
);
pre_update(p_rec);
update_dml(p_rec);
post_update(p_rec
,p_effective_date
,p_prflagval_override
,p_validate_county
);
,p_program_update_date in date default hr_api.g_date
,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
,p_add_information13 in varchar2 default hr_api.g_varchar2
,p_add_information14 in varchar2 default hr_api.g_varchar2
,p_add_information15 in varchar2 default hr_api.g_varchar2
,p_add_information16 in varchar2 default hr_api.g_varchar2
,p_add_information17 in varchar2 default hr_api.g_varchar2
,p_add_information18 in varchar2 default hr_api.g_varchar2
,p_add_information19 in varchar2 default hr_api.g_varchar2
,p_add_information20 in varchar2 default hr_api.g_varchar2
,p_object_version_number in out nocopy number
,p_party_id in number default hr_api.g_number
,p_validate in boolean default false
,p_effective_date in date
,p_prflagval_override in boolean default false
,p_validate_county in boolean default true
,p_style in varchar2 default hr_api.g_varchar2
) is
--
l_rec per_add_shd.g_rec_type;
p_program_update_date,
p_addr_attribute_category,
p_addr_attribute1,
p_addr_attribute2,
p_addr_attribute3,
p_addr_attribute4,
p_addr_attribute5,
p_addr_attribute6,
p_addr_attribute7,
p_addr_attribute8,
p_addr_attribute9,
p_addr_attribute10,
p_addr_attribute11,
p_addr_attribute12,
p_addr_attribute13,
p_addr_attribute14,
p_addr_attribute15,
p_addr_attribute16,
p_addr_attribute17,
p_addr_attribute18,
p_addr_attribute19,
p_addr_attribute20,
p_add_information13,
p_add_information14,
p_add_information15,
p_add_information16,
p_add_information17,
p_add_information18,
p_add_information19,
p_add_information20,
p_object_version_number,
p_party_id -- HR/TCA merge
);