DBA Data[Home] [Help]

APPS.GHR_CORR_CANC_SF52 dependencies on GHR_PAR_UPD

Line 5184: ghr_par_upd.upd

5180: end if;
5181: close get_req;
5182: if l_sf52_data.first_noa_id = p_sf52_data.second_noa_id then
5183: hr_utility.set_location( l_proc, 60);
5184: ghr_par_upd.upd
5185: (p_pa_request_id => l_sf52_data.pa_request_id,
5186: p_object_version_number => l_sf52_data.ovn,
5187: p_first_noa_cancel_or_correct => NULL,
5188: p_first_noa_pa_request_id => NULL

Line 5192: ghr_par_upd.upd

5188: p_first_noa_pa_request_id => NULL
5189: );
5190: elsif l_sf52_data.second_noa_id = p_sf52_data.second_noa_id then
5191: hr_utility.set_location( l_proc, 70);
5192: ghr_par_upd.upd
5193: (p_pa_request_id => l_sf52_data.pa_request_id,
5194: p_object_version_number => l_sf52_data.ovn,
5195: p_second_noa_cancel_or_correct => NULL,
5196: p_second_noa_pa_request_id => NULL

Line 6186: ghr_par_upd.upd(

6182:
6183: if l_sf52.first_noa_code = p_sf52_data.second_noa_code then
6184: if l_sf52.first_noa_canc_pa_request_id is not null then
6185: hr_utility.set_location('Reset First_noa_canel_or_correct ' || l_proc , 120);
6186: ghr_par_upd.upd(
6187: p_pa_request_id => l_sf52.pa_request_id
6188: ,p_object_version_number => l_sf52.object_version_number
6189: ,p_first_noa_pa_request_id => l_sf52.first_noa_canc_pa_request_id
6190: ,p_first_noa_cancel_or_correct => ghr_history_api.g_cancel

Line 6197: ghr_par_upd.upd(

6193: end if;
6194: else
6195: if l_sf52.second_noa_canc_pa_request_id is not null then
6196: hr_utility.set_location('Reset Second_noa_canel_or_correct ' || l_proc , 120);
6197: ghr_par_upd.upd(
6198: p_pa_request_id => l_sf52.pa_request_id
6199: ,p_object_version_number => l_sf52.object_version_number
6200: ,p_second_noa_pa_request_id => l_sf52.second_noa_canc_pa_request_id
6201: ,p_second_noa_cancel_or_correct => ghr_history_api.g_cancel

Line 6659: ghr_par_upd.upd(

6655: hr_utility.set_location(' END Update_SF52 for pa_request_id : ' ||
6656: l_sf52_canc.pa_request_id || ' ' || l_proc , 120);
6657:
6658: -- Nullify Second_noa_pa_request_id from Correction SF52 beinf cancelled
6659: ghr_par_upd.upd(
6660: p_pa_request_id => p_corr_sf52_detail.pa_request_id
6661: ,p_object_version_number => l_ovn
6662: ,p_second_noa_pa_request_id => NULL);
6663: