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

Line 322: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;

318: l_step_or_rate VARCHAR2(30);
319: l_pay_basis VARCHAR2(30);
320: l_location_id NUMBER;
321: l_duty_station_id NUMBER;
322: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;
323: l_duty_station_code ghr_pa_requests.duty_station_code%type;
324:
325: l_check_child VARCHAR2(2);
326: l_check_org_pos VARCHAR2(2);

Line 323: l_duty_station_code ghr_pa_requests.duty_station_code%type;

319: l_pay_basis VARCHAR2(30);
320: l_location_id NUMBER;
321: l_duty_station_id NUMBER;
322: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;
323: l_duty_station_code ghr_pa_requests.duty_station_code%type;
324:
325: l_check_child VARCHAR2(2);
326: l_check_org_pos VARCHAR2(2);
327: l_avail_status_id NUMBER;

Line 369: t_duty_station_desc ghr_pa_requests.duty_station_desc%type;

365:
366: t_personnel_office_id VARCHAR2(300);
367: t_sub_element_code VARCHAR2(300);
368: t_duty_station_id NUMBER(15);
369: t_duty_station_desc ghr_pa_requests.duty_station_desc%type;
370: t_duty_station_code ghr_pa_requests.duty_station_code%type;
371: t_duty_station_locn_id NUMBER(15);
372: t_office_symbol VARCHAR2(30);
373: t_payroll_office_id VARCHAR2(30);

Line 370: t_duty_station_code ghr_pa_requests.duty_station_code%type;

366: t_personnel_office_id VARCHAR2(300);
367: t_sub_element_code VARCHAR2(300);
368: t_duty_station_id NUMBER(15);
369: t_duty_station_desc ghr_pa_requests.duty_station_desc%type;
370: t_duty_station_code ghr_pa_requests.duty_station_code%type;
371: t_duty_station_locn_id NUMBER(15);
372: t_office_symbol VARCHAR2(30);
373: t_payroll_office_id VARCHAR2(30);
374: t_org_func_code VARCHAR2(30);

Line 426: l_sf52_rec ghr_pa_requests%rowtype;

422: l_executive_order_DATE DATE;
423:
424: l_row_cnt NUMBER := 0;
425:
426: l_sf52_rec ghr_pa_requests%rowtype;
427: l_lac_sf52_rec ghr_pa_requests%rowtype;
428: l_errbuf VARCHAR2(2000);
429:
430: l_retcode NUMBER;

Line 427: l_lac_sf52_rec ghr_pa_requests%rowtype;

423:
424: l_row_cnt NUMBER := 0;
425:
426: l_sf52_rec ghr_pa_requests%rowtype;
427: l_lac_sf52_rec ghr_pa_requests%rowtype;
428: l_errbuf VARCHAR2(2000);
429:
430: l_retcode NUMBER;
431:

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 1297: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;

1293: l_position_org_line6 VARCHAR2(40);
1294: l_par_object_version_NUMBER NUMBER := l_sf52_rec.object_version_NUMBER;
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,

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 1340: l_pa_request_NUMBER ghr_pa_requests.request_NUMBER%TYPE;

1336: END IF;
1337:
1338: -- Added by Dinkar for reports
1339: declare
1340: l_pa_request_NUMBER ghr_pa_requests.request_NUMBER%TYPE;
1341: --
1342: BEGIN
1343: l_pa_request_NUMBER :=
1344: l_sf52_rec.request_NUMBER||'-'||p_mass_realignment_id;

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 2225: from ghr_pa_requests /, per_organization_units B/

2221: B.NAME ORGANIZATION_NAME,
2222: */
2223: EMPLOYEE_ASSIGNMENT_ID,
2224: PAY_RATE_DETERMINANT
2225: from ghr_pa_requests /*, per_organization_units B*/
2226: WHERE person_id = p_person_id
2227: and effective_DATE = p_effective_DATE
2228: -- Added by Dinkar for reports
2229: and substr(request_NUMBER,(instr(request_NUMBER,'-')+1)) = to_char(p_mass_realignment_id)

Line 2704: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;

