3471: trunc(p_effective_date) > sysdate then
3472: l_action_taken := 'FUTURE_ACTION';
3473: End if;
3474:
3475: ghr_prh_upd.upd
3476: (
3477: p_pa_routing_history_id => l_u_pa_routing_history_id,
3478: p_attachment_modified_flag => nvl(p_u_attachment_modified_flag,'N'),
3479: p_initiator_flag => nvl(l_initiator_flag,'N'),
4667:
4668: hr_utility.set_location('before upd to prh',1);
4669: hr_utility.set_location('emp id ' || to_char(l_user_name_employee_id),1);
4670:
4671: ghr_prh_upd.upd
4672: (p_pa_routing_history_id => l_pa_routing_history_id
4673: ,p_user_name => l_user_name
4674: ,p_initiator_flag => nvl(l_initiator_flag,'N')
4675: ,p_requester_flag => nvl(l_requester_flag,'N')