The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure update_dml(p_rec in out nocopy ota_evt_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'update_dml';
update ota_events
set
event_id = p_rec.event_id,
vendor_id = p_rec.vendor_id,
activity_version_id = p_rec.activity_version_id,
business_group_id = p_rec.business_group_id,
organization_id = p_rec.organization_id,
event_type = p_rec.event_type,
object_version_number = p_rec.object_version_number,
title = p_rec.title,
budget_cost = p_rec.budget_cost,
actual_cost = p_rec.actual_cost,
budget_currency_code = p_rec.budget_currency_code,
centre = p_rec.centre,
comments = p_rec.comments,
course_end_date = p_rec.course_end_date,
course_end_time = p_rec.course_end_time,
course_start_date = p_rec.course_start_date,
course_start_time = p_rec.course_start_time,
duration = p_rec.duration,
duration_units = p_rec.duration_units,
enrolment_end_date = p_rec.enrolment_end_date,
enrolment_start_date = p_rec.enrolment_start_date,
language_id = p_rec.language_id,
user_status = p_rec.user_status,
development_event_type = p_rec.development_event_type,
event_status = p_rec.event_status,
price_basis = p_rec.price_basis,
currency_code = p_rec.currency_code,
maximum_attendees = p_rec.maximum_attendees,
maximum_internal_attendees = p_rec.maximum_internal_attendees,
minimum_attendees = p_rec.minimum_attendees,
standard_price = p_rec.standard_price,
category_code = p_rec.category_code,
parent_event_id = p_rec.parent_event_id,
book_independent_flag = p_rec.book_independent_flag,
public_event_flag = p_rec.public_event_flag,
secure_event_flag = p_rec.secure_event_flag,
evt_information_category = p_rec.evt_information_category,
evt_information1 = p_rec.evt_information1,
evt_information2 = p_rec.evt_information2,
evt_information3 = p_rec.evt_information3,
evt_information4 = p_rec.evt_information4,
evt_information5 = p_rec.evt_information5,
evt_information6 = p_rec.evt_information6,
evt_information7 = p_rec.evt_information7,
evt_information8 = p_rec.evt_information8,
evt_information9 = p_rec.evt_information9,
evt_information10 = p_rec.evt_information10,
evt_information11 = p_rec.evt_information11,
evt_information12 = p_rec.evt_information12,
evt_information13 = p_rec.evt_information13,
evt_information14 = p_rec.evt_information14,
evt_information15 = p_rec.evt_information15,
evt_information16 = p_rec.evt_information16,
evt_information17 = p_rec.evt_information17,
evt_information18 = p_rec.evt_information18,
evt_information19 = p_rec.evt_information19,
evt_information20 = p_rec.evt_information20,
project_id = p_rec.project_id,
owner_id = p_rec.owner_id,
line_id = p_rec.line_id,
org_id = p_rec.org_id,
training_center_id = p_rec.training_center_id,
location_id = p_rec.location_id,
offering_id = p_rec.offering_id,
timezone = p_rec.timezone,
parent_offering_id = p_rec.parent_offering_id,
data_source = p_rec.data_source
where event_id = p_rec.event_id;
End update_dml;
Procedure pre_update(p_rec in ota_evt_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'pre_update';
End pre_update;
Procedure post_update(p_rec in ota_evt_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'post_update';
End post_update;
ota_evt_bus.update_validate(temp_var);
pre_update(p_rec);
update_dml(p_rec);
post_update(p_rec);
p_event_fired => 'oracle.apps.ota.api.event_api.update_class_schedule');
p_event_fired => 'oracle.apps.ota.api.event_api.update_trng_cntr_and_location');
p_event_fired => 'oracle.apps.ota.api.event_api.update_location');
p_event_fired => 'oracle.apps.ota.api.event_api.update_training_center');