The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure update_competence_element_a (
p_competence_element_id number,
p_object_version_number number,
p_proficiency_level_id number,
p_high_proficiency_level_id number,
p_weighting_level_id number,
p_rating_level_id number,
p_mandatory varchar2,
p_effective_date_from date,
p_effective_date_to date,
p_group_competence_type varchar2,
p_competence_type varchar2,
p_normal_elapse_duration number,
p_normal_elapse_duration_unit varchar2,
p_sequence_number number,
p_source_of_proficiency_level varchar2,
p_line_score number,
p_certification_date date,
p_certification_method varchar2,
p_next_certification_date date,
p_comments varchar2,
p_attribute_category varchar2,
p_attribute1 varchar2,
p_attribute2 varchar2,
p_attribute3 varchar2,
p_attribute4 varchar2,
p_attribute5 varchar2,
p_attribute6 varchar2,
p_attribute7 varchar2,
p_attribute8 varchar2,
p_attribute9 varchar2,
p_attribute10 varchar2,
p_attribute11 varchar2,
p_attribute12 varchar2,
p_attribute13 varchar2,
p_attribute14 varchar2,
p_attribute15 varchar2,
p_attribute16 varchar2,
p_attribute17 varchar2,
p_attribute18 varchar2,
p_attribute19 varchar2,
p_attribute20 varchar2,
p_effective_date date,
p_qualification_type_id number,
p_unit_standard_type varchar2,
p_status varchar2,
p_information_category varchar2,
p_information1 varchar2,
p_information2 varchar2,
p_information3 varchar2,
p_information4 varchar2,
p_information5 varchar2,
p_information6 varchar2,
p_information7 varchar2,
p_information8 varchar2,
p_information9 varchar2,
p_information10 varchar2,
p_information11 varchar2,
p_information12 varchar2,
p_information13 varchar2,
p_information14 varchar2,
p_information15 varchar2,
p_information16 varchar2,
p_information17 varchar2,
p_information18 varchar2,
p_information19 varchar2,
p_information20 varchar2,
p_achieved_date date,
p_appr_line_score number) is
l_event_key number;
select per_wf_events_s.nextval from dual;
l_proc varchar2(72):=' hr_competence_element_be2.update_competence_element_a';
l_event_name:='oracle.apps.per.api.competence_element.update_competence_element';
end update_competence_element_a;