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.HXC_ULQ_UPD dependencies on HXC_ULQ_SHD

Line 56: (p_rec in out nocopy hxc_ulq_shd.g_rec_type

52: --
53: -- {End Of Comments}
54: -- ----------------------------------------------------------------------------
55: Procedure update_dml
56: (p_rec in out nocopy hxc_ulq_shd.g_rec_type
57: ) is
58: --
59: l_proc varchar2(72) ;
60: --

Line 127: hxc_ulq_shd.constraint_error

123: Exception
124: When hr_api.check_integrity_violated Then
125: -- A check constraint has been violated
126: --
127: hxc_ulq_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.parent_integrity_violated Then
130: -- Parent integrity has been violated
131: --

Line 132: hxc_ulq_shd.constraint_error

128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.parent_integrity_violated Then
130: -- Parent integrity has been violated
131: --
132: hxc_ulq_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.unique_integrity_violated Then
135: -- Unique integrity has been violated
136: --

Line 137: hxc_ulq_shd.constraint_error

133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.unique_integrity_violated Then
135: -- Unique integrity has been violated
136: --
137: hxc_ulq_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When Others Then
140: --
141: Raise;

Line 177: (p_rec in hxc_ulq_shd.g_rec_type

173: --
174: -- {End Of Comments}
175: -- ----------------------------------------------------------------------------
176: Procedure pre_update
177: (p_rec in hxc_ulq_shd.g_rec_type
178: ) is
179: --
180: l_proc varchar2(72) ;
181: --

Line 224: (p_rec in hxc_ulq_shd.g_rec_type

220: --
221: -- {End Of Comments}
222: -- ----------------------------------------------------------------------------
223: Procedure post_update
224: (p_rec in hxc_ulq_shd.g_rec_type
225: ) is
226: --
227: l_proc varchar2(72) ;
228: --

Line 307: => hxc_ulq_shd.g_old_rec.qualifier_name

303: => p_rec.qualifier_attribute30
304: ,p_object_version_number
305: => p_rec.object_version_number
306: ,p_qualifier_name_o
307: => hxc_ulq_shd.g_old_rec.qualifier_name
308: ,p_qualifier_attribute_catego_o
309: => hxc_ulq_shd.g_old_rec.qualifier_attribute_category
310: ,p_qualifier_attribute1_o
311: => hxc_ulq_shd.g_old_rec.qualifier_attribute1

Line 309: => hxc_ulq_shd.g_old_rec.qualifier_attribute_category

305: => p_rec.object_version_number
306: ,p_qualifier_name_o
307: => hxc_ulq_shd.g_old_rec.qualifier_name
308: ,p_qualifier_attribute_catego_o
309: => hxc_ulq_shd.g_old_rec.qualifier_attribute_category
310: ,p_qualifier_attribute1_o
311: => hxc_ulq_shd.g_old_rec.qualifier_attribute1
312: ,p_qualifier_attribute2_o
313: => hxc_ulq_shd.g_old_rec.qualifier_attribute2

Line 311: => hxc_ulq_shd.g_old_rec.qualifier_attribute1

307: => hxc_ulq_shd.g_old_rec.qualifier_name
308: ,p_qualifier_attribute_catego_o
309: => hxc_ulq_shd.g_old_rec.qualifier_attribute_category
310: ,p_qualifier_attribute1_o
311: => hxc_ulq_shd.g_old_rec.qualifier_attribute1
312: ,p_qualifier_attribute2_o
313: => hxc_ulq_shd.g_old_rec.qualifier_attribute2
314: ,p_qualifier_attribute3_o
315: => hxc_ulq_shd.g_old_rec.qualifier_attribute3

Line 313: => hxc_ulq_shd.g_old_rec.qualifier_attribute2

309: => hxc_ulq_shd.g_old_rec.qualifier_attribute_category
310: ,p_qualifier_attribute1_o
311: => hxc_ulq_shd.g_old_rec.qualifier_attribute1
312: ,p_qualifier_attribute2_o
313: => hxc_ulq_shd.g_old_rec.qualifier_attribute2
314: ,p_qualifier_attribute3_o
315: => hxc_ulq_shd.g_old_rec.qualifier_attribute3
316: ,p_qualifier_attribute4_o
317: => hxc_ulq_shd.g_old_rec.qualifier_attribute4

Line 315: => hxc_ulq_shd.g_old_rec.qualifier_attribute3

311: => hxc_ulq_shd.g_old_rec.qualifier_attribute1
312: ,p_qualifier_attribute2_o
313: => hxc_ulq_shd.g_old_rec.qualifier_attribute2
314: ,p_qualifier_attribute3_o
315: => hxc_ulq_shd.g_old_rec.qualifier_attribute3
316: ,p_qualifier_attribute4_o
317: => hxc_ulq_shd.g_old_rec.qualifier_attribute4
318: ,p_qualifier_attribute5_o
319: => hxc_ulq_shd.g_old_rec.qualifier_attribute5

Line 317: => hxc_ulq_shd.g_old_rec.qualifier_attribute4

313: => hxc_ulq_shd.g_old_rec.qualifier_attribute2
314: ,p_qualifier_attribute3_o
315: => hxc_ulq_shd.g_old_rec.qualifier_attribute3
316: ,p_qualifier_attribute4_o
317: => hxc_ulq_shd.g_old_rec.qualifier_attribute4
318: ,p_qualifier_attribute5_o
319: => hxc_ulq_shd.g_old_rec.qualifier_attribute5
320: ,p_qualifier_attribute6_o
321: => hxc_ulq_shd.g_old_rec.qualifier_attribute6

Line 319: => hxc_ulq_shd.g_old_rec.qualifier_attribute5

315: => hxc_ulq_shd.g_old_rec.qualifier_attribute3
316: ,p_qualifier_attribute4_o
317: => hxc_ulq_shd.g_old_rec.qualifier_attribute4
318: ,p_qualifier_attribute5_o
319: => hxc_ulq_shd.g_old_rec.qualifier_attribute5
320: ,p_qualifier_attribute6_o
321: => hxc_ulq_shd.g_old_rec.qualifier_attribute6
322: ,p_qualifier_attribute7_o
323: => hxc_ulq_shd.g_old_rec.qualifier_attribute7

Line 321: => hxc_ulq_shd.g_old_rec.qualifier_attribute6

317: => hxc_ulq_shd.g_old_rec.qualifier_attribute4
318: ,p_qualifier_attribute5_o
319: => hxc_ulq_shd.g_old_rec.qualifier_attribute5
320: ,p_qualifier_attribute6_o
321: => hxc_ulq_shd.g_old_rec.qualifier_attribute6
322: ,p_qualifier_attribute7_o
323: => hxc_ulq_shd.g_old_rec.qualifier_attribute7
324: ,p_qualifier_attribute8_o
325: => hxc_ulq_shd.g_old_rec.qualifier_attribute8

Line 323: => hxc_ulq_shd.g_old_rec.qualifier_attribute7

319: => hxc_ulq_shd.g_old_rec.qualifier_attribute5
320: ,p_qualifier_attribute6_o
321: => hxc_ulq_shd.g_old_rec.qualifier_attribute6
322: ,p_qualifier_attribute7_o
323: => hxc_ulq_shd.g_old_rec.qualifier_attribute7
324: ,p_qualifier_attribute8_o
325: => hxc_ulq_shd.g_old_rec.qualifier_attribute8
326: ,p_qualifier_attribute9_o
327: => hxc_ulq_shd.g_old_rec.qualifier_attribute9

Line 325: => hxc_ulq_shd.g_old_rec.qualifier_attribute8

321: => hxc_ulq_shd.g_old_rec.qualifier_attribute6
322: ,p_qualifier_attribute7_o
323: => hxc_ulq_shd.g_old_rec.qualifier_attribute7
324: ,p_qualifier_attribute8_o
325: => hxc_ulq_shd.g_old_rec.qualifier_attribute8
326: ,p_qualifier_attribute9_o
327: => hxc_ulq_shd.g_old_rec.qualifier_attribute9
328: ,p_qualifier_attribute10_o
329: => hxc_ulq_shd.g_old_rec.qualifier_attribute10

Line 327: => hxc_ulq_shd.g_old_rec.qualifier_attribute9

323: => hxc_ulq_shd.g_old_rec.qualifier_attribute7
324: ,p_qualifier_attribute8_o
325: => hxc_ulq_shd.g_old_rec.qualifier_attribute8
326: ,p_qualifier_attribute9_o
327: => hxc_ulq_shd.g_old_rec.qualifier_attribute9
328: ,p_qualifier_attribute10_o
329: => hxc_ulq_shd.g_old_rec.qualifier_attribute10
330: ,p_qualifier_attribute11_o
331: => hxc_ulq_shd.g_old_rec.qualifier_attribute11

Line 329: => hxc_ulq_shd.g_old_rec.qualifier_attribute10

325: => hxc_ulq_shd.g_old_rec.qualifier_attribute8
326: ,p_qualifier_attribute9_o
327: => hxc_ulq_shd.g_old_rec.qualifier_attribute9
328: ,p_qualifier_attribute10_o
329: => hxc_ulq_shd.g_old_rec.qualifier_attribute10
330: ,p_qualifier_attribute11_o
331: => hxc_ulq_shd.g_old_rec.qualifier_attribute11
332: ,p_qualifier_attribute12_o
333: => hxc_ulq_shd.g_old_rec.qualifier_attribute12

Line 331: => hxc_ulq_shd.g_old_rec.qualifier_attribute11

327: => hxc_ulq_shd.g_old_rec.qualifier_attribute9
328: ,p_qualifier_attribute10_o
329: => hxc_ulq_shd.g_old_rec.qualifier_attribute10
330: ,p_qualifier_attribute11_o
331: => hxc_ulq_shd.g_old_rec.qualifier_attribute11
332: ,p_qualifier_attribute12_o
333: => hxc_ulq_shd.g_old_rec.qualifier_attribute12
334: ,p_qualifier_attribute13_o
335: => hxc_ulq_shd.g_old_rec.qualifier_attribute13

Line 333: => hxc_ulq_shd.g_old_rec.qualifier_attribute12

329: => hxc_ulq_shd.g_old_rec.qualifier_attribute10
330: ,p_qualifier_attribute11_o
331: => hxc_ulq_shd.g_old_rec.qualifier_attribute11
332: ,p_qualifier_attribute12_o
333: => hxc_ulq_shd.g_old_rec.qualifier_attribute12
334: ,p_qualifier_attribute13_o
335: => hxc_ulq_shd.g_old_rec.qualifier_attribute13
336: ,p_qualifier_attribute14_o
337: => hxc_ulq_shd.g_old_rec.qualifier_attribute14

Line 335: => hxc_ulq_shd.g_old_rec.qualifier_attribute13

331: => hxc_ulq_shd.g_old_rec.qualifier_attribute11
332: ,p_qualifier_attribute12_o
333: => hxc_ulq_shd.g_old_rec.qualifier_attribute12
334: ,p_qualifier_attribute13_o
335: => hxc_ulq_shd.g_old_rec.qualifier_attribute13
336: ,p_qualifier_attribute14_o
337: => hxc_ulq_shd.g_old_rec.qualifier_attribute14
338: ,p_qualifier_attribute15_o
339: => hxc_ulq_shd.g_old_rec.qualifier_attribute15

Line 337: => hxc_ulq_shd.g_old_rec.qualifier_attribute14

333: => hxc_ulq_shd.g_old_rec.qualifier_attribute12
334: ,p_qualifier_attribute13_o
335: => hxc_ulq_shd.g_old_rec.qualifier_attribute13
336: ,p_qualifier_attribute14_o
337: => hxc_ulq_shd.g_old_rec.qualifier_attribute14
338: ,p_qualifier_attribute15_o
339: => hxc_ulq_shd.g_old_rec.qualifier_attribute15
340: ,p_qualifier_attribute16_o
341: => hxc_ulq_shd.g_old_rec.qualifier_attribute16

Line 339: => hxc_ulq_shd.g_old_rec.qualifier_attribute15

335: => hxc_ulq_shd.g_old_rec.qualifier_attribute13
336: ,p_qualifier_attribute14_o
337: => hxc_ulq_shd.g_old_rec.qualifier_attribute14
338: ,p_qualifier_attribute15_o
339: => hxc_ulq_shd.g_old_rec.qualifier_attribute15
340: ,p_qualifier_attribute16_o
341: => hxc_ulq_shd.g_old_rec.qualifier_attribute16
342: ,p_qualifier_attribute17_o
343: => hxc_ulq_shd.g_old_rec.qualifier_attribute17

Line 341: => hxc_ulq_shd.g_old_rec.qualifier_attribute16

337: => hxc_ulq_shd.g_old_rec.qualifier_attribute14
338: ,p_qualifier_attribute15_o
339: => hxc_ulq_shd.g_old_rec.qualifier_attribute15
340: ,p_qualifier_attribute16_o
341: => hxc_ulq_shd.g_old_rec.qualifier_attribute16
342: ,p_qualifier_attribute17_o
343: => hxc_ulq_shd.g_old_rec.qualifier_attribute17
344: ,p_qualifier_attribute18_o
345: => hxc_ulq_shd.g_old_rec.qualifier_attribute18

Line 343: => hxc_ulq_shd.g_old_rec.qualifier_attribute17

339: => hxc_ulq_shd.g_old_rec.qualifier_attribute15
340: ,p_qualifier_attribute16_o
341: => hxc_ulq_shd.g_old_rec.qualifier_attribute16
342: ,p_qualifier_attribute17_o
343: => hxc_ulq_shd.g_old_rec.qualifier_attribute17
344: ,p_qualifier_attribute18_o
345: => hxc_ulq_shd.g_old_rec.qualifier_attribute18
346: ,p_qualifier_attribute19_o
347: => hxc_ulq_shd.g_old_rec.qualifier_attribute19

Line 345: => hxc_ulq_shd.g_old_rec.qualifier_attribute18

341: => hxc_ulq_shd.g_old_rec.qualifier_attribute16
342: ,p_qualifier_attribute17_o
343: => hxc_ulq_shd.g_old_rec.qualifier_attribute17
344: ,p_qualifier_attribute18_o
345: => hxc_ulq_shd.g_old_rec.qualifier_attribute18
346: ,p_qualifier_attribute19_o
347: => hxc_ulq_shd.g_old_rec.qualifier_attribute19
348: ,p_qualifier_attribute20_o
349: => hxc_ulq_shd.g_old_rec.qualifier_attribute20

Line 347: => hxc_ulq_shd.g_old_rec.qualifier_attribute19

343: => hxc_ulq_shd.g_old_rec.qualifier_attribute17
344: ,p_qualifier_attribute18_o
345: => hxc_ulq_shd.g_old_rec.qualifier_attribute18
346: ,p_qualifier_attribute19_o
347: => hxc_ulq_shd.g_old_rec.qualifier_attribute19
348: ,p_qualifier_attribute20_o
349: => hxc_ulq_shd.g_old_rec.qualifier_attribute20
350: ,p_qualifier_attribute21_o
351: => hxc_ulq_shd.g_old_rec.qualifier_attribute21

Line 349: => hxc_ulq_shd.g_old_rec.qualifier_attribute20

345: => hxc_ulq_shd.g_old_rec.qualifier_attribute18
346: ,p_qualifier_attribute19_o
347: => hxc_ulq_shd.g_old_rec.qualifier_attribute19
348: ,p_qualifier_attribute20_o
349: => hxc_ulq_shd.g_old_rec.qualifier_attribute20
350: ,p_qualifier_attribute21_o
351: => hxc_ulq_shd.g_old_rec.qualifier_attribute21
352: ,p_qualifier_attribute22_o
353: => hxc_ulq_shd.g_old_rec.qualifier_attribute22

Line 351: => hxc_ulq_shd.g_old_rec.qualifier_attribute21

347: => hxc_ulq_shd.g_old_rec.qualifier_attribute19
348: ,p_qualifier_attribute20_o
349: => hxc_ulq_shd.g_old_rec.qualifier_attribute20
350: ,p_qualifier_attribute21_o
351: => hxc_ulq_shd.g_old_rec.qualifier_attribute21
352: ,p_qualifier_attribute22_o
353: => hxc_ulq_shd.g_old_rec.qualifier_attribute22
354: ,p_qualifier_attribute23_o
355: => hxc_ulq_shd.g_old_rec.qualifier_attribute23

Line 353: => hxc_ulq_shd.g_old_rec.qualifier_attribute22

349: => hxc_ulq_shd.g_old_rec.qualifier_attribute20
350: ,p_qualifier_attribute21_o
351: => hxc_ulq_shd.g_old_rec.qualifier_attribute21
352: ,p_qualifier_attribute22_o
353: => hxc_ulq_shd.g_old_rec.qualifier_attribute22
354: ,p_qualifier_attribute23_o
355: => hxc_ulq_shd.g_old_rec.qualifier_attribute23
356: ,p_qualifier_attribute24_o
357: => hxc_ulq_shd.g_old_rec.qualifier_attribute24

Line 355: => hxc_ulq_shd.g_old_rec.qualifier_attribute23

351: => hxc_ulq_shd.g_old_rec.qualifier_attribute21
352: ,p_qualifier_attribute22_o
353: => hxc_ulq_shd.g_old_rec.qualifier_attribute22
354: ,p_qualifier_attribute23_o
355: => hxc_ulq_shd.g_old_rec.qualifier_attribute23
356: ,p_qualifier_attribute24_o
357: => hxc_ulq_shd.g_old_rec.qualifier_attribute24
358: ,p_qualifier_attribute25_o
359: => hxc_ulq_shd.g_old_rec.qualifier_attribute25

Line 357: => hxc_ulq_shd.g_old_rec.qualifier_attribute24

353: => hxc_ulq_shd.g_old_rec.qualifier_attribute22
354: ,p_qualifier_attribute23_o
355: => hxc_ulq_shd.g_old_rec.qualifier_attribute23
356: ,p_qualifier_attribute24_o
357: => hxc_ulq_shd.g_old_rec.qualifier_attribute24
358: ,p_qualifier_attribute25_o
359: => hxc_ulq_shd.g_old_rec.qualifier_attribute25
360: ,p_qualifier_attribute26_o
361: => hxc_ulq_shd.g_old_rec.qualifier_attribute26

Line 359: => hxc_ulq_shd.g_old_rec.qualifier_attribute25

355: => hxc_ulq_shd.g_old_rec.qualifier_attribute23
356: ,p_qualifier_attribute24_o
357: => hxc_ulq_shd.g_old_rec.qualifier_attribute24
358: ,p_qualifier_attribute25_o
359: => hxc_ulq_shd.g_old_rec.qualifier_attribute25
360: ,p_qualifier_attribute26_o
361: => hxc_ulq_shd.g_old_rec.qualifier_attribute26
362: ,p_qualifier_attribute27_o
363: => hxc_ulq_shd.g_old_rec.qualifier_attribute27

Line 361: => hxc_ulq_shd.g_old_rec.qualifier_attribute26

357: => hxc_ulq_shd.g_old_rec.qualifier_attribute24
358: ,p_qualifier_attribute25_o
359: => hxc_ulq_shd.g_old_rec.qualifier_attribute25
360: ,p_qualifier_attribute26_o
361: => hxc_ulq_shd.g_old_rec.qualifier_attribute26
362: ,p_qualifier_attribute27_o
363: => hxc_ulq_shd.g_old_rec.qualifier_attribute27
364: ,p_qualifier_attribute28_o
365: => hxc_ulq_shd.g_old_rec.qualifier_attribute28

Line 363: => hxc_ulq_shd.g_old_rec.qualifier_attribute27

359: => hxc_ulq_shd.g_old_rec.qualifier_attribute25
360: ,p_qualifier_attribute26_o
361: => hxc_ulq_shd.g_old_rec.qualifier_attribute26
362: ,p_qualifier_attribute27_o
363: => hxc_ulq_shd.g_old_rec.qualifier_attribute27
364: ,p_qualifier_attribute28_o
365: => hxc_ulq_shd.g_old_rec.qualifier_attribute28
366: ,p_qualifier_attribute29_o
367: => hxc_ulq_shd.g_old_rec.qualifier_attribute29

Line 365: => hxc_ulq_shd.g_old_rec.qualifier_attribute28

361: => hxc_ulq_shd.g_old_rec.qualifier_attribute26
362: ,p_qualifier_attribute27_o
363: => hxc_ulq_shd.g_old_rec.qualifier_attribute27
364: ,p_qualifier_attribute28_o
365: => hxc_ulq_shd.g_old_rec.qualifier_attribute28
366: ,p_qualifier_attribute29_o
367: => hxc_ulq_shd.g_old_rec.qualifier_attribute29
368: ,p_qualifier_attribute30_o
369: => hxc_ulq_shd.g_old_rec.qualifier_attribute30

Line 367: => hxc_ulq_shd.g_old_rec.qualifier_attribute29

363: => hxc_ulq_shd.g_old_rec.qualifier_attribute27
364: ,p_qualifier_attribute28_o
365: => hxc_ulq_shd.g_old_rec.qualifier_attribute28
366: ,p_qualifier_attribute29_o
367: => hxc_ulq_shd.g_old_rec.qualifier_attribute29
368: ,p_qualifier_attribute30_o
369: => hxc_ulq_shd.g_old_rec.qualifier_attribute30
370: ,p_object_version_number_o
371: => hxc_ulq_shd.g_old_rec.object_version_number

Line 369: => hxc_ulq_shd.g_old_rec.qualifier_attribute30

365: => hxc_ulq_shd.g_old_rec.qualifier_attribute28
366: ,p_qualifier_attribute29_o
367: => hxc_ulq_shd.g_old_rec.qualifier_attribute29
368: ,p_qualifier_attribute30_o
369: => hxc_ulq_shd.g_old_rec.qualifier_attribute30
370: ,p_object_version_number_o
371: => hxc_ulq_shd.g_old_rec.object_version_number
372: );
373: --

Line 371: => hxc_ulq_shd.g_old_rec.object_version_number

367: => hxc_ulq_shd.g_old_rec.qualifier_attribute29
368: ,p_qualifier_attribute30_o
369: => hxc_ulq_shd.g_old_rec.qualifier_attribute30
370: ,p_object_version_number_o
371: => hxc_ulq_shd.g_old_rec.object_version_number
372: );
373: --
374: exception
375: --

Line 433: (p_rec in out nocopy hxc_ulq_shd.g_rec_type

429: --
430: -- {End Of Comments}
431: -- ----------------------------------------------------------------------------
432: Procedure convert_defs
433: (p_rec in out nocopy hxc_ulq_shd.g_rec_type
434: ) is
435: --
436: Begin
437: --

Line 445: hxc_ulq_shd.g_old_rec.qualifier_name;

441: -- is being used then we must set to the 'current' argument value.
442: --
443: If (p_rec.qualifier_name = hr_api.g_varchar2) then
444: p_rec.qualifier_name :=
445: hxc_ulq_shd.g_old_rec.qualifier_name;
446: End If;
447: If (p_rec.qualifier_attribute_category = hr_api.g_varchar2) then
448: p_rec.qualifier_attribute_category :=
449: hxc_ulq_shd.g_old_rec.qualifier_attribute_category;

Line 449: hxc_ulq_shd.g_old_rec.qualifier_attribute_category;

445: hxc_ulq_shd.g_old_rec.qualifier_name;
446: End If;
447: If (p_rec.qualifier_attribute_category = hr_api.g_varchar2) then
448: p_rec.qualifier_attribute_category :=
449: hxc_ulq_shd.g_old_rec.qualifier_attribute_category;
450: End If;
451: If (p_rec.qualifier_attribute1 = hr_api.g_varchar2) then
452: p_rec.qualifier_attribute1 :=
453: hxc_ulq_shd.g_old_rec.qualifier_attribute1;

Line 453: hxc_ulq_shd.g_old_rec.qualifier_attribute1;

449: hxc_ulq_shd.g_old_rec.qualifier_attribute_category;
450: End If;
451: If (p_rec.qualifier_attribute1 = hr_api.g_varchar2) then
452: p_rec.qualifier_attribute1 :=
453: hxc_ulq_shd.g_old_rec.qualifier_attribute1;
454: End If;
455: If (p_rec.qualifier_attribute2 = hr_api.g_varchar2) then
456: p_rec.qualifier_attribute2 :=
457: hxc_ulq_shd.g_old_rec.qualifier_attribute2;

Line 457: hxc_ulq_shd.g_old_rec.qualifier_attribute2;

453: hxc_ulq_shd.g_old_rec.qualifier_attribute1;
454: End If;
455: If (p_rec.qualifier_attribute2 = hr_api.g_varchar2) then
456: p_rec.qualifier_attribute2 :=
457: hxc_ulq_shd.g_old_rec.qualifier_attribute2;
458: End If;
459: If (p_rec.qualifier_attribute3 = hr_api.g_varchar2) then
460: p_rec.qualifier_attribute3 :=
461: hxc_ulq_shd.g_old_rec.qualifier_attribute3;

Line 461: hxc_ulq_shd.g_old_rec.qualifier_attribute3;

457: hxc_ulq_shd.g_old_rec.qualifier_attribute2;
458: End If;
459: If (p_rec.qualifier_attribute3 = hr_api.g_varchar2) then
460: p_rec.qualifier_attribute3 :=
461: hxc_ulq_shd.g_old_rec.qualifier_attribute3;
462: End If;
463: If (p_rec.qualifier_attribute4 = hr_api.g_varchar2) then
464: p_rec.qualifier_attribute4 :=
465: hxc_ulq_shd.g_old_rec.qualifier_attribute4;

Line 465: hxc_ulq_shd.g_old_rec.qualifier_attribute4;

461: hxc_ulq_shd.g_old_rec.qualifier_attribute3;
462: End If;
463: If (p_rec.qualifier_attribute4 = hr_api.g_varchar2) then
464: p_rec.qualifier_attribute4 :=
465: hxc_ulq_shd.g_old_rec.qualifier_attribute4;
466: End If;
467: If (p_rec.qualifier_attribute5 = hr_api.g_varchar2) then
468: p_rec.qualifier_attribute5 :=
469: hxc_ulq_shd.g_old_rec.qualifier_attribute5;

Line 469: hxc_ulq_shd.g_old_rec.qualifier_attribute5;

465: hxc_ulq_shd.g_old_rec.qualifier_attribute4;
466: End If;
467: If (p_rec.qualifier_attribute5 = hr_api.g_varchar2) then
468: p_rec.qualifier_attribute5 :=
469: hxc_ulq_shd.g_old_rec.qualifier_attribute5;
470: End If;
471: If (p_rec.qualifier_attribute6 = hr_api.g_varchar2) then
472: p_rec.qualifier_attribute6 :=
473: hxc_ulq_shd.g_old_rec.qualifier_attribute6;

Line 473: hxc_ulq_shd.g_old_rec.qualifier_attribute6;

469: hxc_ulq_shd.g_old_rec.qualifier_attribute5;
470: End If;
471: If (p_rec.qualifier_attribute6 = hr_api.g_varchar2) then
472: p_rec.qualifier_attribute6 :=
473: hxc_ulq_shd.g_old_rec.qualifier_attribute6;
474: End If;
475: If (p_rec.qualifier_attribute7 = hr_api.g_varchar2) then
476: p_rec.qualifier_attribute7 :=
477: hxc_ulq_shd.g_old_rec.qualifier_attribute7;

Line 477: hxc_ulq_shd.g_old_rec.qualifier_attribute7;

473: hxc_ulq_shd.g_old_rec.qualifier_attribute6;
474: End If;
475: If (p_rec.qualifier_attribute7 = hr_api.g_varchar2) then
476: p_rec.qualifier_attribute7 :=
477: hxc_ulq_shd.g_old_rec.qualifier_attribute7;
478: End If;
479: If (p_rec.qualifier_attribute8 = hr_api.g_varchar2) then
480: p_rec.qualifier_attribute8 :=
481: hxc_ulq_shd.g_old_rec.qualifier_attribute8;

Line 481: hxc_ulq_shd.g_old_rec.qualifier_attribute8;

477: hxc_ulq_shd.g_old_rec.qualifier_attribute7;
478: End If;
479: If (p_rec.qualifier_attribute8 = hr_api.g_varchar2) then
480: p_rec.qualifier_attribute8 :=
481: hxc_ulq_shd.g_old_rec.qualifier_attribute8;
482: End If;
483: If (p_rec.qualifier_attribute9 = hr_api.g_varchar2) then
484: p_rec.qualifier_attribute9 :=
485: hxc_ulq_shd.g_old_rec.qualifier_attribute9;

Line 485: hxc_ulq_shd.g_old_rec.qualifier_attribute9;

481: hxc_ulq_shd.g_old_rec.qualifier_attribute8;
482: End If;
483: If (p_rec.qualifier_attribute9 = hr_api.g_varchar2) then
484: p_rec.qualifier_attribute9 :=
485: hxc_ulq_shd.g_old_rec.qualifier_attribute9;
486: End If;
487: If (p_rec.qualifier_attribute10 = hr_api.g_varchar2) then
488: p_rec.qualifier_attribute10 :=
489: hxc_ulq_shd.g_old_rec.qualifier_attribute10;

Line 489: hxc_ulq_shd.g_old_rec.qualifier_attribute10;

485: hxc_ulq_shd.g_old_rec.qualifier_attribute9;
486: End If;
487: If (p_rec.qualifier_attribute10 = hr_api.g_varchar2) then
488: p_rec.qualifier_attribute10 :=
489: hxc_ulq_shd.g_old_rec.qualifier_attribute10;
490: End If;
491: If (p_rec.qualifier_attribute11 = hr_api.g_varchar2) then
492: p_rec.qualifier_attribute11 :=
493: hxc_ulq_shd.g_old_rec.qualifier_attribute11;

Line 493: hxc_ulq_shd.g_old_rec.qualifier_attribute11;

489: hxc_ulq_shd.g_old_rec.qualifier_attribute10;
490: End If;
491: If (p_rec.qualifier_attribute11 = hr_api.g_varchar2) then
492: p_rec.qualifier_attribute11 :=
493: hxc_ulq_shd.g_old_rec.qualifier_attribute11;
494: End If;
495: If (p_rec.qualifier_attribute12 = hr_api.g_varchar2) then
496: p_rec.qualifier_attribute12 :=
497: hxc_ulq_shd.g_old_rec.qualifier_attribute12;

Line 497: hxc_ulq_shd.g_old_rec.qualifier_attribute12;

493: hxc_ulq_shd.g_old_rec.qualifier_attribute11;
494: End If;
495: If (p_rec.qualifier_attribute12 = hr_api.g_varchar2) then
496: p_rec.qualifier_attribute12 :=
497: hxc_ulq_shd.g_old_rec.qualifier_attribute12;
498: End If;
499: If (p_rec.qualifier_attribute13 = hr_api.g_varchar2) then
500: p_rec.qualifier_attribute13 :=
501: hxc_ulq_shd.g_old_rec.qualifier_attribute13;

Line 501: hxc_ulq_shd.g_old_rec.qualifier_attribute13;

497: hxc_ulq_shd.g_old_rec.qualifier_attribute12;
498: End If;
499: If (p_rec.qualifier_attribute13 = hr_api.g_varchar2) then
500: p_rec.qualifier_attribute13 :=
501: hxc_ulq_shd.g_old_rec.qualifier_attribute13;
502: End If;
503: If (p_rec.qualifier_attribute14 = hr_api.g_varchar2) then
504: p_rec.qualifier_attribute14 :=
505: hxc_ulq_shd.g_old_rec.qualifier_attribute14;

Line 505: hxc_ulq_shd.g_old_rec.qualifier_attribute14;

501: hxc_ulq_shd.g_old_rec.qualifier_attribute13;
502: End If;
503: If (p_rec.qualifier_attribute14 = hr_api.g_varchar2) then
504: p_rec.qualifier_attribute14 :=
505: hxc_ulq_shd.g_old_rec.qualifier_attribute14;
506: End If;
507: If (p_rec.qualifier_attribute15 = hr_api.g_varchar2) then
508: p_rec.qualifier_attribute15 :=
509: hxc_ulq_shd.g_old_rec.qualifier_attribute15;

Line 509: hxc_ulq_shd.g_old_rec.qualifier_attribute15;

505: hxc_ulq_shd.g_old_rec.qualifier_attribute14;
506: End If;
507: If (p_rec.qualifier_attribute15 = hr_api.g_varchar2) then
508: p_rec.qualifier_attribute15 :=
509: hxc_ulq_shd.g_old_rec.qualifier_attribute15;
510: End If;
511: If (p_rec.qualifier_attribute16 = hr_api.g_varchar2) then
512: p_rec.qualifier_attribute16 :=
513: hxc_ulq_shd.g_old_rec.qualifier_attribute16;

Line 513: hxc_ulq_shd.g_old_rec.qualifier_attribute16;

509: hxc_ulq_shd.g_old_rec.qualifier_attribute15;
510: End If;
511: If (p_rec.qualifier_attribute16 = hr_api.g_varchar2) then
512: p_rec.qualifier_attribute16 :=
513: hxc_ulq_shd.g_old_rec.qualifier_attribute16;
514: End If;
515: If (p_rec.qualifier_attribute17 = hr_api.g_varchar2) then
516: p_rec.qualifier_attribute17 :=
517: hxc_ulq_shd.g_old_rec.qualifier_attribute17;

Line 517: hxc_ulq_shd.g_old_rec.qualifier_attribute17;

513: hxc_ulq_shd.g_old_rec.qualifier_attribute16;
514: End If;
515: If (p_rec.qualifier_attribute17 = hr_api.g_varchar2) then
516: p_rec.qualifier_attribute17 :=
517: hxc_ulq_shd.g_old_rec.qualifier_attribute17;
518: End If;
519: If (p_rec.qualifier_attribute18 = hr_api.g_varchar2) then
520: p_rec.qualifier_attribute18 :=
521: hxc_ulq_shd.g_old_rec.qualifier_attribute18;

Line 521: hxc_ulq_shd.g_old_rec.qualifier_attribute18;

517: hxc_ulq_shd.g_old_rec.qualifier_attribute17;
518: End If;
519: If (p_rec.qualifier_attribute18 = hr_api.g_varchar2) then
520: p_rec.qualifier_attribute18 :=
521: hxc_ulq_shd.g_old_rec.qualifier_attribute18;
522: End If;
523: If (p_rec.qualifier_attribute19 = hr_api.g_varchar2) then
524: p_rec.qualifier_attribute19 :=
525: hxc_ulq_shd.g_old_rec.qualifier_attribute19;

Line 525: hxc_ulq_shd.g_old_rec.qualifier_attribute19;

521: hxc_ulq_shd.g_old_rec.qualifier_attribute18;
522: End If;
523: If (p_rec.qualifier_attribute19 = hr_api.g_varchar2) then
524: p_rec.qualifier_attribute19 :=
525: hxc_ulq_shd.g_old_rec.qualifier_attribute19;
526: End If;
527: If (p_rec.qualifier_attribute20 = hr_api.g_varchar2) then
528: p_rec.qualifier_attribute20 :=
529: hxc_ulq_shd.g_old_rec.qualifier_attribute20;

Line 529: hxc_ulq_shd.g_old_rec.qualifier_attribute20;

525: hxc_ulq_shd.g_old_rec.qualifier_attribute19;
526: End If;
527: If (p_rec.qualifier_attribute20 = hr_api.g_varchar2) then
528: p_rec.qualifier_attribute20 :=
529: hxc_ulq_shd.g_old_rec.qualifier_attribute20;
530: End If;
531: If (p_rec.qualifier_attribute21 = hr_api.g_varchar2) then
532: p_rec.qualifier_attribute21 :=
533: hxc_ulq_shd.g_old_rec.qualifier_attribute21;

Line 533: hxc_ulq_shd.g_old_rec.qualifier_attribute21;

529: hxc_ulq_shd.g_old_rec.qualifier_attribute20;
530: End If;
531: If (p_rec.qualifier_attribute21 = hr_api.g_varchar2) then
532: p_rec.qualifier_attribute21 :=
533: hxc_ulq_shd.g_old_rec.qualifier_attribute21;
534: End If;
535: If (p_rec.qualifier_attribute22 = hr_api.g_varchar2) then
536: p_rec.qualifier_attribute22 :=
537: hxc_ulq_shd.g_old_rec.qualifier_attribute22;

Line 537: hxc_ulq_shd.g_old_rec.qualifier_attribute22;

533: hxc_ulq_shd.g_old_rec.qualifier_attribute21;
534: End If;
535: If (p_rec.qualifier_attribute22 = hr_api.g_varchar2) then
536: p_rec.qualifier_attribute22 :=
537: hxc_ulq_shd.g_old_rec.qualifier_attribute22;
538: End If;
539: If (p_rec.qualifier_attribute23 = hr_api.g_varchar2) then
540: p_rec.qualifier_attribute23 :=
541: hxc_ulq_shd.g_old_rec.qualifier_attribute23;

Line 541: hxc_ulq_shd.g_old_rec.qualifier_attribute23;

537: hxc_ulq_shd.g_old_rec.qualifier_attribute22;
538: End If;
539: If (p_rec.qualifier_attribute23 = hr_api.g_varchar2) then
540: p_rec.qualifier_attribute23 :=
541: hxc_ulq_shd.g_old_rec.qualifier_attribute23;
542: End If;
543: If (p_rec.qualifier_attribute24 = hr_api.g_varchar2) then
544: p_rec.qualifier_attribute24 :=
545: hxc_ulq_shd.g_old_rec.qualifier_attribute24;

Line 545: hxc_ulq_shd.g_old_rec.qualifier_attribute24;

541: hxc_ulq_shd.g_old_rec.qualifier_attribute23;
542: End If;
543: If (p_rec.qualifier_attribute24 = hr_api.g_varchar2) then
544: p_rec.qualifier_attribute24 :=
545: hxc_ulq_shd.g_old_rec.qualifier_attribute24;
546: End If;
547: If (p_rec.qualifier_attribute25 = hr_api.g_varchar2) then
548: p_rec.qualifier_attribute25 :=
549: hxc_ulq_shd.g_old_rec.qualifier_attribute25;

Line 549: hxc_ulq_shd.g_old_rec.qualifier_attribute25;

545: hxc_ulq_shd.g_old_rec.qualifier_attribute24;
546: End If;
547: If (p_rec.qualifier_attribute25 = hr_api.g_varchar2) then
548: p_rec.qualifier_attribute25 :=
549: hxc_ulq_shd.g_old_rec.qualifier_attribute25;
550: End If;
551: If (p_rec.qualifier_attribute26 = hr_api.g_varchar2) then
552: p_rec.qualifier_attribute26 :=
553: hxc_ulq_shd.g_old_rec.qualifier_attribute26;

Line 553: hxc_ulq_shd.g_old_rec.qualifier_attribute26;

549: hxc_ulq_shd.g_old_rec.qualifier_attribute25;
550: End If;
551: If (p_rec.qualifier_attribute26 = hr_api.g_varchar2) then
552: p_rec.qualifier_attribute26 :=
553: hxc_ulq_shd.g_old_rec.qualifier_attribute26;
554: End If;
555: If (p_rec.qualifier_attribute27 = hr_api.g_varchar2) then
556: p_rec.qualifier_attribute27 :=
557: hxc_ulq_shd.g_old_rec.qualifier_attribute27;

Line 557: hxc_ulq_shd.g_old_rec.qualifier_attribute27;

553: hxc_ulq_shd.g_old_rec.qualifier_attribute26;
554: End If;
555: If (p_rec.qualifier_attribute27 = hr_api.g_varchar2) then
556: p_rec.qualifier_attribute27 :=
557: hxc_ulq_shd.g_old_rec.qualifier_attribute27;
558: End If;
559: If (p_rec.qualifier_attribute28 = hr_api.g_varchar2) then
560: p_rec.qualifier_attribute28 :=
561: hxc_ulq_shd.g_old_rec.qualifier_attribute28;

Line 561: hxc_ulq_shd.g_old_rec.qualifier_attribute28;

557: hxc_ulq_shd.g_old_rec.qualifier_attribute27;
558: End If;
559: If (p_rec.qualifier_attribute28 = hr_api.g_varchar2) then
560: p_rec.qualifier_attribute28 :=
561: hxc_ulq_shd.g_old_rec.qualifier_attribute28;
562: End If;
563: If (p_rec.qualifier_attribute29 = hr_api.g_varchar2) then
564: p_rec.qualifier_attribute29 :=
565: hxc_ulq_shd.g_old_rec.qualifier_attribute29;

Line 565: hxc_ulq_shd.g_old_rec.qualifier_attribute29;

561: hxc_ulq_shd.g_old_rec.qualifier_attribute28;
562: End If;
563: If (p_rec.qualifier_attribute29 = hr_api.g_varchar2) then
564: p_rec.qualifier_attribute29 :=
565: hxc_ulq_shd.g_old_rec.qualifier_attribute29;
566: End If;
567: If (p_rec.qualifier_attribute30 = hr_api.g_varchar2) then
568: p_rec.qualifier_attribute30 :=
569: hxc_ulq_shd.g_old_rec.qualifier_attribute30;

Line 569: hxc_ulq_shd.g_old_rec.qualifier_attribute30;

565: hxc_ulq_shd.g_old_rec.qualifier_attribute29;
566: End If;
567: If (p_rec.qualifier_attribute30 = hr_api.g_varchar2) then
568: p_rec.qualifier_attribute30 :=
569: hxc_ulq_shd.g_old_rec.qualifier_attribute30;
570: End If;
571: --
572: End convert_defs;
573: --

Line 578: (p_rec in out nocopy hxc_ulq_shd.g_rec_type

574: -- ----------------------------------------------------------------------------
575: -- |---------------------------------< upd >----------------------------------|
576: -- ----------------------------------------------------------------------------
577: Procedure upd
578: (p_rec in out nocopy hxc_ulq_shd.g_rec_type
579: ) is
580: --
581: l_proc varchar2(72) ;
582: --

Line 592: hxc_ulq_shd.lck

588: end if;
589: --
590: -- We must lock the row which we need to update.
591: --
592: hxc_ulq_shd.lck
593: (p_rec.layout_comp_qualifier_id
594: ,p_rec.object_version_number
595: );
596: --

Line 664: l_rec hxc_ulq_shd.g_rec_type;

660: ,p_qualifier_attribute29 in varchar2 default hr_api.g_varchar2
661: ,p_qualifier_attribute30 in varchar2 default hr_api.g_varchar2
662: ) is
663: --
664: l_rec hxc_ulq_shd.g_rec_type;
665: l_proc varchar2(72) ;
666: --
667: Begin
668: g_debug :=hr_utility.debug_enabled;

Line 678: hxc_ulq_shd.convert_args

674: -- Call conversion function to turn arguments into the
675: -- l_rec structure.
676: --
677: l_rec :=
678: hxc_ulq_shd.convert_args
679: (p_layout_comp_qualifier_id
680: ,p_layout_component_id
681: ,p_qualifier_name
682: ,p_qualifier_attribute_category