DBA Data[Home] [Help]

APPS.PER_EQT_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_eqt_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'update_dml';
Line: 72

  update per_qualification_types
  set
  qualification_type_id       = p_rec.qualification_type_id,
  name                        = p_rec.name,
  category                    = p_rec.category,
  rank                        = p_rec.rank,
  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,
  object_version_number       = p_rec.object_version_number,
  information_category        = p_rec.information_category,
  information1	              = p_rec.information1,
  information2	              = p_rec.information2,
  information3	    	      = p_rec.information3,
  information4	     	      = p_rec.information4,
  information5	     	      = p_rec.information5,
  information6	      	      = p_rec.information6,
  information7	    	      = p_rec.information7,
  information8	     	      = p_rec.information8,
  information9	     	      = p_rec.information9,
  information10	     	      = p_rec.information10,
  information11	     	      = p_rec.information11,
  information12	    	      = p_rec.information12,
  information13	    	      = p_rec.information13,
  information14	    	      = p_rec.information14,
  information15	   	      = p_rec.information15,
  information16	   	      = p_rec.information16,
  information17	   	      = p_rec.information17,
  information18	     	      = p_rec.information18,
  information19	    	      = p_rec.information19,
  information20	     	      = p_rec.information20,
  information21	     	      = p_rec.information21,
  information22	    	      = p_rec.information22,
  information23	    	      = p_rec.information23,
  information24	    	      = p_rec.information24,
  information25	   	      = p_rec.information25,
  information26	   	      = p_rec.information26,
  information27	   	      = p_rec.information27,
  information28	     	      = p_rec.information28,
  information29	    	      = p_rec.information29,
  information30	     	      = p_rec.information30
 ,qual_framework_id           = p_rec.qual_framework_id
 ,qualification_type          = p_rec.qualification_type
 ,credit_type                 = p_rec.credit_type
 ,credits                     = p_rec.credits
 ,level_type                  = p_rec.level_type
 ,level_number                = p_rec.level_number
 ,field                       = p_rec.field
 ,sub_field                   = p_rec.sub_field
 ,provider                    = p_rec.provider
 ,qa_organization             = p_rec.qa_organization
  where qualification_type_id = p_rec.qualification_type_id;
Line: 166

End update_dml;
Line: 200

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

End pre_update;
Line: 242

Procedure post_update(p_rec in per_eqt_shd.g_rec_type
                     ,p_effective_date in date
                      ) is
--
  l_proc  varchar2(72) := g_package||'post_update';
Line: 257

    per_eqt_rku.after_update
    (p_qualification_type_id  => p_rec.qualification_type_id
    ,p_name                   => p_rec.name
    ,p_category               => p_rec.category
    ,p_rank                   => p_rec.rank
    ,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_object_version_number  => p_rec.object_version_number
    ,p_effective_date         => p_effective_date
    ,p_information_category   => p_rec.information_category
    ,p_information1	      => p_rec.information1
    ,p_information2	      => p_rec.information2
    ,p_information3	      => p_rec.information3
    ,p_information4	      => p_rec.information4
    ,p_information5	      => p_rec.information5
    ,p_information6	      => p_rec.information6
    ,p_information7	      => p_rec.information7
    ,p_information8	      => p_rec.information8
    ,p_information9	      => p_rec.information9
    ,p_information10          => p_rec.information10
    ,p_information11          => p_rec.information11
    ,p_information12          => p_rec.information12
    ,p_information13          => p_rec.information13
    ,p_information14          => p_rec.information14
    ,p_information15          => p_rec.information15
    ,p_information16          => p_rec.information16
    ,p_information17          => p_rec.information17
    ,p_information18          => p_rec.information18
    ,p_information19          => p_rec.information19
    ,p_information20          => p_rec.information20
    ,p_information21          => p_rec.information21
    ,p_information22          => p_rec.information22
    ,p_information23          => p_rec.information23
    ,p_information24          => p_rec.information24
    ,p_information25          => p_rec.information25
    ,p_information26          => p_rec.information26
    ,p_information27          => p_rec.information27
    ,p_information28          => p_rec.information28
    ,p_information29          => p_rec.information29
    ,p_information30          => p_rec.information30
    -- BUG3356369
    ,p_qual_framework_id      => p_rec.qual_framework_id
    ,p_qualification_type     => p_rec.qualification_type
    ,p_credit_type            => p_rec.credit_type
    ,p_credits                => p_rec.credits
    ,p_level_type             => p_rec.level_type
    ,p_level_number           => p_rec.level_number
    ,p_field                  => p_rec.field
    ,p_sub_field              => p_rec.sub_field
    ,p_provider               => p_rec.provider
    ,p_qa_organization        => p_rec.qa_organization
    ,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
    ,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: 403

End post_update;
Line: 774

  per_eqt_bus.update_validate(p_rec, p_effective_date);
Line: 778

  pre_update(p_rec);
Line: 782

  update_dml(p_rec);
Line: 786

  post_update(p_rec
             ,p_effective_date
              );