APPS.HR_APPLICATION_BE1 SQL Statements

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

Line: 4

procedure update_apl_details_a (
p_application_id               number,
p_object_version_number        number,
p_effective_date               date,
p_comments                     varchar2,
p_current_employer             varchar2,
p_projected_hire_date          date,
p_termination_reason           varchar2,
p_appl_attribute_category      varchar2,
p_appl_attribute1              varchar2,
p_appl_attribute2              varchar2,
p_appl_attribute3              varchar2,
p_appl_attribute4              varchar2,
p_appl_attribute5              varchar2,
p_appl_attribute6              varchar2,
p_appl_attribute7              varchar2,
p_appl_attribute8              varchar2,
p_appl_attribute9              varchar2,
p_appl_attribute10             varchar2,
p_appl_attribute11             varchar2,
p_appl_attribute12             varchar2,
p_appl_attribute13             varchar2,
p_appl_attribute14             varchar2,
p_appl_attribute15             varchar2,
p_appl_attribute16             varchar2,
p_appl_attribute17             varchar2,
p_appl_attribute18             varchar2,
p_appl_attribute19             varchar2,
p_appl_attribute20             varchar2) is
  l_event_key number;

Line: 40

  select per_wf_events_s.nextval from dual;

Line: 42

  l_proc varchar2(72):='  hr_application_be1.update_apl_details_a';

Line: 46

  l_event_name:='oracle.apps.per.api.application.update_apl_details';

Line: 204

end update_apl_details_a;