DBA Data[Home] [Help]

APPS.GHR_SF52_UPDATE dependencies on GHR_HISTORY_FETCH

Line 859: l_prev_info_type := Ghr_History_Fetch.g_info_type;

855: loop
856: -- second correction
857: if rec_chk_dual.mass_action_id < p_imm_pa_request_rec.pa_request_id
858: and p_imm_pa_request_rec.first_noa_code = rec_root_details.second_noa_code then
859: l_prev_info_type := Ghr_History_Fetch.g_info_type;
860: -- Assigned to NULL before fetching as by this it is fetching for latest effective date
861: Ghr_History_Fetch.g_info_type := NULL;
862: Ghr_History_Fetch.Fetch_ASGEI_prior_root_sf50
863: (

Line 861: Ghr_History_Fetch.g_info_type := NULL;

857: if rec_chk_dual.mass_action_id < p_imm_pa_request_rec.pa_request_id
858: and p_imm_pa_request_rec.first_noa_code = rec_root_details.second_noa_code then
859: l_prev_info_type := Ghr_History_Fetch.g_info_type;
860: -- Assigned to NULL before fetching as by this it is fetching for latest effective date
861: Ghr_History_Fetch.g_info_type := NULL;
862: Ghr_History_Fetch.Fetch_ASGEI_prior_root_sf50
863: (
864: p_assignment_id => p_imm_pa_request_rec.employee_assignment_id,
865: p_information_type => 'GHR_US_ASG_SF52',

Line 862: Ghr_History_Fetch.Fetch_ASGEI_prior_root_sf50

858: and p_imm_pa_request_rec.first_noa_code = rec_root_details.second_noa_code then
859: l_prev_info_type := Ghr_History_Fetch.g_info_type;
860: -- Assigned to NULL before fetching as by this it is fetching for latest effective date
861: Ghr_History_Fetch.g_info_type := NULL;
862: Ghr_History_Fetch.Fetch_ASGEI_prior_root_sf50
863: (
864: p_assignment_id => p_imm_pa_request_rec.employee_assignment_id,
865: p_information_type => 'GHR_US_ASG_SF52',
866: p_date_effective => p_imm_pa_request_rec.effective_date,

Line 873: Ghr_History_Fetch.g_info_type := l_prev_info_type;

869: p_get_ovn_flag => 'Y',
870: p_asgei_data => l_asg_ei_data
871: );
872: ghr_process_sf52.g_dual_prior_ws := l_asg_ei_data.aei_information7;
873: Ghr_History_Fetch.g_info_type := l_prev_info_type;
874: if rec_root_details.noa_family_code = 'RETURN_TO_DUTY' then
875: ghr_process_sf52.g_dual_prior_prd := l_asg_ei_data.aei_information6;--Bug# 8268353
876: end if;
877: