[Home] [Help]
212: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
213: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
214:
215: l_imm_extra_info_rec ghr_api.extra_info_rec_type;
216: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
217: l_pos_extra_info_rec per_position_extra_info%rowtype;
218: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
219: l_imm_personal_info ghr_api.personal_info_type;
220: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type;
248: l_agency_code varchar2(50);
249: l_special_info_type ghr_api.special_information_type;
250: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
251: l_session ghr_history_api.g_session_var_type;
252: l_asg_ei_data per_assignment_extra_info%rowtype;
253: l_assignment_data per_all_assignments_f%rowtype;
254: l_result_code varchar2(50);
255: l_person_type per_person_types.system_person_type%type;
256: l_effective_date date;
805: p_per_group2 in out nocopy ghr_api.per_group2_type
806: )
807: is
808: l_per_extra_info_rec per_people_extra_info%rowtype;
809: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
810: l_pos_extra_info_rec per_position_extra_info%rowtype;
811: l_proc varchar2(70) := 'Retrieve_all_extra_info';
812: l_person_type per_person_types.system_person_type%type := hr_api.g_varchar2;
813: l_position_id per_positions.position_id%type;
2313:
2314: l_old_user_status per_assignment_status_types.user_status%type;
2315: l_old_system_status per_assignment_status_types.per_system_status%type;
2316: l_old_effective_start_date date;
2317: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
2318: l_user_apnt_status per_assignment_status_types.user_status%type;
2319: l_user_apnt_eff_date date;
2320:
2321: Cursor c_user_status is