eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.GHR_SF52_PRE_UPDATE dependencies on PER_POSITION_EXTRA_INFO

Line 217: l_pos_extra_info_rec per_position_extra_info%rowtype;

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;
221: l_imm_agency_sf52 ghr_api.agency_sf52_type;

Line 810: l_pos_extra_info_rec per_position_extra_info%rowtype;

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;
814: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;

Line 2304: l_office_symbol per_position_extra_info.poei_information4%type := p_pos_grp1.office_symbol;

2300: AND information_type = l_information_type);
2301:
2302:
2303: -- Bug 3260890
2304: l_office_symbol per_position_extra_info.poei_information4%type := p_pos_grp1.office_symbol;
2305: l_organization_structure_id per_position_extra_info.poei_information5%type := p_pos_grp1.organization_structure_id;
2306: l_positions_organization per_position_extra_info.poei_information21%type := p_pos_grp1.positions_organization;
2307: l_organization_function_code per_position_extra_info.poei_information4%type := p_pos_grp2.organization_function_code;
2308: l_personnel_office_id per_position_extra_info.poei_information3%type := p_pos_grp1.personnel_office_id;

Line 2305: l_organization_structure_id per_position_extra_info.poei_information5%type := p_pos_grp1.organization_structure_id;

2301:
2302:
2303: -- Bug 3260890
2304: l_office_symbol per_position_extra_info.poei_information4%type := p_pos_grp1.office_symbol;
2305: l_organization_structure_id per_position_extra_info.poei_information5%type := p_pos_grp1.organization_structure_id;
2306: l_positions_organization per_position_extra_info.poei_information21%type := p_pos_grp1.positions_organization;
2307: l_organization_function_code per_position_extra_info.poei_information4%type := p_pos_grp2.organization_function_code;
2308: l_personnel_office_id per_position_extra_info.poei_information3%type := p_pos_grp1.personnel_office_id;
2309: l_payroll_office_id ghr_pa_request_extra_info.rei_information4%type := p_pos_grp1.payroll_office_id;

Line 2306: l_positions_organization per_position_extra_info.poei_information21%type := p_pos_grp1.positions_organization;

2302:
2303: -- Bug 3260890
2304: l_office_symbol per_position_extra_info.poei_information4%type := p_pos_grp1.office_symbol;
2305: l_organization_structure_id per_position_extra_info.poei_information5%type := p_pos_grp1.organization_structure_id;
2306: l_positions_organization per_position_extra_info.poei_information21%type := p_pos_grp1.positions_organization;
2307: l_organization_function_code per_position_extra_info.poei_information4%type := p_pos_grp2.organization_function_code;
2308: l_personnel_office_id per_position_extra_info.poei_information3%type := p_pos_grp1.personnel_office_id;
2309: l_payroll_office_id ghr_pa_request_extra_info.rei_information4%type := p_pos_grp1.payroll_office_id;
2310: -- End Bug 3260890

Line 2307: l_organization_function_code per_position_extra_info.poei_information4%type := p_pos_grp2.organization_function_code;

2303: -- Bug 3260890
2304: l_office_symbol per_position_extra_info.poei_information4%type := p_pos_grp1.office_symbol;
2305: l_organization_structure_id per_position_extra_info.poei_information5%type := p_pos_grp1.organization_structure_id;
2306: l_positions_organization per_position_extra_info.poei_information21%type := p_pos_grp1.positions_organization;
2307: l_organization_function_code per_position_extra_info.poei_information4%type := p_pos_grp2.organization_function_code;
2308: l_personnel_office_id per_position_extra_info.poei_information3%type := p_pos_grp1.personnel_office_id;
2309: l_payroll_office_id ghr_pa_request_extra_info.rei_information4%type := p_pos_grp1.payroll_office_id;
2310: -- End Bug 3260890
2311:

Line 2308: l_personnel_office_id per_position_extra_info.poei_information3%type := p_pos_grp1.personnel_office_id;

2304: l_office_symbol per_position_extra_info.poei_information4%type := p_pos_grp1.office_symbol;
2305: l_organization_structure_id per_position_extra_info.poei_information5%type := p_pos_grp1.organization_structure_id;
2306: l_positions_organization per_position_extra_info.poei_information21%type := p_pos_grp1.positions_organization;
2307: l_organization_function_code per_position_extra_info.poei_information4%type := p_pos_grp2.organization_function_code;
2308: l_personnel_office_id per_position_extra_info.poei_information3%type := p_pos_grp1.personnel_office_id;
2309: l_payroll_office_id ghr_pa_request_extra_info.rei_information4%type := p_pos_grp1.payroll_office_id;
2310: -- End Bug 3260890
2311:
2312: -- Bug# 4672772 Begin

Line 2369: /*l_pos_extra_info_rec per_position_extra_info%rowtype;

2365: FROM ghr_pa_requests
2366: WHERE pa_request_id = p_pa_request_rec.pa_request_id;
2367: --end Bug# 10182526
2368: --Begin Bug# 13942237
2369: /*l_pos_extra_info_rec per_position_extra_info%rowtype;
2370: l_valid_grade_name VARCHAR2(150);
2371: l_target_grade_name VARCHAR2(150);
2372:
2373: cursor grade_id(p_grade_id in varchar2) is