APPS.PAY_ETM_UPD SQL Statements

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

Line: 48

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

Line: 61

  update pay_element_templates
  set
  base_processing_priority          = p_rec.base_processing_priority,
  version_number                    = p_rec.version_number,
  max_base_name_length              = p_rec.max_base_name_length,
  preference_info_category          = p_rec.preference_info_category,
  preference_information1           = p_rec.preference_information1,
  preference_information2           = p_rec.preference_information2,
  preference_information3           = p_rec.preference_information3,
  preference_information4           = p_rec.preference_information4,
  preference_information5           = p_rec.preference_information5,
  preference_information6           = p_rec.preference_information6,
  preference_information7           = p_rec.preference_information7,
  preference_information8           = p_rec.preference_information8,
  preference_information9           = p_rec.preference_information9,
  preference_information10          = p_rec.preference_information10,
  preference_information11          = p_rec.preference_information11,
  preference_information12          = p_rec.preference_information12,
  preference_information13          = p_rec.preference_information13,
  preference_information14          = p_rec.preference_information14,
  preference_information15          = p_rec.preference_information15,
  preference_information16          = p_rec.preference_information16,
  preference_information17          = p_rec.preference_information17,
  preference_information18          = p_rec.preference_information18,
  preference_information19          = p_rec.preference_information19,
  preference_information20          = p_rec.preference_information20,
  preference_information21          = p_rec.preference_information21,
  preference_information22          = p_rec.preference_information22,
  preference_information23          = p_rec.preference_information23,
  preference_information24          = p_rec.preference_information24,
  preference_information25          = p_rec.preference_information25,
  preference_information26          = p_rec.preference_information26,
  preference_information27          = p_rec.preference_information27,
  preference_information28          = p_rec.preference_information28,
  preference_information29          = p_rec.preference_information29,
  preference_information30          = p_rec.preference_information30,
  configuration_info_category       = p_rec.configuration_info_category,
  configuration_information1        = p_rec.configuration_information1,
  configuration_information2        = p_rec.configuration_information2,
  configuration_information3        = p_rec.configuration_information3,
  configuration_information4        = p_rec.configuration_information4,
  configuration_information5        = p_rec.configuration_information5,
  configuration_information6        = p_rec.configuration_information6,
  configuration_information7        = p_rec.configuration_information7,
  configuration_information8        = p_rec.configuration_information8,
  configuration_information9        = p_rec.configuration_information9,
  configuration_information10       = p_rec.configuration_information10,
  configuration_information11       = p_rec.configuration_information11,
  configuration_information12       = p_rec.configuration_information12,
  configuration_information13       = p_rec.configuration_information13,
  configuration_information14       = p_rec.configuration_information14,
  configuration_information15       = p_rec.configuration_information15,
  configuration_information16       = p_rec.configuration_information16,
  configuration_information17       = p_rec.configuration_information17,
  configuration_information18       = p_rec.configuration_information18,
  configuration_information19       = p_rec.configuration_information19,
  configuration_information20       = p_rec.configuration_information20,
  configuration_information21       = p_rec.configuration_information21,
  configuration_information22       = p_rec.configuration_information22,
  configuration_information23       = p_rec.configuration_information23,
  configuration_information24       = p_rec.configuration_information24,
  configuration_information25       = p_rec.configuration_information25,
  configuration_information26       = p_rec.configuration_information26,
  configuration_information27       = p_rec.configuration_information27,
  configuration_information28       = p_rec.configuration_information28,
  configuration_information29       = p_rec.configuration_information29,
  configuration_information30       = p_rec.configuration_information30,
  object_version_number             = p_rec.object_version_number
  where template_id = p_rec.template_id;

Line: 148

End update_dml;

Line: 182

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

Line: 190

End pre_update;

Line: 224

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

Line: 232

End post_update;

Line: 605

  pay_etm_bus.update_validate(p_effective_date, p_rec);

Line: 609

  pre_update(p_rec);

Line: 613

  update_dml(p_rec);

Line: 617

  post_update(p_rec);