The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure update_dml(p_rec in out NOCOPY ghr_prh_shd.g_rec_type) is
--
l_proc varchar2(72) ;
l_proc := g_package||'update_dml';
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;
End update_dml;
Procedure pre_update(p_rec in ghr_prh_shd.g_rec_type) is
--
l_proc varchar2(72) ;
l_proc := g_package||'pre_update';
End pre_update;
Procedure post_update(p_rec in ghr_prh_shd.g_rec_type) is
--
l_proc varchar2(72);
l_proc := g_package||'post_update';
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
);
End post_update;
ghr_prh_bus.update_validate(p_rec);
pre_update(p_rec);
update_dml(p_rec);
post_update(p_rec);