[Home] [Help]
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;
814: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
815: l_session ghr_history_api.g_session_var_type;
816: l_person_status per_assignment_status_types.user_status%type;
817:
1658: --
1659: l_bus_gp number;
1660: l_agency_code varchar2(50);
1661: l_proc varchar2(70) := 'SF52_br_extra_info';
1662: l_position_id per_positions.position_id%type;
1663:
1664: --
1665: --Bug# 957677 -- Parameter Name Change
1666: cursor c_bus_gp(p_position_id number) is
2010: hr_utility.set_location(l_proc,95);
2011: --
2012: --
2013: -- Bug 3226555 Commented below code as they can never be equal. It was unnecessarily inserting a
2014: -- row into the history for the table PER_POSITIONS_EXTRA_INFO and thereby making the Position
2015: -- status as invalid when cancellation to any action was done.
2016: /* If p_pa_request_rec.to_occ_code is not null then
2017: If P_pa_request_rec.to_Occ_Code <>
2018: nvl(p_pos_grp1.occupation_category_code,hr_api.g_varchar2) then