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

APPS.PER_PER_BUS dependencies on PER_ALL_PEOPLE_F

Line 294: (p_person_id in per_all_people_f.person_id%TYPE

290: -- Access Status:
291: -- Internal Table Handler Use Only.
292: --
293: procedure chk_start_date
294: (p_person_id in per_all_people_f.person_id%TYPE
295: ,p_start_date in date
296: ,p_effective_date in date
297: ,p_object_version_number in per_all_people_f.object_version_number%TYPE);
298: --

Line 297: ,p_object_version_number in per_all_people_f.object_version_number%TYPE);

293: procedure chk_start_date
294: (p_person_id in per_all_people_f.person_id%TYPE
295: ,p_start_date in date
296: ,p_effective_date in date
297: ,p_object_version_number in per_all_people_f.object_version_number%TYPE);
298: --
299: procedure chk_party_id
300: (p_person_id in per_all_people_f.person_id%TYPE
301: ,p_party_id in number

Line 300: (p_person_id in per_all_people_f.person_id%TYPE

296: ,p_effective_date in date
297: ,p_object_version_number in per_all_people_f.object_version_number%TYPE);
298: --
299: procedure chk_party_id
300: (p_person_id in per_all_people_f.person_id%TYPE
301: ,p_party_id in number
302: ,p_effective_date in date
303: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
304: );

Line 303: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

299: procedure chk_party_id
300: (p_person_id in per_all_people_f.person_id%TYPE
301: ,p_party_id in number
302: ,p_effective_date in date
303: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
304: );
305: -- ---------------------------------------------------------------------------
306: -- |--------------------< chk_orig_and_start_dates >----------------------|
307: -- -------------------------------------------------------------------------

Line 352: (p_person_id in per_all_people_f.person_id%TYPE

348: --
349: -- Internal Table Handler Use Only.
350: --
351: procedure chk_orig_and_start_dates
352: (p_person_id in per_all_people_f.person_id%TYPE
353: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
354: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
355: ,p_original_date_of_hire in per_all_people_f.original_date_of_hire%TYPE
356: ,p_start_date in per_all_people_f.start_date%TYPE

Line 353: ,p_person_type_id in per_all_people_f.person_type_id%TYPE

349: -- Internal Table Handler Use Only.
350: --
351: procedure chk_orig_and_start_dates
352: (p_person_id in per_all_people_f.person_id%TYPE
353: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
354: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
355: ,p_original_date_of_hire in per_all_people_f.original_date_of_hire%TYPE
356: ,p_start_date in per_all_people_f.start_date%TYPE
357: ,p_effective_date in date

Line 354: ,p_business_group_id in per_all_people_f.business_group_id%TYPE

350: --
351: procedure chk_orig_and_start_dates
352: (p_person_id in per_all_people_f.person_id%TYPE
353: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
354: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
355: ,p_original_date_of_hire in per_all_people_f.original_date_of_hire%TYPE
356: ,p_start_date in per_all_people_f.start_date%TYPE
357: ,p_effective_date in date
358: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

Line 355: ,p_original_date_of_hire in per_all_people_f.original_date_of_hire%TYPE

351: procedure chk_orig_and_start_dates
352: (p_person_id in per_all_people_f.person_id%TYPE
353: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
354: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
355: ,p_original_date_of_hire in per_all_people_f.original_date_of_hire%TYPE
356: ,p_start_date in per_all_people_f.start_date%TYPE
357: ,p_effective_date in date
358: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
359: ,p_orig_hire_warning out nocopy boolean

Line 356: ,p_start_date in per_all_people_f.start_date%TYPE

352: (p_person_id in per_all_people_f.person_id%TYPE
353: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
354: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
355: ,p_original_date_of_hire in per_all_people_f.original_date_of_hire%TYPE
356: ,p_start_date in per_all_people_f.start_date%TYPE
357: ,p_effective_date in date
358: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
359: ,p_orig_hire_warning out nocopy boolean
360: );

Line 358: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

354: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
355: ,p_original_date_of_hire in per_all_people_f.original_date_of_hire%TYPE
356: ,p_start_date in per_all_people_f.start_date%TYPE
357: ,p_effective_date in date
358: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
359: ,p_orig_hire_warning out nocopy boolean
360: );
361: --
362: -- ----------------------------------------------------------------------------

Line 397: p_person_id in per_all_people_f.person_id%TYPE

393: --
394: -- ----------------------------------------------------------------------------
395: procedure set_security_group_id
396: (
397: p_person_id in per_all_people_f.person_id%TYPE
398: ,p_associated_column1 in varchar2 default null
399: );
400: --
401: --

Line 451: (p_person_id in per_all_people_f.person_id%TYPE

447: -- Access Status:
448: -- Internal Development Use Only.
449: --
450: procedure chk_date_of_birth
451: (p_person_id in per_all_people_f.person_id%TYPE
452: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
453: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
454: ,p_start_date in date
455: ,p_date_of_birth in date

Line 452: ,p_person_type_id in per_all_people_f.person_type_id%TYPE

448: -- Internal Development Use Only.
449: --
450: procedure chk_date_of_birth
451: (p_person_id in per_all_people_f.person_id%TYPE
452: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
453: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
454: ,p_start_date in date
455: ,p_date_of_birth in date
456: ,p_dob_null_warning out nocopy boolean

Line 453: ,p_business_group_id in per_all_people_f.business_group_id%TYPE

449: --
450: procedure chk_date_of_birth
451: (p_person_id in per_all_people_f.person_id%TYPE
452: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
453: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
454: ,p_start_date in date
455: ,p_date_of_birth in date
456: ,p_dob_null_warning out nocopy boolean
457: ,p_effective_date in date

Line 460: ,p_object_version_number in per_all_people_f.object_version_number%TYPE);

456: ,p_dob_null_warning out nocopy boolean
457: ,p_effective_date in date
458: ,p_validation_start_date in date
459: ,p_validation_end_date in date
460: ,p_object_version_number in per_all_people_f.object_version_number%TYPE);
461: --
462: --start for bug 6241572
463: --
464: -- ---------------------------------------------------------------------------

Line 502: (p_person_id in per_all_people_f.person_id%TYPE

498: -- Access Status:
499: -- Internal Development Use Only.
500: --
501: procedure chk_national_identifier
502: (p_person_id in per_all_people_f.person_id%TYPE
503: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
504: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
505: ,p_date_of_birth in date
506: ,p_sex in per_all_people_f.sex%TYPE

Line 503: ,p_business_group_id in per_all_people_f.business_group_id%TYPE

499: -- Internal Development Use Only.
500: --
501: procedure chk_national_identifier
502: (p_person_id in per_all_people_f.person_id%TYPE
503: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
504: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
505: ,p_date_of_birth in date
506: ,p_sex in per_all_people_f.sex%TYPE
507: ,p_effective_date in date

Line 504: ,p_national_identifier in per_all_people_f.national_identifier%TYPE

500: --
501: procedure chk_national_identifier
502: (p_person_id in per_all_people_f.person_id%TYPE
503: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
504: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
505: ,p_date_of_birth in date
506: ,p_sex in per_all_people_f.sex%TYPE
507: ,p_effective_date in date
508: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

Line 506: ,p_sex in per_all_people_f.sex%TYPE

502: (p_person_id in per_all_people_f.person_id%TYPE
503: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
504: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
505: ,p_date_of_birth in date
506: ,p_sex in per_all_people_f.sex%TYPE
507: ,p_effective_date in date
508: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
509: ,p_legislation_code in per_business_groups.legislation_code%TYPE
510: ,p_person_type_id in per_all_people_f.person_type_id%TYPE

Line 508: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

504: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
505: ,p_date_of_birth in date
506: ,p_sex in per_all_people_f.sex%TYPE
507: ,p_effective_date in date
508: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
509: ,p_legislation_code in per_business_groups.legislation_code%TYPE
510: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
511: ,p_region_of_birth in per_all_people_f.region_of_birth%TYPE default NULL
512: ,p_country_of_birth in per_all_people_f.country_of_birth%TYPE default NULL

Line 510: ,p_person_type_id in per_all_people_f.person_type_id%TYPE

506: ,p_sex in per_all_people_f.sex%TYPE
507: ,p_effective_date in date
508: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
509: ,p_legislation_code in per_business_groups.legislation_code%TYPE
510: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
511: ,p_region_of_birth in per_all_people_f.region_of_birth%TYPE default NULL
512: ,p_country_of_birth in per_all_people_f.country_of_birth%TYPE default NULL
513: ,p_nationality in per_all_people_f.nationality%TYPE);
514:

Line 511: ,p_region_of_birth in per_all_people_f.region_of_birth%TYPE default NULL

507: ,p_effective_date in date
508: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
509: ,p_legislation_code in per_business_groups.legislation_code%TYPE
510: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
511: ,p_region_of_birth in per_all_people_f.region_of_birth%TYPE default NULL
512: ,p_country_of_birth in per_all_people_f.country_of_birth%TYPE default NULL
513: ,p_nationality in per_all_people_f.nationality%TYPE);
514:
515: --end for bug 6241572

Line 512: ,p_country_of_birth in per_all_people_f.country_of_birth%TYPE default NULL

508: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
509: ,p_legislation_code in per_business_groups.legislation_code%TYPE
510: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
511: ,p_region_of_birth in per_all_people_f.region_of_birth%TYPE default NULL
512: ,p_country_of_birth in per_all_people_f.country_of_birth%TYPE default NULL
513: ,p_nationality in per_all_people_f.nationality%TYPE);
514:
515: --end for bug 6241572
516: --

Line 513: ,p_nationality in per_all_people_f.nationality%TYPE);

509: ,p_legislation_code in per_business_groups.legislation_code%TYPE
510: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
511: ,p_region_of_birth in per_all_people_f.region_of_birth%TYPE default NULL
512: ,p_country_of_birth in per_all_people_f.country_of_birth%TYPE default NULL
513: ,p_nationality in per_all_people_f.nationality%TYPE);
514:
515: --end for bug 6241572
516: --
517: --

Line 551: (p_person_id in per_all_people_f.person_id%TYPE

547: -- Access Status:
548: -- Internal Development Use Only.
549: --
550: procedure chk_national_identifier
551: (p_person_id in per_all_people_f.person_id%TYPE
552: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
553: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
554: ,p_date_of_birth in date
555: ,p_sex in per_all_people_f.sex%TYPE

Line 552: ,p_business_group_id in per_all_people_f.business_group_id%TYPE

548: -- Internal Development Use Only.
549: --
550: procedure chk_national_identifier
551: (p_person_id in per_all_people_f.person_id%TYPE
552: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
553: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
554: ,p_date_of_birth in date
555: ,p_sex in per_all_people_f.sex%TYPE
556: ,p_effective_date in date

Line 553: ,p_national_identifier in per_all_people_f.national_identifier%TYPE

549: --
550: procedure chk_national_identifier
551: (p_person_id in per_all_people_f.person_id%TYPE
552: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
553: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
554: ,p_date_of_birth in date
555: ,p_sex in per_all_people_f.sex%TYPE
556: ,p_effective_date in date
557: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

Line 555: ,p_sex in per_all_people_f.sex%TYPE

551: (p_person_id in per_all_people_f.person_id%TYPE
552: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
553: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
554: ,p_date_of_birth in date
555: ,p_sex in per_all_people_f.sex%TYPE
556: ,p_effective_date in date
557: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
558: ,p_legislation_code in per_business_groups.legislation_code%TYPE
559: ,p_person_type_id in per_all_people_f.person_type_id%TYPE);

Line 557: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

553: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
554: ,p_date_of_birth in date
555: ,p_sex in per_all_people_f.sex%TYPE
556: ,p_effective_date in date
557: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
558: ,p_legislation_code in per_business_groups.legislation_code%TYPE
559: ,p_person_type_id in per_all_people_f.person_type_id%TYPE);
560: --
561: --

Line 559: ,p_person_type_id in per_all_people_f.person_type_id%TYPE);

555: ,p_sex in per_all_people_f.sex%TYPE
556: ,p_effective_date in date
557: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
558: ,p_legislation_code in per_business_groups.legislation_code%TYPE
559: ,p_person_type_id in per_all_people_f.person_type_id%TYPE);
560: --
561: --
562: -- ---------------------------------------------------------------------------
563: -- |-----------------------< chk_employee_number >-------------------------|

Line 618: (p_person_id in per_all_people_f.person_id%TYPE

614: -- Access Status:
615: -- Internal Development Use Only.
616: --
617: procedure chk_employee_number
618: (p_person_id in per_all_people_f.person_id%TYPE
619: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
620: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
621: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
622: ,p_national_identifier in per_all_people_f.national_identifier%TYPE

Line 619: ,p_business_group_id in per_all_people_f.business_group_id%TYPE

615: -- Internal Development Use Only.
616: --
617: procedure chk_employee_number
618: (p_person_id in per_all_people_f.person_id%TYPE
619: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
620: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
621: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
622: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
623: ,p_effective_date in date

Line 620: ,p_person_type_id in per_all_people_f.person_type_id%TYPE

616: --
617: procedure chk_employee_number
618: (p_person_id in per_all_people_f.person_id%TYPE
619: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
620: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
621: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
622: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
623: ,p_effective_date in date
624: ,p_object_version_number in per_all_people_f.object_version_number%TYPE);

Line 621: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE

617: procedure chk_employee_number
618: (p_person_id in per_all_people_f.person_id%TYPE
619: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
620: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
621: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
622: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
623: ,p_effective_date in date
624: ,p_object_version_number in per_all_people_f.object_version_number%TYPE);
625: --

Line 622: ,p_national_identifier in per_all_people_f.national_identifier%TYPE

618: (p_person_id in per_all_people_f.person_id%TYPE
619: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
620: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
621: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
622: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
623: ,p_effective_date in date
624: ,p_object_version_number in per_all_people_f.object_version_number%TYPE);
625: --
626: procedure chk_employee_number

Line 624: ,p_object_version_number in per_all_people_f.object_version_number%TYPE);

620: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
621: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
622: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
623: ,p_effective_date in date
624: ,p_object_version_number in per_all_people_f.object_version_number%TYPE);
625: --
626: procedure chk_employee_number
627: (p_person_id in per_all_people_f.person_id%TYPE
628: ,p_business_group_id in per_all_people_f.business_group_id%TYPE

Line 627: (p_person_id in per_all_people_f.person_id%TYPE

623: ,p_effective_date in date
624: ,p_object_version_number in per_all_people_f.object_version_number%TYPE);
625: --
626: procedure chk_employee_number
627: (p_person_id in per_all_people_f.person_id%TYPE
628: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
629: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
630: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
631: ,p_national_identifier in per_all_people_f.national_identifier%TYPE

Line 628: ,p_business_group_id in per_all_people_f.business_group_id%TYPE

624: ,p_object_version_number in per_all_people_f.object_version_number%TYPE);
625: --
626: procedure chk_employee_number
627: (p_person_id in per_all_people_f.person_id%TYPE
628: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
629: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
630: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
631: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
632: ,p_effective_date in date

Line 629: ,p_person_type_id in per_all_people_f.person_type_id%TYPE

625: --
626: procedure chk_employee_number
627: (p_person_id in per_all_people_f.person_id%TYPE
628: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
629: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
630: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
631: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
632: ,p_effective_date in date
633: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

Line 630: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE

626: procedure chk_employee_number
627: (p_person_id in per_all_people_f.person_id%TYPE
628: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
629: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
630: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
631: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
632: ,p_effective_date in date
633: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
634: ,p_party_id in per_all_people_f.party_id%TYPE

Line 631: ,p_national_identifier in per_all_people_f.national_identifier%TYPE

627: (p_person_id in per_all_people_f.person_id%TYPE
628: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
629: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
630: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
631: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
632: ,p_effective_date in date
633: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
634: ,p_party_id in per_all_people_f.party_id%TYPE
635: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE

Line 633: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

629: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
630: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
631: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
632: ,p_effective_date in date
633: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
634: ,p_party_id in per_all_people_f.party_id%TYPE
635: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
636: ,p_start_date in per_periods_of_service.date_start%TYPE);
637: --

Line 634: ,p_party_id in per_all_people_f.party_id%TYPE

630: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
631: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
632: ,p_effective_date in date
633: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
634: ,p_party_id in per_all_people_f.party_id%TYPE
635: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
636: ,p_start_date in per_periods_of_service.date_start%TYPE);
637: --
638: --

Line 635: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE

631: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
632: ,p_effective_date in date
633: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
634: ,p_party_id in per_all_people_f.party_id%TYPE
635: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
636: ,p_start_date in per_periods_of_service.date_start%TYPE);
637: --
638: --
639: -- ---------------------------------------------------------------------------

Line 694: (p_person_id in per_all_people_f.person_id%TYPE

690: -- Access Status:
691: -- Internal Development Use Only.
692: --
693: procedure chk_npw_number
694: (p_person_id in per_all_people_f.person_id%TYPE
695: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
696: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
697: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
698: ,p_national_identifier in per_all_people_f.national_identifier%TYPE

Line 695: ,p_business_group_id in per_all_people_f.business_group_id%TYPE

691: -- Internal Development Use Only.
692: --
693: procedure chk_npw_number
694: (p_person_id in per_all_people_f.person_id%TYPE
695: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
696: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
697: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
698: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
699: ,p_effective_date in date

Line 696: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE

692: --
693: procedure chk_npw_number
694: (p_person_id in per_all_people_f.person_id%TYPE
695: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
696: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
697: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
698: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
699: ,p_effective_date in date
700: ,p_object_version_number in per_all_people_f.object_version_number%TYPE);

Line 697: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE

693: procedure chk_npw_number
694: (p_person_id in per_all_people_f.person_id%TYPE
695: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
696: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
697: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
698: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
699: ,p_effective_date in date
700: ,p_object_version_number in per_all_people_f.object_version_number%TYPE);
701: --

Line 698: ,p_national_identifier in per_all_people_f.national_identifier%TYPE

694: (p_person_id in per_all_people_f.person_id%TYPE
695: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
696: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
697: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
698: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
699: ,p_effective_date in date
700: ,p_object_version_number in per_all_people_f.object_version_number%TYPE);
701: --
702: procedure chk_npw_number

Line 700: ,p_object_version_number in per_all_people_f.object_version_number%TYPE);

696: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
697: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
698: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
699: ,p_effective_date in date
700: ,p_object_version_number in per_all_people_f.object_version_number%TYPE);
701: --
702: procedure chk_npw_number
703: (p_person_id in per_all_people_f.person_id%TYPE
704: ,p_business_group_id in per_all_people_f.business_group_id%TYPE

Line 703: (p_person_id in per_all_people_f.person_id%TYPE

699: ,p_effective_date in date
700: ,p_object_version_number in per_all_people_f.object_version_number%TYPE);
701: --
702: procedure chk_npw_number
703: (p_person_id in per_all_people_f.person_id%TYPE
704: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
705: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
706: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
707: ,p_national_identifier in per_all_people_f.national_identifier%TYPE

Line 704: ,p_business_group_id in per_all_people_f.business_group_id%TYPE

700: ,p_object_version_number in per_all_people_f.object_version_number%TYPE);
701: --
702: procedure chk_npw_number
703: (p_person_id in per_all_people_f.person_id%TYPE
704: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
705: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
706: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
707: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
708: ,p_effective_date in date

Line 705: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE

701: --
702: procedure chk_npw_number
703: (p_person_id in per_all_people_f.person_id%TYPE
704: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
705: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
706: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
707: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
708: ,p_effective_date in date
709: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

Line 706: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE

702: procedure chk_npw_number
703: (p_person_id in per_all_people_f.person_id%TYPE
704: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
705: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
706: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
707: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
708: ,p_effective_date in date
709: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
710: ,p_party_id in per_all_people_f.party_id%TYPE

Line 707: ,p_national_identifier in per_all_people_f.national_identifier%TYPE

703: (p_person_id in per_all_people_f.person_id%TYPE
704: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
705: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
706: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
707: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
708: ,p_effective_date in date
709: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
710: ,p_party_id in per_all_people_f.party_id%TYPE
711: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE

Line 709: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

705: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
706: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
707: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
708: ,p_effective_date in date
709: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
710: ,p_party_id in per_all_people_f.party_id%TYPE
711: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
712: ,p_start_date in date);
713: --

Line 710: ,p_party_id in per_all_people_f.party_id%TYPE

706: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
707: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
708: ,p_effective_date in date
709: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
710: ,p_party_id in per_all_people_f.party_id%TYPE
711: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
712: ,p_start_date in date);
713: --
714: -- ---------------------------------------------------------------------------

Line 711: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE

707: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
708: ,p_effective_date in date
709: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
710: ,p_party_id in per_all_people_f.party_id%TYPE
711: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
712: ,p_start_date in date);
713: --
714: -- ---------------------------------------------------------------------------
715: -- |-----------------------< chk_sex_title >-------------------------------|

Line 777: (p_person_id in per_all_people_f.person_id%TYPE

773: -- Access Status:
774: -- Internal Developer Use Only.
775: --
776: procedure chk_sex_title
777: (p_person_id in per_all_people_f.person_id%TYPE
778: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
779: ,p_person_type_id in per_all_people_f.person_type_id%TYPe
780: ,p_title in per_all_people_f.title%TYPE
781: ,p_sex in per_all_people_f.sex%TYPE

Line 778: ,p_business_group_id in per_all_people_f.business_group_id%TYPE

774: -- Internal Developer Use Only.
775: --
776: procedure chk_sex_title
777: (p_person_id in per_all_people_f.person_id%TYPE
778: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
779: ,p_person_type_id in per_all_people_f.person_type_id%TYPe
780: ,p_title in per_all_people_f.title%TYPE
781: ,p_sex in per_all_people_f.sex%TYPE
782: ,p_effective_date in date

Line 779: ,p_person_type_id in per_all_people_f.person_type_id%TYPe

775: --
776: procedure chk_sex_title
777: (p_person_id in per_all_people_f.person_id%TYPE
778: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
779: ,p_person_type_id in per_all_people_f.person_type_id%TYPe
780: ,p_title in per_all_people_f.title%TYPE
781: ,p_sex in per_all_people_f.sex%TYPE
782: ,p_effective_date in date
783: ,p_validation_start_date in date

Line 780: ,p_title in per_all_people_f.title%TYPE

776: procedure chk_sex_title
777: (p_person_id in per_all_people_f.person_id%TYPE
778: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
779: ,p_person_type_id in per_all_people_f.person_type_id%TYPe
780: ,p_title in per_all_people_f.title%TYPE
781: ,p_sex in per_all_people_f.sex%TYPE
782: ,p_effective_date in date
783: ,p_validation_start_date in date
784: ,p_validation_end_date in date

Line 781: ,p_sex in per_all_people_f.sex%TYPE

777: (p_person_id in per_all_people_f.person_id%TYPE
778: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
779: ,p_person_type_id in per_all_people_f.person_type_id%TYPe
780: ,p_title in per_all_people_f.title%TYPE
781: ,p_sex in per_all_people_f.sex%TYPE
782: ,p_effective_date in date
783: ,p_validation_start_date in date
784: ,p_validation_end_date in date
785: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

Line 785: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

781: ,p_sex in per_all_people_f.sex%TYPE
782: ,p_effective_date in date
783: ,p_validation_start_date in date
784: ,p_validation_end_date in date
785: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
786: );
787: --
788: -- ---------------------------------------------------------------------------
789: -- |-----------------------< chk_applicant_number >------------------------|

Line 861: (p_person_id in per_all_people_f.person_id%TYPE

857: -- Access Status:
858: -- Internal Table Handler Use Only.
859: --
860: procedure chk_applicant_number
861: (p_person_id in per_all_people_f.person_id%TYPE
862: ,p_applicant_number in out nocopy per_all_people_f.applicant_number%TYPE
863: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
864: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
865: ,p_person_type_id in per_all_people_f.person_type_id%TYPE

Line 862: ,p_applicant_number in out nocopy per_all_people_f.applicant_number%TYPE

858: -- Internal Table Handler Use Only.
859: --
860: procedure chk_applicant_number
861: (p_person_id in per_all_people_f.person_id%TYPE
862: ,p_applicant_number in out nocopy per_all_people_f.applicant_number%TYPE
863: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
864: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
865: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
866: ,p_effective_date in date

Line 863: ,p_business_group_id in per_all_people_f.business_group_id%TYPE

859: --
860: procedure chk_applicant_number
861: (p_person_id in per_all_people_f.person_id%TYPE
862: ,p_applicant_number in out nocopy per_all_people_f.applicant_number%TYPE
863: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
864: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
865: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
866: ,p_effective_date in date
867: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

Line 864: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE

860: procedure chk_applicant_number
861: (p_person_id in per_all_people_f.person_id%TYPE
862: ,p_applicant_number in out nocopy per_all_people_f.applicant_number%TYPE
863: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
864: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
865: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
866: ,p_effective_date in date
867: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
868: );

Line 865: ,p_person_type_id in per_all_people_f.person_type_id%TYPE

861: (p_person_id in per_all_people_f.person_id%TYPE
862: ,p_applicant_number in out nocopy per_all_people_f.applicant_number%TYPE
863: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
864: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
865: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
866: ,p_effective_date in date
867: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
868: );
869: --

Line 867: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

863: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
864: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
865: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
866: ,p_effective_date in date
867: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
868: );
869: --
870: procedure chk_applicant_number
871: (p_person_id in per_all_people_f.person_id%TYPE

Line 871: (p_person_id in per_all_people_f.person_id%TYPE

867: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
868: );
869: --
870: procedure chk_applicant_number
871: (p_person_id in per_all_people_f.person_id%TYPE
872: ,p_applicant_number in out nocopy per_all_people_f.applicant_number%TYPE
873: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
874: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
875: ,p_person_type_id in per_all_people_f.person_type_id%TYPE

Line 872: ,p_applicant_number in out nocopy per_all_people_f.applicant_number%TYPE

868: );
869: --
870: procedure chk_applicant_number
871: (p_person_id in per_all_people_f.person_id%TYPE
872: ,p_applicant_number in out nocopy per_all_people_f.applicant_number%TYPE
873: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
874: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
875: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
876: ,p_effective_date in date

Line 873: ,p_business_group_id in per_all_people_f.business_group_id%TYPE

869: --
870: procedure chk_applicant_number
871: (p_person_id in per_all_people_f.person_id%TYPE
872: ,p_applicant_number in out nocopy per_all_people_f.applicant_number%TYPE
873: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
874: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
875: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
876: ,p_effective_date in date
877: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

Line 874: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE

870: procedure chk_applicant_number
871: (p_person_id in per_all_people_f.person_id%TYPE
872: ,p_applicant_number in out nocopy per_all_people_f.applicant_number%TYPE
873: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
874: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
875: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
876: ,p_effective_date in date
877: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
878: ,p_party_id in per_all_people_f.party_id%TYPE

Line 875: ,p_person_type_id in per_all_people_f.person_type_id%TYPE

871: (p_person_id in per_all_people_f.person_id%TYPE
872: ,p_applicant_number in out nocopy per_all_people_f.applicant_number%TYPE
873: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
874: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
875: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
876: ,p_effective_date in date
877: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
878: ,p_party_id in per_all_people_f.party_id%TYPE
879: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE

Line 877: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

873: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
874: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
875: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
876: ,p_effective_date in date
877: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
878: ,p_party_id in per_all_people_f.party_id%TYPE
879: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
880: ,p_start_date in date
881: );

Line 878: ,p_party_id in per_all_people_f.party_id%TYPE

874: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
875: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
876: ,p_effective_date in date
877: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
878: ,p_party_id in per_all_people_f.party_id%TYPE
879: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
880: ,p_start_date in date
881: );
882: --

Line 879: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE

875: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
876: ,p_effective_date in date
877: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
878: ,p_party_id in per_all_people_f.party_id%TYPE
879: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
880: ,p_start_date in date
881: );
882: --
883: --

Line 917: (p_person_id in per_all_people_f.person_id%TYPE

913: -- Access Status:
914: -- Internal Developer Use Only.
915: --
916: procedure chk_date_emp_data_verified
917: (p_person_id in per_all_people_f.person_id%TYPE
918: ,p_date_employee_data_verified in
919: per_all_people_f.date_employee_data_verified%TYPE
920: ,p_effective_start_date in date
921: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

Line 919: per_all_people_f.date_employee_data_verified%TYPE

915: --
916: procedure chk_date_emp_data_verified
917: (p_person_id in per_all_people_f.person_id%TYPE
918: ,p_date_employee_data_verified in
919: per_all_people_f.date_employee_data_verified%TYPE
920: ,p_effective_start_date in date
921: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
922: );
923: --

Line 921: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

917: (p_person_id in per_all_people_f.person_id%TYPE
918: ,p_date_employee_data_verified in
919: per_all_people_f.date_employee_data_verified%TYPE
920: ,p_effective_start_date in date
921: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
922: );
923: --
924: --
925: -- ---------------------------------------------------------------------------

Line 959: (p_person_id in per_all_people_f.person_id%TYPE

955: -- Access Status:
956: -- Internal Table Handler Use Only.
957: --
958: procedure chk_vendor_id
959: (p_person_id in per_all_people_f.person_id%TYPE
960: ,p_vendor_id in per_all_people_f.vendor_id%TYPE
961: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
962: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
963: ,p_effective_date in date

Line 960: ,p_vendor_id in per_all_people_f.vendor_id%TYPE

956: -- Internal Table Handler Use Only.
957: --
958: procedure chk_vendor_id
959: (p_person_id in per_all_people_f.person_id%TYPE
960: ,p_vendor_id in per_all_people_f.vendor_id%TYPE
961: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
962: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
963: ,p_effective_date in date
964: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

Line 961: ,p_person_type_id in per_all_people_f.person_type_id%TYPE

957: --
958: procedure chk_vendor_id
959: (p_person_id in per_all_people_f.person_id%TYPE
960: ,p_vendor_id in per_all_people_f.vendor_id%TYPE
961: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
962: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
963: ,p_effective_date in date
964: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
965: );

Line 962: ,p_business_group_id in per_all_people_f.business_group_id%TYPE

958: procedure chk_vendor_id
959: (p_person_id in per_all_people_f.person_id%TYPE
960: ,p_vendor_id in per_all_people_f.vendor_id%TYPE
961: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
962: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
963: ,p_effective_date in date
964: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
965: );
966: --

Line 964: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

960: ,p_vendor_id in per_all_people_f.vendor_id%TYPE
961: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
962: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
963: ,p_effective_date in date
964: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
965: );
966: --
967: end per_per_bus;