[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure update_dml(p_rec in out nocopy ghr_par_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'update_dml';
update ghr_pa_requests
set
pa_request_id = p_rec.pa_request_id,
pa_notification_id = p_rec.pa_notification_id,
noa_family_code = p_rec.noa_family_code,
routing_group_id = p_rec.routing_group_id,
proposed_effective_asap_flag = p_rec.proposed_effective_asap_flag,
academic_discipline = p_rec.academic_discipline,
additional_info_person_id = p_rec.additional_info_person_id,
additional_info_tel_number = p_rec.additional_info_tel_number,
agency_code = p_rec.agency_code,
altered_pa_request_id = p_rec.altered_pa_request_id,
annuitant_indicator = p_rec.annuitant_indicator,
annuitant_indicator_desc = p_rec.annuitant_indicator_desc,
appropriation_code1 = p_rec.appropriation_code1,
appropriation_code2 = p_rec.appropriation_code2,
approval_date = p_rec.approval_date,
approving_official_full_name = p_rec.approving_official_full_name,
approving_official_work_title = p_rec.approving_official_work_title,
sf50_approval_date = p_rec.sf50_approval_date,
sf50_approving_ofcl_full_name = p_rec.sf50_approving_ofcl_full_name,
sf50_approving_ofcl_work_title = p_rec.sf50_approving_ofcl_work_title,
authorized_by_person_id = p_rec.authorized_by_person_id,
authorized_by_title = p_rec.authorized_by_title,
award_amount = p_rec.award_amount,
award_uom = p_rec.award_uom,
bargaining_unit_status = p_rec.bargaining_unit_status,
citizenship = p_rec.citizenship,
concurrence_date = p_rec.concurrence_date,
custom_pay_calc_flag = p_rec.custom_pay_calc_flag,
duty_station_code = p_rec.duty_station_code,
duty_station_desc = p_rec.duty_station_desc,
duty_station_id = p_rec.duty_station_id,
duty_station_location_id = p_rec.duty_station_location_id,
education_level = p_rec.education_level,
effective_date = p_rec.effective_date,
employee_assignment_id = p_rec.employee_assignment_id,
employee_date_of_birth = p_rec.employee_date_of_birth,
employee_dept_or_agency = p_rec.employee_dept_or_agency,
employee_first_name = p_rec.employee_first_name,
employee_last_name = p_rec.employee_last_name,
employee_middle_names = p_rec.employee_middle_names,
employee_national_identifier = p_rec.employee_national_identifier,
fegli = p_rec.fegli,
fegli_desc = p_rec.fegli_desc,
first_action_la_code1 = p_rec.first_action_la_code1,
first_action_la_code2 = p_rec.first_action_la_code2,
first_action_la_desc1 = p_rec.first_action_la_desc1,
first_action_la_desc2 = p_rec.first_action_la_desc2,
first_noa_cancel_or_correct = p_rec.first_noa_cancel_or_correct,
first_noa_code = p_rec.first_noa_code,
first_noa_desc = p_rec.first_noa_desc,
first_noa_id = p_rec.first_noa_id,
first_noa_pa_request_id = p_rec.first_noa_pa_request_id,
flsa_category = p_rec.flsa_category,
forwarding_address_line1 = p_rec.forwarding_address_line1,
forwarding_address_line2 = p_rec.forwarding_address_line2,
forwarding_address_line3 = p_rec.forwarding_address_line3,
forwarding_country = p_rec.forwarding_country,
forwarding_country_short_name = p_rec.forwarding_country_short_name,
forwarding_postal_code = p_rec.forwarding_postal_code,
forwarding_region_2 = p_rec.forwarding_region_2,
forwarding_town_or_city = p_rec.forwarding_town_or_city,
from_adj_basic_pay = p_rec.from_adj_basic_pay,
from_agency_code = p_rec.from_agency_code,
from_agency_desc = p_rec.from_agency_desc,
from_basic_pay = p_rec.from_basic_pay,
from_grade_or_level = p_rec.from_grade_or_level,
from_locality_adj = p_rec.from_locality_adj,
from_occ_code = p_rec.from_occ_code,
from_office_symbol = p_rec.from_office_symbol,
from_other_pay_amount = p_rec.from_other_pay_amount,
from_pay_basis = p_rec.from_pay_basis,
from_pay_plan = p_rec.from_pay_plan,
-- FWFA Changes Bug#4444609
input_pay_rate_determinant = p_rec.input_pay_rate_determinant,
from_pay_table_identifier = p_rec.from_pay_table_identifier,
-- FWFA Changes
from_position_id = p_rec.from_position_id,
from_position_org_line1 = p_rec.from_position_org_line1,
from_position_org_line2 = p_rec.from_position_org_line2,
from_position_org_line3 = p_rec.from_position_org_line3,
from_position_org_line4 = p_rec.from_position_org_line4,
from_position_org_line5 = p_rec.from_position_org_line5,
from_position_org_line6 = p_rec.from_position_org_line6,
from_position_number = p_rec.from_position_number,
from_position_seq_no = p_rec.from_position_seq_no,
from_position_title = p_rec.from_position_title,
from_step_or_rate = p_rec.from_step_or_rate,
from_total_salary = p_rec.from_total_salary,
functional_class = p_rec.functional_class,
notepad = p_rec.notepad,
part_time_hours = p_rec.part_time_hours,
pay_rate_determinant = p_rec.pay_rate_determinant,
personnel_office_id = p_rec.personnel_office_id,
person_id = p_rec.person_id,
position_occupied = p_rec.position_occupied,
proposed_effective_date = p_rec.proposed_effective_date,
requested_by_person_id = p_rec.requested_by_person_id,
requested_by_title = p_rec.requested_by_title,
requested_date = p_rec.requested_date,
requesting_office_remarks_desc = p_rec.requesting_office_remarks_desc,
requesting_office_remarks_flag = p_rec.requesting_office_remarks_flag,
request_number = p_rec.request_number,
resign_and_retire_reason_desc = p_rec.resign_and_retire_reason_desc,
retirement_plan = p_rec.retirement_plan,
retirement_plan_desc = p_rec.retirement_plan_desc,
second_action_la_code1 = p_rec.second_action_la_code1,
second_action_la_code2 = p_rec.second_action_la_code2,
second_action_la_desc1 = p_rec.second_action_la_desc1,
second_action_la_desc2 = p_rec.second_action_la_desc2,
second_noa_cancel_or_correct = p_rec.second_noa_cancel_or_correct,
second_noa_code = p_rec.second_noa_code,
second_noa_desc = p_rec.second_noa_desc,
second_noa_id = p_rec.second_noa_id,
second_noa_pa_request_id = p_rec.second_noa_pa_request_id,
service_comp_date = p_rec.service_comp_date,
status = p_rec.status,
supervisory_status = p_rec.supervisory_status,
tenure = p_rec.tenure,
to_adj_basic_pay = p_rec.to_adj_basic_pay,
to_basic_pay = p_rec.to_basic_pay,
to_grade_id = p_rec.to_grade_id,
to_grade_or_level = p_rec.to_grade_or_level,
to_job_id = p_rec.to_job_id,
to_locality_adj = p_rec.to_locality_adj,
to_occ_code = p_rec.to_occ_code,
to_office_symbol = p_rec.to_office_symbol,
to_organization_id = p_rec.to_organization_id,
to_other_pay_amount = p_rec.to_other_pay_amount,
to_au_overtime = p_rec.to_au_overtime,
to_auo_premium_pay_indicator = p_rec.to_auo_premium_pay_indicator,
to_availability_pay = p_rec.to_availability_pay,
to_ap_premium_pay_indicator = p_rec.to_ap_premium_pay_indicator,
to_retention_allowance = p_rec.to_retention_allowance,
to_supervisory_differential = p_rec.to_supervisory_differential,
to_staffing_differential = p_rec.to_staffing_differential,
to_pay_basis = p_rec.to_pay_basis,
to_pay_plan = p_rec.to_pay_plan,
-- FWFA Changes Bug#4444609
to_pay_table_identifier = p_rec.to_pay_table_identifier,
-- FWFA Changes
to_position_id = p_rec.to_position_id,
to_position_org_line1 = p_rec.to_position_org_line1,
to_position_org_line2 = p_rec.to_position_org_line2,
to_position_org_line3 = p_rec.to_position_org_line3,
to_position_org_line4 = p_rec.to_position_org_line4,
to_position_org_line5 = p_rec.to_position_org_line5,
to_position_org_line6 = p_rec.to_position_org_line6,
to_position_number = p_rec.to_position_number,
to_position_seq_no = p_rec.to_position_seq_no,
to_position_title = p_rec.to_position_title,
to_step_or_rate = p_rec.to_step_or_rate,
to_total_salary = p_rec.to_total_salary,
veterans_preference = p_rec.veterans_preference,
veterans_pref_for_rif = p_rec.veterans_pref_for_rif,
veterans_status = p_rec.veterans_status,
work_schedule = p_rec.work_schedule,
work_schedule_desc = p_rec.work_schedule_desc,
year_degree_attained = p_rec.year_degree_attained,
first_noa_information1 = p_rec.first_noa_information1,
first_noa_information2 = p_rec.first_noa_information2,
first_noa_information3 = p_rec.first_noa_information3,
first_noa_information4 = p_rec.first_noa_information4,
first_noa_information5 = p_rec.first_noa_information5,
second_lac1_information1 = p_rec.second_lac1_information1,
second_lac1_information2 = p_rec.second_lac1_information2,
second_lac1_information3 = p_rec.second_lac1_information3,
second_lac1_information4 = p_rec.second_lac1_information4,
second_lac1_information5 = p_rec.second_lac1_information5,
second_lac2_information1 = p_rec.second_lac2_information1,
second_lac2_information2 = p_rec.second_lac2_information2,
second_lac2_information3 = p_rec.second_lac2_information3,
second_lac2_information4 = p_rec.second_lac2_information4,
second_lac2_information5 = p_rec.second_lac2_information5,
second_noa_information1 = p_rec.second_noa_information1,
second_noa_information2 = p_rec.second_noa_information2,
second_noa_information3 = p_rec.second_noa_information3,
second_noa_information4 = p_rec.second_noa_information4,
second_noa_information5 = p_rec.second_noa_information5,
first_lac1_information1 = p_rec.first_lac1_information1,
first_lac1_information2 = p_rec.first_lac1_information2,
first_lac1_information3 = p_rec.first_lac1_information3,
first_lac1_information4 = p_rec.first_lac1_information4,
first_lac1_information5 = p_rec.first_lac1_information5,
first_lac2_information1 = p_rec.first_lac2_information1,
first_lac2_information2 = p_rec.first_lac2_information2,
first_lac2_information3 = p_rec.first_lac2_information3,
first_lac2_information4 = p_rec.first_lac2_information4,
first_lac2_information5 = p_rec.first_lac2_information5,
attribute_category = p_rec.attribute_category,
attribute1 = p_rec.attribute1,
attribute2 = p_rec.attribute2,
attribute3 = p_rec.attribute3,
attribute4 = p_rec.attribute4,
attribute5 = p_rec.attribute5,
attribute6 = p_rec.attribute6,
attribute7 = p_rec.attribute7,
attribute8 = p_rec.attribute8,
attribute9 = p_rec.attribute9,
attribute10 = p_rec.attribute10,
attribute11 = p_rec.attribute11,
attribute12 = p_rec.attribute12,
attribute13 = p_rec.attribute13,
attribute14 = p_rec.attribute14,
attribute15 = p_rec.attribute15,
attribute16 = p_rec.attribute16,
attribute17 = p_rec.attribute17,
attribute18 = p_rec.attribute18,
attribute19 = p_rec.attribute19,
attribute20 = p_rec.attribute20,
object_version_number = p_rec.object_version_number ,
first_noa_canc_pa_request_id = p_rec.first_noa_canc_pa_request_id ,
second_noa_canc_pa_request_id = p_rec.second_noa_canc_pa_request_id ,
to_retention_allow_percentage = p_rec.to_retention_allow_percentage ,
to_supervisory_diff_percentage = p_rec.to_supervisory_diff_percentage ,
to_staffing_diff_percentage = p_rec.to_staffing_diff_percentage ,
award_percentage = p_rec.award_percentage ,
rpa_type = p_rec.rpa_type,
mass_action_id = p_rec.mass_action_id,
mass_action_eligible_flag = p_rec.mass_action_eligible_flag,
mass_action_select_flag = p_rec.mass_action_select_flag,
mass_action_comments = p_rec.mass_action_comments,
-- Bug# RRR Changes
pa_incentive_payment_option = p_rec.payment_option,
award_salary = p_rec.award_salary
-- Bug# RRR Changes
where pa_request_id = p_rec.pa_request_id;
End update_dml;
Procedure pre_update(p_rec in ghr_par_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'pre_update';
End pre_update;
Procedure post_update(p_rec in ghr_par_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'post_update';
ghr_par_rku.after_update (
p_pa_request_id => p_rec.pa_request_id ,
p_pa_notification_id => p_rec.pa_notification_id ,
p_noa_family_code => p_rec.noa_family_code ,
p_routing_group_id => p_rec.routing_group_id ,
p_proposed_effective_asap_flag => p_rec.proposed_effective_asap_flag ,
p_academic_discipline => p_rec.academic_discipline ,
p_additional_info_person_id => p_rec.additional_info_person_id ,
p_additional_info_tel_number => p_rec.additional_info_tel_number ,
p_agency_code => p_rec.agency_code ,
p_altered_pa_request_id => p_rec.altered_pa_request_id ,
p_annuitant_indicator => p_rec.annuitant_indicator ,
p_annuitant_indicator_desc => p_rec.annuitant_indicator_desc ,
p_appropriation_code1 => p_rec.appropriation_code1 ,
p_appropriation_code2 => p_rec.appropriation_code2 ,
p_approval_date => p_rec.approval_date ,
p_approving_official_full_name => p_rec.approving_official_full_name ,
p_approving_official_work_titl => p_rec.approving_official_work_title ,
p_sf50_approval_date => p_rec.sf50_approval_date ,
p_sf50_approving_ofcl_full_nam => p_rec.sf50_approving_ofcl_full_name ,
p_sf50_approving_ofcl_work_tit => p_rec.sf50_approving_ofcl_work_title ,
p_authorized_by_person_id => p_rec.authorized_by_person_id ,
p_authorized_by_title => p_rec.authorized_by_title ,
p_award_amount => p_rec.award_amount ,
p_award_uom => p_rec.award_uom ,
p_bargaining_unit_status => p_rec.bargaining_unit_status ,
p_citizenship => p_rec.citizenship ,
p_concurrence_date => p_rec.concurrence_date ,
p_custom_pay_calc_flag => p_rec.custom_pay_calc_flag ,
p_duty_station_code => p_rec.duty_station_code ,
p_duty_station_desc => p_rec.duty_station_desc ,
p_duty_station_id => p_rec.duty_station_id ,
p_duty_station_location_id => p_rec.duty_station_location_id ,
p_education_level => p_rec.education_level ,
p_effective_date => p_rec.effective_date ,
p_employee_assignment_id => p_rec.employee_assignment_id ,
p_employee_date_of_birth => p_rec.employee_date_of_birth ,
p_employee_dept_or_agency => p_rec.employee_dept_or_agency ,
p_employee_first_name => p_rec.employee_first_name ,
p_employee_last_name => p_rec.employee_last_name ,
p_employee_middle_names => p_rec.employee_middle_names ,
p_employee_national_identifier => p_rec.employee_national_identifier ,
p_fegli => p_rec.fegli ,
p_fegli_desc => p_rec.fegli_desc ,
p_first_action_la_code1 => p_rec.first_action_la_code1 ,
p_first_action_la_code2 => p_rec.first_action_la_code2 ,
p_first_action_la_desc1 => p_rec.first_action_la_desc1 ,
p_first_action_la_desc2 => p_rec.first_action_la_desc2 ,
p_first_noa_cancel_or_correct => p_rec.first_noa_cancel_or_correct ,
p_first_noa_code => p_rec.first_noa_code ,
p_first_noa_desc => p_rec.first_noa_desc ,
p_first_noa_id => p_rec.first_noa_id ,
p_first_noa_pa_request_id => p_rec.first_noa_pa_request_id ,
p_flsa_category => p_rec.flsa_category ,
p_forwarding_address_line1 => p_rec.forwarding_address_line1 ,
p_forwarding_address_line2 => p_rec.forwarding_address_line2 ,
p_forwarding_address_line3 => p_rec.forwarding_address_line3 ,
p_forwarding_country => p_rec.forwarding_country ,
p_forwarding_country_short_nam => p_rec.forwarding_country_short_name ,
p_forwarding_postal_code => p_rec.forwarding_postal_code ,
p_forwarding_region_2 => p_rec.forwarding_region_2 ,
p_forwarding_town_or_city => p_rec.forwarding_town_or_city ,
p_from_adj_basic_pay => p_rec.from_adj_basic_pay ,
p_from_agency_code => p_rec.from_agency_code ,
p_from_agency_desc => p_rec.from_agency_desc ,
p_from_basic_pay => p_rec.from_basic_pay ,
p_from_grade_or_level => p_rec.from_grade_or_level ,
p_from_locality_adj => p_rec.from_locality_adj ,
p_from_occ_code => p_rec.from_occ_code ,
p_from_office_symbol => p_rec.from_office_symbol ,
p_from_other_pay_amount => p_rec.from_other_pay_amount ,
p_from_pay_basis => p_rec.from_pay_basis ,
p_from_pay_plan => p_rec.from_pay_plan ,
-- FWFA Changes Bug#4444609
-- p_input_pay_rate_determinant => p_rec.input_pay_rate_determinant ,
-- p_from_pay_table_identifier => p_rec.from_pay_table_identifier ,
-- FWFA Changes
p_from_position_id => p_rec.from_position_id ,
p_from_position_org_line1 => p_rec.from_position_org_line1 ,
p_from_position_org_line2 => p_rec.from_position_org_line2 ,
p_from_position_org_line3 => p_rec.from_position_org_line3 ,
p_from_position_org_line4 => p_rec.from_position_org_line4 ,
p_from_position_org_line5 => p_rec.from_position_org_line5 ,
p_from_position_org_line6 => p_rec.from_position_org_line6 ,
p_from_position_number => p_rec.from_position_number ,
p_from_position_seq_no => p_rec.from_position_seq_no ,
p_from_position_title => p_rec.from_position_title ,
p_from_step_or_rate => p_rec.from_step_or_rate ,
p_from_total_salary => p_rec.from_total_salary ,
p_functional_class => p_rec.functional_class ,
p_notepad => p_rec.notepad ,
p_part_time_hours => p_rec.part_time_hours ,
p_pay_rate_determinant => p_rec.pay_rate_determinant ,
p_personnel_office_id => p_rec.personnel_office_id ,
p_person_id => p_rec.person_id ,
p_position_occupied => p_rec.position_occupied ,
p_proposed_effective_date => p_rec.proposed_effective_date ,
p_requested_by_person_id => p_rec.requested_by_person_id ,
p_requested_by_title => p_rec.requested_by_title ,
p_requested_date => p_rec.requested_date ,
p_requesting_office_remarks_de => p_rec.requesting_office_remarks_desc ,
p_requesting_office_remarks_fl => p_rec.requesting_office_remarks_flag ,
p_request_number => p_rec.request_number ,
p_resign_and_retire_reason_des => p_rec.resign_and_retire_reason_desc ,
p_retirement_plan => p_rec.retirement_plan ,
p_retirement_plan_desc => p_rec.retirement_plan_desc ,
p_second_action_la_code1 => p_rec.second_action_la_code1 ,
p_second_action_la_code2 => p_rec.second_action_la_code2 ,
p_second_action_la_desc1 => p_rec.second_action_la_desc1 ,
p_second_action_la_desc2 => p_rec.second_action_la_desc2 ,
p_second_noa_cancel_or_correct => p_rec.second_noa_cancel_or_correct ,
p_second_noa_code => p_rec.second_noa_code ,
p_second_noa_desc => p_rec.second_noa_desc ,
p_second_noa_id => p_rec.second_noa_id ,
p_second_noa_pa_request_id => p_rec.second_noa_pa_request_id ,
p_service_comp_date => p_rec.service_comp_date ,
p_status => p_rec.status,
p_supervisory_status => p_rec.supervisory_status ,
p_tenure => p_rec.tenure ,
p_to_adj_basic_pay => p_rec.to_adj_basic_pay ,
p_to_basic_pay => p_rec.to_basic_pay ,
p_to_grade_id => p_rec.to_grade_id ,
p_to_grade_or_level => p_rec.to_grade_or_level ,
p_to_job_id => p_rec.to_job_id ,
p_to_locality_adj => p_rec.to_locality_adj ,
p_to_occ_code => p_rec.to_occ_code ,
p_to_office_symbol => p_rec.to_office_symbol ,
p_to_organization_id => p_rec.to_organization_id ,
p_to_other_pay_amount => p_rec.to_other_pay_amount ,
p_to_au_overtime => p_rec.to_au_overtime ,
p_to_auo_premium_pay_indicator => p_rec.to_auo_premium_pay_indicator ,
p_to_availability_pay => p_rec.to_availability_pay ,
p_to_ap_premium_pay_indicator => p_rec.to_ap_premium_pay_indicator ,
p_to_retention_allowance => p_rec.to_retention_allowance ,
p_to_supervisory_differential => p_rec.to_supervisory_differential ,
p_to_staffing_differential => p_rec.to_staffing_differential ,
p_to_pay_basis => p_rec.to_pay_basis ,
p_to_pay_plan => p_rec.to_pay_plan ,
-- FWFA Changes Bug#4444609
-- p_to_pay_table_identifier => p_rec.to_pay_table_identifier ,
-- FWFA Changes
p_to_position_id => p_rec.to_position_id ,
p_to_position_org_line1 => p_rec.to_position_org_line1 ,
p_to_position_org_line2 => p_rec.to_position_org_line2 ,
p_to_position_org_line3 => p_rec.to_position_org_line3 ,
p_to_position_org_line4 => p_rec.to_position_org_line4 ,
p_to_position_org_line5 => p_rec.to_position_org_line5 ,
p_to_position_org_line6 => p_rec.to_position_org_line6 ,
p_to_position_number => p_rec.to_position_number ,
p_to_position_seq_no => p_rec.to_position_seq_no ,
p_to_position_title => p_rec.to_position_title ,
p_to_step_or_rate => p_rec.to_step_or_rate ,
p_to_total_salary => p_rec.to_total_salary ,
p_veterans_preference => p_rec.veterans_preference ,
p_veterans_pref_for_rif => p_rec.veterans_pref_for_rif ,
p_veterans_status => p_rec.veterans_status ,
p_work_schedule => p_rec.work_schedule ,
p_work_schedule_desc => p_rec.work_schedule_desc ,
p_year_degree_attained => p_rec.year_degree_attained ,
p_first_noa_information1 => p_rec.first_noa_information1 ,
p_first_noa_information2 => p_rec.first_noa_information2 ,
p_first_noa_information3 => p_rec.first_noa_information3 ,
p_first_noa_information4 => p_rec.first_noa_information4 ,
p_first_noa_information5 => p_rec.first_noa_information5 ,
p_second_lac1_information1 => p_rec.second_lac1_information1 ,
p_second_lac1_information2 => p_rec.second_lac1_information2 ,
p_second_lac1_information3 => p_rec.second_lac1_information3 ,
p_second_lac1_information4 => p_rec.second_lac1_information4 ,
p_second_lac1_information5 => p_rec.second_lac1_information5 ,
p_second_lac2_information1 => p_rec.second_lac2_information1 ,
p_second_lac2_information2 => p_rec.second_lac2_information2 ,
p_second_lac2_information3 => p_rec.second_lac2_information3 ,
p_second_lac2_information4 => p_rec.second_lac2_information4 ,
p_second_lac2_information5 => p_rec.second_lac2_information5 ,
p_second_noa_information1 => p_rec.second_noa_information1 ,
p_second_noa_information2 => p_rec.second_noa_information2 ,
p_second_noa_information3 => p_rec.second_noa_information3 ,
p_second_noa_information4 => p_rec.second_noa_information4 ,
p_second_noa_information5 => p_rec.second_noa_information5 ,
p_first_lac1_information1 => p_rec.first_lac1_information1 ,
p_first_lac1_information2 => p_rec.first_lac1_information2 ,
p_first_lac1_information3 => p_rec.first_lac1_information3 ,
p_first_lac1_information4 => p_rec.first_lac1_information4 ,
p_first_lac1_information5 => p_rec.first_lac1_information5 ,
p_first_lac2_information1 => p_rec.first_lac2_information1 ,
p_first_lac2_information2 => p_rec.first_lac2_information2 ,
p_first_lac2_information3 => p_rec.first_lac2_information3 ,
p_first_lac2_information4 => p_rec.first_lac2_information4 ,
p_first_lac2_information5 => p_rec.first_lac2_information5 ,
p_attribute_category => p_rec.attribute_category ,
p_attribute1 => p_rec.attribute1 ,
p_attribute2 => p_rec.attribute2 ,
p_attribute3 => p_rec.attribute3 ,
p_attribute4 => p_rec.attribute4 ,
p_attribute5 => p_rec.attribute5 ,
p_attribute6 => p_rec.attribute6 ,
p_attribute7 => p_rec.attribute7 ,
p_attribute8 => p_rec.attribute8 ,
p_attribute9 => p_rec.attribute9 ,
p_attribute10 => p_rec.attribute10 ,
p_attribute11 => p_rec.attribute11 ,
p_attribute12 => p_rec.attribute12 ,
p_attribute13 => p_rec.attribute13 ,
p_attribute14 => p_rec.attribute14 ,
p_attribute15 => p_rec.attribute15 ,
p_attribute16 => p_rec.attribute16 ,
p_attribute17 => p_rec.attribute17 ,
p_attribute18 => p_rec.attribute18 ,
p_attribute19 => p_rec.attribute19 ,
p_attribute20 => p_rec.attribute20 ,
p_first_noa_canc_pa_request_id => p_rec.first_noa_canc_pa_request_id ,
p_second_noa_canc_pa_request_i => p_rec.second_noa_canc_pa_request_id ,
p_to_retention_allow_percentag => p_rec.to_retention_allow_percentage ,
p_to_supervisory_diff_percenta => p_rec.to_supervisory_diff_percentage ,
p_to_staffing_diff_percentage => p_rec.to_staffing_diff_percentage ,
p_award_percentage => p_rec.award_percentage ,
p_rpa_type => p_rec.rpa_type,
p_mass_action_id => p_rec.mass_action_id,
p_mass_action_eligible_flag => p_rec.mass_action_eligible_flag,
p_mass_action_select_flag => p_rec.mass_action_select_flag,
p_mass_action_comments => p_rec.mass_action_comments,
p_pa_notification_id_o => ghr_par_shd.g_old_rec.pa_notification_id ,
p_noa_family_code_o => ghr_par_shd.g_old_rec.noa_family_code ,
p_routing_group_id_o => ghr_par_shd.g_old_rec.routing_group_id ,
p_proposed_effective_asap_fl_o => ghr_par_shd.g_old_rec.proposed_effective_asap_flag ,
p_academic_discipline_o => ghr_par_shd.g_old_rec.academic_discipline ,
p_additional_info_person_id_o => ghr_par_shd.g_old_rec.additional_info_person_id ,
p_additional_info_tel_number_o => ghr_par_shd.g_old_rec.additional_info_tel_number ,
p_agency_code_o => ghr_par_shd.g_old_rec.agency_code ,
p_altered_pa_request_id_o => ghr_par_shd.g_old_rec.altered_pa_request_id ,
p_annuitant_indicator_o => ghr_par_shd.g_old_rec.annuitant_indicator ,
p_annuitant_indicator_desc_o => ghr_par_shd.g_old_rec.annuitant_indicator_desc ,
p_appropriation_code1_o => ghr_par_shd.g_old_rec.appropriation_code1 ,
p_appropriation_code2_o => ghr_par_shd.g_old_rec.appropriation_code2 ,
p_approval_date_o => ghr_par_shd.g_old_rec.approval_date ,
p_approving_official_full_na_o => ghr_par_shd.g_old_rec.approving_official_full_name ,
p_approving_official_work_ti_o => ghr_par_shd.g_old_rec.approving_official_work_title ,
p_sf50_approval_date_o => ghr_par_shd.g_old_rec.sf50_approval_date ,
p_sf50_approving_ofcl_full_n_o => ghr_par_shd.g_old_rec.sf50_approving_ofcl_full_name ,
p_sf50_approving_ofcl_work_t_o => ghr_par_shd.g_old_rec.sf50_approving_ofcl_work_title ,
p_authorized_by_person_id_o => ghr_par_shd.g_old_rec.authorized_by_person_id ,
p_authorized_by_title_o => ghr_par_shd.g_old_rec.authorized_by_title ,
p_award_amount_o => ghr_par_shd.g_old_rec.award_amount ,
p_award_uom_o => ghr_par_shd.g_old_rec.award_uom ,
p_bargaining_unit_status_o => ghr_par_shd.g_old_rec.bargaining_unit_status ,
p_citizenship_o => ghr_par_shd.g_old_rec.citizenship ,
p_concurrence_date_o => ghr_par_shd.g_old_rec.concurrence_date ,
p_custom_pay_calc_flag_o => ghr_par_shd.g_old_rec.custom_pay_calc_flag ,
p_duty_station_code_o => ghr_par_shd.g_old_rec.duty_station_code ,
p_duty_station_desc_o => ghr_par_shd.g_old_rec.duty_station_desc ,
p_duty_station_id_o => ghr_par_shd.g_old_rec.duty_station_id ,
p_duty_station_location_id_o => ghr_par_shd.g_old_rec.duty_station_location_id ,
p_education_level_o => ghr_par_shd.g_old_rec.education_level ,
p_effective_date_o => ghr_par_shd.g_old_rec.effective_date ,
p_employee_assignment_id_o => ghr_par_shd.g_old_rec.employee_assignment_id ,
p_employee_date_of_birth_o => ghr_par_shd.g_old_rec.employee_date_of_birth ,
p_employee_dept_or_agency_o => ghr_par_shd.g_old_rec.employee_dept_or_agency ,
p_employee_first_name_o => ghr_par_shd.g_old_rec.employee_first_name ,
p_employee_last_name_o => ghr_par_shd.g_old_rec.employee_last_name ,
p_employee_middle_names_o => ghr_par_shd.g_old_rec.employee_middle_names ,
p_employee_national_identifi_o => ghr_par_shd.g_old_rec.employee_national_identifier ,
p_fegli_o => ghr_par_shd.g_old_rec.fegli ,
p_fegli_desc_o => ghr_par_shd.g_old_rec.fegli_desc ,
p_first_action_la_code1_o => ghr_par_shd.g_old_rec.first_action_la_code1 ,
p_first_action_la_code2_o => ghr_par_shd.g_old_rec.first_action_la_code2 ,
p_first_action_la_desc1_o => ghr_par_shd.g_old_rec.first_action_la_desc1 ,
p_first_action_la_desc2_o => ghr_par_shd.g_old_rec.first_action_la_desc2 ,
p_first_noa_cancel_or_correc_o => ghr_par_shd.g_old_rec.first_noa_cancel_or_correct ,
p_first_noa_code_o => ghr_par_shd.g_old_rec.first_noa_code ,
p_first_noa_desc_o => ghr_par_shd.g_old_rec.first_noa_desc ,
p_first_noa_id_o => ghr_par_shd.g_old_rec.first_noa_id ,
p_first_noa_pa_request_id_o => ghr_par_shd.g_old_rec.first_noa_pa_request_id ,
p_flsa_category_o => ghr_par_shd.g_old_rec.flsa_category ,
p_forwarding_address_line1_o => ghr_par_shd.g_old_rec.forwarding_address_line1 ,
p_forwarding_address_line2_o => ghr_par_shd.g_old_rec.forwarding_address_line2 ,
p_forwarding_address_line3_o => ghr_par_shd.g_old_rec.forwarding_address_line3 ,
p_forwarding_country_o => ghr_par_shd.g_old_rec.forwarding_country ,
p_forwarding_country_short_n_o => ghr_par_shd.g_old_rec.forwarding_country_short_name ,
p_forwarding_postal_code_o => ghr_par_shd.g_old_rec.forwarding_postal_code ,
p_forwarding_region_2_o => ghr_par_shd.g_old_rec.forwarding_region_2 ,
p_forwarding_town_or_city_o => ghr_par_shd.g_old_rec.forwarding_town_or_city ,
p_from_adj_basic_pay_o => ghr_par_shd.g_old_rec.from_adj_basic_pay ,
p_from_agency_code_o => ghr_par_shd.g_old_rec.from_agency_code ,
p_from_agency_desc_o => ghr_par_shd.g_old_rec.from_agency_desc ,
p_from_basic_pay_o => ghr_par_shd.g_old_rec.from_basic_pay ,
p_from_grade_or_level_o => ghr_par_shd.g_old_rec.from_grade_or_level ,
p_from_locality_adj_o => ghr_par_shd.g_old_rec.from_locality_adj ,
p_from_occ_code_o => ghr_par_shd.g_old_rec.from_occ_code ,
p_from_office_symbol_o => ghr_par_shd.g_old_rec.from_office_symbol ,
p_from_other_pay_amount_o => ghr_par_shd.g_old_rec.from_other_pay_amount ,
p_from_pay_basis_o => ghr_par_shd.g_old_rec.from_pay_basis ,
p_from_pay_plan_o => ghr_par_shd.g_old_rec.from_pay_plan ,
-- FWFA Changes Bug#4444609
-- p_input_pay_rate_determinant_o => ghr_par_shd.g_old_rec.input_pay_rate_determinant ,
-- p_from_pay_table_identifier_o => ghr_par_shd.g_old_rec.from_pay_table_identifier ,
-- FWFA Changes
p_from_position_id_o => ghr_par_shd.g_old_rec.from_position_id ,
p_from_position_org_line1_o => ghr_par_shd.g_old_rec.from_position_org_line1 ,
p_from_position_org_line2_o => ghr_par_shd.g_old_rec.from_position_org_line2 ,
p_from_position_org_line3_o => ghr_par_shd.g_old_rec.from_position_org_line3 ,
p_from_position_org_line4_o => ghr_par_shd.g_old_rec.from_position_org_line4 ,
p_from_position_org_line5_o => ghr_par_shd.g_old_rec.from_position_org_line5 ,
p_from_position_org_line6_o => ghr_par_shd.g_old_rec.from_position_org_line6 ,
p_from_position_number_o => ghr_par_shd.g_old_rec.from_position_number ,
p_from_position_seq_no_o => ghr_par_shd.g_old_rec.from_position_seq_no ,
p_from_position_title_o => ghr_par_shd.g_old_rec.from_position_title ,
p_from_step_or_rate_o => ghr_par_shd.g_old_rec.from_step_or_rate ,
p_from_total_salary_o => ghr_par_shd.g_old_rec.from_total_salary ,
p_functional_class_o => ghr_par_shd.g_old_rec.functional_class ,
p_notepad_o => ghr_par_shd.g_old_rec.notepad ,
p_part_time_hours_o => ghr_par_shd.g_old_rec.part_time_hours ,
p_pay_rate_determinant_o => ghr_par_shd.g_old_rec.pay_rate_determinant ,
p_personnel_office_id_o => ghr_par_shd.g_old_rec.personnel_office_id ,
p_person_id_o => ghr_par_shd.g_old_rec.person_id ,
p_position_occupied_o => ghr_par_shd.g_old_rec.position_occupied ,
p_proposed_effective_date_o => ghr_par_shd.g_old_rec.proposed_effective_date ,
p_requested_by_person_id_o => ghr_par_shd.g_old_rec.requested_by_person_id ,
p_requested_by_title_o => ghr_par_shd.g_old_rec.requested_by_title ,
p_requested_date_o => ghr_par_shd.g_old_rec.requested_date ,
p_requesting_office_remark_d_o => ghr_par_shd.g_old_rec.requesting_office_remarks_desc ,
p_requesting_office_remark_f_o => ghr_par_shd.g_old_rec.requesting_office_remarks_flag ,
p_request_number_o => ghr_par_shd.g_old_rec.request_number ,
p_resign_and_retire_reason_d_o => ghr_par_shd.g_old_rec.resign_and_retire_reason_desc ,
p_retirement_plan_o => ghr_par_shd.g_old_rec.retirement_plan ,
p_retirement_plan_desc_o => ghr_par_shd.g_old_rec.retirement_plan_desc ,
p_second_action_la_code1_o => ghr_par_shd.g_old_rec.second_action_la_code1 ,
p_second_action_la_code2_o => ghr_par_shd.g_old_rec.second_action_la_code2 ,
p_second_action_la_desc1_o => ghr_par_shd.g_old_rec.second_action_la_desc1 ,
p_second_action_la_desc2_o => ghr_par_shd.g_old_rec.second_action_la_desc2 ,
p_second_noa_cancel_or_corre_o => ghr_par_shd.g_old_rec.second_noa_cancel_or_correct ,
p_second_noa_code_o => ghr_par_shd.g_old_rec.second_noa_code ,
p_second_noa_desc_o => ghr_par_shd.g_old_rec.second_noa_desc ,
p_second_noa_id_o => ghr_par_shd.g_old_rec.second_noa_id ,
p_second_noa_pa_request_id_o => ghr_par_shd.g_old_rec.second_noa_pa_request_id ,
p_service_comp_date_o => ghr_par_shd.g_old_rec.service_comp_date ,
p_status_o => ghr_par_shd.g_old_rec.status ,
p_supervisory_status_o => ghr_par_shd.g_old_rec.supervisory_status ,
p_tenure_o => ghr_par_shd.g_old_rec.tenure ,
p_to_adj_basic_pay_o => ghr_par_shd.g_old_rec.to_adj_basic_pay ,
p_to_basic_pay_o => ghr_par_shd.g_old_rec.to_basic_pay ,
p_to_grade_id_o => ghr_par_shd.g_old_rec.to_grade_id ,
p_to_grade_or_level_o => ghr_par_shd.g_old_rec.to_grade_or_level ,
p_to_job_id_o => ghr_par_shd.g_old_rec.to_job_id ,
p_to_locality_adj_o => ghr_par_shd.g_old_rec.to_locality_adj ,
p_to_occ_code_o => ghr_par_shd.g_old_rec.to_occ_code ,
p_to_office_symbol_o => ghr_par_shd.g_old_rec.to_office_symbol ,
p_to_organization_id_o => ghr_par_shd.g_old_rec.to_organization_id ,
p_to_other_pay_amount_o => ghr_par_shd.g_old_rec.to_other_pay_amount ,
p_to_au_overtime_o => ghr_par_shd.g_old_rec.to_au_overtime ,
p_to_auo_premium_pay_indicat_o => ghr_par_shd.g_old_rec.to_auo_premium_pay_indicator ,
p_to_availability_pay_o => ghr_par_shd.g_old_rec.to_availability_pay ,
p_to_ap_premium_pay_indicato_o => ghr_par_shd.g_old_rec.to_ap_premium_pay_indicator ,
p_to_retention_allowance_o => ghr_par_shd.g_old_rec.to_retention_allowance ,
p_to_supervisory_differentia_o => ghr_par_shd.g_old_rec.to_supervisory_differential ,
p_to_staffing_differential_o => ghr_par_shd.g_old_rec.to_staffing_differential ,
p_to_pay_basis_o => ghr_par_shd.g_old_rec.to_pay_basis ,
p_to_pay_plan_o => ghr_par_shd.g_old_rec.to_pay_plan ,
-- FWFA Changes Bug#4444609
-- p_to_pay_table_identifier_o => ghr_par_shd.g_old_rec.to_pay_table_identifier ,
-- FWFA Changes
p_to_position_id_o => ghr_par_shd.g_old_rec.to_position_id ,
p_to_position_org_line1_o => ghr_par_shd.g_old_rec.to_position_org_line1 ,
p_to_position_org_line2_o => ghr_par_shd.g_old_rec.to_position_org_line2 ,
p_to_position_org_line3_o => ghr_par_shd.g_old_rec.to_position_org_line3 ,
p_to_position_org_line4_o => ghr_par_shd.g_old_rec.to_position_org_line4 ,
p_to_position_org_line5_o => ghr_par_shd.g_old_rec.to_position_org_line5 ,
p_to_position_org_line6_o => ghr_par_shd.g_old_rec.to_position_org_line6 ,
p_to_position_number_o => ghr_par_shd.g_old_rec.to_position_number ,
p_to_position_seq_no_o => ghr_par_shd.g_old_rec.to_position_seq_no ,
p_to_position_title_o => ghr_par_shd.g_old_rec.to_position_title ,
p_to_step_or_rate_o => ghr_par_shd.g_old_rec.to_step_or_rate ,
p_to_total_salary_o => ghr_par_shd.g_old_rec.to_total_salary ,
p_veterans_preference_o => ghr_par_shd.g_old_rec.veterans_preference ,
p_veterans_pref_for_rif_o => ghr_par_shd.g_old_rec.veterans_pref_for_rif ,
p_veterans_status_o => ghr_par_shd.g_old_rec.veterans_status ,
p_work_schedule_o => ghr_par_shd.g_old_rec.work_schedule ,
p_work_schedule_desc_o => ghr_par_shd.g_old_rec.work_schedule_desc ,
p_year_degree_attained_o => ghr_par_shd.g_old_rec.year_degree_attained ,
p_first_noa_information1_o => ghr_par_shd.g_old_rec.first_noa_information1 ,
p_first_noa_information2_o => ghr_par_shd.g_old_rec.first_noa_information2 ,
p_first_noa_information3_o => ghr_par_shd.g_old_rec.first_noa_information3 ,
p_first_noa_information4_o => ghr_par_shd.g_old_rec.first_noa_information4 ,
p_first_noa_information5_o => ghr_par_shd.g_old_rec.first_noa_information5 ,
p_second_lac1_information1_o => ghr_par_shd.g_old_rec.second_lac1_information1 ,
p_second_lac1_information2_o => ghr_par_shd.g_old_rec.second_lac1_information2 ,
p_second_lac1_information3_o => ghr_par_shd.g_old_rec.second_lac1_information3 ,
p_second_lac1_information4_o => ghr_par_shd.g_old_rec.second_lac1_information4 ,
p_second_lac1_information5_o => ghr_par_shd.g_old_rec.second_lac1_information5 ,
p_second_lac2_information1_o => ghr_par_shd.g_old_rec.second_lac2_information1 ,
p_second_lac2_information2_o => ghr_par_shd.g_old_rec.second_lac2_information2 ,
p_second_lac2_information3_o => ghr_par_shd.g_old_rec.second_lac2_information3 ,
p_second_lac2_information4_o => ghr_par_shd.g_old_rec.second_lac2_information4 ,
p_second_lac2_information5_o => ghr_par_shd.g_old_rec.second_lac2_information5 ,
p_second_noa_information1_o => ghr_par_shd.g_old_rec.second_noa_information1 ,
p_second_noa_information2_o => ghr_par_shd.g_old_rec.second_noa_information2 ,
p_second_noa_information3_o => ghr_par_shd.g_old_rec.second_noa_information3 ,
p_second_noa_information4_o => ghr_par_shd.g_old_rec.second_noa_information4 ,
p_second_noa_information5_o => ghr_par_shd.g_old_rec.second_noa_information5 ,
p_first_lac1_information1_o => ghr_par_shd.g_old_rec.first_lac1_information1 ,
p_first_lac1_information2_o => ghr_par_shd.g_old_rec.first_lac1_information2 ,
p_first_lac1_information3_o => ghr_par_shd.g_old_rec.first_lac1_information3 ,
p_first_lac1_information4_o => ghr_par_shd.g_old_rec.first_lac1_information4 ,
p_first_lac1_information5_o => ghr_par_shd.g_old_rec.first_lac1_information5 ,
p_first_lac2_information1_o => ghr_par_shd.g_old_rec.first_lac2_information1 ,
p_first_lac2_information2_o => ghr_par_shd.g_old_rec.first_lac2_information2 ,
p_first_lac2_information3_o => ghr_par_shd.g_old_rec.first_lac2_information3 ,
p_first_lac2_information4_o => ghr_par_shd.g_old_rec.first_lac2_information4 ,
p_first_lac2_information5_o => ghr_par_shd.g_old_rec.first_lac2_information5 ,
p_attribute_category_o => ghr_par_shd.g_old_rec.attribute_category ,
p_attribute1_o => ghr_par_shd.g_old_rec.attribute1 ,
p_attribute2_o => ghr_par_shd.g_old_rec.attribute2 ,
p_attribute3_o => ghr_par_shd.g_old_rec.attribute3 ,
p_attribute4_o => ghr_par_shd.g_old_rec.attribute4 ,
p_attribute5_o => ghr_par_shd.g_old_rec.attribute5 ,
p_attribute6_o => ghr_par_shd.g_old_rec.attribute6 ,
p_attribute7_o => ghr_par_shd.g_old_rec.attribute7 ,
p_attribute8_o => ghr_par_shd.g_old_rec.attribute8 ,
p_attribute9_o => ghr_par_shd.g_old_rec.attribute9 ,
p_attribute10_o => ghr_par_shd.g_old_rec.attribute10 ,
p_attribute11_o => ghr_par_shd.g_old_rec.attribute11 ,
p_attribute12_o => ghr_par_shd.g_old_rec.attribute12 ,
p_attribute13_o => ghr_par_shd.g_old_rec.attribute13 ,
p_attribute14_o => ghr_par_shd.g_old_rec.attribute14 ,
p_attribute15_o => ghr_par_shd.g_old_rec.attribute15 ,
p_attribute16_o => ghr_par_shd.g_old_rec.attribute16 ,
p_attribute17_o => ghr_par_shd.g_old_rec.attribute17 ,
p_attribute18_o => ghr_par_shd.g_old_rec.attribute18 ,
p_attribute19_o => ghr_par_shd.g_old_rec.attribute19 ,
p_attribute20_o => ghr_par_shd.g_old_rec.attribute20 ,
p_first_noa_canc_pa_request_o => ghr_par_shd.g_old_rec.first_noa_canc_pa_request_id ,
p_second_noa_canc_pa_request_o => ghr_par_shd.g_old_rec.second_noa_canc_pa_request_id ,
p_to_retention_allow_percent_o => ghr_par_shd.g_old_rec.to_retention_allow_percentage ,
p_to_supervisory_diff_percen_o => ghr_par_shd.g_old_rec.to_supervisory_diff_percentage,
p_to_staffing_diff_percentag_o => ghr_par_shd.g_old_rec.to_staffing_diff_percentage ,
p_award_percentage_o => ghr_par_shd.g_old_rec.award_percentage ,
p_rpa_type_o => ghr_par_shd.g_old_rec.rpa_type,
p_mass_action_id_o => ghr_par_shd.g_old_rec.mass_action_id,
p_mass_action_eligible_flag_o => ghr_par_shd.g_old_rec.mass_action_eligible_flag,
p_mass_action_select_flag_o => ghr_par_shd.g_old_rec.mass_action_select_flag,
p_mass_action_comments_o => ghr_par_shd.g_old_rec.mass_action_comments
);
End post_update;
If (p_rec.mass_action_select_flag = hr_api.g_varchar2) then
p_rec.mass_action_select_flag :=
ghr_par_shd.g_old_rec.mass_action_select_flag;
ghr_par_bus.update_validate(p_rec);
pre_update(p_rec);
update_dml(p_rec);
post_update(p_rec);
p_mass_action_select_flag in varchar2 default hr_api.g_varchar2,
p_mass_action_comments in varchar2 default hr_api.g_varchar2,
-- Bug# RRR Changes
p_payment_option in varchar2 default hr_api.g_varchar2,
p_award_salary in number default hr_api.g_number,
-- Bug# RRR Changes
p_object_version_number in out nocopy number
)
is
--
l_rec ghr_par_shd.g_rec_type;
p_mass_action_select_flag ,
p_mass_action_comments ,
-- Bug# RRR Changes
p_payment_option ,
p_award_salary ,
-- Bug# RRR Changes
p_object_version_number
);