DBA Data[Home] [Help]

APPS.PER_ZA_AO_ASS_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_ao_ass_shd.g_za_rec_type) is
--
  l_proc  varchar2(72) := g_package||'insert_dml';
Line: 65

  insert into per_za_areas_of_assessment(
    area_of_assessment_id,
  	assessment_id,
	area_of_assessment,
	assessment_result,
	assessment_criteria
  )
  Values
  (
    p_rec.area_of_assessment_id,
	p_rec.assessment_id,
	p_rec.area_of_assessment,
	p_rec.assessment_result,
	p_rec.assessment_criteria
  );
Line: 103

End insert_dml;
Line: 137

Procedure post_insert(p_rec in per_za_ao_ass_shd.g_za_rec_type) is
--
  l_proc  varchar2(72) := g_package||'post_insert';
Line: 145

End post_insert;
Line: 173

  insert_dml(p_rec);
Line: 177

  post_insert(p_rec);