APPS.PER_EST_UPD SQL Statements

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

Line: 54

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

Line: 69

  update per_establishments
  set
  establishment_id                  = p_rec.establishment_id,
  name                              = p_rec.name,
  location                          = p_rec.location,
  attribute_category          = p_rec.attribute_category,
  attribute1                  = p_rec.attribute1,
  attribute2                  = p_rec.attribute2,
  attribute3                  = p_rec.attribute3,
  attribute4                  = p_rec.attribute4,
  attribute5                  = p_rec.attribute5,
  attribute6                  = p_rec.attribute6,
  attribute7                  = p_rec.attribute7,
  attribute8                  = p_rec.attribute8,
  attribute9                  = p_rec.attribute9,
  attribute10                 = p_rec.attribute10,
  attribute11                 = p_rec.attribute11,
  attribute12                 = p_rec.attribute12,
  attribute13                 = p_rec.attribute13,
  attribute14                 = p_rec.attribute14,
  attribute15                 = p_rec.attribute15,
  attribute16                 = p_rec.attribute16,
  attribute17                 = p_rec.attribute17,
  attribute18                 = p_rec.attribute18,
  attribute19                 = p_rec.attribute19,
  attribute20                 = p_rec.attribute20,
  est_information_category                = p_rec.est_information_category,
  est_information1                        = p_rec.est_information1,
  est_information2                        = p_rec.est_information2,
  est_information3                        = p_rec.est_information3,
  est_information4                        = p_rec.est_information4,
  est_information5                        = p_rec.est_information5,
  est_information6                        = p_rec.est_information6,
  est_information7                        = p_rec.est_information7,
  est_information8                        = p_rec.est_information8,
  est_information9                        = p_rec.est_information9,
  est_information10                       = p_rec.est_information10,
  est_information11                       = p_rec.est_information11,
  est_information12                       = p_rec.est_information12,
  est_information13                       = p_rec.est_information13,
  est_information14                       = p_rec.est_information14,
  est_information15                       = p_rec.est_information15,
  est_information16                       = p_rec.est_information16,
  est_information17                       = p_rec.est_information17,
  est_information18                       = p_rec.est_information18,
  est_information19                       = p_rec.est_information19,
  est_information20                       = p_rec.est_information20,
  object_version_number             = p_rec.object_version_number
  where establishment_id = p_rec.establishment_id;

Line: 142

End update_dml;

Line: 176

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

Line: 184

End pre_update;

Line: 218

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

Line: 227

    per_est_rku.after_update
   (p_establishment_id             =>p_rec.establishment_id
   ,p_name                         =>p_rec.name
   ,p_location                     =>p_rec.location
   ,p_attribute_category           =>p_rec.attribute_category
   ,p_attribute1                   =>p_rec.attribute1
   ,p_attribute2                   =>p_rec.attribute2
   ,p_attribute3                   =>p_rec.attribute3
   ,p_attribute4                   =>p_rec.attribute4
   ,p_attribute5                   =>p_rec.attribute5
   ,p_attribute6                   =>p_rec.attribute6
   ,p_attribute7                   =>p_rec.attribute7
   ,p_attribute8                   =>p_rec.attribute8
   ,p_attribute9                   =>p_rec.attribute9
   ,p_attribute10                  =>p_rec.attribute10
   ,p_attribute11                  =>p_rec.attribute11
   ,p_attribute12                  =>p_rec.attribute12
   ,p_attribute13                  =>p_rec.attribute13
   ,p_attribute14                  =>p_rec.attribute14
   ,p_attribute15                  =>p_rec.attribute15
   ,p_attribute16                  =>p_rec.attribute16
   ,p_attribute17                  =>p_rec.attribute17
   ,p_attribute18                  =>p_rec.attribute18
   ,p_attribute19                  =>p_rec.attribute19
   ,p_attribute20                  =>p_rec.attribute20,
      p_est_information_category           => p_rec.est_information_category,
      p_est_information1                   => p_rec.est_information1,
      p_est_information2                   => p_rec.est_information2,
      p_est_information3                   => p_rec.est_information3,
      p_est_information4                   => p_rec.est_information4,
      p_est_information5                   => p_rec.est_information5,
      p_est_information6                   => p_rec.est_information6,
      p_est_information7                   => p_rec.est_information7,
      p_est_information8                   => p_rec.est_information8,
      p_est_information9                   => p_rec.est_information9,
      p_est_information10                  => p_rec.est_information10,
      p_est_information11                  => p_rec.est_information11,
      p_est_information12                  => p_rec.est_information12,
      p_est_information13                  => p_rec.est_information13,
      p_est_information14                  => p_rec.est_information14,
      p_est_information15                  => p_rec.est_information15,
      p_est_information16                  => p_rec.est_information16,
      p_est_information17                  => p_rec.est_information17,
      p_est_information18                  => p_rec.est_information18,
      p_est_information19                  => p_rec.est_information19,
      p_est_information20                  => p_rec.est_information20
   ,p_object_version_number        =>p_rec.object_version_number
   ,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_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
   ,p_object_version_number_o      =>per_est_shd.g_old_rec.object_version_number
    );

Line: 329

End post_update;

Line: 608

  per_est_bus.update_validate(p_rec);

Line: 612

  pre_update(p_rec);

Line: 616

  update_dml(p_rec);

Line: 620

  post_update(p_rec);