The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT TIMEZONE
FROM ota_events
WHERE event_id = p_event_id
AND event_type IN ('SCHEDULED', 'SELFPACED');
SELECT cht.chat_id, cht.NAME, cht.description,chb.business_group_id,chb.object_version_number
FROM ota_chats_tl cht, ota_chat_obj_inclusions coi, ota_chats_b chb
WHERE coi.chat_id = cht.chat_id
AND coi.object_id = p_event_id
and cht.language = userenv('LANG')
AND chb.chat_id = coi.chat_id;
SELECT event_id,business_group_id,object_version_number
FROM ota_events
WHERE parent_event_id = p_event_id;
ota_chat_api.update_chat
(p_effective_date => p_effective_date,
p_name => csr_chats_row.name,
p_description => csr_chats_row.description,
p_business_group_id => csr_chats_row.business_group_id,
p_timezone_code => p_timezone,
p_chat_id => csr_chats_row.chat_id,
p_object_version_number => csr_chats_row.object_version_number
);
ota_event_api.update_class
(p_event_id => csr_sess_row.event_id,
p_effective_date => p_effective_date,
p_business_group_id => csr_sess_row.business_group_id,
p_object_version_number => csr_sess_row.object_version_number,
p_timezone => p_timezone
);
procedure update_class
(p_event_id in number,
p_effective_date in date,
p_vendor_id in number default hr_api.g_number,
p_activity_version_id in number default hr_api.g_number,
p_business_group_id in number default hr_api.g_number,
p_organization_id in number default hr_api.g_number,
p_event_type in varchar2 default hr_api.g_varchar2,
p_object_version_number in out nocopy number,
p_title in varchar2 default hr_api.g_varchar2,
p_budget_cost in number default hr_api.g_number,
p_actual_cost in number default hr_api.g_number,
p_budget_currency_code in varchar2 default hr_api.g_varchar2,
p_centre in varchar2 default hr_api.g_varchar2,
p_comments in varchar2 default hr_api.g_varchar2,
p_course_end_date in date default hr_api.g_date,
p_course_end_time in varchar2 default hr_api.g_varchar2,
p_course_start_date in date default hr_api.g_date,
p_course_start_time in varchar2 default hr_api.g_varchar2,
p_duration in number default hr_api.g_number,
p_duration_units in varchar2 default hr_api.g_varchar2,
p_enrolment_end_date in date default hr_api.g_date,
p_enrolment_start_date in date default hr_api.g_date,
p_language_id in number default hr_api.g_number,
p_user_status in varchar2 default hr_api.g_varchar2,
p_development_event_type in varchar2 default hr_api.g_varchar2,
p_event_status in varchar2 default hr_api.g_varchar2,
p_price_basis in varchar2 default hr_api.g_varchar2,
p_currency_code in varchar2 default hr_api.g_varchar2,
p_maximum_attendees in number default hr_api.g_number,
p_maximum_internal_attendees in number default hr_api.g_number,
p_minimum_attendees in number default hr_api.g_number,
p_standard_price in number default hr_api.g_number,
p_category_code in varchar2 default hr_api.g_varchar2,
p_parent_event_id in number default hr_api.g_number,
p_book_independent_flag in varchar2 default hr_api.g_varchar2,
p_public_event_flag in varchar2 default hr_api.g_varchar2,
p_secure_event_flag in varchar2 default hr_api.g_varchar2,
p_evt_information_category in varchar2 default hr_api.g_varchar2,
p_evt_information1 in varchar2 default hr_api.g_varchar2,
p_evt_information2 in varchar2 default hr_api.g_varchar2,
p_evt_information3 in varchar2 default hr_api.g_varchar2,
p_evt_information4 in varchar2 default hr_api.g_varchar2,
p_evt_information5 in varchar2 default hr_api.g_varchar2,
p_evt_information6 in varchar2 default hr_api.g_varchar2,
p_evt_information7 in varchar2 default hr_api.g_varchar2,
p_evt_information8 in varchar2 default hr_api.g_varchar2,
p_evt_information9 in varchar2 default hr_api.g_varchar2,
p_evt_information10 in varchar2 default hr_api.g_varchar2,
p_evt_information11 in varchar2 default hr_api.g_varchar2,
p_evt_information12 in varchar2 default hr_api.g_varchar2,
p_evt_information13 in varchar2 default hr_api.g_varchar2,
p_evt_information14 in varchar2 default hr_api.g_varchar2,
p_evt_information15 in varchar2 default hr_api.g_varchar2,
p_evt_information16 in varchar2 default hr_api.g_varchar2,
p_evt_information17 in varchar2 default hr_api.g_varchar2,
p_evt_information18 in varchar2 default hr_api.g_varchar2,
p_evt_information19 in varchar2 default hr_api.g_varchar2,
p_evt_information20 in varchar2 default hr_api.g_varchar2,
p_project_id in number default hr_api.g_number,
p_owner_id in number default hr_api.g_number,
p_line_id in number default hr_api.g_number,
p_org_id in number default hr_api.g_number,
p_training_center_id in number default hr_api.g_number,
p_location_id in number default hr_api.g_number,
p_offering_id in number default hr_api.g_number,
p_timezone in varchar2 default hr_api.g_varchar2,
-- Bug#2200078 Corrected default value for offering_id and timezone
-- p_offering_id in number default null,
-- p_timezone in varchar2 default null,
p_parent_offering_id in number default hr_api.g_number,
p_data_source in varchar2 default hr_api.g_varchar2,
p_validate in boolean default false
) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||' Update Class';
savepoint UPDATE_CLASS;
ota_event_bk2.update_class_b
(p_effective_date => l_effective_date,
p_event_id => p_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 => p_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_data_source => p_data_source);
(p_module_name => 'UPDATE_CLASS'
,p_hook_type => 'BP'
);
ota_event_bk2.update_class_a
(p_effective_date => l_effective_date,
p_event_id => p_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 => p_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_data_source => p_data_source);
(p_module_name => 'UPDATE_CLASS'
,p_hook_type => 'AP'
);
rollback to UPDATE_CLASS;
rollback to UPDATE_CLASS;
end update_class;
procedure delete_class
(p_validate in boolean default false
,p_event_id in number
,p_object_version_number in number
) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||' Delete Class';
savepoint DELETE_CLASS;
ota_event_bk3.delete_class_b
(p_event_id => p_event_id,
p_object_version_number => p_object_version_number
);
(p_module_name => 'DELETE_CLASS'
,p_hook_type => 'BP'
);
ota_event_bk3.delete_class_a
(p_event_id => p_event_id,
p_object_version_number => p_object_version_number
);
(p_module_name => 'DELETE_CLASS'
,p_hook_type => 'AP'
);
rollback to DELETE_CLASS;
rollback to DELETE_CLASS;
end delete_class;
select dflt_class_eval_id,eval_mandatory_flag
into l_eval_id,l_mand_flag
from ota_evaluations
where object_id = p_activity_version_id
and object_type = 'A';
insert into ota_evaluations (evaluation_id,
eval_mandatory_flag,
object_id,
object_type,
object_version_number) values
(l_eval_id,
l_mand_flag,
p_event_id,
'E',
1);