APPS.PAY_CON_UPD SQL Statements

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

Line: 54

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

Line: 69

  update pay_us_contribution_history
  set
  contr_history_id                  = p_rec.contr_history_id,
  person_id                         = p_rec.person_id,
  date_from                         = p_rec.date_from,
  date_to                           = p_rec.date_to,
  contr_type                        = p_rec.contr_type,
  business_group_id                 = p_rec.business_group_id,
  legislation_code                  = p_rec.legislation_code,
  amt_contr                         = p_rec.amt_contr,
  max_contr_allowed                 = p_rec.max_contr_allowed,
  includable_comp                   = p_rec.includable_comp,
  tax_unit_id                       = p_rec.tax_unit_id,
  source_system                     = p_rec.source_system,
  contr_information_category        = p_rec.contr_information_category,
  contr_information1                = p_rec.contr_information1,
  contr_information2                = p_rec.contr_information2,
  contr_information3                = p_rec.contr_information3,
  contr_information4                = p_rec.contr_information4,
  contr_information5                = p_rec.contr_information5,
  contr_information6                = p_rec.contr_information6,
  contr_information7                = p_rec.contr_information7,
  contr_information8                = p_rec.contr_information8,
  contr_information9                = p_rec.contr_information9,
  contr_information10               = p_rec.contr_information10,
  contr_information11               = p_rec.contr_information11,
  contr_information12               = p_rec.contr_information12,
  contr_information13               = p_rec.contr_information13,
  contr_information14               = p_rec.contr_information14,
  contr_information15               = p_rec.contr_information15,
  contr_information16               = p_rec.contr_information16,
  contr_information17               = p_rec.contr_information17,
  contr_information18               = p_rec.contr_information18,
  contr_information19               = p_rec.contr_information19,
  contr_information20               = p_rec.contr_information20,
  contr_information21               = p_rec.contr_information21,
  contr_information22               = p_rec.contr_information22,
  contr_information23               = p_rec.contr_information23,
  contr_information24               = p_rec.contr_information24,
  contr_information25               = p_rec.contr_information25,
  contr_information26               = p_rec.contr_information26,
  contr_information27               = p_rec.contr_information27,
  contr_information28               = p_rec.contr_information28,
  contr_information29               = p_rec.contr_information29,
  contr_information30               = p_rec.contr_information30,
  object_version_number             = p_rec.object_version_number
  where contr_history_id = p_rec.contr_history_id;

Line: 140

End update_dml;

Line: 174

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

Line: 182

End pre_update;

Line: 216

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

