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_SS_RPA_CREATION dependencies on GHR_PA_REQUESTS

Line 20: FROM GHR_PA_REQUESTS

16: object_version_number,
17: employee_first_name,
18: employee_last_name,
19: employee_middle_names
20: FROM GHR_PA_REQUESTS
21: WHERE person_id = p_person_id
22: and employee_assignment_id = p_assignment_id
23: and effective_date = p_effective_date
24: and first_noa_code = '881'

Line 30: FROM GHR_PA_REQUESTS

26:
27: CURSOR get_rpa_det(p_pa_request_id in number)
28: IS
29: SELECT work_schedule
30: FROM GHR_PA_REQUESTS
31: WHERE pa_request_id = p_pa_request_id;
32:
33: CURSOR del_exists_rem(p_pa_request_id in number)
34: IS

Line 60: l_curr_fegli ghr_pa_requests.fegli%type;

56: WHERE person_id = p_person_id
57: AND p_effective_date between effective_start_date
58: and effective_end_date;
59:
60: l_curr_fegli ghr_pa_requests.fegli%type;
61: l_pa_request_id ghr_pa_requests.pa_request_id%type;
62: l_object_version_number ghr_pa_requests.object_version_number%type;
63: l_proc varchar2(72) := g_package || 'create_sf52_fegli';
64: l_log_text varchar2(2000);

Line 61: l_pa_request_id ghr_pa_requests.pa_request_id%type;

57: AND p_effective_date between effective_start_date
58: and effective_end_date;
59:
60: l_curr_fegli ghr_pa_requests.fegli%type;
61: l_pa_request_id ghr_pa_requests.pa_request_id%type;
62: l_object_version_number ghr_pa_requests.object_version_number%type;
63: l_proc varchar2(72) := g_package || 'create_sf52_fegli';
64: l_log_text varchar2(2000);
65: l_full_name VARCHAR2(380);

Line 62: l_object_version_number ghr_pa_requests.object_version_number%type;

58: and effective_end_date;
59:
60: l_curr_fegli ghr_pa_requests.fegli%type;
61: l_pa_request_id ghr_pa_requests.pa_request_id%type;
62: l_object_version_number ghr_pa_requests.object_version_number%type;
63: l_proc varchar2(72) := g_package || 'create_sf52_fegli';
64: l_log_text varchar2(2000);
65: l_full_name VARCHAR2(380);
66: l_employee_number per_people_f.employee_number%type;

Line 70: l_wrk_sch ghr_pa_requests.work_schedule%type;

66: l_employee_number per_people_f.employee_number%type;
67: l_employee_first_name per_people_f.first_name%type;
68: l_employee_last_name per_people_f.last_name%type;
69: l_employee_middle_names per_people_f.middle_names%type;
70: l_wrk_sch ghr_pa_requests.work_schedule%type;
71: l_fegli_element_value ghr_pa_requests.fegli%type;
72: l_elig_exp varchar2(30);
73: l_event_code varchar2(30);
74: l_multiple_error_flag boolean;

Line 71: l_fegli_element_value ghr_pa_requests.fegli%type;

67: l_employee_first_name per_people_f.first_name%type;
68: l_employee_last_name per_people_f.last_name%type;
69: l_employee_middle_names per_people_f.middle_names%type;
70: l_wrk_sch ghr_pa_requests.work_schedule%type;
71: l_fegli_element_value ghr_pa_requests.fegli%type;
72: l_elig_exp varchar2(30);
73: l_event_code varchar2(30);
74: l_multiple_error_flag boolean;
75: fegli_null_error exception;

Line 93: l_employee_number := ghr_pa_requests_pkg2.get_employee_number

89: open chk_fegli_exists;
90: fetch chk_fegli_exists into l_curr_fegli,l_pa_request_id,l_object_version_number,
91: l_employee_last_name,l_employee_first_name,l_employee_middle_names;
92: l_full_name := l_employee_last_name||','|| l_employee_first_name||' '|| l_employee_middle_names;
93: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
94: (p_person_id => p_person_id,
95: p_effective_date => p_effective_date);
96: if chk_fegli_exists%notfound then
97:

