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_GRD_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: per_grd_shd.g_api_dml := false; -- Unset the api dml status
137: per_grd_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: per_grd_shd.g_api_dml := false; -- Unset the api dml status
137: per_grd_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: per_grd_shd.g_api_dml := false; -- Unset the api dml status
142: per_grd_shd.constraint_error

Line 139: When hr_api.parent_integrity_violated Then

135: -- A check constraint has been violated
136: per_grd_shd.g_api_dml := false; -- Unset the api dml status
137: per_grd_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: per_grd_shd.g_api_dml := false; -- Unset the api dml status
142: per_grd_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: per_grd_shd.g_api_dml := false; -- Unset the api dml status
142: per_grd_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: per_grd_shd.g_api_dml := false; -- Unset the api dml status
147: per_grd_shd.constraint_error

Line 144: When hr_api.unique_integrity_violated Then

140: -- Parent integrity has been violated
141: per_grd_shd.g_api_dml := false; -- Unset the api dml status
142: per_grd_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: per_grd_shd.g_api_dml := false; -- Unset the api dml status
147: per_grd_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: per_grd_shd.g_api_dml := false; -- Unset the api dml status
147: per_grd_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When Others Then
150: per_grd_shd.g_api_dml := false; -- Unset the api dml status
151: Raise;
152: End update_dml;

Line 465: when hr_api.cannot_find_prog_unit then

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

Line 467: hr_api.cannot_find_prog_unit_error

463: exception
464: --
465: when hr_api.cannot_find_prog_unit then
466: --
467: hr_api.cannot_find_prog_unit_error
468: (p_module_name => 'PER_GRADES'
469: ,p_hook_type => 'AU');
470: --
471: end;

Line 530: If (p_rec.business_group_id = hr_api.g_number) then

526: -- p_rec plsql record structure
527: -- to see if a system default is being used. If a system default
528: -- is being used then we must set to the 'current' argument value.
529: --
530: If (p_rec.business_group_id = hr_api.g_number) then
531: p_rec.business_group_id :=
532: per_grd_shd.g_old_rec.business_group_id;
533: End If;
534: If (p_rec.grade_definition_id = hr_api.g_number) then

Line 534: If (p_rec.grade_definition_id = hr_api.g_number) then

530: If (p_rec.business_group_id = hr_api.g_number) then
531: p_rec.business_group_id :=
532: per_grd_shd.g_old_rec.business_group_id;
533: End If;
534: If (p_rec.grade_definition_id = hr_api.g_number) then
535: p_rec.grade_definition_id :=
536: per_grd_shd.g_old_rec.grade_definition_id;
537: End If;
538: If (p_rec.date_from = hr_api.g_date) then

Line 538: If (p_rec.date_from = hr_api.g_date) then

534: If (p_rec.grade_definition_id = hr_api.g_number) then
535: p_rec.grade_definition_id :=
536: per_grd_shd.g_old_rec.grade_definition_id;
537: End If;
538: If (p_rec.date_from = hr_api.g_date) then
539: p_rec.date_from :=
540: per_grd_shd.g_old_rec.date_from;
541: End If;
542: If (p_rec.sequence = hr_api.g_number) then

Line 542: If (p_rec.sequence = hr_api.g_number) then

538: If (p_rec.date_from = hr_api.g_date) then
539: p_rec.date_from :=
540: per_grd_shd.g_old_rec.date_from;
541: End If;
542: If (p_rec.sequence = hr_api.g_number) then
543: p_rec.sequence :=
544: per_grd_shd.g_old_rec.sequence;
545: End If;
546: If (p_rec.date_to = hr_api.g_date) then

Line 546: If (p_rec.date_to = hr_api.g_date) then

542: If (p_rec.sequence = hr_api.g_number) then
543: p_rec.sequence :=
544: per_grd_shd.g_old_rec.sequence;
545: End If;
546: If (p_rec.date_to = hr_api.g_date) then
547: p_rec.date_to :=
548: per_grd_shd.g_old_rec.date_to;
549: End If;
550: If (p_rec.name = hr_api.g_varchar2) then

Line 550: If (p_rec.name = hr_api.g_varchar2) then

546: If (p_rec.date_to = hr_api.g_date) then
547: p_rec.date_to :=
548: per_grd_shd.g_old_rec.date_to;
549: End If;
550: If (p_rec.name = hr_api.g_varchar2) then
551: p_rec.name :=
552: per_grd_shd.g_old_rec.name;
553: End If;
554: If (p_rec.short_name = hr_api.g_varchar2) then

Line 554: If (p_rec.short_name = hr_api.g_varchar2) then

550: If (p_rec.name = hr_api.g_varchar2) then
551: p_rec.name :=
552: per_grd_shd.g_old_rec.name;
553: End If;
554: If (p_rec.short_name = hr_api.g_varchar2) then
555: p_rec.short_name :=
556: per_grd_shd.g_old_rec.short_name;
557: End If;
558: If (p_rec.request_id = hr_api.g_number) then

Line 558: If (p_rec.request_id = hr_api.g_number) then

554: If (p_rec.short_name = hr_api.g_varchar2) then
555: p_rec.short_name :=
556: per_grd_shd.g_old_rec.short_name;
557: End If;
558: If (p_rec.request_id = hr_api.g_number) then
559: p_rec.request_id :=
560: per_grd_shd.g_old_rec.request_id;
561: End If;
562: If (p_rec.program_application_id = hr_api.g_number) then

Line 562: If (p_rec.program_application_id = hr_api.g_number) then

558: If (p_rec.request_id = hr_api.g_number) then
559: p_rec.request_id :=
560: per_grd_shd.g_old_rec.request_id;
561: End If;
562: If (p_rec.program_application_id = hr_api.g_number) then
563: p_rec.program_application_id :=
564: per_grd_shd.g_old_rec.program_application_id;
565: End If;
566: If (p_rec.program_id = hr_api.g_number) then

Line 566: If (p_rec.program_id = hr_api.g_number) then

562: If (p_rec.program_application_id = hr_api.g_number) then
563: p_rec.program_application_id :=
564: per_grd_shd.g_old_rec.program_application_id;
565: End If;
566: If (p_rec.program_id = hr_api.g_number) then
567: p_rec.program_id :=
568: per_grd_shd.g_old_rec.program_id;
569: End If;
570: If (p_rec.program_update_date = hr_api.g_date) then

Line 570: If (p_rec.program_update_date = hr_api.g_date) then

566: If (p_rec.program_id = hr_api.g_number) then
567: p_rec.program_id :=
568: per_grd_shd.g_old_rec.program_id;
569: End If;
570: If (p_rec.program_update_date = hr_api.g_date) then
571: p_rec.program_update_date :=
572: per_grd_shd.g_old_rec.program_update_date;
573: End If;
574: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

570: If (p_rec.program_update_date = hr_api.g_date) then
571: p_rec.program_update_date :=
572: per_grd_shd.g_old_rec.program_update_date;
573: End If;
574: If (p_rec.attribute_category = hr_api.g_varchar2) then
575: p_rec.attribute_category :=
576: per_grd_shd.g_old_rec.attribute_category;
577: End If;
578: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

