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_MTI_APP dependencies on GHR_PA_REQUESTS

Line 147: l_lac_sf52_rec ghr_pa_requests%rowtype;

143: AND trunc(p_eff_date) BETWEEN asg.effective_start_date AND asg.effective_end_date
144: ORDER BY asg.assignment_id;
145:
146: l_pa_request_id number;
147: l_lac_sf52_rec ghr_pa_requests%rowtype;
148:
149: l_person_id number;
150: l_employee_assignment_id number;
151: l_position_id number;

Line 193: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;

189: l_step_or_rate varchar2(30);
190: l_pay_basis varchar2(30);
191: l_location_id number;
192: l_duty_station_id number;
193: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;
194: l_duty_station_code ghr_pa_requests.duty_station_code%type;
195: l_mt_status varchar2(2);
196:
197: l_org1 varchar2(40);

Line 194: l_duty_station_code ghr_pa_requests.duty_station_code%type;

190: l_pay_basis varchar2(30);
191: l_location_id number;
192: l_duty_station_id number;
193: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;
194: l_duty_station_code ghr_pa_requests.duty_station_code%type;
195: l_mt_status varchar2(2);
196:
197: l_org1 varchar2(40);
198: l_org2 varchar2(40);

Line 235: l_sf52_rec ghr_pa_requests%rowtype;

231: l_non_disc_agmt_status varchar2(150);
232: l_position_working_title varchar2(150);
233: l_part_time_indicator varchar2(150);
234:
235: l_sf52_rec ghr_pa_requests%rowtype;
236: l_errbuf varchar2(2000);
237:
238: l_retcode number;
239:

Line 249: l_education_level ghr_pa_requests.education_level%type;

245: l_per_ei3_data per_people_extra_info%rowtype;
246: l_per_ei4_data per_people_extra_info%rowtype;
247: l_per_ei5_data per_people_extra_info%rowtype;
248:
249: l_education_level ghr_pa_requests.education_level%type;
250: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;
251: l_academic_discipline ghr_pa_requests.academic_discipline%type;
252: l_service_comp_date date;
253:

Line 250: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;

246: l_per_ei4_data per_people_extra_info%rowtype;
247: l_per_ei5_data per_people_extra_info%rowtype;
248:
249: l_education_level ghr_pa_requests.education_level%type;
250: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;
251: l_academic_discipline ghr_pa_requests.academic_discipline%type;
252: l_service_comp_date date;
253:
254: -- Changes 4093771

Line 251: l_academic_discipline ghr_pa_requests.academic_discipline%type;

247: l_per_ei5_data per_people_extra_info%rowtype;
248:
249: l_education_level ghr_pa_requests.education_level%type;
250: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;
251: l_academic_discipline ghr_pa_requests.academic_discipline%type;
252: l_service_comp_date date;
253:
254: -- Changes 4093771
255: l_to_basic_pay ghr_pa_requests.to_basic_pay%type;

Line 255: l_to_basic_pay ghr_pa_requests.to_basic_pay%type;

251: l_academic_discipline ghr_pa_requests.academic_discipline%type;
252: l_service_comp_date date;
253:
254: -- Changes 4093771
255: l_to_basic_pay ghr_pa_requests.to_basic_pay%type;
256: l_to_adj_basic_pay ghr_pa_requests.to_adj_basic_pay%type;
257: l_to_total_salary ghr_pa_requests.to_total_salary%type;
258: -- End Changes 4093771
259: --Bug# 8724192

Line 256: l_to_adj_basic_pay ghr_pa_requests.to_adj_basic_pay%type;

252: l_service_comp_date date;
253:
254: -- Changes 4093771
255: l_to_basic_pay ghr_pa_requests.to_basic_pay%type;
256: l_to_adj_basic_pay ghr_pa_requests.to_adj_basic_pay%type;
257: l_to_total_salary ghr_pa_requests.to_total_salary%type;
258: -- End Changes 4093771
259: --Bug# 8724192
260: l_orig_appt_auth_code_1_desc varchar2(80);

Line 257: l_to_total_salary ghr_pa_requests.to_total_salary%type;

253:
254: -- Changes 4093771
255: l_to_basic_pay ghr_pa_requests.to_basic_pay%type;
256: l_to_adj_basic_pay ghr_pa_requests.to_adj_basic_pay%type;
257: l_to_total_salary ghr_pa_requests.to_total_salary%type;
258: -- End Changes 4093771
259: --Bug# 8724192
260: l_orig_appt_auth_code_1_desc varchar2(80);
261: l_orig_appt_auth_code_2_desc varchar2(80);

Line 404: ghr_pa_requests_pkg.get_SF52_to_data_elements

400:
401: if nvl(l_mt_status,'U') = 'P' THEN
402:
403: if check_eligibility(l_person_id,p_effective_date) then
404: ghr_pa_requests_pkg.get_SF52_to_data_elements
405: (p_position_id => l_position_id
406: ,p_effective_date => p_effective_date
407: ,p_prd => l_pay_rate_determinant
408: ,p_grade_id => l_grade_id

Line 432: ghr_pa_requests_pkg.get_duty_station_details

428: hr_utility.set_location('Grade Or Level ' || l_grade_or_level, 85);
429: hr_utility.set_location('Pay Basis ' || l_pay_basis, 85);
430:
431: begin
432: ghr_pa_requests_pkg.get_duty_station_details
433: (p_duty_station_id => l_duty_station_id
434: ,p_effective_date => p_effective_date
435: ,p_duty_station_code => l_duty_station_code
436: ,p_duty_station_desc => l_duty_station_desc);

Line 1055: ,p_lac_sf52_rec in ghr_pa_requests%rowtype

1051: , p_to_basic_pay IN number
1052: , p_to_adj_basic_pay IN number
1053: , p_to_total_salary IN number
1054: -- End Changes 4093771
1055: ,p_lac_sf52_rec in ghr_pa_requests%rowtype
1056: ,p_sf52_rec out nocopy ghr_pa_requests%rowtype)
1057: IS
1058:
1059: l_proc varchar2(72)

Line 1056: ,p_sf52_rec out nocopy ghr_pa_requests%rowtype)

1052: , p_to_adj_basic_pay IN number
1053: , p_to_total_salary IN number
1054: -- End Changes 4093771
1055: ,p_lac_sf52_rec in ghr_pa_requests%rowtype
1056: ,p_sf52_rec out nocopy ghr_pa_requests%rowtype)
1057: IS
1058:
1059: l_proc varchar2(72)
1060: := g_package || '.assign_to_sf52_rec';