The following lines contain the word 'select', 'insert', 'update' or 'delete':
e_crt_not_allowed exception; -- when mode is 'Update Only'
raise e_crt_not_allowed; -- Update only flag is enabled but Trying to Create
select object_version_number into l_object_version_number from ota_events
where event_id = l_event_id;
ota_event_api.update_class
(p_effective_date => p_effective_date
,p_event_id => l_event_id
,p_vendor_id => p_vendor_id
,p_activity_version_id => p_activity_version_id
,p_business_group_id => p_business_group_id
,p_organization_id => p_organization_id
,p_event_type => p_event_type
,p_object_version_number => l_object_version_number
,p_title => p_title
,p_budget_cost => p_budget_cost
,p_actual_cost => p_actual_cost
,p_budget_currency_code => p_budget_currency_code
,p_centre => p_centre
,p_comments => p_comments
,p_course_end_date => p_course_end_date
,p_course_end_time => p_course_end_time
,p_course_start_date => p_course_start_date
,p_course_start_time => p_course_start_time
,p_duration => p_duration
,p_duration_units => p_duration_units
,p_enrolment_end_date => p_enrolment_end_date
,p_enrolment_start_date => p_enrolment_start_date
,p_language_id => p_language_id
,p_user_status => p_user_status
,p_development_event_type => p_development_event_type
,p_event_status => p_event_status
,p_price_basis => p_price_basis
,p_currency_code => p_currency_code
,p_maximum_attendees => p_maximum_attendees
,p_maximum_internal_attendees => p_maximum_internal_attendees
,p_minimum_attendees => p_minimum_attendees
,p_standard_price => p_standard_price
,p_category_code => p_category_code
,p_parent_event_id => p_parent_event_id
,p_book_independent_flag => p_book_independent_flag
,p_public_event_flag => l_public_event_flag
,p_secure_event_flag => p_secure_event_flag
,p_evt_information_category => p_evt_information_category
,p_evt_information1 => p_evt_information1
,p_evt_information2 => p_evt_information2
,p_evt_information3 => p_evt_information3
,p_evt_information4 => p_evt_information4
,p_evt_information5 => p_evt_information5
,p_evt_information6 => p_evt_information6
,p_evt_information7 => p_evt_information7
,p_evt_information8 => p_evt_information8
,p_evt_information9 => p_evt_information9
,p_evt_information10 => p_evt_information10
,p_evt_information11 => p_evt_information11
,p_evt_information12 => p_evt_information12
,p_evt_information13 => p_evt_information13
,p_evt_information14 => p_evt_information14
,p_evt_information15 => p_evt_information15
,p_evt_information16 => p_evt_information16
,p_evt_information17 => p_evt_information17
,p_evt_information18 => p_evt_information18
,p_evt_information19 => p_evt_information19
,p_evt_information20 => p_evt_information20
,p_project_id => p_project_id
,p_owner_id => p_owner_id
,p_line_id => p_line_id
,p_org_id => p_org_id
,p_training_center_id => p_training_center_id
,p_location_id => p_location_id
,p_offering_id => p_offering_id
,p_timezone => p_timezone
,p_parent_offering_id => p_parent_offering_id
,p_validate => l_validate
,p_data_source => p_data_source
);