APPS.GHR_PDH_INS SQL Statements

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

Line: 47

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

Line: 59

  insert into ghr_pd_routing_history
     (pd_routing_history_id,
	position_description_id,
	initiator_flag,
	requester_flag,
	approver_flag,
	reviewer_flag,
      authorizer_flag,
      personnelist_flag,
	approved_flag,
    	user_name,
	user_name_employee_id,
     	user_name_emp_first_name,
	user_name_emp_last_name,
	user_name_emp_middle_names,
	action_taken,
	groupbox_id,
	routing_list_id,
      routing_seq_number,
 	date_notification_sent,
	object_version_number,
        item_key
  )
  Values
  (	p_rec.pd_routing_history_id,
	p_rec.position_description_id,
	p_rec.initiator_flag,
	p_rec.requester_flag,
	p_rec.approver_flag,
	p_rec.reviewer_flag,
      p_rec.authorizer_flag,
      p_rec.personnelist_flag,
	p_rec.approved_flag,
      p_rec.user_name,
	p_rec.user_name_employee_id,
     	p_rec.user_name_emp_first_name,
	p_rec.user_name_emp_last_name,
	p_rec.user_name_emp_middle_names,
	p_rec.action_taken,
	p_rec.groupbox_id,
	p_rec.routing_list_id,
      p_rec.routing_seq_number,
 	p_rec.date_notification_sent,
	p_rec.object_version_number,
        p_rec.item_key
  );

Line: 123

End insert_dml;

Line: 162

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

Line: 167

  Cursor C_Sel1 is select ghr_pd_routing_history_s.nextval from sys.dual;

Line: 179

End pre_insert;

Line: 216

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

Line: 226

     ghr_pdh_rki.after_insert   (
      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);

Line: 259

End post_insert;

Line: 286

  ghr_pdh_bus.insert_validate(p_rec);

Line: 291

  pre_insert(p_rec);

Line: 295

  insert_dml(p_rec);

Line: 299

  post_insert(p_rec);