APPS.HXC_TAT_DEL dependencies on HXC_TAT_SHD

Line 50: (p_rec in hxc_tat_shd.g_rec_type

46: --
47: -- {end Of Comments}
48: -- --------------------------------------------------------------------------
49: procedure delete_dml
50: (p_rec in hxc_tat_shd.g_rec_type
51: ) is
52:
53: l_proc varchar2(72) ;
54:

Line 73: hxc_tat_shd.constraint_error

69: end if;
70:
71: exception
72: when hr_api.child_integrity_violated then
73: hxc_tat_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: when others then
76: raise;
77:

Line 112: procedure pre_delete(p_rec in hxc_tat_shd.g_rec_type) is

108: -- Internal Row Handler Use Only.
109: --
110: -- {end Of Comments}
111: -- --------------------------------------------------------------------------
112: procedure pre_delete(p_rec in hxc_tat_shd.g_rec_type) is
113:
114: l_proc varchar2(72) ;
115:
116: begin

Line 158: procedure post_delete(p_rec in hxc_tat_shd.g_rec_type) is

154: -- Internal Row Handler Use Only.
155: --
156: -- {end Of Comments}
157: -- -------------------------------------------------------------------------
158: procedure post_delete(p_rec in hxc_tat_shd.g_rec_type) is
159:
160: l_proc varchar2(72) ;
161:
162: begin

Line 175: => hxc_tat_shd.g_old_rec.object_version_number

171: hxc_tat_rkd.after_delete
172: (p_time_attribute_id
173: => p_rec.time_attribute_id
174: ,p_object_version_number_o
175: => hxc_tat_shd.g_old_rec.object_version_number
176: ,p_attribute_category_o
177: => hxc_tat_shd.g_old_rec.attribute_category
178: ,p_attribute1_o
179: => hxc_tat_shd.g_old_rec.attribute1

Line 177: => hxc_tat_shd.g_old_rec.attribute_category

173: => p_rec.time_attribute_id
174: ,p_object_version_number_o
175: => hxc_tat_shd.g_old_rec.object_version_number
176: ,p_attribute_category_o
177: => hxc_tat_shd.g_old_rec.attribute_category
178: ,p_attribute1_o
179: => hxc_tat_shd.g_old_rec.attribute1
180: ,p_attribute2_o
181: => hxc_tat_shd.g_old_rec.attribute2

Line 179: => hxc_tat_shd.g_old_rec.attribute1

175: => hxc_tat_shd.g_old_rec.object_version_number
176: ,p_attribute_category_o
177: => hxc_tat_shd.g_old_rec.attribute_category
178: ,p_attribute1_o
179: => hxc_tat_shd.g_old_rec.attribute1
180: ,p_attribute2_o
181: => hxc_tat_shd.g_old_rec.attribute2
182: ,p_attribute3_o
183: => hxc_tat_shd.g_old_rec.attribute3

Line 181: => hxc_tat_shd.g_old_rec.attribute2

177: => hxc_tat_shd.g_old_rec.attribute_category
178: ,p_attribute1_o
179: => hxc_tat_shd.g_old_rec.attribute1
180: ,p_attribute2_o
181: => hxc_tat_shd.g_old_rec.attribute2
182: ,p_attribute3_o
183: => hxc_tat_shd.g_old_rec.attribute3
184: ,p_attribute4_o
185: => hxc_tat_shd.g_old_rec.attribute4

Line 183: => hxc_tat_shd.g_old_rec.attribute3

179: => hxc_tat_shd.g_old_rec.attribute1
180: ,p_attribute2_o
181: => hxc_tat_shd.g_old_rec.attribute2
182: ,p_attribute3_o
183: => hxc_tat_shd.g_old_rec.attribute3
184: ,p_attribute4_o
185: => hxc_tat_shd.g_old_rec.attribute4
186: ,p_attribute5_o
187: => hxc_tat_shd.g_old_rec.attribute5

Line 185: => hxc_tat_shd.g_old_rec.attribute4

181: => hxc_tat_shd.g_old_rec.attribute2
182: ,p_attribute3_o
183: => hxc_tat_shd.g_old_rec.attribute3
184: ,p_attribute4_o
185: => hxc_tat_shd.g_old_rec.attribute4
186: ,p_attribute5_o
187: => hxc_tat_shd.g_old_rec.attribute5
188: ,p_attribute6_o
189: => hxc_tat_shd.g_old_rec.attribute6

Line 187: => hxc_tat_shd.g_old_rec.attribute5

183: => hxc_tat_shd.g_old_rec.attribute3
184: ,p_attribute4_o
185: => hxc_tat_shd.g_old_rec.attribute4
186: ,p_attribute5_o
187: => hxc_tat_shd.g_old_rec.attribute5
188: ,p_attribute6_o
189: => hxc_tat_shd.g_old_rec.attribute6
190: ,p_attribute7_o
191: => hxc_tat_shd.g_old_rec.attribute7

Line 189: => hxc_tat_shd.g_old_rec.attribute6

185: => hxc_tat_shd.g_old_rec.attribute4
186: ,p_attribute5_o
187: => hxc_tat_shd.g_old_rec.attribute5
188: ,p_attribute6_o
189: => hxc_tat_shd.g_old_rec.attribute6
190: ,p_attribute7_o
191: => hxc_tat_shd.g_old_rec.attribute7
192: ,p_attribute8_o
193: => hxc_tat_shd.g_old_rec.attribute8

Line 191: => hxc_tat_shd.g_old_rec.attribute7

187: => hxc_tat_shd.g_old_rec.attribute5
188: ,p_attribute6_o
189: => hxc_tat_shd.g_old_rec.attribute6
190: ,p_attribute7_o
191: => hxc_tat_shd.g_old_rec.attribute7
192: ,p_attribute8_o
193: => hxc_tat_shd.g_old_rec.attribute8
194: ,p_attribute9_o
195: => hxc_tat_shd.g_old_rec.attribute9

Line 193: => hxc_tat_shd.g_old_rec.attribute8

189: => hxc_tat_shd.g_old_rec.attribute6
190: ,p_attribute7_o
191: => hxc_tat_shd.g_old_rec.attribute7
192: ,p_attribute8_o
193: => hxc_tat_shd.g_old_rec.attribute8
194: ,p_attribute9_o
195: => hxc_tat_shd.g_old_rec.attribute9
196: ,p_attribute10_o
197: => hxc_tat_shd.g_old_rec.attribute10

Line 195: => hxc_tat_shd.g_old_rec.attribute9

191: => hxc_tat_shd.g_old_rec.attribute7
192: ,p_attribute8_o
193: => hxc_tat_shd.g_old_rec.attribute8
194: ,p_attribute9_o
195: => hxc_tat_shd.g_old_rec.attribute9
196: ,p_attribute10_o
197: => hxc_tat_shd.g_old_rec.attribute10
198: ,p_attribute11_o
199: => hxc_tat_shd.g_old_rec.attribute11

Line 197: => hxc_tat_shd.g_old_rec.attribute10

193: => hxc_tat_shd.g_old_rec.attribute8
194: ,p_attribute9_o
195: => hxc_tat_shd.g_old_rec.attribute9
196: ,p_attribute10_o
197: => hxc_tat_shd.g_old_rec.attribute10
198: ,p_attribute11_o
199: => hxc_tat_shd.g_old_rec.attribute11
200: ,p_attribute12_o
201: => hxc_tat_shd.g_old_rec.attribute12

Line 199: => hxc_tat_shd.g_old_rec.attribute11

195: => hxc_tat_shd.g_old_rec.attribute9
196: ,p_attribute10_o
197: => hxc_tat_shd.g_old_rec.attribute10
198: ,p_attribute11_o
199: => hxc_tat_shd.g_old_rec.attribute11
200: ,p_attribute12_o
201: => hxc_tat_shd.g_old_rec.attribute12
202: ,p_attribute13_o
203: => hxc_tat_shd.g_old_rec.attribute13

Line 201: => hxc_tat_shd.g_old_rec.attribute12

197: => hxc_tat_shd.g_old_rec.attribute10
198: ,p_attribute11_o
199: => hxc_tat_shd.g_old_rec.attribute11
200: ,p_attribute12_o
201: => hxc_tat_shd.g_old_rec.attribute12
202: ,p_attribute13_o
203: => hxc_tat_shd.g_old_rec.attribute13
204: ,p_attribute14_o
205: => hxc_tat_shd.g_old_rec.attribute14

Line 203: => hxc_tat_shd.g_old_rec.attribute13

199: => hxc_tat_shd.g_old_rec.attribute11
200: ,p_attribute12_o
201: => hxc_tat_shd.g_old_rec.attribute12
202: ,p_attribute13_o
203: => hxc_tat_shd.g_old_rec.attribute13
204: ,p_attribute14_o
205: => hxc_tat_shd.g_old_rec.attribute14
206: ,p_attribute15_o
207: => hxc_tat_shd.g_old_rec.attribute15

Line 205: => hxc_tat_shd.g_old_rec.attribute14

201: => hxc_tat_shd.g_old_rec.attribute12
202: ,p_attribute13_o
203: => hxc_tat_shd.g_old_rec.attribute13
204: ,p_attribute14_o
205: => hxc_tat_shd.g_old_rec.attribute14
206: ,p_attribute15_o
207: => hxc_tat_shd.g_old_rec.attribute15
208: ,p_attribute16_o
209: => hxc_tat_shd.g_old_rec.attribute16

Line 207: => hxc_tat_shd.g_old_rec.attribute15

203: => hxc_tat_shd.g_old_rec.attribute13
204: ,p_attribute14_o
205: => hxc_tat_shd.g_old_rec.attribute14
206: ,p_attribute15_o
207: => hxc_tat_shd.g_old_rec.attribute15
208: ,p_attribute16_o
209: => hxc_tat_shd.g_old_rec.attribute16
210: ,p_attribute17_o
211: => hxc_tat_shd.g_old_rec.attribute17

Line 209: => hxc_tat_shd.g_old_rec.attribute16

205: => hxc_tat_shd.g_old_rec.attribute14
206: ,p_attribute15_o
207: => hxc_tat_shd.g_old_rec.attribute15
208: ,p_attribute16_o
209: => hxc_tat_shd.g_old_rec.attribute16
210: ,p_attribute17_o
211: => hxc_tat_shd.g_old_rec.attribute17
212: ,p_attribute18_o
213: => hxc_tat_shd.g_old_rec.attribute18

Line 211: => hxc_tat_shd.g_old_rec.attribute17

207: => hxc_tat_shd.g_old_rec.attribute15
208: ,p_attribute16_o
209: => hxc_tat_shd.g_old_rec.attribute16
210: ,p_attribute17_o
211: => hxc_tat_shd.g_old_rec.attribute17
212: ,p_attribute18_o
213: => hxc_tat_shd.g_old_rec.attribute18
214: ,p_attribute19_o
215: => hxc_tat_shd.g_old_rec.attribute19

Line 213: => hxc_tat_shd.g_old_rec.attribute18

209: => hxc_tat_shd.g_old_rec.attribute16
210: ,p_attribute17_o
211: => hxc_tat_shd.g_old_rec.attribute17
212: ,p_attribute18_o
213: => hxc_tat_shd.g_old_rec.attribute18
214: ,p_attribute19_o
215: => hxc_tat_shd.g_old_rec.attribute19
216: ,p_attribute20_o
217: => hxc_tat_shd.g_old_rec.attribute20

Line 215: => hxc_tat_shd.g_old_rec.attribute19

211: => hxc_tat_shd.g_old_rec.attribute17
212: ,p_attribute18_o
213: => hxc_tat_shd.g_old_rec.attribute18
214: ,p_attribute19_o
215: => hxc_tat_shd.g_old_rec.attribute19
216: ,p_attribute20_o
217: => hxc_tat_shd.g_old_rec.attribute20
218: ,p_attribute21_o
219: => hxc_tat_shd.g_old_rec.attribute21

Line 217: => hxc_tat_shd.g_old_rec.attribute20

213: => hxc_tat_shd.g_old_rec.attribute18
214: ,p_attribute19_o
215: => hxc_tat_shd.g_old_rec.attribute19
216: ,p_attribute20_o
217: => hxc_tat_shd.g_old_rec.attribute20
218: ,p_attribute21_o
219: => hxc_tat_shd.g_old_rec.attribute21
220: ,p_attribute22_o
221: => hxc_tat_shd.g_old_rec.attribute22

Line 219: => hxc_tat_shd.g_old_rec.attribute21

215: => hxc_tat_shd.g_old_rec.attribute19
216: ,p_attribute20_o
217: => hxc_tat_shd.g_old_rec.attribute20
218: ,p_attribute21_o
219: => hxc_tat_shd.g_old_rec.attribute21
220: ,p_attribute22_o
221: => hxc_tat_shd.g_old_rec.attribute22
222: ,p_attribute23_o
223: => hxc_tat_shd.g_old_rec.attribute23

Line 221: => hxc_tat_shd.g_old_rec.attribute22

217: => hxc_tat_shd.g_old_rec.attribute20
218: ,p_attribute21_o
219: => hxc_tat_shd.g_old_rec.attribute21
220: ,p_attribute22_o
221: => hxc_tat_shd.g_old_rec.attribute22
222: ,p_attribute23_o
223: => hxc_tat_shd.g_old_rec.attribute23
224: ,p_attribute24_o
225: => hxc_tat_shd.g_old_rec.attribute24

Line 223: => hxc_tat_shd.g_old_rec.attribute23

219: => hxc_tat_shd.g_old_rec.attribute21
220: ,p_attribute22_o
221: => hxc_tat_shd.g_old_rec.attribute22
222: ,p_attribute23_o
223: => hxc_tat_shd.g_old_rec.attribute23
224: ,p_attribute24_o
225: => hxc_tat_shd.g_old_rec.attribute24
226: ,p_attribute25_o
227: => hxc_tat_shd.g_old_rec.attribute25

Line 225: => hxc_tat_shd.g_old_rec.attribute24

221: => hxc_tat_shd.g_old_rec.attribute22
222: ,p_attribute23_o
223: => hxc_tat_shd.g_old_rec.attribute23
224: ,p_attribute24_o
225: => hxc_tat_shd.g_old_rec.attribute24
226: ,p_attribute25_o
227: => hxc_tat_shd.g_old_rec.attribute25
228: ,p_attribute26_o
229: => hxc_tat_shd.g_old_rec.attribute26

Line 227: => hxc_tat_shd.g_old_rec.attribute25

223: => hxc_tat_shd.g_old_rec.attribute23
224: ,p_attribute24_o
225: => hxc_tat_shd.g_old_rec.attribute24
226: ,p_attribute25_o
227: => hxc_tat_shd.g_old_rec.attribute25
228: ,p_attribute26_o
229: => hxc_tat_shd.g_old_rec.attribute26
230: ,p_attribute27_o
231: => hxc_tat_shd.g_old_rec.attribute27

Line 229: => hxc_tat_shd.g_old_rec.attribute26

225: => hxc_tat_shd.g_old_rec.attribute24
226: ,p_attribute25_o
227: => hxc_tat_shd.g_old_rec.attribute25
228: ,p_attribute26_o
229: => hxc_tat_shd.g_old_rec.attribute26
230: ,p_attribute27_o
231: => hxc_tat_shd.g_old_rec.attribute27
232: ,p_attribute28_o
233: => hxc_tat_shd.g_old_rec.attribute28

Line 231: => hxc_tat_shd.g_old_rec.attribute27

227: => hxc_tat_shd.g_old_rec.attribute25
228: ,p_attribute26_o
229: => hxc_tat_shd.g_old_rec.attribute26
230: ,p_attribute27_o
231: => hxc_tat_shd.g_old_rec.attribute27
232: ,p_attribute28_o
233: => hxc_tat_shd.g_old_rec.attribute28
234: ,p_attribute29_o
235: => hxc_tat_shd.g_old_rec.attribute29

Line 233: => hxc_tat_shd.g_old_rec.attribute28

229: => hxc_tat_shd.g_old_rec.attribute26
230: ,p_attribute27_o
231: => hxc_tat_shd.g_old_rec.attribute27
232: ,p_attribute28_o
233: => hxc_tat_shd.g_old_rec.attribute28
234: ,p_attribute29_o
235: => hxc_tat_shd.g_old_rec.attribute29
236: ,p_attribute30_o
237: => hxc_tat_shd.g_old_rec.attribute30

Line 235: => hxc_tat_shd.g_old_rec.attribute29

231: => hxc_tat_shd.g_old_rec.attribute27
232: ,p_attribute28_o
233: => hxc_tat_shd.g_old_rec.attribute28
234: ,p_attribute29_o
235: => hxc_tat_shd.g_old_rec.attribute29
236: ,p_attribute30_o
237: => hxc_tat_shd.g_old_rec.attribute30
238: ,p_bld_blk_info_type_id_o
239: => hxc_tat_shd.g_old_rec.bld_blk_info_type_id

Line 237: => hxc_tat_shd.g_old_rec.attribute30

233: => hxc_tat_shd.g_old_rec.attribute28
234: ,p_attribute29_o
235: => hxc_tat_shd.g_old_rec.attribute29
236: ,p_attribute30_o
237: => hxc_tat_shd.g_old_rec.attribute30
238: ,p_bld_blk_info_type_id_o
239: => hxc_tat_shd.g_old_rec.bld_blk_info_type_id
240: );
241:

Line 239: => hxc_tat_shd.g_old_rec.bld_blk_info_type_id

235: => hxc_tat_shd.g_old_rec.attribute29
236: ,p_attribute30_o
237: => hxc_tat_shd.g_old_rec.attribute30
238: ,p_bld_blk_info_type_id_o
239: => hxc_tat_shd.g_old_rec.bld_blk_info_type_id
240: );
241:
242: exception
243: when hr_api.cannot_find_prog_unit then

Line 259: (p_rec in hxc_tat_shd.g_rec_type

255: -- --------------------------------------------------------------------------
256: -- |---------------------------------< del >--------------------------------|
257: -- --------------------------------------------------------------------------
258: procedure del
259: (p_rec in hxc_tat_shd.g_rec_type
260: ) is
261:
262: l_proc varchar2(72) ;
263:

Line 273: hxc_tat_shd.lck

269: end if;
270:
271: -- we must lock the row which we need to delete.
272:
273: hxc_tat_shd.lck
274: (p_rec.time_attribute_id
275: ,p_rec.object_version_number
276: );
277:

Line 304: l_rec hxc_tat_shd.g_rec_type;

300: (p_time_attribute_id in number
301: ,p_object_version_number in number
302: ) is
303:
304: l_rec hxc_tat_shd.g_rec_type;
305: l_proc varchar2(72) ;
306:
307: begin
308: g_debug :=hr_utility.debug_enabled;