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.PQP_VRI_UPD dependencies on HR_API

Line 139: When hr_api.check_integrity_violated Then

135: --
136: hr_utility.set_location(' Leaving:'||l_proc, 10);
137: --
138: Exception
139: When hr_api.check_integrity_violated Then
140: -- A check constraint has been violated
141: pqp_vri_shd.g_api_dml := false; -- Unset the api dml status
142: pqp_vri_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.check_integrity_violated Then
140: -- A check constraint has been violated
141: pqp_vri_shd.g_api_dml := false; -- Unset the api dml status
142: pqp_vri_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.parent_integrity_violated Then
145: -- Parent integrity has been violated
146: pqp_vri_shd.g_api_dml := false; -- Unset the api dml status
147: pqp_vri_shd.constraint_error

Line 144: When hr_api.parent_integrity_violated Then

140: -- A check constraint has been violated
141: pqp_vri_shd.g_api_dml := false; -- Unset the api dml status
142: pqp_vri_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.parent_integrity_violated Then
145: -- Parent integrity has been violated
146: pqp_vri_shd.g_api_dml := false; -- Unset the api dml status
147: pqp_vri_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.parent_integrity_violated Then
145: -- Parent integrity has been violated
146: pqp_vri_shd.g_api_dml := false; -- Unset the api dml status
147: pqp_vri_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: pqp_vri_shd.g_api_dml := false; -- Unset the api dml status
152: pqp_vri_shd.constraint_error

Line 149: When hr_api.unique_integrity_violated Then

145: -- Parent integrity has been violated
146: pqp_vri_shd.g_api_dml := false; -- Unset the api dml status
147: pqp_vri_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: pqp_vri_shd.g_api_dml := false; -- Unset the api dml status
152: pqp_vri_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: pqp_vri_shd.g_api_dml := false; -- Unset the api dml status
152: pqp_vri_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When Others Then
155: pqp_vri_shd.g_api_dml := false; -- Unset the api dml status
156: Raise;
157: End update_dml;

Line 488: when hr_api.cannot_find_prog_unit then

484: );
485: --
486: exception
487: --
488: when hr_api.cannot_find_prog_unit then
489: --
490: hr_api.cannot_find_prog_unit_error
491: (p_module_name => 'PQP_VEH_REPOS_EXTRA_INFO'
492: ,p_hook_type => 'AU');

Line 490: hr_api.cannot_find_prog_unit_error

486: exception
487: --
488: when hr_api.cannot_find_prog_unit then
489: --
490: hr_api.cannot_find_prog_unit_error
491: (p_module_name => 'PQP_VEH_REPOS_EXTRA_INFO'
492: ,p_hook_type => 'AU');
493: --
494: end;

Line 553: If (p_rec.vehicle_repository_id = hr_api.g_number) then

549: -- p_rec plsql record structure
550: -- to see if a system default is being used. If a system default
551: -- is being used then we must set to the 'current' argument value.
552: --
553: If (p_rec.vehicle_repository_id = hr_api.g_number) then
554: p_rec.vehicle_repository_id :=
555: pqp_vri_shd.g_old_rec.vehicle_repository_id;
556: End If;
557: If (p_rec.information_type = hr_api.g_varchar2) then

Line 557: If (p_rec.information_type = hr_api.g_varchar2) then

553: If (p_rec.vehicle_repository_id = hr_api.g_number) then
554: p_rec.vehicle_repository_id :=
555: pqp_vri_shd.g_old_rec.vehicle_repository_id;
556: End If;
557: If (p_rec.information_type = hr_api.g_varchar2) then
558: p_rec.information_type :=
559: pqp_vri_shd.g_old_rec.information_type;
560: End If;
561: If (p_rec.vrei_attribute_category = hr_api.g_varchar2) then

Line 561: If (p_rec.vrei_attribute_category = hr_api.g_varchar2) then

557: If (p_rec.information_type = hr_api.g_varchar2) then
558: p_rec.information_type :=
559: pqp_vri_shd.g_old_rec.information_type;
560: End If;
561: If (p_rec.vrei_attribute_category = hr_api.g_varchar2) then
562: p_rec.vrei_attribute_category :=
563: pqp_vri_shd.g_old_rec.vrei_attribute_category;
564: End If;
565: If (p_rec.vrei_attribute1 = hr_api.g_varchar2) then

Line 565: If (p_rec.vrei_attribute1 = hr_api.g_varchar2) then

561: If (p_rec.vrei_attribute_category = hr_api.g_varchar2) then
562: p_rec.vrei_attribute_category :=
563: pqp_vri_shd.g_old_rec.vrei_attribute_category;
564: End If;
565: If (p_rec.vrei_attribute1 = hr_api.g_varchar2) then
566: p_rec.vrei_attribute1 :=
567: pqp_vri_shd.g_old_rec.vrei_attribute1;
568: End If;
569: If (p_rec.vrei_attribute2 = hr_api.g_varchar2) then

Line 569: If (p_rec.vrei_attribute2 = hr_api.g_varchar2) then

565: If (p_rec.vrei_attribute1 = hr_api.g_varchar2) then
566: p_rec.vrei_attribute1 :=
567: pqp_vri_shd.g_old_rec.vrei_attribute1;
568: End If;
569: If (p_rec.vrei_attribute2 = hr_api.g_varchar2) then
570: p_rec.vrei_attribute2 :=
571: pqp_vri_shd.g_old_rec.vrei_attribute2;
572: End If;
573: If (p_rec.vrei_attribute3 = hr_api.g_varchar2) then

Line 573: If (p_rec.vrei_attribute3 = hr_api.g_varchar2) then

569: If (p_rec.vrei_attribute2 = hr_api.g_varchar2) then
570: p_rec.vrei_attribute2 :=
571: pqp_vri_shd.g_old_rec.vrei_attribute2;
572: End If;
573: If (p_rec.vrei_attribute3 = hr_api.g_varchar2) then
574: p_rec.vrei_attribute3 :=
575: pqp_vri_shd.g_old_rec.vrei_attribute3;
576: End If;
577: If (p_rec.vrei_attribute4 = hr_api.g_varchar2) then

Line 577: If (p_rec.vrei_attribute4 = hr_api.g_varchar2) then

573: If (p_rec.vrei_attribute3 = hr_api.g_varchar2) then
574: p_rec.vrei_attribute3 :=
575: pqp_vri_shd.g_old_rec.vrei_attribute3;
576: End If;
577: If (p_rec.vrei_attribute4 = hr_api.g_varchar2) then
578: p_rec.vrei_attribute4 :=
579: pqp_vri_shd.g_old_rec.vrei_attribute4;
580: End If;
581: If (p_rec.vrei_attribute5 = hr_api.g_varchar2) then

Line 581: If (p_rec.vrei_attribute5 = hr_api.g_varchar2) then

577: If (p_rec.vrei_attribute4 = hr_api.g_varchar2) then
578: p_rec.vrei_attribute4 :=
579: pqp_vri_shd.g_old_rec.vrei_attribute4;
580: End If;
581: If (p_rec.vrei_attribute5 = hr_api.g_varchar2) then
582: p_rec.vrei_attribute5 :=
583: pqp_vri_shd.g_old_rec.vrei_attribute5;
584: End If;
585: If (p_rec.vrei_attribute6 = hr_api.g_varchar2) then

Line 585: If (p_rec.vrei_attribute6 = hr_api.g_varchar2) then

581: If (p_rec.vrei_attribute5 = hr_api.g_varchar2) then
582: p_rec.vrei_attribute5 :=
583: pqp_vri_shd.g_old_rec.vrei_attribute5;
584: End If;
585: If (p_rec.vrei_attribute6 = hr_api.g_varchar2) then
586: p_rec.vrei_attribute6 :=
587: pqp_vri_shd.g_old_rec.vrei_attribute6;
588: End If;
589: If (p_rec.vrei_attribute7 = hr_api.g_varchar2) then

Line 589: If (p_rec.vrei_attribute7 = hr_api.g_varchar2) then

585: If (p_rec.vrei_attribute6 = hr_api.g_varchar2) then
586: p_rec.vrei_attribute6 :=
587: pqp_vri_shd.g_old_rec.vrei_attribute6;
588: End If;
589: If (p_rec.vrei_attribute7 = hr_api.g_varchar2) then
590: p_rec.vrei_attribute7 :=
591: pqp_vri_shd.g_old_rec.vrei_attribute7;
592: End If;
593: If (p_rec.vrei_attribute8 = hr_api.g_varchar2) then

Line 593: If (p_rec.vrei_attribute8 = hr_api.g_varchar2) then

589: If (p_rec.vrei_attribute7 = hr_api.g_varchar2) then
590: p_rec.vrei_attribute7 :=
591: pqp_vri_shd.g_old_rec.vrei_attribute7;
592: End If;
593: If (p_rec.vrei_attribute8 = hr_api.g_varchar2) then
594: p_rec.vrei_attribute8 :=
595: pqp_vri_shd.g_old_rec.vrei_attribute8;
596: End If;
597: If (p_rec.vrei_attribute9 = hr_api.g_varchar2) then

Line 597: If (p_rec.vrei_attribute9 = hr_api.g_varchar2) then

593: If (p_rec.vrei_attribute8 = hr_api.g_varchar2) then
594: p_rec.vrei_attribute8 :=
595: pqp_vri_shd.g_old_rec.vrei_attribute8;
596: End If;
597: If (p_rec.vrei_attribute9 = hr_api.g_varchar2) then
598: p_rec.vrei_attribute9 :=
599: pqp_vri_shd.g_old_rec.vrei_attribute9;
600: End If;
601: If (p_rec.vrei_attribute10 = hr_api.g_varchar2) then

Line 601: If (p_rec.vrei_attribute10 = hr_api.g_varchar2) then

597: If (p_rec.vrei_attribute9 = hr_api.g_varchar2) then
598: p_rec.vrei_attribute9 :=
599: pqp_vri_shd.g_old_rec.vrei_attribute9;
600: End If;
601: If (p_rec.vrei_attribute10 = hr_api.g_varchar2) then
602: p_rec.vrei_attribute10 :=
603: pqp_vri_shd.g_old_rec.vrei_attribute10;
604: End If;
605: If (p_rec.vrei_attribute11 = hr_api.g_varchar2) then

