APPS.PQH_RFT_INS SQL Statements

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

Line: 47

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

Line: 68

  insert into pqh_ref_templates
  (	ref_template_id,
	base_template_id,
	parent_template_id,
        reference_type_cd,
	object_version_number
  )
  Values
  (	p_rec.ref_template_id,
	p_rec.base_template_id,
	p_rec.parent_template_id,
        p_rec.reference_type_cd,
	p_rec.object_version_number
  );

Line: 100

End insert_dml;

Line: 139

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

Line: 143

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

Line: 156

End pre_insert;

Line: 190

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

Line: 202

    pqh_rft_rki.after_insert
      (
  p_ref_template_id               =>p_rec.ref_template_id
 ,p_base_template_id              =>p_rec.base_template_id
 ,p_parent_template_id            =>p_rec.parent_template_id
 ,p_reference_type_cd             =>p_rec.reference_type_cd
,p_effective_date                =>p_effective_date
 ,p_object_version_number         =>p_rec.object_version_number
      );

Line: 226

End post_insert;

Line: 244

  pqh_rft_bus.insert_validate(p_rec ,p_effective_date);

Line: 248

  pre_insert(p_rec);

Line: 252

  insert_dml(p_rec);

Line: 256

  post_insert(p_effective_date,p_rec);