APPS.PAY_AIF_DEL SQL Statements

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

Line: 51

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

Line: 64

  delete from pay_action_information
  where action_information_id = p_rec.action_information_id;

Line: 80

End delete_dml;

Line: 114

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

Line: 122

End pre_delete;

Line: 156

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

Line: 164

    pay_aif_rkd.after_delete
      (p_action_information_id
      => p_rec.action_information_id
      ,p_action_context_id_o
      => pay_aif_shd.g_old_rec.action_context_id
      ,p_action_context_type_o
      => pay_aif_shd.g_old_rec.action_context_type
      ,p_tax_unit_id_o
      => pay_aif_shd.g_old_rec.tax_unit_id
      ,p_jurisdiction_code_o
      => pay_aif_shd.g_old_rec.jurisdiction_code
      ,p_source_id_o
      => pay_aif_shd.g_old_rec.source_id
      ,p_source_text_o
      => pay_aif_shd.g_old_rec.source_text
      ,p_tax_group_o
      => pay_aif_shd.g_old_rec.tax_group
      ,p_object_version_number_o
      => pay_aif_shd.g_old_rec.object_version_number
      ,p_effective_date_o
      => pay_aif_shd.g_old_rec.effective_date
      ,p_assignment_id_o
      => pay_aif_shd.g_old_rec.assignment_id
      ,p_action_information_categor_o
      => pay_aif_shd.g_old_rec.action_information_category
      ,p_action_information1_o
      => pay_aif_shd.g_old_rec.action_information1
      ,p_action_information2_o
      => pay_aif_shd.g_old_rec.action_information2
      ,p_action_information3_o
      => pay_aif_shd.g_old_rec.action_information3
      ,p_action_information4_o
      => pay_aif_shd.g_old_rec.action_information4
      ,p_action_information5_o
      => pay_aif_shd.g_old_rec.action_information5
      ,p_action_information6_o
      => pay_aif_shd.g_old_rec.action_information6
      ,p_action_information7_o
      => pay_aif_shd.g_old_rec.action_information7
      ,p_action_information8_o
      => pay_aif_shd.g_old_rec.action_information8
      ,p_action_information9_o
      => pay_aif_shd.g_old_rec.action_information9
      ,p_action_information10_o
      => pay_aif_shd.g_old_rec.action_information10
      ,p_action_information11_o
      => pay_aif_shd.g_old_rec.action_information11
      ,p_action_information12_o
      => pay_aif_shd.g_old_rec.action_information12
      ,p_action_information13_o
      => pay_aif_shd.g_old_rec.action_information13
      ,p_action_information14_o
      => pay_aif_shd.g_old_rec.action_information14
      ,p_action_information15_o
      => pay_aif_shd.g_old_rec.action_information15
      ,p_action_information16_o
      => pay_aif_shd.g_old_rec.action_information16
      ,p_action_information17_o
      => pay_aif_shd.g_old_rec.action_information17
      ,p_action_information18_o
      => pay_aif_shd.g_old_rec.action_information18
      ,p_action_information19_o
      => pay_aif_shd.g_old_rec.action_information19
      ,p_action_information20_o
      => pay_aif_shd.g_old_rec.action_information20
      ,p_action_information21_o
      => pay_aif_shd.g_old_rec.action_information21
      ,p_action_information22_o
      => pay_aif_shd.g_old_rec.action_information22
      ,p_action_information23_o
      => pay_aif_shd.g_old_rec.action_information23
      ,p_action_information24_o
      => pay_aif_shd.g_old_rec.action_information24
      ,p_action_information25_o
      => pay_aif_shd.g_old_rec.action_information25
      ,p_action_information26_o
      => pay_aif_shd.g_old_rec.action_information26
      ,p_action_information27_o
      => pay_aif_shd.g_old_rec.action_information27
      ,p_action_information28_o
      => pay_aif_shd.g_old_rec.action_information28
      ,p_action_information29_o
      => pay_aif_shd.g_old_rec.action_information29
      ,p_action_information30_o
      => pay_aif_shd.g_old_rec.action_information30
      );

Line: 262

End post_delete;

Line: 285

  pay_aif_bus.delete_validate(p_rec);

Line: 293

  pay_aif_del.pre_delete(p_rec);

Line: 297

  pay_aif_del.delete_dml(p_rec);

Line: 301

  pay_aif_del.post_delete(p_rec);