Line 605: If (p_rec.vrei_attribute11 = hr_api.g_varchar2) then

601: If (p_rec.vrei_attribute10 = hr_api.g_varchar2) then
602: p_rec.vrei_attribute10 :=
603: pqp_vri_shd.g_old_rec.vrei_attribute10;
604: End If;
605: If (p_rec.vrei_attribute11 = hr_api.g_varchar2) then
606: p_rec.vrei_attribute11 :=
607: pqp_vri_shd.g_old_rec.vrei_attribute11;
608: End If;
609: If (p_rec.vrei_attribute12 = hr_api.g_varchar2) then

Line 609: If (p_rec.vrei_attribute12 = hr_api.g_varchar2) then

605: If (p_rec.vrei_attribute11 = hr_api.g_varchar2) then
606: p_rec.vrei_attribute11 :=
607: pqp_vri_shd.g_old_rec.vrei_attribute11;
608: End If;
609: If (p_rec.vrei_attribute12 = hr_api.g_varchar2) then
610: p_rec.vrei_attribute12 :=
611: pqp_vri_shd.g_old_rec.vrei_attribute12;
612: End If;
613: If (p_rec.vrei_attribute13 = hr_api.g_varchar2) then

Line 613: If (p_rec.vrei_attribute13 = hr_api.g_varchar2) then

609: If (p_rec.vrei_attribute12 = hr_api.g_varchar2) then
610: p_rec.vrei_attribute12 :=
611: pqp_vri_shd.g_old_rec.vrei_attribute12;
612: End If;
613: If (p_rec.vrei_attribute13 = hr_api.g_varchar2) then
614: p_rec.vrei_attribute13 :=
615: pqp_vri_shd.g_old_rec.vrei_attribute13;
616: End If;
617: If (p_rec.vrei_attribute14 = hr_api.g_varchar2) then

Line 617: If (p_rec.vrei_attribute14 = hr_api.g_varchar2) then

613: If (p_rec.vrei_attribute13 = hr_api.g_varchar2) then
614: p_rec.vrei_attribute13 :=
615: pqp_vri_shd.g_old_rec.vrei_attribute13;
616: End If;
617: If (p_rec.vrei_attribute14 = hr_api.g_varchar2) then
618: p_rec.vrei_attribute14 :=
619: pqp_vri_shd.g_old_rec.vrei_attribute14;
620: End If;
621: If (p_rec.vrei_attribute15 = hr_api.g_varchar2) then

Line 621: If (p_rec.vrei_attribute15 = hr_api.g_varchar2) then

617: If (p_rec.vrei_attribute14 = hr_api.g_varchar2) then
618: p_rec.vrei_attribute14 :=
619: pqp_vri_shd.g_old_rec.vrei_attribute14;
620: End If;
621: If (p_rec.vrei_attribute15 = hr_api.g_varchar2) then
622: p_rec.vrei_attribute15 :=
623: pqp_vri_shd.g_old_rec.vrei_attribute15;
624: End If;
625: If (p_rec.vrei_attribute16 = hr_api.g_varchar2) then

Line 625: If (p_rec.vrei_attribute16 = hr_api.g_varchar2) then

621: If (p_rec.vrei_attribute15 = hr_api.g_varchar2) then
622: p_rec.vrei_attribute15 :=
623: pqp_vri_shd.g_old_rec.vrei_attribute15;
624: End If;
625: If (p_rec.vrei_attribute16 = hr_api.g_varchar2) then
626: p_rec.vrei_attribute16 :=
627: pqp_vri_shd.g_old_rec.vrei_attribute16;
628: End If;
629: If (p_rec.vrei_attribute17 = hr_api.g_varchar2) then

Line 629: If (p_rec.vrei_attribute17 = hr_api.g_varchar2) then

625: If (p_rec.vrei_attribute16 = hr_api.g_varchar2) then
626: p_rec.vrei_attribute16 :=
627: pqp_vri_shd.g_old_rec.vrei_attribute16;
628: End If;
629: If (p_rec.vrei_attribute17 = hr_api.g_varchar2) then
630: p_rec.vrei_attribute17 :=
631: pqp_vri_shd.g_old_rec.vrei_attribute17;
632: End If;
633: If (p_rec.vrei_attribute18 = hr_api.g_varchar2) then

Line 633: If (p_rec.vrei_attribute18 = hr_api.g_varchar2) then

629: If (p_rec.vrei_attribute17 = hr_api.g_varchar2) then
630: p_rec.vrei_attribute17 :=
631: pqp_vri_shd.g_old_rec.vrei_attribute17;
632: End If;
633: If (p_rec.vrei_attribute18 = hr_api.g_varchar2) then
634: p_rec.vrei_attribute18 :=
635: pqp_vri_shd.g_old_rec.vrei_attribute18;
636: End If;
637: If (p_rec.vrei_attribute19 = hr_api.g_varchar2) then

Line 637: If (p_rec.vrei_attribute19 = hr_api.g_varchar2) then

633: If (p_rec.vrei_attribute18 = hr_api.g_varchar2) then
634: p_rec.vrei_attribute18 :=
635: pqp_vri_shd.g_old_rec.vrei_attribute18;
636: End If;
637: If (p_rec.vrei_attribute19 = hr_api.g_varchar2) then
638: p_rec.vrei_attribute19 :=
639: pqp_vri_shd.g_old_rec.vrei_attribute19;
640: End If;
641: If (p_rec.vrei_attribute20 = hr_api.g_varchar2) then

Line 641: If (p_rec.vrei_attribute20 = hr_api.g_varchar2) then

637: If (p_rec.vrei_attribute19 = hr_api.g_varchar2) then
638: p_rec.vrei_attribute19 :=
639: pqp_vri_shd.g_old_rec.vrei_attribute19;
640: End If;
641: If (p_rec.vrei_attribute20 = hr_api.g_varchar2) then
642: p_rec.vrei_attribute20 :=
643: pqp_vri_shd.g_old_rec.vrei_attribute20;
644: End If;
645: If (p_rec.vrei_information_category = hr_api.g_varchar2) then

Line 645: If (p_rec.vrei_information_category = hr_api.g_varchar2) then

641: If (p_rec.vrei_attribute20 = hr_api.g_varchar2) then
642: p_rec.vrei_attribute20 :=
643: pqp_vri_shd.g_old_rec.vrei_attribute20;
644: End If;
645: If (p_rec.vrei_information_category = hr_api.g_varchar2) then
646: p_rec.vrei_information_category :=
647: pqp_vri_shd.g_old_rec.vrei_information_category;
648: End If;
649: If (p_rec.vrei_information1 = hr_api.g_varchar2) then

Line 649: If (p_rec.vrei_information1 = hr_api.g_varchar2) then

645: If (p_rec.vrei_information_category = hr_api.g_varchar2) then
646: p_rec.vrei_information_category :=
647: pqp_vri_shd.g_old_rec.vrei_information_category;
648: End If;
649: If (p_rec.vrei_information1 = hr_api.g_varchar2) then
650: p_rec.vrei_information1 :=
651: pqp_vri_shd.g_old_rec.vrei_information1;
652: End If;
653: If (p_rec.vrei_information2 = hr_api.g_varchar2) then

Line 653: If (p_rec.vrei_information2 = hr_api.g_varchar2) then

649: If (p_rec.vrei_information1 = hr_api.g_varchar2) then
650: p_rec.vrei_information1 :=
651: pqp_vri_shd.g_old_rec.vrei_information1;
652: End If;
653: If (p_rec.vrei_information2 = hr_api.g_varchar2) then
654: p_rec.vrei_information2 :=
655: pqp_vri_shd.g_old_rec.vrei_information2;
656: End If;
657: If (p_rec.vrei_information3 = hr_api.g_varchar2) then

Line 657: If (p_rec.vrei_information3 = hr_api.g_varchar2) then

653: If (p_rec.vrei_information2 = hr_api.g_varchar2) then
654: p_rec.vrei_information2 :=
655: pqp_vri_shd.g_old_rec.vrei_information2;
656: End If;
657: If (p_rec.vrei_information3 = hr_api.g_varchar2) then
658: p_rec.vrei_information3 :=
659: pqp_vri_shd.g_old_rec.vrei_information3;
660: End If;
661: If (p_rec.vrei_information4 = hr_api.g_varchar2) then

Line 661: If (p_rec.vrei_information4 = hr_api.g_varchar2) then

657: If (p_rec.vrei_information3 = hr_api.g_varchar2) then
658: p_rec.vrei_information3 :=
659: pqp_vri_shd.g_old_rec.vrei_information3;
660: End If;
661: If (p_rec.vrei_information4 = hr_api.g_varchar2) then
662: p_rec.vrei_information4 :=
663: pqp_vri_shd.g_old_rec.vrei_information4;
664: End If;
665: If (p_rec.vrei_information5 = hr_api.g_varchar2) then

Line 665: If (p_rec.vrei_information5 = hr_api.g_varchar2) then

661: If (p_rec.vrei_information4 = hr_api.g_varchar2) then
662: p_rec.vrei_information4 :=
663: pqp_vri_shd.g_old_rec.vrei_information4;
664: End If;
665: If (p_rec.vrei_information5 = hr_api.g_varchar2) then
666: p_rec.vrei_information5 :=
667: pqp_vri_shd.g_old_rec.vrei_information5;
668: End If;
669: If (p_rec.vrei_information6 = hr_api.g_varchar2) then

Line 669: If (p_rec.vrei_information6 = hr_api.g_varchar2) then

665: If (p_rec.vrei_information5 = hr_api.g_varchar2) then
666: p_rec.vrei_information5 :=
667: pqp_vri_shd.g_old_rec.vrei_information5;
668: End If;
669: If (p_rec.vrei_information6 = hr_api.g_varchar2) then
670: p_rec.vrei_information6 :=
671: pqp_vri_shd.g_old_rec.vrei_information6;
672: End If;
673: If (p_rec.vrei_information7 = hr_api.g_varchar2) then

