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;
1990: hr_phone_api.create_or_update_phone
1991: (p_effective_date => l_creation_date --p_effective_date
1992: ,p_parent_id => p_person_id
1993: ,p_update_mode => l_datetrack_update_mode
1994: ,p_parent_table => 'PER_ALL_PEOPLE_F'
1995: ,p_phone_type => 'H1'
1996: ,p_phone_number => p_phn_h_phone_number
1997: ,p_date_from => p_phn_h_date_from
1998: ,p_date_to => p_phn_h_date_to
2012: hr_phone_api.create_or_update_phone
2013: (p_effective_date => l_creation_date --p_effective_date
2014: ,p_parent_id => p_person_id
2015: ,p_update_mode => l_datetrack_update_mode
2016: ,p_parent_table => 'PER_ALL_PEOPLE_F'
2017: ,p_phone_type => 'W1'
2018: ,p_phone_number => p_phn_w_phone_number
2019: ,p_date_from => p_phn_w_date_from
2020: ,p_date_to => p_phn_w_date_to
2034: hr_phone_api.create_or_update_phone
2035: (p_effective_date => l_creation_date --p_effective_date
2036: ,p_parent_id => p_person_id
2037: ,p_update_mode => l_datetrack_update_mode
2038: ,p_parent_table => 'PER_ALL_PEOPLE_F'
2039: ,p_phone_type => 'M'
2040: ,p_phone_number => p_phn_m_phone_number
2041: ,p_date_from => p_phn_m_date_from
2042: ,p_date_to => p_phn_m_date_to
2056: hr_phone_api.create_or_update_phone
2057: (p_effective_date => l_creation_date --p_effective_date
2058: ,p_parent_id => p_person_id
2059: ,p_update_mode => l_datetrack_update_mode
2060: ,p_parent_table => 'PER_ALL_PEOPLE_F'
2061: ,p_phone_type => 'HF'
2062: ,p_phone_number => p_phn_hf_phone_number
2063: ,p_date_from => p_phn_hf_date_from
2064: ,p_date_to => p_phn_hf_date_to
2078: hr_phone_api.create_or_update_phone
2079: (p_effective_date => l_creation_date --p_effective_date
2080: ,p_parent_id => p_person_id
2081: ,p_update_mode => l_datetrack_update_mode
2082: ,p_parent_table => 'PER_ALL_PEOPLE_F'
2083: ,p_phone_type => 'WF'
2084: ,p_phone_number => p_phn_wf_phone_number
2085: ,p_date_from => p_phn_wf_date_from
2086: ,p_date_to => p_phn_wf_date_to
2645: --We need to provide code here to pass back the correct OVNs to the form
2646: --
2647: if p_person_id is not null then
2648: select per.object_version_number into l_per_object_version_number
2649: from per_all_people_f per
2650: where per.person_id=p_person_id
2651: -- and p_effective_date between per.effective_start_date and per.effective_end_date;
2652: and l_creation_date between per.effective_start_date and per.effective_end_date;
2653: --
2674: PROCEDURE update_maintain_data
2675: (p_effective_date IN DATE
2676: ,p_datetrack_update_mode IN VARCHAR2
2677: ,p_person_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
2678: ,p_person_id IN per_all_people_f.person_id%TYPE
2679: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
2680: ,p_legislation_code IN VARCHAR2
2681: ,p_per_effective_start_date IN OUT NOCOPY per_all_people_f.effective_start_date%TYPE
2682: ,p_per_effective_end_date IN OUT NOCOPY per_all_people_f.effective_end_date%TYPE
2675: (p_effective_date IN DATE
2676: ,p_datetrack_update_mode IN VARCHAR2
2677: ,p_person_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
2678: ,p_person_id IN per_all_people_f.person_id%TYPE
2679: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
2680: ,p_legislation_code IN VARCHAR2
2681: ,p_per_effective_start_date IN OUT NOCOPY per_all_people_f.effective_start_date%TYPE
2682: ,p_per_effective_end_date IN OUT NOCOPY per_all_people_f.effective_end_date%TYPE
2683: ,p_per_validation_start_date OUT NOCOPY DATE
2677: ,p_person_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
2678: ,p_person_id IN per_all_people_f.person_id%TYPE
2679: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
2680: ,p_legislation_code IN VARCHAR2
2681: ,p_per_effective_start_date IN OUT NOCOPY per_all_people_f.effective_start_date%TYPE
2682: ,p_per_effective_end_date IN OUT NOCOPY per_all_people_f.effective_end_date%TYPE
2683: ,p_per_validation_start_date OUT NOCOPY DATE
2684: ,p_per_validation_end_date OUT NOCOPY DATE
2685: ,p_person_type IN per_person_types.user_person_type%TYPE
2678: ,p_person_id IN per_all_people_f.person_id%TYPE
2679: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
2680: ,p_legislation_code IN VARCHAR2
2681: ,p_per_effective_start_date IN OUT NOCOPY per_all_people_f.effective_start_date%TYPE
2682: ,p_per_effective_end_date IN OUT NOCOPY per_all_people_f.effective_end_date%TYPE
2683: ,p_per_validation_start_date OUT NOCOPY DATE
2684: ,p_per_validation_end_date OUT NOCOPY DATE
2685: ,p_person_type IN per_person_types.user_person_type%TYPE
2686: ,p_system_person_type IN per_person_types.system_person_type%TYPE
2683: ,p_per_validation_start_date OUT NOCOPY DATE
2684: ,p_per_validation_end_date OUT NOCOPY DATE
2685: ,p_person_type IN per_person_types.user_person_type%TYPE
2686: ,p_system_person_type IN per_person_types.system_person_type%TYPE
2687: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
2688: ,p_last_name IN per_all_people_f.last_name%TYPE
2689: ,p_start_date IN per_all_people_f.start_date%TYPE
2690: ,p_applicant_number IN per_all_people_f.applicant_number%TYPE
2691: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
2684: ,p_per_validation_end_date OUT NOCOPY DATE
2685: ,p_person_type IN per_person_types.user_person_type%TYPE
2686: ,p_system_person_type IN per_person_types.system_person_type%TYPE
2687: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
2688: ,p_last_name IN per_all_people_f.last_name%TYPE
2689: ,p_start_date IN per_all_people_f.start_date%TYPE
2690: ,p_applicant_number IN per_all_people_f.applicant_number%TYPE
2691: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
2692: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
2685: ,p_person_type IN per_person_types.user_person_type%TYPE
2686: ,p_system_person_type IN per_person_types.system_person_type%TYPE
2687: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
2688: ,p_last_name IN per_all_people_f.last_name%TYPE
2689: ,p_start_date IN per_all_people_f.start_date%TYPE
2690: ,p_applicant_number IN per_all_people_f.applicant_number%TYPE
2691: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
2692: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
2693: ,p_blood_type IN per_all_people_f.blood_type%TYPE
2686: ,p_system_person_type IN per_person_types.system_person_type%TYPE
2687: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
2688: ,p_last_name IN per_all_people_f.last_name%TYPE
2689: ,p_start_date IN per_all_people_f.start_date%TYPE
2690: ,p_applicant_number IN per_all_people_f.applicant_number%TYPE
2691: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
2692: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
2693: ,p_blood_type IN per_all_people_f.blood_type%TYPE
2694: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
2687: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
2688: ,p_last_name IN per_all_people_f.last_name%TYPE
2689: ,p_start_date IN per_all_people_f.start_date%TYPE
2690: ,p_applicant_number IN per_all_people_f.applicant_number%TYPE
2691: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
2692: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
2693: ,p_blood_type IN per_all_people_f.blood_type%TYPE
2694: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
2695: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
2688: ,p_last_name IN per_all_people_f.last_name%TYPE
2689: ,p_start_date IN per_all_people_f.start_date%TYPE
2690: ,p_applicant_number IN per_all_people_f.applicant_number%TYPE
2691: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
2692: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
2693: ,p_blood_type IN per_all_people_f.blood_type%TYPE
2694: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
2695: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
2696: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
2689: ,p_start_date IN per_all_people_f.start_date%TYPE
2690: ,p_applicant_number IN per_all_people_f.applicant_number%TYPE
2691: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
2692: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
2693: ,p_blood_type IN per_all_people_f.blood_type%TYPE
2694: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
2695: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
2696: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
2697: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
2690: ,p_applicant_number IN per_all_people_f.applicant_number%TYPE
2691: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
2692: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
2693: ,p_blood_type IN per_all_people_f.blood_type%TYPE
2694: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
2695: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
2696: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
2697: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
2698: --CWK
2691: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
2692: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
2693: ,p_blood_type IN per_all_people_f.blood_type%TYPE
2694: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
2695: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
2696: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
2697: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
2698: --CWK
2699: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
2692: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
2693: ,p_blood_type IN per_all_people_f.blood_type%TYPE
2694: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
2695: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
2696: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
2697: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
2698: --CWK
2699: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
2700: ,p_npw_number IN per_all_people_f.npw_number%TYPE
2693: ,p_blood_type IN per_all_people_f.blood_type%TYPE
2694: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
2695: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
2696: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
2697: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
2698: --CWK
2699: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
2700: ,p_npw_number IN per_all_people_f.npw_number%TYPE
2701: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE
2695: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
2696: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
2697: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
2698: --CWK
2699: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
2700: ,p_npw_number IN per_all_people_f.npw_number%TYPE
2701: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE
2702: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
2703: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
2696: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
2697: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
2698: --CWK
2699: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
2700: ,p_npw_number IN per_all_people_f.npw_number%TYPE
2701: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE
2702: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
2703: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
2704: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
2715: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
2716: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
2717: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
2718: --
2719: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
2720: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
2721: ,p_email_address IN per_all_people_f.email_address%TYPE
2722: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
2723: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
2716: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
2717: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
2718: --
2719: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
2720: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
2721: ,p_email_address IN per_all_people_f.email_address%TYPE
2722: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
2723: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
2724: ,p_first_name IN per_all_people_f.first_name%TYPE
2717: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
2718: --
2719: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
2720: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
2721: ,p_email_address IN per_all_people_f.email_address%TYPE
2722: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
2723: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
2724: ,p_first_name IN per_all_people_f.first_name%TYPE
2725: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
2718: --
2719: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
2720: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
2721: ,p_email_address IN per_all_people_f.email_address%TYPE
2722: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
2723: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
2724: ,p_first_name IN per_all_people_f.first_name%TYPE
2725: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
2726: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
2719: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
2720: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
2721: ,p_email_address IN per_all_people_f.email_address%TYPE
2722: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
2723: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
2724: ,p_first_name IN per_all_people_f.first_name%TYPE
2725: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
2726: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
2727: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
2720: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
2721: ,p_email_address IN per_all_people_f.email_address%TYPE
2722: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
2723: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
2724: ,p_first_name IN per_all_people_f.first_name%TYPE
2725: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
2726: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
2727: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
2728: ,p_honors IN per_all_people_f.honors%TYPE
2721: ,p_email_address IN per_all_people_f.email_address%TYPE
2722: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
2723: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
2724: ,p_first_name IN per_all_people_f.first_name%TYPE
2725: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
2726: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
2727: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
2728: ,p_honors IN per_all_people_f.honors%TYPE
2729: ,p_internal_location IN per_all_people_f.internal_location%TYPE
2722: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
2723: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
2724: ,p_first_name IN per_all_people_f.first_name%TYPE
2725: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
2726: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
2727: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
2728: ,p_honors IN per_all_people_f.honors%TYPE
2729: ,p_internal_location IN per_all_people_f.internal_location%TYPE
2730: ,p_known_as IN per_all_people_f.known_as%TYPE
2723: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
2724: ,p_first_name IN per_all_people_f.first_name%TYPE
2725: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
2726: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
2727: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
2728: ,p_honors IN per_all_people_f.honors%TYPE
2729: ,p_internal_location IN per_all_people_f.internal_location%TYPE
2730: ,p_known_as IN per_all_people_f.known_as%TYPE
2731: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
2724: ,p_first_name IN per_all_people_f.first_name%TYPE
2725: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
2726: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
2727: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
2728: ,p_honors IN per_all_people_f.honors%TYPE
2729: ,p_internal_location IN per_all_people_f.internal_location%TYPE
2730: ,p_known_as IN per_all_people_f.known_as%TYPE
2731: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
2732: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
2725: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
2726: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
2727: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
2728: ,p_honors IN per_all_people_f.honors%TYPE
2729: ,p_internal_location IN per_all_people_f.internal_location%TYPE
2730: ,p_known_as IN per_all_people_f.known_as%TYPE
2731: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
2732: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
2733: ,p_mailstop IN per_all_people_f.mailstop%TYPE
2726: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
2727: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
2728: ,p_honors IN per_all_people_f.honors%TYPE
2729: ,p_internal_location IN per_all_people_f.internal_location%TYPE
2730: ,p_known_as IN per_all_people_f.known_as%TYPE
2731: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
2732: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
2733: ,p_mailstop IN per_all_people_f.mailstop%TYPE
2734: ,p_marital_status IN per_all_people_f.marital_status%TYPE
2727: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
2728: ,p_honors IN per_all_people_f.honors%TYPE
2729: ,p_internal_location IN per_all_people_f.internal_location%TYPE
2730: ,p_known_as IN per_all_people_f.known_as%TYPE
2731: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
2732: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
2733: ,p_mailstop IN per_all_people_f.mailstop%TYPE
2734: ,p_marital_status IN per_all_people_f.marital_status%TYPE
2735: ,p_middle_names IN per_all_people_f.middle_names%TYPE
2728: ,p_honors IN per_all_people_f.honors%TYPE
2729: ,p_internal_location IN per_all_people_f.internal_location%TYPE
2730: ,p_known_as IN per_all_people_f.known_as%TYPE
2731: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
2732: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
2733: ,p_mailstop IN per_all_people_f.mailstop%TYPE
2734: ,p_marital_status IN per_all_people_f.marital_status%TYPE
2735: ,p_middle_names IN per_all_people_f.middle_names%TYPE
2736: ,p_nationality IN per_all_people_f.nationality%TYPE
2729: ,p_internal_location IN per_all_people_f.internal_location%TYPE
2730: ,p_known_as IN per_all_people_f.known_as%TYPE
2731: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
2732: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
2733: ,p_mailstop IN per_all_people_f.mailstop%TYPE
2734: ,p_marital_status IN per_all_people_f.marital_status%TYPE
2735: ,p_middle_names IN per_all_people_f.middle_names%TYPE
2736: ,p_nationality IN per_all_people_f.nationality%TYPE
2737: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
2730: ,p_known_as IN per_all_people_f.known_as%TYPE
2731: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
2732: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
2733: ,p_mailstop IN per_all_people_f.mailstop%TYPE
2734: ,p_marital_status IN per_all_people_f.marital_status%TYPE
2735: ,p_middle_names IN per_all_people_f.middle_names%TYPE
2736: ,p_nationality IN per_all_people_f.nationality%TYPE
2737: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
2738: ,p_office_number IN per_all_people_f.office_number%TYPE
2731: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
2732: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
2733: ,p_mailstop IN per_all_people_f.mailstop%TYPE
2734: ,p_marital_status IN per_all_people_f.marital_status%TYPE
2735: ,p_middle_names IN per_all_people_f.middle_names%TYPE
2736: ,p_nationality IN per_all_people_f.nationality%TYPE
2737: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
2738: ,p_office_number IN per_all_people_f.office_number%TYPE
2739: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
2732: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
2733: ,p_mailstop IN per_all_people_f.mailstop%TYPE
2734: ,p_marital_status IN per_all_people_f.marital_status%TYPE
2735: ,p_middle_names IN per_all_people_f.middle_names%TYPE
2736: ,p_nationality IN per_all_people_f.nationality%TYPE
2737: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
2738: ,p_office_number IN per_all_people_f.office_number%TYPE
2739: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
2740: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
2733: ,p_mailstop IN per_all_people_f.mailstop%TYPE
2734: ,p_marital_status IN per_all_people_f.marital_status%TYPE
2735: ,p_middle_names IN per_all_people_f.middle_names%TYPE
2736: ,p_nationality IN per_all_people_f.nationality%TYPE
2737: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
2738: ,p_office_number IN per_all_people_f.office_number%TYPE
2739: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
2740: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
2741: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
2734: ,p_marital_status IN per_all_people_f.marital_status%TYPE
2735: ,p_middle_names IN per_all_people_f.middle_names%TYPE
2736: ,p_nationality IN per_all_people_f.nationality%TYPE
2737: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
2738: ,p_office_number IN per_all_people_f.office_number%TYPE
2739: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
2740: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
2741: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
2742: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
2735: ,p_middle_names IN per_all_people_f.middle_names%TYPE
2736: ,p_nationality IN per_all_people_f.nationality%TYPE
2737: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
2738: ,p_office_number IN per_all_people_f.office_number%TYPE
2739: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
2740: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
2741: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
2742: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
2743: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
2736: ,p_nationality IN per_all_people_f.nationality%TYPE
2737: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
2738: ,p_office_number IN per_all_people_f.office_number%TYPE
2739: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
2740: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
2741: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
2742: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
2743: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
2744: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
2737: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
2738: ,p_office_number IN per_all_people_f.office_number%TYPE
2739: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
2740: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
2741: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
2742: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
2743: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
2744: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
2745: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
2738: ,p_office_number IN per_all_people_f.office_number%TYPE
2739: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
2740: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
2741: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
2742: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
2743: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
2744: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
2745: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
2746: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
2739: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
2740: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
2741: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
2742: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
2743: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
2744: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
2745: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
2746: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
2747: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
2740: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
2741: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
2742: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
2743: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
2744: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
2745: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
2746: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
2747: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
2748: ,p_sex IN per_all_people_f.sex%TYPE
2741: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
2742: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
2743: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
2744: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
2745: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
2746: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
2747: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
2748: ,p_sex IN per_all_people_f.sex%TYPE
2749: ,p_student_status IN per_all_people_f.student_status%TYPE
2742: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
2743: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
2744: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
2745: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
2746: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
2747: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
2748: ,p_sex IN per_all_people_f.sex%TYPE
2749: ,p_student_status IN per_all_people_f.student_status%TYPE
2750: ,p_suffix IN per_all_people_f.suffix%TYPE
2743: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
2744: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
2745: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
2746: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
2747: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
2748: ,p_sex IN per_all_people_f.sex%TYPE
2749: ,p_student_status IN per_all_people_f.student_status%TYPE
2750: ,p_suffix IN per_all_people_f.suffix%TYPE
2751: ,p_title IN per_all_people_f.title%TYPE
2744: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
2745: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
2746: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
2747: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
2748: ,p_sex IN per_all_people_f.sex%TYPE
2749: ,p_student_status IN per_all_people_f.student_status%TYPE
2750: ,p_suffix IN per_all_people_f.suffix%TYPE
2751: ,p_title IN per_all_people_f.title%TYPE
2752: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
2745: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
2746: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
2747: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
2748: ,p_sex IN per_all_people_f.sex%TYPE
2749: ,p_student_status IN per_all_people_f.student_status%TYPE
2750: ,p_suffix IN per_all_people_f.suffix%TYPE
2751: ,p_title IN per_all_people_f.title%TYPE
2752: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
2753: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
2746: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
2747: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
2748: ,p_sex IN per_all_people_f.sex%TYPE
2749: ,p_student_status IN per_all_people_f.student_status%TYPE
2750: ,p_suffix IN per_all_people_f.suffix%TYPE
2751: ,p_title IN per_all_people_f.title%TYPE
2752: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
2753: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
2754: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
2747: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
2748: ,p_sex IN per_all_people_f.sex%TYPE
2749: ,p_student_status IN per_all_people_f.student_status%TYPE
2750: ,p_suffix IN per_all_people_f.suffix%TYPE
2751: ,p_title IN per_all_people_f.title%TYPE
2752: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
2753: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
2754: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
2755: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
2748: ,p_sex IN per_all_people_f.sex%TYPE
2749: ,p_student_status IN per_all_people_f.student_status%TYPE
2750: ,p_suffix IN per_all_people_f.suffix%TYPE
2751: ,p_title IN per_all_people_f.title%TYPE
2752: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
2753: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
2754: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
2755: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
2756: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
2749: ,p_student_status IN per_all_people_f.student_status%TYPE
2750: ,p_suffix IN per_all_people_f.suffix%TYPE
2751: ,p_title IN per_all_people_f.title%TYPE
2752: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
2753: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
2754: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
2755: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
2756: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
2757: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
2750: ,p_suffix IN per_all_people_f.suffix%TYPE
2751: ,p_title IN per_all_people_f.title%TYPE
2752: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
2753: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
2754: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
2755: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
2756: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
2757: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
2758: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
2751: ,p_title IN per_all_people_f.title%TYPE
2752: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
2753: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
2754: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
2755: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
2756: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
2757: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
2758: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
2759: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
2752: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
2753: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
2754: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
2755: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
2756: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
2757: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
2758: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
2759: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
2760: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
2753: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
2754: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
2755: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
2756: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
2757: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
2758: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
2759: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
2760: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
2761: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
2754: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
2755: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
2756: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
2757: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
2758: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
2759: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
2760: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
2761: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
2762: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
2755: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
2756: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
2757: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
2758: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
2759: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
2760: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
2761: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
2762: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
2763: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
2756: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
2757: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
2758: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
2759: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
2760: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
2761: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
2762: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
2763: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
2764: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
2757: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
2758: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
2759: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
2760: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
2761: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
2762: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
2763: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
2764: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
2765: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
2758: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
2759: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
2760: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
2761: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
2762: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
2763: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
2764: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
2765: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
2766: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
2759: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
2760: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
2761: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
2762: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
2763: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
2764: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
2765: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
2766: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
2767: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
2760: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
2761: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
2762: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
2763: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
2764: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
2765: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
2766: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
2767: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
2768: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
2761: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
2762: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
2763: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
2764: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
2765: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
2766: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
2767: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
2768: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
2769: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
2762: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
2763: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
2764: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
2765: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
2766: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
2767: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
2768: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
2769: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
2770: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
2763: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
2764: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
2765: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
2766: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
2767: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
2768: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
2769: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
2770: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
2771: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
2764: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
2765: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
2766: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
2767: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
2768: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
2769: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
2770: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
2771: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
2772: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
2765: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
2766: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
2767: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
2768: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
2769: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
2770: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
2771: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
2772: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
2773: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
2766: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
2767: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
2768: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
2769: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
2770: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
2771: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
2772: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
2773: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
2774: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
2767: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
2768: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
2769: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
2770: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
2771: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
2772: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
2773: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
2774: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
2775: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
2768: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
2769: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
2770: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
2771: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
2772: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
2773: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
2774: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
2775: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
2776: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
2769: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
2770: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
2771: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
2772: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
2773: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
2774: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
2775: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
2776: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
2777: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
2770: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
2771: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
2772: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
2773: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
2774: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
2775: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
2776: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
2777: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
2778: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
2771: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
2772: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
2773: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
2774: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
2775: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
2776: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
2777: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
2778: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
2779: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
2772: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
2773: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
2774: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
2775: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
2776: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
2777: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
2778: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
2779: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
2780: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
2773: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
2774: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
2775: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
2776: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
2777: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
2778: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
2779: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
2780: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
2781: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
2774: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
2775: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
2776: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
2777: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
2778: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
2779: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
2780: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
2781: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
2782: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
2775: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
2776: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
2777: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
2778: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
2779: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
2780: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
2781: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
2782: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
2783: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
2776: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
2777: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
2778: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
2779: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
2780: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
2781: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
2782: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
2783: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
2784: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
2777: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
2778: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
2779: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
2780: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
2781: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
2782: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
2783: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
2784: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
2785: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
2778: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
2779: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
2780: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
2781: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
2782: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
2783: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
2784: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
2785: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
2786: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
2779: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
2780: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
2781: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
2782: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
2783: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
2784: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
2785: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
2786: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
2787: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
2780: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
2781: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
2782: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
2783: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
2784: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
2785: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
2786: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
2787: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
2788: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
2781: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
2782: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
2783: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
2784: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
2785: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
2786: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
2787: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
2788: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
2789: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
2782: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
2783: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
2784: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
2785: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
2786: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
2787: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
2788: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
2789: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
2790: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
2783: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
2784: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
2785: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
2786: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
2787: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
2788: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
2789: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
2790: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
2791: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
2784: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
2785: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
2786: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
2787: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
2788: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
2789: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
2790: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
2791: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
2792: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
2785: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
2786: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
2787: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
2788: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
2789: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
2790: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
2791: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
2792: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
2793: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
2786: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
2787: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
2788: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
2789: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
2790: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
2791: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
2792: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
2793: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
2794: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
2787: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
2788: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
2789: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
2790: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
2791: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
2792: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
2793: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
2794: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
2795: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
2788: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
2789: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
2790: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
2791: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
2792: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
2793: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
2794: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
2795: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
2796: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
2789: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
2790: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
2791: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
2792: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
2793: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
2794: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
2795: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
2796: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
2797: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
2790: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
2791: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
2792: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
2793: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
2794: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
2795: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
2796: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
2797: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
2798: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
2791: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
2792: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
2793: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
2794: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
2795: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
2796: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
2797: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
2798: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
2799: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
2792: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
2793: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
2794: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
2795: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
2796: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
2797: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
2798: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
2799: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
2800: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
2793: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
2794: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
2795: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
2796: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
2797: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
2798: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
2799: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
2800: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
2801: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
2794: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
2795: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
2796: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
2797: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
2798: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
2799: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
2800: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
2801: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
2802: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
2795: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
2796: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
2797: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
2798: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
2799: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
2800: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
2801: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
2802: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
2803: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
2796: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
2797: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
2798: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
2799: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
2800: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
2801: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
2802: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
2803: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
2804: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
2797: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
2798: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
2799: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
2800: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
2801: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
2802: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
2803: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
2804: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
2805: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
2798: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
2799: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
2800: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
2801: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
2802: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
2803: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
2804: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
2805: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
2806: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
2799: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
2800: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
2801: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
2802: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
2803: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
2804: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
2805: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
2806: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
2807: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
2800: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
2801: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
2802: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
2803: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
2804: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
2805: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
2806: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
2807: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
2808: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
2801: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
2802: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
2803: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
2804: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
2805: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
2806: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
2807: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
2808: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
2809: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
2802: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
2803: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
2804: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
2805: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
2806: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
2807: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
2808: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
2809: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
2810: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
2803: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
2804: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
2805: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
2806: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
2807: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
2808: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
2809: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
2810: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
2811: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
2804: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
2805: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
2806: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
2807: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
2808: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
2809: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
2810: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
2811: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
2812: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
2805: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
2806: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
2807: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
2808: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
2809: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
2810: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
2811: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
2812: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
2813: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
2806: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
2807: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
2808: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
2809: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
2810: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
2811: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
2812: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
2813: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
2814: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
2807: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
2808: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
2809: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
2810: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
2811: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
2812: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
2813: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
2814: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
2815: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
2808: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
2809: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
2810: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
2811: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
2812: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
2813: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
2814: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
2815: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
2816: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
2809: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
2810: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
2811: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
2812: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
2813: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
2814: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
2815: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
2816: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
2817: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
2810: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
2811: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
2812: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
2813: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
2814: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
2815: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
2816: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
2817: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
2818: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
2811: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
2812: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
2813: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
2814: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
2815: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
2816: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
2817: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
2818: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
2819: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
2812: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
2813: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
2814: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
2815: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
2816: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
2817: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
2818: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
2819: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
2820: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
2813: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
2814: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
2815: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
2816: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
2817: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
2818: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
2819: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
2820: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
2821: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
2814: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
2815: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
2816: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
2817: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
2818: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
2819: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
2820: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
2821: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
2822: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
2815: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
2816: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
2817: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
2818: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
2819: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
2820: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
2821: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
2822: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
2823: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
2816: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
2817: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
2818: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
2819: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
2820: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
2821: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
2822: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
2823: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
2824: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
2817: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
2818: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
2819: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
2820: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
2821: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
2822: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
2823: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
2824: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
2825: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
2818: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
2819: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
2820: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
2821: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
2822: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
2823: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
2824: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
2825: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
2826: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
2819: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
2820: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
2821: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
2822: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
2823: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
2824: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
2825: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
2826: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
2827: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
2820: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
2821: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
2822: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
2823: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
2824: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
2825: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
2826: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
2827: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
2828: ,p_assignment_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
2821: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
2822: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
2823: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
2824: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
2825: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
2826: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
2827: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
2828: ,p_assignment_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
2829: ,p_assignment_id IN OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
2822: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
2823: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
2824: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
2825: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
2826: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
2827: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
2828: ,p_assignment_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
2829: ,p_assignment_id IN OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
2830: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
2823: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
2824: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
2825: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
2826: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
2827: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
2828: ,p_assignment_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
2829: ,p_assignment_id IN OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
2830: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
2831: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
3391: ,p_payroll_warning OUT NOCOPY BOOLEAN
3392: ,p_gsp_post_process_warning OUT NOCOPY VARCHAR2
3393: ) IS
3394: --
3395: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
3396: l_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE;
3397: l_employee_number per_all_people_f.employee_number%TYPE;
3398: l_npw_number per_all_people_f.npw_number%TYPE := p_npw_number;
3399: l_per_effective_start_date DATE;
3393: ) IS
3394: --
3395: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
3396: l_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE;
3397: l_employee_number per_all_people_f.employee_number%TYPE;
3398: l_npw_number per_all_people_f.npw_number%TYPE := p_npw_number;
3399: l_per_effective_start_date DATE;
3400: l_per_effective_end_date DATE;
3401: l_per_validation_start_date DATE;
3394: --
3395: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
3396: l_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE;
3397: l_employee_number per_all_people_f.employee_number%TYPE;
3398: l_npw_number per_all_people_f.npw_number%TYPE := p_npw_number;
3399: l_per_effective_start_date DATE;
3400: l_per_effective_end_date DATE;
3401: l_per_validation_start_date DATE;
3402: l_per_validation_end_date DATE;
3400: l_per_effective_end_date DATE;
3401: l_per_validation_start_date DATE;
3402: l_per_validation_end_date DATE;
3403: l_per_datetrack_update_mode VARCHAR2(30);
3404: l_full_name per_all_people_f.full_name%TYPE;
3405: l_duplicate_flag VARCHAR2(1);
3406: l_comment_id NUMBER;
3407: l_name_combination_warning BOOLEAN;
3408: l_assign_payroll_warning BOOLEAN;
3464: l_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
3465: l_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
3466: l_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE;
3467: --
3468: l_party_id per_all_people_f.party_id%TYPE;
3469: --
3470: l_gsp_post_process_warning varchar2(30); -- bug2999562
3471: l_gsp_post_process_warning2 varchar2(30);
3472: l_gsp_post_process_warning3 varchar2(30);
3904: hr_utility.set_location(l_proc, 40);
3905: --
3906: select party_id
3907: into l_party_id
3908: from per_all_people_f
3909: where person_id=p_person_id
3910: and p_effective_date between effective_start_date
3911: and effective_end_date;
3912: hr_person_api.update_person
5834: hr_phone_api.create_or_update_phone
5835: (p_effective_date => p_effective_date
5836: ,p_parent_id => p_person_id
5837: ,p_update_mode => p_datetrack_update_mode
5838: ,p_parent_table => 'PER_ALL_PEOPLE_F'
5839: ,p_phone_type => 'H1'
5840: ,p_phone_number => p_phn_h_phone_number
5841: ,p_date_from => p_phn_h_date_from
5842: ,p_date_to => p_phn_h_date_to
5894: hr_phone_api.create_or_update_phone
5895: (p_effective_date => p_effective_date
5896: ,p_parent_id => p_person_id
5897: ,p_update_mode => p_datetrack_update_mode
5898: ,p_parent_table => 'PER_ALL_PEOPLE_F'
5899: ,p_phone_type => 'W1'
5900: ,p_phone_number => p_phn_w_phone_number
5901: ,p_date_from => p_phn_w_date_from
5902: ,p_date_to => p_phn_w_date_to
5954: hr_phone_api.create_or_update_phone
5955: (p_effective_date => p_effective_date
5956: ,p_parent_id => p_person_id
5957: ,p_update_mode => p_datetrack_update_mode
5958: ,p_parent_table => 'PER_ALL_PEOPLE_F'
5959: ,p_phone_type => 'M'
5960: ,p_phone_number => p_phn_m_phone_number
5961: ,p_date_from => p_phn_m_date_from
5962: ,p_date_to => p_phn_m_date_to
5992: hr_phone_api.create_or_update_phone
5993: (p_effective_date => p_effective_date
5994: ,p_parent_id => p_person_id
5995: ,p_update_mode => p_datetrack_update_mode
5996: ,p_parent_table => 'PER_ALL_PEOPLE_F'
5997: ,p_phone_type => 'HF'
5998: ,p_phone_number => p_phn_hf_phone_number
5999: ,p_date_from => p_phn_hf_date_from
6000: ,p_date_to => p_phn_hf_date_to
6045: hr_phone_api.create_or_update_phone
6046: (p_effective_date => p_effective_date
6047: ,p_parent_id => p_person_id
6048: ,p_update_mode => p_datetrack_update_mode
6049: ,p_parent_table => 'PER_ALL_PEOPLE_F'
6050: ,p_phone_type => 'WF'
6051: ,p_phone_number => p_phn_wf_phone_number
6052: ,p_date_from => p_phn_wf_date_from
6053: ,p_date_to => p_phn_wf_date_to
6970: --We need to provide code here to pass back the correct OVNs to the form
6971: --
6972: if p_person_id is not null then
6973: select per.object_version_number into l_per_object_version_number
6974: from per_all_people_f per
6975: where per.person_id=p_person_id
6976: and p_effective_date between per.effective_start_date and per.effective_end_date;
6977: --
6978: p_per_object_version_number := l_per_object_version_number;
6997: PROCEDURE lock_maintain_data
6998: (p_effective_date DATE
6999: ,p_datetrack_update_mode VARCHAR2
7000: ,p_person_update_allowed VARCHAR2 DEFAULT 'TRUE'
7001: ,p_person_id per_all_people_f.person_id%TYPE
7002: ,p_per_effective_start_date per_all_people_f.effective_start_date%TYPE
7003: ,p_per_effective_end_date per_all_people_f.effective_end_date%TYPE
7004: ,p_per_validation_start_date OUT NOCOPY DATE
7005: ,p_per_validation_end_date OUT NOCOPY DATE
6998: (p_effective_date DATE
6999: ,p_datetrack_update_mode VARCHAR2
7000: ,p_person_update_allowed VARCHAR2 DEFAULT 'TRUE'
7001: ,p_person_id per_all_people_f.person_id%TYPE
7002: ,p_per_effective_start_date per_all_people_f.effective_start_date%TYPE
7003: ,p_per_effective_end_date per_all_people_f.effective_end_date%TYPE
7004: ,p_per_validation_start_date OUT NOCOPY DATE
7005: ,p_per_validation_end_date OUT NOCOPY DATE
7006: ,p_per_object_version_number per_all_people_f.object_version_number%TYPE
6999: ,p_datetrack_update_mode VARCHAR2
7000: ,p_person_update_allowed VARCHAR2 DEFAULT 'TRUE'
7001: ,p_person_id per_all_people_f.person_id%TYPE
7002: ,p_per_effective_start_date per_all_people_f.effective_start_date%TYPE
7003: ,p_per_effective_end_date per_all_people_f.effective_end_date%TYPE
7004: ,p_per_validation_start_date OUT NOCOPY DATE
7005: ,p_per_validation_end_date OUT NOCOPY DATE
7006: ,p_per_object_version_number per_all_people_f.object_version_number%TYPE
7007: --CWK
7002: ,p_per_effective_start_date per_all_people_f.effective_start_date%TYPE
7003: ,p_per_effective_end_date per_all_people_f.effective_end_date%TYPE
7004: ,p_per_validation_start_date OUT NOCOPY DATE
7005: ,p_per_validation_end_date OUT NOCOPY DATE
7006: ,p_per_object_version_number per_all_people_f.object_version_number%TYPE
7007: --CWK
7008: ,p_placement_date_start per_periods_of_placement.date_start%TYPE
7009: ,p_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE
7010: ,p_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE