The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure insert_dml(p_rec in out nocopy ota_evt_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'insert_dml';
insert into ota_events
( event_id,
vendor_id,
activity_version_id,
business_group_id,
organization_id,
event_type,
object_version_number,
title,
budget_cost,
actual_cost,
budget_currency_code,
centre,
comments,
course_end_date,
course_end_time,
course_start_date,
course_start_time,
duration,
duration_units,
enrolment_end_date,
enrolment_start_date,
language_id,
user_status,
development_event_type,
event_status,
price_basis,
currency_code,
maximum_attendees,
maximum_internal_attendees,
minimum_attendees,
standard_price,
category_code,
parent_event_id,
book_independent_flag,
public_event_flag,
secure_event_flag,
evt_information_category,
evt_information1,
evt_information2,
evt_information3,
evt_information4,
evt_information5,
evt_information6,
evt_information7,
evt_information8,
evt_information9,
evt_information10,
evt_information11,
evt_information12,
evt_information13,
evt_information14,
evt_information15,
evt_information16,
evt_information17,
evt_information18,
evt_information19,
evt_information20,
project_id,
owner_id,
line_id,
org_id,
training_center_id,
location_id,
offering_id,
timezone,
parent_offering_id,
data_source,
event_availability
)
Values
( p_rec.event_id,
p_rec.vendor_id,
p_rec.activity_version_id,
p_rec.business_group_id,
p_rec.organization_id,
p_rec.event_type,
p_rec.object_version_number,
p_rec.title,
p_rec.budget_cost,
p_rec.actual_cost,
p_rec.budget_currency_code,
p_rec.centre,
p_rec.comments,
p_rec.course_end_date,
p_rec.course_end_time,
p_rec.course_start_date,
p_rec.course_start_time,
p_rec.duration,
p_rec.duration_units,
p_rec.enrolment_end_date,
p_rec.enrolment_start_date,
p_rec.language_id,
p_rec.user_status,
p_rec.development_event_type,
p_rec.event_status,
p_rec.price_basis,
p_rec.currency_code,
p_rec.maximum_attendees,
p_rec.maximum_internal_attendees,
p_rec.minimum_attendees,
p_rec.standard_price,
p_rec.category_code,
p_rec.parent_event_id,
p_rec.book_independent_flag,
p_rec.public_event_flag,
p_rec.secure_event_flag,
p_rec.evt_information_category,
p_rec.evt_information1,
p_rec.evt_information2,
p_rec.evt_information3,
p_rec.evt_information4,
p_rec.evt_information5,
p_rec.evt_information6,
p_rec.evt_information7,
p_rec.evt_information8,
p_rec.evt_information9,
p_rec.evt_information10,
p_rec.evt_information11,
p_rec.evt_information12,
p_rec.evt_information13,
p_rec.evt_information14,
p_rec.evt_information15,
p_rec.evt_information16,
p_rec.evt_information17,
p_rec.evt_information18,
p_rec.evt_information19,
p_rec.evt_information20,
p_rec.project_id,
p_rec.owner_id,
p_rec.line_id,
p_rec.org_id,
p_rec.training_center_id,
p_rec.location_id,
p_rec.offering_id,
p_rec.timezone,
p_rec.parent_offering_id,
p_rec.data_source,
p_rec.event_availability
);
End insert_dml;
Procedure pre_insert
(p_rec in out nocopy ota_evt_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'pre_insert';
Cursor C_Sel1 is select ota_events_s.nextval from sys.dual;
Select null
from ota_events
where event_id =
ota_evt_ins.g_event_id_i;
End pre_insert;
Procedure post_insert(p_rec in ota_evt_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'post_insert';
/* commented out to fix bug 3385192. The call is moved to ota_tdb_ins.post_insert */
/* IF p_rec.line_id is not null then
l_return := ota_utility.check_wf_status(p_rec.line_id,'BLOCK');
End post_insert;
ota_evt_bus.insert_validate(p_rec);
pre_insert(p_rec);
insert_dml(p_rec);
post_insert(p_rec);