The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure update_saved_search_a (
p_effective_date date,
p_search_criteria_id number,
p_person_id number,
p_search_name varchar2,
p_location varchar2,
p_distance_to_location varchar2,
p_geocode_location varchar2,
p_geocode_country varchar2,
p_derived_location varchar2,
p_location_id number,
p_longitude number,
p_latitude number,
p_employee varchar2,
p_contractor varchar2,
p_employment_category varchar2,
p_keywords varchar2,
p_travel_percentage number,
p_min_salary number,
p_salary_currency varchar2,
p_salary_period varchar2,
p_match_competence varchar2,
p_match_qualification varchar2,
p_work_at_home varchar2,
p_job_title varchar2,
p_department varchar2,
p_professional_area varchar2,
p_use_for_matching varchar2,
p_description 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_attribute21 varchar2,
p_attribute22 varchar2,
p_attribute23 varchar2,
p_attribute24 varchar2,
p_attribute25 varchar2,
p_attribute26 varchar2,
p_attribute27 varchar2,
p_attribute28 varchar2,
p_attribute29 varchar2,
p_attribute30 varchar2,
p_isc_information_category varchar2,
p_isc_information1 varchar2,
p_isc_information2 varchar2,
p_isc_information3 varchar2,
p_isc_information4 varchar2,
p_isc_information5 varchar2,
p_isc_information6 varchar2,
p_isc_information7 varchar2,
p_isc_information8 varchar2,
p_isc_information9 varchar2,
p_isc_information10 varchar2,
p_isc_information11 varchar2,
p_isc_information12 varchar2,
p_isc_information13 varchar2,
p_isc_information14 varchar2,
p_isc_information15 varchar2,
p_isc_information16 varchar2,
p_isc_information17 varchar2,
p_isc_information18 varchar2,
p_isc_information19 varchar2,
p_isc_information20 varchar2,
p_isc_information21 varchar2,
p_isc_information22 varchar2,
p_isc_information23 varchar2,
p_isc_information24 varchar2,
p_isc_information25 varchar2,
p_isc_information26 varchar2,
p_isc_information27 varchar2,
p_isc_information28 varchar2,
p_isc_information29 varchar2,
p_isc_information30 varchar2,
p_date_posted varchar2,
p_object_version_number number) is
l_event_key number;
select per_wf_events_s.nextval from dual;
l_proc varchar2(72):=' irc_search_criteria_be2.update_saved_search_a';
l_event_name:='oracle.apps.per.irc.api.search_criteria.update_saved_search';
end update_saved_search_a;