The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
activity_version_id,
activity_id,
superseded_by_act_version_id,
developer_organization_id,
controlling_person_id,
object_version_number,
version_name,
comments,
description,
duration,
duration_units,
end_date,
intended_audience,
language_id,
maximum_attendees,
minimum_attendees,
objectives,
start_date,
success_criteria,
user_status,
vendor_id,
actual_cost,
budget_cost,
budget_currency_code,
expenses_allowed,
professional_credit_type,
professional_credits,
maximum_internal_attendees,
tav_information_category,
tav_information1,
tav_information2,
tav_information3,
tav_information4,
tav_information5,
tav_information6,
tav_information7,
tav_information8,
tav_information9,
tav_information10,
tav_information11,
tav_information12,
tav_information13,
tav_information14,
tav_information15,
tav_information16,
tav_information17,
tav_information18,
tav_information19,
tav_information20,
inventory_item_id,
organization_id,
rco_id,
version_code,
business_group_id,
data_source
,competency_update_level,
eres_enabled
from ota_activity_versions
where activity_version_id = p_activity_version_id;
select activity_version_id,
activity_id,
superseded_by_act_version_id,
developer_organization_id,
controlling_person_id,
object_version_number,
version_name,
comments,
description,
duration,
duration_units,
end_date,
intended_audience,
language_id,
maximum_attendees,
minimum_attendees,
objectives,
start_date,
success_criteria,
user_status,
vendor_id,
actual_cost,
budget_cost,
budget_currency_code,
expenses_allowed,
professional_credit_type,
professional_credits,
maximum_internal_attendees,
tav_information_category,
tav_information1,
tav_information2,
tav_information3,
tav_information4,
tav_information5,
tav_information6,
tav_information7,
tav_information8,
tav_information9,
tav_information10,
tav_information11,
tav_information12,
tav_information13,
tav_information14,
tav_information15,
tav_information16,
tav_information17,
tav_information18,
tav_information19,
tav_information20,
inventory_item_id,
organization_id,
rco_id,
version_code,
business_group_id,
data_source
,competency_update_level,
eres_enabled
from ota_activity_versions
where activity_version_id = p_activity_version_id
for update nowait;
,p_competency_update_level in varchar2,
p_eres_enabled in varchar2
)
Return g_rec_type is
--
l_rec g_rec_type;
l_rec.competency_update_level := p_competency_update_level ;