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

Line 214: if hr_api.not_exists_in_hr_lookups

210: -- lookup type 'SA_RELIGION' with an enabled flag set to 'Y' and that
211: -- the effective start date of the person is between start date
212: -- active and end date active in hr_lookups.
213: --
214: if hr_api.not_exists_in_hr_lookups
215: (p_effective_date => p_effective_date
216: ,p_lookup_type => 'SA_RELIGION'
217: ,p_lookup_code => p_per_information7
218: )

Line 288: if hr_api.not_exists_in_hr_lookups

284: -- lookup type 'SA_RELIGION' with an enabled flag set to 'Y' and that
285: -- the effective start date of the person is between start date
286: -- active and end date active in hr_lookups.
287: --
288: if hr_api.not_exists_in_hr_lookups
289: (p_effective_date => p_date_received
290: ,p_lookup_type => 'SA_RELIGION'
291: ,p_lookup_code => p_per_information7
292: )

Line 363: if hr_api.not_exists_in_hr_lookups

359: -- lookup type 'SA_RELIGION' with an enabled flag set to 'Y' and that
360: -- the effective start date of the person is between start date
361: -- active and end date active in hr_lookups.
362: --
363: if hr_api.not_exists_in_hr_lookups
364: (p_effective_date => p_hire_date
365: ,p_lookup_type => 'SA_RELIGION'
366: ,p_lookup_code => p_per_information7
367: )

Line 441: if hr_api.not_exists_in_hr_lookups

437: -- lookup type 'SA_RELIGION' with an enabled flag set to 'Y' and that
438: -- the effective start date of the person is between start date
439: -- active and end date active in hr_lookups.
440: --
441: if hr_api.not_exists_in_hr_lookups
442: (p_effective_date => p_start_date
443: ,p_lookup_type => 'SA_RELIGION'
444: ,p_lookup_code => p_per_information7
445: )

Line 458: (p_employer_name IN varchar2 default hr_api.g_varchar2

454: END IF;
455: END contact_cwk_validate;
456: --Procedure for validating previous_employer
457: PROCEDURE previous_employer_validate
458: (p_employer_name IN varchar2 default hr_api.g_varchar2
459: ,p_start_date IN date default hr_api.g_date
460: ,p_pem_information_category IN varchar2 default hr_api.g_varchar2
461: ,p_pem_information1 IN varchar2 default hr_api.g_varchar2
462: ) IS

Line 459: ,p_start_date IN date default hr_api.g_date

455: END contact_cwk_validate;
456: --Procedure for validating previous_employer
457: PROCEDURE previous_employer_validate
458: (p_employer_name IN varchar2 default hr_api.g_varchar2
459: ,p_start_date IN date default hr_api.g_date
460: ,p_pem_information_category IN varchar2 default hr_api.g_varchar2
461: ,p_pem_information1 IN varchar2 default hr_api.g_varchar2
462: ) IS
463: BEGIN

Line 460: ,p_pem_information_category IN varchar2 default hr_api.g_varchar2

456: --Procedure for validating previous_employer
457: PROCEDURE previous_employer_validate
458: (p_employer_name IN varchar2 default hr_api.g_varchar2
459: ,p_start_date IN date default hr_api.g_date
460: ,p_pem_information_category IN varchar2 default hr_api.g_varchar2
461: ,p_pem_information1 IN varchar2 default hr_api.g_varchar2
462: ) IS
463: BEGIN
464:

Line 461: ,p_pem_information1 IN varchar2 default hr_api.g_varchar2

457: PROCEDURE previous_employer_validate
458: (p_employer_name IN varchar2 default hr_api.g_varchar2
459: ,p_start_date IN date default hr_api.g_date
460: ,p_pem_information_category IN varchar2 default hr_api.g_varchar2
461: ,p_pem_information1 IN varchar2 default hr_api.g_varchar2
462: ) IS
463: BEGIN
464:
465: /* Added for GSI Bug 5472781 */

Line 526: IF hr_api.not_exists_in_hr_lookups

522: -- Check that the employment status exists in hr_lookups for the
523: -- lookup type 'SA_EMPLOYMENT_STATUS' with an enabled flag set to 'Y'
524: --
525: IF p_ctr_information1 IS NOT NULL THEN
526: IF hr_api.not_exists_in_hr_lookups
527: (p_effective_date => p_effective_date
528: ,p_lookup_type => 'SA_EMPLOYMENT_STATUS'
529: ,p_lookup_code => p_ctr_information1
530: )

Line 543: ,p_pds_information_category IN varchar2 default hr_api.g_varchar2

539: END IF;
540: END contract_validate;
541: PROCEDURE periods_of_service_validate
542: (p_period_of_service_id IN number
543: ,p_pds_information_category IN varchar2 default hr_api.g_varchar2
544: ,p_pds_information1 IN varchar2 default hr_api.g_varchar2
545: ) is
546: l_hijrah_date varchar2(10);
547: l_valid_date varchar2(10);

Line 544: ,p_pds_information1 IN varchar2 default hr_api.g_varchar2

540: END contract_validate;
541: PROCEDURE periods_of_service_validate
542: (p_period_of_service_id IN number
543: ,p_pds_information_category IN varchar2 default hr_api.g_varchar2
544: ,p_pds_information1 IN varchar2 default hr_api.g_varchar2
545: ) is
546: l_hijrah_date varchar2(10);
547: l_valid_date varchar2(10);
548: BEGIN

Line 559: (p_pei_information_category IN varchar2 default hr_api.g_varchar2

555: END IF;
556: END periods_of_service_validate;
557:
558: PROCEDURE person_eit_validate
559: (p_pei_information_category IN varchar2 default hr_api.g_varchar2
560: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
561: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
562: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
563: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2

Line 560: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2

556: END periods_of_service_validate;
557:
558: PROCEDURE person_eit_validate
559: (p_pei_information_category IN varchar2 default hr_api.g_varchar2
560: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
561: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
562: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
563: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
564: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2

Line 561: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2

557:
558: PROCEDURE person_eit_validate
559: (p_pei_information_category IN varchar2 default hr_api.g_varchar2
560: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
561: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
562: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
563: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
564: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
565: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2

Line 562: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2

558: PROCEDURE person_eit_validate
559: (p_pei_information_category IN varchar2 default hr_api.g_varchar2
560: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
561: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
562: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
563: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
564: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
565: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
566: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2

Line 563: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2

559: (p_pei_information_category IN varchar2 default hr_api.g_varchar2
560: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
561: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
562: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
563: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
564: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
565: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
566: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
567: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2

Line 564: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2

560: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
561: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
562: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
563: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
564: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
565: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
566: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
567: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
568: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2

Line 565: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2

561: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
562: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
563: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
564: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
565: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
566: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
567: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
568: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
569: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2

Line 566: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2

562: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
563: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
564: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
565: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
566: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
567: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
568: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
569: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2
570: ) is

Line 567: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2

563: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
564: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
565: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
566: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
567: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
568: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
569: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2
570: ) is
571: l_valid_date1 varchar2(10);

Line 568: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2

564: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
565: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
566: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
567: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
568: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
569: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2
570: ) is
571: l_valid_date1 varchar2(10);
572: l_valid_date2 varchar2(10);

Line 569: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2

565: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
566: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
567: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
568: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
569: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2
570: ) is
571: l_valid_date1 varchar2(10);
572: l_valid_date2 varchar2(10);
573: BEGIN

Line 589: ,p_pei_information_category IN varchar2 default hr_api.g_varchar2

585:
586:
587: PROCEDURE create_person_eit_validate
588: (p_person_id IN number
589: ,p_pei_information_category IN varchar2 default hr_api.g_varchar2
590: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
591: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
592: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
593: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2

Line 590: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2

586:
587: PROCEDURE create_person_eit_validate
588: (p_person_id IN number
589: ,p_pei_information_category IN varchar2 default hr_api.g_varchar2
590: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
591: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
592: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
593: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
594: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2

Line 591: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2

587: PROCEDURE create_person_eit_validate
588: (p_person_id IN number
589: ,p_pei_information_category IN varchar2 default hr_api.g_varchar2
590: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
591: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
592: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
593: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
594: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
595: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2

Line 592: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2

588: (p_person_id IN number
589: ,p_pei_information_category IN varchar2 default hr_api.g_varchar2
590: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
591: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
592: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
593: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
594: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
595: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
596: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2

Line 593: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2

589: ,p_pei_information_category IN varchar2 default hr_api.g_varchar2
590: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
591: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
592: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
593: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
594: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
595: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
596: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
597: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2

Line 594: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2

590: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
591: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
592: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
593: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
594: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
595: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
596: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
597: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
598: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2

Line 595: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2

591: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
592: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
593: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
594: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
595: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
596: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
597: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
598: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
599: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2

Line 596: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2

592: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
593: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
594: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
595: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
596: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
597: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
598: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
599: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2
600: ) is

Line 597: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2

593: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
594: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
595: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
596: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
597: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
598: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
599: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2
600: ) is
601: l_valid_date1 varchar2(10);

Line 598: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2

594: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
595: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
596: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
597: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
598: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
599: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2
600: ) is
601: l_valid_date1 varchar2(10);
602: l_valid_date2 varchar2(10);

Line 599: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2

595: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
596: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
597: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
598: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
599: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2
600: ) is
601: l_valid_date1 varchar2(10);
602: l_valid_date2 varchar2(10);
603: l_nationality varchar2(30);

Line 636: ,p_pei_information_category IN varchar2 default hr_api.g_varchar2

632:
633:
634: PROCEDURE update_person_eit_validate
635: (p_person_extra_info_id IN number
636: ,p_pei_information_category IN varchar2 default hr_api.g_varchar2
637: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
638: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
639: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
640: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2

Line 637: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2

633:
634: PROCEDURE update_person_eit_validate
635: (p_person_extra_info_id IN number
636: ,p_pei_information_category IN varchar2 default hr_api.g_varchar2
637: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
638: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
639: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
640: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
641: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2

Line 638: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2

634: PROCEDURE update_person_eit_validate
635: (p_person_extra_info_id IN number
636: ,p_pei_information_category IN varchar2 default hr_api.g_varchar2
637: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
638: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
639: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
640: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
641: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
642: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2

Line 639: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2

635: (p_person_extra_info_id IN number
636: ,p_pei_information_category IN varchar2 default hr_api.g_varchar2
637: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
638: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
639: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
640: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
641: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
642: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
643: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2

Line 640: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2

636: ,p_pei_information_category IN varchar2 default hr_api.g_varchar2
637: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
638: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
639: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
640: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
641: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
642: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
643: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
644: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2

Line 641: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2

637: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
638: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
639: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
640: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
641: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
642: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
643: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
644: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
645: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2

Line 642: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2

638: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
639: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
640: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
641: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
642: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
643: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
644: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
645: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
646: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2

Line 643: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2

639: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
640: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
641: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
642: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
643: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
644: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
645: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
646: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2
647: ) is

Line 644: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2

640: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
641: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
642: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
643: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
644: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
645: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
646: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2
647: ) is
648: l_valid_date1 varchar2(10);

Line 645: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2

641: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
642: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
643: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
644: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
645: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
646: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2
647: ) is
648: l_valid_date1 varchar2(10);
649: l_valid_date2 varchar2(10);

Line 646: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2

642: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
643: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
644: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
645: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
646: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2
647: ) is
648: l_valid_date1 varchar2(10);
649: l_valid_date2 varchar2(10);
650: l_nationality varchar2(30);