APPS.HR_PERSON_ABSENCE_BE2 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 4

procedure update_person_absence_a (
p_effective_date               date,
p_absence_attendance_id        number,
p_object_version_number        number,
p_abs_attendance_reason_id     number,
p_comments                     clob,
p_date_notification            date,
p_date_projected_start         date,
p_time_projected_start         varchar2,
p_date_projected_end           date,
p_time_projected_end           varchar2,
p_date_start                   date,
p_time_start                   varchar2,
p_date_end                     date,
p_time_end                     varchar2,
p_absence_days                 number,
p_absence_hours                number,
p_authorising_person_id        number,
p_replacement_person_id        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_period_of_incapacity_id      number,
p_ssp1_issued                  varchar2,
p_maternity_id                 number,
p_sickness_start_date          date,
p_sickness_end_date            date,
p_pregnancy_related_illness    varchar2,
p_reason_for_notification_dela varchar2,
p_accept_late_notification_fla varchar2,
p_linked_absence_id            number,
p_batch_id                     number,
p_abs_information_category     varchar2,
p_abs_information1             varchar2,
p_abs_information2             varchar2,
p_abs_information3             varchar2,
p_abs_information4             varchar2,
p_abs_information5             varchar2,
p_abs_information6             varchar2,
p_abs_information7             varchar2,
p_abs_information8             varchar2,
p_abs_information9             varchar2,
p_abs_information10            varchar2,
p_abs_information11            varchar2,
p_abs_information12            varchar2,
p_abs_information13            varchar2,
p_abs_information14            varchar2,
p_abs_information15            varchar2,
p_abs_information16            varchar2,
p_abs_information17            varchar2,
p_abs_information18            varchar2,
p_abs_information19            varchar2,
p_abs_information20            varchar2,
p_abs_information21            varchar2,
p_abs_information22            varchar2,
p_abs_information23            varchar2,
p_abs_information24            varchar2,
p_abs_information25            varchar2,
p_abs_information26            varchar2,
p_abs_information27            varchar2,
p_abs_information28            varchar2,
p_abs_information29            varchar2,
p_abs_information30            varchar2,
p_absence_case_id              number,
p_dur_dys_less_warning         boolean,
p_dur_hrs_less_warning         boolean,
p_exceeds_pto_entit_warning    boolean,
p_exceeds_run_total_warning    boolean,
p_abs_overlap_warning          boolean,
p_abs_day_after_warning        boolean,
p_dur_overwritten_warning      boolean,
p_del_element_entry_warning    boolean) is
  l_event_key number;

Line: 101

  select per_wf_events_s.nextval from dual;

Line: 103

  l_proc varchar2(72):='  hr_person_absence_be2.update_person_absence_a';

Line: 107

  l_event_name:='oracle.apps.per.api.person_absence.update_person_absence';

Line: 539

end update_person_absence_a;