[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select PAH.*
from ghr_pa_history pah
where
(table_name = c_table_name and information1 = c_information1 and nvl(person_id, -1) = nvl(c_person_id,-1)) and
((effective_date = c_effective_date and
(( c_root_hist_id < pah.pa_history_id and pah.pa_request_id is null) or
(pah.pa_request_id is not null and pah.altered_pa_request_id is null and c_root_hist_id <
(select min(pa_history_id) from ghr_pa_history where pa_request_id = pah.pa_request_id
and nature_of_action_id = pah.nature_of_action_id)) or
(altered_pa_request_id is not null and c_root_hist_id <
(select min(pa_history_id) from ghr_pa_history pah2
where pa_request_id = (select min(pa_request_id) from ghr_pa_requests
connect by pa_request_id = prior altered_pa_request_id
start with pa_request_id = pah.pa_request_id) and
nature_of_action_id = pah.nature_of_action_id and
not exists (select 'exists'
from ghr_pa_history pah3
where pah3.pa_request_id = pah.altered_pa_request_id and
table_name = c_table_name and
information1 = c_information1
and pah3.nature_of_action_id = pah.nature_of_action_id)
)
)
)) OR
(effective_date > c_effective_date and
((pah.pa_request_id is null) or
(pah.pa_request_id is not null and pah.altered_pa_request_id is null) or
(pah.altered_pa_request_id is not null and not exists
(select 'exists'
from ghr_pa_history pah4
where pah4.pa_request_id = pah.altered_pa_request_id
and table_name = c_table_name
and information1 = c_information1
and pah4.nature_of_action_id = pah.nature_of_action_id)))))
order by effective_date , pa_history_id;
Select pah.*
from ghr_pa_history pah
where table_name = c_table_name
and information1 = c_information1
-- and person_id = c_person_id
-- see comments in the cursor c_history
and pa_request_id in
(select pa_request_id
from ghr_pa_requests
start with pa_request_id = c_pa_request_id
connect by prior pa_request_id = altered_pa_request_id)
and nature_of_action_id = c_noa_id
order by pa_history_id;
select min(pa_history_id)
from ghr_pa_history
where pa_request_id =
(select min(pa_request_id)
from ghr_pa_requests
connect by pa_request_id = prior altered_pa_request_id
start with pa_request_id = (select pa_request_id
from ghr_pa_history
where pa_history_id = cp_pa_history_id))
AND nature_of_action_id = (select nature_of_action_id
from ghr_pa_history
where pa_history_id = cp_pa_history_id);
-- update history record with changes to be cascaded :
hr_utility.set_location(l_proc,80);
Select *
from per_all_people_f
where effective_start_date >= c_date_effective and
person_id = c_person_id;
-- updated the same row on the same date, the data in the
-- core table might be incorrect since the date effectivity has the
-- granularity of a day, and not date and time. So, this will
-- re-apply the data from history for the effective date of the current action to the
-- core table. This will insure that the core table will contain the correct information
-- in all cases.
hr_utility.set_location( l_proc, 20);
Select *
from per_all_assignments_f
where effective_start_date >= c_date_effective and
assignment_id = c_asgn_id;
-- updated the same row on the same date, the data in the
-- core table might be incorrect since the date effectivity has the
-- granularity of a day, and not date and time. So, this will
-- re-apply the data from history for the effective date of the current action to the
-- core table. This will insure that the core table will contain the correct information
-- in all cases.
hr_utility.set_location( l_proc, 20);
-- the most recent record from history and update the database.
hr_utility.set_location( l_proc, 20);
-- the most recent record from history and update the database.
hr_utility.set_location( l_proc, 20);
-- the most recent record from history and update the database.
hr_utility.set_location( l_proc, 20);
-- the most recent record from history and update the database.
hr_utility.set_location( l_proc, 20);
Select *
from hr_all_positions_f
where effective_start_date >= c_date_effective and
position_id = c_posn_id;
-- updated the same row on the same date, the data in the
-- core table might be incorrect since the date effectivity has the
-- granularity of a day, and not date and time. So, this will
-- re-apply the data from history for the effective date of the current action to the
-- core table. This will insure that the core table will contain the correct information
-- in all cases.
hr_utility.set_location( l_proc, 20);
-- the most recent record from history and update the database.
hr_utility.set_location( l_proc, 20);
-- the most recent record from history and update the database.
hr_utility.set_location( l_proc, 20);
-- table can be updated.
cursor c_people_getovn( cp_person_id number,
cp_eff_st_dt date
,cp_eff_end_dt date) is
select object_version_number
from per_all_people_f
where person_id = cp_person_id
and effective_start_date = cp_eff_st_dt;
p_resume_last_updated => p_people_data.resume_last_updated ,
p_registered_disabled_flag => p_people_data.registered_disabled_flag ,
p_second_passport_exists => p_people_data.second_passport_exists ,
p_sex => p_people_data.sex ,
p_student_status => p_people_data.student_status ,
p_suffix => p_people_data.suffix ,
p_title => p_people_data.title ,
p_vendor_id => p_people_data.vendor_id ,
p_work_schedule => p_people_data.work_schedule ,
p_work_telephone => p_people_data.work_telephone ,
p_request_id => p_people_data.request_id ,
p_program_application_id => p_people_data.program_application_id ,
p_program_id => p_people_data.program_id ,
p_program_update_date => p_people_data.program_update_date ,
p_attribute_category => p_people_data.attribute_category ,
p_attribute1 => p_people_data.attribute1 ,
p_attribute2 => p_people_data.attribute2 ,
p_attribute3 => p_people_data.attribute3 ,
p_attribute4 => p_people_data.attribute4 ,
p_attribute5 => p_people_data.attribute5 ,
p_attribute6 => p_people_data.attribute6 ,
p_attribute7 => p_people_data.attribute7 ,
p_attribute8 => p_people_data.attribute8 ,
p_attribute9 => p_people_data.attribute9 ,
p_attribute10 => p_people_data.attribute10 ,
p_attribute11 => p_people_data.attribute11 ,
p_attribute12 => p_people_data.attribute12 ,
p_attribute13 => p_people_data.attribute13 ,
p_attribute14 => p_people_data.attribute14 ,
p_attribute15 => p_people_data.attribute15 ,
p_attribute16 => p_people_data.attribute16 ,
p_attribute17 => p_people_data.attribute17 ,
p_attribute18 => p_people_data.attribute18 ,
p_attribute19 => p_people_data.attribute19 ,
p_attribute20 => p_people_data.attribute20 ,
p_attribute21 => p_people_data.attribute21 ,
p_attribute22 => p_people_data.attribute22 ,
p_attribute23 => p_people_data.attribute23 ,
p_attribute24 => p_people_data.attribute24 ,
p_attribute25 => p_people_data.attribute25 ,
p_attribute26 => p_people_data.attribute26 ,
p_attribute27 => p_people_data.attribute27 ,
p_attribute28 => p_people_data.attribute28 ,
p_attribute29 => p_people_data.attribute29 ,
p_attribute30 => p_people_data.attribute30 ,
p_per_information_category => p_people_data.per_information_category ,
p_per_information1 => p_people_data.per_information1 ,
p_per_information2 => p_people_data.per_information2 ,
p_per_information3 => p_people_data.per_information3 ,
p_per_information4 => p_people_data.per_information4 ,
p_per_information5 => p_people_data.per_information5 ,
p_per_information6 => p_people_data.per_information6 ,
p_per_information7 => p_people_data.per_information7 ,
p_per_information8 => p_people_data.per_information8 ,
p_per_information9 => p_people_data.per_information9 ,
p_per_information10 => p_people_data.per_information10 ,
p_per_information11 => p_people_data.per_information11 ,
p_per_information12 => p_people_data.per_information12 ,
p_per_information13 => p_people_data.per_information13 ,
p_per_information14 => p_people_data.per_information14 ,
p_per_information15 => p_people_data.per_information15 ,
p_per_information16 => p_people_data.per_information16 ,
p_per_information17 => p_people_data.per_information17 ,
p_per_information18 => p_people_data.per_information18 ,
p_per_information19 => p_people_data.per_information19 ,
p_per_information20 => p_people_data.per_information20 ,
p_per_information21 => p_people_data.per_information21 ,
p_per_information22 => p_people_data.per_information22 ,
p_per_information23 => p_people_data.per_information23 ,
p_per_information24 => p_people_data.per_information24 ,
p_per_information25 => p_people_data.per_information25 ,
p_per_information26 => p_people_data.per_information26 ,
p_per_information27 => p_people_data.per_information27 ,
p_per_information28 => p_people_data.per_information28 ,
p_per_information29 => p_people_data.per_information29 ,
p_per_information30 => p_people_data.per_information30 ,
p_object_version_number => p_people_data.object_version_number ,
p_date_of_death => p_people_data.date_of_death ,
p_rehire_reason => p_people_data.rehire_reason ,
p_effective_date => p_people_data.effective_start_date ,
p_datetrack_mode => l_datetrack_mode ,
p_name_combination_warning => l_name_combination_warning ,
p_dob_null_warning => l_dob_null_warning,
p_orig_hire_warning => l_orig_hire_warning,
p_npw_number => p_people_data.npw_number,
p_current_npw_flag => p_people_data.current_npw_flag
);
-- table can be updated.
cursor c_asgn_getovn( cp_assignment_id number,
cp_eff_st_dt date
,cp_eff_end_dt date) is
select object_version_number
from per_all_assignments_f
where assignment_id = cp_assignment_id
and effective_start_date = cp_eff_st_dt;
l_payroll_id_updated boolean;
p_program_update_date => p_asgn_data.program_update_date ,
p_ass_attribute_category => p_asgn_data.ass_attribute_category ,
p_ass_attribute1 => p_asgn_data.ass_attribute1 ,
p_ass_attribute2 => p_asgn_data.ass_attribute2 ,
p_ass_attribute3 => p_asgn_data.ass_attribute3 ,
p_ass_attribute4 => p_asgn_data.ass_attribute4 ,
p_ass_attribute5 => p_asgn_data.ass_attribute5 ,
p_ass_attribute6 => p_asgn_data.ass_attribute6 ,
p_ass_attribute7 => p_asgn_data.ass_attribute7 ,
p_ass_attribute8 => p_asgn_data.ass_attribute8 ,
p_ass_attribute9 => p_asgn_data.ass_attribute9 ,
p_ass_attribute10 => p_asgn_data.ass_attribute10 ,
p_ass_attribute11 => p_asgn_data.ass_attribute11 ,
p_ass_attribute12 => p_asgn_data.ass_attribute12 ,
p_ass_attribute13 => p_asgn_data.ass_attribute13 ,
p_ass_attribute14 => p_asgn_data.ass_attribute14 ,
p_ass_attribute15 => p_asgn_data.ass_attribute15 ,
p_ass_attribute16 => p_asgn_data.ass_attribute16 ,
p_ass_attribute17 => p_asgn_data.ass_attribute17 ,
p_ass_attribute18 => p_asgn_data.ass_attribute18 ,
p_ass_attribute19 => p_asgn_data.ass_attribute19 ,
p_ass_attribute20 => p_asgn_data.ass_attribute20 ,
p_ass_attribute21 => p_asgn_data.ass_attribute21 ,
p_ass_attribute22 => p_asgn_data.ass_attribute22 ,
p_ass_attribute23 => p_asgn_data.ass_attribute23 ,
p_ass_attribute24 => p_asgn_data.ass_attribute24 ,
p_ass_attribute25 => p_asgn_data.ass_attribute25 ,
p_ass_attribute26 => p_asgn_data.ass_attribute26 ,
p_ass_attribute27 => p_asgn_data.ass_attribute27 ,
p_ass_attribute28 => p_asgn_data.ass_attribute28 ,
p_ass_attribute29 => p_asgn_data.ass_attribute29 ,
p_ass_attribute30 => p_asgn_data.ass_attribute30 ,
p_title => p_asgn_data.title ,
p_object_version_number => p_asgn_data.object_version_number ,
p_payroll_id_updated => l_payroll_id_updated ,
p_other_manager_warning => l_other_manager_warning ,
p_no_managers_warning => l_no_managers_warning ,
p_org_now_no_manager_warning => l_org_now_no_manager_warning ,
p_hourly_salaried_warning => l_hourly_salaried_warning ,
p_validation_start_date => l_validation_start_date ,
p_validation_end_date => l_validation_end_date ,
p_effective_date => l_effective_date ,
p_datetrack_mode => l_datetrack_mode ,
p_validate => l_validate
);
-- table can be updated.
cursor c_peopleei_getovn( cp_people_ei_id number) is
select object_version_number
from per_people_extra_info
where person_extra_info_id = cp_people_ei_id;
p_program_update_date => p_peopleei_data.program_update_date ,
p_pei_attribute_category => p_peopleei_data.pei_attribute_category ,
p_pei_attribute1 => p_peopleei_data.pei_attribute1 ,
p_pei_attribute2 => p_peopleei_data.pei_attribute2 ,
p_pei_attribute3 => p_peopleei_data.pei_attribute3 ,
p_pei_attribute4 => p_peopleei_data.pei_attribute4 ,
p_pei_attribute5 => p_peopleei_data.pei_attribute5 ,
p_pei_attribute6 => p_peopleei_data.pei_attribute6 ,
p_pei_attribute7 => p_peopleei_data.pei_attribute7 ,
p_pei_attribute8 => p_peopleei_data.pei_attribute8 ,
p_pei_attribute9 => p_peopleei_data.pei_attribute9 ,
p_pei_attribute10 => p_peopleei_data.pei_attribute10 ,
p_pei_attribute11 => p_peopleei_data.pei_attribute11 ,
p_pei_attribute12 => p_peopleei_data.pei_attribute12 ,
p_pei_attribute13 => p_peopleei_data.pei_attribute13 ,
p_pei_attribute14 => p_peopleei_data.pei_attribute14 ,
p_pei_attribute15 => p_peopleei_data.pei_attribute15 ,
p_pei_attribute16 => p_peopleei_data.pei_attribute16 ,
p_pei_attribute17 => p_peopleei_data.pei_attribute17 ,
p_pei_attribute18 => p_peopleei_data.pei_attribute18 ,
p_pei_attribute19 => p_peopleei_data.pei_attribute19 ,
p_pei_attribute20 => p_peopleei_data.pei_attribute20 ,
p_pei_information_category => p_peopleei_data.pei_information_category ,
p_pei_information1 => p_peopleei_data.pei_information1 ,
p_pei_information2 => p_peopleei_data.pei_information2 ,
p_pei_information3 => p_peopleei_data.pei_information3 ,
p_pei_information4 => p_peopleei_data.pei_information4 ,
p_pei_information5 => p_peopleei_data.pei_information5 ,
p_pei_information6 => p_peopleei_data.pei_information6 ,
p_pei_information7 => p_peopleei_data.pei_information7 ,
p_pei_information8 => p_peopleei_data.pei_information8 ,
p_pei_information9 => p_peopleei_data.pei_information9 ,
p_pei_information10 => p_peopleei_data.pei_information10 ,
p_pei_information11 => p_peopleei_data.pei_information11 ,
p_pei_information12 => p_peopleei_data.pei_information12 ,
p_pei_information13 => p_peopleei_data.pei_information13 ,
p_pei_information14 => p_peopleei_data.pei_information14 ,
p_pei_information15 => p_peopleei_data.pei_information15 ,
p_pei_information16 => p_peopleei_data.pei_information16 ,
p_pei_information17 => p_peopleei_data.pei_information17 ,
p_pei_information18 => p_peopleei_data.pei_information18 ,
p_pei_information19 => p_peopleei_data.pei_information19 ,
p_pei_information20 => p_peopleei_data.pei_information20 ,
p_pei_information21 => p_peopleei_data.pei_information21 ,
p_pei_information22 => p_peopleei_data.pei_information22 ,
p_pei_information23 => p_peopleei_data.pei_information23 ,
p_pei_information24 => p_peopleei_data.pei_information24 ,
p_pei_information25 => p_peopleei_data.pei_information25 ,
p_pei_information26 => p_peopleei_data.pei_information26 ,
p_pei_information27 => p_peopleei_data.pei_information27 ,
p_pei_information28 => p_peopleei_data.pei_information28 ,
p_pei_information29 => p_peopleei_data.pei_information29 ,
p_pei_information30 => p_peopleei_data.pei_information30 ,
p_object_version_number => p_peopleei_data.object_version_number
);
-- table can be updated.
cursor c_asgnei_getovn( cp_assignment_ei_id number) is
select object_version_number
from per_assignment_extra_info
where assignment_extra_info_id = cp_assignment_ei_id;
p_program_update_date => p_asgnei_data.program_update_date ,
p_aei_attribute_category => p_asgnei_data.aei_attribute_category ,
p_aei_attribute1 => p_asgnei_data.aei_attribute1 ,
p_aei_attribute2 => p_asgnei_data.aei_attribute2 ,
p_aei_attribute3 => p_asgnei_data.aei_attribute3 ,
p_aei_attribute4 => p_asgnei_data.aei_attribute4 ,
p_aei_attribute5 => p_asgnei_data.aei_attribute5 ,
p_aei_attribute6 => p_asgnei_data.aei_attribute6 ,
p_aei_attribute7 => p_asgnei_data.aei_attribute7 ,
p_aei_attribute8 => p_asgnei_data.aei_attribute8 ,
p_aei_attribute9 => p_asgnei_data.aei_attribute9 ,
p_aei_attribute10 => p_asgnei_data.aei_attribute10 ,
p_aei_attribute11 => p_asgnei_data.aei_attribute11 ,
p_aei_attribute12 => p_asgnei_data.aei_attribute12 ,
p_aei_attribute13 => p_asgnei_data.aei_attribute13 ,
p_aei_attribute14 => p_asgnei_data.aei_attribute14 ,
p_aei_attribute15 => p_asgnei_data.aei_attribute15 ,
p_aei_attribute16 => p_asgnei_data.aei_attribute16 ,
p_aei_attribute17 => p_asgnei_data.aei_attribute17 ,
p_aei_attribute18 => p_asgnei_data.aei_attribute18 ,
p_aei_attribute19 => p_asgnei_data.aei_attribute19 ,
p_aei_attribute20 => p_asgnei_data.aei_attribute20 ,
p_aei_information_category => p_asgnei_data.aei_information_category ,
p_aei_information1 => p_asgnei_data.aei_information1 ,
p_aei_information2 => p_asgnei_data.aei_information2 ,
p_aei_information3 => p_asgnei_data.aei_information3 ,
p_aei_information4 => p_asgnei_data.aei_information4 ,
p_aei_information5 => p_asgnei_data.aei_information5 ,
p_aei_information6 => p_asgnei_data.aei_information6 ,
p_aei_information7 => p_asgnei_data.aei_information7 ,
p_aei_information8 => p_asgnei_data.aei_information8 ,
p_aei_information9 => p_asgnei_data.aei_information9 ,
p_aei_information10 => p_asgnei_data.aei_information10 ,
p_aei_information11 => p_asgnei_data.aei_information11 ,
p_aei_information12 => p_asgnei_data.aei_information12 ,
p_aei_information13 => p_asgnei_data.aei_information13 ,
p_aei_information14 => p_asgnei_data.aei_information14 ,
p_aei_information15 => p_asgnei_data.aei_information15 ,
p_aei_information16 => p_asgnei_data.aei_information16 ,
p_aei_information17 => p_asgnei_data.aei_information17 ,
p_aei_information18 => p_asgnei_data.aei_information18 ,
p_aei_information19 => p_asgnei_data.aei_information19 ,
p_aei_information20 => p_asgnei_data.aei_information20 ,
p_aei_information21 => p_asgnei_data.aei_information21 ,
p_aei_information22 => p_asgnei_data.aei_information22 ,
p_aei_information23 => p_asgnei_data.aei_information23 ,
p_aei_information24 => p_asgnei_data.aei_information24 ,
p_aei_information25 => p_asgnei_data.aei_information25 ,
p_aei_information26 => p_asgnei_data.aei_information26 ,
p_aei_information27 => p_asgnei_data.aei_information27 ,
p_aei_information28 => p_asgnei_data.aei_information28 ,
p_aei_information29 => p_asgnei_data.aei_information29 ,
p_aei_information30 => p_asgnei_data.aei_information30 ,
p_object_version_number => p_asgnei_data.object_version_number
);
-- table can be updated.
cursor c_posnei_getovn( cp_position_ei_id number) is
select object_version_number
from per_position_extra_info
where position_extra_info_id = cp_position_ei_id;
p_program_update_date => p_posnei_data.program_update_date ,
p_poei_attribute_category => p_posnei_data.poei_attribute_category ,
p_poei_attribute1 => p_posnei_data.poei_attribute1 ,
p_poei_attribute2 => p_posnei_data.poei_attribute2 ,
p_poei_attribute3 => p_posnei_data.poei_attribute3 ,
p_poei_attribute4 => p_posnei_data.poei_attribute4 ,
p_poei_attribute5 => p_posnei_data.poei_attribute5 ,
p_poei_attribute6 => p_posnei_data.poei_attribute6 ,
p_poei_attribute7 => p_posnei_data.poei_attribute7 ,
p_poei_attribute8 => p_posnei_data.poei_attribute8 ,
p_poei_attribute9 => p_posnei_data.poei_attribute9 ,
p_poei_attribute10 => p_posnei_data.poei_attribute10 ,
p_poei_attribute11 => p_posnei_data.poei_attribute11 ,
p_poei_attribute12 => p_posnei_data.poei_attribute12 ,
p_poei_attribute13 => p_posnei_data.poei_attribute13 ,
p_poei_attribute14 => p_posnei_data.poei_attribute14 ,
p_poei_attribute15 => p_posnei_data.poei_attribute15 ,
p_poei_attribute16 => p_posnei_data.poei_attribute16 ,
p_poei_attribute17 => p_posnei_data.poei_attribute17 ,
p_poei_attribute18 => p_posnei_data.poei_attribute18 ,
p_poei_attribute19 => p_posnei_data.poei_attribute19 ,
p_poei_attribute20 => p_posnei_data.poei_attribute20 ,
p_poei_information_category => p_posnei_data.poei_information_category ,
p_poei_information1 => p_posnei_data.poei_information1 ,
p_poei_information2 => p_posnei_data.poei_information2 ,
p_poei_information3 => p_posnei_data.poei_information3 ,
p_poei_information4 => p_posnei_data.poei_information4 ,
p_poei_information5 => p_posnei_data.poei_information5 ,
p_poei_information6 => p_posnei_data.poei_information6 ,
p_poei_information7 => p_posnei_data.poei_information7 ,
p_poei_information8 => p_posnei_data.poei_information8 ,
p_poei_information9 => p_posnei_data.poei_information9 ,
p_poei_information10 => p_posnei_data.poei_information10 ,
p_poei_information11 => p_posnei_data.poei_information11 ,
p_poei_information12 => p_posnei_data.poei_information12 ,
p_poei_information13 => p_posnei_data.poei_information13 ,
p_poei_information14 => p_posnei_data.poei_information14 ,
p_poei_information15 => p_posnei_data.poei_information15 ,
p_poei_information16 => p_posnei_data.poei_information16 ,
p_poei_information17 => p_posnei_data.poei_information17 ,
p_poei_information18 => p_posnei_data.poei_information18 ,
p_poei_information19 => p_posnei_data.poei_information19 ,
p_poei_information20 => p_posnei_data.poei_information20 ,
p_poei_information21 => p_posnei_data.poei_information21 ,
p_poei_information22 => p_posnei_data.poei_information22 ,
p_poei_information23 => p_posnei_data.poei_information23 ,
p_poei_information24 => p_posnei_data.poei_information24 ,
p_poei_information25 => p_posnei_data.poei_information25 ,
p_poei_information26 => p_posnei_data.poei_information26 ,
p_poei_information27 => p_posnei_data.poei_information27 ,
p_poei_information28 => p_posnei_data.poei_information28 ,
p_poei_information29 => p_posnei_data.poei_information29 ,
p_poei_information30 => p_posnei_data.poei_information30 ,
p_object_version_number => p_posnei_data.object_version_number
);
-- table can be updated.
cursor c_posn_getovn( cp_position_id number
,cp_eff_st_dt date
,cp_eff_end_dt date) is
select object_version_number
from hr_all_positions_f
where position_id = cp_position_id
and effective_start_date = cp_eff_st_dt;
l_position_data_rec ghr_sf52_pos_update.position_data_rec_type;
p_update_source_cd => p_posn_data.update_source_cd ,
p_working_hours => p_posn_data.working_hours ,
p_works_council_approval_flag => p_posn_data.works_council_approval_flag ,
p_work_period_type_cd => p_posn_data.work_period_type_cd ,
p_work_term_end_day_cd => p_posn_data.work_term_end_day_cd ,
p_work_term_end_month_cd => p_posn_data.work_term_end_month_cd ,
p_proposed_fte_for_layoff => p_posn_data.proposed_fte_for_layoff ,
p_proposed_date_for_layoff => p_posn_data.proposed_date_for_layoff ,
p_pay_basis_id => p_posn_data.pay_basis_id ,
p_supervisor_id => p_posn_data.supervisor_id ,
p_copied_to_old_table_flag => p_posn_data.copied_to_old_table_flag ,
p_information1 => p_posn_data.information1 ,
p_information2 => p_posn_data.information2 ,
p_information3 => p_posn_data.information3 ,
p_information4 => p_posn_data.information4 ,
p_information5 => p_posn_data.information5 ,
p_information6 => p_posn_data.information6 ,
p_information7 => p_posn_data.information7 ,
p_information8 => p_posn_data.information8 ,
p_information9 => p_posn_data.information9 ,
p_information10 => p_posn_data.information10 ,
p_information11 => p_posn_data.information11 ,
p_information12 => p_posn_data.information12 ,
p_information13 => p_posn_data.information13 ,
p_information14 => p_posn_data.information14 ,
p_information15 => p_posn_data.information15 ,
p_information16 => p_posn_data.information16 ,
p_information17 => p_posn_data.information17 ,
p_information18 => p_posn_data.information18 ,
p_information19 => p_posn_data.information19 ,
p_information20 => p_posn_data.information20 ,
p_information21 => p_posn_data.information21 ,
p_information22 => p_posn_data.information22 ,
p_information23 => p_posn_data.information23 ,
p_information24 => p_posn_data.information24 ,
p_information25 => p_posn_data.information25 ,
p_information26 => p_posn_data.information26 ,
p_information27 => p_posn_data.information27 ,
p_information28 => p_posn_data.information28 ,
p_information29 => p_posn_data.information29 ,
p_information30 => p_posn_data.information30 ,
p_information_category => p_posn_data.information_category ,
p_attribute1 => p_posn_data.attribute1 ,
p_attribute2 => p_posn_data.attribute2 ,
p_attribute3 => p_posn_data.attribute3 ,
p_attribute4 => p_posn_data.attribute4 ,
p_attribute5 => p_posn_data.attribute5 ,
p_attribute6 => p_posn_data.attribute6 ,
p_attribute7 => p_posn_data.attribute7 ,
p_attribute8 => p_posn_data.attribute8 ,
p_attribute9 => p_posn_data.attribute9 ,
p_attribute10 => p_posn_data.attribute10 ,
p_attribute11 => p_posn_data.attribute11 ,
p_attribute12 => p_posn_data.attribute12 ,
p_attribute13 => p_posn_data.attribute13 ,
p_attribute14 => p_posn_data.attribute14 ,
p_attribute15 => p_posn_data.attribute15 ,
p_attribute16 => p_posn_data.attribute16 ,
p_attribute17 => p_posn_data.attribute17 ,
p_attribute18 => p_posn_data.attribute18 ,
p_attribute19 => p_posn_data.attribute19 ,
p_attribute20 => p_posn_data.attribute20 ,
p_attribute21 => p_posn_data.attribute21 ,
p_attribute22 => p_posn_data.attribute22 ,
p_attribute23 => p_posn_data.attribute23 ,
p_attribute24 => p_posn_data.attribute24 ,
p_attribute25 => p_posn_data.attribute25 ,
p_attribute26 => p_posn_data.attribute26 ,
p_attribute27 => p_posn_data.attribute27 ,
p_attribute28 => p_posn_data.attribute28 ,
p_attribute29 => p_posn_data.attribute29 ,
p_attribute30 => p_posn_data.attribute30 ,
p_attribute_category => p_posn_data.attribute_category ,
p_request_id => p_posn_data.request_id ,
p_program_application_id => p_posn_data.program_application_id ,
p_program_id => p_posn_data.program_id ,
p_program_update_date => p_posn_data.program_update_date ,
p_object_version_number => p_posn_data.object_version_number ,
p_datetrack_mode => l_datetrack_mode ,
p_effective_date => p_posn_data.effective_start_date
);
ghr_sf52_pos_update.update_position_info
(p_pos_data_rec => l_position_data_rec
);
-- table can be updated.
cursor c_addr is
select object_version_number
from per_addresses
where address_id = p_addr_data.address_id;
-- table can be updated.
cursor c_perana is
select object_version_number
from per_person_analyses
where person_analysis_id = p_perana_data.person_analysis_id;