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

Line 798: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

794:
795: pr('After check sel flg value is ',l_sel_flg,l_sel_status);
796: l_ind := 70;
797: begin
798: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
799: (p_location_id => l_location_id
800: ,p_duty_station_id => l_duty_station_id);
801: exception
802: when others then

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

799: (p_location_id => l_location_id
800: ,p_duty_station_id => l_duty_station_id);
801: exception
802: when others then
803: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
804: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
805: 'Err is '||sqlerrm(sqlcode),20);
806: l_mass_errbuf := 'Error in get_sf52_loc_ddf_details Sql Err is '||
807: sqlerrm(sqlcode);

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

800: ,p_duty_station_id => l_duty_station_id);
801: exception
802: when others then
803: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
804: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
805: 'Err is '||sqlerrm(sqlcode),20);
806: l_mass_errbuf := 'Error in get_sf52_loc_ddf_details Sql Err is '||
807: sqlerrm(sqlcode);
808: raise mass_error;

Line 856: ghr_pa_requests_pkg.get_sf52_asg_ddf_details

852: per.person_id) then
853:
854: l_ind := 60;
855: BEGIN
856: ghr_pa_requests_pkg.get_sf52_asg_ddf_details
857: (l_assignment_id,
858: l_effective_date,
859: l_tenure,
860: l_annuitant_indicator,

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

862: l_work_schedule,
863: l_part_time_hour);
864: EXCEPTION
865: when others then
866: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
867: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
868: 'Err is '||sqlerrm(sqlcode),20);
869: l_mass_errbuf := 'Error in get_sf52_asgddf_details Sql Err is '||
870: sqlerrm(sqlcode);

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

863: l_part_time_hour);
864: EXCEPTION
865: when others then
866: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
867: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
868: 'Err is '||sqlerrm(sqlcode),20);
869: l_mass_errbuf := 'Error in get_sf52_asgddf_details Sql Err is '||
870: sqlerrm(sqlcode);
871: raise mass_error;

Line 913: ghr_pa_requests_pkg.get_duty_station_details

909: l_appropriation_code2,
910: l_pos_grp2_rec);
911: l_ind := 90;
912: BEGIN
913: ghr_pa_requests_pkg.get_duty_station_details
914: (p_duty_station_id => l_duty_station_id
915: ,p_effective_date => l_effective_date
916: ,p_duty_station_code => l_duty_station_code
917: ,p_duty_station_desc => l_duty_station_desc);

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

916: ,p_duty_station_code => l_duty_station_code
917: ,p_duty_station_desc => l_duty_station_desc);
918: EXCEPTION
919: when others then
920: pr('Error in Ghr_pa_requests_pkg.get_duty_station_details');
921: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
922: 'Err is '||sqlerrm(sqlcode),20);
923: l_mass_errbuf := 'Error in get_duty_station_details Sql Err is '||
924: sqlerrm(sqlcode);

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

917: ,p_duty_station_desc => l_duty_station_desc);
918: EXCEPTION
919: when others then
920: pr('Error in Ghr_pa_requests_pkg.get_duty_station_details');
921: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
922: 'Err is '||sqlerrm(sqlcode),20);
923: l_mass_errbuf := 'Error in get_duty_station_details Sql Err is '||
924: sqlerrm(sqlcode);
925: raise mass_error;

Line 1278: IF ghr_pa_requests_pkg.get_pos_availability_status(l_avail_status_id)

1274: hr_general.decode_availability_status is return pos_aval_status description not the system code
1275: IF ( HR_GENERAL.DECODE_AVAILABILITY_STATUS(l_avail_status_id)
1276: not in ('Eliminated','Frozen','Deleted') ) THEN*/
1277:
1278: IF ghr_pa_requests_pkg.get_pos_availability_status(l_avail_status_id)
1279: NOT IN ('DELETED','FROZEN','ELIMINATED') THEN
1280: --End Bug# 13684234
1281:
1282: l_position_id := per.position_id;

Line 1347: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

1343: l_position_organization,
1344: l_pos_grp1_rec);
1345:
1346: begin
1347: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
1348: (p_location_id => l_location_id
1349: ,p_duty_station_id => l_duty_station_id);
1350: end;
1351:

Line 1353: ghr_pa_requests_pkg.get_duty_station_details

1349: ,p_duty_station_id => l_duty_station_id);
1350: end;
1351:
1352: begin
1353: ghr_pa_requests_pkg.get_duty_station_details
1354: (p_duty_station_id => l_duty_station_id
1355: ,p_effective_date => l_effective_date
1356: ,p_duty_station_code => l_duty_station_code
1357: ,p_duty_station_desc => l_duty_station_desc);

Line 1456: IF ghr_pa_requests_pkg.get_pos_availability_status(l_avail_status_id)

1452: hr_general.decode_availability_status is return pos_aval_status description not the system code
1453: IF ( HR_GENERAL.DECODE_AVAILABILITY_STATUS(l_avail_status_id)
1454: not in ('Eliminated','Frozen','Deleted') ) THEN*/
1455:
1456: IF ghr_pa_requests_pkg.get_pos_availability_status(l_avail_status_id)
1457: NOT IN ('DELETED','FROZEN','ELIMINATED') THEN
1458: --End Bug# 13684234
1459:
1460: IF check_select_flg(per_vacant.position_id,upper(p_action),