APPS.PAY_SET_UPD SQL Statements

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

Line: 51

Procedure update_dml(p_rec in out nocopy pay_set_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'update_dml';

Line: 65

  update pay_shadow_element_types
  set
  classification_name               = p_rec.classification_name,
  additional_entry_allowed_flag     = p_rec.additional_entry_allowed_flag,
  adjustment_only_flag              = p_rec.adjustment_only_flag,
  closed_for_entry_flag             = p_rec.closed_for_entry_flag,
  element_name                      = p_rec.element_name,
  indirect_only_flag                = p_rec.indirect_only_flag,
  multiple_entries_allowed_flag     = p_rec.multiple_entries_allowed_flag,
  multiply_value_flag               = p_rec.multiply_value_flag,
  post_termination_rule             = p_rec.post_termination_rule,
  process_in_run_flag               = p_rec.process_in_run_flag,
  relative_processing_priority      = p_rec.relative_processing_priority,
  processing_type                   = p_rec.processing_type,
  standard_link_flag                = p_rec.standard_link_flag,
  input_currency_code               = p_rec.input_currency_code,
  output_currency_code              = p_rec.output_currency_code,
  benefit_classification_name       = p_rec.benefit_classification_name,
  description                       = p_rec.description,
  qualifying_age                    = p_rec.qualifying_age,
  qualifying_length_of_service      = p_rec.qualifying_length_of_service,
  qualifying_units                  = p_rec.qualifying_units,
  reporting_name                    = p_rec.reporting_name,
  attribute_category                = p_rec.attribute_category,
  attribute1                        = p_rec.attribute1,
  attribute2                        = p_rec.attribute2,
  attribute3                        = p_rec.attribute3,
  attribute4                        = p_rec.attribute4,
  attribute5                        = p_rec.attribute5,
  attribute6                        = p_rec.attribute6,
  attribute7                        = p_rec.attribute7,
  attribute8                        = p_rec.attribute8,
  attribute9                        = p_rec.attribute9,
  attribute10                       = p_rec.attribute10,
  attribute11                       = p_rec.attribute11,
  attribute12                       = p_rec.attribute12,
  attribute13                       = p_rec.attribute13,
  attribute14                       = p_rec.attribute14,
  attribute15                       = p_rec.attribute15,
  attribute16                       = p_rec.attribute16,
  attribute17                       = p_rec.attribute17,
  attribute18                       = p_rec.attribute18,
  attribute19                       = p_rec.attribute19,
  attribute20                       = p_rec.attribute20,
  element_information_category      = p_rec.element_information_category,
  element_information1              = p_rec.element_information1,
  element_information2              = p_rec.element_information2,
  element_information3              = p_rec.element_information3,
  element_information4              = p_rec.element_information4,
  element_information5              = p_rec.element_information5,
  element_information6              = p_rec.element_information6,
  element_information7              = p_rec.element_information7,
  element_information8              = p_rec.element_information8,
  element_information9              = p_rec.element_information9,
  element_information10             = p_rec.element_information10,
  element_information11             = p_rec.element_information11,
  element_information12             = p_rec.element_information12,
  element_information13             = p_rec.element_information13,
  element_information14             = p_rec.element_information14,
  element_information15             = p_rec.element_information15,
  element_information16             = p_rec.element_information16,
  element_information17             = p_rec.element_information17,
  element_information18             = p_rec.element_information18,
  element_information19             = p_rec.element_information19,
  element_information20             = p_rec.element_information20,
  third_party_pay_only_flag         = p_rec.third_party_pay_only_flag,
  skip_formula                      = p_rec.skip_formula,
  payroll_formula_id                = p_rec.payroll_formula_id,
  exclusion_rule_id                 = p_rec.exclusion_rule_id,
  iterative_flag                    = p_rec.iterative_flag,
  iterative_priority                = p_rec.iterative_priority,
  iterative_formula_name            = p_rec.iterative_formula_name,
  process_mode                      = p_rec.process_mode,
  grossup_flag                      = p_rec.grossup_flag,
  advance_indicator                 = p_rec.advance_indicator,
  advance_payable                   = p_rec.advance_payable,
  advance_deduction                 = p_rec.advance_deduction,
  process_advance_entry             = p_rec.process_advance_entry,
  proration_group                   = p_rec.proration_group,
  proration_formula                 = p_rec.proration_formula,
  recalc_event_group                = p_rec.recalc_event_group,
  once_each_period_flag             = p_rec.once_each_period_flag,
  object_version_number             = p_rec.object_version_number
  where element_type_id = p_rec.element_type_id;

Line: 168

End update_dml;

Line: 202

Procedure pre_update(p_rec in pay_set_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'pre_update';

Line: 209

End pre_update;

Line: 243

Procedure post_update(p_rec in pay_set_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'post_update';

Line: 251

End post_update;

Line: 667

  pay_set_bus.update_validate(p_effective_date, p_rec);

Line: 671

  pre_update(p_rec);

Line: 675

  update_dml(p_rec);

Line: 679

  post_update(p_rec);