Line 273: l_sf52_rec ghr_pa_requests%rowtype;

269: FROM ghr_pa_routing_history prh
270: WHERE prh.pa_request_id = p_pa_request_id
271: ORDER BY 1 desc;
272:
273: l_sf52_rec ghr_pa_requests%rowtype;
274: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
275: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
276: l_2_prh_object_version_number ghr_pa_requests.object_version_number%type;
277: l_2_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;

Line 275: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;

271: ORDER BY 1 desc;
272:
273: l_sf52_rec ghr_pa_requests%rowtype;
274: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
275: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
276: l_2_prh_object_version_number ghr_pa_requests.object_version_number%type;
277: l_2_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
278: l_object_version_number ghr_pa_remarks.object_version_number%type;
279: l_full_name VARCHAR2(380);

Line 276: l_2_prh_object_version_number ghr_pa_requests.object_version_number%type;

272:
273: l_sf52_rec ghr_pa_requests%rowtype;
274: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
275: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
276: l_2_prh_object_version_number ghr_pa_requests.object_version_number%type;
277: l_2_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
278: l_object_version_number ghr_pa_remarks.object_version_number%type;
279: l_full_name VARCHAR2(380);
280: l_employee_number per_people_f.employee_number%type;

Line 281: l_routing_group_id ghr_pa_requests.routing_group_id%type;

277: l_2_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
278: l_object_version_number ghr_pa_remarks.object_version_number%type;
279: l_full_name VARCHAR2(380);
280: l_employee_number per_people_f.employee_number%type;
281: l_routing_group_id ghr_pa_requests.routing_group_id%type;
282: l_old_fegli ghr_pa_requests.fegli%type;
283: fegli_error exception;
284: l_log_text varchar2(2000);
285: l_dummy_char varchar2(150);

Line 282: l_old_fegli ghr_pa_requests.fegli%type;

278: l_object_version_number ghr_pa_remarks.object_version_number%type;
279: l_full_name VARCHAR2(380);
280: l_employee_number per_people_f.employee_number%type;
281: l_routing_group_id ghr_pa_requests.routing_group_id%type;
282: l_old_fegli ghr_pa_requests.fegli%type;
283: fegli_error exception;
284: l_log_text varchar2(2000);
285: l_dummy_char varchar2(150);
286: l_personnel_officer_name per_people_f.full_name%type;

Line 289: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;

285: l_dummy_char varchar2(150);
286: l_personnel_officer_name per_people_f.full_name%type;
287: l_groupbox_id ghr_groupboxes.groupbox_id%type;
288: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
289: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;
290: l_scd_leave varchar2(50);
291: l_multiple_error_flag boolean;
292: l_proc varchar2(72) := g_package || 'create_sf52_fegli_rpa';
293:

Line 321: l_employee_number := ghr_pa_requests_pkg2.get_employee_number

317: EXIT;
318: END LOOP;
319:
320: l_full_name := l_sf52_rec.employee_last_name||','|| l_sf52_rec.employee_first_name||' '|| l_sf52_rec.employee_middle_names;
321: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
322: (p_person_id => l_sf52_rec.person_id,
323: p_effective_date => l_sf52_rec.effective_date);
324:
325:

Line 327: ghr_pa_requests_pkg.get_sf52_asg_ddf_details(l_sf52_rec.employee_assignment_id,

323: p_effective_date => l_sf52_rec.effective_date);
324:
325:
326: BEGIN
327: ghr_pa_requests_pkg.get_sf52_asg_ddf_details(l_sf52_rec.employee_assignment_id,
328: p_effective_date,
329: l_sf52_rec.tenure,
330: l_sf52_rec.annuitant_indicator,
331: l_sf52_rec.pay_rate_determinant,

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

332: l_sf52_rec.work_schedule,
333: l_sf52_rec.part_time_hours);
334: EXCEPTION
335: WHEN OTHERS THEN
336: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
337: 'Err is '||sqlerrm(sqlcode),20);
338: l_log_text := 'Error in get_sf52_asgddf_details for employee with Emp No: '||l_employee_number||'; Name:'||l_full_name
339: || '; SQL Error: '|| sqlerrm(sqlcode);
340: raise fegli_error;

