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 687: ghr_pa_requests_pkg.get_sf52_asg_ddf_details

683: ,p_business_group_id => per.business_group_id
684: );
685: l_ind := 60;
686: BEGIN
687: ghr_pa_requests_pkg.get_sf52_asg_ddf_details
688: (l_assignment_id,
689: l_effective_DATE,
690: l_tenure,
691: l_annuitant_indicator,

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

693: l_work_schedule,
694: l_part_time_hour);
695: EXCEPTION
696: when others then
697: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
698: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
699: 'Err is '||sqlerrm(sqlcode),20);
700: l_mslerrbuf := 'Error in get_sf52_asgddf_details Sql Err is '||
701: sqlerrm(sqlcode);

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

694: l_part_time_hour);
695: EXCEPTION
696: when others then
697: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
698: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
699: 'Err is '||sqlerrm(sqlcode),20);
700: l_mslerrbuf := 'Error in get_sf52_asgddf_details Sql Err is '||
701: sqlerrm(sqlcode);
702: raise mass_error;

Line 721: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

717: raise mass_error;
718: END;
719: l_ind := 70;
720: BEGIN
721: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
722: (p_location_id => l_location_id
723: ,p_duty_station_id => l_duty_station_id);
724: EXCEPTION
725: when others then

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

722: (p_location_id => l_location_id
723: ,p_duty_station_id => l_duty_station_id);
724: EXCEPTION
725: when others then
726: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
727: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
728: 'Err is '||sqlerrm(sqlcode),20);
729: -- Bug 3718167 Added Person,SSN in the message instead of person_id
730: l_mslerrbuf := 'Error in get_sf52_loc_ddf_details Sql Err is '||

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

723: ,p_duty_station_id => l_duty_station_id);
724: EXCEPTION
725: when others then
726: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
727: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
728: 'Err is '||sqlerrm(sqlcode),20);
729: -- Bug 3718167 Added Person,SSN in the message instead of person_id
730: l_mslerrbuf := 'Error in get_sf52_loc_ddf_details Sql Err is '||
731: sqlerrm(sqlcode);

Line 744: ghr_pa_requests_pkg.get_duty_station_details

740: l_appropriation_code2);
741: --l_pos_grp2_rec);
742: l_ind := 90;
743: BEGIN
744: ghr_pa_requests_pkg.get_duty_station_details
745: (p_duty_station_id => l_duty_station_id
746: ,p_effective_DATE => l_effective_DATE
747: ,p_duty_station_code => l_duty_station_code
748: ,p_duty_station_desc => l_duty_station_desc);

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

747: ,p_duty_station_code => l_duty_station_code
748: ,p_duty_station_desc => l_duty_station_desc);
749: EXCEPTION
750: when others then
751: pr('Error in Ghr_pa_requests_pkg.get_duty_station_details');
752: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
753: 'Err is '||sqlerrm(sqlcode),20);
754: l_mslerrbuf := 'Error in get_duty_station_details Sql Err is '||
755: sqlerrm(sqlcode);

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

748: ,p_duty_station_desc => l_duty_station_desc);
749: EXCEPTION
750: when others then
751: pr('Error in Ghr_pa_requests_pkg.get_duty_station_details');
752: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
753: 'Err is '||sqlerrm(sqlcode),20);
754: l_mslerrbuf := 'Error in get_duty_station_details Sql Err is '||
755: sqlerrm(sqlcode);
756: raise mass_error;

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

