82: --
83: -- {End Of Comments}
84: -- ----------------------------------------------------------------------------
85: Procedure delete_dml
86: (p_rec in pqp_pcv_shd.g_rec_type
87: ) is
88: --
89: l_proc varchar2(72) := g_package||'delete_dml';
90: --
105: Exception
106: When hr_api.child_integrity_violated then
107: -- Child integrity has been violated
108: --
109: pqp_pcv_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: --
113: Raise;
144: -- Internal Row Handler Use Only.
145: --
146: -- {End Of Comments}
147: -- ----------------------------------------------------------------------------
148: Procedure pre_delete(p_rec in pqp_pcv_shd.g_rec_type) is
149: --
150: l_proc varchar2(72) := g_package||'pre_delete';
151: --
152: Begin
186: -- Internal Row Handler Use Only.
187: --
188: -- {End Of Comments}
189: -- -----------------------------------------------------------------------------
190: Procedure post_delete(p_rec in pqp_pcv_shd.g_rec_type) is
191: --
192: l_proc varchar2(72) := g_package||'post_delete';
193: --
194: Begin
203: pqp_pcv_rkd.after_delete
204: (p_configuration_value_id
205: => p_rec.configuration_value_id
206: ,p_business_group_id_o
207: => pqp_pcv_shd.g_old_rec.business_group_id
208: ,p_legislation_code_o
209: => pqp_pcv_shd.g_old_rec.legislation_code
210: ,p_pcv_attribute_category_o
211: => pqp_pcv_shd.g_old_rec.pcv_attribute_category
205: => p_rec.configuration_value_id
206: ,p_business_group_id_o
207: => pqp_pcv_shd.g_old_rec.business_group_id
208: ,p_legislation_code_o
209: => pqp_pcv_shd.g_old_rec.legislation_code
210: ,p_pcv_attribute_category_o
211: => pqp_pcv_shd.g_old_rec.pcv_attribute_category
212: ,p_pcv_attribute1_o
213: => pqp_pcv_shd.g_old_rec.pcv_attribute1
207: => pqp_pcv_shd.g_old_rec.business_group_id
208: ,p_legislation_code_o
209: => pqp_pcv_shd.g_old_rec.legislation_code
210: ,p_pcv_attribute_category_o
211: => pqp_pcv_shd.g_old_rec.pcv_attribute_category
212: ,p_pcv_attribute1_o
213: => pqp_pcv_shd.g_old_rec.pcv_attribute1
214: ,p_pcv_attribute2_o
215: => pqp_pcv_shd.g_old_rec.pcv_attribute2
209: => pqp_pcv_shd.g_old_rec.legislation_code
210: ,p_pcv_attribute_category_o
211: => pqp_pcv_shd.g_old_rec.pcv_attribute_category
212: ,p_pcv_attribute1_o
213: => pqp_pcv_shd.g_old_rec.pcv_attribute1
214: ,p_pcv_attribute2_o
215: => pqp_pcv_shd.g_old_rec.pcv_attribute2
216: ,p_pcv_attribute3_o
217: => pqp_pcv_shd.g_old_rec.pcv_attribute3
211: => pqp_pcv_shd.g_old_rec.pcv_attribute_category
212: ,p_pcv_attribute1_o
213: => pqp_pcv_shd.g_old_rec.pcv_attribute1
214: ,p_pcv_attribute2_o
215: => pqp_pcv_shd.g_old_rec.pcv_attribute2
216: ,p_pcv_attribute3_o
217: => pqp_pcv_shd.g_old_rec.pcv_attribute3
218: ,p_pcv_attribute4_o
219: => pqp_pcv_shd.g_old_rec.pcv_attribute4
213: => pqp_pcv_shd.g_old_rec.pcv_attribute1
214: ,p_pcv_attribute2_o
215: => pqp_pcv_shd.g_old_rec.pcv_attribute2
216: ,p_pcv_attribute3_o
217: => pqp_pcv_shd.g_old_rec.pcv_attribute3
218: ,p_pcv_attribute4_o
219: => pqp_pcv_shd.g_old_rec.pcv_attribute4
220: ,p_pcv_attribute5_o
221: => pqp_pcv_shd.g_old_rec.pcv_attribute5
215: => pqp_pcv_shd.g_old_rec.pcv_attribute2
216: ,p_pcv_attribute3_o
217: => pqp_pcv_shd.g_old_rec.pcv_attribute3
218: ,p_pcv_attribute4_o
219: => pqp_pcv_shd.g_old_rec.pcv_attribute4
220: ,p_pcv_attribute5_o
221: => pqp_pcv_shd.g_old_rec.pcv_attribute5
222: ,p_pcv_attribute6_o
223: => pqp_pcv_shd.g_old_rec.pcv_attribute6
217: => pqp_pcv_shd.g_old_rec.pcv_attribute3
218: ,p_pcv_attribute4_o
219: => pqp_pcv_shd.g_old_rec.pcv_attribute4
220: ,p_pcv_attribute5_o
221: => pqp_pcv_shd.g_old_rec.pcv_attribute5
222: ,p_pcv_attribute6_o
223: => pqp_pcv_shd.g_old_rec.pcv_attribute6
224: ,p_pcv_attribute7_o
225: => pqp_pcv_shd.g_old_rec.pcv_attribute7
219: => pqp_pcv_shd.g_old_rec.pcv_attribute4
220: ,p_pcv_attribute5_o
221: => pqp_pcv_shd.g_old_rec.pcv_attribute5
222: ,p_pcv_attribute6_o
223: => pqp_pcv_shd.g_old_rec.pcv_attribute6
224: ,p_pcv_attribute7_o
225: => pqp_pcv_shd.g_old_rec.pcv_attribute7
226: ,p_pcv_attribute8_o
227: => pqp_pcv_shd.g_old_rec.pcv_attribute8
221: => pqp_pcv_shd.g_old_rec.pcv_attribute5
222: ,p_pcv_attribute6_o
223: => pqp_pcv_shd.g_old_rec.pcv_attribute6
224: ,p_pcv_attribute7_o
225: => pqp_pcv_shd.g_old_rec.pcv_attribute7
226: ,p_pcv_attribute8_o
227: => pqp_pcv_shd.g_old_rec.pcv_attribute8
228: ,p_pcv_attribute9_o
229: => pqp_pcv_shd.g_old_rec.pcv_attribute9
223: => pqp_pcv_shd.g_old_rec.pcv_attribute6
224: ,p_pcv_attribute7_o
225: => pqp_pcv_shd.g_old_rec.pcv_attribute7
226: ,p_pcv_attribute8_o
227: => pqp_pcv_shd.g_old_rec.pcv_attribute8
228: ,p_pcv_attribute9_o
229: => pqp_pcv_shd.g_old_rec.pcv_attribute9
230: ,p_pcv_attribute10_o
231: => pqp_pcv_shd.g_old_rec.pcv_attribute10
225: => pqp_pcv_shd.g_old_rec.pcv_attribute7
226: ,p_pcv_attribute8_o
227: => pqp_pcv_shd.g_old_rec.pcv_attribute8
228: ,p_pcv_attribute9_o
229: => pqp_pcv_shd.g_old_rec.pcv_attribute9
230: ,p_pcv_attribute10_o
231: => pqp_pcv_shd.g_old_rec.pcv_attribute10
232: ,p_pcv_attribute11_o
233: => pqp_pcv_shd.g_old_rec.pcv_attribute11
227: => pqp_pcv_shd.g_old_rec.pcv_attribute8
228: ,p_pcv_attribute9_o
229: => pqp_pcv_shd.g_old_rec.pcv_attribute9
230: ,p_pcv_attribute10_o
231: => pqp_pcv_shd.g_old_rec.pcv_attribute10
232: ,p_pcv_attribute11_o
233: => pqp_pcv_shd.g_old_rec.pcv_attribute11
234: ,p_pcv_attribute12_o
235: => pqp_pcv_shd.g_old_rec.pcv_attribute12
229: => pqp_pcv_shd.g_old_rec.pcv_attribute9
230: ,p_pcv_attribute10_o
231: => pqp_pcv_shd.g_old_rec.pcv_attribute10
232: ,p_pcv_attribute11_o
233: => pqp_pcv_shd.g_old_rec.pcv_attribute11
234: ,p_pcv_attribute12_o
235: => pqp_pcv_shd.g_old_rec.pcv_attribute12
236: ,p_pcv_attribute13_o
237: => pqp_pcv_shd.g_old_rec.pcv_attribute13
231: => pqp_pcv_shd.g_old_rec.pcv_attribute10
232: ,p_pcv_attribute11_o
233: => pqp_pcv_shd.g_old_rec.pcv_attribute11
234: ,p_pcv_attribute12_o
235: => pqp_pcv_shd.g_old_rec.pcv_attribute12
236: ,p_pcv_attribute13_o
237: => pqp_pcv_shd.g_old_rec.pcv_attribute13
238: ,p_pcv_attribute14_o
239: => pqp_pcv_shd.g_old_rec.pcv_attribute14
233: => pqp_pcv_shd.g_old_rec.pcv_attribute11
234: ,p_pcv_attribute12_o
235: => pqp_pcv_shd.g_old_rec.pcv_attribute12
236: ,p_pcv_attribute13_o
237: => pqp_pcv_shd.g_old_rec.pcv_attribute13
238: ,p_pcv_attribute14_o
239: => pqp_pcv_shd.g_old_rec.pcv_attribute14
240: ,p_pcv_attribute15_o
241: => pqp_pcv_shd.g_old_rec.pcv_attribute15
235: => pqp_pcv_shd.g_old_rec.pcv_attribute12
236: ,p_pcv_attribute13_o
237: => pqp_pcv_shd.g_old_rec.pcv_attribute13
238: ,p_pcv_attribute14_o
239: => pqp_pcv_shd.g_old_rec.pcv_attribute14
240: ,p_pcv_attribute15_o
241: => pqp_pcv_shd.g_old_rec.pcv_attribute15
242: ,p_pcv_attribute16_o
243: => pqp_pcv_shd.g_old_rec.pcv_attribute16
237: => pqp_pcv_shd.g_old_rec.pcv_attribute13
238: ,p_pcv_attribute14_o
239: => pqp_pcv_shd.g_old_rec.pcv_attribute14
240: ,p_pcv_attribute15_o
241: => pqp_pcv_shd.g_old_rec.pcv_attribute15
242: ,p_pcv_attribute16_o
243: => pqp_pcv_shd.g_old_rec.pcv_attribute16
244: ,p_pcv_attribute17_o
245: => pqp_pcv_shd.g_old_rec.pcv_attribute17
239: => pqp_pcv_shd.g_old_rec.pcv_attribute14
240: ,p_pcv_attribute15_o
241: => pqp_pcv_shd.g_old_rec.pcv_attribute15
242: ,p_pcv_attribute16_o
243: => pqp_pcv_shd.g_old_rec.pcv_attribute16
244: ,p_pcv_attribute17_o
245: => pqp_pcv_shd.g_old_rec.pcv_attribute17
246: ,p_pcv_attribute18_o
247: => pqp_pcv_shd.g_old_rec.pcv_attribute18
241: => pqp_pcv_shd.g_old_rec.pcv_attribute15
242: ,p_pcv_attribute16_o
243: => pqp_pcv_shd.g_old_rec.pcv_attribute16
244: ,p_pcv_attribute17_o
245: => pqp_pcv_shd.g_old_rec.pcv_attribute17
246: ,p_pcv_attribute18_o
247: => pqp_pcv_shd.g_old_rec.pcv_attribute18
248: ,p_pcv_attribute19_o
249: => pqp_pcv_shd.g_old_rec.pcv_attribute19
243: => pqp_pcv_shd.g_old_rec.pcv_attribute16
244: ,p_pcv_attribute17_o
245: => pqp_pcv_shd.g_old_rec.pcv_attribute17
246: ,p_pcv_attribute18_o
247: => pqp_pcv_shd.g_old_rec.pcv_attribute18
248: ,p_pcv_attribute19_o
249: => pqp_pcv_shd.g_old_rec.pcv_attribute19
250: ,p_pcv_attribute20_o
251: => pqp_pcv_shd.g_old_rec.pcv_attribute20
245: => pqp_pcv_shd.g_old_rec.pcv_attribute17
246: ,p_pcv_attribute18_o
247: => pqp_pcv_shd.g_old_rec.pcv_attribute18
248: ,p_pcv_attribute19_o
249: => pqp_pcv_shd.g_old_rec.pcv_attribute19
250: ,p_pcv_attribute20_o
251: => pqp_pcv_shd.g_old_rec.pcv_attribute20
252: ,p_pcv_information_category_o
253: => pqp_pcv_shd.g_old_rec.pcv_information_category
247: => pqp_pcv_shd.g_old_rec.pcv_attribute18
248: ,p_pcv_attribute19_o
249: => pqp_pcv_shd.g_old_rec.pcv_attribute19
250: ,p_pcv_attribute20_o
251: => pqp_pcv_shd.g_old_rec.pcv_attribute20
252: ,p_pcv_information_category_o
253: => pqp_pcv_shd.g_old_rec.pcv_information_category
254: ,p_pcv_information1_o
255: => pqp_pcv_shd.g_old_rec.pcv_information1
249: => pqp_pcv_shd.g_old_rec.pcv_attribute19
250: ,p_pcv_attribute20_o
251: => pqp_pcv_shd.g_old_rec.pcv_attribute20
252: ,p_pcv_information_category_o
253: => pqp_pcv_shd.g_old_rec.pcv_information_category
254: ,p_pcv_information1_o
255: => pqp_pcv_shd.g_old_rec.pcv_information1
256: ,p_pcv_information2_o
257: => pqp_pcv_shd.g_old_rec.pcv_information2
251: => pqp_pcv_shd.g_old_rec.pcv_attribute20
252: ,p_pcv_information_category_o
253: => pqp_pcv_shd.g_old_rec.pcv_information_category
254: ,p_pcv_information1_o
255: => pqp_pcv_shd.g_old_rec.pcv_information1
256: ,p_pcv_information2_o
257: => pqp_pcv_shd.g_old_rec.pcv_information2
258: ,p_pcv_information3_o
259: => pqp_pcv_shd.g_old_rec.pcv_information3
253: => pqp_pcv_shd.g_old_rec.pcv_information_category
254: ,p_pcv_information1_o
255: => pqp_pcv_shd.g_old_rec.pcv_information1
256: ,p_pcv_information2_o
257: => pqp_pcv_shd.g_old_rec.pcv_information2
258: ,p_pcv_information3_o
259: => pqp_pcv_shd.g_old_rec.pcv_information3
260: ,p_pcv_information4_o
261: => pqp_pcv_shd.g_old_rec.pcv_information4
255: => pqp_pcv_shd.g_old_rec.pcv_information1
256: ,p_pcv_information2_o
257: => pqp_pcv_shd.g_old_rec.pcv_information2
258: ,p_pcv_information3_o
259: => pqp_pcv_shd.g_old_rec.pcv_information3
260: ,p_pcv_information4_o
261: => pqp_pcv_shd.g_old_rec.pcv_information4
262: ,p_pcv_information5_o
263: => pqp_pcv_shd.g_old_rec.pcv_information5
257: => pqp_pcv_shd.g_old_rec.pcv_information2
258: ,p_pcv_information3_o
259: => pqp_pcv_shd.g_old_rec.pcv_information3
260: ,p_pcv_information4_o
261: => pqp_pcv_shd.g_old_rec.pcv_information4
262: ,p_pcv_information5_o
263: => pqp_pcv_shd.g_old_rec.pcv_information5
264: ,p_pcv_information6_o
265: => pqp_pcv_shd.g_old_rec.pcv_information6
259: => pqp_pcv_shd.g_old_rec.pcv_information3
260: ,p_pcv_information4_o
261: => pqp_pcv_shd.g_old_rec.pcv_information4
262: ,p_pcv_information5_o
263: => pqp_pcv_shd.g_old_rec.pcv_information5
264: ,p_pcv_information6_o
265: => pqp_pcv_shd.g_old_rec.pcv_information6
266: ,p_pcv_information7_o
267: => pqp_pcv_shd.g_old_rec.pcv_information7
261: => pqp_pcv_shd.g_old_rec.pcv_information4
262: ,p_pcv_information5_o
263: => pqp_pcv_shd.g_old_rec.pcv_information5
264: ,p_pcv_information6_o
265: => pqp_pcv_shd.g_old_rec.pcv_information6
266: ,p_pcv_information7_o
267: => pqp_pcv_shd.g_old_rec.pcv_information7
268: ,p_pcv_information8_o
269: => pqp_pcv_shd.g_old_rec.pcv_information8
263: => pqp_pcv_shd.g_old_rec.pcv_information5
264: ,p_pcv_information6_o
265: => pqp_pcv_shd.g_old_rec.pcv_information6
266: ,p_pcv_information7_o
267: => pqp_pcv_shd.g_old_rec.pcv_information7
268: ,p_pcv_information8_o
269: => pqp_pcv_shd.g_old_rec.pcv_information8
270: ,p_pcv_information9_o
271: => pqp_pcv_shd.g_old_rec.pcv_information9
265: => pqp_pcv_shd.g_old_rec.pcv_information6
266: ,p_pcv_information7_o
267: => pqp_pcv_shd.g_old_rec.pcv_information7
268: ,p_pcv_information8_o
269: => pqp_pcv_shd.g_old_rec.pcv_information8
270: ,p_pcv_information9_o
271: => pqp_pcv_shd.g_old_rec.pcv_information9
272: ,p_pcv_information10_o
273: => pqp_pcv_shd.g_old_rec.pcv_information10
267: => pqp_pcv_shd.g_old_rec.pcv_information7
268: ,p_pcv_information8_o
269: => pqp_pcv_shd.g_old_rec.pcv_information8
270: ,p_pcv_information9_o
271: => pqp_pcv_shd.g_old_rec.pcv_information9
272: ,p_pcv_information10_o
273: => pqp_pcv_shd.g_old_rec.pcv_information10
274: ,p_pcv_information11_o
275: => pqp_pcv_shd.g_old_rec.pcv_information11
269: => pqp_pcv_shd.g_old_rec.pcv_information8
270: ,p_pcv_information9_o
271: => pqp_pcv_shd.g_old_rec.pcv_information9
272: ,p_pcv_information10_o
273: => pqp_pcv_shd.g_old_rec.pcv_information10
274: ,p_pcv_information11_o
275: => pqp_pcv_shd.g_old_rec.pcv_information11
276: ,p_pcv_information12_o
277: => pqp_pcv_shd.g_old_rec.pcv_information12
271: => pqp_pcv_shd.g_old_rec.pcv_information9
272: ,p_pcv_information10_o
273: => pqp_pcv_shd.g_old_rec.pcv_information10
274: ,p_pcv_information11_o
275: => pqp_pcv_shd.g_old_rec.pcv_information11
276: ,p_pcv_information12_o
277: => pqp_pcv_shd.g_old_rec.pcv_information12
278: ,p_pcv_information13_o
279: => pqp_pcv_shd.g_old_rec.pcv_information13
273: => pqp_pcv_shd.g_old_rec.pcv_information10
274: ,p_pcv_information11_o
275: => pqp_pcv_shd.g_old_rec.pcv_information11
276: ,p_pcv_information12_o
277: => pqp_pcv_shd.g_old_rec.pcv_information12
278: ,p_pcv_information13_o
279: => pqp_pcv_shd.g_old_rec.pcv_information13
280: ,p_pcv_information14_o
281: => pqp_pcv_shd.g_old_rec.pcv_information14
275: => pqp_pcv_shd.g_old_rec.pcv_information11
276: ,p_pcv_information12_o
277: => pqp_pcv_shd.g_old_rec.pcv_information12
278: ,p_pcv_information13_o
279: => pqp_pcv_shd.g_old_rec.pcv_information13
280: ,p_pcv_information14_o
281: => pqp_pcv_shd.g_old_rec.pcv_information14
282: ,p_pcv_information15_o
283: => pqp_pcv_shd.g_old_rec.pcv_information15
277: => pqp_pcv_shd.g_old_rec.pcv_information12
278: ,p_pcv_information13_o
279: => pqp_pcv_shd.g_old_rec.pcv_information13
280: ,p_pcv_information14_o
281: => pqp_pcv_shd.g_old_rec.pcv_information14
282: ,p_pcv_information15_o
283: => pqp_pcv_shd.g_old_rec.pcv_information15
284: ,p_pcv_information16_o
285: => pqp_pcv_shd.g_old_rec.pcv_information16
279: => pqp_pcv_shd.g_old_rec.pcv_information13
280: ,p_pcv_information14_o
281: => pqp_pcv_shd.g_old_rec.pcv_information14
282: ,p_pcv_information15_o
283: => pqp_pcv_shd.g_old_rec.pcv_information15
284: ,p_pcv_information16_o
285: => pqp_pcv_shd.g_old_rec.pcv_information16
286: ,p_pcv_information17_o
287: => pqp_pcv_shd.g_old_rec.pcv_information17
281: => pqp_pcv_shd.g_old_rec.pcv_information14
282: ,p_pcv_information15_o
283: => pqp_pcv_shd.g_old_rec.pcv_information15
284: ,p_pcv_information16_o
285: => pqp_pcv_shd.g_old_rec.pcv_information16
286: ,p_pcv_information17_o
287: => pqp_pcv_shd.g_old_rec.pcv_information17
288: ,p_pcv_information18_o
289: => pqp_pcv_shd.g_old_rec.pcv_information18
283: => pqp_pcv_shd.g_old_rec.pcv_information15
284: ,p_pcv_information16_o
285: => pqp_pcv_shd.g_old_rec.pcv_information16
286: ,p_pcv_information17_o
287: => pqp_pcv_shd.g_old_rec.pcv_information17
288: ,p_pcv_information18_o
289: => pqp_pcv_shd.g_old_rec.pcv_information18
290: ,p_pcv_information19_o
291: => pqp_pcv_shd.g_old_rec.pcv_information19
285: => pqp_pcv_shd.g_old_rec.pcv_information16
286: ,p_pcv_information17_o
287: => pqp_pcv_shd.g_old_rec.pcv_information17
288: ,p_pcv_information18_o
289: => pqp_pcv_shd.g_old_rec.pcv_information18
290: ,p_pcv_information19_o
291: => pqp_pcv_shd.g_old_rec.pcv_information19
292: ,p_pcv_information20_o
293: => pqp_pcv_shd.g_old_rec.pcv_information20
287: => pqp_pcv_shd.g_old_rec.pcv_information17
288: ,p_pcv_information18_o
289: => pqp_pcv_shd.g_old_rec.pcv_information18
290: ,p_pcv_information19_o
291: => pqp_pcv_shd.g_old_rec.pcv_information19
292: ,p_pcv_information20_o
293: => pqp_pcv_shd.g_old_rec.pcv_information20
294: ,p_object_version_number_o
295: => pqp_pcv_shd.g_old_rec.object_version_number
289: => pqp_pcv_shd.g_old_rec.pcv_information18
290: ,p_pcv_information19_o
291: => pqp_pcv_shd.g_old_rec.pcv_information19
292: ,p_pcv_information20_o
293: => pqp_pcv_shd.g_old_rec.pcv_information20
294: ,p_object_version_number_o
295: => pqp_pcv_shd.g_old_rec.object_version_number
296: ,p_configuration_name_o
297: => pqp_pcv_shd.g_old_rec.configuration_name
291: => pqp_pcv_shd.g_old_rec.pcv_information19
292: ,p_pcv_information20_o
293: => pqp_pcv_shd.g_old_rec.pcv_information20
294: ,p_object_version_number_o
295: => pqp_pcv_shd.g_old_rec.object_version_number
296: ,p_configuration_name_o
297: => pqp_pcv_shd.g_old_rec.configuration_name
298:
299: );
293: => pqp_pcv_shd.g_old_rec.pcv_information20
294: ,p_object_version_number_o
295: => pqp_pcv_shd.g_old_rec.object_version_number
296: ,p_configuration_name_o
297: => pqp_pcv_shd.g_old_rec.configuration_name
298:
299: );
300: --
301: exception
314: -- ----------------------------------------------------------------------------
315: -- |---------------------------------< del >----------------------------------|
316: -- ----------------------------------------------------------------------------
317: Procedure del
318: (p_rec in pqp_pcv_shd.g_rec_type
319: ) is
320: --
321: l_proc varchar2(72) := g_package||'del';
322: --
324: hr_utility.set_location('Entering:'||l_proc, 5);
325: --
326: -- We must lock the row which we need to delete.
327: --
328: pqp_pcv_shd.lck
329: (p_rec.configuration_value_id
330: ,p_rec.object_version_number
331: );
332: --
361: (p_configuration_value_id in number
362: ,p_object_version_number in number
363: ) is
364: --
365: l_rec pqp_pcv_shd.g_rec_type;
366: l_proc varchar2(72) := g_package||'del';
367: --
368: Begin
369: hr_utility.set_location('Entering:'||l_proc, 5);