DBA Data[Home] [Help]

APPS.PER_ZA_LSA_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_lsa_shd.g_za_rec_type) is
--
  l_proc  varchar2(72) := g_package||'update_dml';
Line: 68

  update per_za_learnership_agreements
  set
    agreement_id           = p_rec.agreement_id,
	name				   = p_rec.name,
	description			   = p_rec.description,
	agreement_number	   = p_rec.agreement_number,
  	person_id 			   = p_rec.person_id,
	agreement_start_date   = p_rec.agreement_start_date,
	agreement_end_date	   = p_rec.agreement_end_date,
	status				   = p_rec.status,
	seta				   = p_rec.seta,
	probationary_end_date  = p_rec.probationary_end_date,
	terminated_by		   = p_rec.terminated_by,
	learner_type		   = p_rec.learner_type,
	reason_for_termination = p_rec.reason_for_termination,
	actual_end_date		   = p_rec.actual_end_date,
	agreement_hard_copy_id = p_rec.agreement_hard_copy_id
  where agreement_id = p_rec.agreement_id;
Line: 110

End update_dml;
Line: 144

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

End pre_update;
Line: 186

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

End post_update;
Line: 238

  pre_update(p_rec);
Line: 242

  update_dml(p_rec);
Line: 246

  post_update(p_rec);