120: hr_utility.set_location(' Leaving:'||l_proc, 10);
121: end if;
122: --
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));
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: --
132: hxc_ulq_shd.constraint_error
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: --
132: hxc_ulq_shd.constraint_error
133: (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: --
137: hxc_ulq_shd.constraint_error
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: --
137: hxc_ulq_shd.constraint_error
138: (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;
142: End update_dml;
372: );
373: --
374: exception
375: --
376: when hr_api.cannot_find_prog_unit then
377: --
378: hr_api.cannot_find_prog_unit_error
379: (p_module_name => 'HXC_LAYOUT_COMP_QUALIFIERS'
380: ,p_hook_type => 'AU');
374: exception
375: --
376: when hr_api.cannot_find_prog_unit then
377: --
378: hr_api.cannot_find_prog_unit_error
379: (p_module_name => 'HXC_LAYOUT_COMP_QUALIFIERS'
380: ,p_hook_type => 'AU');
381: --
382: end;
439: -- p_rec plsql record structure
440: -- to see if a system default is being used. If a system default
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
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;
450: End If;
451: If (p_rec.qualifier_attribute1 = hr_api.g_varchar2) then
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;
454: End If;
455: If (p_rec.qualifier_attribute2 = hr_api.g_varchar2) then
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;
458: End If;
459: If (p_rec.qualifier_attribute3 = hr_api.g_varchar2) then
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;
462: End If;
463: If (p_rec.qualifier_attribute4 = hr_api.g_varchar2) then
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;
466: End If;
467: If (p_rec.qualifier_attribute5 = hr_api.g_varchar2) then
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;
470: End If;
471: If (p_rec.qualifier_attribute6 = hr_api.g_varchar2) then
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;
474: End If;
475: If (p_rec.qualifier_attribute7 = hr_api.g_varchar2) then
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;
478: End If;
479: If (p_rec.qualifier_attribute8 = hr_api.g_varchar2) then
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;
482: End If;
483: If (p_rec.qualifier_attribute9 = hr_api.g_varchar2) then
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;
486: End If;
487: If (p_rec.qualifier_attribute10 = hr_api.g_varchar2) then
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;
490: End If;
491: If (p_rec.qualifier_attribute11 = hr_api.g_varchar2) then
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;
494: End If;
495: If (p_rec.qualifier_attribute12 = hr_api.g_varchar2) then
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;
498: End If;
499: If (p_rec.qualifier_attribute13 = hr_api.g_varchar2) then
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;
502: End If;
503: If (p_rec.qualifier_attribute14 = hr_api.g_varchar2) then
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;
506: End If;
507: If (p_rec.qualifier_attribute15 = hr_api.g_varchar2) then
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;
510: End If;
511: If (p_rec.qualifier_attribute16 = hr_api.g_varchar2) then
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;
514: End If;
515: If (p_rec.qualifier_attribute17 = hr_api.g_varchar2) then
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;
518: End If;
519: If (p_rec.qualifier_attribute18 = hr_api.g_varchar2) then
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;
522: End If;
523: If (p_rec.qualifier_attribute19 = hr_api.g_varchar2) then
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;
526: End If;
527: If (p_rec.qualifier_attribute20 = hr_api.g_varchar2) then
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;
530: End If;
531: If (p_rec.qualifier_attribute21 = hr_api.g_varchar2) then
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;
534: End If;
535: If (p_rec.qualifier_attribute22 = hr_api.g_varchar2) then
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;
538: End If;
539: If (p_rec.qualifier_attribute23 = hr_api.g_varchar2) then
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;
542: End If;
543: If (p_rec.qualifier_attribute24 = hr_api.g_varchar2) then
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;
546: End If;
547: If (p_rec.qualifier_attribute25 = hr_api.g_varchar2) then
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;
550: End If;
551: If (p_rec.qualifier_attribute26 = hr_api.g_varchar2) then
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;
554: End If;
555: If (p_rec.qualifier_attribute27 = hr_api.g_varchar2) then
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;
558: End If;
559: If (p_rec.qualifier_attribute28 = hr_api.g_varchar2) then
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;
562: End If;
563: If (p_rec.qualifier_attribute29 = hr_api.g_varchar2) then
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;
566: End If;
567: If (p_rec.qualifier_attribute30 = hr_api.g_varchar2) then
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;
570: End If;
571: --
625: -- ----------------------------------------------------------------------------
626: Procedure upd
627: (p_layout_comp_qualifier_id in number
628: ,p_object_version_number in out nocopy number
629: ,p_layout_component_id in number default hr_api.g_number
630: ,p_qualifier_name in varchar2 default hr_api.g_varchar2
631: ,p_qualifier_attribute_category in varchar2 default hr_api.g_varchar2
632: ,p_qualifier_attribute1 in varchar2 default hr_api.g_varchar2
633: ,p_qualifier_attribute2 in varchar2 default hr_api.g_varchar2
626: Procedure upd
627: (p_layout_comp_qualifier_id in number
628: ,p_object_version_number in out nocopy number
629: ,p_layout_component_id in number default hr_api.g_number
630: ,p_qualifier_name in varchar2 default hr_api.g_varchar2
631: ,p_qualifier_attribute_category in varchar2 default hr_api.g_varchar2
632: ,p_qualifier_attribute1 in varchar2 default hr_api.g_varchar2
633: ,p_qualifier_attribute2 in varchar2 default hr_api.g_varchar2
634: ,p_qualifier_attribute3 in varchar2 default hr_api.g_varchar2
627: (p_layout_comp_qualifier_id in number
628: ,p_object_version_number in out nocopy number
629: ,p_layout_component_id in number default hr_api.g_number
630: ,p_qualifier_name in varchar2 default hr_api.g_varchar2
631: ,p_qualifier_attribute_category in varchar2 default hr_api.g_varchar2
632: ,p_qualifier_attribute1 in varchar2 default hr_api.g_varchar2
633: ,p_qualifier_attribute2 in varchar2 default hr_api.g_varchar2
634: ,p_qualifier_attribute3 in varchar2 default hr_api.g_varchar2
635: ,p_qualifier_attribute4 in varchar2 default hr_api.g_varchar2
628: ,p_object_version_number in out nocopy number
629: ,p_layout_component_id in number default hr_api.g_number
630: ,p_qualifier_name in varchar2 default hr_api.g_varchar2
631: ,p_qualifier_attribute_category in varchar2 default hr_api.g_varchar2
632: ,p_qualifier_attribute1 in varchar2 default hr_api.g_varchar2
633: ,p_qualifier_attribute2 in varchar2 default hr_api.g_varchar2
634: ,p_qualifier_attribute3 in varchar2 default hr_api.g_varchar2
635: ,p_qualifier_attribute4 in varchar2 default hr_api.g_varchar2
636: ,p_qualifier_attribute5 in varchar2 default hr_api.g_varchar2
629: ,p_layout_component_id in number default hr_api.g_number
630: ,p_qualifier_name in varchar2 default hr_api.g_varchar2
631: ,p_qualifier_attribute_category in varchar2 default hr_api.g_varchar2
632: ,p_qualifier_attribute1 in varchar2 default hr_api.g_varchar2
633: ,p_qualifier_attribute2 in varchar2 default hr_api.g_varchar2
634: ,p_qualifier_attribute3 in varchar2 default hr_api.g_varchar2
635: ,p_qualifier_attribute4 in varchar2 default hr_api.g_varchar2
636: ,p_qualifier_attribute5 in varchar2 default hr_api.g_varchar2
637: ,p_qualifier_attribute6 in varchar2 default hr_api.g_varchar2
630: ,p_qualifier_name in varchar2 default hr_api.g_varchar2
631: ,p_qualifier_attribute_category in varchar2 default hr_api.g_varchar2
632: ,p_qualifier_attribute1 in varchar2 default hr_api.g_varchar2
633: ,p_qualifier_attribute2 in varchar2 default hr_api.g_varchar2
634: ,p_qualifier_attribute3 in varchar2 default hr_api.g_varchar2
635: ,p_qualifier_attribute4 in varchar2 default hr_api.g_varchar2
636: ,p_qualifier_attribute5 in varchar2 default hr_api.g_varchar2
637: ,p_qualifier_attribute6 in varchar2 default hr_api.g_varchar2
638: ,p_qualifier_attribute7 in varchar2 default hr_api.g_varchar2
631: ,p_qualifier_attribute_category in varchar2 default hr_api.g_varchar2
632: ,p_qualifier_attribute1 in varchar2 default hr_api.g_varchar2
633: ,p_qualifier_attribute2 in varchar2 default hr_api.g_varchar2
634: ,p_qualifier_attribute3 in varchar2 default hr_api.g_varchar2
635: ,p_qualifier_attribute4 in varchar2 default hr_api.g_varchar2
636: ,p_qualifier_attribute5 in varchar2 default hr_api.g_varchar2
637: ,p_qualifier_attribute6 in varchar2 default hr_api.g_varchar2
638: ,p_qualifier_attribute7 in varchar2 default hr_api.g_varchar2
639: ,p_qualifier_attribute8 in varchar2 default hr_api.g_varchar2
632: ,p_qualifier_attribute1 in varchar2 default hr_api.g_varchar2
633: ,p_qualifier_attribute2 in varchar2 default hr_api.g_varchar2
634: ,p_qualifier_attribute3 in varchar2 default hr_api.g_varchar2
635: ,p_qualifier_attribute4 in varchar2 default hr_api.g_varchar2
636: ,p_qualifier_attribute5 in varchar2 default hr_api.g_varchar2
637: ,p_qualifier_attribute6 in varchar2 default hr_api.g_varchar2
638: ,p_qualifier_attribute7 in varchar2 default hr_api.g_varchar2
639: ,p_qualifier_attribute8 in varchar2 default hr_api.g_varchar2
640: ,p_qualifier_attribute9 in varchar2 default hr_api.g_varchar2
633: ,p_qualifier_attribute2 in varchar2 default hr_api.g_varchar2
634: ,p_qualifier_attribute3 in varchar2 default hr_api.g_varchar2
635: ,p_qualifier_attribute4 in varchar2 default hr_api.g_varchar2
636: ,p_qualifier_attribute5 in varchar2 default hr_api.g_varchar2
637: ,p_qualifier_attribute6 in varchar2 default hr_api.g_varchar2
638: ,p_qualifier_attribute7 in varchar2 default hr_api.g_varchar2
639: ,p_qualifier_attribute8 in varchar2 default hr_api.g_varchar2
640: ,p_qualifier_attribute9 in varchar2 default hr_api.g_varchar2
641: ,p_qualifier_attribute10 in varchar2 default hr_api.g_varchar2
634: ,p_qualifier_attribute3 in varchar2 default hr_api.g_varchar2
635: ,p_qualifier_attribute4 in varchar2 default hr_api.g_varchar2
636: ,p_qualifier_attribute5 in varchar2 default hr_api.g_varchar2
637: ,p_qualifier_attribute6 in varchar2 default hr_api.g_varchar2
638: ,p_qualifier_attribute7 in varchar2 default hr_api.g_varchar2
639: ,p_qualifier_attribute8 in varchar2 default hr_api.g_varchar2
640: ,p_qualifier_attribute9 in varchar2 default hr_api.g_varchar2
641: ,p_qualifier_attribute10 in varchar2 default hr_api.g_varchar2
642: ,p_qualifier_attribute11 in varchar2 default hr_api.g_varchar2
635: ,p_qualifier_attribute4 in varchar2 default hr_api.g_varchar2
636: ,p_qualifier_attribute5 in varchar2 default hr_api.g_varchar2
637: ,p_qualifier_attribute6 in varchar2 default hr_api.g_varchar2
638: ,p_qualifier_attribute7 in varchar2 default hr_api.g_varchar2
639: ,p_qualifier_attribute8 in varchar2 default hr_api.g_varchar2
640: ,p_qualifier_attribute9 in varchar2 default hr_api.g_varchar2
641: ,p_qualifier_attribute10 in varchar2 default hr_api.g_varchar2
642: ,p_qualifier_attribute11 in varchar2 default hr_api.g_varchar2
643: ,p_qualifier_attribute12 in varchar2 default hr_api.g_varchar2
636: ,p_qualifier_attribute5 in varchar2 default hr_api.g_varchar2
637: ,p_qualifier_attribute6 in varchar2 default hr_api.g_varchar2
638: ,p_qualifier_attribute7 in varchar2 default hr_api.g_varchar2
639: ,p_qualifier_attribute8 in varchar2 default hr_api.g_varchar2
640: ,p_qualifier_attribute9 in varchar2 default hr_api.g_varchar2
641: ,p_qualifier_attribute10 in varchar2 default hr_api.g_varchar2
642: ,p_qualifier_attribute11 in varchar2 default hr_api.g_varchar2
643: ,p_qualifier_attribute12 in varchar2 default hr_api.g_varchar2
644: ,p_qualifier_attribute13 in varchar2 default hr_api.g_varchar2
637: ,p_qualifier_attribute6 in varchar2 default hr_api.g_varchar2
638: ,p_qualifier_attribute7 in varchar2 default hr_api.g_varchar2
639: ,p_qualifier_attribute8 in varchar2 default hr_api.g_varchar2
640: ,p_qualifier_attribute9 in varchar2 default hr_api.g_varchar2
641: ,p_qualifier_attribute10 in varchar2 default hr_api.g_varchar2
642: ,p_qualifier_attribute11 in varchar2 default hr_api.g_varchar2
643: ,p_qualifier_attribute12 in varchar2 default hr_api.g_varchar2
644: ,p_qualifier_attribute13 in varchar2 default hr_api.g_varchar2
645: ,p_qualifier_attribute14 in varchar2 default hr_api.g_varchar2
638: ,p_qualifier_attribute7 in varchar2 default hr_api.g_varchar2
639: ,p_qualifier_attribute8 in varchar2 default hr_api.g_varchar2
640: ,p_qualifier_attribute9 in varchar2 default hr_api.g_varchar2
641: ,p_qualifier_attribute10 in varchar2 default hr_api.g_varchar2
642: ,p_qualifier_attribute11 in varchar2 default hr_api.g_varchar2
643: ,p_qualifier_attribute12 in varchar2 default hr_api.g_varchar2
644: ,p_qualifier_attribute13 in varchar2 default hr_api.g_varchar2
645: ,p_qualifier_attribute14 in varchar2 default hr_api.g_varchar2
646: ,p_qualifier_attribute15 in varchar2 default hr_api.g_varchar2
639: ,p_qualifier_attribute8 in varchar2 default hr_api.g_varchar2
640: ,p_qualifier_attribute9 in varchar2 default hr_api.g_varchar2
641: ,p_qualifier_attribute10 in varchar2 default hr_api.g_varchar2
642: ,p_qualifier_attribute11 in varchar2 default hr_api.g_varchar2
643: ,p_qualifier_attribute12 in varchar2 default hr_api.g_varchar2
644: ,p_qualifier_attribute13 in varchar2 default hr_api.g_varchar2
645: ,p_qualifier_attribute14 in varchar2 default hr_api.g_varchar2
646: ,p_qualifier_attribute15 in varchar2 default hr_api.g_varchar2
647: ,p_qualifier_attribute16 in varchar2 default hr_api.g_varchar2
640: ,p_qualifier_attribute9 in varchar2 default hr_api.g_varchar2
641: ,p_qualifier_attribute10 in varchar2 default hr_api.g_varchar2
642: ,p_qualifier_attribute11 in varchar2 default hr_api.g_varchar2
643: ,p_qualifier_attribute12 in varchar2 default hr_api.g_varchar2
644: ,p_qualifier_attribute13 in varchar2 default hr_api.g_varchar2
645: ,p_qualifier_attribute14 in varchar2 default hr_api.g_varchar2
646: ,p_qualifier_attribute15 in varchar2 default hr_api.g_varchar2
647: ,p_qualifier_attribute16 in varchar2 default hr_api.g_varchar2
648: ,p_qualifier_attribute17 in varchar2 default hr_api.g_varchar2
641: ,p_qualifier_attribute10 in varchar2 default hr_api.g_varchar2
642: ,p_qualifier_attribute11 in varchar2 default hr_api.g_varchar2
643: ,p_qualifier_attribute12 in varchar2 default hr_api.g_varchar2
644: ,p_qualifier_attribute13 in varchar2 default hr_api.g_varchar2
645: ,p_qualifier_attribute14 in varchar2 default hr_api.g_varchar2
646: ,p_qualifier_attribute15 in varchar2 default hr_api.g_varchar2
647: ,p_qualifier_attribute16 in varchar2 default hr_api.g_varchar2
648: ,p_qualifier_attribute17 in varchar2 default hr_api.g_varchar2
649: ,p_qualifier_attribute18 in varchar2 default hr_api.g_varchar2
642: ,p_qualifier_attribute11 in varchar2 default hr_api.g_varchar2
643: ,p_qualifier_attribute12 in varchar2 default hr_api.g_varchar2
644: ,p_qualifier_attribute13 in varchar2 default hr_api.g_varchar2
645: ,p_qualifier_attribute14 in varchar2 default hr_api.g_varchar2
646: ,p_qualifier_attribute15 in varchar2 default hr_api.g_varchar2
647: ,p_qualifier_attribute16 in varchar2 default hr_api.g_varchar2
648: ,p_qualifier_attribute17 in varchar2 default hr_api.g_varchar2
649: ,p_qualifier_attribute18 in varchar2 default hr_api.g_varchar2
650: ,p_qualifier_attribute19 in varchar2 default hr_api.g_varchar2
643: ,p_qualifier_attribute12 in varchar2 default hr_api.g_varchar2
644: ,p_qualifier_attribute13 in varchar2 default hr_api.g_varchar2
645: ,p_qualifier_attribute14 in varchar2 default hr_api.g_varchar2
646: ,p_qualifier_attribute15 in varchar2 default hr_api.g_varchar2
647: ,p_qualifier_attribute16 in varchar2 default hr_api.g_varchar2
648: ,p_qualifier_attribute17 in varchar2 default hr_api.g_varchar2
649: ,p_qualifier_attribute18 in varchar2 default hr_api.g_varchar2
650: ,p_qualifier_attribute19 in varchar2 default hr_api.g_varchar2
651: ,p_qualifier_attribute20 in varchar2 default hr_api.g_varchar2
644: ,p_qualifier_attribute13 in varchar2 default hr_api.g_varchar2
645: ,p_qualifier_attribute14 in varchar2 default hr_api.g_varchar2
646: ,p_qualifier_attribute15 in varchar2 default hr_api.g_varchar2
647: ,p_qualifier_attribute16 in varchar2 default hr_api.g_varchar2
648: ,p_qualifier_attribute17 in varchar2 default hr_api.g_varchar2
649: ,p_qualifier_attribute18 in varchar2 default hr_api.g_varchar2
650: ,p_qualifier_attribute19 in varchar2 default hr_api.g_varchar2
651: ,p_qualifier_attribute20 in varchar2 default hr_api.g_varchar2
652: ,p_qualifier_attribute21 in varchar2 default hr_api.g_varchar2
645: ,p_qualifier_attribute14 in varchar2 default hr_api.g_varchar2
646: ,p_qualifier_attribute15 in varchar2 default hr_api.g_varchar2
647: ,p_qualifier_attribute16 in varchar2 default hr_api.g_varchar2
648: ,p_qualifier_attribute17 in varchar2 default hr_api.g_varchar2
649: ,p_qualifier_attribute18 in varchar2 default hr_api.g_varchar2
650: ,p_qualifier_attribute19 in varchar2 default hr_api.g_varchar2
651: ,p_qualifier_attribute20 in varchar2 default hr_api.g_varchar2
652: ,p_qualifier_attribute21 in varchar2 default hr_api.g_varchar2
653: ,p_qualifier_attribute22 in varchar2 default hr_api.g_varchar2
646: ,p_qualifier_attribute15 in varchar2 default hr_api.g_varchar2
647: ,p_qualifier_attribute16 in varchar2 default hr_api.g_varchar2
648: ,p_qualifier_attribute17 in varchar2 default hr_api.g_varchar2
649: ,p_qualifier_attribute18 in varchar2 default hr_api.g_varchar2
650: ,p_qualifier_attribute19 in varchar2 default hr_api.g_varchar2
651: ,p_qualifier_attribute20 in varchar2 default hr_api.g_varchar2
652: ,p_qualifier_attribute21 in varchar2 default hr_api.g_varchar2
653: ,p_qualifier_attribute22 in varchar2 default hr_api.g_varchar2
654: ,p_qualifier_attribute23 in varchar2 default hr_api.g_varchar2
647: ,p_qualifier_attribute16 in varchar2 default hr_api.g_varchar2
648: ,p_qualifier_attribute17 in varchar2 default hr_api.g_varchar2
649: ,p_qualifier_attribute18 in varchar2 default hr_api.g_varchar2
650: ,p_qualifier_attribute19 in varchar2 default hr_api.g_varchar2
651: ,p_qualifier_attribute20 in varchar2 default hr_api.g_varchar2
652: ,p_qualifier_attribute21 in varchar2 default hr_api.g_varchar2
653: ,p_qualifier_attribute22 in varchar2 default hr_api.g_varchar2
654: ,p_qualifier_attribute23 in varchar2 default hr_api.g_varchar2
655: ,p_qualifier_attribute24 in varchar2 default hr_api.g_varchar2
648: ,p_qualifier_attribute17 in varchar2 default hr_api.g_varchar2
649: ,p_qualifier_attribute18 in varchar2 default hr_api.g_varchar2
650: ,p_qualifier_attribute19 in varchar2 default hr_api.g_varchar2
651: ,p_qualifier_attribute20 in varchar2 default hr_api.g_varchar2
652: ,p_qualifier_attribute21 in varchar2 default hr_api.g_varchar2
653: ,p_qualifier_attribute22 in varchar2 default hr_api.g_varchar2
654: ,p_qualifier_attribute23 in varchar2 default hr_api.g_varchar2
655: ,p_qualifier_attribute24 in varchar2 default hr_api.g_varchar2
656: ,p_qualifier_attribute25 in varchar2 default hr_api.g_varchar2
649: ,p_qualifier_attribute18 in varchar2 default hr_api.g_varchar2
650: ,p_qualifier_attribute19 in varchar2 default hr_api.g_varchar2
651: ,p_qualifier_attribute20 in varchar2 default hr_api.g_varchar2
652: ,p_qualifier_attribute21 in varchar2 default hr_api.g_varchar2
653: ,p_qualifier_attribute22 in varchar2 default hr_api.g_varchar2
654: ,p_qualifier_attribute23 in varchar2 default hr_api.g_varchar2
655: ,p_qualifier_attribute24 in varchar2 default hr_api.g_varchar2
656: ,p_qualifier_attribute25 in varchar2 default hr_api.g_varchar2
657: ,p_qualifier_attribute26 in varchar2 default hr_api.g_varchar2
650: ,p_qualifier_attribute19 in varchar2 default hr_api.g_varchar2
651: ,p_qualifier_attribute20 in varchar2 default hr_api.g_varchar2
652: ,p_qualifier_attribute21 in varchar2 default hr_api.g_varchar2
653: ,p_qualifier_attribute22 in varchar2 default hr_api.g_varchar2
654: ,p_qualifier_attribute23 in varchar2 default hr_api.g_varchar2
655: ,p_qualifier_attribute24 in varchar2 default hr_api.g_varchar2
656: ,p_qualifier_attribute25 in varchar2 default hr_api.g_varchar2
657: ,p_qualifier_attribute26 in varchar2 default hr_api.g_varchar2
658: ,p_qualifier_attribute27 in varchar2 default hr_api.g_varchar2
651: ,p_qualifier_attribute20 in varchar2 default hr_api.g_varchar2
652: ,p_qualifier_attribute21 in varchar2 default hr_api.g_varchar2
653: ,p_qualifier_attribute22 in varchar2 default hr_api.g_varchar2
654: ,p_qualifier_attribute23 in varchar2 default hr_api.g_varchar2
655: ,p_qualifier_attribute24 in varchar2 default hr_api.g_varchar2
656: ,p_qualifier_attribute25 in varchar2 default hr_api.g_varchar2
657: ,p_qualifier_attribute26 in varchar2 default hr_api.g_varchar2
658: ,p_qualifier_attribute27 in varchar2 default hr_api.g_varchar2
659: ,p_qualifier_attribute28 in varchar2 default hr_api.g_varchar2
652: ,p_qualifier_attribute21 in varchar2 default hr_api.g_varchar2
653: ,p_qualifier_attribute22 in varchar2 default hr_api.g_varchar2
654: ,p_qualifier_attribute23 in varchar2 default hr_api.g_varchar2
655: ,p_qualifier_attribute24 in varchar2 default hr_api.g_varchar2
656: ,p_qualifier_attribute25 in varchar2 default hr_api.g_varchar2
657: ,p_qualifier_attribute26 in varchar2 default hr_api.g_varchar2
658: ,p_qualifier_attribute27 in varchar2 default hr_api.g_varchar2
659: ,p_qualifier_attribute28 in varchar2 default hr_api.g_varchar2
660: ,p_qualifier_attribute29 in varchar2 default hr_api.g_varchar2
653: ,p_qualifier_attribute22 in varchar2 default hr_api.g_varchar2
654: ,p_qualifier_attribute23 in varchar2 default hr_api.g_varchar2
655: ,p_qualifier_attribute24 in varchar2 default hr_api.g_varchar2
656: ,p_qualifier_attribute25 in varchar2 default hr_api.g_varchar2
657: ,p_qualifier_attribute26 in varchar2 default hr_api.g_varchar2
658: ,p_qualifier_attribute27 in varchar2 default hr_api.g_varchar2
659: ,p_qualifier_attribute28 in varchar2 default hr_api.g_varchar2
660: ,p_qualifier_attribute29 in varchar2 default hr_api.g_varchar2
661: ,p_qualifier_attribute30 in varchar2 default hr_api.g_varchar2
654: ,p_qualifier_attribute23 in varchar2 default hr_api.g_varchar2
655: ,p_qualifier_attribute24 in varchar2 default hr_api.g_varchar2
656: ,p_qualifier_attribute25 in varchar2 default hr_api.g_varchar2
657: ,p_qualifier_attribute26 in varchar2 default hr_api.g_varchar2
658: ,p_qualifier_attribute27 in varchar2 default hr_api.g_varchar2
659: ,p_qualifier_attribute28 in varchar2 default hr_api.g_varchar2
660: ,p_qualifier_attribute29 in varchar2 default hr_api.g_varchar2
661: ,p_qualifier_attribute30 in varchar2 default hr_api.g_varchar2
662: ) is
655: ,p_qualifier_attribute24 in varchar2 default hr_api.g_varchar2
656: ,p_qualifier_attribute25 in varchar2 default hr_api.g_varchar2
657: ,p_qualifier_attribute26 in varchar2 default hr_api.g_varchar2
658: ,p_qualifier_attribute27 in varchar2 default hr_api.g_varchar2
659: ,p_qualifier_attribute28 in varchar2 default hr_api.g_varchar2
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: --
656: ,p_qualifier_attribute25 in varchar2 default hr_api.g_varchar2
657: ,p_qualifier_attribute26 in varchar2 default hr_api.g_varchar2
658: ,p_qualifier_attribute27 in varchar2 default hr_api.g_varchar2
659: ,p_qualifier_attribute28 in varchar2 default hr_api.g_varchar2
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;
657: ,p_qualifier_attribute26 in varchar2 default hr_api.g_varchar2
658: ,p_qualifier_attribute27 in varchar2 default hr_api.g_varchar2
659: ,p_qualifier_attribute28 in varchar2 default hr_api.g_varchar2
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) ;