Line 354: ghr_pa_requests_pkg.get_SF52_pos_ddf_details

350: END LOOP;
351:
352:
353: BEGIN
354: ghr_pa_requests_pkg.get_SF52_pos_ddf_details
355: (p_position_id => l_sf52_rec.from_position_id
356: ,p_date_Effective => l_sf52_rec.effective_date
357: ,p_flsa_category => l_sf52_rec.flsa_category
358: ,p_bargaining_unit_status => l_sf52_rec.bargaining_unit_status

Line 370: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_SF52_pos_ddf_details'

366: ,p_office_symbol => l_sf52_rec.from_office_symbol
367: ,p_part_time_hours => l_sf52_rec.part_time_hours);
368: EXCEPTION
369: WHEN OTHERS THEN
370: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_SF52_pos_ddf_details'
371: || 'Err is' ||sqlerrm(sqlcode),20);
372: l_log_text := 'Error in get_SF52_pos_ddf_details for employee with Emp No: '||l_employee_number||'; Name:'||l_full_name
373: || '; SQL Error: '|| sqlerrm(sqlcode);
374: raise fegli_error;

Line 457: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

453: l_sf52_rec.to_position_org_line6 := l_sf52_rec.from_position_org_line6;
454: l_sf52_rec.to_position_id := l_sf52_rec.from_position_id;
455:
456: BEGIN
457: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
458: (p_location_id => l_sf52_rec.duty_station_location_id
459: ,p_duty_station_id => l_sf52_rec.duty_station_id);
460: EXCEPTION
461: WHEN OTHERS THEN

Line 462: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_SF52_loc_ddf_details'||

458: (p_location_id => l_sf52_rec.duty_station_location_id
459: ,p_duty_station_id => l_sf52_rec.duty_station_id);
460: EXCEPTION
461: WHEN OTHERS THEN
462: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_SF52_loc_ddf_details'||
463: 'Err is'||sqlerrm(sqlcode),20);
464: l_log_text := 'Error in get_SF52_loc_ddf_details for employee with Emp No: '||l_employee_number||'; Name:'||l_full_name
465: || '; SQL Error: '||sqlerrm(sqlcode);
466: raise fegli_error;

Line 470: ghr_pa_requests_pkg.get_duty_station_details

466: raise fegli_error;
467: END;
468:
469: BEGIN
470: ghr_pa_requests_pkg.get_duty_station_details
471: (p_duty_station_id => l_sf52_rec.duty_station_id
472: ,p_effective_date => l_sf52_rec.effective_date
473: ,p_duty_station_code => l_sf52_rec.duty_station_code
474: ,p_duty_station_desc => l_sf52_rec.duty_station_desc);

Line 477: hr_utility.set_location('Error in ghr_pa_requests_pkg.get_duty_station_details'||

473: ,p_duty_station_code => l_sf52_rec.duty_station_code
474: ,p_duty_station_desc => l_sf52_rec.duty_station_desc);
475: EXCEPTION
476: WHEN OTHERS THEN
477: hr_utility.set_location('Error in ghr_pa_requests_pkg.get_duty_station_details'||
478: 'Err is '||sqlerrm(sqlcode),20);
479: l_log_text := 'Error in get_duty_station_details for employee with Emp No: '||l_employee_number||'; Name:'||l_full_name
480: || '; SQL Error: '|| sqlerrm(sqlcode);
481: raise fegli_error;

Line 502: ghr_pa_requests_pkg.get_SF52_person_ddf_details

