The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure update_personal_pay_method_a (
p_effective_date date,
p_datetrack_update_mode varchar2,
p_personal_payment_method_id number,
p_object_version_number number,
p_amount number,
p_comments varchar2,
p_percentage number,
p_priority number,
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_territory_code varchar2,
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_payee_type varchar2,
p_payee_id number,
p_comment_id number,
p_external_account_id number,
p_effective_start_date date,
p_effective_end_date date,
p_ppm_information1 varchar2,
p_ppm_information2 varchar2,
p_ppm_information3 varchar2,
p_ppm_information4 varchar2,
p_ppm_information5 varchar2,
p_ppm_information6 varchar2,
p_ppm_information7 varchar2,
p_ppm_information8 varchar2,
p_ppm_information9 varchar2,
p_ppm_information10 varchar2,
p_ppm_information11 varchar2,
p_ppm_information12 varchar2,
p_ppm_information13 varchar2,
p_ppm_information14 varchar2,
p_ppm_information15 varchar2,
p_ppm_information16 varchar2,
p_ppm_information17 varchar2,
p_ppm_information18 varchar2,
p_ppm_information19 varchar2,
p_ppm_information20 varchar2,
p_ppm_information21 varchar2,
p_ppm_information22 varchar2,
p_ppm_information23 varchar2,
p_ppm_information24 varchar2,
p_ppm_information25 varchar2,
p_ppm_information26 varchar2,
p_ppm_information27 varchar2,
p_ppm_information28 varchar2,
p_ppm_information29 varchar2,
p_ppm_information30 varchar2,
p_ppm_information_category varchar2) is
l_event_key number;
select per_wf_events_s.nextval from dual;
l_proc varchar2(72):=' hr_personal_pay_method_be2.update_personal_pay_method_a';
l_event_name:='oracle.apps.per.api.personal_pay_method.update_personal_pay_method';
l_text:='';
l_text:=l_text||irc_utilities_pkg.removeTags(p_datetrack_update_mode);
l_text:=l_text||'';
end update_personal_pay_method_a;