APPS.PER_ZA_EQT_INS SQL Statements

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

Line: 53

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

Line: 65

  insert into per_qualification_types
  (	qualification_type_id,
	name,
	category,
	rank,
	attribute_category,
	attribute1,
	attribute2,
	attribute3,
	attribute4,
	attribute5,
	attribute6,
	attribute7,
	attribute8,
	attribute9,
	attribute10,
	attribute11,
	attribute12,
	attribute13,
	attribute14,
	attribute15,
	attribute16,
	attribute17,
	attribute18,
	attribute19,
	attribute20,
	object_version_number
  )
  Values
  (	p_rec.qualification_type_id,
	p_rec.name,
	p_rec.category,
	p_rec.rank,
	p_rec.attribute_category,
	p_rec.attribute1,
	p_rec.attribute2,
	p_rec.attribute3,
	p_rec.attribute4,
	p_rec.attribute5,
	p_rec.attribute6,
	p_rec.attribute7,
	p_rec.attribute8,
	p_rec.attribute9,
	p_rec.attribute10,
	p_rec.attribute11,
	p_rec.attribute12,
	p_rec.attribute13,
	p_rec.attribute14,
	p_rec.attribute15,
	p_rec.attribute16,
	p_rec.attribute17,
	p_rec.attribute18,
	p_rec.attribute19,
	p_rec.attribute20,
	p_rec.object_version_number
  );

Line: 122

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

Line: 149

End insert_dml;

Line: 188

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

Line: 193

    select per_qualification_types_s.nextval
    from   sys.dual;

Line: 206

End pre_insert;

Line: 240

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

Line: 248

End post_insert;

Line: 276

  per_za_eqt_bus.insert_validate(p_rec,p_effective_date);

Line: 280

  pre_insert(p_rec);

Line: 284

  insert_dml(p_rec);

Line: 288

  post_insert(p_rec);