eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_LPE_DEL dependencies on OTA_LPE_SHD

Line 52: (p_rec in ota_lpe_shd.g_rec_type

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

Line 75: ota_lpe_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: --
75: ota_lpe_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 ota_lpe_shd.g_rec_type) is

110: -- Internal Row Handler Use Only.
111: --
112: -- {End Of Comments}
113: -- ----------------------------------------------------------------------------
114: Procedure pre_delete(p_rec in ota_lpe_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 ota_lpe_shd.g_rec_type) is

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

Line 168: => ota_lpe_shd.g_old_rec.learning_path_id

164: ota_lpe_rkd.after_delete
165: (p_lp_enrollment_id
166: => p_rec.lp_enrollment_id
167: ,p_learning_path_id_o
168: => ota_lpe_shd.g_old_rec.learning_path_id
169: ,p_person_id_o
170: => ota_lpe_shd.g_old_rec.person_id
171: ,p_contact_id_o
172: => ota_lpe_shd.g_old_rec.contact_id

Line 170: => ota_lpe_shd.g_old_rec.person_id

166: => p_rec.lp_enrollment_id
167: ,p_learning_path_id_o
168: => ota_lpe_shd.g_old_rec.learning_path_id
169: ,p_person_id_o
170: => ota_lpe_shd.g_old_rec.person_id
171: ,p_contact_id_o
172: => ota_lpe_shd.g_old_rec.contact_id
173: ,p_path_status_code_o
174: => ota_lpe_shd.g_old_rec.path_status_code

Line 172: => ota_lpe_shd.g_old_rec.contact_id

168: => ota_lpe_shd.g_old_rec.learning_path_id
169: ,p_person_id_o
170: => ota_lpe_shd.g_old_rec.person_id
171: ,p_contact_id_o
172: => ota_lpe_shd.g_old_rec.contact_id
173: ,p_path_status_code_o
174: => ota_lpe_shd.g_old_rec.path_status_code
175: ,p_enrollment_source_code_o
176: => ota_lpe_shd.g_old_rec.enrollment_source_code

Line 174: => ota_lpe_shd.g_old_rec.path_status_code

170: => ota_lpe_shd.g_old_rec.person_id
171: ,p_contact_id_o
172: => ota_lpe_shd.g_old_rec.contact_id
173: ,p_path_status_code_o
174: => ota_lpe_shd.g_old_rec.path_status_code
175: ,p_enrollment_source_code_o
176: => ota_lpe_shd.g_old_rec.enrollment_source_code
177: ,p_no_of_mandatory_courses_o
178: => ota_lpe_shd.g_old_rec.no_of_mandatory_courses

Line 176: => ota_lpe_shd.g_old_rec.enrollment_source_code

172: => ota_lpe_shd.g_old_rec.contact_id
173: ,p_path_status_code_o
174: => ota_lpe_shd.g_old_rec.path_status_code
175: ,p_enrollment_source_code_o
176: => ota_lpe_shd.g_old_rec.enrollment_source_code
177: ,p_no_of_mandatory_courses_o
178: => ota_lpe_shd.g_old_rec.no_of_mandatory_courses
179: ,p_no_of_completed_courses_o
180: => ota_lpe_shd.g_old_rec.no_of_completed_courses

Line 178: => ota_lpe_shd.g_old_rec.no_of_mandatory_courses

174: => ota_lpe_shd.g_old_rec.path_status_code
175: ,p_enrollment_source_code_o
176: => ota_lpe_shd.g_old_rec.enrollment_source_code
177: ,p_no_of_mandatory_courses_o
178: => ota_lpe_shd.g_old_rec.no_of_mandatory_courses
179: ,p_no_of_completed_courses_o
180: => ota_lpe_shd.g_old_rec.no_of_completed_courses
181: ,p_completion_target_date_o
182: => ota_lpe_shd.g_old_rec.completion_target_date

Line 180: => ota_lpe_shd.g_old_rec.no_of_completed_courses

176: => ota_lpe_shd.g_old_rec.enrollment_source_code
177: ,p_no_of_mandatory_courses_o
178: => ota_lpe_shd.g_old_rec.no_of_mandatory_courses
179: ,p_no_of_completed_courses_o
180: => ota_lpe_shd.g_old_rec.no_of_completed_courses
181: ,p_completion_target_date_o
182: => ota_lpe_shd.g_old_rec.completion_target_date
183: ,p_completion_date_o
184: => ota_lpe_shd.g_old_rec.completion_date

Line 182: => ota_lpe_shd.g_old_rec.completion_target_date

178: => ota_lpe_shd.g_old_rec.no_of_mandatory_courses
179: ,p_no_of_completed_courses_o
180: => ota_lpe_shd.g_old_rec.no_of_completed_courses
181: ,p_completion_target_date_o
182: => ota_lpe_shd.g_old_rec.completion_target_date
183: ,p_completion_date_o
184: => ota_lpe_shd.g_old_rec.completion_date
185: ,p_creator_person_id_o
186: => ota_lpe_shd.g_old_rec.creator_person_id

Line 184: => ota_lpe_shd.g_old_rec.completion_date

180: => ota_lpe_shd.g_old_rec.no_of_completed_courses
181: ,p_completion_target_date_o
182: => ota_lpe_shd.g_old_rec.completion_target_date
183: ,p_completion_date_o
184: => ota_lpe_shd.g_old_rec.completion_date
185: ,p_creator_person_id_o
186: => ota_lpe_shd.g_old_rec.creator_person_id
187: ,p_object_version_number_o
188: => ota_lpe_shd.g_old_rec.object_version_number

Line 186: => ota_lpe_shd.g_old_rec.creator_person_id

182: => ota_lpe_shd.g_old_rec.completion_target_date
183: ,p_completion_date_o
184: => ota_lpe_shd.g_old_rec.completion_date
185: ,p_creator_person_id_o
186: => ota_lpe_shd.g_old_rec.creator_person_id
187: ,p_object_version_number_o
188: => ota_lpe_shd.g_old_rec.object_version_number
189: ,p_business_group_id_o
190: => ota_lpe_shd.g_old_rec.business_group_id

Line 188: => ota_lpe_shd.g_old_rec.object_version_number

184: => ota_lpe_shd.g_old_rec.completion_date
185: ,p_creator_person_id_o
186: => ota_lpe_shd.g_old_rec.creator_person_id
187: ,p_object_version_number_o
188: => ota_lpe_shd.g_old_rec.object_version_number
189: ,p_business_group_id_o
190: => ota_lpe_shd.g_old_rec.business_group_id
191: ,p_attribute_category_o
192: => ota_lpe_shd.g_old_rec.attribute_category

Line 190: => ota_lpe_shd.g_old_rec.business_group_id

186: => ota_lpe_shd.g_old_rec.creator_person_id
187: ,p_object_version_number_o
188: => ota_lpe_shd.g_old_rec.object_version_number
189: ,p_business_group_id_o
190: => ota_lpe_shd.g_old_rec.business_group_id
191: ,p_attribute_category_o
192: => ota_lpe_shd.g_old_rec.attribute_category
193: ,p_attribute1_o
194: => ota_lpe_shd.g_old_rec.attribute1

Line 192: => ota_lpe_shd.g_old_rec.attribute_category

188: => ota_lpe_shd.g_old_rec.object_version_number
189: ,p_business_group_id_o
190: => ota_lpe_shd.g_old_rec.business_group_id
191: ,p_attribute_category_o
192: => ota_lpe_shd.g_old_rec.attribute_category
193: ,p_attribute1_o
194: => ota_lpe_shd.g_old_rec.attribute1
195: ,p_attribute2_o
196: => ota_lpe_shd.g_old_rec.attribute2

Line 194: => ota_lpe_shd.g_old_rec.attribute1

190: => ota_lpe_shd.g_old_rec.business_group_id
191: ,p_attribute_category_o
192: => ota_lpe_shd.g_old_rec.attribute_category
193: ,p_attribute1_o
194: => ota_lpe_shd.g_old_rec.attribute1
195: ,p_attribute2_o
196: => ota_lpe_shd.g_old_rec.attribute2
197: ,p_attribute3_o
198: => ota_lpe_shd.g_old_rec.attribute3

Line 196: => ota_lpe_shd.g_old_rec.attribute2

192: => ota_lpe_shd.g_old_rec.attribute_category
193: ,p_attribute1_o
194: => ota_lpe_shd.g_old_rec.attribute1
195: ,p_attribute2_o
196: => ota_lpe_shd.g_old_rec.attribute2
197: ,p_attribute3_o
198: => ota_lpe_shd.g_old_rec.attribute3
199: ,p_attribute4_o
200: => ota_lpe_shd.g_old_rec.attribute4

Line 198: => ota_lpe_shd.g_old_rec.attribute3

194: => ota_lpe_shd.g_old_rec.attribute1
195: ,p_attribute2_o
196: => ota_lpe_shd.g_old_rec.attribute2
197: ,p_attribute3_o
198: => ota_lpe_shd.g_old_rec.attribute3
199: ,p_attribute4_o
200: => ota_lpe_shd.g_old_rec.attribute4
201: ,p_attribute5_o
202: => ota_lpe_shd.g_old_rec.attribute5

Line 200: => ota_lpe_shd.g_old_rec.attribute4

196: => ota_lpe_shd.g_old_rec.attribute2
197: ,p_attribute3_o
198: => ota_lpe_shd.g_old_rec.attribute3
199: ,p_attribute4_o
200: => ota_lpe_shd.g_old_rec.attribute4
201: ,p_attribute5_o
202: => ota_lpe_shd.g_old_rec.attribute5
203: ,p_attribute6_o
204: => ota_lpe_shd.g_old_rec.attribute6

Line 202: => ota_lpe_shd.g_old_rec.attribute5

198: => ota_lpe_shd.g_old_rec.attribute3
199: ,p_attribute4_o
200: => ota_lpe_shd.g_old_rec.attribute4
201: ,p_attribute5_o
202: => ota_lpe_shd.g_old_rec.attribute5
203: ,p_attribute6_o
204: => ota_lpe_shd.g_old_rec.attribute6
205: ,p_attribute7_o
206: => ota_lpe_shd.g_old_rec.attribute7

Line 204: => ota_lpe_shd.g_old_rec.attribute6

200: => ota_lpe_shd.g_old_rec.attribute4
201: ,p_attribute5_o
202: => ota_lpe_shd.g_old_rec.attribute5
203: ,p_attribute6_o
204: => ota_lpe_shd.g_old_rec.attribute6
205: ,p_attribute7_o
206: => ota_lpe_shd.g_old_rec.attribute7
207: ,p_attribute8_o
208: => ota_lpe_shd.g_old_rec.attribute8

Line 206: => ota_lpe_shd.g_old_rec.attribute7

202: => ota_lpe_shd.g_old_rec.attribute5
203: ,p_attribute6_o
204: => ota_lpe_shd.g_old_rec.attribute6
205: ,p_attribute7_o
206: => ota_lpe_shd.g_old_rec.attribute7
207: ,p_attribute8_o
208: => ota_lpe_shd.g_old_rec.attribute8
209: ,p_attribute9_o
210: => ota_lpe_shd.g_old_rec.attribute9

Line 208: => ota_lpe_shd.g_old_rec.attribute8

204: => ota_lpe_shd.g_old_rec.attribute6
205: ,p_attribute7_o
206: => ota_lpe_shd.g_old_rec.attribute7
207: ,p_attribute8_o
208: => ota_lpe_shd.g_old_rec.attribute8
209: ,p_attribute9_o
210: => ota_lpe_shd.g_old_rec.attribute9
211: ,p_attribute10_o
212: => ota_lpe_shd.g_old_rec.attribute10

Line 210: => ota_lpe_shd.g_old_rec.attribute9

206: => ota_lpe_shd.g_old_rec.attribute7
207: ,p_attribute8_o
208: => ota_lpe_shd.g_old_rec.attribute8
209: ,p_attribute9_o
210: => ota_lpe_shd.g_old_rec.attribute9
211: ,p_attribute10_o
212: => ota_lpe_shd.g_old_rec.attribute10
213: ,p_attribute11_o
214: => ota_lpe_shd.g_old_rec.attribute11

Line 212: => ota_lpe_shd.g_old_rec.attribute10

208: => ota_lpe_shd.g_old_rec.attribute8
209: ,p_attribute9_o
210: => ota_lpe_shd.g_old_rec.attribute9
211: ,p_attribute10_o
212: => ota_lpe_shd.g_old_rec.attribute10
213: ,p_attribute11_o
214: => ota_lpe_shd.g_old_rec.attribute11
215: ,p_attribute12_o
216: => ota_lpe_shd.g_old_rec.attribute12

Line 214: => ota_lpe_shd.g_old_rec.attribute11

210: => ota_lpe_shd.g_old_rec.attribute9
211: ,p_attribute10_o
212: => ota_lpe_shd.g_old_rec.attribute10
213: ,p_attribute11_o
214: => ota_lpe_shd.g_old_rec.attribute11
215: ,p_attribute12_o
216: => ota_lpe_shd.g_old_rec.attribute12
217: ,p_attribute13_o
218: => ota_lpe_shd.g_old_rec.attribute13

Line 216: => ota_lpe_shd.g_old_rec.attribute12

212: => ota_lpe_shd.g_old_rec.attribute10
213: ,p_attribute11_o
214: => ota_lpe_shd.g_old_rec.attribute11
215: ,p_attribute12_o
216: => ota_lpe_shd.g_old_rec.attribute12
217: ,p_attribute13_o
218: => ota_lpe_shd.g_old_rec.attribute13
219: ,p_attribute14_o
220: => ota_lpe_shd.g_old_rec.attribute14

Line 218: => ota_lpe_shd.g_old_rec.attribute13

214: => ota_lpe_shd.g_old_rec.attribute11
215: ,p_attribute12_o
216: => ota_lpe_shd.g_old_rec.attribute12
217: ,p_attribute13_o
218: => ota_lpe_shd.g_old_rec.attribute13
219: ,p_attribute14_o
220: => ota_lpe_shd.g_old_rec.attribute14
221: ,p_attribute15_o
222: => ota_lpe_shd.g_old_rec.attribute15

Line 220: => ota_lpe_shd.g_old_rec.attribute14

216: => ota_lpe_shd.g_old_rec.attribute12
217: ,p_attribute13_o
218: => ota_lpe_shd.g_old_rec.attribute13
219: ,p_attribute14_o
220: => ota_lpe_shd.g_old_rec.attribute14
221: ,p_attribute15_o
222: => ota_lpe_shd.g_old_rec.attribute15
223: ,p_attribute16_o
224: => ota_lpe_shd.g_old_rec.attribute16

Line 222: => ota_lpe_shd.g_old_rec.attribute15

218: => ota_lpe_shd.g_old_rec.attribute13
219: ,p_attribute14_o
220: => ota_lpe_shd.g_old_rec.attribute14
221: ,p_attribute15_o
222: => ota_lpe_shd.g_old_rec.attribute15
223: ,p_attribute16_o
224: => ota_lpe_shd.g_old_rec.attribute16
225: ,p_attribute17_o
226: => ota_lpe_shd.g_old_rec.attribute17

Line 224: => ota_lpe_shd.g_old_rec.attribute16

220: => ota_lpe_shd.g_old_rec.attribute14
221: ,p_attribute15_o
222: => ota_lpe_shd.g_old_rec.attribute15
223: ,p_attribute16_o
224: => ota_lpe_shd.g_old_rec.attribute16
225: ,p_attribute17_o
226: => ota_lpe_shd.g_old_rec.attribute17
227: ,p_attribute18_o
228: => ota_lpe_shd.g_old_rec.attribute18

Line 226: => ota_lpe_shd.g_old_rec.attribute17

222: => ota_lpe_shd.g_old_rec.attribute15
223: ,p_attribute16_o
224: => ota_lpe_shd.g_old_rec.attribute16
225: ,p_attribute17_o
226: => ota_lpe_shd.g_old_rec.attribute17
227: ,p_attribute18_o
228: => ota_lpe_shd.g_old_rec.attribute18
229: ,p_attribute19_o
230: => ota_lpe_shd.g_old_rec.attribute19

Line 228: => ota_lpe_shd.g_old_rec.attribute18

224: => ota_lpe_shd.g_old_rec.attribute16
225: ,p_attribute17_o
226: => ota_lpe_shd.g_old_rec.attribute17
227: ,p_attribute18_o
228: => ota_lpe_shd.g_old_rec.attribute18
229: ,p_attribute19_o
230: => ota_lpe_shd.g_old_rec.attribute19
231: ,p_attribute20_o
232: => ota_lpe_shd.g_old_rec.attribute20

Line 230: => ota_lpe_shd.g_old_rec.attribute19

226: => ota_lpe_shd.g_old_rec.attribute17
227: ,p_attribute18_o
228: => ota_lpe_shd.g_old_rec.attribute18
229: ,p_attribute19_o
230: => ota_lpe_shd.g_old_rec.attribute19
231: ,p_attribute20_o
232: => ota_lpe_shd.g_old_rec.attribute20
233: ,p_attribute21_o
234: => ota_lpe_shd.g_old_rec.attribute21

Line 232: => ota_lpe_shd.g_old_rec.attribute20

228: => ota_lpe_shd.g_old_rec.attribute18
229: ,p_attribute19_o
230: => ota_lpe_shd.g_old_rec.attribute19
231: ,p_attribute20_o
232: => ota_lpe_shd.g_old_rec.attribute20
233: ,p_attribute21_o
234: => ota_lpe_shd.g_old_rec.attribute21
235: ,p_attribute22_o
236: => ota_lpe_shd.g_old_rec.attribute22

Line 234: => ota_lpe_shd.g_old_rec.attribute21

230: => ota_lpe_shd.g_old_rec.attribute19
231: ,p_attribute20_o
232: => ota_lpe_shd.g_old_rec.attribute20
233: ,p_attribute21_o
234: => ota_lpe_shd.g_old_rec.attribute21
235: ,p_attribute22_o
236: => ota_lpe_shd.g_old_rec.attribute22
237: ,p_attribute23_o
238: => ota_lpe_shd.g_old_rec.attribute23

Line 236: => ota_lpe_shd.g_old_rec.attribute22

232: => ota_lpe_shd.g_old_rec.attribute20
233: ,p_attribute21_o
234: => ota_lpe_shd.g_old_rec.attribute21
235: ,p_attribute22_o
236: => ota_lpe_shd.g_old_rec.attribute22
237: ,p_attribute23_o
238: => ota_lpe_shd.g_old_rec.attribute23
239: ,p_attribute24_o
240: => ota_lpe_shd.g_old_rec.attribute24

Line 238: => ota_lpe_shd.g_old_rec.attribute23

234: => ota_lpe_shd.g_old_rec.attribute21
235: ,p_attribute22_o
236: => ota_lpe_shd.g_old_rec.attribute22
237: ,p_attribute23_o
238: => ota_lpe_shd.g_old_rec.attribute23
239: ,p_attribute24_o
240: => ota_lpe_shd.g_old_rec.attribute24
241: ,p_attribute25_o
242: => ota_lpe_shd.g_old_rec.attribute25

Line 240: => ota_lpe_shd.g_old_rec.attribute24

236: => ota_lpe_shd.g_old_rec.attribute22
237: ,p_attribute23_o
238: => ota_lpe_shd.g_old_rec.attribute23
239: ,p_attribute24_o
240: => ota_lpe_shd.g_old_rec.attribute24
241: ,p_attribute25_o
242: => ota_lpe_shd.g_old_rec.attribute25
243: ,p_attribute26_o
244: => ota_lpe_shd.g_old_rec.attribute26

Line 242: => ota_lpe_shd.g_old_rec.attribute25

238: => ota_lpe_shd.g_old_rec.attribute23
239: ,p_attribute24_o
240: => ota_lpe_shd.g_old_rec.attribute24
241: ,p_attribute25_o
242: => ota_lpe_shd.g_old_rec.attribute25
243: ,p_attribute26_o
244: => ota_lpe_shd.g_old_rec.attribute26
245: ,p_attribute27_o
246: => ota_lpe_shd.g_old_rec.attribute27

Line 244: => ota_lpe_shd.g_old_rec.attribute26

240: => ota_lpe_shd.g_old_rec.attribute24
241: ,p_attribute25_o
242: => ota_lpe_shd.g_old_rec.attribute25
243: ,p_attribute26_o
244: => ota_lpe_shd.g_old_rec.attribute26
245: ,p_attribute27_o
246: => ota_lpe_shd.g_old_rec.attribute27
247: ,p_attribute28_o
248: => ota_lpe_shd.g_old_rec.attribute28

Line 246: => ota_lpe_shd.g_old_rec.attribute27

242: => ota_lpe_shd.g_old_rec.attribute25
243: ,p_attribute26_o
244: => ota_lpe_shd.g_old_rec.attribute26
245: ,p_attribute27_o
246: => ota_lpe_shd.g_old_rec.attribute27
247: ,p_attribute28_o
248: => ota_lpe_shd.g_old_rec.attribute28
249: ,p_attribute29_o
250: => ota_lpe_shd.g_old_rec.attribute29

Line 248: => ota_lpe_shd.g_old_rec.attribute28

244: => ota_lpe_shd.g_old_rec.attribute26
245: ,p_attribute27_o
246: => ota_lpe_shd.g_old_rec.attribute27
247: ,p_attribute28_o
248: => ota_lpe_shd.g_old_rec.attribute28
249: ,p_attribute29_o
250: => ota_lpe_shd.g_old_rec.attribute29
251: ,p_attribute30_o
252: => ota_lpe_shd.g_old_rec.attribute30

Line 250: => ota_lpe_shd.g_old_rec.attribute29

246: => ota_lpe_shd.g_old_rec.attribute27
247: ,p_attribute28_o
248: => ota_lpe_shd.g_old_rec.attribute28
249: ,p_attribute29_o
250: => ota_lpe_shd.g_old_rec.attribute29
251: ,p_attribute30_o
252: => ota_lpe_shd.g_old_rec.attribute30
253: ,p_is_history_flag_o
254: => ota_lpe_shd.g_old_rec.is_history_flag

Line 252: => ota_lpe_shd.g_old_rec.attribute30

248: => ota_lpe_shd.g_old_rec.attribute28
249: ,p_attribute29_o
250: => ota_lpe_shd.g_old_rec.attribute29
251: ,p_attribute30_o
252: => ota_lpe_shd.g_old_rec.attribute30
253: ,p_is_history_flag_o
254: => ota_lpe_shd.g_old_rec.is_history_flag
255: );
256: --

