The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure update_document_type_a (
p_document_type_id number,
p_effective_date date,
p_document_type varchar2,
p_language_code varchar2,
p_description varchar2,
p_category_code varchar2,
p_active_inactive_flag varchar2,
p_multiple_occurences_flag varchar2,
p_authorization_required varchar2,
p_sub_category_code varchar2,
p_legislation_code varchar2,
p_warning_period number,
p_request_id number,
p_program_application_id number,
p_program_id number,
p_program_update_date date,
p_object_version_number number) is
l_event_key number;
select per_wf_events_s.nextval from dual;
l_proc varchar2(72):=' hr_document_types_be2.update_document_type_a';
l_event_name:='oracle.apps.per.api.document_types.update_document_type';
l_text:='';
l_text:=l_text||fnd_date.date_to_canonical(p_program_update_date);
l_text:=l_text||'';
end update_document_type_a;