1073: END;
1074:
1075: --Call Pay cap Procedure
1076: BEGIN
1077: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop( p_assignment_id => l_assignment_id
1078: ,p_effective_DATE => l_effective_DATE);
1079: ghr_pay_caps.do_pay_caps_main
1080: (p_pa_request_id => null
1081: ,p_effective_DATE => l_effective_DATE

Line 1299: ghr_pa_requests_pkg.get_rei_org_lines(

1295: l_dummy NUMBER;
1296: l_personnel_officer_name per_people_f.full_name%type;
1297: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;
1298: BEGIN
1299: ghr_pa_requests_pkg.get_rei_org_lines(
1300: p_pa_request_id => l_sf52_rec.pa_request_id,
1301: p_organization_id => l_organization_id,
1302: p_position_org_line1 => l_position_org_line1,
1303: p_position_org_line2 => l_position_org_line2,

Line 1473: IF ghr_pa_requests_pkg.get_pos_availability_status(l_avail_status_id)

1469: hr_general.decode_availability_status is return pos_aval_status description not the system code
1470: IF ( HR_GENERAL.DECODE_AVAILABILITY_STATUS(l_avail_status_id)
1471: not in ('Eliminated','Frozen','Deleted') ) THEN*/
1472:
1473: IF ghr_pa_requests_pkg.get_pos_availability_status(l_avail_status_id)
1474: NOT IN ('DELETED','FROZEN','ELIMINATED') THEN
1475: --End Bug# 13684234
1476:
1477: l_position_id := per.position_id;

Line 1539: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

1535: l_appropriation_code1,
1536: l_appropriation_code2);
1537:
1538: BEGIN
1539: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
1540: (p_location_id => l_location_id
1541: ,p_duty_station_id => l_duty_station_id);
1542: END;
1543:

Line 1545: ghr_pa_requests_pkg.get_duty_station_details

1541: ,p_duty_station_id => l_duty_station_id);
1542: END;
1543:
1544: BEGIN
1545: ghr_pa_requests_pkg.get_duty_station_details
1546: (p_duty_station_id => l_duty_station_id
1547: ,p_effective_DATE => l_effective_DATE
1548: ,p_duty_station_code => l_duty_station_code
1549: ,p_duty_station_desc => l_duty_station_desc);

Line 1714: IF ghr_pa_requests_pkg.get_pos_availability_status(l_avail_status_id)

1710: /* commented below code and added func get_pos_availability_status, since
1711: hr_general.decode_availability_status is return pos_aval_status description not the system code
1712: IF ( HR_GENERAL.DECODE_AVAILABILITY_STATUS(l_avail_status_id)
1713: not in ('Eliminated','Frozen','Deleted') ) THEN*/
1714: IF ghr_pa_requests_pkg.get_pos_availability_status(l_avail_status_id)
1715: NOT IN ('DELETED','FROZEN','ELIMINATED') THEN
1716: --End Bug# 13684234
1717:
1718: IF check_SELECT_flg(per_vacant.position_id,UPPER(p_action),

Line 1757: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

1753: l_location_id := per_vacant.location_id;
1754:
1755: --BUG #13872029 Added Exception procedure wise
1756: BEGIN
1757: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
1758: (p_location_id => l_location_id
1759: ,p_duty_station_id => l_duty_station_id);
1760: EXCEPTION
1761: WHEN OTHERS THEN

Line 1772: ghr_pa_requests_pkg.get_duty_station_details

1768: END;
1769:
1770: --BUG #13872029 Added Exception procedure wise
1771: BEGIN
1772: ghr_pa_requests_pkg.get_duty_station_details
1773: (p_duty_station_id => l_duty_station_id
1774: ,p_effective_DATE => l_effective_DATE
1775: ,p_duty_station_code => l_duty_station_code
1776: ,p_duty_station_desc => l_duty_station_desc);

Line 2764: l_employee_number := ghr_pa_requests_pkg2.get_employee_number

2760: exit;
2761: END loop;
2762: --Bug # 9329643
2763: If p_person_id is not null then
2764: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
2765: (p_person_id => p_person_id,
2766: p_effective_date => p_effective_date);
2767: End if;
2768: if l_action_taken <> 'CANCELED' then

Line 3693: ghr_pa_requests_pkg.get_duty_station_details

3689: END IF;
3690:
3691: if l_duty_station_id is not null or o_duty_station_id is not null then
3692: ----- Duty station is changed
3693: ghr_pa_requests_pkg.get_duty_station_details
3694: (p_duty_station_id => ll_duty_station_id
3695: ,p_effective_DATE => p_effective_DATE
3696: ,p_duty_station_code => ll_duty_station_code
3697: ,p_duty_station_desc => ll_duty_station_desc);