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_SS_RPA_CREATION dependencies on GHR_PA_REQUESTS_PKG

Line 93: l_employee_number := ghr_pa_requests_pkg2.get_employee_number

89: open chk_fegli_exists;
90: fetch chk_fegli_exists into l_curr_fegli,l_pa_request_id,l_object_version_number,
91: l_employee_last_name,l_employee_first_name,l_employee_middle_names;
92: l_full_name := l_employee_last_name||','|| l_employee_first_name||' '|| l_employee_middle_names;
93: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
94: (p_person_id => p_person_id,
95: p_effective_date => p_effective_date);
96: if chk_fegli_exists%notfound then
97:

Line 321: l_employee_number := ghr_pa_requests_pkg2.get_employee_number

317: EXIT;
318: END LOOP;
319:
320: l_full_name := l_sf52_rec.employee_last_name||','|| l_sf52_rec.employee_first_name||' '|| l_sf52_rec.employee_middle_names;
321: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
322: (p_person_id => l_sf52_rec.person_id,
323: p_effective_date => l_sf52_rec.effective_date);
324:
325:

Line 327: ghr_pa_requests_pkg.get_sf52_asg_ddf_details(l_sf52_rec.employee_assignment_id,

323: p_effective_date => l_sf52_rec.effective_date);
324:
325:
326: BEGIN
327: ghr_pa_requests_pkg.get_sf52_asg_ddf_details(l_sf52_rec.employee_assignment_id,
328: p_effective_date,
329: l_sf52_rec.tenure,
330: l_sf52_rec.annuitant_indicator,
331: l_sf52_rec.pay_rate_determinant,

Line 336: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||

332: l_sf52_rec.work_schedule,
333: l_sf52_rec.part_time_hours);
334: EXCEPTION
335: WHEN OTHERS THEN
336: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
337: 'Err is '||sqlerrm(sqlcode),20);
338: l_log_text := 'Error in get_sf52_asgddf_details for employee with Emp No: '||l_employee_number||'; Name:'||l_full_name
339: || '; SQL Error: '|| sqlerrm(sqlcode);
340: raise fegli_error;

Line 354: ghr_pa_requests_pkg.get_SF52_pos_ddf_details

350: END LOOP;
351:
352:
353: BEGIN
354: ghr_pa_requests_pkg.get_SF52_pos_ddf_details
355: (p_position_id => l_sf52_rec.from_position_id
356: ,p_date_Effective => l_sf52_rec.effective_date
357: ,p_flsa_category => l_sf52_rec.flsa_category
358: ,p_bargaining_unit_status => l_sf52_rec.bargaining_unit_status

Line 370: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_SF52_pos_ddf_details'

366: ,p_office_symbol => l_sf52_rec.from_office_symbol
367: ,p_part_time_hours => l_sf52_rec.part_time_hours);
368: EXCEPTION
369: WHEN OTHERS THEN
370: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_SF52_pos_ddf_details'
371: || 'Err is' ||sqlerrm(sqlcode),20);
372: l_log_text := 'Error in get_SF52_pos_ddf_details for employee with Emp No: '||l_employee_number||'; Name:'||l_full_name
373: || '; SQL Error: '|| sqlerrm(sqlcode);
374: raise fegli_error;

Line 457: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

453: l_sf52_rec.to_position_org_line6 := l_sf52_rec.from_position_org_line6;
454: l_sf52_rec.to_position_id := l_sf52_rec.from_position_id;
455:
456: BEGIN
457: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
458: (p_location_id => l_sf52_rec.duty_station_location_id
459: ,p_duty_station_id => l_sf52_rec.duty_station_id);
460: EXCEPTION
461: WHEN OTHERS THEN

Line 462: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_SF52_loc_ddf_details'||

458: (p_location_id => l_sf52_rec.duty_station_location_id
459: ,p_duty_station_id => l_sf52_rec.duty_station_id);
460: EXCEPTION
461: WHEN OTHERS THEN
462: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_SF52_loc_ddf_details'||
463: 'Err is'||sqlerrm(sqlcode),20);
464: l_log_text := 'Error in get_SF52_loc_ddf_details for employee with Emp No: '||l_employee_number||'; Name:'||l_full_name
465: || '; SQL Error: '||sqlerrm(sqlcode);
466: raise fegli_error;

Line 470: ghr_pa_requests_pkg.get_duty_station_details

466: raise fegli_error;
467: END;
468:
469: BEGIN
470: ghr_pa_requests_pkg.get_duty_station_details
471: (p_duty_station_id => l_sf52_rec.duty_station_id
472: ,p_effective_date => l_sf52_rec.effective_date
473: ,p_duty_station_code => l_sf52_rec.duty_station_code
474: ,p_duty_station_desc => l_sf52_rec.duty_station_desc);

Line 477: hr_utility.set_location('Error in ghr_pa_requests_pkg.get_duty_station_details'||

473: ,p_duty_station_code => l_sf52_rec.duty_station_code
474: ,p_duty_station_desc => l_sf52_rec.duty_station_desc);
475: EXCEPTION
476: WHEN OTHERS THEN
477: hr_utility.set_location('Error in ghr_pa_requests_pkg.get_duty_station_details'||
478: 'Err is '||sqlerrm(sqlcode),20);
479: l_log_text := 'Error in get_duty_station_details for employee with Emp No: '||l_employee_number||'; Name:'||l_full_name
480: || '; SQL Error: '|| sqlerrm(sqlcode);
481: raise fegli_error;

