APPS.PQH_RST_DEL SQL Statements

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

Line: 45

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

Line: 55

  delete from pqh_rule_sets
  where rule_set_id = p_rec.rule_set_id;

Line: 68

End delete_dml;

Line: 102

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

Line: 110

End pre_delete;

Line: 144

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

Line: 157

    pqh_rst_rkd.after_delete
      (
  p_rule_set_id                   =>p_rec.rule_set_id
 ,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: 189

End post_delete;

Line: 215

  pqh_rst_bus.delete_validate(p_rec
  ,p_effective_date);

Line: 220

  pre_delete(p_rec);

Line: 224

  delete_dml(p_rec);

Line: 228

  post_delete(
p_effective_date,p_rec);