DBA Data[Home] [Help]

APPS.GHR_CORR_CANC_SF52 dependencies on GHR_PAR_UPD

Line 4842: ghr_par_upd.upd

4838: end if;
4839: close get_req;
4840: if l_sf52_data.first_noa_id = p_sf52_data.second_noa_id then
4841: hr_utility.set_location( l_proc, 60);
4842: ghr_par_upd.upd
4843: (p_pa_request_id => l_sf52_data.pa_request_id,
4844: p_object_version_number => l_sf52_data.ovn,
4845: p_first_noa_cancel_or_correct => NULL,
4846: p_first_noa_pa_request_id => NULL

Line 4850: ghr_par_upd.upd

4846: p_first_noa_pa_request_id => NULL
4847: );
4848: elsif l_sf52_data.second_noa_id = p_sf52_data.second_noa_id then
4849: hr_utility.set_location( l_proc, 70);
4850: ghr_par_upd.upd
4851: (p_pa_request_id => l_sf52_data.pa_request_id,
4852: p_object_version_number => l_sf52_data.ovn,
4853: p_second_noa_cancel_or_correct => NULL,
4854: p_second_noa_pa_request_id => NULL

Line 5833: ghr_par_upd.upd(

5829:
5830: if l_sf52.first_noa_code = p_sf52_data.second_noa_code then
5831: if l_sf52.first_noa_canc_pa_request_id is not null then
5832: hr_utility.set_location('Reset First_noa_canel_or_correct ' || l_proc , 120);
5833: ghr_par_upd.upd(
5834: p_pa_request_id => l_sf52.pa_request_id
5835: ,p_object_version_number => l_sf52.object_version_number
5836: ,p_first_noa_pa_request_id => l_sf52.first_noa_canc_pa_request_id
5837: ,p_first_noa_cancel_or_correct => ghr_history_api.g_cancel

Line 5844: ghr_par_upd.upd(

5840: end if;
5841: else
5842: if l_sf52.second_noa_canc_pa_request_id is not null then
5843: hr_utility.set_location('Reset Second_noa_canel_or_correct ' || l_proc , 120);
5844: ghr_par_upd.upd(
5845: p_pa_request_id => l_sf52.pa_request_id
5846: ,p_object_version_number => l_sf52.object_version_number
5847: ,p_second_noa_pa_request_id => l_sf52.second_noa_canc_pa_request_id
5848: ,p_second_noa_cancel_or_correct => ghr_history_api.g_cancel

Line 6304: ghr_par_upd.upd(

6300: hr_utility.set_location(' END Update_SF52 for pa_request_id : ' ||
6301: l_sf52_canc.pa_request_id || ' ' || l_proc , 120);
6302:
6303: -- Nullify Second_noa_pa_request_id from Correction SF52 beinf cancelled
6304: ghr_par_upd.upd(
6305: p_pa_request_id => p_corr_sf52_detail.pa_request_id
6306: ,p_object_version_number => l_ovn
6307: ,p_second_noa_pa_request_id => NULL);
6308: