APPS.PER_CAG_UPD SQL Statements

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

Line: 56

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

Line: 70

  update per_collective_agreements
  set
  collective_agreement_id           = p_rec.collective_agreement_id,
  business_group_id                 = p_rec.business_group_id,
  object_version_number             = p_rec.object_version_number,
  name                              = p_rec.name,
  status		            	    = p_rec.status,
  cag_number                        = p_rec.cag_number,
  description                       = p_rec.description,
  start_date                        = p_rec.start_date,
  end_date                          = p_rec.end_date,
  employer_organization_id          = p_rec.employer_organization_id,
  employer_signatory                = p_rec.employer_signatory,
  bargaining_organization_id        = p_rec.bargaining_organization_id,
  bargaining_unit_signatory         = p_rec.bargaining_unit_signatory,
  jurisdiction                      = p_rec.jurisdiction,
  authorizing_body                  = p_rec.authorizing_body,
  authorized_date                   = p_rec.authorized_date,
  cag_information_category          = p_rec.cag_information_category,
  cag_information1                  = p_rec.cag_information1,
  cag_information2                  = p_rec.cag_information2,
  cag_information3                  = p_rec.cag_information3,
  cag_information4                  = p_rec.cag_information4,
  cag_information5                  = p_rec.cag_information5,
  cag_information6                  = p_rec.cag_information6,
  cag_information7                  = p_rec.cag_information7,
  cag_information8                  = p_rec.cag_information8,
  cag_information9                  = p_rec.cag_information9,
  cag_information10                 = p_rec.cag_information10,
  cag_information11                 = p_rec.cag_information11,
  cag_information12                 = p_rec.cag_information12,
  cag_information13                 = p_rec.cag_information13,
  cag_information14                 = p_rec.cag_information14,
  cag_information15                 = p_rec.cag_information15,
  cag_information16                 = p_rec.cag_information16,
  cag_information17                 = p_rec.cag_information17,
  cag_information18                 = p_rec.cag_information18,
  cag_information19                 = p_rec.cag_information19,
  cag_information20                 = p_rec.cag_information20,
  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
  where collective_agreement_id = p_rec.collective_agreement_id;

Line: 150

End update_dml;

Line: 184

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

Line: 192

End pre_update;

Line: 226

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