Line 673: If (p_rec.vrei_information7 = hr_api.g_varchar2) then

669: If (p_rec.vrei_information6 = hr_api.g_varchar2) then
670: p_rec.vrei_information6 :=
671: pqp_vri_shd.g_old_rec.vrei_information6;
672: End If;
673: If (p_rec.vrei_information7 = hr_api.g_varchar2) then
674: p_rec.vrei_information7 :=
675: pqp_vri_shd.g_old_rec.vrei_information7;
676: End If;
677: If (p_rec.vrei_information8 = hr_api.g_varchar2) then

Line 677: If (p_rec.vrei_information8 = hr_api.g_varchar2) then

673: If (p_rec.vrei_information7 = hr_api.g_varchar2) then
674: p_rec.vrei_information7 :=
675: pqp_vri_shd.g_old_rec.vrei_information7;
676: End If;
677: If (p_rec.vrei_information8 = hr_api.g_varchar2) then
678: p_rec.vrei_information8 :=
679: pqp_vri_shd.g_old_rec.vrei_information8;
680: End If;
681: If (p_rec.vrei_information9 = hr_api.g_varchar2) then

Line 681: If (p_rec.vrei_information9 = hr_api.g_varchar2) then

677: If (p_rec.vrei_information8 = hr_api.g_varchar2) then
678: p_rec.vrei_information8 :=
679: pqp_vri_shd.g_old_rec.vrei_information8;
680: End If;
681: If (p_rec.vrei_information9 = hr_api.g_varchar2) then
682: p_rec.vrei_information9 :=
683: pqp_vri_shd.g_old_rec.vrei_information9;
684: End If;
685: If (p_rec.vrei_information10 = hr_api.g_varchar2) then

Line 685: If (p_rec.vrei_information10 = hr_api.g_varchar2) then

681: If (p_rec.vrei_information9 = hr_api.g_varchar2) then
682: p_rec.vrei_information9 :=
683: pqp_vri_shd.g_old_rec.vrei_information9;
684: End If;
685: If (p_rec.vrei_information10 = hr_api.g_varchar2) then
686: p_rec.vrei_information10 :=
687: pqp_vri_shd.g_old_rec.vrei_information10;
688: End If;
689: If (p_rec.vrei_information11 = hr_api.g_varchar2) then

Line 689: If (p_rec.vrei_information11 = hr_api.g_varchar2) then

685: If (p_rec.vrei_information10 = hr_api.g_varchar2) then
686: p_rec.vrei_information10 :=
687: pqp_vri_shd.g_old_rec.vrei_information10;
688: End If;
689: If (p_rec.vrei_information11 = hr_api.g_varchar2) then
690: p_rec.vrei_information11 :=
691: pqp_vri_shd.g_old_rec.vrei_information11;
692: End If;
693: If (p_rec.vrei_information12 = hr_api.g_varchar2) then

Line 693: If (p_rec.vrei_information12 = hr_api.g_varchar2) then

689: If (p_rec.vrei_information11 = hr_api.g_varchar2) then
690: p_rec.vrei_information11 :=
691: pqp_vri_shd.g_old_rec.vrei_information11;
692: End If;
693: If (p_rec.vrei_information12 = hr_api.g_varchar2) then
694: p_rec.vrei_information12 :=
695: pqp_vri_shd.g_old_rec.vrei_information12;
696: End If;
697: If (p_rec.vrei_information13 = hr_api.g_varchar2) then

Line 697: If (p_rec.vrei_information13 = hr_api.g_varchar2) then

693: If (p_rec.vrei_information12 = hr_api.g_varchar2) then
694: p_rec.vrei_information12 :=
695: pqp_vri_shd.g_old_rec.vrei_information12;
696: End If;
697: If (p_rec.vrei_information13 = hr_api.g_varchar2) then
698: p_rec.vrei_information13 :=
699: pqp_vri_shd.g_old_rec.vrei_information13;
700: End If;
701: If (p_rec.vrei_information14 = hr_api.g_varchar2) then

Line 701: If (p_rec.vrei_information14 = hr_api.g_varchar2) then

697: If (p_rec.vrei_information13 = hr_api.g_varchar2) then
698: p_rec.vrei_information13 :=
699: pqp_vri_shd.g_old_rec.vrei_information13;
700: End If;
701: If (p_rec.vrei_information14 = hr_api.g_varchar2) then
702: p_rec.vrei_information14 :=
703: pqp_vri_shd.g_old_rec.vrei_information14;
704: End If;
705: If (p_rec.vrei_information15 = hr_api.g_varchar2) then

Line 705: If (p_rec.vrei_information15 = hr_api.g_varchar2) then

701: If (p_rec.vrei_information14 = hr_api.g_varchar2) then
702: p_rec.vrei_information14 :=
703: pqp_vri_shd.g_old_rec.vrei_information14;
704: End If;
705: If (p_rec.vrei_information15 = hr_api.g_varchar2) then
706: p_rec.vrei_information15 :=
707: pqp_vri_shd.g_old_rec.vrei_information15;
708: End If;
709: If (p_rec.vrei_information16 = hr_api.g_varchar2) then

Line 709: If (p_rec.vrei_information16 = hr_api.g_varchar2) then

705: If (p_rec.vrei_information15 = hr_api.g_varchar2) then
706: p_rec.vrei_information15 :=
707: pqp_vri_shd.g_old_rec.vrei_information15;
708: End If;
709: If (p_rec.vrei_information16 = hr_api.g_varchar2) then
710: p_rec.vrei_information16 :=
711: pqp_vri_shd.g_old_rec.vrei_information16;
712: End If;
713: If (p_rec.vrei_information17 = hr_api.g_varchar2) then

Line 713: If (p_rec.vrei_information17 = hr_api.g_varchar2) then

709: If (p_rec.vrei_information16 = hr_api.g_varchar2) then
710: p_rec.vrei_information16 :=
711: pqp_vri_shd.g_old_rec.vrei_information16;
712: End If;
713: If (p_rec.vrei_information17 = hr_api.g_varchar2) then
714: p_rec.vrei_information17 :=
715: pqp_vri_shd.g_old_rec.vrei_information17;
716: End If;
717: If (p_rec.vrei_information18 = hr_api.g_varchar2) then

Line 717: If (p_rec.vrei_information18 = hr_api.g_varchar2) then

713: If (p_rec.vrei_information17 = hr_api.g_varchar2) then
714: p_rec.vrei_information17 :=
715: pqp_vri_shd.g_old_rec.vrei_information17;
716: End If;
717: If (p_rec.vrei_information18 = hr_api.g_varchar2) then
718: p_rec.vrei_information18 :=
719: pqp_vri_shd.g_old_rec.vrei_information18;
720: End If;
721: If (p_rec.vrei_information19 = hr_api.g_varchar2) then

Line 721: If (p_rec.vrei_information19 = hr_api.g_varchar2) then

717: If (p_rec.vrei_information18 = hr_api.g_varchar2) then
718: p_rec.vrei_information18 :=
719: pqp_vri_shd.g_old_rec.vrei_information18;
720: End If;
721: If (p_rec.vrei_information19 = hr_api.g_varchar2) then
722: p_rec.vrei_information19 :=
723: pqp_vri_shd.g_old_rec.vrei_information19;
724: End If;
725: If (p_rec.vrei_information20 = hr_api.g_varchar2) then

Line 725: If (p_rec.vrei_information20 = hr_api.g_varchar2) then

721: If (p_rec.vrei_information19 = hr_api.g_varchar2) then
722: p_rec.vrei_information19 :=
723: pqp_vri_shd.g_old_rec.vrei_information19;
724: End If;
725: If (p_rec.vrei_information20 = hr_api.g_varchar2) then
726: p_rec.vrei_information20 :=
727: pqp_vri_shd.g_old_rec.vrei_information20;
728: End If;
729: If (p_rec.vrei_information21 = hr_api.g_varchar2) then

Line 729: If (p_rec.vrei_information21 = hr_api.g_varchar2) then

725: If (p_rec.vrei_information20 = hr_api.g_varchar2) then
726: p_rec.vrei_information20 :=
727: pqp_vri_shd.g_old_rec.vrei_information20;
728: End If;
729: If (p_rec.vrei_information21 = hr_api.g_varchar2) then
730: p_rec.vrei_information21 :=
731: pqp_vri_shd.g_old_rec.vrei_information21;
732: End If;
733: If (p_rec.vrei_information22 = hr_api.g_varchar2) then

Line 733: If (p_rec.vrei_information22 = hr_api.g_varchar2) then

729: If (p_rec.vrei_information21 = hr_api.g_varchar2) then
730: p_rec.vrei_information21 :=
731: pqp_vri_shd.g_old_rec.vrei_information21;
732: End If;
733: If (p_rec.vrei_information22 = hr_api.g_varchar2) then
734: p_rec.vrei_information22 :=
735: pqp_vri_shd.g_old_rec.vrei_information22;
736: End If;
737: If (p_rec.vrei_information23 = hr_api.g_varchar2) then

Line 737: If (p_rec.vrei_information23 = hr_api.g_varchar2) then

733: If (p_rec.vrei_information22 = hr_api.g_varchar2) then
734: p_rec.vrei_information22 :=
735: pqp_vri_shd.g_old_rec.vrei_information22;
736: End If;
737: If (p_rec.vrei_information23 = hr_api.g_varchar2) then
738: p_rec.vrei_information23 :=
739: pqp_vri_shd.g_old_rec.vrei_information23;
740: End If;
741: If (p_rec.vrei_information24 = hr_api.g_varchar2) then

Line 741: If (p_rec.vrei_information24 = hr_api.g_varchar2) then

737: If (p_rec.vrei_information23 = hr_api.g_varchar2) then
738: p_rec.vrei_information23 :=
739: pqp_vri_shd.g_old_rec.vrei_information23;
740: End If;
741: If (p_rec.vrei_information24 = hr_api.g_varchar2) then
742: p_rec.vrei_information24 :=
743: pqp_vri_shd.g_old_rec.vrei_information24;
744: End If;
745: If (p_rec.vrei_information25 = hr_api.g_varchar2) then

