46: -- default is false. The validation is controlled by a savepoint and
47: -- rollback mechanism. The savepoint is issued at the beginning of the
48: -- business process and is rollbacked at the end of the business process
49: -- when all the processing has been completed. The rollback is controlled
50: -- by raising and handling the exception hr_api.validate_enabled. We use
51: -- the exception because, by raising the exception with the business
52: -- process, we can exit successfully without having any of the 'OUT'
53: -- arguments being set.
54: --
129: -- ----------------------------------------------------------------------------
130: Procedure upd
131: (
132: p_period_of_service_id in number,
133: p_termination_accepted_person in number default hr_api.g_number,
134: p_date_start in date default hr_api.g_date,
135: p_accepted_termination_date in date default hr_api.g_date,
136: p_actual_termination_date in date default hr_api.g_date,
137: p_comments in varchar2 default hr_api.g_varchar2,
130: Procedure upd
131: (
132: p_period_of_service_id in number,
133: p_termination_accepted_person in number default hr_api.g_number,
134: p_date_start in date default hr_api.g_date,
135: p_accepted_termination_date in date default hr_api.g_date,
136: p_actual_termination_date in date default hr_api.g_date,
137: p_comments in varchar2 default hr_api.g_varchar2,
138: p_final_process_date in date default hr_api.g_date,
131: (
132: p_period_of_service_id in number,
133: p_termination_accepted_person in number default hr_api.g_number,
134: p_date_start in date default hr_api.g_date,
135: p_accepted_termination_date in date default hr_api.g_date,
136: p_actual_termination_date in date default hr_api.g_date,
137: p_comments in varchar2 default hr_api.g_varchar2,
138: p_final_process_date in date default hr_api.g_date,
139: p_last_standard_process_date in date default hr_api.g_date,
132: p_period_of_service_id in number,
133: p_termination_accepted_person in number default hr_api.g_number,
134: p_date_start in date default hr_api.g_date,
135: p_accepted_termination_date in date default hr_api.g_date,
136: p_actual_termination_date in date default hr_api.g_date,
137: p_comments in varchar2 default hr_api.g_varchar2,
138: p_final_process_date in date default hr_api.g_date,
139: p_last_standard_process_date in date default hr_api.g_date,
140: p_leaving_reason in varchar2 default hr_api.g_varchar2,
133: p_termination_accepted_person in number default hr_api.g_number,
134: p_date_start in date default hr_api.g_date,
135: p_accepted_termination_date in date default hr_api.g_date,
136: p_actual_termination_date in date default hr_api.g_date,
137: p_comments in varchar2 default hr_api.g_varchar2,
138: p_final_process_date in date default hr_api.g_date,
139: p_last_standard_process_date in date default hr_api.g_date,
140: p_leaving_reason in varchar2 default hr_api.g_varchar2,
141: p_notified_termination_date in date default hr_api.g_date,
134: p_date_start in date default hr_api.g_date,
135: p_accepted_termination_date in date default hr_api.g_date,
136: p_actual_termination_date in date default hr_api.g_date,
137: p_comments in varchar2 default hr_api.g_varchar2,
138: p_final_process_date in date default hr_api.g_date,
139: p_last_standard_process_date in date default hr_api.g_date,
140: p_leaving_reason in varchar2 default hr_api.g_varchar2,
141: p_notified_termination_date in date default hr_api.g_date,
142: p_projected_termination_date in date default hr_api.g_date,
135: p_accepted_termination_date in date default hr_api.g_date,
136: p_actual_termination_date in date default hr_api.g_date,
137: p_comments in varchar2 default hr_api.g_varchar2,
138: p_final_process_date in date default hr_api.g_date,
139: p_last_standard_process_date in date default hr_api.g_date,
140: p_leaving_reason in varchar2 default hr_api.g_varchar2,
141: p_notified_termination_date in date default hr_api.g_date,
142: p_projected_termination_date in date default hr_api.g_date,
143: p_adjusted_svc_date in date default hr_api.g_date,
136: p_actual_termination_date in date default hr_api.g_date,
137: p_comments in varchar2 default hr_api.g_varchar2,
138: p_final_process_date in date default hr_api.g_date,
139: p_last_standard_process_date in date default hr_api.g_date,
140: p_leaving_reason in varchar2 default hr_api.g_varchar2,
141: p_notified_termination_date in date default hr_api.g_date,
142: p_projected_termination_date in date default hr_api.g_date,
143: p_adjusted_svc_date in date default hr_api.g_date,
144: p_request_id in number default hr_api.g_number,
137: p_comments in varchar2 default hr_api.g_varchar2,
138: p_final_process_date in date default hr_api.g_date,
139: p_last_standard_process_date in date default hr_api.g_date,
140: p_leaving_reason in varchar2 default hr_api.g_varchar2,
141: p_notified_termination_date in date default hr_api.g_date,
142: p_projected_termination_date in date default hr_api.g_date,
143: p_adjusted_svc_date in date default hr_api.g_date,
144: p_request_id in number default hr_api.g_number,
145: p_program_application_id in number default hr_api.g_number,
138: p_final_process_date in date default hr_api.g_date,
139: p_last_standard_process_date in date default hr_api.g_date,
140: p_leaving_reason in varchar2 default hr_api.g_varchar2,
141: p_notified_termination_date in date default hr_api.g_date,
142: p_projected_termination_date in date default hr_api.g_date,
143: p_adjusted_svc_date in date default hr_api.g_date,
144: p_request_id in number default hr_api.g_number,
145: p_program_application_id in number default hr_api.g_number,
146: p_program_id in number default hr_api.g_number,
139: p_last_standard_process_date in date default hr_api.g_date,
140: p_leaving_reason in varchar2 default hr_api.g_varchar2,
141: p_notified_termination_date in date default hr_api.g_date,
142: p_projected_termination_date in date default hr_api.g_date,
143: p_adjusted_svc_date in date default hr_api.g_date,
144: p_request_id in number default hr_api.g_number,
145: p_program_application_id in number default hr_api.g_number,
146: p_program_id in number default hr_api.g_number,
147: p_program_update_date in date default hr_api.g_date,
140: p_leaving_reason in varchar2 default hr_api.g_varchar2,
141: p_notified_termination_date in date default hr_api.g_date,
142: p_projected_termination_date in date default hr_api.g_date,
143: p_adjusted_svc_date in date default hr_api.g_date,
144: p_request_id in number default hr_api.g_number,
145: p_program_application_id in number default hr_api.g_number,
146: p_program_id in number default hr_api.g_number,
147: p_program_update_date in date default hr_api.g_date,
148: p_attribute_category in varchar2 default hr_api.g_varchar2,
141: p_notified_termination_date in date default hr_api.g_date,
142: p_projected_termination_date in date default hr_api.g_date,
143: p_adjusted_svc_date in date default hr_api.g_date,
144: p_request_id in number default hr_api.g_number,
145: p_program_application_id in number default hr_api.g_number,
146: p_program_id in number default hr_api.g_number,
147: p_program_update_date in date default hr_api.g_date,
148: p_attribute_category in varchar2 default hr_api.g_varchar2,
149: p_attribute1 in varchar2 default hr_api.g_varchar2,
142: p_projected_termination_date in date default hr_api.g_date,
143: p_adjusted_svc_date in date default hr_api.g_date,
144: p_request_id in number default hr_api.g_number,
145: p_program_application_id in number default hr_api.g_number,
146: p_program_id in number default hr_api.g_number,
147: p_program_update_date in date default hr_api.g_date,
148: p_attribute_category in varchar2 default hr_api.g_varchar2,
149: p_attribute1 in varchar2 default hr_api.g_varchar2,
150: p_attribute2 in varchar2 default hr_api.g_varchar2,
143: p_adjusted_svc_date in date default hr_api.g_date,
144: p_request_id in number default hr_api.g_number,
145: p_program_application_id in number default hr_api.g_number,
146: p_program_id in number default hr_api.g_number,
147: p_program_update_date in date default hr_api.g_date,
148: p_attribute_category in varchar2 default hr_api.g_varchar2,
149: p_attribute1 in varchar2 default hr_api.g_varchar2,
150: p_attribute2 in varchar2 default hr_api.g_varchar2,
151: p_attribute3 in varchar2 default hr_api.g_varchar2,
144: p_request_id in number default hr_api.g_number,
145: p_program_application_id in number default hr_api.g_number,
146: p_program_id in number default hr_api.g_number,
147: p_program_update_date in date default hr_api.g_date,
148: p_attribute_category in varchar2 default hr_api.g_varchar2,
149: p_attribute1 in varchar2 default hr_api.g_varchar2,
150: p_attribute2 in varchar2 default hr_api.g_varchar2,
151: p_attribute3 in varchar2 default hr_api.g_varchar2,
152: p_attribute4 in varchar2 default hr_api.g_varchar2,
145: p_program_application_id in number default hr_api.g_number,
146: p_program_id in number default hr_api.g_number,
147: p_program_update_date in date default hr_api.g_date,
148: p_attribute_category in varchar2 default hr_api.g_varchar2,
149: p_attribute1 in varchar2 default hr_api.g_varchar2,
150: p_attribute2 in varchar2 default hr_api.g_varchar2,
151: p_attribute3 in varchar2 default hr_api.g_varchar2,
152: p_attribute4 in varchar2 default hr_api.g_varchar2,
153: p_attribute5 in varchar2 default hr_api.g_varchar2,
146: p_program_id in number default hr_api.g_number,
147: p_program_update_date in date default hr_api.g_date,
148: p_attribute_category in varchar2 default hr_api.g_varchar2,
149: p_attribute1 in varchar2 default hr_api.g_varchar2,
150: p_attribute2 in varchar2 default hr_api.g_varchar2,
151: p_attribute3 in varchar2 default hr_api.g_varchar2,
152: p_attribute4 in varchar2 default hr_api.g_varchar2,
153: p_attribute5 in varchar2 default hr_api.g_varchar2,
154: p_attribute6 in varchar2 default hr_api.g_varchar2,
147: p_program_update_date in date default hr_api.g_date,
148: p_attribute_category in varchar2 default hr_api.g_varchar2,
149: p_attribute1 in varchar2 default hr_api.g_varchar2,
150: p_attribute2 in varchar2 default hr_api.g_varchar2,
151: p_attribute3 in varchar2 default hr_api.g_varchar2,
152: p_attribute4 in varchar2 default hr_api.g_varchar2,
153: p_attribute5 in varchar2 default hr_api.g_varchar2,
154: p_attribute6 in varchar2 default hr_api.g_varchar2,
155: p_attribute7 in varchar2 default hr_api.g_varchar2,
148: p_attribute_category in varchar2 default hr_api.g_varchar2,
149: p_attribute1 in varchar2 default hr_api.g_varchar2,
150: p_attribute2 in varchar2 default hr_api.g_varchar2,
151: p_attribute3 in varchar2 default hr_api.g_varchar2,
152: p_attribute4 in varchar2 default hr_api.g_varchar2,
153: p_attribute5 in varchar2 default hr_api.g_varchar2,
154: p_attribute6 in varchar2 default hr_api.g_varchar2,
155: p_attribute7 in varchar2 default hr_api.g_varchar2,
156: p_attribute8 in varchar2 default hr_api.g_varchar2,
149: p_attribute1 in varchar2 default hr_api.g_varchar2,
150: p_attribute2 in varchar2 default hr_api.g_varchar2,
151: p_attribute3 in varchar2 default hr_api.g_varchar2,
152: p_attribute4 in varchar2 default hr_api.g_varchar2,
153: p_attribute5 in varchar2 default hr_api.g_varchar2,
154: p_attribute6 in varchar2 default hr_api.g_varchar2,
155: p_attribute7 in varchar2 default hr_api.g_varchar2,
156: p_attribute8 in varchar2 default hr_api.g_varchar2,
157: p_attribute9 in varchar2 default hr_api.g_varchar2,
150: p_attribute2 in varchar2 default hr_api.g_varchar2,
151: p_attribute3 in varchar2 default hr_api.g_varchar2,
152: p_attribute4 in varchar2 default hr_api.g_varchar2,
153: p_attribute5 in varchar2 default hr_api.g_varchar2,
154: p_attribute6 in varchar2 default hr_api.g_varchar2,
155: p_attribute7 in varchar2 default hr_api.g_varchar2,
156: p_attribute8 in varchar2 default hr_api.g_varchar2,
157: p_attribute9 in varchar2 default hr_api.g_varchar2,
158: p_attribute10 in varchar2 default hr_api.g_varchar2,
151: p_attribute3 in varchar2 default hr_api.g_varchar2,
152: p_attribute4 in varchar2 default hr_api.g_varchar2,
153: p_attribute5 in varchar2 default hr_api.g_varchar2,
154: p_attribute6 in varchar2 default hr_api.g_varchar2,
155: p_attribute7 in varchar2 default hr_api.g_varchar2,
156: p_attribute8 in varchar2 default hr_api.g_varchar2,
157: p_attribute9 in varchar2 default hr_api.g_varchar2,
158: p_attribute10 in varchar2 default hr_api.g_varchar2,
159: p_attribute11 in varchar2 default hr_api.g_varchar2,
152: p_attribute4 in varchar2 default hr_api.g_varchar2,
153: p_attribute5 in varchar2 default hr_api.g_varchar2,
154: p_attribute6 in varchar2 default hr_api.g_varchar2,
155: p_attribute7 in varchar2 default hr_api.g_varchar2,
156: p_attribute8 in varchar2 default hr_api.g_varchar2,
157: p_attribute9 in varchar2 default hr_api.g_varchar2,
158: p_attribute10 in varchar2 default hr_api.g_varchar2,
159: p_attribute11 in varchar2 default hr_api.g_varchar2,
160: p_attribute12 in varchar2 default hr_api.g_varchar2,
153: p_attribute5 in varchar2 default hr_api.g_varchar2,
154: p_attribute6 in varchar2 default hr_api.g_varchar2,
155: p_attribute7 in varchar2 default hr_api.g_varchar2,
156: p_attribute8 in varchar2 default hr_api.g_varchar2,
157: p_attribute9 in varchar2 default hr_api.g_varchar2,
158: p_attribute10 in varchar2 default hr_api.g_varchar2,
159: p_attribute11 in varchar2 default hr_api.g_varchar2,
160: p_attribute12 in varchar2 default hr_api.g_varchar2,
161: p_attribute13 in varchar2 default hr_api.g_varchar2,
154: p_attribute6 in varchar2 default hr_api.g_varchar2,
155: p_attribute7 in varchar2 default hr_api.g_varchar2,
156: p_attribute8 in varchar2 default hr_api.g_varchar2,
157: p_attribute9 in varchar2 default hr_api.g_varchar2,
158: p_attribute10 in varchar2 default hr_api.g_varchar2,
159: p_attribute11 in varchar2 default hr_api.g_varchar2,
160: p_attribute12 in varchar2 default hr_api.g_varchar2,
161: p_attribute13 in varchar2 default hr_api.g_varchar2,
162: p_attribute14 in varchar2 default hr_api.g_varchar2,
155: p_attribute7 in varchar2 default hr_api.g_varchar2,
156: p_attribute8 in varchar2 default hr_api.g_varchar2,
157: p_attribute9 in varchar2 default hr_api.g_varchar2,
158: p_attribute10 in varchar2 default hr_api.g_varchar2,
159: p_attribute11 in varchar2 default hr_api.g_varchar2,
160: p_attribute12 in varchar2 default hr_api.g_varchar2,
161: p_attribute13 in varchar2 default hr_api.g_varchar2,
162: p_attribute14 in varchar2 default hr_api.g_varchar2,
163: p_attribute15 in varchar2 default hr_api.g_varchar2,
156: p_attribute8 in varchar2 default hr_api.g_varchar2,
157: p_attribute9 in varchar2 default hr_api.g_varchar2,
158: p_attribute10 in varchar2 default hr_api.g_varchar2,
159: p_attribute11 in varchar2 default hr_api.g_varchar2,
160: p_attribute12 in varchar2 default hr_api.g_varchar2,
161: p_attribute13 in varchar2 default hr_api.g_varchar2,
162: p_attribute14 in varchar2 default hr_api.g_varchar2,
163: p_attribute15 in varchar2 default hr_api.g_varchar2,
164: p_attribute16 in varchar2 default hr_api.g_varchar2,
157: p_attribute9 in varchar2 default hr_api.g_varchar2,
158: p_attribute10 in varchar2 default hr_api.g_varchar2,
159: p_attribute11 in varchar2 default hr_api.g_varchar2,
160: p_attribute12 in varchar2 default hr_api.g_varchar2,
161: p_attribute13 in varchar2 default hr_api.g_varchar2,
162: p_attribute14 in varchar2 default hr_api.g_varchar2,
163: p_attribute15 in varchar2 default hr_api.g_varchar2,
164: p_attribute16 in varchar2 default hr_api.g_varchar2,
165: p_attribute17 in varchar2 default hr_api.g_varchar2,
158: p_attribute10 in varchar2 default hr_api.g_varchar2,
159: p_attribute11 in varchar2 default hr_api.g_varchar2,
160: p_attribute12 in varchar2 default hr_api.g_varchar2,
161: p_attribute13 in varchar2 default hr_api.g_varchar2,
162: p_attribute14 in varchar2 default hr_api.g_varchar2,
163: p_attribute15 in varchar2 default hr_api.g_varchar2,
164: p_attribute16 in varchar2 default hr_api.g_varchar2,
165: p_attribute17 in varchar2 default hr_api.g_varchar2,
166: p_attribute18 in varchar2 default hr_api.g_varchar2,
159: p_attribute11 in varchar2 default hr_api.g_varchar2,
160: p_attribute12 in varchar2 default hr_api.g_varchar2,
161: p_attribute13 in varchar2 default hr_api.g_varchar2,
162: p_attribute14 in varchar2 default hr_api.g_varchar2,
163: p_attribute15 in varchar2 default hr_api.g_varchar2,
164: p_attribute16 in varchar2 default hr_api.g_varchar2,
165: p_attribute17 in varchar2 default hr_api.g_varchar2,
166: p_attribute18 in varchar2 default hr_api.g_varchar2,
167: p_attribute19 in varchar2 default hr_api.g_varchar2,
160: p_attribute12 in varchar2 default hr_api.g_varchar2,
161: p_attribute13 in varchar2 default hr_api.g_varchar2,
162: p_attribute14 in varchar2 default hr_api.g_varchar2,
163: p_attribute15 in varchar2 default hr_api.g_varchar2,
164: p_attribute16 in varchar2 default hr_api.g_varchar2,
165: p_attribute17 in varchar2 default hr_api.g_varchar2,
166: p_attribute18 in varchar2 default hr_api.g_varchar2,
167: p_attribute19 in varchar2 default hr_api.g_varchar2,
168: p_attribute20 in varchar2 default hr_api.g_varchar2,
161: p_attribute13 in varchar2 default hr_api.g_varchar2,
162: p_attribute14 in varchar2 default hr_api.g_varchar2,
163: p_attribute15 in varchar2 default hr_api.g_varchar2,
164: p_attribute16 in varchar2 default hr_api.g_varchar2,
165: p_attribute17 in varchar2 default hr_api.g_varchar2,
166: p_attribute18 in varchar2 default hr_api.g_varchar2,
167: p_attribute19 in varchar2 default hr_api.g_varchar2,
168: p_attribute20 in varchar2 default hr_api.g_varchar2,
169: p_object_version_number in out nocopy number,
162: p_attribute14 in varchar2 default hr_api.g_varchar2,
163: p_attribute15 in varchar2 default hr_api.g_varchar2,
164: p_attribute16 in varchar2 default hr_api.g_varchar2,
165: p_attribute17 in varchar2 default hr_api.g_varchar2,
166: p_attribute18 in varchar2 default hr_api.g_varchar2,
167: p_attribute19 in varchar2 default hr_api.g_varchar2,
168: p_attribute20 in varchar2 default hr_api.g_varchar2,
169: p_object_version_number in out nocopy number,
170: p_prior_employment_ssp_weeks in number default hr_api.g_number,
163: p_attribute15 in varchar2 default hr_api.g_varchar2,
164: p_attribute16 in varchar2 default hr_api.g_varchar2,
165: p_attribute17 in varchar2 default hr_api.g_varchar2,
166: p_attribute18 in varchar2 default hr_api.g_varchar2,
167: p_attribute19 in varchar2 default hr_api.g_varchar2,
168: p_attribute20 in varchar2 default hr_api.g_varchar2,
169: p_object_version_number in out nocopy number,
170: p_prior_employment_ssp_weeks in number default hr_api.g_number,
171: p_prior_employment_ssp_paid_to in date default hr_api.g_date,
164: p_attribute16 in varchar2 default hr_api.g_varchar2,
165: p_attribute17 in varchar2 default hr_api.g_varchar2,
166: p_attribute18 in varchar2 default hr_api.g_varchar2,
167: p_attribute19 in varchar2 default hr_api.g_varchar2,
168: p_attribute20 in varchar2 default hr_api.g_varchar2,
169: p_object_version_number in out nocopy number,
170: p_prior_employment_ssp_weeks in number default hr_api.g_number,
171: p_prior_employment_ssp_paid_to in date default hr_api.g_date,
172: p_pds_information_category in varchar2 default hr_api.g_varchar2,
166: p_attribute18 in varchar2 default hr_api.g_varchar2,
167: p_attribute19 in varchar2 default hr_api.g_varchar2,
168: p_attribute20 in varchar2 default hr_api.g_varchar2,
169: p_object_version_number in out nocopy number,
170: p_prior_employment_ssp_weeks in number default hr_api.g_number,
171: p_prior_employment_ssp_paid_to in date default hr_api.g_date,
172: p_pds_information_category in varchar2 default hr_api.g_varchar2,
173: p_pds_information1 in varchar2 default hr_api.g_varchar2,
174: p_pds_information2 in varchar2 default hr_api.g_varchar2,
167: p_attribute19 in varchar2 default hr_api.g_varchar2,
168: p_attribute20 in varchar2 default hr_api.g_varchar2,
169: p_object_version_number in out nocopy number,
170: p_prior_employment_ssp_weeks in number default hr_api.g_number,
171: p_prior_employment_ssp_paid_to in date default hr_api.g_date,
172: p_pds_information_category in varchar2 default hr_api.g_varchar2,
173: p_pds_information1 in varchar2 default hr_api.g_varchar2,
174: p_pds_information2 in varchar2 default hr_api.g_varchar2,
175: p_pds_information3 in varchar2 default hr_api.g_varchar2,
168: p_attribute20 in varchar2 default hr_api.g_varchar2,
169: p_object_version_number in out nocopy number,
170: p_prior_employment_ssp_weeks in number default hr_api.g_number,
171: p_prior_employment_ssp_paid_to in date default hr_api.g_date,
172: p_pds_information_category in varchar2 default hr_api.g_varchar2,
173: p_pds_information1 in varchar2 default hr_api.g_varchar2,
174: p_pds_information2 in varchar2 default hr_api.g_varchar2,
175: p_pds_information3 in varchar2 default hr_api.g_varchar2,
176: p_pds_information4 in varchar2 default hr_api.g_varchar2,
169: p_object_version_number in out nocopy number,
170: p_prior_employment_ssp_weeks in number default hr_api.g_number,
171: p_prior_employment_ssp_paid_to in date default hr_api.g_date,
172: p_pds_information_category in varchar2 default hr_api.g_varchar2,
173: p_pds_information1 in varchar2 default hr_api.g_varchar2,
174: p_pds_information2 in varchar2 default hr_api.g_varchar2,
175: p_pds_information3 in varchar2 default hr_api.g_varchar2,
176: p_pds_information4 in varchar2 default hr_api.g_varchar2,
177: p_pds_information5 in varchar2 default hr_api.g_varchar2,
170: p_prior_employment_ssp_weeks in number default hr_api.g_number,
171: p_prior_employment_ssp_paid_to in date default hr_api.g_date,
172: p_pds_information_category in varchar2 default hr_api.g_varchar2,
173: p_pds_information1 in varchar2 default hr_api.g_varchar2,
174: p_pds_information2 in varchar2 default hr_api.g_varchar2,
175: p_pds_information3 in varchar2 default hr_api.g_varchar2,
176: p_pds_information4 in varchar2 default hr_api.g_varchar2,
177: p_pds_information5 in varchar2 default hr_api.g_varchar2,
178: p_pds_information6 in varchar2 default hr_api.g_varchar2,
171: p_prior_employment_ssp_paid_to in date default hr_api.g_date,
172: p_pds_information_category in varchar2 default hr_api.g_varchar2,
173: p_pds_information1 in varchar2 default hr_api.g_varchar2,
174: p_pds_information2 in varchar2 default hr_api.g_varchar2,
175: p_pds_information3 in varchar2 default hr_api.g_varchar2,
176: p_pds_information4 in varchar2 default hr_api.g_varchar2,
177: p_pds_information5 in varchar2 default hr_api.g_varchar2,
178: p_pds_information6 in varchar2 default hr_api.g_varchar2,
179: p_pds_information7 in varchar2 default hr_api.g_varchar2,
172: p_pds_information_category in varchar2 default hr_api.g_varchar2,
173: p_pds_information1 in varchar2 default hr_api.g_varchar2,
174: p_pds_information2 in varchar2 default hr_api.g_varchar2,
175: p_pds_information3 in varchar2 default hr_api.g_varchar2,
176: p_pds_information4 in varchar2 default hr_api.g_varchar2,
177: p_pds_information5 in varchar2 default hr_api.g_varchar2,
178: p_pds_information6 in varchar2 default hr_api.g_varchar2,
179: p_pds_information7 in varchar2 default hr_api.g_varchar2,
180: p_pds_information8 in varchar2 default hr_api.g_varchar2,
173: p_pds_information1 in varchar2 default hr_api.g_varchar2,
174: p_pds_information2 in varchar2 default hr_api.g_varchar2,
175: p_pds_information3 in varchar2 default hr_api.g_varchar2,
176: p_pds_information4 in varchar2 default hr_api.g_varchar2,
177: p_pds_information5 in varchar2 default hr_api.g_varchar2,
178: p_pds_information6 in varchar2 default hr_api.g_varchar2,
179: p_pds_information7 in varchar2 default hr_api.g_varchar2,
180: p_pds_information8 in varchar2 default hr_api.g_varchar2,
181: p_pds_information9 in varchar2 default hr_api.g_varchar2,
174: p_pds_information2 in varchar2 default hr_api.g_varchar2,
175: p_pds_information3 in varchar2 default hr_api.g_varchar2,
176: p_pds_information4 in varchar2 default hr_api.g_varchar2,
177: p_pds_information5 in varchar2 default hr_api.g_varchar2,
178: p_pds_information6 in varchar2 default hr_api.g_varchar2,
179: p_pds_information7 in varchar2 default hr_api.g_varchar2,
180: p_pds_information8 in varchar2 default hr_api.g_varchar2,
181: p_pds_information9 in varchar2 default hr_api.g_varchar2,
182: p_pds_information10 in varchar2 default hr_api.g_varchar2,
175: p_pds_information3 in varchar2 default hr_api.g_varchar2,
176: p_pds_information4 in varchar2 default hr_api.g_varchar2,
177: p_pds_information5 in varchar2 default hr_api.g_varchar2,
178: p_pds_information6 in varchar2 default hr_api.g_varchar2,
179: p_pds_information7 in varchar2 default hr_api.g_varchar2,
180: p_pds_information8 in varchar2 default hr_api.g_varchar2,
181: p_pds_information9 in varchar2 default hr_api.g_varchar2,
182: p_pds_information10 in varchar2 default hr_api.g_varchar2,
183: p_pds_information11 in varchar2 default hr_api.g_varchar2,
176: p_pds_information4 in varchar2 default hr_api.g_varchar2,
177: p_pds_information5 in varchar2 default hr_api.g_varchar2,
178: p_pds_information6 in varchar2 default hr_api.g_varchar2,
179: p_pds_information7 in varchar2 default hr_api.g_varchar2,
180: p_pds_information8 in varchar2 default hr_api.g_varchar2,
181: p_pds_information9 in varchar2 default hr_api.g_varchar2,
182: p_pds_information10 in varchar2 default hr_api.g_varchar2,
183: p_pds_information11 in varchar2 default hr_api.g_varchar2,
184: p_pds_information12 in varchar2 default hr_api.g_varchar2,
177: p_pds_information5 in varchar2 default hr_api.g_varchar2,
178: p_pds_information6 in varchar2 default hr_api.g_varchar2,
179: p_pds_information7 in varchar2 default hr_api.g_varchar2,
180: p_pds_information8 in varchar2 default hr_api.g_varchar2,
181: p_pds_information9 in varchar2 default hr_api.g_varchar2,
182: p_pds_information10 in varchar2 default hr_api.g_varchar2,
183: p_pds_information11 in varchar2 default hr_api.g_varchar2,
184: p_pds_information12 in varchar2 default hr_api.g_varchar2,
185: p_pds_information13 in varchar2 default hr_api.g_varchar2,
178: p_pds_information6 in varchar2 default hr_api.g_varchar2,
179: p_pds_information7 in varchar2 default hr_api.g_varchar2,
180: p_pds_information8 in varchar2 default hr_api.g_varchar2,
181: p_pds_information9 in varchar2 default hr_api.g_varchar2,
182: p_pds_information10 in varchar2 default hr_api.g_varchar2,
183: p_pds_information11 in varchar2 default hr_api.g_varchar2,
184: p_pds_information12 in varchar2 default hr_api.g_varchar2,
185: p_pds_information13 in varchar2 default hr_api.g_varchar2,
186: p_pds_information14 in varchar2 default hr_api.g_varchar2,
179: p_pds_information7 in varchar2 default hr_api.g_varchar2,
180: p_pds_information8 in varchar2 default hr_api.g_varchar2,
181: p_pds_information9 in varchar2 default hr_api.g_varchar2,
182: p_pds_information10 in varchar2 default hr_api.g_varchar2,
183: p_pds_information11 in varchar2 default hr_api.g_varchar2,
184: p_pds_information12 in varchar2 default hr_api.g_varchar2,
185: p_pds_information13 in varchar2 default hr_api.g_varchar2,
186: p_pds_information14 in varchar2 default hr_api.g_varchar2,
187: p_pds_information15 in varchar2 default hr_api.g_varchar2,
180: p_pds_information8 in varchar2 default hr_api.g_varchar2,
181: p_pds_information9 in varchar2 default hr_api.g_varchar2,
182: p_pds_information10 in varchar2 default hr_api.g_varchar2,
183: p_pds_information11 in varchar2 default hr_api.g_varchar2,
184: p_pds_information12 in varchar2 default hr_api.g_varchar2,
185: p_pds_information13 in varchar2 default hr_api.g_varchar2,
186: p_pds_information14 in varchar2 default hr_api.g_varchar2,
187: p_pds_information15 in varchar2 default hr_api.g_varchar2,
188: p_pds_information16 in varchar2 default hr_api.g_varchar2,
181: p_pds_information9 in varchar2 default hr_api.g_varchar2,
182: p_pds_information10 in varchar2 default hr_api.g_varchar2,
183: p_pds_information11 in varchar2 default hr_api.g_varchar2,
184: p_pds_information12 in varchar2 default hr_api.g_varchar2,
185: p_pds_information13 in varchar2 default hr_api.g_varchar2,
186: p_pds_information14 in varchar2 default hr_api.g_varchar2,
187: p_pds_information15 in varchar2 default hr_api.g_varchar2,
188: p_pds_information16 in varchar2 default hr_api.g_varchar2,
189: p_pds_information17 in varchar2 default hr_api.g_varchar2,
182: p_pds_information10 in varchar2 default hr_api.g_varchar2,
183: p_pds_information11 in varchar2 default hr_api.g_varchar2,
184: p_pds_information12 in varchar2 default hr_api.g_varchar2,
185: p_pds_information13 in varchar2 default hr_api.g_varchar2,
186: p_pds_information14 in varchar2 default hr_api.g_varchar2,
187: p_pds_information15 in varchar2 default hr_api.g_varchar2,
188: p_pds_information16 in varchar2 default hr_api.g_varchar2,
189: p_pds_information17 in varchar2 default hr_api.g_varchar2,
190: p_pds_information18 in varchar2 default hr_api.g_varchar2,
183: p_pds_information11 in varchar2 default hr_api.g_varchar2,
184: p_pds_information12 in varchar2 default hr_api.g_varchar2,
185: p_pds_information13 in varchar2 default hr_api.g_varchar2,
186: p_pds_information14 in varchar2 default hr_api.g_varchar2,
187: p_pds_information15 in varchar2 default hr_api.g_varchar2,
188: p_pds_information16 in varchar2 default hr_api.g_varchar2,
189: p_pds_information17 in varchar2 default hr_api.g_varchar2,
190: p_pds_information18 in varchar2 default hr_api.g_varchar2,
191: p_pds_information19 in varchar2 default hr_api.g_varchar2,
184: p_pds_information12 in varchar2 default hr_api.g_varchar2,
185: p_pds_information13 in varchar2 default hr_api.g_varchar2,
186: p_pds_information14 in varchar2 default hr_api.g_varchar2,
187: p_pds_information15 in varchar2 default hr_api.g_varchar2,
188: p_pds_information16 in varchar2 default hr_api.g_varchar2,
189: p_pds_information17 in varchar2 default hr_api.g_varchar2,
190: p_pds_information18 in varchar2 default hr_api.g_varchar2,
191: p_pds_information19 in varchar2 default hr_api.g_varchar2,
192: p_pds_information20 in varchar2 default hr_api.g_varchar2,
185: p_pds_information13 in varchar2 default hr_api.g_varchar2,
186: p_pds_information14 in varchar2 default hr_api.g_varchar2,
187: p_pds_information15 in varchar2 default hr_api.g_varchar2,
188: p_pds_information16 in varchar2 default hr_api.g_varchar2,
189: p_pds_information17 in varchar2 default hr_api.g_varchar2,
190: p_pds_information18 in varchar2 default hr_api.g_varchar2,
191: p_pds_information19 in varchar2 default hr_api.g_varchar2,
192: p_pds_information20 in varchar2 default hr_api.g_varchar2,
193: p_pds_information21 in varchar2 default hr_api.g_varchar2,
186: p_pds_information14 in varchar2 default hr_api.g_varchar2,
187: p_pds_information15 in varchar2 default hr_api.g_varchar2,
188: p_pds_information16 in varchar2 default hr_api.g_varchar2,
189: p_pds_information17 in varchar2 default hr_api.g_varchar2,
190: p_pds_information18 in varchar2 default hr_api.g_varchar2,
191: p_pds_information19 in varchar2 default hr_api.g_varchar2,
192: p_pds_information20 in varchar2 default hr_api.g_varchar2,
193: p_pds_information21 in varchar2 default hr_api.g_varchar2,
194: p_pds_information22 in varchar2 default hr_api.g_varchar2,
187: p_pds_information15 in varchar2 default hr_api.g_varchar2,
188: p_pds_information16 in varchar2 default hr_api.g_varchar2,
189: p_pds_information17 in varchar2 default hr_api.g_varchar2,
190: p_pds_information18 in varchar2 default hr_api.g_varchar2,
191: p_pds_information19 in varchar2 default hr_api.g_varchar2,
192: p_pds_information20 in varchar2 default hr_api.g_varchar2,
193: p_pds_information21 in varchar2 default hr_api.g_varchar2,
194: p_pds_information22 in varchar2 default hr_api.g_varchar2,
195: p_pds_information23 in varchar2 default hr_api.g_varchar2,
188: p_pds_information16 in varchar2 default hr_api.g_varchar2,
189: p_pds_information17 in varchar2 default hr_api.g_varchar2,
190: p_pds_information18 in varchar2 default hr_api.g_varchar2,
191: p_pds_information19 in varchar2 default hr_api.g_varchar2,
192: p_pds_information20 in varchar2 default hr_api.g_varchar2,
193: p_pds_information21 in varchar2 default hr_api.g_varchar2,
194: p_pds_information22 in varchar2 default hr_api.g_varchar2,
195: p_pds_information23 in varchar2 default hr_api.g_varchar2,
196: p_pds_information24 in varchar2 default hr_api.g_varchar2,
189: p_pds_information17 in varchar2 default hr_api.g_varchar2,
190: p_pds_information18 in varchar2 default hr_api.g_varchar2,
191: p_pds_information19 in varchar2 default hr_api.g_varchar2,
192: p_pds_information20 in varchar2 default hr_api.g_varchar2,
193: p_pds_information21 in varchar2 default hr_api.g_varchar2,
194: p_pds_information22 in varchar2 default hr_api.g_varchar2,
195: p_pds_information23 in varchar2 default hr_api.g_varchar2,
196: p_pds_information24 in varchar2 default hr_api.g_varchar2,
197: p_pds_information25 in varchar2 default hr_api.g_varchar2,
190: p_pds_information18 in varchar2 default hr_api.g_varchar2,
191: p_pds_information19 in varchar2 default hr_api.g_varchar2,
192: p_pds_information20 in varchar2 default hr_api.g_varchar2,
193: p_pds_information21 in varchar2 default hr_api.g_varchar2,
194: p_pds_information22 in varchar2 default hr_api.g_varchar2,
195: p_pds_information23 in varchar2 default hr_api.g_varchar2,
196: p_pds_information24 in varchar2 default hr_api.g_varchar2,
197: p_pds_information25 in varchar2 default hr_api.g_varchar2,
198: p_pds_information26 in varchar2 default hr_api.g_varchar2,
191: p_pds_information19 in varchar2 default hr_api.g_varchar2,
192: p_pds_information20 in varchar2 default hr_api.g_varchar2,
193: p_pds_information21 in varchar2 default hr_api.g_varchar2,
194: p_pds_information22 in varchar2 default hr_api.g_varchar2,
195: p_pds_information23 in varchar2 default hr_api.g_varchar2,
196: p_pds_information24 in varchar2 default hr_api.g_varchar2,
197: p_pds_information25 in varchar2 default hr_api.g_varchar2,
198: p_pds_information26 in varchar2 default hr_api.g_varchar2,
199: p_pds_information27 in varchar2 default hr_api.g_varchar2,
192: p_pds_information20 in varchar2 default hr_api.g_varchar2,
193: p_pds_information21 in varchar2 default hr_api.g_varchar2,
194: p_pds_information22 in varchar2 default hr_api.g_varchar2,
195: p_pds_information23 in varchar2 default hr_api.g_varchar2,
196: p_pds_information24 in varchar2 default hr_api.g_varchar2,
197: p_pds_information25 in varchar2 default hr_api.g_varchar2,
198: p_pds_information26 in varchar2 default hr_api.g_varchar2,
199: p_pds_information27 in varchar2 default hr_api.g_varchar2,
200: p_pds_information28 in varchar2 default hr_api.g_varchar2,
193: p_pds_information21 in varchar2 default hr_api.g_varchar2,
194: p_pds_information22 in varchar2 default hr_api.g_varchar2,
195: p_pds_information23 in varchar2 default hr_api.g_varchar2,
196: p_pds_information24 in varchar2 default hr_api.g_varchar2,
197: p_pds_information25 in varchar2 default hr_api.g_varchar2,
198: p_pds_information26 in varchar2 default hr_api.g_varchar2,
199: p_pds_information27 in varchar2 default hr_api.g_varchar2,
200: p_pds_information28 in varchar2 default hr_api.g_varchar2,
201: p_pds_information29 in varchar2 default hr_api.g_varchar2,
194: p_pds_information22 in varchar2 default hr_api.g_varchar2,
195: p_pds_information23 in varchar2 default hr_api.g_varchar2,
196: p_pds_information24 in varchar2 default hr_api.g_varchar2,
197: p_pds_information25 in varchar2 default hr_api.g_varchar2,
198: p_pds_information26 in varchar2 default hr_api.g_varchar2,
199: p_pds_information27 in varchar2 default hr_api.g_varchar2,
200: p_pds_information28 in varchar2 default hr_api.g_varchar2,
201: p_pds_information29 in varchar2 default hr_api.g_varchar2,
202: p_pds_information30 in varchar2 default hr_api.g_varchar2,
195: p_pds_information23 in varchar2 default hr_api.g_varchar2,
196: p_pds_information24 in varchar2 default hr_api.g_varchar2,
197: p_pds_information25 in varchar2 default hr_api.g_varchar2,
198: p_pds_information26 in varchar2 default hr_api.g_varchar2,
199: p_pds_information27 in varchar2 default hr_api.g_varchar2,
200: p_pds_information28 in varchar2 default hr_api.g_varchar2,
201: p_pds_information29 in varchar2 default hr_api.g_varchar2,
202: p_pds_information30 in varchar2 default hr_api.g_varchar2,
203: p_effective_date in date,
196: p_pds_information24 in varchar2 default hr_api.g_varchar2,
197: p_pds_information25 in varchar2 default hr_api.g_varchar2,
198: p_pds_information26 in varchar2 default hr_api.g_varchar2,
199: p_pds_information27 in varchar2 default hr_api.g_varchar2,
200: p_pds_information28 in varchar2 default hr_api.g_varchar2,
201: p_pds_information29 in varchar2 default hr_api.g_varchar2,
202: p_pds_information30 in varchar2 default hr_api.g_varchar2,
203: p_effective_date in date,
204: p_validate in boolean default false
197: p_pds_information25 in varchar2 default hr_api.g_varchar2,
198: p_pds_information26 in varchar2 default hr_api.g_varchar2,
199: p_pds_information27 in varchar2 default hr_api.g_varchar2,
200: p_pds_information28 in varchar2 default hr_api.g_varchar2,
201: p_pds_information29 in varchar2 default hr_api.g_varchar2,
202: p_pds_information30 in varchar2 default hr_api.g_varchar2,
203: p_effective_date in date,
204: p_validate in boolean default false
205: );
198: p_pds_information26 in varchar2 default hr_api.g_varchar2,
199: p_pds_information27 in varchar2 default hr_api.g_varchar2,
200: p_pds_information28 in varchar2 default hr_api.g_varchar2,
201: p_pds_information29 in varchar2 default hr_api.g_varchar2,
202: p_pds_information30 in varchar2 default hr_api.g_varchar2,
203: p_effective_date in date,
204: p_validate in boolean default false
205: );
206: --