DBA Data[Home] [Help]

APPS.GHR_SS_RPA_CREATION dependencies on GHR_PA_REQUEST_SHADOW

Line 846: UPDATE ghr_pa_request_shadow

842: ,l_sf52_rec.fegli
843: );
844: ghr_process_sf52.create_shadow_row (p_sf52_data => l_sf52_rec);
845:
846: UPDATE ghr_pa_request_shadow
847: SET employee_national_identifier = l_sf52_rec.employee_national_identifier,
848: employee_date_of_birth = l_sf52_rec.employee_date_of_birth,
849: employee_first_name = l_sf52_rec.employee_first_name,
850: employee_last_name = l_sf52_rec.employee_last_name,

Line 1665: l_sf52_shadow_rec ghr_pa_request_shadow%ROWTYPE;

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:
1668: UPDATE GHR_PA_REQUEST_SHADOW
1669: SET

Line 1668: UPDATE GHR_PA_REQUEST_SHADOW

1664: p_result out nocopy BOOLEAN) IS
1665: l_sf52_shadow_rec ghr_pa_request_shadow%ROWTYPE;
1666: BEGIN
1667:
1668: UPDATE GHR_PA_REQUEST_SHADOW
1669: SET
1670: pa_request_id = p_sf52_rec.pa_request_id
1671: ,academic_discipline = p_sf52_rec.academic_discipline
1672: ,annuitant_indicator = p_sf52_rec.annuitant_indicator