APPS.HR_DOCUMENT_EXTRA_INFO_BE2 SQL Statements

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

Line: 4

procedure update_doc_extra_info_a (
p_document_extra_info_id       number,
p_person_id                    number,
p_document_type_id             number,
p_date_from                    date,
p_date_to                      date,
p_document_number              varchar2,
p_issued_by                    varchar2,
p_issued_at                    varchar2,
p_issued_date                  date,
p_issuing_authority            varchar2,
p_verified_by                  number,
p_verified_date                date,
p_related_object_name          varchar2,
p_related_object_id_col        varchar2,
p_related_object_id            number,
p_dei_attribute_category       varchar2,
p_dei_attribute1               varchar2,
p_dei_attribute2               varchar2,
p_dei_attribute3               varchar2,
p_dei_attribute4               varchar2,
p_dei_attribute5               varchar2,
p_dei_attribute6               varchar2,
p_dei_attribute7               varchar2,
p_dei_attribute8               varchar2,
p_dei_attribute9               varchar2,
p_dei_attribute10              varchar2,
p_dei_attribute11              varchar2,
p_dei_attribute12              varchar2,
p_dei_attribute13              varchar2,
p_dei_attribute14              varchar2,
p_dei_attribute15              varchar2,
p_dei_attribute16              varchar2,
p_dei_attribute17              varchar2,
p_dei_attribute18              varchar2,
p_dei_attribute19              varchar2,
p_dei_attribute20              varchar2,
p_dei_attribute21              varchar2,
p_dei_attribute22              varchar2,
p_dei_attribute23              varchar2,
p_dei_attribute24              varchar2,
p_dei_attribute25              varchar2,
p_dei_attribute26              varchar2,
p_dei_attribute27              varchar2,
p_dei_attribute28              varchar2,
p_dei_attribute29              varchar2,
p_dei_attribute30              varchar2,
p_dei_information_category     varchar2,
p_dei_information1             varchar2,
p_dei_information2             varchar2,
p_dei_information3             varchar2,
p_dei_information4             varchar2,
p_dei_information5             varchar2,
p_dei_information6             varchar2,
p_dei_information7             varchar2,
p_dei_information8             varchar2,
p_dei_information9             varchar2,
p_dei_information10            varchar2,
p_dei_information11            varchar2,
p_dei_information12            varchar2,
p_dei_information13            varchar2,
p_dei_information14            varchar2,
p_dei_information15            varchar2,
p_dei_information16            varchar2,
p_dei_information17            varchar2,
p_dei_information18            varchar2,
p_dei_information19            varchar2,
p_dei_information20            varchar2,
p_dei_information21            varchar2,
p_dei_information22            varchar2,
p_dei_information23            varchar2,
p_dei_information24            varchar2,
p_dei_information25            varchar2,
p_dei_information26            varchar2,
p_dei_information27            varchar2,
p_dei_information28            varchar2,
p_dei_information29            varchar2,
p_dei_information30            varchar2,
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;

Line: 94

  select per_wf_events_s.nextval from dual;

Line: 96

  l_proc varchar2(72):='  hr_document_extra_info_be2.update_doc_extra_info_a';

Line: 100

  l_event_name:='oracle.apps.per.api.document_extra_info.update_doc_extra_info';

Line: 440

    l_text:='';

Line: 441

    l_text:=l_text||fnd_date.date_to_canonical(p_program_update_date);

Line: 442

    l_text:=l_text||'';

Line: 472

end update_doc_extra_info_a;