APPS.HR_PDT_DEL dependencies on HR_PDT_SHD

Line 52: (p_rec in hr_pdt_shd.g_rec_type

48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in hr_pdt_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --

Line 75: hr_pdt_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: --
75: hr_pdt_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: --
79: Raise;

Line 114: Procedure pre_delete(p_rec in hr_pdt_shd.g_rec_type) is

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

Line 156: Procedure post_delete(p_rec in hr_pdt_shd.g_rec_type) is

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

Line 168: => hr_pdt_shd.g_old_rec.object_version_number

164: hr_pdt_rkd.after_delete
165: (p_person_deployment_id
166: => p_rec.person_deployment_id
167: ,p_object_version_number_o
168: => hr_pdt_shd.g_old_rec.object_version_number
169: ,p_from_business_group_id_o
170: => hr_pdt_shd.g_old_rec.from_business_group_id
171: ,p_to_business_group_id_o
172: => hr_pdt_shd.g_old_rec.to_business_group_id

Line 170: => hr_pdt_shd.g_old_rec.from_business_group_id

166: => p_rec.person_deployment_id
167: ,p_object_version_number_o
168: => hr_pdt_shd.g_old_rec.object_version_number
169: ,p_from_business_group_id_o
170: => hr_pdt_shd.g_old_rec.from_business_group_id
171: ,p_to_business_group_id_o
172: => hr_pdt_shd.g_old_rec.to_business_group_id
173: ,p_from_person_id_o
174: => hr_pdt_shd.g_old_rec.from_person_id

Line 172: => hr_pdt_shd.g_old_rec.to_business_group_id

168: => hr_pdt_shd.g_old_rec.object_version_number
169: ,p_from_business_group_id_o
170: => hr_pdt_shd.g_old_rec.from_business_group_id
171: ,p_to_business_group_id_o
172: => hr_pdt_shd.g_old_rec.to_business_group_id
173: ,p_from_person_id_o
174: => hr_pdt_shd.g_old_rec.from_person_id
175: ,p_to_person_id_o
176: => hr_pdt_shd.g_old_rec.to_person_id

Line 174: => hr_pdt_shd.g_old_rec.from_person_id

170: => hr_pdt_shd.g_old_rec.from_business_group_id
171: ,p_to_business_group_id_o
172: => hr_pdt_shd.g_old_rec.to_business_group_id
173: ,p_from_person_id_o
174: => hr_pdt_shd.g_old_rec.from_person_id
175: ,p_to_person_id_o
176: => hr_pdt_shd.g_old_rec.to_person_id
177: ,p_person_type_id_o
178: => hr_pdt_shd.g_old_rec.person_type_id

Line 176: => hr_pdt_shd.g_old_rec.to_person_id

172: => hr_pdt_shd.g_old_rec.to_business_group_id
173: ,p_from_person_id_o
174: => hr_pdt_shd.g_old_rec.from_person_id
175: ,p_to_person_id_o
176: => hr_pdt_shd.g_old_rec.to_person_id
177: ,p_person_type_id_o
178: => hr_pdt_shd.g_old_rec.person_type_id
179: ,p_start_date_o
180: => hr_pdt_shd.g_old_rec.start_date

Line 178: => hr_pdt_shd.g_old_rec.person_type_id

174: => hr_pdt_shd.g_old_rec.from_person_id
175: ,p_to_person_id_o
176: => hr_pdt_shd.g_old_rec.to_person_id
177: ,p_person_type_id_o
178: => hr_pdt_shd.g_old_rec.person_type_id
179: ,p_start_date_o
180: => hr_pdt_shd.g_old_rec.start_date
181: ,p_end_date_o
182: => hr_pdt_shd.g_old_rec.end_date

Line 180: => hr_pdt_shd.g_old_rec.start_date

176: => hr_pdt_shd.g_old_rec.to_person_id
177: ,p_person_type_id_o
178: => hr_pdt_shd.g_old_rec.person_type_id
179: ,p_start_date_o
180: => hr_pdt_shd.g_old_rec.start_date
181: ,p_end_date_o
182: => hr_pdt_shd.g_old_rec.end_date
183: ,p_deployment_reason_o
184: => hr_pdt_shd.g_old_rec.deployment_reason

Line 182: => hr_pdt_shd.g_old_rec.end_date

178: => hr_pdt_shd.g_old_rec.person_type_id
179: ,p_start_date_o
180: => hr_pdt_shd.g_old_rec.start_date
181: ,p_end_date_o
182: => hr_pdt_shd.g_old_rec.end_date
183: ,p_deployment_reason_o
184: => hr_pdt_shd.g_old_rec.deployment_reason
185: ,p_employee_number_o
186: => hr_pdt_shd.g_old_rec.employee_number

Line 184: => hr_pdt_shd.g_old_rec.deployment_reason

180: => hr_pdt_shd.g_old_rec.start_date
181: ,p_end_date_o
182: => hr_pdt_shd.g_old_rec.end_date
183: ,p_deployment_reason_o
184: => hr_pdt_shd.g_old_rec.deployment_reason
185: ,p_employee_number_o
186: => hr_pdt_shd.g_old_rec.employee_number
187: ,p_leaving_reason_o
188: => hr_pdt_shd.g_old_rec.leaving_reason

Line 186: => hr_pdt_shd.g_old_rec.employee_number

182: => hr_pdt_shd.g_old_rec.end_date
183: ,p_deployment_reason_o
184: => hr_pdt_shd.g_old_rec.deployment_reason
185: ,p_employee_number_o
186: => hr_pdt_shd.g_old_rec.employee_number
187: ,p_leaving_reason_o
188: => hr_pdt_shd.g_old_rec.leaving_reason
189: ,p_leaving_person_type_id_o
190: => hr_pdt_shd.g_old_rec.leaving_person_type_id

Line 188: => hr_pdt_shd.g_old_rec.leaving_reason

184: => hr_pdt_shd.g_old_rec.deployment_reason
185: ,p_employee_number_o
186: => hr_pdt_shd.g_old_rec.employee_number
187: ,p_leaving_reason_o
188: => hr_pdt_shd.g_old_rec.leaving_reason
189: ,p_leaving_person_type_id_o
190: => hr_pdt_shd.g_old_rec.leaving_person_type_id
191: ,p_permanent_o
192: => hr_pdt_shd.g_old_rec.permanent

Line 190: => hr_pdt_shd.g_old_rec.leaving_person_type_id

186: => hr_pdt_shd.g_old_rec.employee_number
187: ,p_leaving_reason_o
188: => hr_pdt_shd.g_old_rec.leaving_reason
189: ,p_leaving_person_type_id_o
190: => hr_pdt_shd.g_old_rec.leaving_person_type_id
191: ,p_permanent_o
192: => hr_pdt_shd.g_old_rec.permanent
193: ,p_status_o
194: => hr_pdt_shd.g_old_rec.status

Line 192: => hr_pdt_shd.g_old_rec.permanent

188: => hr_pdt_shd.g_old_rec.leaving_reason
189: ,p_leaving_person_type_id_o
190: => hr_pdt_shd.g_old_rec.leaving_person_type_id
191: ,p_permanent_o
192: => hr_pdt_shd.g_old_rec.permanent
193: ,p_status_o
194: => hr_pdt_shd.g_old_rec.status
195: ,p_status_change_reason_o
196: => hr_pdt_shd.g_old_rec.status_change_reason

Line 194: => hr_pdt_shd.g_old_rec.status

190: => hr_pdt_shd.g_old_rec.leaving_person_type_id
191: ,p_permanent_o
192: => hr_pdt_shd.g_old_rec.permanent
193: ,p_status_o
194: => hr_pdt_shd.g_old_rec.status
195: ,p_status_change_reason_o
196: => hr_pdt_shd.g_old_rec.status_change_reason
197: ,p_status_change_date_o
198: => hr_pdt_shd.g_old_rec.status_change_date

Line 196: => hr_pdt_shd.g_old_rec.status_change_reason

192: => hr_pdt_shd.g_old_rec.permanent
193: ,p_status_o
194: => hr_pdt_shd.g_old_rec.status
195: ,p_status_change_reason_o
196: => hr_pdt_shd.g_old_rec.status_change_reason
197: ,p_status_change_date_o
198: => hr_pdt_shd.g_old_rec.status_change_date
199: ,p_deplymt_policy_id_o
200: => hr_pdt_shd.g_old_rec.deplymt_policy_id

Line 198: => hr_pdt_shd.g_old_rec.status_change_date

194: => hr_pdt_shd.g_old_rec.status
195: ,p_status_change_reason_o
196: => hr_pdt_shd.g_old_rec.status_change_reason
197: ,p_status_change_date_o
198: => hr_pdt_shd.g_old_rec.status_change_date
199: ,p_deplymt_policy_id_o
200: => hr_pdt_shd.g_old_rec.deplymt_policy_id
201: ,p_organization_id_o
202: => hr_pdt_shd.g_old_rec.organization_id

Line 200: => hr_pdt_shd.g_old_rec.deplymt_policy_id

196: => hr_pdt_shd.g_old_rec.status_change_reason
197: ,p_status_change_date_o
198: => hr_pdt_shd.g_old_rec.status_change_date
199: ,p_deplymt_policy_id_o
200: => hr_pdt_shd.g_old_rec.deplymt_policy_id
201: ,p_organization_id_o
202: => hr_pdt_shd.g_old_rec.organization_id
203: ,p_location_id_o
204: => hr_pdt_shd.g_old_rec.location_id

Line 202: => hr_pdt_shd.g_old_rec.organization_id

198: => hr_pdt_shd.g_old_rec.status_change_date
199: ,p_deplymt_policy_id_o
200: => hr_pdt_shd.g_old_rec.deplymt_policy_id
201: ,p_organization_id_o
202: => hr_pdt_shd.g_old_rec.organization_id
203: ,p_location_id_o
204: => hr_pdt_shd.g_old_rec.location_id
205: ,p_job_id_o
206: => hr_pdt_shd.g_old_rec.job_id

Line 204: => hr_pdt_shd.g_old_rec.location_id

200: => hr_pdt_shd.g_old_rec.deplymt_policy_id
201: ,p_organization_id_o
202: => hr_pdt_shd.g_old_rec.organization_id
203: ,p_location_id_o
204: => hr_pdt_shd.g_old_rec.location_id
205: ,p_job_id_o
206: => hr_pdt_shd.g_old_rec.job_id
207: ,p_position_id_o
208: => hr_pdt_shd.g_old_rec.position_id

Line 206: => hr_pdt_shd.g_old_rec.job_id

202: => hr_pdt_shd.g_old_rec.organization_id
203: ,p_location_id_o
204: => hr_pdt_shd.g_old_rec.location_id
205: ,p_job_id_o
206: => hr_pdt_shd.g_old_rec.job_id
207: ,p_position_id_o
208: => hr_pdt_shd.g_old_rec.position_id
209: ,p_grade_id_o
210: => hr_pdt_shd.g_old_rec.grade_id

Line 208: => hr_pdt_shd.g_old_rec.position_id

204: => hr_pdt_shd.g_old_rec.location_id
205: ,p_job_id_o
206: => hr_pdt_shd.g_old_rec.job_id
207: ,p_position_id_o
208: => hr_pdt_shd.g_old_rec.position_id
209: ,p_grade_id_o
210: => hr_pdt_shd.g_old_rec.grade_id
211: ,p_supervisor_id_o
212: => hr_pdt_shd.g_old_rec.supervisor_id

Line 210: => hr_pdt_shd.g_old_rec.grade_id

206: => hr_pdt_shd.g_old_rec.job_id
207: ,p_position_id_o
208: => hr_pdt_shd.g_old_rec.position_id
209: ,p_grade_id_o
210: => hr_pdt_shd.g_old_rec.grade_id
211: ,p_supervisor_id_o
212: => hr_pdt_shd.g_old_rec.supervisor_id
213: ,p_supervisor_assignment_id_o
214: => hr_pdt_shd.g_old_rec.supervisor_assignment_id

Line 212: => hr_pdt_shd.g_old_rec.supervisor_id

208: => hr_pdt_shd.g_old_rec.position_id
209: ,p_grade_id_o
210: => hr_pdt_shd.g_old_rec.grade_id
211: ,p_supervisor_id_o
212: => hr_pdt_shd.g_old_rec.supervisor_id
213: ,p_supervisor_assignment_id_o
214: => hr_pdt_shd.g_old_rec.supervisor_assignment_id
215: ,p_retain_direct_reports_o
216: => hr_pdt_shd.g_old_rec.retain_direct_reports

Line 214: => hr_pdt_shd.g_old_rec.supervisor_assignment_id

210: => hr_pdt_shd.g_old_rec.grade_id
211: ,p_supervisor_id_o
212: => hr_pdt_shd.g_old_rec.supervisor_id
213: ,p_supervisor_assignment_id_o
214: => hr_pdt_shd.g_old_rec.supervisor_assignment_id
215: ,p_retain_direct_reports_o
216: => hr_pdt_shd.g_old_rec.retain_direct_reports
217: ,p_payroll_id_o
218: => hr_pdt_shd.g_old_rec.payroll_id

Line 216: => hr_pdt_shd.g_old_rec.retain_direct_reports

212: => hr_pdt_shd.g_old_rec.supervisor_id
213: ,p_supervisor_assignment_id_o
214: => hr_pdt_shd.g_old_rec.supervisor_assignment_id
215: ,p_retain_direct_reports_o
216: => hr_pdt_shd.g_old_rec.retain_direct_reports
217: ,p_payroll_id_o
218: => hr_pdt_shd.g_old_rec.payroll_id
219: ,p_pay_basis_id_o
220: => hr_pdt_shd.g_old_rec.pay_basis_id

Line 218: => hr_pdt_shd.g_old_rec.payroll_id

214: => hr_pdt_shd.g_old_rec.supervisor_assignment_id
215: ,p_retain_direct_reports_o
216: => hr_pdt_shd.g_old_rec.retain_direct_reports
217: ,p_payroll_id_o
218: => hr_pdt_shd.g_old_rec.payroll_id
219: ,p_pay_basis_id_o
220: => hr_pdt_shd.g_old_rec.pay_basis_id
221: ,p_proposed_salary_o
222: => hr_pdt_shd.g_old_rec.proposed_salary

Line 220: => hr_pdt_shd.g_old_rec.pay_basis_id

216: => hr_pdt_shd.g_old_rec.retain_direct_reports
217: ,p_payroll_id_o
218: => hr_pdt_shd.g_old_rec.payroll_id
219: ,p_pay_basis_id_o
220: => hr_pdt_shd.g_old_rec.pay_basis_id
221: ,p_proposed_salary_o
222: => hr_pdt_shd.g_old_rec.proposed_salary
223: ,p_people_group_id_o
224: => hr_pdt_shd.g_old_rec.people_group_id

Line 222: => hr_pdt_shd.g_old_rec.proposed_salary

218: => hr_pdt_shd.g_old_rec.payroll_id
219: ,p_pay_basis_id_o
220: => hr_pdt_shd.g_old_rec.pay_basis_id
221: ,p_proposed_salary_o
222: => hr_pdt_shd.g_old_rec.proposed_salary
223: ,p_people_group_id_o
224: => hr_pdt_shd.g_old_rec.people_group_id
225: ,p_soft_coding_keyflex_id_o
226: => hr_pdt_shd.g_old_rec.soft_coding_keyflex_id

Line 224: => hr_pdt_shd.g_old_rec.people_group_id

220: => hr_pdt_shd.g_old_rec.pay_basis_id
221: ,p_proposed_salary_o
222: => hr_pdt_shd.g_old_rec.proposed_salary
223: ,p_people_group_id_o
224: => hr_pdt_shd.g_old_rec.people_group_id
225: ,p_soft_coding_keyflex_id_o
226: => hr_pdt_shd.g_old_rec.soft_coding_keyflex_id
227: ,p_assignment_status_type_id_o
228: => hr_pdt_shd.g_old_rec.assignment_status_type_id

Line 226: => hr_pdt_shd.g_old_rec.soft_coding_keyflex_id

222: => hr_pdt_shd.g_old_rec.proposed_salary
223: ,p_people_group_id_o
224: => hr_pdt_shd.g_old_rec.people_group_id
225: ,p_soft_coding_keyflex_id_o
226: => hr_pdt_shd.g_old_rec.soft_coding_keyflex_id
227: ,p_assignment_status_type_id_o
228: => hr_pdt_shd.g_old_rec.assignment_status_type_id
229: ,p_ass_status_change_reason_o
230: => hr_pdt_shd.g_old_rec.ass_status_change_reason

Line 228: => hr_pdt_shd.g_old_rec.assignment_status_type_id

224: => hr_pdt_shd.g_old_rec.people_group_id
225: ,p_soft_coding_keyflex_id_o
226: => hr_pdt_shd.g_old_rec.soft_coding_keyflex_id
227: ,p_assignment_status_type_id_o
228: => hr_pdt_shd.g_old_rec.assignment_status_type_id
229: ,p_ass_status_change_reason_o
230: => hr_pdt_shd.g_old_rec.ass_status_change_reason
231: ,p_assignment_category_o
232: => hr_pdt_shd.g_old_rec.assignment_category

Line 230: => hr_pdt_shd.g_old_rec.ass_status_change_reason

226: => hr_pdt_shd.g_old_rec.soft_coding_keyflex_id
227: ,p_assignment_status_type_id_o
228: => hr_pdt_shd.g_old_rec.assignment_status_type_id
229: ,p_ass_status_change_reason_o
230: => hr_pdt_shd.g_old_rec.ass_status_change_reason
231: ,p_assignment_category_o
232: => hr_pdt_shd.g_old_rec.assignment_category
233: ,p_per_information_category_o
234: => hr_pdt_shd.g_old_rec.per_information_category

Line 232: => hr_pdt_shd.g_old_rec.assignment_category

228: => hr_pdt_shd.g_old_rec.assignment_status_type_id
229: ,p_ass_status_change_reason_o
230: => hr_pdt_shd.g_old_rec.ass_status_change_reason
231: ,p_assignment_category_o
232: => hr_pdt_shd.g_old_rec.assignment_category
233: ,p_per_information_category_o
234: => hr_pdt_shd.g_old_rec.per_information_category
235: ,p_per_information1_o
236: => hr_pdt_shd.g_old_rec.per_information1

Line 234: => hr_pdt_shd.g_old_rec.per_information_category

230: => hr_pdt_shd.g_old_rec.ass_status_change_reason
231: ,p_assignment_category_o
232: => hr_pdt_shd.g_old_rec.assignment_category
233: ,p_per_information_category_o
234: => hr_pdt_shd.g_old_rec.per_information_category
235: ,p_per_information1_o
236: => hr_pdt_shd.g_old_rec.per_information1
237: ,p_per_information2_o
238: => hr_pdt_shd.g_old_rec.per_information2

Line 236: => hr_pdt_shd.g_old_rec.per_information1

232: => hr_pdt_shd.g_old_rec.assignment_category
233: ,p_per_information_category_o
234: => hr_pdt_shd.g_old_rec.per_information_category
235: ,p_per_information1_o
236: => hr_pdt_shd.g_old_rec.per_information1
237: ,p_per_information2_o
238: => hr_pdt_shd.g_old_rec.per_information2
239: ,p_per_information3_o
240: => hr_pdt_shd.g_old_rec.per_information3

Line 238: => hr_pdt_shd.g_old_rec.per_information2

234: => hr_pdt_shd.g_old_rec.per_information_category
235: ,p_per_information1_o
236: => hr_pdt_shd.g_old_rec.per_information1
237: ,p_per_information2_o
238: => hr_pdt_shd.g_old_rec.per_information2
239: ,p_per_information3_o
240: => hr_pdt_shd.g_old_rec.per_information3
241: ,p_per_information4_o
242: => hr_pdt_shd.g_old_rec.per_information4

Line 240: => hr_pdt_shd.g_old_rec.per_information3

236: => hr_pdt_shd.g_old_rec.per_information1
237: ,p_per_information2_o
238: => hr_pdt_shd.g_old_rec.per_information2
239: ,p_per_information3_o
240: => hr_pdt_shd.g_old_rec.per_information3
241: ,p_per_information4_o
242: => hr_pdt_shd.g_old_rec.per_information4
243: ,p_per_information5_o
244: => hr_pdt_shd.g_old_rec.per_information5

Line 242: => hr_pdt_shd.g_old_rec.per_information4

238: => hr_pdt_shd.g_old_rec.per_information2
239: ,p_per_information3_o
240: => hr_pdt_shd.g_old_rec.per_information3
241: ,p_per_information4_o
242: => hr_pdt_shd.g_old_rec.per_information4
243: ,p_per_information5_o
244: => hr_pdt_shd.g_old_rec.per_information5
245: ,p_per_information6_o
246: => hr_pdt_shd.g_old_rec.per_information6

Line 244: => hr_pdt_shd.g_old_rec.per_information5

240: => hr_pdt_shd.g_old_rec.per_information3
241: ,p_per_information4_o
242: => hr_pdt_shd.g_old_rec.per_information4
243: ,p_per_information5_o
244: => hr_pdt_shd.g_old_rec.per_information5
245: ,p_per_information6_o
246: => hr_pdt_shd.g_old_rec.per_information6
247: ,p_per_information7_o
248: => hr_pdt_shd.g_old_rec.per_information7

Line 246: => hr_pdt_shd.g_old_rec.per_information6

242: => hr_pdt_shd.g_old_rec.per_information4
243: ,p_per_information5_o
244: => hr_pdt_shd.g_old_rec.per_information5
245: ,p_per_information6_o
246: => hr_pdt_shd.g_old_rec.per_information6
247: ,p_per_information7_o
248: => hr_pdt_shd.g_old_rec.per_information7
249: ,p_per_information8_o
250: => hr_pdt_shd.g_old_rec.per_information8

Line 248: => hr_pdt_shd.g_old_rec.per_information7

244: => hr_pdt_shd.g_old_rec.per_information5
245: ,p_per_information6_o
246: => hr_pdt_shd.g_old_rec.per_information6
247: ,p_per_information7_o
248: => hr_pdt_shd.g_old_rec.per_information7
249: ,p_per_information8_o
250: => hr_pdt_shd.g_old_rec.per_information8
251: ,p_per_information9_o
252: => hr_pdt_shd.g_old_rec.per_information9

Line 250: => hr_pdt_shd.g_old_rec.per_information8

246: => hr_pdt_shd.g_old_rec.per_information6
247: ,p_per_information7_o
248: => hr_pdt_shd.g_old_rec.per_information7
249: ,p_per_information8_o
250: => hr_pdt_shd.g_old_rec.per_information8
251: ,p_per_information9_o
252: => hr_pdt_shd.g_old_rec.per_information9
253: ,p_per_information10_o
254: => hr_pdt_shd.g_old_rec.per_information10

Line 252: => hr_pdt_shd.g_old_rec.per_information9

248: => hr_pdt_shd.g_old_rec.per_information7
249: ,p_per_information8_o
250: => hr_pdt_shd.g_old_rec.per_information8
251: ,p_per_information9_o
252: => hr_pdt_shd.g_old_rec.per_information9
253: ,p_per_information10_o
254: => hr_pdt_shd.g_old_rec.per_information10
255: ,p_per_information11_o
256: => hr_pdt_shd.g_old_rec.per_information11

Line 254: => hr_pdt_shd.g_old_rec.per_information10

250: => hr_pdt_shd.g_old_rec.per_information8
251: ,p_per_information9_o
252: => hr_pdt_shd.g_old_rec.per_information9
253: ,p_per_information10_o
254: => hr_pdt_shd.g_old_rec.per_information10
255: ,p_per_information11_o
256: => hr_pdt_shd.g_old_rec.per_information11
257: ,p_per_information12_o
258: => hr_pdt_shd.g_old_rec.per_information12

Line 256: => hr_pdt_shd.g_old_rec.per_information11

252: => hr_pdt_shd.g_old_rec.per_information9
253: ,p_per_information10_o
254: => hr_pdt_shd.g_old_rec.per_information10
255: ,p_per_information11_o
256: => hr_pdt_shd.g_old_rec.per_information11
257: ,p_per_information12_o
258: => hr_pdt_shd.g_old_rec.per_information12
259: ,p_per_information13_o
260: => hr_pdt_shd.g_old_rec.per_information13

Line 258: => hr_pdt_shd.g_old_rec.per_information12

254: => hr_pdt_shd.g_old_rec.per_information10
255: ,p_per_information11_o
256: => hr_pdt_shd.g_old_rec.per_information11
257: ,p_per_information12_o
258: => hr_pdt_shd.g_old_rec.per_information12
259: ,p_per_information13_o
260: => hr_pdt_shd.g_old_rec.per_information13
261: ,p_per_information14_o
262: => hr_pdt_shd.g_old_rec.per_information14

Line 260: => hr_pdt_shd.g_old_rec.per_information13

256: => hr_pdt_shd.g_old_rec.per_information11
257: ,p_per_information12_o
258: => hr_pdt_shd.g_old_rec.per_information12
259: ,p_per_information13_o
260: => hr_pdt_shd.g_old_rec.per_information13
261: ,p_per_information14_o
262: => hr_pdt_shd.g_old_rec.per_information14
263: ,p_per_information15_o
264: => hr_pdt_shd.g_old_rec.per_information15

Line 262: => hr_pdt_shd.g_old_rec.per_information14

258: => hr_pdt_shd.g_old_rec.per_information12
259: ,p_per_information13_o
260: => hr_pdt_shd.g_old_rec.per_information13
261: ,p_per_information14_o
262: => hr_pdt_shd.g_old_rec.per_information14
263: ,p_per_information15_o
264: => hr_pdt_shd.g_old_rec.per_information15
265: ,p_per_information16_o
266: => hr_pdt_shd.g_old_rec.per_information16

Line 264: => hr_pdt_shd.g_old_rec.per_information15

260: => hr_pdt_shd.g_old_rec.per_information13
261: ,p_per_information14_o
262: => hr_pdt_shd.g_old_rec.per_information14
263: ,p_per_information15_o
264: => hr_pdt_shd.g_old_rec.per_information15
265: ,p_per_information16_o
266: => hr_pdt_shd.g_old_rec.per_information16
267: ,p_per_information17_o
268: => hr_pdt_shd.g_old_rec.per_information17

Line 266: => hr_pdt_shd.g_old_rec.per_information16

262: => hr_pdt_shd.g_old_rec.per_information14
263: ,p_per_information15_o
264: => hr_pdt_shd.g_old_rec.per_information15
265: ,p_per_information16_o
266: => hr_pdt_shd.g_old_rec.per_information16
267: ,p_per_information17_o
268: => hr_pdt_shd.g_old_rec.per_information17
269: ,p_per_information18_o
270: => hr_pdt_shd.g_old_rec.per_information18

Line 268: => hr_pdt_shd.g_old_rec.per_information17

264: => hr_pdt_shd.g_old_rec.per_information15
265: ,p_per_information16_o
266: => hr_pdt_shd.g_old_rec.per_information16
267: ,p_per_information17_o
268: => hr_pdt_shd.g_old_rec.per_information17
269: ,p_per_information18_o
270: => hr_pdt_shd.g_old_rec.per_information18
271: ,p_per_information19_o
272: => hr_pdt_shd.g_old_rec.per_information19

Line 270: => hr_pdt_shd.g_old_rec.per_information18

266: => hr_pdt_shd.g_old_rec.per_information16
267: ,p_per_information17_o
268: => hr_pdt_shd.g_old_rec.per_information17
269: ,p_per_information18_o
270: => hr_pdt_shd.g_old_rec.per_information18
271: ,p_per_information19_o
272: => hr_pdt_shd.g_old_rec.per_information19
273: ,p_per_information20_o
274: => hr_pdt_shd.g_old_rec.per_information20

Line 272: => hr_pdt_shd.g_old_rec.per_information19

268: => hr_pdt_shd.g_old_rec.per_information17
269: ,p_per_information18_o
270: => hr_pdt_shd.g_old_rec.per_information18
271: ,p_per_information19_o
272: => hr_pdt_shd.g_old_rec.per_information19
273: ,p_per_information20_o
274: => hr_pdt_shd.g_old_rec.per_information20
275: ,p_per_information21_o
276: => hr_pdt_shd.g_old_rec.per_information21

Line 274: => hr_pdt_shd.g_old_rec.per_information20

270: => hr_pdt_shd.g_old_rec.per_information18
271: ,p_per_information19_o
272: => hr_pdt_shd.g_old_rec.per_information19
273: ,p_per_information20_o
274: => hr_pdt_shd.g_old_rec.per_information20
275: ,p_per_information21_o
276: => hr_pdt_shd.g_old_rec.per_information21
277: ,p_per_information22_o
278: => hr_pdt_shd.g_old_rec.per_information22

Line 276: => hr_pdt_shd.g_old_rec.per_information21

272: => hr_pdt_shd.g_old_rec.per_information19
273: ,p_per_information20_o
274: => hr_pdt_shd.g_old_rec.per_information20
275: ,p_per_information21_o
276: => hr_pdt_shd.g_old_rec.per_information21
277: ,p_per_information22_o
278: => hr_pdt_shd.g_old_rec.per_information22
279: ,p_per_information23_o
280: => hr_pdt_shd.g_old_rec.per_information23

Line 278: => hr_pdt_shd.g_old_rec.per_information22

274: => hr_pdt_shd.g_old_rec.per_information20
275: ,p_per_information21_o
276: => hr_pdt_shd.g_old_rec.per_information21
277: ,p_per_information22_o
278: => hr_pdt_shd.g_old_rec.per_information22
279: ,p_per_information23_o
280: => hr_pdt_shd.g_old_rec.per_information23
281: ,p_per_information24_o
282: => hr_pdt_shd.g_old_rec.per_information24

Line 280: => hr_pdt_shd.g_old_rec.per_information23

276: => hr_pdt_shd.g_old_rec.per_information21
277: ,p_per_information22_o
278: => hr_pdt_shd.g_old_rec.per_information22
279: ,p_per_information23_o
280: => hr_pdt_shd.g_old_rec.per_information23
281: ,p_per_information24_o
282: => hr_pdt_shd.g_old_rec.per_information24
283: ,p_per_information25_o
284: => hr_pdt_shd.g_old_rec.per_information25

Line 282: => hr_pdt_shd.g_old_rec.per_information24

278: => hr_pdt_shd.g_old_rec.per_information22
279: ,p_per_information23_o
280: => hr_pdt_shd.g_old_rec.per_information23
281: ,p_per_information24_o
282: => hr_pdt_shd.g_old_rec.per_information24
283: ,p_per_information25_o
284: => hr_pdt_shd.g_old_rec.per_information25
285: ,p_per_information26_o
286: => hr_pdt_shd.g_old_rec.per_information26

Line 284: => hr_pdt_shd.g_old_rec.per_information25

280: => hr_pdt_shd.g_old_rec.per_information23
281: ,p_per_information24_o
282: => hr_pdt_shd.g_old_rec.per_information24
283: ,p_per_information25_o
284: => hr_pdt_shd.g_old_rec.per_information25
285: ,p_per_information26_o
286: => hr_pdt_shd.g_old_rec.per_information26
287: ,p_per_information27_o
288: => hr_pdt_shd.g_old_rec.per_information27

Line 286: => hr_pdt_shd.g_old_rec.per_information26

282: => hr_pdt_shd.g_old_rec.per_information24
283: ,p_per_information25_o
284: => hr_pdt_shd.g_old_rec.per_information25
285: ,p_per_information26_o
286: => hr_pdt_shd.g_old_rec.per_information26
287: ,p_per_information27_o
288: => hr_pdt_shd.g_old_rec.per_information27
289: ,p_per_information28_o
290: => hr_pdt_shd.g_old_rec.per_information28

Line 288: => hr_pdt_shd.g_old_rec.per_information27

284: => hr_pdt_shd.g_old_rec.per_information25
285: ,p_per_information26_o
286: => hr_pdt_shd.g_old_rec.per_information26
287: ,p_per_information27_o
288: => hr_pdt_shd.g_old_rec.per_information27
289: ,p_per_information28_o
290: => hr_pdt_shd.g_old_rec.per_information28
291: ,p_per_information29_o
292: => hr_pdt_shd.g_old_rec.per_information29

Line 290: => hr_pdt_shd.g_old_rec.per_information28

286: => hr_pdt_shd.g_old_rec.per_information26
287: ,p_per_information27_o
288: => hr_pdt_shd.g_old_rec.per_information27
289: ,p_per_information28_o
290: => hr_pdt_shd.g_old_rec.per_information28
291: ,p_per_information29_o
292: => hr_pdt_shd.g_old_rec.per_information29
293: ,p_per_information30_o
294: => hr_pdt_shd.g_old_rec.per_information30

Line 292: => hr_pdt_shd.g_old_rec.per_information29

288: => hr_pdt_shd.g_old_rec.per_information27
289: ,p_per_information28_o
290: => hr_pdt_shd.g_old_rec.per_information28
291: ,p_per_information29_o
292: => hr_pdt_shd.g_old_rec.per_information29
293: ,p_per_information30_o
294: => hr_pdt_shd.g_old_rec.per_information30
295: );
296: --

Line 294: => hr_pdt_shd.g_old_rec.per_information30

290: => hr_pdt_shd.g_old_rec.per_information28
291: ,p_per_information29_o
292: => hr_pdt_shd.g_old_rec.per_information29
293: ,p_per_information30_o
294: => hr_pdt_shd.g_old_rec.per_information30
295: );
296: --
297: exception
298: --

Line 314: (p_rec in hr_pdt_shd.g_rec_type

310: -- ----------------------------------------------------------------------------
311: -- |---------------------------------< del >----------------------------------|
312: -- ----------------------------------------------------------------------------
313: Procedure del
314: (p_rec in hr_pdt_shd.g_rec_type
315: ) is
316: --
317: l_proc varchar2(72) := g_package||'del';
318: --

Line 324: hr_pdt_shd.lck

320: hr_utility.set_location('Entering:'||l_proc, 5);
321: --
322: -- We must lock the row which we need to delete.
323: --
324: hr_pdt_shd.lck
325: (p_rec.person_deployment_id
326: ,p_rec.object_version_number
327: );
328: --

Line 361: l_rec hr_pdt_shd.g_rec_type;

357: (p_person_deployment_id in number
358: ,p_object_version_number in number
359: ) is
360: --
361: l_rec hr_pdt_shd.g_rec_type;
362: l_proc varchar2(72) := g_package||'del';
363: --
364: Begin
365: hr_utility.set_location('Entering:'||l_proc, 5);