APPS.PAY_ELEMENT_TYPES_BE2 SQL Statements

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

Line: 4

procedure update_element_type_a (
p_effective_date               date,
p_datetrack_update_mode        varchar2,
p_element_type_id              number,
p_object_version_number        number,
p_formula_id                   number,
p_benefit_classification_id    number,
p_additional_entry_allowed_fla varchar2,
p_adjustment_only_flag         varchar2,
p_closed_for_entry_flag        varchar2,
p_element_name                 varchar2,
p_reporting_name               varchar2,
p_description                  varchar2,
p_indirect_only_flag           varchar2,
p_multiple_entries_allowed_fla varchar2,
p_multiply_value_flag          varchar2,
p_post_termination_rule        varchar2,
p_process_in_run_flag          varchar2,
p_processing_priority          number,
p_standard_link_flag           varchar2,
p_comments                     varchar2,
p_third_party_pay_only_flag    varchar2,
p_iterative_flag               varchar2,
p_iterative_formula_id         number,
p_iterative_priority           number,
p_creator_type                 varchar2,
p_retro_summ_ele_id            number,
p_grossup_flag                 varchar2,
p_process_mode                 varchar2,
p_advance_indicator            varchar2,
p_advance_payable              varchar2,
p_advance_deduction            varchar2,
p_process_advance_entry        varchar2,
p_proration_group_id           number,
p_proration_formula_id         number,
p_recalc_event_group_id        number,
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_element_information_category varchar2,
p_element_information1         varchar2,
p_element_information2         varchar2,
p_element_information3         varchar2,
p_element_information4         varchar2,
p_element_information5         varchar2,
p_element_information6         varchar2,
p_element_information7         varchar2,
p_element_information8         varchar2,
p_element_information9         varchar2,
p_element_information10        varchar2,
p_element_information11        varchar2,
p_element_information12        varchar2,
p_element_information13        varchar2,
p_element_information14        varchar2,
p_element_information15        varchar2,
p_element_information16        varchar2,
p_element_information17        varchar2,
p_element_information18        varchar2,
p_element_information19        varchar2,
p_element_information20        varchar2,
p_once_each_period_flag        varchar2,
p_language_code                varchar2,
p_time_definition_type         varchar2,
p_time_definition_id           number,
p_advance_element_type_id      number,
p_deduction_element_type_id    number,
p_effective_start_date         date,
p_effective_end_date           date,
p_comment_id                   number,
p_processing_priority_warning  boolean,
p_element_name_warning         boolean,
p_element_name_change_warning  boolean) is
  l_event_key number;

Line: 104

  select per_wf_events_s.nextval from dual;

Line: 106

  l_proc varchar2(72):='  pay_element_types_be2.update_element_type_a';

Line: 110

  l_event_name:='oracle.apps.pay.api.element_types.update_element_type';

Line: 134

    l_text:='';

Line: 135

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

Line: 136

    l_text:=l_text||'';

Line: 556

end update_element_type_a;