Line: 228

    pay_con_rku.after_update
      (
  p_contr_history_id              =>p_rec.contr_history_id
 ,p_person_id                     =>p_rec.person_id
 ,p_date_from                     =>p_rec.date_from
 ,p_date_to                       =>p_rec.date_to
 ,p_contr_type                    =>p_rec.contr_type
 ,p_business_group_id             =>p_rec.business_group_id
 ,p_legislation_code              =>p_rec.legislation_code
 ,p_amt_contr                     =>p_rec.amt_contr
 ,p_max_contr_allowed             =>p_rec.max_contr_allowed
 ,p_includable_comp               =>p_rec.includable_comp
 ,p_tax_unit_id                   =>p_rec.tax_unit_id
 ,p_source_system                 =>p_rec.source_system
 ,p_contr_information_category    =>p_rec.contr_information_category
 ,p_contr_information1            =>p_rec.contr_information1
 ,p_contr_information2            =>p_rec.contr_information2
 ,p_contr_information3            =>p_rec.contr_information3
 ,p_contr_information4            =>p_rec.contr_information4
 ,p_contr_information5            =>p_rec.contr_information5
 ,p_contr_information6            =>p_rec.contr_information6
 ,p_contr_information7            =>p_rec.contr_information7
 ,p_contr_information8            =>p_rec.contr_information8
 ,p_contr_information9            =>p_rec.contr_information9
 ,p_contr_information10           =>p_rec.contr_information10
 ,p_contr_information11           =>p_rec.contr_information11
 ,p_contr_information12           =>p_rec.contr_information12
 ,p_contr_information13           =>p_rec.contr_information13
 ,p_contr_information14           =>p_rec.contr_information14
 ,p_contr_information15           =>p_rec.contr_information15
 ,p_contr_information16           =>p_rec.contr_information16
 ,p_contr_information17           =>p_rec.contr_information17
 ,p_contr_information18           =>p_rec.contr_information18
 ,p_contr_information19           =>p_rec.contr_information19
 ,p_contr_information20           =>p_rec.contr_information20
 ,p_contr_information21           =>p_rec.contr_information21
 ,p_contr_information22           =>p_rec.contr_information22
 ,p_contr_information23           =>p_rec.contr_information23
 ,p_contr_information24           =>p_rec.contr_information24
 ,p_contr_information25           =>p_rec.contr_information25
 ,p_contr_information26           =>p_rec.contr_information26
 ,p_contr_information27           =>p_rec.contr_information27
 ,p_contr_information28           =>p_rec.contr_information28
 ,p_contr_information29           =>p_rec.contr_information29
 ,p_contr_information30           =>p_rec.contr_information30
 ,p_object_version_number         =>p_rec.object_version_number
 ,p_person_id_o                   =>pay_con_shd.g_old_rec.person_id
 ,p_date_from_o                   =>pay_con_shd.g_old_rec.date_from
 ,p_date_to_o                     =>pay_con_shd.g_old_rec.date_to
 ,p_contr_type_o                  =>pay_con_shd.g_old_rec.contr_type
 ,p_business_group_id_o           =>pay_con_shd.g_old_rec.business_group_id
 ,p_legislation_code_o            =>pay_con_shd.g_old_rec.legislation_code
 ,p_amt_contr_o                   =>pay_con_shd.g_old_rec.amt_contr
 ,p_max_contr_allowed_o           =>pay_con_shd.g_old_rec.max_contr_allowed
 ,p_includable_comp_o             =>pay_con_shd.g_old_rec.includable_comp
 ,p_tax_unit_id_o                 =>pay_con_shd.g_old_rec.tax_unit_id
 ,p_source_system_o               =>pay_con_shd.g_old_rec.source_system
 ,p_contr_information_category_o  =>pay_con_shd.g_old_rec.contr_information_category
 ,p_contr_information1_o          =>pay_con_shd.g_old_rec.contr_information1
 ,p_contr_information2_o          =>pay_con_shd.g_old_rec.contr_information2
 ,p_contr_information3_o          =>pay_con_shd.g_old_rec.contr_information3
 ,p_contr_information4_o          =>pay_con_shd.g_old_rec.contr_information4
 ,p_contr_information5_o          =>pay_con_shd.g_old_rec.contr_information5
 ,p_contr_information6_o          =>pay_con_shd.g_old_rec.contr_information6
 ,p_contr_information7_o          =>pay_con_shd.g_old_rec.contr_information7
 ,p_contr_information8_o          =>pay_con_shd.g_old_rec.contr_information8
 ,p_contr_information9_o          =>pay_con_shd.g_old_rec.contr_information9
 ,p_contr_information10_o         =>pay_con_shd.g_old_rec.contr_information10
 ,p_contr_information11_o         =>pay_con_shd.g_old_rec.contr_information11
 ,p_contr_information12_o         =>pay_con_shd.g_old_rec.contr_information12
 ,p_contr_information13_o         =>pay_con_shd.g_old_rec.contr_information13
 ,p_contr_information14_o         =>pay_con_shd.g_old_rec.contr_information14
 ,p_contr_information15_o         =>pay_con_shd.g_old_rec.contr_information15
 ,p_contr_information16_o         =>pay_con_shd.g_old_rec.contr_information16
 ,p_contr_information17_o         =>pay_con_shd.g_old_rec.contr_information17
 ,p_contr_information18_o         =>pay_con_shd.g_old_rec.contr_information18
 ,p_contr_information19_o         =>pay_con_shd.g_old_rec.contr_information19
 ,p_contr_information20_o         =>pay_con_shd.g_old_rec.contr_information20
 ,p_contr_information21_o         =>pay_con_shd.g_old_rec.contr_information21
 ,p_contr_information22_o         =>pay_con_shd.g_old_rec.contr_information22
 ,p_contr_information23_o         =>pay_con_shd.g_old_rec.contr_information23
 ,p_contr_information24_o         =>pay_con_shd.g_old_rec.contr_information24
 ,p_contr_information25_o         =>pay_con_shd.g_old_rec.contr_information25
 ,p_contr_information26_o         =>pay_con_shd.g_old_rec.contr_information26
 ,p_contr_information27_o         =>pay_con_shd.g_old_rec.contr_information27
 ,p_contr_information28_o         =>pay_con_shd.g_old_rec.contr_information28
 ,p_contr_information29_o         =>pay_con_shd.g_old_rec.contr_information29
 ,p_contr_information30_o         =>pay_con_shd.g_old_rec.contr_information30
 ,p_object_version_number_o       =>pay_con_shd.g_old_rec.object_version_number
      );

Line: 333

End post_update;

Line: 593

  pay_con_bus.update_validate(p_rec);

Line: 597

  pre_update(p_rec);

Line: 601

  update_dml(p_rec);

Line: 605

  post_update(p_rec);