APPS.PER_PDS_DEL dependencies on PER_PDS_SHD

Line 51: Procedure delete_dml(p_rec in per_pds_shd.g_rec_type) is

47: -- Internal Table Handler Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml(p_rec in per_pds_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin

Line 58: per_pds_shd.g_api_dml := true; -- Set the api dml status

54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: per_pds_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the per_periods_of_service row.
61: --
62: delete from per_periods_of_service

Line 66: per_pds_shd.g_api_dml := false; -- Unset the api dml status

62: delete from per_periods_of_service
63: where period_of_service_id = p_rec.period_of_service_id
64: and object_version_number = p_rec.object_version_number;
65: --
66: per_pds_shd.g_api_dml := false; -- Unset the api dml status
67: --
68: hr_utility.set_location(' Leaving:'||l_proc, 10);
69: --
70: Exception

Line 73: per_pds_shd.g_api_dml := false; -- Unset the api dml status

69: --
70: Exception
71: When hr_api.child_integrity_violated then
72: -- Child integrity has been violated
73: per_pds_shd.g_api_dml := false; -- Unset the api dml status
74: per_pds_shd.constraint_error
75: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
76: When Others Then
77: per_pds_shd.g_api_dml := false; -- Unset the api dml status

Line 74: per_pds_shd.constraint_error

70: Exception
71: When hr_api.child_integrity_violated then
72: -- Child integrity has been violated
73: per_pds_shd.g_api_dml := false; -- Unset the api dml status
74: per_pds_shd.constraint_error
75: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
76: When Others Then
77: per_pds_shd.g_api_dml := false; -- Unset the api dml status
78: Raise;

Line 77: per_pds_shd.g_api_dml := false; -- Unset the api dml status

73: per_pds_shd.g_api_dml := false; -- Unset the api dml status
74: per_pds_shd.constraint_error
75: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
76: When Others Then
77: per_pds_shd.g_api_dml := false; -- Unset the api dml status
78: Raise;
79: End delete_dml;
80: --
81: -- ----------------------------------------------------------------------------

Line 113: Procedure pre_delete(p_rec in per_pds_shd.g_rec_type) is

109: -- Internal Table Handler Use Only.
110: --
111: -- {End Of Comments}
112: -- ----------------------------------------------------------------------------
113: Procedure pre_delete(p_rec in per_pds_shd.g_rec_type) is
114: --
115: l_proc varchar2(72) := g_package||'pre_delete';
116: --
117: Begin

Line 155: Procedure post_delete(p_rec in per_pds_shd.g_rec_type) is

151: -- Internal Table Handler Use Only.
152: --
153: -- {End Of Comments}
154: -- ----------------------------------------------------------------------------
155: Procedure post_delete(p_rec in per_pds_shd.g_rec_type) is
156: --
157: l_proc varchar2(72) := g_package||'post_delete';
158: --
159: Begin

Line 167: ,p_business_group_id_o =>per_pds_shd.g_old_rec.business_group_id

163: begin
164: per_pds_rkd.after_delete
165: (
166: p_period_of_service_id =>p_rec.period_of_service_id
167: ,p_business_group_id_o =>per_pds_shd.g_old_rec.business_group_id
168: ,p_person_id_o =>per_pds_shd.g_old_rec.person_id
169: ,p_terminat_accepted_person_o =>per_pds_shd.g_old_rec.termination_accepted_person_id
170: ,p_date_start_o =>per_pds_shd.g_old_rec.date_start
171: ,p_accepted_termination_date_o =>per_pds_shd.g_old_rec.accepted_termination_date

Line 168: ,p_person_id_o =>per_pds_shd.g_old_rec.person_id

164: per_pds_rkd.after_delete
165: (
166: p_period_of_service_id =>p_rec.period_of_service_id
167: ,p_business_group_id_o =>per_pds_shd.g_old_rec.business_group_id
168: ,p_person_id_o =>per_pds_shd.g_old_rec.person_id
169: ,p_terminat_accepted_person_o =>per_pds_shd.g_old_rec.termination_accepted_person_id
170: ,p_date_start_o =>per_pds_shd.g_old_rec.date_start
171: ,p_accepted_termination_date_o =>per_pds_shd.g_old_rec.accepted_termination_date
172: ,p_actual_termination_date_o =>per_pds_shd.g_old_rec.actual_termination_date

Line 169: ,p_terminat_accepted_person_o =>per_pds_shd.g_old_rec.termination_accepted_person_id

165: (
166: p_period_of_service_id =>p_rec.period_of_service_id
167: ,p_business_group_id_o =>per_pds_shd.g_old_rec.business_group_id
168: ,p_person_id_o =>per_pds_shd.g_old_rec.person_id
169: ,p_terminat_accepted_person_o =>per_pds_shd.g_old_rec.termination_accepted_person_id
170: ,p_date_start_o =>per_pds_shd.g_old_rec.date_start
171: ,p_accepted_termination_date_o =>per_pds_shd.g_old_rec.accepted_termination_date
172: ,p_actual_termination_date_o =>per_pds_shd.g_old_rec.actual_termination_date
173: ,p_comments_o =>per_pds_shd.g_old_rec.comments

Line 170: ,p_date_start_o =>per_pds_shd.g_old_rec.date_start

166: p_period_of_service_id =>p_rec.period_of_service_id
167: ,p_business_group_id_o =>per_pds_shd.g_old_rec.business_group_id
168: ,p_person_id_o =>per_pds_shd.g_old_rec.person_id
169: ,p_terminat_accepted_person_o =>per_pds_shd.g_old_rec.termination_accepted_person_id
170: ,p_date_start_o =>per_pds_shd.g_old_rec.date_start
171: ,p_accepted_termination_date_o =>per_pds_shd.g_old_rec.accepted_termination_date
172: ,p_actual_termination_date_o =>per_pds_shd.g_old_rec.actual_termination_date
173: ,p_comments_o =>per_pds_shd.g_old_rec.comments
174: ,p_adjusted_svc_date_o =>per_pds_shd.g_old_rec.adjusted_svc_date

Line 171: ,p_accepted_termination_date_o =>per_pds_shd.g_old_rec.accepted_termination_date

167: ,p_business_group_id_o =>per_pds_shd.g_old_rec.business_group_id
168: ,p_person_id_o =>per_pds_shd.g_old_rec.person_id
169: ,p_terminat_accepted_person_o =>per_pds_shd.g_old_rec.termination_accepted_person_id
170: ,p_date_start_o =>per_pds_shd.g_old_rec.date_start
171: ,p_accepted_termination_date_o =>per_pds_shd.g_old_rec.accepted_termination_date
172: ,p_actual_termination_date_o =>per_pds_shd.g_old_rec.actual_termination_date
173: ,p_comments_o =>per_pds_shd.g_old_rec.comments
174: ,p_adjusted_svc_date_o =>per_pds_shd.g_old_rec.adjusted_svc_date
175: ,p_final_process_date_o =>per_pds_shd.g_old_rec.final_process_date

Line 172: ,p_actual_termination_date_o =>per_pds_shd.g_old_rec.actual_termination_date

168: ,p_person_id_o =>per_pds_shd.g_old_rec.person_id
169: ,p_terminat_accepted_person_o =>per_pds_shd.g_old_rec.termination_accepted_person_id
170: ,p_date_start_o =>per_pds_shd.g_old_rec.date_start
171: ,p_accepted_termination_date_o =>per_pds_shd.g_old_rec.accepted_termination_date
172: ,p_actual_termination_date_o =>per_pds_shd.g_old_rec.actual_termination_date
173: ,p_comments_o =>per_pds_shd.g_old_rec.comments
174: ,p_adjusted_svc_date_o =>per_pds_shd.g_old_rec.adjusted_svc_date
175: ,p_final_process_date_o =>per_pds_shd.g_old_rec.final_process_date
176: ,p_last_standard_process_date_o =>per_pds_shd.g_old_rec.last_standard_process_date

Line 173: ,p_comments_o =>per_pds_shd.g_old_rec.comments

169: ,p_terminat_accepted_person_o =>per_pds_shd.g_old_rec.termination_accepted_person_id
170: ,p_date_start_o =>per_pds_shd.g_old_rec.date_start
171: ,p_accepted_termination_date_o =>per_pds_shd.g_old_rec.accepted_termination_date
172: ,p_actual_termination_date_o =>per_pds_shd.g_old_rec.actual_termination_date
173: ,p_comments_o =>per_pds_shd.g_old_rec.comments
174: ,p_adjusted_svc_date_o =>per_pds_shd.g_old_rec.adjusted_svc_date
175: ,p_final_process_date_o =>per_pds_shd.g_old_rec.final_process_date
176: ,p_last_standard_process_date_o =>per_pds_shd.g_old_rec.last_standard_process_date
177: ,p_leaving_reason_o =>per_pds_shd.g_old_rec.leaving_reason

Line 174: ,p_adjusted_svc_date_o =>per_pds_shd.g_old_rec.adjusted_svc_date

170: ,p_date_start_o =>per_pds_shd.g_old_rec.date_start
171: ,p_accepted_termination_date_o =>per_pds_shd.g_old_rec.accepted_termination_date
172: ,p_actual_termination_date_o =>per_pds_shd.g_old_rec.actual_termination_date
173: ,p_comments_o =>per_pds_shd.g_old_rec.comments
174: ,p_adjusted_svc_date_o =>per_pds_shd.g_old_rec.adjusted_svc_date
175: ,p_final_process_date_o =>per_pds_shd.g_old_rec.final_process_date
176: ,p_last_standard_process_date_o =>per_pds_shd.g_old_rec.last_standard_process_date
177: ,p_leaving_reason_o =>per_pds_shd.g_old_rec.leaving_reason
178: ,p_notified_termination_date_o =>per_pds_shd.g_old_rec.notified_termination_date

Line 175: ,p_final_process_date_o =>per_pds_shd.g_old_rec.final_process_date

171: ,p_accepted_termination_date_o =>per_pds_shd.g_old_rec.accepted_termination_date
172: ,p_actual_termination_date_o =>per_pds_shd.g_old_rec.actual_termination_date
173: ,p_comments_o =>per_pds_shd.g_old_rec.comments
174: ,p_adjusted_svc_date_o =>per_pds_shd.g_old_rec.adjusted_svc_date
175: ,p_final_process_date_o =>per_pds_shd.g_old_rec.final_process_date
176: ,p_last_standard_process_date_o =>per_pds_shd.g_old_rec.last_standard_process_date
177: ,p_leaving_reason_o =>per_pds_shd.g_old_rec.leaving_reason
178: ,p_notified_termination_date_o =>per_pds_shd.g_old_rec.notified_termination_date
179: ,p_projected_termination_date_o =>per_pds_shd.g_old_rec.projected_termination_date

Line 176: ,p_last_standard_process_date_o =>per_pds_shd.g_old_rec.last_standard_process_date

172: ,p_actual_termination_date_o =>per_pds_shd.g_old_rec.actual_termination_date
173: ,p_comments_o =>per_pds_shd.g_old_rec.comments
174: ,p_adjusted_svc_date_o =>per_pds_shd.g_old_rec.adjusted_svc_date
175: ,p_final_process_date_o =>per_pds_shd.g_old_rec.final_process_date
176: ,p_last_standard_process_date_o =>per_pds_shd.g_old_rec.last_standard_process_date
177: ,p_leaving_reason_o =>per_pds_shd.g_old_rec.leaving_reason
178: ,p_notified_termination_date_o =>per_pds_shd.g_old_rec.notified_termination_date
179: ,p_projected_termination_date_o =>per_pds_shd.g_old_rec.projected_termination_date
180: ,p_request_id_o =>per_pds_shd.g_old_rec.request_id

Line 177: ,p_leaving_reason_o =>per_pds_shd.g_old_rec.leaving_reason

173: ,p_comments_o =>per_pds_shd.g_old_rec.comments
174: ,p_adjusted_svc_date_o =>per_pds_shd.g_old_rec.adjusted_svc_date
175: ,p_final_process_date_o =>per_pds_shd.g_old_rec.final_process_date
176: ,p_last_standard_process_date_o =>per_pds_shd.g_old_rec.last_standard_process_date
177: ,p_leaving_reason_o =>per_pds_shd.g_old_rec.leaving_reason
178: ,p_notified_termination_date_o =>per_pds_shd.g_old_rec.notified_termination_date
179: ,p_projected_termination_date_o =>per_pds_shd.g_old_rec.projected_termination_date
180: ,p_request_id_o =>per_pds_shd.g_old_rec.request_id
181: ,p_program_application_id_o =>per_pds_shd.g_old_rec.program_application_id

Line 178: ,p_notified_termination_date_o =>per_pds_shd.g_old_rec.notified_termination_date

174: ,p_adjusted_svc_date_o =>per_pds_shd.g_old_rec.adjusted_svc_date
175: ,p_final_process_date_o =>per_pds_shd.g_old_rec.final_process_date
176: ,p_last_standard_process_date_o =>per_pds_shd.g_old_rec.last_standard_process_date
177: ,p_leaving_reason_o =>per_pds_shd.g_old_rec.leaving_reason
178: ,p_notified_termination_date_o =>per_pds_shd.g_old_rec.notified_termination_date
179: ,p_projected_termination_date_o =>per_pds_shd.g_old_rec.projected_termination_date
180: ,p_request_id_o =>per_pds_shd.g_old_rec.request_id
181: ,p_program_application_id_o =>per_pds_shd.g_old_rec.program_application_id
182: ,p_program_id_o =>per_pds_shd.g_old_rec.program_id

Line 179: ,p_projected_termination_date_o =>per_pds_shd.g_old_rec.projected_termination_date

175: ,p_final_process_date_o =>per_pds_shd.g_old_rec.final_process_date
176: ,p_last_standard_process_date_o =>per_pds_shd.g_old_rec.last_standard_process_date
177: ,p_leaving_reason_o =>per_pds_shd.g_old_rec.leaving_reason
178: ,p_notified_termination_date_o =>per_pds_shd.g_old_rec.notified_termination_date
179: ,p_projected_termination_date_o =>per_pds_shd.g_old_rec.projected_termination_date
180: ,p_request_id_o =>per_pds_shd.g_old_rec.request_id
181: ,p_program_application_id_o =>per_pds_shd.g_old_rec.program_application_id
182: ,p_program_id_o =>per_pds_shd.g_old_rec.program_id
183: ,p_program_update_date_o =>per_pds_shd.g_old_rec.program_update_date

Line 180: ,p_request_id_o =>per_pds_shd.g_old_rec.request_id

176: ,p_last_standard_process_date_o =>per_pds_shd.g_old_rec.last_standard_process_date
177: ,p_leaving_reason_o =>per_pds_shd.g_old_rec.leaving_reason
178: ,p_notified_termination_date_o =>per_pds_shd.g_old_rec.notified_termination_date
179: ,p_projected_termination_date_o =>per_pds_shd.g_old_rec.projected_termination_date
180: ,p_request_id_o =>per_pds_shd.g_old_rec.request_id
181: ,p_program_application_id_o =>per_pds_shd.g_old_rec.program_application_id
182: ,p_program_id_o =>per_pds_shd.g_old_rec.program_id
183: ,p_program_update_date_o =>per_pds_shd.g_old_rec.program_update_date
184: ,p_attribute_category_o =>per_pds_shd.g_old_rec.attribute_category

Line 181: ,p_program_application_id_o =>per_pds_shd.g_old_rec.program_application_id

177: ,p_leaving_reason_o =>per_pds_shd.g_old_rec.leaving_reason
178: ,p_notified_termination_date_o =>per_pds_shd.g_old_rec.notified_termination_date
179: ,p_projected_termination_date_o =>per_pds_shd.g_old_rec.projected_termination_date
180: ,p_request_id_o =>per_pds_shd.g_old_rec.request_id
181: ,p_program_application_id_o =>per_pds_shd.g_old_rec.program_application_id
182: ,p_program_id_o =>per_pds_shd.g_old_rec.program_id
183: ,p_program_update_date_o =>per_pds_shd.g_old_rec.program_update_date
184: ,p_attribute_category_o =>per_pds_shd.g_old_rec.attribute_category
185: ,p_attribute1_o =>per_pds_shd.g_old_rec.attribute1

Line 182: ,p_program_id_o =>per_pds_shd.g_old_rec.program_id

178: ,p_notified_termination_date_o =>per_pds_shd.g_old_rec.notified_termination_date
179: ,p_projected_termination_date_o =>per_pds_shd.g_old_rec.projected_termination_date
180: ,p_request_id_o =>per_pds_shd.g_old_rec.request_id
181: ,p_program_application_id_o =>per_pds_shd.g_old_rec.program_application_id
182: ,p_program_id_o =>per_pds_shd.g_old_rec.program_id
183: ,p_program_update_date_o =>per_pds_shd.g_old_rec.program_update_date
184: ,p_attribute_category_o =>per_pds_shd.g_old_rec.attribute_category
185: ,p_attribute1_o =>per_pds_shd.g_old_rec.attribute1
186: ,p_attribute2_o =>per_pds_shd.g_old_rec.attribute2

Line 183: ,p_program_update_date_o =>per_pds_shd.g_old_rec.program_update_date

179: ,p_projected_termination_date_o =>per_pds_shd.g_old_rec.projected_termination_date
180: ,p_request_id_o =>per_pds_shd.g_old_rec.request_id
181: ,p_program_application_id_o =>per_pds_shd.g_old_rec.program_application_id
182: ,p_program_id_o =>per_pds_shd.g_old_rec.program_id
183: ,p_program_update_date_o =>per_pds_shd.g_old_rec.program_update_date
184: ,p_attribute_category_o =>per_pds_shd.g_old_rec.attribute_category
185: ,p_attribute1_o =>per_pds_shd.g_old_rec.attribute1
186: ,p_attribute2_o =>per_pds_shd.g_old_rec.attribute2
187: ,p_attribute3_o =>per_pds_shd.g_old_rec.attribute3

Line 184: ,p_attribute_category_o =>per_pds_shd.g_old_rec.attribute_category

180: ,p_request_id_o =>per_pds_shd.g_old_rec.request_id
181: ,p_program_application_id_o =>per_pds_shd.g_old_rec.program_application_id
182: ,p_program_id_o =>per_pds_shd.g_old_rec.program_id
183: ,p_program_update_date_o =>per_pds_shd.g_old_rec.program_update_date
184: ,p_attribute_category_o =>per_pds_shd.g_old_rec.attribute_category
185: ,p_attribute1_o =>per_pds_shd.g_old_rec.attribute1
186: ,p_attribute2_o =>per_pds_shd.g_old_rec.attribute2
187: ,p_attribute3_o =>per_pds_shd.g_old_rec.attribute3
188: ,p_attribute4_o =>per_pds_shd.g_old_rec.attribute4

Line 185: ,p_attribute1_o =>per_pds_shd.g_old_rec.attribute1

181: ,p_program_application_id_o =>per_pds_shd.g_old_rec.program_application_id
182: ,p_program_id_o =>per_pds_shd.g_old_rec.program_id
183: ,p_program_update_date_o =>per_pds_shd.g_old_rec.program_update_date
184: ,p_attribute_category_o =>per_pds_shd.g_old_rec.attribute_category
185: ,p_attribute1_o =>per_pds_shd.g_old_rec.attribute1
186: ,p_attribute2_o =>per_pds_shd.g_old_rec.attribute2
187: ,p_attribute3_o =>per_pds_shd.g_old_rec.attribute3
188: ,p_attribute4_o =>per_pds_shd.g_old_rec.attribute4
189: ,p_attribute5_o =>per_pds_shd.g_old_rec.attribute5

Line 186: ,p_attribute2_o =>per_pds_shd.g_old_rec.attribute2

182: ,p_program_id_o =>per_pds_shd.g_old_rec.program_id
183: ,p_program_update_date_o =>per_pds_shd.g_old_rec.program_update_date
184: ,p_attribute_category_o =>per_pds_shd.g_old_rec.attribute_category
185: ,p_attribute1_o =>per_pds_shd.g_old_rec.attribute1
186: ,p_attribute2_o =>per_pds_shd.g_old_rec.attribute2
187: ,p_attribute3_o =>per_pds_shd.g_old_rec.attribute3
188: ,p_attribute4_o =>per_pds_shd.g_old_rec.attribute4
189: ,p_attribute5_o =>per_pds_shd.g_old_rec.attribute5
190: ,p_attribute6_o =>per_pds_shd.g_old_rec.attribute6

Line 187: ,p_attribute3_o =>per_pds_shd.g_old_rec.attribute3

183: ,p_program_update_date_o =>per_pds_shd.g_old_rec.program_update_date
184: ,p_attribute_category_o =>per_pds_shd.g_old_rec.attribute_category
185: ,p_attribute1_o =>per_pds_shd.g_old_rec.attribute1
186: ,p_attribute2_o =>per_pds_shd.g_old_rec.attribute2
187: ,p_attribute3_o =>per_pds_shd.g_old_rec.attribute3
188: ,p_attribute4_o =>per_pds_shd.g_old_rec.attribute4
189: ,p_attribute5_o =>per_pds_shd.g_old_rec.attribute5
190: ,p_attribute6_o =>per_pds_shd.g_old_rec.attribute6
191: ,p_attribute7_o =>per_pds_shd.g_old_rec.attribute7

Line 188: ,p_attribute4_o =>per_pds_shd.g_old_rec.attribute4

184: ,p_attribute_category_o =>per_pds_shd.g_old_rec.attribute_category
185: ,p_attribute1_o =>per_pds_shd.g_old_rec.attribute1
186: ,p_attribute2_o =>per_pds_shd.g_old_rec.attribute2
187: ,p_attribute3_o =>per_pds_shd.g_old_rec.attribute3
188: ,p_attribute4_o =>per_pds_shd.g_old_rec.attribute4
189: ,p_attribute5_o =>per_pds_shd.g_old_rec.attribute5
190: ,p_attribute6_o =>per_pds_shd.g_old_rec.attribute6
191: ,p_attribute7_o =>per_pds_shd.g_old_rec.attribute7
192: ,p_attribute8_o =>per_pds_shd.g_old_rec.attribute8

Line 189: ,p_attribute5_o =>per_pds_shd.g_old_rec.attribute5

185: ,p_attribute1_o =>per_pds_shd.g_old_rec.attribute1
186: ,p_attribute2_o =>per_pds_shd.g_old_rec.attribute2
187: ,p_attribute3_o =>per_pds_shd.g_old_rec.attribute3
188: ,p_attribute4_o =>per_pds_shd.g_old_rec.attribute4
189: ,p_attribute5_o =>per_pds_shd.g_old_rec.attribute5
190: ,p_attribute6_o =>per_pds_shd.g_old_rec.attribute6
191: ,p_attribute7_o =>per_pds_shd.g_old_rec.attribute7
192: ,p_attribute8_o =>per_pds_shd.g_old_rec.attribute8
193: ,p_attribute9_o =>per_pds_shd.g_old_rec.attribute9

Line 190: ,p_attribute6_o =>per_pds_shd.g_old_rec.attribute6

186: ,p_attribute2_o =>per_pds_shd.g_old_rec.attribute2
187: ,p_attribute3_o =>per_pds_shd.g_old_rec.attribute3
188: ,p_attribute4_o =>per_pds_shd.g_old_rec.attribute4
189: ,p_attribute5_o =>per_pds_shd.g_old_rec.attribute5
190: ,p_attribute6_o =>per_pds_shd.g_old_rec.attribute6
191: ,p_attribute7_o =>per_pds_shd.g_old_rec.attribute7
192: ,p_attribute8_o =>per_pds_shd.g_old_rec.attribute8
193: ,p_attribute9_o =>per_pds_shd.g_old_rec.attribute9
194: ,p_attribute10_o =>per_pds_shd.g_old_rec.attribute10

Line 191: ,p_attribute7_o =>per_pds_shd.g_old_rec.attribute7

187: ,p_attribute3_o =>per_pds_shd.g_old_rec.attribute3
188: ,p_attribute4_o =>per_pds_shd.g_old_rec.attribute4
189: ,p_attribute5_o =>per_pds_shd.g_old_rec.attribute5
190: ,p_attribute6_o =>per_pds_shd.g_old_rec.attribute6
191: ,p_attribute7_o =>per_pds_shd.g_old_rec.attribute7
192: ,p_attribute8_o =>per_pds_shd.g_old_rec.attribute8
193: ,p_attribute9_o =>per_pds_shd.g_old_rec.attribute9
194: ,p_attribute10_o =>per_pds_shd.g_old_rec.attribute10
195: ,p_attribute11_o =>per_pds_shd.g_old_rec.attribute11

Line 192: ,p_attribute8_o =>per_pds_shd.g_old_rec.attribute8

188: ,p_attribute4_o =>per_pds_shd.g_old_rec.attribute4
189: ,p_attribute5_o =>per_pds_shd.g_old_rec.attribute5
190: ,p_attribute6_o =>per_pds_shd.g_old_rec.attribute6
191: ,p_attribute7_o =>per_pds_shd.g_old_rec.attribute7
192: ,p_attribute8_o =>per_pds_shd.g_old_rec.attribute8
193: ,p_attribute9_o =>per_pds_shd.g_old_rec.attribute9
194: ,p_attribute10_o =>per_pds_shd.g_old_rec.attribute10
195: ,p_attribute11_o =>per_pds_shd.g_old_rec.attribute11
196: ,p_attribute12_o =>per_pds_shd.g_old_rec.attribute12

Line 193: ,p_attribute9_o =>per_pds_shd.g_old_rec.attribute9

189: ,p_attribute5_o =>per_pds_shd.g_old_rec.attribute5
190: ,p_attribute6_o =>per_pds_shd.g_old_rec.attribute6
191: ,p_attribute7_o =>per_pds_shd.g_old_rec.attribute7
192: ,p_attribute8_o =>per_pds_shd.g_old_rec.attribute8
193: ,p_attribute9_o =>per_pds_shd.g_old_rec.attribute9
194: ,p_attribute10_o =>per_pds_shd.g_old_rec.attribute10
195: ,p_attribute11_o =>per_pds_shd.g_old_rec.attribute11
196: ,p_attribute12_o =>per_pds_shd.g_old_rec.attribute12
197: ,p_attribute13_o =>per_pds_shd.g_old_rec.attribute13

Line 194: ,p_attribute10_o =>per_pds_shd.g_old_rec.attribute10

190: ,p_attribute6_o =>per_pds_shd.g_old_rec.attribute6
191: ,p_attribute7_o =>per_pds_shd.g_old_rec.attribute7
192: ,p_attribute8_o =>per_pds_shd.g_old_rec.attribute8
193: ,p_attribute9_o =>per_pds_shd.g_old_rec.attribute9
194: ,p_attribute10_o =>per_pds_shd.g_old_rec.attribute10
195: ,p_attribute11_o =>per_pds_shd.g_old_rec.attribute11
196: ,p_attribute12_o =>per_pds_shd.g_old_rec.attribute12
197: ,p_attribute13_o =>per_pds_shd.g_old_rec.attribute13
198: ,p_attribute14_o =>per_pds_shd.g_old_rec.attribute14

Line 195: ,p_attribute11_o =>per_pds_shd.g_old_rec.attribute11

191: ,p_attribute7_o =>per_pds_shd.g_old_rec.attribute7
192: ,p_attribute8_o =>per_pds_shd.g_old_rec.attribute8
193: ,p_attribute9_o =>per_pds_shd.g_old_rec.attribute9
194: ,p_attribute10_o =>per_pds_shd.g_old_rec.attribute10
195: ,p_attribute11_o =>per_pds_shd.g_old_rec.attribute11
196: ,p_attribute12_o =>per_pds_shd.g_old_rec.attribute12
197: ,p_attribute13_o =>per_pds_shd.g_old_rec.attribute13
198: ,p_attribute14_o =>per_pds_shd.g_old_rec.attribute14
199: ,p_attribute15_o =>per_pds_shd.g_old_rec.attribute15

Line 196: ,p_attribute12_o =>per_pds_shd.g_old_rec.attribute12

192: ,p_attribute8_o =>per_pds_shd.g_old_rec.attribute8
193: ,p_attribute9_o =>per_pds_shd.g_old_rec.attribute9
194: ,p_attribute10_o =>per_pds_shd.g_old_rec.attribute10
195: ,p_attribute11_o =>per_pds_shd.g_old_rec.attribute11
196: ,p_attribute12_o =>per_pds_shd.g_old_rec.attribute12
197: ,p_attribute13_o =>per_pds_shd.g_old_rec.attribute13
198: ,p_attribute14_o =>per_pds_shd.g_old_rec.attribute14
199: ,p_attribute15_o =>per_pds_shd.g_old_rec.attribute15
200: ,p_attribute16_o =>per_pds_shd.g_old_rec.attribute16

Line 197: ,p_attribute13_o =>per_pds_shd.g_old_rec.attribute13

193: ,p_attribute9_o =>per_pds_shd.g_old_rec.attribute9
194: ,p_attribute10_o =>per_pds_shd.g_old_rec.attribute10
195: ,p_attribute11_o =>per_pds_shd.g_old_rec.attribute11
196: ,p_attribute12_o =>per_pds_shd.g_old_rec.attribute12
197: ,p_attribute13_o =>per_pds_shd.g_old_rec.attribute13
198: ,p_attribute14_o =>per_pds_shd.g_old_rec.attribute14
199: ,p_attribute15_o =>per_pds_shd.g_old_rec.attribute15
200: ,p_attribute16_o =>per_pds_shd.g_old_rec.attribute16
201: ,p_attribute17_o =>per_pds_shd.g_old_rec.attribute17

Line 198: ,p_attribute14_o =>per_pds_shd.g_old_rec.attribute14

194: ,p_attribute10_o =>per_pds_shd.g_old_rec.attribute10
195: ,p_attribute11_o =>per_pds_shd.g_old_rec.attribute11
196: ,p_attribute12_o =>per_pds_shd.g_old_rec.attribute12
197: ,p_attribute13_o =>per_pds_shd.g_old_rec.attribute13
198: ,p_attribute14_o =>per_pds_shd.g_old_rec.attribute14
199: ,p_attribute15_o =>per_pds_shd.g_old_rec.attribute15
200: ,p_attribute16_o =>per_pds_shd.g_old_rec.attribute16
201: ,p_attribute17_o =>per_pds_shd.g_old_rec.attribute17
202: ,p_attribute18_o =>per_pds_shd.g_old_rec.attribute18

Line 199: ,p_attribute15_o =>per_pds_shd.g_old_rec.attribute15

195: ,p_attribute11_o =>per_pds_shd.g_old_rec.attribute11
196: ,p_attribute12_o =>per_pds_shd.g_old_rec.attribute12
197: ,p_attribute13_o =>per_pds_shd.g_old_rec.attribute13
198: ,p_attribute14_o =>per_pds_shd.g_old_rec.attribute14
199: ,p_attribute15_o =>per_pds_shd.g_old_rec.attribute15
200: ,p_attribute16_o =>per_pds_shd.g_old_rec.attribute16
201: ,p_attribute17_o =>per_pds_shd.g_old_rec.attribute17
202: ,p_attribute18_o =>per_pds_shd.g_old_rec.attribute18
203: ,p_attribute19_o =>per_pds_shd.g_old_rec.attribute19

Line 200: ,p_attribute16_o =>per_pds_shd.g_old_rec.attribute16

196: ,p_attribute12_o =>per_pds_shd.g_old_rec.attribute12
197: ,p_attribute13_o =>per_pds_shd.g_old_rec.attribute13
198: ,p_attribute14_o =>per_pds_shd.g_old_rec.attribute14
199: ,p_attribute15_o =>per_pds_shd.g_old_rec.attribute15
200: ,p_attribute16_o =>per_pds_shd.g_old_rec.attribute16
201: ,p_attribute17_o =>per_pds_shd.g_old_rec.attribute17
202: ,p_attribute18_o =>per_pds_shd.g_old_rec.attribute18
203: ,p_attribute19_o =>per_pds_shd.g_old_rec.attribute19
204: ,p_attribute20_o =>per_pds_shd.g_old_rec.attribute20

Line 201: ,p_attribute17_o =>per_pds_shd.g_old_rec.attribute17

197: ,p_attribute13_o =>per_pds_shd.g_old_rec.attribute13
198: ,p_attribute14_o =>per_pds_shd.g_old_rec.attribute14
199: ,p_attribute15_o =>per_pds_shd.g_old_rec.attribute15
200: ,p_attribute16_o =>per_pds_shd.g_old_rec.attribute16
201: ,p_attribute17_o =>per_pds_shd.g_old_rec.attribute17
202: ,p_attribute18_o =>per_pds_shd.g_old_rec.attribute18
203: ,p_attribute19_o =>per_pds_shd.g_old_rec.attribute19
204: ,p_attribute20_o =>per_pds_shd.g_old_rec.attribute20
205: ,p_object_version_number_o =>per_pds_shd.g_old_rec.object_version_number

Line 202: ,p_attribute18_o =>per_pds_shd.g_old_rec.attribute18

198: ,p_attribute14_o =>per_pds_shd.g_old_rec.attribute14
199: ,p_attribute15_o =>per_pds_shd.g_old_rec.attribute15
200: ,p_attribute16_o =>per_pds_shd.g_old_rec.attribute16
201: ,p_attribute17_o =>per_pds_shd.g_old_rec.attribute17
202: ,p_attribute18_o =>per_pds_shd.g_old_rec.attribute18
203: ,p_attribute19_o =>per_pds_shd.g_old_rec.attribute19
204: ,p_attribute20_o =>per_pds_shd.g_old_rec.attribute20
205: ,p_object_version_number_o =>per_pds_shd.g_old_rec.object_version_number
206: ,p_prior_employment_ssp_weeks_o =>per_pds_shd.g_old_rec.prior_employment_ssp_weeks

Line 203: ,p_attribute19_o =>per_pds_shd.g_old_rec.attribute19

199: ,p_attribute15_o =>per_pds_shd.g_old_rec.attribute15
200: ,p_attribute16_o =>per_pds_shd.g_old_rec.attribute16
201: ,p_attribute17_o =>per_pds_shd.g_old_rec.attribute17
202: ,p_attribute18_o =>per_pds_shd.g_old_rec.attribute18
203: ,p_attribute19_o =>per_pds_shd.g_old_rec.attribute19
204: ,p_attribute20_o =>per_pds_shd.g_old_rec.attribute20
205: ,p_object_version_number_o =>per_pds_shd.g_old_rec.object_version_number
206: ,p_prior_employment_ssp_weeks_o =>per_pds_shd.g_old_rec.prior_employment_ssp_weeks
207: ,p_prior_employmt_ssp_paid_to_o =>per_pds_shd.g_old_rec.prior_employment_ssp_paid_to

Line 204: ,p_attribute20_o =>per_pds_shd.g_old_rec.attribute20

200: ,p_attribute16_o =>per_pds_shd.g_old_rec.attribute16
201: ,p_attribute17_o =>per_pds_shd.g_old_rec.attribute17
202: ,p_attribute18_o =>per_pds_shd.g_old_rec.attribute18
203: ,p_attribute19_o =>per_pds_shd.g_old_rec.attribute19
204: ,p_attribute20_o =>per_pds_shd.g_old_rec.attribute20
205: ,p_object_version_number_o =>per_pds_shd.g_old_rec.object_version_number
206: ,p_prior_employment_ssp_weeks_o =>per_pds_shd.g_old_rec.prior_employment_ssp_weeks
207: ,p_prior_employmt_ssp_paid_to_o =>per_pds_shd.g_old_rec.prior_employment_ssp_paid_to
208: ,p_pds_information_category_o =>per_pds_shd.g_old_rec.pds_information_category

Line 205: ,p_object_version_number_o =>per_pds_shd.g_old_rec.object_version_number

201: ,p_attribute17_o =>per_pds_shd.g_old_rec.attribute17
202: ,p_attribute18_o =>per_pds_shd.g_old_rec.attribute18
203: ,p_attribute19_o =>per_pds_shd.g_old_rec.attribute19
204: ,p_attribute20_o =>per_pds_shd.g_old_rec.attribute20
205: ,p_object_version_number_o =>per_pds_shd.g_old_rec.object_version_number
206: ,p_prior_employment_ssp_weeks_o =>per_pds_shd.g_old_rec.prior_employment_ssp_weeks
207: ,p_prior_employmt_ssp_paid_to_o =>per_pds_shd.g_old_rec.prior_employment_ssp_paid_to
208: ,p_pds_information_category_o =>per_pds_shd.g_old_rec.pds_information_category
209: ,p_pds_information1_o =>per_pds_shd.g_old_rec.pds_information1

Line 206: ,p_prior_employment_ssp_weeks_o =>per_pds_shd.g_old_rec.prior_employment_ssp_weeks

202: ,p_attribute18_o =>per_pds_shd.g_old_rec.attribute18
203: ,p_attribute19_o =>per_pds_shd.g_old_rec.attribute19
204: ,p_attribute20_o =>per_pds_shd.g_old_rec.attribute20
205: ,p_object_version_number_o =>per_pds_shd.g_old_rec.object_version_number
206: ,p_prior_employment_ssp_weeks_o =>per_pds_shd.g_old_rec.prior_employment_ssp_weeks
207: ,p_prior_employmt_ssp_paid_to_o =>per_pds_shd.g_old_rec.prior_employment_ssp_paid_to
208: ,p_pds_information_category_o =>per_pds_shd.g_old_rec.pds_information_category
209: ,p_pds_information1_o =>per_pds_shd.g_old_rec.pds_information1
210: ,p_pds_information2_o =>per_pds_shd.g_old_rec.pds_information2

Line 207: ,p_prior_employmt_ssp_paid_to_o =>per_pds_shd.g_old_rec.prior_employment_ssp_paid_to

203: ,p_attribute19_o =>per_pds_shd.g_old_rec.attribute19
204: ,p_attribute20_o =>per_pds_shd.g_old_rec.attribute20
205: ,p_object_version_number_o =>per_pds_shd.g_old_rec.object_version_number
206: ,p_prior_employment_ssp_weeks_o =>per_pds_shd.g_old_rec.prior_employment_ssp_weeks
207: ,p_prior_employmt_ssp_paid_to_o =>per_pds_shd.g_old_rec.prior_employment_ssp_paid_to
208: ,p_pds_information_category_o =>per_pds_shd.g_old_rec.pds_information_category
209: ,p_pds_information1_o =>per_pds_shd.g_old_rec.pds_information1
210: ,p_pds_information2_o =>per_pds_shd.g_old_rec.pds_information2
211: ,p_pds_information3_o =>per_pds_shd.g_old_rec.pds_information3

Line 208: ,p_pds_information_category_o =>per_pds_shd.g_old_rec.pds_information_category

204: ,p_attribute20_o =>per_pds_shd.g_old_rec.attribute20
205: ,p_object_version_number_o =>per_pds_shd.g_old_rec.object_version_number
206: ,p_prior_employment_ssp_weeks_o =>per_pds_shd.g_old_rec.prior_employment_ssp_weeks
207: ,p_prior_employmt_ssp_paid_to_o =>per_pds_shd.g_old_rec.prior_employment_ssp_paid_to
208: ,p_pds_information_category_o =>per_pds_shd.g_old_rec.pds_information_category
209: ,p_pds_information1_o =>per_pds_shd.g_old_rec.pds_information1
210: ,p_pds_information2_o =>per_pds_shd.g_old_rec.pds_information2
211: ,p_pds_information3_o =>per_pds_shd.g_old_rec.pds_information3
212: ,p_pds_information4_o =>per_pds_shd.g_old_rec.pds_information4

Line 209: ,p_pds_information1_o =>per_pds_shd.g_old_rec.pds_information1

205: ,p_object_version_number_o =>per_pds_shd.g_old_rec.object_version_number
206: ,p_prior_employment_ssp_weeks_o =>per_pds_shd.g_old_rec.prior_employment_ssp_weeks
207: ,p_prior_employmt_ssp_paid_to_o =>per_pds_shd.g_old_rec.prior_employment_ssp_paid_to
208: ,p_pds_information_category_o =>per_pds_shd.g_old_rec.pds_information_category
209: ,p_pds_information1_o =>per_pds_shd.g_old_rec.pds_information1
210: ,p_pds_information2_o =>per_pds_shd.g_old_rec.pds_information2
211: ,p_pds_information3_o =>per_pds_shd.g_old_rec.pds_information3
212: ,p_pds_information4_o =>per_pds_shd.g_old_rec.pds_information4
213: ,p_pds_information5_o =>per_pds_shd.g_old_rec.pds_information5

Line 210: ,p_pds_information2_o =>per_pds_shd.g_old_rec.pds_information2

206: ,p_prior_employment_ssp_weeks_o =>per_pds_shd.g_old_rec.prior_employment_ssp_weeks
207: ,p_prior_employmt_ssp_paid_to_o =>per_pds_shd.g_old_rec.prior_employment_ssp_paid_to
208: ,p_pds_information_category_o =>per_pds_shd.g_old_rec.pds_information_category
209: ,p_pds_information1_o =>per_pds_shd.g_old_rec.pds_information1
210: ,p_pds_information2_o =>per_pds_shd.g_old_rec.pds_information2
211: ,p_pds_information3_o =>per_pds_shd.g_old_rec.pds_information3
212: ,p_pds_information4_o =>per_pds_shd.g_old_rec.pds_information4
213: ,p_pds_information5_o =>per_pds_shd.g_old_rec.pds_information5
214: ,p_pds_information6_o =>per_pds_shd.g_old_rec.pds_information6

Line 211: ,p_pds_information3_o =>per_pds_shd.g_old_rec.pds_information3

207: ,p_prior_employmt_ssp_paid_to_o =>per_pds_shd.g_old_rec.prior_employment_ssp_paid_to
208: ,p_pds_information_category_o =>per_pds_shd.g_old_rec.pds_information_category
209: ,p_pds_information1_o =>per_pds_shd.g_old_rec.pds_information1
210: ,p_pds_information2_o =>per_pds_shd.g_old_rec.pds_information2
211: ,p_pds_information3_o =>per_pds_shd.g_old_rec.pds_information3
212: ,p_pds_information4_o =>per_pds_shd.g_old_rec.pds_information4
213: ,p_pds_information5_o =>per_pds_shd.g_old_rec.pds_information5
214: ,p_pds_information6_o =>per_pds_shd.g_old_rec.pds_information6
215: ,p_pds_information7_o =>per_pds_shd.g_old_rec.pds_information7

Line 212: ,p_pds_information4_o =>per_pds_shd.g_old_rec.pds_information4

208: ,p_pds_information_category_o =>per_pds_shd.g_old_rec.pds_information_category
209: ,p_pds_information1_o =>per_pds_shd.g_old_rec.pds_information1
210: ,p_pds_information2_o =>per_pds_shd.g_old_rec.pds_information2
211: ,p_pds_information3_o =>per_pds_shd.g_old_rec.pds_information3
212: ,p_pds_information4_o =>per_pds_shd.g_old_rec.pds_information4
213: ,p_pds_information5_o =>per_pds_shd.g_old_rec.pds_information5
214: ,p_pds_information6_o =>per_pds_shd.g_old_rec.pds_information6
215: ,p_pds_information7_o =>per_pds_shd.g_old_rec.pds_information7
216: ,p_pds_information8_o =>per_pds_shd.g_old_rec.pds_information8

Line 213: ,p_pds_information5_o =>per_pds_shd.g_old_rec.pds_information5

209: ,p_pds_information1_o =>per_pds_shd.g_old_rec.pds_information1
210: ,p_pds_information2_o =>per_pds_shd.g_old_rec.pds_information2
211: ,p_pds_information3_o =>per_pds_shd.g_old_rec.pds_information3
212: ,p_pds_information4_o =>per_pds_shd.g_old_rec.pds_information4
213: ,p_pds_information5_o =>per_pds_shd.g_old_rec.pds_information5
214: ,p_pds_information6_o =>per_pds_shd.g_old_rec.pds_information6
215: ,p_pds_information7_o =>per_pds_shd.g_old_rec.pds_information7
216: ,p_pds_information8_o =>per_pds_shd.g_old_rec.pds_information8
217: ,p_pds_information9_o =>per_pds_shd.g_old_rec.pds_information9

Line 214: ,p_pds_information6_o =>per_pds_shd.g_old_rec.pds_information6

210: ,p_pds_information2_o =>per_pds_shd.g_old_rec.pds_information2
211: ,p_pds_information3_o =>per_pds_shd.g_old_rec.pds_information3
212: ,p_pds_information4_o =>per_pds_shd.g_old_rec.pds_information4
213: ,p_pds_information5_o =>per_pds_shd.g_old_rec.pds_information5
214: ,p_pds_information6_o =>per_pds_shd.g_old_rec.pds_information6
215: ,p_pds_information7_o =>per_pds_shd.g_old_rec.pds_information7
216: ,p_pds_information8_o =>per_pds_shd.g_old_rec.pds_information8
217: ,p_pds_information9_o =>per_pds_shd.g_old_rec.pds_information9
218: ,p_pds_information10_o =>per_pds_shd.g_old_rec.pds_information10

Line 215: ,p_pds_information7_o =>per_pds_shd.g_old_rec.pds_information7

211: ,p_pds_information3_o =>per_pds_shd.g_old_rec.pds_information3
212: ,p_pds_information4_o =>per_pds_shd.g_old_rec.pds_information4
213: ,p_pds_information5_o =>per_pds_shd.g_old_rec.pds_information5
214: ,p_pds_information6_o =>per_pds_shd.g_old_rec.pds_information6
215: ,p_pds_information7_o =>per_pds_shd.g_old_rec.pds_information7
216: ,p_pds_information8_o =>per_pds_shd.g_old_rec.pds_information8
217: ,p_pds_information9_o =>per_pds_shd.g_old_rec.pds_information9
218: ,p_pds_information10_o =>per_pds_shd.g_old_rec.pds_information10
219: ,p_pds_information11_o =>per_pds_shd.g_old_rec.pds_information11

Line 216: ,p_pds_information8_o =>per_pds_shd.g_old_rec.pds_information8

212: ,p_pds_information4_o =>per_pds_shd.g_old_rec.pds_information4
213: ,p_pds_information5_o =>per_pds_shd.g_old_rec.pds_information5
214: ,p_pds_information6_o =>per_pds_shd.g_old_rec.pds_information6
215: ,p_pds_information7_o =>per_pds_shd.g_old_rec.pds_information7
216: ,p_pds_information8_o =>per_pds_shd.g_old_rec.pds_information8
217: ,p_pds_information9_o =>per_pds_shd.g_old_rec.pds_information9
218: ,p_pds_information10_o =>per_pds_shd.g_old_rec.pds_information10
219: ,p_pds_information11_o =>per_pds_shd.g_old_rec.pds_information11
220: ,p_pds_information12_o =>per_pds_shd.g_old_rec.pds_information12

Line 217: ,p_pds_information9_o =>per_pds_shd.g_old_rec.pds_information9

213: ,p_pds_information5_o =>per_pds_shd.g_old_rec.pds_information5
214: ,p_pds_information6_o =>per_pds_shd.g_old_rec.pds_information6
215: ,p_pds_information7_o =>per_pds_shd.g_old_rec.pds_information7
216: ,p_pds_information8_o =>per_pds_shd.g_old_rec.pds_information8
217: ,p_pds_information9_o =>per_pds_shd.g_old_rec.pds_information9
218: ,p_pds_information10_o =>per_pds_shd.g_old_rec.pds_information10
219: ,p_pds_information11_o =>per_pds_shd.g_old_rec.pds_information11
220: ,p_pds_information12_o =>per_pds_shd.g_old_rec.pds_information12
221: ,p_pds_information13_o =>per_pds_shd.g_old_rec.pds_information13

Line 218: ,p_pds_information10_o =>per_pds_shd.g_old_rec.pds_information10

214: ,p_pds_information6_o =>per_pds_shd.g_old_rec.pds_information6
215: ,p_pds_information7_o =>per_pds_shd.g_old_rec.pds_information7
216: ,p_pds_information8_o =>per_pds_shd.g_old_rec.pds_information8
217: ,p_pds_information9_o =>per_pds_shd.g_old_rec.pds_information9
218: ,p_pds_information10_o =>per_pds_shd.g_old_rec.pds_information10
219: ,p_pds_information11_o =>per_pds_shd.g_old_rec.pds_information11
220: ,p_pds_information12_o =>per_pds_shd.g_old_rec.pds_information12
221: ,p_pds_information13_o =>per_pds_shd.g_old_rec.pds_information13
222: ,p_pds_information14_o =>per_pds_shd.g_old_rec.pds_information14

Line 219: ,p_pds_information11_o =>per_pds_shd.g_old_rec.pds_information11

215: ,p_pds_information7_o =>per_pds_shd.g_old_rec.pds_information7
216: ,p_pds_information8_o =>per_pds_shd.g_old_rec.pds_information8
217: ,p_pds_information9_o =>per_pds_shd.g_old_rec.pds_information9
218: ,p_pds_information10_o =>per_pds_shd.g_old_rec.pds_information10
219: ,p_pds_information11_o =>per_pds_shd.g_old_rec.pds_information11
220: ,p_pds_information12_o =>per_pds_shd.g_old_rec.pds_information12
221: ,p_pds_information13_o =>per_pds_shd.g_old_rec.pds_information13
222: ,p_pds_information14_o =>per_pds_shd.g_old_rec.pds_information14
223: ,p_pds_information15_o =>per_pds_shd.g_old_rec.pds_information15

Line 220: ,p_pds_information12_o =>per_pds_shd.g_old_rec.pds_information12

216: ,p_pds_information8_o =>per_pds_shd.g_old_rec.pds_information8
217: ,p_pds_information9_o =>per_pds_shd.g_old_rec.pds_information9
218: ,p_pds_information10_o =>per_pds_shd.g_old_rec.pds_information10
219: ,p_pds_information11_o =>per_pds_shd.g_old_rec.pds_information11
220: ,p_pds_information12_o =>per_pds_shd.g_old_rec.pds_information12
221: ,p_pds_information13_o =>per_pds_shd.g_old_rec.pds_information13
222: ,p_pds_information14_o =>per_pds_shd.g_old_rec.pds_information14
223: ,p_pds_information15_o =>per_pds_shd.g_old_rec.pds_information15
224: ,p_pds_information16_o =>per_pds_shd.g_old_rec.pds_information16

Line 221: ,p_pds_information13_o =>per_pds_shd.g_old_rec.pds_information13

217: ,p_pds_information9_o =>per_pds_shd.g_old_rec.pds_information9
218: ,p_pds_information10_o =>per_pds_shd.g_old_rec.pds_information10
219: ,p_pds_information11_o =>per_pds_shd.g_old_rec.pds_information11
220: ,p_pds_information12_o =>per_pds_shd.g_old_rec.pds_information12
221: ,p_pds_information13_o =>per_pds_shd.g_old_rec.pds_information13
222: ,p_pds_information14_o =>per_pds_shd.g_old_rec.pds_information14
223: ,p_pds_information15_o =>per_pds_shd.g_old_rec.pds_information15
224: ,p_pds_information16_o =>per_pds_shd.g_old_rec.pds_information16
225: ,p_pds_information17_o =>per_pds_shd.g_old_rec.pds_information17

Line 222: ,p_pds_information14_o =>per_pds_shd.g_old_rec.pds_information14

218: ,p_pds_information10_o =>per_pds_shd.g_old_rec.pds_information10
219: ,p_pds_information11_o =>per_pds_shd.g_old_rec.pds_information11
220: ,p_pds_information12_o =>per_pds_shd.g_old_rec.pds_information12
221: ,p_pds_information13_o =>per_pds_shd.g_old_rec.pds_information13
222: ,p_pds_information14_o =>per_pds_shd.g_old_rec.pds_information14
223: ,p_pds_information15_o =>per_pds_shd.g_old_rec.pds_information15
224: ,p_pds_information16_o =>per_pds_shd.g_old_rec.pds_information16
225: ,p_pds_information17_o =>per_pds_shd.g_old_rec.pds_information17
226: ,p_pds_information18_o =>per_pds_shd.g_old_rec.pds_information18

Line 223: ,p_pds_information15_o =>per_pds_shd.g_old_rec.pds_information15

219: ,p_pds_information11_o =>per_pds_shd.g_old_rec.pds_information11
220: ,p_pds_information12_o =>per_pds_shd.g_old_rec.pds_information12
221: ,p_pds_information13_o =>per_pds_shd.g_old_rec.pds_information13
222: ,p_pds_information14_o =>per_pds_shd.g_old_rec.pds_information14
223: ,p_pds_information15_o =>per_pds_shd.g_old_rec.pds_information15
224: ,p_pds_information16_o =>per_pds_shd.g_old_rec.pds_information16
225: ,p_pds_information17_o =>per_pds_shd.g_old_rec.pds_information17
226: ,p_pds_information18_o =>per_pds_shd.g_old_rec.pds_information18
227: ,p_pds_information19_o =>per_pds_shd.g_old_rec.pds_information19

Line 224: ,p_pds_information16_o =>per_pds_shd.g_old_rec.pds_information16

220: ,p_pds_information12_o =>per_pds_shd.g_old_rec.pds_information12
221: ,p_pds_information13_o =>per_pds_shd.g_old_rec.pds_information13
222: ,p_pds_information14_o =>per_pds_shd.g_old_rec.pds_information14
223: ,p_pds_information15_o =>per_pds_shd.g_old_rec.pds_information15
224: ,p_pds_information16_o =>per_pds_shd.g_old_rec.pds_information16
225: ,p_pds_information17_o =>per_pds_shd.g_old_rec.pds_information17
226: ,p_pds_information18_o =>per_pds_shd.g_old_rec.pds_information18
227: ,p_pds_information19_o =>per_pds_shd.g_old_rec.pds_information19
228: ,p_pds_information20_o =>per_pds_shd.g_old_rec.pds_information20

Line 225: ,p_pds_information17_o =>per_pds_shd.g_old_rec.pds_information17

221: ,p_pds_information13_o =>per_pds_shd.g_old_rec.pds_information13
222: ,p_pds_information14_o =>per_pds_shd.g_old_rec.pds_information14
223: ,p_pds_information15_o =>per_pds_shd.g_old_rec.pds_information15
224: ,p_pds_information16_o =>per_pds_shd.g_old_rec.pds_information16
225: ,p_pds_information17_o =>per_pds_shd.g_old_rec.pds_information17
226: ,p_pds_information18_o =>per_pds_shd.g_old_rec.pds_information18
227: ,p_pds_information19_o =>per_pds_shd.g_old_rec.pds_information19
228: ,p_pds_information20_o =>per_pds_shd.g_old_rec.pds_information20
229: ,p_pds_information21_o =>per_pds_shd.g_old_rec.pds_information21

Line 226: ,p_pds_information18_o =>per_pds_shd.g_old_rec.pds_information18

222: ,p_pds_information14_o =>per_pds_shd.g_old_rec.pds_information14
223: ,p_pds_information15_o =>per_pds_shd.g_old_rec.pds_information15
224: ,p_pds_information16_o =>per_pds_shd.g_old_rec.pds_information16
225: ,p_pds_information17_o =>per_pds_shd.g_old_rec.pds_information17
226: ,p_pds_information18_o =>per_pds_shd.g_old_rec.pds_information18
227: ,p_pds_information19_o =>per_pds_shd.g_old_rec.pds_information19
228: ,p_pds_information20_o =>per_pds_shd.g_old_rec.pds_information20
229: ,p_pds_information21_o =>per_pds_shd.g_old_rec.pds_information21
230: ,p_pds_information22_o =>per_pds_shd.g_old_rec.pds_information22

Line 227: ,p_pds_information19_o =>per_pds_shd.g_old_rec.pds_information19

223: ,p_pds_information15_o =>per_pds_shd.g_old_rec.pds_information15
224: ,p_pds_information16_o =>per_pds_shd.g_old_rec.pds_information16
225: ,p_pds_information17_o =>per_pds_shd.g_old_rec.pds_information17
226: ,p_pds_information18_o =>per_pds_shd.g_old_rec.pds_information18
227: ,p_pds_information19_o =>per_pds_shd.g_old_rec.pds_information19
228: ,p_pds_information20_o =>per_pds_shd.g_old_rec.pds_information20
229: ,p_pds_information21_o =>per_pds_shd.g_old_rec.pds_information21
230: ,p_pds_information22_o =>per_pds_shd.g_old_rec.pds_information22
231: ,p_pds_information23_o =>per_pds_shd.g_old_rec.pds_information23

Line 228: ,p_pds_information20_o =>per_pds_shd.g_old_rec.pds_information20

224: ,p_pds_information16_o =>per_pds_shd.g_old_rec.pds_information16
225: ,p_pds_information17_o =>per_pds_shd.g_old_rec.pds_information17
226: ,p_pds_information18_o =>per_pds_shd.g_old_rec.pds_information18
227: ,p_pds_information19_o =>per_pds_shd.g_old_rec.pds_information19
228: ,p_pds_information20_o =>per_pds_shd.g_old_rec.pds_information20
229: ,p_pds_information21_o =>per_pds_shd.g_old_rec.pds_information21
230: ,p_pds_information22_o =>per_pds_shd.g_old_rec.pds_information22
231: ,p_pds_information23_o =>per_pds_shd.g_old_rec.pds_information23
232: ,p_pds_information24_o =>per_pds_shd.g_old_rec.pds_information24

Line 229: ,p_pds_information21_o =>per_pds_shd.g_old_rec.pds_information21

225: ,p_pds_information17_o =>per_pds_shd.g_old_rec.pds_information17
226: ,p_pds_information18_o =>per_pds_shd.g_old_rec.pds_information18
227: ,p_pds_information19_o =>per_pds_shd.g_old_rec.pds_information19
228: ,p_pds_information20_o =>per_pds_shd.g_old_rec.pds_information20
229: ,p_pds_information21_o =>per_pds_shd.g_old_rec.pds_information21
230: ,p_pds_information22_o =>per_pds_shd.g_old_rec.pds_information22
231: ,p_pds_information23_o =>per_pds_shd.g_old_rec.pds_information23
232: ,p_pds_information24_o =>per_pds_shd.g_old_rec.pds_information24
233: ,p_pds_information25_o =>per_pds_shd.g_old_rec.pds_information25

Line 230: ,p_pds_information22_o =>per_pds_shd.g_old_rec.pds_information22

226: ,p_pds_information18_o =>per_pds_shd.g_old_rec.pds_information18
227: ,p_pds_information19_o =>per_pds_shd.g_old_rec.pds_information19
228: ,p_pds_information20_o =>per_pds_shd.g_old_rec.pds_information20
229: ,p_pds_information21_o =>per_pds_shd.g_old_rec.pds_information21
230: ,p_pds_information22_o =>per_pds_shd.g_old_rec.pds_information22
231: ,p_pds_information23_o =>per_pds_shd.g_old_rec.pds_information23
232: ,p_pds_information24_o =>per_pds_shd.g_old_rec.pds_information24
233: ,p_pds_information25_o =>per_pds_shd.g_old_rec.pds_information25
234: ,p_pds_information26_o =>per_pds_shd.g_old_rec.pds_information26

Line 231: ,p_pds_information23_o =>per_pds_shd.g_old_rec.pds_information23

227: ,p_pds_information19_o =>per_pds_shd.g_old_rec.pds_information19
228: ,p_pds_information20_o =>per_pds_shd.g_old_rec.pds_information20
229: ,p_pds_information21_o =>per_pds_shd.g_old_rec.pds_information21
230: ,p_pds_information22_o =>per_pds_shd.g_old_rec.pds_information22
231: ,p_pds_information23_o =>per_pds_shd.g_old_rec.pds_information23
232: ,p_pds_information24_o =>per_pds_shd.g_old_rec.pds_information24
233: ,p_pds_information25_o =>per_pds_shd.g_old_rec.pds_information25
234: ,p_pds_information26_o =>per_pds_shd.g_old_rec.pds_information26
235: ,p_pds_information27_o =>per_pds_shd.g_old_rec.pds_information27

Line 232: ,p_pds_information24_o =>per_pds_shd.g_old_rec.pds_information24

228: ,p_pds_information20_o =>per_pds_shd.g_old_rec.pds_information20
229: ,p_pds_information21_o =>per_pds_shd.g_old_rec.pds_information21
230: ,p_pds_information22_o =>per_pds_shd.g_old_rec.pds_information22
231: ,p_pds_information23_o =>per_pds_shd.g_old_rec.pds_information23
232: ,p_pds_information24_o =>per_pds_shd.g_old_rec.pds_information24
233: ,p_pds_information25_o =>per_pds_shd.g_old_rec.pds_information25
234: ,p_pds_information26_o =>per_pds_shd.g_old_rec.pds_information26
235: ,p_pds_information27_o =>per_pds_shd.g_old_rec.pds_information27
236: ,p_pds_information28_o =>per_pds_shd.g_old_rec.pds_information28

Line 233: ,p_pds_information25_o =>per_pds_shd.g_old_rec.pds_information25

229: ,p_pds_information21_o =>per_pds_shd.g_old_rec.pds_information21
230: ,p_pds_information22_o =>per_pds_shd.g_old_rec.pds_information22
231: ,p_pds_information23_o =>per_pds_shd.g_old_rec.pds_information23
232: ,p_pds_information24_o =>per_pds_shd.g_old_rec.pds_information24
233: ,p_pds_information25_o =>per_pds_shd.g_old_rec.pds_information25
234: ,p_pds_information26_o =>per_pds_shd.g_old_rec.pds_information26
235: ,p_pds_information27_o =>per_pds_shd.g_old_rec.pds_information27
236: ,p_pds_information28_o =>per_pds_shd.g_old_rec.pds_information28
237: ,p_pds_information29_o =>per_pds_shd.g_old_rec.pds_information29

Line 234: ,p_pds_information26_o =>per_pds_shd.g_old_rec.pds_information26

230: ,p_pds_information22_o =>per_pds_shd.g_old_rec.pds_information22
231: ,p_pds_information23_o =>per_pds_shd.g_old_rec.pds_information23
232: ,p_pds_information24_o =>per_pds_shd.g_old_rec.pds_information24
233: ,p_pds_information25_o =>per_pds_shd.g_old_rec.pds_information25
234: ,p_pds_information26_o =>per_pds_shd.g_old_rec.pds_information26
235: ,p_pds_information27_o =>per_pds_shd.g_old_rec.pds_information27
236: ,p_pds_information28_o =>per_pds_shd.g_old_rec.pds_information28
237: ,p_pds_information29_o =>per_pds_shd.g_old_rec.pds_information29
238: ,p_pds_information30_o =>per_pds_shd.g_old_rec.pds_information30

Line 235: ,p_pds_information27_o =>per_pds_shd.g_old_rec.pds_information27

231: ,p_pds_information23_o =>per_pds_shd.g_old_rec.pds_information23
232: ,p_pds_information24_o =>per_pds_shd.g_old_rec.pds_information24
233: ,p_pds_information25_o =>per_pds_shd.g_old_rec.pds_information25
234: ,p_pds_information26_o =>per_pds_shd.g_old_rec.pds_information26
235: ,p_pds_information27_o =>per_pds_shd.g_old_rec.pds_information27
236: ,p_pds_information28_o =>per_pds_shd.g_old_rec.pds_information28
237: ,p_pds_information29_o =>per_pds_shd.g_old_rec.pds_information29
238: ,p_pds_information30_o =>per_pds_shd.g_old_rec.pds_information30
239: );

Line 236: ,p_pds_information28_o =>per_pds_shd.g_old_rec.pds_information28

232: ,p_pds_information24_o =>per_pds_shd.g_old_rec.pds_information24
233: ,p_pds_information25_o =>per_pds_shd.g_old_rec.pds_information25
234: ,p_pds_information26_o =>per_pds_shd.g_old_rec.pds_information26
235: ,p_pds_information27_o =>per_pds_shd.g_old_rec.pds_information27
236: ,p_pds_information28_o =>per_pds_shd.g_old_rec.pds_information28
237: ,p_pds_information29_o =>per_pds_shd.g_old_rec.pds_information29
238: ,p_pds_information30_o =>per_pds_shd.g_old_rec.pds_information30
239: );
240: exception

Line 237: ,p_pds_information29_o =>per_pds_shd.g_old_rec.pds_information29

233: ,p_pds_information25_o =>per_pds_shd.g_old_rec.pds_information25
234: ,p_pds_information26_o =>per_pds_shd.g_old_rec.pds_information26
235: ,p_pds_information27_o =>per_pds_shd.g_old_rec.pds_information27
236: ,p_pds_information28_o =>per_pds_shd.g_old_rec.pds_information28
237: ,p_pds_information29_o =>per_pds_shd.g_old_rec.pds_information29
238: ,p_pds_information30_o =>per_pds_shd.g_old_rec.pds_information30
239: );
240: exception
241: when hr_api.cannot_find_prog_unit then

Line 238: ,p_pds_information30_o =>per_pds_shd.g_old_rec.pds_information30

234: ,p_pds_information26_o =>per_pds_shd.g_old_rec.pds_information26
235: ,p_pds_information27_o =>per_pds_shd.g_old_rec.pds_information27
236: ,p_pds_information28_o =>per_pds_shd.g_old_rec.pds_information28
237: ,p_pds_information29_o =>per_pds_shd.g_old_rec.pds_information29
238: ,p_pds_information30_o =>per_pds_shd.g_old_rec.pds_information30
239: );
240: exception
241: when hr_api.cannot_find_prog_unit then
242: hr_api.cannot_find_prog_unit_error

Line 256: p_rec in per_pds_shd.g_rec_type,

252: -- |---------------------------------< del >----------------------------------|
253: -- ----------------------------------------------------------------------------
254: Procedure del
255: (
256: p_rec in per_pds_shd.g_rec_type,
257: p_validate in boolean default false
258: ) is
259: --
260: l_proc varchar2(72) := g_package||'del';

Line 276: per_pds_shd.lck

272: End If;
273: --
274: -- We must lock the row which we need to delete.
275: --
276: per_pds_shd.lck
277: (
278: p_rec.period_of_service_id,
279: p_rec.object_version_number
280: );

Line 324: l_rec per_pds_shd.g_rec_type;

320: p_object_version_number in number,
321: p_validate in boolean default false
322: ) is
323: --
324: l_rec per_pds_shd.g_rec_type;
325: l_proc varchar2(72) := g_package||'del';
326: --
327: Begin
328: hr_utility.set_location('Entering:'||l_proc, 5);