Line: 239

    per_cag_rku.after_update
     ( p_collective_agreement_id      =>p_rec.collective_agreement_id,
       p_business_group_id            =>p_rec.business_group_id,
       p_object_version_number        =>p_rec.object_version_number,
       p_name                         =>p_rec.name,
       p_status                       =>p_rec.status,
       p_cag_number                   =>p_rec.cag_number,
       p_description                  =>p_rec.description,
       p_start_date                   =>p_rec.start_date,
       p_end_date                     =>p_rec.end_date,
       p_employer_organization_id     =>p_rec.employer_organization_id,
       p_employer_signatory           =>p_rec.employer_signatory,
       p_bargaining_organization_id   =>p_rec.bargaining_organization_id,
       p_bargaining_unit_signatory    =>p_rec.bargaining_unit_signatory,
       p_jurisdiction                 =>p_rec.jurisdiction,
       p_authorizing_body             =>p_rec.authorizing_body,
       p_authorized_date              =>p_rec.authorized_date,
       p_cag_information_category     =>p_rec.cag_information_category,
       p_cag_information1             =>p_rec.cag_information1,
       p_cag_information2             =>p_rec.cag_information2,
       p_cag_information3             =>p_rec.cag_information3,
       p_cag_information4             =>p_rec.cag_information4,
       p_cag_information5             =>p_rec.cag_information5,
       p_cag_information6             =>p_rec.cag_information6,
       p_cag_information7             =>p_rec.cag_information7,
       p_cag_information8             =>p_rec.cag_information8,
       p_cag_information9             =>p_rec.cag_information9,
       p_cag_information10            =>p_rec.cag_information10,
       p_cag_information11            =>p_rec.cag_information11,
       p_cag_information12            =>p_rec.cag_information12,
       p_cag_information13            =>p_rec.cag_information13,
       p_cag_information14            =>p_rec.cag_information14,
       p_cag_information15            =>p_rec.cag_information15,
       p_cag_information16            =>p_rec.cag_information16,
       p_cag_information17            =>p_rec.cag_information17,
       p_cag_information18            =>p_rec.cag_information18,
       p_cag_information19            =>p_rec.cag_information19,
       p_cag_information20            =>p_rec.cag_information20,
       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_business_group_id_o          =>per_cag_shd.g_old_rec.business_group_id,
       p_object_version_number_o      =>per_cag_shd.g_old_rec.object_version_number,
       p_name_o                       =>per_cag_shd.g_old_rec.name,
       p_status_o                     =>per_cag_shd.g_old_rec.status,
       p_cag_number_o                 =>per_cag_shd.g_old_rec.cag_number,
       p_description_o                =>per_cag_shd.g_old_rec.description,
       p_start_date_o                 =>per_cag_shd.g_old_rec.start_date,
       p_end_date_o                   =>per_cag_shd.g_old_rec.end_date,
       p_employer_organization_id_o   =>per_cag_shd.g_old_rec.employer_organization_id,
       p_employer_signatory_o         =>per_cag_shd.g_old_rec.employer_signatory,
       p_bargaining_organization_id_o =>per_cag_shd.g_old_rec.bargaining_organization_id,
       p_bargaining_unit_signatory_o  =>per_cag_shd.g_old_rec.bargaining_unit_signatory,
       p_jurisdiction_o               =>per_cag_shd.g_old_rec.jurisdiction,
       p_authorizing_body_o           =>per_cag_shd.g_old_rec.authorizing_body,
       p_authorized_date_o            =>per_cag_shd.g_old_rec.authorized_date,
       p_cag_information_category_o   =>per_cag_shd.g_old_rec.cag_information_category,
       p_cag_information1_o           =>per_cag_shd.g_old_rec.cag_information1,
       p_cag_information2_o           =>per_cag_shd.g_old_rec.cag_information2,
       p_cag_information3_o           =>per_cag_shd.g_old_rec.cag_information3,
       p_cag_information4_o           =>per_cag_shd.g_old_rec.cag_information4,
       p_cag_information5_o           =>per_cag_shd.g_old_rec.cag_information5,
       p_cag_information6_o           =>per_cag_shd.g_old_rec.cag_information6,
       p_cag_information7_o           =>per_cag_shd.g_old_rec.cag_information7,
       p_cag_information8_o           =>per_cag_shd.g_old_rec.cag_information8,
       p_cag_information9_o           =>per_cag_shd.g_old_rec.cag_information9,
       p_cag_information10_o          =>per_cag_shd.g_old_rec.cag_information10,
       p_cag_information11_o          =>per_cag_shd.g_old_rec.cag_information11,
       p_cag_information12_o          =>per_cag_shd.g_old_rec.cag_information12,
       p_cag_information13_o          =>per_cag_shd.g_old_rec.cag_information13,
       p_cag_information14_o          =>per_cag_shd.g_old_rec.cag_information14,
       p_cag_information15_o          =>per_cag_shd.g_old_rec.cag_information15,
       p_cag_information16_o          =>per_cag_shd.g_old_rec.cag_information16,
       p_cag_information17_o          =>per_cag_shd.g_old_rec.cag_information17,
       p_cag_information18_o          =>per_cag_shd.g_old_rec.cag_information18,
       p_cag_information19_o          =>per_cag_shd.g_old_rec.cag_information19,
       p_cag_information20_o          =>per_cag_shd.g_old_rec.cag_information20,
       p_attribute_category_o         =>per_cag_shd.g_old_rec.attribute_category,
       p_attribute1_o                 =>per_cag_shd.g_old_rec.attribute1,
       p_attribute2_o                 =>per_cag_shd.g_old_rec.attribute2,
       p_attribute3_o                 =>per_cag_shd.g_old_rec.attribute3,
       p_attribute4_o                 =>per_cag_shd.g_old_rec.attribute4,
       p_attribute5_o                 =>per_cag_shd.g_old_rec.attribute5,
       p_attribute6_o                 =>per_cag_shd.g_old_rec.attribute6,
       p_attribute7_o                 =>per_cag_shd.g_old_rec.attribute7,
       p_attribute8_o                 =>per_cag_shd.g_old_rec.attribute8,
       p_attribute9_o                 =>per_cag_shd.g_old_rec.attribute9,
       p_attribute10_o                =>per_cag_shd.g_old_rec.attribute10,
       p_attribute11_o                =>per_cag_shd.g_old_rec.attribute11,
       p_attribute12_o                =>per_cag_shd.g_old_rec.attribute12,
       p_attribute13_o                =>per_cag_shd.g_old_rec.attribute13,
       p_attribute14_o                =>per_cag_shd.g_old_rec.attribute14,
       p_attribute15_o                =>per_cag_shd.g_old_rec.attribute15,
       p_attribute16_o                =>per_cag_shd.g_old_rec.attribute16,
       p_attribute17_o                =>per_cag_shd.g_old_rec.attribute17,
       p_attribute18_o                =>per_cag_shd.g_old_rec.attribute18,
       p_attribute19_o                =>per_cag_shd.g_old_rec.attribute19,
       p_attribute20_o                =>per_cag_shd.g_old_rec.attribute20
     );

Line: 372

End post_update;

Line: 689

  per_cag_bus.update_validate(p_rec);

Line: 693

  pre_update(p_rec);

Line: 697

  update_dml(p_rec);

Line: 701

  post_update(p_rec);