Line 745: If (p_rec.vrei_information25 = hr_api.g_varchar2) then

741: If (p_rec.vrei_information24 = hr_api.g_varchar2) then
742: p_rec.vrei_information24 :=
743: pqp_vri_shd.g_old_rec.vrei_information24;
744: End If;
745: If (p_rec.vrei_information25 = hr_api.g_varchar2) then
746: p_rec.vrei_information25 :=
747: pqp_vri_shd.g_old_rec.vrei_information25;
748: End If;
749: If (p_rec.vrei_information26 = hr_api.g_varchar2) then

Line 749: If (p_rec.vrei_information26 = hr_api.g_varchar2) then

745: If (p_rec.vrei_information25 = hr_api.g_varchar2) then
746: p_rec.vrei_information25 :=
747: pqp_vri_shd.g_old_rec.vrei_information25;
748: End If;
749: If (p_rec.vrei_information26 = hr_api.g_varchar2) then
750: p_rec.vrei_information26 :=
751: pqp_vri_shd.g_old_rec.vrei_information26;
752: End If;
753: If (p_rec.vrei_information27 = hr_api.g_varchar2) then

Line 753: If (p_rec.vrei_information27 = hr_api.g_varchar2) then

749: If (p_rec.vrei_information26 = hr_api.g_varchar2) then
750: p_rec.vrei_information26 :=
751: pqp_vri_shd.g_old_rec.vrei_information26;
752: End If;
753: If (p_rec.vrei_information27 = hr_api.g_varchar2) then
754: p_rec.vrei_information27 :=
755: pqp_vri_shd.g_old_rec.vrei_information27;
756: End If;
757: If (p_rec.vrei_information28 = hr_api.g_varchar2) then

Line 757: If (p_rec.vrei_information28 = hr_api.g_varchar2) then

753: If (p_rec.vrei_information27 = hr_api.g_varchar2) then
754: p_rec.vrei_information27 :=
755: pqp_vri_shd.g_old_rec.vrei_information27;
756: End If;
757: If (p_rec.vrei_information28 = hr_api.g_varchar2) then
758: p_rec.vrei_information28 :=
759: pqp_vri_shd.g_old_rec.vrei_information28;
760: End If;
761: If (p_rec.vrei_information29 = hr_api.g_varchar2) then

Line 761: If (p_rec.vrei_information29 = hr_api.g_varchar2) then

757: If (p_rec.vrei_information28 = hr_api.g_varchar2) then
758: p_rec.vrei_information28 :=
759: pqp_vri_shd.g_old_rec.vrei_information28;
760: End If;
761: If (p_rec.vrei_information29 = hr_api.g_varchar2) then
762: p_rec.vrei_information29 :=
763: pqp_vri_shd.g_old_rec.vrei_information29;
764: End If;
765: If (p_rec.vrei_information30 = hr_api.g_varchar2) then

Line 765: If (p_rec.vrei_information30 = hr_api.g_varchar2) then

761: If (p_rec.vrei_information29 = hr_api.g_varchar2) then
762: p_rec.vrei_information29 :=
763: pqp_vri_shd.g_old_rec.vrei_information29;
764: End If;
765: If (p_rec.vrei_information30 = hr_api.g_varchar2) then
766: p_rec.vrei_information30 :=
767: pqp_vri_shd.g_old_rec.vrei_information30;
768: End If;
769: If (p_rec.request_id = hr_api.g_number) then

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

765: If (p_rec.vrei_information30 = hr_api.g_varchar2) then
766: p_rec.vrei_information30 :=
767: pqp_vri_shd.g_old_rec.vrei_information30;
768: End If;
769: If (p_rec.request_id = hr_api.g_number) then
770: p_rec.request_id :=
771: pqp_vri_shd.g_old_rec.request_id;
772: End If;
773: If (p_rec.program_application_id = hr_api.g_number) then

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

769: If (p_rec.request_id = hr_api.g_number) then
770: p_rec.request_id :=
771: pqp_vri_shd.g_old_rec.request_id;
772: End If;
773: If (p_rec.program_application_id = hr_api.g_number) then
774: p_rec.program_application_id :=
775: pqp_vri_shd.g_old_rec.program_application_id;
776: End If;
777: If (p_rec.program_id = hr_api.g_number) then

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

773: If (p_rec.program_application_id = hr_api.g_number) then
774: p_rec.program_application_id :=
775: pqp_vri_shd.g_old_rec.program_application_id;
776: End If;
777: If (p_rec.program_id = hr_api.g_number) then
778: p_rec.program_id :=
779: pqp_vri_shd.g_old_rec.program_id;
780: End If;
781: If (p_rec.program_update_date = hr_api.g_date) then

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

777: If (p_rec.program_id = hr_api.g_number) then
778: p_rec.program_id :=
779: pqp_vri_shd.g_old_rec.program_id;
780: End If;
781: If (p_rec.program_update_date = hr_api.g_date) then
782: p_rec.program_update_date :=
783: pqp_vri_shd.g_old_rec.program_update_date;
784: End If;
785: --

Line 845: ,p_vehicle_repository_id in number default hr_api.g_number

