eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ROL_UPD dependencies on HR_API

Line 134: When hr_api.check_integrity_violated Then

130: --
131: hr_utility.set_location(' Leaving:'||l_proc, 10);
132: --
133: Exception
134: When hr_api.check_integrity_violated Then
135: -- A check constraint has been violated
136: --
137: per_rol_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: per_rol_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: per_rol_shd.constraint_error

Line 139: When hr_api.parent_integrity_violated Then

135: -- A check constraint has been violated
136: --
137: per_rol_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: per_rol_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: per_rol_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: per_rol_shd.constraint_error

Line 144: When hr_api.unique_integrity_violated Then

140: -- Parent integrity has been violated
141: --
142: per_rol_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: per_rol_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: per_rol_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 462: when hr_api.cannot_find_prog_unit then

458: );
459: --
460: exception
461: --
462: when hr_api.cannot_find_prog_unit then
463: --
464: hr_api.cannot_find_prog_unit_error
465: (p_module_name => 'PER_ROLES'
466: ,p_hook_type => 'AU');

Line 464: hr_api.cannot_find_prog_unit_error

460: exception
461: --
462: when hr_api.cannot_find_prog_unit then
463: --
464: hr_api.cannot_find_prog_unit_error
465: (p_module_name => 'PER_ROLES'
466: ,p_hook_type => 'AU');
467: --
468: end;

Line 527: If (p_rec.job_id = hr_api.g_number) then

523: -- p_rec plsql record structure
524: -- to see if a system default is being used. If a system default
525: -- is being used then we must set to the 'current' argument value.
526: --
527: If (p_rec.job_id = hr_api.g_number) then
528: p_rec.job_id :=
529: per_rol_shd.g_old_rec.job_id;
530: End If;
531: If (p_rec.job_group_id = hr_api.g_number) then

Line 531: If (p_rec.job_group_id = hr_api.g_number) then

527: If (p_rec.job_id = hr_api.g_number) then
528: p_rec.job_id :=
529: per_rol_shd.g_old_rec.job_id;
530: End If;
531: If (p_rec.job_group_id = hr_api.g_number) then
532: p_rec.job_group_id :=
533: per_rol_shd.g_old_rec.job_group_id;
534: End If;
535: If (p_rec.person_id = hr_api.g_number) then

Line 535: If (p_rec.person_id = hr_api.g_number) then

531: If (p_rec.job_group_id = hr_api.g_number) then
532: p_rec.job_group_id :=
533: per_rol_shd.g_old_rec.job_group_id;
534: End If;
535: If (p_rec.person_id = hr_api.g_number) then
536: p_rec.person_id :=
537: per_rol_shd.g_old_rec.person_id;
538: End If;
539: If (p_rec.organization_id = hr_api.g_number) then

Line 539: If (p_rec.organization_id = hr_api.g_number) then

535: If (p_rec.person_id = hr_api.g_number) then
536: p_rec.person_id :=
537: per_rol_shd.g_old_rec.person_id;
538: End If;
539: If (p_rec.organization_id = hr_api.g_number) then
540: p_rec.organization_id :=
541: per_rol_shd.g_old_rec.organization_id;
542: End If;
543: If (p_rec.start_date = hr_api.g_date) then

Line 543: If (p_rec.start_date = hr_api.g_date) then

539: If (p_rec.organization_id = hr_api.g_number) then
540: p_rec.organization_id :=
541: per_rol_shd.g_old_rec.organization_id;
542: End If;
543: If (p_rec.start_date = hr_api.g_date) then
544: p_rec.start_date :=
545: per_rol_shd.g_old_rec.start_date;
546: End If;
547: If (p_rec.end_date = hr_api.g_date) then

Line 547: If (p_rec.end_date = hr_api.g_date) then

543: If (p_rec.start_date = hr_api.g_date) then
544: p_rec.start_date :=
545: per_rol_shd.g_old_rec.start_date;
546: End If;
547: If (p_rec.end_date = hr_api.g_date) then
548: p_rec.end_date :=
549: per_rol_shd.g_old_rec.end_date;
550: End If;
551: If (p_rec.confidential_date = hr_api.g_date) then

Line 551: If (p_rec.confidential_date = hr_api.g_date) then

547: If (p_rec.end_date = hr_api.g_date) then
548: p_rec.end_date :=
549: per_rol_shd.g_old_rec.end_date;
550: End If;
551: If (p_rec.confidential_date = hr_api.g_date) then
552: p_rec.confidential_date :=
553: per_rol_shd.g_old_rec.confidential_date;
554: End If;
555: If (p_rec.emp_rights_flag = hr_api.g_varchar2) then

Line 555: If (p_rec.emp_rights_flag = hr_api.g_varchar2) then

551: If (p_rec.confidential_date = hr_api.g_date) then
552: p_rec.confidential_date :=
553: per_rol_shd.g_old_rec.confidential_date;
554: End If;
555: If (p_rec.emp_rights_flag = hr_api.g_varchar2) then
556: p_rec.emp_rights_flag :=
557: per_rol_shd.g_old_rec.emp_rights_flag;
558: End If;
559: If (p_rec.end_of_rights_date = hr_api.g_date) then

Line 559: If (p_rec.end_of_rights_date = hr_api.g_date) then

555: If (p_rec.emp_rights_flag = hr_api.g_varchar2) then
556: p_rec.emp_rights_flag :=
557: per_rol_shd.g_old_rec.emp_rights_flag;
558: End If;
559: If (p_rec.end_of_rights_date = hr_api.g_date) then
560: p_rec.end_of_rights_date :=
561: per_rol_shd.g_old_rec.end_of_rights_date;
562: End If;
563: If (p_rec.primary_contact_flag = hr_api.g_varchar2) then

Line 563: If (p_rec.primary_contact_flag = hr_api.g_varchar2) then

559: If (p_rec.end_of_rights_date = hr_api.g_date) then
560: p_rec.end_of_rights_date :=
561: per_rol_shd.g_old_rec.end_of_rights_date;
562: End If;
563: If (p_rec.primary_contact_flag = hr_api.g_varchar2) then
564: p_rec.primary_contact_flag :=
565: per_rol_shd.g_old_rec.primary_contact_flag;
566: End If;
567: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 567: If (p_rec.attribute_category = hr_api.g_varchar2) then

563: If (p_rec.primary_contact_flag = hr_api.g_varchar2) then
564: p_rec.primary_contact_flag :=
565: per_rol_shd.g_old_rec.primary_contact_flag;
566: End If;
567: If (p_rec.attribute_category = hr_api.g_varchar2) then
568: p_rec.attribute_category :=
569: per_rol_shd.g_old_rec.attribute_category;
570: End If;
571: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 571: If (p_rec.attribute1 = hr_api.g_varchar2) then

567: If (p_rec.attribute_category = hr_api.g_varchar2) then
568: p_rec.attribute_category :=
569: per_rol_shd.g_old_rec.attribute_category;
570: End If;
571: If (p_rec.attribute1 = hr_api.g_varchar2) then
572: p_rec.attribute1 :=
573: per_rol_shd.g_old_rec.attribute1;
574: End If;
575: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 575: If (p_rec.attribute2 = hr_api.g_varchar2) then

571: If (p_rec.attribute1 = hr_api.g_varchar2) then
572: p_rec.attribute1 :=
573: per_rol_shd.g_old_rec.attribute1;
574: End If;
575: If (p_rec.attribute2 = hr_api.g_varchar2) then
576: p_rec.attribute2 :=
577: per_rol_shd.g_old_rec.attribute2;
578: End If;
579: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 579: If (p_rec.attribute3 = hr_api.g_varchar2) then

