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.

APPS.GHR_SF52_API dependencies on GHR_PA_REQUEST_EXTRA_INFO

Line 272: l_rei_rec ghr_pa_request_extra_info%rowtype; -- Temporarily added till wrapper is available

268: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
269: l_temp number(15);
270: --l_rec ghr_par_shd.g_old_rec%type;
271: l_rec ghr_pa_requests%rowtype;
272: l_rei_rec ghr_pa_request_extra_info%rowtype; -- Temporarily added till wrapper is available
273: l_par_object_version_number ghr_pa_requests.object_version_number%TYPE;
274: l_rei_object_version_number ghr_pa_request_extra_info.object_version_number%TYPE;
275: l_pa_request_extra_info_id ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE;
276: l_flag varchar2(1);

Line 274: l_rei_object_version_number ghr_pa_request_extra_info.object_version_number%TYPE;

270: --l_rec ghr_par_shd.g_old_rec%type;
271: l_rec ghr_pa_requests%rowtype;
272: l_rei_rec ghr_pa_request_extra_info%rowtype; -- Temporarily added till wrapper is available
273: l_par_object_version_number ghr_pa_requests.object_version_number%TYPE;
274: l_rei_object_version_number ghr_pa_request_extra_info.object_version_number%TYPE;
275: l_pa_request_extra_info_id ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE;
276: l_flag varchar2(1);
277: l_position_id hr_all_positions_f.position_id%type;
278: l_employee_id per_people_f.person_id%type;

Line 275: l_pa_request_extra_info_id ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE;

271: l_rec ghr_pa_requests%rowtype;
272: l_rei_rec ghr_pa_request_extra_info%rowtype; -- Temporarily added till wrapper is available
273: l_par_object_version_number ghr_pa_requests.object_version_number%TYPE;
274: l_rei_object_version_number ghr_pa_request_extra_info.object_version_number%TYPE;
275: l_pa_request_extra_info_id ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE;
276: l_flag varchar2(1);
277: l_position_id hr_all_positions_f.position_id%type;
278: l_employee_id per_people_f.person_id%type;
279: l_approval_date date;

Line 2267: l_rei_rec ghr_pa_request_extra_info%rowtype;

2263: l_old_action_taken ghr_pa_routing_history.action_taken%TYPE;
2264: l_forward_to_name ghr_pa_routing_history.user_name%type;
2265: l_rec ghr_pa_requests%rowtype;
2266: -- l_rec ghr_par_shd.g_old_rec%type;
2267: l_rei_rec ghr_pa_request_extra_info%rowtype;
2268: l_part_time_hours ghr_pa_requests.part_time_hours%type;
2269: l_requesting_office_remarks_fl ghr_pa_requests.requesting_office_remarks_flag%type;
2270: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%type;
2271: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%type;

Line 2438: FROM ghr_pa_request_extra_info rei

2434:
2435: CURSOR c_rei_rec IS
2436: SELECT pa_request_extra_info_id,
2437: object_version_number
2438: FROM ghr_pa_request_extra_info rei
2439: WHERE rei.pa_request_id = p_pa_request_id
2440: AND rei.information_type = l_information_type;
2441:
2442: CURSOR c_ovn IS

Line 5023: FROM ghr_pa_request_extra_info

5019: rei_information5 position_id,
5020: rei_information6 grade_id,
5021: rei_information7 job_id,
5022: rei_information12 location_id
5023: FROM ghr_pa_request_extra_info
5024: WHERE rei_information_category='GHR_US_PAR_DET_INFO'
5025: AND pa_request_id = p_pa_request_id;
5026:
5027: CURSOR cur_det_grd(l_grade_id NUMBER) IS

Line 5050: l_detail_position_id ghr_pa_request_extra_info.rei_information5%TYPE;

5046: where remark_id =l_remark_id
5047: and pa_request_id = p_pa_request_id;
5048:
5049:
5050: l_detail_position_id ghr_pa_request_extra_info.rei_information5%TYPE;
5051: l_detail_grade_id ghr_pa_request_extra_info.rei_information6%TYPE;
5052: l_detail_job_id ghr_pa_request_extra_info.rei_information7%TYPE;
5053: l_detail_location_id ghr_pa_request_extra_info.rei_information12%TYPE;
5054: l_detail_org ghr_pa_request_extra_info.rei_information13%TYPE;

Line 5051: l_detail_grade_id ghr_pa_request_extra_info.rei_information6%TYPE;

5047: and pa_request_id = p_pa_request_id;
5048:
5049:
5050: l_detail_position_id ghr_pa_request_extra_info.rei_information5%TYPE;
5051: l_detail_grade_id ghr_pa_request_extra_info.rei_information6%TYPE;
5052: l_detail_job_id ghr_pa_request_extra_info.rei_information7%TYPE;
5053: l_detail_location_id ghr_pa_request_extra_info.rei_information12%TYPE;
5054: l_detail_org ghr_pa_request_extra_info.rei_information13%TYPE;
5055:

Line 5052: l_detail_job_id ghr_pa_request_extra_info.rei_information7%TYPE;

5048:
5049:
5050: l_detail_position_id ghr_pa_request_extra_info.rei_information5%TYPE;
5051: l_detail_grade_id ghr_pa_request_extra_info.rei_information6%TYPE;
5052: l_detail_job_id ghr_pa_request_extra_info.rei_information7%TYPE;
5053: l_detail_location_id ghr_pa_request_extra_info.rei_information12%TYPE;
5054: l_detail_org ghr_pa_request_extra_info.rei_information13%TYPE;
5055:
5056: l_detail_position_name hr_all_positions_f.name%type;

Line 5053: l_detail_location_id ghr_pa_request_extra_info.rei_information12%TYPE;

5049:
5050: l_detail_position_id ghr_pa_request_extra_info.rei_information5%TYPE;
5051: l_detail_grade_id ghr_pa_request_extra_info.rei_information6%TYPE;
5052: l_detail_job_id ghr_pa_request_extra_info.rei_information7%TYPE;
5053: l_detail_location_id ghr_pa_request_extra_info.rei_information12%TYPE;
5054: l_detail_org ghr_pa_request_extra_info.rei_information13%TYPE;
5055:
5056: l_detail_position_name hr_all_positions_f.name%type;
5057: l_detail_grade PER_GRADES.name%type;

Line 5054: l_detail_org ghr_pa_request_extra_info.rei_information13%TYPE;

5050: l_detail_position_id ghr_pa_request_extra_info.rei_information5%TYPE;
5051: l_detail_grade_id ghr_pa_request_extra_info.rei_information6%TYPE;
5052: l_detail_job_id ghr_pa_request_extra_info.rei_information7%TYPE;
5053: l_detail_location_id ghr_pa_request_extra_info.rei_information12%TYPE;
5054: l_detail_org ghr_pa_request_extra_info.rei_information13%TYPE;
5055:
5056: l_detail_position_name hr_all_positions_f.name%type;
5057: l_detail_grade PER_GRADES.name%type;
5058: l_detail_job HR_LOOKUPS.MEANING%type;