Line 254: => ota_lpe_shd.g_old_rec.is_history_flag

250: => ota_lpe_shd.g_old_rec.attribute29
251: ,p_attribute30_o
252: => ota_lpe_shd.g_old_rec.attribute30
253: ,p_is_history_flag_o
254: => ota_lpe_shd.g_old_rec.is_history_flag
255: );
256: --
257: exception
258: --

Line 274: (p_rec in ota_lpe_shd.g_rec_type

270: -- ----------------------------------------------------------------------------
271: -- |---------------------------------< del >----------------------------------|
272: -- ----------------------------------------------------------------------------
273: Procedure del
274: (p_rec in ota_lpe_shd.g_rec_type
275: ) is
276: --
277: l_proc varchar2(72) := g_package||'del';
278: --

Line 284: ota_lpe_shd.lck

280: hr_utility.set_location('Entering:'||l_proc, 5);
281: --
282: -- We must lock the row which we need to delete.
283: --
284: ota_lpe_shd.lck
285: (p_rec.lp_enrollment_id
286: ,p_rec.object_version_number
287: );
288: --

Line 321: l_rec ota_lpe_shd.g_rec_type;

317: (p_lp_enrollment_id in number
318: ,p_object_version_number in number
319: ) is
320: --
321: l_rec ota_lpe_shd.g_rec_type;
322: l_proc varchar2(72) := g_package||'del';
323: --
324: Begin
325: hr_utility.set_location('Entering:'||l_proc, 5);