[Home] [Help]
1188: exit;
1189: End loop;
1190: Else -- read from history
1191: l_personal_analysis_id := Null;
1192: ghr_history_fetch.return_special_information
1193: (p_person_id => p_pa_request_rec.person_id,
1194: p_structure_name => 'US Fed Education',
1195: p_effective_date => p_pa_request_rec.effective_date,
1196: p_special_info => l_special_info
1664: IF l_NTE_Dates IS NULL THEN
1665: /* FOR l_Cur_NTE_date_bef_np in Cur_NTE_date_bef_np(p_pa_request_rec.person_id,l_np_eff_date) LOOP
1666: l_NTE_Dates := l_Cur_NTE_date_bef_np.NTE_Dates;
1667: END LOOP; */
1668: ghr_history_fetch.fetch_asgei ( p_assignment_id => p_pa_request_rec.employee_assignment_id,
1669: p_information_type => 'GHR_US_ASG_NTE_DATES',
1670: p_date_effective => (l_np_eff_date-1),
1671: p_asg_ei_data => l_asg_ei_data
1672: );
4057: END LOOP;
4058: hr_utility.set_location('Assg Pos ' ||l_asg_position,599);
4059:
4060: --Getting Grade id
4061: ghr_history_fetch.fetch_positionei
4062: (p_position_id => l_position_id
4063: ,p_information_type => 'GHR_US_POS_VALID_GRADE'
4064: ,p_date_effective => p_pa_request_rec.effective_date
4065: ,p_pos_ei_data => l_pos_ei_data);
6299: p_dlei => NULL
6300: );
6301: --Begin Bug 10104811
6302: IF nvl(p_pa_request_rec.noa_family_code,hr_api.g_varchar2) IN ('RETURN_TO_DUTY') AND p_wgi.p_last_equi_incr IS NULL THEN
6303: ghr_history_fetch.fetch_element_entry_value
6304: (p_element_name => 'Within Grade Increase',
6305: p_input_value_name => 'Last Equivalent Increase',
6306: p_assignment_id => p_pa_request_rec.employee_assignment_id,
6307: p_date_effective => p_pa_request_rec.effective_date,
6406: -- Bug#5666880 - Included NOA 896, 897
6407: IF (p_pa_request_rec.first_noa_code IN ('892','867','896','897') OR
6408: p_pa_request_rec.second_noa_code IN ('892','867','896','897')) THEN
6409: hr_utility.set_location('inside NOA Code 897',9999999);
6410: ghr_history_fetch.fetch_element_entry_value
6411: (p_element_name => 'Within Grade Increase',
6412: p_input_value_name => 'Last Equivalent Increase',
6413: p_assignment_id => p_pa_request_rec.employee_assignment_id,
6414: p_date_effective => p_pa_request_rec.effective_date,
6420: -- Bug 3709414 Retrieving Last equivalent increase date if it's not entered in RPA EIT.
6421: hr_utility.set_location('p_wgi.p_last_equi_incr is ' || p_wgi.p_last_equi_incr,1);
6422: IF (p_pa_request_rec.first_noa_code = '713' OR p_pa_request_rec.second_noa_code = '713')
6423: AND p_wgi.p_last_equi_incr IS NULL THEN
6424: ghr_history_fetch.fetch_element_entry_value
6425: (p_element_name => 'Within Grade Increase',
6426: p_input_value_name => 'Last Equivalent Increase',
6427: p_assignment_id => p_pa_request_rec.employee_assignment_id,
6428: p_date_effective => p_pa_request_rec.effective_date,
8228: l_step_or_rate := next_from_step.to_step;
8229: end loop;
8230: Else
8231: -- get the user table id for the position in all other cases .
8232: ghr_history_fetch.fetch_positionei
8233: (
8234: p_position_id => p_pa_request_rec.to_position_id
8235: ,p_information_type => 'GHR_US_POS_VALID_GRADE'
8236: ,p_date_effective => p_pa_request_rec.effective_date
8417: THEN
8418: hr_utility.set_location('Do not calc. WGI Dates for all steps in QSI ',1);
8419: -- Start of Bug 3111719
8420: -- Return the current WGI due date for steps other than 4,7,10 in QSI.
8421: ghr_history_fetch.fetch_element_entry_value
8422: (p_element_name => 'Within Grade Increase',
8423: p_input_value_name => 'Date Due',
8424: p_assignment_id => p_pa_request_rec.employee_assignment_id,
8425: p_date_effective => p_pa_request_rec.effective_date,
8430: -- End of Bug 3111719.
8431: -- Bug 3709414 New Approach-- For 713 actions take from element entry
8432: -- If DLEI is entered, use that to calculate Due Date, else retain the old date
8433: ELSIF (p_pa_request_rec.first_noa_code = '713' OR p_pa_request_rec.second_noa_code = '713') AND p_dlei IS NULL THEN
8434: ghr_history_fetch.fetch_element_entry_value
8435: (p_element_name => 'Within Grade Increase',
8436: p_input_value_name => 'Date Due',
8437: p_assignment_id => p_pa_request_rec.employee_assignment_id,
8438: p_date_effective => p_pa_request_rec.effective_date,
8448: end loop;
8449: If (p_pa_request_rec.first_noa_code = '892' or p_pa_request_rec.second_noa_code = '892') and
8450: (p_retained_grade_rec.step_or_rate in (4,7) or l_from_step in (4,7)) then
8451: -- get current WGI Due Date
8452: ghr_history_fetch.fetch_element_entry_value
8453: (p_element_name => 'Within Grade Increase',
8454: p_input_value_name => 'Date Due',
8455: p_assignment_id => p_pa_request_rec.employee_assignment_id,
8456: p_date_effective => p_pa_request_rec.effective_date,