APPS.PER_CAG_DEL SQL Statements

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

Line: 53

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

Line: 63

  delete from per_collective_agreements
  where collective_agreement_id = p_rec.collective_agreement_id;

Line: 76

End delete_dml;

Line: 110

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

Line: 118

End pre_delete;

Line: 152

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

Line: 165

    per_cag_rkd.after_delete
     ( p_collective_agreement_id    =>p_rec.collective_agreement_id,
       p_business_group_id          =>per_cag_shd.g_old_rec.business_group_id,
       p_object_version_number      =>per_cag_shd.g_old_rec.object_version_number,
       p_name                       =>per_cag_shd.g_old_rec.name,
       p_status                 =>per_cag_shd.g_old_rec.status,
       p_cag_number                 =>per_cag_shd.g_old_rec.cag_number,
       p_description                =>per_cag_shd.g_old_rec.description,
       p_start_date                 =>per_cag_shd.g_old_rec.start_date,
       p_end_date                   =>per_cag_shd.g_old_rec.end_date,
       p_employer_organization_id   =>per_cag_shd.g_old_rec.employer_organization_id,
       p_employer_signatory         =>per_cag_shd.g_old_rec.employer_signatory,
       p_bargaining_organization_id =>per_cag_shd.g_old_rec.bargaining_organization_id,
       p_bargaining_unit_signatory  =>per_cag_shd.g_old_rec.bargaining_unit_signatory,
       p_jurisdiction               =>per_cag_shd.g_old_rec.jurisdiction,
       p_authorizing_body           =>per_cag_shd.g_old_rec.authorizing_body,
       p_authorized_date            =>per_cag_shd.g_old_rec.authorized_date,
       p_cag_information_category   =>per_cag_shd.g_old_rec.cag_information_category,
       p_cag_information1           =>per_cag_shd.g_old_rec.cag_information1,
       p_cag_information2           =>per_cag_shd.g_old_rec.cag_information2,
       p_cag_information3           =>per_cag_shd.g_old_rec.cag_information3,
       p_cag_information4           =>per_cag_shd.g_old_rec.cag_information4,
       p_cag_information5           =>per_cag_shd.g_old_rec.cag_information5,
       p_cag_information6           =>per_cag_shd.g_old_rec.cag_information6,
       p_cag_information7           =>per_cag_shd.g_old_rec.cag_information7,
       p_cag_information8           =>per_cag_shd.g_old_rec.cag_information8,
       p_cag_information9           =>per_cag_shd.g_old_rec.cag_information9,
       p_cag_information10          =>per_cag_shd.g_old_rec.cag_information10,
       p_cag_information11          =>per_cag_shd.g_old_rec.cag_information11,
       p_cag_information12          =>per_cag_shd.g_old_rec.cag_information12,
       p_cag_information13          =>per_cag_shd.g_old_rec.cag_information13,
       p_cag_information14          =>per_cag_shd.g_old_rec.cag_information14,
       p_cag_information15          =>per_cag_shd.g_old_rec.cag_information15,
       p_cag_information16          =>per_cag_shd.g_old_rec.cag_information16,
       p_cag_information17          =>per_cag_shd.g_old_rec.cag_information17,
       p_cag_information18          =>per_cag_shd.g_old_rec.cag_information18,
       p_cag_information19          =>per_cag_shd.g_old_rec.cag_information19,
       p_cag_information20          =>per_cag_shd.g_old_rec.cag_information20,
       p_attribute_category         =>per_cag_shd.g_old_rec.attribute_category,
       p_attribute1                 =>per_cag_shd.g_old_rec.attribute1,
       p_attribute2                 =>per_cag_shd.g_old_rec.attribute2,
       p_attribute3                 =>per_cag_shd.g_old_rec.attribute3,
       p_attribute4                 =>per_cag_shd.g_old_rec.attribute4,
       p_attribute5                 =>per_cag_shd.g_old_rec.attribute5,
       p_attribute6                 =>per_cag_shd.g_old_rec.attribute6,
       p_attribute7                 =>per_cag_shd.g_old_rec.attribute7,
       p_attribute8                 =>per_cag_shd.g_old_rec.attribute8,
       p_attribute9                 =>per_cag_shd.g_old_rec.attribute9,
       p_attribute10                =>per_cag_shd.g_old_rec.attribute10,
       p_attribute11                =>per_cag_shd.g_old_rec.attribute11,
       p_attribute12                =>per_cag_shd.g_old_rec.attribute12,
       p_attribute13                =>per_cag_shd.g_old_rec.attribute13,
       p_attribute14                =>per_cag_shd.g_old_rec.attribute14,
       p_attribute15                =>per_cag_shd.g_old_rec.attribute15,
       p_attribute16                =>per_cag_shd.g_old_rec.attribute16,
       p_attribute17                =>per_cag_shd.g_old_rec.attribute17,
       p_attribute18                =>per_cag_shd.g_old_rec.attribute18,
       p_attribute19                =>per_cag_shd.g_old_rec.attribute19,
       p_attribute20                =>per_cag_shd.g_old_rec.attribute20
     );

Line: 240

End post_delete;

Line: 265

  per_cag_bus.delete_validate(p_rec);

Line: 269

  pre_delete(p_rec);

Line: 273

  delete_dml(p_rec);

Line: 277

  post_delete(p_rec);