APPS.PQH_RST_UPD SQL Statements

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

Line: 48

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

Line: 65

  update pqh_rule_sets
  set
  business_group_id                 = p_rec.business_group_id,
  rule_set_id                       = p_rec.rule_set_id,
  rule_set_name                     = p_rec.rule_set_name,
  organization_structure_id         = p_rec.organization_structure_id,
  organization_id                   = p_rec.organization_id,
  referenced_rule_set_id            = p_rec.referenced_rule_set_id,
  rule_level_cd                     = p_rec.rule_level_cd,
  object_version_number             = p_rec.object_version_number,
  short_name                        = p_rec.short_name,
  rule_applicability		    = p_rec.rule_applicability,
  rule_category		  	    = p_rec.rule_category,
  starting_organization_id	    = p_rec.starting_organization_id,
  seeded_rule_flag		    = p_rec.seeded_rule_flag,
  status                            = p_rec.status
  where rule_set_id = p_rec.rule_set_id;

Line: 101

End update_dml;

Line: 135

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

Line: 143

End pre_update;

Line: 177

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

Line: 190

    pqh_rst_rku.after_update
      (
  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
 ,p_business_group_id_o           =>pqh_rst_shd.g_old_rec.business_group_id
 ,p_rule_set_name_o               =>pqh_rst_shd.g_old_rec.rule_set_name
 ,p_organization_structure_id_o   =>pqh_rst_shd.g_old_rec.organization_structure_id
 ,p_organization_id_o             =>pqh_rst_shd.g_old_rec.organization_id
 ,p_referenced_rule_set_id_o      =>pqh_rst_shd.g_old_rec.referenced_rule_set_id
 ,p_rule_level_cd_o               =>pqh_rst_shd.g_old_rec.rule_level_cd
 ,p_object_version_number_o       =>pqh_rst_shd.g_old_rec.object_version_number
 ,p_short_name_o                  =>pqh_rst_shd.g_old_rec.short_name
 ,p_rule_applicability_o	  =>pqh_rst_shd.g_old_rec.rule_applicability
 ,p_rule_category_o		  =>pqh_rst_shd.g_old_rec.rule_category
 ,p_starting_organization_id_o	  =>pqh_rst_shd.g_old_rec.starting_organization_id
 ,p_seeded_rule_flag_o		  =>pqh_rst_shd.g_old_rec.seeded_rule_flag
 ,p_status_o                      =>pqh_rst_shd.g_old_rec.status
      );

Line: 236

End post_update;

Line: 376

  pqh_rst_bus.update_validate(p_rec
  ,p_effective_date);

Line: 381

  pre_update(p_rec);

Line: 385

  update_dml(p_rec);

Line: 389

  post_update(
p_effective_date,p_rec);