[Home] [Help]
208: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
209: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
210:
211: l_imm_extra_info_rec ghr_api.extra_info_rec_type;
212: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
213: l_pos_extra_info_rec per_position_extra_info%rowtype;
214: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
215: l_imm_personal_info ghr_api.personal_info_type;
216: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type;
244: l_agency_code varchar2(50);
245: l_special_info_type ghr_api.special_information_type;
246: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
247: l_session ghr_history_api.g_session_var_type;
248: l_asg_ei_data per_assignment_extra_info%rowtype;
249: l_assignment_data per_all_assignments_f%rowtype;
250: l_result_code varchar2(50);
251: l_person_type per_person_types.system_person_type%type;
252: l_effective_date date;
785: p_retirement_info in out nocopy ghr_api.per_retirement_info_type
786: )
787: is
788: l_per_extra_info_rec per_people_extra_info%rowtype;
789: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
790: l_pos_extra_info_rec per_position_extra_info%rowtype;
791: l_proc varchar2(70) := 'Retrieve_all_extra_info';
792: l_person_type per_person_types.system_person_type%type := hr_api.g_varchar2;
793: l_position_id per_positions.position_id%type;
2192:
2193: l_old_user_status per_assignment_status_types.user_status%type;
2194: l_old_system_status per_assignment_status_types.per_system_status%type;
2195: l_old_effective_start_date date;
2196: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
2197: l_user_apnt_status per_assignment_status_types.user_status%type;
2198: l_user_apnt_eff_date date;
2199:
2200: Cursor c_user_status is