2700: l_name per_people_f.full_name%type;
2701: -- Bug#3718167 Added l_ssn
2702: l_ssn per_people_f.national_identifier%TYPE;
2703: l_code_action VARCHAR2(65);
2704: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
2705: --Bug # 9329643
2706: l_employee_number per_people_f.employee_number%type;
2707:
2708:

Line 2711: from ghr_pa_requests pr, ghr_pa_routing_history prh

2707:
2708:
2709: cursor csr_action_taken is
2710: SELECT pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
2711: from ghr_pa_requests pr, ghr_pa_routing_history prh
2712: WHERE pr.pa_request_id = prh.pa_request_id
2713: and person_id = p_person_id
2714: and first_noa_code = p_first_noa_code
2715: and effective_DATE = p_effective_DATE

Line 2725: from ghr_pa_requests pr

2721: -- Bug#3718167 Added SSN in the cursor
2722: cursor csr_name is
2723: SELECT substr(pr.employee_last_name || ', ' || pr.employee_first_name,1,240) fname,
2724: pr.employee_national_identifier SSN
2725: from ghr_pa_requests pr
2726: WHERE pr.pa_request_id = l_pa_request_id;
2727:
2728: cursor pa_hist_cur (p_r_hist_id NUMBER) is
2729: SELECT nvl(action_taken,' ') action_taken

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 2794: from ghr_pa_requests pr, ghr_pa_routing_history prh

2790: return BOOLEAN is
2791: --
2792: cursor csr_action_taken is
2793: SELECT pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
2794: from ghr_pa_requests pr, ghr_pa_routing_history prh
2795: WHERE pr.pa_request_id = prh.pa_request_id
2796: and nvl(person_id,0) = p_person_id
2797: and nvl(second_noa_code,0) = p_second_noa_code
2798: and trunc(nvl(effective_DATE,sysDATE)) = trunc(p_effective_DATE)

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);

Line 3805: p_duty_station_code in ghr_pa_requests.duty_station_code%type,

3801: p_personnel_office_id in VARCHAR2,
3802: p_sub_element_code in VARCHAR2,
3803: p_duty_station_id in NUMBER,
3804: p_duty_station_locn_id in NUMBER,
3805: p_duty_station_code in ghr_pa_requests.duty_station_code%type,
3806: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
3807: p_office_symbol in VARCHAR2,
3808: p_payroll_office_id in VARCHAR2,
3809: p_org_func_code in VARCHAR2,

Line 3806: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,

3802: p_sub_element_code in VARCHAR2,
3803: p_duty_station_id in NUMBER,
3804: p_duty_station_locn_id in NUMBER,
3805: p_duty_station_code in ghr_pa_requests.duty_station_code%type,
3806: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
3807: p_office_symbol in VARCHAR2,
3808: p_payroll_office_id in VARCHAR2,
3809: p_org_func_code in VARCHAR2,
3810: p_appropriation_code1 in VARCHAR2,

Line 3813: p_lac_sf52_rec in ghr_pa_requests%rowtype,

3809: p_org_func_code in VARCHAR2,
3810: p_appropriation_code1 in VARCHAR2,
3811: p_appropriation_code2 in VARCHAR2,
3812: p_position_organization in VARCHAR2,
3813: p_lac_sf52_rec in ghr_pa_requests%rowtype,
3814: p_sf52_rec out NOCOPY ghr_pa_requests%rowtype) IS
3815:
3816: l_proc VARCHAR2(72)
3817: := g_package || '.assign_to_sf52_rec';

Line 3814: p_sf52_rec out NOCOPY ghr_pa_requests%rowtype) IS

3810: p_appropriation_code1 in VARCHAR2,
3811: p_appropriation_code2 in VARCHAR2,
3812: p_position_organization in VARCHAR2,
3813: p_lac_sf52_rec in ghr_pa_requests%rowtype,
3814: p_sf52_rec out NOCOPY ghr_pa_requests%rowtype) IS
3815:
3816: l_proc VARCHAR2(72)
3817: := g_package || '.assign_to_sf52_rec';
3818: BEGIN