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 217: if hr_api.not_exists_in_hr_lookups

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

Line 291: if hr_api.not_exists_in_hr_lookups

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

Line 366: if hr_api.not_exists_in_hr_lookups

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

Line 444: if hr_api.not_exists_in_hr_lookups

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

Line 461: (p_employer_name IN varchar2 default hr_api.g_varchar2

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

Line 462: ,p_start_date IN date default hr_api.g_date

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

Line 463: ,p_pem_information_category IN varchar2 default hr_api.g_varchar2

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

Line 464: ,p_pem_information1 IN varchar2 default hr_api.g_varchar2

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

Line 529: IF hr_api.not_exists_in_hr_lookups

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

Line 546: ,p_pds_information_category IN varchar2 default hr_api.g_varchar2

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

Line 547: ,p_pds_information1 IN varchar2 default hr_api.g_varchar2

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

Line 562: (p_pei_information_category IN varchar2 default hr_api.g_varchar2

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

Line 563: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2

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

Line 564: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2

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

Line 565: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2

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

Line 566: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2

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

Line 567: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2

563: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
564: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
565: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
566: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
567: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
568: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
569: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
570: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
571: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2

Line 568: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2

564: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
565: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
566: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
567: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
568: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
569: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
570: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
571: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
572: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2

Line 569: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2

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

Line 570: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2

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

Line 571: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2

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

Line 572: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2

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

Line 592: ,p_pei_information_category IN varchar2 default hr_api.g_varchar2

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

Line 593: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2

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

Line 594: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2

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

Line 595: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2

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

Line 596: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2

592: ,p_pei_information_category IN varchar2 default hr_api.g_varchar2
593: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
594: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
595: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
596: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
597: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
598: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
599: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
600: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2

Line 597: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2

593: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
594: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
595: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
596: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
597: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
598: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
599: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
600: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
601: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2

Line 598: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2

594: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
595: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
596: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
597: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
598: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
599: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
600: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
601: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
602: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2

Line 599: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2

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

Line 600: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2

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

Line 601: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2

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

Line 602: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2

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

Line 639: ,p_pei_information_category IN varchar2 default hr_api.g_varchar2

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

Line 640: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2

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

Line 641: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2

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

Line 642: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2

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

Line 643: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2

639: ,p_pei_information_category IN varchar2 default hr_api.g_varchar2
640: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
641: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
642: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
643: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
644: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
645: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
646: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
647: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2

Line 644: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2

640: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
641: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
642: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
643: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
644: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
645: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
646: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
647: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
648: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2

Line 645: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2

641: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
642: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
643: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
644: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
645: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
646: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
647: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
648: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
649: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2

Line 646: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2

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

Line 647: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2

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

Line 648: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2

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

Line 649: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2

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