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

Line: 76

  insert into pqh_rule_sets
  (	business_group_id,
	rule_set_id,
	rule_set_name,
	organization_structure_id,
	organization_id,
	referenced_rule_set_id,
	rule_level_cd,
	object_version_number,
	short_name,
	rule_applicability,
	rule_category,
  	starting_organization_id,
  	seeded_rule_flag,
        status
  )
  Values
  (	p_rec.business_group_id,
	p_rec.rule_set_id,
	p_rec.rule_set_name,
	p_rec.organization_structure_id,
	p_rec.organization_id,
	p_rec.referenced_rule_set_id,
	p_rec.rule_level_cd,
	p_rec.object_version_number,
	p_rec.short_name,
	p_rec.rule_applicability,
	p_rec.rule_category,
	p_rec.starting_organization_id,
	p_rec.seeded_rule_flag,
        p_rec.status
  );

Line: 126

End insert_dml;

Line: 165

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

Line: 170

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

Line: 181

End pre_insert;

Line: 215

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

Line: 228

    pqh_rst_rki.after_insert
      (
  p_business_group_id             =>p_rec.business_group_id
 ,p_rule_set_id                   =>p_rec.rule_set_id
 ,p_rule_set_name                 =>p_rec.rule_set_name
 ,p_organization_structure_id     =>p_rec.organization_structure_id
 ,p_organization_id               =>p_rec.organization_id
 ,p_referenced_rule_set_id        =>p_rec.referenced_rule_set_id
 ,p_rule_level_cd                 =>p_rec.rule_level_cd
 ,p_object_version_number         =>p_rec.object_version_number
 ,p_short_name                    =>p_rec.short_name
 ,p_rule_applicability		  =>p_rec.rule_applicability
 ,p_rule_category		  =>p_rec.rule_category
 ,p_starting_organization_id	  =>p_rec.starting_organization_id
 ,p_seeded_rule_flag		  =>p_rec.seeded_rule_flag
 ,p_status                     	  =>p_rec.status
 ,p_effective_date                =>p_effective_date
      );

Line: 261

End post_insert;

Line: 279

  pqh_rst_bus.insert_validate(p_rec
  ,p_effective_date);

Line: 284

  pre_insert(p_rec);

Line: 288

  insert_dml(p_rec);

Line: 292

  post_insert(
p_effective_date,p_rec);