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

Line 412: p_first_lac1_record.first_action_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY','VDR');

408: g_equivalent_pay_plan := l_eql_pay_plan.equivalent_pay_plan;
409: END LOOP;
410: IF g_equivalent_pay_plan ='ES' THEN
411: p_first_lac1_record.first_action_la_code1 := 'VDR';
412: p_first_lac1_record.first_action_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY','VDR');
413: ELSE
414: p_first_lac1_record.first_action_la_code1 := 'VAJ';
415: p_first_lac1_record.first_action_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY','VAJ');
416: END IF;

Line 415: p_first_lac1_record.first_action_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY','VAJ');

411: p_first_lac1_record.first_action_la_code1 := 'VDR';
412: p_first_lac1_record.first_action_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY','VDR');
413: ELSE
414: p_first_lac1_record.first_action_la_code1 := 'VAJ';
415: p_first_lac1_record.first_action_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY','VAJ');
416: END IF;
417: ELSIF p_noa_action ='292' THEN
418: p_first_lac1_record.first_action_la_code1 := 'CGM';
419: p_first_lac1_record.first_action_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY','CGM');

Line 419: p_first_lac1_record.first_action_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY','CGM');

415: p_first_lac1_record.first_action_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY','VAJ');
416: END IF;
417: ELSIF p_noa_action ='292' THEN
418: p_first_lac1_record.first_action_la_code1 := 'CGM';
419: p_first_lac1_record.first_action_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY','CGM');
420:
421: END IF;
422: hr_utility.set_location('Leaving ' || l_proc,20);
423:

Line 1228: l_pa_request_rec.noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family

1224: p_effective_date => l_pa_request_rec.effective_date,
1225: p_noa_id => l_pa_request_rec.first_noa_id,
1226: p_noa_desc => l_pa_request_rec.first_noa_desc
1227: );
1228: l_pa_request_rec.noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family
1229: (p_nature_of_action_id => l_pa_request_rec.first_noa_id);
1230:
1231: hr_utility.set_location(l_proc,20);
1232: ghr_pa_requests_pkg.get_person_details

Line 1232: ghr_pa_requests_pkg.get_person_details

1228: l_pa_request_rec.noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family
1229: (p_nature_of_action_id => l_pa_request_rec.first_noa_id);
1230:
1231: hr_utility.set_location(l_proc,20);
1232: ghr_pa_requests_pkg.get_person_details
1233: (p_person_id => p_person_id
1234: ,p_effective_date => p_effective_date
1235: ,p_national_identifier => l_pa_request_rec.employee_national_identifier
1236: ,p_date_of_birth => l_pa_request_rec.employee_date_of_birth

Line 1243: l_employee_number := ghr_pa_requests_pkg2.get_employee_number

1239: ,p_middle_names => l_pa_request_rec.employee_middle_names
1240: );
1241:
1242: If p_person_id is not null then
1243: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
1244: (p_person_id => p_person_id,
1245: p_effective_date => p_effective_date);
1246: End if;
1247:

Line 1298: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

1294:
1295: hr_utility.set_location(l_proc,30);
1296: l_pa_request_rec.duty_station_location_id := l_duty_station_location_id;
1297:
1298: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
1299: (p_location_id => l_duty_station_location_id
1300: ,p_duty_station_id => l_pa_request_rec.duty_station_id);
1301:
1302: ghr_pa_requests_pkg.get_duty_station_details

Line 1302: ghr_pa_requests_pkg.get_duty_station_details

1298: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
1299: (p_location_id => l_duty_station_location_id
1300: ,p_duty_station_id => l_pa_request_rec.duty_station_id);
1301:
1302: ghr_pa_requests_pkg.get_duty_station_details
1303: (p_duty_station_id => l_pa_request_rec.duty_station_id
1304: ,p_effective_date => l_pa_request_rec.effective_date
1305: ,p_duty_station_code => l_pa_request_rec.duty_station_code
1306: ,p_duty_station_desc => l_pa_request_rec.duty_station_desc);

Line 1361: ghr_pa_requests_pkg.get_sf52_pos_ddf_details

