54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy per_per_shd.g_rec_type,
59: p_effective_date in date,
60: p_datetrack_mode in varchar2,
61: p_validation_start_date in date,
62: p_validation_end_date in date) is
87: (p_base_table_name => 'per_all_people_f',
88: p_base_key_column => 'person_id',
89: p_base_key_value => p_rec.person_id);
90: --
91: per_per_shd.g_api_dml := true; -- Set the api dml status
92:
93: /* --bug#1942531 change starts
94: if not FND_FLEX_DESCVAL.validate_desccols
95: (appl_short_name => 'PER'
263: close c_person;
264: --
265: per_hrtca_merge.update_tca_person(p_rec => l_person);
266: --
267: per_per_shd.g_api_dml := false; -- Unset the api dml status
268: --
269: -- Set the effective start and end dates
270: --
271: p_rec.effective_start_date := p_validation_start_date;
275: hr_utility.set_location(' Leaving:'||l_proc, 15);
276: Exception
277: When hr_api.check_integrity_violated Then
278: -- A check constraint has been violated
279: per_per_shd.g_api_dml := false; -- Unset the api dml status
280: per_per_shd.constraint_error
281: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
282: When hr_api.unique_integrity_violated Then
283: -- Unique integrity has been violated
276: Exception
277: When hr_api.check_integrity_violated Then
278: -- A check constraint has been violated
279: per_per_shd.g_api_dml := false; -- Unset the api dml status
280: per_per_shd.constraint_error
281: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
282: When hr_api.unique_integrity_violated Then
283: -- Unique integrity has been violated
284: per_per_shd.g_api_dml := false; -- Unset the api dml status
280: per_per_shd.constraint_error
281: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
282: When hr_api.unique_integrity_violated Then
283: -- Unique integrity has been violated
284: per_per_shd.g_api_dml := false; -- Unset the api dml status
285: per_per_shd.constraint_error
286: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
287: When Others Then
288: per_per_shd.g_api_dml := false; -- Unset the api dml status
281: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
282: When hr_api.unique_integrity_violated Then
283: -- Unique integrity has been violated
284: per_per_shd.g_api_dml := false; -- Unset the api dml status
285: per_per_shd.constraint_error
286: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
287: When Others Then
288: per_per_shd.g_api_dml := false; -- Unset the api dml status
289: Raise;
284: per_per_shd.g_api_dml := false; -- Unset the api dml status
285: per_per_shd.constraint_error
286: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
287: When Others Then
288: per_per_shd.g_api_dml := false; -- Unset the api dml status
289: Raise;
290: End dt_update_dml;
291: --
292: -- ----------------------------------------------------------------------------
320: --
321: -- {End Of Comments}
322: -- ----------------------------------------------------------------------------
323: Procedure update_dml
324: (p_rec in out nocopy per_per_shd.g_rec_type,
325: p_effective_date in date,
326: p_datetrack_mode in varchar2,
327: p_validation_start_date in date,
328: p_validation_end_date in date) is
384: --
385: -- {End Of Comments}
386: -- ----------------------------------------------------------------------------
387: Procedure dt_pre_update
388: (p_rec in out nocopy per_per_shd.g_rec_type,
389: p_effective_date in date,
390: p_datetrack_mode in varchar2,
391: p_validation_start_date in date,
392: p_validation_end_date in date) is
400: hr_utility.set_location(l_proc, 10);
401: --
402: -- Update the current effective end date
403: --
404: per_per_shd.upd_effective_end_date
405: (p_effective_date => p_effective_date,
406: p_base_key_value => p_rec.person_id,
407: p_new_effective_end_date => (p_validation_start_date - 1),
408: p_validation_start_date => p_validation_start_date,
469: --
470: -- {End Of Comments}
471: -- ----------------------------------------------------------------------------
472: Procedure pre_update
473: (p_rec in out nocopy per_per_shd.g_rec_type,
474: p_effective_date in date,
475: p_datetrack_mode in varchar2,
476: p_validation_start_date in date,
477: p_validation_end_date in date) is
506: p_source_table_name => 'per_all_people_f',
507: p_comment_text => p_rec.comments);
508: -- Update the comments if they have changed
509: ElsIf (p_rec.comment_id is not null and p_rec.comments <>
510: per_per_shd.g_old_rec.comments) then
511: hr_comm_api.upd(p_comment_id => p_rec.comment_id,
512: p_source_table_name => 'per_all_people_f',
513: p_comment_text => p_rec.comments);
514: End If;
523: -- Desc: Call the BEN proc for change log event.
524: if p_datetrack_mode <> 'CORRECTION' then
525: ben_ext_chlg.log_per_chg
526: (p_event => 'UPDATE',
527: p_old_rec => per_per_shd.g_old_rec,
528: p_new_rec => p_rec
529: );
530: end if;
531: -- Bug 3717072 Ends
634: --
635: -- {End Of Comments}
636: -- ----------------------------------------------------------------------------
637: Procedure post_update
638: (p_rec in per_per_shd.g_rec_type,
639: p_effective_date in date,
640: p_datetrack_mode in varchar2,
641: p_validation_start_date in date,
642: p_validation_end_date in date,
814: ,p_name_combination_warning => p_name_combination_warning
815: ,p_dob_null_warning => p_dob_null_warning
816: ,p_orig_hire_warning => p_orig_hire_warning
817: ,p_effective_start_date_o
818: => per_per_shd.g_old_rec.effective_start_date
819: ,p_effective_end_date_o
820: => per_per_shd.g_old_rec.effective_end_date
821: ,p_business_group_id_o
822: => per_per_shd.g_old_rec.business_group_id
816: ,p_orig_hire_warning => p_orig_hire_warning
817: ,p_effective_start_date_o
818: => per_per_shd.g_old_rec.effective_start_date
819: ,p_effective_end_date_o
820: => per_per_shd.g_old_rec.effective_end_date
821: ,p_business_group_id_o
822: => per_per_shd.g_old_rec.business_group_id
823: ,p_person_type_id_o
824: => per_per_shd.g_old_rec.person_type_id
818: => per_per_shd.g_old_rec.effective_start_date
819: ,p_effective_end_date_o
820: => per_per_shd.g_old_rec.effective_end_date
821: ,p_business_group_id_o
822: => per_per_shd.g_old_rec.business_group_id
823: ,p_person_type_id_o
824: => per_per_shd.g_old_rec.person_type_id
825: ,p_last_name_o
826: => per_per_shd.g_old_rec.last_name
820: => per_per_shd.g_old_rec.effective_end_date
821: ,p_business_group_id_o
822: => per_per_shd.g_old_rec.business_group_id
823: ,p_person_type_id_o
824: => per_per_shd.g_old_rec.person_type_id
825: ,p_last_name_o
826: => per_per_shd.g_old_rec.last_name
827: ,p_start_date_o
828: => per_per_shd.g_old_rec.start_date
822: => per_per_shd.g_old_rec.business_group_id
823: ,p_person_type_id_o
824: => per_per_shd.g_old_rec.person_type_id
825: ,p_last_name_o
826: => per_per_shd.g_old_rec.last_name
827: ,p_start_date_o
828: => per_per_shd.g_old_rec.start_date
829: ,p_applicant_number_o
830: => per_per_shd.g_old_rec.applicant_number
824: => per_per_shd.g_old_rec.person_type_id
825: ,p_last_name_o
826: => per_per_shd.g_old_rec.last_name
827: ,p_start_date_o
828: => per_per_shd.g_old_rec.start_date
829: ,p_applicant_number_o
830: => per_per_shd.g_old_rec.applicant_number
831: ,p_comment_id_o
832: => per_per_shd.g_old_rec.comment_id
826: => per_per_shd.g_old_rec.last_name
827: ,p_start_date_o
828: => per_per_shd.g_old_rec.start_date
829: ,p_applicant_number_o
830: => per_per_shd.g_old_rec.applicant_number
831: ,p_comment_id_o
832: => per_per_shd.g_old_rec.comment_id
833: ,p_current_applicant_flag_o
834: => per_per_shd.g_old_rec.current_applicant_flag
828: => per_per_shd.g_old_rec.start_date
829: ,p_applicant_number_o
830: => per_per_shd.g_old_rec.applicant_number
831: ,p_comment_id_o
832: => per_per_shd.g_old_rec.comment_id
833: ,p_current_applicant_flag_o
834: => per_per_shd.g_old_rec.current_applicant_flag
835: ,p_current_emp_or_apl_flag_o
836: => per_per_shd.g_old_rec.current_emp_or_apl_flag
830: => per_per_shd.g_old_rec.applicant_number
831: ,p_comment_id_o
832: => per_per_shd.g_old_rec.comment_id
833: ,p_current_applicant_flag_o
834: => per_per_shd.g_old_rec.current_applicant_flag
835: ,p_current_emp_or_apl_flag_o
836: => per_per_shd.g_old_rec.current_emp_or_apl_flag
837: ,p_current_employee_flag_o
838: => per_per_shd.g_old_rec.current_employee_flag
832: => per_per_shd.g_old_rec.comment_id
833: ,p_current_applicant_flag_o
834: => per_per_shd.g_old_rec.current_applicant_flag
835: ,p_current_emp_or_apl_flag_o
836: => per_per_shd.g_old_rec.current_emp_or_apl_flag
837: ,p_current_employee_flag_o
838: => per_per_shd.g_old_rec.current_employee_flag
839: ,p_date_employee_data_verifie_o
840: => per_per_shd.g_old_rec.date_employee_data_verified
834: => per_per_shd.g_old_rec.current_applicant_flag
835: ,p_current_emp_or_apl_flag_o
836: => per_per_shd.g_old_rec.current_emp_or_apl_flag
837: ,p_current_employee_flag_o
838: => per_per_shd.g_old_rec.current_employee_flag
839: ,p_date_employee_data_verifie_o
840: => per_per_shd.g_old_rec.date_employee_data_verified
841: ,p_date_of_birth_o
842: => per_per_shd.g_old_rec.date_of_birth
836: => per_per_shd.g_old_rec.current_emp_or_apl_flag
837: ,p_current_employee_flag_o
838: => per_per_shd.g_old_rec.current_employee_flag
839: ,p_date_employee_data_verifie_o
840: => per_per_shd.g_old_rec.date_employee_data_verified
841: ,p_date_of_birth_o
842: => per_per_shd.g_old_rec.date_of_birth
843: ,p_email_address_o
844: => per_per_shd.g_old_rec.email_address
838: => per_per_shd.g_old_rec.current_employee_flag
839: ,p_date_employee_data_verifie_o
840: => per_per_shd.g_old_rec.date_employee_data_verified
841: ,p_date_of_birth_o
842: => per_per_shd.g_old_rec.date_of_birth
843: ,p_email_address_o
844: => per_per_shd.g_old_rec.email_address
845: ,p_employee_number_o
846: => per_per_shd.g_old_rec.employee_number
840: => per_per_shd.g_old_rec.date_employee_data_verified
841: ,p_date_of_birth_o
842: => per_per_shd.g_old_rec.date_of_birth
843: ,p_email_address_o
844: => per_per_shd.g_old_rec.email_address
845: ,p_employee_number_o
846: => per_per_shd.g_old_rec.employee_number
847: ,p_expense_check_send_to_addr_o
848: => per_per_shd.g_old_rec.expense_check_send_to_address
842: => per_per_shd.g_old_rec.date_of_birth
843: ,p_email_address_o
844: => per_per_shd.g_old_rec.email_address
845: ,p_employee_number_o
846: => per_per_shd.g_old_rec.employee_number
847: ,p_expense_check_send_to_addr_o
848: => per_per_shd.g_old_rec.expense_check_send_to_address
849: ,p_first_name_o
850: => per_per_shd.g_old_rec.first_name
844: => per_per_shd.g_old_rec.email_address
845: ,p_employee_number_o
846: => per_per_shd.g_old_rec.employee_number
847: ,p_expense_check_send_to_addr_o
848: => per_per_shd.g_old_rec.expense_check_send_to_address
849: ,p_first_name_o
850: => per_per_shd.g_old_rec.first_name
851: ,p_full_name_o
852: => per_per_shd.g_old_rec.full_name
846: => per_per_shd.g_old_rec.employee_number
847: ,p_expense_check_send_to_addr_o
848: => per_per_shd.g_old_rec.expense_check_send_to_address
849: ,p_first_name_o
850: => per_per_shd.g_old_rec.first_name
851: ,p_full_name_o
852: => per_per_shd.g_old_rec.full_name
853: ,p_known_as_o
854: => per_per_shd.g_old_rec.known_as
848: => per_per_shd.g_old_rec.expense_check_send_to_address
849: ,p_first_name_o
850: => per_per_shd.g_old_rec.first_name
851: ,p_full_name_o
852: => per_per_shd.g_old_rec.full_name
853: ,p_known_as_o
854: => per_per_shd.g_old_rec.known_as
855: ,p_marital_status_o
856: => per_per_shd.g_old_rec.marital_status
850: => per_per_shd.g_old_rec.first_name
851: ,p_full_name_o
852: => per_per_shd.g_old_rec.full_name
853: ,p_known_as_o
854: => per_per_shd.g_old_rec.known_as
855: ,p_marital_status_o
856: => per_per_shd.g_old_rec.marital_status
857: ,p_middle_names_o
858: => per_per_shd.g_old_rec.middle_names
852: => per_per_shd.g_old_rec.full_name
853: ,p_known_as_o
854: => per_per_shd.g_old_rec.known_as
855: ,p_marital_status_o
856: => per_per_shd.g_old_rec.marital_status
857: ,p_middle_names_o
858: => per_per_shd.g_old_rec.middle_names
859: ,p_nationality_o
860: => per_per_shd.g_old_rec.nationality
854: => per_per_shd.g_old_rec.known_as
855: ,p_marital_status_o
856: => per_per_shd.g_old_rec.marital_status
857: ,p_middle_names_o
858: => per_per_shd.g_old_rec.middle_names
859: ,p_nationality_o
860: => per_per_shd.g_old_rec.nationality
861: ,p_national_identifier_o
862: => per_per_shd.g_old_rec.national_identifier
856: => per_per_shd.g_old_rec.marital_status
857: ,p_middle_names_o
858: => per_per_shd.g_old_rec.middle_names
859: ,p_nationality_o
860: => per_per_shd.g_old_rec.nationality
861: ,p_national_identifier_o
862: => per_per_shd.g_old_rec.national_identifier
863: ,p_previous_last_name_o
864: => per_per_shd.g_old_rec.previous_last_name
858: => per_per_shd.g_old_rec.middle_names
859: ,p_nationality_o
860: => per_per_shd.g_old_rec.nationality
861: ,p_national_identifier_o
862: => per_per_shd.g_old_rec.national_identifier
863: ,p_previous_last_name_o
864: => per_per_shd.g_old_rec.previous_last_name
865: ,p_registered_disabled_flag_o
866: => per_per_shd.g_old_rec.registered_disabled_flag
860: => per_per_shd.g_old_rec.nationality
861: ,p_national_identifier_o
862: => per_per_shd.g_old_rec.national_identifier
863: ,p_previous_last_name_o
864: => per_per_shd.g_old_rec.previous_last_name
865: ,p_registered_disabled_flag_o
866: => per_per_shd.g_old_rec.registered_disabled_flag
867: ,p_sex_o
868: => per_per_shd.g_old_rec.sex
862: => per_per_shd.g_old_rec.national_identifier
863: ,p_previous_last_name_o
864: => per_per_shd.g_old_rec.previous_last_name
865: ,p_registered_disabled_flag_o
866: => per_per_shd.g_old_rec.registered_disabled_flag
867: ,p_sex_o
868: => per_per_shd.g_old_rec.sex
869: ,p_title_o
870: => per_per_shd.g_old_rec.title
864: => per_per_shd.g_old_rec.previous_last_name
865: ,p_registered_disabled_flag_o
866: => per_per_shd.g_old_rec.registered_disabled_flag
867: ,p_sex_o
868: => per_per_shd.g_old_rec.sex
869: ,p_title_o
870: => per_per_shd.g_old_rec.title
871: ,p_vendor_id_o
872: => per_per_shd.g_old_rec.vendor_id
866: => per_per_shd.g_old_rec.registered_disabled_flag
867: ,p_sex_o
868: => per_per_shd.g_old_rec.sex
869: ,p_title_o
870: => per_per_shd.g_old_rec.title
871: ,p_vendor_id_o
872: => per_per_shd.g_old_rec.vendor_id
873: ,p_work_telephone_o
874: => per_per_shd.g_old_rec.work_telephone
868: => per_per_shd.g_old_rec.sex
869: ,p_title_o
870: => per_per_shd.g_old_rec.title
871: ,p_vendor_id_o
872: => per_per_shd.g_old_rec.vendor_id
873: ,p_work_telephone_o
874: => per_per_shd.g_old_rec.work_telephone
875: ,p_request_id_o
876: => per_per_shd.g_old_rec.request_id
870: => per_per_shd.g_old_rec.title
871: ,p_vendor_id_o
872: => per_per_shd.g_old_rec.vendor_id
873: ,p_work_telephone_o
874: => per_per_shd.g_old_rec.work_telephone
875: ,p_request_id_o
876: => per_per_shd.g_old_rec.request_id
877: ,p_program_application_id_o
878: => per_per_shd.g_old_rec.program_application_id
872: => per_per_shd.g_old_rec.vendor_id
873: ,p_work_telephone_o
874: => per_per_shd.g_old_rec.work_telephone
875: ,p_request_id_o
876: => per_per_shd.g_old_rec.request_id
877: ,p_program_application_id_o
878: => per_per_shd.g_old_rec.program_application_id
879: ,p_program_id_o
880: => per_per_shd.g_old_rec.program_id
874: => per_per_shd.g_old_rec.work_telephone
875: ,p_request_id_o
876: => per_per_shd.g_old_rec.request_id
877: ,p_program_application_id_o
878: => per_per_shd.g_old_rec.program_application_id
879: ,p_program_id_o
880: => per_per_shd.g_old_rec.program_id
881: ,p_program_update_date_o
882: => per_per_shd.g_old_rec.program_update_date
876: => per_per_shd.g_old_rec.request_id
877: ,p_program_application_id_o
878: => per_per_shd.g_old_rec.program_application_id
879: ,p_program_id_o
880: => per_per_shd.g_old_rec.program_id
881: ,p_program_update_date_o
882: => per_per_shd.g_old_rec.program_update_date
883: ,p_attribute_category_o
884: => per_per_shd.g_old_rec.attribute_category
878: => per_per_shd.g_old_rec.program_application_id
879: ,p_program_id_o
880: => per_per_shd.g_old_rec.program_id
881: ,p_program_update_date_o
882: => per_per_shd.g_old_rec.program_update_date
883: ,p_attribute_category_o
884: => per_per_shd.g_old_rec.attribute_category
885: ,p_attribute1_o
886: => per_per_shd.g_old_rec.attribute1
880: => per_per_shd.g_old_rec.program_id
881: ,p_program_update_date_o
882: => per_per_shd.g_old_rec.program_update_date
883: ,p_attribute_category_o
884: => per_per_shd.g_old_rec.attribute_category
885: ,p_attribute1_o
886: => per_per_shd.g_old_rec.attribute1
887: ,p_attribute2_o
888: => per_per_shd.g_old_rec.attribute2
882: => per_per_shd.g_old_rec.program_update_date
883: ,p_attribute_category_o
884: => per_per_shd.g_old_rec.attribute_category
885: ,p_attribute1_o
886: => per_per_shd.g_old_rec.attribute1
887: ,p_attribute2_o
888: => per_per_shd.g_old_rec.attribute2
889: ,p_attribute3_o
890: => per_per_shd.g_old_rec.attribute3
884: => per_per_shd.g_old_rec.attribute_category
885: ,p_attribute1_o
886: => per_per_shd.g_old_rec.attribute1
887: ,p_attribute2_o
888: => per_per_shd.g_old_rec.attribute2
889: ,p_attribute3_o
890: => per_per_shd.g_old_rec.attribute3
891: ,p_attribute4_o
892: => per_per_shd.g_old_rec.attribute4
886: => per_per_shd.g_old_rec.attribute1
887: ,p_attribute2_o
888: => per_per_shd.g_old_rec.attribute2
889: ,p_attribute3_o
890: => per_per_shd.g_old_rec.attribute3
891: ,p_attribute4_o
892: => per_per_shd.g_old_rec.attribute4
893: ,p_attribute5_o
894: => per_per_shd.g_old_rec.attribute5
888: => per_per_shd.g_old_rec.attribute2
889: ,p_attribute3_o
890: => per_per_shd.g_old_rec.attribute3
891: ,p_attribute4_o
892: => per_per_shd.g_old_rec.attribute4
893: ,p_attribute5_o
894: => per_per_shd.g_old_rec.attribute5
895: ,p_attribute6_o
896: => per_per_shd.g_old_rec.attribute6
890: => per_per_shd.g_old_rec.attribute3
891: ,p_attribute4_o
892: => per_per_shd.g_old_rec.attribute4
893: ,p_attribute5_o
894: => per_per_shd.g_old_rec.attribute5
895: ,p_attribute6_o
896: => per_per_shd.g_old_rec.attribute6
897: ,p_attribute7_o
898: => per_per_shd.g_old_rec.attribute7
892: => per_per_shd.g_old_rec.attribute4
893: ,p_attribute5_o
894: => per_per_shd.g_old_rec.attribute5
895: ,p_attribute6_o
896: => per_per_shd.g_old_rec.attribute6
897: ,p_attribute7_o
898: => per_per_shd.g_old_rec.attribute7
899: ,p_attribute8_o
900: => per_per_shd.g_old_rec.attribute8
894: => per_per_shd.g_old_rec.attribute5
895: ,p_attribute6_o
896: => per_per_shd.g_old_rec.attribute6
897: ,p_attribute7_o
898: => per_per_shd.g_old_rec.attribute7
899: ,p_attribute8_o
900: => per_per_shd.g_old_rec.attribute8
901: ,p_attribute9_o
902: => per_per_shd.g_old_rec.attribute9
896: => per_per_shd.g_old_rec.attribute6
897: ,p_attribute7_o
898: => per_per_shd.g_old_rec.attribute7
899: ,p_attribute8_o
900: => per_per_shd.g_old_rec.attribute8
901: ,p_attribute9_o
902: => per_per_shd.g_old_rec.attribute9
903: ,p_attribute10_o
904: => per_per_shd.g_old_rec.attribute10
898: => per_per_shd.g_old_rec.attribute7
899: ,p_attribute8_o
900: => per_per_shd.g_old_rec.attribute8
901: ,p_attribute9_o
902: => per_per_shd.g_old_rec.attribute9
903: ,p_attribute10_o
904: => per_per_shd.g_old_rec.attribute10
905: ,p_attribute11_o
906: => per_per_shd.g_old_rec.attribute11
900: => per_per_shd.g_old_rec.attribute8
901: ,p_attribute9_o
902: => per_per_shd.g_old_rec.attribute9
903: ,p_attribute10_o
904: => per_per_shd.g_old_rec.attribute10
905: ,p_attribute11_o
906: => per_per_shd.g_old_rec.attribute11
907: ,p_attribute12_o
908: => per_per_shd.g_old_rec.attribute12
902: => per_per_shd.g_old_rec.attribute9
903: ,p_attribute10_o
904: => per_per_shd.g_old_rec.attribute10
905: ,p_attribute11_o
906: => per_per_shd.g_old_rec.attribute11
907: ,p_attribute12_o
908: => per_per_shd.g_old_rec.attribute12
909: ,p_attribute13_o
910: => per_per_shd.g_old_rec.attribute13
904: => per_per_shd.g_old_rec.attribute10
905: ,p_attribute11_o
906: => per_per_shd.g_old_rec.attribute11
907: ,p_attribute12_o
908: => per_per_shd.g_old_rec.attribute12
909: ,p_attribute13_o
910: => per_per_shd.g_old_rec.attribute13
911: ,p_attribute14_o
912: => per_per_shd.g_old_rec.attribute14
906: => per_per_shd.g_old_rec.attribute11
907: ,p_attribute12_o
908: => per_per_shd.g_old_rec.attribute12
909: ,p_attribute13_o
910: => per_per_shd.g_old_rec.attribute13
911: ,p_attribute14_o
912: => per_per_shd.g_old_rec.attribute14
913: ,p_attribute15_o
914: => per_per_shd.g_old_rec.attribute15
908: => per_per_shd.g_old_rec.attribute12
909: ,p_attribute13_o
910: => per_per_shd.g_old_rec.attribute13
911: ,p_attribute14_o
912: => per_per_shd.g_old_rec.attribute14
913: ,p_attribute15_o
914: => per_per_shd.g_old_rec.attribute15
915: ,p_attribute16_o
916: => per_per_shd.g_old_rec.attribute16
910: => per_per_shd.g_old_rec.attribute13
911: ,p_attribute14_o
912: => per_per_shd.g_old_rec.attribute14
913: ,p_attribute15_o
914: => per_per_shd.g_old_rec.attribute15
915: ,p_attribute16_o
916: => per_per_shd.g_old_rec.attribute16
917: ,p_attribute17_o
918: => per_per_shd.g_old_rec.attribute17
912: => per_per_shd.g_old_rec.attribute14
913: ,p_attribute15_o
914: => per_per_shd.g_old_rec.attribute15
915: ,p_attribute16_o
916: => per_per_shd.g_old_rec.attribute16
917: ,p_attribute17_o
918: => per_per_shd.g_old_rec.attribute17
919: ,p_attribute18_o
920: => per_per_shd.g_old_rec.attribute18
914: => per_per_shd.g_old_rec.attribute15
915: ,p_attribute16_o
916: => per_per_shd.g_old_rec.attribute16
917: ,p_attribute17_o
918: => per_per_shd.g_old_rec.attribute17
919: ,p_attribute18_o
920: => per_per_shd.g_old_rec.attribute18
921: ,p_attribute19_o
922: => per_per_shd.g_old_rec.attribute19
916: => per_per_shd.g_old_rec.attribute16
917: ,p_attribute17_o
918: => per_per_shd.g_old_rec.attribute17
919: ,p_attribute18_o
920: => per_per_shd.g_old_rec.attribute18
921: ,p_attribute19_o
922: => per_per_shd.g_old_rec.attribute19
923: ,p_attribute20_o
924: => per_per_shd.g_old_rec.attribute20
918: => per_per_shd.g_old_rec.attribute17
919: ,p_attribute18_o
920: => per_per_shd.g_old_rec.attribute18
921: ,p_attribute19_o
922: => per_per_shd.g_old_rec.attribute19
923: ,p_attribute20_o
924: => per_per_shd.g_old_rec.attribute20
925: ,p_attribute21_o
926: => per_per_shd.g_old_rec.attribute21
920: => per_per_shd.g_old_rec.attribute18
921: ,p_attribute19_o
922: => per_per_shd.g_old_rec.attribute19
923: ,p_attribute20_o
924: => per_per_shd.g_old_rec.attribute20
925: ,p_attribute21_o
926: => per_per_shd.g_old_rec.attribute21
927: ,p_attribute22_o
928: => per_per_shd.g_old_rec.attribute22
922: => per_per_shd.g_old_rec.attribute19
923: ,p_attribute20_o
924: => per_per_shd.g_old_rec.attribute20
925: ,p_attribute21_o
926: => per_per_shd.g_old_rec.attribute21
927: ,p_attribute22_o
928: => per_per_shd.g_old_rec.attribute22
929: ,p_attribute23_o
930: => per_per_shd.g_old_rec.attribute23
924: => per_per_shd.g_old_rec.attribute20
925: ,p_attribute21_o
926: => per_per_shd.g_old_rec.attribute21
927: ,p_attribute22_o
928: => per_per_shd.g_old_rec.attribute22
929: ,p_attribute23_o
930: => per_per_shd.g_old_rec.attribute23
931: ,p_attribute24_o
932: => per_per_shd.g_old_rec.attribute24
926: => per_per_shd.g_old_rec.attribute21
927: ,p_attribute22_o
928: => per_per_shd.g_old_rec.attribute22
929: ,p_attribute23_o
930: => per_per_shd.g_old_rec.attribute23
931: ,p_attribute24_o
932: => per_per_shd.g_old_rec.attribute24
933: ,p_attribute25_o
934: => per_per_shd.g_old_rec.attribute25
928: => per_per_shd.g_old_rec.attribute22
929: ,p_attribute23_o
930: => per_per_shd.g_old_rec.attribute23
931: ,p_attribute24_o
932: => per_per_shd.g_old_rec.attribute24
933: ,p_attribute25_o
934: => per_per_shd.g_old_rec.attribute25
935: ,p_attribute26_o
936: => per_per_shd.g_old_rec.attribute26
930: => per_per_shd.g_old_rec.attribute23
931: ,p_attribute24_o
932: => per_per_shd.g_old_rec.attribute24
933: ,p_attribute25_o
934: => per_per_shd.g_old_rec.attribute25
935: ,p_attribute26_o
936: => per_per_shd.g_old_rec.attribute26
937: ,p_attribute27_o
938: => per_per_shd.g_old_rec.attribute27
932: => per_per_shd.g_old_rec.attribute24
933: ,p_attribute25_o
934: => per_per_shd.g_old_rec.attribute25
935: ,p_attribute26_o
936: => per_per_shd.g_old_rec.attribute26
937: ,p_attribute27_o
938: => per_per_shd.g_old_rec.attribute27
939: ,p_attribute28_o
940: => per_per_shd.g_old_rec.attribute28
934: => per_per_shd.g_old_rec.attribute25
935: ,p_attribute26_o
936: => per_per_shd.g_old_rec.attribute26
937: ,p_attribute27_o
938: => per_per_shd.g_old_rec.attribute27
939: ,p_attribute28_o
940: => per_per_shd.g_old_rec.attribute28
941: ,p_attribute29_o
942: => per_per_shd.g_old_rec.attribute29
936: => per_per_shd.g_old_rec.attribute26
937: ,p_attribute27_o
938: => per_per_shd.g_old_rec.attribute27
939: ,p_attribute28_o
940: => per_per_shd.g_old_rec.attribute28
941: ,p_attribute29_o
942: => per_per_shd.g_old_rec.attribute29
943: ,p_attribute30_o
944: => per_per_shd.g_old_rec.attribute30
938: => per_per_shd.g_old_rec.attribute27
939: ,p_attribute28_o
940: => per_per_shd.g_old_rec.attribute28
941: ,p_attribute29_o
942: => per_per_shd.g_old_rec.attribute29
943: ,p_attribute30_o
944: => per_per_shd.g_old_rec.attribute30
945: ,p_per_information_category_o
946: => per_per_shd.g_old_rec.per_information_category
940: => per_per_shd.g_old_rec.attribute28
941: ,p_attribute29_o
942: => per_per_shd.g_old_rec.attribute29
943: ,p_attribute30_o
944: => per_per_shd.g_old_rec.attribute30
945: ,p_per_information_category_o
946: => per_per_shd.g_old_rec.per_information_category
947: ,p_per_information1_o
948: => per_per_shd.g_old_rec.per_information1
942: => per_per_shd.g_old_rec.attribute29
943: ,p_attribute30_o
944: => per_per_shd.g_old_rec.attribute30
945: ,p_per_information_category_o
946: => per_per_shd.g_old_rec.per_information_category
947: ,p_per_information1_o
948: => per_per_shd.g_old_rec.per_information1
949: ,p_per_information2_o
950: => per_per_shd.g_old_rec.per_information2
944: => per_per_shd.g_old_rec.attribute30
945: ,p_per_information_category_o
946: => per_per_shd.g_old_rec.per_information_category
947: ,p_per_information1_o
948: => per_per_shd.g_old_rec.per_information1
949: ,p_per_information2_o
950: => per_per_shd.g_old_rec.per_information2
951: ,p_per_information3_o
952: => per_per_shd.g_old_rec.per_information3
946: => per_per_shd.g_old_rec.per_information_category
947: ,p_per_information1_o
948: => per_per_shd.g_old_rec.per_information1
949: ,p_per_information2_o
950: => per_per_shd.g_old_rec.per_information2
951: ,p_per_information3_o
952: => per_per_shd.g_old_rec.per_information3
953: ,p_per_information4_o
954: => per_per_shd.g_old_rec.per_information4
948: => per_per_shd.g_old_rec.per_information1
949: ,p_per_information2_o
950: => per_per_shd.g_old_rec.per_information2
951: ,p_per_information3_o
952: => per_per_shd.g_old_rec.per_information3
953: ,p_per_information4_o
954: => per_per_shd.g_old_rec.per_information4
955: ,p_per_information5_o
956: => per_per_shd.g_old_rec.per_information5
950: => per_per_shd.g_old_rec.per_information2
951: ,p_per_information3_o
952: => per_per_shd.g_old_rec.per_information3
953: ,p_per_information4_o
954: => per_per_shd.g_old_rec.per_information4
955: ,p_per_information5_o
956: => per_per_shd.g_old_rec.per_information5
957: ,p_per_information6_o
958: => per_per_shd.g_old_rec.per_information6
952: => per_per_shd.g_old_rec.per_information3
953: ,p_per_information4_o
954: => per_per_shd.g_old_rec.per_information4
955: ,p_per_information5_o
956: => per_per_shd.g_old_rec.per_information5
957: ,p_per_information6_o
958: => per_per_shd.g_old_rec.per_information6
959: ,p_per_information7_o
960: => per_per_shd.g_old_rec.per_information7
954: => per_per_shd.g_old_rec.per_information4
955: ,p_per_information5_o
956: => per_per_shd.g_old_rec.per_information5
957: ,p_per_information6_o
958: => per_per_shd.g_old_rec.per_information6
959: ,p_per_information7_o
960: => per_per_shd.g_old_rec.per_information7
961: ,p_per_information8_o
962: => per_per_shd.g_old_rec.per_information8
956: => per_per_shd.g_old_rec.per_information5
957: ,p_per_information6_o
958: => per_per_shd.g_old_rec.per_information6
959: ,p_per_information7_o
960: => per_per_shd.g_old_rec.per_information7
961: ,p_per_information8_o
962: => per_per_shd.g_old_rec.per_information8
963: ,p_per_information9_o
964: => per_per_shd.g_old_rec.per_information9
958: => per_per_shd.g_old_rec.per_information6
959: ,p_per_information7_o
960: => per_per_shd.g_old_rec.per_information7
961: ,p_per_information8_o
962: => per_per_shd.g_old_rec.per_information8
963: ,p_per_information9_o
964: => per_per_shd.g_old_rec.per_information9
965: ,p_per_information10_o
966: => per_per_shd.g_old_rec.per_information10
960: => per_per_shd.g_old_rec.per_information7
961: ,p_per_information8_o
962: => per_per_shd.g_old_rec.per_information8
963: ,p_per_information9_o
964: => per_per_shd.g_old_rec.per_information9
965: ,p_per_information10_o
966: => per_per_shd.g_old_rec.per_information10
967: ,p_per_information11_o
968: => per_per_shd.g_old_rec.per_information11
962: => per_per_shd.g_old_rec.per_information8
963: ,p_per_information9_o
964: => per_per_shd.g_old_rec.per_information9
965: ,p_per_information10_o
966: => per_per_shd.g_old_rec.per_information10
967: ,p_per_information11_o
968: => per_per_shd.g_old_rec.per_information11
969: ,p_per_information12_o
970: => per_per_shd.g_old_rec.per_information12
964: => per_per_shd.g_old_rec.per_information9
965: ,p_per_information10_o
966: => per_per_shd.g_old_rec.per_information10
967: ,p_per_information11_o
968: => per_per_shd.g_old_rec.per_information11
969: ,p_per_information12_o
970: => per_per_shd.g_old_rec.per_information12
971: ,p_per_information13_o
972: => per_per_shd.g_old_rec.per_information13
966: => per_per_shd.g_old_rec.per_information10
967: ,p_per_information11_o
968: => per_per_shd.g_old_rec.per_information11
969: ,p_per_information12_o
970: => per_per_shd.g_old_rec.per_information12
971: ,p_per_information13_o
972: => per_per_shd.g_old_rec.per_information13
973: ,p_per_information14_o
974: => per_per_shd.g_old_rec.per_information14
968: => per_per_shd.g_old_rec.per_information11
969: ,p_per_information12_o
970: => per_per_shd.g_old_rec.per_information12
971: ,p_per_information13_o
972: => per_per_shd.g_old_rec.per_information13
973: ,p_per_information14_o
974: => per_per_shd.g_old_rec.per_information14
975: ,p_per_information15_o
976: => per_per_shd.g_old_rec.per_information15
970: => per_per_shd.g_old_rec.per_information12
971: ,p_per_information13_o
972: => per_per_shd.g_old_rec.per_information13
973: ,p_per_information14_o
974: => per_per_shd.g_old_rec.per_information14
975: ,p_per_information15_o
976: => per_per_shd.g_old_rec.per_information15
977: ,p_per_information16_o
978: => per_per_shd.g_old_rec.per_information16
972: => per_per_shd.g_old_rec.per_information13
973: ,p_per_information14_o
974: => per_per_shd.g_old_rec.per_information14
975: ,p_per_information15_o
976: => per_per_shd.g_old_rec.per_information15
977: ,p_per_information16_o
978: => per_per_shd.g_old_rec.per_information16
979: ,p_per_information17_o
980: => per_per_shd.g_old_rec.per_information17
974: => per_per_shd.g_old_rec.per_information14
975: ,p_per_information15_o
976: => per_per_shd.g_old_rec.per_information15
977: ,p_per_information16_o
978: => per_per_shd.g_old_rec.per_information16
979: ,p_per_information17_o
980: => per_per_shd.g_old_rec.per_information17
981: ,p_per_information18_o
982: => per_per_shd.g_old_rec.per_information18
976: => per_per_shd.g_old_rec.per_information15
977: ,p_per_information16_o
978: => per_per_shd.g_old_rec.per_information16
979: ,p_per_information17_o
980: => per_per_shd.g_old_rec.per_information17
981: ,p_per_information18_o
982: => per_per_shd.g_old_rec.per_information18
983: ,p_per_information19_o
984: => per_per_shd.g_old_rec.per_information19
978: => per_per_shd.g_old_rec.per_information16
979: ,p_per_information17_o
980: => per_per_shd.g_old_rec.per_information17
981: ,p_per_information18_o
982: => per_per_shd.g_old_rec.per_information18
983: ,p_per_information19_o
984: => per_per_shd.g_old_rec.per_information19
985: ,p_per_information20_o
986: => per_per_shd.g_old_rec.per_information20
980: => per_per_shd.g_old_rec.per_information17
981: ,p_per_information18_o
982: => per_per_shd.g_old_rec.per_information18
983: ,p_per_information19_o
984: => per_per_shd.g_old_rec.per_information19
985: ,p_per_information20_o
986: => per_per_shd.g_old_rec.per_information20
987: ,p_suffix_o
988: => per_per_shd.g_old_rec.suffix
982: => per_per_shd.g_old_rec.per_information18
983: ,p_per_information19_o
984: => per_per_shd.g_old_rec.per_information19
985: ,p_per_information20_o
986: => per_per_shd.g_old_rec.per_information20
987: ,p_suffix_o
988: => per_per_shd.g_old_rec.suffix
989: ,p_DATE_OF_DEATH_o
990: => per_per_shd.g_old_rec.DATE_OF_DEATH
984: => per_per_shd.g_old_rec.per_information19
985: ,p_per_information20_o
986: => per_per_shd.g_old_rec.per_information20
987: ,p_suffix_o
988: => per_per_shd.g_old_rec.suffix
989: ,p_DATE_OF_DEATH_o
990: => per_per_shd.g_old_rec.DATE_OF_DEATH
991: ,p_BACKGROUND_CHECK_STATUS_o
992: => per_per_shd.g_old_rec.BACKGROUND_CHECK_STATUS
986: => per_per_shd.g_old_rec.per_information20
987: ,p_suffix_o
988: => per_per_shd.g_old_rec.suffix
989: ,p_DATE_OF_DEATH_o
990: => per_per_shd.g_old_rec.DATE_OF_DEATH
991: ,p_BACKGROUND_CHECK_STATUS_o
992: => per_per_shd.g_old_rec.BACKGROUND_CHECK_STATUS
993: ,p_BACKGROUND_DATE_CHECK_o
994: => per_per_shd.g_old_rec.BACKGROUND_DATE_CHECK
988: => per_per_shd.g_old_rec.suffix
989: ,p_DATE_OF_DEATH_o
990: => per_per_shd.g_old_rec.DATE_OF_DEATH
991: ,p_BACKGROUND_CHECK_STATUS_o
992: => per_per_shd.g_old_rec.BACKGROUND_CHECK_STATUS
993: ,p_BACKGROUND_DATE_CHECK_o
994: => per_per_shd.g_old_rec.BACKGROUND_DATE_CHECK
995: ,p_BLOOD_TYPE_o
996: => per_per_shd.g_old_rec.BLOOD_TYPE
990: => per_per_shd.g_old_rec.DATE_OF_DEATH
991: ,p_BACKGROUND_CHECK_STATUS_o
992: => per_per_shd.g_old_rec.BACKGROUND_CHECK_STATUS
993: ,p_BACKGROUND_DATE_CHECK_o
994: => per_per_shd.g_old_rec.BACKGROUND_DATE_CHECK
995: ,p_BLOOD_TYPE_o
996: => per_per_shd.g_old_rec.BLOOD_TYPE
997: ,p_CORRESPONDENCE_LANGUAGE_o
998: => per_per_shd.g_old_rec.CORRESPONDENCE_LANGUAGE
992: => per_per_shd.g_old_rec.BACKGROUND_CHECK_STATUS
993: ,p_BACKGROUND_DATE_CHECK_o
994: => per_per_shd.g_old_rec.BACKGROUND_DATE_CHECK
995: ,p_BLOOD_TYPE_o
996: => per_per_shd.g_old_rec.BLOOD_TYPE
997: ,p_CORRESPONDENCE_LANGUAGE_o
998: => per_per_shd.g_old_rec.CORRESPONDENCE_LANGUAGE
999: ,p_FAST_PATH_EMPLOYEE_o
1000: => per_per_shd.g_old_rec.FAST_PATH_EMPLOYEE
994: => per_per_shd.g_old_rec.BACKGROUND_DATE_CHECK
995: ,p_BLOOD_TYPE_o
996: => per_per_shd.g_old_rec.BLOOD_TYPE
997: ,p_CORRESPONDENCE_LANGUAGE_o
998: => per_per_shd.g_old_rec.CORRESPONDENCE_LANGUAGE
999: ,p_FAST_PATH_EMPLOYEE_o
1000: => per_per_shd.g_old_rec.FAST_PATH_EMPLOYEE
1001: ,p_FTE_CAPACITY_o
1002: => per_per_shd.g_old_rec.FTE_CAPACITY
996: => per_per_shd.g_old_rec.BLOOD_TYPE
997: ,p_CORRESPONDENCE_LANGUAGE_o
998: => per_per_shd.g_old_rec.CORRESPONDENCE_LANGUAGE
999: ,p_FAST_PATH_EMPLOYEE_o
1000: => per_per_shd.g_old_rec.FAST_PATH_EMPLOYEE
1001: ,p_FTE_CAPACITY_o
1002: => per_per_shd.g_old_rec.FTE_CAPACITY
1003: ,p_HOLD_APPLICANT_DATE_UNTIL_o
1004: => per_per_shd.g_old_rec.HOLD_APPLICANT_DATE_UNTIL
998: => per_per_shd.g_old_rec.CORRESPONDENCE_LANGUAGE
999: ,p_FAST_PATH_EMPLOYEE_o
1000: => per_per_shd.g_old_rec.FAST_PATH_EMPLOYEE
1001: ,p_FTE_CAPACITY_o
1002: => per_per_shd.g_old_rec.FTE_CAPACITY
1003: ,p_HOLD_APPLICANT_DATE_UNTIL_o
1004: => per_per_shd.g_old_rec.HOLD_APPLICANT_DATE_UNTIL
1005: ,p_HONORS_o
1006: => per_per_shd.g_old_rec.HONORS
1000: => per_per_shd.g_old_rec.FAST_PATH_EMPLOYEE
1001: ,p_FTE_CAPACITY_o
1002: => per_per_shd.g_old_rec.FTE_CAPACITY
1003: ,p_HOLD_APPLICANT_DATE_UNTIL_o
1004: => per_per_shd.g_old_rec.HOLD_APPLICANT_DATE_UNTIL
1005: ,p_HONORS_o
1006: => per_per_shd.g_old_rec.HONORS
1007: ,p_INTERNAL_LOCATION_o
1008: => per_per_shd.g_old_rec.INTERNAL_LOCATION
1002: => per_per_shd.g_old_rec.FTE_CAPACITY
1003: ,p_HOLD_APPLICANT_DATE_UNTIL_o
1004: => per_per_shd.g_old_rec.HOLD_APPLICANT_DATE_UNTIL
1005: ,p_HONORS_o
1006: => per_per_shd.g_old_rec.HONORS
1007: ,p_INTERNAL_LOCATION_o
1008: => per_per_shd.g_old_rec.INTERNAL_LOCATION
1009: ,p_LAST_MEDICAL_TEST_BY_o
1010: => per_per_shd.g_old_rec.LAST_MEDICAL_TEST_BY
1004: => per_per_shd.g_old_rec.HOLD_APPLICANT_DATE_UNTIL
1005: ,p_HONORS_o
1006: => per_per_shd.g_old_rec.HONORS
1007: ,p_INTERNAL_LOCATION_o
1008: => per_per_shd.g_old_rec.INTERNAL_LOCATION
1009: ,p_LAST_MEDICAL_TEST_BY_o
1010: => per_per_shd.g_old_rec.LAST_MEDICAL_TEST_BY
1011: ,p_LAST_MEDICAL_TEST_DATE_o
1012: => per_per_shd.g_old_rec.LAST_MEDICAL_TEST_DATE
1006: => per_per_shd.g_old_rec.HONORS
1007: ,p_INTERNAL_LOCATION_o
1008: => per_per_shd.g_old_rec.INTERNAL_LOCATION
1009: ,p_LAST_MEDICAL_TEST_BY_o
1010: => per_per_shd.g_old_rec.LAST_MEDICAL_TEST_BY
1011: ,p_LAST_MEDICAL_TEST_DATE_o
1012: => per_per_shd.g_old_rec.LAST_MEDICAL_TEST_DATE
1013: ,p_MAILSTOP_o
1014: => per_per_shd.g_old_rec.MAILSTOP
1008: => per_per_shd.g_old_rec.INTERNAL_LOCATION
1009: ,p_LAST_MEDICAL_TEST_BY_o
1010: => per_per_shd.g_old_rec.LAST_MEDICAL_TEST_BY
1011: ,p_LAST_MEDICAL_TEST_DATE_o
1012: => per_per_shd.g_old_rec.LAST_MEDICAL_TEST_DATE
1013: ,p_MAILSTOP_o
1014: => per_per_shd.g_old_rec.MAILSTOP
1015: ,p_OFFICE_NUMBER_o
1016: => per_per_shd.g_old_rec.OFFICE_NUMBER
1010: => per_per_shd.g_old_rec.LAST_MEDICAL_TEST_BY
1011: ,p_LAST_MEDICAL_TEST_DATE_o
1012: => per_per_shd.g_old_rec.LAST_MEDICAL_TEST_DATE
1013: ,p_MAILSTOP_o
1014: => per_per_shd.g_old_rec.MAILSTOP
1015: ,p_OFFICE_NUMBER_o
1016: => per_per_shd.g_old_rec.OFFICE_NUMBER
1017: ,p_ON_MILITARY_SERVICE_o
1018: => per_per_shd.g_old_rec.ON_MILITARY_SERVICE
1012: => per_per_shd.g_old_rec.LAST_MEDICAL_TEST_DATE
1013: ,p_MAILSTOP_o
1014: => per_per_shd.g_old_rec.MAILSTOP
1015: ,p_OFFICE_NUMBER_o
1016: => per_per_shd.g_old_rec.OFFICE_NUMBER
1017: ,p_ON_MILITARY_SERVICE_o
1018: => per_per_shd.g_old_rec.ON_MILITARY_SERVICE
1019: ,p_ORDER_NAME_o
1020: => per_per_shd.g_old_rec.ORDER_NAME
1014: => per_per_shd.g_old_rec.MAILSTOP
1015: ,p_OFFICE_NUMBER_o
1016: => per_per_shd.g_old_rec.OFFICE_NUMBER
1017: ,p_ON_MILITARY_SERVICE_o
1018: => per_per_shd.g_old_rec.ON_MILITARY_SERVICE
1019: ,p_ORDER_NAME_o
1020: => per_per_shd.g_old_rec.ORDER_NAME
1021: ,p_PRE_NAME_ADJUNCT_o
1022: => per_per_shd.g_old_rec.PRE_NAME_ADJUNCT
1016: => per_per_shd.g_old_rec.OFFICE_NUMBER
1017: ,p_ON_MILITARY_SERVICE_o
1018: => per_per_shd.g_old_rec.ON_MILITARY_SERVICE
1019: ,p_ORDER_NAME_o
1020: => per_per_shd.g_old_rec.ORDER_NAME
1021: ,p_PRE_NAME_ADJUNCT_o
1022: => per_per_shd.g_old_rec.PRE_NAME_ADJUNCT
1023: ,p_PROJECTED_START_DATE_o
1024: => per_per_shd.g_old_rec.PROJECTED_START_DATE
1018: => per_per_shd.g_old_rec.ON_MILITARY_SERVICE
1019: ,p_ORDER_NAME_o
1020: => per_per_shd.g_old_rec.ORDER_NAME
1021: ,p_PRE_NAME_ADJUNCT_o
1022: => per_per_shd.g_old_rec.PRE_NAME_ADJUNCT
1023: ,p_PROJECTED_START_DATE_o
1024: => per_per_shd.g_old_rec.PROJECTED_START_DATE
1025: ,p_REHIRE_AUTHORIZOR_o
1026: => per_per_shd.g_old_rec.REHIRE_AUTHORIZOR
1020: => per_per_shd.g_old_rec.ORDER_NAME
1021: ,p_PRE_NAME_ADJUNCT_o
1022: => per_per_shd.g_old_rec.PRE_NAME_ADJUNCT
1023: ,p_PROJECTED_START_DATE_o
1024: => per_per_shd.g_old_rec.PROJECTED_START_DATE
1025: ,p_REHIRE_AUTHORIZOR_o
1026: => per_per_shd.g_old_rec.REHIRE_AUTHORIZOR
1027: ,p_REHIRE_RECOMMENDATION_o
1028: => per_per_shd.g_old_rec.REHIRE_RECOMMENDATION
1022: => per_per_shd.g_old_rec.PRE_NAME_ADJUNCT
1023: ,p_PROJECTED_START_DATE_o
1024: => per_per_shd.g_old_rec.PROJECTED_START_DATE
1025: ,p_REHIRE_AUTHORIZOR_o
1026: => per_per_shd.g_old_rec.REHIRE_AUTHORIZOR
1027: ,p_REHIRE_RECOMMENDATION_o
1028: => per_per_shd.g_old_rec.REHIRE_RECOMMENDATION
1029: ,p_RESUME_EXISTS_o
1030: => per_per_shd.g_old_rec.RESUME_EXISTS
1024: => per_per_shd.g_old_rec.PROJECTED_START_DATE
1025: ,p_REHIRE_AUTHORIZOR_o
1026: => per_per_shd.g_old_rec.REHIRE_AUTHORIZOR
1027: ,p_REHIRE_RECOMMENDATION_o
1028: => per_per_shd.g_old_rec.REHIRE_RECOMMENDATION
1029: ,p_RESUME_EXISTS_o
1030: => per_per_shd.g_old_rec.RESUME_EXISTS
1031: ,p_RESUME_LAST_UPDATED_o
1032: => per_per_shd.g_old_rec.RESUME_LAST_UPDATED
1026: => per_per_shd.g_old_rec.REHIRE_AUTHORIZOR
1027: ,p_REHIRE_RECOMMENDATION_o
1028: => per_per_shd.g_old_rec.REHIRE_RECOMMENDATION
1029: ,p_RESUME_EXISTS_o
1030: => per_per_shd.g_old_rec.RESUME_EXISTS
1031: ,p_RESUME_LAST_UPDATED_o
1032: => per_per_shd.g_old_rec.RESUME_LAST_UPDATED
1033: ,p_SECOND_PASSPORT_EXISTS_o
1034: => per_per_shd.g_old_rec.SECOND_PASSPORT_EXISTS
1028: => per_per_shd.g_old_rec.REHIRE_RECOMMENDATION
1029: ,p_RESUME_EXISTS_o
1030: => per_per_shd.g_old_rec.RESUME_EXISTS
1031: ,p_RESUME_LAST_UPDATED_o
1032: => per_per_shd.g_old_rec.RESUME_LAST_UPDATED
1033: ,p_SECOND_PASSPORT_EXISTS_o
1034: => per_per_shd.g_old_rec.SECOND_PASSPORT_EXISTS
1035: ,p_STUDENT_STATUS_o
1036: => per_per_shd.g_old_rec.STUDENT_STATUS
1030: => per_per_shd.g_old_rec.RESUME_EXISTS
1031: ,p_RESUME_LAST_UPDATED_o
1032: => per_per_shd.g_old_rec.RESUME_LAST_UPDATED
1033: ,p_SECOND_PASSPORT_EXISTS_o
1034: => per_per_shd.g_old_rec.SECOND_PASSPORT_EXISTS
1035: ,p_STUDENT_STATUS_o
1036: => per_per_shd.g_old_rec.STUDENT_STATUS
1037: ,p_WORK_SCHEDULE_o
1038: => per_per_shd.g_old_rec.WORK_SCHEDULE
1032: => per_per_shd.g_old_rec.RESUME_LAST_UPDATED
1033: ,p_SECOND_PASSPORT_EXISTS_o
1034: => per_per_shd.g_old_rec.SECOND_PASSPORT_EXISTS
1035: ,p_STUDENT_STATUS_o
1036: => per_per_shd.g_old_rec.STUDENT_STATUS
1037: ,p_WORK_SCHEDULE_o
1038: => per_per_shd.g_old_rec.WORK_SCHEDULE
1039: ,p_PER_INFORMATION21_o
1040: => per_per_shd.g_old_rec.PER_INFORMATION21
1034: => per_per_shd.g_old_rec.SECOND_PASSPORT_EXISTS
1035: ,p_STUDENT_STATUS_o
1036: => per_per_shd.g_old_rec.STUDENT_STATUS
1037: ,p_WORK_SCHEDULE_o
1038: => per_per_shd.g_old_rec.WORK_SCHEDULE
1039: ,p_PER_INFORMATION21_o
1040: => per_per_shd.g_old_rec.PER_INFORMATION21
1041: ,p_PER_INFORMATION22_o
1042: => per_per_shd.g_old_rec.PER_INFORMATION22
1036: => per_per_shd.g_old_rec.STUDENT_STATUS
1037: ,p_WORK_SCHEDULE_o
1038: => per_per_shd.g_old_rec.WORK_SCHEDULE
1039: ,p_PER_INFORMATION21_o
1040: => per_per_shd.g_old_rec.PER_INFORMATION21
1041: ,p_PER_INFORMATION22_o
1042: => per_per_shd.g_old_rec.PER_INFORMATION22
1043: ,p_PER_INFORMATION23_o
1044: => per_per_shd.g_old_rec.PER_INFORMATION23
1038: => per_per_shd.g_old_rec.WORK_SCHEDULE
1039: ,p_PER_INFORMATION21_o
1040: => per_per_shd.g_old_rec.PER_INFORMATION21
1041: ,p_PER_INFORMATION22_o
1042: => per_per_shd.g_old_rec.PER_INFORMATION22
1043: ,p_PER_INFORMATION23_o
1044: => per_per_shd.g_old_rec.PER_INFORMATION23
1045: ,p_PER_INFORMATION24_o
1046: => per_per_shd.g_old_rec.PER_INFORMATION24
1040: => per_per_shd.g_old_rec.PER_INFORMATION21
1041: ,p_PER_INFORMATION22_o
1042: => per_per_shd.g_old_rec.PER_INFORMATION22
1043: ,p_PER_INFORMATION23_o
1044: => per_per_shd.g_old_rec.PER_INFORMATION23
1045: ,p_PER_INFORMATION24_o
1046: => per_per_shd.g_old_rec.PER_INFORMATION24
1047: ,p_PER_INFORMATION25_o
1048: => per_per_shd.g_old_rec.PER_INFORMATION25
1042: => per_per_shd.g_old_rec.PER_INFORMATION22
1043: ,p_PER_INFORMATION23_o
1044: => per_per_shd.g_old_rec.PER_INFORMATION23
1045: ,p_PER_INFORMATION24_o
1046: => per_per_shd.g_old_rec.PER_INFORMATION24
1047: ,p_PER_INFORMATION25_o
1048: => per_per_shd.g_old_rec.PER_INFORMATION25
1049: ,p_PER_INFORMATION26_o
1050: => per_per_shd.g_old_rec.PER_INFORMATION26
1044: => per_per_shd.g_old_rec.PER_INFORMATION23
1045: ,p_PER_INFORMATION24_o
1046: => per_per_shd.g_old_rec.PER_INFORMATION24
1047: ,p_PER_INFORMATION25_o
1048: => per_per_shd.g_old_rec.PER_INFORMATION25
1049: ,p_PER_INFORMATION26_o
1050: => per_per_shd.g_old_rec.PER_INFORMATION26
1051: ,p_PER_INFORMATION27_o
1052: => per_per_shd.g_old_rec.PER_INFORMATION27
1046: => per_per_shd.g_old_rec.PER_INFORMATION24
1047: ,p_PER_INFORMATION25_o
1048: => per_per_shd.g_old_rec.PER_INFORMATION25
1049: ,p_PER_INFORMATION26_o
1050: => per_per_shd.g_old_rec.PER_INFORMATION26
1051: ,p_PER_INFORMATION27_o
1052: => per_per_shd.g_old_rec.PER_INFORMATION27
1053: ,p_PER_INFORMATION28_o
1054: => per_per_shd.g_old_rec.PER_INFORMATION28
1048: => per_per_shd.g_old_rec.PER_INFORMATION25
1049: ,p_PER_INFORMATION26_o
1050: => per_per_shd.g_old_rec.PER_INFORMATION26
1051: ,p_PER_INFORMATION27_o
1052: => per_per_shd.g_old_rec.PER_INFORMATION27
1053: ,p_PER_INFORMATION28_o
1054: => per_per_shd.g_old_rec.PER_INFORMATION28
1055: ,p_PER_INFORMATION29_o
1056: => per_per_shd.g_old_rec.PER_INFORMATION29
1050: => per_per_shd.g_old_rec.PER_INFORMATION26
1051: ,p_PER_INFORMATION27_o
1052: => per_per_shd.g_old_rec.PER_INFORMATION27
1053: ,p_PER_INFORMATION28_o
1054: => per_per_shd.g_old_rec.PER_INFORMATION28
1055: ,p_PER_INFORMATION29_o
1056: => per_per_shd.g_old_rec.PER_INFORMATION29
1057: ,p_PER_INFORMATION30_o
1058: => per_per_shd.g_old_rec.PER_INFORMATION30
1052: => per_per_shd.g_old_rec.PER_INFORMATION27
1053: ,p_PER_INFORMATION28_o
1054: => per_per_shd.g_old_rec.PER_INFORMATION28
1055: ,p_PER_INFORMATION29_o
1056: => per_per_shd.g_old_rec.PER_INFORMATION29
1057: ,p_PER_INFORMATION30_o
1058: => per_per_shd.g_old_rec.PER_INFORMATION30
1059: ,p_REHIRE_REASON_o
1060: => per_per_shd.g_old_rec.REHIRE_REASON
1054: => per_per_shd.g_old_rec.PER_INFORMATION28
1055: ,p_PER_INFORMATION29_o
1056: => per_per_shd.g_old_rec.PER_INFORMATION29
1057: ,p_PER_INFORMATION30_o
1058: => per_per_shd.g_old_rec.PER_INFORMATION30
1059: ,p_REHIRE_REASON_o
1060: => per_per_shd.g_old_rec.REHIRE_REASON
1061: ,p_BENEFIT_GROUP_ID_o
1062: => per_per_shd.g_old_rec.BENEFIT_GROUP_ID
1056: => per_per_shd.g_old_rec.PER_INFORMATION29
1057: ,p_PER_INFORMATION30_o
1058: => per_per_shd.g_old_rec.PER_INFORMATION30
1059: ,p_REHIRE_REASON_o
1060: => per_per_shd.g_old_rec.REHIRE_REASON
1061: ,p_BENEFIT_GROUP_ID_o
1062: => per_per_shd.g_old_rec.BENEFIT_GROUP_ID
1063: ,p_RECEIPT_OF_DEATH_CERT_DATE_o
1064: => per_per_shd.g_old_rec.RECEIPT_OF_DEATH_CERT_DATE
1058: => per_per_shd.g_old_rec.PER_INFORMATION30
1059: ,p_REHIRE_REASON_o
1060: => per_per_shd.g_old_rec.REHIRE_REASON
1061: ,p_BENEFIT_GROUP_ID_o
1062: => per_per_shd.g_old_rec.BENEFIT_GROUP_ID
1063: ,p_RECEIPT_OF_DEATH_CERT_DATE_o
1064: => per_per_shd.g_old_rec.RECEIPT_OF_DEATH_CERT_DATE
1065: ,p_COORD_BEN_MED_PLN_NO_o
1066: => per_per_shd.g_old_rec.COORD_BEN_MED_PLN_NO
1060: => per_per_shd.g_old_rec.REHIRE_REASON
1061: ,p_BENEFIT_GROUP_ID_o
1062: => per_per_shd.g_old_rec.BENEFIT_GROUP_ID
1063: ,p_RECEIPT_OF_DEATH_CERT_DATE_o
1064: => per_per_shd.g_old_rec.RECEIPT_OF_DEATH_CERT_DATE
1065: ,p_COORD_BEN_MED_PLN_NO_o
1066: => per_per_shd.g_old_rec.COORD_BEN_MED_PLN_NO
1067: ,p_COORD_BEN_NO_CVG_FLAG_o
1068: => per_per_shd.g_old_rec.COORD_BEN_NO_CVG_FLAG
1062: => per_per_shd.g_old_rec.BENEFIT_GROUP_ID
1063: ,p_RECEIPT_OF_DEATH_CERT_DATE_o
1064: => per_per_shd.g_old_rec.RECEIPT_OF_DEATH_CERT_DATE
1065: ,p_COORD_BEN_MED_PLN_NO_o
1066: => per_per_shd.g_old_rec.COORD_BEN_MED_PLN_NO
1067: ,p_COORD_BEN_NO_CVG_FLAG_o
1068: => per_per_shd.g_old_rec.COORD_BEN_NO_CVG_FLAG
1069: ,p_coord_ben_med_ext_er_o
1070: => per_per_shd.g_old_rec.coord_ben_med_ext_er
1064: => per_per_shd.g_old_rec.RECEIPT_OF_DEATH_CERT_DATE
1065: ,p_COORD_BEN_MED_PLN_NO_o
1066: => per_per_shd.g_old_rec.COORD_BEN_MED_PLN_NO
1067: ,p_COORD_BEN_NO_CVG_FLAG_o
1068: => per_per_shd.g_old_rec.COORD_BEN_NO_CVG_FLAG
1069: ,p_coord_ben_med_ext_er_o
1070: => per_per_shd.g_old_rec.coord_ben_med_ext_er
1071: ,p_coord_ben_med_pl_name_o
1072: => per_per_shd.g_old_rec.coord_ben_med_pl_name
1066: => per_per_shd.g_old_rec.COORD_BEN_MED_PLN_NO
1067: ,p_COORD_BEN_NO_CVG_FLAG_o
1068: => per_per_shd.g_old_rec.COORD_BEN_NO_CVG_FLAG
1069: ,p_coord_ben_med_ext_er_o
1070: => per_per_shd.g_old_rec.coord_ben_med_ext_er
1071: ,p_coord_ben_med_pl_name_o
1072: => per_per_shd.g_old_rec.coord_ben_med_pl_name
1073: ,p_coord_ben_med_insr_crr_nam_o
1074: => per_per_shd.g_old_rec.coord_ben_med_insr_crr_name
1068: => per_per_shd.g_old_rec.COORD_BEN_NO_CVG_FLAG
1069: ,p_coord_ben_med_ext_er_o
1070: => per_per_shd.g_old_rec.coord_ben_med_ext_er
1071: ,p_coord_ben_med_pl_name_o
1072: => per_per_shd.g_old_rec.coord_ben_med_pl_name
1073: ,p_coord_ben_med_insr_crr_nam_o
1074: => per_per_shd.g_old_rec.coord_ben_med_insr_crr_name
1075: ,p_coord_ben_med_insr_crr_ide_o
1076: => per_per_shd.g_old_rec.coord_ben_med_insr_crr_ident
1070: => per_per_shd.g_old_rec.coord_ben_med_ext_er
1071: ,p_coord_ben_med_pl_name_o
1072: => per_per_shd.g_old_rec.coord_ben_med_pl_name
1073: ,p_coord_ben_med_insr_crr_nam_o
1074: => per_per_shd.g_old_rec.coord_ben_med_insr_crr_name
1075: ,p_coord_ben_med_insr_crr_ide_o
1076: => per_per_shd.g_old_rec.coord_ben_med_insr_crr_ident
1077: ,p_coord_ben_med_cvg_strt_dt_o
1078: => per_per_shd.g_old_rec.coord_ben_med_cvg_strt_dt
1072: => per_per_shd.g_old_rec.coord_ben_med_pl_name
1073: ,p_coord_ben_med_insr_crr_nam_o
1074: => per_per_shd.g_old_rec.coord_ben_med_insr_crr_name
1075: ,p_coord_ben_med_insr_crr_ide_o
1076: => per_per_shd.g_old_rec.coord_ben_med_insr_crr_ident
1077: ,p_coord_ben_med_cvg_strt_dt_o
1078: => per_per_shd.g_old_rec.coord_ben_med_cvg_strt_dt
1079: ,p_coord_ben_med_cvg_end_dt_o
1080: => per_per_shd.g_old_rec.coord_ben_med_cvg_end_dt
1074: => per_per_shd.g_old_rec.coord_ben_med_insr_crr_name
1075: ,p_coord_ben_med_insr_crr_ide_o
1076: => per_per_shd.g_old_rec.coord_ben_med_insr_crr_ident
1077: ,p_coord_ben_med_cvg_strt_dt_o
1078: => per_per_shd.g_old_rec.coord_ben_med_cvg_strt_dt
1079: ,p_coord_ben_med_cvg_end_dt_o
1080: => per_per_shd.g_old_rec.coord_ben_med_cvg_end_dt
1081: ,p_USES_TOBACCO_FLAG_o
1082: => per_per_shd.g_old_rec.USES_TOBACCO_FLAG
1076: => per_per_shd.g_old_rec.coord_ben_med_insr_crr_ident
1077: ,p_coord_ben_med_cvg_strt_dt_o
1078: => per_per_shd.g_old_rec.coord_ben_med_cvg_strt_dt
1079: ,p_coord_ben_med_cvg_end_dt_o
1080: => per_per_shd.g_old_rec.coord_ben_med_cvg_end_dt
1081: ,p_USES_TOBACCO_FLAG_o
1082: => per_per_shd.g_old_rec.USES_TOBACCO_FLAG
1083: ,p_DPDNT_ADOPTION_DATE_o
1084: => per_per_shd.g_old_rec.DPDNT_ADOPTION_DATE
1078: => per_per_shd.g_old_rec.coord_ben_med_cvg_strt_dt
1079: ,p_coord_ben_med_cvg_end_dt_o
1080: => per_per_shd.g_old_rec.coord_ben_med_cvg_end_dt
1081: ,p_USES_TOBACCO_FLAG_o
1082: => per_per_shd.g_old_rec.USES_TOBACCO_FLAG
1083: ,p_DPDNT_ADOPTION_DATE_o
1084: => per_per_shd.g_old_rec.DPDNT_ADOPTION_DATE
1085: ,p_DPDNT_VLNTRY_SVCE_FLAG_o
1086: => per_per_shd.g_old_rec.DPDNT_VLNTRY_SVCE_FLAG
1080: => per_per_shd.g_old_rec.coord_ben_med_cvg_end_dt
1081: ,p_USES_TOBACCO_FLAG_o
1082: => per_per_shd.g_old_rec.USES_TOBACCO_FLAG
1083: ,p_DPDNT_ADOPTION_DATE_o
1084: => per_per_shd.g_old_rec.DPDNT_ADOPTION_DATE
1085: ,p_DPDNT_VLNTRY_SVCE_FLAG_o
1086: => per_per_shd.g_old_rec.DPDNT_VLNTRY_SVCE_FLAG
1087: ,p_ORIGINAL_DATE_OF_HIRE_o
1088: => per_per_shd.g_old_rec.ORIGINAL_DATE_OF_HIRE
1082: => per_per_shd.g_old_rec.USES_TOBACCO_FLAG
1083: ,p_DPDNT_ADOPTION_DATE_o
1084: => per_per_shd.g_old_rec.DPDNT_ADOPTION_DATE
1085: ,p_DPDNT_VLNTRY_SVCE_FLAG_o
1086: => per_per_shd.g_old_rec.DPDNT_VLNTRY_SVCE_FLAG
1087: ,p_ORIGINAL_DATE_OF_HIRE_o
1088: => per_per_shd.g_old_rec.ORIGINAL_DATE_OF_HIRE
1089: ,p_town_of_birth_o
1090: => per_per_shd.g_old_rec.town_of_birth
1084: => per_per_shd.g_old_rec.DPDNT_ADOPTION_DATE
1085: ,p_DPDNT_VLNTRY_SVCE_FLAG_o
1086: => per_per_shd.g_old_rec.DPDNT_VLNTRY_SVCE_FLAG
1087: ,p_ORIGINAL_DATE_OF_HIRE_o
1088: => per_per_shd.g_old_rec.ORIGINAL_DATE_OF_HIRE
1089: ,p_town_of_birth_o
1090: => per_per_shd.g_old_rec.town_of_birth
1091: ,p_region_of_birth_o
1092: => per_per_shd.g_old_rec.region_of_birth
1086: => per_per_shd.g_old_rec.DPDNT_VLNTRY_SVCE_FLAG
1087: ,p_ORIGINAL_DATE_OF_HIRE_o
1088: => per_per_shd.g_old_rec.ORIGINAL_DATE_OF_HIRE
1089: ,p_town_of_birth_o
1090: => per_per_shd.g_old_rec.town_of_birth
1091: ,p_region_of_birth_o
1092: => per_per_shd.g_old_rec.region_of_birth
1093: ,p_country_of_birth_o
1094: => per_per_shd.g_old_rec.country_of_birth
1088: => per_per_shd.g_old_rec.ORIGINAL_DATE_OF_HIRE
1089: ,p_town_of_birth_o
1090: => per_per_shd.g_old_rec.town_of_birth
1091: ,p_region_of_birth_o
1092: => per_per_shd.g_old_rec.region_of_birth
1093: ,p_country_of_birth_o
1094: => per_per_shd.g_old_rec.country_of_birth
1095: ,p_global_person_id_o
1096: => per_per_shd.g_old_rec.global_person_id
1090: => per_per_shd.g_old_rec.town_of_birth
1091: ,p_region_of_birth_o
1092: => per_per_shd.g_old_rec.region_of_birth
1093: ,p_country_of_birth_o
1094: => per_per_shd.g_old_rec.country_of_birth
1095: ,p_global_person_id_o
1096: => per_per_shd.g_old_rec.global_person_id
1097: ,p_party_id_o
1098: => per_per_shd.g_old_rec.party_id
1092: => per_per_shd.g_old_rec.region_of_birth
1093: ,p_country_of_birth_o
1094: => per_per_shd.g_old_rec.country_of_birth
1095: ,p_global_person_id_o
1096: => per_per_shd.g_old_rec.global_person_id
1097: ,p_party_id_o
1098: => per_per_shd.g_old_rec.party_id
1099: ,p_npw_number_o
1100: => per_per_shd.g_old_rec.npw_number
1094: => per_per_shd.g_old_rec.country_of_birth
1095: ,p_global_person_id_o
1096: => per_per_shd.g_old_rec.global_person_id
1097: ,p_party_id_o
1098: => per_per_shd.g_old_rec.party_id
1099: ,p_npw_number_o
1100: => per_per_shd.g_old_rec.npw_number
1101: ,p_current_npw_flag_o
1102: => per_per_shd.g_old_rec.current_npw_flag
1096: => per_per_shd.g_old_rec.global_person_id
1097: ,p_party_id_o
1098: => per_per_shd.g_old_rec.party_id
1099: ,p_npw_number_o
1100: => per_per_shd.g_old_rec.npw_number
1101: ,p_current_npw_flag_o
1102: => per_per_shd.g_old_rec.current_npw_flag
1103: ,p_global_name_o
1104: => per_per_shd.g_old_rec.global_name
1098: => per_per_shd.g_old_rec.party_id
1099: ,p_npw_number_o
1100: => per_per_shd.g_old_rec.npw_number
1101: ,p_current_npw_flag_o
1102: => per_per_shd.g_old_rec.current_npw_flag
1103: ,p_global_name_o
1104: => per_per_shd.g_old_rec.global_name
1105: ,p_local_name_o
1106: => per_per_shd.g_old_rec.local_name
1100: => per_per_shd.g_old_rec.npw_number
1101: ,p_current_npw_flag_o
1102: => per_per_shd.g_old_rec.current_npw_flag
1103: ,p_global_name_o
1104: => per_per_shd.g_old_rec.global_name
1105: ,p_local_name_o
1106: => per_per_shd.g_old_rec.local_name
1107: ,p_object_version_number_o
1108: => per_per_shd.g_old_rec.object_version_number
1102: => per_per_shd.g_old_rec.current_npw_flag
1103: ,p_global_name_o
1104: => per_per_shd.g_old_rec.global_name
1105: ,p_local_name_o
1106: => per_per_shd.g_old_rec.local_name
1107: ,p_object_version_number_o
1108: => per_per_shd.g_old_rec.object_version_number
1109: );
1110: exception
1104: => per_per_shd.g_old_rec.global_name
1105: ,p_local_name_o
1106: => per_per_shd.g_old_rec.local_name
1107: ,p_object_version_number_o
1108: => per_per_shd.g_old_rec.object_version_number
1109: );
1110: exception
1111: when hr_api.cannot_find_prog_unit then
1112: hr_api.cannot_find_prog_unit_error
1173: -- Internal Table Handler Use Only.
1174: --
1175: -- {End Of Comments}
1176: -- ----------------------------------------------------------------------------
1177: Procedure convert_defs(p_rec in out nocopy per_per_shd.g_rec_type) is
1178: --
1179: l_proc varchar2(72) := g_package||'convert_defs';
1180: --
1181: Begin
1188: -- is being used then we must set to the 'current' argument value.
1189: --
1190: If (p_rec.business_group_id = hr_api.g_number) then
1191: p_rec.business_group_id :=
1192: per_per_shd.g_old_rec.business_group_id;
1193: End If;
1194: If (p_rec.person_type_id = hr_api.g_number) then
1195: p_rec.person_type_id :=
1196: per_per_shd.g_old_rec.person_type_id;
1192: per_per_shd.g_old_rec.business_group_id;
1193: End If;
1194: If (p_rec.person_type_id = hr_api.g_number) then
1195: p_rec.person_type_id :=
1196: per_per_shd.g_old_rec.person_type_id;
1197: End If;
1198: If (p_rec.last_name = hr_api.g_varchar2) then
1199: p_rec.last_name :=
1200: per_per_shd.g_old_rec.last_name;
1196: per_per_shd.g_old_rec.person_type_id;
1197: End If;
1198: If (p_rec.last_name = hr_api.g_varchar2) then
1199: p_rec.last_name :=
1200: per_per_shd.g_old_rec.last_name;
1201: End If;
1202: If (p_rec.start_date = hr_api.g_date) then
1203: p_rec.start_date :=
1204: per_per_shd.g_old_rec.start_date;
1200: per_per_shd.g_old_rec.last_name;
1201: End If;
1202: If (p_rec.start_date = hr_api.g_date) then
1203: p_rec.start_date :=
1204: per_per_shd.g_old_rec.start_date;
1205: End If;
1206: If (p_rec.applicant_number = hr_api.g_varchar2) then
1207: p_rec.applicant_number :=
1208: per_per_shd.g_old_rec.applicant_number;
1204: per_per_shd.g_old_rec.start_date;
1205: End If;
1206: If (p_rec.applicant_number = hr_api.g_varchar2) then
1207: p_rec.applicant_number :=
1208: per_per_shd.g_old_rec.applicant_number;
1209: End If;
1210: If (p_rec.comment_id = hr_api.g_number) then
1211: p_rec.comment_id :=
1212: per_per_shd.g_old_rec.comment_id;
1208: per_per_shd.g_old_rec.applicant_number;
1209: End If;
1210: If (p_rec.comment_id = hr_api.g_number) then
1211: p_rec.comment_id :=
1212: per_per_shd.g_old_rec.comment_id;
1213: End If;
1214: If (p_rec.comments = hr_api.g_varchar2) then
1215: p_rec.comments := per_per_shd.g_old_rec.comments;
1216: End If;
1211: p_rec.comment_id :=
1212: per_per_shd.g_old_rec.comment_id;
1213: End If;
1214: If (p_rec.comments = hr_api.g_varchar2) then
1215: p_rec.comments := per_per_shd.g_old_rec.comments;
1216: End If;
1217: If (p_rec.current_applicant_flag = hr_api.g_varchar2) then
1218: p_rec.current_applicant_flag :=
1219: per_per_shd.g_old_rec.current_applicant_flag;
1215: p_rec.comments := per_per_shd.g_old_rec.comments;
1216: End If;
1217: If (p_rec.current_applicant_flag = hr_api.g_varchar2) then
1218: p_rec.current_applicant_flag :=
1219: per_per_shd.g_old_rec.current_applicant_flag;
1220: End If;
1221: If (p_rec.current_emp_or_apl_flag = hr_api.g_varchar2) then
1222: p_rec.current_emp_or_apl_flag :=
1223: per_per_shd.g_old_rec.current_emp_or_apl_flag;
1219: per_per_shd.g_old_rec.current_applicant_flag;
1220: End If;
1221: If (p_rec.current_emp_or_apl_flag = hr_api.g_varchar2) then
1222: p_rec.current_emp_or_apl_flag :=
1223: per_per_shd.g_old_rec.current_emp_or_apl_flag;
1224: End If;
1225: If (p_rec.current_employee_flag = hr_api.g_varchar2) then
1226: p_rec.current_employee_flag :=
1227: per_per_shd.g_old_rec.current_employee_flag;
1223: per_per_shd.g_old_rec.current_emp_or_apl_flag;
1224: End If;
1225: If (p_rec.current_employee_flag = hr_api.g_varchar2) then
1226: p_rec.current_employee_flag :=
1227: per_per_shd.g_old_rec.current_employee_flag;
1228: End If;
1229: If (p_rec.date_employee_data_verified = hr_api.g_date) then
1230: p_rec.date_employee_data_verified :=
1231: per_per_shd.g_old_rec.date_employee_data_verified;
1227: per_per_shd.g_old_rec.current_employee_flag;
1228: End If;
1229: If (p_rec.date_employee_data_verified = hr_api.g_date) then
1230: p_rec.date_employee_data_verified :=
1231: per_per_shd.g_old_rec.date_employee_data_verified;
1232: End If;
1233: If (p_rec.date_of_birth = hr_api.g_date) then
1234: p_rec.date_of_birth :=
1235: per_per_shd.g_old_rec.date_of_birth;
1231: per_per_shd.g_old_rec.date_employee_data_verified;
1232: End If;
1233: If (p_rec.date_of_birth = hr_api.g_date) then
1234: p_rec.date_of_birth :=
1235: per_per_shd.g_old_rec.date_of_birth;
1236: End If;
1237: If (p_rec.email_address = hr_api.g_varchar2) then
1238: p_rec.email_address :=
1239: per_per_shd.g_old_rec.email_address;
1235: per_per_shd.g_old_rec.date_of_birth;
1236: End If;
1237: If (p_rec.email_address = hr_api.g_varchar2) then
1238: p_rec.email_address :=
1239: per_per_shd.g_old_rec.email_address;
1240: End If;
1241: If (p_rec.employee_number = hr_api.g_varchar2) then
1242: p_rec.employee_number :=
1243: per_per_shd.g_old_rec.employee_number;
1239: per_per_shd.g_old_rec.email_address;
1240: End If;
1241: If (p_rec.employee_number = hr_api.g_varchar2) then
1242: p_rec.employee_number :=
1243: per_per_shd.g_old_rec.employee_number;
1244: End If;
1245: If (p_rec.expense_check_send_to_address = hr_api.g_varchar2) then
1246: p_rec.expense_check_send_to_address :=
1247: per_per_shd.g_old_rec.expense_check_send_to_address;
1243: per_per_shd.g_old_rec.employee_number;
1244: End If;
1245: If (p_rec.expense_check_send_to_address = hr_api.g_varchar2) then
1246: p_rec.expense_check_send_to_address :=
1247: per_per_shd.g_old_rec.expense_check_send_to_address;
1248: End If;
1249: If (p_rec.first_name = hr_api.g_varchar2) then
1250: p_rec.first_name :=
1251: per_per_shd.g_old_rec.first_name;
1247: per_per_shd.g_old_rec.expense_check_send_to_address;
1248: End If;
1249: If (p_rec.first_name = hr_api.g_varchar2) then
1250: p_rec.first_name :=
1251: per_per_shd.g_old_rec.first_name;
1252: End If;
1253: If (p_rec.full_name = hr_api.g_varchar2) then
1254: p_rec.full_name :=
1255: per_per_shd.g_old_rec.full_name;
1251: per_per_shd.g_old_rec.first_name;
1252: End If;
1253: If (p_rec.full_name = hr_api.g_varchar2) then
1254: p_rec.full_name :=
1255: per_per_shd.g_old_rec.full_name;
1256: End If;
1257: If (p_rec.known_as = hr_api.g_varchar2) then
1258: p_rec.known_as :=
1259: per_per_shd.g_old_rec.known_as;
1255: per_per_shd.g_old_rec.full_name;
1256: End If;
1257: If (p_rec.known_as = hr_api.g_varchar2) then
1258: p_rec.known_as :=
1259: per_per_shd.g_old_rec.known_as;
1260: End If;
1261: If (p_rec.marital_status = hr_api.g_varchar2) then
1262: p_rec.marital_status :=
1263: per_per_shd.g_old_rec.marital_status;
1259: per_per_shd.g_old_rec.known_as;
1260: End If;
1261: If (p_rec.marital_status = hr_api.g_varchar2) then
1262: p_rec.marital_status :=
1263: per_per_shd.g_old_rec.marital_status;
1264: End If;
1265: If (p_rec.middle_names = hr_api.g_varchar2) then
1266: p_rec.middle_names :=
1267: per_per_shd.g_old_rec.middle_names;
1263: per_per_shd.g_old_rec.marital_status;
1264: End If;
1265: If (p_rec.middle_names = hr_api.g_varchar2) then
1266: p_rec.middle_names :=
1267: per_per_shd.g_old_rec.middle_names;
1268: End If;
1269: If (p_rec.nationality = hr_api.g_varchar2) then
1270: p_rec.nationality :=
1271: per_per_shd.g_old_rec.nationality;
1267: per_per_shd.g_old_rec.middle_names;
1268: End If;
1269: If (p_rec.nationality = hr_api.g_varchar2) then
1270: p_rec.nationality :=
1271: per_per_shd.g_old_rec.nationality;
1272: End If;
1273: If (p_rec.national_identifier = hr_api.g_varchar2) then
1274: p_rec.national_identifier :=
1275: per_per_shd.g_old_rec.national_identifier;
1271: per_per_shd.g_old_rec.nationality;
1272: End If;
1273: If (p_rec.national_identifier = hr_api.g_varchar2) then
1274: p_rec.national_identifier :=
1275: per_per_shd.g_old_rec.national_identifier;
1276: End If;
1277: If (p_rec.previous_last_name = hr_api.g_varchar2) then
1278: p_rec.previous_last_name :=
1279: per_per_shd.g_old_rec.previous_last_name;
1275: per_per_shd.g_old_rec.national_identifier;
1276: End If;
1277: If (p_rec.previous_last_name = hr_api.g_varchar2) then
1278: p_rec.previous_last_name :=
1279: per_per_shd.g_old_rec.previous_last_name;
1280: End If;
1281: If (p_rec.registered_disabled_flag = hr_api.g_varchar2) then
1282: p_rec.registered_disabled_flag :=
1283: per_per_shd.g_old_rec.registered_disabled_flag;
1279: per_per_shd.g_old_rec.previous_last_name;
1280: End If;
1281: If (p_rec.registered_disabled_flag = hr_api.g_varchar2) then
1282: p_rec.registered_disabled_flag :=
1283: per_per_shd.g_old_rec.registered_disabled_flag;
1284: End If;
1285: If (p_rec.sex = hr_api.g_varchar2) then
1286: p_rec.sex :=
1287: per_per_shd.g_old_rec.sex;
1283: per_per_shd.g_old_rec.registered_disabled_flag;
1284: End If;
1285: If (p_rec.sex = hr_api.g_varchar2) then
1286: p_rec.sex :=
1287: per_per_shd.g_old_rec.sex;
1288: End If;
1289: If (p_rec.title = hr_api.g_varchar2) then
1290: p_rec.title :=
1291: per_per_shd.g_old_rec.title;
1287: per_per_shd.g_old_rec.sex;
1288: End If;
1289: If (p_rec.title = hr_api.g_varchar2) then
1290: p_rec.title :=
1291: per_per_shd.g_old_rec.title;
1292: End If;
1293: If (p_rec.vendor_id = hr_api.g_number) then
1294: p_rec.vendor_id :=
1295: per_per_shd.g_old_rec.vendor_id;
1291: per_per_shd.g_old_rec.title;
1292: End If;
1293: If (p_rec.vendor_id = hr_api.g_number) then
1294: p_rec.vendor_id :=
1295: per_per_shd.g_old_rec.vendor_id;
1296: End If;
1297: If (p_rec.work_telephone = hr_api.g_varchar2) then
1298: p_rec.work_telephone :=
1299: per_per_shd.g_old_rec.work_telephone;
1295: per_per_shd.g_old_rec.vendor_id;
1296: End If;
1297: If (p_rec.work_telephone = hr_api.g_varchar2) then
1298: p_rec.work_telephone :=
1299: per_per_shd.g_old_rec.work_telephone;
1300: End If;
1301: If (p_rec.request_id = hr_api.g_number) then
1302: p_rec.request_id :=
1303: per_per_shd.g_old_rec.request_id;
1299: per_per_shd.g_old_rec.work_telephone;
1300: End If;
1301: If (p_rec.request_id = hr_api.g_number) then
1302: p_rec.request_id :=
1303: per_per_shd.g_old_rec.request_id;
1304: End If;
1305: If (p_rec.program_application_id = hr_api.g_number) then
1306: p_rec.program_application_id :=
1307: per_per_shd.g_old_rec.program_application_id;
1303: per_per_shd.g_old_rec.request_id;
1304: End If;
1305: If (p_rec.program_application_id = hr_api.g_number) then
1306: p_rec.program_application_id :=
1307: per_per_shd.g_old_rec.program_application_id;
1308: End If;
1309: If (p_rec.program_id = hr_api.g_number) then
1310: p_rec.program_id :=
1311: per_per_shd.g_old_rec.program_id;
1307: per_per_shd.g_old_rec.program_application_id;
1308: End If;
1309: If (p_rec.program_id = hr_api.g_number) then
1310: p_rec.program_id :=
1311: per_per_shd.g_old_rec.program_id;
1312: End If;
1313: If (p_rec.program_update_date = hr_api.g_date) then
1314: p_rec.program_update_date :=
1315: per_per_shd.g_old_rec.program_update_date;
1311: per_per_shd.g_old_rec.program_id;
1312: End If;
1313: If (p_rec.program_update_date = hr_api.g_date) then
1314: p_rec.program_update_date :=
1315: per_per_shd.g_old_rec.program_update_date;
1316: End If;
1317: If (p_rec.attribute_category = hr_api.g_varchar2) then
1318: p_rec.attribute_category :=
1319: per_per_shd.g_old_rec.attribute_category;
1315: per_per_shd.g_old_rec.program_update_date;
1316: End If;
1317: If (p_rec.attribute_category = hr_api.g_varchar2) then
1318: p_rec.attribute_category :=
1319: per_per_shd.g_old_rec.attribute_category;
1320: End If;
1321: If (p_rec.attribute1 = hr_api.g_varchar2) then
1322: p_rec.attribute1 :=
1323: per_per_shd.g_old_rec.attribute1;
1319: per_per_shd.g_old_rec.attribute_category;
1320: End If;
1321: If (p_rec.attribute1 = hr_api.g_varchar2) then
1322: p_rec.attribute1 :=
1323: per_per_shd.g_old_rec.attribute1;
1324: End If;
1325: If (p_rec.attribute2 = hr_api.g_varchar2) then
1326: p_rec.attribute2 :=
1327: per_per_shd.g_old_rec.attribute2;
1323: per_per_shd.g_old_rec.attribute1;
1324: End If;
1325: If (p_rec.attribute2 = hr_api.g_varchar2) then
1326: p_rec.attribute2 :=
1327: per_per_shd.g_old_rec.attribute2;
1328: End If;
1329: If (p_rec.attribute3 = hr_api.g_varchar2) then
1330: p_rec.attribute3 :=
1331: per_per_shd.g_old_rec.attribute3;
1327: per_per_shd.g_old_rec.attribute2;
1328: End If;
1329: If (p_rec.attribute3 = hr_api.g_varchar2) then
1330: p_rec.attribute3 :=
1331: per_per_shd.g_old_rec.attribute3;
1332: End If;
1333: If (p_rec.attribute4 = hr_api.g_varchar2) then
1334: p_rec.attribute4 :=
1335: per_per_shd.g_old_rec.attribute4;
1331: per_per_shd.g_old_rec.attribute3;
1332: End If;
1333: If (p_rec.attribute4 = hr_api.g_varchar2) then
1334: p_rec.attribute4 :=
1335: per_per_shd.g_old_rec.attribute4;
1336: End If;
1337: If (p_rec.attribute5 = hr_api.g_varchar2) then
1338: p_rec.attribute5 :=
1339: per_per_shd.g_old_rec.attribute5;
1335: per_per_shd.g_old_rec.attribute4;
1336: End If;
1337: If (p_rec.attribute5 = hr_api.g_varchar2) then
1338: p_rec.attribute5 :=
1339: per_per_shd.g_old_rec.attribute5;
1340: End If;
1341: If (p_rec.attribute6 = hr_api.g_varchar2) then
1342: p_rec.attribute6 :=
1343: per_per_shd.g_old_rec.attribute6;
1339: per_per_shd.g_old_rec.attribute5;
1340: End If;
1341: If (p_rec.attribute6 = hr_api.g_varchar2) then
1342: p_rec.attribute6 :=
1343: per_per_shd.g_old_rec.attribute6;
1344: End If;
1345: If (p_rec.attribute7 = hr_api.g_varchar2) then
1346: p_rec.attribute7 :=
1347: per_per_shd.g_old_rec.attribute7;
1343: per_per_shd.g_old_rec.attribute6;
1344: End If;
1345: If (p_rec.attribute7 = hr_api.g_varchar2) then
1346: p_rec.attribute7 :=
1347: per_per_shd.g_old_rec.attribute7;
1348: End If;
1349: If (p_rec.attribute8 = hr_api.g_varchar2) then
1350: p_rec.attribute8 :=
1351: per_per_shd.g_old_rec.attribute8;
1347: per_per_shd.g_old_rec.attribute7;
1348: End If;
1349: If (p_rec.attribute8 = hr_api.g_varchar2) then
1350: p_rec.attribute8 :=
1351: per_per_shd.g_old_rec.attribute8;
1352: End If;
1353: If (p_rec.attribute9 = hr_api.g_varchar2) then
1354: p_rec.attribute9 :=
1355: per_per_shd.g_old_rec.attribute9;
1351: per_per_shd.g_old_rec.attribute8;
1352: End If;
1353: If (p_rec.attribute9 = hr_api.g_varchar2) then
1354: p_rec.attribute9 :=
1355: per_per_shd.g_old_rec.attribute9;
1356: End If;
1357: If (p_rec.attribute10 = hr_api.g_varchar2) then
1358: p_rec.attribute10 :=
1359: per_per_shd.g_old_rec.attribute10;
1355: per_per_shd.g_old_rec.attribute9;
1356: End If;
1357: If (p_rec.attribute10 = hr_api.g_varchar2) then
1358: p_rec.attribute10 :=
1359: per_per_shd.g_old_rec.attribute10;
1360: End If;
1361: If (p_rec.attribute11 = hr_api.g_varchar2) then
1362: p_rec.attribute11 :=
1363: per_per_shd.g_old_rec.attribute11;
1359: per_per_shd.g_old_rec.attribute10;
1360: End If;
1361: If (p_rec.attribute11 = hr_api.g_varchar2) then
1362: p_rec.attribute11 :=
1363: per_per_shd.g_old_rec.attribute11;
1364: End If;
1365: If (p_rec.attribute12 = hr_api.g_varchar2) then
1366: p_rec.attribute12 :=
1367: per_per_shd.g_old_rec.attribute12;
1363: per_per_shd.g_old_rec.attribute11;
1364: End If;
1365: If (p_rec.attribute12 = hr_api.g_varchar2) then
1366: p_rec.attribute12 :=
1367: per_per_shd.g_old_rec.attribute12;
1368: End If;
1369: If (p_rec.attribute13 = hr_api.g_varchar2) then
1370: p_rec.attribute13 :=
1371: per_per_shd.g_old_rec.attribute13;
1367: per_per_shd.g_old_rec.attribute12;
1368: End If;
1369: If (p_rec.attribute13 = hr_api.g_varchar2) then
1370: p_rec.attribute13 :=
1371: per_per_shd.g_old_rec.attribute13;
1372: End If;
1373: If (p_rec.attribute14 = hr_api.g_varchar2) then
1374: p_rec.attribute14 :=
1375: per_per_shd.g_old_rec.attribute14;
1371: per_per_shd.g_old_rec.attribute13;
1372: End If;
1373: If (p_rec.attribute14 = hr_api.g_varchar2) then
1374: p_rec.attribute14 :=
1375: per_per_shd.g_old_rec.attribute14;
1376: End If;
1377: If (p_rec.attribute15 = hr_api.g_varchar2) then
1378: p_rec.attribute15 :=
1379: per_per_shd.g_old_rec.attribute15;
1375: per_per_shd.g_old_rec.attribute14;
1376: End If;
1377: If (p_rec.attribute15 = hr_api.g_varchar2) then
1378: p_rec.attribute15 :=
1379: per_per_shd.g_old_rec.attribute15;
1380: End If;
1381: If (p_rec.attribute16 = hr_api.g_varchar2) then
1382: p_rec.attribute16 :=
1383: per_per_shd.g_old_rec.attribute16;
1379: per_per_shd.g_old_rec.attribute15;
1380: End If;
1381: If (p_rec.attribute16 = hr_api.g_varchar2) then
1382: p_rec.attribute16 :=
1383: per_per_shd.g_old_rec.attribute16;
1384: End If;
1385: If (p_rec.attribute17 = hr_api.g_varchar2) then
1386: p_rec.attribute17 :=
1387: per_per_shd.g_old_rec.attribute17;
1383: per_per_shd.g_old_rec.attribute16;
1384: End If;
1385: If (p_rec.attribute17 = hr_api.g_varchar2) then
1386: p_rec.attribute17 :=
1387: per_per_shd.g_old_rec.attribute17;
1388: End If;
1389: If (p_rec.attribute18 = hr_api.g_varchar2) then
1390: p_rec.attribute18 :=
1391: per_per_shd.g_old_rec.attribute18;
1387: per_per_shd.g_old_rec.attribute17;
1388: End If;
1389: If (p_rec.attribute18 = hr_api.g_varchar2) then
1390: p_rec.attribute18 :=
1391: per_per_shd.g_old_rec.attribute18;
1392: End If;
1393: If (p_rec.attribute19 = hr_api.g_varchar2) then
1394: p_rec.attribute19 :=
1395: per_per_shd.g_old_rec.attribute19;
1391: per_per_shd.g_old_rec.attribute18;
1392: End If;
1393: If (p_rec.attribute19 = hr_api.g_varchar2) then
1394: p_rec.attribute19 :=
1395: per_per_shd.g_old_rec.attribute19;
1396: End If;
1397: If (p_rec.attribute20 = hr_api.g_varchar2) then
1398: p_rec.attribute20 :=
1399: per_per_shd.g_old_rec.attribute20;
1395: per_per_shd.g_old_rec.attribute19;
1396: End If;
1397: If (p_rec.attribute20 = hr_api.g_varchar2) then
1398: p_rec.attribute20 :=
1399: per_per_shd.g_old_rec.attribute20;
1400: End If;
1401: If (p_rec.attribute21 = hr_api.g_varchar2) then
1402: p_rec.attribute21 :=
1403: per_per_shd.g_old_rec.attribute21;
1399: per_per_shd.g_old_rec.attribute20;
1400: End If;
1401: If (p_rec.attribute21 = hr_api.g_varchar2) then
1402: p_rec.attribute21 :=
1403: per_per_shd.g_old_rec.attribute21;
1404: End If;
1405: If (p_rec.attribute22 = hr_api.g_varchar2) then
1406: p_rec.attribute22 :=
1407: per_per_shd.g_old_rec.attribute22;
1403: per_per_shd.g_old_rec.attribute21;
1404: End If;
1405: If (p_rec.attribute22 = hr_api.g_varchar2) then
1406: p_rec.attribute22 :=
1407: per_per_shd.g_old_rec.attribute22;
1408: End If;
1409: If (p_rec.attribute23 = hr_api.g_varchar2) then
1410: p_rec.attribute23 :=
1411: per_per_shd.g_old_rec.attribute23;
1407: per_per_shd.g_old_rec.attribute22;
1408: End If;
1409: If (p_rec.attribute23 = hr_api.g_varchar2) then
1410: p_rec.attribute23 :=
1411: per_per_shd.g_old_rec.attribute23;
1412: End If;
1413: If (p_rec.attribute24 = hr_api.g_varchar2) then
1414: p_rec.attribute24 :=
1415: per_per_shd.g_old_rec.attribute24;
1411: per_per_shd.g_old_rec.attribute23;
1412: End If;
1413: If (p_rec.attribute24 = hr_api.g_varchar2) then
1414: p_rec.attribute24 :=
1415: per_per_shd.g_old_rec.attribute24;
1416: End If;
1417: If (p_rec.attribute25 = hr_api.g_varchar2) then
1418: p_rec.attribute25 :=
1419: per_per_shd.g_old_rec.attribute25;
1415: per_per_shd.g_old_rec.attribute24;
1416: End If;
1417: If (p_rec.attribute25 = hr_api.g_varchar2) then
1418: p_rec.attribute25 :=
1419: per_per_shd.g_old_rec.attribute25;
1420: End If;
1421: If (p_rec.attribute26 = hr_api.g_varchar2) then
1422: p_rec.attribute26 :=
1423: per_per_shd.g_old_rec.attribute26;
1419: per_per_shd.g_old_rec.attribute25;
1420: End If;
1421: If (p_rec.attribute26 = hr_api.g_varchar2) then
1422: p_rec.attribute26 :=
1423: per_per_shd.g_old_rec.attribute26;
1424: End If;
1425: If (p_rec.attribute27 = hr_api.g_varchar2) then
1426: p_rec.attribute27 :=
1427: per_per_shd.g_old_rec.attribute27;
1423: per_per_shd.g_old_rec.attribute26;
1424: End If;
1425: If (p_rec.attribute27 = hr_api.g_varchar2) then
1426: p_rec.attribute27 :=
1427: per_per_shd.g_old_rec.attribute27;
1428: End If;
1429: If (p_rec.attribute28 = hr_api.g_varchar2) then
1430: p_rec.attribute28 :=
1431: per_per_shd.g_old_rec.attribute28;
1427: per_per_shd.g_old_rec.attribute27;
1428: End If;
1429: If (p_rec.attribute28 = hr_api.g_varchar2) then
1430: p_rec.attribute28 :=
1431: per_per_shd.g_old_rec.attribute28;
1432: End If;
1433: If (p_rec.attribute29 = hr_api.g_varchar2) then
1434: p_rec.attribute29 :=
1435: per_per_shd.g_old_rec.attribute29;
1431: per_per_shd.g_old_rec.attribute28;
1432: End If;
1433: If (p_rec.attribute29 = hr_api.g_varchar2) then
1434: p_rec.attribute29 :=
1435: per_per_shd.g_old_rec.attribute29;
1436: End If;
1437: If (p_rec.attribute30 = hr_api.g_varchar2) then
1438: p_rec.attribute30 :=
1439: per_per_shd.g_old_rec.attribute30;
1435: per_per_shd.g_old_rec.attribute29;
1436: End If;
1437: If (p_rec.attribute30 = hr_api.g_varchar2) then
1438: p_rec.attribute30 :=
1439: per_per_shd.g_old_rec.attribute30;
1440: End If;
1441: If (p_rec.per_information_category = hr_api.g_varchar2) then
1442: p_rec.per_information_category :=
1443: per_per_shd.g_old_rec.per_information_category;
1439: per_per_shd.g_old_rec.attribute30;
1440: End If;
1441: If (p_rec.per_information_category = hr_api.g_varchar2) then
1442: p_rec.per_information_category :=
1443: per_per_shd.g_old_rec.per_information_category;
1444: End If;
1445: If (p_rec.per_information1 = hr_api.g_varchar2) then
1446: p_rec.per_information1 :=
1447: per_per_shd.g_old_rec.per_information1;
1443: per_per_shd.g_old_rec.per_information_category;
1444: End If;
1445: If (p_rec.per_information1 = hr_api.g_varchar2) then
1446: p_rec.per_information1 :=
1447: per_per_shd.g_old_rec.per_information1;
1448: End If;
1449: If (p_rec.per_information2 = hr_api.g_varchar2) then
1450: p_rec.per_information2 :=
1451: per_per_shd.g_old_rec.per_information2;
1447: per_per_shd.g_old_rec.per_information1;
1448: End If;
1449: If (p_rec.per_information2 = hr_api.g_varchar2) then
1450: p_rec.per_information2 :=
1451: per_per_shd.g_old_rec.per_information2;
1452: End If;
1453: If (p_rec.per_information3 = hr_api.g_varchar2) then
1454: p_rec.per_information3 :=
1455: per_per_shd.g_old_rec.per_information3;
1451: per_per_shd.g_old_rec.per_information2;
1452: End If;
1453: If (p_rec.per_information3 = hr_api.g_varchar2) then
1454: p_rec.per_information3 :=
1455: per_per_shd.g_old_rec.per_information3;
1456: End If;
1457: If (p_rec.per_information4 = hr_api.g_varchar2) then
1458: p_rec.per_information4 :=
1459: per_per_shd.g_old_rec.per_information4;
1455: per_per_shd.g_old_rec.per_information3;
1456: End If;
1457: If (p_rec.per_information4 = hr_api.g_varchar2) then
1458: p_rec.per_information4 :=
1459: per_per_shd.g_old_rec.per_information4;
1460: End If;
1461: If (p_rec.per_information5 = hr_api.g_varchar2) then
1462: p_rec.per_information5 :=
1463: per_per_shd.g_old_rec.per_information5;
1459: per_per_shd.g_old_rec.per_information4;
1460: End If;
1461: If (p_rec.per_information5 = hr_api.g_varchar2) then
1462: p_rec.per_information5 :=
1463: per_per_shd.g_old_rec.per_information5;
1464: End If;
1465: If (p_rec.per_information6 = hr_api.g_varchar2) then
1466: p_rec.per_information6 :=
1467: per_per_shd.g_old_rec.per_information6;
1463: per_per_shd.g_old_rec.per_information5;
1464: End If;
1465: If (p_rec.per_information6 = hr_api.g_varchar2) then
1466: p_rec.per_information6 :=
1467: per_per_shd.g_old_rec.per_information6;
1468: End If;
1469: If (p_rec.per_information7 = hr_api.g_varchar2) then
1470: p_rec.per_information7 :=
1471: per_per_shd.g_old_rec.per_information7;
1467: per_per_shd.g_old_rec.per_information6;
1468: End If;
1469: If (p_rec.per_information7 = hr_api.g_varchar2) then
1470: p_rec.per_information7 :=
1471: per_per_shd.g_old_rec.per_information7;
1472: End If;
1473: If (p_rec.per_information8 = hr_api.g_varchar2) then
1474: p_rec.per_information8 :=
1475: per_per_shd.g_old_rec.per_information8;
1471: per_per_shd.g_old_rec.per_information7;
1472: End If;
1473: If (p_rec.per_information8 = hr_api.g_varchar2) then
1474: p_rec.per_information8 :=
1475: per_per_shd.g_old_rec.per_information8;
1476: End If;
1477: If (p_rec.per_information9 = hr_api.g_varchar2) then
1478: p_rec.per_information9 :=
1479: per_per_shd.g_old_rec.per_information9;
1475: per_per_shd.g_old_rec.per_information8;
1476: End If;
1477: If (p_rec.per_information9 = hr_api.g_varchar2) then
1478: p_rec.per_information9 :=
1479: per_per_shd.g_old_rec.per_information9;
1480: End If;
1481: If (p_rec.per_information10 = hr_api.g_varchar2) then
1482: p_rec.per_information10 :=
1483: per_per_shd.g_old_rec.per_information10;
1479: per_per_shd.g_old_rec.per_information9;
1480: End If;
1481: If (p_rec.per_information10 = hr_api.g_varchar2) then
1482: p_rec.per_information10 :=
1483: per_per_shd.g_old_rec.per_information10;
1484: End If;
1485: If (p_rec.per_information11 = hr_api.g_varchar2) then
1486: p_rec.per_information11 :=
1487: per_per_shd.g_old_rec.per_information11;
1483: per_per_shd.g_old_rec.per_information10;
1484: End If;
1485: If (p_rec.per_information11 = hr_api.g_varchar2) then
1486: p_rec.per_information11 :=
1487: per_per_shd.g_old_rec.per_information11;
1488: End If;
1489: If (p_rec.per_information12 = hr_api.g_varchar2) then
1490: p_rec.per_information12 :=
1491: per_per_shd.g_old_rec.per_information12;
1487: per_per_shd.g_old_rec.per_information11;
1488: End If;
1489: If (p_rec.per_information12 = hr_api.g_varchar2) then
1490: p_rec.per_information12 :=
1491: per_per_shd.g_old_rec.per_information12;
1492: End If;
1493: If (p_rec.per_information13 = hr_api.g_varchar2) then
1494: p_rec.per_information13 :=
1495: per_per_shd.g_old_rec.per_information13;
1491: per_per_shd.g_old_rec.per_information12;
1492: End If;
1493: If (p_rec.per_information13 = hr_api.g_varchar2) then
1494: p_rec.per_information13 :=
1495: per_per_shd.g_old_rec.per_information13;
1496: End If;
1497: If (p_rec.per_information14 = hr_api.g_varchar2) then
1498: p_rec.per_information14 :=
1499: per_per_shd.g_old_rec.per_information14;
1495: per_per_shd.g_old_rec.per_information13;
1496: End If;
1497: If (p_rec.per_information14 = hr_api.g_varchar2) then
1498: p_rec.per_information14 :=
1499: per_per_shd.g_old_rec.per_information14;
1500: End If;
1501: If (p_rec.per_information15 = hr_api.g_varchar2) then
1502: p_rec.per_information15 :=
1503: per_per_shd.g_old_rec.per_information15;
1499: per_per_shd.g_old_rec.per_information14;
1500: End If;
1501: If (p_rec.per_information15 = hr_api.g_varchar2) then
1502: p_rec.per_information15 :=
1503: per_per_shd.g_old_rec.per_information15;
1504: End If;
1505: If (p_rec.per_information16 = hr_api.g_varchar2) then
1506: p_rec.per_information16 :=
1507: per_per_shd.g_old_rec.per_information16;
1503: per_per_shd.g_old_rec.per_information15;
1504: End If;
1505: If (p_rec.per_information16 = hr_api.g_varchar2) then
1506: p_rec.per_information16 :=
1507: per_per_shd.g_old_rec.per_information16;
1508: End If;
1509: If (p_rec.per_information17 = hr_api.g_varchar2) then
1510: p_rec.per_information17 :=
1511: per_per_shd.g_old_rec.per_information17;
1507: per_per_shd.g_old_rec.per_information16;
1508: End If;
1509: If (p_rec.per_information17 = hr_api.g_varchar2) then
1510: p_rec.per_information17 :=
1511: per_per_shd.g_old_rec.per_information17;
1512: End If;
1513: If (p_rec.per_information18 = hr_api.g_varchar2) then
1514: p_rec.per_information18 :=
1515: per_per_shd.g_old_rec.per_information18;
1511: per_per_shd.g_old_rec.per_information17;
1512: End If;
1513: If (p_rec.per_information18 = hr_api.g_varchar2) then
1514: p_rec.per_information18 :=
1515: per_per_shd.g_old_rec.per_information18;
1516: End If;
1517: If (p_rec.per_information19 = hr_api.g_varchar2) then
1518: p_rec.per_information19 :=
1519: per_per_shd.g_old_rec.per_information19;
1515: per_per_shd.g_old_rec.per_information18;
1516: End If;
1517: If (p_rec.per_information19 = hr_api.g_varchar2) then
1518: p_rec.per_information19 :=
1519: per_per_shd.g_old_rec.per_information19;
1520: End If;
1521: If (p_rec.per_information20 = hr_api.g_varchar2) then
1522: p_rec.per_information20 :=
1523: per_per_shd.g_old_rec.per_information20;
1519: per_per_shd.g_old_rec.per_information19;
1520: End If;
1521: If (p_rec.per_information20 = hr_api.g_varchar2) then
1522: p_rec.per_information20 :=
1523: per_per_shd.g_old_rec.per_information20;
1524: End If;
1525: If (p_rec.suffix = hr_api.g_varchar2) then
1526: p_rec.suffix := per_per_shd.g_old_rec.suffix;
1527: End If;
1522: p_rec.per_information20 :=
1523: per_per_shd.g_old_rec.per_information20;
1524: End If;
1525: If (p_rec.suffix = hr_api.g_varchar2) then
1526: p_rec.suffix := per_per_shd.g_old_rec.suffix;
1527: End If;
1528: If (p_rec.DATE_OF_DEATH = hr_api.g_date) then
1529: p_rec.DATE_OF_DEATH := per_per_shd.g_old_rec.DATE_OF_DEATH ;
1530: End If;
1525: If (p_rec.suffix = hr_api.g_varchar2) then
1526: p_rec.suffix := per_per_shd.g_old_rec.suffix;
1527: End If;
1528: If (p_rec.DATE_OF_DEATH = hr_api.g_date) then
1529: p_rec.DATE_OF_DEATH := per_per_shd.g_old_rec.DATE_OF_DEATH ;
1530: End If;
1531: If (p_rec.BACKGROUND_CHECK_STATUS = hr_api.g_varchar2) then
1532: p_rec.BACKGROUND_CHECK_STATUS := per_per_shd.g_old_rec.BACKGROUND_CHECK_STATUS ;
1533: End If;
1528: If (p_rec.DATE_OF_DEATH = hr_api.g_date) then
1529: p_rec.DATE_OF_DEATH := per_per_shd.g_old_rec.DATE_OF_DEATH ;
1530: End If;
1531: If (p_rec.BACKGROUND_CHECK_STATUS = hr_api.g_varchar2) then
1532: p_rec.BACKGROUND_CHECK_STATUS := per_per_shd.g_old_rec.BACKGROUND_CHECK_STATUS ;
1533: End If;
1534: If (p_rec.BACKGROUND_DATE_CHECK = hr_api.g_date) then
1535: p_rec.BACKGROUND_DATE_CHECK := per_per_shd.g_old_rec.BACKGROUND_DATE_CHECK ;
1536: End If;
1531: If (p_rec.BACKGROUND_CHECK_STATUS = hr_api.g_varchar2) then
1532: p_rec.BACKGROUND_CHECK_STATUS := per_per_shd.g_old_rec.BACKGROUND_CHECK_STATUS ;
1533: End If;
1534: If (p_rec.BACKGROUND_DATE_CHECK = hr_api.g_date) then
1535: p_rec.BACKGROUND_DATE_CHECK := per_per_shd.g_old_rec.BACKGROUND_DATE_CHECK ;
1536: End If;
1537: If (p_rec.BLOOD_TYPE = hr_api.g_varchar2) then
1538: p_rec.BLOOD_TYPE := per_per_shd.g_old_rec.BLOOD_TYPE ;
1539: End If;
1534: If (p_rec.BACKGROUND_DATE_CHECK = hr_api.g_date) then
1535: p_rec.BACKGROUND_DATE_CHECK := per_per_shd.g_old_rec.BACKGROUND_DATE_CHECK ;
1536: End If;
1537: If (p_rec.BLOOD_TYPE = hr_api.g_varchar2) then
1538: p_rec.BLOOD_TYPE := per_per_shd.g_old_rec.BLOOD_TYPE ;
1539: End If;
1540: If (p_rec.CORRESPONDENCE_LANGUAGE = hr_api.g_varchar2) then
1541: p_rec.CORRESPONDENCE_LANGUAGE := per_per_shd.g_old_rec.CORRESPONDENCE_LANGUAGE ;
1542: End If;
1537: If (p_rec.BLOOD_TYPE = hr_api.g_varchar2) then
1538: p_rec.BLOOD_TYPE := per_per_shd.g_old_rec.BLOOD_TYPE ;
1539: End If;
1540: If (p_rec.CORRESPONDENCE_LANGUAGE = hr_api.g_varchar2) then
1541: p_rec.CORRESPONDENCE_LANGUAGE := per_per_shd.g_old_rec.CORRESPONDENCE_LANGUAGE ;
1542: End If;
1543: If (p_rec.FAST_PATH_EMPLOYEE = hr_api.g_varchar2) then
1544: p_rec.FAST_PATH_EMPLOYEE := per_per_shd.g_old_rec.FAST_PATH_EMPLOYEE ;
1545: End If;
1540: If (p_rec.CORRESPONDENCE_LANGUAGE = hr_api.g_varchar2) then
1541: p_rec.CORRESPONDENCE_LANGUAGE := per_per_shd.g_old_rec.CORRESPONDENCE_LANGUAGE ;
1542: End If;
1543: If (p_rec.FAST_PATH_EMPLOYEE = hr_api.g_varchar2) then
1544: p_rec.FAST_PATH_EMPLOYEE := per_per_shd.g_old_rec.FAST_PATH_EMPLOYEE ;
1545: End If;
1546: If (p_rec.FTE_CAPACITY = hr_api.g_number) then
1547: p_rec.FTE_CAPACITY := per_per_shd.g_old_rec.FTE_CAPACITY ;
1548: End If;
1543: If (p_rec.FAST_PATH_EMPLOYEE = hr_api.g_varchar2) then
1544: p_rec.FAST_PATH_EMPLOYEE := per_per_shd.g_old_rec.FAST_PATH_EMPLOYEE ;
1545: End If;
1546: If (p_rec.FTE_CAPACITY = hr_api.g_number) then
1547: p_rec.FTE_CAPACITY := per_per_shd.g_old_rec.FTE_CAPACITY ;
1548: End If;
1549: If (p_rec.HOLD_APPLICANT_DATE_UNTIL = hr_api.g_date) then
1550: p_rec.HOLD_APPLICANT_DATE_UNTIL := per_per_shd.g_old_rec.HOLD_APPLICANT_DATE_UNTIL;
1551: End If;
1546: If (p_rec.FTE_CAPACITY = hr_api.g_number) then
1547: p_rec.FTE_CAPACITY := per_per_shd.g_old_rec.FTE_CAPACITY ;
1548: End If;
1549: If (p_rec.HOLD_APPLICANT_DATE_UNTIL = hr_api.g_date) then
1550: p_rec.HOLD_APPLICANT_DATE_UNTIL := per_per_shd.g_old_rec.HOLD_APPLICANT_DATE_UNTIL;
1551: End If;
1552: If (p_rec.HONORS = hr_api.g_varchar2) then
1553: p_rec.HONORS := per_per_shd.g_old_rec.HONORS ;
1554: End If;
1549: If (p_rec.HOLD_APPLICANT_DATE_UNTIL = hr_api.g_date) then
1550: p_rec.HOLD_APPLICANT_DATE_UNTIL := per_per_shd.g_old_rec.HOLD_APPLICANT_DATE_UNTIL;
1551: End If;
1552: If (p_rec.HONORS = hr_api.g_varchar2) then
1553: p_rec.HONORS := per_per_shd.g_old_rec.HONORS ;
1554: End If;
1555: If (p_rec.INTERNAL_LOCATION = hr_api.g_varchar2) then
1556: p_rec.INTERNAL_LOCATION := per_per_shd.g_old_rec.INTERNAL_LOCATION ;
1557: End If;
1552: If (p_rec.HONORS = hr_api.g_varchar2) then
1553: p_rec.HONORS := per_per_shd.g_old_rec.HONORS ;
1554: End If;
1555: If (p_rec.INTERNAL_LOCATION = hr_api.g_varchar2) then
1556: p_rec.INTERNAL_LOCATION := per_per_shd.g_old_rec.INTERNAL_LOCATION ;
1557: End If;
1558: If (p_rec.LAST_MEDICAL_TEST_BY = hr_api.g_varchar2) then
1559: p_rec.LAST_MEDICAL_TEST_BY := per_per_shd.g_old_rec.LAST_MEDICAL_TEST_BY ;
1560: End If;
1555: If (p_rec.INTERNAL_LOCATION = hr_api.g_varchar2) then
1556: p_rec.INTERNAL_LOCATION := per_per_shd.g_old_rec.INTERNAL_LOCATION ;
1557: End If;
1558: If (p_rec.LAST_MEDICAL_TEST_BY = hr_api.g_varchar2) then
1559: p_rec.LAST_MEDICAL_TEST_BY := per_per_shd.g_old_rec.LAST_MEDICAL_TEST_BY ;
1560: End If;
1561: If (p_rec.LAST_MEDICAL_TEST_DATE = hr_api.g_date) then
1562: p_rec.LAST_MEDICAL_TEST_DATE := per_per_shd.g_old_rec.LAST_MEDICAL_TEST_DATE ;
1563: End If;
1558: If (p_rec.LAST_MEDICAL_TEST_BY = hr_api.g_varchar2) then
1559: p_rec.LAST_MEDICAL_TEST_BY := per_per_shd.g_old_rec.LAST_MEDICAL_TEST_BY ;
1560: End If;
1561: If (p_rec.LAST_MEDICAL_TEST_DATE = hr_api.g_date) then
1562: p_rec.LAST_MEDICAL_TEST_DATE := per_per_shd.g_old_rec.LAST_MEDICAL_TEST_DATE ;
1563: End If;
1564: If (p_rec.MAILSTOP = hr_api.g_varchar2) then
1565: p_rec.MAILSTOP := per_per_shd.g_old_rec.MAILSTOP ;
1566: End If;
1561: If (p_rec.LAST_MEDICAL_TEST_DATE = hr_api.g_date) then
1562: p_rec.LAST_MEDICAL_TEST_DATE := per_per_shd.g_old_rec.LAST_MEDICAL_TEST_DATE ;
1563: End If;
1564: If (p_rec.MAILSTOP = hr_api.g_varchar2) then
1565: p_rec.MAILSTOP := per_per_shd.g_old_rec.MAILSTOP ;
1566: End If;
1567: If (p_rec.OFFICE_NUMBER = hr_api.g_varchar2) then
1568: p_rec.OFFICE_NUMBER := per_per_shd.g_old_rec.OFFICE_NUMBER ;
1569: End If;
1564: If (p_rec.MAILSTOP = hr_api.g_varchar2) then
1565: p_rec.MAILSTOP := per_per_shd.g_old_rec.MAILSTOP ;
1566: End If;
1567: If (p_rec.OFFICE_NUMBER = hr_api.g_varchar2) then
1568: p_rec.OFFICE_NUMBER := per_per_shd.g_old_rec.OFFICE_NUMBER ;
1569: End If;
1570: If (p_rec.ON_MILITARY_SERVICE = hr_api.g_varchar2) then
1571: p_rec.ON_MILITARY_SERVICE := per_per_shd.g_old_rec.ON_MILITARY_SERVICE ;
1572: End If;
1567: If (p_rec.OFFICE_NUMBER = hr_api.g_varchar2) then
1568: p_rec.OFFICE_NUMBER := per_per_shd.g_old_rec.OFFICE_NUMBER ;
1569: End If;
1570: If (p_rec.ON_MILITARY_SERVICE = hr_api.g_varchar2) then
1571: p_rec.ON_MILITARY_SERVICE := per_per_shd.g_old_rec.ON_MILITARY_SERVICE ;
1572: End If;
1573: If (p_rec.ORDER_NAME = hr_api.g_varchar2) then
1574: p_rec.ORDER_NAME := per_per_shd.g_old_rec.ORDER_NAME ;
1575: End If;
1570: If (p_rec.ON_MILITARY_SERVICE = hr_api.g_varchar2) then
1571: p_rec.ON_MILITARY_SERVICE := per_per_shd.g_old_rec.ON_MILITARY_SERVICE ;
1572: End If;
1573: If (p_rec.ORDER_NAME = hr_api.g_varchar2) then
1574: p_rec.ORDER_NAME := per_per_shd.g_old_rec.ORDER_NAME ;
1575: End If;
1576: If (p_rec.PRE_NAME_ADJUNCT = hr_api.g_varchar2) then
1577: p_rec.PRE_NAME_ADJUNCT := per_per_shd.g_old_rec.PRE_NAME_ADJUNCT ;
1578: End If;
1573: If (p_rec.ORDER_NAME = hr_api.g_varchar2) then
1574: p_rec.ORDER_NAME := per_per_shd.g_old_rec.ORDER_NAME ;
1575: End If;
1576: If (p_rec.PRE_NAME_ADJUNCT = hr_api.g_varchar2) then
1577: p_rec.PRE_NAME_ADJUNCT := per_per_shd.g_old_rec.PRE_NAME_ADJUNCT ;
1578: End If;
1579: If (p_rec.PROJECTED_START_DATE = hr_api.g_date) then
1580: p_rec.PROJECTED_START_DATE := per_per_shd.g_old_rec.PROJECTED_START_DATE ;
1581: End If;
1576: If (p_rec.PRE_NAME_ADJUNCT = hr_api.g_varchar2) then
1577: p_rec.PRE_NAME_ADJUNCT := per_per_shd.g_old_rec.PRE_NAME_ADJUNCT ;
1578: End If;
1579: If (p_rec.PROJECTED_START_DATE = hr_api.g_date) then
1580: p_rec.PROJECTED_START_DATE := per_per_shd.g_old_rec.PROJECTED_START_DATE ;
1581: End If;
1582: If (p_rec.REHIRE_AUTHORIZOR = hr_api.g_varchar2) then
1583: p_rec.REHIRE_AUTHORIZOR := per_per_shd.g_old_rec.REHIRE_AUTHORIZOR ;
1584: End If;
1579: If (p_rec.PROJECTED_START_DATE = hr_api.g_date) then
1580: p_rec.PROJECTED_START_DATE := per_per_shd.g_old_rec.PROJECTED_START_DATE ;
1581: End If;
1582: If (p_rec.REHIRE_AUTHORIZOR = hr_api.g_varchar2) then
1583: p_rec.REHIRE_AUTHORIZOR := per_per_shd.g_old_rec.REHIRE_AUTHORIZOR ;
1584: End If;
1585: If (p_rec.REHIRE_RECOMMENDATION = hr_api.g_varchar2) then
1586: p_rec.REHIRE_RECOMMENDATION := per_per_shd.g_old_rec.REHIRE_RECOMMENDATION ;
1587: End If;
1582: If (p_rec.REHIRE_AUTHORIZOR = hr_api.g_varchar2) then
1583: p_rec.REHIRE_AUTHORIZOR := per_per_shd.g_old_rec.REHIRE_AUTHORIZOR ;
1584: End If;
1585: If (p_rec.REHIRE_RECOMMENDATION = hr_api.g_varchar2) then
1586: p_rec.REHIRE_RECOMMENDATION := per_per_shd.g_old_rec.REHIRE_RECOMMENDATION ;
1587: End If;
1588: If (p_rec.RESUME_EXISTS = hr_api.g_varchar2) then
1589: p_rec.RESUME_EXISTS := per_per_shd.g_old_rec.RESUME_EXISTS ;
1590: End If;
1585: If (p_rec.REHIRE_RECOMMENDATION = hr_api.g_varchar2) then
1586: p_rec.REHIRE_RECOMMENDATION := per_per_shd.g_old_rec.REHIRE_RECOMMENDATION ;
1587: End If;
1588: If (p_rec.RESUME_EXISTS = hr_api.g_varchar2) then
1589: p_rec.RESUME_EXISTS := per_per_shd.g_old_rec.RESUME_EXISTS ;
1590: End If;
1591: If (p_rec.RESUME_LAST_UPDATED = hr_api.g_date) then
1592: p_rec.RESUME_LAST_UPDATED := per_per_shd.g_old_rec.RESUME_LAST_UPDATED ;
1593: End If;
1588: If (p_rec.RESUME_EXISTS = hr_api.g_varchar2) then
1589: p_rec.RESUME_EXISTS := per_per_shd.g_old_rec.RESUME_EXISTS ;
1590: End If;
1591: If (p_rec.RESUME_LAST_UPDATED = hr_api.g_date) then
1592: p_rec.RESUME_LAST_UPDATED := per_per_shd.g_old_rec.RESUME_LAST_UPDATED ;
1593: End If;
1594: If (p_rec.SECOND_PASSPORT_EXISTS = hr_api.g_varchar2) then
1595: p_rec.SECOND_PASSPORT_EXISTS := per_per_shd.g_old_rec.SECOND_PASSPORT_EXISTS ;
1596: End If;
1591: If (p_rec.RESUME_LAST_UPDATED = hr_api.g_date) then
1592: p_rec.RESUME_LAST_UPDATED := per_per_shd.g_old_rec.RESUME_LAST_UPDATED ;
1593: End If;
1594: If (p_rec.SECOND_PASSPORT_EXISTS = hr_api.g_varchar2) then
1595: p_rec.SECOND_PASSPORT_EXISTS := per_per_shd.g_old_rec.SECOND_PASSPORT_EXISTS ;
1596: End If;
1597: If (p_rec.STUDENT_STATUS = hr_api.g_varchar2) then
1598: p_rec.STUDENT_STATUS := per_per_shd.g_old_rec.STUDENT_STATUS ;
1599: End If;
1594: If (p_rec.SECOND_PASSPORT_EXISTS = hr_api.g_varchar2) then
1595: p_rec.SECOND_PASSPORT_EXISTS := per_per_shd.g_old_rec.SECOND_PASSPORT_EXISTS ;
1596: End If;
1597: If (p_rec.STUDENT_STATUS = hr_api.g_varchar2) then
1598: p_rec.STUDENT_STATUS := per_per_shd.g_old_rec.STUDENT_STATUS ;
1599: End If;
1600: If (p_rec.WORK_SCHEDULE = hr_api.g_varchar2) then
1601: p_rec.WORK_SCHEDULE := per_per_shd.g_old_rec.WORK_SCHEDULE ;
1602: End If;
1597: If (p_rec.STUDENT_STATUS = hr_api.g_varchar2) then
1598: p_rec.STUDENT_STATUS := per_per_shd.g_old_rec.STUDENT_STATUS ;
1599: End If;
1600: If (p_rec.WORK_SCHEDULE = hr_api.g_varchar2) then
1601: p_rec.WORK_SCHEDULE := per_per_shd.g_old_rec.WORK_SCHEDULE ;
1602: End If;
1603: If (p_rec.PER_INFORMATION21 = hr_api.g_varchar2) then
1604: p_rec.PER_INFORMATION21 := per_per_shd.g_old_rec.PER_INFORMATION21 ;
1605: End If;
1600: If (p_rec.WORK_SCHEDULE = hr_api.g_varchar2) then
1601: p_rec.WORK_SCHEDULE := per_per_shd.g_old_rec.WORK_SCHEDULE ;
1602: End If;
1603: If (p_rec.PER_INFORMATION21 = hr_api.g_varchar2) then
1604: p_rec.PER_INFORMATION21 := per_per_shd.g_old_rec.PER_INFORMATION21 ;
1605: End If;
1606: If (p_rec.PER_INFORMATION22 = hr_api.g_varchar2) then
1607: p_rec.PER_INFORMATION22 := per_per_shd.g_old_rec.PER_INFORMATION22 ;
1608: End If;
1603: If (p_rec.PER_INFORMATION21 = hr_api.g_varchar2) then
1604: p_rec.PER_INFORMATION21 := per_per_shd.g_old_rec.PER_INFORMATION21 ;
1605: End If;
1606: If (p_rec.PER_INFORMATION22 = hr_api.g_varchar2) then
1607: p_rec.PER_INFORMATION22 := per_per_shd.g_old_rec.PER_INFORMATION22 ;
1608: End If;
1609: If (p_rec.PER_INFORMATION23 = hr_api.g_varchar2) then
1610: p_rec.PER_INFORMATION23 := per_per_shd.g_old_rec.PER_INFORMATION23 ;
1611: End If;
1606: If (p_rec.PER_INFORMATION22 = hr_api.g_varchar2) then
1607: p_rec.PER_INFORMATION22 := per_per_shd.g_old_rec.PER_INFORMATION22 ;
1608: End If;
1609: If (p_rec.PER_INFORMATION23 = hr_api.g_varchar2) then
1610: p_rec.PER_INFORMATION23 := per_per_shd.g_old_rec.PER_INFORMATION23 ;
1611: End If;
1612: If (p_rec.PER_INFORMATION24 = hr_api.g_varchar2) then
1613: p_rec.PER_INFORMATION24 := per_per_shd.g_old_rec.PER_INFORMATION24 ;
1614: End If;
1609: If (p_rec.PER_INFORMATION23 = hr_api.g_varchar2) then
1610: p_rec.PER_INFORMATION23 := per_per_shd.g_old_rec.PER_INFORMATION23 ;
1611: End If;
1612: If (p_rec.PER_INFORMATION24 = hr_api.g_varchar2) then
1613: p_rec.PER_INFORMATION24 := per_per_shd.g_old_rec.PER_INFORMATION24 ;
1614: End If;
1615: If (p_rec.PER_INFORMATION25 = hr_api.g_varchar2) then
1616: p_rec.PER_INFORMATION25 := per_per_shd.g_old_rec.PER_INFORMATION25 ;
1617: End If;
1612: If (p_rec.PER_INFORMATION24 = hr_api.g_varchar2) then
1613: p_rec.PER_INFORMATION24 := per_per_shd.g_old_rec.PER_INFORMATION24 ;
1614: End If;
1615: If (p_rec.PER_INFORMATION25 = hr_api.g_varchar2) then
1616: p_rec.PER_INFORMATION25 := per_per_shd.g_old_rec.PER_INFORMATION25 ;
1617: End If;
1618: If (p_rec.PER_INFORMATION26 = hr_api.g_varchar2) then
1619: p_rec.PER_INFORMATION26 := per_per_shd.g_old_rec.PER_INFORMATION26 ;
1620: End If;
1615: If (p_rec.PER_INFORMATION25 = hr_api.g_varchar2) then
1616: p_rec.PER_INFORMATION25 := per_per_shd.g_old_rec.PER_INFORMATION25 ;
1617: End If;
1618: If (p_rec.PER_INFORMATION26 = hr_api.g_varchar2) then
1619: p_rec.PER_INFORMATION26 := per_per_shd.g_old_rec.PER_INFORMATION26 ;
1620: End If;
1621: If (p_rec.PER_INFORMATION27 = hr_api.g_varchar2) then
1622: p_rec.PER_INFORMATION27 := per_per_shd.g_old_rec.PER_INFORMATION27 ;
1623: End If;
1618: If (p_rec.PER_INFORMATION26 = hr_api.g_varchar2) then
1619: p_rec.PER_INFORMATION26 := per_per_shd.g_old_rec.PER_INFORMATION26 ;
1620: End If;
1621: If (p_rec.PER_INFORMATION27 = hr_api.g_varchar2) then
1622: p_rec.PER_INFORMATION27 := per_per_shd.g_old_rec.PER_INFORMATION27 ;
1623: End If;
1624: If (p_rec.PER_INFORMATION28 = hr_api.g_varchar2) then
1625: p_rec.PER_INFORMATION28 := per_per_shd.g_old_rec.PER_INFORMATION28 ;
1626: End If;
1621: If (p_rec.PER_INFORMATION27 = hr_api.g_varchar2) then
1622: p_rec.PER_INFORMATION27 := per_per_shd.g_old_rec.PER_INFORMATION27 ;
1623: End If;
1624: If (p_rec.PER_INFORMATION28 = hr_api.g_varchar2) then
1625: p_rec.PER_INFORMATION28 := per_per_shd.g_old_rec.PER_INFORMATION28 ;
1626: End If;
1627: If (p_rec.PER_INFORMATION29 = hr_api.g_varchar2) then
1628: p_rec.PER_INFORMATION29 := per_per_shd.g_old_rec.PER_INFORMATION29 ;
1629: End If;
1624: If (p_rec.PER_INFORMATION28 = hr_api.g_varchar2) then
1625: p_rec.PER_INFORMATION28 := per_per_shd.g_old_rec.PER_INFORMATION28 ;
1626: End If;
1627: If (p_rec.PER_INFORMATION29 = hr_api.g_varchar2) then
1628: p_rec.PER_INFORMATION29 := per_per_shd.g_old_rec.PER_INFORMATION29 ;
1629: End If;
1630: If (p_rec.PER_INFORMATION30 = hr_api.g_varchar2) then
1631: p_rec.PER_INFORMATION30 := per_per_shd.g_old_rec.PER_INFORMATION30 ;
1632: End If;
1627: If (p_rec.PER_INFORMATION29 = hr_api.g_varchar2) then
1628: p_rec.PER_INFORMATION29 := per_per_shd.g_old_rec.PER_INFORMATION29 ;
1629: End If;
1630: If (p_rec.PER_INFORMATION30 = hr_api.g_varchar2) then
1631: p_rec.PER_INFORMATION30 := per_per_shd.g_old_rec.PER_INFORMATION30 ;
1632: End If;
1633: If (p_rec.REHIRE_REASON = hr_api.g_varchar2) then
1634: p_rec.REHIRE_REASON := per_per_shd.g_old_rec.REHIRE_REASON ;
1635: End If;
1630: If (p_rec.PER_INFORMATION30 = hr_api.g_varchar2) then
1631: p_rec.PER_INFORMATION30 := per_per_shd.g_old_rec.PER_INFORMATION30 ;
1632: End If;
1633: If (p_rec.REHIRE_REASON = hr_api.g_varchar2) then
1634: p_rec.REHIRE_REASON := per_per_shd.g_old_rec.REHIRE_REASON ;
1635: End If;
1636: If (p_rec.BENEFIT_GROUP_ID = hr_api.g_number) then
1637: p_rec.BENEFIT_GROUP_ID := per_per_shd.g_old_rec.BENEFIT_GROUP_ID ;
1638: End If;
1633: If (p_rec.REHIRE_REASON = hr_api.g_varchar2) then
1634: p_rec.REHIRE_REASON := per_per_shd.g_old_rec.REHIRE_REASON ;
1635: End If;
1636: If (p_rec.BENEFIT_GROUP_ID = hr_api.g_number) then
1637: p_rec.BENEFIT_GROUP_ID := per_per_shd.g_old_rec.BENEFIT_GROUP_ID ;
1638: End If;
1639: If (p_rec.RECEIPT_OF_DEATH_CERT_DATE = hr_api.g_date) then
1640: p_rec.RECEIPT_OF_DEATH_CERT_DATE := per_per_shd.g_old_rec.RECEIPT_OF_DEATH_CERT_DATE ;
1641: End If;
1636: If (p_rec.BENEFIT_GROUP_ID = hr_api.g_number) then
1637: p_rec.BENEFIT_GROUP_ID := per_per_shd.g_old_rec.BENEFIT_GROUP_ID ;
1638: End If;
1639: If (p_rec.RECEIPT_OF_DEATH_CERT_DATE = hr_api.g_date) then
1640: p_rec.RECEIPT_OF_DEATH_CERT_DATE := per_per_shd.g_old_rec.RECEIPT_OF_DEATH_CERT_DATE ;
1641: End If;
1642: If (p_rec.COORD_BEN_MED_PLN_NO = hr_api.g_varchar2) then
1643: p_rec.COORD_BEN_MED_PLN_NO := per_per_shd.g_old_rec.COORD_BEN_MED_PLN_NO ;
1644: End If;
1639: If (p_rec.RECEIPT_OF_DEATH_CERT_DATE = hr_api.g_date) then
1640: p_rec.RECEIPT_OF_DEATH_CERT_DATE := per_per_shd.g_old_rec.RECEIPT_OF_DEATH_CERT_DATE ;
1641: End If;
1642: If (p_rec.COORD_BEN_MED_PLN_NO = hr_api.g_varchar2) then
1643: p_rec.COORD_BEN_MED_PLN_NO := per_per_shd.g_old_rec.COORD_BEN_MED_PLN_NO ;
1644: End If;
1645: If (p_rec.COORD_BEN_NO_CVG_FLAG = hr_api.g_varchar2) then
1646: p_rec.COORD_BEN_NO_CVG_FLAG := per_per_shd.g_old_rec.COORD_BEN_NO_CVG_FLAG ;
1647: End If;
1642: If (p_rec.COORD_BEN_MED_PLN_NO = hr_api.g_varchar2) then
1643: p_rec.COORD_BEN_MED_PLN_NO := per_per_shd.g_old_rec.COORD_BEN_MED_PLN_NO ;
1644: End If;
1645: If (p_rec.COORD_BEN_NO_CVG_FLAG = hr_api.g_varchar2) then
1646: p_rec.COORD_BEN_NO_CVG_FLAG := per_per_shd.g_old_rec.COORD_BEN_NO_CVG_FLAG ;
1647: End If;
1648: if (p_rec.COORD_BEN_MED_EXT_ER = hr_api.g_varchar2) then
1649: p_rec.COORD_BEN_MED_EXT_ER:= per_per_shd.g_old_rec.COORD_BEN_MED_EXT_ER;
1650: end if;
1645: If (p_rec.COORD_BEN_NO_CVG_FLAG = hr_api.g_varchar2) then
1646: p_rec.COORD_BEN_NO_CVG_FLAG := per_per_shd.g_old_rec.COORD_BEN_NO_CVG_FLAG ;
1647: End If;
1648: if (p_rec.COORD_BEN_MED_EXT_ER = hr_api.g_varchar2) then
1649: p_rec.COORD_BEN_MED_EXT_ER:= per_per_shd.g_old_rec.COORD_BEN_MED_EXT_ER;
1650: end if;
1651: if (p_rec.COORD_BEN_MED_PL_NAME = hr_api.g_varchar2) then
1652: p_rec.COORD_BEN_MED_PL_NAME:= per_per_shd.g_old_rec.COORD_BEN_MED_PL_NAME;
1653: end if;
1648: if (p_rec.COORD_BEN_MED_EXT_ER = hr_api.g_varchar2) then
1649: p_rec.COORD_BEN_MED_EXT_ER:= per_per_shd.g_old_rec.COORD_BEN_MED_EXT_ER;
1650: end if;
1651: if (p_rec.COORD_BEN_MED_PL_NAME = hr_api.g_varchar2) then
1652: p_rec.COORD_BEN_MED_PL_NAME:= per_per_shd.g_old_rec.COORD_BEN_MED_PL_NAME;
1653: end if;
1654: if (p_rec.COORD_BEN_MED_INSR_CRR_NAME = hr_api.g_varchar2) then
1655: p_rec.COORD_BEN_MED_INSR_CRR_NAME:= per_per_shd.g_old_rec.COORD_BEN_MED_INSR_CRR_NAME;
1656: end if;
1651: if (p_rec.COORD_BEN_MED_PL_NAME = hr_api.g_varchar2) then
1652: p_rec.COORD_BEN_MED_PL_NAME:= per_per_shd.g_old_rec.COORD_BEN_MED_PL_NAME;
1653: end if;
1654: if (p_rec.COORD_BEN_MED_INSR_CRR_NAME = hr_api.g_varchar2) then
1655: p_rec.COORD_BEN_MED_INSR_CRR_NAME:= per_per_shd.g_old_rec.COORD_BEN_MED_INSR_CRR_NAME;
1656: end if;
1657: if (p_rec.COORD_BEN_MED_INSR_CRR_IDENT = hr_api.g_varchar2) then
1658: p_rec.COORD_BEN_MED_INSR_CRR_IDENT:= per_per_shd.g_old_rec.COORD_BEN_MED_INSR_CRR_IDENT;
1659: end if;
1654: if (p_rec.COORD_BEN_MED_INSR_CRR_NAME = hr_api.g_varchar2) then
1655: p_rec.COORD_BEN_MED_INSR_CRR_NAME:= per_per_shd.g_old_rec.COORD_BEN_MED_INSR_CRR_NAME;
1656: end if;
1657: if (p_rec.COORD_BEN_MED_INSR_CRR_IDENT = hr_api.g_varchar2) then
1658: p_rec.COORD_BEN_MED_INSR_CRR_IDENT:= per_per_shd.g_old_rec.COORD_BEN_MED_INSR_CRR_IDENT;
1659: end if;
1660: if (p_rec.COORD_BEN_MED_CVG_STRT_DT = hr_api.g_date) then
1661: p_rec.COORD_BEN_MED_CVG_STRT_DT:= per_per_shd.g_old_rec.COORD_BEN_MED_CVG_STRT_DT;
1662: end if;
1657: if (p_rec.COORD_BEN_MED_INSR_CRR_IDENT = hr_api.g_varchar2) then
1658: p_rec.COORD_BEN_MED_INSR_CRR_IDENT:= per_per_shd.g_old_rec.COORD_BEN_MED_INSR_CRR_IDENT;
1659: end if;
1660: if (p_rec.COORD_BEN_MED_CVG_STRT_DT = hr_api.g_date) then
1661: p_rec.COORD_BEN_MED_CVG_STRT_DT:= per_per_shd.g_old_rec.COORD_BEN_MED_CVG_STRT_DT;
1662: end if;
1663: if (p_rec.COORD_BEN_MED_CVG_END_DT = hr_api.g_date) then
1664: p_rec.COORD_BEN_MED_CVG_END_DT := per_per_shd.g_old_rec.COORD_BEN_MED_CVG_END_DT;
1665: end if;
1660: if (p_rec.COORD_BEN_MED_CVG_STRT_DT = hr_api.g_date) then
1661: p_rec.COORD_BEN_MED_CVG_STRT_DT:= per_per_shd.g_old_rec.COORD_BEN_MED_CVG_STRT_DT;
1662: end if;
1663: if (p_rec.COORD_BEN_MED_CVG_END_DT = hr_api.g_date) then
1664: p_rec.COORD_BEN_MED_CVG_END_DT := per_per_shd.g_old_rec.COORD_BEN_MED_CVG_END_DT;
1665: end if;
1666: If (p_rec.USES_TOBACCO_FLAG = hr_api.g_varchar2) then
1667: p_rec.USES_TOBACCO_FLAG := per_per_shd.g_old_rec.USES_TOBACCO_FLAG ;
1668: End If;
1663: if (p_rec.COORD_BEN_MED_CVG_END_DT = hr_api.g_date) then
1664: p_rec.COORD_BEN_MED_CVG_END_DT := per_per_shd.g_old_rec.COORD_BEN_MED_CVG_END_DT;
1665: end if;
1666: If (p_rec.USES_TOBACCO_FLAG = hr_api.g_varchar2) then
1667: p_rec.USES_TOBACCO_FLAG := per_per_shd.g_old_rec.USES_TOBACCO_FLAG ;
1668: End If;
1669: If (p_rec.DPDNT_ADOPTION_DATE = hr_api.g_date) then
1670: p_rec.DPDNT_ADOPTION_DATE := per_per_shd.g_old_rec.DPDNT_ADOPTION_DATE ;
1671: End If;
1666: If (p_rec.USES_TOBACCO_FLAG = hr_api.g_varchar2) then
1667: p_rec.USES_TOBACCO_FLAG := per_per_shd.g_old_rec.USES_TOBACCO_FLAG ;
1668: End If;
1669: If (p_rec.DPDNT_ADOPTION_DATE = hr_api.g_date) then
1670: p_rec.DPDNT_ADOPTION_DATE := per_per_shd.g_old_rec.DPDNT_ADOPTION_DATE ;
1671: End If;
1672: If (p_rec.DPDNT_VLNTRY_SVCE_FLAG = hr_api.g_varchar2) then
1673: p_rec.DPDNT_VLNTRY_SVCE_FLAG := per_per_shd.g_old_rec.DPDNT_VLNTRY_SVCE_FLAG ;
1674: End If;
1669: If (p_rec.DPDNT_ADOPTION_DATE = hr_api.g_date) then
1670: p_rec.DPDNT_ADOPTION_DATE := per_per_shd.g_old_rec.DPDNT_ADOPTION_DATE ;
1671: End If;
1672: If (p_rec.DPDNT_VLNTRY_SVCE_FLAG = hr_api.g_varchar2) then
1673: p_rec.DPDNT_VLNTRY_SVCE_FLAG := per_per_shd.g_old_rec.DPDNT_VLNTRY_SVCE_FLAG ;
1674: End If;
1675: If (p_rec.ORIGINAL_DATE_OF_HIRE = hr_api.g_date) then
1676: p_rec.ORIGINAL_DATE_OF_HIRE := per_per_shd.g_old_rec.ORIGINAL_DATE_OF_HIRE ;
1677: End If;
1672: If (p_rec.DPDNT_VLNTRY_SVCE_FLAG = hr_api.g_varchar2) then
1673: p_rec.DPDNT_VLNTRY_SVCE_FLAG := per_per_shd.g_old_rec.DPDNT_VLNTRY_SVCE_FLAG ;
1674: End If;
1675: If (p_rec.ORIGINAL_DATE_OF_HIRE = hr_api.g_date) then
1676: p_rec.ORIGINAL_DATE_OF_HIRE := per_per_shd.g_old_rec.ORIGINAL_DATE_OF_HIRE ;
1677: End If;
1678: If (p_rec.town_of_birth = hr_api.g_varchar2) then
1679: p_rec.town_of_birth := per_per_shd.g_old_rec.town_of_birth ;
1680: End If;
1675: If (p_rec.ORIGINAL_DATE_OF_HIRE = hr_api.g_date) then
1676: p_rec.ORIGINAL_DATE_OF_HIRE := per_per_shd.g_old_rec.ORIGINAL_DATE_OF_HIRE ;
1677: End If;
1678: If (p_rec.town_of_birth = hr_api.g_varchar2) then
1679: p_rec.town_of_birth := per_per_shd.g_old_rec.town_of_birth ;
1680: End If;
1681: If (p_rec.region_of_birth = hr_api.g_varchar2) then
1682: p_rec.region_of_birth := per_per_shd.g_old_rec.region_of_birth ;
1683: End If;
1678: If (p_rec.town_of_birth = hr_api.g_varchar2) then
1679: p_rec.town_of_birth := per_per_shd.g_old_rec.town_of_birth ;
1680: End If;
1681: If (p_rec.region_of_birth = hr_api.g_varchar2) then
1682: p_rec.region_of_birth := per_per_shd.g_old_rec.region_of_birth ;
1683: End If;
1684: If (p_rec.country_of_birth = hr_api.g_varchar2) then
1685: p_rec.country_of_birth := per_per_shd.g_old_rec.country_of_birth ;
1686: End If;
1681: If (p_rec.region_of_birth = hr_api.g_varchar2) then
1682: p_rec.region_of_birth := per_per_shd.g_old_rec.region_of_birth ;
1683: End If;
1684: If (p_rec.country_of_birth = hr_api.g_varchar2) then
1685: p_rec.country_of_birth := per_per_shd.g_old_rec.country_of_birth ;
1686: End If;
1687: If (p_rec.global_person_id = hr_api.g_varchar2) then
1688: p_rec.global_person_id := per_per_shd.g_old_rec.global_person_id ;
1689: End If;
1684: If (p_rec.country_of_birth = hr_api.g_varchar2) then
1685: p_rec.country_of_birth := per_per_shd.g_old_rec.country_of_birth ;
1686: End If;
1687: If (p_rec.global_person_id = hr_api.g_varchar2) then
1688: p_rec.global_person_id := per_per_shd.g_old_rec.global_person_id ;
1689: End If;
1690: If (p_rec.party_id = hr_api.g_number) then
1691: p_rec.party_id := per_per_shd.g_old_rec.party_id ;
1692: End If;
1687: If (p_rec.global_person_id = hr_api.g_varchar2) then
1688: p_rec.global_person_id := per_per_shd.g_old_rec.global_person_id ;
1689: End If;
1690: If (p_rec.party_id = hr_api.g_number) then
1691: p_rec.party_id := per_per_shd.g_old_rec.party_id ;
1692: End If;
1693: If (p_rec.npw_number = hr_api.g_varchar2) then
1694: p_rec.npw_number := per_per_shd.g_old_rec.npw_number ;
1695: End If;
1690: If (p_rec.party_id = hr_api.g_number) then
1691: p_rec.party_id := per_per_shd.g_old_rec.party_id ;
1692: End If;
1693: If (p_rec.npw_number = hr_api.g_varchar2) then
1694: p_rec.npw_number := per_per_shd.g_old_rec.npw_number ;
1695: End If;
1696: If (p_rec.current_npw_flag = hr_api.g_varchar2) then
1697: p_rec.current_npw_flag := per_per_shd.g_old_rec.current_npw_flag ;
1698: End If;
1693: If (p_rec.npw_number = hr_api.g_varchar2) then
1694: p_rec.npw_number := per_per_shd.g_old_rec.npw_number ;
1695: End If;
1696: If (p_rec.current_npw_flag = hr_api.g_varchar2) then
1697: p_rec.current_npw_flag := per_per_shd.g_old_rec.current_npw_flag ;
1698: End If;
1699: --
1700: -- Return the plsql record structure.
1701: --
1707: -- |---------------------------------< upd >----------------------------------|
1708: -- ----------------------------------------------------------------------------
1709: Procedure upd
1710: (
1711: p_rec in out nocopy per_per_shd.g_rec_type,
1712: p_effective_date in date,
1713: p_datetrack_mode in varchar2,
1714: p_validate in boolean default false,
1715: p_name_combination_warning out nocopy boolean,
1741: End If;
1742: --
1743: -- We must lock the row which we need to update.
1744: --
1745: per_per_shd.lck
1746: (p_effective_date => p_effective_date,
1747: p_datetrack_mode => p_datetrack_mode,
1748: p_person_id => p_rec.person_id,
1749: p_object_version_number => p_rec.object_version_number,
1996: p_dob_null_warning out nocopy boolean,
1997: p_orig_hire_warning out nocopy boolean
1998: ) is
1999: --
2000: l_rec per_per_shd.g_rec_type;
2001: l_proc varchar2(72) := g_package||'upd';
2002: --
2003: Begin
2004: hr_utility.set_location('Entering:'||l_proc, 5);
2006: -- Call conversion function to turn arguments into the
2007: -- l_rec structure.
2008: --
2009: l_rec :=
2010: per_per_shd.convert_args
2011: (
2012: p_person_id,
2013: null,
2014: null,