APPS.GHR_SS_RPA_CREATION dependencies on GHR_MASS_ACTIONS_PKG

Line 556: ghr_mass_actions_pkg.get_personnel_officer_name

552: ,'GHR_US_RETIREMENT_PLAN'
553: ,l_sf52_rec.retirement_plan
554: );
555: BEGIN
556: ghr_mass_actions_pkg.get_personnel_officer_name
557: (p_personnel_office_id => l_sf52_rec.personnel_office_id,
558: p_person_full_name => l_personnel_officer_name,
559: p_approving_off_work_title => l_approving_off_work_title);
560: EXCEPTION

Line 562: hr_utility.set_location('Error in ghr_mass_actions_pkg.get_personnel_officer_name'||

558: p_person_full_name => l_personnel_officer_name,
559: p_approving_off_work_title => l_approving_off_work_title);
560: EXCEPTION
561: WHEN OTHERS THEN
562: hr_utility.set_location('Error in ghr_mass_actions_pkg.get_personnel_officer_name'||
563: 'Err is '||sqlerrm(sqlcode),20);
564: l_log_text := 'Error in get_personnel_officer_name for employee with Emp No: '||l_employee_number||'; Name:'||l_full_name
565: || '; SQL Error:'|| sqlerrm(sqlcode);
566: raise fegli_error;

Line 600: ghr_mass_actions_pkg.get_noa_id_desc

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
601: (p_noa_code => l_sf52_rec.first_noa_code,
602: p_effective_date => l_sf52_rec.effective_date,
603: p_noa_id => l_sf52_rec.first_noa_id,
604: p_noa_desc => l_sf52_rec.first_noa_desc

Line 608: hr_utility.set_location('Error in ghr_mass_actions_pkg.get_noa_id_desc'||

604: p_noa_desc => l_sf52_rec.first_noa_desc
605: );
606: EXCEPTION
607: WHEN OTHERS THEN
608: hr_utility.set_location('Error in ghr_mass_actions_pkg.get_noa_id_desc'||
609: 'Err is '||sqlerrm(sqlcode),20);
610: l_log_text := 'Error in get_noa_id_desc for employee with Emp No: '||l_employee_number||'; Name:'||l_full_name
611: || '; SQL Error:'|| sqlerrm(sqlcode);
612: raise fegli_error;

Line 805: ghr_mass_actions_pkg.get_personnel_off_groupbox(l_sf52_rec.to_position_id,

801:
802:
803:
804: BEGIN
805: ghr_mass_actions_pkg.get_personnel_off_groupbox(l_sf52_rec.to_position_id,
806: l_sf52_rec.effective_date,
807: l_groupbox_id,
808: l_routing_group_id);
809:

Line 1217: ghr_mass_actions_pkg.get_personnel_off_groupbox(l_sf52_rec.to_position_id,

1213: hr_utility.set_location('l_sf52_rec.effective_date'||l_sf52_rec.effective_date,10);
1214:
1215:
1216: BEGIN
1217: ghr_mass_actions_pkg.get_personnel_off_groupbox(l_sf52_rec.to_position_id,
1218: l_sf52_rec.effective_date,
1219: l_groupbox_id,
1220: l_routing_group_id);
1221:

Line 1391: ghr_mass_actions_pkg.get_remark_id_desc

1387:
1388: -- get remark_id remark_desc, remark_code_information1, ...
1389: hr_utility.set_location('Entering ' || l_proc,5);
1390:
1391: ghr_mass_actions_pkg.get_remark_id_desc
1392: (p_remark_code => p_remark_code,
1393: p_effective_date => trunc(nvl(p_effective_date,sysdate)),
1394: p_remark_id => l_remark_id,
1395: p_remark_desc => l_description