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 124: l_lac_sf52_rec ghr_pa_requests%rowtype;

120: AND trunc(p_eff_date) BETWEEN asg.effective_start_date AND asg.effective_end_date
121: ORDER BY asg.assignment_id;
122:
123: l_pa_request_id number;
124: l_lac_sf52_rec ghr_pa_requests%rowtype;
125:
126: l_person_id number;
127: l_employee_assignment_id number;
128: l_position_id number;

Line 170: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;

166: l_step_or_rate varchar2(30);
167: l_pay_basis varchar2(30);
168: l_location_id number;
169: l_duty_station_id number;
170: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;
171: l_duty_station_code ghr_pa_requests.duty_station_code%type;
172: l_mt_status varchar2(2);
173:
174: l_org1 varchar2(40);

Line 171: l_duty_station_code ghr_pa_requests.duty_station_code%type;

167: l_pay_basis varchar2(30);
168: l_location_id number;
169: l_duty_station_id number;
170: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;
171: l_duty_station_code ghr_pa_requests.duty_station_code%type;
172: l_mt_status varchar2(2);
173:
174: l_org1 varchar2(40);
175: l_org2 varchar2(40);

Line 212: l_sf52_rec ghr_pa_requests%rowtype;

208: l_non_disc_agmt_status varchar2(150);
209: l_position_working_title varchar2(150);
210: l_part_time_indicator varchar2(150);
211:
212: l_sf52_rec ghr_pa_requests%rowtype;
213: l_errbuf varchar2(2000);
214:
215: l_retcode number;
216:

Line 226: l_education_level ghr_pa_requests.education_level%type;

222: l_per_ei3_data per_people_extra_info%rowtype;
223: l_per_ei4_data per_people_extra_info%rowtype;
224: l_per_ei5_data per_people_extra_info%rowtype;
225:
226: l_education_level ghr_pa_requests.education_level%type;
227: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;
228: l_academic_discipline ghr_pa_requests.academic_discipline%type;
229: l_service_comp_date date;
230:

Line 227: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;

223: l_per_ei4_data per_people_extra_info%rowtype;
224: l_per_ei5_data per_people_extra_info%rowtype;
225:
226: l_education_level ghr_pa_requests.education_level%type;
227: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;
228: l_academic_discipline ghr_pa_requests.academic_discipline%type;
229: l_service_comp_date date;
230:
231: -- Changes 4093771

Line 228: l_academic_discipline ghr_pa_requests.academic_discipline%type;

224: l_per_ei5_data per_people_extra_info%rowtype;
225:
226: l_education_level ghr_pa_requests.education_level%type;
227: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;
228: l_academic_discipline ghr_pa_requests.academic_discipline%type;
229: l_service_comp_date date;
230:
231: -- Changes 4093771
232: l_to_basic_pay ghr_pa_requests.to_basic_pay%type;

Line 232: l_to_basic_pay ghr_pa_requests.to_basic_pay%type;

228: l_academic_discipline ghr_pa_requests.academic_discipline%type;
229: l_service_comp_date date;
230:
231: -- Changes 4093771
232: l_to_basic_pay ghr_pa_requests.to_basic_pay%type;
233: l_to_adj_basic_pay ghr_pa_requests.to_adj_basic_pay%type;
234: l_to_total_salary ghr_pa_requests.to_total_salary%type;
235: -- End Changes 4093771
236:

Line 233: l_to_adj_basic_pay ghr_pa_requests.to_adj_basic_pay%type;

229: l_service_comp_date date;
230:
231: -- Changes 4093771
232: l_to_basic_pay ghr_pa_requests.to_basic_pay%type;
233: l_to_adj_basic_pay ghr_pa_requests.to_adj_basic_pay%type;
234: l_to_total_salary ghr_pa_requests.to_total_salary%type;
235: -- End Changes 4093771
236:
237: l_proc varchar2(72) := g_package || '.get_all_52_elements';

Line 234: l_to_total_salary ghr_pa_requests.to_total_salary%type;

230:
231: -- Changes 4093771
232: l_to_basic_pay ghr_pa_requests.to_basic_pay%type;
233: l_to_adj_basic_pay ghr_pa_requests.to_adj_basic_pay%type;
234: l_to_total_salary ghr_pa_requests.to_total_salary%type;
235: -- End Changes 4093771
236:
237: l_proc varchar2(72) := g_package || '.get_all_52_elements';
238:

Line 365: ghr_pa_requests_pkg.get_SF52_to_data_elements

361:
362: if nvl(l_mt_status,'U') = 'P' THEN
363:
364: if check_eligibility(l_person_id,p_effective_date) then
365: ghr_pa_requests_pkg.get_SF52_to_data_elements
366: (p_position_id => l_position_id
367: ,p_effective_date => p_effective_date
368: ,p_prd => l_pay_rate_determinant
369: ,p_grade_id => l_grade_id

Line 393: ghr_pa_requests_pkg.get_duty_station_details

389: hr_utility.set_location('Grade Or Level ' || l_grade_or_level, 85);
390: hr_utility.set_location('Pay Basis ' || l_pay_basis, 85);
391:
392: begin
393: ghr_pa_requests_pkg.get_duty_station_details
394: (p_duty_station_id => l_duty_station_id
395: ,p_effective_date => p_effective_date
396: ,p_duty_station_code => l_duty_station_code
397: ,p_duty_station_desc => l_duty_station_desc);

Line 942: ,p_lac_sf52_rec in ghr_pa_requests%rowtype

938: , p_to_basic_pay IN number
939: , p_to_adj_basic_pay IN number
940: , p_to_total_salary IN number
941: -- End Changes 4093771
942: ,p_lac_sf52_rec in ghr_pa_requests%rowtype
943: ,p_sf52_rec out nocopy ghr_pa_requests%rowtype)
944: IS
945:
946: l_proc varchar2(72)

Line 943: ,p_sf52_rec out nocopy ghr_pa_requests%rowtype)

939: , p_to_adj_basic_pay IN number
940: , p_to_total_salary IN number
941: -- End Changes 4093771
942: ,p_lac_sf52_rec in ghr_pa_requests%rowtype
943: ,p_sf52_rec out nocopy ghr_pa_requests%rowtype)
944: IS
945:
946: l_proc varchar2(72)
947: := g_package || '.assign_to_sf52_rec';