APPS.HXC_ULQ_DEL dependencies on HXC_ULQ_SHD

Line 53: (p_rec in hxc_ulq_shd.g_rec_type

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

Line 82: hxc_ulq_shd.constraint_error

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

Line 121: Procedure pre_delete(p_rec in hxc_ulq_shd.g_rec_type) is

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

Line 166: Procedure post_delete(p_rec in hxc_ulq_shd.g_rec_type) is

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

Line 182: => hxc_ulq_shd.g_old_rec.layout_component_id

178: hxc_ulq_rkd.after_delete
179: (p_layout_comp_qualifier_id
180: => p_rec.layout_comp_qualifier_id
181: ,p_layout_component_id_o
182: => hxc_ulq_shd.g_old_rec.layout_component_id
183: ,p_qualifier_name_o
184: => hxc_ulq_shd.g_old_rec.qualifier_name
185: ,p_qualifier_attribute_catego_o
186: => hxc_ulq_shd.g_old_rec.qualifier_attribute_category

Line 184: => hxc_ulq_shd.g_old_rec.qualifier_name

180: => p_rec.layout_comp_qualifier_id
181: ,p_layout_component_id_o
182: => hxc_ulq_shd.g_old_rec.layout_component_id
183: ,p_qualifier_name_o
184: => hxc_ulq_shd.g_old_rec.qualifier_name
185: ,p_qualifier_attribute_catego_o
186: => hxc_ulq_shd.g_old_rec.qualifier_attribute_category
187: ,p_qualifier_attribute1_o
188: => hxc_ulq_shd.g_old_rec.qualifier_attribute1

Line 186: => hxc_ulq_shd.g_old_rec.qualifier_attribute_category

182: => hxc_ulq_shd.g_old_rec.layout_component_id
183: ,p_qualifier_name_o
184: => hxc_ulq_shd.g_old_rec.qualifier_name
185: ,p_qualifier_attribute_catego_o
186: => hxc_ulq_shd.g_old_rec.qualifier_attribute_category
187: ,p_qualifier_attribute1_o
188: => hxc_ulq_shd.g_old_rec.qualifier_attribute1
189: ,p_qualifier_attribute2_o
190: => hxc_ulq_shd.g_old_rec.qualifier_attribute2

Line 188: => hxc_ulq_shd.g_old_rec.qualifier_attribute1

184: => hxc_ulq_shd.g_old_rec.qualifier_name
185: ,p_qualifier_attribute_catego_o
186: => hxc_ulq_shd.g_old_rec.qualifier_attribute_category
187: ,p_qualifier_attribute1_o
188: => hxc_ulq_shd.g_old_rec.qualifier_attribute1
189: ,p_qualifier_attribute2_o
190: => hxc_ulq_shd.g_old_rec.qualifier_attribute2
191: ,p_qualifier_attribute3_o
192: => hxc_ulq_shd.g_old_rec.qualifier_attribute3

Line 190: => hxc_ulq_shd.g_old_rec.qualifier_attribute2

186: => hxc_ulq_shd.g_old_rec.qualifier_attribute_category
187: ,p_qualifier_attribute1_o
188: => hxc_ulq_shd.g_old_rec.qualifier_attribute1
189: ,p_qualifier_attribute2_o
190: => hxc_ulq_shd.g_old_rec.qualifier_attribute2
191: ,p_qualifier_attribute3_o
192: => hxc_ulq_shd.g_old_rec.qualifier_attribute3
193: ,p_qualifier_attribute4_o
194: => hxc_ulq_shd.g_old_rec.qualifier_attribute4

Line 192: => hxc_ulq_shd.g_old_rec.qualifier_attribute3

188: => hxc_ulq_shd.g_old_rec.qualifier_attribute1
189: ,p_qualifier_attribute2_o
190: => hxc_ulq_shd.g_old_rec.qualifier_attribute2
191: ,p_qualifier_attribute3_o
192: => hxc_ulq_shd.g_old_rec.qualifier_attribute3
193: ,p_qualifier_attribute4_o
194: => hxc_ulq_shd.g_old_rec.qualifier_attribute4
195: ,p_qualifier_attribute5_o
196: => hxc_ulq_shd.g_old_rec.qualifier_attribute5

Line 194: => hxc_ulq_shd.g_old_rec.qualifier_attribute4

190: => hxc_ulq_shd.g_old_rec.qualifier_attribute2
191: ,p_qualifier_attribute3_o
192: => hxc_ulq_shd.g_old_rec.qualifier_attribute3
193: ,p_qualifier_attribute4_o
194: => hxc_ulq_shd.g_old_rec.qualifier_attribute4
195: ,p_qualifier_attribute5_o
196: => hxc_ulq_shd.g_old_rec.qualifier_attribute5
197: ,p_qualifier_attribute6_o
198: => hxc_ulq_shd.g_old_rec.qualifier_attribute6

Line 196: => hxc_ulq_shd.g_old_rec.qualifier_attribute5

192: => hxc_ulq_shd.g_old_rec.qualifier_attribute3
193: ,p_qualifier_attribute4_o
194: => hxc_ulq_shd.g_old_rec.qualifier_attribute4
195: ,p_qualifier_attribute5_o
196: => hxc_ulq_shd.g_old_rec.qualifier_attribute5
197: ,p_qualifier_attribute6_o
198: => hxc_ulq_shd.g_old_rec.qualifier_attribute6
199: ,p_qualifier_attribute7_o
200: => hxc_ulq_shd.g_old_rec.qualifier_attribute7

Line 198: => hxc_ulq_shd.g_old_rec.qualifier_attribute6

194: => hxc_ulq_shd.g_old_rec.qualifier_attribute4
195: ,p_qualifier_attribute5_o
196: => hxc_ulq_shd.g_old_rec.qualifier_attribute5
197: ,p_qualifier_attribute6_o
198: => hxc_ulq_shd.g_old_rec.qualifier_attribute6
199: ,p_qualifier_attribute7_o
200: => hxc_ulq_shd.g_old_rec.qualifier_attribute7
201: ,p_qualifier_attribute8_o
202: => hxc_ulq_shd.g_old_rec.qualifier_attribute8

Line 200: => hxc_ulq_shd.g_old_rec.qualifier_attribute7

196: => hxc_ulq_shd.g_old_rec.qualifier_attribute5
197: ,p_qualifier_attribute6_o
198: => hxc_ulq_shd.g_old_rec.qualifier_attribute6
199: ,p_qualifier_attribute7_o
200: => hxc_ulq_shd.g_old_rec.qualifier_attribute7
201: ,p_qualifier_attribute8_o
202: => hxc_ulq_shd.g_old_rec.qualifier_attribute8
203: ,p_qualifier_attribute9_o
204: => hxc_ulq_shd.g_old_rec.qualifier_attribute9

Line 202: => hxc_ulq_shd.g_old_rec.qualifier_attribute8

198: => hxc_ulq_shd.g_old_rec.qualifier_attribute6
199: ,p_qualifier_attribute7_o
200: => hxc_ulq_shd.g_old_rec.qualifier_attribute7
201: ,p_qualifier_attribute8_o
202: => hxc_ulq_shd.g_old_rec.qualifier_attribute8
203: ,p_qualifier_attribute9_o
204: => hxc_ulq_shd.g_old_rec.qualifier_attribute9
205: ,p_qualifier_attribute10_o
206: => hxc_ulq_shd.g_old_rec.qualifier_attribute10

Line 204: => hxc_ulq_shd.g_old_rec.qualifier_attribute9

200: => hxc_ulq_shd.g_old_rec.qualifier_attribute7
201: ,p_qualifier_attribute8_o
202: => hxc_ulq_shd.g_old_rec.qualifier_attribute8
203: ,p_qualifier_attribute9_o
204: => hxc_ulq_shd.g_old_rec.qualifier_attribute9
205: ,p_qualifier_attribute10_o
206: => hxc_ulq_shd.g_old_rec.qualifier_attribute10
207: ,p_qualifier_attribute11_o
208: => hxc_ulq_shd.g_old_rec.qualifier_attribute11

Line 206: => hxc_ulq_shd.g_old_rec.qualifier_attribute10

202: => hxc_ulq_shd.g_old_rec.qualifier_attribute8
203: ,p_qualifier_attribute9_o
204: => hxc_ulq_shd.g_old_rec.qualifier_attribute9
205: ,p_qualifier_attribute10_o
206: => hxc_ulq_shd.g_old_rec.qualifier_attribute10
207: ,p_qualifier_attribute11_o
208: => hxc_ulq_shd.g_old_rec.qualifier_attribute11
209: ,p_qualifier_attribute12_o
210: => hxc_ulq_shd.g_old_rec.qualifier_attribute12

Line 208: => hxc_ulq_shd.g_old_rec.qualifier_attribute11

204: => hxc_ulq_shd.g_old_rec.qualifier_attribute9
205: ,p_qualifier_attribute10_o
206: => hxc_ulq_shd.g_old_rec.qualifier_attribute10
207: ,p_qualifier_attribute11_o
208: => hxc_ulq_shd.g_old_rec.qualifier_attribute11
209: ,p_qualifier_attribute12_o
210: => hxc_ulq_shd.g_old_rec.qualifier_attribute12
211: ,p_qualifier_attribute13_o
212: => hxc_ulq_shd.g_old_rec.qualifier_attribute13

Line 210: => hxc_ulq_shd.g_old_rec.qualifier_attribute12

206: => hxc_ulq_shd.g_old_rec.qualifier_attribute10
207: ,p_qualifier_attribute11_o
208: => hxc_ulq_shd.g_old_rec.qualifier_attribute11
209: ,p_qualifier_attribute12_o
210: => hxc_ulq_shd.g_old_rec.qualifier_attribute12
211: ,p_qualifier_attribute13_o
212: => hxc_ulq_shd.g_old_rec.qualifier_attribute13
213: ,p_qualifier_attribute14_o
214: => hxc_ulq_shd.g_old_rec.qualifier_attribute14

Line 212: => hxc_ulq_shd.g_old_rec.qualifier_attribute13

208: => hxc_ulq_shd.g_old_rec.qualifier_attribute11
209: ,p_qualifier_attribute12_o
210: => hxc_ulq_shd.g_old_rec.qualifier_attribute12
211: ,p_qualifier_attribute13_o
212: => hxc_ulq_shd.g_old_rec.qualifier_attribute13
213: ,p_qualifier_attribute14_o
214: => hxc_ulq_shd.g_old_rec.qualifier_attribute14
215: ,p_qualifier_attribute15_o
216: => hxc_ulq_shd.g_old_rec.qualifier_attribute15

Line 214: => hxc_ulq_shd.g_old_rec.qualifier_attribute14

210: => hxc_ulq_shd.g_old_rec.qualifier_attribute12
211: ,p_qualifier_attribute13_o
212: => hxc_ulq_shd.g_old_rec.qualifier_attribute13
213: ,p_qualifier_attribute14_o
214: => hxc_ulq_shd.g_old_rec.qualifier_attribute14
215: ,p_qualifier_attribute15_o
216: => hxc_ulq_shd.g_old_rec.qualifier_attribute15
217: ,p_qualifier_attribute16_o
218: => hxc_ulq_shd.g_old_rec.qualifier_attribute16

Line 216: => hxc_ulq_shd.g_old_rec.qualifier_attribute15

212: => hxc_ulq_shd.g_old_rec.qualifier_attribute13
213: ,p_qualifier_attribute14_o
214: => hxc_ulq_shd.g_old_rec.qualifier_attribute14
215: ,p_qualifier_attribute15_o
216: => hxc_ulq_shd.g_old_rec.qualifier_attribute15
217: ,p_qualifier_attribute16_o
218: => hxc_ulq_shd.g_old_rec.qualifier_attribute16
219: ,p_qualifier_attribute17_o
220: => hxc_ulq_shd.g_old_rec.qualifier_attribute17

Line 218: => hxc_ulq_shd.g_old_rec.qualifier_attribute16

214: => hxc_ulq_shd.g_old_rec.qualifier_attribute14
215: ,p_qualifier_attribute15_o
216: => hxc_ulq_shd.g_old_rec.qualifier_attribute15
217: ,p_qualifier_attribute16_o
218: => hxc_ulq_shd.g_old_rec.qualifier_attribute16
219: ,p_qualifier_attribute17_o
220: => hxc_ulq_shd.g_old_rec.qualifier_attribute17
221: ,p_qualifier_attribute18_o
222: => hxc_ulq_shd.g_old_rec.qualifier_attribute18

Line 220: => hxc_ulq_shd.g_old_rec.qualifier_attribute17

216: => hxc_ulq_shd.g_old_rec.qualifier_attribute15
217: ,p_qualifier_attribute16_o
218: => hxc_ulq_shd.g_old_rec.qualifier_attribute16
219: ,p_qualifier_attribute17_o
220: => hxc_ulq_shd.g_old_rec.qualifier_attribute17
221: ,p_qualifier_attribute18_o
222: => hxc_ulq_shd.g_old_rec.qualifier_attribute18
223: ,p_qualifier_attribute19_o
224: => hxc_ulq_shd.g_old_rec.qualifier_attribute19

Line 222: => hxc_ulq_shd.g_old_rec.qualifier_attribute18

218: => hxc_ulq_shd.g_old_rec.qualifier_attribute16
219: ,p_qualifier_attribute17_o
220: => hxc_ulq_shd.g_old_rec.qualifier_attribute17
221: ,p_qualifier_attribute18_o
222: => hxc_ulq_shd.g_old_rec.qualifier_attribute18
223: ,p_qualifier_attribute19_o
224: => hxc_ulq_shd.g_old_rec.qualifier_attribute19
225: ,p_qualifier_attribute20_o
226: => hxc_ulq_shd.g_old_rec.qualifier_attribute20

Line 224: => hxc_ulq_shd.g_old_rec.qualifier_attribute19

220: => hxc_ulq_shd.g_old_rec.qualifier_attribute17
221: ,p_qualifier_attribute18_o
222: => hxc_ulq_shd.g_old_rec.qualifier_attribute18
223: ,p_qualifier_attribute19_o
224: => hxc_ulq_shd.g_old_rec.qualifier_attribute19
225: ,p_qualifier_attribute20_o
226: => hxc_ulq_shd.g_old_rec.qualifier_attribute20
227: ,p_qualifier_attribute21_o
228: => hxc_ulq_shd.g_old_rec.qualifier_attribute21

Line 226: => hxc_ulq_shd.g_old_rec.qualifier_attribute20

222: => hxc_ulq_shd.g_old_rec.qualifier_attribute18
223: ,p_qualifier_attribute19_o
224: => hxc_ulq_shd.g_old_rec.qualifier_attribute19
225: ,p_qualifier_attribute20_o
226: => hxc_ulq_shd.g_old_rec.qualifier_attribute20
227: ,p_qualifier_attribute21_o
228: => hxc_ulq_shd.g_old_rec.qualifier_attribute21
229: ,p_qualifier_attribute22_o
230: => hxc_ulq_shd.g_old_rec.qualifier_attribute22

Line 228: => hxc_ulq_shd.g_old_rec.qualifier_attribute21

224: => hxc_ulq_shd.g_old_rec.qualifier_attribute19
225: ,p_qualifier_attribute20_o
226: => hxc_ulq_shd.g_old_rec.qualifier_attribute20
227: ,p_qualifier_attribute21_o
228: => hxc_ulq_shd.g_old_rec.qualifier_attribute21
229: ,p_qualifier_attribute22_o
230: => hxc_ulq_shd.g_old_rec.qualifier_attribute22
231: ,p_qualifier_attribute23_o
232: => hxc_ulq_shd.g_old_rec.qualifier_attribute23

Line 230: => hxc_ulq_shd.g_old_rec.qualifier_attribute22

226: => hxc_ulq_shd.g_old_rec.qualifier_attribute20
227: ,p_qualifier_attribute21_o
228: => hxc_ulq_shd.g_old_rec.qualifier_attribute21
229: ,p_qualifier_attribute22_o
230: => hxc_ulq_shd.g_old_rec.qualifier_attribute22
231: ,p_qualifier_attribute23_o
232: => hxc_ulq_shd.g_old_rec.qualifier_attribute23
233: ,p_qualifier_attribute24_o
234: => hxc_ulq_shd.g_old_rec.qualifier_attribute24

Line 232: => hxc_ulq_shd.g_old_rec.qualifier_attribute23

228: => hxc_ulq_shd.g_old_rec.qualifier_attribute21
229: ,p_qualifier_attribute22_o
230: => hxc_ulq_shd.g_old_rec.qualifier_attribute22
231: ,p_qualifier_attribute23_o
232: => hxc_ulq_shd.g_old_rec.qualifier_attribute23
233: ,p_qualifier_attribute24_o
234: => hxc_ulq_shd.g_old_rec.qualifier_attribute24
235: ,p_qualifier_attribute25_o
236: => hxc_ulq_shd.g_old_rec.qualifier_attribute25

Line 234: => hxc_ulq_shd.g_old_rec.qualifier_attribute24

230: => hxc_ulq_shd.g_old_rec.qualifier_attribute22
231: ,p_qualifier_attribute23_o
232: => hxc_ulq_shd.g_old_rec.qualifier_attribute23
233: ,p_qualifier_attribute24_o
234: => hxc_ulq_shd.g_old_rec.qualifier_attribute24
235: ,p_qualifier_attribute25_o
236: => hxc_ulq_shd.g_old_rec.qualifier_attribute25
237: ,p_qualifier_attribute26_o
238: => hxc_ulq_shd.g_old_rec.qualifier_attribute26

Line 236: => hxc_ulq_shd.g_old_rec.qualifier_attribute25

232: => hxc_ulq_shd.g_old_rec.qualifier_attribute23
233: ,p_qualifier_attribute24_o
234: => hxc_ulq_shd.g_old_rec.qualifier_attribute24
235: ,p_qualifier_attribute25_o
236: => hxc_ulq_shd.g_old_rec.qualifier_attribute25
237: ,p_qualifier_attribute26_o
238: => hxc_ulq_shd.g_old_rec.qualifier_attribute26
239: ,p_qualifier_attribute27_o
240: => hxc_ulq_shd.g_old_rec.qualifier_attribute27

Line 238: => hxc_ulq_shd.g_old_rec.qualifier_attribute26

234: => hxc_ulq_shd.g_old_rec.qualifier_attribute24
235: ,p_qualifier_attribute25_o
236: => hxc_ulq_shd.g_old_rec.qualifier_attribute25
237: ,p_qualifier_attribute26_o
238: => hxc_ulq_shd.g_old_rec.qualifier_attribute26
239: ,p_qualifier_attribute27_o
240: => hxc_ulq_shd.g_old_rec.qualifier_attribute27
241: ,p_qualifier_attribute28_o
242: => hxc_ulq_shd.g_old_rec.qualifier_attribute28

Line 240: => hxc_ulq_shd.g_old_rec.qualifier_attribute27

236: => hxc_ulq_shd.g_old_rec.qualifier_attribute25
237: ,p_qualifier_attribute26_o
238: => hxc_ulq_shd.g_old_rec.qualifier_attribute26
239: ,p_qualifier_attribute27_o
240: => hxc_ulq_shd.g_old_rec.qualifier_attribute27
241: ,p_qualifier_attribute28_o
242: => hxc_ulq_shd.g_old_rec.qualifier_attribute28
243: ,p_qualifier_attribute29_o
244: => hxc_ulq_shd.g_old_rec.qualifier_attribute29

Line 242: => hxc_ulq_shd.g_old_rec.qualifier_attribute28

238: => hxc_ulq_shd.g_old_rec.qualifier_attribute26
239: ,p_qualifier_attribute27_o
240: => hxc_ulq_shd.g_old_rec.qualifier_attribute27
241: ,p_qualifier_attribute28_o
242: => hxc_ulq_shd.g_old_rec.qualifier_attribute28
243: ,p_qualifier_attribute29_o
244: => hxc_ulq_shd.g_old_rec.qualifier_attribute29
245: ,p_qualifier_attribute30_o
246: => hxc_ulq_shd.g_old_rec.qualifier_attribute30

Line 244: => hxc_ulq_shd.g_old_rec.qualifier_attribute29

240: => hxc_ulq_shd.g_old_rec.qualifier_attribute27
241: ,p_qualifier_attribute28_o
242: => hxc_ulq_shd.g_old_rec.qualifier_attribute28
243: ,p_qualifier_attribute29_o
244: => hxc_ulq_shd.g_old_rec.qualifier_attribute29
245: ,p_qualifier_attribute30_o
246: => hxc_ulq_shd.g_old_rec.qualifier_attribute30
247: ,p_object_version_number_o
248: => hxc_ulq_shd.g_old_rec.object_version_number

Line 246: => hxc_ulq_shd.g_old_rec.qualifier_attribute30

242: => hxc_ulq_shd.g_old_rec.qualifier_attribute28
243: ,p_qualifier_attribute29_o
244: => hxc_ulq_shd.g_old_rec.qualifier_attribute29
245: ,p_qualifier_attribute30_o
246: => hxc_ulq_shd.g_old_rec.qualifier_attribute30
247: ,p_object_version_number_o
248: => hxc_ulq_shd.g_old_rec.object_version_number
249: );
250: --

Line 248: => hxc_ulq_shd.g_old_rec.object_version_number

244: => hxc_ulq_shd.g_old_rec.qualifier_attribute29
245: ,p_qualifier_attribute30_o
246: => hxc_ulq_shd.g_old_rec.qualifier_attribute30
247: ,p_object_version_number_o
248: => hxc_ulq_shd.g_old_rec.object_version_number
249: );
250: --
251: exception
252: --

Line 270: (p_rec in hxc_ulq_shd.g_rec_type

266: -- ----------------------------------------------------------------------------
267: -- |---------------------------------< del >----------------------------------|
268: -- ----------------------------------------------------------------------------
269: Procedure del
270: (p_rec in hxc_ulq_shd.g_rec_type
271: ) is
272: --
273: l_proc varchar2(72) ;
274: --

Line 284: hxc_ulq_shd.lck

280: end if;
281: --
282: -- We must lock the row which we need to delete.
283: --
284: hxc_ulq_shd.lck
285: (p_rec.layout_comp_qualifier_id
286: ,p_rec.object_version_number
287: );
288: --

Line 315: l_rec hxc_ulq_shd.g_rec_type;

311: (p_layout_comp_qualifier_id in number
312: ,p_object_version_number in number
313: ) is
314: --
315: l_rec hxc_ulq_shd.g_rec_type;
316: l_proc varchar2(72) ;
317: --
318: Begin
319: g_debug :=hr_utility.debug_enabled;