4228: if l_old_leaving_reason = 'R' then
4229: --
4230: hr_utility.set_location(l_proc,66);
4231: --
4232: hr_per_type_usage_internal.cancel_person_type_usage
4233: (p_effective_date => p_actual_termination_date+1
4234: ,p_person_id => p_person_id
4235: ,p_system_person_type => 'RETIREE');
4236: -- end if; fix Bug 2048953
4239: -- aswell along with RETIREE
4240: --
4241: hr_utility.set_location(l_proc,67);
4242: --
4243: hr_per_type_usage_internal.cancel_person_type_usage
4244: (p_effective_date => p_actual_termination_date+1
4245: ,p_person_id => p_person_id
4246: ,p_system_person_type => 'EX_EMP');
4247: --
4248: -- End of Bug 5507290.
4249: --
4250: else
4251: hr_utility.set_location('REV_TERM '||l_proc,68);
4252: hr_per_type_usage_internal.cancel_person_type_usage
4253: (p_effective_date => p_actual_termination_date+1
4254: ,p_person_id => p_person_id
4255: ,p_system_person_type => 'EX_EMP');
4256: end if;