[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT fegli,
pa_request_id,
object_version_number,
employee_first_name,
employee_last_name,
employee_middle_names
FROM GHR_PA_REQUESTS
WHERE person_id = p_person_id
and employee_assignment_id = p_assignment_id
and effective_date = p_effective_date
and first_noa_code = '881'
and pa_notification_id is null;
SELECT work_schedule
FROM GHR_PA_REQUESTS
WHERE pa_request_id = p_pa_request_id;
SELECT parem.pa_remark_id,
parem.object_version_number
FROM GHR_PA_REMARKS parem,GHR_REMARKS rem
WHERE parem.pa_request_id = p_pa_request_id
AND rem.remark_id = parem.remark_id
AND rem.code = 'B51';
SELECT pen_attribute1 fegli_event_code
FROM ben_prtt_enrt_rslt_f
WHERE person_id = p_person_id
-- AND pgm_id = p_pgm_id
AND p_effective_date between effective_start_date and effective_end_date
AND pen_attribute_category = 'GHR_FEGLI_EXTRA_INFO'
AND NVL(prtt_enrt_rslt_stat_cd,'@@') NOT IN ('BCKDT','VOIDD');
SELECT full_name, employee_number
FROM per_all_people_f
WHERE person_id = p_person_id
AND p_effective_date between effective_start_date
and effective_end_date;
UPDATE_SF52_FEGLI_RPA(p_pa_request_id => l_pa_request_id,
p_person_id => p_person_id,
p_assignment_id => p_assignment_id,
p_fegli_code => p_fegli_code,
p_effective_date => p_effective_date);
ghr_pa_remarks_api.delete_pa_remarks
(p_pa_remark_id => cur_pa_rem.pa_remark_id
,p_object_version_number => cur_pa_rem.object_version_number);
l_log_text := 'Cannot Create/Update SS Fegli RPA';
SELECT first_name,
last_name,
middle_names,
national_identifier,
date_of_birth,
employee_number
FROM PER_PEOPLE_F
WHERE person_id = p_person_id
AND p_effective_date between effective_start_date and effective_end_date;
SELECT position_id,
assignment_id,
location_id
FROM per_assignments_f
WHERE person_id = p_person_id
AND p_effective_date between effective_start_date and effective_end_date;
SELECT prh.pa_routing_history_id,
prh.object_version_number
FROM ghr_pa_routing_history prh
WHERE prh.pa_request_id = p_pa_request_id
ORDER BY 1 desc;
UPDATE ghr_pa_request_shadow
SET employee_national_identifier = l_sf52_rec.employee_national_identifier,
employee_date_of_birth = l_sf52_rec.employee_date_of_birth,
employee_first_name = l_sf52_rec.employee_first_name,
employee_last_name = l_sf52_rec.employee_last_name,
employee_middle_names = l_sf52_rec.employee_middle_names
WHERE pa_request_id = l_sf52_rec.pa_request_id;
ghr_sf52_post_update.get_notification_details(
p_pa_request_id => l_sf52_rec.pa_request_id,
p_effective_date => l_sf52_rec.effective_date,
p_from_position_id => l_sf52_rec.from_position_id,
p_to_position_id => l_sf52_rec.to_position_id,
p_agency_code => l_sf52_rec.agency_code,
p_from_agency_code => l_sf52_rec.from_agency_code,
p_from_agency_desc => l_sf52_rec.from_agency_desc,
p_from_office_symbol => l_sf52_rec.from_office_symbol,
p_personnel_office_id => l_sf52_rec.personnel_office_id,
p_employee_dept_or_agency => l_sf52_rec.employee_dept_or_agency,
p_to_office_symbol => l_sf52_rec.to_office_symbol);
l_log_text := 'Error while create / Update the PA Request Rec. ';
l_log_text := 'Error while create / Update the PA Request Rec. ';
PROCEDURE UPDATE_SF52_FEGLI_RPA(p_pa_request_id in number,
p_person_id in number,
p_assignment_id in number,
p_fegli_code in varchar2,
p_effective_date in date) IS
CURSOR get_rpa_det
IS
SELECT *
FROM GHR_PA_REQUESTS
WHERE pa_request_id = p_pa_request_id;
SELECT prh.pa_routing_history_id,
prh.object_version_number
FROM ghr_pa_routing_history prh
WHERE prh.pa_request_id = p_pa_request_id
ORDER BY 1 desc;
l_proc varchar2(72) := g_package || 'update_sf52_fegli_rpa';
ghr_sf52_api.update_sf52
(p_pa_request_id =>l_sf52_rec.pa_request_id,
p_noa_family_code =>l_sf52_rec.noa_family_code,
p_routing_group_id =>l_sf52_rec.routing_group_id,
p_par_object_version_number =>l_sf52_rec.object_version_number,
p_proposed_effective_asap_flag =>l_sf52_rec.proposed_effective_asap_flag,
p_academic_discipline =>l_sf52_rec.academic_discipline,
p_additional_info_person_id =>l_sf52_rec.additional_info_person_id,
p_additional_info_tel_number =>l_sf52_rec.additional_info_tel_number,
p_altered_pa_request_id =>l_sf52_rec.altered_pa_request_id,
p_annuitant_indicator =>l_sf52_rec.annuitant_indicator,
p_annuitant_indicator_desc =>l_sf52_rec.annuitant_indicator_desc,
p_appropriation_code1 =>l_sf52_rec.appropriation_code1,
p_appropriation_code2 =>l_sf52_rec.appropriation_code2,
p_approval_date =>l_sf52_rec.approval_date,
p_approving_official_full_name =>l_sf52_rec.approving_official_full_name,
p_approving_official_work_titl =>l_sf52_rec.approving_official_work_title,
p_authorized_by_person_id =>l_sf52_rec.authorized_by_person_id,
p_authorized_by_title =>l_sf52_rec.authorized_by_title,
p_award_amount =>l_sf52_rec.award_amount,
p_award_uom =>l_sf52_rec.award_uom,
p_bargaining_unit_status =>l_sf52_rec.bargaining_unit_status,
p_citizenship =>l_sf52_rec.citizenship,
p_concurrence_date =>l_sf52_rec.concurrence_date,
p_custom_pay_calc_flag =>l_sf52_rec.custom_pay_calc_flag,
p_duty_station_code =>l_sf52_rec.duty_station_code,
p_duty_station_desc =>l_sf52_rec.duty_station_desc,
p_duty_station_id =>l_sf52_rec.duty_station_id,
p_duty_station_location_id =>l_sf52_rec.duty_station_location_id,
p_education_level =>l_sf52_rec.education_level,
p_effective_date =>p_effective_date,
p_employee_assignment_id =>l_sf52_rec.employee_assignment_id,
p_employee_date_of_birth =>l_sf52_rec.employee_date_of_birth,
p_employee_first_name =>l_sf52_rec.employee_first_name,
p_employee_last_name =>l_sf52_rec.employee_last_name,
p_employee_middle_names =>l_sf52_rec.employee_middle_names,
p_employee_national_identifier =>l_sf52_rec.employee_national_identifier,
p_fegli =>p_fegli_code,
p_fegli_desc =>l_fegli_desc,
p_first_action_la_code1 =>l_sf52_rec.first_action_la_code1,
p_first_action_la_code2 =>l_sf52_rec.first_action_la_code2,
p_first_action_la_desc1 =>l_sf52_rec.first_action_la_desc1,
p_first_action_la_desc2 =>l_sf52_rec.first_action_la_desc2,
p_first_noa_cancel_or_correct =>l_sf52_rec.first_noa_cancel_or_correct,
p_first_noa_code =>l_sf52_rec.first_noa_code,
p_first_noa_desc =>l_sf52_rec.first_noa_desc,
p_first_noa_id =>l_sf52_rec.first_noa_id,
p_first_noa_pa_request_id =>l_sf52_rec.first_noa_pa_request_id,
p_flsa_category =>l_sf52_rec.flsa_category,
p_forwarding_address_line1 =>l_sf52_rec.forwarding_address_line1,
p_forwarding_address_line2 =>l_sf52_rec.forwarding_address_line2,
p_forwarding_address_line3 =>l_sf52_rec.forwarding_address_line3,
p_forwarding_country =>l_sf52_rec.forwarding_country,
p_forwarding_country_short_nam =>l_sf52_rec.forwarding_country_short_name,
p_forwarding_postal_code =>l_sf52_rec.forwarding_postal_code,
p_forwarding_region_2 =>l_sf52_rec.forwarding_region_2,
p_forwarding_town_or_city =>l_sf52_rec.forwarding_town_or_city,
p_from_adj_basic_pay =>l_sf52_rec.from_adj_basic_pay,
p_from_basic_pay =>l_sf52_rec.from_basic_pay,
p_from_grade_or_level =>l_sf52_rec.from_grade_or_level,
p_from_locality_adj =>l_sf52_rec.from_locality_adj,
p_from_occ_code =>l_sf52_rec.from_occ_code,
p_from_other_pay_amount =>l_sf52_rec.from_other_pay_amount,
p_from_pay_basis =>l_sf52_rec.from_pay_basis,
p_from_pay_plan =>l_sf52_rec.from_pay_plan,
p_input_pay_rate_determinant =>l_sf52_rec.input_pay_rate_determinant,
p_from_pay_table_identifier =>l_sf52_rec.from_pay_table_identifier,
p_from_position_id =>l_sf52_rec.from_position_id,
p_from_position_org_line1 =>l_sf52_rec.from_position_org_line1,
p_from_position_org_line2 =>l_sf52_rec.from_position_org_line2,
p_from_position_org_line3 =>l_sf52_rec.from_position_org_line3,
p_from_position_org_line4 =>l_sf52_rec.from_position_org_line4,
p_from_position_org_line5 =>l_sf52_rec.from_position_org_line5,
p_from_position_org_line6 =>l_sf52_rec.from_position_org_line6,
p_from_position_number =>l_sf52_rec.from_position_number,
p_from_position_seq_no =>l_sf52_rec.from_position_seq_no,
p_from_position_title =>l_sf52_rec.from_position_title,
p_from_step_or_rate =>l_sf52_rec.from_step_or_rate,
p_from_total_salary =>l_sf52_rec.from_total_salary,
p_functional_class =>l_sf52_rec.functional_class,
p_notepad =>l_sf52_rec.notepad,
p_part_time_hours =>l_sf52_rec.part_time_hours,
p_pay_rate_determinant =>l_sf52_rec.pay_rate_determinant,
p_person_id =>l_sf52_rec.person_id,
p_position_occupied =>l_sf52_rec.position_occupied,
p_proposed_effective_date =>l_sf52_rec.proposed_effective_date,
p_requested_by_person_id =>l_sf52_rec.requested_by_person_id,
p_requested_by_title =>l_sf52_rec.requested_by_title,
p_requested_date =>l_sf52_rec.requested_date,
p_requesting_office_remarks_de =>l_sf52_rec.requesting_office_remarks_desc,
p_requesting_office_remarks_fl =>l_sf52_rec.REQUESTING_OFFICE_REMARKS_FLAG,
p_request_number =>l_sf52_rec.request_number,
p_resign_and_retire_reason_des =>l_sf52_rec.resign_and_retire_reason_desc,
p_retirement_plan =>l_sf52_rec.retirement_plan,
p_retirement_plan_desc =>l_sf52_rec.retirement_plan_desc,
p_second_action_la_code1 =>l_sf52_rec.second_action_la_code1,
p_second_action_la_code2 =>l_sf52_rec.second_action_la_code2,
p_second_action_la_desc1 =>l_sf52_rec.second_action_la_desc1,
p_second_action_la_desc2 =>l_sf52_rec.second_action_la_desc2,
p_second_noa_cancel_or_correct =>l_sf52_rec.second_noa_cancel_or_correct,
p_second_noa_code =>l_sf52_rec.second_noa_code,
p_second_noa_desc =>l_sf52_rec.second_noa_desc,
p_second_noa_id =>l_sf52_rec.second_noa_id,
p_second_noa_pa_request_id =>l_sf52_rec.second_noa_pa_request_id,
p_service_comp_date =>l_sf52_rec.service_comp_date,
p_supervisory_status =>l_sf52_rec.supervisory_status,
p_tenure =>l_sf52_rec.tenure,
p_to_adj_basic_pay =>l_sf52_rec.to_adj_basic_pay,
p_to_basic_pay =>l_sf52_rec.to_basic_pay,
p_to_grade_id =>l_sf52_rec.to_grade_id,
p_to_grade_or_level =>l_sf52_rec.to_grade_or_level,
p_to_job_id =>l_sf52_rec.to_job_id,
p_to_locality_adj =>l_sf52_rec.to_locality_adj,
p_to_occ_code =>l_sf52_rec.to_occ_code,
p_to_organization_id =>l_sf52_rec.to_organization_id,
p_to_other_pay_amount =>l_sf52_rec.to_other_pay_amount,
p_to_au_overtime =>l_sf52_rec.to_au_overtime,
p_to_auo_premium_pay_indicator =>l_sf52_rec.to_auo_premium_pay_indicator,
p_to_availability_pay =>l_sf52_rec.to_availability_pay,
p_to_ap_premium_pay_indicator =>l_sf52_rec.to_ap_premium_pay_indicator,
p_to_retention_allowance =>l_sf52_rec.to_retention_allowance,
p_to_supervisory_differential =>l_sf52_rec.to_supervisory_differential,
p_to_staffing_differential =>l_sf52_rec.to_staffing_differential,
p_to_pay_basis =>l_sf52_rec.to_pay_basis,
p_to_pay_plan =>l_sf52_rec.to_pay_plan,
p_to_pay_table_identifier =>l_sf52_rec.to_pay_table_identifier,
p_to_position_id =>l_sf52_rec.to_position_id,
p_to_position_org_line1 =>l_sf52_rec.to_position_org_line1,
p_to_position_org_line2 =>l_sf52_rec.to_position_org_line2,
p_to_position_org_line3 =>l_sf52_rec.to_position_org_line3,
p_to_position_org_line4 =>l_sf52_rec.to_position_org_line4,
p_to_position_org_line5 =>l_sf52_rec.to_position_org_line5,
p_to_position_org_line6 =>l_sf52_rec.to_position_org_line6,
p_to_position_number =>l_sf52_rec.to_position_number,
p_to_position_seq_no =>l_sf52_rec.to_position_seq_no,
p_to_position_title =>l_sf52_rec.to_position_title,
p_to_step_or_rate =>l_sf52_rec.to_step_or_rate,
p_to_total_salary =>l_sf52_rec.to_total_salary,
p_veterans_preference =>l_sf52_rec.veterans_preference,
p_veterans_pref_for_rif =>l_sf52_rec.veterans_pref_for_rif,
p_veterans_status =>l_sf52_rec.veterans_status,
p_work_schedule =>l_sf52_rec.work_schedule,
p_work_schedule_desc =>l_sf52_rec.work_schedule_desc,
p_year_degree_attained =>l_sf52_rec.year_degree_attained,
p_first_noa_information1 =>l_sf52_rec.first_noa_information1,
p_first_noa_information2 =>l_sf52_rec.first_noa_information2,
p_first_noa_information3 =>l_sf52_rec.first_noa_information3,
p_first_noa_information4 =>l_sf52_rec.first_noa_information4,
p_first_noa_information5 =>l_sf52_rec.first_noa_information5,
p_second_lac1_information1 =>l_sf52_rec.second_lac1_information1,
p_second_lac1_information2 =>l_sf52_rec.second_lac1_information2,
p_second_lac1_information3 =>l_sf52_rec.second_lac1_information3,
p_second_lac1_information4 =>l_sf52_rec.second_lac1_information4,
p_second_lac1_information5 =>l_sf52_rec.second_lac1_information5,
p_second_lac2_information1 =>l_sf52_rec.second_lac2_information1,
p_second_lac2_information2 =>l_sf52_rec.second_lac2_information2,
p_second_lac2_information3 =>l_sf52_rec.second_lac2_information3,
p_second_lac2_information4 =>l_sf52_rec.second_lac2_information4,
p_second_lac2_information5 =>l_sf52_rec.second_lac2_information5 ,
p_second_noa_information1 =>l_sf52_rec.second_noa_information1,
p_second_noa_information2 =>l_sf52_rec.second_noa_information2,
p_second_noa_information3 =>l_sf52_rec.second_noa_information3,
p_second_noa_information4 =>l_sf52_rec.second_noa_information4,
p_second_noa_information5 =>l_sf52_rec.second_noa_information5,
p_first_lac1_information1 =>l_sf52_rec.first_lac1_information1,
p_first_lac1_information2 =>l_sf52_rec.first_lac1_information2,
p_first_lac1_information3 =>l_sf52_rec.first_lac1_information3,
p_first_lac1_information4 =>l_sf52_rec.first_lac1_information4,
p_first_lac1_information5 =>l_sf52_rec.first_lac1_information5,
p_first_lac2_information1 =>l_sf52_rec.first_lac2_information1,
p_first_lac2_information2 =>l_sf52_rec.first_lac2_information2,
p_first_lac2_information3 =>l_sf52_rec.first_lac2_information3,
p_first_lac2_information4 =>l_sf52_rec.first_lac2_information4,
p_first_lac2_information5 =>l_sf52_rec.first_lac2_information5,
p_attribute_category =>l_sf52_rec.attribute_category,
p_attribute1 =>l_sf52_rec.attribute1,
p_attribute2 =>l_sf52_rec.attribute2,
p_attribute3 =>l_sf52_rec.attribute3,
p_attribute4 =>l_sf52_rec.attribute4,
p_attribute5 =>l_sf52_rec.attribute5,
p_attribute6 =>l_sf52_rec.attribute6,
p_attribute7 =>l_sf52_rec.attribute7,
p_attribute8 =>l_sf52_rec.attribute8,
p_attribute9 =>l_sf52_rec.attribute9,
p_attribute10 =>l_sf52_rec.attribute10,
p_attribute11 =>l_sf52_rec.attribute11,
p_attribute12 =>l_sf52_rec.attribute12,
p_attribute13 =>l_sf52_rec.attribute13,
p_attribute14 =>l_sf52_rec.attribute14,
p_attribute15 =>l_sf52_rec.attribute15,
p_attribute16 =>l_sf52_rec.attribute16,
p_attribute17 =>l_sf52_rec.attribute17,
p_attribute18 =>l_sf52_rec.attribute18,
p_attribute19 =>l_sf52_rec.attribute19,
p_attribute20 =>l_sf52_rec.attribute20,
p_u_approved_flag =>'N',
p_u_user_name_acted_on =>Null,
p_u_action_taken =>'NOT_ROUTED',
p_u_approval_status =>'APPROVE',
p_i_user_name_routed_to =>Null,
p_i_groupbox_id =>Null,
p_i_routing_list_id =>Null,
p_i_routing_seq_number =>Null,
p_to_retention_allow_percentag =>l_sf52_rec.to_retention_allow_percentage,
p_to_supervisory_diff_percenta =>l_sf52_rec.to_supervisory_diff_percentage,
p_to_staffing_diff_percentage =>l_sf52_rec.to_staffing_diff_percentage,
p_award_percentage =>l_sf52_rec.award_percentage,
p_u_prh_object_version_number => l_uprh_object_version_number,
p_i_pa_routing_history_id => l_pa_routing_history_id,
p_i_prh_object_version_number => l_iprh_object_version_number
);
update_shadow_row (p_sf52_rec => l_sf52_rec, p_result => l_result);
ghr_sf52_post_update.get_notification_details(
p_pa_request_id => l_sf52_rec.pa_request_id,
p_effective_date => l_sf52_rec.effective_date,
p_from_position_id => l_sf52_rec.from_position_id,
p_to_position_id => l_sf52_rec.to_position_id,
p_agency_code => l_sf52_rec.agency_code,
p_from_agency_code => l_sf52_rec.from_agency_code,
p_from_agency_desc => l_sf52_rec.from_agency_desc,
p_from_office_symbol => l_sf52_rec.from_office_symbol,
p_personnel_office_id => l_sf52_rec.personnel_office_id,
p_employee_dept_or_agency => l_sf52_rec.employee_dept_or_agency,
p_to_office_symbol => l_sf52_rec.to_office_symbol);
l_log_text := 'Error while Update the PA Request Rec. ';
l_log_text := 'Error while Update the PA Request Rec. ';
END UPDATE_SF52_FEGLI_RPA;
SELECT 1
FROM GHR_PA_REMARKS
WHERE pa_request_id = p_pa_request_id
AND remark_id = p_remark_id;
SELECT pa_request_extra_info_id,
object_version_number
FROM GHR_PA_REQUEST_EXTRA_INFO
WHERE pa_request_id = p_pa_request_id
AND information_type = 'GHR_US_PAR_FEGLI';
insert into ghr_pa_request_ei_shadow
(
pa_request_extra_info_id ,
pa_request_id ,
information_type,
rei_information1 ,
rei_information2 ,
rei_information3 ,
rei_information4 ,
rei_information5 ,
rei_information6 ,
rei_information7 ,
rei_information8 ,
rei_information9 ,
rei_information10 ,
rei_information11 ,
rei_information12 ,
rei_information13 ,
rei_information14 ,
rei_information15 ,
rei_information16 ,
rei_information17 ,
rei_information18 ,
rei_information19 ,
rei_information20 ,
rei_information21 ,
rei_information22 ,
rei_information23 ,
rei_information24 ,
rei_information25 ,
rei_information26 ,
rei_information27 ,
rei_information28 ,
rei_information29 ,
rei_information30
) values
(l_pa_request_extra_info_id,
p_pa_request_id,
p_info_type,
p_attribute1,
p_attribute2,
p_attribute3,
p_attribute4,
p_attribute5,
p_attribute6,
p_attribute7,
p_attribute8,
p_attribute9,
p_attribute10,
p_attribute11,
p_attribute12,
p_attribute13,
p_attribute14,
p_attribute15,
p_attribute16,
p_attribute17,
p_attribute18,
p_attribute19,
p_attribute20,
p_attribute21,
p_attribute22,
p_attribute23,
p_attribute24,
p_attribute25,
p_attribute26,
p_attribute27,
p_attribute28,
p_attribute29,
p_attribute30
);
ghr_par_extra_info_api.update_pa_request_extra_info
(P_PA_REQUEST_EXTRA_INFO_ID => l_pa_request_extra_info_id,
P_OBJECT_VERSION_NUMBER => l_object_version_number ,
p_rei_information1 => p_attribute1,
p_rei_information2 => p_attribute2,
p_rei_information3 => p_attribute3,
p_rei_information4 => p_attribute4,
p_rei_information5 => p_attribute5,
p_rei_information6 => p_attribute6,
p_rei_information7 => p_attribute7,
p_rei_information8 => p_attribute8,
p_rei_information9 => p_attribute9,
p_rei_information10 => p_attribute10,
p_rei_information11 => p_attribute11,
p_rei_information12 => p_attribute12,
p_rei_information13 => p_attribute13,
p_rei_information14 => p_attribute14,
p_rei_information15 => p_attribute15,
p_rei_information16 => p_attribute16,
p_rei_information17 => p_attribute17,
p_rei_information18 => p_attribute18,
p_rei_information19 => p_attribute19,
p_rei_information20 => p_attribute20,
p_rei_information21 => p_attribute21,
p_rei_information22 => p_attribute22,
p_rei_information23 => p_attribute23,
p_rei_information24 => p_attribute24,
p_rei_information25 => p_attribute25,
p_rei_information26 => p_attribute26,
p_rei_information27 => p_attribute27,
p_rei_information28 => p_attribute28,
p_rei_information29 => p_attribute29,
p_rei_information30 => p_attribute30
);
update ghr_pa_request_ei_shadow set
rei_information1 = p_attribute1,
rei_information2 = p_attribute2,
rei_information3 = p_attribute3,
rei_information4 = p_attribute4,
rei_information5 = p_attribute5,
rei_information6 = p_attribute6,
rei_information7 = p_attribute7,
rei_information8 = p_attribute8,
rei_information9 = p_attribute9,
rei_information10 = p_attribute10,
rei_information11 = p_attribute11,
rei_information12 = p_attribute12,
rei_information13 = p_attribute13,
rei_information14 = p_attribute14,
rei_information15 = p_attribute15,
rei_information16 = p_attribute16,
rei_information17 = p_attribute17,
rei_information18 = p_attribute18,
rei_information19 = p_attribute19,
rei_information20 = p_attribute20,
rei_information21 = p_attribute21,
rei_information22 = p_attribute22,
rei_information23 = p_attribute23,
rei_information24 = p_attribute24,
rei_information25 = p_attribute25,
rei_information26 = p_attribute26,
rei_information27 = p_attribute27,
rei_information28 = p_attribute28,
rei_information29 = p_attribute29,
rei_information30 = p_attribute30
where pa_request_extra_info_id = l_pa_request_extra_info_id;
PROCEDURE UPDATE_SHADOW_ROW(p_sf52_rec in ghr_pa_requests%rowtype,
p_result out nocopy BOOLEAN) IS
l_sf52_shadow_rec ghr_pa_request_shadow%ROWTYPE;
UPDATE GHR_PA_REQUEST_SHADOW
SET
pa_request_id = p_sf52_rec.pa_request_id
,academic_discipline = p_sf52_rec.academic_discipline
,annuitant_indicator = p_sf52_rec.annuitant_indicator
,appropriation_code1 = p_sf52_rec.appropriation_code1
,appropriation_code2 = p_sf52_rec.appropriation_code2
,bargaining_unit_status = p_sf52_rec.bargaining_unit_status
,citizenship = p_sf52_rec.citizenship
,duty_station_id = p_sf52_rec.duty_station_id
,duty_station_location_id = p_sf52_rec.duty_station_location_id
,education_level = p_sf52_rec.education_level
,fegli = p_sf52_rec.fegli
,flsa_category = p_sf52_rec.flsa_category
,forwarding_address_line1 = p_sf52_rec.forwarding_address_line1
,forwarding_address_line2 = p_sf52_rec.forwarding_address_line2
,forwarding_address_line3 = p_sf52_rec.forwarding_address_line3
,forwarding_country_short_name = p_sf52_rec.forwarding_country_short_name
,forwarding_postal_code = p_sf52_rec.forwarding_postal_code
,forwarding_region_2 = p_sf52_rec.forwarding_region_2
,forwarding_town_or_city = p_sf52_rec.forwarding_town_or_city
,functional_class = p_sf52_rec.functional_class
,part_time_hours = p_sf52_rec.part_time_hours
,pay_rate_determinant = p_sf52_rec.pay_rate_determinant
,position_occupied = p_sf52_rec.position_occupied
,retirement_plan = p_sf52_rec.retirement_plan
,service_comp_date = p_sf52_rec.service_comp_date
,supervisory_status = p_sf52_rec.supervisory_status
,tenure = p_sf52_rec.tenure
,to_ap_premium_pay_indicator = p_sf52_rec.to_ap_premium_pay_indicator
,to_auo_premium_pay_indicator = p_sf52_rec.to_auo_premium_pay_indicator
,to_occ_code = p_sf52_rec.to_occ_code
,to_position_id = p_sf52_rec.to_position_id
,to_retention_allowance = p_sf52_rec.to_retention_allowance
,to_retention_allow_percentage = p_sf52_rec.to_retention_allow_percentage
,to_staffing_differential = p_sf52_rec.to_staffing_differential
,to_staffing_diff_percentage = p_sf52_rec.to_staffing_diff_percentage
,to_step_or_rate = p_sf52_rec.to_step_or_rate
,to_supervisory_differential = p_sf52_rec.to_supervisory_differential
,to_supervisory_diff_percentage = p_sf52_rec.to_supervisory_diff_percentage
,veterans_preference = p_sf52_rec.veterans_preference
,veterans_pref_for_rif = p_sf52_rec.veterans_pref_for_rif
,veterans_status = p_sf52_rec.veterans_status
,work_schedule = p_sf52_rec.work_schedule
,year_degree_attained = p_sf52_rec.year_degree_attained
WHERE pa_request_id = p_sf52_rec.pa_request_id;
END UPDATE_SHADOW_ROW;