APPS.HXC_ULQ_UPD dependencies on HR_API

Line 124: When hr_api.check_integrity_violated Then

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));

Line 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

Line 129: When hr_api.parent_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
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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

Line 134: When hr_api.unique_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
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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;

Line 376: when hr_api.cannot_find_prog_unit then

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');

Line 378: hr_api.cannot_find_prog_unit_error

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;

Line 443: If (p_rec.qualifier_name = hr_api.g_varchar2) then

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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: --

Line 629: ,p_layout_component_id in number default hr_api.g_number

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

Line 630: ,p_qualifier_name 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

Line 631: ,p_qualifier_attribute_category 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

Line 632: ,p_qualifier_attribute1 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

Line 633: ,p_qualifier_attribute2 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

Line 634: ,p_qualifier_attribute3 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

Line 635: ,p_qualifier_attribute4 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

Line 636: ,p_qualifier_attribute5 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

Line 637: ,p_qualifier_attribute6 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

Line 638: ,p_qualifier_attribute7 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

Line 639: ,p_qualifier_attribute8 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

Line 640: ,p_qualifier_attribute9 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

Line 641: ,p_qualifier_attribute10 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

Line 642: ,p_qualifier_attribute11 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

Line 643: ,p_qualifier_attribute12 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

Line 644: ,p_qualifier_attribute13 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

Line 645: ,p_qualifier_attribute14 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

Line 646: ,p_qualifier_attribute15 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

Line 647: ,p_qualifier_attribute16 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

Line 648: ,p_qualifier_attribute17 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

Line 649: ,p_qualifier_attribute18 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

Line 650: ,p_qualifier_attribute19 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

Line 651: ,p_qualifier_attribute20 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

Line 652: ,p_qualifier_attribute21 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

Line 653: ,p_qualifier_attribute22 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

Line 654: ,p_qualifier_attribute23 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

Line 655: ,p_qualifier_attribute24 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

Line 656: ,p_qualifier_attribute25 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

Line 657: ,p_qualifier_attribute26 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

Line 658: ,p_qualifier_attribute27 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

Line 659: ,p_qualifier_attribute28 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
663: --

Line 660: ,p_qualifier_attribute29 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: --
664: l_rec hxc_ulq_shd.g_rec_type;

Line 661: ,p_qualifier_attribute30 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;
665: l_proc varchar2(72) ;