841: -- ----------------------------------------------------------------------------
842: Procedure upd
843: (p_veh_repos_extra_info_id in number
844: ,p_object_version_number in out nocopy number
845: ,p_vehicle_repository_id in number default hr_api.g_number
846: ,p_information_type in varchar2 default hr_api.g_varchar2
847: ,p_vrei_attribute_category in varchar2 default hr_api.g_varchar2
848: ,p_vrei_attribute1 in varchar2 default hr_api.g_varchar2
849: ,p_vrei_attribute2 in varchar2 default hr_api.g_varchar2

Line 846: ,p_information_type in varchar2 default hr_api.g_varchar2

842: Procedure upd
843: (p_veh_repos_extra_info_id in number
844: ,p_object_version_number in out nocopy number
845: ,p_vehicle_repository_id in number default hr_api.g_number
846: ,p_information_type in varchar2 default hr_api.g_varchar2
847: ,p_vrei_attribute_category in varchar2 default hr_api.g_varchar2
848: ,p_vrei_attribute1 in varchar2 default hr_api.g_varchar2
849: ,p_vrei_attribute2 in varchar2 default hr_api.g_varchar2
850: ,p_vrei_attribute3 in varchar2 default hr_api.g_varchar2

Line 847: ,p_vrei_attribute_category in varchar2 default hr_api.g_varchar2

843: (p_veh_repos_extra_info_id in number
844: ,p_object_version_number in out nocopy number
845: ,p_vehicle_repository_id in number default hr_api.g_number
846: ,p_information_type in varchar2 default hr_api.g_varchar2
847: ,p_vrei_attribute_category in varchar2 default hr_api.g_varchar2
848: ,p_vrei_attribute1 in varchar2 default hr_api.g_varchar2
849: ,p_vrei_attribute2 in varchar2 default hr_api.g_varchar2
850: ,p_vrei_attribute3 in varchar2 default hr_api.g_varchar2
851: ,p_vrei_attribute4 in varchar2 default hr_api.g_varchar2

Line 848: ,p_vrei_attribute1 in varchar2 default hr_api.g_varchar2

844: ,p_object_version_number in out nocopy number
845: ,p_vehicle_repository_id in number default hr_api.g_number
846: ,p_information_type in varchar2 default hr_api.g_varchar2
847: ,p_vrei_attribute_category in varchar2 default hr_api.g_varchar2
848: ,p_vrei_attribute1 in varchar2 default hr_api.g_varchar2
849: ,p_vrei_attribute2 in varchar2 default hr_api.g_varchar2
850: ,p_vrei_attribute3 in varchar2 default hr_api.g_varchar2
851: ,p_vrei_attribute4 in varchar2 default hr_api.g_varchar2
852: ,p_vrei_attribute5 in varchar2 default hr_api.g_varchar2

Line 849: ,p_vrei_attribute2 in varchar2 default hr_api.g_varchar2

845: ,p_vehicle_repository_id in number default hr_api.g_number
846: ,p_information_type in varchar2 default hr_api.g_varchar2
847: ,p_vrei_attribute_category in varchar2 default hr_api.g_varchar2
848: ,p_vrei_attribute1 in varchar2 default hr_api.g_varchar2
849: ,p_vrei_attribute2 in varchar2 default hr_api.g_varchar2
850: ,p_vrei_attribute3 in varchar2 default hr_api.g_varchar2
851: ,p_vrei_attribute4 in varchar2 default hr_api.g_varchar2
852: ,p_vrei_attribute5 in varchar2 default hr_api.g_varchar2
853: ,p_vrei_attribute6 in varchar2 default hr_api.g_varchar2

Line 850: ,p_vrei_attribute3 in varchar2 default hr_api.g_varchar2

846: ,p_information_type in varchar2 default hr_api.g_varchar2
847: ,p_vrei_attribute_category in varchar2 default hr_api.g_varchar2
848: ,p_vrei_attribute1 in varchar2 default hr_api.g_varchar2
849: ,p_vrei_attribute2 in varchar2 default hr_api.g_varchar2
850: ,p_vrei_attribute3 in varchar2 default hr_api.g_varchar2
851: ,p_vrei_attribute4 in varchar2 default hr_api.g_varchar2
852: ,p_vrei_attribute5 in varchar2 default hr_api.g_varchar2
853: ,p_vrei_attribute6 in varchar2 default hr_api.g_varchar2
854: ,p_vrei_attribute7 in varchar2 default hr_api.g_varchar2

Line 851: ,p_vrei_attribute4 in varchar2 default hr_api.g_varchar2

847: ,p_vrei_attribute_category in varchar2 default hr_api.g_varchar2
848: ,p_vrei_attribute1 in varchar2 default hr_api.g_varchar2
849: ,p_vrei_attribute2 in varchar2 default hr_api.g_varchar2
850: ,p_vrei_attribute3 in varchar2 default hr_api.g_varchar2
851: ,p_vrei_attribute4 in varchar2 default hr_api.g_varchar2
852: ,p_vrei_attribute5 in varchar2 default hr_api.g_varchar2
853: ,p_vrei_attribute6 in varchar2 default hr_api.g_varchar2
854: ,p_vrei_attribute7 in varchar2 default hr_api.g_varchar2
855: ,p_vrei_attribute8 in varchar2 default hr_api.g_varchar2

Line 852: ,p_vrei_attribute5 in varchar2 default hr_api.g_varchar2

848: ,p_vrei_attribute1 in varchar2 default hr_api.g_varchar2
849: ,p_vrei_attribute2 in varchar2 default hr_api.g_varchar2
850: ,p_vrei_attribute3 in varchar2 default hr_api.g_varchar2
851: ,p_vrei_attribute4 in varchar2 default hr_api.g_varchar2
852: ,p_vrei_attribute5 in varchar2 default hr_api.g_varchar2
853: ,p_vrei_attribute6 in varchar2 default hr_api.g_varchar2
854: ,p_vrei_attribute7 in varchar2 default hr_api.g_varchar2
855: ,p_vrei_attribute8 in varchar2 default hr_api.g_varchar2
856: ,p_vrei_attribute9 in varchar2 default hr_api.g_varchar2

Line 853: ,p_vrei_attribute6 in varchar2 default hr_api.g_varchar2

849: ,p_vrei_attribute2 in varchar2 default hr_api.g_varchar2
850: ,p_vrei_attribute3 in varchar2 default hr_api.g_varchar2
851: ,p_vrei_attribute4 in varchar2 default hr_api.g_varchar2
852: ,p_vrei_attribute5 in varchar2 default hr_api.g_varchar2
853: ,p_vrei_attribute6 in varchar2 default hr_api.g_varchar2
854: ,p_vrei_attribute7 in varchar2 default hr_api.g_varchar2
855: ,p_vrei_attribute8 in varchar2 default hr_api.g_varchar2
856: ,p_vrei_attribute9 in varchar2 default hr_api.g_varchar2
857: ,p_vrei_attribute10 in varchar2 default hr_api.g_varchar2

Line 854: ,p_vrei_attribute7 in varchar2 default hr_api.g_varchar2

850: ,p_vrei_attribute3 in varchar2 default hr_api.g_varchar2
851: ,p_vrei_attribute4 in varchar2 default hr_api.g_varchar2
852: ,p_vrei_attribute5 in varchar2 default hr_api.g_varchar2
853: ,p_vrei_attribute6 in varchar2 default hr_api.g_varchar2
854: ,p_vrei_attribute7 in varchar2 default hr_api.g_varchar2
855: ,p_vrei_attribute8 in varchar2 default hr_api.g_varchar2
856: ,p_vrei_attribute9 in varchar2 default hr_api.g_varchar2
857: ,p_vrei_attribute10 in varchar2 default hr_api.g_varchar2
858: ,p_vrei_attribute11 in varchar2 default hr_api.g_varchar2

Line 855: ,p_vrei_attribute8 in varchar2 default hr_api.g_varchar2

851: ,p_vrei_attribute4 in varchar2 default hr_api.g_varchar2
852: ,p_vrei_attribute5 in varchar2 default hr_api.g_varchar2
853: ,p_vrei_attribute6 in varchar2 default hr_api.g_varchar2
854: ,p_vrei_attribute7 in varchar2 default hr_api.g_varchar2
855: ,p_vrei_attribute8 in varchar2 default hr_api.g_varchar2
856: ,p_vrei_attribute9 in varchar2 default hr_api.g_varchar2
857: ,p_vrei_attribute10 in varchar2 default hr_api.g_varchar2
858: ,p_vrei_attribute11 in varchar2 default hr_api.g_varchar2
859: ,p_vrei_attribute12 in varchar2 default hr_api.g_varchar2

Line 856: ,p_vrei_attribute9 in varchar2 default hr_api.g_varchar2

852: ,p_vrei_attribute5 in varchar2 default hr_api.g_varchar2
853: ,p_vrei_attribute6 in varchar2 default hr_api.g_varchar2
854: ,p_vrei_attribute7 in varchar2 default hr_api.g_varchar2
855: ,p_vrei_attribute8 in varchar2 default hr_api.g_varchar2
856: ,p_vrei_attribute9 in varchar2 default hr_api.g_varchar2
857: ,p_vrei_attribute10 in varchar2 default hr_api.g_varchar2
858: ,p_vrei_attribute11 in varchar2 default hr_api.g_varchar2
859: ,p_vrei_attribute12 in varchar2 default hr_api.g_varchar2
860: ,p_vrei_attribute13 in varchar2 default hr_api.g_varchar2

Line 857: ,p_vrei_attribute10 in varchar2 default hr_api.g_varchar2

853: ,p_vrei_attribute6 in varchar2 default hr_api.g_varchar2
854: ,p_vrei_attribute7 in varchar2 default hr_api.g_varchar2
855: ,p_vrei_attribute8 in varchar2 default hr_api.g_varchar2
856: ,p_vrei_attribute9 in varchar2 default hr_api.g_varchar2
857: ,p_vrei_attribute10 in varchar2 default hr_api.g_varchar2
858: ,p_vrei_attribute11 in varchar2 default hr_api.g_varchar2
859: ,p_vrei_attribute12 in varchar2 default hr_api.g_varchar2
860: ,p_vrei_attribute13 in varchar2 default hr_api.g_varchar2
861: ,p_vrei_attribute14 in varchar2 default hr_api.g_varchar2

Line 858: ,p_vrei_attribute11 in varchar2 default hr_api.g_varchar2

854: ,p_vrei_attribute7 in varchar2 default hr_api.g_varchar2
855: ,p_vrei_attribute8 in varchar2 default hr_api.g_varchar2
856: ,p_vrei_attribute9 in varchar2 default hr_api.g_varchar2
857: ,p_vrei_attribute10 in varchar2 default hr_api.g_varchar2
858: ,p_vrei_attribute11 in varchar2 default hr_api.g_varchar2
859: ,p_vrei_attribute12 in varchar2 default hr_api.g_varchar2
860: ,p_vrei_attribute13 in varchar2 default hr_api.g_varchar2
861: ,p_vrei_attribute14 in varchar2 default hr_api.g_varchar2
862: ,p_vrei_attribute15 in varchar2 default hr_api.g_varchar2

Line 859: ,p_vrei_attribute12 in varchar2 default hr_api.g_varchar2

855: ,p_vrei_attribute8 in varchar2 default hr_api.g_varchar2
856: ,p_vrei_attribute9 in varchar2 default hr_api.g_varchar2
857: ,p_vrei_attribute10 in varchar2 default hr_api.g_varchar2
858: ,p_vrei_attribute11 in varchar2 default hr_api.g_varchar2
859: ,p_vrei_attribute12 in varchar2 default hr_api.g_varchar2
860: ,p_vrei_attribute13 in varchar2 default hr_api.g_varchar2
861: ,p_vrei_attribute14 in varchar2 default hr_api.g_varchar2
862: ,p_vrei_attribute15 in varchar2 default hr_api.g_varchar2
863: ,p_vrei_attribute16 in varchar2 default hr_api.g_varchar2

Line 860: ,p_vrei_attribute13 in varchar2 default hr_api.g_varchar2

856: ,p_vrei_attribute9 in varchar2 default hr_api.g_varchar2
857: ,p_vrei_attribute10 in varchar2 default hr_api.g_varchar2
858: ,p_vrei_attribute11 in varchar2 default hr_api.g_varchar2
859: ,p_vrei_attribute12 in varchar2 default hr_api.g_varchar2
860: ,p_vrei_attribute13 in varchar2 default hr_api.g_varchar2
861: ,p_vrei_attribute14 in varchar2 default hr_api.g_varchar2
862: ,p_vrei_attribute15 in varchar2 default hr_api.g_varchar2
863: ,p_vrei_attribute16 in varchar2 default hr_api.g_varchar2
864: ,p_vrei_attribute17 in varchar2 default hr_api.g_varchar2

Line 861: ,p_vrei_attribute14 in varchar2 default hr_api.g_varchar2

857: ,p_vrei_attribute10 in varchar2 default hr_api.g_varchar2
858: ,p_vrei_attribute11 in varchar2 default hr_api.g_varchar2
859: ,p_vrei_attribute12 in varchar2 default hr_api.g_varchar2
860: ,p_vrei_attribute13 in varchar2 default hr_api.g_varchar2
861: ,p_vrei_attribute14 in varchar2 default hr_api.g_varchar2
862: ,p_vrei_attribute15 in varchar2 default hr_api.g_varchar2
863: ,p_vrei_attribute16 in varchar2 default hr_api.g_varchar2
864: ,p_vrei_attribute17 in varchar2 default hr_api.g_varchar2
865: ,p_vrei_attribute18 in varchar2 default hr_api.g_varchar2

Line 862: ,p_vrei_attribute15 in varchar2 default hr_api.g_varchar2

858: ,p_vrei_attribute11 in varchar2 default hr_api.g_varchar2
859: ,p_vrei_attribute12 in varchar2 default hr_api.g_varchar2
860: ,p_vrei_attribute13 in varchar2 default hr_api.g_varchar2
861: ,p_vrei_attribute14 in varchar2 default hr_api.g_varchar2
862: ,p_vrei_attribute15 in varchar2 default hr_api.g_varchar2
863: ,p_vrei_attribute16 in varchar2 default hr_api.g_varchar2
864: ,p_vrei_attribute17 in varchar2 default hr_api.g_varchar2
865: ,p_vrei_attribute18 in varchar2 default hr_api.g_varchar2
866: ,p_vrei_attribute19 in varchar2 default hr_api.g_varchar2

Line 863: ,p_vrei_attribute16 in varchar2 default hr_api.g_varchar2

859: ,p_vrei_attribute12 in varchar2 default hr_api.g_varchar2
860: ,p_vrei_attribute13 in varchar2 default hr_api.g_varchar2
861: ,p_vrei_attribute14 in varchar2 default hr_api.g_varchar2
862: ,p_vrei_attribute15 in varchar2 default hr_api.g_varchar2
863: ,p_vrei_attribute16 in varchar2 default hr_api.g_varchar2
864: ,p_vrei_attribute17 in varchar2 default hr_api.g_varchar2
865: ,p_vrei_attribute18 in varchar2 default hr_api.g_varchar2
866: ,p_vrei_attribute19 in varchar2 default hr_api.g_varchar2
867: ,p_vrei_attribute20 in varchar2 default hr_api.g_varchar2

Line 864: ,p_vrei_attribute17 in varchar2 default hr_api.g_varchar2

860: ,p_vrei_attribute13 in varchar2 default hr_api.g_varchar2
861: ,p_vrei_attribute14 in varchar2 default hr_api.g_varchar2
862: ,p_vrei_attribute15 in varchar2 default hr_api.g_varchar2
863: ,p_vrei_attribute16 in varchar2 default hr_api.g_varchar2
864: ,p_vrei_attribute17 in varchar2 default hr_api.g_varchar2
865: ,p_vrei_attribute18 in varchar2 default hr_api.g_varchar2
866: ,p_vrei_attribute19 in varchar2 default hr_api.g_varchar2
867: ,p_vrei_attribute20 in varchar2 default hr_api.g_varchar2
868: ,p_vrei_information_category in varchar2 default hr_api.g_varchar2

Line 865: ,p_vrei_attribute18 in varchar2 default hr_api.g_varchar2

861: ,p_vrei_attribute14 in varchar2 default hr_api.g_varchar2
862: ,p_vrei_attribute15 in varchar2 default hr_api.g_varchar2
863: ,p_vrei_attribute16 in varchar2 default hr_api.g_varchar2
864: ,p_vrei_attribute17 in varchar2 default hr_api.g_varchar2
865: ,p_vrei_attribute18 in varchar2 default hr_api.g_varchar2
866: ,p_vrei_attribute19 in varchar2 default hr_api.g_varchar2
867: ,p_vrei_attribute20 in varchar2 default hr_api.g_varchar2
868: ,p_vrei_information_category in varchar2 default hr_api.g_varchar2
869: ,p_vrei_information1 in varchar2 default hr_api.g_varchar2

Line 866: ,p_vrei_attribute19 in varchar2 default hr_api.g_varchar2

862: ,p_vrei_attribute15 in varchar2 default hr_api.g_varchar2
863: ,p_vrei_attribute16 in varchar2 default hr_api.g_varchar2
864: ,p_vrei_attribute17 in varchar2 default hr_api.g_varchar2
865: ,p_vrei_attribute18 in varchar2 default hr_api.g_varchar2
866: ,p_vrei_attribute19 in varchar2 default hr_api.g_varchar2
867: ,p_vrei_attribute20 in varchar2 default hr_api.g_varchar2
868: ,p_vrei_information_category in varchar2 default hr_api.g_varchar2
869: ,p_vrei_information1 in varchar2 default hr_api.g_varchar2
870: ,p_vrei_information2 in varchar2 default hr_api.g_varchar2

Line 867: ,p_vrei_attribute20 in varchar2 default hr_api.g_varchar2

863: ,p_vrei_attribute16 in varchar2 default hr_api.g_varchar2
864: ,p_vrei_attribute17 in varchar2 default hr_api.g_varchar2
865: ,p_vrei_attribute18 in varchar2 default hr_api.g_varchar2
866: ,p_vrei_attribute19 in varchar2 default hr_api.g_varchar2
867: ,p_vrei_attribute20 in varchar2 default hr_api.g_varchar2
868: ,p_vrei_information_category in varchar2 default hr_api.g_varchar2
869: ,p_vrei_information1 in varchar2 default hr_api.g_varchar2
870: ,p_vrei_information2 in varchar2 default hr_api.g_varchar2
871: ,p_vrei_information3 in varchar2 default hr_api.g_varchar2

Line 868: ,p_vrei_information_category in varchar2 default hr_api.g_varchar2

864: ,p_vrei_attribute17 in varchar2 default hr_api.g_varchar2
865: ,p_vrei_attribute18 in varchar2 default hr_api.g_varchar2
866: ,p_vrei_attribute19 in varchar2 default hr_api.g_varchar2
867: ,p_vrei_attribute20 in varchar2 default hr_api.g_varchar2
868: ,p_vrei_information_category in varchar2 default hr_api.g_varchar2
869: ,p_vrei_information1 in varchar2 default hr_api.g_varchar2
870: ,p_vrei_information2 in varchar2 default hr_api.g_varchar2
871: ,p_vrei_information3 in varchar2 default hr_api.g_varchar2
872: ,p_vrei_information4 in varchar2 default hr_api.g_varchar2

Line 869: ,p_vrei_information1 in varchar2 default hr_api.g_varchar2

865: ,p_vrei_attribute18 in varchar2 default hr_api.g_varchar2
866: ,p_vrei_attribute19 in varchar2 default hr_api.g_varchar2
867: ,p_vrei_attribute20 in varchar2 default hr_api.g_varchar2
868: ,p_vrei_information_category in varchar2 default hr_api.g_varchar2
869: ,p_vrei_information1 in varchar2 default hr_api.g_varchar2
870: ,p_vrei_information2 in varchar2 default hr_api.g_varchar2
871: ,p_vrei_information3 in varchar2 default hr_api.g_varchar2
872: ,p_vrei_information4 in varchar2 default hr_api.g_varchar2
873: ,p_vrei_information5 in varchar2 default hr_api.g_varchar2

Line 870: ,p_vrei_information2 in varchar2 default hr_api.g_varchar2

866: ,p_vrei_attribute19 in varchar2 default hr_api.g_varchar2
867: ,p_vrei_attribute20 in varchar2 default hr_api.g_varchar2
868: ,p_vrei_information_category in varchar2 default hr_api.g_varchar2
869: ,p_vrei_information1 in varchar2 default hr_api.g_varchar2
870: ,p_vrei_information2 in varchar2 default hr_api.g_varchar2
871: ,p_vrei_information3 in varchar2 default hr_api.g_varchar2
872: ,p_vrei_information4 in varchar2 default hr_api.g_varchar2
873: ,p_vrei_information5 in varchar2 default hr_api.g_varchar2
874: ,p_vrei_information6 in varchar2 default hr_api.g_varchar2

Line 871: ,p_vrei_information3 in varchar2 default hr_api.g_varchar2

867: ,p_vrei_attribute20 in varchar2 default hr_api.g_varchar2
868: ,p_vrei_information_category in varchar2 default hr_api.g_varchar2
869: ,p_vrei_information1 in varchar2 default hr_api.g_varchar2
870: ,p_vrei_information2 in varchar2 default hr_api.g_varchar2
871: ,p_vrei_information3 in varchar2 default hr_api.g_varchar2
872: ,p_vrei_information4 in varchar2 default hr_api.g_varchar2
873: ,p_vrei_information5 in varchar2 default hr_api.g_varchar2
874: ,p_vrei_information6 in varchar2 default hr_api.g_varchar2
875: ,p_vrei_information7 in varchar2 default hr_api.g_varchar2

Line 872: ,p_vrei_information4 in varchar2 default hr_api.g_varchar2

868: ,p_vrei_information_category in varchar2 default hr_api.g_varchar2
869: ,p_vrei_information1 in varchar2 default hr_api.g_varchar2
870: ,p_vrei_information2 in varchar2 default hr_api.g_varchar2
871: ,p_vrei_information3 in varchar2 default hr_api.g_varchar2
872: ,p_vrei_information4 in varchar2 default hr_api.g_varchar2
873: ,p_vrei_information5 in varchar2 default hr_api.g_varchar2
874: ,p_vrei_information6 in varchar2 default hr_api.g_varchar2
875: ,p_vrei_information7 in varchar2 default hr_api.g_varchar2
876: ,p_vrei_information8 in varchar2 default hr_api.g_varchar2

Line 873: ,p_vrei_information5 in varchar2 default hr_api.g_varchar2

869: ,p_vrei_information1 in varchar2 default hr_api.g_varchar2
870: ,p_vrei_information2 in varchar2 default hr_api.g_varchar2
871: ,p_vrei_information3 in varchar2 default hr_api.g_varchar2
872: ,p_vrei_information4 in varchar2 default hr_api.g_varchar2
873: ,p_vrei_information5 in varchar2 default hr_api.g_varchar2
874: ,p_vrei_information6 in varchar2 default hr_api.g_varchar2
875: ,p_vrei_information7 in varchar2 default hr_api.g_varchar2
876: ,p_vrei_information8 in varchar2 default hr_api.g_varchar2
877: ,p_vrei_information9 in varchar2 default hr_api.g_varchar2

Line 874: ,p_vrei_information6 in varchar2 default hr_api.g_varchar2

870: ,p_vrei_information2 in varchar2 default hr_api.g_varchar2
871: ,p_vrei_information3 in varchar2 default hr_api.g_varchar2
872: ,p_vrei_information4 in varchar2 default hr_api.g_varchar2
873: ,p_vrei_information5 in varchar2 default hr_api.g_varchar2
874: ,p_vrei_information6 in varchar2 default hr_api.g_varchar2
875: ,p_vrei_information7 in varchar2 default hr_api.g_varchar2
876: ,p_vrei_information8 in varchar2 default hr_api.g_varchar2
877: ,p_vrei_information9 in varchar2 default hr_api.g_varchar2
878: ,p_vrei_information10 in varchar2 default hr_api.g_varchar2

Line 875: ,p_vrei_information7 in varchar2 default hr_api.g_varchar2

871: ,p_vrei_information3 in varchar2 default hr_api.g_varchar2
872: ,p_vrei_information4 in varchar2 default hr_api.g_varchar2
873: ,p_vrei_information5 in varchar2 default hr_api.g_varchar2
874: ,p_vrei_information6 in varchar2 default hr_api.g_varchar2
875: ,p_vrei_information7 in varchar2 default hr_api.g_varchar2
876: ,p_vrei_information8 in varchar2 default hr_api.g_varchar2
877: ,p_vrei_information9 in varchar2 default hr_api.g_varchar2
878: ,p_vrei_information10 in varchar2 default hr_api.g_varchar2
879: ,p_vrei_information11 in varchar2 default hr_api.g_varchar2

Line 876: ,p_vrei_information8 in varchar2 default hr_api.g_varchar2

872: ,p_vrei_information4 in varchar2 default hr_api.g_varchar2
873: ,p_vrei_information5 in varchar2 default hr_api.g_varchar2
874: ,p_vrei_information6 in varchar2 default hr_api.g_varchar2
875: ,p_vrei_information7 in varchar2 default hr_api.g_varchar2
876: ,p_vrei_information8 in varchar2 default hr_api.g_varchar2
877: ,p_vrei_information9 in varchar2 default hr_api.g_varchar2
878: ,p_vrei_information10 in varchar2 default hr_api.g_varchar2
879: ,p_vrei_information11 in varchar2 default hr_api.g_varchar2
880: ,p_vrei_information12 in varchar2 default hr_api.g_varchar2

Line 877: ,p_vrei_information9 in varchar2 default hr_api.g_varchar2

873: ,p_vrei_information5 in varchar2 default hr_api.g_varchar2
874: ,p_vrei_information6 in varchar2 default hr_api.g_varchar2
875: ,p_vrei_information7 in varchar2 default hr_api.g_varchar2
876: ,p_vrei_information8 in varchar2 default hr_api.g_varchar2
877: ,p_vrei_information9 in varchar2 default hr_api.g_varchar2
878: ,p_vrei_information10 in varchar2 default hr_api.g_varchar2
879: ,p_vrei_information11 in varchar2 default hr_api.g_varchar2
880: ,p_vrei_information12 in varchar2 default hr_api.g_varchar2
881: ,p_vrei_information13 in varchar2 default hr_api.g_varchar2

Line 878: ,p_vrei_information10 in varchar2 default hr_api.g_varchar2

874: ,p_vrei_information6 in varchar2 default hr_api.g_varchar2
875: ,p_vrei_information7 in varchar2 default hr_api.g_varchar2
876: ,p_vrei_information8 in varchar2 default hr_api.g_varchar2
877: ,p_vrei_information9 in varchar2 default hr_api.g_varchar2
878: ,p_vrei_information10 in varchar2 default hr_api.g_varchar2
879: ,p_vrei_information11 in varchar2 default hr_api.g_varchar2
880: ,p_vrei_information12 in varchar2 default hr_api.g_varchar2
881: ,p_vrei_information13 in varchar2 default hr_api.g_varchar2
882: ,p_vrei_information14 in varchar2 default hr_api.g_varchar2

Line 879: ,p_vrei_information11 in varchar2 default hr_api.g_varchar2

875: ,p_vrei_information7 in varchar2 default hr_api.g_varchar2
876: ,p_vrei_information8 in varchar2 default hr_api.g_varchar2
877: ,p_vrei_information9 in varchar2 default hr_api.g_varchar2
878: ,p_vrei_information10 in varchar2 default hr_api.g_varchar2
879: ,p_vrei_information11 in varchar2 default hr_api.g_varchar2
880: ,p_vrei_information12 in varchar2 default hr_api.g_varchar2
881: ,p_vrei_information13 in varchar2 default hr_api.g_varchar2
882: ,p_vrei_information14 in varchar2 default hr_api.g_varchar2
883: ,p_vrei_information15 in varchar2 default hr_api.g_varchar2

Line 880: ,p_vrei_information12 in varchar2 default hr_api.g_varchar2

876: ,p_vrei_information8 in varchar2 default hr_api.g_varchar2
877: ,p_vrei_information9 in varchar2 default hr_api.g_varchar2
878: ,p_vrei_information10 in varchar2 default hr_api.g_varchar2
879: ,p_vrei_information11 in varchar2 default hr_api.g_varchar2
880: ,p_vrei_information12 in varchar2 default hr_api.g_varchar2
881: ,p_vrei_information13 in varchar2 default hr_api.g_varchar2
882: ,p_vrei_information14 in varchar2 default hr_api.g_varchar2
883: ,p_vrei_information15 in varchar2 default hr_api.g_varchar2
884: ,p_vrei_information16 in varchar2 default hr_api.g_varchar2

Line 881: ,p_vrei_information13 in varchar2 default hr_api.g_varchar2

877: ,p_vrei_information9 in varchar2 default hr_api.g_varchar2
878: ,p_vrei_information10 in varchar2 default hr_api.g_varchar2
879: ,p_vrei_information11 in varchar2 default hr_api.g_varchar2
880: ,p_vrei_information12 in varchar2 default hr_api.g_varchar2
881: ,p_vrei_information13 in varchar2 default hr_api.g_varchar2
882: ,p_vrei_information14 in varchar2 default hr_api.g_varchar2
883: ,p_vrei_information15 in varchar2 default hr_api.g_varchar2
884: ,p_vrei_information16 in varchar2 default hr_api.g_varchar2
885: ,p_vrei_information17 in varchar2 default hr_api.g_varchar2

Line 882: ,p_vrei_information14 in varchar2 default hr_api.g_varchar2

878: ,p_vrei_information10 in varchar2 default hr_api.g_varchar2
879: ,p_vrei_information11 in varchar2 default hr_api.g_varchar2
880: ,p_vrei_information12 in varchar2 default hr_api.g_varchar2
881: ,p_vrei_information13 in varchar2 default hr_api.g_varchar2
882: ,p_vrei_information14 in varchar2 default hr_api.g_varchar2
883: ,p_vrei_information15 in varchar2 default hr_api.g_varchar2
884: ,p_vrei_information16 in varchar2 default hr_api.g_varchar2
885: ,p_vrei_information17 in varchar2 default hr_api.g_varchar2
886: ,p_vrei_information18 in varchar2 default hr_api.g_varchar2

Line 883: ,p_vrei_information15 in varchar2 default hr_api.g_varchar2

879: ,p_vrei_information11 in varchar2 default hr_api.g_varchar2
880: ,p_vrei_information12 in varchar2 default hr_api.g_varchar2
881: ,p_vrei_information13 in varchar2 default hr_api.g_varchar2
882: ,p_vrei_information14 in varchar2 default hr_api.g_varchar2
883: ,p_vrei_information15 in varchar2 default hr_api.g_varchar2
884: ,p_vrei_information16 in varchar2 default hr_api.g_varchar2
885: ,p_vrei_information17 in varchar2 default hr_api.g_varchar2
886: ,p_vrei_information18 in varchar2 default hr_api.g_varchar2
887: ,p_vrei_information19 in varchar2 default hr_api.g_varchar2

Line 884: ,p_vrei_information16 in varchar2 default hr_api.g_varchar2

880: ,p_vrei_information12 in varchar2 default hr_api.g_varchar2
881: ,p_vrei_information13 in varchar2 default hr_api.g_varchar2
882: ,p_vrei_information14 in varchar2 default hr_api.g_varchar2
883: ,p_vrei_information15 in varchar2 default hr_api.g_varchar2
884: ,p_vrei_information16 in varchar2 default hr_api.g_varchar2
885: ,p_vrei_information17 in varchar2 default hr_api.g_varchar2
886: ,p_vrei_information18 in varchar2 default hr_api.g_varchar2
887: ,p_vrei_information19 in varchar2 default hr_api.g_varchar2
888: ,p_vrei_information20 in varchar2 default hr_api.g_varchar2

Line 885: ,p_vrei_information17 in varchar2 default hr_api.g_varchar2

881: ,p_vrei_information13 in varchar2 default hr_api.g_varchar2
882: ,p_vrei_information14 in varchar2 default hr_api.g_varchar2
883: ,p_vrei_information15 in varchar2 default hr_api.g_varchar2
884: ,p_vrei_information16 in varchar2 default hr_api.g_varchar2
885: ,p_vrei_information17 in varchar2 default hr_api.g_varchar2
886: ,p_vrei_information18 in varchar2 default hr_api.g_varchar2
887: ,p_vrei_information19 in varchar2 default hr_api.g_varchar2
888: ,p_vrei_information20 in varchar2 default hr_api.g_varchar2
889: ,p_vrei_information21 in varchar2 default hr_api.g_varchar2

Line 886: ,p_vrei_information18 in varchar2 default hr_api.g_varchar2

882: ,p_vrei_information14 in varchar2 default hr_api.g_varchar2
883: ,p_vrei_information15 in varchar2 default hr_api.g_varchar2
884: ,p_vrei_information16 in varchar2 default hr_api.g_varchar2
885: ,p_vrei_information17 in varchar2 default hr_api.g_varchar2
886: ,p_vrei_information18 in varchar2 default hr_api.g_varchar2
887: ,p_vrei_information19 in varchar2 default hr_api.g_varchar2
888: ,p_vrei_information20 in varchar2 default hr_api.g_varchar2
889: ,p_vrei_information21 in varchar2 default hr_api.g_varchar2
890: ,p_vrei_information22 in varchar2 default hr_api.g_varchar2

Line 887: ,p_vrei_information19 in varchar2 default hr_api.g_varchar2

883: ,p_vrei_information15 in varchar2 default hr_api.g_varchar2
884: ,p_vrei_information16 in varchar2 default hr_api.g_varchar2
885: ,p_vrei_information17 in varchar2 default hr_api.g_varchar2
886: ,p_vrei_information18 in varchar2 default hr_api.g_varchar2
887: ,p_vrei_information19 in varchar2 default hr_api.g_varchar2
888: ,p_vrei_information20 in varchar2 default hr_api.g_varchar2
889: ,p_vrei_information21 in varchar2 default hr_api.g_varchar2
890: ,p_vrei_information22 in varchar2 default hr_api.g_varchar2
891: ,p_vrei_information23 in varchar2 default hr_api.g_varchar2

Line 888: ,p_vrei_information20 in varchar2 default hr_api.g_varchar2

884: ,p_vrei_information16 in varchar2 default hr_api.g_varchar2
885: ,p_vrei_information17 in varchar2 default hr_api.g_varchar2
886: ,p_vrei_information18 in varchar2 default hr_api.g_varchar2
887: ,p_vrei_information19 in varchar2 default hr_api.g_varchar2
888: ,p_vrei_information20 in varchar2 default hr_api.g_varchar2
889: ,p_vrei_information21 in varchar2 default hr_api.g_varchar2
890: ,p_vrei_information22 in varchar2 default hr_api.g_varchar2
891: ,p_vrei_information23 in varchar2 default hr_api.g_varchar2
892: ,p_vrei_information24 in varchar2 default hr_api.g_varchar2

Line 889: ,p_vrei_information21 in varchar2 default hr_api.g_varchar2

885: ,p_vrei_information17 in varchar2 default hr_api.g_varchar2
886: ,p_vrei_information18 in varchar2 default hr_api.g_varchar2
887: ,p_vrei_information19 in varchar2 default hr_api.g_varchar2
888: ,p_vrei_information20 in varchar2 default hr_api.g_varchar2
889: ,p_vrei_information21 in varchar2 default hr_api.g_varchar2
890: ,p_vrei_information22 in varchar2 default hr_api.g_varchar2
891: ,p_vrei_information23 in varchar2 default hr_api.g_varchar2
892: ,p_vrei_information24 in varchar2 default hr_api.g_varchar2
893: ,p_vrei_information25 in varchar2 default hr_api.g_varchar2

Line 890: ,p_vrei_information22 in varchar2 default hr_api.g_varchar2

886: ,p_vrei_information18 in varchar2 default hr_api.g_varchar2
887: ,p_vrei_information19 in varchar2 default hr_api.g_varchar2
888: ,p_vrei_information20 in varchar2 default hr_api.g_varchar2
889: ,p_vrei_information21 in varchar2 default hr_api.g_varchar2
890: ,p_vrei_information22 in varchar2 default hr_api.g_varchar2
891: ,p_vrei_information23 in varchar2 default hr_api.g_varchar2
892: ,p_vrei_information24 in varchar2 default hr_api.g_varchar2
893: ,p_vrei_information25 in varchar2 default hr_api.g_varchar2
894: ,p_vrei_information26 in varchar2 default hr_api.g_varchar2

Line 891: ,p_vrei_information23 in varchar2 default hr_api.g_varchar2

887: ,p_vrei_information19 in varchar2 default hr_api.g_varchar2
888: ,p_vrei_information20 in varchar2 default hr_api.g_varchar2
889: ,p_vrei_information21 in varchar2 default hr_api.g_varchar2
890: ,p_vrei_information22 in varchar2 default hr_api.g_varchar2
891: ,p_vrei_information23 in varchar2 default hr_api.g_varchar2
892: ,p_vrei_information24 in varchar2 default hr_api.g_varchar2
893: ,p_vrei_information25 in varchar2 default hr_api.g_varchar2
894: ,p_vrei_information26 in varchar2 default hr_api.g_varchar2
895: ,p_vrei_information27 in varchar2 default hr_api.g_varchar2

Line 892: ,p_vrei_information24 in varchar2 default hr_api.g_varchar2

888: ,p_vrei_information20 in varchar2 default hr_api.g_varchar2
889: ,p_vrei_information21 in varchar2 default hr_api.g_varchar2
890: ,p_vrei_information22 in varchar2 default hr_api.g_varchar2
891: ,p_vrei_information23 in varchar2 default hr_api.g_varchar2
892: ,p_vrei_information24 in varchar2 default hr_api.g_varchar2
893: ,p_vrei_information25 in varchar2 default hr_api.g_varchar2
894: ,p_vrei_information26 in varchar2 default hr_api.g_varchar2
895: ,p_vrei_information27 in varchar2 default hr_api.g_varchar2
896: ,p_vrei_information28 in varchar2 default hr_api.g_varchar2

Line 893: ,p_vrei_information25 in varchar2 default hr_api.g_varchar2

889: ,p_vrei_information21 in varchar2 default hr_api.g_varchar2
890: ,p_vrei_information22 in varchar2 default hr_api.g_varchar2
891: ,p_vrei_information23 in varchar2 default hr_api.g_varchar2
892: ,p_vrei_information24 in varchar2 default hr_api.g_varchar2
893: ,p_vrei_information25 in varchar2 default hr_api.g_varchar2
894: ,p_vrei_information26 in varchar2 default hr_api.g_varchar2
895: ,p_vrei_information27 in varchar2 default hr_api.g_varchar2
896: ,p_vrei_information28 in varchar2 default hr_api.g_varchar2
897: ,p_vrei_information29 in varchar2 default hr_api.g_varchar2

Line 894: ,p_vrei_information26 in varchar2 default hr_api.g_varchar2

890: ,p_vrei_information22 in varchar2 default hr_api.g_varchar2
891: ,p_vrei_information23 in varchar2 default hr_api.g_varchar2
892: ,p_vrei_information24 in varchar2 default hr_api.g_varchar2
893: ,p_vrei_information25 in varchar2 default hr_api.g_varchar2
894: ,p_vrei_information26 in varchar2 default hr_api.g_varchar2
895: ,p_vrei_information27 in varchar2 default hr_api.g_varchar2
896: ,p_vrei_information28 in varchar2 default hr_api.g_varchar2
897: ,p_vrei_information29 in varchar2 default hr_api.g_varchar2
898: ,p_vrei_information30 in varchar2 default hr_api.g_varchar2

Line 895: ,p_vrei_information27 in varchar2 default hr_api.g_varchar2

891: ,p_vrei_information23 in varchar2 default hr_api.g_varchar2
892: ,p_vrei_information24 in varchar2 default hr_api.g_varchar2
893: ,p_vrei_information25 in varchar2 default hr_api.g_varchar2
894: ,p_vrei_information26 in varchar2 default hr_api.g_varchar2
895: ,p_vrei_information27 in varchar2 default hr_api.g_varchar2
896: ,p_vrei_information28 in varchar2 default hr_api.g_varchar2
897: ,p_vrei_information29 in varchar2 default hr_api.g_varchar2
898: ,p_vrei_information30 in varchar2 default hr_api.g_varchar2
899: ,p_request_id in number default hr_api.g_number

Line 896: ,p_vrei_information28 in varchar2 default hr_api.g_varchar2

892: ,p_vrei_information24 in varchar2 default hr_api.g_varchar2
893: ,p_vrei_information25 in varchar2 default hr_api.g_varchar2
894: ,p_vrei_information26 in varchar2 default hr_api.g_varchar2
895: ,p_vrei_information27 in varchar2 default hr_api.g_varchar2
896: ,p_vrei_information28 in varchar2 default hr_api.g_varchar2
897: ,p_vrei_information29 in varchar2 default hr_api.g_varchar2
898: ,p_vrei_information30 in varchar2 default hr_api.g_varchar2
899: ,p_request_id in number default hr_api.g_number
900: ,p_program_application_id in number default hr_api.g_number

Line 897: ,p_vrei_information29 in varchar2 default hr_api.g_varchar2

893: ,p_vrei_information25 in varchar2 default hr_api.g_varchar2
894: ,p_vrei_information26 in varchar2 default hr_api.g_varchar2
895: ,p_vrei_information27 in varchar2 default hr_api.g_varchar2
896: ,p_vrei_information28 in varchar2 default hr_api.g_varchar2
897: ,p_vrei_information29 in varchar2 default hr_api.g_varchar2
898: ,p_vrei_information30 in varchar2 default hr_api.g_varchar2
899: ,p_request_id in number default hr_api.g_number
900: ,p_program_application_id in number default hr_api.g_number
901: ,p_program_id in number default hr_api.g_number

Line 898: ,p_vrei_information30 in varchar2 default hr_api.g_varchar2

894: ,p_vrei_information26 in varchar2 default hr_api.g_varchar2
895: ,p_vrei_information27 in varchar2 default hr_api.g_varchar2
896: ,p_vrei_information28 in varchar2 default hr_api.g_varchar2
897: ,p_vrei_information29 in varchar2 default hr_api.g_varchar2
898: ,p_vrei_information30 in varchar2 default hr_api.g_varchar2
899: ,p_request_id in number default hr_api.g_number
900: ,p_program_application_id in number default hr_api.g_number
901: ,p_program_id in number default hr_api.g_number
902: ,p_program_update_date in date default hr_api.g_date

Line 899: ,p_request_id in number default hr_api.g_number

895: ,p_vrei_information27 in varchar2 default hr_api.g_varchar2
896: ,p_vrei_information28 in varchar2 default hr_api.g_varchar2
897: ,p_vrei_information29 in varchar2 default hr_api.g_varchar2
898: ,p_vrei_information30 in varchar2 default hr_api.g_varchar2
899: ,p_request_id in number default hr_api.g_number
900: ,p_program_application_id in number default hr_api.g_number
901: ,p_program_id in number default hr_api.g_number
902: ,p_program_update_date in date default hr_api.g_date
903: ) is

Line 900: ,p_program_application_id in number default hr_api.g_number

896: ,p_vrei_information28 in varchar2 default hr_api.g_varchar2
897: ,p_vrei_information29 in varchar2 default hr_api.g_varchar2
898: ,p_vrei_information30 in varchar2 default hr_api.g_varchar2
899: ,p_request_id in number default hr_api.g_number
900: ,p_program_application_id in number default hr_api.g_number
901: ,p_program_id in number default hr_api.g_number
902: ,p_program_update_date in date default hr_api.g_date
903: ) is
904: --

Line 901: ,p_program_id in number default hr_api.g_number

897: ,p_vrei_information29 in varchar2 default hr_api.g_varchar2
898: ,p_vrei_information30 in varchar2 default hr_api.g_varchar2
899: ,p_request_id in number default hr_api.g_number
900: ,p_program_application_id in number default hr_api.g_number
901: ,p_program_id in number default hr_api.g_number
902: ,p_program_update_date in date default hr_api.g_date
903: ) is
904: --
905: l_rec pqp_vri_shd.g_rec_type;

Line 902: ,p_program_update_date in date default hr_api.g_date

898: ,p_vrei_information30 in varchar2 default hr_api.g_varchar2
899: ,p_request_id in number default hr_api.g_number
900: ,p_program_application_id in number default hr_api.g_number
901: ,p_program_id in number default hr_api.g_number
902: ,p_program_update_date in date default hr_api.g_date
903: ) is
904: --
905: l_rec pqp_vri_shd.g_rec_type;
906: l_proc varchar2(72) := g_package||'upd';