APPS.PER_EQT_DEL SQL Statements

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

Line: 51

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

Line: 62

  delete from per_qualification_types
  where qualification_type_id = p_rec.qualification_type_id;

Line: 78

End delete_dml;

Line: 112

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

Line: 120

End pre_delete;

Line: 157

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

Line: 167

    per_eqt_rkd.after_delete
     (p_qualification_type_id     => p_rec.qualification_type_id
     ,p_object_version_number     => per_eqt_shd.g_old_rec.object_version_number
     ,p_name_o                    => per_eqt_shd.g_old_rec.name
     ,p_category_o                => per_eqt_shd.g_old_rec.category
     ,p_rank_o                    => per_eqt_shd.g_old_rec.rank
     ,p_attribute_category_o      => per_eqt_shd.g_old_rec.attribute_category
     ,p_attribute1_o              => per_eqt_shd.g_old_rec.attribute1
     ,p_attribute2_o              => per_eqt_shd.g_old_rec.attribute2
     ,p_attribute3_o              => per_eqt_shd.g_old_rec.attribute3
     ,p_attribute4_o              => per_eqt_shd.g_old_rec.attribute4
     ,p_attribute5_o              => per_eqt_shd.g_old_rec.attribute5
     ,p_attribute6_o              => per_eqt_shd.g_old_rec.attribute6
     ,p_attribute7_o              => per_eqt_shd.g_old_rec.attribute7
     ,p_attribute8_o              => per_eqt_shd.g_old_rec.attribute8
     ,p_attribute9_o              => per_eqt_shd.g_old_rec.attribute9
     ,p_attribute10_o             => per_eqt_shd.g_old_rec.attribute10
     ,p_attribute11_o             => per_eqt_shd.g_old_rec.attribute11
     ,p_attribute12_o             => per_eqt_shd.g_old_rec.attribute12
     ,p_attribute13_o             => per_eqt_shd.g_old_rec.attribute13
     ,p_attribute14_o             => per_eqt_shd.g_old_rec.attribute14
     ,p_attribute15_o             => per_eqt_shd.g_old_rec.attribute15
     ,p_attribute16_o             => per_eqt_shd.g_old_rec.attribute16
     ,p_attribute17_o             => per_eqt_shd.g_old_rec.attribute17
     ,p_attribute18_o             => per_eqt_shd.g_old_rec.attribute18
     ,p_attribute19_o             => per_eqt_shd.g_old_rec.attribute19
     ,p_attribute20_o             => per_eqt_shd.g_old_rec.attribute20
     ,p_object_version_number_o   => per_eqt_shd.g_old_rec.object_version_number
     ,p_information_category_o    => per_eqt_shd.g_old_rec.information_category
     ,p_information1_o	          => per_eqt_shd.g_old_rec.information1
     ,p_information2_o	          => per_eqt_shd.g_old_rec.information2
     ,p_information3_o	          => per_eqt_shd.g_old_rec.information3
     ,p_information4_o	          => per_eqt_shd.g_old_rec.information4
     ,p_information5_o	          => per_eqt_shd.g_old_rec.information5
     ,p_information6_o	          => per_eqt_shd.g_old_rec.information6
     ,p_information7_o	          => per_eqt_shd.g_old_rec.information7
     ,p_information8_o	          => per_eqt_shd.g_old_rec.information8
     ,p_information9_o	          => per_eqt_shd.g_old_rec.information9
     ,p_information10_o	          => per_eqt_shd.g_old_rec.information10
     ,p_information11_o	          => per_eqt_shd.g_old_rec.information11
     ,p_information12_o	          => per_eqt_shd.g_old_rec.information12
     ,p_information13_o	          => per_eqt_shd.g_old_rec.information13
     ,p_information14_o	          => per_eqt_shd.g_old_rec.information14
     ,p_information15_o	          => per_eqt_shd.g_old_rec.information15
     ,p_information16_o	          => per_eqt_shd.g_old_rec.information16
     ,p_information17_o	          => per_eqt_shd.g_old_rec.information17
     ,p_information18_o	          => per_eqt_shd.g_old_rec.information18
     ,p_information19_o	          => per_eqt_shd.g_old_rec.information19
     ,p_information20_o	          => per_eqt_shd.g_old_rec.information20
     ,p_information21_o	          => per_eqt_shd.g_old_rec.information21
     ,p_information22_o	          => per_eqt_shd.g_old_rec.information22
     ,p_information23_o	          => per_eqt_shd.g_old_rec.information23
     ,p_information24_o	          => per_eqt_shd.g_old_rec.information24
     ,p_information25_o	          => per_eqt_shd.g_old_rec.information25
     ,p_information26_o	          => per_eqt_shd.g_old_rec.information26
     ,p_information27_o	          => per_eqt_shd.g_old_rec.information27
     ,p_information28_o	          => per_eqt_shd.g_old_rec.information28
     ,p_information29_o	          => per_eqt_shd.g_old_rec.information29
     ,p_information30_o	          => per_eqt_shd.g_old_rec.information30
     -- BUG3356369
     ,p_qual_framework_id_o       => per_eqt_shd.g_old_rec.qual_framework_id
     ,p_qualification_type_o      => per_eqt_shd.g_old_rec.qualification_type
     ,p_credit_type_o             => per_eqt_shd.g_old_rec.credit_type
     ,p_credits_o                 => per_eqt_shd.g_old_rec.credits
     ,p_level_type_o              => per_eqt_shd.g_old_rec.level_type
     ,p_level_number_o            => per_eqt_shd.g_old_rec.level_number
     ,p_field_o                   => per_eqt_shd.g_old_rec.field
     ,p_sub_field_o               => per_eqt_shd.g_old_rec.sub_field
     ,p_provider_o                => per_eqt_shd.g_old_rec.provider
     ,p_qa_organization_o         => per_eqt_shd.g_old_rec.qa_organization
     );

Line: 248

End post_delete;

Line: 283

  per_eqt_bus.delete_validate(p_rec);

Line: 287

  pre_delete(p_rec);

Line: 291

  delete_dml(p_rec);

Line: 295

  post_delete(p_rec);