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

Line: 55

  l_proc := g_package||'update_dml';

Line: 68

  update ghr_pa_routing_history
  set
  pa_routing_history_id             = p_rec.pa_routing_history_id,
  attachment_modified_flag          = p_rec.attachment_modified_flag,
  initiator_flag                    = p_rec.initiator_flag,
  approver_flag                     = p_rec.approver_flag,
  reviewer_flag                     = p_rec.reviewer_flag,
  requester_flag                    = p_rec.requester_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,
  notepad          			= p_rec.notepad,
  action_taken                      = p_rec.action_taken,
  groupbox_id                       = p_rec.groupbox_id,
  noa_family_code                   = p_rec.noa_family_code,
  nature_of_action_id               = p_rec.nature_of_action_id,
  second_nature_of_action_id        = p_rec.second_nature_of_action_id,
  approval_status                   = p_rec.approval_status,
  date_notification_sent            = p_rec.date_notification_sent,
  object_version_number             = p_rec.object_version_number
  where pa_routing_history_id = p_rec.pa_routing_history_id;

Line: 116

End update_dml;

Line: 150

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

Line: 155

  l_proc  := g_package||'pre_update';

Line: 159

End pre_update;

Line: 193

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

Line: 198

  l_proc  := g_package||'post_update';

Line: 204

     ghr_prh_rku.after_update	(
      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,
      p_pa_request_id_o            => ghr_prh_shd.g_old_rec.pa_request_id,
      p_action_taken_o             => ghr_prh_shd.g_old_rec.action_taken,
      p_approved_flag_o            => ghr_prh_shd.g_old_rec.approved_flag,
      p_approver_flag_o            => ghr_prh_shd.g_old_rec.approver_flag,
      p_approval_status_o          => ghr_prh_shd.g_old_rec.approval_status,
      p_attachment_modified_flag_o => ghr_prh_shd.g_old_rec.attachment_modified_flag,
      p_authorizer_flag_o          => ghr_prh_shd.g_old_rec.authorizer_flag,
      p_date_notification_sent_o   => ghr_prh_shd.g_old_rec.date_notification_sent,
      p_groupbox_id_o              => ghr_prh_shd.g_old_rec.groupbox_id,
      p_initiator_flag_o           => ghr_prh_shd.g_old_rec.initiator_flag,
      p_nature_of_action_id_o      => ghr_prh_shd.g_old_rec.nature_of_action_id,
      p_noa_family_code_o          => ghr_prh_shd.g_old_rec.noa_family_code,
      p_notepad_o                  => ghr_prh_shd.g_old_rec.notepad,
      p_personnelist_flag_o        => ghr_prh_shd.g_old_rec.personnelist_flag,
      p_requester_flag_o           => ghr_prh_shd.g_old_rec.requester_flag,
      p_reviewer_flag_o            => ghr_prh_shd.g_old_rec.reviewer_flag,
      p_routing_list_id_o          => ghr_prh_shd.g_old_rec.routing_list_id,
      p_routing_seq_number_o       => ghr_prh_shd.g_old_rec.routing_seq_number,
      p_second_nature_of_action_id_o =>
                                   ghr_prh_shd.g_old_rec.second_nature_of_action_id,
      p_user_name_o                => ghr_prh_shd.g_old_rec.user_name,
      p_user_name_employee_id_o    => ghr_prh_shd.g_old_rec.user_name_employee_id,
      p_user_name_emp_first_name_o => ghr_prh_shd.g_old_rec.user_name_emp_first_name,
      p_user_name_emp_last_name_o  => ghr_prh_shd.g_old_rec.user_name_emp_last_name,
      p_user_name_emp_middle_names_o =>
                                   ghr_prh_shd.g_old_rec.user_name_emp_middle_names,
      p_object_version_number_o    => ghr_prh_shd.g_old_rec.object_version_number
      );

Line: 270

End post_update;

Line: 478

  ghr_prh_bus.update_validate(p_rec);

Line: 482

  pre_update(p_rec);

Line: 486

  update_dml(p_rec);

Line: 490

  post_update(p_rec);