The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure dt_update_dml
(p_rec in out nocopy per_per_shd.g_rec_type,
p_effective_date in date,
p_datetrack_mode in varchar2,
p_validation_start_date in date,
p_validation_end_date in date) is
--
l_proc varchar2(72) := g_package||'dt_update_dml';
select *
from per_all_people_f
where person_id = p_rec.person_id
and p_effective_date
between effective_start_date
and effective_end_date;
update per_all_people_f
set
person_id = p_rec.person_id,
person_type_id = p_rec.person_type_id,
last_name = p_rec.last_name,
start_date = p_rec.start_date,
applicant_number = p_rec.applicant_number,
comment_id = p_rec.comment_id,
current_applicant_flag = p_rec.current_applicant_flag,
current_emp_or_apl_flag = p_rec.current_emp_or_apl_flag,
current_employee_flag = p_rec.current_employee_flag,
date_employee_data_verified = p_rec.date_employee_data_verified,
date_of_birth = p_rec.date_of_birth,
email_address = p_rec.email_address,
employee_number = p_rec.employee_number,
expense_check_send_to_address = p_rec.expense_check_send_to_address,
first_name = p_rec.first_name,
full_name = p_rec.full_name,
known_as = p_rec.known_as,
marital_status = p_rec.marital_status,
middle_names = p_rec.middle_names,
nationality = p_rec.nationality,
national_identifier = p_rec.national_identifier,
previous_last_name = p_rec.previous_last_name,
registered_disabled_flag = p_rec.registered_disabled_flag,
sex = p_rec.sex,
title = p_rec.title,
vendor_id = p_rec.vendor_id,
-- work_telephone = p_rec.work_telephone,
request_id = p_rec.request_id,
program_application_id = p_rec.program_application_id,
program_id = p_rec.program_id,
program_update_date = p_rec.program_update_date,
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,
attribute21 = p_rec.attribute21,
attribute22 = p_rec.attribute22,
attribute23 = p_rec.attribute23,
attribute24 = p_rec.attribute24,
attribute25 = p_rec.attribute25,
attribute26 = p_rec.attribute26,
attribute27 = p_rec.attribute27,
attribute28 = p_rec.attribute28,
attribute29 = p_rec.attribute29,
attribute30 = p_rec.attribute30,
per_information_category = p_rec.per_information_category,
per_information1 = p_rec.per_information1,
per_information2 = p_rec.per_information2,
per_information3 = p_rec.per_information3,
per_information4 = p_rec.per_information4,
per_information5 = p_rec.per_information5,
per_information6 = p_rec.per_information6,
per_information7 = p_rec.per_information7,
per_information8 = p_rec.per_information8,
per_information9 = p_rec.per_information9,
per_information10 = p_rec.per_information10,
per_information11 = p_rec.per_information11,
per_information12 = p_rec.per_information12,
per_information13 = p_rec.per_information13,
per_information14 = p_rec.per_information14,
per_information15 = p_rec.per_information15,
per_information16 = p_rec.per_information16,
per_information17 = p_rec.per_information17,
per_information18 = p_rec.per_information18,
per_information19 = p_rec.per_information19,
per_information20 = p_rec.per_information20,
object_version_number = p_rec.object_version_number,
suffix = p_rec.suffix,
DATE_OF_DEATH = p_rec.DATE_OF_DEATH,
BACKGROUND_CHECK_STATUS = p_rec.BACKGROUND_CHECK_STATUS ,
BACKGROUND_DATE_CHECK = p_rec.BACKGROUND_DATE_CHECK ,
BLOOD_TYPE = p_rec.BLOOD_TYPE ,
CORRESPONDENCE_LANGUAGE = p_rec.CORRESPONDENCE_LANGUAGE ,
FAST_PATH_EMPLOYEE = p_rec.FAST_PATH_EMPLOYEE ,
FTE_CAPACITY = p_rec.FTE_CAPACITY ,
HOLD_APPLICANT_DATE_UNTIL = p_rec.HOLD_APPLICANT_DATE_UNTIL ,
HONORS = p_rec.HONORS ,
INTERNAL_LOCATION = p_rec.INTERNAL_LOCATION ,
LAST_MEDICAL_TEST_BY = p_rec.LAST_MEDICAL_TEST_BY ,
LAST_MEDICAL_TEST_DATE = p_rec.LAST_MEDICAL_TEST_DATE ,
MAILSTOP = p_rec.MAILSTOP ,
OFFICE_NUMBER = p_rec.OFFICE_NUMBER ,
ON_MILITARY_SERVICE = p_rec.ON_MILITARY_SERVICE ,
ORDER_NAME = p_rec.ORDER_NAME ,
PRE_NAME_ADJUNCT = p_rec.PRE_NAME_ADJUNCT ,
PROJECTED_START_DATE = p_rec.PROJECTED_START_DATE ,
REHIRE_AUTHORIZOR = p_rec.REHIRE_AUTHORIZOR ,
REHIRE_RECOMMENDATION = p_rec.REHIRE_RECOMMENDATION ,
RESUME_EXISTS = p_rec.RESUME_EXISTS ,
RESUME_LAST_UPDATED = p_rec.RESUME_LAST_UPDATED ,
SECOND_PASSPORT_EXISTS = p_rec.SECOND_PASSPORT_EXISTS ,
STUDENT_STATUS = p_rec.STUDENT_STATUS ,
WORK_SCHEDULE = p_rec.WORK_SCHEDULE ,
PER_INFORMATION21 = p_rec.PER_INFORMATION21 ,
PER_INFORMATION22 = p_rec.PER_INFORMATION22 ,
PER_INFORMATION23 = p_rec.PER_INFORMATION23 ,
PER_INFORMATION24 = p_rec.PER_INFORMATION24 ,
PER_INFORMATION25 = p_rec.PER_INFORMATION25 ,
PER_INFORMATION26 = p_rec.PER_INFORMATION26 ,
PER_INFORMATION27 = p_rec.PER_INFORMATION27 ,
PER_INFORMATION28 = p_rec.PER_INFORMATION28 ,
PER_INFORMATION29 = p_rec.PER_INFORMATION29 ,
PER_INFORMATION30 = p_rec.PER_INFORMATION30 ,
REHIRE_REASON = p_rec.REHIRE_REASON ,
BENEFIT_GROUP_ID = p_rec.BENEFIT_GROUP_ID ,
RECEIPT_OF_DEATH_CERT_DATE = p_rec.RECEIPT_OF_DEATH_CERT_DATE ,
COORD_BEN_MED_PLN_NO = p_rec.COORD_BEN_MED_PLN_NO ,
COORD_BEN_NO_CVG_FLAG = p_rec.COORD_BEN_NO_CVG_FLAG ,
COORD_BEN_MED_EXT_ER = p_rec.COORD_BEN_MED_ext_er,
COORD_BEN_MED_PL_NAME = p_rec.COORD_BEN_MED_pl_name,
COORD_BEN_MED_INSR_CRR_NAME = p_rec.COORD_BEN_MED_insr_crr_name,
COORD_BEN_MED_INSR_CRR_IDENT = p_rec.COORD_BEN_MED_insr_crr_ident,
COORD_BEN_MED_CVG_STRT_DT = p_rec.COORD_BEN_MED_cvg_strt_dt,
COORD_BEN_MED_CVG_END_DT = p_rec.COORD_BEN_MED_cvg_end_dt,
USES_TOBACCO_FLAG = p_rec.USES_TOBACCO_FLAG ,
DPDNT_ADOPTION_DATE = p_rec.DPDNT_ADOPTION_DATE ,
DPDNT_VLNTRY_SVCE_FLAG = p_rec.DPDNT_VLNTRY_SVCE_FLAG ,
ORIGINAL_DATE_OF_HIRE = p_rec.ORIGINAL_DATE_OF_HIRE ,
town_of_birth = p_rec.town_of_birth ,
region_of_birth = p_rec.region_of_birth ,
country_of_birth = p_rec.country_of_birth ,
global_person_id = p_rec.global_person_id ,
party_id = p_rec.party_id,
npw_number = p_rec.npw_number,
current_npw_flag = p_rec.current_npw_flag,
global_name = p_rec.global_name, -- #3889584
local_name = p_rec.local_name
where person_id = p_rec.person_id
and effective_start_date = p_validation_start_date
and effective_end_date = p_validation_end_date;
per_hrtca_merge.update_tca_person(p_rec => l_person);
End dt_update_dml;
Procedure update_dml
(p_rec in out nocopy per_per_shd.g_rec_type,
p_effective_date in date,
p_datetrack_mode in varchar2,
p_validation_start_date in date,
p_validation_end_date in date) is
--
l_proc varchar2(72) := g_package||'update_dml';
dt_update_dml(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => p_datetrack_mode,
p_validation_start_date => p_validation_start_date,
p_validation_end_date => p_validation_end_date);
End update_dml;
Procedure dt_pre_update
(p_rec in out nocopy per_per_shd.g_rec_type,
p_effective_date in date,
p_datetrack_mode in varchar2,
p_validation_start_date in date,
p_validation_end_date in date) is
--
l_proc varchar2(72) := g_package||'dt_pre_update';
If (p_datetrack_mode = 'UPDATE_OVERRIDE') then
hr_utility.set_location(l_proc, 15);
per_per_del.delete_dml
(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => p_datetrack_mode,
p_validation_start_date => p_validation_start_date,
p_validation_end_date => p_validation_end_date);
per_per_ins.insert_dml
(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => p_datetrack_mode,
p_validation_start_date => p_validation_start_date,
p_validation_end_date => p_validation_end_date);
End dt_pre_update;
Procedure pre_update
(p_rec in out nocopy per_per_shd.g_rec_type,
p_effective_date in date,
p_datetrack_mode in varchar2,
p_validation_start_date in date,
p_validation_end_date in date) is
--
l_proc varchar2(72) := g_package||'pre_update';
select rowid, effective_start_date, effective_end_date
from per_all_people_f
where person_id = p_rec.person_id
and p_effective_date between
effective_start_date and effective_end_date;
select rowid
from per_all_people_f
where person_id = p_rec.person_id
and p_effective_date -1 between
effective_start_date and effective_end_date;
dt_pre_update
(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => p_datetrack_mode,
p_validation_start_date => p_validation_start_date,
p_validation_end_date => p_validation_end_date);
(p_event => 'UPDATE',
p_old_rec => per_per_shd.g_old_rec,
p_new_rec => p_rec
);
End pre_update;
Procedure post_update
(p_rec in per_per_shd.g_rec_type,
p_effective_date in date,
p_datetrack_mode in varchar2,
p_validation_start_date in date,
p_validation_end_date in date,
p_name_combination_warning in boolean,
p_dob_null_warning in boolean,
p_orig_hire_warning in boolean) is
--
l_proc varchar2(72) := g_package||'post_update';
select *
from per_all_people_f
where person_id = p_rec.person_id
and effective_start_date = p_rec.effective_start_date
and effective_end_date = p_rec.effective_end_date;
per_per_rku.after_update
(p_person_id => p_rec.person_id
,p_effective_start_date => p_rec.effective_start_date
,p_effective_end_date => p_rec.effective_end_date
,p_person_type_id => p_rec.person_type_id
,p_last_name => p_rec.last_name
,p_start_date => p_rec.start_date
,p_applicant_number => p_rec.applicant_number
,p_comment_id => p_rec.comment_id
,p_comments => p_rec.comments
,p_current_applicant_flag => p_rec.current_applicant_flag
,p_current_emp_or_apl_flag => p_rec.current_emp_or_apl_flag
,p_current_employee_flag => p_rec.current_employee_flag
,p_date_employee_data_verified => p_rec.date_employee_data_verified
,p_date_of_birth => p_rec.date_of_birth
,p_email_address => p_rec.email_address
,p_employee_number => p_rec.employee_number
,p_expense_check_send_to_addres => p_rec.expense_check_send_to_address
,p_first_name => p_rec.first_name
,p_full_name => p_rec.full_name
,p_known_as => p_rec.known_as
,p_marital_status => p_rec.marital_status
,p_middle_names => p_rec.middle_names
,p_nationality => p_rec.nationality
,p_national_identifier => p_rec.national_identifier
,p_previous_last_name => p_rec.previous_last_name
,p_registered_disabled_flag => p_rec.registered_disabled_flag
,p_sex => p_rec.sex
,p_title => p_rec.title
,p_vendor_id => p_rec.vendor_id
,p_work_telephone => p_rec.work_telephone
,p_request_id => p_rec.request_id
,p_program_application_id => p_rec.program_application_id
,p_program_id => p_rec.program_id
,p_program_update_date => p_rec.program_update_date
,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_attribute21 => p_rec.attribute21
,p_attribute22 => p_rec.attribute22
,p_attribute23 => p_rec.attribute23
,p_attribute24 => p_rec.attribute24
,p_attribute25 => p_rec.attribute25
,p_attribute26 => p_rec.attribute26
,p_attribute27 => p_rec.attribute27
,p_attribute28 => p_rec.attribute28
,p_attribute29 => p_rec.attribute29
,p_attribute30 => p_rec.attribute30
,p_per_information_category => p_rec.per_information_category
,p_per_information1 => p_rec.per_information1
,p_per_information2 => p_rec.per_information2
,p_per_information3 => p_rec.per_information3
,p_per_information4 => p_rec.per_information4
,p_per_information5 => p_rec.per_information5
,p_per_information6 => p_rec.per_information6
,p_per_information7 => p_rec.per_information7
,p_per_information8 => p_rec.per_information8
,p_per_information9 => p_rec.per_information9
,p_per_information10 => p_rec.per_information10
,p_per_information11 => p_rec.per_information11
,p_per_information12 => p_rec.per_information12
,p_per_information13 => p_rec.per_information13
,p_per_information14 => p_rec.per_information14
,p_per_information15 => p_rec.per_information15
,p_per_information16 => p_rec.per_information16
,p_per_information17 => p_rec.per_information17
,p_per_information18 => p_rec.per_information18
,p_per_information19 => p_rec.per_information19
,p_per_information20 => p_rec.per_information20
,p_suffix => p_rec.suffix
,p_DATE_OF_DEATH => p_rec.DATE_OF_DEATH
,p_BACKGROUND_CHECK_STATUS => p_rec.BACKGROUND_CHECK_STATUS
,p_BACKGROUND_DATE_CHECK => p_rec.BACKGROUND_DATE_CHECK
,p_BLOOD_TYPE => p_rec.BLOOD_TYPE
,p_CORRESPONDENCE_LANGUAGE => p_rec.CORRESPONDENCE_LANGUAGE
,p_FAST_PATH_EMPLOYEE => p_rec.FAST_PATH_EMPLOYEE
,p_FTE_CAPACITY => p_rec.FTE_CAPACITY
,p_HOLD_APPLICANT_DATE_UNTIL => p_rec.HOLD_APPLICANT_DATE_UNTIL
,p_HONORS => p_rec.HONORS
,p_INTERNAL_LOCATION => p_rec.INTERNAL_LOCATION
,p_LAST_MEDICAL_TEST_BY => p_rec.LAST_MEDICAL_TEST_BY
,p_LAST_MEDICAL_TEST_DATE => p_rec.LAST_MEDICAL_TEST_DATE
,p_MAILSTOP => p_rec.MAILSTOP
,p_OFFICE_NUMBER => p_rec.OFFICE_NUMBER
,p_ON_MILITARY_SERVICE => p_rec.ON_MILITARY_SERVICE
,p_ORDER_NAME => p_rec.ORDER_NAME
,p_PRE_NAME_ADJUNCT => p_rec.PRE_NAME_ADJUNCT
,p_PROJECTED_START_DATE => p_rec.PROJECTED_START_DATE
,p_REHIRE_AUTHORIZOR => p_rec.REHIRE_AUTHORIZOR
,p_REHIRE_RECOMMENDATION => p_rec.REHIRE_RECOMMENDATION
,p_RESUME_EXISTS => p_rec.RESUME_EXISTS
,p_RESUME_LAST_UPDATED => p_rec.RESUME_LAST_UPDATED
,p_SECOND_PASSPORT_EXISTS => p_rec.SECOND_PASSPORT_EXISTS
,p_STUDENT_STATUS => p_rec.STUDENT_STATUS
,p_WORK_SCHEDULE => p_rec.WORK_SCHEDULE
,p_PER_INFORMATION21 => p_rec.PER_INFORMATION21
,p_PER_INFORMATION22 => p_rec.PER_INFORMATION22
,p_PER_INFORMATION23 => p_rec.PER_INFORMATION23
,p_PER_INFORMATION24 => p_rec.PER_INFORMATION24
,p_PER_INFORMATION25 => p_rec.PER_INFORMATION25
,p_PER_INFORMATION26 => p_rec.PER_INFORMATION26
,p_PER_INFORMATION27 => p_rec.PER_INFORMATION27
,p_PER_INFORMATION28 => p_rec.PER_INFORMATION28
,p_PER_INFORMATION29 => p_rec.PER_INFORMATION29
,p_PER_INFORMATION30 => p_rec.PER_INFORMATION30
,p_REHIRE_REASON => p_rec.REHIRE_REASON
,p_BENEFIT_GROUP_ID => p_rec.BENEFIT_GROUP_ID
,p_RECEIPT_OF_DEATH_CERT_DATE => p_rec.RECEIPT_OF_DEATH_CERT_DATE
,p_COORD_BEN_MED_PLN_NO => p_rec.COORD_BEN_MED_PLN_NO
,p_COORD_BEN_NO_CVG_FLAG => p_rec.COORD_BEN_NO_CVG_FLAG
,p_coord_ben_med_ext_er => p_rec.coord_ben_med_ext_er
,p_coord_ben_med_pl_name => p_rec.coord_ben_med_pl_name
,p_coord_ben_med_insr_crr_name => p_rec.coord_ben_med_insr_crr_name
,p_coord_ben_med_insr_crr_ident => p_rec.coord_ben_med_insr_crr_ident
,p_coord_ben_med_cvg_strt_dt => p_rec.coord_ben_med_cvg_strt_dt
,p_coord_ben_med_cvg_end_dt => p_rec.coord_ben_med_cvg_end_dt
,p_USES_TOBACCO_FLAG => p_rec.USES_TOBACCO_FLAG
,p_DPDNT_ADOPTION_DATE => p_rec.DPDNT_ADOPTION_DATE
,p_DPDNT_VLNTRY_SVCE_FLAG => p_rec.DPDNT_VLNTRY_SVCE_FLAG
,p_ORIGINAL_DATE_OF_HIRE => p_rec.ORIGINAL_DATE_OF_HIRE
,p_town_of_birth => p_rec.town_of_birth
,p_region_of_birth => p_rec.region_of_birth
,p_country_of_birth => p_rec.country_of_birth
,p_global_person_id => p_rec.global_person_id
,p_party_id => p_rec.party_id
,p_npw_number => p_rec.npw_number
,p_current_npw_flag => p_rec.current_npw_flag
,p_global_name => p_rec.global_name
,p_local_name => p_rec.local_name
,p_object_version_number => p_rec.object_version_number
,p_effective_date => p_effective_date
,p_datetrack_mode => p_datetrack_mode
,p_validation_start_date => p_validation_start_date
,p_validation_end_date => p_validation_end_date
,p_name_combination_warning => p_name_combination_warning
,p_dob_null_warning => p_dob_null_warning
,p_orig_hire_warning => p_orig_hire_warning
,p_effective_start_date_o
=> per_per_shd.g_old_rec.effective_start_date
,p_effective_end_date_o
=> per_per_shd.g_old_rec.effective_end_date
,p_business_group_id_o
=> per_per_shd.g_old_rec.business_group_id
,p_person_type_id_o
=> per_per_shd.g_old_rec.person_type_id
,p_last_name_o
=> per_per_shd.g_old_rec.last_name
,p_start_date_o
=> per_per_shd.g_old_rec.start_date
,p_applicant_number_o
=> per_per_shd.g_old_rec.applicant_number
,p_comment_id_o
=> per_per_shd.g_old_rec.comment_id
,p_current_applicant_flag_o
=> per_per_shd.g_old_rec.current_applicant_flag
,p_current_emp_or_apl_flag_o
=> per_per_shd.g_old_rec.current_emp_or_apl_flag
,p_current_employee_flag_o
=> per_per_shd.g_old_rec.current_employee_flag
,p_date_employee_data_verifie_o
=> per_per_shd.g_old_rec.date_employee_data_verified
,p_date_of_birth_o
=> per_per_shd.g_old_rec.date_of_birth
,p_email_address_o
=> per_per_shd.g_old_rec.email_address
,p_employee_number_o
=> per_per_shd.g_old_rec.employee_number
,p_expense_check_send_to_addr_o
=> per_per_shd.g_old_rec.expense_check_send_to_address
,p_first_name_o
=> per_per_shd.g_old_rec.first_name
,p_full_name_o
=> per_per_shd.g_old_rec.full_name
,p_known_as_o
=> per_per_shd.g_old_rec.known_as
,p_marital_status_o
=> per_per_shd.g_old_rec.marital_status
,p_middle_names_o
=> per_per_shd.g_old_rec.middle_names
,p_nationality_o
=> per_per_shd.g_old_rec.nationality
,p_national_identifier_o
=> per_per_shd.g_old_rec.national_identifier
,p_previous_last_name_o
=> per_per_shd.g_old_rec.previous_last_name
,p_registered_disabled_flag_o
=> per_per_shd.g_old_rec.registered_disabled_flag
,p_sex_o
=> per_per_shd.g_old_rec.sex
,p_title_o
=> per_per_shd.g_old_rec.title
,p_vendor_id_o
=> per_per_shd.g_old_rec.vendor_id
,p_work_telephone_o
=> per_per_shd.g_old_rec.work_telephone
,p_request_id_o
=> per_per_shd.g_old_rec.request_id
,p_program_application_id_o
=> per_per_shd.g_old_rec.program_application_id
,p_program_id_o
=> per_per_shd.g_old_rec.program_id
,p_program_update_date_o
=> per_per_shd.g_old_rec.program_update_date
,p_attribute_category_o
=> per_per_shd.g_old_rec.attribute_category
,p_attribute1_o
=> per_per_shd.g_old_rec.attribute1
,p_attribute2_o
=> per_per_shd.g_old_rec.attribute2
,p_attribute3_o
=> per_per_shd.g_old_rec.attribute3
,p_attribute4_o
=> per_per_shd.g_old_rec.attribute4
,p_attribute5_o
=> per_per_shd.g_old_rec.attribute5
,p_attribute6_o
=> per_per_shd.g_old_rec.attribute6
,p_attribute7_o
=> per_per_shd.g_old_rec.attribute7
,p_attribute8_o
=> per_per_shd.g_old_rec.attribute8
,p_attribute9_o
=> per_per_shd.g_old_rec.attribute9
,p_attribute10_o
=> per_per_shd.g_old_rec.attribute10
,p_attribute11_o
=> per_per_shd.g_old_rec.attribute11
,p_attribute12_o
=> per_per_shd.g_old_rec.attribute12
,p_attribute13_o
=> per_per_shd.g_old_rec.attribute13
,p_attribute14_o
=> per_per_shd.g_old_rec.attribute14
,p_attribute15_o
=> per_per_shd.g_old_rec.attribute15
,p_attribute16_o
=> per_per_shd.g_old_rec.attribute16
,p_attribute17_o
=> per_per_shd.g_old_rec.attribute17
,p_attribute18_o
=> per_per_shd.g_old_rec.attribute18
,p_attribute19_o
=> per_per_shd.g_old_rec.attribute19
,p_attribute20_o
=> per_per_shd.g_old_rec.attribute20
,p_attribute21_o
=> per_per_shd.g_old_rec.attribute21
,p_attribute22_o
=> per_per_shd.g_old_rec.attribute22
,p_attribute23_o
=> per_per_shd.g_old_rec.attribute23
,p_attribute24_o
=> per_per_shd.g_old_rec.attribute24
,p_attribute25_o
=> per_per_shd.g_old_rec.attribute25
,p_attribute26_o
=> per_per_shd.g_old_rec.attribute26
,p_attribute27_o
=> per_per_shd.g_old_rec.attribute27
,p_attribute28_o
=> per_per_shd.g_old_rec.attribute28
,p_attribute29_o
=> per_per_shd.g_old_rec.attribute29
,p_attribute30_o
=> per_per_shd.g_old_rec.attribute30
,p_per_information_category_o
=> per_per_shd.g_old_rec.per_information_category
,p_per_information1_o
=> per_per_shd.g_old_rec.per_information1
,p_per_information2_o
=> per_per_shd.g_old_rec.per_information2
,p_per_information3_o
=> per_per_shd.g_old_rec.per_information3
,p_per_information4_o
=> per_per_shd.g_old_rec.per_information4
,p_per_information5_o
=> per_per_shd.g_old_rec.per_information5
,p_per_information6_o
=> per_per_shd.g_old_rec.per_information6
,p_per_information7_o
=> per_per_shd.g_old_rec.per_information7
,p_per_information8_o
=> per_per_shd.g_old_rec.per_information8
,p_per_information9_o
=> per_per_shd.g_old_rec.per_information9
,p_per_information10_o
=> per_per_shd.g_old_rec.per_information10
,p_per_information11_o
=> per_per_shd.g_old_rec.per_information11
,p_per_information12_o
=> per_per_shd.g_old_rec.per_information12
,p_per_information13_o
=> per_per_shd.g_old_rec.per_information13
,p_per_information14_o
=> per_per_shd.g_old_rec.per_information14
,p_per_information15_o
=> per_per_shd.g_old_rec.per_information15
,p_per_information16_o
=> per_per_shd.g_old_rec.per_information16
,p_per_information17_o
=> per_per_shd.g_old_rec.per_information17
,p_per_information18_o
=> per_per_shd.g_old_rec.per_information18
,p_per_information19_o
=> per_per_shd.g_old_rec.per_information19
,p_per_information20_o
=> per_per_shd.g_old_rec.per_information20
,p_suffix_o
=> per_per_shd.g_old_rec.suffix
,p_DATE_OF_DEATH_o
=> per_per_shd.g_old_rec.DATE_OF_DEATH
,p_BACKGROUND_CHECK_STATUS_o
=> per_per_shd.g_old_rec.BACKGROUND_CHECK_STATUS
,p_BACKGROUND_DATE_CHECK_o
=> per_per_shd.g_old_rec.BACKGROUND_DATE_CHECK
,p_BLOOD_TYPE_o
=> per_per_shd.g_old_rec.BLOOD_TYPE
,p_CORRESPONDENCE_LANGUAGE_o
=> per_per_shd.g_old_rec.CORRESPONDENCE_LANGUAGE
,p_FAST_PATH_EMPLOYEE_o
=> per_per_shd.g_old_rec.FAST_PATH_EMPLOYEE
,p_FTE_CAPACITY_o
=> per_per_shd.g_old_rec.FTE_CAPACITY
,p_HOLD_APPLICANT_DATE_UNTIL_o
=> per_per_shd.g_old_rec.HOLD_APPLICANT_DATE_UNTIL
,p_HONORS_o
=> per_per_shd.g_old_rec.HONORS
,p_INTERNAL_LOCATION_o
=> per_per_shd.g_old_rec.INTERNAL_LOCATION
,p_LAST_MEDICAL_TEST_BY_o
=> per_per_shd.g_old_rec.LAST_MEDICAL_TEST_BY
,p_LAST_MEDICAL_TEST_DATE_o
=> per_per_shd.g_old_rec.LAST_MEDICAL_TEST_DATE
,p_MAILSTOP_o
=> per_per_shd.g_old_rec.MAILSTOP
,p_OFFICE_NUMBER_o
=> per_per_shd.g_old_rec.OFFICE_NUMBER
,p_ON_MILITARY_SERVICE_o
=> per_per_shd.g_old_rec.ON_MILITARY_SERVICE
,p_ORDER_NAME_o
=> per_per_shd.g_old_rec.ORDER_NAME
,p_PRE_NAME_ADJUNCT_o
=> per_per_shd.g_old_rec.PRE_NAME_ADJUNCT
,p_PROJECTED_START_DATE_o
=> per_per_shd.g_old_rec.PROJECTED_START_DATE
,p_REHIRE_AUTHORIZOR_o
=> per_per_shd.g_old_rec.REHIRE_AUTHORIZOR
,p_REHIRE_RECOMMENDATION_o
=> per_per_shd.g_old_rec.REHIRE_RECOMMENDATION
,p_RESUME_EXISTS_o
=> per_per_shd.g_old_rec.RESUME_EXISTS
,p_RESUME_LAST_UPDATED_o
=> per_per_shd.g_old_rec.RESUME_LAST_UPDATED
,p_SECOND_PASSPORT_EXISTS_o
=> per_per_shd.g_old_rec.SECOND_PASSPORT_EXISTS
,p_STUDENT_STATUS_o
=> per_per_shd.g_old_rec.STUDENT_STATUS
,p_WORK_SCHEDULE_o
=> per_per_shd.g_old_rec.WORK_SCHEDULE
,p_PER_INFORMATION21_o
=> per_per_shd.g_old_rec.PER_INFORMATION21
,p_PER_INFORMATION22_o
=> per_per_shd.g_old_rec.PER_INFORMATION22
,p_PER_INFORMATION23_o
=> per_per_shd.g_old_rec.PER_INFORMATION23
,p_PER_INFORMATION24_o
=> per_per_shd.g_old_rec.PER_INFORMATION24
,p_PER_INFORMATION25_o
=> per_per_shd.g_old_rec.PER_INFORMATION25
,p_PER_INFORMATION26_o
=> per_per_shd.g_old_rec.PER_INFORMATION26
,p_PER_INFORMATION27_o
=> per_per_shd.g_old_rec.PER_INFORMATION27
,p_PER_INFORMATION28_o
=> per_per_shd.g_old_rec.PER_INFORMATION28
,p_PER_INFORMATION29_o
=> per_per_shd.g_old_rec.PER_INFORMATION29
,p_PER_INFORMATION30_o
=> per_per_shd.g_old_rec.PER_INFORMATION30
,p_REHIRE_REASON_o
=> per_per_shd.g_old_rec.REHIRE_REASON
,p_BENEFIT_GROUP_ID_o
=> per_per_shd.g_old_rec.BENEFIT_GROUP_ID
,p_RECEIPT_OF_DEATH_CERT_DATE_o
=> per_per_shd.g_old_rec.RECEIPT_OF_DEATH_CERT_DATE
,p_COORD_BEN_MED_PLN_NO_o
=> per_per_shd.g_old_rec.COORD_BEN_MED_PLN_NO
,p_COORD_BEN_NO_CVG_FLAG_o
=> per_per_shd.g_old_rec.COORD_BEN_NO_CVG_FLAG
,p_coord_ben_med_ext_er_o
=> per_per_shd.g_old_rec.coord_ben_med_ext_er
,p_coord_ben_med_pl_name_o
=> per_per_shd.g_old_rec.coord_ben_med_pl_name
,p_coord_ben_med_insr_crr_nam_o
=> per_per_shd.g_old_rec.coord_ben_med_insr_crr_name
,p_coord_ben_med_insr_crr_ide_o
=> per_per_shd.g_old_rec.coord_ben_med_insr_crr_ident
,p_coord_ben_med_cvg_strt_dt_o
=> per_per_shd.g_old_rec.coord_ben_med_cvg_strt_dt
,p_coord_ben_med_cvg_end_dt_o
=> per_per_shd.g_old_rec.coord_ben_med_cvg_end_dt
,p_USES_TOBACCO_FLAG_o
=> per_per_shd.g_old_rec.USES_TOBACCO_FLAG
,p_DPDNT_ADOPTION_DATE_o
=> per_per_shd.g_old_rec.DPDNT_ADOPTION_DATE
,p_DPDNT_VLNTRY_SVCE_FLAG_o
=> per_per_shd.g_old_rec.DPDNT_VLNTRY_SVCE_FLAG
,p_ORIGINAL_DATE_OF_HIRE_o
=> per_per_shd.g_old_rec.ORIGINAL_DATE_OF_HIRE
,p_town_of_birth_o
=> per_per_shd.g_old_rec.town_of_birth
,p_region_of_birth_o
=> per_per_shd.g_old_rec.region_of_birth
,p_country_of_birth_o
=> per_per_shd.g_old_rec.country_of_birth
,p_global_person_id_o
=> per_per_shd.g_old_rec.global_person_id
,p_party_id_o
=> per_per_shd.g_old_rec.party_id
,p_npw_number_o
=> per_per_shd.g_old_rec.npw_number
,p_current_npw_flag_o
=> per_per_shd.g_old_rec.current_npw_flag
,p_global_name_o
=> per_per_shd.g_old_rec.global_name
,p_local_name_o
=> per_per_shd.g_old_rec.local_name
,p_object_version_number_o
=> per_per_shd.g_old_rec.object_version_number
);
p_action => 'UPDATE');
End post_update;
If (p_rec.program_update_date = hr_api.g_date) then
p_rec.program_update_date :=
per_per_shd.g_old_rec.program_update_date;
If (p_rec.RESUME_LAST_UPDATED = hr_api.g_date) then
p_rec.RESUME_LAST_UPDATED := per_per_shd.g_old_rec.RESUME_LAST_UPDATED ;
per_per_bus.update_validate
-- (p_rec => p_rec,
(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => p_datetrack_mode,
p_validation_start_date => l_validation_start_date,
p_validation_end_date => l_validation_end_date,
p_name_combination_warning => l_name_combination_warning,
p_dob_null_warning => l_dob_null_warning,
p_orig_hire_warning => l_orig_hire_warning);
pre_update
(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => p_datetrack_mode,
p_validation_start_date => l_validation_start_date,
p_validation_end_date => l_validation_end_date);
update_dml
(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => p_datetrack_mode,
p_validation_start_date => l_validation_start_date,
p_validation_end_date => l_validation_end_date);
post_update
(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => p_datetrack_mode,
p_validation_start_date => l_validation_start_date,
p_validation_end_date => l_validation_end_date,
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_program_update_date in date default hr_api.g_date,
p_attribute_category in varchar2 default hr_api.g_varchar2,
p_attribute1 in varchar2 default hr_api.g_varchar2,
p_attribute2 in varchar2 default hr_api.g_varchar2,
p_attribute3 in varchar2 default hr_api.g_varchar2,
p_attribute4 in varchar2 default hr_api.g_varchar2,
p_attribute5 in varchar2 default hr_api.g_varchar2,
p_attribute6 in varchar2 default hr_api.g_varchar2,
p_attribute7 in varchar2 default hr_api.g_varchar2,
p_attribute8 in varchar2 default hr_api.g_varchar2,
p_attribute9 in varchar2 default hr_api.g_varchar2,
p_attribute10 in varchar2 default hr_api.g_varchar2,
p_attribute11 in varchar2 default hr_api.g_varchar2,
p_attribute12 in varchar2 default hr_api.g_varchar2,
p_attribute13 in varchar2 default hr_api.g_varchar2,
p_attribute14 in varchar2 default hr_api.g_varchar2,
p_attribute15 in varchar2 default hr_api.g_varchar2,
p_attribute16 in varchar2 default hr_api.g_varchar2,
p_attribute17 in varchar2 default hr_api.g_varchar2,
p_attribute18 in varchar2 default hr_api.g_varchar2,
p_attribute19 in varchar2 default hr_api.g_varchar2,
p_attribute20 in varchar2 default hr_api.g_varchar2,
p_attribute21 in varchar2 default hr_api.g_varchar2,
p_attribute22 in varchar2 default hr_api.g_varchar2,
p_attribute23 in varchar2 default hr_api.g_varchar2,
p_attribute24 in varchar2 default hr_api.g_varchar2,
p_attribute25 in varchar2 default hr_api.g_varchar2,
p_attribute26 in varchar2 default hr_api.g_varchar2,
p_attribute27 in varchar2 default hr_api.g_varchar2,
p_attribute28 in varchar2 default hr_api.g_varchar2,
p_attribute29 in varchar2 default hr_api.g_varchar2,
p_attribute30 in varchar2 default hr_api.g_varchar2,
p_per_information_category in varchar2 default hr_api.g_varchar2,
p_per_information1 in varchar2 default hr_api.g_varchar2,
p_per_information2 in varchar2 default hr_api.g_varchar2,
p_per_information3 in varchar2 default hr_api.g_varchar2,
p_per_information4 in varchar2 default hr_api.g_varchar2,
p_per_information5 in varchar2 default hr_api.g_varchar2,
p_per_information6 in varchar2 default hr_api.g_varchar2,
p_per_information7 in varchar2 default hr_api.g_varchar2,
p_per_information8 in varchar2 default hr_api.g_varchar2,
p_per_information9 in varchar2 default hr_api.g_varchar2,
p_per_information10 in varchar2 default hr_api.g_varchar2,
p_per_information11 in varchar2 default hr_api.g_varchar2,
p_per_information12 in varchar2 default hr_api.g_varchar2,
p_per_information13 in varchar2 default hr_api.g_varchar2,
p_per_information14 in varchar2 default hr_api.g_varchar2,
p_per_information15 in varchar2 default hr_api.g_varchar2,
p_per_information16 in varchar2 default hr_api.g_varchar2,
p_per_information17 in varchar2 default hr_api.g_varchar2,
p_per_information18 in varchar2 default hr_api.g_varchar2,
p_per_information19 in varchar2 default hr_api.g_varchar2,
p_per_information20 in varchar2 default hr_api.g_varchar2,
p_suffix in varchar2 default hr_api.g_varchar2,
p_DATE_OF_DEATH in date default hr_api.g_date,
p_BACKGROUND_CHECK_STATUS in varchar2 default hr_api.g_varchar2,
p_BACKGROUND_DATE_CHECK in date default hr_api.g_date,
p_BLOOD_TYPE in varchar2 default hr_api.g_varchar2,
p_CORRESPONDENCE_LANGUAGE in varchar2 default hr_api.g_varchar2,
p_FAST_PATH_EMPLOYEE in varchar2 default hr_api.g_varchar2,
p_FTE_CAPACITY in number default hr_api.g_number,
p_HOLD_APPLICANT_DATE_UNTIL in date default hr_api.g_date,
p_HONORS in varchar2 default hr_api.g_varchar2,
p_INTERNAL_LOCATION in varchar2 default hr_api.g_varchar2,
p_LAST_MEDICAL_TEST_BY in varchar2 default hr_api.g_varchar2,
p_LAST_MEDICAL_TEST_DATE in date default hr_api.g_date,
p_MAILSTOP in varchar2 default hr_api.g_varchar2,
p_OFFICE_NUMBER in varchar2 default hr_api.g_varchar2,
p_ON_MILITARY_SERVICE in varchar2 default hr_api.g_varchar2,
p_ORDER_NAME in varchar2 default hr_api.g_varchar2,
p_PRE_NAME_ADJUNCT in varchar2 default hr_api.g_varchar2,
p_PROJECTED_START_DATE in date default hr_api.g_date,
p_REHIRE_AUTHORIZOR in varchar2 default hr_api.g_varchar2,
p_REHIRE_RECOMMENDATION in varchar2 default hr_api.g_varchar2,
p_RESUME_EXISTS in varchar2 default hr_api.g_varchar2,
p_RESUME_LAST_UPDATED in date default hr_api.g_date,
p_SECOND_PASSPORT_EXISTS in varchar2 default hr_api.g_varchar2,
p_STUDENT_STATUS in varchar2 default hr_api.g_varchar2,
p_WORK_SCHEDULE in varchar2 default hr_api.g_varchar2,
p_PER_INFORMATION21 in varchar2 default hr_api.g_varchar2,
p_PER_INFORMATION22 in varchar2 default hr_api.g_varchar2,
p_PER_INFORMATION23 in varchar2 default hr_api.g_varchar2,
p_PER_INFORMATION24 in varchar2 default hr_api.g_varchar2,
p_PER_INFORMATION25 in varchar2 default hr_api.g_varchar2,
p_PER_INFORMATION26 in varchar2 default hr_api.g_varchar2,
p_PER_INFORMATION27 in varchar2 default hr_api.g_varchar2,
p_PER_INFORMATION28 in varchar2 default hr_api.g_varchar2,
p_PER_INFORMATION29 in varchar2 default hr_api.g_varchar2,
p_PER_INFORMATION30 in varchar2 default hr_api.g_varchar2,
p_REHIRE_REASON in varchar2 default hr_api.g_varchar2,
p_BENEFIT_GROUP_ID in number default hr_api.g_number,
p_RECEIPT_OF_DEATH_CERT_DATE in date default hr_api.g_date,
p_COORD_BEN_MED_PLN_NO in varchar2 default hr_api.g_varchar2,
p_COORD_BEN_NO_CVG_FLAG in varchar2 default hr_api.g_varchar2,
p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2,
p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2,
p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2,
p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2,
p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date,
p_coord_ben_med_cvg_end_dt in date default hr_api.g_date,
p_USES_TOBACCO_FLAG in varchar2 default hr_api.g_varchar2,
p_DPDNT_ADOPTION_DATE in date default hr_api.g_date,
p_DPDNT_VLNTRY_SVCE_FLAG in varchar2 default hr_api.g_varchar2,
p_ORIGINAL_DATE_OF_HIRE in date default hr_api.g_date,
p_town_of_birth in varchar2 default hr_api.g_varchar2,
p_region_of_birth in varchar2 default hr_api.g_varchar2,
p_country_of_birth in varchar2 default hr_api.g_varchar2,
p_global_person_id in varchar2 default hr_api.g_varchar2,
p_party_id in number default hr_api.g_number,
p_npw_number in out nocopy varchar2,
p_current_npw_flag in varchar2 default hr_api.g_varchar2,
p_object_version_number in out nocopy number,
p_effective_date in date,
p_datetrack_mode in varchar2,
p_validate in boolean default false,
p_name_combination_warning out nocopy boolean,
p_dob_null_warning out nocopy boolean,
p_orig_hire_warning out nocopy boolean
) is
--
l_rec per_per_shd.g_rec_type;
p_program_update_date,
p_attribute_category,
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,
p_per_information_category,
p_per_information1,
p_per_information2,
p_per_information3,
p_per_information4,
p_per_information5,
p_per_information6,
p_per_information7,
p_per_information8,
p_per_information9,
p_per_information10,
p_per_information11,
p_per_information12,
p_per_information13,
p_per_information14,
p_per_information15,
p_per_information16,
p_per_information17,
p_per_information18,
p_per_information19,
p_per_information20,
p_object_version_number,
p_suffix,
p_DATE_OF_DEATH ,
p_BACKGROUND_CHECK_STATUS ,
p_BACKGROUND_DATE_CHECK ,
p_BLOOD_TYPE ,
p_CORRESPONDENCE_LANGUAGE ,
p_FAST_PATH_EMPLOYEE ,
p_FTE_CAPACITY ,
p_HOLD_APPLICANT_DATE_UNTIL ,
p_HONORS ,
p_INTERNAL_LOCATION ,
p_LAST_MEDICAL_TEST_BY ,
p_LAST_MEDICAL_TEST_DATE ,
p_MAILSTOP ,
p_OFFICE_NUMBER ,
p_ON_MILITARY_SERVICE ,
p_ORDER_NAME ,
p_PRE_NAME_ADJUNCT ,
p_PROJECTED_START_DATE ,
p_REHIRE_AUTHORIZOR ,
p_REHIRE_RECOMMENDATION ,
p_RESUME_EXISTS ,
p_RESUME_LAST_UPDATED ,
p_SECOND_PASSPORT_EXISTS ,
p_STUDENT_STATUS ,
p_WORK_SCHEDULE ,
p_PER_INFORMATION21 ,
p_PER_INFORMATION22 ,
p_PER_INFORMATION23 ,
p_PER_INFORMATION24 ,
p_PER_INFORMATION25 ,
p_PER_INFORMATION26 ,
p_PER_INFORMATION27 ,
p_PER_INFORMATION28 ,
p_PER_INFORMATION29 ,
p_PER_INFORMATION30 ,
p_REHIRE_REASON ,
p_BENEFIT_GROUP_ID ,
p_RECEIPT_OF_DEATH_CERT_DATE ,
p_COORD_BEN_MED_PLN_NO ,
p_COORD_BEN_NO_CVG_FLAG ,
p_coord_ben_med_ext_er ,
p_coord_ben_med_pl_name ,
p_coord_ben_med_insr_crr_name ,
p_coord_ben_med_insr_crr_ident ,
p_coord_ben_med_cvg_strt_dt ,
p_coord_ben_med_cvg_end_dt ,
p_USES_TOBACCO_FLAG ,
p_DPDNT_ADOPTION_DATE ,
p_DPDNT_VLNTRY_SVCE_FLAG ,
p_ORIGINAL_DATE_OF_HIRE ,
p_town_of_birth ,
p_region_of_birth ,
p_country_of_birth ,
p_global_person_id ,
p_party_id ,
p_npw_number ,
p_current_npw_flag ,
null , -- global_name
null -- local_name
);