The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure update_cwk_asg_criteria_a (
p_effective_date date,
p_datetrack_update_mode varchar2,
p_assignment_id number,
p_object_version_number number,
p_grade_id number,
p_position_id number,
p_job_id number,
p_location_id number,
p_organization_id number,
p_pay_basis_id number,
p_segment1 varchar2,
p_segment2 varchar2,
p_segment3 varchar2,
p_segment4 varchar2,
p_segment5 varchar2,
p_segment6 varchar2,
p_segment7 varchar2,
p_segment8 varchar2,
p_segment9 varchar2,
p_segment10 varchar2,
p_segment11 varchar2,
p_segment12 varchar2,
p_segment13 varchar2,
p_segment14 varchar2,
p_segment15 varchar2,
p_segment16 varchar2,
p_segment17 varchar2,
p_segment18 varchar2,
p_segment19 varchar2,
p_segment20 varchar2,
p_segment21 varchar2,
p_segment22 varchar2,
p_segment23 varchar2,
p_segment24 varchar2,
p_segment25 varchar2,
p_segment26 varchar2,
p_segment27 varchar2,
p_segment28 varchar2,
p_segment29 varchar2,
p_segment30 varchar2,
p_people_group_name varchar2,
p_effective_start_date date,
p_effective_end_date date,
p_people_group_id number,
p_org_now_no_manager_warning boolean,
p_other_manager_warning boolean,
p_spp_delete_warning boolean,
p_entries_changed_warning varchar2,
p_tax_district_changed_warning boolean,
p_concat_segments varchar2) is
l_event_key number;
select per_wf_events_s.nextval from dual;
l_proc varchar2(72):=' hr_assignment_beO.update_cwk_asg_criteria_a';
l_event_name:='oracle.apps.per.api.assignment.update_cwk_asg_criteria';
l_text:='';
l_text:=l_text||irc_utilities_pkg.removeTags(p_datetrack_update_mode);
l_text:=l_text||'';
l_text:='';
if(P_SPP_DELETE_WARNING) then
l_text:=l_text||'TRUE';
l_text:=l_text||'';
end update_cwk_asg_criteria_a;