[Home] [Help]
2092: -- action we are cancelling. If it is different, then there are intervening actions on
2093: -- the same date and the update should not be applied to pay_element_entry_values_f table.
2094: -- If it is the same, then there are no intervening actions on the same date and the
2095: -- update should be applied.
2096: ghr_history_fetch.get_date_eff_eleevl(p_element_entry_value_id => l_hist_pre.information1,
2097: p_date_effective => l_hist_rec.effective_date,
2098: p_element_entry_data => l_date_eff_rec,
2099: p_result_code => l_result_code,
2100: p_pa_history_id => l_pa_history_id);
2451: fetch get_hist into l_hist_id;
2452: close get_hist;
2453: hr_utility.set_location( 'Fetched Hist id' || l_proc, 15);
2454:
2455: ghr_history_fetch.fetch_people(
2456: p_person_id => p_sf52_data.person_id,
2457: p_date_effective => p_sf52_data.effective_date,
2458: p_pa_history_id => l_hist_id,
2459: p_altered_pa_request_id => p_sf52_data.altered_pa_request_id,
3059: else
3060: ghr_history_conv_rg.copy_field_value(p_sf52rec_correct.award_percentage,p_sf52rec.award_percentage);
3061: IF p_sf52rec.award_percentage IS NOT NULL THEN
3062: -- Begin Bug# 5014663
3063: ghr_history_fetch.fetch_asgei(
3064: p_assignment_id => p_sf52rec.employee_assignment_id,
3065: p_information_type => 'GHR_US_ASG_SF52',
3066: p_date_effective => p_sf52rec.effective_date,
3067: p_asg_ei_data => l_asg_ei_data);
3432: l_session_var1.assignment_id := l_session_var.assignment_id;
3433: l_session_var1.fire_trigger := 'N';
3434: l_session_var1.program_name := 'sf50';
3435: ghr_history_api.set_g_session_var(l_session_var1);
3436: ghr_history_fetch.fetch_positionei(
3437: p_position_id => p_sf52_data_result.to_position_id,
3438: p_information_type => 'GHR_US_POS_GRP1',
3439: p_date_effective => p_sf52_data_result.effective_date,
3440: p_pos_ei_data => l_pos_ei_grp1_data);
3503: l_session_var1.program_name := 'sf50';
3504: ghr_history_api.set_g_session_var(l_session_var1);
3505:
3506: -- Retrieve the Grade info from the POI history table
3507: ghr_history_fetch.fetch_positionei(
3508: p_position_id => p_sf52_data_result.to_position_id,
3509: p_information_type => 'GHR_US_POS_VALID_GRADE',
3510: p_date_effective => p_sf52_data_result.effective_date,
3511: p_pos_ei_data => l_pos_ei_grade_data);
5279: l_session_var1.program_name := 'sf50';
5280: ghr_history_api.set_g_session_var(l_session_var1);
5281:
5282: -- Retrieve the Grade info from the POI history table
5283: ghr_history_fetch.fetch_positionei(
5284: p_position_id => p_sf52_data_result.to_position_id,
5285: p_information_type => 'GHR_US_POS_VALID_GRADE',
5286: p_date_effective => p_sf52_data_result.effective_date,
5287: p_pos_ei_data => l_pos_ei_grade_data);