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

Line: 70

  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
  where qualification_type_id = p_rec.qualification_type_id;

Line: 101

    select 1
	into l_dummy
	from per_za_qualification_types
    where qualification_type_id = p_rec.qualification_type_id;

Line: 106

	-- Record exists, can update.
    update per_za_qualification_types
    set nqf_qualification_type  = p_rec.nqf_qualification_type
    where qualification_type_id = p_rec.qualification_type_id;

Line: 114

	  insert into per_za_qualification_types(qualification_type_id,
	  		 	  							 nqf_qualification_type)
									  values(p_rec.qualification_type_id,
									  		 p_rec.nqf_qualification_type);

Line: 144

End update_dml;

Line: 178

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

Line: 186

End pre_update;

Line: 220

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

Line: 228

End post_update;

Line: 432

  per_za_eqt_bus.update_validate(p_rec,p_effective_date);

Line: 436

  pre_update(p_rec);

Line: 440

  update_dml(p_rec);

Line: 444

  post_update(p_rec);