DBA Data[Home] [Help]

APPS.PQH_RHT_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_rht_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'update_dml';
Line: 62

  update pqh_routing_history
  set
  routing_history_id                = p_rec.routing_history_id,
  approval_cd                       = p_rec.approval_cd,
  comments                          = p_rec.comments,
  forwarded_by_assignment_id        = p_rec.forwarded_by_assignment_id,
  forwarded_by_member_id            = p_rec.forwarded_by_member_id,
  forwarded_by_position_id          = p_rec.forwarded_by_position_id,
  forwarded_by_user_id              = p_rec.forwarded_by_user_id,
  forwarded_by_role_id              = p_rec.forwarded_by_role_id,
  forwarded_to_assignment_id        = p_rec.forwarded_to_assignment_id,
  forwarded_to_member_id            = p_rec.forwarded_to_member_id,
  forwarded_to_position_id          = p_rec.forwarded_to_position_id,
  forwarded_to_user_id              = p_rec.forwarded_to_user_id,
  forwarded_to_role_id              = p_rec.forwarded_to_role_id,
  notification_date                 = p_rec.notification_date,
  pos_structure_version_id          = p_rec.pos_structure_version_id,
  routing_category_id               = p_rec.routing_category_id,
  transaction_category_id           = p_rec.transaction_category_id,
  transaction_id                    = p_rec.transaction_id,
  user_action_cd                    = p_rec.user_action_cd,
  from_range_name                   = p_rec.from_range_name,
  to_range_name                     = p_rec.to_range_name,
  list_range_name                   = p_rec.list_range_name,
  object_version_number             = p_rec.object_version_number
  where routing_history_id = p_rec.routing_history_id;
Line: 107

End update_dml;
Line: 141

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

End pre_update;
Line: 183

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

    pqh_rht_rku.after_update
      (
  p_routing_history_id            =>p_rec.routing_history_id
 ,p_approval_cd                   =>p_rec.approval_cd
 ,p_comments                      =>p_rec.comments
 ,p_forwarded_by_assignment_id    =>p_rec.forwarded_by_assignment_id
 ,p_forwarded_by_member_id        =>p_rec.forwarded_by_member_id
 ,p_forwarded_by_position_id      =>p_rec.forwarded_by_position_id
 ,p_forwarded_by_user_id          =>p_rec.forwarded_by_user_id
 ,p_forwarded_by_role_id          =>p_rec.forwarded_by_role_id
 ,p_forwarded_to_assignment_id    =>p_rec.forwarded_to_assignment_id
 ,p_forwarded_to_member_id        =>p_rec.forwarded_to_member_id
 ,p_forwarded_to_position_id      =>p_rec.forwarded_to_position_id
 ,p_forwarded_to_user_id          =>p_rec.forwarded_to_user_id
 ,p_forwarded_to_role_id          =>p_rec.forwarded_to_role_id
 ,p_notification_date             =>p_rec.notification_date
 ,p_pos_structure_version_id      =>p_rec.pos_structure_version_id
 ,p_routing_category_id           =>p_rec.routing_category_id
 ,p_transaction_category_id       =>p_rec.transaction_category_id
 ,p_transaction_id                =>p_rec.transaction_id
 ,p_user_action_cd                =>p_rec.user_action_cd
 ,p_from_range_name               =>p_rec.from_range_name
 ,p_to_range_name                 =>p_rec.to_range_name
 ,p_list_range_name               =>p_rec.list_range_name
 ,p_object_version_number         =>p_rec.object_version_number
 ,p_effective_date                =>p_effective_date
 ,p_approval_cd_o                 =>pqh_rht_shd.g_old_rec.approval_cd
 ,p_comments_o                    =>pqh_rht_shd.g_old_rec.comments
 ,p_forwarded_by_assignment_id_o  =>pqh_rht_shd.g_old_rec.forwarded_by_assignment_id
 ,p_forwarded_by_member_id_o      =>pqh_rht_shd.g_old_rec.forwarded_by_member_id
 ,p_forwarded_by_position_id_o    =>pqh_rht_shd.g_old_rec.forwarded_by_position_id
 ,p_forwarded_by_user_id_o        =>pqh_rht_shd.g_old_rec.forwarded_by_user_id
 ,p_forwarded_by_role_id_o        =>pqh_rht_shd.g_old_rec.forwarded_by_role_id
 ,p_forwarded_to_assignment_id_o  =>pqh_rht_shd.g_old_rec.forwarded_to_assignment_id
 ,p_forwarded_to_member_id_o      =>pqh_rht_shd.g_old_rec.forwarded_to_member_id
 ,p_forwarded_to_position_id_o    =>pqh_rht_shd.g_old_rec.forwarded_to_position_id
 ,p_forwarded_to_user_id_o        =>pqh_rht_shd.g_old_rec.forwarded_to_user_id
 ,p_forwarded_to_role_id_o        =>pqh_rht_shd.g_old_rec.forwarded_to_role_id
 ,p_notification_date_o           =>pqh_rht_shd.g_old_rec.notification_date
 ,p_pos_structure_version_id_o    =>pqh_rht_shd.g_old_rec.pos_structure_version_id
 ,p_routing_category_id_o         =>pqh_rht_shd.g_old_rec.routing_category_id
 ,p_transaction_category_id_o     =>pqh_rht_shd.g_old_rec.transaction_category_id
 ,p_transaction_id_o              =>pqh_rht_shd.g_old_rec.transaction_id
 ,p_user_action_cd_o              =>pqh_rht_shd.g_old_rec.user_action_cd
 ,p_from_range_name_o             =>pqh_rht_shd.g_old_rec.from_range_name
 ,p_to_range_name_o               =>pqh_rht_shd.g_old_rec.to_range_name
 ,p_list_range_name_o             =>pqh_rht_shd.g_old_rec.list_range_name
 ,p_object_version_number_o       =>pqh_rht_shd.g_old_rec.object_version_number
      );
Line: 260

End post_update;
Line: 437

  pqh_rht_bus.update_validate(p_rec
  ,p_effective_date);
Line: 442

  pre_update(p_rec);
Line: 446

  update_dml(p_rec);
Line: 450

  post_update(
p_effective_date,p_rec);