Line 502: ghr_pa_requests_pkg.get_SF52_person_ddf_details

498: raise fegli_error;
499: END;
500:
501: BEGIN
502: ghr_pa_requests_pkg.get_SF52_person_ddf_details
503: (p_person_id => l_sf52_rec.person_id,
504: p_date_effective => l_sf52_rec.effective_date,
505: p_citizenship => l_sf52_rec.citizenship,
506: p_veterans_preference => l_sf52_rec.veterans_preference,

Line 513: hr_utility.set_location('Error in ghr_pa_requests_pkg.get_SF52_person_ddf_details'||

509: p_scd_leave => l_scd_leave
510: );
511: EXCEPTION
512: WHEN OTHERS THEN
513: hr_utility.set_location('Error in ghr_pa_requests_pkg.get_SF52_person_ddf_details'||
514: 'Err is '||sqlerrm(sqlcode),20);
515: l_log_text := 'Error in get_SF52_person_ddf_details for employee with Emp No: '||l_employee_number||'; Name:'||l_full_name
516: || '; SQL Error:'|| sqlerrm(sqlcode);
517: raise fegli_error;

Line 521: l_sf52_rec.annuitant_indicator_desc := ghr_pa_requests_pkg.get_lookup_meaning

517: raise fegli_error;
518: END;
519:
520: -- Annuitant_indicator
521: l_sf52_rec.annuitant_indicator_desc := ghr_pa_requests_pkg.get_lookup_meaning
522: (800
523: ,'GHR_US_ANNUITANT_INDICATOR'
524: ,l_sf52_rec.annuitant_indicator
525: );

Line 528: l_sf52_rec.work_schedule_desc := ghr_pa_requests_pkg.get_lookup_meaning

524: ,l_sf52_rec.annuitant_indicator
525: );
526:
527: --WORK_SCHEDULE
528: l_sf52_rec.work_schedule_desc := ghr_pa_requests_pkg.get_lookup_meaning
529: (800
530: ,'GHR_US_WORK_SCHEDULE'
531: ,l_sf52_rec.work_schedule
532: );

Line 534: l_sf52_rec.fegli_desc := ghr_pa_requests_pkg.get_lookup_meaning

530: ,'GHR_US_WORK_SCHEDULE'
531: ,l_sf52_rec.work_schedule
532: );
533:
534: l_sf52_rec.fegli_desc := ghr_pa_requests_pkg.get_lookup_meaning
535: (800
536: ,'GHR_US_FEGLI'
537: ,l_sf52_rec.fegli
538: );

Line 550: l_sf52_rec.retirement_plan_desc := ghr_pa_requests_pkg.get_lookup_meaning

546: ,p_multiple_error_flag => l_multiple_error_flag
547: );
548:
549:
550: l_sf52_rec.retirement_plan_desc := ghr_pa_requests_pkg.get_lookup_meaning
551: (800
552: ,'GHR_US_RETIREMENT_PLAN'
553: ,l_sf52_rec.retirement_plan
554: );

Line 596: l_sf52_rec.first_action_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY',l_sf52_rec.first_action_la_code1);

592:
593: ---LAC Details
594:
595: l_sf52_rec.first_action_la_code1 := 'DPM';
596: l_sf52_rec.first_action_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY',l_sf52_rec.first_action_la_code1);
597:
598: ---NOA Desc
599: BEGIN
600: ghr_mass_actions_pkg.get_noa_id_desc

Line 839: l_sf52_rec.fegli_desc := ghr_pa_requests_pkg.get_lookup_meaning

835: p_value => l_old_fegli,
836: p_multiple_error_flag => l_multiple_error_flag
837: );
838: l_sf52_rec.fegli := l_old_fegli;
839: l_sf52_rec.fegli_desc := ghr_pa_requests_pkg.get_lookup_meaning
840: (800
841: ,'GHR_US_FEGLI'
842: ,l_sf52_rec.fegli
843: );

Line 993: l_fegli_desc := ghr_pa_requests_pkg.get_lookup_meaning

989: fetch get_rpa_det into l_sf52_rec;
990: close get_rpa_det;
991:
992:
993: l_fegli_desc := ghr_pa_requests_pkg.get_lookup_meaning
994: (800
995: ,'GHR_US_FEGLI'
996: ,p_fegli_code
997: );

Line 1263: l_sf52_rec.fegli_desc := ghr_pa_requests_pkg.get_lookup_meaning

1259: p_value => l_old_fegli,
1260: p_multiple_error_flag => l_multiple_error_flag
1261: );
1262: l_sf52_rec.fegli := l_old_fegli;
1263: l_sf52_rec.fegli_desc := ghr_pa_requests_pkg.get_lookup_meaning
1264: (800
1265: ,'GHR_US_FEGLI'
1266: ,l_sf52_rec.fegli
1267: );