[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ppt.system_person_type
FROM per_person_types ppt
WHERE ppt.person_type_id = p_person_type_id;
SELECT per.effective_start_date
,per.effective_end_date
,per.object_version_number
,per.person_type_id
,per.employee_number
,per.npw_number
,per.last_name
,per.applicant_number
,per.date_employee_data_verified
,per.original_date_of_hire
,per.date_of_birth
,per.town_of_birth
,per.region_of_birth
,per.country_of_birth
,per.global_person_id
,per.email_address
,per.expense_check_send_to_address
,per.first_name
,per.known_as
,per.marital_status
,per.middle_names
,per.nationality
,per.national_identifier
,per.previous_last_name
,per.registered_disabled_flag
,per.sex
,per.title
,per.vendor_id
,per.work_telephone
,per.suffix
,per.attribute_category
,per.attribute1
,per.attribute2
,per.attribute3
,per.attribute4
,per.attribute5
,per.attribute6
,per.attribute7
,per.attribute8
,per.attribute9
,per.attribute10
,per.attribute11
,per.attribute12
,per.attribute13
,per.attribute14
,per.attribute15
,per.attribute16
,per.attribute17
,per.attribute18
,per.attribute19
,per.attribute20
,per.attribute21
,per.attribute22
,per.attribute23
,per.attribute24
,per.attribute25
,per.attribute26
,per.attribute27
,per.attribute28
,per.attribute29
,per.attribute30
,per.per_information_category
,per.per_information1
,per.per_information2
,per.per_information3
,per.per_information4
,per.per_information5
,per.per_information6
,per.per_information7
,per.per_information8
,per.per_information9
,per.per_information10
,per.per_information11
,per.per_information12
,per.per_information13
,per.per_information14
,per.per_information15
,per.per_information16
,per.per_information17
,per.per_information18
,per.per_information19
,per.per_information20
,per.per_information21
,per.per_information22
,per.per_information23
,per.per_information24
,per.per_information25
,per.per_information26
,per.per_information27
,per.per_information28
,per.per_information29
,per.per_information30
,per.date_of_death
,per.background_check_status
,per.background_date_check
,per.blood_type
,per.correspondence_language
,per.fast_path_employee
,per.fte_capacity
,per.hold_applicant_date_until
,per.honors
,per.internal_location
,per.last_medical_test_by
,per.last_medical_test_date
,per.mailstop
,per.office_number
,per.on_military_service
,per.pre_name_adjunct
,per.projected_start_date
,per.rehire_authorizor
,per.rehire_recommendation
,per.resume_exists
,per.resume_last_updated
,per.second_passport_exists
,per.student_status
,per.work_schedule
,per.rehire_reason
,per.benefit_group_id
,per.receipt_of_death_cert_date
,per.coord_ben_med_pln_no
,per.coord_ben_no_cvg_flag
,per.uses_tobacco_flag
,per.dpdnt_adoption_date
,per.dpdnt_vlntry_svce_flag
,per.comment_id
,hc.comment_text
,pos.adjusted_svc_date
FROM per_all_people_f per
,hr_comments hc
,per_periods_of_service pos
WHERE per.person_id = p_person_id
AND p_eff_date BETWEEN per.effective_start_date and per.effective_end_date
AND hc.comment_id (+) = per.comment_id
-- bug 2747159 : Making an outer join to the per_periods_of_service table.
AND per.person_id = pos.person_id(+)
and per.effective_start_date between pos.date_start(+)
and nvl(pos.actual_termination_date(+),per.effective_start_date);
SELECT per.current_applicant_flag,
per.current_employee_flag,
per.current_npw_flag
FROM per_all_people_f per
WHERE per.person_id = p_person_id
AND p_eff_date BETWEEN per.effective_start_date and per.effective_end_date;
SELECT ptu.person_type_id
FROM per_person_type_usages_f ptu,
per_person_types ppt
WHERE ptu.person_id = p_person_id
AND p_effective_date between ptu.effective_start_date
and ptu.effective_end_date
AND ptu.person_type_id = ppt.person_type_id
AND ppt.system_person_type = 'APL'
AND ppt.active_flag = 'Y';
SELECT meaning
FROM hr_lookups
WHERE lookup_type = upper(p_lookup_type)
AND lookup_code = upper(p_lookup_code);
select max(EFFECTIVE_START_DATE) into l_effective_date
from per_all_people_f where person_id = p_person_id;
,p_attribute_update_mode out nocopy varchar2
,p_person_id out nocopy number
,p_object_version_number out nocopy number
,p_person_type_id out nocopy number
,p_last_name out nocopy varchar2
,p_applicant_number out nocopy varchar2
,p_comments out nocopy varchar2
,p_date_employee_data_verified out nocopy date
,p_original_date_of_hire out nocopy date
,p_date_of_birth out nocopy date
,p_town_of_birth out nocopy varchar2
,p_region_of_birth out nocopy varchar2
,p_country_of_birth out nocopy varchar2
,p_global_person_id out nocopy varchar2
,p_email_address out nocopy varchar2
,p_employee_number out nocopy varchar2
,p_npw_number out nocopy varchar2
,p_expense_check_send_to_addres out nocopy varchar2
,p_first_name out nocopy varchar2
,p_known_as out nocopy varchar2
,p_marital_status out nocopy varchar2
,p_middle_names out nocopy varchar2
,p_nationality out nocopy varchar2
,p_national_identifier out nocopy varchar2
,p_previous_last_name out nocopy varchar2
,p_registered_disabled_flag out nocopy varchar2
,p_sex out nocopy varchar2
,p_title out nocopy varchar2
,p_vendor_id out nocopy number
,p_work_telephone out nocopy varchar2
,p_suffix out nocopy varchar2
,p_date_of_death out nocopy date
,p_background_check_status out nocopy varchar2
,p_background_date_check out nocopy date
,p_blood_type out nocopy varchar2
,p_correspondence_language out nocopy varchar2
,p_fast_path_employee out nocopy varchar2
,p_fte_capacity out nocopy number
,p_hold_applicant_date_until out nocopy date
,p_honors out nocopy varchar2
,p_internal_location out nocopy varchar2
,p_last_medical_test_by out nocopy varchar2
,p_last_medical_test_date out nocopy date
,p_mailstop out nocopy varchar2
,p_office_number out nocopy varchar2
,p_on_military_service out nocopy varchar2
,p_pre_name_adjunct out nocopy varchar2
,p_projected_start_date out nocopy date
,p_rehire_authorizor out nocopy varchar2
,p_rehire_recommendation out nocopy varchar2
,p_resume_exists out nocopy varchar2
,p_resume_last_updated out nocopy date
,p_second_passport_exists out nocopy varchar2
,p_student_status out nocopy varchar2
,p_work_schedule out nocopy varchar2
,p_rehire_reason out nocopy varchar2
,p_benefit_group_id out nocopy number
,p_receipt_of_death_cert_date out nocopy date
,p_coord_ben_med_pln_no out nocopy varchar2
,p_coord_ben_no_cvg_flag out nocopy varchar2
,p_uses_tobacco_flag out nocopy varchar2
,p_dpdnt_adoption_date out nocopy varchar2
,p_dpdnt_vlntry_svce_flag out nocopy varchar2
--StartRegistration.
,p_adjusted_svc_date out nocopy date
,p_date_start out nocopy date
--EndRegistration.
,p_attribute_category out nocopy varchar2
,p_attribute1 out nocopy varchar2
,p_attribute2 out nocopy varchar2
,p_attribute3 out nocopy varchar2
,p_attribute4 out nocopy varchar2
,p_attribute5 out nocopy varchar2
,p_attribute6 out nocopy varchar2
,p_attribute7 out nocopy varchar2
,p_attribute8 out nocopy varchar2
,p_attribute9 out nocopy varchar2
,p_attribute10 out nocopy varchar2
,p_attribute11 out nocopy varchar2
,p_attribute12 out nocopy varchar2
,p_attribute13 out nocopy varchar2
,p_attribute14 out nocopy varchar2
,p_attribute15 out nocopy varchar2
,p_attribute16 out nocopy varchar2
,p_attribute17 out nocopy varchar2
,p_attribute18 out nocopy varchar2
,p_attribute19 out nocopy varchar2
,p_attribute20 out nocopy varchar2
,p_attribute21 out nocopy varchar2
,p_attribute22 out nocopy varchar2
,p_attribute23 out nocopy varchar2
,p_attribute24 out nocopy varchar2
,p_attribute25 out nocopy varchar2
,p_attribute26 out nocopy varchar2
,p_attribute27 out nocopy varchar2
,p_attribute28 out nocopy varchar2
,p_attribute29 out nocopy varchar2
,p_attribute30 out nocopy varchar2
,p_per_information_category out nocopy varchar2
,p_per_information1 out nocopy varchar2
,p_per_information2 out nocopy varchar2
,p_per_information3 out nocopy varchar2
,p_per_information4 out nocopy varchar2
,p_per_information5 out nocopy varchar2
,p_per_information6 out nocopy varchar2
,p_per_information7 out nocopy varchar2
,p_per_information8 out nocopy varchar2
,p_per_information9 out nocopy varchar2
,p_per_information10 out nocopy varchar2
,p_per_information11 out nocopy varchar2
,p_per_information12 out nocopy varchar2
,p_per_information13 out nocopy varchar2
,p_per_information14 out nocopy varchar2
,p_per_information15 out nocopy varchar2
,p_per_information16 out nocopy varchar2
,p_per_information17 out nocopy varchar2
,p_per_information18 out nocopy varchar2
,p_per_information19 out nocopy varchar2
,p_per_information20 out nocopy varchar2
,p_per_information21 out nocopy varchar2
,p_per_information22 out nocopy varchar2
,p_per_information23 out nocopy varchar2
,p_per_information24 out nocopy varchar2
,p_per_information25 out nocopy varchar2
,p_per_information26 out nocopy varchar2
,p_per_information27 out nocopy varchar2
,p_per_information28 out nocopy varchar2
,p_per_information29 out nocopy varchar2
,p_per_information30 out nocopy varchar2
,p_title_meaning out nocopy varchar2
,p_marital_status_meaning out nocopy varchar2
,p_full_name out nocopy varchar2
,p_business_group_id out nocopy number
,p_review_proc_call out nocopy varchar2
,p_action_type out nocopy varchar2
)is
l_trans_step_ids hr_util_web.g_varchar2_tab_type;
,p_attribute_update_mode => p_attribute_update_mode
,p_person_id => p_person_id
,p_object_version_number => p_object_version_number
,p_person_type_id => p_person_type_id
,p_last_name => p_last_name
,p_applicant_number => p_applicant_number
,p_comments => p_comments
,p_date_employee_data_verified => p_date_employee_data_verified
,p_original_date_of_hire => p_original_date_of_hire
,p_date_of_birth => p_date_of_birth
,p_town_of_birth => p_town_of_birth
,p_region_of_birth => p_region_of_birth
,p_country_of_birth => p_country_of_birth
,p_global_person_id => p_global_person_id
,p_email_address => p_email_address
,p_employee_number => p_employee_number
,p_npw_number => p_npw_number
,p_expense_check_send_to_addres => p_expense_check_send_to_addres
,p_first_name => p_first_name
,p_known_as => p_known_as
,p_marital_status => p_marital_status
,p_middle_names => p_middle_names
,p_nationality => p_nationality
,p_national_identifier => p_national_identifier
,p_previous_last_name => p_previous_last_name
,p_registered_disabled_flag => p_registered_disabled_flag
,p_sex => p_sex
,p_title => p_title
,p_vendor_id => p_vendor_id
,p_work_telephone => p_work_telephone
,p_suffix => p_suffix
,p_attribute_category => p_attribute_category
,p_date_of_death => p_date_of_death
,p_background_check_status => p_background_check_status
,p_background_date_check => p_background_date_check
,p_blood_type => p_blood_type
,p_correspondence_language => p_correspondence_language
,p_fast_path_employee => p_fast_path_employee
,p_fte_capacity => p_fte_capacity
,p_hold_applicant_date_until => p_hold_applicant_date_until
,p_honors => p_honors
,p_internal_location => p_internal_location
,p_last_medical_test_by => p_last_medical_test_by
,p_last_medical_test_date => p_last_medical_test_date
,p_mailstop => p_mailstop
,p_office_number => p_office_number
,p_on_military_service => p_on_military_service
,p_pre_name_adjunct => p_pre_name_adjunct
,p_projected_start_date => p_projected_start_date
,p_rehire_authorizor => p_rehire_authorizor
,p_rehire_recommendation => p_rehire_recommendation
,p_resume_exists => p_resume_exists
,p_resume_last_updated => p_resume_last_updated
,p_second_passport_exists => p_second_passport_exists
,p_student_status => p_student_status
,p_work_schedule => p_work_schedule
,p_rehire_reason => p_rehire_reason
,p_benefit_group_id => p_benefit_group_id
,p_receipt_of_death_cert_date => p_receipt_of_death_cert_date
,p_coord_ben_med_pln_no => p_coord_ben_med_pln_no
,p_coord_ben_no_cvg_flag => p_coord_ben_no_cvg_flag
,p_uses_tobacco_flag => p_uses_tobacco_flag
,p_dpdnt_adoption_date => p_dpdnt_adoption_date
,p_dpdnt_vlntry_svce_flag => p_dpdnt_vlntry_svce_flag
-- StartRegistration.
,p_adjusted_svc_date => p_adjusted_svc_date
,p_date_start => p_date_start
-- EndRegistration.
,p_attribute1 => p_attribute1
,p_attribute2 => p_attribute2
,p_attribute3 => p_attribute3
,p_attribute4 => p_attribute4
,p_attribute5 => p_attribute5
,p_attribute6 => p_attribute6
,p_attribute7 => p_attribute7
,p_attribute8 => p_attribute8
,p_attribute9 => p_attribute9
,p_attribute10 => p_attribute10
,p_attribute11 => p_attribute11
,p_attribute12 => p_attribute12
,p_attribute13 => p_attribute13
,p_attribute14 => p_attribute14
,p_attribute15 => p_attribute15
,p_attribute16 => p_attribute16
,p_attribute17 => p_attribute17
,p_attribute18 => p_attribute18
,p_attribute19 => p_attribute19
,p_attribute20 => p_attribute20
,p_attribute21 => p_attribute21
,p_attribute22 => p_attribute22
,p_attribute23 => p_attribute23
,p_attribute24 => p_attribute24
,p_attribute25 => p_attribute25
,p_attribute26 => p_attribute26
,p_attribute27 => p_attribute27
,p_attribute28 => p_attribute28
,p_attribute29 => p_attribute29
,p_attribute30 => p_attribute30
,p_per_information_category => p_per_information_category
,p_per_information1 => p_per_information1
,p_per_information2 => p_per_information2
,p_per_information3 => p_per_information3
,p_per_information4 => p_per_information4
,p_per_information5 => p_per_information5
,p_per_information6 => p_per_information6
,p_per_information7 => p_per_information7
,p_per_information8 => p_per_information8
,p_per_information9 => p_per_information9
,p_per_information10 => p_per_information10
,p_per_information11 => p_per_information11
,p_per_information12 => p_per_information12
,p_per_information13 => p_per_information13
,p_per_information14 => p_per_information14
,p_per_information15 => p_per_information15
,p_per_information16 => p_per_information16
,p_per_information17 => p_per_information17
,p_per_information18 => p_per_information18
,p_per_information19 => p_per_information19
,p_per_information20 => p_per_information20
,p_per_information21 => p_per_information21
,p_per_information22 => p_per_information22
,p_per_information23 => p_per_information23
,p_per_information24 => p_per_information24
,p_per_information25 => p_per_information25
,p_per_information26 => p_per_information26
,p_per_information27 => p_per_information27
,p_per_information28 => p_per_information28
,p_per_information29 => p_per_information29
,p_per_information30 => p_per_information30
,p_title_meaning => p_title_meaning
,p_marital_status_meaning => p_marital_status_meaning
,p_full_name => p_full_name
,p_business_group_id => p_business_group_id
,p_review_proc_call => p_review_proc_call
,p_action_type => p_action_type
);
,p_attribute_update_mode out nocopy varchar2
,p_person_id out nocopy number
,p_object_version_number out nocopy number
,p_person_type_id out nocopy number
,p_last_name out nocopy varchar2
,p_applicant_number out nocopy varchar2
,p_comments out nocopy varchar2
,p_date_employee_data_verified out nocopy date
,p_original_date_of_hire out nocopy date
,p_date_of_birth out nocopy date
,p_town_of_birth out nocopy varchar2
,p_region_of_birth out nocopy varchar2
,p_country_of_birth out nocopy varchar2
,p_global_person_id out nocopy varchar2
,p_email_address out nocopy varchar2
,p_employee_number out nocopy varchar2
,p_npw_number out nocopy varchar2
,p_expense_check_send_to_addres out nocopy varchar2
,p_first_name out nocopy varchar2
,p_known_as out nocopy varchar2
,p_marital_status out nocopy varchar2
,p_middle_names out nocopy varchar2
,p_nationality out nocopy varchar2
,p_national_identifier out nocopy varchar2
,p_previous_last_name out nocopy varchar2
,p_registered_disabled_flag out nocopy varchar2
,p_sex out nocopy varchar2
,p_title out nocopy varchar2
,p_vendor_id out nocopy number
,p_work_telephone out nocopy varchar2
,p_suffix out nocopy varchar2
,p_date_of_death out nocopy date
,p_background_check_status out nocopy varchar2
,p_background_date_check out nocopy date
,p_blood_type out nocopy varchar2
,p_correspondence_language out nocopy varchar2
,p_fast_path_employee out nocopy varchar2
,p_fte_capacity out nocopy number
,p_hold_applicant_date_until out nocopy date
,p_honors out nocopy varchar2
,p_internal_location out nocopy varchar2
,p_last_medical_test_by out nocopy varchar2
,p_last_medical_test_date out nocopy date
,p_mailstop out nocopy varchar2
,p_office_number out nocopy varchar2
,p_on_military_service out nocopy varchar2
,p_pre_name_adjunct out nocopy varchar2
,p_projected_start_date out nocopy date
,p_rehire_authorizor out nocopy varchar2
,p_rehire_recommendation out nocopy varchar2
,p_resume_exists out nocopy varchar2
,p_resume_last_updated out nocopy date
,p_second_passport_exists out nocopy varchar2
,p_student_status out nocopy varchar2
,p_work_schedule out nocopy varchar2
,p_rehire_reason out nocopy varchar2
,p_benefit_group_id out nocopy number
,p_receipt_of_death_cert_date out nocopy date
,p_coord_ben_med_pln_no out nocopy varchar2
,p_coord_ben_no_cvg_flag out nocopy varchar2
,p_uses_tobacco_flag out nocopy varchar2
,p_dpdnt_adoption_date out nocopy date
,p_dpdnt_vlntry_svce_flag out nocopy varchar2
-- StartRegistration.
,p_adjusted_svc_date out nocopy date
,p_date_start out nocopy date
-- EndRegistration.
,p_attribute_category out nocopy varchar2
,p_attribute1 out nocopy varchar2
,p_attribute2 out nocopy varchar2
,p_attribute3 out nocopy varchar2
,p_attribute4 out nocopy varchar2
,p_attribute5 out nocopy varchar2
,p_attribute6 out nocopy varchar2
,p_attribute7 out nocopy varchar2
,p_attribute8 out nocopy varchar2
,p_attribute9 out nocopy varchar2
,p_attribute10 out nocopy varchar2
,p_attribute11 out nocopy varchar2
,p_attribute12 out nocopy varchar2
,p_attribute13 out nocopy varchar2
,p_attribute14 out nocopy varchar2
,p_attribute15 out nocopy varchar2
,p_attribute16 out nocopy varchar2
,p_attribute17 out nocopy varchar2
,p_attribute18 out nocopy varchar2
,p_attribute19 out nocopy varchar2
,p_attribute20 out nocopy varchar2
,p_attribute21 out nocopy varchar2
,p_attribute22 out nocopy varchar2
,p_attribute23 out nocopy varchar2
,p_attribute24 out nocopy varchar2
,p_attribute25 out nocopy varchar2
,p_attribute26 out nocopy varchar2
,p_attribute27 out nocopy varchar2
,p_attribute28 out nocopy varchar2
,p_attribute29 out nocopy varchar2
,p_attribute30 out nocopy varchar2
,p_per_information_category out nocopy varchar2
,p_per_information1 out nocopy varchar2
,p_per_information2 out nocopy varchar2
,p_per_information3 out nocopy varchar2
,p_per_information4 out nocopy varchar2
,p_per_information5 out nocopy varchar2
,p_per_information6 out nocopy varchar2
,p_per_information7 out nocopy varchar2
,p_per_information8 out nocopy varchar2
,p_per_information9 out nocopy varchar2
,p_per_information10 out nocopy varchar2
,p_per_information11 out nocopy varchar2
,p_per_information12 out nocopy varchar2
,p_per_information13 out nocopy varchar2
,p_per_information14 out nocopy varchar2
,p_per_information15 out nocopy varchar2
,p_per_information16 out nocopy varchar2
,p_per_information17 out nocopy varchar2
,p_per_information18 out nocopy varchar2
,p_per_information19 out nocopy varchar2
,p_per_information20 out nocopy varchar2
,p_per_information21 out nocopy varchar2
,p_per_information22 out nocopy varchar2
,p_per_information23 out nocopy varchar2
,p_per_information24 out nocopy varchar2
,p_per_information25 out nocopy varchar2
,p_per_information26 out nocopy varchar2
,p_per_information27 out nocopy varchar2
,p_per_information28 out nocopy varchar2
,p_per_information29 out nocopy varchar2
,p_per_information30 out nocopy varchar2
,p_title_meaning out nocopy varchar2
,p_marital_status_meaning out nocopy varchar2
,p_full_name out nocopy varchar2
,p_business_group_id out nocopy number
,p_review_proc_call out nocopy varchar2
,p_action_type out nocopy varchar2
)is
l_title per_all_people_f.title%type default null;
p_attribute_update_mode :=
hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE_UPDATE_MODE');
p_resume_last_updated :=
hr_transaction_api.get_date_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_RESUME_LAST_UPDATED');
SELECT doc.document_id
, doc.binary_doc
, doc.mime_type
, doc.file_name
, doc.description
, hrl.meaning
FROM irc_documents doc
, hr_lookups hrl
WHERE hrl.lookup_type = 'IRC_DOCUMENT_TYPE'
AND doc.type = hrl.lookup_code
AND doc.end_date IS NULL
AND person_id = irc_utilities_pkg.get_recruitment_person_id (x_person_id, sysdate);
SELECT CATEGORY_ID
FROM FND_DOCUMENT_CATEGORIES
WHERE NAME = 'MISC';
SELECT hats.selected_person_id
, fffv.function_name
INTO l_person_id
, l_function_name
FROM hr_api_transactions hats
, fnd_form_functions_vl fffv
WHERE hats.transaction_id = p_transaction_id
AND fffv.function_id = hats.function_id;
hr_utility.set_location ('Attachment from Irecruitment Successfully inserted', 607);
hr_utility.set_location ('Attachment insert failed'
|| l_proc, 608);
procedure update_person
(p_item_type in varchar2
,p_item_key in varchar2
,p_actid in number
,p_login_person_id in number
,p_process_section_name in varchar2
,p_action_type in varchar2
,p_validate_mode in varchar2 default 'Y'
,p_review_page_region_code in varchar2 default hr_api.g_varchar2
,p_effective_date in date
,p_business_group_id in number
,p_person_id in number
,p_object_version_number in out nocopy number
,p_person_type_id in number default hr_api.g_number
,p_last_name in varchar2 default hr_api.g_varchar2
,p_applicant_number in varchar2 default hr_api.g_varchar2
,p_comments in varchar2 default hr_api.g_varchar2
,p_date_employee_data_verified in date default hr_api.g_date
,p_original_date_of_hire in date default hr_api.g_date
,p_date_of_birth 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_email_address in varchar2 default hr_api.g_varchar2
,p_employee_number in out nocopy varchar2
,p_npw_number in varchar2 default hr_api.g_varchar2
,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
,p_first_name in varchar2 default hr_api.g_varchar2
,p_known_as in varchar2 default hr_api.g_varchar2
,p_marital_status in varchar2 default hr_api.g_varchar2
,p_middle_names in varchar2 default hr_api.g_varchar2
,p_nationality in varchar2 default hr_api.g_varchar2
,p_national_identifier in varchar2 default hr_api.g_varchar2
,p_previous_last_name in varchar2 default hr_api.g_varchar2
,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
,p_sex in varchar2 default hr_api.g_varchar2
,p_title in varchar2 default hr_api.g_varchar2
,p_vendor_id in number default hr_api.g_number
,p_work_telephone 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_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_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_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_adjusted_svc_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_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_effective_start_date out nocopy date
,p_effective_end_date out nocopy date
,p_full_name in out nocopy varchar2
,p_comment_id out nocopy number
,p_name_combination_warning out nocopy varchar2
,p_assign_payroll_warning in out nocopy varchar2
,p_orig_hire_warning out nocopy varchar2
,p_save_mode in varchar2 default null
,p_asgn_change_mode in varchar2 default null
,p_appl_assign_id in number default null
,p_error_message out nocopy long
,p_ni_duplicate_warn_or_err in out nocopy varchar2
,p_validate_ni in out nocopy varchar2
) IS
CURSOR get_wf_actid (c_activity_name in varchar2) IS
--BUG 3636429
SELECT distinct process_activity activity_id
FROM
(
SELECT
ws.process_activity
FROM wf_item_activity_statuses ws
,wf_process_activities wp
WHERE ws.item_type = p_item_type
AND ws.item_key = p_item_key
AND ws.process_activity = wp.instance_id
AND wp.activity_name = c_activity_name
UNION ALL
SELECT
ws.process_activity
FROM wf_item_activity_statuses_h ws
,wf_process_activities wp
WHERE ws.item_type = p_item_type
AND ws.item_key = p_item_key
AND ws.process_activity = wp.instance_id
AND wp.activity_name = c_activity_name
);
select asg.assignment_id,
asg.payroll_id, asg.soft_coding_keyflex_id
from per_all_assignments_f asg,
per_assignment_status_types pas
where asg.assignment_status_type_id = pas.assignment_status_type_id
and asg.person_id = p_person_id
and p_effective_date between asg.effective_start_date
and asg.effective_end_date
and pas.per_system_status = 'ACCEPTED'
and asg.assignment_type = 'A'
and asg.payroll_id is not null
order by asg.assignment_id;
SELECT transaction_step_id FROM hr_api_transaction_steps
WHERE item_type = p_item_type
AND item_key = p_item_key
AND api_name = 'HR_PROCESS_PERSON_SS.PROCESS_DUMMY_API';
select pj.name, hou.name from
per_all_assignments_f asf, per_jobs_tl pj, hr_all_organization_units_tl hou
where asf.person_id = p_person_id and asf.primary_flag = 'Y'
AND asf.organization_id = hou.organization_id(+)
AND hou.language = userenv('LANG')
AND asf.job_id = pj.job_id(+)
AND pj.language(+)=userenv('LANG')
and p_effective_date between effective_start_date and effective_end_date;
select DESCRIPTIVE_FLEXFIELD_NAME from FND_DESCR_FLEX_CONTEXTS
where DESCRIPTIVE_FLEXFIELD_NAME = 'Extra Person Info DDF'
and DESCRIPTIVE_FLEX_CONTEXT_CODE = 'US_ETHNIC_ORIGIN';
select legislation_code
from per_business_groups_perf
where business_group_id = p_business_group_id;
select style
from per_addresses a
where a.person_id = p_person_id and a.primary_flag = 'Y'
and p_effective_date between a.date_from and nvl(a.date_to,hr_api.g_eot);
select region_1
from per_addresses a
where a.person_id = p_person_id and a.primary_flag = 'Y'
and p_effective_date between a.date_from and nvl(a.date_to,hr_api.g_eot);
l_attribute_update_mode varchar2(100) default null;
l_basic_details_update_mode varchar2(100) default null;
l_proc varchar2(72) := g_package||'update_person';
l_attribute_update_mode := g_attribute_update;
l_attribute_update_mode := g_attribute_correct;
hr_utility.set_location('l_attribute_update_mode=' || l_attribute_update_mode, 20);
update per_addresses set style = 'US' ,region_1 ='Snohomish'
where person_id = p_person_id and primary_flag = 'Y'
and p_effective_date between date_from and nvl(date_to,hr_api.g_eot);
update per_addresses set style = l_style_old, region_1=l_region1_old
where person_id = p_person_id and primary_flag = 'Y'
and p_effective_date between date_from and nvl(date_to,hr_api.g_eot);
,p_resume_last_updated => p_resume_last_updated
,p_second_passport_exists => p_second_passport_exists
,p_student_status => p_student_status
,p_work_schedule => p_work_schedule
,p_rehire_reason => p_rehire_reason
,p_benefit_group_id => l_benefit_group_id
,p_receipt_of_death_cert_date => p_receipt_of_death_cert_date
,p_coord_ben_med_pln_no => p_coord_ben_med_pln_no
,p_coord_ben_no_cvg_flag => p_coord_ben_no_cvg_flag
,p_uses_tobacco_flag => p_uses_tobacco_flag
,p_dpdnt_adoption_date => p_dpdnt_adoption_date
,p_dpdnt_vlntry_svce_flag => p_dpdnt_vlntry_svce_flag
,p_adjusted_svc_date => p_adjusted_svc_date
,p_attribute_category => p_attribute_category
,p_attribute1 => p_attribute1
,p_attribute2 => p_attribute2
,p_attribute3 => p_attribute3
,p_attribute4 => p_attribute4
,p_attribute5 => p_attribute5
,p_attribute6 => p_attribute6
,p_attribute7 => p_attribute7
,p_attribute8 => p_attribute8
,p_attribute9 => p_attribute9
,p_attribute10 => p_attribute10
,p_attribute11 => p_attribute11
,p_attribute12 => p_attribute12
,p_attribute13 => p_attribute13
,p_attribute14 => p_attribute14
,p_attribute15 => p_attribute15
,p_attribute16 => p_attribute16
,p_attribute17 => p_attribute17
,p_attribute18 => p_attribute18
,p_attribute19 => p_attribute19
,p_attribute20 => p_attribute20
,p_attribute21 => p_attribute21
,p_attribute22 => p_attribute22
,p_attribute23 => p_attribute23
,p_attribute24 => p_attribute24
,p_attribute25 => p_attribute25
,p_attribute26 => p_attribute26
,p_attribute27 => p_attribute27
,p_attribute28 => p_attribute28
,p_attribute29 => p_attribute29
,p_attribute30 => p_attribute30
,p_per_information_category => p_per_information_category
,p_per_information1 => p_per_information1
,p_per_information2 => p_per_information2
,p_per_information3 => p_per_information3
,p_per_information4 => p_per_information4
,p_per_information5 => p_per_information5
,p_per_information6 => p_per_information6
,p_per_information7 => p_per_information7
,p_per_information8 => p_per_information8
,p_per_information9 => p_per_information9
,p_per_information10 => p_per_information10
,p_per_information11 => p_per_information11
,p_per_information12 => p_per_information12
,p_per_information13 => p_per_information13
,p_per_information14 => p_per_information14
,p_per_information15 => p_per_information15
,p_per_information16 => p_per_information16
,p_per_information17 => p_per_information17
,p_per_information18 => p_per_information18
,p_per_information19 => p_per_information19
,p_per_information20 => p_per_information20
,p_per_information21 => p_per_information21
,p_per_information22 => p_per_information22
,p_per_information23 => p_per_information23
,p_per_information24 => p_per_information24
,p_per_information25 => p_per_information25
,p_per_information26 => p_per_information26
,p_per_information27 => p_per_information27
,p_per_information28 => p_per_information28
,p_per_information29 => p_per_information29
,p_per_information30 => p_per_information30
);
,p_attribute_update_mode => l_attribute_update_mode
,p_effective_date => p_effective_date
,p_person_id => p_person_id
,p_object_version_number => l_ovn
,p_person_type_id => l_person_type_id
,p_last_name => p_last_name
,p_applicant_number => p_applicant_number
,p_comments => l_comments
,p_date_employee_data_verified => p_date_employee_data_verified
,p_original_date_of_hire => p_original_date_of_hire
,p_date_of_birth => p_date_of_birth
,p_town_of_birth => p_town_of_birth
,p_region_of_birth => p_region_of_birth
,p_country_of_birth => p_country_of_birth
,p_global_person_id => p_global_person_id
,p_email_address => p_email_address
,p_employee_number => l_employee_number
,p_npw_number => p_npw_number
,p_expense_check_send_to_addres => p_expense_check_send_to_addres
,p_first_name => p_first_name
,p_known_as => p_known_as
,p_marital_status => p_marital_status
,p_middle_names => p_middle_names
,p_nationality => p_nationality
,p_national_identifier => p_national_identifier
,p_previous_last_name => p_previous_last_name
,p_registered_disabled_flag => p_registered_disabled_flag
,p_sex => p_sex
,p_title => p_title
,p_vendor_id => l_vendor_id
,p_work_telephone => p_work_telephone
,p_suffix => p_suffix
,p_date_of_death => p_date_of_death
,p_background_check_status => p_background_check_status
,p_background_date_check => p_background_date_check
,p_blood_type => p_blood_type
,p_correspondence_language => p_correspondence_language
,p_fast_path_employee => p_fast_path_employee
,p_fte_capacity => l_fte_capacity
,p_hold_applicant_date_until => p_hold_applicant_date_until
,p_honors => p_honors
,p_internal_location => p_internal_location
,p_last_medical_test_by => p_last_medical_test_by
,p_last_medical_test_date => p_last_medical_test_date
,p_mailstop => p_mailstop
,p_office_number => p_office_number
,p_on_military_service => p_on_military_service
,p_pre_name_adjunct => p_pre_name_adjunct
,p_projected_start_date => p_projected_start_date
,p_rehire_authorizor => p_rehire_authorizor
,p_rehire_recommendation => p_rehire_recommendation
,p_resume_exists => p_resume_exists
,p_resume_last_updated => p_resume_last_updated
,p_second_passport_exists => p_second_passport_exists
,p_student_status => p_student_status
,p_work_schedule => p_work_schedule
,p_rehire_reason => p_rehire_reason
,p_benefit_group_id => l_benefit_group_id
,p_receipt_of_death_cert_date => p_receipt_of_death_cert_date
,p_coord_ben_med_pln_no => p_coord_ben_med_pln_no
,p_coord_ben_no_cvg_flag => p_coord_ben_no_cvg_flag
,p_uses_tobacco_flag => p_uses_tobacco_flag
,p_dpdnt_adoption_date => p_dpdnt_adoption_date
,p_dpdnt_vlntry_svce_flag => p_dpdnt_vlntry_svce_flag
,p_adjusted_svc_date => p_adjusted_svc_date
,p_attribute_category => p_attribute_category
,p_attribute1 => p_attribute1
,p_attribute2 => p_attribute2
,p_attribute3 => p_attribute3
,p_attribute4 => p_attribute4
,p_attribute5 => p_attribute5
,p_attribute6 => p_attribute6
,p_attribute7 => p_attribute7
,p_attribute8 => p_attribute8
,p_attribute9 => p_attribute9
,p_attribute10 => p_attribute10
,p_attribute11 => p_attribute11
,p_attribute12 => p_attribute12
,p_attribute13 => p_attribute13
,p_attribute14 => p_attribute14
,p_attribute15 => p_attribute15
,p_attribute16 => p_attribute16
,p_attribute17 => p_attribute17
,p_attribute18 => p_attribute18
,p_attribute19 => p_attribute19
,p_attribute20 => p_attribute20
,p_attribute21 => p_attribute21
,p_attribute22 => p_attribute22
,p_attribute23 => p_attribute23
,p_attribute24 => p_attribute24
,p_attribute25 => p_attribute25
,p_attribute26 => p_attribute26
,p_attribute27 => p_attribute27
,p_attribute28 => p_attribute28
,p_attribute29 => p_attribute29
,p_attribute30 => p_attribute30
,p_per_information_category => p_per_information_category
,p_per_information1 => p_per_information1
,p_per_information2 => p_per_information2
,p_per_information3 => p_per_information3
,p_per_information4 => p_per_information4
,p_per_information5 => p_per_information5
,p_per_information6 => p_per_information6
,p_per_information7 => p_per_information7
,p_per_information8 => p_per_information8
,p_per_information9 => p_per_information9
,p_per_information10 => p_per_information10
,p_per_information11 => p_per_information11
,p_per_information12 => p_per_information12
,p_per_information13 => p_per_information13
,p_per_information14 => p_per_information14
,p_per_information15 => p_per_information15
,p_per_information16 => p_per_information16
,p_per_information17 => p_per_information17
,p_per_information18 => p_per_information18
,p_per_information19 => p_per_information19
,p_per_information20 => p_per_information20
,p_per_information21 => p_per_information21
,p_per_information22 => p_per_information22
,p_per_information23 => p_per_information23
,p_per_information24 => p_per_information24
,p_per_information25 => p_per_information25
,p_per_information26 => p_per_information26
,p_per_information27 => p_per_information27
,p_per_information28 => p_per_information28
,p_per_information29 => p_per_information29
,p_per_information30 => p_per_information30
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_full_name => l_full_name
,p_comment_id => l_comment_id
,p_name_combination_warning => l_name_combination_warning
,p_assign_payroll_warning => l_assign_payroll_warning
,p_orig_hire_warning => l_orig_hire_warning
,p_error_message => l_error_message
);
l_transaction_table(l_count).param_name := 'P_ATTRIBUTE_UPDATE_MODE';
l_transaction_table(l_count).param_value := l_attribute_update_mode;
l_transaction_table(l_count).param_name := 'P_RESUME_LAST_UPDATED';
(p_resume_last_updated
,hr_transaction_ss.g_date_format);
END update_person;
,p_attribute_update_mode in varchar2
,p_effective_date in date
,p_person_id in number
,p_object_version_number in out nocopy number
,p_person_type_id in number default hr_api.g_number
,p_last_name in varchar2 default hr_api.g_varchar2
,p_applicant_number in varchar2 default hr_api.g_varchar2
,p_comments in varchar2 default hr_api.g_varchar2
,p_date_employee_data_verified in date default hr_api.g_date
,p_original_date_of_hire in date default hr_api.g_date
,p_date_of_birth 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_email_address in varchar2 default hr_api.g_varchar2
,p_employee_number in out nocopy varchar2
,p_npw_number in varchar2 default hr_api.g_varchar2
,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
,p_first_name in varchar2 default hr_api.g_varchar2
,p_known_as in varchar2 default hr_api.g_varchar2
,p_marital_status in varchar2 default hr_api.g_varchar2
,p_middle_names in varchar2 default hr_api.g_varchar2
,p_nationality in varchar2 default hr_api.g_varchar2
,p_national_identifier in varchar2 default hr_api.g_varchar2
,p_previous_last_name in varchar2 default hr_api.g_varchar2
,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
,p_sex in varchar2 default hr_api.g_varchar2
,p_title in varchar2 default hr_api.g_varchar2
,p_vendor_id in number default hr_api.g_number
,p_work_telephone 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_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_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_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_adjusted_svc_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_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_effective_start_date out nocopy date
,p_effective_end_date out nocopy date
,p_full_name out nocopy varchar2
,p_comment_id out nocopy number
,p_name_combination_warning out nocopy boolean
,p_assign_payroll_warning in out nocopy boolean
,p_orig_hire_warning out nocopy boolean
,p_error_message out nocopy long
)
IS
CURSOR get_current_rec(
p_eff_date in date default trunc(sysdate)) is
SELECT effective_start_date, object_version_number
FROM per_all_people_f
WHERE person_id = p_person_id
AND p_eff_date between effective_start_date
and effective_end_date;
hr_person_att.update_person gives error
THE MANDATORY COLUMN ATTRIBUTE HAS NOT BEEN ASSIGNED A VALUE
when a segment in descriptive flex field is made as required.
The solution suggested is to add the descriptive flex is to
ignore validation using hr_dflex_utility.create_ignore_df_validation
please refer to bug for further details.
*/
hr_person_info_util_ss.create_ignore_df_validation('PER_PERIODS_OF_SERVICE');
hr_person_api.update_person (
p_validate => false
,p_datetrack_update_mode => p_attribute_update_mode
,p_effective_date => p_effective_date
,p_person_id => p_person_id
,p_object_version_number => l_ovn
,p_person_type_id => p_person_type_id
,p_last_name => p_last_name
,p_applicant_number => p_applicant_number
,p_comments => p_comments
,p_date_employee_data_verified => p_date_employee_data_verified
,p_original_date_of_hire => p_original_date_of_hire
,p_date_of_birth => p_date_of_birth
,p_town_of_birth => p_town_of_birth
,p_region_of_birth => p_region_of_birth
,p_country_of_birth => p_country_of_birth
,p_global_person_id => p_global_person_id
,p_email_address => p_email_address
,p_employee_number => l_employee_number
,p_npw_number => p_npw_number
,p_expense_check_send_to_addres => p_expense_check_send_to_addres
,p_first_name => p_first_name
,p_known_as => p_known_as
,p_marital_status => p_marital_status
,p_middle_names => p_middle_names
,p_nationality => p_nationality
,p_national_identifier => p_national_identifier
,p_previous_last_name => p_previous_last_name
,p_registered_disabled_flag => p_registered_disabled_flag
,p_sex => p_sex
,p_title => p_title
,p_vendor_id => p_vendor_id
,p_work_telephone => p_work_telephone
,p_suffix => p_suffix
,p_date_of_death => p_date_of_death
,p_background_check_status => p_background_check_status
,p_background_date_check => p_background_date_check
,p_blood_type => p_blood_type
,p_correspondence_language => p_correspondence_language
,p_fast_path_employee => p_fast_path_employee
,p_fte_capacity => p_fte_capacity
,p_hold_applicant_date_until => p_hold_applicant_date_until
,p_honors => p_honors
,p_internal_location => p_internal_location
,p_last_medical_test_by => p_last_medical_test_by
,p_last_medical_test_date => p_last_medical_test_date
,p_mailstop => p_mailstop
,p_office_number => p_office_number
,p_on_military_service => p_on_military_service
,p_pre_name_adjunct => p_pre_name_adjunct
,p_projected_start_date => p_projected_start_date
,p_rehire_authorizor => p_rehire_authorizor
,p_rehire_recommendation => p_rehire_recommendation
,p_resume_exists => p_resume_exists
,p_resume_last_updated => p_resume_last_updated
,p_second_passport_exists => p_second_passport_exists
,p_student_status => p_student_status
,p_work_schedule => p_work_schedule
,p_rehire_reason => p_rehire_reason
,p_benefit_group_id => p_benefit_group_id
,p_receipt_of_death_cert_date => p_receipt_of_death_cert_date
,p_coord_ben_med_pln_no => p_coord_ben_med_pln_no
,p_coord_ben_no_cvg_flag => p_coord_ben_no_cvg_flag
,p_uses_tobacco_flag => p_uses_tobacco_flag
,p_dpdnt_adoption_date => p_dpdnt_adoption_date
,p_dpdnt_vlntry_svce_flag => p_dpdnt_vlntry_svce_flag
,p_adjusted_svc_date => p_adjusted_svc_date
,p_attribute_category => p_attribute_category
,p_attribute1 => p_attribute1
,p_attribute2 => p_attribute2
,p_attribute3 => p_attribute3
,p_attribute4 => p_attribute4
,p_attribute5 => p_attribute5
,p_attribute6 => p_attribute6
,p_attribute7 => p_attribute7
,p_attribute8 => p_attribute8
,p_attribute9 => p_attribute9
,p_attribute10 => p_attribute10
,p_attribute11 => p_attribute11
,p_attribute12 => p_attribute12
,p_attribute13 => p_attribute13
,p_attribute14 => p_attribute14
,p_attribute15 => p_attribute15
,p_attribute16 => p_attribute16
,p_attribute17 => p_attribute17
,p_attribute18 => p_attribute18
,p_attribute19 => p_attribute19
,p_attribute20 => p_attribute20
,p_attribute21 => p_attribute21
,p_attribute22 => p_attribute22
,p_attribute23 => p_attribute23
,p_attribute24 => p_attribute24
,p_attribute25 => p_attribute25
,p_attribute26 => p_attribute26
,p_attribute27 => p_attribute27
,p_attribute28 => p_attribute28
,p_attribute29 => p_attribute29
,p_attribute30 => p_attribute30
,p_per_information_category => p_per_information_category
,p_per_information1 => p_per_information1
,p_per_information2 => p_per_information2
,p_per_information3 => p_per_information3
,p_per_information4 => p_per_information4
,p_per_information5 => p_per_information5
,p_per_information6 => p_per_information6
,p_per_information7 => p_per_information7
,p_per_information8 => p_per_information8
,p_per_information9 => p_per_information9
,p_per_information10 => p_per_information10
,p_per_information11 => p_per_information11
,p_per_information12 => p_per_information12
,p_per_information13 => p_per_information13
,p_per_information14 => p_per_information14
,p_per_information15 => p_per_information15
,p_per_information16 => p_per_information16
,p_per_information17 => p_per_information17
,p_per_information18 => p_per_information18
,p_per_information19 => p_per_information19
,p_per_information20 => p_per_information20
,p_per_information21 => p_per_information21
,p_per_information22 => p_per_information22
,p_per_information23 => p_per_information23
,p_per_information24 => p_per_information24
,p_per_information25 => p_per_information25
,p_per_information26 => p_per_information26
,p_per_information27 => p_per_information27
,p_per_information28 => p_per_information28
,p_per_information29 => p_per_information29
,p_per_information30 => p_per_information30
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_full_name => l_full_name
,p_comment_id => l_comment_id
,p_name_combination_warning => l_name_combination_warning
,p_assign_payroll_warning => l_assign_payroll_warning
,p_orig_hire_warning => l_orig_hire_warning);
p_message_name => 'HR_UPDATE_NOT_ALLOWED');
,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_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_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_adjusted_svc_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_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
)
return boolean
IS
l_rec_changed boolean default null;
IF p_resume_last_updated <> hr_api.g_date OR p_resume_last_updated IS NULL
THEN
IF nvl(p_resume_last_updated, hr_api.g_date) <>
nvl(l_cur_person_data.resume_last_updated, hr_api.g_date)
THEN
l_rec_changed := TRUE;
SELECT oi.org_information9 legislation_code
FROM hr_organization_information oi
WHERE oi.organization_id = l_organization_id
AND oi.org_information_context = 'Business Group Information';
select asg.assignment_id,
asg.payroll_id, asg.soft_coding_keyflex_id
from per_all_assignments_f asg,
per_assignment_status_types pas
where asg.assignment_status_type_id = pas.assignment_status_type_id
and asg.person_id = l_person_id
and l_effective_date between asg.effective_start_date
and asg.effective_end_date
and pas.per_system_status = 'ACCEPTED'
and asg.assignment_type = 'A'
and asg.payroll_id is not null
order by asg.assignment_id;
select legislation_code
from per_business_groups_perf
where business_group_id = p_business_group_id;
select style
from per_addresses a
where a.person_id = p_person_id and a.primary_flag = 'Y'
and p_effective_date between a.date_from and nvl(a.date_to,hr_api.g_eot);
select region_1
from per_addresses a
where a.person_id = p_person_id and a.primary_flag = 'Y'
and p_effective_date between a.date_from and nvl(a.date_to,hr_api.g_eot);
select CREATOR_PERSON_ID into login_person_id
from HR_API_TRANSACTION_STEPS
where TRANSACTION_STEP_ID = p_transaction_step_id;
update per_addresses set style = 'US' ,region_1 ='Snohomish'
where person_id = l_person_id and primary_flag = 'Y'
and l_effective_date between date_from and nvl(date_to,hr_api.g_eot);
update per_addresses set style = l_style_old, region_1 = l_region1_old
where person_id = l_person_id and primary_flag = 'Y'
and l_effective_date between date_from and nvl(date_to,hr_api.g_eot);
update per_all_assignments_f set payroll_id=asg_pay_rec(i).payroll_id
where assignment_id = asg_pay_rec(i).assignment_id and
l_effective_date - 1 between effective_start_date and effective_end_date;
update per_all_assignments_f set payroll_id=asg_pay_rec(i).payroll_id
where assignment_id = asg_pay_rec(i).assignment_id and
assignment_id <> l_appl_assignment_id and
l_effective_date between effective_start_date and effective_end_date;
hr_person_api.update_person(
p_validate => p_validate
,p_effective_date => l_effective_date
,p_datetrack_update_mode => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE_UPDATE_MODE')
,p_person_id => l_person_id
,p_object_version_number => l_ovn
,p_person_type_id => l_person_type_id
,p_last_name => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_LAST_NAME')
,p_applicant_number => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_APPLICANT_NUMBER')
,p_comments => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_COMMENTS')
,p_date_employee_data_verified => hr_transaction_api.get_date_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_DATE_EMPLOYEE_DATA_VERIFIED')
-- bug 4416684 pass original_date_of_hire only if it is not null
,p_original_date_of_hire => nvl(hr_transaction_api.get_date_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ORIGINAL_DATE_OF_HIRE'),hr_api.g_date)
,p_date_of_birth => hr_transaction_api.get_date_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_DATE_OF_BIRTH')
,p_town_of_birth => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_TOWN_OF_BIRTH')
,p_region_of_birth => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_REGION_OF_BIRTH')
,p_country_of_birth => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_COUNTRY_OF_BIRTH')
,p_global_person_id => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_GLOBAL_PERSON_ID')
,p_employee_number => l_employee_number
,p_npw_number => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_NPW_NUMBER')
,p_email_address => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_EMAIL_ADDRESS')
,p_expense_check_send_to_addres => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_EXPENSE_CHECK_SEND_TO_ADDRES')
,p_first_name => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_FIRST_NAME')
,p_known_as => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_KNOWN_AS')
,p_marital_status => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_MARITAL_STATUS')
,p_middle_names => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_MIDDLE_NAMES')
,p_nationality => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_NATIONALITY')
,p_national_identifier => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_NATIONAL_IDENTIFIER')
,p_previous_last_name => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PREVIOUS_LAST_NAME')
,p_registered_disabled_flag => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_REGISTERED_DISABLED_FLAG')
,p_sex => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_SEX')
,p_title => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_TITLE')
,p_vendor_id => hr_transaction_api.get_number_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_VENDOR_ID')
,p_work_telephone => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_WORK_TELEPHONE')
,p_suffix => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_SUFFIX')
,p_date_of_death => hr_transaction_api.get_date_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_DATE_OF_DEATH')
,p_background_check_status => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_BACKGROUND_CHECK_STATUS')
,p_background_date_check => hr_transaction_api.get_date_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_BACKGROUND_DATE_CHECK')
,p_blood_type => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_BLOOD_TYPE')
,p_correspondence_language => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_CORRESPONDENCE_LANGUAGE')
,p_fast_path_employee => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_FAST_PATH_EMPLOYEE')
,p_fte_capacity => hr_transaction_api.get_number_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_FTE_CAPACITY')
,p_hold_applicant_date_until => hr_transaction_api.get_date_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_HOLD_APPLICANT_DATE_UNTIL')
,p_honors => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_HONORS')
,p_internal_location => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_INTERNAL_LOCATION')
,p_last_medical_test_by => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_LAST_MEDICAL_TEST_BY')
,p_last_medical_test_date => hr_transaction_api.get_date_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_LAST_MEDICAL_TEST_DATE')
,p_mailstop => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_MAILSTOP')
,p_office_number => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_OFFICE_NUMBER')
,p_on_military_service => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ON_MILITARY_SERVICE')
,p_pre_name_adjunct => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PRE_NAME_ADJUNCT')
,p_projected_start_date => hr_transaction_api.get_date_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PROJECTED_START_DATE')
,p_rehire_authorizor => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_REHIRE_AUTHORIZOR')
,p_rehire_recommendation => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_REHIRE_RECOMMENDATION')
,p_resume_exists => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_RESUME_EXISTS')
,p_resume_last_updated => hr_transaction_api.get_date_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_RESUME_LAST_UPDATED')
,p_second_passport_exists => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_SECOND_PASSPORT_EXISTS')
,p_student_status => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_STUDENT_STATUS')
,p_work_schedule => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_WORK_SCHEDULE')
,p_rehire_reason => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_REHIRE_REASON')
,p_benefit_group_id => hr_transaction_api.get_number_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_BENEFIT_GROUP_ID')
,p_receipt_of_death_cert_date => hr_transaction_api.get_date_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_RECEIPT_OF_DEATH_CERT_DATE')
,p_coord_ben_med_pln_no => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_COORD_BEN_MED_PLN_NO')
,p_coord_ben_no_cvg_flag => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_COORD_BEN_NO_CVG_FLAG')
,p_uses_tobacco_flag => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_USES_TOBACCO_FLAG')
,p_dpdnt_adoption_date => hr_transaction_api.get_date_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_DPDNT_ADOPTION_DATE')
,p_dpdnt_vlntry_svce_flag => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_DPDNT_VLNTRY_SVCE_FLAG')
,p_adjusted_svc_date => hr_transaction_api.get_date_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ADJUSTED_SVC_DATE')
,p_attribute_category => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE_CATEGORY')
,p_attribute1 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE1')
,p_attribute2 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE2')
,p_attribute3 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE3')
,p_attribute4 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE4')
,p_attribute5 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE5')
,p_attribute6 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE6')
,p_attribute7 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE7')
,p_attribute8 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE8')
,p_attribute9 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE9')
,p_attribute10 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE10')
,p_attribute11 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE11')
,p_attribute12 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE12')
,p_attribute13 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE13')
,p_attribute14 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE14')
,p_attribute15 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE15')
,p_attribute16 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE16')
,p_attribute17 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE17')
,p_attribute18 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE18')
,p_attribute19 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE19')
,p_attribute20 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE20')
,p_attribute21 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE21')
,p_attribute22 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE22')
,p_attribute23 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE23')
,p_attribute24 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE24')
,p_attribute25 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE25')
,p_attribute26 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE26')
,p_attribute27 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE27')
,p_attribute28 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE28')
,p_attribute29 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE29')
,p_attribute30 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE30')
,p_per_information_category => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION_CATEGORY')
,p_per_information1 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION1')
,p_per_information2 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION2')
,p_per_information3 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION3')
,p_per_information4 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION4')
,p_per_information5 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION5')
,p_per_information6 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION6')
,p_per_information7 => l_per_information7
,p_per_information8 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION8')
,p_per_information9 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION9')
,p_per_information10 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION10')
,p_per_information11 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION11')
,p_per_information12 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION12')
,p_per_information13 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION13')
,p_per_information14 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION14')
,p_per_information15 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION15')
,p_per_information16 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION16')
,p_per_information17 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION17')
,p_per_information18 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION18')
,p_per_information19 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION19')
,p_per_information20 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION20')
,p_per_information21 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION21')
,p_per_information22 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION22')
,p_per_information23 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION23')
,p_per_information24 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION24')
,p_per_information25 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION25')
,p_per_information26 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION26')
,p_per_information27 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION27')
,p_per_information28 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION28')
,p_per_information29 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION29')
,p_per_information30 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION30')
,p_effective_start_date => l_effective_start_Date
,p_effective_end_date => l_effective_end_Date
,p_full_name => l_full_name
,p_comment_id => l_comment_id
,p_name_combination_warning => l_name_combination_warning
,p_assign_payroll_warning => l_assign_payroll_warning
,p_orig_hire_warning => l_orig_hire_warning
);
if l_flow_name = 'Insert' then
--end cobra codes
if hr_new_user_reg_ss.g_ignore_emp_generation = 'YES' then
--
-- Special case for SSHR if the profile is set
-- as we need to make sure that the generation controls table is not
-- locked.
--
hr_utility.set_location('l_flow_name = Insert:'||l_proc,100);
,p_resume_last_updated => hr_transaction_api.get_date_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_RESUME_LAST_UPDATED')
,p_second_passport_exists => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_SECOND_PASSPORT_EXISTS')
,p_sex => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_SEX')
,p_student_status => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_STUDENT_STATUS')
,p_suffix => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_SUFFIX')
,p_title => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_TITLE')
,p_town_of_birth => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_TOWN_OF_BIRTH')
,p_uses_tobacco_flag => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_USES_TOBACCO_FLAG')
,p_vendor_id => hr_transaction_api.get_number_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_VENDOR_ID')
,p_work_schedule => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_WORK_SCHEDULE')
,p_work_telephone => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_WORK_TELEPHONE')
--,p_exp_check_send_to_address =>
--,p_hold_applicant_date_until =>
,p_date_employee_data_verified => hr_transaction_api.get_date_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_DATE_EMPLOYEE_DATA_VERIFIED')
,p_benefit_group_id => hr_transaction_api.get_number_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_BENEFIT_GROUP_ID')
,p_coord_ben_med_pln_no => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_COORD_BEN_MED_PLN_NO')
,p_coord_ben_no_cvg_flag => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_COORD_BEN_NO_CVG_FLAG')
,p_original_date_of_hire => hr_transaction_api.get_date_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ORIGINAL_DATE_OF_HIRE')
,p_attribute_category => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE_CATEGORY')
,p_attribute1 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE1')
,p_attribute2 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE2')
,p_attribute3 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE3')
,p_attribute4 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE4')
,p_attribute5 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE5')
,p_attribute6 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE6')
,p_attribute7 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE7')
,p_attribute8 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE8')
,p_attribute9 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE9')
,p_attribute10 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE10')
,p_attribute11 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE11')
,p_attribute12 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE12')
,p_attribute13 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE13')
,p_attribute14 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE14')
,p_attribute15 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE15')
,p_attribute16 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE16')
,p_attribute17 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE17')
,p_attribute18 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE18')
,p_attribute19 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE19')
,p_attribute20 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE20')
,p_attribute21 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE21')
,p_attribute22 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE22')
,p_attribute23 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE23')
,p_attribute24 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE24')
,p_attribute25 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE25')
,p_attribute26 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE26')
,p_attribute27 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE27')
,p_attribute28 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE28')
,p_attribute29 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE29')
,p_attribute30 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ATTRIBUTE30')
,p_per_information_category => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION_CATEGORY')
,p_per_information1 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION1')
,p_per_information2 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION2')
,p_per_information3 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION3')
,p_per_information4 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION4')
,p_per_information5 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION5')
,p_per_information6 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION6')
,p_per_information7 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION7')
,p_per_information8 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION8')
,p_per_information9 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION9')
,p_per_information10 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION10')
,p_per_information11 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION11')
,p_per_information12 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION12')
,p_per_information13 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION13')
,p_per_information14 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION14')
,p_per_information15 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION15')
,p_per_information16 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION16')
,p_per_information17 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION17')
,p_per_information18 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION18')
,p_per_information19 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION19')
,p_per_information20 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION20')
,p_per_information21 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION21')
,p_per_information22 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION22')
,p_per_information23 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION23')
,p_per_information24 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION24')
,p_per_information25 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION25')
,p_per_information26 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION26')
,p_per_information27 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION27')
,p_per_information28 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION28')
,p_per_information29 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION29')
,p_per_information30 => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PER_INFORMATION30')
,p_person_id => l_person_id
,p_per_object_version_number => l_povn
,p_per_effective_start_date => l_effective_start_Date
,p_per_effective_end_date => l_effective_end_Date
,p_pdp_object_version_number => l_dovn
,p_full_name => l_full_name
,p_comment_id => l_comment_id
,p_assignment_id => l_assignment_id
,p_asg_object_version_number => l_aovn
,p_assignment_sequence => l_assignment_sequence
,p_assignment_number => l_assignment_number
,p_name_combination_warning => l_name_combination_warning
);
,p_resume_last_updated => hr_transaction_api.get_date_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_RESUME_LAST_UPDATED')
,p_second_passport_exists => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_SECOND_PASSPORT_EXISTS')
,p_student_status => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_STUDENT_STATUS')
,p_work_schedule => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_WORK_SCHEDULE')
,p_suffix => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_SUFFIX')
,p_benefit_group_id => hr_transaction_api.get_number_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_BENEFIT_GROUP_ID')
,p_receipt_of_death_cert_date => hr_transaction_api.get_date_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_RECEIPT_OF_DEATH_CERT_DATE')
,p_coord_ben_med_pln_no => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_COORD_BEN_MED_PLN_NO')
,p_coord_ben_no_cvg_flag => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_COORD_BEN_NO_CVG_FLAG')
,p_uses_tobacco_flag => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_USES_TOBACCO_FLAG')
,p_dpdnt_adoption_date => hr_transaction_api.get_date_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_DPDNT_ADOPTION_DATE')
,p_dpdnt_vlntry_svce_flag => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_DPDNT_VLNTRY_SVCE_FLAG')
,p_original_date_of_hire => hr_transaction_api.get_date_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ORIGINAL_DATE_OF_HIRE')
,p_adjusted_svc_date => hr_transaction_api.get_date_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_ADJUSTED_SVC_DATE')
,p_town_of_birth => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_TOWN_OF_BIRTH')
,p_region_of_birth => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_REGION_OF_BIRTH')
,p_country_of_birth => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_COUNTRY_OF_BIRTH')
,p_global_person_id => hr_transaction_api.get_varchar2_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_GLOBAL_PERSON_ID')
,p_party_id => hr_transaction_api.get_number_value
(p_transaction_step_id => p_transaction_step_id
,p_name => 'P_PARTY_ID')
,p_person_id => l_person_id
,p_assignment_id => l_assignment_id
,p_per_object_version_number => l_povn
,p_asg_object_version_number => l_aovn
,p_per_effective_start_date => l_effective_start_Date
,p_per_effective_end_date => l_effective_end_Date
,p_full_name => l_full_name
,p_per_comment_id => l_comment_id
,p_assignment_sequence => l_assignment_sequence
,p_assignment_number => l_assignment_number
,p_name_combination_warning => l_name_combination_warning
,p_assign_payroll_warning => l_assign_payroll_warning
,p_orig_hire_warning => l_orig_hire_warning
);
,p_resume_last_updated in date default null
,p_second_passport_exists in varchar2 default null
,p_student_status in varchar2 default null
,p_work_schedule in varchar2 default null
,p_suffix in varchar2 default null
,p_benefit_group_id in number default null
,p_receipt_of_death_cert_date in date default null
,p_coord_ben_med_pln_no in varchar2 default null
,p_coord_ben_no_cvg_flag in varchar2 default 'N'
,p_uses_tobacco_flag in varchar2 default null
,p_dpdnt_adoption_date in date default null
,p_dpdnt_vlntry_svce_flag in varchar2 default 'N'
,p_original_date_of_hire in date default null
,p_adjusted_svc_date in date default null
,p_town_of_birth in varchar2 default null
,p_region_of_birth in varchar2 default null
,p_country_of_birth in varchar2 default null
,p_global_person_id in varchar2 default null
,p_effective_date in date default sysdate
,p_attribute_update_mode in varchar2 default null
,p_object_version_number in number default null
,p_applicant_number in varchar2 default null
,p_comments in varchar2 default null
,p_rehire_authorizor in varchar2 default null
,p_rehire_recommendation in varchar2 default null
,p_hold_applicant_date_until in date default null
,p_rehire_reason in varchar2 default null
-- start cobra codes
,p_flow_name in varchar2 default null
-- end cobra codes
,p_person_id out nocopy number
,p_assignment_id out nocopy number
,p_per_object_version_number out nocopy number
,p_asg_object_version_number out nocopy number
,p_per_effective_start_date out nocopy date
,p_per_effective_end_date out nocopy date
,p_full_name out nocopy varchar2
,p_per_comment_id out nocopy number
,p_assignment_sequence out nocopy number
,p_assignment_number out nocopy varchar2
,p_name_combination_warning out nocopy varchar2 ---boolean
,p_assign_payroll_warning out nocopy varchar2 ---boolean
,p_orig_hire_warning out nocopy varchar2 ---boolean
,p_party_id in number default null
,p_save_mode in varchar2 default null
,p_error_message out nocopy long
,p_ni_duplicate_warn_or_err in out nocopy varchar2
,p_validate_ni in out nocopy varchar2
) IS
CURSOR get_wf_actid (c_activity_name in varchar2) IS
SELECT distinct wfias.activity_id
FROM wf_item_activity_statuses_v wfias
WHERE wfias.item_type = p_item_type
and wfias.item_key = p_item_key
and wfias.activity_name = c_activity_name;
IF p_flow_name = 'Insert' THEN
-- end cobra codes
if(p_ni_duplicate_warn_or_err <> 'IGNORE') then
hr_person_info_util_ss.check_ni_unique(
p_national_identifier => p_national_identifier
,p_business_group_id => p_business_group_id
,p_person_id => p_person_id
,p_ni_duplicate_warn_or_err => p_ni_duplicate_warn_or_err);
,p_resume_last_updated => p_resume_last_updated
,p_second_passport_exists => p_second_passport_exists
,p_sex => p_sex
,p_student_status => p_student_status
,p_suffix => p_suffix
,p_title => p_title
,p_town_of_birth => p_town_of_birth
,p_uses_tobacco_flag => p_uses_tobacco_flag
,p_vendor_id => l_vendor_id
,p_work_schedule => p_work_schedule
,p_work_telephone => p_work_telephone
--,p_exp_check_send_to_address =>
--,p_hold_applicant_date_until =>
,p_date_employee_data_verified => p_date_employee_data_verified
,p_benefit_group_id => l_benefit_group_id
,p_coord_ben_med_pln_no => p_coord_ben_med_pln_no
,p_coord_ben_no_cvg_flag => p_coord_ben_no_cvg_flag
,p_original_date_of_hire => p_original_date_of_hire
,p_attribute_category => p_attribute_category
,p_attribute1 => p_attribute1
,p_attribute2 => p_attribute2
,p_attribute3 => p_attribute3
,p_attribute4 => p_attribute4
,p_attribute5 => p_attribute5
,p_attribute6 => p_attribute6
,p_attribute7 => p_attribute7
,p_attribute8 => p_attribute8
,p_attribute9 => p_attribute9
,p_attribute10 => p_attribute10
,p_attribute11 => p_attribute11
,p_attribute12 => p_attribute12
,p_attribute13 => p_attribute13
,p_attribute14 => p_attribute14
,p_attribute15 => p_attribute15
,p_attribute16 => p_attribute16
,p_attribute17 => p_attribute17
,p_attribute18 => p_attribute18
,p_attribute19 => p_attribute19
,p_attribute20 => p_attribute20
,p_attribute21 => p_attribute21
,p_attribute22 => p_attribute22
,p_attribute23 => p_attribute23
,p_attribute24 => p_attribute24
,p_attribute25 => p_attribute25
,p_attribute26 => p_attribute26
,p_attribute27 => p_attribute27
,p_attribute28 => p_attribute28
,p_attribute29 => p_attribute29
,p_attribute30 => p_attribute30
,p_per_information_category => p_per_information_category
,p_per_information1 => p_per_information1
,p_per_information2 => p_per_information2
,p_per_information3 => p_per_information3
,p_per_information4 => p_per_information4
,p_per_information5 => p_per_information5
,p_per_information6 => p_per_information6
,p_per_information7 => p_per_information7
,p_per_information8 => p_per_information8
,p_per_information9 => p_per_information9
,p_per_information10 => p_per_information10
,p_per_information11 => p_per_information11
,p_per_information12 => p_per_information12
,p_per_information13 => p_per_information13
,p_per_information14 => p_per_information14
,p_per_information15 => p_per_information15
,p_per_information16 => p_per_information16
,p_per_information17 => p_per_information17
,p_per_information18 => p_per_information18
,p_per_information19 => p_per_information19
,p_per_information20 => p_per_information20
,p_per_information21 => p_per_information21
,p_per_information22 => p_per_information22
,p_per_information23 => p_per_information23
,p_per_information24 => p_per_information24
,p_per_information25 => p_per_information25
,p_per_information26 => p_per_information26
,p_per_information27 => p_per_information27
,p_per_information28 => p_per_information28
,p_per_information29 => p_per_information29
,p_per_information30 => p_per_information30
,p_person_id => l_person_id
,p_per_object_version_number => l_per_ovn
,p_per_effective_start_date => l_per_effective_start_date
,p_per_effective_end_date => l_per_effective_end_date
,p_pdp_object_version_number => l_pdp_ovn
,p_full_name => l_full_name
,p_comment_id => l_per_comment_id
,p_assignment_id => l_assignment_id
,p_asg_object_version_number => l_asg_ovn
,p_assignment_sequence => l_assignment_sequence
,p_assignment_number => l_assignment_number
,p_name_combination_warning => l_name_combination_warning
);
,p_resume_last_updated => p_resume_last_updated
,p_second_passport_exists => p_second_passport_exists
,p_student_status => p_student_status
,p_work_schedule => p_work_schedule
,p_suffix => p_suffix
,p_benefit_group_id => l_benefit_group_id
,p_receipt_of_death_cert_date => p_receipt_of_death_cert_date
,p_coord_ben_med_pln_no => p_coord_ben_med_pln_no
,p_coord_ben_no_cvg_flag => p_coord_ben_no_cvg_flag
,p_uses_tobacco_flag => p_uses_tobacco_flag
,p_dpdnt_adoption_date => p_dpdnt_adoption_date
,p_dpdnt_vlntry_svce_flag => p_dpdnt_vlntry_svce_flag
,p_original_date_of_hire => p_original_date_of_hire
,p_adjusted_svc_date => p_adjusted_svc_date
,p_town_of_birth => p_town_of_birth
,p_region_of_birth => p_region_of_birth
,p_country_of_birth => p_country_of_birth
,p_global_person_id => p_global_person_id
,p_party_id => p_party_id
,p_person_id => l_person_id -- out number
,p_assignment_id => l_assignment_id -- out number
,p_per_object_version_number => l_per_ovn --- out nocopy number
,p_asg_object_version_number => l_asg_ovn --- out nocopy number
,p_per_effective_start_date => l_per_effective_start_date --out date
,p_per_effective_end_date => l_per_effective_end_date --out date
,p_full_name => l_full_name ---out nocopy varchar2
,p_per_comment_id => l_per_comment_id ---out nocopy number
,p_assignment_sequence => l_assignment_sequence --out number
,p_assignment_number => l_assignment_number --out varchar2
,p_name_combination_warning => l_name_combination_warning
--out boolean
,p_assign_payroll_warning => l_assign_payroll_warning
-- out boolean
,p_orig_hire_warning => l_orig_hire_warning -- out boolean
);
l_transaction_table(l_count).param_name := 'P_RESUME_LAST_UPDATED';
(p_resume_last_updated
,hr_transaction_ss.g_date_format);
l_transaction_table(l_count).param_name := 'P_ATTRIBUTE_UPDATE_MODE';
l_transaction_table(l_count).param_value := p_attribute_update_mode;
select date_of_birth from per_people_f
where person_id = p_person_id
and p_effective_date between effective_start_date
and effective_end_date;
select address_line1 from per_addresses
where person_id = p_person_id and primary_flag='Y'
and ( (style='US' and region_1 is not null)
or style<>'US');
select legislation_code from per_business_groups_perf
where business_group_id = p_business_group_id;
select legislation_code from pay_legislation_rules
where legislation_code = l_legislation_code
and rule_type = 'TAX_UNIT' and rule_mode = 'Y';
update per_all_assignments_f set payroll_id=null where assignment_id = p_assignment_id and
p_effective_date between effective_start_date and effective_end_date;