APPS.PAY_AUD_DEL SQL Statements

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

Line: 51

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

Line: 64

  delete from pay_stat_trans_audit
  where stat_trans_audit_id = p_rec.stat_trans_audit_id;

Line: 80

End delete_dml;

Line: 114

Procedure pre_delete(p_rec in pay_aud_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_aud_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'post_delete';

Line: 164

    pay_aud_rkd.after_delete
      (p_stat_trans_audit_id
      => p_rec.stat_trans_audit_id
      ,p_transaction_type_o
      => pay_aud_shd.g_old_rec.transaction_type
      ,p_transaction_subtype_o
      => pay_aud_shd.g_old_rec.transaction_subtype
      ,p_transaction_date_o
      => pay_aud_shd.g_old_rec.transaction_date
      ,p_transaction_effective_date_o
      => pay_aud_shd.g_old_rec.transaction_effective_date
      ,p_business_group_id_o
      => pay_aud_shd.g_old_rec.business_group_id
      ,p_person_id_o
      => pay_aud_shd.g_old_rec.person_id
      ,p_assignment_id_o
      => pay_aud_shd.g_old_rec.assignment_id
      ,p_source1_o
      => pay_aud_shd.g_old_rec.source1
      ,p_source1_type_o
      => pay_aud_shd.g_old_rec.source1_type
      ,p_source2_o
      => pay_aud_shd.g_old_rec.source2
      ,p_source2_type_o
      => pay_aud_shd.g_old_rec.source2_type
      ,p_source3_o
      => pay_aud_shd.g_old_rec.source3
      ,p_source3_type_o
      => pay_aud_shd.g_old_rec.source3_type
      ,p_source4_o
      => pay_aud_shd.g_old_rec.source4
      ,p_source4_type_o
      => pay_aud_shd.g_old_rec.source4_type
      ,p_source5_o
      => pay_aud_shd.g_old_rec.source5
      ,p_source5_type_o
      => pay_aud_shd.g_old_rec.source5_type
      ,p_transaction_parent_id_o
      => pay_aud_shd.g_old_rec.transaction_parent_id
      ,p_audit_information_category_o
      => pay_aud_shd.g_old_rec.audit_information_category
      ,p_audit_information1_o
      => pay_aud_shd.g_old_rec.audit_information1
      ,p_audit_information2_o
      => pay_aud_shd.g_old_rec.audit_information2
      ,p_audit_information3_o
      => pay_aud_shd.g_old_rec.audit_information3
      ,p_audit_information4_o
      => pay_aud_shd.g_old_rec.audit_information4
      ,p_audit_information5_o
      => pay_aud_shd.g_old_rec.audit_information5
      ,p_audit_information6_o
      => pay_aud_shd.g_old_rec.audit_information6
      ,p_audit_information7_o
      => pay_aud_shd.g_old_rec.audit_information7
      ,p_audit_information8_o
      => pay_aud_shd.g_old_rec.audit_information8
      ,p_audit_information9_o
      => pay_aud_shd.g_old_rec.audit_information9
      ,p_audit_information10_o
      => pay_aud_shd.g_old_rec.audit_information10
      ,p_audit_information11_o
      => pay_aud_shd.g_old_rec.audit_information11
      ,p_audit_information12_o
      => pay_aud_shd.g_old_rec.audit_information12
      ,p_audit_information13_o
      => pay_aud_shd.g_old_rec.audit_information13
      ,p_audit_information14_o
      => pay_aud_shd.g_old_rec.audit_information14
      ,p_audit_information15_o
      => pay_aud_shd.g_old_rec.audit_information15
      ,p_audit_information16_o
      => pay_aud_shd.g_old_rec.audit_information16
      ,p_audit_information17_o
      => pay_aud_shd.g_old_rec.audit_information17
      ,p_audit_information18_o
      => pay_aud_shd.g_old_rec.audit_information18
      ,p_audit_information19_o
      => pay_aud_shd.g_old_rec.audit_information19
      ,p_audit_information20_o
      => pay_aud_shd.g_old_rec.audit_information20
      ,p_audit_information21_o
      => pay_aud_shd.g_old_rec.audit_information21
      ,p_audit_information22_o
      => pay_aud_shd.g_old_rec.audit_information22
      ,p_audit_information23_o
      => pay_aud_shd.g_old_rec.audit_information23
      ,p_audit_information24_o
      => pay_aud_shd.g_old_rec.audit_information24
      ,p_audit_information25_o
      => pay_aud_shd.g_old_rec.audit_information25
      ,p_audit_information26_o
      => pay_aud_shd.g_old_rec.audit_information26
      ,p_audit_information27_o
      => pay_aud_shd.g_old_rec.audit_information27
      ,p_audit_information28_o
      => pay_aud_shd.g_old_rec.audit_information28
      ,p_audit_information29_o
      => pay_aud_shd.g_old_rec.audit_information29
      ,p_audit_information30_o
      => pay_aud_shd.g_old_rec.audit_information30
      ,p_title_o
      => pay_aud_shd.g_old_rec.title
      ,p_object_version_number_o
      => pay_aud_shd.g_old_rec.object_version_number
      );

Line: 282

End post_delete;

Line: 305

  pay_aud_bus.delete_validate(p_rec);

Line: 309

  pay_aud_del.pre_delete(p_rec);

Line: 313

  pay_aud_del.delete_dml(p_rec);

Line: 317

  pay_aud_del.post_delete(p_rec);