49: --
50: -- {End Of Comments}
51: -- ----------------------------------------------------------------------------
52: Procedure delete_dml
53: (p_rec in per_pac_shd.g_rec_type
54: ) is
55: --
56: l_proc varchar2(72) := g_package||'delete_dml';
57: --
72: Exception
73: When hr_api.child_integrity_violated then
74: -- Child integrity has been violated
75: --
76: per_pac_shd.constraint_error
77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
78: When Others Then
79: --
80: Raise;
111: -- Internal Row Handler Use Only.
112: --
113: -- {End Of Comments}
114: -- ----------------------------------------------------------------------------
115: Procedure pre_delete(p_rec in per_pac_shd.g_rec_type) is
116: --
117: l_proc varchar2(72) := g_package||'pre_delete';
118: --
119: Begin
153: -- Internal Row Handler Use Only.
154: --
155: -- {End Of Comments}
156: -- -----------------------------------------------------------------------------
157: Procedure post_delete(p_rec in per_pac_shd.g_rec_type) is
158: --
159: l_proc varchar2(72) := g_package||'post_delete';
160: --
161: Begin
165: per_pac_rkd.after_delete
166: (p_allocated_checklist_id
167: => p_rec.allocated_checklist_id
168: ,p_checklist_id_o
169: => per_pac_shd.g_old_rec.checklist_id
170: ,p_person_id_o
171: => per_pac_shd.g_old_rec.person_id
172: ,p_assignment_id_o
173: => per_pac_shd.g_old_rec.assignment_id
167: => p_rec.allocated_checklist_id
168: ,p_checklist_id_o
169: => per_pac_shd.g_old_rec.checklist_id
170: ,p_person_id_o
171: => per_pac_shd.g_old_rec.person_id
172: ,p_assignment_id_o
173: => per_pac_shd.g_old_rec.assignment_id
174: ,p_checklist_name_o
175: => per_pac_shd.g_old_rec.checklist_name
169: => per_pac_shd.g_old_rec.checklist_id
170: ,p_person_id_o
171: => per_pac_shd.g_old_rec.person_id
172: ,p_assignment_id_o
173: => per_pac_shd.g_old_rec.assignment_id
174: ,p_checklist_name_o
175: => per_pac_shd.g_old_rec.checklist_name
176: ,p_description_o
177: => per_pac_shd.g_old_rec.description
171: => per_pac_shd.g_old_rec.person_id
172: ,p_assignment_id_o
173: => per_pac_shd.g_old_rec.assignment_id
174: ,p_checklist_name_o
175: => per_pac_shd.g_old_rec.checklist_name
176: ,p_description_o
177: => per_pac_shd.g_old_rec.description
178: ,p_checklist_category_o
179: => per_pac_shd.g_old_rec.checklist_category
173: => per_pac_shd.g_old_rec.assignment_id
174: ,p_checklist_name_o
175: => per_pac_shd.g_old_rec.checklist_name
176: ,p_description_o
177: => per_pac_shd.g_old_rec.description
178: ,p_checklist_category_o
179: => per_pac_shd.g_old_rec.checklist_category
180: ,p_object_version_number_o
181: => per_pac_shd.g_old_rec.object_version_number
175: => per_pac_shd.g_old_rec.checklist_name
176: ,p_description_o
177: => per_pac_shd.g_old_rec.description
178: ,p_checklist_category_o
179: => per_pac_shd.g_old_rec.checklist_category
180: ,p_object_version_number_o
181: => per_pac_shd.g_old_rec.object_version_number
182: ,p_attribute_category_o
183: => per_pac_shd.g_old_rec.attribute_category
177: => per_pac_shd.g_old_rec.description
178: ,p_checklist_category_o
179: => per_pac_shd.g_old_rec.checklist_category
180: ,p_object_version_number_o
181: => per_pac_shd.g_old_rec.object_version_number
182: ,p_attribute_category_o
183: => per_pac_shd.g_old_rec.attribute_category
184: ,p_attribute1_o
185: => per_pac_shd.g_old_rec.attribute1
179: => per_pac_shd.g_old_rec.checklist_category
180: ,p_object_version_number_o
181: => per_pac_shd.g_old_rec.object_version_number
182: ,p_attribute_category_o
183: => per_pac_shd.g_old_rec.attribute_category
184: ,p_attribute1_o
185: => per_pac_shd.g_old_rec.attribute1
186: ,p_attribute2_o
187: => per_pac_shd.g_old_rec.attribute2
181: => per_pac_shd.g_old_rec.object_version_number
182: ,p_attribute_category_o
183: => per_pac_shd.g_old_rec.attribute_category
184: ,p_attribute1_o
185: => per_pac_shd.g_old_rec.attribute1
186: ,p_attribute2_o
187: => per_pac_shd.g_old_rec.attribute2
188: ,p_attribute3_o
189: => per_pac_shd.g_old_rec.attribute3
183: => per_pac_shd.g_old_rec.attribute_category
184: ,p_attribute1_o
185: => per_pac_shd.g_old_rec.attribute1
186: ,p_attribute2_o
187: => per_pac_shd.g_old_rec.attribute2
188: ,p_attribute3_o
189: => per_pac_shd.g_old_rec.attribute3
190: ,p_attribute4_o
191: => per_pac_shd.g_old_rec.attribute4
185: => per_pac_shd.g_old_rec.attribute1
186: ,p_attribute2_o
187: => per_pac_shd.g_old_rec.attribute2
188: ,p_attribute3_o
189: => per_pac_shd.g_old_rec.attribute3
190: ,p_attribute4_o
191: => per_pac_shd.g_old_rec.attribute4
192: ,p_attribute5_o
193: => per_pac_shd.g_old_rec.attribute5
187: => per_pac_shd.g_old_rec.attribute2
188: ,p_attribute3_o
189: => per_pac_shd.g_old_rec.attribute3
190: ,p_attribute4_o
191: => per_pac_shd.g_old_rec.attribute4
192: ,p_attribute5_o
193: => per_pac_shd.g_old_rec.attribute5
194: ,p_attribute6_o
195: => per_pac_shd.g_old_rec.attribute6
189: => per_pac_shd.g_old_rec.attribute3
190: ,p_attribute4_o
191: => per_pac_shd.g_old_rec.attribute4
192: ,p_attribute5_o
193: => per_pac_shd.g_old_rec.attribute5
194: ,p_attribute6_o
195: => per_pac_shd.g_old_rec.attribute6
196: ,p_attribute7_o
197: => per_pac_shd.g_old_rec.attribute7
191: => per_pac_shd.g_old_rec.attribute4
192: ,p_attribute5_o
193: => per_pac_shd.g_old_rec.attribute5
194: ,p_attribute6_o
195: => per_pac_shd.g_old_rec.attribute6
196: ,p_attribute7_o
197: => per_pac_shd.g_old_rec.attribute7
198: ,p_attribute8_o
199: => per_pac_shd.g_old_rec.attribute8
193: => per_pac_shd.g_old_rec.attribute5
194: ,p_attribute6_o
195: => per_pac_shd.g_old_rec.attribute6
196: ,p_attribute7_o
197: => per_pac_shd.g_old_rec.attribute7
198: ,p_attribute8_o
199: => per_pac_shd.g_old_rec.attribute8
200: ,p_attribute9_o
201: => per_pac_shd.g_old_rec.attribute9
195: => per_pac_shd.g_old_rec.attribute6
196: ,p_attribute7_o
197: => per_pac_shd.g_old_rec.attribute7
198: ,p_attribute8_o
199: => per_pac_shd.g_old_rec.attribute8
200: ,p_attribute9_o
201: => per_pac_shd.g_old_rec.attribute9
202: ,p_attribute10_o
203: => per_pac_shd.g_old_rec.attribute10
197: => per_pac_shd.g_old_rec.attribute7
198: ,p_attribute8_o
199: => per_pac_shd.g_old_rec.attribute8
200: ,p_attribute9_o
201: => per_pac_shd.g_old_rec.attribute9
202: ,p_attribute10_o
203: => per_pac_shd.g_old_rec.attribute10
204: ,p_attribute11_o
205: => per_pac_shd.g_old_rec.attribute11
199: => per_pac_shd.g_old_rec.attribute8
200: ,p_attribute9_o
201: => per_pac_shd.g_old_rec.attribute9
202: ,p_attribute10_o
203: => per_pac_shd.g_old_rec.attribute10
204: ,p_attribute11_o
205: => per_pac_shd.g_old_rec.attribute11
206: ,p_attribute12_o
207: => per_pac_shd.g_old_rec.attribute12
201: => per_pac_shd.g_old_rec.attribute9
202: ,p_attribute10_o
203: => per_pac_shd.g_old_rec.attribute10
204: ,p_attribute11_o
205: => per_pac_shd.g_old_rec.attribute11
206: ,p_attribute12_o
207: => per_pac_shd.g_old_rec.attribute12
208: ,p_attribute13_o
209: => per_pac_shd.g_old_rec.attribute13
203: => per_pac_shd.g_old_rec.attribute10
204: ,p_attribute11_o
205: => per_pac_shd.g_old_rec.attribute11
206: ,p_attribute12_o
207: => per_pac_shd.g_old_rec.attribute12
208: ,p_attribute13_o
209: => per_pac_shd.g_old_rec.attribute13
210: ,p_attribute14_o
211: => per_pac_shd.g_old_rec.attribute14
205: => per_pac_shd.g_old_rec.attribute11
206: ,p_attribute12_o
207: => per_pac_shd.g_old_rec.attribute12
208: ,p_attribute13_o
209: => per_pac_shd.g_old_rec.attribute13
210: ,p_attribute14_o
211: => per_pac_shd.g_old_rec.attribute14
212: ,p_attribute15_o
213: => per_pac_shd.g_old_rec.attribute15
207: => per_pac_shd.g_old_rec.attribute12
208: ,p_attribute13_o
209: => per_pac_shd.g_old_rec.attribute13
210: ,p_attribute14_o
211: => per_pac_shd.g_old_rec.attribute14
212: ,p_attribute15_o
213: => per_pac_shd.g_old_rec.attribute15
214: ,p_attribute16_o
215: => per_pac_shd.g_old_rec.attribute16
209: => per_pac_shd.g_old_rec.attribute13
210: ,p_attribute14_o
211: => per_pac_shd.g_old_rec.attribute14
212: ,p_attribute15_o
213: => per_pac_shd.g_old_rec.attribute15
214: ,p_attribute16_o
215: => per_pac_shd.g_old_rec.attribute16
216: ,p_attribute17_o
217: => per_pac_shd.g_old_rec.attribute17
211: => per_pac_shd.g_old_rec.attribute14
212: ,p_attribute15_o
213: => per_pac_shd.g_old_rec.attribute15
214: ,p_attribute16_o
215: => per_pac_shd.g_old_rec.attribute16
216: ,p_attribute17_o
217: => per_pac_shd.g_old_rec.attribute17
218: ,p_attribute18_o
219: => per_pac_shd.g_old_rec.attribute18
213: => per_pac_shd.g_old_rec.attribute15
214: ,p_attribute16_o
215: => per_pac_shd.g_old_rec.attribute16
216: ,p_attribute17_o
217: => per_pac_shd.g_old_rec.attribute17
218: ,p_attribute18_o
219: => per_pac_shd.g_old_rec.attribute18
220: ,p_attribute19_o
221: => per_pac_shd.g_old_rec.attribute19
215: => per_pac_shd.g_old_rec.attribute16
216: ,p_attribute17_o
217: => per_pac_shd.g_old_rec.attribute17
218: ,p_attribute18_o
219: => per_pac_shd.g_old_rec.attribute18
220: ,p_attribute19_o
221: => per_pac_shd.g_old_rec.attribute19
222: ,p_attribute20_o
223: => per_pac_shd.g_old_rec.attribute20
217: => per_pac_shd.g_old_rec.attribute17
218: ,p_attribute18_o
219: => per_pac_shd.g_old_rec.attribute18
220: ,p_attribute19_o
221: => per_pac_shd.g_old_rec.attribute19
222: ,p_attribute20_o
223: => per_pac_shd.g_old_rec.attribute20
224: ,p_information_category_o
225: => per_pac_shd.g_old_rec.information_category
219: => per_pac_shd.g_old_rec.attribute18
220: ,p_attribute19_o
221: => per_pac_shd.g_old_rec.attribute19
222: ,p_attribute20_o
223: => per_pac_shd.g_old_rec.attribute20
224: ,p_information_category_o
225: => per_pac_shd.g_old_rec.information_category
226: ,p_information1_o
227: => per_pac_shd.g_old_rec.information1
221: => per_pac_shd.g_old_rec.attribute19
222: ,p_attribute20_o
223: => per_pac_shd.g_old_rec.attribute20
224: ,p_information_category_o
225: => per_pac_shd.g_old_rec.information_category
226: ,p_information1_o
227: => per_pac_shd.g_old_rec.information1
228: ,p_information2_o
229: => per_pac_shd.g_old_rec.information2
223: => per_pac_shd.g_old_rec.attribute20
224: ,p_information_category_o
225: => per_pac_shd.g_old_rec.information_category
226: ,p_information1_o
227: => per_pac_shd.g_old_rec.information1
228: ,p_information2_o
229: => per_pac_shd.g_old_rec.information2
230: ,p_information3_o
231: => per_pac_shd.g_old_rec.information3
225: => per_pac_shd.g_old_rec.information_category
226: ,p_information1_o
227: => per_pac_shd.g_old_rec.information1
228: ,p_information2_o
229: => per_pac_shd.g_old_rec.information2
230: ,p_information3_o
231: => per_pac_shd.g_old_rec.information3
232: ,p_information4_o
233: => per_pac_shd.g_old_rec.information4
227: => per_pac_shd.g_old_rec.information1
228: ,p_information2_o
229: => per_pac_shd.g_old_rec.information2
230: ,p_information3_o
231: => per_pac_shd.g_old_rec.information3
232: ,p_information4_o
233: => per_pac_shd.g_old_rec.information4
234: ,p_information5_o
235: => per_pac_shd.g_old_rec.information5
229: => per_pac_shd.g_old_rec.information2
230: ,p_information3_o
231: => per_pac_shd.g_old_rec.information3
232: ,p_information4_o
233: => per_pac_shd.g_old_rec.information4
234: ,p_information5_o
235: => per_pac_shd.g_old_rec.information5
236: ,p_information6_o
237: => per_pac_shd.g_old_rec.information6
231: => per_pac_shd.g_old_rec.information3
232: ,p_information4_o
233: => per_pac_shd.g_old_rec.information4
234: ,p_information5_o
235: => per_pac_shd.g_old_rec.information5
236: ,p_information6_o
237: => per_pac_shd.g_old_rec.information6
238: ,p_information7_o
239: => per_pac_shd.g_old_rec.information7
233: => per_pac_shd.g_old_rec.information4
234: ,p_information5_o
235: => per_pac_shd.g_old_rec.information5
236: ,p_information6_o
237: => per_pac_shd.g_old_rec.information6
238: ,p_information7_o
239: => per_pac_shd.g_old_rec.information7
240: ,p_information8_o
241: => per_pac_shd.g_old_rec.information8
235: => per_pac_shd.g_old_rec.information5
236: ,p_information6_o
237: => per_pac_shd.g_old_rec.information6
238: ,p_information7_o
239: => per_pac_shd.g_old_rec.information7
240: ,p_information8_o
241: => per_pac_shd.g_old_rec.information8
242: ,p_information9_o
243: => per_pac_shd.g_old_rec.information9
237: => per_pac_shd.g_old_rec.information6
238: ,p_information7_o
239: => per_pac_shd.g_old_rec.information7
240: ,p_information8_o
241: => per_pac_shd.g_old_rec.information8
242: ,p_information9_o
243: => per_pac_shd.g_old_rec.information9
244: ,p_information10_o
245: => per_pac_shd.g_old_rec.information10
239: => per_pac_shd.g_old_rec.information7
240: ,p_information8_o
241: => per_pac_shd.g_old_rec.information8
242: ,p_information9_o
243: => per_pac_shd.g_old_rec.information9
244: ,p_information10_o
245: => per_pac_shd.g_old_rec.information10
246: ,p_information11_o
247: => per_pac_shd.g_old_rec.information11
241: => per_pac_shd.g_old_rec.information8
242: ,p_information9_o
243: => per_pac_shd.g_old_rec.information9
244: ,p_information10_o
245: => per_pac_shd.g_old_rec.information10
246: ,p_information11_o
247: => per_pac_shd.g_old_rec.information11
248: ,p_information12_o
249: => per_pac_shd.g_old_rec.information12
243: => per_pac_shd.g_old_rec.information9
244: ,p_information10_o
245: => per_pac_shd.g_old_rec.information10
246: ,p_information11_o
247: => per_pac_shd.g_old_rec.information11
248: ,p_information12_o
249: => per_pac_shd.g_old_rec.information12
250: ,p_information13_o
251: => per_pac_shd.g_old_rec.information13
245: => per_pac_shd.g_old_rec.information10
246: ,p_information11_o
247: => per_pac_shd.g_old_rec.information11
248: ,p_information12_o
249: => per_pac_shd.g_old_rec.information12
250: ,p_information13_o
251: => per_pac_shd.g_old_rec.information13
252: ,p_information14_o
253: => per_pac_shd.g_old_rec.information14
247: => per_pac_shd.g_old_rec.information11
248: ,p_information12_o
249: => per_pac_shd.g_old_rec.information12
250: ,p_information13_o
251: => per_pac_shd.g_old_rec.information13
252: ,p_information14_o
253: => per_pac_shd.g_old_rec.information14
254: ,p_information15_o
255: => per_pac_shd.g_old_rec.information15
249: => per_pac_shd.g_old_rec.information12
250: ,p_information13_o
251: => per_pac_shd.g_old_rec.information13
252: ,p_information14_o
253: => per_pac_shd.g_old_rec.information14
254: ,p_information15_o
255: => per_pac_shd.g_old_rec.information15
256: ,p_information16_o
257: => per_pac_shd.g_old_rec.information16
251: => per_pac_shd.g_old_rec.information13
252: ,p_information14_o
253: => per_pac_shd.g_old_rec.information14
254: ,p_information15_o
255: => per_pac_shd.g_old_rec.information15
256: ,p_information16_o
257: => per_pac_shd.g_old_rec.information16
258: ,p_information17_o
259: => per_pac_shd.g_old_rec.information17
253: => per_pac_shd.g_old_rec.information14
254: ,p_information15_o
255: => per_pac_shd.g_old_rec.information15
256: ,p_information16_o
257: => per_pac_shd.g_old_rec.information16
258: ,p_information17_o
259: => per_pac_shd.g_old_rec.information17
260: ,p_information18_o
261: => per_pac_shd.g_old_rec.information18
255: => per_pac_shd.g_old_rec.information15
256: ,p_information16_o
257: => per_pac_shd.g_old_rec.information16
258: ,p_information17_o
259: => per_pac_shd.g_old_rec.information17
260: ,p_information18_o
261: => per_pac_shd.g_old_rec.information18
262: ,p_information19_o
263: => per_pac_shd.g_old_rec.information19
257: => per_pac_shd.g_old_rec.information16
258: ,p_information17_o
259: => per_pac_shd.g_old_rec.information17
260: ,p_information18_o
261: => per_pac_shd.g_old_rec.information18
262: ,p_information19_o
263: => per_pac_shd.g_old_rec.information19
264: ,p_information20_o
265: => per_pac_shd.g_old_rec.information20
259: => per_pac_shd.g_old_rec.information17
260: ,p_information18_o
261: => per_pac_shd.g_old_rec.information18
262: ,p_information19_o
263: => per_pac_shd.g_old_rec.information19
264: ,p_information20_o
265: => per_pac_shd.g_old_rec.information20
266: );
267: --
261: => per_pac_shd.g_old_rec.information18
262: ,p_information19_o
263: => per_pac_shd.g_old_rec.information19
264: ,p_information20_o
265: => per_pac_shd.g_old_rec.information20
266: );
267: --
268: exception
269: --
281: -- ----------------------------------------------------------------------------
282: -- |---------------------------------< del >----------------------------------|
283: -- ----------------------------------------------------------------------------
284: Procedure del
285: (p_rec in per_pac_shd.g_rec_type
286: ) is
287: --
288: l_proc varchar2(72) := g_package||'del';
289: --
291: hr_utility.set_location('Entering:'||l_proc, 5);
292: --
293: -- We must lock the row which we need to delete.
294: --
295: per_pac_shd.lck
296: (p_rec.allocated_checklist_id
297: ,p_rec.object_version_number
298: );
299: --
328: (p_allocated_checklist_id in number
329: ,p_object_version_number in number
330: ) is
331: --
332: l_rec per_pac_shd.g_rec_type;
333: l_proc varchar2(72) := g_package||'del';
334: --
335: Begin
336: hr_utility.set_location('Entering:'||l_proc, 5);