498: raise fegli_error;
499: END;
500:
501: BEGIN
502: ghr_pa_requests_pkg.get_SF52_person_ddf_details
503: (p_person_id => l_sf52_rec.person_id,
504: p_date_effective => l_sf52_rec.effective_date,
505: p_citizenship => l_sf52_rec.citizenship,
506: p_veterans_preference => l_sf52_rec.veterans_preference,

Line 513: hr_utility.set_location('Error in ghr_pa_requests_pkg.get_SF52_person_ddf_details'||

509: p_scd_leave => l_scd_leave
510: );
511: EXCEPTION
512: WHEN OTHERS THEN
513: hr_utility.set_location('Error in ghr_pa_requests_pkg.get_SF52_person_ddf_details'||
514: 'Err is '||sqlerrm(sqlcode),20);
515: l_log_text := 'Error in get_SF52_person_ddf_details for employee with Emp No: '||l_employee_number||'; Name:'||l_full_name
516: || '; SQL Error:'|| sqlerrm(sqlcode);
517: raise fegli_error;

Line 521: l_sf52_rec.annuitant_indicator_desc := ghr_pa_requests_pkg.get_lookup_meaning

517: raise fegli_error;
518: END;
519:
520: -- Annuitant_indicator
521: l_sf52_rec.annuitant_indicator_desc := ghr_pa_requests_pkg.get_lookup_meaning
522: (800
523: ,'GHR_US_ANNUITANT_INDICATOR'
524: ,l_sf52_rec.annuitant_indicator
525: );

Line 528: l_sf52_rec.work_schedule_desc := ghr_pa_requests_pkg.get_lookup_meaning

524: ,l_sf52_rec.annuitant_indicator
525: );
526:
527: --WORK_SCHEDULE
528: l_sf52_rec.work_schedule_desc := ghr_pa_requests_pkg.get_lookup_meaning
529: (800
530: ,'GHR_US_WORK_SCHEDULE'
531: ,l_sf52_rec.work_schedule
532: );

Line 534: l_sf52_rec.fegli_desc := ghr_pa_requests_pkg.get_lookup_meaning

530: ,'GHR_US_WORK_SCHEDULE'
531: ,l_sf52_rec.work_schedule
532: );
533:
534: l_sf52_rec.fegli_desc := ghr_pa_requests_pkg.get_lookup_meaning
535: (800
536: ,'GHR_US_FEGLI'
537: ,l_sf52_rec.fegli
538: );

Line 550: l_sf52_rec.retirement_plan_desc := ghr_pa_requests_pkg.get_lookup_meaning

546: ,p_multiple_error_flag => l_multiple_error_flag
547: );
548:
549:
550: l_sf52_rec.retirement_plan_desc := ghr_pa_requests_pkg.get_lookup_meaning
551: (800
552: ,'GHR_US_RETIREMENT_PLAN'
553: ,l_sf52_rec.retirement_plan
554: );

Line 596: l_sf52_rec.first_action_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY',l_sf52_rec.first_action_la_code1);

592:
593: ---LAC Details
594:
595: l_sf52_rec.first_action_la_code1 := 'DPM';
596: l_sf52_rec.first_action_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY',l_sf52_rec.first_action_la_code1);
597:
598: ---NOA Desc
599: BEGIN
600: ghr_mass_actions_pkg.get_noa_id_desc

Line 839: l_sf52_rec.fegli_desc := ghr_pa_requests_pkg.get_lookup_meaning

835: p_value => l_old_fegli,
836: p_multiple_error_flag => l_multiple_error_flag
837: );
838: l_sf52_rec.fegli := l_old_fegli;
839: l_sf52_rec.fegli_desc := ghr_pa_requests_pkg.get_lookup_meaning
840: (800
841: ,'GHR_US_FEGLI'
842: ,l_sf52_rec.fegli
843: );

Line 955: FROM GHR_PA_REQUESTS

951: p_effective_date in date) IS
952: CURSOR get_rpa_det
953: IS
954: SELECT *
955: FROM GHR_PA_REQUESTS
956: WHERE pa_request_id = p_pa_request_id;
957:
958: CURSOR c_routing_history(p_pa_request_id in number)
959: IS

Line 969: l_sf52_rec ghr_pa_requests%rowtype;

965:
966: l_uprh_object_version_number ghr_pa_routing_history.object_version_number%type;
967: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
968: l_iprh_object_version_number ghr_pa_routing_history.object_version_number%type;
969: l_sf52_rec ghr_pa_requests%rowtype;
970: l_full_name VARCHAR2(380);
971: l_employee_number per_people_f.employee_number%type;
972: l_routing_group_id ghr_pa_requests.routing_group_id%type;
973: fegli_upd_error exception;