575: If (p_rec.attribute2 = hr_api.g_varchar2) then
576: p_rec.attribute2 :=
577: per_rol_shd.g_old_rec.attribute2;
578: End If;
579: If (p_rec.attribute3 = hr_api.g_varchar2) then
580: p_rec.attribute3 :=
581: per_rol_shd.g_old_rec.attribute3;
582: End If;
583: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 583: If (p_rec.attribute4 = hr_api.g_varchar2) then

579: If (p_rec.attribute3 = hr_api.g_varchar2) then
580: p_rec.attribute3 :=
581: per_rol_shd.g_old_rec.attribute3;
582: End If;
583: If (p_rec.attribute4 = hr_api.g_varchar2) then
584: p_rec.attribute4 :=
585: per_rol_shd.g_old_rec.attribute4;
586: End If;
587: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 587: If (p_rec.attribute5 = hr_api.g_varchar2) then

583: If (p_rec.attribute4 = hr_api.g_varchar2) then
584: p_rec.attribute4 :=
585: per_rol_shd.g_old_rec.attribute4;
586: End If;
587: If (p_rec.attribute5 = hr_api.g_varchar2) then
588: p_rec.attribute5 :=
589: per_rol_shd.g_old_rec.attribute5;
590: End If;
591: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 591: If (p_rec.attribute6 = hr_api.g_varchar2) then

587: If (p_rec.attribute5 = hr_api.g_varchar2) then
588: p_rec.attribute5 :=
589: per_rol_shd.g_old_rec.attribute5;
590: End If;
591: If (p_rec.attribute6 = hr_api.g_varchar2) then
592: p_rec.attribute6 :=
593: per_rol_shd.g_old_rec.attribute6;
594: End If;
595: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 595: If (p_rec.attribute7 = hr_api.g_varchar2) then

591: If (p_rec.attribute6 = hr_api.g_varchar2) then
592: p_rec.attribute6 :=
593: per_rol_shd.g_old_rec.attribute6;
594: End If;
595: If (p_rec.attribute7 = hr_api.g_varchar2) then
596: p_rec.attribute7 :=
597: per_rol_shd.g_old_rec.attribute7;
598: End If;
599: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 599: If (p_rec.attribute8 = hr_api.g_varchar2) then

595: If (p_rec.attribute7 = hr_api.g_varchar2) then
596: p_rec.attribute7 :=
597: per_rol_shd.g_old_rec.attribute7;
598: End If;
599: If (p_rec.attribute8 = hr_api.g_varchar2) then
600: p_rec.attribute8 :=
601: per_rol_shd.g_old_rec.attribute8;
602: End If;
603: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 603: If (p_rec.attribute9 = hr_api.g_varchar2) then

599: If (p_rec.attribute8 = hr_api.g_varchar2) then
600: p_rec.attribute8 :=
601: per_rol_shd.g_old_rec.attribute8;
602: End If;
603: If (p_rec.attribute9 = hr_api.g_varchar2) then
604: p_rec.attribute9 :=
605: per_rol_shd.g_old_rec.attribute9;
606: End If;
607: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 607: If (p_rec.attribute10 = hr_api.g_varchar2) then

603: If (p_rec.attribute9 = hr_api.g_varchar2) then
604: p_rec.attribute9 :=
605: per_rol_shd.g_old_rec.attribute9;
606: End If;
607: If (p_rec.attribute10 = hr_api.g_varchar2) then
608: p_rec.attribute10 :=
609: per_rol_shd.g_old_rec.attribute10;
610: End If;
611: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 611: If (p_rec.attribute11 = hr_api.g_varchar2) then

607: If (p_rec.attribute10 = hr_api.g_varchar2) then
608: p_rec.attribute10 :=
609: per_rol_shd.g_old_rec.attribute10;
610: End If;
611: If (p_rec.attribute11 = hr_api.g_varchar2) then
612: p_rec.attribute11 :=
613: per_rol_shd.g_old_rec.attribute11;
614: End If;
615: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 615: If (p_rec.attribute12 = hr_api.g_varchar2) then

611: If (p_rec.attribute11 = hr_api.g_varchar2) then
612: p_rec.attribute11 :=
613: per_rol_shd.g_old_rec.attribute11;
614: End If;
615: If (p_rec.attribute12 = hr_api.g_varchar2) then
616: p_rec.attribute12 :=
617: per_rol_shd.g_old_rec.attribute12;
618: End If;
619: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 619: If (p_rec.attribute13 = hr_api.g_varchar2) then

615: If (p_rec.attribute12 = hr_api.g_varchar2) then
616: p_rec.attribute12 :=
617: per_rol_shd.g_old_rec.attribute12;
618: End If;
619: If (p_rec.attribute13 = hr_api.g_varchar2) then
620: p_rec.attribute13 :=
621: per_rol_shd.g_old_rec.attribute13;
622: End If;
623: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 623: If (p_rec.attribute14 = hr_api.g_varchar2) then

619: If (p_rec.attribute13 = hr_api.g_varchar2) then
620: p_rec.attribute13 :=
621: per_rol_shd.g_old_rec.attribute13;
622: End If;
623: If (p_rec.attribute14 = hr_api.g_varchar2) then
624: p_rec.attribute14 :=
625: per_rol_shd.g_old_rec.attribute14;
626: End If;
627: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 627: If (p_rec.attribute15 = hr_api.g_varchar2) then

623: If (p_rec.attribute14 = hr_api.g_varchar2) then
624: p_rec.attribute14 :=
625: per_rol_shd.g_old_rec.attribute14;
626: End If;
627: If (p_rec.attribute15 = hr_api.g_varchar2) then
628: p_rec.attribute15 :=
629: per_rol_shd.g_old_rec.attribute15;
630: End If;
631: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 631: If (p_rec.attribute16 = hr_api.g_varchar2) then

627: If (p_rec.attribute15 = hr_api.g_varchar2) then
628: p_rec.attribute15 :=
629: per_rol_shd.g_old_rec.attribute15;
630: End If;
631: If (p_rec.attribute16 = hr_api.g_varchar2) then
632: p_rec.attribute16 :=
633: per_rol_shd.g_old_rec.attribute16;
634: End If;
635: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 635: If (p_rec.attribute17 = hr_api.g_varchar2) then

631: If (p_rec.attribute16 = hr_api.g_varchar2) then
632: p_rec.attribute16 :=
633: per_rol_shd.g_old_rec.attribute16;
634: End If;
635: If (p_rec.attribute17 = hr_api.g_varchar2) then
636: p_rec.attribute17 :=
637: per_rol_shd.g_old_rec.attribute17;
638: End If;
639: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 639: If (p_rec.attribute18 = hr_api.g_varchar2) then

635: If (p_rec.attribute17 = hr_api.g_varchar2) then
636: p_rec.attribute17 :=
637: per_rol_shd.g_old_rec.attribute17;
638: End If;
639: If (p_rec.attribute18 = hr_api.g_varchar2) then
640: p_rec.attribute18 :=
641: per_rol_shd.g_old_rec.attribute18;
642: End If;
643: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 643: If (p_rec.attribute19 = hr_api.g_varchar2) then

639: If (p_rec.attribute18 = hr_api.g_varchar2) then
640: p_rec.attribute18 :=
641: per_rol_shd.g_old_rec.attribute18;
642: End If;
643: If (p_rec.attribute19 = hr_api.g_varchar2) then
644: p_rec.attribute19 :=
645: per_rol_shd.g_old_rec.attribute19;
646: End If;
647: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 647: If (p_rec.attribute20 = hr_api.g_varchar2) then

643: If (p_rec.attribute19 = hr_api.g_varchar2) then
644: p_rec.attribute19 :=
645: per_rol_shd.g_old_rec.attribute19;
646: End If;
647: If (p_rec.attribute20 = hr_api.g_varchar2) then
648: p_rec.attribute20 :=
649: per_rol_shd.g_old_rec.attribute20;
650: End If;
651: If (p_rec.role_information_category = hr_api.g_varchar2) then

Line 651: If (p_rec.role_information_category = hr_api.g_varchar2) then

647: If (p_rec.attribute20 = hr_api.g_varchar2) then
648: p_rec.attribute20 :=
649: per_rol_shd.g_old_rec.attribute20;
650: End If;
651: If (p_rec.role_information_category = hr_api.g_varchar2) then
652: p_rec.role_information_category :=
653: per_rol_shd.g_old_rec.role_information_category;
654: End If;
655: If (p_rec.role_information1 = hr_api.g_varchar2) then

Line 655: If (p_rec.role_information1 = hr_api.g_varchar2) then

651: If (p_rec.role_information_category = hr_api.g_varchar2) then
652: p_rec.role_information_category :=
653: per_rol_shd.g_old_rec.role_information_category;
654: End If;
655: If (p_rec.role_information1 = hr_api.g_varchar2) then
656: p_rec.role_information1 :=
657: per_rol_shd.g_old_rec.role_information1;
658: End If;
659: If (p_rec.role_information2 = hr_api.g_varchar2) then

Line 659: If (p_rec.role_information2 = hr_api.g_varchar2) then

655: If (p_rec.role_information1 = hr_api.g_varchar2) then
656: p_rec.role_information1 :=
657: per_rol_shd.g_old_rec.role_information1;
658: End If;
659: If (p_rec.role_information2 = hr_api.g_varchar2) then
660: p_rec.role_information2 :=
661: per_rol_shd.g_old_rec.role_information2;
662: End If;
663: If (p_rec.role_information3 = hr_api.g_varchar2) then

Line 663: If (p_rec.role_information3 = hr_api.g_varchar2) then

659: If (p_rec.role_information2 = hr_api.g_varchar2) then
660: p_rec.role_information2 :=
661: per_rol_shd.g_old_rec.role_information2;
662: End If;
663: If (p_rec.role_information3 = hr_api.g_varchar2) then
664: p_rec.role_information3 :=
665: per_rol_shd.g_old_rec.role_information3;
666: End If;
667: If (p_rec.role_information4 = hr_api.g_varchar2) then

Line 667: If (p_rec.role_information4 = hr_api.g_varchar2) then

663: If (p_rec.role_information3 = hr_api.g_varchar2) then
664: p_rec.role_information3 :=
665: per_rol_shd.g_old_rec.role_information3;
666: End If;
667: If (p_rec.role_information4 = hr_api.g_varchar2) then
668: p_rec.role_information4 :=
669: per_rol_shd.g_old_rec.role_information4;
670: End If;
671: If (p_rec.role_information5 = hr_api.g_varchar2) then

Line 671: If (p_rec.role_information5 = hr_api.g_varchar2) then

667: If (p_rec.role_information4 = hr_api.g_varchar2) then
668: p_rec.role_information4 :=
669: per_rol_shd.g_old_rec.role_information4;
670: End If;
671: If (p_rec.role_information5 = hr_api.g_varchar2) then
672: p_rec.role_information5 :=
673: per_rol_shd.g_old_rec.role_information5;
674: End If;
675: If (p_rec.role_information6 = hr_api.g_varchar2) then

Line 675: If (p_rec.role_information6 = hr_api.g_varchar2) then

671: If (p_rec.role_information5 = hr_api.g_varchar2) then
672: p_rec.role_information5 :=
673: per_rol_shd.g_old_rec.role_information5;
674: End If;
675: If (p_rec.role_information6 = hr_api.g_varchar2) then
676: p_rec.role_information6 :=
677: per_rol_shd.g_old_rec.role_information6;
678: End If;
679: If (p_rec.role_information7 = hr_api.g_varchar2) then

Line 679: If (p_rec.role_information7 = hr_api.g_varchar2) then

675: If (p_rec.role_information6 = hr_api.g_varchar2) then
676: p_rec.role_information6 :=
677: per_rol_shd.g_old_rec.role_information6;
678: End If;
679: If (p_rec.role_information7 = hr_api.g_varchar2) then
680: p_rec.role_information7 :=
681: per_rol_shd.g_old_rec.role_information7;
682: End If;
683: If (p_rec.role_information8 = hr_api.g_varchar2) then

Line 683: If (p_rec.role_information8 = hr_api.g_varchar2) then

679: If (p_rec.role_information7 = hr_api.g_varchar2) then
680: p_rec.role_information7 :=
681: per_rol_shd.g_old_rec.role_information7;
682: End If;
683: If (p_rec.role_information8 = hr_api.g_varchar2) then
684: p_rec.role_information8 :=
685: per_rol_shd.g_old_rec.role_information8;
686: End If;
687: If (p_rec.role_information9 = hr_api.g_varchar2) then

Line 687: If (p_rec.role_information9 = hr_api.g_varchar2) then

683: If (p_rec.role_information8 = hr_api.g_varchar2) then
684: p_rec.role_information8 :=
685: per_rol_shd.g_old_rec.role_information8;
686: End If;
687: If (p_rec.role_information9 = hr_api.g_varchar2) then
688: p_rec.role_information9 :=
689: per_rol_shd.g_old_rec.role_information9;
690: End If;
691: If (p_rec.role_information10 = hr_api.g_varchar2) then

Line 691: If (p_rec.role_information10 = hr_api.g_varchar2) then

687: If (p_rec.role_information9 = hr_api.g_varchar2) then
688: p_rec.role_information9 :=
689: per_rol_shd.g_old_rec.role_information9;
690: End If;
691: If (p_rec.role_information10 = hr_api.g_varchar2) then
692: p_rec.role_information10 :=
693: per_rol_shd.g_old_rec.role_information10;
694: End If;
695: If (p_rec.role_information11 = hr_api.g_varchar2) then

Line 695: If (p_rec.role_information11 = hr_api.g_varchar2) then

691: If (p_rec.role_information10 = hr_api.g_varchar2) then
692: p_rec.role_information10 :=
693: per_rol_shd.g_old_rec.role_information10;
694: End If;
695: If (p_rec.role_information11 = hr_api.g_varchar2) then
696: p_rec.role_information11 :=
697: per_rol_shd.g_old_rec.role_information11;
698: End If;
699: If (p_rec.role_information12 = hr_api.g_varchar2) then

Line 699: If (p_rec.role_information12 = hr_api.g_varchar2) then

695: If (p_rec.role_information11 = hr_api.g_varchar2) then
696: p_rec.role_information11 :=
697: per_rol_shd.g_old_rec.role_information11;
698: End If;
699: If (p_rec.role_information12 = hr_api.g_varchar2) then
700: p_rec.role_information12 :=
701: per_rol_shd.g_old_rec.role_information12;
702: End If;
703: If (p_rec.role_information13 = hr_api.g_varchar2) then

Line 703: If (p_rec.role_information13 = hr_api.g_varchar2) then

699: If (p_rec.role_information12 = hr_api.g_varchar2) then
700: p_rec.role_information12 :=
701: per_rol_shd.g_old_rec.role_information12;
702: End If;
703: If (p_rec.role_information13 = hr_api.g_varchar2) then
704: p_rec.role_information13 :=
705: per_rol_shd.g_old_rec.role_information13;
706: End If;
707: If (p_rec.role_information14 = hr_api.g_varchar2) then

Line 707: If (p_rec.role_information14 = hr_api.g_varchar2) then

703: If (p_rec.role_information13 = hr_api.g_varchar2) then
704: p_rec.role_information13 :=
705: per_rol_shd.g_old_rec.role_information13;
706: End If;
707: If (p_rec.role_information14 = hr_api.g_varchar2) then
708: p_rec.role_information14 :=
709: per_rol_shd.g_old_rec.role_information14;
710: End If;
711: If (p_rec.role_information15 = hr_api.g_varchar2) then

Line 711: If (p_rec.role_information15 = hr_api.g_varchar2) then

707: If (p_rec.role_information14 = hr_api.g_varchar2) then
708: p_rec.role_information14 :=
709: per_rol_shd.g_old_rec.role_information14;
710: End If;
711: If (p_rec.role_information15 = hr_api.g_varchar2) then
712: p_rec.role_information15 :=
713: per_rol_shd.g_old_rec.role_information15;
714: End If;
715: If (p_rec.role_information16 = hr_api.g_varchar2) then

Line 715: If (p_rec.role_information16 = hr_api.g_varchar2) then

711: If (p_rec.role_information15 = hr_api.g_varchar2) then
712: p_rec.role_information15 :=
713: per_rol_shd.g_old_rec.role_information15;
714: End If;
715: If (p_rec.role_information16 = hr_api.g_varchar2) then
716: p_rec.role_information16 :=
717: per_rol_shd.g_old_rec.role_information16;
718: End If;
719: If (p_rec.role_information17 = hr_api.g_varchar2) then

Line 719: If (p_rec.role_information17 = hr_api.g_varchar2) then

715: If (p_rec.role_information16 = hr_api.g_varchar2) then
716: p_rec.role_information16 :=
717: per_rol_shd.g_old_rec.role_information16;
718: End If;
719: If (p_rec.role_information17 = hr_api.g_varchar2) then
720: p_rec.role_information17 :=
721: per_rol_shd.g_old_rec.role_information17;
722: End If;
723: If (p_rec.role_information18 = hr_api.g_varchar2) then

Line 723: If (p_rec.role_information18 = hr_api.g_varchar2) then

719: If (p_rec.role_information17 = hr_api.g_varchar2) then
720: p_rec.role_information17 :=
721: per_rol_shd.g_old_rec.role_information17;
722: End If;
723: If (p_rec.role_information18 = hr_api.g_varchar2) then
724: p_rec.role_information18 :=
725: per_rol_shd.g_old_rec.role_information18;
726: End If;
727: If (p_rec.role_information19 = hr_api.g_varchar2) then

Line 727: If (p_rec.role_information19 = hr_api.g_varchar2) then

723: If (p_rec.role_information18 = hr_api.g_varchar2) then
724: p_rec.role_information18 :=
725: per_rol_shd.g_old_rec.role_information18;
726: End If;
727: If (p_rec.role_information19 = hr_api.g_varchar2) then
728: p_rec.role_information19 :=
729: per_rol_shd.g_old_rec.role_information19;
730: End If;
731: If (p_rec.role_information20 = hr_api.g_varchar2) then

Line 731: If (p_rec.role_information20 = hr_api.g_varchar2) then

727: If (p_rec.role_information19 = hr_api.g_varchar2) then
728: p_rec.role_information19 :=
729: per_rol_shd.g_old_rec.role_information19;
730: End If;
731: If (p_rec.role_information20 = hr_api.g_varchar2) then
732: p_rec.role_information20 :=
733: per_rol_shd.g_old_rec.role_information20;
734: End If;
735: --

Line 793: ,p_start_date in date default hr_api.g_date

789: Procedure upd
790: (p_effective_date in date
791: ,p_role_id in number
792: ,p_object_version_number in out nocopy number
793: ,p_start_date in date default hr_api.g_date
794: ,p_end_date in date default hr_api.g_date
795: ,p_confidential_date in date default hr_api.g_date
796: ,p_emp_rights_flag in varchar2 default hr_api.g_varchar2
797: ,p_end_of_rights_date in date default hr_api.g_date

Line 794: ,p_end_date in date default hr_api.g_date

790: (p_effective_date in date
791: ,p_role_id in number
792: ,p_object_version_number in out nocopy number
793: ,p_start_date in date default hr_api.g_date
794: ,p_end_date in date default hr_api.g_date
795: ,p_confidential_date in date default hr_api.g_date
796: ,p_emp_rights_flag in varchar2 default hr_api.g_varchar2
797: ,p_end_of_rights_date in date default hr_api.g_date
798: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2

Line 795: ,p_confidential_date in date default hr_api.g_date

791: ,p_role_id in number
792: ,p_object_version_number in out nocopy number
793: ,p_start_date in date default hr_api.g_date
794: ,p_end_date in date default hr_api.g_date
795: ,p_confidential_date in date default hr_api.g_date
796: ,p_emp_rights_flag in varchar2 default hr_api.g_varchar2
797: ,p_end_of_rights_date in date default hr_api.g_date
798: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
799: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 796: ,p_emp_rights_flag in varchar2 default hr_api.g_varchar2

792: ,p_object_version_number in out nocopy number
793: ,p_start_date in date default hr_api.g_date
794: ,p_end_date in date default hr_api.g_date
795: ,p_confidential_date in date default hr_api.g_date
796: ,p_emp_rights_flag in varchar2 default hr_api.g_varchar2
797: ,p_end_of_rights_date in date default hr_api.g_date
798: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
799: ,p_attribute_category in varchar2 default hr_api.g_varchar2
800: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 797: ,p_end_of_rights_date in date default hr_api.g_date

793: ,p_start_date in date default hr_api.g_date
794: ,p_end_date in date default hr_api.g_date
795: ,p_confidential_date in date default hr_api.g_date
796: ,p_emp_rights_flag in varchar2 default hr_api.g_varchar2
797: ,p_end_of_rights_date in date default hr_api.g_date
798: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
799: ,p_attribute_category in varchar2 default hr_api.g_varchar2
800: ,p_attribute1 in varchar2 default hr_api.g_varchar2
801: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 798: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2

794: ,p_end_date in date default hr_api.g_date
795: ,p_confidential_date in date default hr_api.g_date
796: ,p_emp_rights_flag in varchar2 default hr_api.g_varchar2
797: ,p_end_of_rights_date in date default hr_api.g_date
798: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
799: ,p_attribute_category in varchar2 default hr_api.g_varchar2
800: ,p_attribute1 in varchar2 default hr_api.g_varchar2
801: ,p_attribute2 in varchar2 default hr_api.g_varchar2
802: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 799: ,p_attribute_category in varchar2 default hr_api.g_varchar2

795: ,p_confidential_date in date default hr_api.g_date
796: ,p_emp_rights_flag in varchar2 default hr_api.g_varchar2
797: ,p_end_of_rights_date in date default hr_api.g_date
798: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
799: ,p_attribute_category in varchar2 default hr_api.g_varchar2
800: ,p_attribute1 in varchar2 default hr_api.g_varchar2
801: ,p_attribute2 in varchar2 default hr_api.g_varchar2
802: ,p_attribute3 in varchar2 default hr_api.g_varchar2
803: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 800: ,p_attribute1 in varchar2 default hr_api.g_varchar2

796: ,p_emp_rights_flag in varchar2 default hr_api.g_varchar2
797: ,p_end_of_rights_date in date default hr_api.g_date
798: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
799: ,p_attribute_category in varchar2 default hr_api.g_varchar2
800: ,p_attribute1 in varchar2 default hr_api.g_varchar2
801: ,p_attribute2 in varchar2 default hr_api.g_varchar2
802: ,p_attribute3 in varchar2 default hr_api.g_varchar2
803: ,p_attribute4 in varchar2 default hr_api.g_varchar2
804: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 801: ,p_attribute2 in varchar2 default hr_api.g_varchar2

797: ,p_end_of_rights_date in date default hr_api.g_date
798: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
799: ,p_attribute_category in varchar2 default hr_api.g_varchar2
800: ,p_attribute1 in varchar2 default hr_api.g_varchar2
801: ,p_attribute2 in varchar2 default hr_api.g_varchar2
802: ,p_attribute3 in varchar2 default hr_api.g_varchar2
803: ,p_attribute4 in varchar2 default hr_api.g_varchar2
804: ,p_attribute5 in varchar2 default hr_api.g_varchar2
805: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 802: ,p_attribute3 in varchar2 default hr_api.g_varchar2

798: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
799: ,p_attribute_category in varchar2 default hr_api.g_varchar2
800: ,p_attribute1 in varchar2 default hr_api.g_varchar2
801: ,p_attribute2 in varchar2 default hr_api.g_varchar2
802: ,p_attribute3 in varchar2 default hr_api.g_varchar2
803: ,p_attribute4 in varchar2 default hr_api.g_varchar2
804: ,p_attribute5 in varchar2 default hr_api.g_varchar2
805: ,p_attribute6 in varchar2 default hr_api.g_varchar2
806: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 803: ,p_attribute4 in varchar2 default hr_api.g_varchar2

799: ,p_attribute_category in varchar2 default hr_api.g_varchar2
800: ,p_attribute1 in varchar2 default hr_api.g_varchar2
801: ,p_attribute2 in varchar2 default hr_api.g_varchar2
802: ,p_attribute3 in varchar2 default hr_api.g_varchar2
803: ,p_attribute4 in varchar2 default hr_api.g_varchar2
804: ,p_attribute5 in varchar2 default hr_api.g_varchar2
805: ,p_attribute6 in varchar2 default hr_api.g_varchar2
806: ,p_attribute7 in varchar2 default hr_api.g_varchar2
807: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 804: ,p_attribute5 in varchar2 default hr_api.g_varchar2

800: ,p_attribute1 in varchar2 default hr_api.g_varchar2
801: ,p_attribute2 in varchar2 default hr_api.g_varchar2
802: ,p_attribute3 in varchar2 default hr_api.g_varchar2
803: ,p_attribute4 in varchar2 default hr_api.g_varchar2
804: ,p_attribute5 in varchar2 default hr_api.g_varchar2
805: ,p_attribute6 in varchar2 default hr_api.g_varchar2
806: ,p_attribute7 in varchar2 default hr_api.g_varchar2
807: ,p_attribute8 in varchar2 default hr_api.g_varchar2
808: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 805: ,p_attribute6 in varchar2 default hr_api.g_varchar2

801: ,p_attribute2 in varchar2 default hr_api.g_varchar2
802: ,p_attribute3 in varchar2 default hr_api.g_varchar2
803: ,p_attribute4 in varchar2 default hr_api.g_varchar2
804: ,p_attribute5 in varchar2 default hr_api.g_varchar2
805: ,p_attribute6 in varchar2 default hr_api.g_varchar2
806: ,p_attribute7 in varchar2 default hr_api.g_varchar2
807: ,p_attribute8 in varchar2 default hr_api.g_varchar2
808: ,p_attribute9 in varchar2 default hr_api.g_varchar2
809: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 806: ,p_attribute7 in varchar2 default hr_api.g_varchar2

802: ,p_attribute3 in varchar2 default hr_api.g_varchar2
803: ,p_attribute4 in varchar2 default hr_api.g_varchar2
804: ,p_attribute5 in varchar2 default hr_api.g_varchar2
805: ,p_attribute6 in varchar2 default hr_api.g_varchar2
806: ,p_attribute7 in varchar2 default hr_api.g_varchar2
807: ,p_attribute8 in varchar2 default hr_api.g_varchar2
808: ,p_attribute9 in varchar2 default hr_api.g_varchar2
809: ,p_attribute10 in varchar2 default hr_api.g_varchar2
810: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 807: ,p_attribute8 in varchar2 default hr_api.g_varchar2

803: ,p_attribute4 in varchar2 default hr_api.g_varchar2
804: ,p_attribute5 in varchar2 default hr_api.g_varchar2
805: ,p_attribute6 in varchar2 default hr_api.g_varchar2
806: ,p_attribute7 in varchar2 default hr_api.g_varchar2
807: ,p_attribute8 in varchar2 default hr_api.g_varchar2
808: ,p_attribute9 in varchar2 default hr_api.g_varchar2
809: ,p_attribute10 in varchar2 default hr_api.g_varchar2
810: ,p_attribute11 in varchar2 default hr_api.g_varchar2
811: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 808: ,p_attribute9 in varchar2 default hr_api.g_varchar2

804: ,p_attribute5 in varchar2 default hr_api.g_varchar2
805: ,p_attribute6 in varchar2 default hr_api.g_varchar2
806: ,p_attribute7 in varchar2 default hr_api.g_varchar2
807: ,p_attribute8 in varchar2 default hr_api.g_varchar2
808: ,p_attribute9 in varchar2 default hr_api.g_varchar2
809: ,p_attribute10 in varchar2 default hr_api.g_varchar2
810: ,p_attribute11 in varchar2 default hr_api.g_varchar2
811: ,p_attribute12 in varchar2 default hr_api.g_varchar2
812: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 809: ,p_attribute10 in varchar2 default hr_api.g_varchar2

805: ,p_attribute6 in varchar2 default hr_api.g_varchar2
806: ,p_attribute7 in varchar2 default hr_api.g_varchar2
807: ,p_attribute8 in varchar2 default hr_api.g_varchar2
808: ,p_attribute9 in varchar2 default hr_api.g_varchar2
809: ,p_attribute10 in varchar2 default hr_api.g_varchar2
810: ,p_attribute11 in varchar2 default hr_api.g_varchar2
811: ,p_attribute12 in varchar2 default hr_api.g_varchar2
812: ,p_attribute13 in varchar2 default hr_api.g_varchar2
813: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 810: ,p_attribute11 in varchar2 default hr_api.g_varchar2

806: ,p_attribute7 in varchar2 default hr_api.g_varchar2
807: ,p_attribute8 in varchar2 default hr_api.g_varchar2
808: ,p_attribute9 in varchar2 default hr_api.g_varchar2
809: ,p_attribute10 in varchar2 default hr_api.g_varchar2
810: ,p_attribute11 in varchar2 default hr_api.g_varchar2
811: ,p_attribute12 in varchar2 default hr_api.g_varchar2
812: ,p_attribute13 in varchar2 default hr_api.g_varchar2
813: ,p_attribute14 in varchar2 default hr_api.g_varchar2
814: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 811: ,p_attribute12 in varchar2 default hr_api.g_varchar2

807: ,p_attribute8 in varchar2 default hr_api.g_varchar2
808: ,p_attribute9 in varchar2 default hr_api.g_varchar2
809: ,p_attribute10 in varchar2 default hr_api.g_varchar2
810: ,p_attribute11 in varchar2 default hr_api.g_varchar2
811: ,p_attribute12 in varchar2 default hr_api.g_varchar2
812: ,p_attribute13 in varchar2 default hr_api.g_varchar2
813: ,p_attribute14 in varchar2 default hr_api.g_varchar2
814: ,p_attribute15 in varchar2 default hr_api.g_varchar2
815: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 812: ,p_attribute13 in varchar2 default hr_api.g_varchar2

808: ,p_attribute9 in varchar2 default hr_api.g_varchar2
809: ,p_attribute10 in varchar2 default hr_api.g_varchar2
810: ,p_attribute11 in varchar2 default hr_api.g_varchar2
811: ,p_attribute12 in varchar2 default hr_api.g_varchar2
812: ,p_attribute13 in varchar2 default hr_api.g_varchar2
813: ,p_attribute14 in varchar2 default hr_api.g_varchar2
814: ,p_attribute15 in varchar2 default hr_api.g_varchar2
815: ,p_attribute16 in varchar2 default hr_api.g_varchar2
816: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 813: ,p_attribute14 in varchar2 default hr_api.g_varchar2

809: ,p_attribute10 in varchar2 default hr_api.g_varchar2
810: ,p_attribute11 in varchar2 default hr_api.g_varchar2
811: ,p_attribute12 in varchar2 default hr_api.g_varchar2
812: ,p_attribute13 in varchar2 default hr_api.g_varchar2
813: ,p_attribute14 in varchar2 default hr_api.g_varchar2
814: ,p_attribute15 in varchar2 default hr_api.g_varchar2
815: ,p_attribute16 in varchar2 default hr_api.g_varchar2
816: ,p_attribute17 in varchar2 default hr_api.g_varchar2
817: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 814: ,p_attribute15 in varchar2 default hr_api.g_varchar2

810: ,p_attribute11 in varchar2 default hr_api.g_varchar2
811: ,p_attribute12 in varchar2 default hr_api.g_varchar2
812: ,p_attribute13 in varchar2 default hr_api.g_varchar2
813: ,p_attribute14 in varchar2 default hr_api.g_varchar2
814: ,p_attribute15 in varchar2 default hr_api.g_varchar2
815: ,p_attribute16 in varchar2 default hr_api.g_varchar2
816: ,p_attribute17 in varchar2 default hr_api.g_varchar2
817: ,p_attribute18 in varchar2 default hr_api.g_varchar2
818: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 815: ,p_attribute16 in varchar2 default hr_api.g_varchar2

811: ,p_attribute12 in varchar2 default hr_api.g_varchar2
812: ,p_attribute13 in varchar2 default hr_api.g_varchar2
813: ,p_attribute14 in varchar2 default hr_api.g_varchar2
814: ,p_attribute15 in varchar2 default hr_api.g_varchar2
815: ,p_attribute16 in varchar2 default hr_api.g_varchar2
816: ,p_attribute17 in varchar2 default hr_api.g_varchar2
817: ,p_attribute18 in varchar2 default hr_api.g_varchar2
818: ,p_attribute19 in varchar2 default hr_api.g_varchar2
819: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 816: ,p_attribute17 in varchar2 default hr_api.g_varchar2

812: ,p_attribute13 in varchar2 default hr_api.g_varchar2
813: ,p_attribute14 in varchar2 default hr_api.g_varchar2
814: ,p_attribute15 in varchar2 default hr_api.g_varchar2
815: ,p_attribute16 in varchar2 default hr_api.g_varchar2
816: ,p_attribute17 in varchar2 default hr_api.g_varchar2
817: ,p_attribute18 in varchar2 default hr_api.g_varchar2
818: ,p_attribute19 in varchar2 default hr_api.g_varchar2
819: ,p_attribute20 in varchar2 default hr_api.g_varchar2
820: ,p_role_information_category in varchar2 default hr_api.g_varchar2

Line 817: ,p_attribute18 in varchar2 default hr_api.g_varchar2

813: ,p_attribute14 in varchar2 default hr_api.g_varchar2
814: ,p_attribute15 in varchar2 default hr_api.g_varchar2
815: ,p_attribute16 in varchar2 default hr_api.g_varchar2
816: ,p_attribute17 in varchar2 default hr_api.g_varchar2
817: ,p_attribute18 in varchar2 default hr_api.g_varchar2
818: ,p_attribute19 in varchar2 default hr_api.g_varchar2
819: ,p_attribute20 in varchar2 default hr_api.g_varchar2
820: ,p_role_information_category in varchar2 default hr_api.g_varchar2
821: ,p_role_information1 in varchar2 default hr_api.g_varchar2

Line 818: ,p_attribute19 in varchar2 default hr_api.g_varchar2

814: ,p_attribute15 in varchar2 default hr_api.g_varchar2
815: ,p_attribute16 in varchar2 default hr_api.g_varchar2
816: ,p_attribute17 in varchar2 default hr_api.g_varchar2
817: ,p_attribute18 in varchar2 default hr_api.g_varchar2
818: ,p_attribute19 in varchar2 default hr_api.g_varchar2
819: ,p_attribute20 in varchar2 default hr_api.g_varchar2
820: ,p_role_information_category in varchar2 default hr_api.g_varchar2
821: ,p_role_information1 in varchar2 default hr_api.g_varchar2
822: ,p_role_information2 in varchar2 default hr_api.g_varchar2

Line 819: ,p_attribute20 in varchar2 default hr_api.g_varchar2

815: ,p_attribute16 in varchar2 default hr_api.g_varchar2
816: ,p_attribute17 in varchar2 default hr_api.g_varchar2
817: ,p_attribute18 in varchar2 default hr_api.g_varchar2
818: ,p_attribute19 in varchar2 default hr_api.g_varchar2
819: ,p_attribute20 in varchar2 default hr_api.g_varchar2
820: ,p_role_information_category in varchar2 default hr_api.g_varchar2
821: ,p_role_information1 in varchar2 default hr_api.g_varchar2
822: ,p_role_information2 in varchar2 default hr_api.g_varchar2
823: ,p_role_information3 in varchar2 default hr_api.g_varchar2

Line 820: ,p_role_information_category in varchar2 default hr_api.g_varchar2

816: ,p_attribute17 in varchar2 default hr_api.g_varchar2
817: ,p_attribute18 in varchar2 default hr_api.g_varchar2
818: ,p_attribute19 in varchar2 default hr_api.g_varchar2
819: ,p_attribute20 in varchar2 default hr_api.g_varchar2
820: ,p_role_information_category in varchar2 default hr_api.g_varchar2
821: ,p_role_information1 in varchar2 default hr_api.g_varchar2
822: ,p_role_information2 in varchar2 default hr_api.g_varchar2
823: ,p_role_information3 in varchar2 default hr_api.g_varchar2
824: ,p_role_information4 in varchar2 default hr_api.g_varchar2

Line 821: ,p_role_information1 in varchar2 default hr_api.g_varchar2

817: ,p_attribute18 in varchar2 default hr_api.g_varchar2
818: ,p_attribute19 in varchar2 default hr_api.g_varchar2
819: ,p_attribute20 in varchar2 default hr_api.g_varchar2
820: ,p_role_information_category in varchar2 default hr_api.g_varchar2
821: ,p_role_information1 in varchar2 default hr_api.g_varchar2
822: ,p_role_information2 in varchar2 default hr_api.g_varchar2
823: ,p_role_information3 in varchar2 default hr_api.g_varchar2
824: ,p_role_information4 in varchar2 default hr_api.g_varchar2
825: ,p_role_information5 in varchar2 default hr_api.g_varchar2

Line 822: ,p_role_information2 in varchar2 default hr_api.g_varchar2

818: ,p_attribute19 in varchar2 default hr_api.g_varchar2
819: ,p_attribute20 in varchar2 default hr_api.g_varchar2
820: ,p_role_information_category in varchar2 default hr_api.g_varchar2
821: ,p_role_information1 in varchar2 default hr_api.g_varchar2
822: ,p_role_information2 in varchar2 default hr_api.g_varchar2
823: ,p_role_information3 in varchar2 default hr_api.g_varchar2
824: ,p_role_information4 in varchar2 default hr_api.g_varchar2
825: ,p_role_information5 in varchar2 default hr_api.g_varchar2
826: ,p_role_information6 in varchar2 default hr_api.g_varchar2

Line 823: ,p_role_information3 in varchar2 default hr_api.g_varchar2

819: ,p_attribute20 in varchar2 default hr_api.g_varchar2
820: ,p_role_information_category in varchar2 default hr_api.g_varchar2
821: ,p_role_information1 in varchar2 default hr_api.g_varchar2
822: ,p_role_information2 in varchar2 default hr_api.g_varchar2
823: ,p_role_information3 in varchar2 default hr_api.g_varchar2
824: ,p_role_information4 in varchar2 default hr_api.g_varchar2
825: ,p_role_information5 in varchar2 default hr_api.g_varchar2
826: ,p_role_information6 in varchar2 default hr_api.g_varchar2
827: ,p_role_information7 in varchar2 default hr_api.g_varchar2

Line 824: ,p_role_information4 in varchar2 default hr_api.g_varchar2

820: ,p_role_information_category in varchar2 default hr_api.g_varchar2
821: ,p_role_information1 in varchar2 default hr_api.g_varchar2
822: ,p_role_information2 in varchar2 default hr_api.g_varchar2
823: ,p_role_information3 in varchar2 default hr_api.g_varchar2
824: ,p_role_information4 in varchar2 default hr_api.g_varchar2
825: ,p_role_information5 in varchar2 default hr_api.g_varchar2
826: ,p_role_information6 in varchar2 default hr_api.g_varchar2
827: ,p_role_information7 in varchar2 default hr_api.g_varchar2
828: ,p_role_information8 in varchar2 default hr_api.g_varchar2

Line 825: ,p_role_information5 in varchar2 default hr_api.g_varchar2

821: ,p_role_information1 in varchar2 default hr_api.g_varchar2
822: ,p_role_information2 in varchar2 default hr_api.g_varchar2
823: ,p_role_information3 in varchar2 default hr_api.g_varchar2
824: ,p_role_information4 in varchar2 default hr_api.g_varchar2
825: ,p_role_information5 in varchar2 default hr_api.g_varchar2
826: ,p_role_information6 in varchar2 default hr_api.g_varchar2
827: ,p_role_information7 in varchar2 default hr_api.g_varchar2
828: ,p_role_information8 in varchar2 default hr_api.g_varchar2
829: ,p_role_information9 in varchar2 default hr_api.g_varchar2

Line 826: ,p_role_information6 in varchar2 default hr_api.g_varchar2

822: ,p_role_information2 in varchar2 default hr_api.g_varchar2
823: ,p_role_information3 in varchar2 default hr_api.g_varchar2
824: ,p_role_information4 in varchar2 default hr_api.g_varchar2
825: ,p_role_information5 in varchar2 default hr_api.g_varchar2
826: ,p_role_information6 in varchar2 default hr_api.g_varchar2
827: ,p_role_information7 in varchar2 default hr_api.g_varchar2
828: ,p_role_information8 in varchar2 default hr_api.g_varchar2
829: ,p_role_information9 in varchar2 default hr_api.g_varchar2
830: ,p_role_information10 in varchar2 default hr_api.g_varchar2

Line 827: ,p_role_information7 in varchar2 default hr_api.g_varchar2

823: ,p_role_information3 in varchar2 default hr_api.g_varchar2
824: ,p_role_information4 in varchar2 default hr_api.g_varchar2
825: ,p_role_information5 in varchar2 default hr_api.g_varchar2
826: ,p_role_information6 in varchar2 default hr_api.g_varchar2
827: ,p_role_information7 in varchar2 default hr_api.g_varchar2
828: ,p_role_information8 in varchar2 default hr_api.g_varchar2
829: ,p_role_information9 in varchar2 default hr_api.g_varchar2
830: ,p_role_information10 in varchar2 default hr_api.g_varchar2
831: ,p_role_information11 in varchar2 default hr_api.g_varchar2

Line 828: ,p_role_information8 in varchar2 default hr_api.g_varchar2

824: ,p_role_information4 in varchar2 default hr_api.g_varchar2
825: ,p_role_information5 in varchar2 default hr_api.g_varchar2
826: ,p_role_information6 in varchar2 default hr_api.g_varchar2
827: ,p_role_information7 in varchar2 default hr_api.g_varchar2
828: ,p_role_information8 in varchar2 default hr_api.g_varchar2
829: ,p_role_information9 in varchar2 default hr_api.g_varchar2
830: ,p_role_information10 in varchar2 default hr_api.g_varchar2
831: ,p_role_information11 in varchar2 default hr_api.g_varchar2
832: ,p_role_information12 in varchar2 default hr_api.g_varchar2

Line 829: ,p_role_information9 in varchar2 default hr_api.g_varchar2

825: ,p_role_information5 in varchar2 default hr_api.g_varchar2
826: ,p_role_information6 in varchar2 default hr_api.g_varchar2
827: ,p_role_information7 in varchar2 default hr_api.g_varchar2
828: ,p_role_information8 in varchar2 default hr_api.g_varchar2
829: ,p_role_information9 in varchar2 default hr_api.g_varchar2
830: ,p_role_information10 in varchar2 default hr_api.g_varchar2
831: ,p_role_information11 in varchar2 default hr_api.g_varchar2
832: ,p_role_information12 in varchar2 default hr_api.g_varchar2
833: ,p_role_information13 in varchar2 default hr_api.g_varchar2

Line 830: ,p_role_information10 in varchar2 default hr_api.g_varchar2

826: ,p_role_information6 in varchar2 default hr_api.g_varchar2
827: ,p_role_information7 in varchar2 default hr_api.g_varchar2
828: ,p_role_information8 in varchar2 default hr_api.g_varchar2
829: ,p_role_information9 in varchar2 default hr_api.g_varchar2
830: ,p_role_information10 in varchar2 default hr_api.g_varchar2
831: ,p_role_information11 in varchar2 default hr_api.g_varchar2
832: ,p_role_information12 in varchar2 default hr_api.g_varchar2
833: ,p_role_information13 in varchar2 default hr_api.g_varchar2
834: ,p_role_information14 in varchar2 default hr_api.g_varchar2

Line 831: ,p_role_information11 in varchar2 default hr_api.g_varchar2

827: ,p_role_information7 in varchar2 default hr_api.g_varchar2
828: ,p_role_information8 in varchar2 default hr_api.g_varchar2
829: ,p_role_information9 in varchar2 default hr_api.g_varchar2
830: ,p_role_information10 in varchar2 default hr_api.g_varchar2
831: ,p_role_information11 in varchar2 default hr_api.g_varchar2
832: ,p_role_information12 in varchar2 default hr_api.g_varchar2
833: ,p_role_information13 in varchar2 default hr_api.g_varchar2
834: ,p_role_information14 in varchar2 default hr_api.g_varchar2
835: ,p_role_information15 in varchar2 default hr_api.g_varchar2

Line 832: ,p_role_information12 in varchar2 default hr_api.g_varchar2

828: ,p_role_information8 in varchar2 default hr_api.g_varchar2
829: ,p_role_information9 in varchar2 default hr_api.g_varchar2
830: ,p_role_information10 in varchar2 default hr_api.g_varchar2
831: ,p_role_information11 in varchar2 default hr_api.g_varchar2
832: ,p_role_information12 in varchar2 default hr_api.g_varchar2
833: ,p_role_information13 in varchar2 default hr_api.g_varchar2
834: ,p_role_information14 in varchar2 default hr_api.g_varchar2
835: ,p_role_information15 in varchar2 default hr_api.g_varchar2
836: ,p_role_information16 in varchar2 default hr_api.g_varchar2

Line 833: ,p_role_information13 in varchar2 default hr_api.g_varchar2

829: ,p_role_information9 in varchar2 default hr_api.g_varchar2
830: ,p_role_information10 in varchar2 default hr_api.g_varchar2
831: ,p_role_information11 in varchar2 default hr_api.g_varchar2
832: ,p_role_information12 in varchar2 default hr_api.g_varchar2
833: ,p_role_information13 in varchar2 default hr_api.g_varchar2
834: ,p_role_information14 in varchar2 default hr_api.g_varchar2
835: ,p_role_information15 in varchar2 default hr_api.g_varchar2
836: ,p_role_information16 in varchar2 default hr_api.g_varchar2
837: ,p_role_information17 in varchar2 default hr_api.g_varchar2

Line 834: ,p_role_information14 in varchar2 default hr_api.g_varchar2

830: ,p_role_information10 in varchar2 default hr_api.g_varchar2
831: ,p_role_information11 in varchar2 default hr_api.g_varchar2
832: ,p_role_information12 in varchar2 default hr_api.g_varchar2
833: ,p_role_information13 in varchar2 default hr_api.g_varchar2
834: ,p_role_information14 in varchar2 default hr_api.g_varchar2
835: ,p_role_information15 in varchar2 default hr_api.g_varchar2
836: ,p_role_information16 in varchar2 default hr_api.g_varchar2
837: ,p_role_information17 in varchar2 default hr_api.g_varchar2
838: ,p_role_information18 in varchar2 default hr_api.g_varchar2

Line 835: ,p_role_information15 in varchar2 default hr_api.g_varchar2

831: ,p_role_information11 in varchar2 default hr_api.g_varchar2
832: ,p_role_information12 in varchar2 default hr_api.g_varchar2
833: ,p_role_information13 in varchar2 default hr_api.g_varchar2
834: ,p_role_information14 in varchar2 default hr_api.g_varchar2
835: ,p_role_information15 in varchar2 default hr_api.g_varchar2
836: ,p_role_information16 in varchar2 default hr_api.g_varchar2
837: ,p_role_information17 in varchar2 default hr_api.g_varchar2
838: ,p_role_information18 in varchar2 default hr_api.g_varchar2
839: ,p_role_information19 in varchar2 default hr_api.g_varchar2

Line 836: ,p_role_information16 in varchar2 default hr_api.g_varchar2

832: ,p_role_information12 in varchar2 default hr_api.g_varchar2
833: ,p_role_information13 in varchar2 default hr_api.g_varchar2
834: ,p_role_information14 in varchar2 default hr_api.g_varchar2
835: ,p_role_information15 in varchar2 default hr_api.g_varchar2
836: ,p_role_information16 in varchar2 default hr_api.g_varchar2
837: ,p_role_information17 in varchar2 default hr_api.g_varchar2
838: ,p_role_information18 in varchar2 default hr_api.g_varchar2
839: ,p_role_information19 in varchar2 default hr_api.g_varchar2
840: ,p_role_information20 in varchar2 default hr_api.g_varchar2

Line 837: ,p_role_information17 in varchar2 default hr_api.g_varchar2

833: ,p_role_information13 in varchar2 default hr_api.g_varchar2
834: ,p_role_information14 in varchar2 default hr_api.g_varchar2
835: ,p_role_information15 in varchar2 default hr_api.g_varchar2
836: ,p_role_information16 in varchar2 default hr_api.g_varchar2
837: ,p_role_information17 in varchar2 default hr_api.g_varchar2
838: ,p_role_information18 in varchar2 default hr_api.g_varchar2
839: ,p_role_information19 in varchar2 default hr_api.g_varchar2
840: ,p_role_information20 in varchar2 default hr_api.g_varchar2
841: ,p_old_end_date in date default hr_api.g_date -- fix 1370960

Line 838: ,p_role_information18 in varchar2 default hr_api.g_varchar2

834: ,p_role_information14 in varchar2 default hr_api.g_varchar2
835: ,p_role_information15 in varchar2 default hr_api.g_varchar2
836: ,p_role_information16 in varchar2 default hr_api.g_varchar2
837: ,p_role_information17 in varchar2 default hr_api.g_varchar2
838: ,p_role_information18 in varchar2 default hr_api.g_varchar2
839: ,p_role_information19 in varchar2 default hr_api.g_varchar2
840: ,p_role_information20 in varchar2 default hr_api.g_varchar2
841: ,p_old_end_date in date default hr_api.g_date -- fix 1370960
842: ) is

Line 839: ,p_role_information19 in varchar2 default hr_api.g_varchar2

835: ,p_role_information15 in varchar2 default hr_api.g_varchar2
836: ,p_role_information16 in varchar2 default hr_api.g_varchar2
837: ,p_role_information17 in varchar2 default hr_api.g_varchar2
838: ,p_role_information18 in varchar2 default hr_api.g_varchar2
839: ,p_role_information19 in varchar2 default hr_api.g_varchar2
840: ,p_role_information20 in varchar2 default hr_api.g_varchar2
841: ,p_old_end_date in date default hr_api.g_date -- fix 1370960
842: ) is
843: --

Line 840: ,p_role_information20 in varchar2 default hr_api.g_varchar2

836: ,p_role_information16 in varchar2 default hr_api.g_varchar2
837: ,p_role_information17 in varchar2 default hr_api.g_varchar2
838: ,p_role_information18 in varchar2 default hr_api.g_varchar2
839: ,p_role_information19 in varchar2 default hr_api.g_varchar2
840: ,p_role_information20 in varchar2 default hr_api.g_varchar2
841: ,p_old_end_date in date default hr_api.g_date -- fix 1370960
842: ) is
843: --
844: l_rec per_rol_shd.g_rec_type;

Line 841: ,p_old_end_date in date default hr_api.g_date -- fix 1370960

837: ,p_role_information17 in varchar2 default hr_api.g_varchar2
838: ,p_role_information18 in varchar2 default hr_api.g_varchar2
839: ,p_role_information19 in varchar2 default hr_api.g_varchar2
840: ,p_role_information20 in varchar2 default hr_api.g_varchar2
841: ,p_old_end_date in date default hr_api.g_date -- fix 1370960
842: ) is
843: --
844: l_rec per_rol_shd.g_rec_type;
845: l_proc varchar2(72) := g_package||'upd';

Line 856: ,hr_api.g_number

852: --
853: l_rec :=
854: per_rol_shd.convert_args
855: (p_role_id
856: ,hr_api.g_number
857: ,hr_api.g_number
858: ,hr_api.g_number
859: ,hr_api.g_number
860: ,p_start_date

Line 857: ,hr_api.g_number

853: l_rec :=
854: per_rol_shd.convert_args
855: (p_role_id
856: ,hr_api.g_number
857: ,hr_api.g_number
858: ,hr_api.g_number
859: ,hr_api.g_number
860: ,p_start_date
861: ,p_end_date

Line 858: ,hr_api.g_number

854: per_rol_shd.convert_args
855: (p_role_id
856: ,hr_api.g_number
857: ,hr_api.g_number
858: ,hr_api.g_number
859: ,hr_api.g_number
860: ,p_start_date
861: ,p_end_date
862: ,p_confidential_date

Line 859: ,hr_api.g_number

855: (p_role_id
856: ,hr_api.g_number
857: ,hr_api.g_number
858: ,hr_api.g_number
859: ,hr_api.g_number
860: ,p_start_date
861: ,p_end_date
862: ,p_confidential_date
863: ,p_emp_rights_flag