APPS.GHR_PDH_UPD SQL Statements

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

Line: 49

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

Line: 65

  update ghr_pd_routing_history
  set
  pd_routing_history_id             = p_rec.pd_routing_history_id,
  initiator_flag                    = p_rec.initiator_flag,
  requester_flag                    = p_rec.requester_flag,
  approver_flag                     = p_rec.approver_flag,
  reviewer_flag                     = p_rec.reviewer_flag,
  authorizer_flag                   = p_rec.authorizer_flag,
  personnelist_flag                 = p_rec.personnelist_flag,
  approved_flag                     = p_rec.approved_flag,
  user_name                         = p_rec.user_name,
  user_name_employee_id             = p_rec.user_name_employee_id,
  user_name_emp_first_name          = p_rec.user_name_emp_first_name,
  user_name_emp_last_name           = p_rec.user_name_emp_last_name,
  user_name_emp_middle_names        = p_rec.user_name_emp_middle_names,
  action_taken                      = p_rec.action_taken,
  date_notification_sent            = p_rec.date_notification_sent,
  object_version_number             = p_rec.object_version_number
  where pd_routing_history_id = p_rec.pd_routing_history_id;

Line: 102

End update_dml;

Line: 136

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

Line: 144

End pre_update;

Line: 178

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

Line: 188

     ghr_pdh_rku.after_update	(
      p_pd_routing_history_id       =>     p_rec.pd_routing_history_id,
      p_position_description_id     =>     p_rec.position_description_id,
      p_initiator_flag              =>     p_rec.initiator_flag,
      p_requester_flag              =>     p_rec.requester_flag,
      p_approver_flag               =>     p_rec.approver_flag,
      p_personnelist_flag           =>     p_rec.personnelist_flag,
      p_reviewer_flag               =>     p_rec.reviewer_flag,
      p_authorizer_flag             =>     p_rec.authorizer_flag,
      p_approved_flag               =>     p_rec.approved_flag,
      p_user_name                   =>     p_rec.user_name,
      p_user_name_employee_id       =>     p_rec.user_name_employee_id,
      p_user_name_emp_first_name    =>     p_rec.user_name_emp_first_name,
      p_user_name_emp_last_name     =>     p_rec.user_name_emp_last_name,
      p_user_name_emp_middle_names  =>     p_rec.user_name_emp_middle_names,
      p_action_taken                =>     p_rec.action_taken,
      p_groupbox_id                 =>     p_rec.groupbox_id,
      p_routing_list_id             =>     p_rec.routing_list_id,
      p_routing_seq_number          =>     p_rec.routing_seq_number,
      p_date_notification_sent      =>     p_rec.date_notification_sent,
      p_item_key                   =>      p_rec.item_key,
      p_object_version_number       =>     p_rec.object_version_number,
      p_position_description_id_o   =>     ghr_pdh_shd.g_old_rec.position_description_id,
      p_initiator_flag_o            =>     ghr_pdh_shd.g_old_rec.initiator_flag,
      p_requester_flag_o              =>   ghr_pdh_shd.g_old_rec.requester_flag,
      p_approver_flag_o             =>     ghr_pdh_shd.g_old_rec.approver_flag,
      p_personnelist_flag_o         =>     ghr_pdh_shd.g_old_rec.personnelist_flag,
      p_reviewer_flag_o             =>     ghr_pdh_shd.g_old_rec.reviewer_flag,
      p_authorizer_flag_o           =>     ghr_pdh_shd.g_old_rec.authorizer_flag,
      p_approved_flag_o             =>     ghr_pdh_shd.g_old_rec.approved_flag,
      p_user_name_o                 =>     ghr_pdh_shd.g_old_rec.user_name,
      p_user_name_employee_id_o     =>     ghr_pdh_shd.g_old_rec.user_name_employee_id,
      p_user_name_emp_first_name_o  =>     ghr_pdh_shd.g_old_rec.user_name_emp_first_name,
      p_user_name_emp_last_name_o   =>     ghr_pdh_shd.g_old_rec.user_name_emp_last_name,
      p_user_name_emp_middle_names_o=>     ghr_pdh_shd.g_old_rec.user_name_emp_middle_names,
      p_action_taken_o              =>     ghr_pdh_shd.g_old_rec.action_taken,
      p_groupbox_id_o               =>     ghr_pdh_shd.g_old_rec.groupbox_id,
      p_routing_list_id_o           =>     ghr_pdh_shd.g_old_rec.routing_list_id,
      p_routing_seq_number_o        =>     ghr_pdh_shd.g_old_rec.routing_seq_number,
      p_date_notification_sent_o    =>     ghr_pdh_shd.g_old_rec.date_notification_sent,
      p_item_key_o                   =>      ghr_pdh_shd.g_old_rec.item_key,
      p_object_version_number_o     =>     ghr_pdh_shd.g_old_rec.object_version_number );

Line: 240

End post_update;

Line: 434

  ghr_pdh_bus.update_validate(p_rec);

Line: 438

  pre_update(p_rec);

Line: 442

  update_dml(p_rec);

Line: 446

  post_update(p_rec);