APPS.PAY_ELEMENT_LINK_BE2 SQL Statements

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

Line: 4

procedure update_element_link_a (
p_effective_date               date,
p_element_link_id              number,
p_datetrack_mode               varchar2,
p_costable_type                varchar2,
p_element_set_id               number,
p_multiply_value_flag          varchar2,
p_standard_link_flag           varchar2,
p_transfer_to_gl_flag          varchar2,
p_comments                     varchar2,
p_comment_id                   varchar2,
p_employment_category          varchar2,
p_qualifying_age               number,
p_qualifying_length_of_service number,
p_qualifying_units             varchar2,
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_cost_segment1                varchar2,
p_cost_segment2                varchar2,
p_cost_segment3                varchar2,
p_cost_segment4                varchar2,
p_cost_segment5                varchar2,
p_cost_segment6                varchar2,
p_cost_segment7                varchar2,
p_cost_segment8                varchar2,
p_cost_segment9                varchar2,
p_cost_segment10               varchar2,
p_cost_segment11               varchar2,
p_cost_segment12               varchar2,
p_cost_segment13               varchar2,
p_cost_segment14               varchar2,
p_cost_segment15               varchar2,
p_cost_segment16               varchar2,
p_cost_segment17               varchar2,
p_cost_segment18               varchar2,
p_cost_segment19               varchar2,
p_cost_segment20               varchar2,
p_cost_segment21               varchar2,
p_cost_segment22               varchar2,
p_cost_segment23               varchar2,
p_cost_segment24               varchar2,
p_cost_segment25               varchar2,
p_cost_segment26               varchar2,
p_cost_segment27               varchar2,
p_cost_segment28               varchar2,
p_cost_segment29               varchar2,
p_cost_segment30               varchar2,
p_balance_segment1             varchar2,
p_balance_segment2             varchar2,
p_balance_segment3             varchar2,
p_balance_segment4             varchar2,
p_balance_segment5             varchar2,
p_balance_segment6             varchar2,
p_balance_segment7             varchar2,
p_balance_segment8             varchar2,
p_balance_segment9             varchar2,
p_balance_segment10            varchar2,
p_balance_segment11            varchar2,
p_balance_segment12            varchar2,
p_balance_segment13            varchar2,
p_balance_segment14            varchar2,
p_balance_segment15            varchar2,
p_balance_segment16            varchar2,
p_balance_segment17            varchar2,
p_balance_segment18            varchar2,
p_balance_segment19            varchar2,
p_balance_segment20            varchar2,
p_balance_segment21            varchar2,
p_balance_segment22            varchar2,
p_balance_segment23            varchar2,
p_balance_segment24            varchar2,
p_balance_segment25            varchar2,
p_balance_segment26            varchar2,
p_balance_segment27            varchar2,
p_balance_segment28            varchar2,
p_balance_segment29            varchar2,
p_balance_segment30            varchar2,
p_cost_concat_segments_in      varchar2,
p_balance_concat_segments_in   varchar2,
p_object_version_number        number,
p_cost_allocation_keyflex_id   number,
p_balancing_keyflex_id         number,
p_cost_concat_segments_out     varchar2,
p_balance_concat_segments_out  varchar2,
p_effective_start_date         date,
p_effective_end_date           date) is
  l_event_key number;

Line: 116

  select per_wf_events_s.nextval from dual;

Line: 118

  l_proc varchar2(72):='  pay_element_link_be2.update_element_link_a';

Line: 122

  l_event_name:='oracle.apps.pay.api.element_link.update_element_link';

Line: 604

end update_element_link_a;