The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure update_apl_asg_a (
p_effective_date date,
p_datetrack_update_mode varchar2,
p_assignment_id number,
p_object_version_number number,
p_grade_id number,
p_job_id number,
p_payroll_id number,
p_location_id number,
p_organization_id number,
p_position_id number,
p_application_id number,
p_special_ceiling_step_id number,
p_recruiter_id number,
p_recruitment_activity_id number,
p_soft_coding_keyflex_id number,
p_vacancy_id number,
p_pay_basis_id number,
p_person_referred_by_id number,
p_supervisor_id number,
p_source_organization_id number,
p_change_reason varchar2,
p_assignment_status_type_id number,
p_internal_address_line varchar2,
p_default_code_comb_id number,
p_employment_category varchar2,
p_frequency varchar2,
p_manager_flag varchar2,
p_normal_hours number,
p_perf_review_period number,
p_perf_review_period_frequency varchar2,
p_probation_period number,
p_probation_unit varchar2,
p_sal_review_period number,
p_sal_review_period_frequency varchar2,
p_set_of_books_id number,
p_source_type varchar2,
p_time_normal_finish varchar2,
p_time_normal_start varchar2,
p_bargaining_unit_code varchar2,
p_comments varchar2,
p_date_probation_end date,
p_title varchar2,
p_ass_attribute_category varchar2,
p_ass_attribute1 varchar2,
p_ass_attribute2 varchar2,
p_ass_attribute3 varchar2,
p_ass_attribute4 varchar2,
p_ass_attribute5 varchar2,
p_ass_attribute6 varchar2,
p_ass_attribute7 varchar2,
p_ass_attribute8 varchar2,
p_ass_attribute9 varchar2,
p_ass_attribute10 varchar2,
p_ass_attribute11 varchar2,
p_ass_attribute12 varchar2,
p_ass_attribute13 varchar2,
p_ass_attribute14 varchar2,
p_ass_attribute15 varchar2,
p_ass_attribute16 varchar2,
p_ass_attribute17 varchar2,
p_ass_attribute18 varchar2,
p_ass_attribute19 varchar2,
p_ass_attribute20 varchar2,
p_ass_attribute21 varchar2,
p_ass_attribute22 varchar2,
p_ass_attribute23 varchar2,
p_ass_attribute24 varchar2,
p_ass_attribute25 varchar2,
p_ass_attribute26 varchar2,
p_ass_attribute27 varchar2,
p_ass_attribute28 varchar2,
p_ass_attribute29 varchar2,
p_ass_attribute30 varchar2,
p_scl_segment1 varchar2,
p_scl_segment2 varchar2,
p_scl_segment3 varchar2,
p_scl_segment4 varchar2,
p_scl_segment5 varchar2,
p_scl_segment6 varchar2,
p_scl_segment7 varchar2,
p_scl_segment8 varchar2,
p_scl_segment9 varchar2,
p_scl_segment10 varchar2,
p_scl_segment11 varchar2,
p_scl_segment12 varchar2,
p_scl_segment13 varchar2,
p_scl_segment14 varchar2,
p_scl_segment15 varchar2,
p_scl_segment16 varchar2,
p_scl_segment17 varchar2,
p_scl_segment18 varchar2,
p_scl_segment19 varchar2,
p_scl_segment20 varchar2,
p_scl_segment21 varchar2,
p_scl_segment22 varchar2,
p_scl_segment23 varchar2,
p_scl_segment24 varchar2,
p_scl_segment25 varchar2,
p_scl_segment26 varchar2,
p_scl_segment27 varchar2,
p_scl_segment28 varchar2,
p_scl_segment29 varchar2,
p_scl_segment30 varchar2,
p_concatenated_segments varchar2,
p_pgp_segment1 varchar2,
p_pgp_segment2 varchar2,
p_pgp_segment3 varchar2,
p_pgp_segment4 varchar2,
p_pgp_segment5 varchar2,
p_pgp_segment6 varchar2,
p_pgp_segment7 varchar2,
p_pgp_segment8 varchar2,
p_pgp_segment9 varchar2,
p_pgp_segment10 varchar2,
p_pgp_segment11 varchar2,
p_pgp_segment12 varchar2,
p_pgp_segment13 varchar2,
p_pgp_segment14 varchar2,
p_pgp_segment15 varchar2,
p_pgp_segment16 varchar2,
p_pgp_segment17 varchar2,
p_pgp_segment18 varchar2,
p_pgp_segment19 varchar2,
p_pgp_segment20 varchar2,
p_pgp_segment21 varchar2,
p_pgp_segment22 varchar2,
p_pgp_segment23 varchar2,
p_pgp_segment24 varchar2,
p_pgp_segment25 varchar2,
p_pgp_segment26 varchar2,
p_pgp_segment27 varchar2,
p_pgp_segment28 varchar2,
p_pgp_segment29 varchar2,
p_pgp_segment30 varchar2,
p_group_name varchar2,
p_comment_id number,
p_people_group_id number,
p_effective_start_date date,
p_effective_end_date date,
p_scl_concat_segments varchar2,
p_concat_segments varchar2,
p_contract_id number,
p_establishment_id number,
p_collective_agreement_id number,
p_cagr_id_flex_num number,
p_cag_segment1 varchar2,
p_cag_segment2 varchar2,
p_cag_segment3 varchar2,
p_cag_segment4 varchar2,
p_cag_segment5 varchar2,
p_cag_segment6 varchar2,
p_cag_segment7 varchar2,
p_cag_segment8 varchar2,
p_cag_segment9 varchar2,
p_cag_segment10 varchar2,
p_cag_segment11 varchar2,
p_cag_segment12 varchar2,
p_cag_segment13 varchar2,
p_cag_segment14 varchar2,
p_cag_segment15 varchar2,
p_cag_segment16 varchar2,
p_cag_segment17 varchar2,
p_cag_segment18 varchar2,
p_cag_segment19 varchar2,
p_cag_segment20 varchar2,
p_notice_period number,
p_notice_period_uom varchar2,
p_employee_category varchar2,
p_work_at_home varchar2,
p_job_post_source_name varchar2,
p_cagr_grade_def_id number,
p_cagr_concatenated_segments varchar2,
p_applicant_rank number,
p_posting_content_id number,
p_grade_ladder_pgm_id number,
p_supervisor_assignment_id number) is
l_event_key number;
select per_wf_events_s.nextval from dual;
l_proc varchar2(72):=' hr_assignment_be5.update_apl_asg_a';
l_event_name:='oracle.apps.per.api.assignment.update_apl_asg';
l_text:='';
l_text:=l_text||irc_utilities_pkg.removeTags(p_datetrack_update_mode);
l_text:=l_text||'';
end update_apl_asg_a;