APPS.HR_PERSONAL_PAY_METHOD_BE2 SQL Statements

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

Line: 4

procedure update_personal_pay_method_a (
p_effective_date               date,
p_datetrack_update_mode        varchar2,
p_personal_payment_method_id   number,
p_object_version_number        number,
p_amount                       number,
p_comments                     varchar2,
p_percentage                   number,
p_priority                     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_territory_code               varchar2,
p_segment1                     varchar2,
p_segment2                     varchar2,
p_segment3                     varchar2,
p_segment4                     varchar2,
p_segment5                     varchar2,
p_segment6                     varchar2,
p_segment7                     varchar2,
p_segment8                     varchar2,
p_segment9                     varchar2,
p_segment10                    varchar2,
p_segment11                    varchar2,
p_segment12                    varchar2,
p_segment13                    varchar2,
p_segment14                    varchar2,
p_segment15                    varchar2,
p_segment16                    varchar2,
p_segment17                    varchar2,
p_segment18                    varchar2,
p_segment19                    varchar2,
p_segment20                    varchar2,
p_segment21                    varchar2,
p_segment22                    varchar2,
p_segment23                    varchar2,
p_segment24                    varchar2,
p_segment25                    varchar2,
p_segment26                    varchar2,
p_segment27                    varchar2,
p_segment28                    varchar2,
p_segment29                    varchar2,
p_segment30                    varchar2,
p_payee_type                   varchar2,
p_payee_id                     number,
p_comment_id                   number,
p_external_account_id          number,
p_effective_start_date         date,
p_effective_end_date           date,
p_ppm_information1             varchar2,
p_ppm_information2             varchar2,
p_ppm_information3             varchar2,
p_ppm_information4             varchar2,
p_ppm_information5             varchar2,
p_ppm_information6             varchar2,
p_ppm_information7             varchar2,
p_ppm_information8             varchar2,
p_ppm_information9             varchar2,
p_ppm_information10            varchar2,
p_ppm_information11            varchar2,
p_ppm_information12            varchar2,
p_ppm_information13            varchar2,
p_ppm_information14            varchar2,
p_ppm_information15            varchar2,
p_ppm_information16            varchar2,
p_ppm_information17            varchar2,
p_ppm_information18            varchar2,
p_ppm_information19            varchar2,
p_ppm_information20            varchar2,
p_ppm_information21            varchar2,
p_ppm_information22            varchar2,
p_ppm_information23            varchar2,
p_ppm_information24            varchar2,
p_ppm_information25            varchar2,
p_ppm_information26            varchar2,
p_ppm_information27            varchar2,
p_ppm_information28            varchar2,
p_ppm_information29            varchar2,
p_ppm_information30            varchar2) is
  l_event_key number;

Line: 108

  select per_wf_events_s.nextval from dual;

Line: 110

  l_proc varchar2(72):='  hr_personal_pay_method_be2.update_personal_pay_method_a';

Line: 114

  l_event_name:='oracle.apps.per.api.personal_pay_method.update_personal_pay_method';

Line: 138

    l_text:='';

Line: 139

    l_text:=l_text||irc_utilities_pkg.removeTags(p_datetrack_update_mode);

Line: 140

    l_text:=l_text||'';

Line: 564

end update_personal_pay_method_a;