[Home] [Help]
2759: hr_utility.set_location(l_proc,175);
2760: --
2761: -- Lock the person record in PER_ALL_PEOPLE_F ready for UPDATE at a later point.
2762: -- (Note: This is necessary because calling the table handlers in locking
2763: -- ladder order invokes an error in per_apl_upd.upd due to the person
2764: -- being modified by the per_per_upd.upd table handler.)
2765: per_per_shd.lck
2766: (p_effective_date => l_hire_date
2767: --bug no 5105005
2841: -- Update the application details by calling the upd procedure in the
2842: -- application table handler:
2843: -- Date_end is set to l_hire_date - 1;
2844: --
2845: per_apl_upd.upd
2846: (p_application_id => l_application_id
2847: ,p_date_end => l_hire_date - 1
2848: ,p_object_version_number => l_apl_object_version_number
2849: ,p_effective_date => l_hire_date
4663: ,termination_reason = p_termination_reason
4664: WHERE application_id = l_application.application_id;
4665: /*
4666: this raises error when calling per_apl_bus.chk_date_end
4667: per_apl_upd.upd
4668: (p_application_id => l_application.application_id
4669: ,p_object_version_number => l_application.object_version_number
4670: ,p_effective_date => l_effective_date
4671: ,p_date_end => l_effective_date