574: If (p_rec.attribute_category = hr_api.g_varchar2) then
575: p_rec.attribute_category :=
576: per_grd_shd.g_old_rec.attribute_category;
577: End If;
578: If (p_rec.attribute1 = hr_api.g_varchar2) then
579: p_rec.attribute1 :=
580: per_grd_shd.g_old_rec.attribute1;
581: End If;
582: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

578: If (p_rec.attribute1 = hr_api.g_varchar2) then
579: p_rec.attribute1 :=
580: per_grd_shd.g_old_rec.attribute1;
581: End If;
582: If (p_rec.attribute2 = hr_api.g_varchar2) then
583: p_rec.attribute2 :=
584: per_grd_shd.g_old_rec.attribute2;
585: End If;
586: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

582: If (p_rec.attribute2 = hr_api.g_varchar2) then
583: p_rec.attribute2 :=
584: per_grd_shd.g_old_rec.attribute2;
585: End If;
586: If (p_rec.attribute3 = hr_api.g_varchar2) then
587: p_rec.attribute3 :=
588: per_grd_shd.g_old_rec.attribute3;
589: End If;
590: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

586: If (p_rec.attribute3 = hr_api.g_varchar2) then
587: p_rec.attribute3 :=
588: per_grd_shd.g_old_rec.attribute3;
589: End If;
590: If (p_rec.attribute4 = hr_api.g_varchar2) then
591: p_rec.attribute4 :=
592: per_grd_shd.g_old_rec.attribute4;
593: End If;
594: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

590: If (p_rec.attribute4 = hr_api.g_varchar2) then
591: p_rec.attribute4 :=
592: per_grd_shd.g_old_rec.attribute4;
593: End If;
594: If (p_rec.attribute5 = hr_api.g_varchar2) then
595: p_rec.attribute5 :=
596: per_grd_shd.g_old_rec.attribute5;
597: End If;
598: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

594: If (p_rec.attribute5 = hr_api.g_varchar2) then
595: p_rec.attribute5 :=
596: per_grd_shd.g_old_rec.attribute5;
597: End If;
598: If (p_rec.attribute6 = hr_api.g_varchar2) then
599: p_rec.attribute6 :=
600: per_grd_shd.g_old_rec.attribute6;
601: End If;
602: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

598: If (p_rec.attribute6 = hr_api.g_varchar2) then
599: p_rec.attribute6 :=
600: per_grd_shd.g_old_rec.attribute6;
601: End If;
602: If (p_rec.attribute7 = hr_api.g_varchar2) then
603: p_rec.attribute7 :=
604: per_grd_shd.g_old_rec.attribute7;
605: End If;
606: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

602: If (p_rec.attribute7 = hr_api.g_varchar2) then
603: p_rec.attribute7 :=
604: per_grd_shd.g_old_rec.attribute7;
605: End If;
606: If (p_rec.attribute8 = hr_api.g_varchar2) then
607: p_rec.attribute8 :=
608: per_grd_shd.g_old_rec.attribute8;
609: End If;
610: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

606: If (p_rec.attribute8 = hr_api.g_varchar2) then
607: p_rec.attribute8 :=
608: per_grd_shd.g_old_rec.attribute8;
609: End If;
610: If (p_rec.attribute9 = hr_api.g_varchar2) then
611: p_rec.attribute9 :=
612: per_grd_shd.g_old_rec.attribute9;
613: End If;
614: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

610: If (p_rec.attribute9 = hr_api.g_varchar2) then
611: p_rec.attribute9 :=
612: per_grd_shd.g_old_rec.attribute9;
613: End If;
614: If (p_rec.attribute10 = hr_api.g_varchar2) then
615: p_rec.attribute10 :=
616: per_grd_shd.g_old_rec.attribute10;
617: End If;
618: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

614: If (p_rec.attribute10 = hr_api.g_varchar2) then
615: p_rec.attribute10 :=
616: per_grd_shd.g_old_rec.attribute10;
617: End If;
618: If (p_rec.attribute11 = hr_api.g_varchar2) then
619: p_rec.attribute11 :=
620: per_grd_shd.g_old_rec.attribute11;
621: End If;
622: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

618: If (p_rec.attribute11 = hr_api.g_varchar2) then
619: p_rec.attribute11 :=
620: per_grd_shd.g_old_rec.attribute11;
621: End If;
622: If (p_rec.attribute12 = hr_api.g_varchar2) then
623: p_rec.attribute12 :=
624: per_grd_shd.g_old_rec.attribute12;
625: End If;
626: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

622: If (p_rec.attribute12 = hr_api.g_varchar2) then
623: p_rec.attribute12 :=
624: per_grd_shd.g_old_rec.attribute12;
625: End If;
626: If (p_rec.attribute13 = hr_api.g_varchar2) then
627: p_rec.attribute13 :=
628: per_grd_shd.g_old_rec.attribute13;
629: End If;
630: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

626: If (p_rec.attribute13 = hr_api.g_varchar2) then
627: p_rec.attribute13 :=
628: per_grd_shd.g_old_rec.attribute13;
629: End If;
630: If (p_rec.attribute14 = hr_api.g_varchar2) then
631: p_rec.attribute14 :=
632: per_grd_shd.g_old_rec.attribute14;
633: End If;
634: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

630: If (p_rec.attribute14 = hr_api.g_varchar2) then
631: p_rec.attribute14 :=
632: per_grd_shd.g_old_rec.attribute14;
633: End If;
634: If (p_rec.attribute15 = hr_api.g_varchar2) then
635: p_rec.attribute15 :=
636: per_grd_shd.g_old_rec.attribute15;
637: End If;
638: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

634: If (p_rec.attribute15 = hr_api.g_varchar2) then
635: p_rec.attribute15 :=
636: per_grd_shd.g_old_rec.attribute15;
637: End If;
638: If (p_rec.attribute16 = hr_api.g_varchar2) then
639: p_rec.attribute16 :=
640: per_grd_shd.g_old_rec.attribute16;
641: End If;
642: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

638: If (p_rec.attribute16 = hr_api.g_varchar2) then
639: p_rec.attribute16 :=
640: per_grd_shd.g_old_rec.attribute16;
641: End If;
642: If (p_rec.attribute17 = hr_api.g_varchar2) then
643: p_rec.attribute17 :=
644: per_grd_shd.g_old_rec.attribute17;
645: End If;
646: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

642: If (p_rec.attribute17 = hr_api.g_varchar2) then
643: p_rec.attribute17 :=
644: per_grd_shd.g_old_rec.attribute17;
645: End If;
646: If (p_rec.attribute18 = hr_api.g_varchar2) then
647: p_rec.attribute18 :=
648: per_grd_shd.g_old_rec.attribute18;
649: End If;
650: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

646: If (p_rec.attribute18 = hr_api.g_varchar2) then
647: p_rec.attribute18 :=
648: per_grd_shd.g_old_rec.attribute18;
649: End If;
650: If (p_rec.attribute19 = hr_api.g_varchar2) then
651: p_rec.attribute19 :=
652: per_grd_shd.g_old_rec.attribute19;
653: End If;
654: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

650: If (p_rec.attribute19 = hr_api.g_varchar2) then
651: p_rec.attribute19 :=
652: per_grd_shd.g_old_rec.attribute19;
653: End If;
654: If (p_rec.attribute20 = hr_api.g_varchar2) then
655: p_rec.attribute20 :=
656: per_grd_shd.g_old_rec.attribute20;
657: End If;
658: If (p_rec.information_category = hr_api.g_varchar2) then

Line 658: If (p_rec.information_category = hr_api.g_varchar2) then

654: If (p_rec.attribute20 = hr_api.g_varchar2) then
655: p_rec.attribute20 :=
656: per_grd_shd.g_old_rec.attribute20;
657: End If;
658: If (p_rec.information_category = hr_api.g_varchar2) then
659: p_rec.information_category :=
660: per_grd_shd.g_old_rec.information_category;
661: End If;
662: If (p_rec.information1 = hr_api.g_varchar2) then

Line 662: If (p_rec.information1 = hr_api.g_varchar2) then

658: If (p_rec.information_category = hr_api.g_varchar2) then
659: p_rec.information_category :=
660: per_grd_shd.g_old_rec.information_category;
661: End If;
662: If (p_rec.information1 = hr_api.g_varchar2) then
663: p_rec.information1 :=
664: per_grd_shd.g_old_rec.information1;
665: End If;
666: If (p_rec.information2 = hr_api.g_varchar2) then

Line 666: If (p_rec.information2 = hr_api.g_varchar2) then

662: If (p_rec.information1 = hr_api.g_varchar2) then
663: p_rec.information1 :=
664: per_grd_shd.g_old_rec.information1;
665: End If;
666: If (p_rec.information2 = hr_api.g_varchar2) then
667: p_rec.information2 :=
668: per_grd_shd.g_old_rec.information2;
669: End If;
670: If (p_rec.information3 = hr_api.g_varchar2) then

Line 670: If (p_rec.information3 = hr_api.g_varchar2) then

666: If (p_rec.information2 = hr_api.g_varchar2) then
667: p_rec.information2 :=
668: per_grd_shd.g_old_rec.information2;
669: End If;
670: If (p_rec.information3 = hr_api.g_varchar2) then
671: p_rec.information3 :=
672: per_grd_shd.g_old_rec.information3;
673: End If;
674: If (p_rec.information4 = hr_api.g_varchar2) then

Line 674: If (p_rec.information4 = hr_api.g_varchar2) then

670: If (p_rec.information3 = hr_api.g_varchar2) then
671: p_rec.information3 :=
672: per_grd_shd.g_old_rec.information3;
673: End If;
674: If (p_rec.information4 = hr_api.g_varchar2) then
675: p_rec.information4 :=
676: per_grd_shd.g_old_rec.information4;
677: End If;
678: If (p_rec.information5 = hr_api.g_varchar2) then

Line 678: If (p_rec.information5 = hr_api.g_varchar2) then

674: If (p_rec.information4 = hr_api.g_varchar2) then
675: p_rec.information4 :=
676: per_grd_shd.g_old_rec.information4;
677: End If;
678: If (p_rec.information5 = hr_api.g_varchar2) then
679: p_rec.information5 :=
680: per_grd_shd.g_old_rec.information5;
681: End If;
682: If (p_rec.information6 = hr_api.g_varchar2) then

Line 682: If (p_rec.information6 = hr_api.g_varchar2) then

678: If (p_rec.information5 = hr_api.g_varchar2) then
679: p_rec.information5 :=
680: per_grd_shd.g_old_rec.information5;
681: End If;
682: If (p_rec.information6 = hr_api.g_varchar2) then
683: p_rec.information6 :=
684: per_grd_shd.g_old_rec.information6;
685: End If;
686: If (p_rec.information7 = hr_api.g_varchar2) then

Line 686: If (p_rec.information7 = hr_api.g_varchar2) then

682: If (p_rec.information6 = hr_api.g_varchar2) then
683: p_rec.information6 :=
684: per_grd_shd.g_old_rec.information6;
685: End If;
686: If (p_rec.information7 = hr_api.g_varchar2) then
687: p_rec.information7 :=
688: per_grd_shd.g_old_rec.information7;
689: End If;
690: If (p_rec.information8 = hr_api.g_varchar2) then

Line 690: If (p_rec.information8 = hr_api.g_varchar2) then

686: If (p_rec.information7 = hr_api.g_varchar2) then
687: p_rec.information7 :=
688: per_grd_shd.g_old_rec.information7;
689: End If;
690: If (p_rec.information8 = hr_api.g_varchar2) then
691: p_rec.information8 :=
692: per_grd_shd.g_old_rec.information8;
693: End If;
694: If (p_rec.information9 = hr_api.g_varchar2) then

Line 694: If (p_rec.information9 = hr_api.g_varchar2) then

690: If (p_rec.information8 = hr_api.g_varchar2) then
691: p_rec.information8 :=
692: per_grd_shd.g_old_rec.information8;
693: End If;
694: If (p_rec.information9 = hr_api.g_varchar2) then
695: p_rec.information9 :=
696: per_grd_shd.g_old_rec.information9;
697: End If;
698: If (p_rec.information10 = hr_api.g_varchar2) then

Line 698: If (p_rec.information10 = hr_api.g_varchar2) then

694: If (p_rec.information9 = hr_api.g_varchar2) then
695: p_rec.information9 :=
696: per_grd_shd.g_old_rec.information9;
697: End If;
698: If (p_rec.information10 = hr_api.g_varchar2) then
699: p_rec.information10 :=
700: per_grd_shd.g_old_rec.information10;
701: End If;
702: If (p_rec.information11 = hr_api.g_varchar2) then

Line 702: If (p_rec.information11 = hr_api.g_varchar2) then

698: If (p_rec.information10 = hr_api.g_varchar2) then
699: p_rec.information10 :=
700: per_grd_shd.g_old_rec.information10;
701: End If;
702: If (p_rec.information11 = hr_api.g_varchar2) then
703: p_rec.information11 :=
704: per_grd_shd.g_old_rec.information11;
705: End If;
706: If (p_rec.information12 = hr_api.g_varchar2) then

Line 706: If (p_rec.information12 = hr_api.g_varchar2) then

702: If (p_rec.information11 = hr_api.g_varchar2) then
703: p_rec.information11 :=
704: per_grd_shd.g_old_rec.information11;
705: End If;
706: If (p_rec.information12 = hr_api.g_varchar2) then
707: p_rec.information12 :=
708: per_grd_shd.g_old_rec.information12;
709: End If;
710: If (p_rec.information13 = hr_api.g_varchar2) then

Line 710: If (p_rec.information13 = hr_api.g_varchar2) then

706: If (p_rec.information12 = hr_api.g_varchar2) then
707: p_rec.information12 :=
708: per_grd_shd.g_old_rec.information12;
709: End If;
710: If (p_rec.information13 = hr_api.g_varchar2) then
711: p_rec.information13 :=
712: per_grd_shd.g_old_rec.information13;
713: End If;
714: If (p_rec.information14 = hr_api.g_varchar2) then

Line 714: If (p_rec.information14 = hr_api.g_varchar2) then

710: If (p_rec.information13 = hr_api.g_varchar2) then
711: p_rec.information13 :=
712: per_grd_shd.g_old_rec.information13;
713: End If;
714: If (p_rec.information14 = hr_api.g_varchar2) then
715: p_rec.information14 :=
716: per_grd_shd.g_old_rec.information14;
717: End If;
718: If (p_rec.information15 = hr_api.g_varchar2) then

Line 718: If (p_rec.information15 = hr_api.g_varchar2) then

714: If (p_rec.information14 = hr_api.g_varchar2) then
715: p_rec.information14 :=
716: per_grd_shd.g_old_rec.information14;
717: End If;
718: If (p_rec.information15 = hr_api.g_varchar2) then
719: p_rec.information15 :=
720: per_grd_shd.g_old_rec.information15;
721: End If;
722: If (p_rec.information16 = hr_api.g_varchar2) then

Line 722: If (p_rec.information16 = hr_api.g_varchar2) then

718: If (p_rec.information15 = hr_api.g_varchar2) then
719: p_rec.information15 :=
720: per_grd_shd.g_old_rec.information15;
721: End If;
722: If (p_rec.information16 = hr_api.g_varchar2) then
723: p_rec.information16 :=
724: per_grd_shd.g_old_rec.information16;
725: End If;
726: If (p_rec.information17 = hr_api.g_varchar2) then

Line 726: If (p_rec.information17 = hr_api.g_varchar2) then

722: If (p_rec.information16 = hr_api.g_varchar2) then
723: p_rec.information16 :=
724: per_grd_shd.g_old_rec.information16;
725: End If;
726: If (p_rec.information17 = hr_api.g_varchar2) then
727: p_rec.information17 :=
728: per_grd_shd.g_old_rec.information17;
729: End If;
730: If (p_rec.information18 = hr_api.g_varchar2) then

Line 730: If (p_rec.information18 = hr_api.g_varchar2) then

726: If (p_rec.information17 = hr_api.g_varchar2) then
727: p_rec.information17 :=
728: per_grd_shd.g_old_rec.information17;
729: End If;
730: If (p_rec.information18 = hr_api.g_varchar2) then
731: p_rec.information18 :=
732: per_grd_shd.g_old_rec.information18;
733: End If;
734: If (p_rec.information19 = hr_api.g_varchar2) then

Line 734: If (p_rec.information19 = hr_api.g_varchar2) then

730: If (p_rec.information18 = hr_api.g_varchar2) then
731: p_rec.information18 :=
732: per_grd_shd.g_old_rec.information18;
733: End If;
734: If (p_rec.information19 = hr_api.g_varchar2) then
735: p_rec.information19 :=
736: per_grd_shd.g_old_rec.information19;
737: End If;
738: If (p_rec.information20 = hr_api.g_varchar2) then

Line 738: If (p_rec.information20 = hr_api.g_varchar2) then

734: If (p_rec.information19 = hr_api.g_varchar2) then
735: p_rec.information19 :=
736: per_grd_shd.g_old_rec.information19;
737: End If;
738: If (p_rec.information20 = hr_api.g_varchar2) then
739: p_rec.information20 :=
740: per_grd_shd.g_old_rec.information20;
741: End If;
742: --

Line 806: ,p_business_group_id in number default hr_api.g_number

