APPS.GHR_PDH_DEL SQL Statements

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

Line: 45

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

Line: 55

  delete from ghr_pd_routing_history
  where pd_routing_history_id = p_rec.pd_routing_history_id;

Line: 68

End delete_dml;

Line: 102

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

Line: 110

End pre_delete;

Line: 144

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

Line: 154

     ghr_pdh_rkd.after_delete	(
      p_pd_routing_history_id       =>     p_rec.pd_routing_history_id,
      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: 186

End post_delete;

Line: 221

  ghr_pdh_bus.delete_validate(p_rec);

Line: 225

  pre_delete(p_rec);

Line: 229

  delete_dml(p_rec);

Line: 233

  post_delete(p_rec);