[Home] [Help]
2191: hr_utility.set_location(l_proc,170);
2192: --
2193: -- Lock the person record in PER_ALL_PEOPLE_F ready for UPDATE at a later point.
2194: -- (Note: This is necessary because calling the table handlers in locking
2195: -- ladder order invokes an error in per_apl_upd.upd due to the person
2196: -- being modified by the per_per_upd.upd table handler.)
2197: per_per_shd.lck
2198: (p_effective_date => l_hire_date
2199: --bug no 5105005
2273: -- Update the application details by calling the upd procedure in the
2274: -- application table handler:
2275: -- Date_end is set to l_hire_date - 1;
2276: --
2277: per_apl_upd.upd
2278: (p_application_id => l_application_id
2279: ,p_date_end => l_hire_date - 1
2280: ,p_object_version_number => l_apl_object_version_number
2281: ,p_effective_date => l_hire_date
3590: ,termination_reason = p_termination_reason
3591: WHERE application_id = l_application.application_id;
3592: /*
3593: this raises error when calling per_apl_bus.chk_date_end
3594: per_apl_upd.upd
3595: (p_application_id => l_application.application_id
3596: ,p_object_version_number => l_application.object_version_number
3597: ,p_effective_date => l_effective_date
3598: ,p_date_end => l_effective_date