[Home] [Help]
5: --
6: g_package VARCHAR2(33) := ' per_qh_maintain_update.';
7: PROCEDURE insert_maintain_data
8: (p_effective_date IN DATE
9: ,p_person_id OUT NOCOPY per_all_people_f.person_id%TYPE
10: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
11: ,p_legislation_code IN VARCHAR2
12: ,p_per_effective_start_date IN OUT NOCOPY per_all_people_f.effective_start_date%TYPE
13: ,p_per_effective_end_date IN OUT NOCOPY per_all_people_f.effective_end_date%TYPE
6: g_package VARCHAR2(33) := ' per_qh_maintain_update.';
7: PROCEDURE insert_maintain_data
8: (p_effective_date IN DATE
9: ,p_person_id OUT NOCOPY per_all_people_f.person_id%TYPE
10: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
11: ,p_legislation_code IN VARCHAR2
12: ,p_per_effective_start_date IN OUT NOCOPY per_all_people_f.effective_start_date%TYPE
13: ,p_per_effective_end_date IN OUT NOCOPY per_all_people_f.effective_end_date%TYPE
14: ,p_per_validation_start_date OUT NOCOPY DATE
8: (p_effective_date IN DATE
9: ,p_person_id OUT NOCOPY per_all_people_f.person_id%TYPE
10: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
11: ,p_legislation_code IN VARCHAR2
12: ,p_per_effective_start_date IN OUT NOCOPY per_all_people_f.effective_start_date%TYPE
13: ,p_per_effective_end_date IN OUT NOCOPY per_all_people_f.effective_end_date%TYPE
14: ,p_per_validation_start_date OUT NOCOPY DATE
15: ,p_per_validation_end_date OUT NOCOPY DATE
16: ,p_person_type IN per_person_types.user_person_type%TYPE
9: ,p_person_id OUT NOCOPY per_all_people_f.person_id%TYPE
10: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
11: ,p_legislation_code IN VARCHAR2
12: ,p_per_effective_start_date IN OUT NOCOPY per_all_people_f.effective_start_date%TYPE
13: ,p_per_effective_end_date IN OUT NOCOPY per_all_people_f.effective_end_date%TYPE
14: ,p_per_validation_start_date OUT NOCOPY DATE
15: ,p_per_validation_end_date OUT NOCOPY DATE
16: ,p_person_type IN per_person_types.user_person_type%TYPE
17: ,p_system_person_type IN per_person_types.system_person_type%TYPE
14: ,p_per_validation_start_date OUT NOCOPY DATE
15: ,p_per_validation_end_date OUT NOCOPY DATE
16: ,p_person_type IN per_person_types.user_person_type%TYPE
17: ,p_system_person_type IN per_person_types.system_person_type%TYPE
18: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
19: ,p_last_name IN per_all_people_f.last_name%TYPE
20: ,p_start_date IN per_all_people_f.start_date%TYPE
21: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
22: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
15: ,p_per_validation_end_date OUT NOCOPY DATE
16: ,p_person_type IN per_person_types.user_person_type%TYPE
17: ,p_system_person_type IN per_person_types.system_person_type%TYPE
18: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
19: ,p_last_name IN per_all_people_f.last_name%TYPE
20: ,p_start_date IN per_all_people_f.start_date%TYPE
21: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
22: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
23: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
16: ,p_person_type IN per_person_types.user_person_type%TYPE
17: ,p_system_person_type IN per_person_types.system_person_type%TYPE
18: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
19: ,p_last_name IN per_all_people_f.last_name%TYPE
20: ,p_start_date IN per_all_people_f.start_date%TYPE
21: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
22: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
23: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
24: ,p_blood_type IN per_all_people_f.blood_type%TYPE
17: ,p_system_person_type IN per_person_types.system_person_type%TYPE
18: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
19: ,p_last_name IN per_all_people_f.last_name%TYPE
20: ,p_start_date IN per_all_people_f.start_date%TYPE
21: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
22: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
23: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
24: ,p_blood_type IN per_all_people_f.blood_type%TYPE
25: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
18: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
19: ,p_last_name IN per_all_people_f.last_name%TYPE
20: ,p_start_date IN per_all_people_f.start_date%TYPE
21: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
22: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
23: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
24: ,p_blood_type IN per_all_people_f.blood_type%TYPE
25: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
26: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
19: ,p_last_name IN per_all_people_f.last_name%TYPE
20: ,p_start_date IN per_all_people_f.start_date%TYPE
21: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
22: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
23: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
24: ,p_blood_type IN per_all_people_f.blood_type%TYPE
25: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
26: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
27: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
20: ,p_start_date IN per_all_people_f.start_date%TYPE
21: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
22: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
23: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
24: ,p_blood_type IN per_all_people_f.blood_type%TYPE
25: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
26: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
27: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
28: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
21: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
22: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
23: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
24: ,p_blood_type IN per_all_people_f.blood_type%TYPE
25: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
26: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
27: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
28: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
29: ,p_hire_date IN OUT NOCOPY per_periods_of_service.date_start%TYPE -- Bug 3975241
22: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
23: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
24: ,p_blood_type IN per_all_people_f.blood_type%TYPE
25: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
26: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
27: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
28: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
29: ,p_hire_date IN OUT NOCOPY per_periods_of_service.date_start%TYPE -- Bug 3975241
30: --CWK
23: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
24: ,p_blood_type IN per_all_people_f.blood_type%TYPE
25: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
26: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
27: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
28: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
29: ,p_hire_date IN OUT NOCOPY per_periods_of_service.date_start%TYPE -- Bug 3975241
30: --CWK
31: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
24: ,p_blood_type IN per_all_people_f.blood_type%TYPE
25: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
26: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
27: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
28: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
29: ,p_hire_date IN OUT NOCOPY per_periods_of_service.date_start%TYPE -- Bug 3975241
30: --CWK
31: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
32: ,p_npw_number IN OUT NOCOPY per_all_people_f.npw_number%TYPE
27: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
28: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
29: ,p_hire_date IN OUT NOCOPY per_periods_of_service.date_start%TYPE -- Bug 3975241
30: --CWK
31: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
32: ,p_npw_number IN OUT NOCOPY per_all_people_f.npw_number%TYPE
33: ,p_placement_date_start IN OUT NOCOPY per_all_assignments_f.period_of_placement_date_start%TYPE -- Bug 4287925
34: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
35: ,p_pdp_object_version_number OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
28: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
29: ,p_hire_date IN OUT NOCOPY per_periods_of_service.date_start%TYPE -- Bug 3975241
30: --CWK
31: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
32: ,p_npw_number IN OUT NOCOPY per_all_people_f.npw_number%TYPE
33: ,p_placement_date_start IN OUT NOCOPY per_all_assignments_f.period_of_placement_date_start%TYPE -- Bug 4287925
34: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
35: ,p_pdp_object_version_number OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
36: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
47: ,p_rate_effective_start_date OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
48: ,p_rate_effective_end_date OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
49: ,p_rate_object_version_number OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
50: --
51: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
52: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
53: ,p_email_address IN per_all_people_f.email_address%TYPE
54: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
55: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
48: ,p_rate_effective_end_date OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
49: ,p_rate_object_version_number OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
50: --
51: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
52: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
53: ,p_email_address IN per_all_people_f.email_address%TYPE
54: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
55: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
56: ,p_first_name IN per_all_people_f.first_name%TYPE
49: ,p_rate_object_version_number OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
50: --
51: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
52: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
53: ,p_email_address IN per_all_people_f.email_address%TYPE
54: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
55: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
56: ,p_first_name IN per_all_people_f.first_name%TYPE
57: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
50: --
51: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
52: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
53: ,p_email_address IN per_all_people_f.email_address%TYPE
54: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
55: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
56: ,p_first_name IN per_all_people_f.first_name%TYPE
57: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
58: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
51: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
52: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
53: ,p_email_address IN per_all_people_f.email_address%TYPE
54: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
55: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
56: ,p_first_name IN per_all_people_f.first_name%TYPE
57: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
58: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
59: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
52: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
53: ,p_email_address IN per_all_people_f.email_address%TYPE
54: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
55: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
56: ,p_first_name IN per_all_people_f.first_name%TYPE
57: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
58: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
59: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
60: ,p_honors IN per_all_people_f.honors%TYPE
53: ,p_email_address IN per_all_people_f.email_address%TYPE
54: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
55: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
56: ,p_first_name IN per_all_people_f.first_name%TYPE
57: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
58: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
59: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
60: ,p_honors IN per_all_people_f.honors%TYPE
61: ,p_internal_location IN per_all_people_f.internal_location%TYPE
54: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
55: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
56: ,p_first_name IN per_all_people_f.first_name%TYPE
57: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
58: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
59: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
60: ,p_honors IN per_all_people_f.honors%TYPE
61: ,p_internal_location IN per_all_people_f.internal_location%TYPE
62: ,p_known_as IN per_all_people_f.known_as%TYPE
55: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
56: ,p_first_name IN per_all_people_f.first_name%TYPE
57: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
58: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
59: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
60: ,p_honors IN per_all_people_f.honors%TYPE
61: ,p_internal_location IN per_all_people_f.internal_location%TYPE
62: ,p_known_as IN per_all_people_f.known_as%TYPE
63: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
56: ,p_first_name IN per_all_people_f.first_name%TYPE
57: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
58: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
59: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
60: ,p_honors IN per_all_people_f.honors%TYPE
61: ,p_internal_location IN per_all_people_f.internal_location%TYPE
62: ,p_known_as IN per_all_people_f.known_as%TYPE
63: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
64: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
57: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
58: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
59: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
60: ,p_honors IN per_all_people_f.honors%TYPE
61: ,p_internal_location IN per_all_people_f.internal_location%TYPE
62: ,p_known_as IN per_all_people_f.known_as%TYPE
63: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
64: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
65: ,p_mailstop IN per_all_people_f.mailstop%TYPE
58: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
59: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
60: ,p_honors IN per_all_people_f.honors%TYPE
61: ,p_internal_location IN per_all_people_f.internal_location%TYPE
62: ,p_known_as IN per_all_people_f.known_as%TYPE
63: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
64: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
65: ,p_mailstop IN per_all_people_f.mailstop%TYPE
66: ,p_marital_status IN per_all_people_f.marital_status%TYPE
59: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
60: ,p_honors IN per_all_people_f.honors%TYPE
61: ,p_internal_location IN per_all_people_f.internal_location%TYPE
62: ,p_known_as IN per_all_people_f.known_as%TYPE
63: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
64: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
65: ,p_mailstop IN per_all_people_f.mailstop%TYPE
66: ,p_marital_status IN per_all_people_f.marital_status%TYPE
67: ,p_middle_names IN per_all_people_f.middle_names%TYPE
60: ,p_honors IN per_all_people_f.honors%TYPE
61: ,p_internal_location IN per_all_people_f.internal_location%TYPE
62: ,p_known_as IN per_all_people_f.known_as%TYPE
63: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
64: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
65: ,p_mailstop IN per_all_people_f.mailstop%TYPE
66: ,p_marital_status IN per_all_people_f.marital_status%TYPE
67: ,p_middle_names IN per_all_people_f.middle_names%TYPE
68: ,p_nationality IN per_all_people_f.nationality%TYPE
61: ,p_internal_location IN per_all_people_f.internal_location%TYPE
62: ,p_known_as IN per_all_people_f.known_as%TYPE
63: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
64: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
65: ,p_mailstop IN per_all_people_f.mailstop%TYPE
66: ,p_marital_status IN per_all_people_f.marital_status%TYPE
67: ,p_middle_names IN per_all_people_f.middle_names%TYPE
68: ,p_nationality IN per_all_people_f.nationality%TYPE
69: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
62: ,p_known_as IN per_all_people_f.known_as%TYPE
63: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
64: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
65: ,p_mailstop IN per_all_people_f.mailstop%TYPE
66: ,p_marital_status IN per_all_people_f.marital_status%TYPE
67: ,p_middle_names IN per_all_people_f.middle_names%TYPE
68: ,p_nationality IN per_all_people_f.nationality%TYPE
69: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
70: ,p_office_number IN per_all_people_f.office_number%TYPE
63: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
64: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
65: ,p_mailstop IN per_all_people_f.mailstop%TYPE
66: ,p_marital_status IN per_all_people_f.marital_status%TYPE
67: ,p_middle_names IN per_all_people_f.middle_names%TYPE
68: ,p_nationality IN per_all_people_f.nationality%TYPE
69: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
70: ,p_office_number IN per_all_people_f.office_number%TYPE
71: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
64: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
65: ,p_mailstop IN per_all_people_f.mailstop%TYPE
66: ,p_marital_status IN per_all_people_f.marital_status%TYPE
67: ,p_middle_names IN per_all_people_f.middle_names%TYPE
68: ,p_nationality IN per_all_people_f.nationality%TYPE
69: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
70: ,p_office_number IN per_all_people_f.office_number%TYPE
71: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
72: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
65: ,p_mailstop IN per_all_people_f.mailstop%TYPE
66: ,p_marital_status IN per_all_people_f.marital_status%TYPE
67: ,p_middle_names IN per_all_people_f.middle_names%TYPE
68: ,p_nationality IN per_all_people_f.nationality%TYPE
69: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
70: ,p_office_number IN per_all_people_f.office_number%TYPE
71: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
72: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
73: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
66: ,p_marital_status IN per_all_people_f.marital_status%TYPE
67: ,p_middle_names IN per_all_people_f.middle_names%TYPE
68: ,p_nationality IN per_all_people_f.nationality%TYPE
69: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
70: ,p_office_number IN per_all_people_f.office_number%TYPE
71: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
72: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
73: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
74: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
67: ,p_middle_names IN per_all_people_f.middle_names%TYPE
68: ,p_nationality IN per_all_people_f.nationality%TYPE
69: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
70: ,p_office_number IN per_all_people_f.office_number%TYPE
71: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
72: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
73: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
74: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
75: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
68: ,p_nationality IN per_all_people_f.nationality%TYPE
69: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
70: ,p_office_number IN per_all_people_f.office_number%TYPE
71: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
72: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
73: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
74: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
75: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
76: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
69: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
70: ,p_office_number IN per_all_people_f.office_number%TYPE
71: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
72: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
73: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
74: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
75: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
76: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
77: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
70: ,p_office_number IN per_all_people_f.office_number%TYPE
71: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
72: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
73: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
74: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
75: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
76: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
77: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
78: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
71: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
72: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
73: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
74: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
75: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
76: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
77: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
78: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
79: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
72: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
73: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
74: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
75: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
76: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
77: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
78: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
79: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
80: ,p_sex IN per_all_people_f.sex%TYPE
73: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
74: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
75: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
76: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
77: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
78: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
79: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
80: ,p_sex IN per_all_people_f.sex%TYPE
81: ,p_student_status IN per_all_people_f.student_status%TYPE
74: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
75: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
76: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
77: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
78: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
79: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
80: ,p_sex IN per_all_people_f.sex%TYPE
81: ,p_student_status IN per_all_people_f.student_status%TYPE
82: ,p_suffix IN per_all_people_f.suffix%TYPE
75: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
76: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
77: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
78: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
79: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
80: ,p_sex IN per_all_people_f.sex%TYPE
81: ,p_student_status IN per_all_people_f.student_status%TYPE
82: ,p_suffix IN per_all_people_f.suffix%TYPE
83: ,p_title IN per_all_people_f.title%TYPE
76: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
77: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
78: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
79: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
80: ,p_sex IN per_all_people_f.sex%TYPE
81: ,p_student_status IN per_all_people_f.student_status%TYPE
82: ,p_suffix IN per_all_people_f.suffix%TYPE
83: ,p_title IN per_all_people_f.title%TYPE
84: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
77: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
78: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
79: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
80: ,p_sex IN per_all_people_f.sex%TYPE
81: ,p_student_status IN per_all_people_f.student_status%TYPE
82: ,p_suffix IN per_all_people_f.suffix%TYPE
83: ,p_title IN per_all_people_f.title%TYPE
84: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
85: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
78: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
79: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
80: ,p_sex IN per_all_people_f.sex%TYPE
81: ,p_student_status IN per_all_people_f.student_status%TYPE
82: ,p_suffix IN per_all_people_f.suffix%TYPE
83: ,p_title IN per_all_people_f.title%TYPE
84: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
85: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
86: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
79: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
80: ,p_sex IN per_all_people_f.sex%TYPE
81: ,p_student_status IN per_all_people_f.student_status%TYPE
82: ,p_suffix IN per_all_people_f.suffix%TYPE
83: ,p_title IN per_all_people_f.title%TYPE
84: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
85: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
86: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
87: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
80: ,p_sex IN per_all_people_f.sex%TYPE
81: ,p_student_status IN per_all_people_f.student_status%TYPE
82: ,p_suffix IN per_all_people_f.suffix%TYPE
83: ,p_title IN per_all_people_f.title%TYPE
84: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
85: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
86: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
87: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
88: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
81: ,p_student_status IN per_all_people_f.student_status%TYPE
82: ,p_suffix IN per_all_people_f.suffix%TYPE
83: ,p_title IN per_all_people_f.title%TYPE
84: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
85: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
86: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
87: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
88: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
89: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
82: ,p_suffix IN per_all_people_f.suffix%TYPE
83: ,p_title IN per_all_people_f.title%TYPE
84: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
85: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
86: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
87: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
88: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
89: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
90: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
83: ,p_title IN per_all_people_f.title%TYPE
84: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
85: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
86: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
87: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
88: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
89: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
90: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
91: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
84: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
85: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
86: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
87: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
88: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
89: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
90: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
91: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
92: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
85: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
86: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
87: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
88: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
89: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
90: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
91: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
92: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
93: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
86: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
87: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
88: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
89: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
90: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
91: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
92: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
93: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
94: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
87: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
88: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
89: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
90: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
91: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
92: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
93: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
94: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
95: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
88: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
89: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
90: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
91: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
92: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
93: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
94: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
95: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
96: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
89: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
90: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
91: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
92: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
93: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
94: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
95: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
96: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
97: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
90: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
91: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
92: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
93: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
94: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
95: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
96: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
97: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
98: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
91: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
92: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
93: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
94: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
95: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
96: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
97: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
98: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
99: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
92: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
93: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
94: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
95: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
96: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
97: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
98: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
99: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
100: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
93: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
94: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
95: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
96: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
97: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
98: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
99: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
100: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
101: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
94: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
95: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
96: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
97: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
98: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
99: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
100: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
101: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
102: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
95: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
96: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
97: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
98: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
99: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
100: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
101: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
102: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
103: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
96: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
97: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
98: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
99: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
100: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
101: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
102: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
103: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
104: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
97: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
98: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
99: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
100: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
101: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
102: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
103: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
104: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
105: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
98: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
99: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
100: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
101: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
102: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
103: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
104: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
105: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
106: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
99: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
100: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
101: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
102: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
103: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
104: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
105: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
106: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
107: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
100: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
101: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
102: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
103: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
104: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
105: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
106: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
107: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
108: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
101: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
102: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
103: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
104: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
105: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
106: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
107: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
108: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
109: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
102: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
103: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
104: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
105: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
106: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
107: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
108: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
109: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
110: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
103: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
104: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
105: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
106: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
107: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
108: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
109: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
110: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
111: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
104: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
105: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
106: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
107: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
108: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
109: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
110: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
111: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
112: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
105: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
106: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
107: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
108: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
109: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
110: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
111: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
112: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
113: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
106: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
107: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
108: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
109: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
110: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
111: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
112: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
113: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
114: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
107: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
108: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
109: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
110: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
111: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
112: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
113: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
114: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
115: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
108: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
109: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
110: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
111: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
112: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
113: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
114: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
115: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
116: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
109: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
110: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
111: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
112: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
113: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
114: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
115: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
116: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
117: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
110: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
111: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
112: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
113: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
114: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
115: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
116: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
117: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
118: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
111: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
112: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
113: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
114: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
115: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
116: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
117: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
118: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
119: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
112: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
113: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
114: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
115: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
116: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
117: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
118: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
119: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
120: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
113: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
114: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
115: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
116: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
117: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
118: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
119: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
120: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
121: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
114: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
115: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
116: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
117: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
118: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
119: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
120: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
121: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
122: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
115: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
116: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
117: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
118: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
119: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
120: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
121: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
122: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
123: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
116: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
117: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
118: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
119: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
120: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
121: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
122: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
123: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
124: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
117: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
118: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
119: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
120: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
121: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
122: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
123: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
124: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
125: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
118: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
119: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
120: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
121: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
122: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
123: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
124: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
125: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
126: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
119: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
120: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
121: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
122: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
123: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
124: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
125: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
126: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
127: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
120: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
121: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
122: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
123: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
124: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
125: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
126: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
127: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
128: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
121: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
122: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
123: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
124: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
125: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
126: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
127: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
128: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
129: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
122: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
123: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
124: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
125: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
126: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
127: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
128: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
129: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
130: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
123: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
124: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
125: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
126: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
127: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
128: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
129: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
130: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
131: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
124: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
125: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
126: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
127: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
128: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
129: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
130: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
131: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
132: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
125: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
126: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
127: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
128: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
129: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
130: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
131: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
132: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
133: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
126: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
127: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
128: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
129: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
130: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
131: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
132: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
133: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
134: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
127: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
128: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
129: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
130: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
131: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
132: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
133: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
134: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
135: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
128: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
129: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
130: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
131: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
132: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
133: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
134: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
135: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
136: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
129: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
130: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
131: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
132: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
133: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
134: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
135: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
136: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
137: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
130: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
131: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
132: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
133: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
134: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
135: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
136: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
137: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
138: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
131: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
132: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
133: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
134: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
135: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
136: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
137: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
138: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
139: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
132: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
133: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
134: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
135: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
136: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
137: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
138: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
139: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
140: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
133: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
134: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
135: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
136: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
137: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
138: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
139: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
140: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
141: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
134: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
135: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
136: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
137: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
138: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
139: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
140: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
141: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
142: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
135: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
136: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
137: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
138: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
139: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
140: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
141: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
142: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
143: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
136: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
137: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
138: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
139: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
140: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
141: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
142: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
143: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
144: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
137: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
138: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
139: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
140: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
141: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
142: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
143: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
144: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
145: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
138: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
139: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
140: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
141: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
142: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
143: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
144: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
145: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
146: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
139: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
140: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
141: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
142: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
143: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
144: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
145: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
146: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
147: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
140: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
141: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
142: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
143: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
144: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
145: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
146: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
147: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
148: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
141: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
142: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
143: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
144: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
145: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
146: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
147: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
148: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
149: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
142: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
143: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
144: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
145: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
146: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
147: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
148: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
149: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
150: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
143: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
144: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
145: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
146: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
147: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
148: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
149: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
150: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
151: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
144: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
145: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
146: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
147: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
148: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
149: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
150: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
151: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
152: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
145: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
146: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
147: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
148: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
149: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
150: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
151: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
152: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
153: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
146: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
147: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
148: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
149: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
150: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
151: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
152: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
153: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
154: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
147: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
148: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
149: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
150: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
151: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
152: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
153: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
154: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
155: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
148: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
149: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
150: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
151: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
152: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
153: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
154: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
155: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
156: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
149: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
150: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
151: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
152: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
153: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
154: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
155: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
156: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
157: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
150: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
151: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
152: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
153: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
154: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
155: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
156: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
157: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
158: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
151: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
152: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
153: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
154: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
155: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
156: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
157: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
158: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
159: ,p_party_id IN per_all_people_f.party_id%TYPE DEFAULT NULL
152: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
153: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
154: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
155: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
156: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
157: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
158: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
159: ,p_party_id IN per_all_people_f.party_id%TYPE DEFAULT NULL
160: ,p_fast_path_employee IN per_all_people_f.fast_path_employee%TYPE default null
153: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
154: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
155: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
156: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
157: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
158: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
159: ,p_party_id IN per_all_people_f.party_id%TYPE DEFAULT NULL
160: ,p_fast_path_employee IN per_all_people_f.fast_path_employee%TYPE default null
161: ,p_rehire_authorizor IN per_all_people_f.rehire_authorizor%TYPE default null
154: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
155: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
156: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
157: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
158: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
159: ,p_party_id IN per_all_people_f.party_id%TYPE DEFAULT NULL
160: ,p_fast_path_employee IN per_all_people_f.fast_path_employee%TYPE default null
161: ,p_rehire_authorizor IN per_all_people_f.rehire_authorizor%TYPE default null
162: ,p_per_object_version_number OUT NOCOPY per_all_people_f.object_version_number%TYPE
155: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
156: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
157: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
158: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
159: ,p_party_id IN per_all_people_f.party_id%TYPE DEFAULT NULL
160: ,p_fast_path_employee IN per_all_people_f.fast_path_employee%TYPE default null
161: ,p_rehire_authorizor IN per_all_people_f.rehire_authorizor%TYPE default null
162: ,p_per_object_version_number OUT NOCOPY per_all_people_f.object_version_number%TYPE
163: ,p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
156: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
157: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
158: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
159: ,p_party_id IN per_all_people_f.party_id%TYPE DEFAULT NULL
160: ,p_fast_path_employee IN per_all_people_f.fast_path_employee%TYPE default null
161: ,p_rehire_authorizor IN per_all_people_f.rehire_authorizor%TYPE default null
162: ,p_per_object_version_number OUT NOCOPY per_all_people_f.object_version_number%TYPE
163: ,p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
164: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
157: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
158: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
159: ,p_party_id IN per_all_people_f.party_id%TYPE DEFAULT NULL
160: ,p_fast_path_employee IN per_all_people_f.fast_path_employee%TYPE default null
161: ,p_rehire_authorizor IN per_all_people_f.rehire_authorizor%TYPE default null
162: ,p_per_object_version_number OUT NOCOPY per_all_people_f.object_version_number%TYPE
163: ,p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
164: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
165: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
158: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
159: ,p_party_id IN per_all_people_f.party_id%TYPE DEFAULT NULL
160: ,p_fast_path_employee IN per_all_people_f.fast_path_employee%TYPE default null
161: ,p_rehire_authorizor IN per_all_people_f.rehire_authorizor%TYPE default null
162: ,p_per_object_version_number OUT NOCOPY per_all_people_f.object_version_number%TYPE
163: ,p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
164: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
165: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
166: ,p_asg_validation_start_date OUT NOCOPY DATE
726: ,p_gsp_post_process_warning OUT NOCOPY VARCHAR2
727: ) IS
728: --
729: l_person_id NUMBER;
730: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
731: l_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE;
732: l_employee_number per_all_people_f.employee_number%TYPE;
733: l_applicant_number per_all_people_f.applicant_number%TYPE;
734: l_npw_number per_all_people_f.npw_number%TYPE;
728: --
729: l_person_id NUMBER;
730: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
731: l_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE;
732: l_employee_number per_all_people_f.employee_number%TYPE;
733: l_applicant_number per_all_people_f.applicant_number%TYPE;
734: l_npw_number per_all_people_f.npw_number%TYPE;
735: l_per_effective_start_date DATE;
736: l_per_effective_end_date DATE;
729: l_person_id NUMBER;
730: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
731: l_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE;
732: l_employee_number per_all_people_f.employee_number%TYPE;
733: l_applicant_number per_all_people_f.applicant_number%TYPE;
734: l_npw_number per_all_people_f.npw_number%TYPE;
735: l_per_effective_start_date DATE;
736: l_per_effective_end_date DATE;
737: l_per_validation_start_date DATE;
730: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
731: l_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE;
732: l_employee_number per_all_people_f.employee_number%TYPE;
733: l_applicant_number per_all_people_f.applicant_number%TYPE;
734: l_npw_number per_all_people_f.npw_number%TYPE;
735: l_per_effective_start_date DATE;
736: l_per_effective_end_date DATE;
737: l_per_validation_start_date DATE;
738: l_per_validation_end_date DATE;
735: l_per_effective_start_date DATE;
736: l_per_effective_end_date DATE;
737: l_per_validation_start_date DATE;
738: l_per_validation_end_date DATE;
739: l_full_name per_all_people_f.full_name%TYPE;
740: l_comment_id NUMBER;
741: l_name_combination_warning BOOLEAN;
742: l_assign_payroll_warning BOOLEAN;
743: l_orig_hire_warning BOOLEAN;
2023: hr_phone_api.create_or_update_phone
2024: (p_effective_date => l_creation_date --p_effective_date
2025: ,p_parent_id => p_person_id
2026: ,p_update_mode => l_datetrack_update_mode
2027: ,p_parent_table => 'PER_ALL_PEOPLE_F'
2028: ,p_phone_type => 'H1'
2029: ,p_phone_number => p_phn_h_phone_number
2030: ,p_date_from => p_phn_h_date_from
2031: ,p_date_to => p_phn_h_date_to
2045: hr_phone_api.create_or_update_phone
2046: (p_effective_date => l_creation_date --p_effective_date
2047: ,p_parent_id => p_person_id
2048: ,p_update_mode => l_datetrack_update_mode
2049: ,p_parent_table => 'PER_ALL_PEOPLE_F'
2050: ,p_phone_type => 'W1'
2051: ,p_phone_number => p_phn_w_phone_number
2052: ,p_date_from => p_phn_w_date_from
2053: ,p_date_to => p_phn_w_date_to
2067: hr_phone_api.create_or_update_phone
2068: (p_effective_date => l_creation_date --p_effective_date
2069: ,p_parent_id => p_person_id
2070: ,p_update_mode => l_datetrack_update_mode
2071: ,p_parent_table => 'PER_ALL_PEOPLE_F'
2072: ,p_phone_type => 'M'
2073: ,p_phone_number => p_phn_m_phone_number
2074: ,p_date_from => p_phn_m_date_from
2075: ,p_date_to => p_phn_m_date_to
2089: hr_phone_api.create_or_update_phone
2090: (p_effective_date => l_creation_date --p_effective_date
2091: ,p_parent_id => p_person_id
2092: ,p_update_mode => l_datetrack_update_mode
2093: ,p_parent_table => 'PER_ALL_PEOPLE_F'
2094: ,p_phone_type => 'HF'
2095: ,p_phone_number => p_phn_hf_phone_number
2096: ,p_date_from => p_phn_hf_date_from
2097: ,p_date_to => p_phn_hf_date_to
2111: hr_phone_api.create_or_update_phone
2112: (p_effective_date => l_creation_date --p_effective_date
2113: ,p_parent_id => p_person_id
2114: ,p_update_mode => l_datetrack_update_mode
2115: ,p_parent_table => 'PER_ALL_PEOPLE_F'
2116: ,p_phone_type => 'WF'
2117: ,p_phone_number => p_phn_wf_phone_number
2118: ,p_date_from => p_phn_wf_date_from
2119: ,p_date_to => p_phn_wf_date_to
2678: --We need to provide code here to pass back the correct OVNs to the form
2679: --
2680: if p_person_id is not null then
2681: select per.object_version_number into l_per_object_version_number
2682: from per_all_people_f per
2683: where per.person_id=p_person_id
2684: -- and p_effective_date between per.effective_start_date and per.effective_end_date;
2685: and l_creation_date between per.effective_start_date and per.effective_end_date;
2686: --
2708: PROCEDURE update_maintain_data
2709: (p_effective_date IN DATE
2710: ,p_datetrack_update_mode IN VARCHAR2
2711: ,p_person_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
2712: ,p_person_id IN per_all_people_f.person_id%TYPE
2713: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
2714: ,p_legislation_code IN VARCHAR2
2715: ,p_per_effective_start_date IN OUT NOCOPY per_all_people_f.effective_start_date%TYPE
2716: ,p_per_effective_end_date IN OUT NOCOPY per_all_people_f.effective_end_date%TYPE
2709: (p_effective_date IN DATE
2710: ,p_datetrack_update_mode IN VARCHAR2
2711: ,p_person_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
2712: ,p_person_id IN per_all_people_f.person_id%TYPE
2713: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
2714: ,p_legislation_code IN VARCHAR2
2715: ,p_per_effective_start_date IN OUT NOCOPY per_all_people_f.effective_start_date%TYPE
2716: ,p_per_effective_end_date IN OUT NOCOPY per_all_people_f.effective_end_date%TYPE
2717: ,p_per_validation_start_date OUT NOCOPY DATE
2711: ,p_person_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
2712: ,p_person_id IN per_all_people_f.person_id%TYPE
2713: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
2714: ,p_legislation_code IN VARCHAR2
2715: ,p_per_effective_start_date IN OUT NOCOPY per_all_people_f.effective_start_date%TYPE
2716: ,p_per_effective_end_date IN OUT NOCOPY per_all_people_f.effective_end_date%TYPE
2717: ,p_per_validation_start_date OUT NOCOPY DATE
2718: ,p_per_validation_end_date OUT NOCOPY DATE
2719: ,p_person_type IN per_person_types.user_person_type%TYPE
2712: ,p_person_id IN per_all_people_f.person_id%TYPE
2713: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
2714: ,p_legislation_code IN VARCHAR2
2715: ,p_per_effective_start_date IN OUT NOCOPY per_all_people_f.effective_start_date%TYPE
2716: ,p_per_effective_end_date IN OUT NOCOPY per_all_people_f.effective_end_date%TYPE
2717: ,p_per_validation_start_date OUT NOCOPY DATE
2718: ,p_per_validation_end_date OUT NOCOPY DATE
2719: ,p_person_type IN per_person_types.user_person_type%TYPE
2720: ,p_system_person_type IN per_person_types.system_person_type%TYPE
2717: ,p_per_validation_start_date OUT NOCOPY DATE
2718: ,p_per_validation_end_date OUT NOCOPY DATE
2719: ,p_person_type IN per_person_types.user_person_type%TYPE
2720: ,p_system_person_type IN per_person_types.system_person_type%TYPE
2721: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
2722: ,p_last_name IN per_all_people_f.last_name%TYPE
2723: ,p_start_date IN per_all_people_f.start_date%TYPE
2724: ,p_applicant_number IN per_all_people_f.applicant_number%TYPE
2725: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
2718: ,p_per_validation_end_date OUT NOCOPY DATE
2719: ,p_person_type IN per_person_types.user_person_type%TYPE
2720: ,p_system_person_type IN per_person_types.system_person_type%TYPE
2721: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
2722: ,p_last_name IN per_all_people_f.last_name%TYPE
2723: ,p_start_date IN per_all_people_f.start_date%TYPE
2724: ,p_applicant_number IN per_all_people_f.applicant_number%TYPE
2725: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
2726: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
2719: ,p_person_type IN per_person_types.user_person_type%TYPE
2720: ,p_system_person_type IN per_person_types.system_person_type%TYPE
2721: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
2722: ,p_last_name IN per_all_people_f.last_name%TYPE
2723: ,p_start_date IN per_all_people_f.start_date%TYPE
2724: ,p_applicant_number IN per_all_people_f.applicant_number%TYPE
2725: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
2726: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
2727: ,p_blood_type IN per_all_people_f.blood_type%TYPE
2720: ,p_system_person_type IN per_person_types.system_person_type%TYPE
2721: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
2722: ,p_last_name IN per_all_people_f.last_name%TYPE
2723: ,p_start_date IN per_all_people_f.start_date%TYPE
2724: ,p_applicant_number IN per_all_people_f.applicant_number%TYPE
2725: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
2726: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
2727: ,p_blood_type IN per_all_people_f.blood_type%TYPE
2728: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
2721: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
2722: ,p_last_name IN per_all_people_f.last_name%TYPE
2723: ,p_start_date IN per_all_people_f.start_date%TYPE
2724: ,p_applicant_number IN per_all_people_f.applicant_number%TYPE
2725: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
2726: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
2727: ,p_blood_type IN per_all_people_f.blood_type%TYPE
2728: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
2729: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
2722: ,p_last_name IN per_all_people_f.last_name%TYPE
2723: ,p_start_date IN per_all_people_f.start_date%TYPE
2724: ,p_applicant_number IN per_all_people_f.applicant_number%TYPE
2725: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
2726: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
2727: ,p_blood_type IN per_all_people_f.blood_type%TYPE
2728: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
2729: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
2730: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
2723: ,p_start_date IN per_all_people_f.start_date%TYPE
2724: ,p_applicant_number IN per_all_people_f.applicant_number%TYPE
2725: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
2726: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
2727: ,p_blood_type IN per_all_people_f.blood_type%TYPE
2728: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
2729: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
2730: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
2731: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
2724: ,p_applicant_number IN per_all_people_f.applicant_number%TYPE
2725: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
2726: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
2727: ,p_blood_type IN per_all_people_f.blood_type%TYPE
2728: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
2729: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
2730: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
2731: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
2732: --CWK
2725: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
2726: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
2727: ,p_blood_type IN per_all_people_f.blood_type%TYPE
2728: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
2729: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
2730: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
2731: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
2732: --CWK
2733: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
2726: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
2727: ,p_blood_type IN per_all_people_f.blood_type%TYPE
2728: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
2729: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
2730: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
2731: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
2732: --CWK
2733: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
2734: ,p_npw_number IN per_all_people_f.npw_number%TYPE
2727: ,p_blood_type IN per_all_people_f.blood_type%TYPE
2728: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
2729: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
2730: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
2731: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
2732: --CWK
2733: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
2734: ,p_npw_number IN per_all_people_f.npw_number%TYPE
2735: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE
2729: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
2730: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
2731: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
2732: --CWK
2733: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
2734: ,p_npw_number IN per_all_people_f.npw_number%TYPE
2735: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE
2736: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
2737: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
2730: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
2731: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
2732: --CWK
2733: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
2734: ,p_npw_number IN per_all_people_f.npw_number%TYPE
2735: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE
2736: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
2737: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
2738: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
2749: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
2750: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
2751: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
2752: --
2753: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
2754: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
2755: ,p_email_address IN per_all_people_f.email_address%TYPE
2756: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
2757: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
2750: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
2751: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
2752: --
2753: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
2754: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
2755: ,p_email_address IN per_all_people_f.email_address%TYPE
2756: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
2757: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
2758: ,p_first_name IN per_all_people_f.first_name%TYPE
2751: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
2752: --
2753: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
2754: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
2755: ,p_email_address IN per_all_people_f.email_address%TYPE
2756: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
2757: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
2758: ,p_first_name IN per_all_people_f.first_name%TYPE
2759: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
2752: --
2753: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
2754: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
2755: ,p_email_address IN per_all_people_f.email_address%TYPE
2756: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
2757: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
2758: ,p_first_name IN per_all_people_f.first_name%TYPE
2759: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
2760: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
2753: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
2754: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
2755: ,p_email_address IN per_all_people_f.email_address%TYPE
2756: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
2757: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
2758: ,p_first_name IN per_all_people_f.first_name%TYPE
2759: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
2760: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
2761: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
2754: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
2755: ,p_email_address IN per_all_people_f.email_address%TYPE
2756: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
2757: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
2758: ,p_first_name IN per_all_people_f.first_name%TYPE
2759: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
2760: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
2761: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
2762: ,p_honors IN per_all_people_f.honors%TYPE
2755: ,p_email_address IN per_all_people_f.email_address%TYPE
2756: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
2757: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
2758: ,p_first_name IN per_all_people_f.first_name%TYPE
2759: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
2760: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
2761: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
2762: ,p_honors IN per_all_people_f.honors%TYPE
2763: ,p_internal_location IN per_all_people_f.internal_location%TYPE
2756: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
2757: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
2758: ,p_first_name IN per_all_people_f.first_name%TYPE
2759: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
2760: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
2761: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
2762: ,p_honors IN per_all_people_f.honors%TYPE
2763: ,p_internal_location IN per_all_people_f.internal_location%TYPE
2764: ,p_known_as IN per_all_people_f.known_as%TYPE
2757: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
2758: ,p_first_name IN per_all_people_f.first_name%TYPE
2759: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
2760: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
2761: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
2762: ,p_honors IN per_all_people_f.honors%TYPE
2763: ,p_internal_location IN per_all_people_f.internal_location%TYPE
2764: ,p_known_as IN per_all_people_f.known_as%TYPE
2765: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
2758: ,p_first_name IN per_all_people_f.first_name%TYPE
2759: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
2760: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
2761: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
2762: ,p_honors IN per_all_people_f.honors%TYPE
2763: ,p_internal_location IN per_all_people_f.internal_location%TYPE
2764: ,p_known_as IN per_all_people_f.known_as%TYPE
2765: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
2766: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
2759: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
2760: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
2761: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
2762: ,p_honors IN per_all_people_f.honors%TYPE
2763: ,p_internal_location IN per_all_people_f.internal_location%TYPE
2764: ,p_known_as IN per_all_people_f.known_as%TYPE
2765: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
2766: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
2767: ,p_mailstop IN per_all_people_f.mailstop%TYPE
2760: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
2761: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
2762: ,p_honors IN per_all_people_f.honors%TYPE
2763: ,p_internal_location IN per_all_people_f.internal_location%TYPE
2764: ,p_known_as IN per_all_people_f.known_as%TYPE
2765: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
2766: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
2767: ,p_mailstop IN per_all_people_f.mailstop%TYPE
2768: ,p_marital_status IN per_all_people_f.marital_status%TYPE
2761: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
2762: ,p_honors IN per_all_people_f.honors%TYPE
2763: ,p_internal_location IN per_all_people_f.internal_location%TYPE
2764: ,p_known_as IN per_all_people_f.known_as%TYPE
2765: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
2766: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
2767: ,p_mailstop IN per_all_people_f.mailstop%TYPE
2768: ,p_marital_status IN per_all_people_f.marital_status%TYPE
2769: ,p_middle_names IN per_all_people_f.middle_names%TYPE
2762: ,p_honors IN per_all_people_f.honors%TYPE
2763: ,p_internal_location IN per_all_people_f.internal_location%TYPE
2764: ,p_known_as IN per_all_people_f.known_as%TYPE
2765: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
2766: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
2767: ,p_mailstop IN per_all_people_f.mailstop%TYPE
2768: ,p_marital_status IN per_all_people_f.marital_status%TYPE
2769: ,p_middle_names IN per_all_people_f.middle_names%TYPE
2770: ,p_nationality IN per_all_people_f.nationality%TYPE
2763: ,p_internal_location IN per_all_people_f.internal_location%TYPE
2764: ,p_known_as IN per_all_people_f.known_as%TYPE
2765: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
2766: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
2767: ,p_mailstop IN per_all_people_f.mailstop%TYPE
2768: ,p_marital_status IN per_all_people_f.marital_status%TYPE
2769: ,p_middle_names IN per_all_people_f.middle_names%TYPE
2770: ,p_nationality IN per_all_people_f.nationality%TYPE
2771: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
2764: ,p_known_as IN per_all_people_f.known_as%TYPE
2765: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
2766: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
2767: ,p_mailstop IN per_all_people_f.mailstop%TYPE
2768: ,p_marital_status IN per_all_people_f.marital_status%TYPE
2769: ,p_middle_names IN per_all_people_f.middle_names%TYPE
2770: ,p_nationality IN per_all_people_f.nationality%TYPE
2771: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
2772: ,p_office_number IN per_all_people_f.office_number%TYPE
2765: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
2766: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
2767: ,p_mailstop IN per_all_people_f.mailstop%TYPE
2768: ,p_marital_status IN per_all_people_f.marital_status%TYPE
2769: ,p_middle_names IN per_all_people_f.middle_names%TYPE
2770: ,p_nationality IN per_all_people_f.nationality%TYPE
2771: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
2772: ,p_office_number IN per_all_people_f.office_number%TYPE
2773: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
2766: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
2767: ,p_mailstop IN per_all_people_f.mailstop%TYPE
2768: ,p_marital_status IN per_all_people_f.marital_status%TYPE
2769: ,p_middle_names IN per_all_people_f.middle_names%TYPE
2770: ,p_nationality IN per_all_people_f.nationality%TYPE
2771: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
2772: ,p_office_number IN per_all_people_f.office_number%TYPE
2773: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
2774: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
2767: ,p_mailstop IN per_all_people_f.mailstop%TYPE
2768: ,p_marital_status IN per_all_people_f.marital_status%TYPE
2769: ,p_middle_names IN per_all_people_f.middle_names%TYPE
2770: ,p_nationality IN per_all_people_f.nationality%TYPE
2771: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
2772: ,p_office_number IN per_all_people_f.office_number%TYPE
2773: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
2774: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
2775: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
2768: ,p_marital_status IN per_all_people_f.marital_status%TYPE
2769: ,p_middle_names IN per_all_people_f.middle_names%TYPE
2770: ,p_nationality IN per_all_people_f.nationality%TYPE
2771: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
2772: ,p_office_number IN per_all_people_f.office_number%TYPE
2773: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
2774: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
2775: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
2776: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
2769: ,p_middle_names IN per_all_people_f.middle_names%TYPE
2770: ,p_nationality IN per_all_people_f.nationality%TYPE
2771: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
2772: ,p_office_number IN per_all_people_f.office_number%TYPE
2773: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
2774: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
2775: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
2776: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
2777: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
2770: ,p_nationality IN per_all_people_f.nationality%TYPE
2771: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
2772: ,p_office_number IN per_all_people_f.office_number%TYPE
2773: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
2774: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
2775: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
2776: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
2777: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
2778: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
2771: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
2772: ,p_office_number IN per_all_people_f.office_number%TYPE
2773: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
2774: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
2775: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
2776: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
2777: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
2778: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
2779: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
2772: ,p_office_number IN per_all_people_f.office_number%TYPE
2773: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
2774: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
2775: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
2776: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
2777: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
2778: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
2779: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
2780: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
2773: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
2774: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
2775: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
2776: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
2777: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
2778: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
2779: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
2780: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
2781: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
2774: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
2775: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
2776: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
2777: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
2778: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
2779: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
2780: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
2781: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
2782: ,p_sex IN per_all_people_f.sex%TYPE
2775: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
2776: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
2777: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
2778: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
2779: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
2780: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
2781: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
2782: ,p_sex IN per_all_people_f.sex%TYPE
2783: ,p_student_status IN per_all_people_f.student_status%TYPE
2776: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
2777: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
2778: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
2779: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
2780: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
2781: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
2782: ,p_sex IN per_all_people_f.sex%TYPE
2783: ,p_student_status IN per_all_people_f.student_status%TYPE
2784: ,p_suffix IN per_all_people_f.suffix%TYPE
2777: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
2778: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
2779: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
2780: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
2781: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
2782: ,p_sex IN per_all_people_f.sex%TYPE
2783: ,p_student_status IN per_all_people_f.student_status%TYPE
2784: ,p_suffix IN per_all_people_f.suffix%TYPE
2785: ,p_title IN per_all_people_f.title%TYPE
2778: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
2779: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
2780: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
2781: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
2782: ,p_sex IN per_all_people_f.sex%TYPE
2783: ,p_student_status IN per_all_people_f.student_status%TYPE
2784: ,p_suffix IN per_all_people_f.suffix%TYPE
2785: ,p_title IN per_all_people_f.title%TYPE
2786: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
2779: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
2780: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
2781: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
2782: ,p_sex IN per_all_people_f.sex%TYPE
2783: ,p_student_status IN per_all_people_f.student_status%TYPE
2784: ,p_suffix IN per_all_people_f.suffix%TYPE
2785: ,p_title IN per_all_people_f.title%TYPE
2786: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
2787: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
2780: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
2781: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
2782: ,p_sex IN per_all_people_f.sex%TYPE
2783: ,p_student_status IN per_all_people_f.student_status%TYPE
2784: ,p_suffix IN per_all_people_f.suffix%TYPE
2785: ,p_title IN per_all_people_f.title%TYPE
2786: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
2787: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
2788: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
2781: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
2782: ,p_sex IN per_all_people_f.sex%TYPE
2783: ,p_student_status IN per_all_people_f.student_status%TYPE
2784: ,p_suffix IN per_all_people_f.suffix%TYPE
2785: ,p_title IN per_all_people_f.title%TYPE
2786: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
2787: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
2788: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
2789: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
2782: ,p_sex IN per_all_people_f.sex%TYPE
2783: ,p_student_status IN per_all_people_f.student_status%TYPE
2784: ,p_suffix IN per_all_people_f.suffix%TYPE
2785: ,p_title IN per_all_people_f.title%TYPE
2786: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
2787: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
2788: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
2789: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
2790: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
2783: ,p_student_status IN per_all_people_f.student_status%TYPE
2784: ,p_suffix IN per_all_people_f.suffix%TYPE
2785: ,p_title IN per_all_people_f.title%TYPE
2786: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
2787: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
2788: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
2789: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
2790: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
2791: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
2784: ,p_suffix IN per_all_people_f.suffix%TYPE
2785: ,p_title IN per_all_people_f.title%TYPE
2786: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
2787: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
2788: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
2789: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
2790: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
2791: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
2792: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
2785: ,p_title IN per_all_people_f.title%TYPE
2786: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
2787: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
2788: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
2789: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
2790: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
2791: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
2792: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
2793: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
2786: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
2787: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
2788: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
2789: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
2790: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
2791: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
2792: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
2793: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
2794: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
2787: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
2788: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
2789: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
2790: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
2791: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
2792: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
2793: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
2794: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
2795: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
2788: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
2789: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
2790: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
2791: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
2792: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
2793: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
2794: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
2795: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
2796: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
2789: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
2790: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
2791: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
2792: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
2793: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
2794: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
2795: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
2796: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
2797: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
2790: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
2791: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
2792: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
2793: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
2794: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
2795: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
2796: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
2797: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
2798: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
2791: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
2792: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
2793: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
2794: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
2795: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
2796: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
2797: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
2798: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
2799: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
2792: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
2793: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
2794: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
2795: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
2796: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
2797: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
2798: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
2799: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
2800: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
2793: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
2794: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
2795: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
2796: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
2797: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
2798: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
2799: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
2800: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
2801: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
2794: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
2795: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
2796: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
2797: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
2798: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
2799: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
2800: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
2801: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
2802: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
2795: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
2796: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
2797: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
2798: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
2799: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
2800: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
2801: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
2802: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
2803: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
2796: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
2797: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
2798: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
2799: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
2800: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
2801: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
2802: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
2803: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
2804: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
2797: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
2798: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
2799: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
2800: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
2801: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
2802: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
2803: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
2804: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
2805: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
2798: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
2799: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
2800: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
2801: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
2802: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
2803: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
2804: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
2805: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
2806: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
2799: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
2800: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
2801: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
2802: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
2803: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
2804: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
2805: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
2806: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
2807: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
2800: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
2801: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
2802: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
2803: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
2804: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
2805: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
2806: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
2807: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
2808: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
2801: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
2802: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
2803: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
2804: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
2805: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
2806: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
2807: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
2808: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
2809: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
2802: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
2803: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
2804: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
2805: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
2806: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
2807: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
2808: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
2809: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
2810: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
2803: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
2804: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
2805: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
2806: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
2807: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
2808: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
2809: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
2810: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
2811: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
2804: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
2805: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
2806: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
2807: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
2808: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
2809: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
2810: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
2811: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
2812: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
2805: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
2806: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
2807: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
2808: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
2809: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
2810: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
2811: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
2812: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
2813: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
2806: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
2807: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
2808: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
2809: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
2810: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
2811: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
2812: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
2813: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
2814: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
2807: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
2808: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
2809: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
2810: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
2811: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
2812: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
2813: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
2814: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
2815: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
2808: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
2809: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
2810: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
2811: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
2812: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
2813: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
2814: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
2815: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
2816: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
2809: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
2810: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
2811: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
2812: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
2813: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
2814: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
2815: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
2816: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
2817: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
2810: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
2811: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
2812: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
2813: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
2814: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
2815: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
2816: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
2817: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
2818: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
2811: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
2812: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
2813: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
2814: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
2815: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
2816: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
2817: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
2818: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
2819: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
2812: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
2813: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
2814: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
2815: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
2816: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
2817: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
2818: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
2819: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
2820: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
2813: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
2814: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
2815: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
2816: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
2817: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
2818: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
2819: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
2820: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
2821: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
2814: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
2815: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
2816: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
2817: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
2818: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
2819: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
2820: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
2821: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
2822: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
2815: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
2816: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
2817: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
2818: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
2819: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
2820: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
2821: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
2822: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
2823: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
2816: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
2817: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
2818: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
2819: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
2820: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
2821: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
2822: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
2823: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
2824: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
2817: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
2818: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
2819: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
2820: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
2821: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
2822: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
2823: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
2824: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
2825: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
2818: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
2819: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
2820: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
2821: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
2822: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
2823: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
2824: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
2825: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
2826: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
2819: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
2820: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
2821: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
2822: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
2823: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
2824: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
2825: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
2826: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
2827: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
2820: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
2821: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
2822: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
2823: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
2824: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
2825: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
2826: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
2827: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
2828: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
2821: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
2822: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
2823: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
2824: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
2825: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
2826: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
2827: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
2828: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
2829: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
2822: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
2823: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
2824: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
2825: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
2826: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
2827: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
2828: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
2829: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
2830: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
2823: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
2824: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
2825: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
2826: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
2827: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
2828: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
2829: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
2830: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
2831: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
2824: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
2825: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
2826: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
2827: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
2828: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
2829: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
2830: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
2831: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
2832: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
2825: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
2826: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
2827: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
2828: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
2829: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
2830: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
2831: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
2832: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
2833: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
2826: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
2827: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
2828: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
2829: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
2830: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
2831: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
2832: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
2833: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
2834: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
2827: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
2828: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
2829: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
2830: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
2831: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
2832: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
2833: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
2834: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
2835: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
2828: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
2829: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
2830: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
2831: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
2832: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
2833: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
2834: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
2835: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
2836: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
2829: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
2830: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
2831: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
2832: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
2833: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
2834: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
2835: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
2836: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
2837: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
2830: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
2831: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
2832: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
2833: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
2834: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
2835: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
2836: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
2837: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
2838: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
2831: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
2832: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
2833: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
2834: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
2835: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
2836: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
2837: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
2838: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
2839: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
2832: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
2833: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
2834: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
2835: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
2836: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
2837: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
2838: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
2839: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
2840: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
2833: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
2834: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
2835: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
2836: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
2837: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
2838: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
2839: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
2840: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
2841: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
2834: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
2835: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
2836: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
2837: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
2838: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
2839: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
2840: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
2841: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
2842: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
2835: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
2836: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
2837: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
2838: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
2839: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
2840: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
2841: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
2842: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
2843: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
2836: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
2837: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
2838: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
2839: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
2840: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
2841: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
2842: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
2843: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
2844: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
2837: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
2838: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
2839: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
2840: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
2841: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
2842: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
2843: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
2844: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
2845: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
2838: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
2839: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
2840: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
2841: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
2842: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
2843: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
2844: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
2845: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
2846: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
2839: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
2840: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
2841: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
2842: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
2843: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
2844: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
2845: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
2846: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
2847: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
2840: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
2841: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
2842: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
2843: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
2844: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
2845: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
2846: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
2847: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
2848: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
2841: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
2842: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
2843: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
2844: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
2845: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
2846: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
2847: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
2848: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
2849: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
2842: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
2843: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
2844: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
2845: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
2846: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
2847: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
2848: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
2849: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
2850: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
2843: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
2844: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
2845: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
2846: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
2847: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
2848: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
2849: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
2850: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
2851: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
2844: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
2845: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
2846: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
2847: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
2848: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
2849: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
2850: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
2851: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
2852: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
2845: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
2846: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
2847: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
2848: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
2849: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
2850: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
2851: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
2852: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
2853: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
2846: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
2847: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
2848: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
2849: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
2850: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
2851: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
2852: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
2853: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
2854: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
2847: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
2848: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
2849: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
2850: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
2851: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
2852: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
2853: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
2854: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
2855: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
2848: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
2849: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
2850: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
2851: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
2852: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
2853: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
2854: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
2855: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
2856: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
2849: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
2850: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
2851: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
2852: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
2853: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
2854: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
2855: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
2856: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
2857: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
2850: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
2851: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
2852: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
2853: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
2854: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
2855: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
2856: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
2857: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
2858: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
2851: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
2852: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
2853: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
2854: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
2855: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
2856: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
2857: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
2858: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
2859: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
2852: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
2853: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
2854: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
2855: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
2856: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
2857: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
2858: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
2859: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
2860: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
2853: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
2854: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
2855: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
2856: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
2857: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
2858: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
2859: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
2860: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
2861: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
2854: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
2855: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
2856: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
2857: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
2858: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
2859: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
2860: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
2861: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
2862: ,p_assignment_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
2855: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
2856: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
2857: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
2858: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
2859: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
2860: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
2861: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
2862: ,p_assignment_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
2863: ,p_assignment_id IN OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
2856: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
2857: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
2858: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
2859: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
2860: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
2861: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
2862: ,p_assignment_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
2863: ,p_assignment_id IN OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
2864: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
2857: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
2858: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
2859: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
2860: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
2861: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
2862: ,p_assignment_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
2863: ,p_assignment_id IN OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
2864: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
2865: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
3425: ,p_payroll_warning OUT NOCOPY BOOLEAN
3426: ,p_gsp_post_process_warning OUT NOCOPY VARCHAR2
3427: ) IS
3428: --
3429: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
3430: l_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE;
3431: l_employee_number per_all_people_f.employee_number%TYPE;
3432: l_npw_number per_all_people_f.npw_number%TYPE := p_npw_number;
3433: l_per_effective_start_date DATE;
3427: ) IS
3428: --
3429: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
3430: l_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE;
3431: l_employee_number per_all_people_f.employee_number%TYPE;
3432: l_npw_number per_all_people_f.npw_number%TYPE := p_npw_number;
3433: l_per_effective_start_date DATE;
3434: l_per_effective_end_date DATE;
3435: l_per_validation_start_date DATE;
3428: --
3429: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
3430: l_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE;
3431: l_employee_number per_all_people_f.employee_number%TYPE;
3432: l_npw_number per_all_people_f.npw_number%TYPE := p_npw_number;
3433: l_per_effective_start_date DATE;
3434: l_per_effective_end_date DATE;
3435: l_per_validation_start_date DATE;
3436: l_per_validation_end_date DATE;
3434: l_per_effective_end_date DATE;
3435: l_per_validation_start_date DATE;
3436: l_per_validation_end_date DATE;
3437: l_per_datetrack_update_mode VARCHAR2(30);
3438: l_full_name per_all_people_f.full_name%TYPE;
3439: l_duplicate_flag VARCHAR2(1);
3440: l_comment_id NUMBER;
3441: l_name_combination_warning BOOLEAN;
3442: l_assign_payroll_warning BOOLEAN;
3498: l_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
3499: l_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
3500: l_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE;
3501: --
3502: l_party_id per_all_people_f.party_id%TYPE;
3503: --
3504: l_gsp_post_process_warning varchar2(30); -- bug2999562
3505: l_gsp_post_process_warning2 varchar2(30);
3506: l_gsp_post_process_warning3 varchar2(30);
3940: hr_utility.set_location(l_proc, 40);
3941: --
3942: select party_id
3943: into l_party_id
3944: from per_all_people_f
3945: where person_id=p_person_id
3946: and p_effective_date between effective_start_date
3947: and effective_end_date;
3948: hr_person_api.update_person
5874: hr_phone_api.create_or_update_phone
5875: (p_effective_date => p_effective_date
5876: ,p_parent_id => p_person_id
5877: ,p_update_mode => p_datetrack_update_mode
5878: ,p_parent_table => 'PER_ALL_PEOPLE_F'
5879: ,p_phone_type => 'H1'
5880: ,p_phone_number => p_phn_h_phone_number
5881: ,p_date_from => p_phn_h_date_from
5882: ,p_date_to => p_phn_h_date_to
5934: hr_phone_api.create_or_update_phone
5935: (p_effective_date => p_effective_date
5936: ,p_parent_id => p_person_id
5937: ,p_update_mode => p_datetrack_update_mode
5938: ,p_parent_table => 'PER_ALL_PEOPLE_F'
5939: ,p_phone_type => 'W1'
5940: ,p_phone_number => p_phn_w_phone_number
5941: ,p_date_from => p_phn_w_date_from
5942: ,p_date_to => p_phn_w_date_to
5994: hr_phone_api.create_or_update_phone
5995: (p_effective_date => p_effective_date
5996: ,p_parent_id => p_person_id
5997: ,p_update_mode => p_datetrack_update_mode
5998: ,p_parent_table => 'PER_ALL_PEOPLE_F'
5999: ,p_phone_type => 'M'
6000: ,p_phone_number => p_phn_m_phone_number
6001: ,p_date_from => p_phn_m_date_from
6002: ,p_date_to => p_phn_m_date_to
6032: hr_phone_api.create_or_update_phone
6033: (p_effective_date => p_effective_date
6034: ,p_parent_id => p_person_id
6035: ,p_update_mode => p_datetrack_update_mode
6036: ,p_parent_table => 'PER_ALL_PEOPLE_F'
6037: ,p_phone_type => 'HF'
6038: ,p_phone_number => p_phn_hf_phone_number
6039: ,p_date_from => p_phn_hf_date_from
6040: ,p_date_to => p_phn_hf_date_to
6085: hr_phone_api.create_or_update_phone
6086: (p_effective_date => p_effective_date
6087: ,p_parent_id => p_person_id
6088: ,p_update_mode => p_datetrack_update_mode
6089: ,p_parent_table => 'PER_ALL_PEOPLE_F'
6090: ,p_phone_type => 'WF'
6091: ,p_phone_number => p_phn_wf_phone_number
6092: ,p_date_from => p_phn_wf_date_from
6093: ,p_date_to => p_phn_wf_date_to
7010: --We need to provide code here to pass back the correct OVNs to the form
7011: --
7012: if p_person_id is not null then
7013: select per.object_version_number into l_per_object_version_number
7014: from per_all_people_f per
7015: where per.person_id=p_person_id
7016: and p_effective_date between per.effective_start_date and per.effective_end_date;
7017: --
7018: p_per_object_version_number := l_per_object_version_number;
7037: PROCEDURE lock_maintain_data
7038: (p_effective_date DATE
7039: ,p_datetrack_update_mode VARCHAR2
7040: ,p_person_update_allowed VARCHAR2 DEFAULT 'TRUE'
7041: ,p_person_id per_all_people_f.person_id%TYPE
7042: ,p_per_effective_start_date per_all_people_f.effective_start_date%TYPE
7043: ,p_per_effective_end_date per_all_people_f.effective_end_date%TYPE
7044: ,p_per_validation_start_date OUT NOCOPY DATE
7045: ,p_per_validation_end_date OUT NOCOPY DATE
7038: (p_effective_date DATE
7039: ,p_datetrack_update_mode VARCHAR2
7040: ,p_person_update_allowed VARCHAR2 DEFAULT 'TRUE'
7041: ,p_person_id per_all_people_f.person_id%TYPE
7042: ,p_per_effective_start_date per_all_people_f.effective_start_date%TYPE
7043: ,p_per_effective_end_date per_all_people_f.effective_end_date%TYPE
7044: ,p_per_validation_start_date OUT NOCOPY DATE
7045: ,p_per_validation_end_date OUT NOCOPY DATE
7046: ,p_per_object_version_number per_all_people_f.object_version_number%TYPE
7039: ,p_datetrack_update_mode VARCHAR2
7040: ,p_person_update_allowed VARCHAR2 DEFAULT 'TRUE'
7041: ,p_person_id per_all_people_f.person_id%TYPE
7042: ,p_per_effective_start_date per_all_people_f.effective_start_date%TYPE
7043: ,p_per_effective_end_date per_all_people_f.effective_end_date%TYPE
7044: ,p_per_validation_start_date OUT NOCOPY DATE
7045: ,p_per_validation_end_date OUT NOCOPY DATE
7046: ,p_per_object_version_number per_all_people_f.object_version_number%TYPE
7047: --CWK
7042: ,p_per_effective_start_date per_all_people_f.effective_start_date%TYPE
7043: ,p_per_effective_end_date per_all_people_f.effective_end_date%TYPE
7044: ,p_per_validation_start_date OUT NOCOPY DATE
7045: ,p_per_validation_end_date OUT NOCOPY DATE
7046: ,p_per_object_version_number per_all_people_f.object_version_number%TYPE
7047: --CWK
7048: ,p_placement_date_start per_periods_of_placement.date_start%TYPE
7049: ,p_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE
7050: ,p_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE