[Home] [Help]
8: -- Fix For Bug 8246722 Ends--
9:
10: PROCEDURE insert_maintain_data
11: (p_effective_date IN DATE
12: ,p_person_id OUT NOCOPY per_all_people_f.person_id%TYPE
13: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
14: ,p_legislation_code IN VARCHAR2
15: ,p_per_effective_start_date IN OUT NOCOPY per_all_people_f.effective_start_date%TYPE
16: ,p_per_effective_end_date IN OUT NOCOPY per_all_people_f.effective_end_date%TYPE
9:
10: PROCEDURE insert_maintain_data
11: (p_effective_date IN DATE
12: ,p_person_id OUT NOCOPY per_all_people_f.person_id%TYPE
13: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
14: ,p_legislation_code IN VARCHAR2
15: ,p_per_effective_start_date IN OUT NOCOPY per_all_people_f.effective_start_date%TYPE
16: ,p_per_effective_end_date IN OUT NOCOPY per_all_people_f.effective_end_date%TYPE
17: ,p_per_validation_start_date OUT NOCOPY DATE
11: (p_effective_date IN DATE
12: ,p_person_id OUT NOCOPY per_all_people_f.person_id%TYPE
13: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
14: ,p_legislation_code IN VARCHAR2
15: ,p_per_effective_start_date IN OUT NOCOPY per_all_people_f.effective_start_date%TYPE
16: ,p_per_effective_end_date IN OUT NOCOPY per_all_people_f.effective_end_date%TYPE
17: ,p_per_validation_start_date OUT NOCOPY DATE
18: ,p_per_validation_end_date OUT NOCOPY DATE
19: ,p_person_type IN per_person_types.user_person_type%TYPE
12: ,p_person_id OUT NOCOPY per_all_people_f.person_id%TYPE
13: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
14: ,p_legislation_code IN VARCHAR2
15: ,p_per_effective_start_date IN OUT NOCOPY per_all_people_f.effective_start_date%TYPE
16: ,p_per_effective_end_date IN OUT NOCOPY per_all_people_f.effective_end_date%TYPE
17: ,p_per_validation_start_date OUT NOCOPY DATE
18: ,p_per_validation_end_date OUT NOCOPY DATE
19: ,p_person_type IN per_person_types.user_person_type%TYPE
20: ,p_system_person_type IN per_person_types.system_person_type%TYPE
17: ,p_per_validation_start_date OUT NOCOPY DATE
18: ,p_per_validation_end_date OUT NOCOPY DATE
19: ,p_person_type IN per_person_types.user_person_type%TYPE
20: ,p_system_person_type IN per_person_types.system_person_type%TYPE
21: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
22: ,p_last_name IN per_all_people_f.last_name%TYPE
23: ,p_start_date IN per_all_people_f.start_date%TYPE
24: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
25: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
18: ,p_per_validation_end_date OUT NOCOPY DATE
19: ,p_person_type IN per_person_types.user_person_type%TYPE
20: ,p_system_person_type IN per_person_types.system_person_type%TYPE
21: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
22: ,p_last_name IN per_all_people_f.last_name%TYPE
23: ,p_start_date IN per_all_people_f.start_date%TYPE
24: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
25: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
26: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
19: ,p_person_type IN per_person_types.user_person_type%TYPE
20: ,p_system_person_type IN per_person_types.system_person_type%TYPE
21: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
22: ,p_last_name IN per_all_people_f.last_name%TYPE
23: ,p_start_date IN per_all_people_f.start_date%TYPE
24: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
25: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
26: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
27: ,p_blood_type IN per_all_people_f.blood_type%TYPE
20: ,p_system_person_type IN per_person_types.system_person_type%TYPE
21: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
22: ,p_last_name IN per_all_people_f.last_name%TYPE
23: ,p_start_date IN per_all_people_f.start_date%TYPE
24: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
25: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
26: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
27: ,p_blood_type IN per_all_people_f.blood_type%TYPE
28: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
21: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
22: ,p_last_name IN per_all_people_f.last_name%TYPE
23: ,p_start_date IN per_all_people_f.start_date%TYPE
24: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
25: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
26: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
27: ,p_blood_type IN per_all_people_f.blood_type%TYPE
28: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
29: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
22: ,p_last_name IN per_all_people_f.last_name%TYPE
23: ,p_start_date IN per_all_people_f.start_date%TYPE
24: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
25: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
26: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
27: ,p_blood_type IN per_all_people_f.blood_type%TYPE
28: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
29: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
30: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
23: ,p_start_date IN per_all_people_f.start_date%TYPE
24: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
25: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
26: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
27: ,p_blood_type IN per_all_people_f.blood_type%TYPE
28: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
29: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
30: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
31: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
24: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
25: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
26: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
27: ,p_blood_type IN per_all_people_f.blood_type%TYPE
28: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
29: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
30: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
31: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
32: ,p_hire_date IN OUT NOCOPY per_periods_of_service.date_start%TYPE -- Bug 3975241
25: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
26: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
27: ,p_blood_type IN per_all_people_f.blood_type%TYPE
28: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
29: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
30: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
31: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
32: ,p_hire_date IN OUT NOCOPY per_periods_of_service.date_start%TYPE -- Bug 3975241
33: --CWK
26: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
27: ,p_blood_type IN per_all_people_f.blood_type%TYPE
28: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
29: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
30: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
31: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
32: ,p_hire_date IN OUT NOCOPY per_periods_of_service.date_start%TYPE -- Bug 3975241
33: --CWK
34: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
27: ,p_blood_type IN per_all_people_f.blood_type%TYPE
28: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
29: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
30: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
31: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
32: ,p_hire_date IN OUT NOCOPY per_periods_of_service.date_start%TYPE -- Bug 3975241
33: --CWK
34: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
35: ,p_npw_number IN OUT NOCOPY per_all_people_f.npw_number%TYPE
30: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
31: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
32: ,p_hire_date IN OUT NOCOPY per_periods_of_service.date_start%TYPE -- Bug 3975241
33: --CWK
34: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
35: ,p_npw_number IN OUT NOCOPY per_all_people_f.npw_number%TYPE
36: ,p_placement_date_start IN OUT NOCOPY per_all_assignments_f.period_of_placement_date_start%TYPE -- Bug 4287925
37: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
38: ,p_pdp_object_version_number OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
31: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
32: ,p_hire_date IN OUT NOCOPY per_periods_of_service.date_start%TYPE -- Bug 3975241
33: --CWK
34: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
35: ,p_npw_number IN OUT NOCOPY per_all_people_f.npw_number%TYPE
36: ,p_placement_date_start IN OUT NOCOPY per_all_assignments_f.period_of_placement_date_start%TYPE -- Bug 4287925
37: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
38: ,p_pdp_object_version_number OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
39: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
50: ,p_rate_effective_start_date OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
51: ,p_rate_effective_end_date OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
52: ,p_rate_object_version_number OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
53: --
54: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
55: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
56: ,p_email_address IN per_all_people_f.email_address%TYPE
57: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
58: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
51: ,p_rate_effective_end_date OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
52: ,p_rate_object_version_number OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
53: --
54: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
55: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
56: ,p_email_address IN per_all_people_f.email_address%TYPE
57: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
58: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
59: ,p_first_name IN per_all_people_f.first_name%TYPE
52: ,p_rate_object_version_number OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
53: --
54: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
55: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
56: ,p_email_address IN per_all_people_f.email_address%TYPE
57: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
58: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
59: ,p_first_name IN per_all_people_f.first_name%TYPE
60: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
53: --
54: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
55: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
56: ,p_email_address IN per_all_people_f.email_address%TYPE
57: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
58: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
59: ,p_first_name IN per_all_people_f.first_name%TYPE
60: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
61: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
54: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
55: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
56: ,p_email_address IN per_all_people_f.email_address%TYPE
57: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
58: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
59: ,p_first_name IN per_all_people_f.first_name%TYPE
60: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
61: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
62: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
55: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
56: ,p_email_address IN per_all_people_f.email_address%TYPE
57: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
58: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
59: ,p_first_name IN per_all_people_f.first_name%TYPE
60: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
61: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
62: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
63: ,p_honors IN per_all_people_f.honors%TYPE
56: ,p_email_address IN per_all_people_f.email_address%TYPE
57: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
58: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
59: ,p_first_name IN per_all_people_f.first_name%TYPE
60: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
61: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
62: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
63: ,p_honors IN per_all_people_f.honors%TYPE
64: ,p_internal_location IN per_all_people_f.internal_location%TYPE
57: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
58: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
59: ,p_first_name IN per_all_people_f.first_name%TYPE
60: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
61: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
62: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
63: ,p_honors IN per_all_people_f.honors%TYPE
64: ,p_internal_location IN per_all_people_f.internal_location%TYPE
65: ,p_known_as IN per_all_people_f.known_as%TYPE
58: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
59: ,p_first_name IN per_all_people_f.first_name%TYPE
60: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
61: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
62: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
63: ,p_honors IN per_all_people_f.honors%TYPE
64: ,p_internal_location IN per_all_people_f.internal_location%TYPE
65: ,p_known_as IN per_all_people_f.known_as%TYPE
66: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
59: ,p_first_name IN per_all_people_f.first_name%TYPE
60: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
61: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
62: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
63: ,p_honors IN per_all_people_f.honors%TYPE
64: ,p_internal_location IN per_all_people_f.internal_location%TYPE
65: ,p_known_as IN per_all_people_f.known_as%TYPE
66: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
67: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
60: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
61: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
62: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
63: ,p_honors IN per_all_people_f.honors%TYPE
64: ,p_internal_location IN per_all_people_f.internal_location%TYPE
65: ,p_known_as IN per_all_people_f.known_as%TYPE
66: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
67: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
68: ,p_mailstop IN per_all_people_f.mailstop%TYPE
61: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
62: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
63: ,p_honors IN per_all_people_f.honors%TYPE
64: ,p_internal_location IN per_all_people_f.internal_location%TYPE
65: ,p_known_as IN per_all_people_f.known_as%TYPE
66: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
67: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
68: ,p_mailstop IN per_all_people_f.mailstop%TYPE
69: ,p_marital_status IN per_all_people_f.marital_status%TYPE
62: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
63: ,p_honors IN per_all_people_f.honors%TYPE
64: ,p_internal_location IN per_all_people_f.internal_location%TYPE
65: ,p_known_as IN per_all_people_f.known_as%TYPE
66: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
67: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
68: ,p_mailstop IN per_all_people_f.mailstop%TYPE
69: ,p_marital_status IN per_all_people_f.marital_status%TYPE
70: ,p_middle_names IN per_all_people_f.middle_names%TYPE
63: ,p_honors IN per_all_people_f.honors%TYPE
64: ,p_internal_location IN per_all_people_f.internal_location%TYPE
65: ,p_known_as IN per_all_people_f.known_as%TYPE
66: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
67: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
68: ,p_mailstop IN per_all_people_f.mailstop%TYPE
69: ,p_marital_status IN per_all_people_f.marital_status%TYPE
70: ,p_middle_names IN per_all_people_f.middle_names%TYPE
71: ,p_nationality IN per_all_people_f.nationality%TYPE
64: ,p_internal_location IN per_all_people_f.internal_location%TYPE
65: ,p_known_as IN per_all_people_f.known_as%TYPE
66: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
67: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
68: ,p_mailstop IN per_all_people_f.mailstop%TYPE
69: ,p_marital_status IN per_all_people_f.marital_status%TYPE
70: ,p_middle_names IN per_all_people_f.middle_names%TYPE
71: ,p_nationality IN per_all_people_f.nationality%TYPE
72: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
65: ,p_known_as IN per_all_people_f.known_as%TYPE
66: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
67: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
68: ,p_mailstop IN per_all_people_f.mailstop%TYPE
69: ,p_marital_status IN per_all_people_f.marital_status%TYPE
70: ,p_middle_names IN per_all_people_f.middle_names%TYPE
71: ,p_nationality IN per_all_people_f.nationality%TYPE
72: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
73: ,p_office_number IN per_all_people_f.office_number%TYPE
66: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
67: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
68: ,p_mailstop IN per_all_people_f.mailstop%TYPE
69: ,p_marital_status IN per_all_people_f.marital_status%TYPE
70: ,p_middle_names IN per_all_people_f.middle_names%TYPE
71: ,p_nationality IN per_all_people_f.nationality%TYPE
72: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
73: ,p_office_number IN per_all_people_f.office_number%TYPE
74: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
67: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
68: ,p_mailstop IN per_all_people_f.mailstop%TYPE
69: ,p_marital_status IN per_all_people_f.marital_status%TYPE
70: ,p_middle_names IN per_all_people_f.middle_names%TYPE
71: ,p_nationality IN per_all_people_f.nationality%TYPE
72: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
73: ,p_office_number IN per_all_people_f.office_number%TYPE
74: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
75: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
68: ,p_mailstop IN per_all_people_f.mailstop%TYPE
69: ,p_marital_status IN per_all_people_f.marital_status%TYPE
70: ,p_middle_names IN per_all_people_f.middle_names%TYPE
71: ,p_nationality IN per_all_people_f.nationality%TYPE
72: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
73: ,p_office_number IN per_all_people_f.office_number%TYPE
74: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
75: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
76: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
69: ,p_marital_status IN per_all_people_f.marital_status%TYPE
70: ,p_middle_names IN per_all_people_f.middle_names%TYPE
71: ,p_nationality IN per_all_people_f.nationality%TYPE
72: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
73: ,p_office_number IN per_all_people_f.office_number%TYPE
74: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
75: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
76: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
77: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
70: ,p_middle_names IN per_all_people_f.middle_names%TYPE
71: ,p_nationality IN per_all_people_f.nationality%TYPE
72: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
73: ,p_office_number IN per_all_people_f.office_number%TYPE
74: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
75: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
76: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
77: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
78: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
71: ,p_nationality IN per_all_people_f.nationality%TYPE
72: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
73: ,p_office_number IN per_all_people_f.office_number%TYPE
74: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
75: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
76: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
77: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
78: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
79: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
72: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
73: ,p_office_number IN per_all_people_f.office_number%TYPE
74: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
75: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
76: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
77: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
78: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
79: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
80: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
73: ,p_office_number IN per_all_people_f.office_number%TYPE
74: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
75: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
76: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
77: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
78: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
79: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
80: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
81: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
74: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
75: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
76: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
77: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
78: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
79: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
80: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
81: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
82: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
75: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
76: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
77: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
78: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
79: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
80: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
81: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
82: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
83: ,p_sex IN per_all_people_f.sex%TYPE
76: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
77: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
78: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
79: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
80: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
81: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
82: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
83: ,p_sex IN per_all_people_f.sex%TYPE
84: ,p_student_status IN per_all_people_f.student_status%TYPE
77: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
78: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
79: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
80: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
81: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
82: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
83: ,p_sex IN per_all_people_f.sex%TYPE
84: ,p_student_status IN per_all_people_f.student_status%TYPE
85: ,p_suffix IN per_all_people_f.suffix%TYPE
78: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
79: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
80: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
81: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
82: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
83: ,p_sex IN per_all_people_f.sex%TYPE
84: ,p_student_status IN per_all_people_f.student_status%TYPE
85: ,p_suffix IN per_all_people_f.suffix%TYPE
86: ,p_title IN per_all_people_f.title%TYPE
79: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
80: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
81: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
82: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
83: ,p_sex IN per_all_people_f.sex%TYPE
84: ,p_student_status IN per_all_people_f.student_status%TYPE
85: ,p_suffix IN per_all_people_f.suffix%TYPE
86: ,p_title IN per_all_people_f.title%TYPE
87: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
80: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
81: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
82: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
83: ,p_sex IN per_all_people_f.sex%TYPE
84: ,p_student_status IN per_all_people_f.student_status%TYPE
85: ,p_suffix IN per_all_people_f.suffix%TYPE
86: ,p_title IN per_all_people_f.title%TYPE
87: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
88: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
81: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
82: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
83: ,p_sex IN per_all_people_f.sex%TYPE
84: ,p_student_status IN per_all_people_f.student_status%TYPE
85: ,p_suffix IN per_all_people_f.suffix%TYPE
86: ,p_title IN per_all_people_f.title%TYPE
87: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
88: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
89: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
82: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
83: ,p_sex IN per_all_people_f.sex%TYPE
84: ,p_student_status IN per_all_people_f.student_status%TYPE
85: ,p_suffix IN per_all_people_f.suffix%TYPE
86: ,p_title IN per_all_people_f.title%TYPE
87: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
88: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
89: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
90: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
83: ,p_sex IN per_all_people_f.sex%TYPE
84: ,p_student_status IN per_all_people_f.student_status%TYPE
85: ,p_suffix IN per_all_people_f.suffix%TYPE
86: ,p_title IN per_all_people_f.title%TYPE
87: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
88: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
89: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
90: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
91: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
84: ,p_student_status IN per_all_people_f.student_status%TYPE
85: ,p_suffix IN per_all_people_f.suffix%TYPE
86: ,p_title IN per_all_people_f.title%TYPE
87: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
88: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
89: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
90: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
91: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
92: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
85: ,p_suffix IN per_all_people_f.suffix%TYPE
86: ,p_title IN per_all_people_f.title%TYPE
87: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
88: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
89: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
90: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
91: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
92: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
93: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
86: ,p_title IN per_all_people_f.title%TYPE
87: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
88: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
89: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
90: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
91: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
92: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
93: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
94: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
87: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
88: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
89: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
90: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
91: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
92: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
93: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
94: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
95: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
88: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
89: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
90: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
91: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
92: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
93: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
94: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
95: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
96: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
89: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
90: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
91: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
92: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
93: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
94: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
95: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
96: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
97: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
90: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
91: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
92: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
93: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
94: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
95: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
96: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
97: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
98: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
91: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
92: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
93: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
94: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
95: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
96: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
97: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
98: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
99: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
92: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
93: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
94: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
95: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
96: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
97: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
98: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
99: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
100: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
93: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
94: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
95: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
96: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
97: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
98: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
99: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
100: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
101: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
94: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
95: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
96: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
97: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
98: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
99: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
100: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
101: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
102: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
95: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
96: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
97: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
98: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
99: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
100: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
101: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
102: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
103: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
96: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
97: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
98: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
99: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
100: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
101: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
102: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
103: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
104: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
97: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
98: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
99: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
100: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
101: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
102: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
103: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
104: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
105: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
98: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
99: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
100: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
101: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
102: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
103: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
104: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
105: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
106: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
99: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
100: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
101: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
102: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
103: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
104: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
105: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
106: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
107: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
100: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
101: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
102: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
103: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
104: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
105: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
106: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
107: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
108: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
101: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
102: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
103: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
104: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
105: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
106: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
107: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
108: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
109: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
102: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
103: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
104: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
105: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
106: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
107: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
108: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
109: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
110: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
103: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
104: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
105: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
106: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
107: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
108: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
109: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
110: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
111: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
104: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
105: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
106: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
107: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
108: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
109: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
110: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
111: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
112: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
105: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
106: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
107: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
108: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
109: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
110: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
111: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
112: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
113: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
106: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
107: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
108: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
109: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
110: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
111: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
112: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
113: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
114: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
107: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
108: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
109: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
110: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
111: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
112: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
113: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
114: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
115: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
108: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
109: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
110: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
111: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
112: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
113: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
114: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
115: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
116: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
109: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
110: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
111: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
112: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
113: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
114: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
115: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
116: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
117: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
110: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
111: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
112: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
113: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
114: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
115: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
116: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
117: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
118: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
111: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
112: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
113: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
114: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
115: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
116: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
117: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
118: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
119: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
112: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
113: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
114: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
115: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
116: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
117: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
118: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
119: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
120: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
113: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
114: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
115: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
116: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
117: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
118: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
119: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
120: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
121: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
114: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
115: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
116: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
117: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
118: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
119: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
120: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
121: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
122: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
115: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
116: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
117: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
118: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
119: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
120: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
121: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
122: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
123: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
116: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
117: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
118: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
119: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
120: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
121: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
122: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
123: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
124: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
117: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
118: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
119: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
120: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
121: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
122: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
123: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
124: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
125: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
118: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
119: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
120: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
121: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
122: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
123: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
124: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
125: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
126: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
119: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
120: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
121: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
122: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
123: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
124: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
125: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
126: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
127: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
120: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
121: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
122: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
123: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
124: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
125: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
126: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
127: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
128: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
121: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
122: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
123: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
124: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
125: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
126: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
127: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
128: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
129: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
122: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
123: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
124: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
125: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
126: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
127: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
128: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
129: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
130: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
123: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
124: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
125: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
126: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
127: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
128: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
129: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
130: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
131: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
124: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
125: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
126: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
127: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
128: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
129: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
130: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
131: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
132: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
125: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
126: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
127: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
128: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
129: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
130: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
131: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
132: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
133: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
126: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
127: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
128: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
129: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
130: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
131: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
132: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
133: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
134: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
127: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
128: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
129: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
130: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
131: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
132: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
133: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
134: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
135: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
128: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
129: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
130: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
131: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
132: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
133: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
134: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
135: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
136: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
129: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
130: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
131: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
132: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
133: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
134: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
135: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
136: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
137: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
130: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
131: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
132: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
133: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
134: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
135: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
136: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
137: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
138: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
131: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
132: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
133: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
134: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
135: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
136: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
137: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
138: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
139: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
132: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
133: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
134: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
135: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
136: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
137: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
138: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
139: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
140: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
133: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
134: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
135: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
136: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
137: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
138: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
139: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
140: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
141: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
134: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
135: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
136: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
137: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
138: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
139: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
140: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
141: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
142: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
135: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
136: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
137: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
138: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
139: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
140: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
141: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
142: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
143: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
136: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
137: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
138: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
139: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
140: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
141: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
142: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
143: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
144: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
137: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
138: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
139: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
140: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
141: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
142: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
143: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
144: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
145: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
138: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
139: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
140: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
141: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
142: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
143: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
144: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
145: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
146: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
139: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
140: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
141: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
142: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
143: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
144: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
145: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
146: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
147: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
140: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
141: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
142: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
143: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
144: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
145: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
146: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
147: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
148: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
141: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
142: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
143: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
144: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
145: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
146: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
147: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
148: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
149: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
142: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
143: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
144: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
145: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
146: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
147: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
148: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
149: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
150: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
143: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
144: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
145: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
146: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
147: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
148: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
149: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
150: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
151: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
144: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
145: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
146: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
147: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
148: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
149: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
150: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
151: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
152: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
145: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
146: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
147: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
148: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
149: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
150: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
151: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
152: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
153: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
146: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
147: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
148: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
149: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
150: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
151: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
152: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
153: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
154: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
147: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
148: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
149: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
150: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
151: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
152: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
153: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
154: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
155: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
148: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
149: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
150: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
151: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
152: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
153: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
154: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
155: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
156: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
149: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
150: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
151: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
152: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
153: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
154: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
155: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
156: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
157: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
150: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
151: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
152: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
153: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
154: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
155: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
156: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
157: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
158: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
151: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
152: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
153: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
154: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
155: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
156: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
157: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
158: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
159: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
152: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
153: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
154: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
155: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
156: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
157: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
158: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
159: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
160: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
153: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
154: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
155: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
156: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
157: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
158: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
159: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
160: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
161: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
154: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
155: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
156: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
157: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
158: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
159: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
160: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
161: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
162: ,p_party_id IN per_all_people_f.party_id%TYPE default null
155: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
156: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
157: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
158: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
159: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
160: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
161: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
162: ,p_party_id IN per_all_people_f.party_id%TYPE default null
163: ,p_fast_path_employee IN per_all_people_f.fast_path_employee%TYPE default null
156: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
157: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
158: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
159: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
160: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
161: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
162: ,p_party_id IN per_all_people_f.party_id%TYPE default null
163: ,p_fast_path_employee IN per_all_people_f.fast_path_employee%TYPE default null
164: ,p_rehire_authorizor IN per_all_people_f.rehire_authorizor%TYPE default null
157: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
158: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
159: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
160: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
161: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
162: ,p_party_id IN per_all_people_f.party_id%TYPE default null
163: ,p_fast_path_employee IN per_all_people_f.fast_path_employee%TYPE default null
164: ,p_rehire_authorizor IN per_all_people_f.rehire_authorizor%TYPE default null
165: ,p_per_object_version_number OUT NOCOPY per_all_people_f.object_version_number%TYPE
158: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
159: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
160: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
161: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
162: ,p_party_id IN per_all_people_f.party_id%TYPE default null
163: ,p_fast_path_employee IN per_all_people_f.fast_path_employee%TYPE default null
164: ,p_rehire_authorizor IN per_all_people_f.rehire_authorizor%TYPE default null
165: ,p_per_object_version_number OUT NOCOPY per_all_people_f.object_version_number%TYPE
166: ,p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
159: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
160: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
161: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
162: ,p_party_id IN per_all_people_f.party_id%TYPE default null
163: ,p_fast_path_employee IN per_all_people_f.fast_path_employee%TYPE default null
164: ,p_rehire_authorizor IN per_all_people_f.rehire_authorizor%TYPE default null
165: ,p_per_object_version_number OUT NOCOPY per_all_people_f.object_version_number%TYPE
166: ,p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
167: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
160: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
161: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
162: ,p_party_id IN per_all_people_f.party_id%TYPE default null
163: ,p_fast_path_employee IN per_all_people_f.fast_path_employee%TYPE default null
164: ,p_rehire_authorizor IN per_all_people_f.rehire_authorizor%TYPE default null
165: ,p_per_object_version_number OUT NOCOPY per_all_people_f.object_version_number%TYPE
166: ,p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
167: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
168: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
161: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
162: ,p_party_id IN per_all_people_f.party_id%TYPE default null
163: ,p_fast_path_employee IN per_all_people_f.fast_path_employee%TYPE default null
164: ,p_rehire_authorizor IN per_all_people_f.rehire_authorizor%TYPE default null
165: ,p_per_object_version_number OUT NOCOPY per_all_people_f.object_version_number%TYPE
166: ,p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
167: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
168: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
169: ,p_asg_validation_start_date OUT NOCOPY DATE
732: PROCEDURE update_maintain_data
733: (p_effective_date IN DATE
734: ,p_datetrack_update_mode IN VARCHAR2
735: ,p_person_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
736: ,p_person_id IN per_all_people_f.person_id%TYPE
737: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
738: ,p_legislation_code IN VARCHAR2
739: ,p_per_effective_start_date IN OUT NOCOPY per_all_people_f.effective_start_date%TYPE
740: ,p_per_effective_end_date IN OUT NOCOPY per_all_people_f.effective_end_date%TYPE
733: (p_effective_date IN DATE
734: ,p_datetrack_update_mode IN VARCHAR2
735: ,p_person_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
736: ,p_person_id IN per_all_people_f.person_id%TYPE
737: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
738: ,p_legislation_code IN VARCHAR2
739: ,p_per_effective_start_date IN OUT NOCOPY per_all_people_f.effective_start_date%TYPE
740: ,p_per_effective_end_date IN OUT NOCOPY per_all_people_f.effective_end_date%TYPE
741: ,p_per_validation_start_date OUT NOCOPY DATE
735: ,p_person_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
736: ,p_person_id IN per_all_people_f.person_id%TYPE
737: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
738: ,p_legislation_code IN VARCHAR2
739: ,p_per_effective_start_date IN OUT NOCOPY per_all_people_f.effective_start_date%TYPE
740: ,p_per_effective_end_date IN OUT NOCOPY per_all_people_f.effective_end_date%TYPE
741: ,p_per_validation_start_date OUT NOCOPY DATE
742: ,p_per_validation_end_date OUT NOCOPY DATE
743: ,p_person_type IN per_person_types.user_person_type%TYPE
736: ,p_person_id IN per_all_people_f.person_id%TYPE
737: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
738: ,p_legislation_code IN VARCHAR2
739: ,p_per_effective_start_date IN OUT NOCOPY per_all_people_f.effective_start_date%TYPE
740: ,p_per_effective_end_date IN OUT NOCOPY per_all_people_f.effective_end_date%TYPE
741: ,p_per_validation_start_date OUT NOCOPY DATE
742: ,p_per_validation_end_date OUT NOCOPY DATE
743: ,p_person_type IN per_person_types.user_person_type%TYPE
744: ,p_system_person_type IN per_person_types.system_person_type%TYPE
741: ,p_per_validation_start_date OUT NOCOPY DATE
742: ,p_per_validation_end_date OUT NOCOPY DATE
743: ,p_person_type IN per_person_types.user_person_type%TYPE
744: ,p_system_person_type IN per_person_types.system_person_type%TYPE
745: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
746: ,p_last_name IN per_all_people_f.last_name%TYPE
747: ,p_start_date IN per_all_people_f.start_date%TYPE
748: ,p_applicant_number IN per_all_people_f.applicant_number%TYPE
749: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
742: ,p_per_validation_end_date OUT NOCOPY DATE
743: ,p_person_type IN per_person_types.user_person_type%TYPE
744: ,p_system_person_type IN per_person_types.system_person_type%TYPE
745: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
746: ,p_last_name IN per_all_people_f.last_name%TYPE
747: ,p_start_date IN per_all_people_f.start_date%TYPE
748: ,p_applicant_number IN per_all_people_f.applicant_number%TYPE
749: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
750: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
743: ,p_person_type IN per_person_types.user_person_type%TYPE
744: ,p_system_person_type IN per_person_types.system_person_type%TYPE
745: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
746: ,p_last_name IN per_all_people_f.last_name%TYPE
747: ,p_start_date IN per_all_people_f.start_date%TYPE
748: ,p_applicant_number IN per_all_people_f.applicant_number%TYPE
749: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
750: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
751: ,p_blood_type IN per_all_people_f.blood_type%TYPE
744: ,p_system_person_type IN per_person_types.system_person_type%TYPE
745: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
746: ,p_last_name IN per_all_people_f.last_name%TYPE
747: ,p_start_date IN per_all_people_f.start_date%TYPE
748: ,p_applicant_number IN per_all_people_f.applicant_number%TYPE
749: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
750: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
751: ,p_blood_type IN per_all_people_f.blood_type%TYPE
752: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
745: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
746: ,p_last_name IN per_all_people_f.last_name%TYPE
747: ,p_start_date IN per_all_people_f.start_date%TYPE
748: ,p_applicant_number IN per_all_people_f.applicant_number%TYPE
749: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
750: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
751: ,p_blood_type IN per_all_people_f.blood_type%TYPE
752: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
753: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
746: ,p_last_name IN per_all_people_f.last_name%TYPE
747: ,p_start_date IN per_all_people_f.start_date%TYPE
748: ,p_applicant_number IN per_all_people_f.applicant_number%TYPE
749: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
750: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
751: ,p_blood_type IN per_all_people_f.blood_type%TYPE
752: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
753: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
754: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
747: ,p_start_date IN per_all_people_f.start_date%TYPE
748: ,p_applicant_number IN per_all_people_f.applicant_number%TYPE
749: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
750: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
751: ,p_blood_type IN per_all_people_f.blood_type%TYPE
752: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
753: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
754: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
755: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
748: ,p_applicant_number IN per_all_people_f.applicant_number%TYPE
749: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
750: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
751: ,p_blood_type IN per_all_people_f.blood_type%TYPE
752: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
753: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
754: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
755: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
756: --CWK
749: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
750: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
751: ,p_blood_type IN per_all_people_f.blood_type%TYPE
752: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
753: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
754: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
755: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
756: --CWK
757: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
750: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
751: ,p_blood_type IN per_all_people_f.blood_type%TYPE
752: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
753: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
754: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
755: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
756: --CWK
757: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
758: ,p_npw_number IN per_all_people_f.npw_number%TYPE
751: ,p_blood_type IN per_all_people_f.blood_type%TYPE
752: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
753: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
754: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
755: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
756: --CWK
757: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
758: ,p_npw_number IN per_all_people_f.npw_number%TYPE
759: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE
753: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
754: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
755: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
756: --CWK
757: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
758: ,p_npw_number IN per_all_people_f.npw_number%TYPE
759: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE
760: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
761: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
754: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
755: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
756: --CWK
757: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
758: ,p_npw_number IN per_all_people_f.npw_number%TYPE
759: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE
760: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
761: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
762: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
773: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
774: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
775: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
776: --
777: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
778: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
779: ,p_email_address IN per_all_people_f.email_address%TYPE
780: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
781: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
774: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
775: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
776: --
777: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
778: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
779: ,p_email_address IN per_all_people_f.email_address%TYPE
780: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
781: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
782: ,p_first_name IN per_all_people_f.first_name%TYPE
775: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
776: --
777: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
778: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
779: ,p_email_address IN per_all_people_f.email_address%TYPE
780: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
781: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
782: ,p_first_name IN per_all_people_f.first_name%TYPE
783: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
776: --
777: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
778: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
779: ,p_email_address IN per_all_people_f.email_address%TYPE
780: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
781: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
782: ,p_first_name IN per_all_people_f.first_name%TYPE
783: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
784: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
777: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
778: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
779: ,p_email_address IN per_all_people_f.email_address%TYPE
780: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
781: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
782: ,p_first_name IN per_all_people_f.first_name%TYPE
783: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
784: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
785: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
778: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
779: ,p_email_address IN per_all_people_f.email_address%TYPE
780: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
781: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
782: ,p_first_name IN per_all_people_f.first_name%TYPE
783: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
784: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
785: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
786: ,p_honors IN per_all_people_f.honors%TYPE
779: ,p_email_address IN per_all_people_f.email_address%TYPE
780: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
781: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
782: ,p_first_name IN per_all_people_f.first_name%TYPE
783: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
784: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
785: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
786: ,p_honors IN per_all_people_f.honors%TYPE
787: ,p_internal_location IN per_all_people_f.internal_location%TYPE
780: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
781: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
782: ,p_first_name IN per_all_people_f.first_name%TYPE
783: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
784: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
785: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
786: ,p_honors IN per_all_people_f.honors%TYPE
787: ,p_internal_location IN per_all_people_f.internal_location%TYPE
788: ,p_known_as IN per_all_people_f.known_as%TYPE
781: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
782: ,p_first_name IN per_all_people_f.first_name%TYPE
783: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
784: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
785: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
786: ,p_honors IN per_all_people_f.honors%TYPE
787: ,p_internal_location IN per_all_people_f.internal_location%TYPE
788: ,p_known_as IN per_all_people_f.known_as%TYPE
789: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
782: ,p_first_name IN per_all_people_f.first_name%TYPE
783: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
784: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
785: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
786: ,p_honors IN per_all_people_f.honors%TYPE
787: ,p_internal_location IN per_all_people_f.internal_location%TYPE
788: ,p_known_as IN per_all_people_f.known_as%TYPE
789: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
790: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
783: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
784: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
785: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
786: ,p_honors IN per_all_people_f.honors%TYPE
787: ,p_internal_location IN per_all_people_f.internal_location%TYPE
788: ,p_known_as IN per_all_people_f.known_as%TYPE
789: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
790: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
791: ,p_mailstop IN per_all_people_f.mailstop%TYPE
784: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
785: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
786: ,p_honors IN per_all_people_f.honors%TYPE
787: ,p_internal_location IN per_all_people_f.internal_location%TYPE
788: ,p_known_as IN per_all_people_f.known_as%TYPE
789: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
790: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
791: ,p_mailstop IN per_all_people_f.mailstop%TYPE
792: ,p_marital_status IN per_all_people_f.marital_status%TYPE
785: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
786: ,p_honors IN per_all_people_f.honors%TYPE
787: ,p_internal_location IN per_all_people_f.internal_location%TYPE
788: ,p_known_as IN per_all_people_f.known_as%TYPE
789: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
790: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
791: ,p_mailstop IN per_all_people_f.mailstop%TYPE
792: ,p_marital_status IN per_all_people_f.marital_status%TYPE
793: ,p_middle_names IN per_all_people_f.middle_names%TYPE
786: ,p_honors IN per_all_people_f.honors%TYPE
787: ,p_internal_location IN per_all_people_f.internal_location%TYPE
788: ,p_known_as IN per_all_people_f.known_as%TYPE
789: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
790: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
791: ,p_mailstop IN per_all_people_f.mailstop%TYPE
792: ,p_marital_status IN per_all_people_f.marital_status%TYPE
793: ,p_middle_names IN per_all_people_f.middle_names%TYPE
794: ,p_nationality IN per_all_people_f.nationality%TYPE
787: ,p_internal_location IN per_all_people_f.internal_location%TYPE
788: ,p_known_as IN per_all_people_f.known_as%TYPE
789: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
790: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
791: ,p_mailstop IN per_all_people_f.mailstop%TYPE
792: ,p_marital_status IN per_all_people_f.marital_status%TYPE
793: ,p_middle_names IN per_all_people_f.middle_names%TYPE
794: ,p_nationality IN per_all_people_f.nationality%TYPE
795: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
788: ,p_known_as IN per_all_people_f.known_as%TYPE
789: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
790: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
791: ,p_mailstop IN per_all_people_f.mailstop%TYPE
792: ,p_marital_status IN per_all_people_f.marital_status%TYPE
793: ,p_middle_names IN per_all_people_f.middle_names%TYPE
794: ,p_nationality IN per_all_people_f.nationality%TYPE
795: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
796: ,p_office_number IN per_all_people_f.office_number%TYPE
789: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
790: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
791: ,p_mailstop IN per_all_people_f.mailstop%TYPE
792: ,p_marital_status IN per_all_people_f.marital_status%TYPE
793: ,p_middle_names IN per_all_people_f.middle_names%TYPE
794: ,p_nationality IN per_all_people_f.nationality%TYPE
795: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
796: ,p_office_number IN per_all_people_f.office_number%TYPE
797: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
790: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
791: ,p_mailstop IN per_all_people_f.mailstop%TYPE
792: ,p_marital_status IN per_all_people_f.marital_status%TYPE
793: ,p_middle_names IN per_all_people_f.middle_names%TYPE
794: ,p_nationality IN per_all_people_f.nationality%TYPE
795: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
796: ,p_office_number IN per_all_people_f.office_number%TYPE
797: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
798: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
791: ,p_mailstop IN per_all_people_f.mailstop%TYPE
792: ,p_marital_status IN per_all_people_f.marital_status%TYPE
793: ,p_middle_names IN per_all_people_f.middle_names%TYPE
794: ,p_nationality IN per_all_people_f.nationality%TYPE
795: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
796: ,p_office_number IN per_all_people_f.office_number%TYPE
797: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
798: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
799: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
792: ,p_marital_status IN per_all_people_f.marital_status%TYPE
793: ,p_middle_names IN per_all_people_f.middle_names%TYPE
794: ,p_nationality IN per_all_people_f.nationality%TYPE
795: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
796: ,p_office_number IN per_all_people_f.office_number%TYPE
797: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
798: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
799: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
800: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
793: ,p_middle_names IN per_all_people_f.middle_names%TYPE
794: ,p_nationality IN per_all_people_f.nationality%TYPE
795: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
796: ,p_office_number IN per_all_people_f.office_number%TYPE
797: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
798: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
799: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
800: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
801: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
794: ,p_nationality IN per_all_people_f.nationality%TYPE
795: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
796: ,p_office_number IN per_all_people_f.office_number%TYPE
797: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
798: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
799: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
800: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
801: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
802: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
795: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
796: ,p_office_number IN per_all_people_f.office_number%TYPE
797: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
798: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
799: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
800: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
801: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
802: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
803: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
796: ,p_office_number IN per_all_people_f.office_number%TYPE
797: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
798: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
799: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
800: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
801: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
802: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
803: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
804: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
797: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
798: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
799: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
800: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
801: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
802: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
803: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
804: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
805: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
798: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
799: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
800: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
801: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
802: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
803: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
804: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
805: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
806: ,p_sex IN per_all_people_f.sex%TYPE
799: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
800: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
801: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
802: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
803: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
804: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
805: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
806: ,p_sex IN per_all_people_f.sex%TYPE
807: ,p_student_status IN per_all_people_f.student_status%TYPE
800: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
801: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
802: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
803: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
804: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
805: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
806: ,p_sex IN per_all_people_f.sex%TYPE
807: ,p_student_status IN per_all_people_f.student_status%TYPE
808: ,p_suffix IN per_all_people_f.suffix%TYPE
801: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
802: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
803: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
804: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
805: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
806: ,p_sex IN per_all_people_f.sex%TYPE
807: ,p_student_status IN per_all_people_f.student_status%TYPE
808: ,p_suffix IN per_all_people_f.suffix%TYPE
809: ,p_title IN per_all_people_f.title%TYPE
802: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
803: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
804: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
805: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
806: ,p_sex IN per_all_people_f.sex%TYPE
807: ,p_student_status IN per_all_people_f.student_status%TYPE
808: ,p_suffix IN per_all_people_f.suffix%TYPE
809: ,p_title IN per_all_people_f.title%TYPE
810: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
803: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
804: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
805: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
806: ,p_sex IN per_all_people_f.sex%TYPE
807: ,p_student_status IN per_all_people_f.student_status%TYPE
808: ,p_suffix IN per_all_people_f.suffix%TYPE
809: ,p_title IN per_all_people_f.title%TYPE
810: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
811: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
804: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
805: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
806: ,p_sex IN per_all_people_f.sex%TYPE
807: ,p_student_status IN per_all_people_f.student_status%TYPE
808: ,p_suffix IN per_all_people_f.suffix%TYPE
809: ,p_title IN per_all_people_f.title%TYPE
810: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
811: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
812: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
805: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
806: ,p_sex IN per_all_people_f.sex%TYPE
807: ,p_student_status IN per_all_people_f.student_status%TYPE
808: ,p_suffix IN per_all_people_f.suffix%TYPE
809: ,p_title IN per_all_people_f.title%TYPE
810: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
811: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
812: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
813: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
806: ,p_sex IN per_all_people_f.sex%TYPE
807: ,p_student_status IN per_all_people_f.student_status%TYPE
808: ,p_suffix IN per_all_people_f.suffix%TYPE
809: ,p_title IN per_all_people_f.title%TYPE
810: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
811: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
812: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
813: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
814: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
807: ,p_student_status IN per_all_people_f.student_status%TYPE
808: ,p_suffix IN per_all_people_f.suffix%TYPE
809: ,p_title IN per_all_people_f.title%TYPE
810: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
811: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
812: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
813: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
814: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
815: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
808: ,p_suffix IN per_all_people_f.suffix%TYPE
809: ,p_title IN per_all_people_f.title%TYPE
810: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
811: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
812: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
813: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
814: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
815: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
816: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
809: ,p_title IN per_all_people_f.title%TYPE
810: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
811: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
812: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
813: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
814: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
815: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
816: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
817: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
810: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
811: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
812: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
813: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
814: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
815: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
816: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
817: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
818: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
811: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
812: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
813: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
814: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
815: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
816: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
817: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
818: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
819: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
812: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
813: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
814: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
815: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
816: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
817: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
818: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
819: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
820: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
813: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
814: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
815: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
816: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
817: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
818: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
819: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
820: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
821: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
814: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
815: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
816: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
817: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
818: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
819: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
820: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
821: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
822: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
815: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
816: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
817: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
818: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
819: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
820: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
821: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
822: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
823: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
816: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
817: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
818: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
819: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
820: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
821: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
822: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
823: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
824: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
817: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
818: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
819: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
820: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
821: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
822: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
823: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
824: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
825: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
818: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
819: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
820: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
821: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
822: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
823: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
824: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
825: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
826: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
819: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
820: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
821: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
822: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
823: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
824: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
825: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
826: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
827: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
820: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
821: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
822: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
823: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
824: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
825: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
826: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
827: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
828: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
821: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
822: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
823: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
824: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
825: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
826: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
827: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
828: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
829: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
822: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
823: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
824: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
825: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
826: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
827: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
828: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
829: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
830: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
823: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
824: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
825: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
826: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
827: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
828: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
829: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
830: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
831: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
824: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
825: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
826: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
827: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
828: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
829: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
830: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
831: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
832: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
825: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
826: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
827: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
828: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
829: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
830: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
831: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
832: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
833: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
826: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
827: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
828: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
829: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
830: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
831: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
832: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
833: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
834: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
827: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
828: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
829: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
830: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
831: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
832: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
833: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
834: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
835: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
828: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
829: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
830: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
831: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
832: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
833: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
834: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
835: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
836: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
829: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
830: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
831: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
832: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
833: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
834: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
835: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
836: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
837: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
830: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
831: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
832: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
833: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
834: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
835: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
836: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
837: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
838: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
831: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
832: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
833: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
834: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
835: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
836: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
837: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
838: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
839: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
832: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
833: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
834: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
835: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
836: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
837: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
838: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
839: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
840: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
833: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
834: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
835: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
836: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
837: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
838: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
839: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
840: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
841: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
834: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
835: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
836: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
837: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
838: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
839: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
840: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
841: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
842: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
835: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
836: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
837: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
838: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
839: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
840: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
841: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
842: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
843: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
836: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
837: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
838: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
839: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
840: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
841: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
842: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
843: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
844: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
837: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
838: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
839: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
840: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
841: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
842: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
843: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
844: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
845: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
838: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
839: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
840: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
841: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
842: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
843: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
844: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
845: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
846: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
839: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
840: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
841: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
842: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
843: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
844: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
845: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
846: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
847: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
840: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
841: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
842: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
843: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
844: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
845: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
846: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
847: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
848: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
841: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
842: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
843: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
844: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
845: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
846: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
847: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
848: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
849: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
842: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
843: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
844: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
845: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
846: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
847: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
848: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
849: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
850: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
843: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
844: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
845: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
846: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
847: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
848: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
849: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
850: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
851: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
844: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
845: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
846: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
847: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
848: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
849: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
850: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
851: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
852: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
845: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
846: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
847: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
848: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
849: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
850: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
851: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
852: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
853: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
846: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
847: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
848: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
849: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
850: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
851: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
852: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
853: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
854: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
847: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
848: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
849: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
850: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
851: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
852: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
853: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
854: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
855: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
848: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
849: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
850: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
851: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
852: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
853: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
854: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
855: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
856: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
849: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
850: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
851: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
852: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
853: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
854: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
855: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
856: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
857: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
850: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
851: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
852: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
853: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
854: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
855: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
856: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
857: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
858: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
851: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
852: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
853: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
854: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
855: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
856: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
857: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
858: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
859: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
852: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
853: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
854: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
855: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
856: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
857: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
858: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
859: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
860: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
853: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
854: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
855: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
856: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
857: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
858: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
859: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
860: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
861: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
854: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
855: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
856: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
857: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
858: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
859: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
860: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
861: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
862: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
855: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
856: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
857: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
858: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
859: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
860: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
861: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
862: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
863: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
856: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
857: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
858: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
859: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
860: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
861: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
862: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
863: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
864: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
857: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
858: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
859: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
860: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
861: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
862: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
863: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
864: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
865: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
858: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
859: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
860: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
861: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
862: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
863: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
864: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
865: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
866: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
859: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
860: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
861: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
862: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
863: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
864: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
865: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
866: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
867: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
860: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
861: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
862: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
863: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
864: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
865: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
866: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
867: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
868: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
861: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
862: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
863: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
864: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
865: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
866: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
867: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
868: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
869: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
862: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
863: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
864: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
865: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
866: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
867: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
868: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
869: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
870: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
863: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
864: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
865: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
866: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
867: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
868: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
869: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
870: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
871: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
864: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
865: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
866: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
867: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
868: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
869: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
870: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
871: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
872: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
865: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
866: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
867: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
868: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
869: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
870: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
871: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
872: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
873: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
866: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
867: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
868: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
869: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
870: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
871: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
872: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
873: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
874: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
867: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
868: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
869: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
870: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
871: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
872: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
873: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
874: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
875: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
868: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
869: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
870: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
871: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
872: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
873: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
874: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
875: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
876: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
869: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
870: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
871: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
872: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
873: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
874: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
875: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
876: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
877: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
870: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
871: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
872: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
873: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
874: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
875: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
876: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
877: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
878: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
871: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
872: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
873: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
874: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
875: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
876: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
877: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
878: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
879: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
872: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
873: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
874: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
875: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
876: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
877: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
878: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
879: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
880: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
873: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
874: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
875: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
876: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
877: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
878: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
879: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
880: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
881: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
874: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
875: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
876: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
877: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
878: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
879: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
880: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
881: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
882: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
875: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
876: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
877: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
878: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
879: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
880: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
881: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
882: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
883: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
876: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
877: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
878: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
879: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
880: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
881: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
882: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
883: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
884: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
877: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
878: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
879: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
880: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
881: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
882: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
883: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
884: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
885: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
878: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
879: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
880: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
881: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
882: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
883: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
884: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
885: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
886: ,p_assignment_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
879: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
880: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
881: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
882: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
883: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
884: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
885: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
886: ,p_assignment_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
887: ,p_assignment_id IN OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
880: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
881: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
882: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
883: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
884: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
885: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
886: ,p_assignment_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
887: ,p_assignment_id IN OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
888: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
881: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
882: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
883: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
884: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
885: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
886: ,p_assignment_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
887: ,p_assignment_id IN OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
888: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
889: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
1453: PROCEDURE lock_maintain_data
1454: (p_effective_date DATE
1455: ,p_datetrack_update_mode VARCHAR2
1456: ,p_person_update_allowed VARCHAR2 DEFAULT 'TRUE'
1457: ,p_person_id per_all_people_f.person_id%TYPE
1458: ,p_per_effective_start_date per_all_people_f.effective_start_date%TYPE
1459: ,p_per_effective_end_date per_all_people_f.effective_end_date%TYPE
1460: ,p_per_validation_start_date OUT NOCOPY DATE
1461: ,p_per_validation_end_date OUT NOCOPY DATE
1454: (p_effective_date DATE
1455: ,p_datetrack_update_mode VARCHAR2
1456: ,p_person_update_allowed VARCHAR2 DEFAULT 'TRUE'
1457: ,p_person_id per_all_people_f.person_id%TYPE
1458: ,p_per_effective_start_date per_all_people_f.effective_start_date%TYPE
1459: ,p_per_effective_end_date per_all_people_f.effective_end_date%TYPE
1460: ,p_per_validation_start_date OUT NOCOPY DATE
1461: ,p_per_validation_end_date OUT NOCOPY DATE
1462: ,p_per_object_version_number per_all_people_f.object_version_number%TYPE
1455: ,p_datetrack_update_mode VARCHAR2
1456: ,p_person_update_allowed VARCHAR2 DEFAULT 'TRUE'
1457: ,p_person_id per_all_people_f.person_id%TYPE
1458: ,p_per_effective_start_date per_all_people_f.effective_start_date%TYPE
1459: ,p_per_effective_end_date per_all_people_f.effective_end_date%TYPE
1460: ,p_per_validation_start_date OUT NOCOPY DATE
1461: ,p_per_validation_end_date OUT NOCOPY DATE
1462: ,p_per_object_version_number per_all_people_f.object_version_number%TYPE
1463: --CWK
1458: ,p_per_effective_start_date per_all_people_f.effective_start_date%TYPE
1459: ,p_per_effective_end_date per_all_people_f.effective_end_date%TYPE
1460: ,p_per_validation_start_date OUT NOCOPY DATE
1461: ,p_per_validation_end_date OUT NOCOPY DATE
1462: ,p_per_object_version_number per_all_people_f.object_version_number%TYPE
1463: --CWK
1464: ,p_placement_date_start per_periods_of_placement.date_start%TYPE
1465: ,p_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE
1466: ,p_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE