130: hr_utility.set_location(' Leaving:'||l_proc, 10);
131: end if;
132: --
133: Exception
134: When hr_api.check_integrity_violated Then
135: -- A check constraint has been violated
136: --
137: hxc_hph_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.check_integrity_violated Then
135: -- A check constraint has been violated
136: --
137: hxc_hph_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.parent_integrity_violated Then
140: -- Parent integrity has been violated
141: --
142: hxc_hph_shd.constraint_error
135: -- A check constraint has been violated
136: --
137: hxc_hph_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.parent_integrity_violated Then
140: -- Parent integrity has been violated
141: --
142: hxc_hph_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.parent_integrity_violated Then
140: -- Parent integrity has been violated
141: --
142: hxc_hph_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.unique_integrity_violated Then
145: -- Unique integrity has been violated
146: --
147: hxc_hph_shd.constraint_error
140: -- Parent integrity has been violated
141: --
142: hxc_hph_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.unique_integrity_violated Then
145: -- Unique integrity has been violated
146: --
147: hxc_hph_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.unique_integrity_violated Then
145: -- Unique integrity has been violated
146: --
147: hxc_hph_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When Others Then
150: --
151: Raise;
152: End update_dml;
467: );
468: --
469: exception
470: --
471: when hr_api.cannot_find_prog_unit then
472: --
473: hr_api.cannot_find_prog_unit_error
474: (p_module_name => 'HXC_PREF_HIERARCHIES'
475: ,p_hook_type => 'AU');
469: exception
470: --
471: when hr_api.cannot_find_prog_unit then
472: --
473: hr_api.cannot_find_prog_unit_error
474: (p_module_name => 'HXC_PREF_HIERARCHIES'
475: ,p_hook_type => 'AU');
476: --
477: end;
534: -- p_rec plsql record structure
535: -- to see if a system default is being used. If a system default
536: -- is being used then we must set to the 'current' argument value.
537: --
538: If (p_rec.type = hr_api.g_varchar2) then
539: p_rec.type :=
540: hxc_hph_shd.g_old_rec.type;
541: End If;
542: If (p_rec.name = hr_api.g_varchar2) then
538: If (p_rec.type = hr_api.g_varchar2) then
539: p_rec.type :=
540: hxc_hph_shd.g_old_rec.type;
541: End If;
542: If (p_rec.name = hr_api.g_varchar2) then
543: p_rec.name :=
544: hxc_hph_shd.g_old_rec.name;
545: End If;
546: If (p_rec.business_group_id = hr_api.g_number) then
542: If (p_rec.name = hr_api.g_varchar2) then
543: p_rec.name :=
544: hxc_hph_shd.g_old_rec.name;
545: End If;
546: If (p_rec.business_group_id = hr_api.g_number) then
547: p_rec.business_group_id :=
548: hxc_ter_shd.g_old_rec.business_group_id;
549: End If;
550: If (p_rec.legislation_code = hr_api.g_varchar2) then
546: If (p_rec.business_group_id = hr_api.g_number) then
547: p_rec.business_group_id :=
548: hxc_ter_shd.g_old_rec.business_group_id;
549: End If;
550: If (p_rec.legislation_code = hr_api.g_varchar2) then
551: p_rec.legislation_code :=
552: hxc_ter_shd.g_old_rec.legislation_code;
553: End If;
554: If (p_rec.parent_pref_hierarchy_id = hr_api.g_number) then
550: If (p_rec.legislation_code = hr_api.g_varchar2) then
551: p_rec.legislation_code :=
552: hxc_ter_shd.g_old_rec.legislation_code;
553: End If;
554: If (p_rec.parent_pref_hierarchy_id = hr_api.g_number) then
555: p_rec.parent_pref_hierarchy_id :=
556: hxc_hph_shd.g_old_rec.parent_pref_hierarchy_id;
557: End If;
558: If (p_rec.edit_allowed = hr_api.g_varchar2) then
554: If (p_rec.parent_pref_hierarchy_id = hr_api.g_number) then
555: p_rec.parent_pref_hierarchy_id :=
556: hxc_hph_shd.g_old_rec.parent_pref_hierarchy_id;
557: End If;
558: If (p_rec.edit_allowed = hr_api.g_varchar2) then
559: p_rec.edit_allowed :=
560: hxc_hph_shd.g_old_rec.edit_allowed;
561: End If;
562: If (p_rec.displayed = hr_api.g_varchar2) then
558: If (p_rec.edit_allowed = hr_api.g_varchar2) then
559: p_rec.edit_allowed :=
560: hxc_hph_shd.g_old_rec.edit_allowed;
561: End If;
562: If (p_rec.displayed = hr_api.g_varchar2) then
563: p_rec.displayed :=
564: hxc_hph_shd.g_old_rec.displayed;
565: End If;
566: If (p_rec.pref_definition_id = hr_api.g_number) then
562: If (p_rec.displayed = hr_api.g_varchar2) then
563: p_rec.displayed :=
564: hxc_hph_shd.g_old_rec.displayed;
565: End If;
566: If (p_rec.pref_definition_id = hr_api.g_number) then
567: p_rec.pref_definition_id :=
568: hxc_hph_shd.g_old_rec.pref_definition_id;
569: End If;
570: If (p_rec.attribute_category = hr_api.g_varchar2) then
566: If (p_rec.pref_definition_id = hr_api.g_number) then
567: p_rec.pref_definition_id :=
568: hxc_hph_shd.g_old_rec.pref_definition_id;
569: End If;
570: If (p_rec.attribute_category = hr_api.g_varchar2) then
571: p_rec.attribute_category :=
572: hxc_hph_shd.g_old_rec.attribute_category;
573: End If;
574: If (p_rec.attribute1 = hr_api.g_varchar2) then
570: If (p_rec.attribute_category = hr_api.g_varchar2) then
571: p_rec.attribute_category :=
572: hxc_hph_shd.g_old_rec.attribute_category;
573: End If;
574: If (p_rec.attribute1 = hr_api.g_varchar2) then
575: p_rec.attribute1 :=
576: hxc_hph_shd.g_old_rec.attribute1;
577: End If;
578: If (p_rec.attribute2 = hr_api.g_varchar2) then
574: If (p_rec.attribute1 = hr_api.g_varchar2) then
575: p_rec.attribute1 :=
576: hxc_hph_shd.g_old_rec.attribute1;
577: End If;
578: If (p_rec.attribute2 = hr_api.g_varchar2) then
579: p_rec.attribute2 :=
580: hxc_hph_shd.g_old_rec.attribute2;
581: End If;
582: If (p_rec.attribute3 = hr_api.g_varchar2) then
578: If (p_rec.attribute2 = hr_api.g_varchar2) then
579: p_rec.attribute2 :=
580: hxc_hph_shd.g_old_rec.attribute2;
581: End If;
582: If (p_rec.attribute3 = hr_api.g_varchar2) then
583: p_rec.attribute3 :=
584: hxc_hph_shd.g_old_rec.attribute3;
585: End If;
586: If (p_rec.attribute4 = hr_api.g_varchar2) then
582: If (p_rec.attribute3 = hr_api.g_varchar2) then
583: p_rec.attribute3 :=
584: hxc_hph_shd.g_old_rec.attribute3;
585: End If;
586: If (p_rec.attribute4 = hr_api.g_varchar2) then
587: p_rec.attribute4 :=
588: hxc_hph_shd.g_old_rec.attribute4;
589: End If;
590: If (p_rec.attribute5 = hr_api.g_varchar2) then
586: If (p_rec.attribute4 = hr_api.g_varchar2) then
587: p_rec.attribute4 :=
588: hxc_hph_shd.g_old_rec.attribute4;
589: End If;
590: If (p_rec.attribute5 = hr_api.g_varchar2) then
591: p_rec.attribute5 :=
592: hxc_hph_shd.g_old_rec.attribute5;
593: End If;
594: If (p_rec.attribute6 = hr_api.g_varchar2) then
590: If (p_rec.attribute5 = hr_api.g_varchar2) then
591: p_rec.attribute5 :=
592: hxc_hph_shd.g_old_rec.attribute5;
593: End If;
594: If (p_rec.attribute6 = hr_api.g_varchar2) then
595: p_rec.attribute6 :=
596: hxc_hph_shd.g_old_rec.attribute6;
597: End If;
598: If (p_rec.attribute7 = hr_api.g_varchar2) then
594: If (p_rec.attribute6 = hr_api.g_varchar2) then
595: p_rec.attribute6 :=
596: hxc_hph_shd.g_old_rec.attribute6;
597: End If;
598: If (p_rec.attribute7 = hr_api.g_varchar2) then
599: p_rec.attribute7 :=
600: hxc_hph_shd.g_old_rec.attribute7;
601: End If;
602: If (p_rec.attribute8 = hr_api.g_varchar2) then
598: If (p_rec.attribute7 = hr_api.g_varchar2) then
599: p_rec.attribute7 :=
600: hxc_hph_shd.g_old_rec.attribute7;
601: End If;
602: If (p_rec.attribute8 = hr_api.g_varchar2) then
603: p_rec.attribute8 :=
604: hxc_hph_shd.g_old_rec.attribute8;
605: End If;
606: If (p_rec.attribute9 = hr_api.g_varchar2) then
602: If (p_rec.attribute8 = hr_api.g_varchar2) then
603: p_rec.attribute8 :=
604: hxc_hph_shd.g_old_rec.attribute8;
605: End If;
606: If (p_rec.attribute9 = hr_api.g_varchar2) then
607: p_rec.attribute9 :=
608: hxc_hph_shd.g_old_rec.attribute9;
609: End If;
610: If (p_rec.attribute10 = hr_api.g_varchar2) then
606: If (p_rec.attribute9 = hr_api.g_varchar2) then
607: p_rec.attribute9 :=
608: hxc_hph_shd.g_old_rec.attribute9;
609: End If;
610: If (p_rec.attribute10 = hr_api.g_varchar2) then
611: p_rec.attribute10 :=
612: hxc_hph_shd.g_old_rec.attribute10;
613: End If;
614: If (p_rec.attribute11 = hr_api.g_varchar2) then
610: If (p_rec.attribute10 = hr_api.g_varchar2) then
611: p_rec.attribute10 :=
612: hxc_hph_shd.g_old_rec.attribute10;
613: End If;
614: If (p_rec.attribute11 = hr_api.g_varchar2) then
615: p_rec.attribute11 :=
616: hxc_hph_shd.g_old_rec.attribute11;
617: End If;
618: If (p_rec.attribute12 = hr_api.g_varchar2) then
614: If (p_rec.attribute11 = hr_api.g_varchar2) then
615: p_rec.attribute11 :=
616: hxc_hph_shd.g_old_rec.attribute11;
617: End If;
618: If (p_rec.attribute12 = hr_api.g_varchar2) then
619: p_rec.attribute12 :=
620: hxc_hph_shd.g_old_rec.attribute12;
621: End If;
622: If (p_rec.attribute13 = hr_api.g_varchar2) then
618: If (p_rec.attribute12 = hr_api.g_varchar2) then
619: p_rec.attribute12 :=
620: hxc_hph_shd.g_old_rec.attribute12;
621: End If;
622: If (p_rec.attribute13 = hr_api.g_varchar2) then
623: p_rec.attribute13 :=
624: hxc_hph_shd.g_old_rec.attribute13;
625: End If;
626: If (p_rec.attribute14 = hr_api.g_varchar2) then
622: If (p_rec.attribute13 = hr_api.g_varchar2) then
623: p_rec.attribute13 :=
624: hxc_hph_shd.g_old_rec.attribute13;
625: End If;
626: If (p_rec.attribute14 = hr_api.g_varchar2) then
627: p_rec.attribute14 :=
628: hxc_hph_shd.g_old_rec.attribute14;
629: End If;
630: If (p_rec.attribute15 = hr_api.g_varchar2) then
626: If (p_rec.attribute14 = hr_api.g_varchar2) then
627: p_rec.attribute14 :=
628: hxc_hph_shd.g_old_rec.attribute14;
629: End If;
630: If (p_rec.attribute15 = hr_api.g_varchar2) then
631: p_rec.attribute15 :=
632: hxc_hph_shd.g_old_rec.attribute15;
633: End If;
634: If (p_rec.attribute16 = hr_api.g_varchar2) then
630: If (p_rec.attribute15 = hr_api.g_varchar2) then
631: p_rec.attribute15 :=
632: hxc_hph_shd.g_old_rec.attribute15;
633: End If;
634: If (p_rec.attribute16 = hr_api.g_varchar2) then
635: p_rec.attribute16 :=
636: hxc_hph_shd.g_old_rec.attribute16;
637: End If;
638: If (p_rec.attribute17 = hr_api.g_varchar2) then
634: If (p_rec.attribute16 = hr_api.g_varchar2) then
635: p_rec.attribute16 :=
636: hxc_hph_shd.g_old_rec.attribute16;
637: End If;
638: If (p_rec.attribute17 = hr_api.g_varchar2) then
639: p_rec.attribute17 :=
640: hxc_hph_shd.g_old_rec.attribute17;
641: End If;
642: If (p_rec.attribute18 = hr_api.g_varchar2) then
638: If (p_rec.attribute17 = hr_api.g_varchar2) then
639: p_rec.attribute17 :=
640: hxc_hph_shd.g_old_rec.attribute17;
641: End If;
642: If (p_rec.attribute18 = hr_api.g_varchar2) then
643: p_rec.attribute18 :=
644: hxc_hph_shd.g_old_rec.attribute18;
645: End If;
646: If (p_rec.attribute19 = hr_api.g_varchar2) then
642: If (p_rec.attribute18 = hr_api.g_varchar2) then
643: p_rec.attribute18 :=
644: hxc_hph_shd.g_old_rec.attribute18;
645: End If;
646: If (p_rec.attribute19 = hr_api.g_varchar2) then
647: p_rec.attribute19 :=
648: hxc_hph_shd.g_old_rec.attribute19;
649: End If;
650: If (p_rec.attribute20 = hr_api.g_varchar2) then
646: If (p_rec.attribute19 = hr_api.g_varchar2) then
647: p_rec.attribute19 :=
648: hxc_hph_shd.g_old_rec.attribute19;
649: End If;
650: If (p_rec.attribute20 = hr_api.g_varchar2) then
651: p_rec.attribute20 :=
652: hxc_hph_shd.g_old_rec.attribute20;
653: End If;
654: If (p_rec.attribute21 = hr_api.g_varchar2) then
650: If (p_rec.attribute20 = hr_api.g_varchar2) then
651: p_rec.attribute20 :=
652: hxc_hph_shd.g_old_rec.attribute20;
653: End If;
654: If (p_rec.attribute21 = hr_api.g_varchar2) then
655: p_rec.attribute21 :=
656: hxc_hph_shd.g_old_rec.attribute21;
657: End If;
658: If (p_rec.attribute22 = hr_api.g_varchar2) then
654: If (p_rec.attribute21 = hr_api.g_varchar2) then
655: p_rec.attribute21 :=
656: hxc_hph_shd.g_old_rec.attribute21;
657: End If;
658: If (p_rec.attribute22 = hr_api.g_varchar2) then
659: p_rec.attribute22 :=
660: hxc_hph_shd.g_old_rec.attribute22;
661: End If;
662: If (p_rec.attribute23 = hr_api.g_varchar2) then
658: If (p_rec.attribute22 = hr_api.g_varchar2) then
659: p_rec.attribute22 :=
660: hxc_hph_shd.g_old_rec.attribute22;
661: End If;
662: If (p_rec.attribute23 = hr_api.g_varchar2) then
663: p_rec.attribute23 :=
664: hxc_hph_shd.g_old_rec.attribute23;
665: End If;
666: If (p_rec.attribute24 = hr_api.g_varchar2) then
662: If (p_rec.attribute23 = hr_api.g_varchar2) then
663: p_rec.attribute23 :=
664: hxc_hph_shd.g_old_rec.attribute23;
665: End If;
666: If (p_rec.attribute24 = hr_api.g_varchar2) then
667: p_rec.attribute24 :=
668: hxc_hph_shd.g_old_rec.attribute24;
669: End If;
670: If (p_rec.attribute25 = hr_api.g_varchar2) then
666: If (p_rec.attribute24 = hr_api.g_varchar2) then
667: p_rec.attribute24 :=
668: hxc_hph_shd.g_old_rec.attribute24;
669: End If;
670: If (p_rec.attribute25 = hr_api.g_varchar2) then
671: p_rec.attribute25 :=
672: hxc_hph_shd.g_old_rec.attribute25;
673: End If;
674: If (p_rec.attribute26 = hr_api.g_varchar2) then
670: If (p_rec.attribute25 = hr_api.g_varchar2) then
671: p_rec.attribute25 :=
672: hxc_hph_shd.g_old_rec.attribute25;
673: End If;
674: If (p_rec.attribute26 = hr_api.g_varchar2) then
675: p_rec.attribute26 :=
676: hxc_hph_shd.g_old_rec.attribute26;
677: End If;
678: If (p_rec.attribute27 = hr_api.g_varchar2) then
674: If (p_rec.attribute26 = hr_api.g_varchar2) then
675: p_rec.attribute26 :=
676: hxc_hph_shd.g_old_rec.attribute26;
677: End If;
678: If (p_rec.attribute27 = hr_api.g_varchar2) then
679: p_rec.attribute27 :=
680: hxc_hph_shd.g_old_rec.attribute27;
681: End If;
682: If (p_rec.attribute28 = hr_api.g_varchar2) then
678: If (p_rec.attribute27 = hr_api.g_varchar2) then
679: p_rec.attribute27 :=
680: hxc_hph_shd.g_old_rec.attribute27;
681: End If;
682: If (p_rec.attribute28 = hr_api.g_varchar2) then
683: p_rec.attribute28 :=
684: hxc_hph_shd.g_old_rec.attribute28;
685: End If;
686: If (p_rec.attribute29 = hr_api.g_varchar2) then
682: If (p_rec.attribute28 = hr_api.g_varchar2) then
683: p_rec.attribute28 :=
684: hxc_hph_shd.g_old_rec.attribute28;
685: End If;
686: If (p_rec.attribute29 = hr_api.g_varchar2) then
687: p_rec.attribute29 :=
688: hxc_hph_shd.g_old_rec.attribute29;
689: End If;
690: If (p_rec.attribute30 = hr_api.g_varchar2) then
686: If (p_rec.attribute29 = hr_api.g_varchar2) then
687: p_rec.attribute29 :=
688: hxc_hph_shd.g_old_rec.attribute29;
689: End If;
690: If (p_rec.attribute30 = hr_api.g_varchar2) then
691: p_rec.attribute30 :=
692: hxc_hph_shd.g_old_rec.attribute30;
693: End If;
694: If (p_rec.orig_pref_hierarchy_id = hr_api.g_number) then
690: If (p_rec.attribute30 = hr_api.g_varchar2) then
691: p_rec.attribute30 :=
692: hxc_hph_shd.g_old_rec.attribute30;
693: End If;
694: If (p_rec.orig_pref_hierarchy_id = hr_api.g_number) then
695: p_rec.orig_pref_hierarchy_id :=
696: hxc_hph_shd.g_old_rec.orig_pref_hierarchy_id;
697: End If;
698: If (p_rec.orig_parent_hierarchy_id = hr_api.g_number) then
694: If (p_rec.orig_pref_hierarchy_id = hr_api.g_number) then
695: p_rec.orig_pref_hierarchy_id :=
696: hxc_hph_shd.g_old_rec.orig_pref_hierarchy_id;
697: End If;
698: If (p_rec.orig_parent_hierarchy_id = hr_api.g_number) then
699: p_rec.orig_parent_hierarchy_id :=
700: hxc_hph_shd.g_old_rec.orig_parent_hierarchy_id;
701: End If;
702: If (p_rec.top_level_parent_id = hr_api.g_number) then -- Performance Fix
698: If (p_rec.orig_parent_hierarchy_id = hr_api.g_number) then
699: p_rec.orig_parent_hierarchy_id :=
700: hxc_hph_shd.g_old_rec.orig_parent_hierarchy_id;
701: End If;
702: If (p_rec.top_level_parent_id = hr_api.g_number) then -- Performance Fix
703: p_rec.top_level_parent_id :=
704: hxc_hph_shd.g_old_rec.top_level_parent_id;
705: End If;
706: If (p_rec.code = hr_api.g_varchar2) then
702: If (p_rec.top_level_parent_id = hr_api.g_number) then -- Performance Fix
703: p_rec.top_level_parent_id :=
704: hxc_hph_shd.g_old_rec.top_level_parent_id;
705: End If;
706: If (p_rec.code = hr_api.g_varchar2) then
707: p_rec.code :=
708: hxc_hph_shd.g_old_rec.code;
709: End If;
710: --
768: Procedure upd
769: (p_effective_date in date
770: ,p_pref_hierarchy_id in number
771: ,p_object_version_number in out nocopy number
772: ,p_name in varchar2 default hr_api.g_varchar2
773: ,p_business_group_id in number default hr_api.g_number
774: ,p_legislation_code in varchar2 default hr_api.g_varchar2
775: ,p_edit_allowed in varchar2 default hr_api.g_varchar2
776: ,p_displayed in varchar2 default hr_api.g_varchar2
769: (p_effective_date in date
770: ,p_pref_hierarchy_id in number
771: ,p_object_version_number in out nocopy number
772: ,p_name in varchar2 default hr_api.g_varchar2
773: ,p_business_group_id in number default hr_api.g_number
774: ,p_legislation_code in varchar2 default hr_api.g_varchar2
775: ,p_edit_allowed in varchar2 default hr_api.g_varchar2
776: ,p_displayed in varchar2 default hr_api.g_varchar2
777: ,p_type in varchar2 default hr_api.g_varchar2
770: ,p_pref_hierarchy_id in number
771: ,p_object_version_number in out nocopy number
772: ,p_name in varchar2 default hr_api.g_varchar2
773: ,p_business_group_id in number default hr_api.g_number
774: ,p_legislation_code in varchar2 default hr_api.g_varchar2
775: ,p_edit_allowed in varchar2 default hr_api.g_varchar2
776: ,p_displayed in varchar2 default hr_api.g_varchar2
777: ,p_type in varchar2 default hr_api.g_varchar2
778: ,p_parent_pref_hierarchy_id in number default hr_api.g_number
771: ,p_object_version_number in out nocopy number
772: ,p_name in varchar2 default hr_api.g_varchar2
773: ,p_business_group_id in number default hr_api.g_number
774: ,p_legislation_code in varchar2 default hr_api.g_varchar2
775: ,p_edit_allowed in varchar2 default hr_api.g_varchar2
776: ,p_displayed in varchar2 default hr_api.g_varchar2
777: ,p_type in varchar2 default hr_api.g_varchar2
778: ,p_parent_pref_hierarchy_id in number default hr_api.g_number
779: ,p_pref_definition_id in number default hr_api.g_number
772: ,p_name in varchar2 default hr_api.g_varchar2
773: ,p_business_group_id in number default hr_api.g_number
774: ,p_legislation_code in varchar2 default hr_api.g_varchar2
775: ,p_edit_allowed in varchar2 default hr_api.g_varchar2
776: ,p_displayed in varchar2 default hr_api.g_varchar2
777: ,p_type in varchar2 default hr_api.g_varchar2
778: ,p_parent_pref_hierarchy_id in number default hr_api.g_number
779: ,p_pref_definition_id in number default hr_api.g_number
780: ,p_attribute_category in varchar2 default hr_api.g_varchar2
773: ,p_business_group_id in number default hr_api.g_number
774: ,p_legislation_code in varchar2 default hr_api.g_varchar2
775: ,p_edit_allowed in varchar2 default hr_api.g_varchar2
776: ,p_displayed in varchar2 default hr_api.g_varchar2
777: ,p_type in varchar2 default hr_api.g_varchar2
778: ,p_parent_pref_hierarchy_id in number default hr_api.g_number
779: ,p_pref_definition_id in number default hr_api.g_number
780: ,p_attribute_category in varchar2 default hr_api.g_varchar2
781: ,p_attribute1 in varchar2 default hr_api.g_varchar2
774: ,p_legislation_code in varchar2 default hr_api.g_varchar2
775: ,p_edit_allowed in varchar2 default hr_api.g_varchar2
776: ,p_displayed in varchar2 default hr_api.g_varchar2
777: ,p_type in varchar2 default hr_api.g_varchar2
778: ,p_parent_pref_hierarchy_id in number default hr_api.g_number
779: ,p_pref_definition_id in number default hr_api.g_number
780: ,p_attribute_category in varchar2 default hr_api.g_varchar2
781: ,p_attribute1 in varchar2 default hr_api.g_varchar2
782: ,p_attribute2 in varchar2 default hr_api.g_varchar2
775: ,p_edit_allowed in varchar2 default hr_api.g_varchar2
776: ,p_displayed in varchar2 default hr_api.g_varchar2
777: ,p_type in varchar2 default hr_api.g_varchar2
778: ,p_parent_pref_hierarchy_id in number default hr_api.g_number
779: ,p_pref_definition_id in number default hr_api.g_number
780: ,p_attribute_category in varchar2 default hr_api.g_varchar2
781: ,p_attribute1 in varchar2 default hr_api.g_varchar2
782: ,p_attribute2 in varchar2 default hr_api.g_varchar2
783: ,p_attribute3 in varchar2 default hr_api.g_varchar2
776: ,p_displayed in varchar2 default hr_api.g_varchar2
777: ,p_type in varchar2 default hr_api.g_varchar2
778: ,p_parent_pref_hierarchy_id in number default hr_api.g_number
779: ,p_pref_definition_id in number default hr_api.g_number
780: ,p_attribute_category in varchar2 default hr_api.g_varchar2
781: ,p_attribute1 in varchar2 default hr_api.g_varchar2
782: ,p_attribute2 in varchar2 default hr_api.g_varchar2
783: ,p_attribute3 in varchar2 default hr_api.g_varchar2
784: ,p_attribute4 in varchar2 default hr_api.g_varchar2
777: ,p_type in varchar2 default hr_api.g_varchar2
778: ,p_parent_pref_hierarchy_id in number default hr_api.g_number
779: ,p_pref_definition_id in number default hr_api.g_number
780: ,p_attribute_category in varchar2 default hr_api.g_varchar2
781: ,p_attribute1 in varchar2 default hr_api.g_varchar2
782: ,p_attribute2 in varchar2 default hr_api.g_varchar2
783: ,p_attribute3 in varchar2 default hr_api.g_varchar2
784: ,p_attribute4 in varchar2 default hr_api.g_varchar2
785: ,p_attribute5 in varchar2 default hr_api.g_varchar2
778: ,p_parent_pref_hierarchy_id in number default hr_api.g_number
779: ,p_pref_definition_id in number default hr_api.g_number
780: ,p_attribute_category in varchar2 default hr_api.g_varchar2
781: ,p_attribute1 in varchar2 default hr_api.g_varchar2
782: ,p_attribute2 in varchar2 default hr_api.g_varchar2
783: ,p_attribute3 in varchar2 default hr_api.g_varchar2
784: ,p_attribute4 in varchar2 default hr_api.g_varchar2
785: ,p_attribute5 in varchar2 default hr_api.g_varchar2
786: ,p_attribute6 in varchar2 default hr_api.g_varchar2
779: ,p_pref_definition_id in number default hr_api.g_number
780: ,p_attribute_category in varchar2 default hr_api.g_varchar2
781: ,p_attribute1 in varchar2 default hr_api.g_varchar2
782: ,p_attribute2 in varchar2 default hr_api.g_varchar2
783: ,p_attribute3 in varchar2 default hr_api.g_varchar2
784: ,p_attribute4 in varchar2 default hr_api.g_varchar2
785: ,p_attribute5 in varchar2 default hr_api.g_varchar2
786: ,p_attribute6 in varchar2 default hr_api.g_varchar2
787: ,p_attribute7 in varchar2 default hr_api.g_varchar2
780: ,p_attribute_category in varchar2 default hr_api.g_varchar2
781: ,p_attribute1 in varchar2 default hr_api.g_varchar2
782: ,p_attribute2 in varchar2 default hr_api.g_varchar2
783: ,p_attribute3 in varchar2 default hr_api.g_varchar2
784: ,p_attribute4 in varchar2 default hr_api.g_varchar2
785: ,p_attribute5 in varchar2 default hr_api.g_varchar2
786: ,p_attribute6 in varchar2 default hr_api.g_varchar2
787: ,p_attribute7 in varchar2 default hr_api.g_varchar2
788: ,p_attribute8 in varchar2 default hr_api.g_varchar2
781: ,p_attribute1 in varchar2 default hr_api.g_varchar2
782: ,p_attribute2 in varchar2 default hr_api.g_varchar2
783: ,p_attribute3 in varchar2 default hr_api.g_varchar2
784: ,p_attribute4 in varchar2 default hr_api.g_varchar2
785: ,p_attribute5 in varchar2 default hr_api.g_varchar2
786: ,p_attribute6 in varchar2 default hr_api.g_varchar2
787: ,p_attribute7 in varchar2 default hr_api.g_varchar2
788: ,p_attribute8 in varchar2 default hr_api.g_varchar2
789: ,p_attribute9 in varchar2 default hr_api.g_varchar2
782: ,p_attribute2 in varchar2 default hr_api.g_varchar2
783: ,p_attribute3 in varchar2 default hr_api.g_varchar2
784: ,p_attribute4 in varchar2 default hr_api.g_varchar2
785: ,p_attribute5 in varchar2 default hr_api.g_varchar2
786: ,p_attribute6 in varchar2 default hr_api.g_varchar2
787: ,p_attribute7 in varchar2 default hr_api.g_varchar2
788: ,p_attribute8 in varchar2 default hr_api.g_varchar2
789: ,p_attribute9 in varchar2 default hr_api.g_varchar2
790: ,p_attribute10 in varchar2 default hr_api.g_varchar2
783: ,p_attribute3 in varchar2 default hr_api.g_varchar2
784: ,p_attribute4 in varchar2 default hr_api.g_varchar2
785: ,p_attribute5 in varchar2 default hr_api.g_varchar2
786: ,p_attribute6 in varchar2 default hr_api.g_varchar2
787: ,p_attribute7 in varchar2 default hr_api.g_varchar2
788: ,p_attribute8 in varchar2 default hr_api.g_varchar2
789: ,p_attribute9 in varchar2 default hr_api.g_varchar2
790: ,p_attribute10 in varchar2 default hr_api.g_varchar2
791: ,p_attribute11 in varchar2 default hr_api.g_varchar2
784: ,p_attribute4 in varchar2 default hr_api.g_varchar2
785: ,p_attribute5 in varchar2 default hr_api.g_varchar2
786: ,p_attribute6 in varchar2 default hr_api.g_varchar2
787: ,p_attribute7 in varchar2 default hr_api.g_varchar2
788: ,p_attribute8 in varchar2 default hr_api.g_varchar2
789: ,p_attribute9 in varchar2 default hr_api.g_varchar2
790: ,p_attribute10 in varchar2 default hr_api.g_varchar2
791: ,p_attribute11 in varchar2 default hr_api.g_varchar2
792: ,p_attribute12 in varchar2 default hr_api.g_varchar2
785: ,p_attribute5 in varchar2 default hr_api.g_varchar2
786: ,p_attribute6 in varchar2 default hr_api.g_varchar2
787: ,p_attribute7 in varchar2 default hr_api.g_varchar2
788: ,p_attribute8 in varchar2 default hr_api.g_varchar2
789: ,p_attribute9 in varchar2 default hr_api.g_varchar2
790: ,p_attribute10 in varchar2 default hr_api.g_varchar2
791: ,p_attribute11 in varchar2 default hr_api.g_varchar2
792: ,p_attribute12 in varchar2 default hr_api.g_varchar2
793: ,p_attribute13 in varchar2 default hr_api.g_varchar2
786: ,p_attribute6 in varchar2 default hr_api.g_varchar2
787: ,p_attribute7 in varchar2 default hr_api.g_varchar2
788: ,p_attribute8 in varchar2 default hr_api.g_varchar2
789: ,p_attribute9 in varchar2 default hr_api.g_varchar2
790: ,p_attribute10 in varchar2 default hr_api.g_varchar2
791: ,p_attribute11 in varchar2 default hr_api.g_varchar2
792: ,p_attribute12 in varchar2 default hr_api.g_varchar2
793: ,p_attribute13 in varchar2 default hr_api.g_varchar2
794: ,p_attribute14 in varchar2 default hr_api.g_varchar2
787: ,p_attribute7 in varchar2 default hr_api.g_varchar2
788: ,p_attribute8 in varchar2 default hr_api.g_varchar2
789: ,p_attribute9 in varchar2 default hr_api.g_varchar2
790: ,p_attribute10 in varchar2 default hr_api.g_varchar2
791: ,p_attribute11 in varchar2 default hr_api.g_varchar2
792: ,p_attribute12 in varchar2 default hr_api.g_varchar2
793: ,p_attribute13 in varchar2 default hr_api.g_varchar2
794: ,p_attribute14 in varchar2 default hr_api.g_varchar2
795: ,p_attribute15 in varchar2 default hr_api.g_varchar2
788: ,p_attribute8 in varchar2 default hr_api.g_varchar2
789: ,p_attribute9 in varchar2 default hr_api.g_varchar2
790: ,p_attribute10 in varchar2 default hr_api.g_varchar2
791: ,p_attribute11 in varchar2 default hr_api.g_varchar2
792: ,p_attribute12 in varchar2 default hr_api.g_varchar2
793: ,p_attribute13 in varchar2 default hr_api.g_varchar2
794: ,p_attribute14 in varchar2 default hr_api.g_varchar2
795: ,p_attribute15 in varchar2 default hr_api.g_varchar2
796: ,p_attribute16 in varchar2 default hr_api.g_varchar2
789: ,p_attribute9 in varchar2 default hr_api.g_varchar2
790: ,p_attribute10 in varchar2 default hr_api.g_varchar2
791: ,p_attribute11 in varchar2 default hr_api.g_varchar2
792: ,p_attribute12 in varchar2 default hr_api.g_varchar2
793: ,p_attribute13 in varchar2 default hr_api.g_varchar2
794: ,p_attribute14 in varchar2 default hr_api.g_varchar2
795: ,p_attribute15 in varchar2 default hr_api.g_varchar2
796: ,p_attribute16 in varchar2 default hr_api.g_varchar2
797: ,p_attribute17 in varchar2 default hr_api.g_varchar2
790: ,p_attribute10 in varchar2 default hr_api.g_varchar2
791: ,p_attribute11 in varchar2 default hr_api.g_varchar2
792: ,p_attribute12 in varchar2 default hr_api.g_varchar2
793: ,p_attribute13 in varchar2 default hr_api.g_varchar2
794: ,p_attribute14 in varchar2 default hr_api.g_varchar2
795: ,p_attribute15 in varchar2 default hr_api.g_varchar2
796: ,p_attribute16 in varchar2 default hr_api.g_varchar2
797: ,p_attribute17 in varchar2 default hr_api.g_varchar2
798: ,p_attribute18 in varchar2 default hr_api.g_varchar2
791: ,p_attribute11 in varchar2 default hr_api.g_varchar2
792: ,p_attribute12 in varchar2 default hr_api.g_varchar2
793: ,p_attribute13 in varchar2 default hr_api.g_varchar2
794: ,p_attribute14 in varchar2 default hr_api.g_varchar2
795: ,p_attribute15 in varchar2 default hr_api.g_varchar2
796: ,p_attribute16 in varchar2 default hr_api.g_varchar2
797: ,p_attribute17 in varchar2 default hr_api.g_varchar2
798: ,p_attribute18 in varchar2 default hr_api.g_varchar2
799: ,p_attribute19 in varchar2 default hr_api.g_varchar2
792: ,p_attribute12 in varchar2 default hr_api.g_varchar2
793: ,p_attribute13 in varchar2 default hr_api.g_varchar2
794: ,p_attribute14 in varchar2 default hr_api.g_varchar2
795: ,p_attribute15 in varchar2 default hr_api.g_varchar2
796: ,p_attribute16 in varchar2 default hr_api.g_varchar2
797: ,p_attribute17 in varchar2 default hr_api.g_varchar2
798: ,p_attribute18 in varchar2 default hr_api.g_varchar2
799: ,p_attribute19 in varchar2 default hr_api.g_varchar2
800: ,p_attribute20 in varchar2 default hr_api.g_varchar2
793: ,p_attribute13 in varchar2 default hr_api.g_varchar2
794: ,p_attribute14 in varchar2 default hr_api.g_varchar2
795: ,p_attribute15 in varchar2 default hr_api.g_varchar2
796: ,p_attribute16 in varchar2 default hr_api.g_varchar2
797: ,p_attribute17 in varchar2 default hr_api.g_varchar2
798: ,p_attribute18 in varchar2 default hr_api.g_varchar2
799: ,p_attribute19 in varchar2 default hr_api.g_varchar2
800: ,p_attribute20 in varchar2 default hr_api.g_varchar2
801: ,p_attribute21 in varchar2 default hr_api.g_varchar2
794: ,p_attribute14 in varchar2 default hr_api.g_varchar2
795: ,p_attribute15 in varchar2 default hr_api.g_varchar2
796: ,p_attribute16 in varchar2 default hr_api.g_varchar2
797: ,p_attribute17 in varchar2 default hr_api.g_varchar2
798: ,p_attribute18 in varchar2 default hr_api.g_varchar2
799: ,p_attribute19 in varchar2 default hr_api.g_varchar2
800: ,p_attribute20 in varchar2 default hr_api.g_varchar2
801: ,p_attribute21 in varchar2 default hr_api.g_varchar2
802: ,p_attribute22 in varchar2 default hr_api.g_varchar2
795: ,p_attribute15 in varchar2 default hr_api.g_varchar2
796: ,p_attribute16 in varchar2 default hr_api.g_varchar2
797: ,p_attribute17 in varchar2 default hr_api.g_varchar2
798: ,p_attribute18 in varchar2 default hr_api.g_varchar2
799: ,p_attribute19 in varchar2 default hr_api.g_varchar2
800: ,p_attribute20 in varchar2 default hr_api.g_varchar2
801: ,p_attribute21 in varchar2 default hr_api.g_varchar2
802: ,p_attribute22 in varchar2 default hr_api.g_varchar2
803: ,p_attribute23 in varchar2 default hr_api.g_varchar2
796: ,p_attribute16 in varchar2 default hr_api.g_varchar2
797: ,p_attribute17 in varchar2 default hr_api.g_varchar2
798: ,p_attribute18 in varchar2 default hr_api.g_varchar2
799: ,p_attribute19 in varchar2 default hr_api.g_varchar2
800: ,p_attribute20 in varchar2 default hr_api.g_varchar2
801: ,p_attribute21 in varchar2 default hr_api.g_varchar2
802: ,p_attribute22 in varchar2 default hr_api.g_varchar2
803: ,p_attribute23 in varchar2 default hr_api.g_varchar2
804: ,p_attribute24 in varchar2 default hr_api.g_varchar2
797: ,p_attribute17 in varchar2 default hr_api.g_varchar2
798: ,p_attribute18 in varchar2 default hr_api.g_varchar2
799: ,p_attribute19 in varchar2 default hr_api.g_varchar2
800: ,p_attribute20 in varchar2 default hr_api.g_varchar2
801: ,p_attribute21 in varchar2 default hr_api.g_varchar2
802: ,p_attribute22 in varchar2 default hr_api.g_varchar2
803: ,p_attribute23 in varchar2 default hr_api.g_varchar2
804: ,p_attribute24 in varchar2 default hr_api.g_varchar2
805: ,p_attribute25 in varchar2 default hr_api.g_varchar2
798: ,p_attribute18 in varchar2 default hr_api.g_varchar2
799: ,p_attribute19 in varchar2 default hr_api.g_varchar2
800: ,p_attribute20 in varchar2 default hr_api.g_varchar2
801: ,p_attribute21 in varchar2 default hr_api.g_varchar2
802: ,p_attribute22 in varchar2 default hr_api.g_varchar2
803: ,p_attribute23 in varchar2 default hr_api.g_varchar2
804: ,p_attribute24 in varchar2 default hr_api.g_varchar2
805: ,p_attribute25 in varchar2 default hr_api.g_varchar2
806: ,p_attribute26 in varchar2 default hr_api.g_varchar2
799: ,p_attribute19 in varchar2 default hr_api.g_varchar2
800: ,p_attribute20 in varchar2 default hr_api.g_varchar2
801: ,p_attribute21 in varchar2 default hr_api.g_varchar2
802: ,p_attribute22 in varchar2 default hr_api.g_varchar2
803: ,p_attribute23 in varchar2 default hr_api.g_varchar2
804: ,p_attribute24 in varchar2 default hr_api.g_varchar2
805: ,p_attribute25 in varchar2 default hr_api.g_varchar2
806: ,p_attribute26 in varchar2 default hr_api.g_varchar2
807: ,p_attribute27 in varchar2 default hr_api.g_varchar2
800: ,p_attribute20 in varchar2 default hr_api.g_varchar2
801: ,p_attribute21 in varchar2 default hr_api.g_varchar2
802: ,p_attribute22 in varchar2 default hr_api.g_varchar2
803: ,p_attribute23 in varchar2 default hr_api.g_varchar2
804: ,p_attribute24 in varchar2 default hr_api.g_varchar2
805: ,p_attribute25 in varchar2 default hr_api.g_varchar2
806: ,p_attribute26 in varchar2 default hr_api.g_varchar2
807: ,p_attribute27 in varchar2 default hr_api.g_varchar2
808: ,p_attribute28 in varchar2 default hr_api.g_varchar2
801: ,p_attribute21 in varchar2 default hr_api.g_varchar2
802: ,p_attribute22 in varchar2 default hr_api.g_varchar2
803: ,p_attribute23 in varchar2 default hr_api.g_varchar2
804: ,p_attribute24 in varchar2 default hr_api.g_varchar2
805: ,p_attribute25 in varchar2 default hr_api.g_varchar2
806: ,p_attribute26 in varchar2 default hr_api.g_varchar2
807: ,p_attribute27 in varchar2 default hr_api.g_varchar2
808: ,p_attribute28 in varchar2 default hr_api.g_varchar2
809: ,p_attribute29 in varchar2 default hr_api.g_varchar2
802: ,p_attribute22 in varchar2 default hr_api.g_varchar2
803: ,p_attribute23 in varchar2 default hr_api.g_varchar2
804: ,p_attribute24 in varchar2 default hr_api.g_varchar2
805: ,p_attribute25 in varchar2 default hr_api.g_varchar2
806: ,p_attribute26 in varchar2 default hr_api.g_varchar2
807: ,p_attribute27 in varchar2 default hr_api.g_varchar2
808: ,p_attribute28 in varchar2 default hr_api.g_varchar2
809: ,p_attribute29 in varchar2 default hr_api.g_varchar2
810: ,p_attribute30 in varchar2 default hr_api.g_varchar2
803: ,p_attribute23 in varchar2 default hr_api.g_varchar2
804: ,p_attribute24 in varchar2 default hr_api.g_varchar2
805: ,p_attribute25 in varchar2 default hr_api.g_varchar2
806: ,p_attribute26 in varchar2 default hr_api.g_varchar2
807: ,p_attribute27 in varchar2 default hr_api.g_varchar2
808: ,p_attribute28 in varchar2 default hr_api.g_varchar2
809: ,p_attribute29 in varchar2 default hr_api.g_varchar2
810: ,p_attribute30 in varchar2 default hr_api.g_varchar2
811: ,p_orig_pref_hierarchy_id in number default hr_api.g_number
804: ,p_attribute24 in varchar2 default hr_api.g_varchar2
805: ,p_attribute25 in varchar2 default hr_api.g_varchar2
806: ,p_attribute26 in varchar2 default hr_api.g_varchar2
807: ,p_attribute27 in varchar2 default hr_api.g_varchar2
808: ,p_attribute28 in varchar2 default hr_api.g_varchar2
809: ,p_attribute29 in varchar2 default hr_api.g_varchar2
810: ,p_attribute30 in varchar2 default hr_api.g_varchar2
811: ,p_orig_pref_hierarchy_id in number default hr_api.g_number
812: ,p_orig_parent_hierarchy_id in number default hr_api.g_number
805: ,p_attribute25 in varchar2 default hr_api.g_varchar2
806: ,p_attribute26 in varchar2 default hr_api.g_varchar2
807: ,p_attribute27 in varchar2 default hr_api.g_varchar2
808: ,p_attribute28 in varchar2 default hr_api.g_varchar2
809: ,p_attribute29 in varchar2 default hr_api.g_varchar2
810: ,p_attribute30 in varchar2 default hr_api.g_varchar2
811: ,p_orig_pref_hierarchy_id in number default hr_api.g_number
812: ,p_orig_parent_hierarchy_id in number default hr_api.g_number
813: ,p_top_level_parent_id in number default hr_api.g_number --Performance Fix
806: ,p_attribute26 in varchar2 default hr_api.g_varchar2
807: ,p_attribute27 in varchar2 default hr_api.g_varchar2
808: ,p_attribute28 in varchar2 default hr_api.g_varchar2
809: ,p_attribute29 in varchar2 default hr_api.g_varchar2
810: ,p_attribute30 in varchar2 default hr_api.g_varchar2
811: ,p_orig_pref_hierarchy_id in number default hr_api.g_number
812: ,p_orig_parent_hierarchy_id in number default hr_api.g_number
813: ,p_top_level_parent_id in number default hr_api.g_number --Performance Fix
814: ,p_code in varchar2 default hr_api.g_varchar2
807: ,p_attribute27 in varchar2 default hr_api.g_varchar2
808: ,p_attribute28 in varchar2 default hr_api.g_varchar2
809: ,p_attribute29 in varchar2 default hr_api.g_varchar2
810: ,p_attribute30 in varchar2 default hr_api.g_varchar2
811: ,p_orig_pref_hierarchy_id in number default hr_api.g_number
812: ,p_orig_parent_hierarchy_id in number default hr_api.g_number
813: ,p_top_level_parent_id in number default hr_api.g_number --Performance Fix
814: ,p_code in varchar2 default hr_api.g_varchar2
815: ) is
808: ,p_attribute28 in varchar2 default hr_api.g_varchar2
809: ,p_attribute29 in varchar2 default hr_api.g_varchar2
810: ,p_attribute30 in varchar2 default hr_api.g_varchar2
811: ,p_orig_pref_hierarchy_id in number default hr_api.g_number
812: ,p_orig_parent_hierarchy_id in number default hr_api.g_number
813: ,p_top_level_parent_id in number default hr_api.g_number --Performance Fix
814: ,p_code in varchar2 default hr_api.g_varchar2
815: ) is
816: --
809: ,p_attribute29 in varchar2 default hr_api.g_varchar2
810: ,p_attribute30 in varchar2 default hr_api.g_varchar2
811: ,p_orig_pref_hierarchy_id in number default hr_api.g_number
812: ,p_orig_parent_hierarchy_id in number default hr_api.g_number
813: ,p_top_level_parent_id in number default hr_api.g_number --Performance Fix
814: ,p_code in varchar2 default hr_api.g_varchar2
815: ) is
816: --
817: l_rec hxc_hph_shd.g_rec_type;
810: ,p_attribute30 in varchar2 default hr_api.g_varchar2
811: ,p_orig_pref_hierarchy_id in number default hr_api.g_number
812: ,p_orig_parent_hierarchy_id in number default hr_api.g_number
813: ,p_top_level_parent_id in number default hr_api.g_number --Performance Fix
814: ,p_code in varchar2 default hr_api.g_varchar2
815: ) is
816: --
817: l_rec hxc_hph_shd.g_rec_type;
818: l_proc varchar2(72);