The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure update_assignment_details_a (
p_effective_date date,
p_datetrack_update_mode varchar2,
p_assignment_details_id number,
p_assignment_id number,
p_attempt_id number,
p_details_version number,
p_latest_details varchar2,
p_effective_start_date date,
p_effective_end_date date,
p_object_version_number number,
p_qualified varchar2,
p_considered varchar2) is
l_event_key number;
select per_wf_events_s.nextval from dual;
l_proc varchar2(72):=' irc_assignment_details_be2.update_assignment_details_a';
l_event_name:='oracle.apps.per.irc.api.assignment_details.update_assignment_details';
l_text:='';
l_text:=l_text||irc_utilities_pkg.removeTags(p_datetrack_update_mode);
l_text:=l_text||'';
end update_assignment_details_a;