APPS.HXC_HPH_UPD dependencies on HR_API

Line 134: When hr_api.check_integrity_violated Then

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

Line 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

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

Line 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

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

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

Line 471: when hr_api.cannot_find_prog_unit then

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

Line 473: hr_api.cannot_find_prog_unit_error

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;

Line 538: If (p_rec.type = hr_api.g_varchar2) then

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

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

Line 772: ,p_name in varchar2 default hr_api.g_varchar2

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

Line 773: ,p_business_group_id in number default hr_api.g_number

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

Line 774: ,p_legislation_code 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

Line 775: ,p_edit_allowed in varchar2 default hr_api.g_varchar2

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

Line 776: ,p_displayed in varchar2 default hr_api.g_varchar2

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

Line 777: ,p_type 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

Line 778: ,p_parent_pref_hierarchy_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
782: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 779: ,p_pref_definition_id in number default hr_api.g_number

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

Line 780: ,p_attribute_category 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

Line 781: ,p_attribute1 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

Line 782: ,p_attribute2 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

Line 783: ,p_attribute3 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

Line 784: ,p_attribute4 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

Line 785: ,p_attribute5 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

Line 786: ,p_attribute6 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

Line 787: ,p_attribute7 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

Line 788: ,p_attribute8 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

Line 789: ,p_attribute9 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

Line 790: ,p_attribute10 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

Line 791: ,p_attribute11 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

Line 792: ,p_attribute12 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

Line 793: ,p_attribute13 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

Line 794: ,p_attribute14 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

Line 795: ,p_attribute15 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

Line 796: ,p_attribute16 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

Line 797: ,p_attribute17 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

Line 798: ,p_attribute18 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

Line 799: ,p_attribute19 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

Line 800: ,p_attribute20 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

Line 801: ,p_attribute21 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

Line 802: ,p_attribute22 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

Line 803: ,p_attribute23 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

Line 804: ,p_attribute24 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

Line 805: ,p_attribute25 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

Line 806: ,p_attribute26 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

Line 807: ,p_attribute27 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

Line 808: ,p_attribute28 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
812: ,p_orig_parent_hierarchy_id in number default hr_api.g_number

Line 809: ,p_attribute29 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
813: ,p_top_level_parent_id in number default hr_api.g_number --Performance Fix

Line 810: ,p_attribute30 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
814: ,p_code in varchar2 default hr_api.g_varchar2

Line 811: ,p_orig_pref_hierarchy_id in number default hr_api.g_number

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

Line 812: ,p_orig_parent_hierarchy_id in number default hr_api.g_number

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

Line 813: ,p_top_level_parent_id in number default hr_api.g_number --Performance Fix

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;

Line 814: ,p_code 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;
818: l_proc varchar2(72);