APPS.PER_EST_DEL SQL Statements

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

Line: 51

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

Line: 62

  delete from per_establishments
  where establishment_id = p_rec.establishment_id;

Line: 78

End delete_dml;

Line: 112

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

Line: 120

End pre_delete;

Line: 154

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

Line: 163

 per_est_rkd.after_delete
  (p_establishment_id             =>p_rec.establishment_id
  ,p_name_o                       =>per_est_shd.g_old_rec.name
  ,p_location_o                   =>per_est_shd.g_old_rec.location
  ,p_attribute_category_o         =>per_est_shd.g_old_rec.attribute_category
  ,p_attribute1_o                 =>per_est_shd.g_old_rec.attribute1
  ,p_attribute2_o                 =>per_est_shd.g_old_rec.attribute2
  ,p_attribute3_o                 =>per_est_shd.g_old_rec.attribute3
  ,p_attribute4_o                 =>per_est_shd.g_old_rec.attribute4
  ,p_attribute5_o                 =>per_est_shd.g_old_rec.attribute5
  ,p_attribute6_o                 =>per_est_shd.g_old_rec.attribute6
  ,p_attribute7_o                 =>per_est_shd.g_old_rec.attribute7
  ,p_attribute8_o                 =>per_est_shd.g_old_rec.attribute8
  ,p_attribute9_o                 =>per_est_shd.g_old_rec.attribute9
  ,p_attribute10_o                =>per_est_shd.g_old_rec.attribute10
  ,p_attribute11_o                =>per_est_shd.g_old_rec.attribute11
  ,p_attribute12_o                =>per_est_shd.g_old_rec.attribute12
  ,p_attribute13_o                =>per_est_shd.g_old_rec.attribute13
  ,p_attribute14_o                =>per_est_shd.g_old_rec.attribute14
  ,p_attribute15_o                =>per_est_shd.g_old_rec.attribute15
  ,p_attribute16_o                =>per_est_shd.g_old_rec.attribute16
  ,p_attribute17_o                =>per_est_shd.g_old_rec.attribute17
  ,p_attribute18_o                =>per_est_shd.g_old_rec.attribute18
  ,p_attribute19_o                =>per_est_shd.g_old_rec.attribute19
  ,p_attribute20_o                =>per_est_shd.g_old_rec.attribute20
  ,p_object_version_number_o      =>per_est_shd.g_old_rec.object_version_number,
      p_est_information_category_o         => per_est_shd.g_old_rec.est_information_category,
      p_est_information1_o                 => per_est_shd.g_old_rec.est_information1,
      p_est_information2_o                 => per_est_shd.g_old_rec.est_information2,
      p_est_information3_o                 => per_est_shd.g_old_rec.est_information3,
      p_est_information4_o                 => per_est_shd.g_old_rec.est_information4,
      p_est_information5_o                 => per_est_shd.g_old_rec.est_information5,
      p_est_information6_o                 => per_est_shd.g_old_rec.est_information6,
      p_est_information7_o                 => per_est_shd.g_old_rec.est_information7,
      p_est_information8_o                 => per_est_shd.g_old_rec.est_information8,
      p_est_information9_o                 => per_est_shd.g_old_rec.est_information9,
      p_est_information10_o                => per_est_shd.g_old_rec.est_information10,
      p_est_information11_o                => per_est_shd.g_old_rec.est_information11,
      p_est_information12_o                => per_est_shd.g_old_rec.est_information12,
      p_est_information13_o                => per_est_shd.g_old_rec.est_information13,
      p_est_information14_o                => per_est_shd.g_old_rec.est_information14,
      p_est_information15_o                => per_est_shd.g_old_rec.est_information15,
      p_est_information16_o                => per_est_shd.g_old_rec.est_information16,
      p_est_information17_o                => per_est_shd.g_old_rec.est_information17,
      p_est_information18_o                => per_est_shd.g_old_rec.est_information18,
      p_est_information19_o                => per_est_shd.g_old_rec.est_information19,
      p_est_information20_o                => per_est_shd.g_old_rec.est_information20
   );

Line: 220

End post_delete;

Line: 255

  per_est_bus.delete_validate(p_rec);

Line: 259

  pre_delete(p_rec);

Line: 263

  delete_dml(p_rec);

Line: 267

  post_delete(p_rec);