DBA Data[Home] [Help]

APPS.GHR_SS_RPA_CREATION dependencies on GHR_PAR_UPD

Line 134: l_log_text := 'Error in ghr_par_upd.upd for employee with Emp No: '||l_employee_number||'; Name:'||l_full_name

130: p_fegli_code => p_fegli_code,
131: p_effective_date => p_effective_date);
132: EXCEPTION
133: WHEN OTHERS THEN
134: l_log_text := 'Error in ghr_par_upd.upd for employee with Emp No: '||l_employee_number||'; Name:'||l_full_name
135: || '; Error: '||sqlerrm(sqlcode);
136: raise fegli_upd_error;
137: END;
138: end if;

Line 822: ghr_par_upd.upd(

818: p_pa_routing_history_id => l_1_pa_routing_history_id,
819: p_groupbox_id => l_groupbox_id,
820: p_object_version_number => l_1_prh_object_version_number);
821:
822: ghr_par_upd.upd(
823: p_pa_request_id => l_sf52_rec.pa_request_id,
824: p_routing_group_id => l_routing_group_id,
825: p_object_version_number => l_sf52_rec.object_version_number);
826:

Line 881: ghr_par_upd.upd

877: || '; Error: '||sqlerrm(sqlcode);
878: RAISE fegli_error;
879: END;
880:
881: ghr_par_upd.upd
882: (p_pa_request_id => l_sf52_rec.pa_request_id,
883: p_object_version_number => l_sf52_rec.object_version_number,
884: p_agency_code => l_sf52_rec.agency_code,
885: p_from_agency_code => l_sf52_rec.from_agency_code,

Line 1247: ghr_par_upd.upd(

1243: p_action_taken => 'FUTURE_ACTION');
1244: hr_utility.set_location('before updating par'||l_routing_group_id,1005);
1245: hr_utility.set_location('before updating par'||l_sf52_rec.object_version_number,1006);
1246: --hr_utility.trace_off;
1247: ghr_par_upd.upd(
1248: p_pa_request_id => l_sf52_rec.pa_request_id,
1249: p_routing_group_id => l_routing_group_id,
1250: p_object_version_number => l_sf52_rec.object_version_number);
1251:

Line 1303: ghr_par_upd.upd

1299: || '; Error: '||sqlerrm(sqlcode);
1300: RAISE fegli_upd_error;
1301: END;
1302:
1303: ghr_par_upd.upd
1304: (p_pa_request_id => l_sf52_rec.pa_request_id,
1305: p_object_version_number => l_sf52_rec.object_version_number,
1306: p_agency_code => l_sf52_rec.agency_code,
1307: p_from_agency_code => l_sf52_rec.from_agency_code,