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

Line 676: ghr_pa_requests_pkg.get_sf52_asg_ddf_details

672: ,p_business_group_id => per.business_group_id
673: );
674: l_ind := 60;
675: BEGIN
676: ghr_pa_requests_pkg.get_sf52_asg_ddf_details
677: (l_assignment_id,
678: l_effective_DATE,
679: l_tenure,
680: l_annuitant_indicator,

Line 686: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');

682: l_work_schedule,
683: l_part_time_hour);
684: EXCEPTION
685: when others then
686: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
687: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
688: 'Err is '||sqlerrm(sqlcode),20);
689: l_mslerrbuf := 'Error in get_sf52_asgddf_details Sql Err is '||
690: sqlerrm(sqlcode);

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

683: l_part_time_hour);
684: EXCEPTION
685: when others then
686: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
687: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
688: 'Err is '||sqlerrm(sqlcode),20);
689: l_mslerrbuf := 'Error in get_sf52_asgddf_details Sql Err is '||
690: sqlerrm(sqlcode);
691: raise mass_error;

Line 710: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

706: raise mass_error;
707: END;
708: l_ind := 70;
709: BEGIN
710: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
711: (p_location_id => l_location_id
712: ,p_duty_station_id => l_duty_station_id);
713: EXCEPTION
714: when others then

Line 715: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');

711: (p_location_id => l_location_id
712: ,p_duty_station_id => l_duty_station_id);
713: EXCEPTION
714: when others then
715: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
716: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
717: 'Err is '||sqlerrm(sqlcode),20);
718: -- Bug 3718167 Added Person,SSN in the message instead of person_id
719: l_mslerrbuf := 'Error in get_sf52_loc_ddf_details Sql Err is '||

Line 716: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||

712: ,p_duty_station_id => l_duty_station_id);
713: EXCEPTION
714: when others then
715: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
716: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
717: 'Err is '||sqlerrm(sqlcode),20);
718: -- Bug 3718167 Added Person,SSN in the message instead of person_id
719: l_mslerrbuf := 'Error in get_sf52_loc_ddf_details Sql Err is '||
720: sqlerrm(sqlcode);

Line 733: ghr_pa_requests_pkg.get_duty_station_details

729: l_appropriation_code2);
730: --l_pos_grp2_rec);
731: l_ind := 90;
732: BEGIN
733: ghr_pa_requests_pkg.get_duty_station_details
734: (p_duty_station_id => l_duty_station_id
735: ,p_effective_DATE => l_effective_DATE
736: ,p_duty_station_code => l_duty_station_code
737: ,p_duty_station_desc => l_duty_station_desc);

Line 740: pr('Error in Ghr_pa_requests_pkg.get_duty_station_details');

736: ,p_duty_station_code => l_duty_station_code
737: ,p_duty_station_desc => l_duty_station_desc);
738: EXCEPTION
739: when others then
740: pr('Error in Ghr_pa_requests_pkg.get_duty_station_details');
741: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
742: 'Err is '||sqlerrm(sqlcode),20);
743: l_mslerrbuf := 'Error in get_duty_station_details Sql Err is '||
744: sqlerrm(sqlcode);

Line 741: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||

737: ,p_duty_station_desc => l_duty_station_desc);
738: EXCEPTION
739: when others then
740: pr('Error in Ghr_pa_requests_pkg.get_duty_station_details');
741: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
742: 'Err is '||sqlerrm(sqlcode),20);
743: l_mslerrbuf := 'Error in get_duty_station_details Sql Err is '||
744: sqlerrm(sqlcode);
745: raise mass_error;

Line 1055: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop( p_assignment_id => l_assignment_id

1051: END;
1052:
1053: --Call Pay cap Procedure
1054: BEGIN
1055: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop( p_assignment_id => l_assignment_id
1056: ,p_effective_DATE => l_effective_DATE);
1057: ghr_pay_caps.do_pay_caps_main
1058: (p_pa_request_id => null
1059: ,p_effective_DATE => l_effective_DATE

Line 1276: ghr_pa_requests_pkg.get_rei_org_lines(

1272: l_dummy NUMBER;
1273: l_personnel_officer_name per_people_f.full_name%type;
1274: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;
1275: BEGIN
1276: ghr_pa_requests_pkg.get_rei_org_lines(
1277: p_pa_request_id => l_sf52_rec.pa_request_id,
1278: p_organization_id => l_organization_id,
1279: p_position_org_line1 => l_position_org_line1,
1280: p_position_org_line2 => l_position_org_line2,

Line 1509: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

1505: l_appropriation_code1,
1506: l_appropriation_code2);
1507:
1508: BEGIN
1509: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
1510: (p_location_id => l_location_id
1511: ,p_duty_station_id => l_duty_station_id);
1512: END;
1513:

Line 1515: ghr_pa_requests_pkg.get_duty_station_details

1511: ,p_duty_station_id => l_duty_station_id);
1512: END;
1513:
1514: BEGIN
1515: ghr_pa_requests_pkg.get_duty_station_details
1516: (p_duty_station_id => l_duty_station_id
1517: ,p_effective_DATE => l_effective_DATE
1518: ,p_duty_station_code => l_duty_station_code
1519: ,p_duty_station_desc => l_duty_station_desc);

Line 1724: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

1720: );
1721:
1722: l_location_id := per_vacant.location_id;
1723: BEGIN
1724: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
1725: (p_location_id => l_location_id
1726: ,p_duty_station_id => l_duty_station_id);
1727: END;
1728:

Line 1730: ghr_pa_requests_pkg.get_duty_station_details

1726: ,p_duty_station_id => l_duty_station_id);
1727: END;
1728:
1729: BEGIN
1730: ghr_pa_requests_pkg.get_duty_station_details
1731: (p_duty_station_id => l_duty_station_id
1732: ,p_effective_DATE => l_effective_DATE
1733: ,p_duty_station_code => l_duty_station_code
1734: ,p_duty_station_desc => l_duty_station_desc);

Line 3526: ghr_pa_requests_pkg.get_duty_station_details

3522: END IF;
3523:
3524: if l_duty_station_id is not null or o_duty_station_id is not null then
3525: ----- Duty station is changed
3526: ghr_pa_requests_pkg.get_duty_station_details
3527: (p_duty_station_id => ll_duty_station_id
3528: ,p_effective_DATE => p_effective_DATE
3529: ,p_duty_station_code => ll_duty_station_code
3530: ,p_duty_station_desc => ll_duty_station_desc);