1357: l_pa_request_rec.to_pay_plan := l_pa_request_rec.from_pay_plan;
1358: END IF;
1359:
1360: hr_utility.set_location(l_proc,40);
1361: ghr_pa_requests_pkg.get_sf52_pos_ddf_details
1362: (p_position_id => p_position_id
1363: ,p_date_Effective => l_pa_request_rec.effective_date
1364: ,p_flsa_category => l_pa_request_rec.flsa_category
1365: ,p_bargaining_unit_status => l_pa_request_rec.bargaining_unit_status

Line 1391: l_pa_request_rec.employee_dept_or_agency := ghr_pa_requests_pkg.get_lookup_meaning

1387: ,p_effective_date => p_effective_date);
1388:
1389: hr_utility.set_location('Agency Code ' || l_pa_request_rec.agency_code ,52);
1390:
1391: l_pa_request_rec.employee_dept_or_agency := ghr_pa_requests_pkg.get_lookup_meaning
1392: (800
1393: ,'GHR_US_AGENCY_CODE'
1394: ,l_pa_request_rec.agency_code
1395: );

Line 1397: ghr_pa_requests_pkg.get_SF52_person_ddf_details

1393: ,'GHR_US_AGENCY_CODE'
1394: ,l_pa_request_rec.agency_code
1395: );
1396:
1397: ghr_pa_requests_pkg.get_SF52_person_ddf_details
1398: (p_person_id => l_pa_request_rec.person_id,
1399: p_date_effective => l_pa_request_rec.effective_date,
1400: p_citizenship => l_pa_request_rec.citizenship,
1401: p_veterans_preference => l_pa_request_rec.veterans_preference,

Line 1421: ghr_pa_requests_pkg.get_SF52_asg_ddf_details

1417: p_year_degree_attained => l_pa_request_rec.year_degree_attained
1418: );
1419:
1420: hr_utility.set_location(l_proc,80);
1421: ghr_pa_requests_pkg.get_SF52_asg_ddf_details
1422: (p_assignment_id => l_pa_request_rec.employee_assignment_id
1423: ,p_date_effective => l_pa_request_rec.effective_date
1424: ,p_tenure => l_pa_request_rec.tenure
1425: ,p_annuitant_indicator => l_pa_request_rec.annuitant_indicator

Line 1432: l_pa_request_rec.annuitant_indicator_desc := ghr_pa_requests_pkg.get_lookup_meaning

1428: ,p_part_time_hours => l_pa_request_rec.part_time_hours
1429: );
1430:
1431: -- Annuitant_indicator
1432: l_pa_request_rec.annuitant_indicator_desc := ghr_pa_requests_pkg.get_lookup_meaning
1433: (800
1434: ,'GHR_US_ANNUITANT_INDICATOR'
1435: ,l_pa_request_rec.annuitant_indicator
1436: );

Line 1439: l_pa_request_rec.work_schedule_desc := ghr_pa_requests_pkg.get_lookup_meaning

1435: ,l_pa_request_rec.annuitant_indicator
1436: );
1437:
1438: --WORK_SCHEDULE
1439: l_pa_request_rec.work_schedule_desc := ghr_pa_requests_pkg.get_lookup_meaning
1440: (800
1441: ,'GHR_US_WORK_SCHEDULE'
1442: ,l_pa_request_rec.work_schedule
1443: );

Line 1455: l_pa_request_rec.fegli_desc := ghr_pa_requests_pkg.get_lookup_meaning

1451: ,p_effective_date => l_pa_request_rec.effective_date
1452: ,p_value => l_pa_request_rec.fegli
1453: ,p_multiple_error_flag => l_multiple_error_flag
1454: );
1455: l_pa_request_rec.fegli_desc := ghr_pa_requests_pkg.get_lookup_meaning
1456: (800
1457: ,'GHR_US_FEGLI'
1458: ,l_pa_request_rec.fegli
1459: );

Line 1472: l_pa_request_rec.retirement_plan_desc := ghr_pa_requests_pkg.get_lookup_meaning

1468: ,p_value => l_pa_request_rec.retirement_plan
1469: ,p_multiple_error_flag => l_multiple_error_flag
1470: );
1471:
1472: l_pa_request_rec.retirement_plan_desc := ghr_pa_requests_pkg.get_lookup_meaning
1473: (800
1474: ,'GHR_US_RETIREMENT_PLAN'
1475: ,l_pa_request_rec.retirement_plan
1476: );

Line 2010: l_employee_number := ghr_pa_requests_pkg2.get_employee_number

2006: hr_utility.set_location('SSN: '||per.national_identifier,2000);
2007: hr_utility.set_location('Position Id: '||per.position_id,2000);
2008: hr_utility.set_location('BG Id: '||per.business_group_id,2000);
2009: l_full_name := per.last_name||','|| per.first_name||' '||per.middle_names;
2010: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
2011: (p_person_id => per.person_id,
2012: p_effective_date => l_effective_date);
2013:
2014: ghr_history_fetch.fetch_asgei