802: Procedure upd
803: (p_effective_date in date
804: ,p_grade_id in number
805: ,p_object_version_number in out nocopy number
806: ,p_business_group_id in number default hr_api.g_number
807: ,p_grade_definition_id in number default hr_api.g_number
808: ,p_date_from in date default hr_api.g_date
809: ,p_sequence in number default hr_api.g_number
810: ,p_date_to in date default hr_api.g_date

Line 807: ,p_grade_definition_id in number default hr_api.g_number

803: (p_effective_date in date
804: ,p_grade_id in number
805: ,p_object_version_number in out nocopy number
806: ,p_business_group_id in number default hr_api.g_number
807: ,p_grade_definition_id in number default hr_api.g_number
808: ,p_date_from in date default hr_api.g_date
809: ,p_sequence in number default hr_api.g_number
810: ,p_date_to in date default hr_api.g_date
811: ,p_name in varchar2 default hr_api.g_varchar2

Line 808: ,p_date_from in date default hr_api.g_date

804: ,p_grade_id in number
805: ,p_object_version_number in out nocopy number
806: ,p_business_group_id in number default hr_api.g_number
807: ,p_grade_definition_id in number default hr_api.g_number
808: ,p_date_from in date default hr_api.g_date
809: ,p_sequence in number default hr_api.g_number
810: ,p_date_to in date default hr_api.g_date
811: ,p_name in varchar2 default hr_api.g_varchar2
812: ,p_short_name in varchar2 default hr_api.g_varchar2

Line 809: ,p_sequence in number default hr_api.g_number

805: ,p_object_version_number in out nocopy number
806: ,p_business_group_id in number default hr_api.g_number
807: ,p_grade_definition_id in number default hr_api.g_number
808: ,p_date_from in date default hr_api.g_date
809: ,p_sequence in number default hr_api.g_number
810: ,p_date_to in date default hr_api.g_date
811: ,p_name in varchar2 default hr_api.g_varchar2
812: ,p_short_name in varchar2 default hr_api.g_varchar2
813: ,p_request_id in number default hr_api.g_number

Line 810: ,p_date_to in date default hr_api.g_date

806: ,p_business_group_id in number default hr_api.g_number
807: ,p_grade_definition_id in number default hr_api.g_number
808: ,p_date_from in date default hr_api.g_date
809: ,p_sequence in number default hr_api.g_number
810: ,p_date_to in date default hr_api.g_date
811: ,p_name in varchar2 default hr_api.g_varchar2
812: ,p_short_name in varchar2 default hr_api.g_varchar2
813: ,p_request_id in number default hr_api.g_number
814: ,p_program_application_id in number default hr_api.g_number

Line 811: ,p_name in varchar2 default hr_api.g_varchar2

807: ,p_grade_definition_id in number default hr_api.g_number
808: ,p_date_from in date default hr_api.g_date
809: ,p_sequence in number default hr_api.g_number
810: ,p_date_to in date default hr_api.g_date
811: ,p_name in varchar2 default hr_api.g_varchar2
812: ,p_short_name in varchar2 default hr_api.g_varchar2
813: ,p_request_id in number default hr_api.g_number
814: ,p_program_application_id in number default hr_api.g_number
815: ,p_program_id in number default hr_api.g_number

Line 812: ,p_short_name in varchar2 default hr_api.g_varchar2

808: ,p_date_from in date default hr_api.g_date
809: ,p_sequence in number default hr_api.g_number
810: ,p_date_to in date default hr_api.g_date
811: ,p_name in varchar2 default hr_api.g_varchar2
812: ,p_short_name in varchar2 default hr_api.g_varchar2
813: ,p_request_id in number default hr_api.g_number
814: ,p_program_application_id in number default hr_api.g_number
815: ,p_program_id in number default hr_api.g_number
816: ,p_program_update_date in date default hr_api.g_date

Line 813: ,p_request_id in number default hr_api.g_number

809: ,p_sequence in number default hr_api.g_number
810: ,p_date_to in date default hr_api.g_date
811: ,p_name in varchar2 default hr_api.g_varchar2
812: ,p_short_name in varchar2 default hr_api.g_varchar2
813: ,p_request_id in number default hr_api.g_number
814: ,p_program_application_id in number default hr_api.g_number
815: ,p_program_id in number default hr_api.g_number
816: ,p_program_update_date in date default hr_api.g_date
817: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 814: ,p_program_application_id in number default hr_api.g_number

810: ,p_date_to in date default hr_api.g_date
811: ,p_name in varchar2 default hr_api.g_varchar2
812: ,p_short_name in varchar2 default hr_api.g_varchar2
813: ,p_request_id in number default hr_api.g_number
814: ,p_program_application_id in number default hr_api.g_number
815: ,p_program_id in number default hr_api.g_number
816: ,p_program_update_date in date default hr_api.g_date
817: ,p_attribute_category in varchar2 default hr_api.g_varchar2
818: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 815: ,p_program_id in number default hr_api.g_number

811: ,p_name in varchar2 default hr_api.g_varchar2
812: ,p_short_name in varchar2 default hr_api.g_varchar2
813: ,p_request_id in number default hr_api.g_number
814: ,p_program_application_id in number default hr_api.g_number
815: ,p_program_id in number default hr_api.g_number
816: ,p_program_update_date in date default hr_api.g_date
817: ,p_attribute_category in varchar2 default hr_api.g_varchar2
818: ,p_attribute1 in varchar2 default hr_api.g_varchar2
819: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 816: ,p_program_update_date in date default hr_api.g_date

812: ,p_short_name in varchar2 default hr_api.g_varchar2
813: ,p_request_id in number default hr_api.g_number
814: ,p_program_application_id in number default hr_api.g_number
815: ,p_program_id in number default hr_api.g_number
816: ,p_program_update_date in date default hr_api.g_date
817: ,p_attribute_category in varchar2 default hr_api.g_varchar2
818: ,p_attribute1 in varchar2 default hr_api.g_varchar2
819: ,p_attribute2 in varchar2 default hr_api.g_varchar2
820: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 817: ,p_attribute_category in varchar2 default hr_api.g_varchar2

813: ,p_request_id in number default hr_api.g_number
814: ,p_program_application_id in number default hr_api.g_number
815: ,p_program_id in number default hr_api.g_number
816: ,p_program_update_date in date default hr_api.g_date
817: ,p_attribute_category in varchar2 default hr_api.g_varchar2
818: ,p_attribute1 in varchar2 default hr_api.g_varchar2
819: ,p_attribute2 in varchar2 default hr_api.g_varchar2
820: ,p_attribute3 in varchar2 default hr_api.g_varchar2
821: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 818: ,p_attribute1 in varchar2 default hr_api.g_varchar2

814: ,p_program_application_id in number default hr_api.g_number
815: ,p_program_id in number default hr_api.g_number
816: ,p_program_update_date in date default hr_api.g_date
817: ,p_attribute_category in varchar2 default hr_api.g_varchar2
818: ,p_attribute1 in varchar2 default hr_api.g_varchar2
819: ,p_attribute2 in varchar2 default hr_api.g_varchar2
820: ,p_attribute3 in varchar2 default hr_api.g_varchar2
821: ,p_attribute4 in varchar2 default hr_api.g_varchar2
822: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 819: ,p_attribute2 in varchar2 default hr_api.g_varchar2

815: ,p_program_id in number default hr_api.g_number
816: ,p_program_update_date in date default hr_api.g_date
817: ,p_attribute_category in varchar2 default hr_api.g_varchar2
818: ,p_attribute1 in varchar2 default hr_api.g_varchar2
819: ,p_attribute2 in varchar2 default hr_api.g_varchar2
820: ,p_attribute3 in varchar2 default hr_api.g_varchar2
821: ,p_attribute4 in varchar2 default hr_api.g_varchar2
822: ,p_attribute5 in varchar2 default hr_api.g_varchar2
823: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 820: ,p_attribute3 in varchar2 default hr_api.g_varchar2

816: ,p_program_update_date in date default hr_api.g_date
817: ,p_attribute_category in varchar2 default hr_api.g_varchar2
818: ,p_attribute1 in varchar2 default hr_api.g_varchar2
819: ,p_attribute2 in varchar2 default hr_api.g_varchar2
820: ,p_attribute3 in varchar2 default hr_api.g_varchar2
821: ,p_attribute4 in varchar2 default hr_api.g_varchar2
822: ,p_attribute5 in varchar2 default hr_api.g_varchar2
823: ,p_attribute6 in varchar2 default hr_api.g_varchar2
824: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 821: ,p_attribute4 in varchar2 default hr_api.g_varchar2

817: ,p_attribute_category in varchar2 default hr_api.g_varchar2
818: ,p_attribute1 in varchar2 default hr_api.g_varchar2
819: ,p_attribute2 in varchar2 default hr_api.g_varchar2
820: ,p_attribute3 in varchar2 default hr_api.g_varchar2
821: ,p_attribute4 in varchar2 default hr_api.g_varchar2
822: ,p_attribute5 in varchar2 default hr_api.g_varchar2
823: ,p_attribute6 in varchar2 default hr_api.g_varchar2
824: ,p_attribute7 in varchar2 default hr_api.g_varchar2
825: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 822: ,p_attribute5 in varchar2 default hr_api.g_varchar2

818: ,p_attribute1 in varchar2 default hr_api.g_varchar2
819: ,p_attribute2 in varchar2 default hr_api.g_varchar2
820: ,p_attribute3 in varchar2 default hr_api.g_varchar2
821: ,p_attribute4 in varchar2 default hr_api.g_varchar2
822: ,p_attribute5 in varchar2 default hr_api.g_varchar2
823: ,p_attribute6 in varchar2 default hr_api.g_varchar2
824: ,p_attribute7 in varchar2 default hr_api.g_varchar2
825: ,p_attribute8 in varchar2 default hr_api.g_varchar2
826: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 823: ,p_attribute6 in varchar2 default hr_api.g_varchar2

819: ,p_attribute2 in varchar2 default hr_api.g_varchar2
820: ,p_attribute3 in varchar2 default hr_api.g_varchar2
821: ,p_attribute4 in varchar2 default hr_api.g_varchar2
822: ,p_attribute5 in varchar2 default hr_api.g_varchar2
823: ,p_attribute6 in varchar2 default hr_api.g_varchar2
824: ,p_attribute7 in varchar2 default hr_api.g_varchar2
825: ,p_attribute8 in varchar2 default hr_api.g_varchar2
826: ,p_attribute9 in varchar2 default hr_api.g_varchar2
827: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 824: ,p_attribute7 in varchar2 default hr_api.g_varchar2

820: ,p_attribute3 in varchar2 default hr_api.g_varchar2
821: ,p_attribute4 in varchar2 default hr_api.g_varchar2
822: ,p_attribute5 in varchar2 default hr_api.g_varchar2
823: ,p_attribute6 in varchar2 default hr_api.g_varchar2
824: ,p_attribute7 in varchar2 default hr_api.g_varchar2
825: ,p_attribute8 in varchar2 default hr_api.g_varchar2
826: ,p_attribute9 in varchar2 default hr_api.g_varchar2
827: ,p_attribute10 in varchar2 default hr_api.g_varchar2
828: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 825: ,p_attribute8 in varchar2 default hr_api.g_varchar2

821: ,p_attribute4 in varchar2 default hr_api.g_varchar2
822: ,p_attribute5 in varchar2 default hr_api.g_varchar2
823: ,p_attribute6 in varchar2 default hr_api.g_varchar2
824: ,p_attribute7 in varchar2 default hr_api.g_varchar2
825: ,p_attribute8 in varchar2 default hr_api.g_varchar2
826: ,p_attribute9 in varchar2 default hr_api.g_varchar2
827: ,p_attribute10 in varchar2 default hr_api.g_varchar2
828: ,p_attribute11 in varchar2 default hr_api.g_varchar2
829: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 826: ,p_attribute9 in varchar2 default hr_api.g_varchar2

822: ,p_attribute5 in varchar2 default hr_api.g_varchar2
823: ,p_attribute6 in varchar2 default hr_api.g_varchar2
824: ,p_attribute7 in varchar2 default hr_api.g_varchar2
825: ,p_attribute8 in varchar2 default hr_api.g_varchar2
826: ,p_attribute9 in varchar2 default hr_api.g_varchar2
827: ,p_attribute10 in varchar2 default hr_api.g_varchar2
828: ,p_attribute11 in varchar2 default hr_api.g_varchar2
829: ,p_attribute12 in varchar2 default hr_api.g_varchar2
830: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 827: ,p_attribute10 in varchar2 default hr_api.g_varchar2

823: ,p_attribute6 in varchar2 default hr_api.g_varchar2
824: ,p_attribute7 in varchar2 default hr_api.g_varchar2
825: ,p_attribute8 in varchar2 default hr_api.g_varchar2
826: ,p_attribute9 in varchar2 default hr_api.g_varchar2
827: ,p_attribute10 in varchar2 default hr_api.g_varchar2
828: ,p_attribute11 in varchar2 default hr_api.g_varchar2
829: ,p_attribute12 in varchar2 default hr_api.g_varchar2
830: ,p_attribute13 in varchar2 default hr_api.g_varchar2
831: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 828: ,p_attribute11 in varchar2 default hr_api.g_varchar2

824: ,p_attribute7 in varchar2 default hr_api.g_varchar2
825: ,p_attribute8 in varchar2 default hr_api.g_varchar2
826: ,p_attribute9 in varchar2 default hr_api.g_varchar2
827: ,p_attribute10 in varchar2 default hr_api.g_varchar2
828: ,p_attribute11 in varchar2 default hr_api.g_varchar2
829: ,p_attribute12 in varchar2 default hr_api.g_varchar2
830: ,p_attribute13 in varchar2 default hr_api.g_varchar2
831: ,p_attribute14 in varchar2 default hr_api.g_varchar2
832: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 829: ,p_attribute12 in varchar2 default hr_api.g_varchar2

825: ,p_attribute8 in varchar2 default hr_api.g_varchar2
826: ,p_attribute9 in varchar2 default hr_api.g_varchar2
827: ,p_attribute10 in varchar2 default hr_api.g_varchar2
828: ,p_attribute11 in varchar2 default hr_api.g_varchar2
829: ,p_attribute12 in varchar2 default hr_api.g_varchar2
830: ,p_attribute13 in varchar2 default hr_api.g_varchar2
831: ,p_attribute14 in varchar2 default hr_api.g_varchar2
832: ,p_attribute15 in varchar2 default hr_api.g_varchar2
833: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 830: ,p_attribute13 in varchar2 default hr_api.g_varchar2

826: ,p_attribute9 in varchar2 default hr_api.g_varchar2
827: ,p_attribute10 in varchar2 default hr_api.g_varchar2
828: ,p_attribute11 in varchar2 default hr_api.g_varchar2
829: ,p_attribute12 in varchar2 default hr_api.g_varchar2
830: ,p_attribute13 in varchar2 default hr_api.g_varchar2
831: ,p_attribute14 in varchar2 default hr_api.g_varchar2
832: ,p_attribute15 in varchar2 default hr_api.g_varchar2
833: ,p_attribute16 in varchar2 default hr_api.g_varchar2
834: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 831: ,p_attribute14 in varchar2 default hr_api.g_varchar2

827: ,p_attribute10 in varchar2 default hr_api.g_varchar2
828: ,p_attribute11 in varchar2 default hr_api.g_varchar2
829: ,p_attribute12 in varchar2 default hr_api.g_varchar2
830: ,p_attribute13 in varchar2 default hr_api.g_varchar2
831: ,p_attribute14 in varchar2 default hr_api.g_varchar2
832: ,p_attribute15 in varchar2 default hr_api.g_varchar2
833: ,p_attribute16 in varchar2 default hr_api.g_varchar2
834: ,p_attribute17 in varchar2 default hr_api.g_varchar2
835: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 832: ,p_attribute15 in varchar2 default hr_api.g_varchar2

828: ,p_attribute11 in varchar2 default hr_api.g_varchar2
829: ,p_attribute12 in varchar2 default hr_api.g_varchar2
830: ,p_attribute13 in varchar2 default hr_api.g_varchar2
831: ,p_attribute14 in varchar2 default hr_api.g_varchar2
832: ,p_attribute15 in varchar2 default hr_api.g_varchar2
833: ,p_attribute16 in varchar2 default hr_api.g_varchar2
834: ,p_attribute17 in varchar2 default hr_api.g_varchar2
835: ,p_attribute18 in varchar2 default hr_api.g_varchar2
836: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 833: ,p_attribute16 in varchar2 default hr_api.g_varchar2

829: ,p_attribute12 in varchar2 default hr_api.g_varchar2
830: ,p_attribute13 in varchar2 default hr_api.g_varchar2
831: ,p_attribute14 in varchar2 default hr_api.g_varchar2
832: ,p_attribute15 in varchar2 default hr_api.g_varchar2
833: ,p_attribute16 in varchar2 default hr_api.g_varchar2
834: ,p_attribute17 in varchar2 default hr_api.g_varchar2
835: ,p_attribute18 in varchar2 default hr_api.g_varchar2
836: ,p_attribute19 in varchar2 default hr_api.g_varchar2
837: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 834: ,p_attribute17 in varchar2 default hr_api.g_varchar2

830: ,p_attribute13 in varchar2 default hr_api.g_varchar2
831: ,p_attribute14 in varchar2 default hr_api.g_varchar2
832: ,p_attribute15 in varchar2 default hr_api.g_varchar2
833: ,p_attribute16 in varchar2 default hr_api.g_varchar2
834: ,p_attribute17 in varchar2 default hr_api.g_varchar2
835: ,p_attribute18 in varchar2 default hr_api.g_varchar2
836: ,p_attribute19 in varchar2 default hr_api.g_varchar2
837: ,p_attribute20 in varchar2 default hr_api.g_varchar2
838: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 835: ,p_attribute18 in varchar2 default hr_api.g_varchar2

831: ,p_attribute14 in varchar2 default hr_api.g_varchar2
832: ,p_attribute15 in varchar2 default hr_api.g_varchar2
833: ,p_attribute16 in varchar2 default hr_api.g_varchar2
834: ,p_attribute17 in varchar2 default hr_api.g_varchar2
835: ,p_attribute18 in varchar2 default hr_api.g_varchar2
836: ,p_attribute19 in varchar2 default hr_api.g_varchar2
837: ,p_attribute20 in varchar2 default hr_api.g_varchar2
838: ,p_information_category in varchar2 default hr_api.g_varchar2
839: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 836: ,p_attribute19 in varchar2 default hr_api.g_varchar2

832: ,p_attribute15 in varchar2 default hr_api.g_varchar2
833: ,p_attribute16 in varchar2 default hr_api.g_varchar2
834: ,p_attribute17 in varchar2 default hr_api.g_varchar2
835: ,p_attribute18 in varchar2 default hr_api.g_varchar2
836: ,p_attribute19 in varchar2 default hr_api.g_varchar2
837: ,p_attribute20 in varchar2 default hr_api.g_varchar2
838: ,p_information_category in varchar2 default hr_api.g_varchar2
839: ,p_information1 in varchar2 default hr_api.g_varchar2
840: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 837: ,p_attribute20 in varchar2 default hr_api.g_varchar2

833: ,p_attribute16 in varchar2 default hr_api.g_varchar2
834: ,p_attribute17 in varchar2 default hr_api.g_varchar2
835: ,p_attribute18 in varchar2 default hr_api.g_varchar2
836: ,p_attribute19 in varchar2 default hr_api.g_varchar2
837: ,p_attribute20 in varchar2 default hr_api.g_varchar2
838: ,p_information_category in varchar2 default hr_api.g_varchar2
839: ,p_information1 in varchar2 default hr_api.g_varchar2
840: ,p_information2 in varchar2 default hr_api.g_varchar2
841: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 838: ,p_information_category in varchar2 default hr_api.g_varchar2

834: ,p_attribute17 in varchar2 default hr_api.g_varchar2
835: ,p_attribute18 in varchar2 default hr_api.g_varchar2
836: ,p_attribute19 in varchar2 default hr_api.g_varchar2
837: ,p_attribute20 in varchar2 default hr_api.g_varchar2
838: ,p_information_category in varchar2 default hr_api.g_varchar2
839: ,p_information1 in varchar2 default hr_api.g_varchar2
840: ,p_information2 in varchar2 default hr_api.g_varchar2
841: ,p_information3 in varchar2 default hr_api.g_varchar2
842: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 839: ,p_information1 in varchar2 default hr_api.g_varchar2

835: ,p_attribute18 in varchar2 default hr_api.g_varchar2
836: ,p_attribute19 in varchar2 default hr_api.g_varchar2
837: ,p_attribute20 in varchar2 default hr_api.g_varchar2
838: ,p_information_category in varchar2 default hr_api.g_varchar2
839: ,p_information1 in varchar2 default hr_api.g_varchar2
840: ,p_information2 in varchar2 default hr_api.g_varchar2
841: ,p_information3 in varchar2 default hr_api.g_varchar2
842: ,p_information4 in varchar2 default hr_api.g_varchar2
843: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 840: ,p_information2 in varchar2 default hr_api.g_varchar2

836: ,p_attribute19 in varchar2 default hr_api.g_varchar2
837: ,p_attribute20 in varchar2 default hr_api.g_varchar2
838: ,p_information_category in varchar2 default hr_api.g_varchar2
839: ,p_information1 in varchar2 default hr_api.g_varchar2
840: ,p_information2 in varchar2 default hr_api.g_varchar2
841: ,p_information3 in varchar2 default hr_api.g_varchar2
842: ,p_information4 in varchar2 default hr_api.g_varchar2
843: ,p_information5 in varchar2 default hr_api.g_varchar2
844: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 841: ,p_information3 in varchar2 default hr_api.g_varchar2

837: ,p_attribute20 in varchar2 default hr_api.g_varchar2
838: ,p_information_category in varchar2 default hr_api.g_varchar2
839: ,p_information1 in varchar2 default hr_api.g_varchar2
840: ,p_information2 in varchar2 default hr_api.g_varchar2
841: ,p_information3 in varchar2 default hr_api.g_varchar2
842: ,p_information4 in varchar2 default hr_api.g_varchar2
843: ,p_information5 in varchar2 default hr_api.g_varchar2
844: ,p_information6 in varchar2 default hr_api.g_varchar2
845: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 842: ,p_information4 in varchar2 default hr_api.g_varchar2

838: ,p_information_category in varchar2 default hr_api.g_varchar2
839: ,p_information1 in varchar2 default hr_api.g_varchar2
840: ,p_information2 in varchar2 default hr_api.g_varchar2
841: ,p_information3 in varchar2 default hr_api.g_varchar2
842: ,p_information4 in varchar2 default hr_api.g_varchar2
843: ,p_information5 in varchar2 default hr_api.g_varchar2
844: ,p_information6 in varchar2 default hr_api.g_varchar2
845: ,p_information7 in varchar2 default hr_api.g_varchar2
846: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 843: ,p_information5 in varchar2 default hr_api.g_varchar2

839: ,p_information1 in varchar2 default hr_api.g_varchar2
840: ,p_information2 in varchar2 default hr_api.g_varchar2
841: ,p_information3 in varchar2 default hr_api.g_varchar2
842: ,p_information4 in varchar2 default hr_api.g_varchar2
843: ,p_information5 in varchar2 default hr_api.g_varchar2
844: ,p_information6 in varchar2 default hr_api.g_varchar2
845: ,p_information7 in varchar2 default hr_api.g_varchar2
846: ,p_information8 in varchar2 default hr_api.g_varchar2
847: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 844: ,p_information6 in varchar2 default hr_api.g_varchar2

840: ,p_information2 in varchar2 default hr_api.g_varchar2
841: ,p_information3 in varchar2 default hr_api.g_varchar2
842: ,p_information4 in varchar2 default hr_api.g_varchar2
843: ,p_information5 in varchar2 default hr_api.g_varchar2
844: ,p_information6 in varchar2 default hr_api.g_varchar2
845: ,p_information7 in varchar2 default hr_api.g_varchar2
846: ,p_information8 in varchar2 default hr_api.g_varchar2
847: ,p_information9 in varchar2 default hr_api.g_varchar2
848: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 845: ,p_information7 in varchar2 default hr_api.g_varchar2

841: ,p_information3 in varchar2 default hr_api.g_varchar2
842: ,p_information4 in varchar2 default hr_api.g_varchar2
843: ,p_information5 in varchar2 default hr_api.g_varchar2
844: ,p_information6 in varchar2 default hr_api.g_varchar2
845: ,p_information7 in varchar2 default hr_api.g_varchar2
846: ,p_information8 in varchar2 default hr_api.g_varchar2
847: ,p_information9 in varchar2 default hr_api.g_varchar2
848: ,p_information10 in varchar2 default hr_api.g_varchar2
849: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 846: ,p_information8 in varchar2 default hr_api.g_varchar2

842: ,p_information4 in varchar2 default hr_api.g_varchar2
843: ,p_information5 in varchar2 default hr_api.g_varchar2
844: ,p_information6 in varchar2 default hr_api.g_varchar2
845: ,p_information7 in varchar2 default hr_api.g_varchar2
846: ,p_information8 in varchar2 default hr_api.g_varchar2
847: ,p_information9 in varchar2 default hr_api.g_varchar2
848: ,p_information10 in varchar2 default hr_api.g_varchar2
849: ,p_information11 in varchar2 default hr_api.g_varchar2
850: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 847: ,p_information9 in varchar2 default hr_api.g_varchar2

843: ,p_information5 in varchar2 default hr_api.g_varchar2
844: ,p_information6 in varchar2 default hr_api.g_varchar2
845: ,p_information7 in varchar2 default hr_api.g_varchar2
846: ,p_information8 in varchar2 default hr_api.g_varchar2
847: ,p_information9 in varchar2 default hr_api.g_varchar2
848: ,p_information10 in varchar2 default hr_api.g_varchar2
849: ,p_information11 in varchar2 default hr_api.g_varchar2
850: ,p_information12 in varchar2 default hr_api.g_varchar2
851: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 848: ,p_information10 in varchar2 default hr_api.g_varchar2

844: ,p_information6 in varchar2 default hr_api.g_varchar2
845: ,p_information7 in varchar2 default hr_api.g_varchar2
846: ,p_information8 in varchar2 default hr_api.g_varchar2
847: ,p_information9 in varchar2 default hr_api.g_varchar2
848: ,p_information10 in varchar2 default hr_api.g_varchar2
849: ,p_information11 in varchar2 default hr_api.g_varchar2
850: ,p_information12 in varchar2 default hr_api.g_varchar2
851: ,p_information13 in varchar2 default hr_api.g_varchar2
852: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 849: ,p_information11 in varchar2 default hr_api.g_varchar2

845: ,p_information7 in varchar2 default hr_api.g_varchar2
846: ,p_information8 in varchar2 default hr_api.g_varchar2
847: ,p_information9 in varchar2 default hr_api.g_varchar2
848: ,p_information10 in varchar2 default hr_api.g_varchar2
849: ,p_information11 in varchar2 default hr_api.g_varchar2
850: ,p_information12 in varchar2 default hr_api.g_varchar2
851: ,p_information13 in varchar2 default hr_api.g_varchar2
852: ,p_information14 in varchar2 default hr_api.g_varchar2
853: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 850: ,p_information12 in varchar2 default hr_api.g_varchar2

846: ,p_information8 in varchar2 default hr_api.g_varchar2
847: ,p_information9 in varchar2 default hr_api.g_varchar2
848: ,p_information10 in varchar2 default hr_api.g_varchar2
849: ,p_information11 in varchar2 default hr_api.g_varchar2
850: ,p_information12 in varchar2 default hr_api.g_varchar2
851: ,p_information13 in varchar2 default hr_api.g_varchar2
852: ,p_information14 in varchar2 default hr_api.g_varchar2
853: ,p_information15 in varchar2 default hr_api.g_varchar2
854: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 851: ,p_information13 in varchar2 default hr_api.g_varchar2

847: ,p_information9 in varchar2 default hr_api.g_varchar2
848: ,p_information10 in varchar2 default hr_api.g_varchar2
849: ,p_information11 in varchar2 default hr_api.g_varchar2
850: ,p_information12 in varchar2 default hr_api.g_varchar2
851: ,p_information13 in varchar2 default hr_api.g_varchar2
852: ,p_information14 in varchar2 default hr_api.g_varchar2
853: ,p_information15 in varchar2 default hr_api.g_varchar2
854: ,p_information16 in varchar2 default hr_api.g_varchar2
855: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 852: ,p_information14 in varchar2 default hr_api.g_varchar2

848: ,p_information10 in varchar2 default hr_api.g_varchar2
849: ,p_information11 in varchar2 default hr_api.g_varchar2
850: ,p_information12 in varchar2 default hr_api.g_varchar2
851: ,p_information13 in varchar2 default hr_api.g_varchar2
852: ,p_information14 in varchar2 default hr_api.g_varchar2
853: ,p_information15 in varchar2 default hr_api.g_varchar2
854: ,p_information16 in varchar2 default hr_api.g_varchar2
855: ,p_information17 in varchar2 default hr_api.g_varchar2
856: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 853: ,p_information15 in varchar2 default hr_api.g_varchar2

849: ,p_information11 in varchar2 default hr_api.g_varchar2
850: ,p_information12 in varchar2 default hr_api.g_varchar2
851: ,p_information13 in varchar2 default hr_api.g_varchar2
852: ,p_information14 in varchar2 default hr_api.g_varchar2
853: ,p_information15 in varchar2 default hr_api.g_varchar2
854: ,p_information16 in varchar2 default hr_api.g_varchar2
855: ,p_information17 in varchar2 default hr_api.g_varchar2
856: ,p_information18 in varchar2 default hr_api.g_varchar2
857: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 854: ,p_information16 in varchar2 default hr_api.g_varchar2

850: ,p_information12 in varchar2 default hr_api.g_varchar2
851: ,p_information13 in varchar2 default hr_api.g_varchar2
852: ,p_information14 in varchar2 default hr_api.g_varchar2
853: ,p_information15 in varchar2 default hr_api.g_varchar2
854: ,p_information16 in varchar2 default hr_api.g_varchar2
855: ,p_information17 in varchar2 default hr_api.g_varchar2
856: ,p_information18 in varchar2 default hr_api.g_varchar2
857: ,p_information19 in varchar2 default hr_api.g_varchar2
858: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 855: ,p_information17 in varchar2 default hr_api.g_varchar2

851: ,p_information13 in varchar2 default hr_api.g_varchar2
852: ,p_information14 in varchar2 default hr_api.g_varchar2
853: ,p_information15 in varchar2 default hr_api.g_varchar2
854: ,p_information16 in varchar2 default hr_api.g_varchar2
855: ,p_information17 in varchar2 default hr_api.g_varchar2
856: ,p_information18 in varchar2 default hr_api.g_varchar2
857: ,p_information19 in varchar2 default hr_api.g_varchar2
858: ,p_information20 in varchar2 default hr_api.g_varchar2
859: ) is

Line 856: ,p_information18 in varchar2 default hr_api.g_varchar2

852: ,p_information14 in varchar2 default hr_api.g_varchar2
853: ,p_information15 in varchar2 default hr_api.g_varchar2
854: ,p_information16 in varchar2 default hr_api.g_varchar2
855: ,p_information17 in varchar2 default hr_api.g_varchar2
856: ,p_information18 in varchar2 default hr_api.g_varchar2
857: ,p_information19 in varchar2 default hr_api.g_varchar2
858: ,p_information20 in varchar2 default hr_api.g_varchar2
859: ) is
860: --

Line 857: ,p_information19 in varchar2 default hr_api.g_varchar2

853: ,p_information15 in varchar2 default hr_api.g_varchar2
854: ,p_information16 in varchar2 default hr_api.g_varchar2
855: ,p_information17 in varchar2 default hr_api.g_varchar2
856: ,p_information18 in varchar2 default hr_api.g_varchar2
857: ,p_information19 in varchar2 default hr_api.g_varchar2
858: ,p_information20 in varchar2 default hr_api.g_varchar2
859: ) is
860: --
861: l_rec per_grd_shd.g_rec_type;

Line 858: ,p_information20 in varchar2 default hr_api.g_varchar2

854: ,p_information16 in varchar2 default hr_api.g_varchar2
855: ,p_information17 in varchar2 default hr_api.g_varchar2
856: ,p_information18 in varchar2 default hr_api.g_varchar2
857: ,p_information19 in varchar2 default hr_api.g_varchar2
858: ,p_information20 in varchar2 default hr_api.g_varchar2
859: ) is
860: --
861: l_rec per_grd_shd.g_rec_type;
862: l_proc varchar2(72) := g_package||'upd';