[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select lower(bic.interface_col_name) interface_col_name
from bne_interface_cols_b bic
where bic.interface_code = c_interface_code
and bic.display_flag ='Y';
select lower(bic.interface_col_name) interface_col_name
from bne_interface_cols_b bic
where bic.interface_code = c_interface_code
and bic.display_flag ='N';
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 => l_class_rec.vendor_id
,p_activity_version_id => l_class_rec.activity_version_id
,p_business_group_id => l_class_rec.business_group_id
,p_organization_id => l_class_rec.organization_id
,p_event_type => l_class_rec.event_type
,p_object_version_number => l_object_version_number
,p_title => l_class_rec.title
,p_budget_cost => l_class_rec.budget_cost
,p_actual_cost => l_class_rec.actual_cost
,p_budget_currency_code => l_class_rec.budget_currency_code
,p_centre => l_class_rec.centre
,p_comments => l_class_rec.comments
,p_course_end_date => l_class_rec.course_end_date
,p_course_end_time => g_course_end_time
,p_course_start_date => l_class_rec.course_start_date
,p_course_start_time => g_course_start_time
,p_duration => l_class_rec.duration
,p_duration_units => l_class_rec.duration_units
,p_enrolment_end_date => l_class_rec.enrolment_end_date
,p_enrolment_start_date => l_class_rec.enrolment_start_date
,p_language_id => l_class_rec.language_id
,p_user_status => l_class_rec.user_status
,p_development_event_type => l_class_rec.development_event_type
,p_event_status => l_class_rec.event_status
,p_price_basis => l_class_rec.price_basis
,p_currency_code => l_class_rec.currency_code
,p_maximum_attendees => l_class_rec.maximum_attendees
,p_maximum_internal_attendees => l_class_rec.maximum_internal_attendees
,p_minimum_attendees => l_class_rec.minimum_attendees
,p_standard_price => l_class_rec.standard_price
,p_category_code => l_class_rec.category_code
,p_parent_event_id => l_class_rec.parent_event_id
,p_book_independent_flag => l_class_rec.book_independent_flag
,p_public_event_flag => l_class_rec.public_event_flag
,p_secure_event_flag => l_class_rec.secure_event_flag
,p_evt_information_category => l_class_rec.evt_information_category
,p_evt_information1 => l_class_rec.evt_information1
,p_evt_information2 => l_class_rec.evt_information2
,p_evt_information3 => l_class_rec.evt_information3
,p_evt_information4 => l_class_rec.evt_information4
,p_evt_information5 => l_class_rec.evt_information5
,p_evt_information6 => l_class_rec.evt_information6
,p_evt_information7 => l_class_rec.evt_information7
,p_evt_information8 => l_class_rec.evt_information8
,p_evt_information9 => l_class_rec.evt_information9
,p_evt_information10 => l_class_rec.evt_information10
,p_evt_information11 => l_class_rec.evt_information11
,p_evt_information12 => l_class_rec.evt_information12
,p_evt_information13 => l_class_rec.evt_information13
,p_evt_information14 => l_class_rec.evt_information14
,p_evt_information15 => l_class_rec.evt_information15
,p_evt_information16 => l_class_rec.evt_information16
,p_evt_information17 => l_class_rec.evt_information17
,p_evt_information18 => l_class_rec.evt_information18
,p_evt_information19 => l_class_rec.evt_information19
,p_evt_information20 => l_class_rec.evt_information20
,p_project_id => l_class_rec.project_id
,p_owner_id => l_class_rec.owner_id
,p_line_id => l_class_rec.line_id
,p_org_id => l_class_rec.org_id
,p_training_center_id => l_class_rec.training_center_id
,p_location_id => l_class_rec.location_id
,p_offering_id => l_class_rec.offering_id
,p_timezone => l_class_rec.timezone
,p_parent_offering_id => l_class_rec.parent_offering_id
,p_validate => l_validate
,p_data_source => l_class_rec.data_source
);