APPS.PER_GRA_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_gra_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'insert_dml';

Line: 65

  insert into per_cagr_grades
  (	cagr_grade_id,
	cagr_grade_structure_id,
	cagr_grade_def_id,
	sequence,
	object_version_number
  )
  Values
  (	p_rec.cagr_grade_id,
	p_rec.cagr_grade_structure_id,
	p_rec.cagr_grade_def_id,
	p_rec.sequence,
	p_rec.object_version_number
  );

Line: 102

End insert_dml;

Line: 141

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

Line: 146

  Cursor C_Sel1 is select per_cagr_grades_s.nextval from sys.dual;

Line: 159

End pre_insert;

Line: 193

Procedure post_insert(p_rec in per_gra_shd.g_rec_type
		     ,p_effective_date   in date) is
--
  l_proc  varchar2(72) := g_package||'post_insert';

Line: 206

    per_gra_rki.after_insert
      (
  p_cagr_grade_id                 =>p_rec.cagr_grade_id
 ,p_cagr_grade_structure_id       =>p_rec.cagr_grade_structure_id
 ,p_cagr_grade_def_id             =>p_rec.cagr_grade_def_id
 ,p_sequence                      =>p_rec.sequence
 ,p_object_version_number         =>p_rec.object_version_number
 ,p_effective_date		  =>p_effective_date
      );

Line: 230

End post_insert;

Line: 248

  per_gra_bus.insert_validate(p_rec	=>  p_rec,
			      p_effective_date   =>p_effective_date);

Line: 253

  pre_insert(p_rec => p_rec,
	     p_effective_date   =>p_effective_date);

Line: 258

  insert_dml(p_rec => p_rec);

Line: 262

  post_insert(p_rec => p_rec,
    	      p_effective_date   =>p_effective_date);