APPS.HXC_HAV_DEL dependencies on HXC_HAV_SHD

Line 53: (p_rec in hxc_hav_shd.g_rec_type

49: --
50: -- {End Of Comments}
51: -- ----------------------------------------------------------------------------
52: Procedure delete_dml
53: (p_rec in hxc_hav_shd.g_rec_type
54: ) is
55: --
56: l_proc varchar2(72);
57: --

Line 81: hxc_hav_shd.constraint_error

77: Exception
78: When hr_api.child_integrity_violated then
79: -- Child integrity has been violated
80: --
81: hxc_hav_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When Others Then
84: --
85: Raise;

Line 120: Procedure pre_delete(p_rec in hxc_hav_shd.g_rec_type) is

116: -- Internal Row Handler Use Only.
117: --
118: -- {End Of Comments}
119: -- ----------------------------------------------------------------------------
120: Procedure pre_delete(p_rec in hxc_hav_shd.g_rec_type) is
121: --
122: l_proc varchar2(72);
123: --
124: Begin

Line 169: Procedure post_delete(p_rec in hxc_hav_shd.g_rec_type) is

165: -- Internal Row Handler Use Only.
166: --
167: -- {End Of Comments}
168: -- -----------------------------------------------------------------------------
169: Procedure post_delete(p_rec in hxc_hav_shd.g_rec_type) is
170: --
171: l_proc varchar2(72);
172: --
173: Begin

Line 184: => hxc_hav_shd.g_old_rec.alias_value_name

180: hxc_hav_rkd.after_delete
181: (p_alias_value_id
182: => p_rec.alias_value_id
183: ,p_alias_value_name_o
184: => hxc_hav_shd.g_old_rec.alias_value_name
185: ,p_date_from_o
186: => hxc_hav_shd.g_old_rec.date_from
187: ,p_date_to_o
188: => hxc_hav_shd.g_old_rec.date_to

Line 186: => hxc_hav_shd.g_old_rec.date_from

182: => p_rec.alias_value_id
183: ,p_alias_value_name_o
184: => hxc_hav_shd.g_old_rec.alias_value_name
185: ,p_date_from_o
186: => hxc_hav_shd.g_old_rec.date_from
187: ,p_date_to_o
188: => hxc_hav_shd.g_old_rec.date_to
189: ,p_alias_definition_id_o
190: => hxc_hav_shd.g_old_rec.alias_definition_id

Line 188: => hxc_hav_shd.g_old_rec.date_to

184: => hxc_hav_shd.g_old_rec.alias_value_name
185: ,p_date_from_o
186: => hxc_hav_shd.g_old_rec.date_from
187: ,p_date_to_o
188: => hxc_hav_shd.g_old_rec.date_to
189: ,p_alias_definition_id_o
190: => hxc_hav_shd.g_old_rec.alias_definition_id
191: ,p_enabled_flag_o
192: => hxc_hav_shd.g_old_rec.enabled_flag

Line 190: => hxc_hav_shd.g_old_rec.alias_definition_id

186: => hxc_hav_shd.g_old_rec.date_from
187: ,p_date_to_o
188: => hxc_hav_shd.g_old_rec.date_to
189: ,p_alias_definition_id_o
190: => hxc_hav_shd.g_old_rec.alias_definition_id
191: ,p_enabled_flag_o
192: => hxc_hav_shd.g_old_rec.enabled_flag
193: ,p_attribute_category_o
194: => hxc_hav_shd.g_old_rec.attribute_category

Line 192: => hxc_hav_shd.g_old_rec.enabled_flag

188: => hxc_hav_shd.g_old_rec.date_to
189: ,p_alias_definition_id_o
190: => hxc_hav_shd.g_old_rec.alias_definition_id
191: ,p_enabled_flag_o
192: => hxc_hav_shd.g_old_rec.enabled_flag
193: ,p_attribute_category_o
194: => hxc_hav_shd.g_old_rec.attribute_category
195: ,p_attribute1_o
196: => hxc_hav_shd.g_old_rec.attribute1

Line 194: => hxc_hav_shd.g_old_rec.attribute_category

190: => hxc_hav_shd.g_old_rec.alias_definition_id
191: ,p_enabled_flag_o
192: => hxc_hav_shd.g_old_rec.enabled_flag
193: ,p_attribute_category_o
194: => hxc_hav_shd.g_old_rec.attribute_category
195: ,p_attribute1_o
196: => hxc_hav_shd.g_old_rec.attribute1
197: ,p_attribute2_o
198: => hxc_hav_shd.g_old_rec.attribute2

Line 196: => hxc_hav_shd.g_old_rec.attribute1

192: => hxc_hav_shd.g_old_rec.enabled_flag
193: ,p_attribute_category_o
194: => hxc_hav_shd.g_old_rec.attribute_category
195: ,p_attribute1_o
196: => hxc_hav_shd.g_old_rec.attribute1
197: ,p_attribute2_o
198: => hxc_hav_shd.g_old_rec.attribute2
199: ,p_attribute3_o
200: => hxc_hav_shd.g_old_rec.attribute3

Line 198: => hxc_hav_shd.g_old_rec.attribute2

194: => hxc_hav_shd.g_old_rec.attribute_category
195: ,p_attribute1_o
196: => hxc_hav_shd.g_old_rec.attribute1
197: ,p_attribute2_o
198: => hxc_hav_shd.g_old_rec.attribute2
199: ,p_attribute3_o
200: => hxc_hav_shd.g_old_rec.attribute3
201: ,p_attribute4_o
202: => hxc_hav_shd.g_old_rec.attribute4

Line 200: => hxc_hav_shd.g_old_rec.attribute3

196: => hxc_hav_shd.g_old_rec.attribute1
197: ,p_attribute2_o
198: => hxc_hav_shd.g_old_rec.attribute2
199: ,p_attribute3_o
200: => hxc_hav_shd.g_old_rec.attribute3
201: ,p_attribute4_o
202: => hxc_hav_shd.g_old_rec.attribute4
203: ,p_attribute5_o
204: => hxc_hav_shd.g_old_rec.attribute5

Line 202: => hxc_hav_shd.g_old_rec.attribute4

198: => hxc_hav_shd.g_old_rec.attribute2
199: ,p_attribute3_o
200: => hxc_hav_shd.g_old_rec.attribute3
201: ,p_attribute4_o
202: => hxc_hav_shd.g_old_rec.attribute4
203: ,p_attribute5_o
204: => hxc_hav_shd.g_old_rec.attribute5
205: ,p_attribute6_o
206: => hxc_hav_shd.g_old_rec.attribute6

Line 204: => hxc_hav_shd.g_old_rec.attribute5

200: => hxc_hav_shd.g_old_rec.attribute3
201: ,p_attribute4_o
202: => hxc_hav_shd.g_old_rec.attribute4
203: ,p_attribute5_o
204: => hxc_hav_shd.g_old_rec.attribute5
205: ,p_attribute6_o
206: => hxc_hav_shd.g_old_rec.attribute6
207: ,p_attribute7_o
208: => hxc_hav_shd.g_old_rec.attribute7

Line 206: => hxc_hav_shd.g_old_rec.attribute6

202: => hxc_hav_shd.g_old_rec.attribute4
203: ,p_attribute5_o
204: => hxc_hav_shd.g_old_rec.attribute5
205: ,p_attribute6_o
206: => hxc_hav_shd.g_old_rec.attribute6
207: ,p_attribute7_o
208: => hxc_hav_shd.g_old_rec.attribute7
209: ,p_attribute8_o
210: => hxc_hav_shd.g_old_rec.attribute8

Line 208: => hxc_hav_shd.g_old_rec.attribute7

204: => hxc_hav_shd.g_old_rec.attribute5
205: ,p_attribute6_o
206: => hxc_hav_shd.g_old_rec.attribute6
207: ,p_attribute7_o
208: => hxc_hav_shd.g_old_rec.attribute7
209: ,p_attribute8_o
210: => hxc_hav_shd.g_old_rec.attribute8
211: ,p_attribute9_o
212: => hxc_hav_shd.g_old_rec.attribute9

Line 210: => hxc_hav_shd.g_old_rec.attribute8

206: => hxc_hav_shd.g_old_rec.attribute6
207: ,p_attribute7_o
208: => hxc_hav_shd.g_old_rec.attribute7
209: ,p_attribute8_o
210: => hxc_hav_shd.g_old_rec.attribute8
211: ,p_attribute9_o
212: => hxc_hav_shd.g_old_rec.attribute9
213: ,p_attribute10_o
214: => hxc_hav_shd.g_old_rec.attribute10

Line 212: => hxc_hav_shd.g_old_rec.attribute9

208: => hxc_hav_shd.g_old_rec.attribute7
209: ,p_attribute8_o
210: => hxc_hav_shd.g_old_rec.attribute8
211: ,p_attribute9_o
212: => hxc_hav_shd.g_old_rec.attribute9
213: ,p_attribute10_o
214: => hxc_hav_shd.g_old_rec.attribute10
215: ,p_attribute11_o
216: => hxc_hav_shd.g_old_rec.attribute11

Line 214: => hxc_hav_shd.g_old_rec.attribute10

210: => hxc_hav_shd.g_old_rec.attribute8
211: ,p_attribute9_o
212: => hxc_hav_shd.g_old_rec.attribute9
213: ,p_attribute10_o
214: => hxc_hav_shd.g_old_rec.attribute10
215: ,p_attribute11_o
216: => hxc_hav_shd.g_old_rec.attribute11
217: ,p_attribute12_o
218: => hxc_hav_shd.g_old_rec.attribute12

Line 216: => hxc_hav_shd.g_old_rec.attribute11

212: => hxc_hav_shd.g_old_rec.attribute9
213: ,p_attribute10_o
214: => hxc_hav_shd.g_old_rec.attribute10
215: ,p_attribute11_o
216: => hxc_hav_shd.g_old_rec.attribute11
217: ,p_attribute12_o
218: => hxc_hav_shd.g_old_rec.attribute12
219: ,p_attribute13_o
220: => hxc_hav_shd.g_old_rec.attribute13

Line 218: => hxc_hav_shd.g_old_rec.attribute12

214: => hxc_hav_shd.g_old_rec.attribute10
215: ,p_attribute11_o
216: => hxc_hav_shd.g_old_rec.attribute11
217: ,p_attribute12_o
218: => hxc_hav_shd.g_old_rec.attribute12
219: ,p_attribute13_o
220: => hxc_hav_shd.g_old_rec.attribute13
221: ,p_attribute14_o
222: => hxc_hav_shd.g_old_rec.attribute14

Line 220: => hxc_hav_shd.g_old_rec.attribute13

216: => hxc_hav_shd.g_old_rec.attribute11
217: ,p_attribute12_o
218: => hxc_hav_shd.g_old_rec.attribute12
219: ,p_attribute13_o
220: => hxc_hav_shd.g_old_rec.attribute13
221: ,p_attribute14_o
222: => hxc_hav_shd.g_old_rec.attribute14
223: ,p_attribute15_o
224: => hxc_hav_shd.g_old_rec.attribute15

Line 222: => hxc_hav_shd.g_old_rec.attribute14

218: => hxc_hav_shd.g_old_rec.attribute12
219: ,p_attribute13_o
220: => hxc_hav_shd.g_old_rec.attribute13
221: ,p_attribute14_o
222: => hxc_hav_shd.g_old_rec.attribute14
223: ,p_attribute15_o
224: => hxc_hav_shd.g_old_rec.attribute15
225: ,p_attribute16_o
226: => hxc_hav_shd.g_old_rec.attribute16

Line 224: => hxc_hav_shd.g_old_rec.attribute15

220: => hxc_hav_shd.g_old_rec.attribute13
221: ,p_attribute14_o
222: => hxc_hav_shd.g_old_rec.attribute14
223: ,p_attribute15_o
224: => hxc_hav_shd.g_old_rec.attribute15
225: ,p_attribute16_o
226: => hxc_hav_shd.g_old_rec.attribute16
227: ,p_attribute17_o
228: => hxc_hav_shd.g_old_rec.attribute17

Line 226: => hxc_hav_shd.g_old_rec.attribute16

222: => hxc_hav_shd.g_old_rec.attribute14
223: ,p_attribute15_o
224: => hxc_hav_shd.g_old_rec.attribute15
225: ,p_attribute16_o
226: => hxc_hav_shd.g_old_rec.attribute16
227: ,p_attribute17_o
228: => hxc_hav_shd.g_old_rec.attribute17
229: ,p_attribute18_o
230: => hxc_hav_shd.g_old_rec.attribute18

Line 228: => hxc_hav_shd.g_old_rec.attribute17

224: => hxc_hav_shd.g_old_rec.attribute15
225: ,p_attribute16_o
226: => hxc_hav_shd.g_old_rec.attribute16
227: ,p_attribute17_o
228: => hxc_hav_shd.g_old_rec.attribute17
229: ,p_attribute18_o
230: => hxc_hav_shd.g_old_rec.attribute18
231: ,p_attribute19_o
232: => hxc_hav_shd.g_old_rec.attribute19

Line 230: => hxc_hav_shd.g_old_rec.attribute18

226: => hxc_hav_shd.g_old_rec.attribute16
227: ,p_attribute17_o
228: => hxc_hav_shd.g_old_rec.attribute17
229: ,p_attribute18_o
230: => hxc_hav_shd.g_old_rec.attribute18
231: ,p_attribute19_o
232: => hxc_hav_shd.g_old_rec.attribute19
233: ,p_attribute20_o
234: => hxc_hav_shd.g_old_rec.attribute20

Line 232: => hxc_hav_shd.g_old_rec.attribute19

228: => hxc_hav_shd.g_old_rec.attribute17
229: ,p_attribute18_o
230: => hxc_hav_shd.g_old_rec.attribute18
231: ,p_attribute19_o
232: => hxc_hav_shd.g_old_rec.attribute19
233: ,p_attribute20_o
234: => hxc_hav_shd.g_old_rec.attribute20
235: ,p_attribute21_o
236: => hxc_hav_shd.g_old_rec.attribute21

Line 234: => hxc_hav_shd.g_old_rec.attribute20

230: => hxc_hav_shd.g_old_rec.attribute18
231: ,p_attribute19_o
232: => hxc_hav_shd.g_old_rec.attribute19
233: ,p_attribute20_o
234: => hxc_hav_shd.g_old_rec.attribute20
235: ,p_attribute21_o
236: => hxc_hav_shd.g_old_rec.attribute21
237: ,p_attribute22_o
238: => hxc_hav_shd.g_old_rec.attribute22

Line 236: => hxc_hav_shd.g_old_rec.attribute21

232: => hxc_hav_shd.g_old_rec.attribute19
233: ,p_attribute20_o
234: => hxc_hav_shd.g_old_rec.attribute20
235: ,p_attribute21_o
236: => hxc_hav_shd.g_old_rec.attribute21
237: ,p_attribute22_o
238: => hxc_hav_shd.g_old_rec.attribute22
239: ,p_attribute23_o
240: => hxc_hav_shd.g_old_rec.attribute23

Line 238: => hxc_hav_shd.g_old_rec.attribute22

234: => hxc_hav_shd.g_old_rec.attribute20
235: ,p_attribute21_o
236: => hxc_hav_shd.g_old_rec.attribute21
237: ,p_attribute22_o
238: => hxc_hav_shd.g_old_rec.attribute22
239: ,p_attribute23_o
240: => hxc_hav_shd.g_old_rec.attribute23
241: ,p_attribute24_o
242: => hxc_hav_shd.g_old_rec.attribute24

Line 240: => hxc_hav_shd.g_old_rec.attribute23

236: => hxc_hav_shd.g_old_rec.attribute21
237: ,p_attribute22_o
238: => hxc_hav_shd.g_old_rec.attribute22
239: ,p_attribute23_o
240: => hxc_hav_shd.g_old_rec.attribute23
241: ,p_attribute24_o
242: => hxc_hav_shd.g_old_rec.attribute24
243: ,p_attribute25_o
244: => hxc_hav_shd.g_old_rec.attribute25

Line 242: => hxc_hav_shd.g_old_rec.attribute24

238: => hxc_hav_shd.g_old_rec.attribute22
239: ,p_attribute23_o
240: => hxc_hav_shd.g_old_rec.attribute23
241: ,p_attribute24_o
242: => hxc_hav_shd.g_old_rec.attribute24
243: ,p_attribute25_o
244: => hxc_hav_shd.g_old_rec.attribute25
245: ,p_attribute26_o
246: => hxc_hav_shd.g_old_rec.attribute26

Line 244: => hxc_hav_shd.g_old_rec.attribute25

240: => hxc_hav_shd.g_old_rec.attribute23
241: ,p_attribute24_o
242: => hxc_hav_shd.g_old_rec.attribute24
243: ,p_attribute25_o
244: => hxc_hav_shd.g_old_rec.attribute25
245: ,p_attribute26_o
246: => hxc_hav_shd.g_old_rec.attribute26
247: ,p_attribute27_o
248: => hxc_hav_shd.g_old_rec.attribute27

Line 246: => hxc_hav_shd.g_old_rec.attribute26

242: => hxc_hav_shd.g_old_rec.attribute24
243: ,p_attribute25_o
244: => hxc_hav_shd.g_old_rec.attribute25
245: ,p_attribute26_o
246: => hxc_hav_shd.g_old_rec.attribute26
247: ,p_attribute27_o
248: => hxc_hav_shd.g_old_rec.attribute27
249: ,p_attribute28_o
250: => hxc_hav_shd.g_old_rec.attribute28

Line 248: => hxc_hav_shd.g_old_rec.attribute27

244: => hxc_hav_shd.g_old_rec.attribute25
245: ,p_attribute26_o
246: => hxc_hav_shd.g_old_rec.attribute26
247: ,p_attribute27_o
248: => hxc_hav_shd.g_old_rec.attribute27
249: ,p_attribute28_o
250: => hxc_hav_shd.g_old_rec.attribute28
251: ,p_attribute29_o
252: => hxc_hav_shd.g_old_rec.attribute29

Line 250: => hxc_hav_shd.g_old_rec.attribute28

246: => hxc_hav_shd.g_old_rec.attribute26
247: ,p_attribute27_o
248: => hxc_hav_shd.g_old_rec.attribute27
249: ,p_attribute28_o
250: => hxc_hav_shd.g_old_rec.attribute28
251: ,p_attribute29_o
252: => hxc_hav_shd.g_old_rec.attribute29
253: ,p_attribute30_o
254: => hxc_hav_shd.g_old_rec.attribute30

Line 252: => hxc_hav_shd.g_old_rec.attribute29

248: => hxc_hav_shd.g_old_rec.attribute27
249: ,p_attribute28_o
250: => hxc_hav_shd.g_old_rec.attribute28
251: ,p_attribute29_o
252: => hxc_hav_shd.g_old_rec.attribute29
253: ,p_attribute30_o
254: => hxc_hav_shd.g_old_rec.attribute30
255: ,p_object_version_number_o
256: => hxc_hav_shd.g_old_rec.object_version_number

Line 254: => hxc_hav_shd.g_old_rec.attribute30

250: => hxc_hav_shd.g_old_rec.attribute28
251: ,p_attribute29_o
252: => hxc_hav_shd.g_old_rec.attribute29
253: ,p_attribute30_o
254: => hxc_hav_shd.g_old_rec.attribute30
255: ,p_object_version_number_o
256: => hxc_hav_shd.g_old_rec.object_version_number
257: );
258: --

Line 256: => hxc_hav_shd.g_old_rec.object_version_number

252: => hxc_hav_shd.g_old_rec.attribute29
253: ,p_attribute30_o
254: => hxc_hav_shd.g_old_rec.attribute30
255: ,p_object_version_number_o
256: => hxc_hav_shd.g_old_rec.object_version_number
257: );
258: --
259: exception
260: --

Line 278: (p_rec in hxc_hav_shd.g_rec_type

274: -- ----------------------------------------------------------------------------
275: -- |---------------------------------< del >----------------------------------|
276: -- ----------------------------------------------------------------------------
277: Procedure del
278: (p_rec in hxc_hav_shd.g_rec_type
279: ) is
280: --
281: l_proc varchar2(72);
282: --

Line 292: hxc_hav_shd.lck

288: end if;
289: --
290: -- We must lock the row which we need to delete.
291: --
292: hxc_hav_shd.lck
293: (p_rec.alias_value_id
294: ,p_rec.object_version_number
295: );
296: --

Line 323: l_rec hxc_hav_shd.g_rec_type;

319: (p_alias_value_id in number
320: ,p_object_version_number in number
321: ) is
322: --
323: l_rec hxc_hav_shd.g_rec_type;
324: l_proc varchar2(72);
325: --
326: Begin
327: g_debug:=hr_utility.debug_enabled;