APPS.PER_ZA_ASS_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_ass_shd.g_za_rec_type) is
--
  l_proc  varchar2(72) := g_package||'update_dml';

Line: 68

  update per_za_assessments
  set
	assessment_id 		      = p_rec.assessment_id,
  	person_id 				  = p_rec.person_id,
  	level_id				  = p_rec.level_id,
  	name_of_assessor		  = p_rec.name_of_assessor,
  	institution				  = p_rec.institution,
  	credit					  = p_rec.credit,
  	date_of_assessment		  = p_rec.date_of_assessment,
  	final_result			  = p_rec.final_result,
  	assessment_number		  = p_rec.assessment_number,
  	location_where_assessed	  = p_rec.location_where_assessed,
  	field_of_learning		  = p_rec.field_of_learning,
	sub_field				  = p_rec.sub_field,
	assessment_start_date 	  = p_rec.assessment_start_date,
	assessment_end_date 	  = p_rec.assessment_end_date,
	competence_acquired 	  = p_rec.competence_acquired,
	ETQA_name 				  = p_rec.ETQA_name,
	certification_date 		  = p_rec.certification_date,
	certificate_number		  = p_rec.certificate_number,
	accredited_by 			  = p_rec.accredited_by,
	date_of_accreditation     = p_rec.date_of_accreditation,
	certification_expiry_date = p_rec.certification_expiry_date
  where assessment_id 		  = p_rec.assessment_id;

Line: 116

End update_dml;

Line: 150

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

Line: 158

End pre_update;

Line: 192

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

Line: 200

End post_update;

Line: 243

  pre_update(p_rec);

Line: 247

  update_dml(p_rec);

Line: 251

  post_update(p_rec);