DBA Data[Home] [Help]

APPS.GHR_PROCESS_SF52 dependencies on GHR_PAR_UPD

Line 2844: ghr_par_upd.upd

2840: );
2841: FOR ovn_rec IN c_ovn (l_sf52_rec.pa_request_id) LOOP
2842: l_object_version_number := ovn_rec.object_version_number;
2843: END LOOP;
2844: ghr_par_upd.upd
2845: (p_pa_request_id => l_sf52_rec.pa_request_id,
2846: p_object_version_number => l_object_version_number,
2847: p_from_position_id => l_sf52_rec.from_position_id,
2848: p_to_position_id => l_sf52_rec.to_position_id,

Line 3305: ghr_par_upd.upd

3301: commit;
3302: Else
3303: p_route_flag := TRUE;
3304: l_log_text := 'Error while updating routing_group_id to ghr_pa_requests table';
3305: ghr_par_upd.upd
3306: (p_pa_request_id => p_pa_request_id,
3307: p_object_version_number => p_object_version_number,
3308: p_routing_group_id => l_routing_group_id
3309: );

Line 6091: ghr_par_upd.upd

6087:
6088: -- Note : Ver 10.53 fix
6089: -- Commented out all the columns that are specific to notification
6090: -- Bug 1304629 uncommented p_agency_code, p_employee_dept_or_agency
6091: ghr_par_upd.upd
6092: (p_pa_request_id => p_sf52_data.pa_request_id
6093: ,p_academic_discipline => p_sf52_data.academic_discipline
6094: ,p_agency_code => p_sf52_data.agency_code
6095: ,p_annuitant_indicator => p_sf52_data.annuitant_indicator

Line 7110: ghr_par_upd.upd(p_pa_request_id => l_sf52_dual_sec_rec.pa_request_id

7106: loop
7107: l_sf52_dual_sec_rec.object_version_number := c_get_ovn.object_version_number;
7108: end loop;
7109:
7110: ghr_par_upd.upd(p_pa_request_id => l_sf52_dual_sec_rec.pa_request_id
7111: ,p_object_version_number => l_sf52_dual_sec_rec.object_version_number
7112: ,p_from_position_id => l_sf52_dual_sec_rec.from_position_id
7113: ,p_to_position_id => l_sf52_dual_sec_rec.to_position_id
7114: ,p_agency_code => l_sf52_dual_sec_rec.agency_code