Line 972: l_routing_group_id ghr_pa_requests.routing_group_id%type;

968: l_iprh_object_version_number ghr_pa_routing_history.object_version_number%type;
969: l_sf52_rec ghr_pa_requests%rowtype;
970: l_full_name VARCHAR2(380);
971: l_employee_number per_people_f.employee_number%type;
972: l_routing_group_id ghr_pa_requests.routing_group_id%type;
973: fegli_upd_error exception;
974: fegli_shadow_upd_error exception;
975: l_log_text varchar2(2000);
976: l_personnel_officer_name per_people_f.full_name%type;

Line 978: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;

974: fegli_shadow_upd_error exception;
975: l_log_text varchar2(2000);
976: l_personnel_officer_name per_people_f.full_name%type;
977: l_groupbox_id ghr_groupboxes.groupbox_id%type;
978: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;
979: l_object_version_number number;
980: l_result BOOLEAN;
981: l_fegli_desc ghr_pa_requests.fegli_desc%type;
982: l_old_fegli ghr_pa_requests.fegli%type;

Line 981: l_fegli_desc ghr_pa_requests.fegli_desc%type;

977: l_groupbox_id ghr_groupboxes.groupbox_id%type;
978: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;
979: l_object_version_number number;
980: l_result BOOLEAN;
981: l_fegli_desc ghr_pa_requests.fegli_desc%type;
982: l_old_fegli ghr_pa_requests.fegli%type;
983: l_multiple_error_flag boolean;
984:
985: l_proc varchar2(72) := g_package || 'update_sf52_fegli_rpa';

Line 982: l_old_fegli ghr_pa_requests.fegli%type;

978: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;
979: l_object_version_number number;
980: l_result BOOLEAN;
981: l_fegli_desc ghr_pa_requests.fegli_desc%type;
982: l_old_fegli ghr_pa_requests.fegli%type;
983: l_multiple_error_flag boolean;
984:
985: l_proc varchar2(72) := g_package || 'update_sf52_fegli_rpa';
986: BEGIN

Line 993: l_fegli_desc := ghr_pa_requests_pkg.get_lookup_meaning

989: fetch get_rpa_det into l_sf52_rec;
990: close get_rpa_det;
991:
992:
993: l_fegli_desc := ghr_pa_requests_pkg.get_lookup_meaning
994: (800
995: ,'GHR_US_FEGLI'
996: ,p_fegli_code
997: );

Line 1263: l_sf52_rec.fegli_desc := ghr_pa_requests_pkg.get_lookup_meaning

1259: p_value => l_old_fegli,
1260: p_multiple_error_flag => l_multiple_error_flag
1261: );
1262: l_sf52_rec.fegli := l_old_fegli;
1263: l_sf52_rec.fegli_desc := ghr_pa_requests_pkg.get_lookup_meaning
1264: (800
1265: ,'GHR_US_FEGLI'
1266: ,l_sf52_rec.fegli
1267: );

Line 1361: PROCEDURE CREATE_PA_REMARKS (p_pa_request_id in ghr_pa_requests.pa_request_id%type,

1357:
1358: END UPDATE_SF52_FEGLI_RPA;
1359:
1360:
1361: PROCEDURE CREATE_PA_REMARKS (p_pa_request_id in ghr_pa_requests.pa_request_id%type,
1362: p_effective_date in date,
1363: p_remark_code in ghr_remarks.code%type) IS
1364:
1365: cursor chk_rem_exists(p_remark_id in NUMBER)

Line 1663: PROCEDURE UPDATE_SHADOW_ROW(p_sf52_rec in ghr_pa_requests%rowtype,

1659: where pa_request_extra_info_id = l_pa_request_extra_info_id;
1660: END IF;
1661: END POPULATE_PA_REQUEST_EXTRA_INFO;
1662:
1663: PROCEDURE UPDATE_SHADOW_ROW(p_sf52_rec in ghr_pa_requests%rowtype,
1664: p_result out nocopy BOOLEAN) IS
1665: l_sf52_shadow_rec ghr_pa_request_shadow%ROWTYPE;
1666: BEGIN
1667: