50: -- Internal Table Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy per_pds_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin
61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: per_pds_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the per_periods_of_service Row
68: --
69: update per_periods_of_service
140: pds_information29 = p_rec.pds_information29,
141: pds_information30 = p_rec.pds_information30
142: where period_of_service_id = p_rec.period_of_service_id;
143: --
144: per_pds_shd.g_api_dml := false; -- Unset the api dml status
145: --
146: hr_utility.set_location(' Leaving:'||l_proc, 10);
147: --
148: Exception
147: --
148: Exception
149: When hr_api.check_integrity_violated Then
150: -- A check constraint has been violated
151: per_pds_shd.g_api_dml := false; -- Unset the api dml status
152: per_pds_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When hr_api.parent_integrity_violated Then
155: -- Parent integrity has been violated
148: Exception
149: When hr_api.check_integrity_violated Then
150: -- A check constraint has been violated
151: per_pds_shd.g_api_dml := false; -- Unset the api dml status
152: per_pds_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When hr_api.parent_integrity_violated Then
155: -- Parent integrity has been violated
156: per_pds_shd.g_api_dml := false; -- Unset the api dml status
152: per_pds_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When hr_api.parent_integrity_violated Then
155: -- Parent integrity has been violated
156: per_pds_shd.g_api_dml := false; -- Unset the api dml status
157: per_pds_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.unique_integrity_violated Then
160: -- Unique integrity has been violated
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When hr_api.parent_integrity_violated Then
155: -- Parent integrity has been violated
156: per_pds_shd.g_api_dml := false; -- Unset the api dml status
157: per_pds_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.unique_integrity_violated Then
160: -- Unique integrity has been violated
161: per_pds_shd.g_api_dml := false; -- Unset the api dml status
157: per_pds_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.unique_integrity_violated Then
160: -- Unique integrity has been violated
161: per_pds_shd.g_api_dml := false; -- Unset the api dml status
162: per_pds_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When Others Then
165: per_pds_shd.g_api_dml := false; -- Unset the api dml status
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.unique_integrity_violated Then
160: -- Unique integrity has been violated
161: per_pds_shd.g_api_dml := false; -- Unset the api dml status
162: per_pds_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When Others Then
165: per_pds_shd.g_api_dml := false; -- Unset the api dml status
166: Raise;
161: per_pds_shd.g_api_dml := false; -- Unset the api dml status
162: per_pds_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When Others Then
165: per_pds_shd.g_api_dml := false; -- Unset the api dml status
166: Raise;
167: End update_dml;
168: --
169: -- ----------------------------------------------------------------------------
197: -- Internal Table Handler Use Only.
198: --
199: -- {End Of Comments}
200: -- ----------------------------------------------------------------------------
201: Procedure pre_update(p_rec in per_pds_shd.g_rec_type) is
202: --
203: l_proc varchar2(72) := g_package||'pre_update';
204: --
205: Begin
239: -- Internal Table Handler Use Only.
240: --
241: -- {End Of Comments}
242: -- ----------------------------------------------------------------------------
243: Procedure post_update(p_rec in per_pds_shd.g_rec_type,p_effective_date in date) is
244: --
245: l_proc varchar2(72) := g_package||'post_update';
246: l_rowid varchar2(72);
247: --
271: -- PDS level is masked and performed once at the end of the terminate.
272: -- This is a fix to bug 2344139.
273: --
274: if hr_ex_employee_internal.g_mask_pds_ler = FALSE then
275: l_old.PERSON_ID := per_pds_shd.g_old_rec.person_id;
276: l_old.BUSINESS_GROUP_ID := per_pds_shd.g_old_rec.business_group_id;
277: l_old.DATE_START := per_pds_shd.g_old_rec.date_start;
278: l_old.ACTUAL_TERMINATION_DATE := per_pds_shd.g_old_rec.actual_termination_date;
279: l_old.LEAVING_REASON := per_pds_shd.g_old_rec.leaving_reason;
272: -- This is a fix to bug 2344139.
273: --
274: if hr_ex_employee_internal.g_mask_pds_ler = FALSE then
275: l_old.PERSON_ID := per_pds_shd.g_old_rec.person_id;
276: l_old.BUSINESS_GROUP_ID := per_pds_shd.g_old_rec.business_group_id;
277: l_old.DATE_START := per_pds_shd.g_old_rec.date_start;
278: l_old.ACTUAL_TERMINATION_DATE := per_pds_shd.g_old_rec.actual_termination_date;
279: l_old.LEAVING_REASON := per_pds_shd.g_old_rec.leaving_reason;
280: l_old.ADJUSTED_SVC_DATE := per_pds_shd.g_old_rec.adjusted_svc_date;
273: --
274: if hr_ex_employee_internal.g_mask_pds_ler = FALSE then
275: l_old.PERSON_ID := per_pds_shd.g_old_rec.person_id;
276: l_old.BUSINESS_GROUP_ID := per_pds_shd.g_old_rec.business_group_id;
277: l_old.DATE_START := per_pds_shd.g_old_rec.date_start;
278: l_old.ACTUAL_TERMINATION_DATE := per_pds_shd.g_old_rec.actual_termination_date;
279: l_old.LEAVING_REASON := per_pds_shd.g_old_rec.leaving_reason;
280: l_old.ADJUSTED_SVC_DATE := per_pds_shd.g_old_rec.adjusted_svc_date;
281: l_old.ATTRIBUTE1 := per_pds_shd.g_old_rec.attribute1;
274: if hr_ex_employee_internal.g_mask_pds_ler = FALSE then
275: l_old.PERSON_ID := per_pds_shd.g_old_rec.person_id;
276: l_old.BUSINESS_GROUP_ID := per_pds_shd.g_old_rec.business_group_id;
277: l_old.DATE_START := per_pds_shd.g_old_rec.date_start;
278: l_old.ACTUAL_TERMINATION_DATE := per_pds_shd.g_old_rec.actual_termination_date;
279: l_old.LEAVING_REASON := per_pds_shd.g_old_rec.leaving_reason;
280: l_old.ADJUSTED_SVC_DATE := per_pds_shd.g_old_rec.adjusted_svc_date;
281: l_old.ATTRIBUTE1 := per_pds_shd.g_old_rec.attribute1;
282: l_old.ATTRIBUTE2 := per_pds_shd.g_old_rec.attribute2;
275: l_old.PERSON_ID := per_pds_shd.g_old_rec.person_id;
276: l_old.BUSINESS_GROUP_ID := per_pds_shd.g_old_rec.business_group_id;
277: l_old.DATE_START := per_pds_shd.g_old_rec.date_start;
278: l_old.ACTUAL_TERMINATION_DATE := per_pds_shd.g_old_rec.actual_termination_date;
279: l_old.LEAVING_REASON := per_pds_shd.g_old_rec.leaving_reason;
280: l_old.ADJUSTED_SVC_DATE := per_pds_shd.g_old_rec.adjusted_svc_date;
281: l_old.ATTRIBUTE1 := per_pds_shd.g_old_rec.attribute1;
282: l_old.ATTRIBUTE2 := per_pds_shd.g_old_rec.attribute2;
283: l_old.ATTRIBUTE3 := per_pds_shd.g_old_rec.attribute3;
276: l_old.BUSINESS_GROUP_ID := per_pds_shd.g_old_rec.business_group_id;
277: l_old.DATE_START := per_pds_shd.g_old_rec.date_start;
278: l_old.ACTUAL_TERMINATION_DATE := per_pds_shd.g_old_rec.actual_termination_date;
279: l_old.LEAVING_REASON := per_pds_shd.g_old_rec.leaving_reason;
280: l_old.ADJUSTED_SVC_DATE := per_pds_shd.g_old_rec.adjusted_svc_date;
281: l_old.ATTRIBUTE1 := per_pds_shd.g_old_rec.attribute1;
282: l_old.ATTRIBUTE2 := per_pds_shd.g_old_rec.attribute2;
283: l_old.ATTRIBUTE3 := per_pds_shd.g_old_rec.attribute3;
284: l_old.ATTRIBUTE4 := per_pds_shd.g_old_rec.attribute4;
277: l_old.DATE_START := per_pds_shd.g_old_rec.date_start;
278: l_old.ACTUAL_TERMINATION_DATE := per_pds_shd.g_old_rec.actual_termination_date;
279: l_old.LEAVING_REASON := per_pds_shd.g_old_rec.leaving_reason;
280: l_old.ADJUSTED_SVC_DATE := per_pds_shd.g_old_rec.adjusted_svc_date;
281: l_old.ATTRIBUTE1 := per_pds_shd.g_old_rec.attribute1;
282: l_old.ATTRIBUTE2 := per_pds_shd.g_old_rec.attribute2;
283: l_old.ATTRIBUTE3 := per_pds_shd.g_old_rec.attribute3;
284: l_old.ATTRIBUTE4 := per_pds_shd.g_old_rec.attribute4;
285: l_old.ATTRIBUTE5 := per_pds_shd.g_old_rec.attribute5;
278: l_old.ACTUAL_TERMINATION_DATE := per_pds_shd.g_old_rec.actual_termination_date;
279: l_old.LEAVING_REASON := per_pds_shd.g_old_rec.leaving_reason;
280: l_old.ADJUSTED_SVC_DATE := per_pds_shd.g_old_rec.adjusted_svc_date;
281: l_old.ATTRIBUTE1 := per_pds_shd.g_old_rec.attribute1;
282: l_old.ATTRIBUTE2 := per_pds_shd.g_old_rec.attribute2;
283: l_old.ATTRIBUTE3 := per_pds_shd.g_old_rec.attribute3;
284: l_old.ATTRIBUTE4 := per_pds_shd.g_old_rec.attribute4;
285: l_old.ATTRIBUTE5 := per_pds_shd.g_old_rec.attribute5;
286: l_old.FINAL_PROCESS_DATE := per_pds_shd.g_old_rec.FINAL_PROCESS_DATE;
279: l_old.LEAVING_REASON := per_pds_shd.g_old_rec.leaving_reason;
280: l_old.ADJUSTED_SVC_DATE := per_pds_shd.g_old_rec.adjusted_svc_date;
281: l_old.ATTRIBUTE1 := per_pds_shd.g_old_rec.attribute1;
282: l_old.ATTRIBUTE2 := per_pds_shd.g_old_rec.attribute2;
283: l_old.ATTRIBUTE3 := per_pds_shd.g_old_rec.attribute3;
284: l_old.ATTRIBUTE4 := per_pds_shd.g_old_rec.attribute4;
285: l_old.ATTRIBUTE5 := per_pds_shd.g_old_rec.attribute5;
286: l_old.FINAL_PROCESS_DATE := per_pds_shd.g_old_rec.FINAL_PROCESS_DATE;
287: l_new.PERSON_ID := p_rec.person_id;
280: l_old.ADJUSTED_SVC_DATE := per_pds_shd.g_old_rec.adjusted_svc_date;
281: l_old.ATTRIBUTE1 := per_pds_shd.g_old_rec.attribute1;
282: l_old.ATTRIBUTE2 := per_pds_shd.g_old_rec.attribute2;
283: l_old.ATTRIBUTE3 := per_pds_shd.g_old_rec.attribute3;
284: l_old.ATTRIBUTE4 := per_pds_shd.g_old_rec.attribute4;
285: l_old.ATTRIBUTE5 := per_pds_shd.g_old_rec.attribute5;
286: l_old.FINAL_PROCESS_DATE := per_pds_shd.g_old_rec.FINAL_PROCESS_DATE;
287: l_new.PERSON_ID := p_rec.person_id;
288: l_new.BUSINESS_GROUP_ID := p_rec.business_group_id;
281: l_old.ATTRIBUTE1 := per_pds_shd.g_old_rec.attribute1;
282: l_old.ATTRIBUTE2 := per_pds_shd.g_old_rec.attribute2;
283: l_old.ATTRIBUTE3 := per_pds_shd.g_old_rec.attribute3;
284: l_old.ATTRIBUTE4 := per_pds_shd.g_old_rec.attribute4;
285: l_old.ATTRIBUTE5 := per_pds_shd.g_old_rec.attribute5;
286: l_old.FINAL_PROCESS_DATE := per_pds_shd.g_old_rec.FINAL_PROCESS_DATE;
287: l_new.PERSON_ID := p_rec.person_id;
288: l_new.BUSINESS_GROUP_ID := p_rec.business_group_id;
289: l_new.DATE_START := p_rec.date_start;
282: l_old.ATTRIBUTE2 := per_pds_shd.g_old_rec.attribute2;
283: l_old.ATTRIBUTE3 := per_pds_shd.g_old_rec.attribute3;
284: l_old.ATTRIBUTE4 := per_pds_shd.g_old_rec.attribute4;
285: l_old.ATTRIBUTE5 := per_pds_shd.g_old_rec.attribute5;
286: l_old.FINAL_PROCESS_DATE := per_pds_shd.g_old_rec.FINAL_PROCESS_DATE;
287: l_new.PERSON_ID := p_rec.person_id;
288: l_new.BUSINESS_GROUP_ID := p_rec.business_group_id;
289: l_new.DATE_START := p_rec.date_start;
290: l_new.ACTUAL_TERMINATION_DATE := p_rec.actual_termination_date;
318: ,p_person_id => p_rec.person_id
319: ,p_pds_atd => p_rec.actual_termination_date
320: ,p_pds_leaving_reason => p_rec.leaving_reason
321: ,p_pds_fpd => p_rec.final_process_date
322: ,p_pds_old_atd => per_pds_shd.g_old_rec.actual_termination_date
323: );
324: --
325: --
326: -- Start of API User Hook for post_update.
398: ,p_pds_information28 =>p_rec.pds_information28
399: ,p_pds_information29 =>p_rec.pds_information29
400: ,p_pds_information30 =>p_rec.pds_information30
401: ,p_effective_date =>p_effective_date
402: ,p_business_group_id_o =>per_pds_shd.g_old_rec.business_group_id
403: ,p_person_id_o =>per_pds_shd.g_old_rec.person_id
404: ,p_terminat_accepted_person_o =>per_pds_shd.g_old_rec.termination_accepted_person_id
405: ,p_date_start_o =>per_pds_shd.g_old_rec.date_start
406: ,p_accepted_termination_date_o =>per_pds_shd.g_old_rec.accepted_termination_date
399: ,p_pds_information29 =>p_rec.pds_information29
400: ,p_pds_information30 =>p_rec.pds_information30
401: ,p_effective_date =>p_effective_date
402: ,p_business_group_id_o =>per_pds_shd.g_old_rec.business_group_id
403: ,p_person_id_o =>per_pds_shd.g_old_rec.person_id
404: ,p_terminat_accepted_person_o =>per_pds_shd.g_old_rec.termination_accepted_person_id
405: ,p_date_start_o =>per_pds_shd.g_old_rec.date_start
406: ,p_accepted_termination_date_o =>per_pds_shd.g_old_rec.accepted_termination_date
407: ,p_actual_termination_date_o =>per_pds_shd.g_old_rec.actual_termination_date
400: ,p_pds_information30 =>p_rec.pds_information30
401: ,p_effective_date =>p_effective_date
402: ,p_business_group_id_o =>per_pds_shd.g_old_rec.business_group_id
403: ,p_person_id_o =>per_pds_shd.g_old_rec.person_id
404: ,p_terminat_accepted_person_o =>per_pds_shd.g_old_rec.termination_accepted_person_id
405: ,p_date_start_o =>per_pds_shd.g_old_rec.date_start
406: ,p_accepted_termination_date_o =>per_pds_shd.g_old_rec.accepted_termination_date
407: ,p_actual_termination_date_o =>per_pds_shd.g_old_rec.actual_termination_date
408: ,p_comments_o =>per_pds_shd.g_old_rec.comments
401: ,p_effective_date =>p_effective_date
402: ,p_business_group_id_o =>per_pds_shd.g_old_rec.business_group_id
403: ,p_person_id_o =>per_pds_shd.g_old_rec.person_id
404: ,p_terminat_accepted_person_o =>per_pds_shd.g_old_rec.termination_accepted_person_id
405: ,p_date_start_o =>per_pds_shd.g_old_rec.date_start
406: ,p_accepted_termination_date_o =>per_pds_shd.g_old_rec.accepted_termination_date
407: ,p_actual_termination_date_o =>per_pds_shd.g_old_rec.actual_termination_date
408: ,p_comments_o =>per_pds_shd.g_old_rec.comments
409: ,p_adjusted_svc_date_o =>per_pds_shd.g_old_rec.adjusted_svc_date
402: ,p_business_group_id_o =>per_pds_shd.g_old_rec.business_group_id
403: ,p_person_id_o =>per_pds_shd.g_old_rec.person_id
404: ,p_terminat_accepted_person_o =>per_pds_shd.g_old_rec.termination_accepted_person_id
405: ,p_date_start_o =>per_pds_shd.g_old_rec.date_start
406: ,p_accepted_termination_date_o =>per_pds_shd.g_old_rec.accepted_termination_date
407: ,p_actual_termination_date_o =>per_pds_shd.g_old_rec.actual_termination_date
408: ,p_comments_o =>per_pds_shd.g_old_rec.comments
409: ,p_adjusted_svc_date_o =>per_pds_shd.g_old_rec.adjusted_svc_date
410: ,p_final_process_date_o =>per_pds_shd.g_old_rec.final_process_date
403: ,p_person_id_o =>per_pds_shd.g_old_rec.person_id
404: ,p_terminat_accepted_person_o =>per_pds_shd.g_old_rec.termination_accepted_person_id
405: ,p_date_start_o =>per_pds_shd.g_old_rec.date_start
406: ,p_accepted_termination_date_o =>per_pds_shd.g_old_rec.accepted_termination_date
407: ,p_actual_termination_date_o =>per_pds_shd.g_old_rec.actual_termination_date
408: ,p_comments_o =>per_pds_shd.g_old_rec.comments
409: ,p_adjusted_svc_date_o =>per_pds_shd.g_old_rec.adjusted_svc_date
410: ,p_final_process_date_o =>per_pds_shd.g_old_rec.final_process_date
411: ,p_last_standard_process_date_o =>per_pds_shd.g_old_rec.last_standard_process_date
404: ,p_terminat_accepted_person_o =>per_pds_shd.g_old_rec.termination_accepted_person_id
405: ,p_date_start_o =>per_pds_shd.g_old_rec.date_start
406: ,p_accepted_termination_date_o =>per_pds_shd.g_old_rec.accepted_termination_date
407: ,p_actual_termination_date_o =>per_pds_shd.g_old_rec.actual_termination_date
408: ,p_comments_o =>per_pds_shd.g_old_rec.comments
409: ,p_adjusted_svc_date_o =>per_pds_shd.g_old_rec.adjusted_svc_date
410: ,p_final_process_date_o =>per_pds_shd.g_old_rec.final_process_date
411: ,p_last_standard_process_date_o =>per_pds_shd.g_old_rec.last_standard_process_date
412: ,p_leaving_reason_o =>per_pds_shd.g_old_rec.leaving_reason
405: ,p_date_start_o =>per_pds_shd.g_old_rec.date_start
406: ,p_accepted_termination_date_o =>per_pds_shd.g_old_rec.accepted_termination_date
407: ,p_actual_termination_date_o =>per_pds_shd.g_old_rec.actual_termination_date
408: ,p_comments_o =>per_pds_shd.g_old_rec.comments
409: ,p_adjusted_svc_date_o =>per_pds_shd.g_old_rec.adjusted_svc_date
410: ,p_final_process_date_o =>per_pds_shd.g_old_rec.final_process_date
411: ,p_last_standard_process_date_o =>per_pds_shd.g_old_rec.last_standard_process_date
412: ,p_leaving_reason_o =>per_pds_shd.g_old_rec.leaving_reason
413: ,p_notified_termination_date_o =>per_pds_shd.g_old_rec.notified_termination_date
406: ,p_accepted_termination_date_o =>per_pds_shd.g_old_rec.accepted_termination_date
407: ,p_actual_termination_date_o =>per_pds_shd.g_old_rec.actual_termination_date
408: ,p_comments_o =>per_pds_shd.g_old_rec.comments
409: ,p_adjusted_svc_date_o =>per_pds_shd.g_old_rec.adjusted_svc_date
410: ,p_final_process_date_o =>per_pds_shd.g_old_rec.final_process_date
411: ,p_last_standard_process_date_o =>per_pds_shd.g_old_rec.last_standard_process_date
412: ,p_leaving_reason_o =>per_pds_shd.g_old_rec.leaving_reason
413: ,p_notified_termination_date_o =>per_pds_shd.g_old_rec.notified_termination_date
414: ,p_projected_termination_date_o =>per_pds_shd.g_old_rec.projected_termination_date
407: ,p_actual_termination_date_o =>per_pds_shd.g_old_rec.actual_termination_date
408: ,p_comments_o =>per_pds_shd.g_old_rec.comments
409: ,p_adjusted_svc_date_o =>per_pds_shd.g_old_rec.adjusted_svc_date
410: ,p_final_process_date_o =>per_pds_shd.g_old_rec.final_process_date
411: ,p_last_standard_process_date_o =>per_pds_shd.g_old_rec.last_standard_process_date
412: ,p_leaving_reason_o =>per_pds_shd.g_old_rec.leaving_reason
413: ,p_notified_termination_date_o =>per_pds_shd.g_old_rec.notified_termination_date
414: ,p_projected_termination_date_o =>per_pds_shd.g_old_rec.projected_termination_date
415: ,p_request_id_o =>per_pds_shd.g_old_rec.request_id
408: ,p_comments_o =>per_pds_shd.g_old_rec.comments
409: ,p_adjusted_svc_date_o =>per_pds_shd.g_old_rec.adjusted_svc_date
410: ,p_final_process_date_o =>per_pds_shd.g_old_rec.final_process_date
411: ,p_last_standard_process_date_o =>per_pds_shd.g_old_rec.last_standard_process_date
412: ,p_leaving_reason_o =>per_pds_shd.g_old_rec.leaving_reason
413: ,p_notified_termination_date_o =>per_pds_shd.g_old_rec.notified_termination_date
414: ,p_projected_termination_date_o =>per_pds_shd.g_old_rec.projected_termination_date
415: ,p_request_id_o =>per_pds_shd.g_old_rec.request_id
416: ,p_program_application_id_o =>per_pds_shd.g_old_rec.program_application_id
409: ,p_adjusted_svc_date_o =>per_pds_shd.g_old_rec.adjusted_svc_date
410: ,p_final_process_date_o =>per_pds_shd.g_old_rec.final_process_date
411: ,p_last_standard_process_date_o =>per_pds_shd.g_old_rec.last_standard_process_date
412: ,p_leaving_reason_o =>per_pds_shd.g_old_rec.leaving_reason
413: ,p_notified_termination_date_o =>per_pds_shd.g_old_rec.notified_termination_date
414: ,p_projected_termination_date_o =>per_pds_shd.g_old_rec.projected_termination_date
415: ,p_request_id_o =>per_pds_shd.g_old_rec.request_id
416: ,p_program_application_id_o =>per_pds_shd.g_old_rec.program_application_id
417: ,p_program_id_o =>per_pds_shd.g_old_rec.program_id
410: ,p_final_process_date_o =>per_pds_shd.g_old_rec.final_process_date
411: ,p_last_standard_process_date_o =>per_pds_shd.g_old_rec.last_standard_process_date
412: ,p_leaving_reason_o =>per_pds_shd.g_old_rec.leaving_reason
413: ,p_notified_termination_date_o =>per_pds_shd.g_old_rec.notified_termination_date
414: ,p_projected_termination_date_o =>per_pds_shd.g_old_rec.projected_termination_date
415: ,p_request_id_o =>per_pds_shd.g_old_rec.request_id
416: ,p_program_application_id_o =>per_pds_shd.g_old_rec.program_application_id
417: ,p_program_id_o =>per_pds_shd.g_old_rec.program_id
418: ,p_program_update_date_o =>per_pds_shd.g_old_rec.program_update_date
411: ,p_last_standard_process_date_o =>per_pds_shd.g_old_rec.last_standard_process_date
412: ,p_leaving_reason_o =>per_pds_shd.g_old_rec.leaving_reason
413: ,p_notified_termination_date_o =>per_pds_shd.g_old_rec.notified_termination_date
414: ,p_projected_termination_date_o =>per_pds_shd.g_old_rec.projected_termination_date
415: ,p_request_id_o =>per_pds_shd.g_old_rec.request_id
416: ,p_program_application_id_o =>per_pds_shd.g_old_rec.program_application_id
417: ,p_program_id_o =>per_pds_shd.g_old_rec.program_id
418: ,p_program_update_date_o =>per_pds_shd.g_old_rec.program_update_date
419: ,p_attribute_category_o =>per_pds_shd.g_old_rec.attribute_category
412: ,p_leaving_reason_o =>per_pds_shd.g_old_rec.leaving_reason
413: ,p_notified_termination_date_o =>per_pds_shd.g_old_rec.notified_termination_date
414: ,p_projected_termination_date_o =>per_pds_shd.g_old_rec.projected_termination_date
415: ,p_request_id_o =>per_pds_shd.g_old_rec.request_id
416: ,p_program_application_id_o =>per_pds_shd.g_old_rec.program_application_id
417: ,p_program_id_o =>per_pds_shd.g_old_rec.program_id
418: ,p_program_update_date_o =>per_pds_shd.g_old_rec.program_update_date
419: ,p_attribute_category_o =>per_pds_shd.g_old_rec.attribute_category
420: ,p_attribute1_o =>per_pds_shd.g_old_rec.attribute1
413: ,p_notified_termination_date_o =>per_pds_shd.g_old_rec.notified_termination_date
414: ,p_projected_termination_date_o =>per_pds_shd.g_old_rec.projected_termination_date
415: ,p_request_id_o =>per_pds_shd.g_old_rec.request_id
416: ,p_program_application_id_o =>per_pds_shd.g_old_rec.program_application_id
417: ,p_program_id_o =>per_pds_shd.g_old_rec.program_id
418: ,p_program_update_date_o =>per_pds_shd.g_old_rec.program_update_date
419: ,p_attribute_category_o =>per_pds_shd.g_old_rec.attribute_category
420: ,p_attribute1_o =>per_pds_shd.g_old_rec.attribute1
421: ,p_attribute2_o =>per_pds_shd.g_old_rec.attribute2
414: ,p_projected_termination_date_o =>per_pds_shd.g_old_rec.projected_termination_date
415: ,p_request_id_o =>per_pds_shd.g_old_rec.request_id
416: ,p_program_application_id_o =>per_pds_shd.g_old_rec.program_application_id
417: ,p_program_id_o =>per_pds_shd.g_old_rec.program_id
418: ,p_program_update_date_o =>per_pds_shd.g_old_rec.program_update_date
419: ,p_attribute_category_o =>per_pds_shd.g_old_rec.attribute_category
420: ,p_attribute1_o =>per_pds_shd.g_old_rec.attribute1
421: ,p_attribute2_o =>per_pds_shd.g_old_rec.attribute2
422: ,p_attribute3_o =>per_pds_shd.g_old_rec.attribute3
415: ,p_request_id_o =>per_pds_shd.g_old_rec.request_id
416: ,p_program_application_id_o =>per_pds_shd.g_old_rec.program_application_id
417: ,p_program_id_o =>per_pds_shd.g_old_rec.program_id
418: ,p_program_update_date_o =>per_pds_shd.g_old_rec.program_update_date
419: ,p_attribute_category_o =>per_pds_shd.g_old_rec.attribute_category
420: ,p_attribute1_o =>per_pds_shd.g_old_rec.attribute1
421: ,p_attribute2_o =>per_pds_shd.g_old_rec.attribute2
422: ,p_attribute3_o =>per_pds_shd.g_old_rec.attribute3
423: ,p_attribute4_o =>per_pds_shd.g_old_rec.attribute4
416: ,p_program_application_id_o =>per_pds_shd.g_old_rec.program_application_id
417: ,p_program_id_o =>per_pds_shd.g_old_rec.program_id
418: ,p_program_update_date_o =>per_pds_shd.g_old_rec.program_update_date
419: ,p_attribute_category_o =>per_pds_shd.g_old_rec.attribute_category
420: ,p_attribute1_o =>per_pds_shd.g_old_rec.attribute1
421: ,p_attribute2_o =>per_pds_shd.g_old_rec.attribute2
422: ,p_attribute3_o =>per_pds_shd.g_old_rec.attribute3
423: ,p_attribute4_o =>per_pds_shd.g_old_rec.attribute4
424: ,p_attribute5_o =>per_pds_shd.g_old_rec.attribute5
417: ,p_program_id_o =>per_pds_shd.g_old_rec.program_id
418: ,p_program_update_date_o =>per_pds_shd.g_old_rec.program_update_date
419: ,p_attribute_category_o =>per_pds_shd.g_old_rec.attribute_category
420: ,p_attribute1_o =>per_pds_shd.g_old_rec.attribute1
421: ,p_attribute2_o =>per_pds_shd.g_old_rec.attribute2
422: ,p_attribute3_o =>per_pds_shd.g_old_rec.attribute3
423: ,p_attribute4_o =>per_pds_shd.g_old_rec.attribute4
424: ,p_attribute5_o =>per_pds_shd.g_old_rec.attribute5
425: ,p_attribute6_o =>per_pds_shd.g_old_rec.attribute6
418: ,p_program_update_date_o =>per_pds_shd.g_old_rec.program_update_date
419: ,p_attribute_category_o =>per_pds_shd.g_old_rec.attribute_category
420: ,p_attribute1_o =>per_pds_shd.g_old_rec.attribute1
421: ,p_attribute2_o =>per_pds_shd.g_old_rec.attribute2
422: ,p_attribute3_o =>per_pds_shd.g_old_rec.attribute3
423: ,p_attribute4_o =>per_pds_shd.g_old_rec.attribute4
424: ,p_attribute5_o =>per_pds_shd.g_old_rec.attribute5
425: ,p_attribute6_o =>per_pds_shd.g_old_rec.attribute6
426: ,p_attribute7_o =>per_pds_shd.g_old_rec.attribute7
419: ,p_attribute_category_o =>per_pds_shd.g_old_rec.attribute_category
420: ,p_attribute1_o =>per_pds_shd.g_old_rec.attribute1
421: ,p_attribute2_o =>per_pds_shd.g_old_rec.attribute2
422: ,p_attribute3_o =>per_pds_shd.g_old_rec.attribute3
423: ,p_attribute4_o =>per_pds_shd.g_old_rec.attribute4
424: ,p_attribute5_o =>per_pds_shd.g_old_rec.attribute5
425: ,p_attribute6_o =>per_pds_shd.g_old_rec.attribute6
426: ,p_attribute7_o =>per_pds_shd.g_old_rec.attribute7
427: ,p_attribute8_o =>per_pds_shd.g_old_rec.attribute8
420: ,p_attribute1_o =>per_pds_shd.g_old_rec.attribute1
421: ,p_attribute2_o =>per_pds_shd.g_old_rec.attribute2
422: ,p_attribute3_o =>per_pds_shd.g_old_rec.attribute3
423: ,p_attribute4_o =>per_pds_shd.g_old_rec.attribute4
424: ,p_attribute5_o =>per_pds_shd.g_old_rec.attribute5
425: ,p_attribute6_o =>per_pds_shd.g_old_rec.attribute6
426: ,p_attribute7_o =>per_pds_shd.g_old_rec.attribute7
427: ,p_attribute8_o =>per_pds_shd.g_old_rec.attribute8
428: ,p_attribute9_o =>per_pds_shd.g_old_rec.attribute9
421: ,p_attribute2_o =>per_pds_shd.g_old_rec.attribute2
422: ,p_attribute3_o =>per_pds_shd.g_old_rec.attribute3
423: ,p_attribute4_o =>per_pds_shd.g_old_rec.attribute4
424: ,p_attribute5_o =>per_pds_shd.g_old_rec.attribute5
425: ,p_attribute6_o =>per_pds_shd.g_old_rec.attribute6
426: ,p_attribute7_o =>per_pds_shd.g_old_rec.attribute7
427: ,p_attribute8_o =>per_pds_shd.g_old_rec.attribute8
428: ,p_attribute9_o =>per_pds_shd.g_old_rec.attribute9
429: ,p_attribute10_o =>per_pds_shd.g_old_rec.attribute10
422: ,p_attribute3_o =>per_pds_shd.g_old_rec.attribute3
423: ,p_attribute4_o =>per_pds_shd.g_old_rec.attribute4
424: ,p_attribute5_o =>per_pds_shd.g_old_rec.attribute5
425: ,p_attribute6_o =>per_pds_shd.g_old_rec.attribute6
426: ,p_attribute7_o =>per_pds_shd.g_old_rec.attribute7
427: ,p_attribute8_o =>per_pds_shd.g_old_rec.attribute8
428: ,p_attribute9_o =>per_pds_shd.g_old_rec.attribute9
429: ,p_attribute10_o =>per_pds_shd.g_old_rec.attribute10
430: ,p_attribute11_o =>per_pds_shd.g_old_rec.attribute11
423: ,p_attribute4_o =>per_pds_shd.g_old_rec.attribute4
424: ,p_attribute5_o =>per_pds_shd.g_old_rec.attribute5
425: ,p_attribute6_o =>per_pds_shd.g_old_rec.attribute6
426: ,p_attribute7_o =>per_pds_shd.g_old_rec.attribute7
427: ,p_attribute8_o =>per_pds_shd.g_old_rec.attribute8
428: ,p_attribute9_o =>per_pds_shd.g_old_rec.attribute9
429: ,p_attribute10_o =>per_pds_shd.g_old_rec.attribute10
430: ,p_attribute11_o =>per_pds_shd.g_old_rec.attribute11
431: ,p_attribute12_o =>per_pds_shd.g_old_rec.attribute12
424: ,p_attribute5_o =>per_pds_shd.g_old_rec.attribute5
425: ,p_attribute6_o =>per_pds_shd.g_old_rec.attribute6
426: ,p_attribute7_o =>per_pds_shd.g_old_rec.attribute7
427: ,p_attribute8_o =>per_pds_shd.g_old_rec.attribute8
428: ,p_attribute9_o =>per_pds_shd.g_old_rec.attribute9
429: ,p_attribute10_o =>per_pds_shd.g_old_rec.attribute10
430: ,p_attribute11_o =>per_pds_shd.g_old_rec.attribute11
431: ,p_attribute12_o =>per_pds_shd.g_old_rec.attribute12
432: ,p_attribute13_o =>per_pds_shd.g_old_rec.attribute13
425: ,p_attribute6_o =>per_pds_shd.g_old_rec.attribute6
426: ,p_attribute7_o =>per_pds_shd.g_old_rec.attribute7
427: ,p_attribute8_o =>per_pds_shd.g_old_rec.attribute8
428: ,p_attribute9_o =>per_pds_shd.g_old_rec.attribute9
429: ,p_attribute10_o =>per_pds_shd.g_old_rec.attribute10
430: ,p_attribute11_o =>per_pds_shd.g_old_rec.attribute11
431: ,p_attribute12_o =>per_pds_shd.g_old_rec.attribute12
432: ,p_attribute13_o =>per_pds_shd.g_old_rec.attribute13
433: ,p_attribute14_o =>per_pds_shd.g_old_rec.attribute14
426: ,p_attribute7_o =>per_pds_shd.g_old_rec.attribute7
427: ,p_attribute8_o =>per_pds_shd.g_old_rec.attribute8
428: ,p_attribute9_o =>per_pds_shd.g_old_rec.attribute9
429: ,p_attribute10_o =>per_pds_shd.g_old_rec.attribute10
430: ,p_attribute11_o =>per_pds_shd.g_old_rec.attribute11
431: ,p_attribute12_o =>per_pds_shd.g_old_rec.attribute12
432: ,p_attribute13_o =>per_pds_shd.g_old_rec.attribute13
433: ,p_attribute14_o =>per_pds_shd.g_old_rec.attribute14
434: ,p_attribute15_o =>per_pds_shd.g_old_rec.attribute15
427: ,p_attribute8_o =>per_pds_shd.g_old_rec.attribute8
428: ,p_attribute9_o =>per_pds_shd.g_old_rec.attribute9
429: ,p_attribute10_o =>per_pds_shd.g_old_rec.attribute10
430: ,p_attribute11_o =>per_pds_shd.g_old_rec.attribute11
431: ,p_attribute12_o =>per_pds_shd.g_old_rec.attribute12
432: ,p_attribute13_o =>per_pds_shd.g_old_rec.attribute13
433: ,p_attribute14_o =>per_pds_shd.g_old_rec.attribute14
434: ,p_attribute15_o =>per_pds_shd.g_old_rec.attribute15
435: ,p_attribute16_o =>per_pds_shd.g_old_rec.attribute16
428: ,p_attribute9_o =>per_pds_shd.g_old_rec.attribute9
429: ,p_attribute10_o =>per_pds_shd.g_old_rec.attribute10
430: ,p_attribute11_o =>per_pds_shd.g_old_rec.attribute11
431: ,p_attribute12_o =>per_pds_shd.g_old_rec.attribute12
432: ,p_attribute13_o =>per_pds_shd.g_old_rec.attribute13
433: ,p_attribute14_o =>per_pds_shd.g_old_rec.attribute14
434: ,p_attribute15_o =>per_pds_shd.g_old_rec.attribute15
435: ,p_attribute16_o =>per_pds_shd.g_old_rec.attribute16
436: ,p_attribute17_o =>per_pds_shd.g_old_rec.attribute17
429: ,p_attribute10_o =>per_pds_shd.g_old_rec.attribute10
430: ,p_attribute11_o =>per_pds_shd.g_old_rec.attribute11
431: ,p_attribute12_o =>per_pds_shd.g_old_rec.attribute12
432: ,p_attribute13_o =>per_pds_shd.g_old_rec.attribute13
433: ,p_attribute14_o =>per_pds_shd.g_old_rec.attribute14
434: ,p_attribute15_o =>per_pds_shd.g_old_rec.attribute15
435: ,p_attribute16_o =>per_pds_shd.g_old_rec.attribute16
436: ,p_attribute17_o =>per_pds_shd.g_old_rec.attribute17
437: ,p_attribute18_o =>per_pds_shd.g_old_rec.attribute18
430: ,p_attribute11_o =>per_pds_shd.g_old_rec.attribute11
431: ,p_attribute12_o =>per_pds_shd.g_old_rec.attribute12
432: ,p_attribute13_o =>per_pds_shd.g_old_rec.attribute13
433: ,p_attribute14_o =>per_pds_shd.g_old_rec.attribute14
434: ,p_attribute15_o =>per_pds_shd.g_old_rec.attribute15
435: ,p_attribute16_o =>per_pds_shd.g_old_rec.attribute16
436: ,p_attribute17_o =>per_pds_shd.g_old_rec.attribute17
437: ,p_attribute18_o =>per_pds_shd.g_old_rec.attribute18
438: ,p_attribute19_o =>per_pds_shd.g_old_rec.attribute19
431: ,p_attribute12_o =>per_pds_shd.g_old_rec.attribute12
432: ,p_attribute13_o =>per_pds_shd.g_old_rec.attribute13
433: ,p_attribute14_o =>per_pds_shd.g_old_rec.attribute14
434: ,p_attribute15_o =>per_pds_shd.g_old_rec.attribute15
435: ,p_attribute16_o =>per_pds_shd.g_old_rec.attribute16
436: ,p_attribute17_o =>per_pds_shd.g_old_rec.attribute17
437: ,p_attribute18_o =>per_pds_shd.g_old_rec.attribute18
438: ,p_attribute19_o =>per_pds_shd.g_old_rec.attribute19
439: ,p_attribute20_o =>per_pds_shd.g_old_rec.attribute20
432: ,p_attribute13_o =>per_pds_shd.g_old_rec.attribute13
433: ,p_attribute14_o =>per_pds_shd.g_old_rec.attribute14
434: ,p_attribute15_o =>per_pds_shd.g_old_rec.attribute15
435: ,p_attribute16_o =>per_pds_shd.g_old_rec.attribute16
436: ,p_attribute17_o =>per_pds_shd.g_old_rec.attribute17
437: ,p_attribute18_o =>per_pds_shd.g_old_rec.attribute18
438: ,p_attribute19_o =>per_pds_shd.g_old_rec.attribute19
439: ,p_attribute20_o =>per_pds_shd.g_old_rec.attribute20
440: ,p_object_version_number_o =>per_pds_shd.g_old_rec.object_version_number
433: ,p_attribute14_o =>per_pds_shd.g_old_rec.attribute14
434: ,p_attribute15_o =>per_pds_shd.g_old_rec.attribute15
435: ,p_attribute16_o =>per_pds_shd.g_old_rec.attribute16
436: ,p_attribute17_o =>per_pds_shd.g_old_rec.attribute17
437: ,p_attribute18_o =>per_pds_shd.g_old_rec.attribute18
438: ,p_attribute19_o =>per_pds_shd.g_old_rec.attribute19
439: ,p_attribute20_o =>per_pds_shd.g_old_rec.attribute20
440: ,p_object_version_number_o =>per_pds_shd.g_old_rec.object_version_number
441: ,p_prior_employment_ssp_weeks_o =>per_pds_shd.g_old_rec.prior_employment_ssp_weeks
434: ,p_attribute15_o =>per_pds_shd.g_old_rec.attribute15
435: ,p_attribute16_o =>per_pds_shd.g_old_rec.attribute16
436: ,p_attribute17_o =>per_pds_shd.g_old_rec.attribute17
437: ,p_attribute18_o =>per_pds_shd.g_old_rec.attribute18
438: ,p_attribute19_o =>per_pds_shd.g_old_rec.attribute19
439: ,p_attribute20_o =>per_pds_shd.g_old_rec.attribute20
440: ,p_object_version_number_o =>per_pds_shd.g_old_rec.object_version_number
441: ,p_prior_employment_ssp_weeks_o =>per_pds_shd.g_old_rec.prior_employment_ssp_weeks
442: ,p_prior_employmt_ssp_paid_to_o =>per_pds_shd.g_old_rec.prior_employment_ssp_paid_to
435: ,p_attribute16_o =>per_pds_shd.g_old_rec.attribute16
436: ,p_attribute17_o =>per_pds_shd.g_old_rec.attribute17
437: ,p_attribute18_o =>per_pds_shd.g_old_rec.attribute18
438: ,p_attribute19_o =>per_pds_shd.g_old_rec.attribute19
439: ,p_attribute20_o =>per_pds_shd.g_old_rec.attribute20
440: ,p_object_version_number_o =>per_pds_shd.g_old_rec.object_version_number
441: ,p_prior_employment_ssp_weeks_o =>per_pds_shd.g_old_rec.prior_employment_ssp_weeks
442: ,p_prior_employmt_ssp_paid_to_o =>per_pds_shd.g_old_rec.prior_employment_ssp_paid_to
443: ,p_pds_information_category_o =>per_pds_shd.g_old_rec.pds_information_category
436: ,p_attribute17_o =>per_pds_shd.g_old_rec.attribute17
437: ,p_attribute18_o =>per_pds_shd.g_old_rec.attribute18
438: ,p_attribute19_o =>per_pds_shd.g_old_rec.attribute19
439: ,p_attribute20_o =>per_pds_shd.g_old_rec.attribute20
440: ,p_object_version_number_o =>per_pds_shd.g_old_rec.object_version_number
441: ,p_prior_employment_ssp_weeks_o =>per_pds_shd.g_old_rec.prior_employment_ssp_weeks
442: ,p_prior_employmt_ssp_paid_to_o =>per_pds_shd.g_old_rec.prior_employment_ssp_paid_to
443: ,p_pds_information_category_o =>per_pds_shd.g_old_rec.pds_information_category
444: ,p_pds_information1_o =>per_pds_shd.g_old_rec.pds_information1
437: ,p_attribute18_o =>per_pds_shd.g_old_rec.attribute18
438: ,p_attribute19_o =>per_pds_shd.g_old_rec.attribute19
439: ,p_attribute20_o =>per_pds_shd.g_old_rec.attribute20
440: ,p_object_version_number_o =>per_pds_shd.g_old_rec.object_version_number
441: ,p_prior_employment_ssp_weeks_o =>per_pds_shd.g_old_rec.prior_employment_ssp_weeks
442: ,p_prior_employmt_ssp_paid_to_o =>per_pds_shd.g_old_rec.prior_employment_ssp_paid_to
443: ,p_pds_information_category_o =>per_pds_shd.g_old_rec.pds_information_category
444: ,p_pds_information1_o =>per_pds_shd.g_old_rec.pds_information1
445: ,p_pds_information2_o =>per_pds_shd.g_old_rec.pds_information2
438: ,p_attribute19_o =>per_pds_shd.g_old_rec.attribute19
439: ,p_attribute20_o =>per_pds_shd.g_old_rec.attribute20
440: ,p_object_version_number_o =>per_pds_shd.g_old_rec.object_version_number
441: ,p_prior_employment_ssp_weeks_o =>per_pds_shd.g_old_rec.prior_employment_ssp_weeks
442: ,p_prior_employmt_ssp_paid_to_o =>per_pds_shd.g_old_rec.prior_employment_ssp_paid_to
443: ,p_pds_information_category_o =>per_pds_shd.g_old_rec.pds_information_category
444: ,p_pds_information1_o =>per_pds_shd.g_old_rec.pds_information1
445: ,p_pds_information2_o =>per_pds_shd.g_old_rec.pds_information2
446: ,p_pds_information3_o =>per_pds_shd.g_old_rec.pds_information3
439: ,p_attribute20_o =>per_pds_shd.g_old_rec.attribute20
440: ,p_object_version_number_o =>per_pds_shd.g_old_rec.object_version_number
441: ,p_prior_employment_ssp_weeks_o =>per_pds_shd.g_old_rec.prior_employment_ssp_weeks
442: ,p_prior_employmt_ssp_paid_to_o =>per_pds_shd.g_old_rec.prior_employment_ssp_paid_to
443: ,p_pds_information_category_o =>per_pds_shd.g_old_rec.pds_information_category
444: ,p_pds_information1_o =>per_pds_shd.g_old_rec.pds_information1
445: ,p_pds_information2_o =>per_pds_shd.g_old_rec.pds_information2
446: ,p_pds_information3_o =>per_pds_shd.g_old_rec.pds_information3
447: ,p_pds_information4_o =>per_pds_shd.g_old_rec.pds_information4
440: ,p_object_version_number_o =>per_pds_shd.g_old_rec.object_version_number
441: ,p_prior_employment_ssp_weeks_o =>per_pds_shd.g_old_rec.prior_employment_ssp_weeks
442: ,p_prior_employmt_ssp_paid_to_o =>per_pds_shd.g_old_rec.prior_employment_ssp_paid_to
443: ,p_pds_information_category_o =>per_pds_shd.g_old_rec.pds_information_category
444: ,p_pds_information1_o =>per_pds_shd.g_old_rec.pds_information1
445: ,p_pds_information2_o =>per_pds_shd.g_old_rec.pds_information2
446: ,p_pds_information3_o =>per_pds_shd.g_old_rec.pds_information3
447: ,p_pds_information4_o =>per_pds_shd.g_old_rec.pds_information4
448: ,p_pds_information5_o =>per_pds_shd.g_old_rec.pds_information5
441: ,p_prior_employment_ssp_weeks_o =>per_pds_shd.g_old_rec.prior_employment_ssp_weeks
442: ,p_prior_employmt_ssp_paid_to_o =>per_pds_shd.g_old_rec.prior_employment_ssp_paid_to
443: ,p_pds_information_category_o =>per_pds_shd.g_old_rec.pds_information_category
444: ,p_pds_information1_o =>per_pds_shd.g_old_rec.pds_information1
445: ,p_pds_information2_o =>per_pds_shd.g_old_rec.pds_information2
446: ,p_pds_information3_o =>per_pds_shd.g_old_rec.pds_information3
447: ,p_pds_information4_o =>per_pds_shd.g_old_rec.pds_information4
448: ,p_pds_information5_o =>per_pds_shd.g_old_rec.pds_information5
449: ,p_pds_information6_o =>per_pds_shd.g_old_rec.pds_information6
442: ,p_prior_employmt_ssp_paid_to_o =>per_pds_shd.g_old_rec.prior_employment_ssp_paid_to
443: ,p_pds_information_category_o =>per_pds_shd.g_old_rec.pds_information_category
444: ,p_pds_information1_o =>per_pds_shd.g_old_rec.pds_information1
445: ,p_pds_information2_o =>per_pds_shd.g_old_rec.pds_information2
446: ,p_pds_information3_o =>per_pds_shd.g_old_rec.pds_information3
447: ,p_pds_information4_o =>per_pds_shd.g_old_rec.pds_information4
448: ,p_pds_information5_o =>per_pds_shd.g_old_rec.pds_information5
449: ,p_pds_information6_o =>per_pds_shd.g_old_rec.pds_information6
450: ,p_pds_information7_o =>per_pds_shd.g_old_rec.pds_information7
443: ,p_pds_information_category_o =>per_pds_shd.g_old_rec.pds_information_category
444: ,p_pds_information1_o =>per_pds_shd.g_old_rec.pds_information1
445: ,p_pds_information2_o =>per_pds_shd.g_old_rec.pds_information2
446: ,p_pds_information3_o =>per_pds_shd.g_old_rec.pds_information3
447: ,p_pds_information4_o =>per_pds_shd.g_old_rec.pds_information4
448: ,p_pds_information5_o =>per_pds_shd.g_old_rec.pds_information5
449: ,p_pds_information6_o =>per_pds_shd.g_old_rec.pds_information6
450: ,p_pds_information7_o =>per_pds_shd.g_old_rec.pds_information7
451: ,p_pds_information8_o =>per_pds_shd.g_old_rec.pds_information8
444: ,p_pds_information1_o =>per_pds_shd.g_old_rec.pds_information1
445: ,p_pds_information2_o =>per_pds_shd.g_old_rec.pds_information2
446: ,p_pds_information3_o =>per_pds_shd.g_old_rec.pds_information3
447: ,p_pds_information4_o =>per_pds_shd.g_old_rec.pds_information4
448: ,p_pds_information5_o =>per_pds_shd.g_old_rec.pds_information5
449: ,p_pds_information6_o =>per_pds_shd.g_old_rec.pds_information6
450: ,p_pds_information7_o =>per_pds_shd.g_old_rec.pds_information7
451: ,p_pds_information8_o =>per_pds_shd.g_old_rec.pds_information8
452: ,p_pds_information9_o =>per_pds_shd.g_old_rec.pds_information9
445: ,p_pds_information2_o =>per_pds_shd.g_old_rec.pds_information2
446: ,p_pds_information3_o =>per_pds_shd.g_old_rec.pds_information3
447: ,p_pds_information4_o =>per_pds_shd.g_old_rec.pds_information4
448: ,p_pds_information5_o =>per_pds_shd.g_old_rec.pds_information5
449: ,p_pds_information6_o =>per_pds_shd.g_old_rec.pds_information6
450: ,p_pds_information7_o =>per_pds_shd.g_old_rec.pds_information7
451: ,p_pds_information8_o =>per_pds_shd.g_old_rec.pds_information8
452: ,p_pds_information9_o =>per_pds_shd.g_old_rec.pds_information9
453: ,p_pds_information10_o =>per_pds_shd.g_old_rec.pds_information10
446: ,p_pds_information3_o =>per_pds_shd.g_old_rec.pds_information3
447: ,p_pds_information4_o =>per_pds_shd.g_old_rec.pds_information4
448: ,p_pds_information5_o =>per_pds_shd.g_old_rec.pds_information5
449: ,p_pds_information6_o =>per_pds_shd.g_old_rec.pds_information6
450: ,p_pds_information7_o =>per_pds_shd.g_old_rec.pds_information7
451: ,p_pds_information8_o =>per_pds_shd.g_old_rec.pds_information8
452: ,p_pds_information9_o =>per_pds_shd.g_old_rec.pds_information9
453: ,p_pds_information10_o =>per_pds_shd.g_old_rec.pds_information10
454: ,p_pds_information11_o =>per_pds_shd.g_old_rec.pds_information11
447: ,p_pds_information4_o =>per_pds_shd.g_old_rec.pds_information4
448: ,p_pds_information5_o =>per_pds_shd.g_old_rec.pds_information5
449: ,p_pds_information6_o =>per_pds_shd.g_old_rec.pds_information6
450: ,p_pds_information7_o =>per_pds_shd.g_old_rec.pds_information7
451: ,p_pds_information8_o =>per_pds_shd.g_old_rec.pds_information8
452: ,p_pds_information9_o =>per_pds_shd.g_old_rec.pds_information9
453: ,p_pds_information10_o =>per_pds_shd.g_old_rec.pds_information10
454: ,p_pds_information11_o =>per_pds_shd.g_old_rec.pds_information11
455: ,p_pds_information12_o =>per_pds_shd.g_old_rec.pds_information12
448: ,p_pds_information5_o =>per_pds_shd.g_old_rec.pds_information5
449: ,p_pds_information6_o =>per_pds_shd.g_old_rec.pds_information6
450: ,p_pds_information7_o =>per_pds_shd.g_old_rec.pds_information7
451: ,p_pds_information8_o =>per_pds_shd.g_old_rec.pds_information8
452: ,p_pds_information9_o =>per_pds_shd.g_old_rec.pds_information9
453: ,p_pds_information10_o =>per_pds_shd.g_old_rec.pds_information10
454: ,p_pds_information11_o =>per_pds_shd.g_old_rec.pds_information11
455: ,p_pds_information12_o =>per_pds_shd.g_old_rec.pds_information12
456: ,p_pds_information13_o =>per_pds_shd.g_old_rec.pds_information13
449: ,p_pds_information6_o =>per_pds_shd.g_old_rec.pds_information6
450: ,p_pds_information7_o =>per_pds_shd.g_old_rec.pds_information7
451: ,p_pds_information8_o =>per_pds_shd.g_old_rec.pds_information8
452: ,p_pds_information9_o =>per_pds_shd.g_old_rec.pds_information9
453: ,p_pds_information10_o =>per_pds_shd.g_old_rec.pds_information10
454: ,p_pds_information11_o =>per_pds_shd.g_old_rec.pds_information11
455: ,p_pds_information12_o =>per_pds_shd.g_old_rec.pds_information12
456: ,p_pds_information13_o =>per_pds_shd.g_old_rec.pds_information13
457: ,p_pds_information14_o =>per_pds_shd.g_old_rec.pds_information14
450: ,p_pds_information7_o =>per_pds_shd.g_old_rec.pds_information7
451: ,p_pds_information8_o =>per_pds_shd.g_old_rec.pds_information8
452: ,p_pds_information9_o =>per_pds_shd.g_old_rec.pds_information9
453: ,p_pds_information10_o =>per_pds_shd.g_old_rec.pds_information10
454: ,p_pds_information11_o =>per_pds_shd.g_old_rec.pds_information11
455: ,p_pds_information12_o =>per_pds_shd.g_old_rec.pds_information12
456: ,p_pds_information13_o =>per_pds_shd.g_old_rec.pds_information13
457: ,p_pds_information14_o =>per_pds_shd.g_old_rec.pds_information14
458: ,p_pds_information15_o =>per_pds_shd.g_old_rec.pds_information15
451: ,p_pds_information8_o =>per_pds_shd.g_old_rec.pds_information8
452: ,p_pds_information9_o =>per_pds_shd.g_old_rec.pds_information9
453: ,p_pds_information10_o =>per_pds_shd.g_old_rec.pds_information10
454: ,p_pds_information11_o =>per_pds_shd.g_old_rec.pds_information11
455: ,p_pds_information12_o =>per_pds_shd.g_old_rec.pds_information12
456: ,p_pds_information13_o =>per_pds_shd.g_old_rec.pds_information13
457: ,p_pds_information14_o =>per_pds_shd.g_old_rec.pds_information14
458: ,p_pds_information15_o =>per_pds_shd.g_old_rec.pds_information15
459: ,p_pds_information16_o =>per_pds_shd.g_old_rec.pds_information16
452: ,p_pds_information9_o =>per_pds_shd.g_old_rec.pds_information9
453: ,p_pds_information10_o =>per_pds_shd.g_old_rec.pds_information10
454: ,p_pds_information11_o =>per_pds_shd.g_old_rec.pds_information11
455: ,p_pds_information12_o =>per_pds_shd.g_old_rec.pds_information12
456: ,p_pds_information13_o =>per_pds_shd.g_old_rec.pds_information13
457: ,p_pds_information14_o =>per_pds_shd.g_old_rec.pds_information14
458: ,p_pds_information15_o =>per_pds_shd.g_old_rec.pds_information15
459: ,p_pds_information16_o =>per_pds_shd.g_old_rec.pds_information16
460: ,p_pds_information17_o =>per_pds_shd.g_old_rec.pds_information17
453: ,p_pds_information10_o =>per_pds_shd.g_old_rec.pds_information10
454: ,p_pds_information11_o =>per_pds_shd.g_old_rec.pds_information11
455: ,p_pds_information12_o =>per_pds_shd.g_old_rec.pds_information12
456: ,p_pds_information13_o =>per_pds_shd.g_old_rec.pds_information13
457: ,p_pds_information14_o =>per_pds_shd.g_old_rec.pds_information14
458: ,p_pds_information15_o =>per_pds_shd.g_old_rec.pds_information15
459: ,p_pds_information16_o =>per_pds_shd.g_old_rec.pds_information16
460: ,p_pds_information17_o =>per_pds_shd.g_old_rec.pds_information17
461: ,p_pds_information18_o =>per_pds_shd.g_old_rec.pds_information18
454: ,p_pds_information11_o =>per_pds_shd.g_old_rec.pds_information11
455: ,p_pds_information12_o =>per_pds_shd.g_old_rec.pds_information12
456: ,p_pds_information13_o =>per_pds_shd.g_old_rec.pds_information13
457: ,p_pds_information14_o =>per_pds_shd.g_old_rec.pds_information14
458: ,p_pds_information15_o =>per_pds_shd.g_old_rec.pds_information15
459: ,p_pds_information16_o =>per_pds_shd.g_old_rec.pds_information16
460: ,p_pds_information17_o =>per_pds_shd.g_old_rec.pds_information17
461: ,p_pds_information18_o =>per_pds_shd.g_old_rec.pds_information18
462: ,p_pds_information19_o =>per_pds_shd.g_old_rec.pds_information19
455: ,p_pds_information12_o =>per_pds_shd.g_old_rec.pds_information12
456: ,p_pds_information13_o =>per_pds_shd.g_old_rec.pds_information13
457: ,p_pds_information14_o =>per_pds_shd.g_old_rec.pds_information14
458: ,p_pds_information15_o =>per_pds_shd.g_old_rec.pds_information15
459: ,p_pds_information16_o =>per_pds_shd.g_old_rec.pds_information16
460: ,p_pds_information17_o =>per_pds_shd.g_old_rec.pds_information17
461: ,p_pds_information18_o =>per_pds_shd.g_old_rec.pds_information18
462: ,p_pds_information19_o =>per_pds_shd.g_old_rec.pds_information19
463: ,p_pds_information20_o =>per_pds_shd.g_old_rec.pds_information20
456: ,p_pds_information13_o =>per_pds_shd.g_old_rec.pds_information13
457: ,p_pds_information14_o =>per_pds_shd.g_old_rec.pds_information14
458: ,p_pds_information15_o =>per_pds_shd.g_old_rec.pds_information15
459: ,p_pds_information16_o =>per_pds_shd.g_old_rec.pds_information16
460: ,p_pds_information17_o =>per_pds_shd.g_old_rec.pds_information17
461: ,p_pds_information18_o =>per_pds_shd.g_old_rec.pds_information18
462: ,p_pds_information19_o =>per_pds_shd.g_old_rec.pds_information19
463: ,p_pds_information20_o =>per_pds_shd.g_old_rec.pds_information20
464: ,p_pds_information21_o =>per_pds_shd.g_old_rec.pds_information21
457: ,p_pds_information14_o =>per_pds_shd.g_old_rec.pds_information14
458: ,p_pds_information15_o =>per_pds_shd.g_old_rec.pds_information15
459: ,p_pds_information16_o =>per_pds_shd.g_old_rec.pds_information16
460: ,p_pds_information17_o =>per_pds_shd.g_old_rec.pds_information17
461: ,p_pds_information18_o =>per_pds_shd.g_old_rec.pds_information18
462: ,p_pds_information19_o =>per_pds_shd.g_old_rec.pds_information19
463: ,p_pds_information20_o =>per_pds_shd.g_old_rec.pds_information20
464: ,p_pds_information21_o =>per_pds_shd.g_old_rec.pds_information21
465: ,p_pds_information22_o =>per_pds_shd.g_old_rec.pds_information22
458: ,p_pds_information15_o =>per_pds_shd.g_old_rec.pds_information15
459: ,p_pds_information16_o =>per_pds_shd.g_old_rec.pds_information16
460: ,p_pds_information17_o =>per_pds_shd.g_old_rec.pds_information17
461: ,p_pds_information18_o =>per_pds_shd.g_old_rec.pds_information18
462: ,p_pds_information19_o =>per_pds_shd.g_old_rec.pds_information19
463: ,p_pds_information20_o =>per_pds_shd.g_old_rec.pds_information20
464: ,p_pds_information21_o =>per_pds_shd.g_old_rec.pds_information21
465: ,p_pds_information22_o =>per_pds_shd.g_old_rec.pds_information22
466: ,p_pds_information23_o =>per_pds_shd.g_old_rec.pds_information23
459: ,p_pds_information16_o =>per_pds_shd.g_old_rec.pds_information16
460: ,p_pds_information17_o =>per_pds_shd.g_old_rec.pds_information17
461: ,p_pds_information18_o =>per_pds_shd.g_old_rec.pds_information18
462: ,p_pds_information19_o =>per_pds_shd.g_old_rec.pds_information19
463: ,p_pds_information20_o =>per_pds_shd.g_old_rec.pds_information20
464: ,p_pds_information21_o =>per_pds_shd.g_old_rec.pds_information21
465: ,p_pds_information22_o =>per_pds_shd.g_old_rec.pds_information22
466: ,p_pds_information23_o =>per_pds_shd.g_old_rec.pds_information23
467: ,p_pds_information24_o =>per_pds_shd.g_old_rec.pds_information24
460: ,p_pds_information17_o =>per_pds_shd.g_old_rec.pds_information17
461: ,p_pds_information18_o =>per_pds_shd.g_old_rec.pds_information18
462: ,p_pds_information19_o =>per_pds_shd.g_old_rec.pds_information19
463: ,p_pds_information20_o =>per_pds_shd.g_old_rec.pds_information20
464: ,p_pds_information21_o =>per_pds_shd.g_old_rec.pds_information21
465: ,p_pds_information22_o =>per_pds_shd.g_old_rec.pds_information22
466: ,p_pds_information23_o =>per_pds_shd.g_old_rec.pds_information23
467: ,p_pds_information24_o =>per_pds_shd.g_old_rec.pds_information24
468: ,p_pds_information25_o =>per_pds_shd.g_old_rec.pds_information25
461: ,p_pds_information18_o =>per_pds_shd.g_old_rec.pds_information18
462: ,p_pds_information19_o =>per_pds_shd.g_old_rec.pds_information19
463: ,p_pds_information20_o =>per_pds_shd.g_old_rec.pds_information20
464: ,p_pds_information21_o =>per_pds_shd.g_old_rec.pds_information21
465: ,p_pds_information22_o =>per_pds_shd.g_old_rec.pds_information22
466: ,p_pds_information23_o =>per_pds_shd.g_old_rec.pds_information23
467: ,p_pds_information24_o =>per_pds_shd.g_old_rec.pds_information24
468: ,p_pds_information25_o =>per_pds_shd.g_old_rec.pds_information25
469: ,p_pds_information26_o =>per_pds_shd.g_old_rec.pds_information26
462: ,p_pds_information19_o =>per_pds_shd.g_old_rec.pds_information19
463: ,p_pds_information20_o =>per_pds_shd.g_old_rec.pds_information20
464: ,p_pds_information21_o =>per_pds_shd.g_old_rec.pds_information21
465: ,p_pds_information22_o =>per_pds_shd.g_old_rec.pds_information22
466: ,p_pds_information23_o =>per_pds_shd.g_old_rec.pds_information23
467: ,p_pds_information24_o =>per_pds_shd.g_old_rec.pds_information24
468: ,p_pds_information25_o =>per_pds_shd.g_old_rec.pds_information25
469: ,p_pds_information26_o =>per_pds_shd.g_old_rec.pds_information26
470: ,p_pds_information27_o =>per_pds_shd.g_old_rec.pds_information27
463: ,p_pds_information20_o =>per_pds_shd.g_old_rec.pds_information20
464: ,p_pds_information21_o =>per_pds_shd.g_old_rec.pds_information21
465: ,p_pds_information22_o =>per_pds_shd.g_old_rec.pds_information22
466: ,p_pds_information23_o =>per_pds_shd.g_old_rec.pds_information23
467: ,p_pds_information24_o =>per_pds_shd.g_old_rec.pds_information24
468: ,p_pds_information25_o =>per_pds_shd.g_old_rec.pds_information25
469: ,p_pds_information26_o =>per_pds_shd.g_old_rec.pds_information26
470: ,p_pds_information27_o =>per_pds_shd.g_old_rec.pds_information27
471: ,p_pds_information28_o =>per_pds_shd.g_old_rec.pds_information28
464: ,p_pds_information21_o =>per_pds_shd.g_old_rec.pds_information21
465: ,p_pds_information22_o =>per_pds_shd.g_old_rec.pds_information22
466: ,p_pds_information23_o =>per_pds_shd.g_old_rec.pds_information23
467: ,p_pds_information24_o =>per_pds_shd.g_old_rec.pds_information24
468: ,p_pds_information25_o =>per_pds_shd.g_old_rec.pds_information25
469: ,p_pds_information26_o =>per_pds_shd.g_old_rec.pds_information26
470: ,p_pds_information27_o =>per_pds_shd.g_old_rec.pds_information27
471: ,p_pds_information28_o =>per_pds_shd.g_old_rec.pds_information28
472: ,p_pds_information29_o =>per_pds_shd.g_old_rec.pds_information29
465: ,p_pds_information22_o =>per_pds_shd.g_old_rec.pds_information22
466: ,p_pds_information23_o =>per_pds_shd.g_old_rec.pds_information23
467: ,p_pds_information24_o =>per_pds_shd.g_old_rec.pds_information24
468: ,p_pds_information25_o =>per_pds_shd.g_old_rec.pds_information25
469: ,p_pds_information26_o =>per_pds_shd.g_old_rec.pds_information26
470: ,p_pds_information27_o =>per_pds_shd.g_old_rec.pds_information27
471: ,p_pds_information28_o =>per_pds_shd.g_old_rec.pds_information28
472: ,p_pds_information29_o =>per_pds_shd.g_old_rec.pds_information29
473: ,p_pds_information30_o =>per_pds_shd.g_old_rec.pds_information30
466: ,p_pds_information23_o =>per_pds_shd.g_old_rec.pds_information23
467: ,p_pds_information24_o =>per_pds_shd.g_old_rec.pds_information24
468: ,p_pds_information25_o =>per_pds_shd.g_old_rec.pds_information25
469: ,p_pds_information26_o =>per_pds_shd.g_old_rec.pds_information26
470: ,p_pds_information27_o =>per_pds_shd.g_old_rec.pds_information27
471: ,p_pds_information28_o =>per_pds_shd.g_old_rec.pds_information28
472: ,p_pds_information29_o =>per_pds_shd.g_old_rec.pds_information29
473: ,p_pds_information30_o =>per_pds_shd.g_old_rec.pds_information30
474: );
467: ,p_pds_information24_o =>per_pds_shd.g_old_rec.pds_information24
468: ,p_pds_information25_o =>per_pds_shd.g_old_rec.pds_information25
469: ,p_pds_information26_o =>per_pds_shd.g_old_rec.pds_information26
470: ,p_pds_information27_o =>per_pds_shd.g_old_rec.pds_information27
471: ,p_pds_information28_o =>per_pds_shd.g_old_rec.pds_information28
472: ,p_pds_information29_o =>per_pds_shd.g_old_rec.pds_information29
473: ,p_pds_information30_o =>per_pds_shd.g_old_rec.pds_information30
474: );
475: --
468: ,p_pds_information25_o =>per_pds_shd.g_old_rec.pds_information25
469: ,p_pds_information26_o =>per_pds_shd.g_old_rec.pds_information26
470: ,p_pds_information27_o =>per_pds_shd.g_old_rec.pds_information27
471: ,p_pds_information28_o =>per_pds_shd.g_old_rec.pds_information28
472: ,p_pds_information29_o =>per_pds_shd.g_old_rec.pds_information29
473: ,p_pds_information30_o =>per_pds_shd.g_old_rec.pds_information30
474: );
475: --
476: exception
469: ,p_pds_information26_o =>per_pds_shd.g_old_rec.pds_information26
470: ,p_pds_information27_o =>per_pds_shd.g_old_rec.pds_information27
471: ,p_pds_information28_o =>per_pds_shd.g_old_rec.pds_information28
472: ,p_pds_information29_o =>per_pds_shd.g_old_rec.pds_information29
473: ,p_pds_information30_o =>per_pds_shd.g_old_rec.pds_information30
474: );
475: --
476: exception
477: when hr_api.cannot_find_prog_unit then
527: -- Internal Table Handler Use Only.
528: --
529: -- {End Of Comments}
530: -- ----------------------------------------------------------------------------
531: Procedure convert_defs(p_rec in out nocopy per_pds_shd.g_rec_type) is
532: --
533: l_proc varchar2(72) := g_package||'convert_defs';
534: --
535: Begin
542: -- is being used then we must set to the 'current' argument value.
543: --
544: If (p_rec.business_group_id = hr_api.g_number) then
545: p_rec.business_group_id :=
546: per_pds_shd.g_old_rec.business_group_id;
547: End If;
548: If (p_rec.termination_accepted_person_id = hr_api.g_number) then
549: p_rec.termination_accepted_person_id :=
550: per_pds_shd.g_old_rec.termination_accepted_person_id;
546: per_pds_shd.g_old_rec.business_group_id;
547: End If;
548: If (p_rec.termination_accepted_person_id = hr_api.g_number) then
549: p_rec.termination_accepted_person_id :=
550: per_pds_shd.g_old_rec.termination_accepted_person_id;
551: End If;
552: If (p_rec.person_id = hr_api.g_number) then
553: p_rec.person_id :=
554: per_pds_shd.g_old_rec.person_id;
550: per_pds_shd.g_old_rec.termination_accepted_person_id;
551: End If;
552: If (p_rec.person_id = hr_api.g_number) then
553: p_rec.person_id :=
554: per_pds_shd.g_old_rec.person_id;
555: End If;
556: If (p_rec.date_start = hr_api.g_date) then
557: p_rec.date_start :=
558: per_pds_shd.g_old_rec.date_start;
554: per_pds_shd.g_old_rec.person_id;
555: End If;
556: If (p_rec.date_start = hr_api.g_date) then
557: p_rec.date_start :=
558: per_pds_shd.g_old_rec.date_start;
559: End If;
560: If (p_rec.accepted_termination_date = hr_api.g_date) then
561: p_rec.accepted_termination_date :=
562: per_pds_shd.g_old_rec.accepted_termination_date;
558: per_pds_shd.g_old_rec.date_start;
559: End If;
560: If (p_rec.accepted_termination_date = hr_api.g_date) then
561: p_rec.accepted_termination_date :=
562: per_pds_shd.g_old_rec.accepted_termination_date;
563: End If;
564: If (p_rec.actual_termination_date = hr_api.g_date) then
565: p_rec.actual_termination_date :=
566: per_pds_shd.g_old_rec.actual_termination_date;
562: per_pds_shd.g_old_rec.accepted_termination_date;
563: End If;
564: If (p_rec.actual_termination_date = hr_api.g_date) then
565: p_rec.actual_termination_date :=
566: per_pds_shd.g_old_rec.actual_termination_date;
567: End If;
568: If (p_rec.comments = hr_api.g_varchar2) then
569: p_rec.comments :=
570: per_pds_shd.g_old_rec.comments;
566: per_pds_shd.g_old_rec.actual_termination_date;
567: End If;
568: If (p_rec.comments = hr_api.g_varchar2) then
569: p_rec.comments :=
570: per_pds_shd.g_old_rec.comments;
571: End If;
572: If (p_rec.final_process_date = hr_api.g_date) then
573: p_rec.final_process_date :=
574: per_pds_shd.g_old_rec.final_process_date;
570: per_pds_shd.g_old_rec.comments;
571: End If;
572: If (p_rec.final_process_date = hr_api.g_date) then
573: p_rec.final_process_date :=
574: per_pds_shd.g_old_rec.final_process_date;
575: End If;
576: If (p_rec.last_standard_process_date = hr_api.g_date) then
577: p_rec.last_standard_process_date :=
578: per_pds_shd.g_old_rec.last_standard_process_date;
574: per_pds_shd.g_old_rec.final_process_date;
575: End If;
576: If (p_rec.last_standard_process_date = hr_api.g_date) then
577: p_rec.last_standard_process_date :=
578: per_pds_shd.g_old_rec.last_standard_process_date;
579: End If;
580: If (p_rec.leaving_reason = hr_api.g_varchar2) then
581: p_rec.leaving_reason :=
582: per_pds_shd.g_old_rec.leaving_reason;
578: per_pds_shd.g_old_rec.last_standard_process_date;
579: End If;
580: If (p_rec.leaving_reason = hr_api.g_varchar2) then
581: p_rec.leaving_reason :=
582: per_pds_shd.g_old_rec.leaving_reason;
583: End If;
584: If (p_rec.notified_termination_date = hr_api.g_date) then
585: p_rec.notified_termination_date :=
586: per_pds_shd.g_old_rec.notified_termination_date;
582: per_pds_shd.g_old_rec.leaving_reason;
583: End If;
584: If (p_rec.notified_termination_date = hr_api.g_date) then
585: p_rec.notified_termination_date :=
586: per_pds_shd.g_old_rec.notified_termination_date;
587: End If;
588: If (p_rec.projected_termination_date = hr_api.g_date) then
589: p_rec.projected_termination_date :=
590: per_pds_shd.g_old_rec.projected_termination_date;
586: per_pds_shd.g_old_rec.notified_termination_date;
587: End If;
588: If (p_rec.projected_termination_date = hr_api.g_date) then
589: p_rec.projected_termination_date :=
590: per_pds_shd.g_old_rec.projected_termination_date;
591: End If;
592: If (p_rec.adjusted_svc_date = hr_api.g_date) then
593: p_rec.adjusted_svc_date :=
594: per_pds_shd.g_old_rec.adjusted_svc_date;
590: per_pds_shd.g_old_rec.projected_termination_date;
591: End If;
592: If (p_rec.adjusted_svc_date = hr_api.g_date) then
593: p_rec.adjusted_svc_date :=
594: per_pds_shd.g_old_rec.adjusted_svc_date;
595: End If;
596: If (p_rec.request_id = hr_api.g_number) then
597: p_rec.request_id :=
598: per_pds_shd.g_old_rec.request_id;
594: per_pds_shd.g_old_rec.adjusted_svc_date;
595: End If;
596: If (p_rec.request_id = hr_api.g_number) then
597: p_rec.request_id :=
598: per_pds_shd.g_old_rec.request_id;
599: End If;
600: If (p_rec.program_application_id = hr_api.g_number) then
601: p_rec.program_application_id :=
602: per_pds_shd.g_old_rec.program_application_id;
598: per_pds_shd.g_old_rec.request_id;
599: End If;
600: If (p_rec.program_application_id = hr_api.g_number) then
601: p_rec.program_application_id :=
602: per_pds_shd.g_old_rec.program_application_id;
603: End If;
604: If (p_rec.program_id = hr_api.g_number) then
605: p_rec.program_id :=
606: per_pds_shd.g_old_rec.program_id;
602: per_pds_shd.g_old_rec.program_application_id;
603: End If;
604: If (p_rec.program_id = hr_api.g_number) then
605: p_rec.program_id :=
606: per_pds_shd.g_old_rec.program_id;
607: End If;
608: If (p_rec.program_update_date = hr_api.g_date) then
609: p_rec.program_update_date :=
610: per_pds_shd.g_old_rec.program_update_date;
606: per_pds_shd.g_old_rec.program_id;
607: End If;
608: If (p_rec.program_update_date = hr_api.g_date) then
609: p_rec.program_update_date :=
610: per_pds_shd.g_old_rec.program_update_date;
611: End If;
612: If (p_rec.attribute_category = hr_api.g_varchar2) then
613: p_rec.attribute_category :=
614: per_pds_shd.g_old_rec.attribute_category;
610: per_pds_shd.g_old_rec.program_update_date;
611: End If;
612: If (p_rec.attribute_category = hr_api.g_varchar2) then
613: p_rec.attribute_category :=
614: per_pds_shd.g_old_rec.attribute_category;
615: End If;
616: If (p_rec.attribute1 = hr_api.g_varchar2) then
617: p_rec.attribute1 :=
618: per_pds_shd.g_old_rec.attribute1;
614: per_pds_shd.g_old_rec.attribute_category;
615: End If;
616: If (p_rec.attribute1 = hr_api.g_varchar2) then
617: p_rec.attribute1 :=
618: per_pds_shd.g_old_rec.attribute1;
619: End If;
620: If (p_rec.attribute2 = hr_api.g_varchar2) then
621: p_rec.attribute2 :=
622: per_pds_shd.g_old_rec.attribute2;
618: per_pds_shd.g_old_rec.attribute1;
619: End If;
620: If (p_rec.attribute2 = hr_api.g_varchar2) then
621: p_rec.attribute2 :=
622: per_pds_shd.g_old_rec.attribute2;
623: End If;
624: If (p_rec.attribute3 = hr_api.g_varchar2) then
625: p_rec.attribute3 :=
626: per_pds_shd.g_old_rec.attribute3;
622: per_pds_shd.g_old_rec.attribute2;
623: End If;
624: If (p_rec.attribute3 = hr_api.g_varchar2) then
625: p_rec.attribute3 :=
626: per_pds_shd.g_old_rec.attribute3;
627: End If;
628: If (p_rec.attribute4 = hr_api.g_varchar2) then
629: p_rec.attribute4 :=
630: per_pds_shd.g_old_rec.attribute4;
626: per_pds_shd.g_old_rec.attribute3;
627: End If;
628: If (p_rec.attribute4 = hr_api.g_varchar2) then
629: p_rec.attribute4 :=
630: per_pds_shd.g_old_rec.attribute4;
631: End If;
632: If (p_rec.attribute5 = hr_api.g_varchar2) then
633: p_rec.attribute5 :=
634: per_pds_shd.g_old_rec.attribute5;
630: per_pds_shd.g_old_rec.attribute4;
631: End If;
632: If (p_rec.attribute5 = hr_api.g_varchar2) then
633: p_rec.attribute5 :=
634: per_pds_shd.g_old_rec.attribute5;
635: End If;
636: If (p_rec.attribute6 = hr_api.g_varchar2) then
637: p_rec.attribute6 :=
638: per_pds_shd.g_old_rec.attribute6;
634: per_pds_shd.g_old_rec.attribute5;
635: End If;
636: If (p_rec.attribute6 = hr_api.g_varchar2) then
637: p_rec.attribute6 :=
638: per_pds_shd.g_old_rec.attribute6;
639: End If;
640: If (p_rec.attribute7 = hr_api.g_varchar2) then
641: p_rec.attribute7 :=
642: per_pds_shd.g_old_rec.attribute7;
638: per_pds_shd.g_old_rec.attribute6;
639: End If;
640: If (p_rec.attribute7 = hr_api.g_varchar2) then
641: p_rec.attribute7 :=
642: per_pds_shd.g_old_rec.attribute7;
643: End If;
644: If (p_rec.attribute8 = hr_api.g_varchar2) then
645: p_rec.attribute8 :=
646: per_pds_shd.g_old_rec.attribute8;
642: per_pds_shd.g_old_rec.attribute7;
643: End If;
644: If (p_rec.attribute8 = hr_api.g_varchar2) then
645: p_rec.attribute8 :=
646: per_pds_shd.g_old_rec.attribute8;
647: End If;
648: If (p_rec.attribute9 = hr_api.g_varchar2) then
649: p_rec.attribute9 :=
650: per_pds_shd.g_old_rec.attribute9;
646: per_pds_shd.g_old_rec.attribute8;
647: End If;
648: If (p_rec.attribute9 = hr_api.g_varchar2) then
649: p_rec.attribute9 :=
650: per_pds_shd.g_old_rec.attribute9;
651: End If;
652: If (p_rec.attribute10 = hr_api.g_varchar2) then
653: p_rec.attribute10 :=
654: per_pds_shd.g_old_rec.attribute10;
650: per_pds_shd.g_old_rec.attribute9;
651: End If;
652: If (p_rec.attribute10 = hr_api.g_varchar2) then
653: p_rec.attribute10 :=
654: per_pds_shd.g_old_rec.attribute10;
655: End If;
656: If (p_rec.attribute11 = hr_api.g_varchar2) then
657: p_rec.attribute11 :=
658: per_pds_shd.g_old_rec.attribute11;
654: per_pds_shd.g_old_rec.attribute10;
655: End If;
656: If (p_rec.attribute11 = hr_api.g_varchar2) then
657: p_rec.attribute11 :=
658: per_pds_shd.g_old_rec.attribute11;
659: End If;
660: If (p_rec.attribute12 = hr_api.g_varchar2) then
661: p_rec.attribute12 :=
662: per_pds_shd.g_old_rec.attribute12;
658: per_pds_shd.g_old_rec.attribute11;
659: End If;
660: If (p_rec.attribute12 = hr_api.g_varchar2) then
661: p_rec.attribute12 :=
662: per_pds_shd.g_old_rec.attribute12;
663: End If;
664: If (p_rec.attribute13 = hr_api.g_varchar2) then
665: p_rec.attribute13 :=
666: per_pds_shd.g_old_rec.attribute13;
662: per_pds_shd.g_old_rec.attribute12;
663: End If;
664: If (p_rec.attribute13 = hr_api.g_varchar2) then
665: p_rec.attribute13 :=
666: per_pds_shd.g_old_rec.attribute13;
667: End If;
668: If (p_rec.attribute14 = hr_api.g_varchar2) then
669: p_rec.attribute14 :=
670: per_pds_shd.g_old_rec.attribute14;
666: per_pds_shd.g_old_rec.attribute13;
667: End If;
668: If (p_rec.attribute14 = hr_api.g_varchar2) then
669: p_rec.attribute14 :=
670: per_pds_shd.g_old_rec.attribute14;
671: End If;
672: If (p_rec.attribute15 = hr_api.g_varchar2) then
673: p_rec.attribute15 :=
674: per_pds_shd.g_old_rec.attribute15;
670: per_pds_shd.g_old_rec.attribute14;
671: End If;
672: If (p_rec.attribute15 = hr_api.g_varchar2) then
673: p_rec.attribute15 :=
674: per_pds_shd.g_old_rec.attribute15;
675: End If;
676: If (p_rec.attribute16 = hr_api.g_varchar2) then
677: p_rec.attribute16 :=
678: per_pds_shd.g_old_rec.attribute16;
674: per_pds_shd.g_old_rec.attribute15;
675: End If;
676: If (p_rec.attribute16 = hr_api.g_varchar2) then
677: p_rec.attribute16 :=
678: per_pds_shd.g_old_rec.attribute16;
679: End If;
680: If (p_rec.attribute17 = hr_api.g_varchar2) then
681: p_rec.attribute17 :=
682: per_pds_shd.g_old_rec.attribute17;
678: per_pds_shd.g_old_rec.attribute16;
679: End If;
680: If (p_rec.attribute17 = hr_api.g_varchar2) then
681: p_rec.attribute17 :=
682: per_pds_shd.g_old_rec.attribute17;
683: End If;
684: If (p_rec.attribute18 = hr_api.g_varchar2) then
685: p_rec.attribute18 :=
686: per_pds_shd.g_old_rec.attribute18;
682: per_pds_shd.g_old_rec.attribute17;
683: End If;
684: If (p_rec.attribute18 = hr_api.g_varchar2) then
685: p_rec.attribute18 :=
686: per_pds_shd.g_old_rec.attribute18;
687: End If;
688: If (p_rec.attribute19 = hr_api.g_varchar2) then
689: p_rec.attribute19 :=
690: per_pds_shd.g_old_rec.attribute19;
686: per_pds_shd.g_old_rec.attribute18;
687: End If;
688: If (p_rec.attribute19 = hr_api.g_varchar2) then
689: p_rec.attribute19 :=
690: per_pds_shd.g_old_rec.attribute19;
691: End If;
692: If (p_rec.attribute20 = hr_api.g_varchar2) then
693: p_rec.attribute20 :=
694: per_pds_shd.g_old_rec.attribute20;
690: per_pds_shd.g_old_rec.attribute19;
691: End If;
692: If (p_rec.attribute20 = hr_api.g_varchar2) then
693: p_rec.attribute20 :=
694: per_pds_shd.g_old_rec.attribute20;
695: End If;
696: If (p_rec.prior_employment_ssp_weeks = hr_api.g_number) then
697: p_rec.prior_employment_ssp_weeks :=
698: per_pds_shd.g_old_rec.prior_employment_ssp_weeks;
694: per_pds_shd.g_old_rec.attribute20;
695: End If;
696: If (p_rec.prior_employment_ssp_weeks = hr_api.g_number) then
697: p_rec.prior_employment_ssp_weeks :=
698: per_pds_shd.g_old_rec.prior_employment_ssp_weeks;
699: End If;
700: If (p_rec.prior_employment_ssp_paid_to = hr_api.g_date) then
701: p_rec.prior_employment_ssp_paid_to :=
702: per_pds_shd.g_old_rec.prior_employment_ssp_paid_to;
698: per_pds_shd.g_old_rec.prior_employment_ssp_weeks;
699: End If;
700: If (p_rec.prior_employment_ssp_paid_to = hr_api.g_date) then
701: p_rec.prior_employment_ssp_paid_to :=
702: per_pds_shd.g_old_rec.prior_employment_ssp_paid_to;
703: End If;
704: If (p_rec.pds_information_category = hr_api.g_varchar2) then
705: p_rec.pds_information_category :=
706: per_pds_shd.g_old_rec.pds_information_category;
702: per_pds_shd.g_old_rec.prior_employment_ssp_paid_to;
703: End If;
704: If (p_rec.pds_information_category = hr_api.g_varchar2) then
705: p_rec.pds_information_category :=
706: per_pds_shd.g_old_rec.pds_information_category;
707: End If;
708: If (p_rec.pds_information1 = hr_api.g_varchar2) then
709: p_rec.pds_information1 :=
710: per_pds_shd.g_old_rec.pds_information1;
706: per_pds_shd.g_old_rec.pds_information_category;
707: End If;
708: If (p_rec.pds_information1 = hr_api.g_varchar2) then
709: p_rec.pds_information1 :=
710: per_pds_shd.g_old_rec.pds_information1;
711: End If;
712: If (p_rec.pds_information2 = hr_api.g_varchar2) then
713: p_rec.pds_information2 :=
714: per_pds_shd.g_old_rec.pds_information2;
710: per_pds_shd.g_old_rec.pds_information1;
711: End If;
712: If (p_rec.pds_information2 = hr_api.g_varchar2) then
713: p_rec.pds_information2 :=
714: per_pds_shd.g_old_rec.pds_information2;
715: End If;
716: If (p_rec.pds_information3 = hr_api.g_varchar2) then
717: p_rec.pds_information3 :=
718: per_pds_shd.g_old_rec.pds_information3;
714: per_pds_shd.g_old_rec.pds_information2;
715: End If;
716: If (p_rec.pds_information3 = hr_api.g_varchar2) then
717: p_rec.pds_information3 :=
718: per_pds_shd.g_old_rec.pds_information3;
719: End If;
720: If (p_rec.pds_information4 = hr_api.g_varchar2) then
721: p_rec.pds_information4 :=
722: per_pds_shd.g_old_rec.pds_information4;
718: per_pds_shd.g_old_rec.pds_information3;
719: End If;
720: If (p_rec.pds_information4 = hr_api.g_varchar2) then
721: p_rec.pds_information4 :=
722: per_pds_shd.g_old_rec.pds_information4;
723: End If;
724: If (p_rec.pds_information5 = hr_api.g_varchar2) then
725: p_rec.pds_information5 :=
726: per_pds_shd.g_old_rec.pds_information5;
722: per_pds_shd.g_old_rec.pds_information4;
723: End If;
724: If (p_rec.pds_information5 = hr_api.g_varchar2) then
725: p_rec.pds_information5 :=
726: per_pds_shd.g_old_rec.pds_information5;
727: End If;
728: If (p_rec.pds_information6 = hr_api.g_varchar2) then
729: p_rec.pds_information6 :=
730: per_pds_shd.g_old_rec.pds_information6;
726: per_pds_shd.g_old_rec.pds_information5;
727: End If;
728: If (p_rec.pds_information6 = hr_api.g_varchar2) then
729: p_rec.pds_information6 :=
730: per_pds_shd.g_old_rec.pds_information6;
731: End If;
732: If (p_rec.pds_information7 = hr_api.g_varchar2) then
733: p_rec.pds_information7 :=
734: per_pds_shd.g_old_rec.pds_information7;
730: per_pds_shd.g_old_rec.pds_information6;
731: End If;
732: If (p_rec.pds_information7 = hr_api.g_varchar2) then
733: p_rec.pds_information7 :=
734: per_pds_shd.g_old_rec.pds_information7;
735: End If;
736: If (p_rec.pds_information8 = hr_api.g_varchar2) then
737: p_rec.pds_information8 :=
738: per_pds_shd.g_old_rec.pds_information8;
734: per_pds_shd.g_old_rec.pds_information7;
735: End If;
736: If (p_rec.pds_information8 = hr_api.g_varchar2) then
737: p_rec.pds_information8 :=
738: per_pds_shd.g_old_rec.pds_information8;
739: End If;
740: If (p_rec.pds_information9 = hr_api.g_varchar2) then
741: p_rec.pds_information9 :=
742: per_pds_shd.g_old_rec.pds_information9;
738: per_pds_shd.g_old_rec.pds_information8;
739: End If;
740: If (p_rec.pds_information9 = hr_api.g_varchar2) then
741: p_rec.pds_information9 :=
742: per_pds_shd.g_old_rec.pds_information9;
743: End If;
744: If (p_rec.pds_information10 = hr_api.g_varchar2) then
745: p_rec.pds_information10 :=
746: per_pds_shd.g_old_rec.pds_information10;
742: per_pds_shd.g_old_rec.pds_information9;
743: End If;
744: If (p_rec.pds_information10 = hr_api.g_varchar2) then
745: p_rec.pds_information10 :=
746: per_pds_shd.g_old_rec.pds_information10;
747: End If;
748: If (p_rec.pds_information11 = hr_api.g_varchar2) then
749: p_rec.pds_information11 :=
750: per_pds_shd.g_old_rec.pds_information11;
746: per_pds_shd.g_old_rec.pds_information10;
747: End If;
748: If (p_rec.pds_information11 = hr_api.g_varchar2) then
749: p_rec.pds_information11 :=
750: per_pds_shd.g_old_rec.pds_information11;
751: End If;
752: If (p_rec.pds_information12 = hr_api.g_varchar2) then
753: p_rec.pds_information12 :=
754: per_pds_shd.g_old_rec.pds_information12;
750: per_pds_shd.g_old_rec.pds_information11;
751: End If;
752: If (p_rec.pds_information12 = hr_api.g_varchar2) then
753: p_rec.pds_information12 :=
754: per_pds_shd.g_old_rec.pds_information12;
755: End If;
756: If (p_rec.pds_information13 = hr_api.g_varchar2) then
757: p_rec.pds_information13 :=
758: per_pds_shd.g_old_rec.pds_information13;
754: per_pds_shd.g_old_rec.pds_information12;
755: End If;
756: If (p_rec.pds_information13 = hr_api.g_varchar2) then
757: p_rec.pds_information13 :=
758: per_pds_shd.g_old_rec.pds_information13;
759: End If;
760: If (p_rec.pds_information14 = hr_api.g_varchar2) then
761: p_rec.pds_information14 :=
762: per_pds_shd.g_old_rec.pds_information14;
758: per_pds_shd.g_old_rec.pds_information13;
759: End If;
760: If (p_rec.pds_information14 = hr_api.g_varchar2) then
761: p_rec.pds_information14 :=
762: per_pds_shd.g_old_rec.pds_information14;
763: End If;
764: If (p_rec.pds_information15 = hr_api.g_varchar2) then
765: p_rec.pds_information15 :=
766: per_pds_shd.g_old_rec.pds_information15;
762: per_pds_shd.g_old_rec.pds_information14;
763: End If;
764: If (p_rec.pds_information15 = hr_api.g_varchar2) then
765: p_rec.pds_information15 :=
766: per_pds_shd.g_old_rec.pds_information15;
767: End If;
768: If (p_rec.pds_information16 = hr_api.g_varchar2) then
769: p_rec.pds_information16 :=
770: per_pds_shd.g_old_rec.pds_information16;
766: per_pds_shd.g_old_rec.pds_information15;
767: End If;
768: If (p_rec.pds_information16 = hr_api.g_varchar2) then
769: p_rec.pds_information16 :=
770: per_pds_shd.g_old_rec.pds_information16;
771: End If;
772: If (p_rec.pds_information17 = hr_api.g_varchar2) then
773: p_rec.pds_information17 :=
774: per_pds_shd.g_old_rec.pds_information17;
770: per_pds_shd.g_old_rec.pds_information16;
771: End If;
772: If (p_rec.pds_information17 = hr_api.g_varchar2) then
773: p_rec.pds_information17 :=
774: per_pds_shd.g_old_rec.pds_information17;
775: End If;
776: If (p_rec.pds_information18 = hr_api.g_varchar2) then
777: p_rec.pds_information18 :=
778: per_pds_shd.g_old_rec.pds_information18;
774: per_pds_shd.g_old_rec.pds_information17;
775: End If;
776: If (p_rec.pds_information18 = hr_api.g_varchar2) then
777: p_rec.pds_information18 :=
778: per_pds_shd.g_old_rec.pds_information18;
779: End If;
780: If (p_rec.pds_information19 = hr_api.g_varchar2) then
781: p_rec.pds_information19 :=
782: per_pds_shd.g_old_rec.pds_information19;
778: per_pds_shd.g_old_rec.pds_information18;
779: End If;
780: If (p_rec.pds_information19 = hr_api.g_varchar2) then
781: p_rec.pds_information19 :=
782: per_pds_shd.g_old_rec.pds_information19;
783: End If;
784: If (p_rec.pds_information20 = hr_api.g_varchar2) then
785: p_rec.pds_information20 :=
786: per_pds_shd.g_old_rec.pds_information20;
782: per_pds_shd.g_old_rec.pds_information19;
783: End If;
784: If (p_rec.pds_information20 = hr_api.g_varchar2) then
785: p_rec.pds_information20 :=
786: per_pds_shd.g_old_rec.pds_information20;
787: End If;
788: If (p_rec.pds_information21 = hr_api.g_varchar2) then
789: p_rec.pds_information21 :=
790: per_pds_shd.g_old_rec.pds_information21;
786: per_pds_shd.g_old_rec.pds_information20;
787: End If;
788: If (p_rec.pds_information21 = hr_api.g_varchar2) then
789: p_rec.pds_information21 :=
790: per_pds_shd.g_old_rec.pds_information21;
791: End If;
792: If (p_rec.pds_information22 = hr_api.g_varchar2) then
793: p_rec.pds_information22 :=
794: per_pds_shd.g_old_rec.pds_information22;
790: per_pds_shd.g_old_rec.pds_information21;
791: End If;
792: If (p_rec.pds_information22 = hr_api.g_varchar2) then
793: p_rec.pds_information22 :=
794: per_pds_shd.g_old_rec.pds_information22;
795: End If;
796: If (p_rec.pds_information23 = hr_api.g_varchar2) then
797: p_rec.pds_information23 :=
798: per_pds_shd.g_old_rec.pds_information23;
794: per_pds_shd.g_old_rec.pds_information22;
795: End If;
796: If (p_rec.pds_information23 = hr_api.g_varchar2) then
797: p_rec.pds_information23 :=
798: per_pds_shd.g_old_rec.pds_information23;
799: End If;
800: If (p_rec.pds_information24 = hr_api.g_varchar2) then
801: p_rec.pds_information24 :=
802: per_pds_shd.g_old_rec.pds_information24;
798: per_pds_shd.g_old_rec.pds_information23;
799: End If;
800: If (p_rec.pds_information24 = hr_api.g_varchar2) then
801: p_rec.pds_information24 :=
802: per_pds_shd.g_old_rec.pds_information24;
803: End If;
804: If (p_rec.pds_information25 = hr_api.g_varchar2) then
805: p_rec.pds_information25 :=
806: per_pds_shd.g_old_rec.pds_information25;
802: per_pds_shd.g_old_rec.pds_information24;
803: End If;
804: If (p_rec.pds_information25 = hr_api.g_varchar2) then
805: p_rec.pds_information25 :=
806: per_pds_shd.g_old_rec.pds_information25;
807: End If;
808: If (p_rec.pds_information26 = hr_api.g_varchar2) then
809: p_rec.pds_information26 :=
810: per_pds_shd.g_old_rec.pds_information26;
806: per_pds_shd.g_old_rec.pds_information25;
807: End If;
808: If (p_rec.pds_information26 = hr_api.g_varchar2) then
809: p_rec.pds_information26 :=
810: per_pds_shd.g_old_rec.pds_information26;
811: End If;
812: If (p_rec.pds_information27 = hr_api.g_varchar2) then
813: p_rec.pds_information27 :=
814: per_pds_shd.g_old_rec.pds_information27;
810: per_pds_shd.g_old_rec.pds_information26;
811: End If;
812: If (p_rec.pds_information27 = hr_api.g_varchar2) then
813: p_rec.pds_information27 :=
814: per_pds_shd.g_old_rec.pds_information27;
815: End If;
816: If (p_rec.pds_information28 = hr_api.g_varchar2) then
817: p_rec.pds_information28 :=
818: per_pds_shd.g_old_rec.pds_information28;
814: per_pds_shd.g_old_rec.pds_information27;
815: End If;
816: If (p_rec.pds_information28 = hr_api.g_varchar2) then
817: p_rec.pds_information28 :=
818: per_pds_shd.g_old_rec.pds_information28;
819: End If;
820: If (p_rec.pds_information29 = hr_api.g_varchar2) then
821: p_rec.pds_information29 :=
822: per_pds_shd.g_old_rec.pds_information29;
818: per_pds_shd.g_old_rec.pds_information28;
819: End If;
820: If (p_rec.pds_information29 = hr_api.g_varchar2) then
821: p_rec.pds_information29 :=
822: per_pds_shd.g_old_rec.pds_information29;
823: End If;
824: If (p_rec.pds_information30 = hr_api.g_varchar2) then
825: p_rec.pds_information30 :=
826: per_pds_shd.g_old_rec.pds_information30;
822: per_pds_shd.g_old_rec.pds_information29;
823: End If;
824: If (p_rec.pds_information30 = hr_api.g_varchar2) then
825: p_rec.pds_information30 :=
826: per_pds_shd.g_old_rec.pds_information30;
827: End If;
828: --
829: hr_utility.set_location(' Leaving:'||l_proc, 10);
830: --
834: -- |---------------------------------< upd >----------------------------------|
835: -- ----------------------------------------------------------------------------
836: Procedure upd
837: (
838: p_rec in out nocopy per_pds_shd.g_rec_type,
839: p_effective_date in date,
840: p_validate in boolean default false
841: ) is
842: --
855: End If;
856: --
857: -- We must lock the row which we need to update.
858: --
859: per_pds_shd.lck
860: (
861: p_rec.period_of_service_id,
862: p_rec.object_version_number
863: );
980: p_effective_date in date,
981: p_validate in boolean default false
982: ) is
983: --
984: l_rec per_pds_shd.g_rec_type;
985: l_proc varchar2(72) := g_package||'upd';
986: --
987: Begin
988: hr_utility.set_location('Entering:'||l_proc, 5);
990: -- Call conversion function to turn arguments into the
991: -- l_rec structure.
992: --
993: l_rec :=
994: per_pds_shd.convert_args
995: (
996: p_period_of_service_id,
997: hr_api.g_number,
998: p_termination_accepted_person,