APPS.GHR_PRH_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_prh_shd.g_rec_type) is
--
  l_proc varchar2(72) ;

Line: 53

  l_proc := g_package||'insert_dml';

Line: 61

  insert into ghr_pa_routing_history
     (pa_routing_history_id,
	pa_request_id,
	attachment_modified_flag,
	initiator_flag,
	approver_flag,
	reviewer_flag,
	requester_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,
	notepad,
	action_taken,
	groupbox_id,
	routing_list_id,
      routing_seq_number,
      noa_family_code,
      nature_of_action_id,
      second_nature_of_action_id,
        approval_status,
 	date_notification_sent,
	object_version_number
  )
  Values
  (	p_rec.pa_routing_history_id,
	p_rec.pa_request_id,
	p_rec.attachment_modified_flag,
	p_rec.initiator_flag,
	p_rec.approver_flag,
	p_rec.reviewer_flag,
	p_rec.requester_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.notepad,
	p_rec.action_taken,
	p_rec.groupbox_id,
	p_rec.routing_list_id,
      p_rec.routing_seq_number,
      p_rec.noa_family_code,
      p_rec.nature_of_action_id,
      p_rec.second_nature_of_action_id,
      p_rec.approval_Status,
 	p_rec.date_notification_sent,
	p_rec.object_version_number
  );

Line: 139

End insert_dml;

Line: 178

Procedure pre_insert
	(p_rec  in out NOCOPY ghr_prh_shd.g_rec_type)is
--
  l_proc varchar2(72);

Line: 184

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

Line: 187

  l_proc := g_package||'pre_insert';

Line: 202

End pre_insert;

Line: 239

Procedure post_insert(p_rec in ghr_prh_shd.g_rec_type) is
--
  l_proc varchar2(72) ;

Line: 244

  l_proc := g_package||'post_insert';

Line: 250

     ghr_prh_rki.after_insert	(
      p_pa_routing_history_id      =>     p_rec.pa_routing_history_id,
      p_pa_request_id              =>     p_rec.pa_request_id,
      p_action_taken               =>     p_rec.action_taken,
      p_approved_flag              =>     p_rec.approved_flag,
      p_approver_flag              =>     p_rec.approver_flag,
      p_approval_status            =>     p_rec.approval_status,
      p_attachment_modified_flag   =>     p_rec.attachment_modified_flag,
      p_authorizer_flag            =>     p_rec.authorizer_flag,
      p_date_notification_sent     =>     p_rec.date_notification_sent,
      p_groupbox_id                =>     p_rec.groupbox_id,
      p_initiator_flag             =>     p_rec.initiator_flag,
      p_nature_of_action_id        =>     p_rec.nature_of_action_id,
      p_noa_family_code            =>     p_rec.noa_family_code,
      p_notepad                    =>     p_rec.notepad,
      p_personnelist_flag          =>     p_rec.personnelist_flag,
      p_requester_flag             =>     p_rec.requester_flag,
      p_reviewer_flag              =>     p_rec.reviewer_flag,
      p_routing_list_id            =>     p_rec.routing_list_id,
      p_routing_seq_number         =>     p_rec.routing_seq_number,
      p_second_nature_of_action_id =>     p_rec.second_nature_of_action_id,
      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_object_version_number      =>     p_rec.object_version_number
      );

Line: 289

End post_insert;

Line: 319

  ghr_prh_bus.insert_validate(p_rec);

Line: 324

  pre_insert(p_rec);

Line: 328

  insert_dml(p_rec);

Line: 332

  post_insert(p_rec);