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_BUS1 dependencies on PER_ALL_PEOPLE_F

Line 94: (p_person_id in per_all_people_f.person_id%TYPE

90: -- |------------------< chk_unsupported_attributes >-----------------------|
91: -- ---------------------------------------------------------------------------
92: --
93: procedure chk_unsupported_attributes
94: (p_person_id in per_all_people_f.person_id%TYPE
95: ,p_fast_path_employee in per_all_people_f.fast_path_employee%TYPE
96: ,p_order_name in per_all_people_f.order_name%TYPE
97: ,p_projected_start_date in per_all_people_f.projected_start_date%TYPE
98: ,p_rehire_authorizor in per_all_people_f.rehire_authorizor%TYPE

Line 95: ,p_fast_path_employee in per_all_people_f.fast_path_employee%TYPE

91: -- ---------------------------------------------------------------------------
92: --
93: procedure chk_unsupported_attributes
94: (p_person_id in per_all_people_f.person_id%TYPE
95: ,p_fast_path_employee in per_all_people_f.fast_path_employee%TYPE
96: ,p_order_name in per_all_people_f.order_name%TYPE
97: ,p_projected_start_date in per_all_people_f.projected_start_date%TYPE
98: ,p_rehire_authorizor in per_all_people_f.rehire_authorizor%TYPE
99: ,p_effective_date in date

Line 96: ,p_order_name in per_all_people_f.order_name%TYPE

92: --
93: procedure chk_unsupported_attributes
94: (p_person_id in per_all_people_f.person_id%TYPE
95: ,p_fast_path_employee in per_all_people_f.fast_path_employee%TYPE
96: ,p_order_name in per_all_people_f.order_name%TYPE
97: ,p_projected_start_date in per_all_people_f.projected_start_date%TYPE
98: ,p_rehire_authorizor in per_all_people_f.rehire_authorizor%TYPE
99: ,p_effective_date in date
100: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

Line 97: ,p_projected_start_date in per_all_people_f.projected_start_date%TYPE

93: procedure chk_unsupported_attributes
94: (p_person_id in per_all_people_f.person_id%TYPE
95: ,p_fast_path_employee in per_all_people_f.fast_path_employee%TYPE
96: ,p_order_name in per_all_people_f.order_name%TYPE
97: ,p_projected_start_date in per_all_people_f.projected_start_date%TYPE
98: ,p_rehire_authorizor in per_all_people_f.rehire_authorizor%TYPE
99: ,p_effective_date in date
100: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
101: )

Line 98: ,p_rehire_authorizor in per_all_people_f.rehire_authorizor%TYPE

94: (p_person_id in per_all_people_f.person_id%TYPE
95: ,p_fast_path_employee in per_all_people_f.fast_path_employee%TYPE
96: ,p_order_name in per_all_people_f.order_name%TYPE
97: ,p_projected_start_date in per_all_people_f.projected_start_date%TYPE
98: ,p_rehire_authorizor in per_all_people_f.rehire_authorizor%TYPE
99: ,p_effective_date in date
100: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
101: )
102: is

Line 100: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

96: ,p_order_name in per_all_people_f.order_name%TYPE
97: ,p_projected_start_date in per_all_people_f.projected_start_date%TYPE
98: ,p_rehire_authorizor in per_all_people_f.rehire_authorizor%TYPE
99: ,p_effective_date in date
100: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
101: )
102: is
103: --
104: l_proc varchar2(72) := g_package||'chk_unsupported_attributes';

Line 193: (p_person_id in per_all_people_f.person_id%TYPE

189: -- |----------------< chk_correspondence_language >--------------------------|
190: -- ---------------------------------------------------------------------------
191: --
192: procedure chk_correspondence_language
193: (p_person_id in per_all_people_f.person_id%TYPE
194: ,p_effective_date in date
195: ,p_correspondence_language in per_all_people_f.correspondence_language%TYPE
196: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
197: )

Line 195: ,p_correspondence_language in per_all_people_f.correspondence_language%TYPE

191: --
192: procedure chk_correspondence_language
193: (p_person_id in per_all_people_f.person_id%TYPE
194: ,p_effective_date in date
195: ,p_correspondence_language in per_all_people_f.correspondence_language%TYPE
196: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
197: )
198: is
199: --

Line 196: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

192: procedure chk_correspondence_language
193: (p_person_id in per_all_people_f.person_id%TYPE
194: ,p_effective_date in date
195: ,p_correspondence_language in per_all_people_f.correspondence_language%TYPE
196: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
197: )
198: is
199: --
200: l_proc varchar2(72) := g_package||'chk_correspondence_language';

Line 258: (p_associated_column1 => 'PER_ALL_PEOPLE_F.CORRESPONDENCE_LANGUAGE'

254: hr_utility.set_location('Leaving '||l_proc,30);
255: exception
256: when app_exception.application_exception then
257: if hr_multi_message.exception_add
258: (p_associated_column1 => 'PER_ALL_PEOPLE_F.CORRESPONDENCE_LANGUAGE'
259: )
260: then
261: hr_utility.set_location(' Leaving:'||l_proc, 40);
262: raise;

Line 306: (p_associated_column1 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_STRT_DT'

302: hr_utility.set_location('Leaving '||l_proc,30);
303: exception
304: when app_exception.application_exception then
305: if hr_multi_message.exception_add
306: (p_associated_column1 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_STRT_DT'
307: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_END_DT'
308: ) then
309: hr_utility.set_location(' Leaving:'||l_proc, 40);
310: raise;

Line 307: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_END_DT'

303: exception
304: when app_exception.application_exception then
305: if hr_multi_message.exception_add
306: (p_associated_column1 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_STRT_DT'
307: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_END_DT'
308: ) then
309: hr_utility.set_location(' Leaving:'||l_proc, 40);
310: raise;
311: end if;

Line 338: (p_check_column1 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_NAME'

334: -- Check that the ben_no_cvg_flag is set accordingly based on the value
335: -- of the covered under medicare flag.
336: --
337: if hr_multi_message.no_all_inclusive_error
338: (p_check_column1 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_NAME'
339: ,p_check_column2 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_END_DT'
340: )
341: then
342: if p_attribute10 = 'Y' or

Line 339: ,p_check_column2 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_END_DT'

335: -- of the covered under medicare flag.
336: --
337: if hr_multi_message.no_all_inclusive_error
338: (p_check_column1 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_NAME'
339: ,p_check_column2 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_END_DT'
340: )
341: then
342: if p_attribute10 = 'Y' or
343: (p_coord_ben_med_insr_crr_name is not null and

Line 359: (p_associated_column1 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_NAME'

355: hr_utility.set_location('Leaving '||l_proc,30);
356: exception
357: when app_exception.application_exception then
358: if hr_multi_message.exception_add
359: (p_associated_column1 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_NAME'
360: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_END_DT'
361: ,p_associated_column3 => 'PER_ALL_PEOPLE_F.COORD_BEN_NO_CVG_FLAG'
362: ,p_associated_column4 => 'PER_ALL_PEOPLE_F.ATTRIBUTE10'
363: ) then

Line 360: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_END_DT'

356: exception
357: when app_exception.application_exception then
358: if hr_multi_message.exception_add
359: (p_associated_column1 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_NAME'
360: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_END_DT'
361: ,p_associated_column3 => 'PER_ALL_PEOPLE_F.COORD_BEN_NO_CVG_FLAG'
362: ,p_associated_column4 => 'PER_ALL_PEOPLE_F.ATTRIBUTE10'
363: ) then
364: hr_utility.set_location(' Leaving:'||l_proc, 40);

Line 361: ,p_associated_column3 => 'PER_ALL_PEOPLE_F.COORD_BEN_NO_CVG_FLAG'

357: when app_exception.application_exception then
358: if hr_multi_message.exception_add
359: (p_associated_column1 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_NAME'
360: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_END_DT'
361: ,p_associated_column3 => 'PER_ALL_PEOPLE_F.COORD_BEN_NO_CVG_FLAG'
362: ,p_associated_column4 => 'PER_ALL_PEOPLE_F.ATTRIBUTE10'
363: ) then
364: hr_utility.set_location(' Leaving:'||l_proc, 40);
365: raise;

Line 362: ,p_associated_column4 => 'PER_ALL_PEOPLE_F.ATTRIBUTE10'

358: if hr_multi_message.exception_add
359: (p_associated_column1 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_NAME'
360: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_END_DT'
361: ,p_associated_column3 => 'PER_ALL_PEOPLE_F.COORD_BEN_NO_CVG_FLAG'
362: ,p_associated_column4 => 'PER_ALL_PEOPLE_F.ATTRIBUTE10'
363: ) then
364: hr_utility.set_location(' Leaving:'||l_proc, 40);
365: raise;
366: end if;

Line 374: (p_person_id in per_all_people_f.person_id%TYPE

370: -- |----------------< chk_fte_capacity >--------------------------|
371: -- ---------------------------------------------------------------------------
372: --
373: procedure chk_fte_capacity
374: (p_person_id in per_all_people_f.person_id%TYPE
375: ,p_effective_date in date
376: ,p_fte_capacity in per_all_people_f.fte_capacity%TYPE
377: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
378: )

Line 376: ,p_fte_capacity in per_all_people_f.fte_capacity%TYPE

372: --
373: procedure chk_fte_capacity
374: (p_person_id in per_all_people_f.person_id%TYPE
375: ,p_effective_date in date
376: ,p_fte_capacity in per_all_people_f.fte_capacity%TYPE
377: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
378: )
379: is
380: --

Line 377: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

373: procedure chk_fte_capacity
374: (p_person_id in per_all_people_f.person_id%TYPE
375: ,p_effective_date in date
376: ,p_fte_capacity in per_all_people_f.fte_capacity%TYPE
377: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
378: )
379: is
380: --
381: l_proc varchar2(72) := g_package||'chk_fte_capacity';

Line 431: (p_associated_column1 => 'PER_ALL_PEOPLE_F.FTE_CAPACITY'

427: hr_utility.set_location('Leaving '||l_proc,30);
428: exception
429: when app_exception.application_exception then
430: if hr_multi_message.exception_add
431: (p_associated_column1 => 'PER_ALL_PEOPLE_F.FTE_CAPACITY'
432: ) then
433: hr_utility.set_location(' Leaving:'||l_proc, 40);
434: raise;
435: end if;

Line 464: (p_check_column1 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_STRT_DT'

460: -- If any of the attributes have been set for benefits coverage then at
461: -- minimum the insurance carrier name must be set.
462: --
463: if hr_multi_message.no_all_inclusive_error
464: (p_check_column1 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_STRT_DT'
465: ,p_check_column2 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_END_DT'
466: )
467: then
468: if p_coord_ben_med_insr_crr_name is null and

Line 465: ,p_check_column2 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_END_DT'

461: -- minimum the insurance carrier name must be set.
462: --
463: if hr_multi_message.no_all_inclusive_error
464: (p_check_column1 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_STRT_DT'
465: ,p_check_column2 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_END_DT'
466: )
467: then
468: if p_coord_ben_med_insr_crr_name is null and
469: (p_coord_ben_med_cvg_strt_dt is not null or

Line 489: (p_associated_column1 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_NAME'

485: hr_utility.set_location('Leaving '||l_proc,30);
486: exception
487: when app_exception.application_exception then
488: if hr_multi_message.exception_add
489: (p_associated_column1 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_NAME'
490: ) then
491: hr_utility.set_location(' Leaving:'||l_proc, 40);
492: raise;
493: end if;

Line 502: (p_person_id in per_all_people_f.person_id%TYPE

498: -- |-----------------< chk_BACKGROUND_CHECK_STATUS >-----------------------|
499: -- ---------------------------------------------------------------------------
500: --
501: procedure chk_BACKGROUND_CHECK_STATUS
502: (p_person_id in per_all_people_f.person_id%TYPE
503: ,p_BACKGROUND_CHECK_STATUS in per_all_people_f.BACKGROUND_CHECK_STATUS%TYPE
504: ,p_effective_date in date
505: ,p_validation_start_date in date
506: ,p_validation_end_date in date

Line 503: ,p_BACKGROUND_CHECK_STATUS in per_all_people_f.BACKGROUND_CHECK_STATUS%TYPE

499: -- ---------------------------------------------------------------------------
500: --
501: procedure chk_BACKGROUND_CHECK_STATUS
502: (p_person_id in per_all_people_f.person_id%TYPE
503: ,p_BACKGROUND_CHECK_STATUS in per_all_people_f.BACKGROUND_CHECK_STATUS%TYPE
504: ,p_effective_date in date
505: ,p_validation_start_date in date
506: ,p_validation_end_date in date
507: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

Line 507: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

503: ,p_BACKGROUND_CHECK_STATUS in per_all_people_f.BACKGROUND_CHECK_STATUS%TYPE
504: ,p_effective_date in date
505: ,p_validation_start_date in date
506: ,p_validation_end_date in date
507: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
508: )
509: is
510: --
511: l_proc varchar2(72) := g_package||'chk_BACKGROUND_CHECK_STATUS';

Line 585: (p_associated_column1 => 'PER_ALL_PEOPLE_F.BACKGROUND_CHECK_STATUS'

581: hr_utility.set_location(' Leaving:'|| l_proc, 40);
582: exception
583: when app_exception.application_exception then
584: if hr_multi_message.exception_add
585: (p_associated_column1 => 'PER_ALL_PEOPLE_F.BACKGROUND_CHECK_STATUS'
586: ) then
587: hr_utility.set_location(' Leaving:'||l_proc, 50);
588: raise;
589: end if;

Line 598: (p_person_id in per_all_people_f.person_id%TYPE

594: -- |--------------------------< chk_blood_type >---------------------------|
595: -- ---------------------------------------------------------------------------
596: --
597: procedure chk_blood_type
598: (p_person_id in per_all_people_f.person_id%TYPE
599: ,p_blood_type in per_all_people_f.blood_type%TYPE
600: ,p_effective_date in date
601: ,p_validation_start_date in date
602: ,p_validation_end_date in date

Line 599: ,p_blood_type in per_all_people_f.blood_type%TYPE

595: -- ---------------------------------------------------------------------------
596: --
597: procedure chk_blood_type
598: (p_person_id in per_all_people_f.person_id%TYPE
599: ,p_blood_type in per_all_people_f.blood_type%TYPE
600: ,p_effective_date in date
601: ,p_validation_start_date in date
602: ,p_validation_end_date in date
603: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

Line 603: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

599: ,p_blood_type in per_all_people_f.blood_type%TYPE
600: ,p_effective_date in date
601: ,p_validation_start_date in date
602: ,p_validation_end_date in date
603: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
604: )
605: is
606: --
607: l_proc varchar2(72) := g_package||'chk_blood_type';

Line 681: (p_associated_column1 => 'PER_ALL_PEOPLE_F.BLOOD_TYPE'

677: hr_utility.set_location(' Leaving:'|| l_proc, 40);
678: exception
679: when app_exception.application_exception then
680: if hr_multi_message.exception_add
681: (p_associated_column1 => 'PER_ALL_PEOPLE_F.BLOOD_TYPE'
682: ) then
683: hr_utility.set_location(' Leaving:'||l_proc, 50);
684: raise;
685: end if;

Line 694: (p_person_id in per_all_people_f.person_id%TYPE

690: -- |-----------------< chk_student_status >-----------------------|
691: -- ---------------------------------------------------------------------------
692: --
693: procedure chk_student_status
694: (p_person_id in per_all_people_f.person_id%TYPE
695: ,p_student_status in per_all_people_f.student_status%TYPE
696: ,p_effective_date in date
697: ,p_validation_start_date in date
698: ,p_validation_end_date in date

Line 695: ,p_student_status in per_all_people_f.student_status%TYPE

691: -- ---------------------------------------------------------------------------
692: --
693: procedure chk_student_status
694: (p_person_id in per_all_people_f.person_id%TYPE
695: ,p_student_status in per_all_people_f.student_status%TYPE
696: ,p_effective_date in date
697: ,p_validation_start_date in date
698: ,p_validation_end_date in date
699: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

Line 699: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

695: ,p_student_status in per_all_people_f.student_status%TYPE
696: ,p_effective_date in date
697: ,p_validation_start_date in date
698: ,p_validation_end_date in date
699: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
700: )
701: is
702: --
703: l_proc varchar2(72) := g_package||'chk_student_status';

Line 777: (p_associated_column1 => 'PER_ALL_PEOPLE_F.STUDENT_STATUS'

773: hr_utility.set_location(' Leaving:'|| l_proc, 40);
774: exception
775: when app_exception.application_exception then
776: if hr_multi_message.exception_add
777: (p_associated_column1 => 'PER_ALL_PEOPLE_F.STUDENT_STATUS'
778: ) then
779: hr_utility.set_location(' Leaving:'||l_proc,50);
780: raise;
781: end if;

Line 790: (p_person_id in per_all_people_f.person_id%TYPE

786: -- |-------------------------< chk_work_schedule >-------------------------|
787: -- ---------------------------------------------------------------------------
788: --
789: procedure chk_work_schedule
790: (p_person_id in per_all_people_f.person_id%TYPE
791: ,p_work_schedule in per_all_people_f.work_schedule%TYPE
792: ,p_effective_date in date
793: ,p_validation_start_date in date
794: ,p_validation_end_date in date

Line 791: ,p_work_schedule in per_all_people_f.work_schedule%TYPE

787: -- ---------------------------------------------------------------------------
788: --
789: procedure chk_work_schedule
790: (p_person_id in per_all_people_f.person_id%TYPE
791: ,p_work_schedule in per_all_people_f.work_schedule%TYPE
792: ,p_effective_date in date
793: ,p_validation_start_date in date
794: ,p_validation_end_date in date
795: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

Line 795: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

791: ,p_work_schedule in per_all_people_f.work_schedule%TYPE
792: ,p_effective_date in date
793: ,p_validation_start_date in date
794: ,p_validation_end_date in date
795: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
796: )
797: is
798: --
799: l_proc varchar2(72) := g_package||'chk_work_schedule';

Line 873: (p_associated_column1 => 'PER_ALL_PEOPLE_F.WORK_SCHEDULE'

869: hr_utility.set_location(' Leaving:'|| l_proc, 40);
870: exception
871: when app_exception.application_exception then
872: if hr_multi_message.exception_add
873: (p_associated_column1 => 'PER_ALL_PEOPLE_F.WORK_SCHEDULE'
874: ) then
875: hr_utility.set_location(' Leaving:'||l_proc, 50);
876: raise;
877: end if;

Line 886: (p_person_id in per_all_people_f.person_id%TYPE

882: -- |-------------------< chk_rehire_recommendation >-----------------------|
883: -- ---------------------------------------------------------------------------
884: --
885: procedure chk_rehire_recommendation
886: (p_person_id in per_all_people_f.person_id%TYPE
887: ,p_rehire_recommendation in per_all_people_f.rehire_recommendation%TYPE
888: ,p_effective_date in date
889: ,p_validation_start_date in date
890: ,p_validation_end_date in date

Line 887: ,p_rehire_recommendation in per_all_people_f.rehire_recommendation%TYPE

883: -- ---------------------------------------------------------------------------
884: --
885: procedure chk_rehire_recommendation
886: (p_person_id in per_all_people_f.person_id%TYPE
887: ,p_rehire_recommendation in per_all_people_f.rehire_recommendation%TYPE
888: ,p_effective_date in date
889: ,p_validation_start_date in date
890: ,p_validation_end_date in date
891: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

Line 891: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

887: ,p_rehire_recommendation in per_all_people_f.rehire_recommendation%TYPE
888: ,p_effective_date in date
889: ,p_validation_start_date in date
890: ,p_validation_end_date in date
891: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
892: )
893: is
894: --
895: l_proc varchar2(72) := g_package||'chk_rehire_recommendation';

Line 969: (p_associated_column1 => 'PER_ALL_PEOPLE_F.REHIRE_RECOMMENDATION'

965: hr_utility.set_location(' Leaving:'|| l_proc, 40);
966: exception
967: when app_exception.application_exception then
968: if hr_multi_message.exception_add
969: (p_associated_column1 => 'PER_ALL_PEOPLE_F.REHIRE_RECOMMENDATION'
970: ) then
971: hr_utility.set_location(' Leaving:'||l_proc, 50);
972: raise;
973: end if;

Line 1008: (p_person_id in per_all_people_f.person_id%TYPE

1004: -- Access Status:
1005: -- Internal Table Handler Use Only.
1006:
1007: procedure chk_benefit_group_id
1008: (p_person_id in per_all_people_f.person_id%TYPE
1009: ,p_benefit_group_id in per_all_people_f.benefit_group_id%TYPE
1010: ,p_effective_date in date
1011: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1012: )

Line 1009: ,p_benefit_group_id in per_all_people_f.benefit_group_id%TYPE

1005: -- Internal Table Handler Use Only.
1006:
1007: procedure chk_benefit_group_id
1008: (p_person_id in per_all_people_f.person_id%TYPE
1009: ,p_benefit_group_id in per_all_people_f.benefit_group_id%TYPE
1010: ,p_effective_date in date
1011: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1012: )
1013: is

Line 1011: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

1007: procedure chk_benefit_group_id
1008: (p_person_id in per_all_people_f.person_id%TYPE
1009: ,p_benefit_group_id in per_all_people_f.benefit_group_id%TYPE
1010: ,p_effective_date in date
1011: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1012: )
1013: is
1014: --
1015: cursor csr_chk_benefit_group_id is

Line 1052: (p_associated_column1 => 'PER_ALL_PEOPLE_F.BENEFIT_GROUP_ID'

1048: --
1049: exception
1050: when app_exception.application_exception then
1051: if hr_multi_message.exception_add
1052: (p_associated_column1 => 'PER_ALL_PEOPLE_F.BENEFIT_GROUP_ID'
1053: ) then
1054: hr_utility.set_location(' Leaving:'||l_proc, 40);
1055: raise;
1056: end if;

Line 1093: (p_person_id in per_all_people_f.person_id%TYPE

1089: -- Access Status:
1090: -- Internal Table Handler Use Only.
1091: --
1092: procedure chk_date_death_and_rcpt_cert
1093: (p_person_id in per_all_people_f.person_id%TYPE
1094: ,p_receipt_of_death_cert_date in per_all_people_f.receipt_of_death_cert_date%TYPE
1095: ,p_effective_date in date
1096: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1097: ,p_date_of_death in date

Line 1094: ,p_receipt_of_death_cert_date in per_all_people_f.receipt_of_death_cert_date%TYPE

1090: -- Internal Table Handler Use Only.
1091: --
1092: procedure chk_date_death_and_rcpt_cert
1093: (p_person_id in per_all_people_f.person_id%TYPE
1094: ,p_receipt_of_death_cert_date in per_all_people_f.receipt_of_death_cert_date%TYPE
1095: ,p_effective_date in date
1096: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1097: ,p_date_of_death in date
1098: )

Line 1096: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

1092: procedure chk_date_death_and_rcpt_cert
1093: (p_person_id in per_all_people_f.person_id%TYPE
1094: ,p_receipt_of_death_cert_date in per_all_people_f.receipt_of_death_cert_date%TYPE
1095: ,p_effective_date in date
1096: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1097: ,p_date_of_death in date
1098: )
1099: is
1100: --

Line 1111: (p_associated_column1 => 'PER_ALL_PEOPLE_F.RECEIPT_OF_DEATH_CERT_DATE'

1107: if p_receipt_of_death_cert_date is NOT NULL then
1108: if p_date_of_death is NULL then
1109: hr_utility.set_message(800,'PER_52424_DATE_DEATH_RCPT_CERT');
1110: hr_multi_message.add
1111: (p_associated_column1 => 'PER_ALL_PEOPLE_F.RECEIPT_OF_DEATH_CERT_DATE'
1112: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_DEATH'
1113: );
1114: elsif p_receipt_of_death_cert_date <= nvl(p_date_of_death, hr_api.g_date) then
1115: hr_utility.set_message(800,'PER_52962_CERT_DTE_LT_DOD');

Line 1112: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_DEATH'

1108: if p_date_of_death is NULL then
1109: hr_utility.set_message(800,'PER_52424_DATE_DEATH_RCPT_CERT');
1110: hr_multi_message.add
1111: (p_associated_column1 => 'PER_ALL_PEOPLE_F.RECEIPT_OF_DEATH_CERT_DATE'
1112: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_DEATH'
1113: );
1114: elsif p_receipt_of_death_cert_date <= nvl(p_date_of_death, hr_api.g_date) then
1115: hr_utility.set_message(800,'PER_52962_CERT_DTE_LT_DOD');
1116: hr_multi_message.add

Line 1117: (p_associated_column1 => 'PER_ALL_PEOPLE_F.RECEIPT_OF_DEATH_CERT_DATE'

1113: );
1114: elsif p_receipt_of_death_cert_date <= nvl(p_date_of_death, hr_api.g_date) then
1115: hr_utility.set_message(800,'PER_52962_CERT_DTE_LT_DOD');
1116: hr_multi_message.add
1117: (p_associated_column1 => 'PER_ALL_PEOPLE_F.RECEIPT_OF_DEATH_CERT_DATE'
1118: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_DEATH'
1119: );
1120: end if;
1121: end if;

Line 1118: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_DEATH'

1114: elsif p_receipt_of_death_cert_date <= nvl(p_date_of_death, hr_api.g_date) then
1115: hr_utility.set_message(800,'PER_52962_CERT_DTE_LT_DOD');
1116: hr_multi_message.add
1117: (p_associated_column1 => 'PER_ALL_PEOPLE_F.RECEIPT_OF_DEATH_CERT_DATE'
1118: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_DEATH'
1119: );
1120: end if;
1121: end if;
1122: --

Line 1160: (p_person_id in per_all_people_f.person_id%TYPE

1156: -- Access Status:
1157: -- Internal Table Handler Use Only.
1158: --
1159: procedure chk_birth_adoption_date
1160: (p_person_id in per_all_people_f.person_id%TYPE
1161: ,p_dpdnt_adoption_date in per_all_people_f.dpdnt_adoption_date%TYPE
1162: ,p_date_of_birth in date
1163: ,p_effective_date in date
1164: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

Line 1161: ,p_dpdnt_adoption_date in per_all_people_f.dpdnt_adoption_date%TYPE

1157: -- Internal Table Handler Use Only.
1158: --
1159: procedure chk_birth_adoption_date
1160: (p_person_id in per_all_people_f.person_id%TYPE
1161: ,p_dpdnt_adoption_date in per_all_people_f.dpdnt_adoption_date%TYPE
1162: ,p_date_of_birth in date
1163: ,p_effective_date in date
1164: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1165: )

Line 1164: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

1160: (p_person_id in per_all_people_f.person_id%TYPE
1161: ,p_dpdnt_adoption_date in per_all_people_f.dpdnt_adoption_date%TYPE
1162: ,p_date_of_birth in date
1163: ,p_effective_date in date
1164: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1165: )
1166: is
1167: --
1168: l_proc varchar2(72) := g_package||'chk_birth_adoption_date';

Line 1178: (p_associated_column1 => 'PER_ALL_PEOPLE_F.DPDNT_ADOPTION_DATE'

1174: if p_dpdnt_adoption_date is NOT NULL then
1175: if p_date_of_birth IS NULL then
1176: hr_utility.set_message(800,'PER_52425_DATE_BIRTH_ADOPTION');
1177: hr_multi_message.add
1178: (p_associated_column1 => 'PER_ALL_PEOPLE_F.DPDNT_ADOPTION_DATE'
1179: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'
1180: );
1181:
1182: -- bug fix : 2164967 begins

Line 1179: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'

1175: if p_date_of_birth IS NULL then
1176: hr_utility.set_message(800,'PER_52425_DATE_BIRTH_ADOPTION');
1177: hr_multi_message.add
1178: (p_associated_column1 => 'PER_ALL_PEOPLE_F.DPDNT_ADOPTION_DATE'
1179: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'
1180: );
1181:
1182: -- bug fix : 2164967 begins
1183:

Line 1187: (p_associated_column1 => 'PER_ALL_PEOPLE_F.DPDNT_ADOPTION_DATE'

1183:
1184: elsif p_dpdnt_adoption_date < nvl(p_date_of_birth, hr_api.g_date) then
1185: hr_utility.set_message(800,'PER_52961_ADOPT_LT_DOB');
1186: hr_multi_message.add
1187: (p_associated_column1 => 'PER_ALL_PEOPLE_F.DPDNT_ADOPTION_DATE'
1188: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'
1189: );
1190:
1191: -- bug fix : 2164967 ends

Line 1188: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'

1184: elsif p_dpdnt_adoption_date < nvl(p_date_of_birth, hr_api.g_date) then
1185: hr_utility.set_message(800,'PER_52961_ADOPT_LT_DOB');
1186: hr_multi_message.add
1187: (p_associated_column1 => 'PER_ALL_PEOPLE_F.DPDNT_ADOPTION_DATE'
1188: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'
1189: );
1190:
1191: -- bug fix : 2164967 ends
1192:

Line 1230: (p_person_id in per_all_people_f.person_id%TYPE

1226: -- Access Status:
1227: -- Internal Table Handler Use Only.
1228: --
1229: procedure chk_date_of_death
1230: (p_person_id in per_all_people_f.person_id%TYPE
1231: ,p_date_of_death in per_all_people_f.date_of_death%TYPE
1232: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
1233: ,p_effective_date in date
1234: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

Line 1231: ,p_date_of_death in per_all_people_f.date_of_death%TYPE

1227: -- Internal Table Handler Use Only.
1228: --
1229: procedure chk_date_of_death
1230: (p_person_id in per_all_people_f.person_id%TYPE
1231: ,p_date_of_death in per_all_people_f.date_of_death%TYPE
1232: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
1233: ,p_effective_date in date
1234: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1235: )

Line 1232: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE

1228: --
1229: procedure chk_date_of_death
1230: (p_person_id in per_all_people_f.person_id%TYPE
1231: ,p_date_of_death in per_all_people_f.date_of_death%TYPE
1232: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
1233: ,p_effective_date in date
1234: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1235: )
1236: is

Line 1234: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

1230: (p_person_id in per_all_people_f.person_id%TYPE
1231: ,p_date_of_death in per_all_people_f.date_of_death%TYPE
1232: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
1233: ,p_effective_date in date
1234: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1235: )
1236: is
1237: --
1238: l_proc varchar2(72) := g_package||'chk_date_of_death';

Line 1252: (p_check_column1 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'

1248: begin
1249: --
1250: hr_utility.set_location('Entering:'|| l_proc,5);
1251: if hr_multi_message.no_exclusive_error
1252: (p_check_column1 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'
1253: ,p_check_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_DEATH'
1254: ) then
1255: if p_date_of_death is NOT NULL then
1256: if p_date_of_death < nvl(p_date_of_birth, hr_api.g_date) then --fix for bug 4262496.

Line 1253: ,p_check_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_DEATH'

1249: --
1250: hr_utility.set_location('Entering:'|| l_proc,5);
1251: if hr_multi_message.no_exclusive_error
1252: (p_check_column1 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'
1253: ,p_check_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_DEATH'
1254: ) then
1255: if p_date_of_death is NOT NULL then
1256: if p_date_of_death < nvl(p_date_of_birth, hr_api.g_date) then --fix for bug 4262496.
1257: hr_utility.set_message(800,'PER_52963_DOD_LT_DOB');

Line 1281: (p_associated_column1 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'

1277: --
1278: exception
1279: when app_exception.application_exception then
1280: if hr_multi_message.exception_add
1281: (p_associated_column1 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'
1282: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_DEATH'
1283: ) then
1284: hr_utility.set_location(' Leaving:'||l_proc, 20);
1285: raise;

Line 1282: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_DEATH'

1278: exception
1279: when app_exception.application_exception then
1280: if hr_multi_message.exception_add
1281: (p_associated_column1 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'
1282: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_DEATH'
1283: ) then
1284: hr_utility.set_location(' Leaving:'||l_proc, 20);
1285: raise;
1286: end if;

Line 1329: (p_person_id in per_all_people_f.person_id%TYPE

1325: -- Access Status:
1326: -- Internal Table Handler Use Only.
1327: --
1328: procedure chk_rd_flag
1329: (p_person_id in per_all_people_f.person_id%TYPE
1330: ,p_registered_disabled_flag in per_all_people_f.registered_disabled_flag%TYPE
1331: ,p_effective_date in date
1332: ,p_validation_start_date in date
1333: ,p_validation_end_date in date

Line 1330: ,p_registered_disabled_flag in per_all_people_f.registered_disabled_flag%TYPE

1326: -- Internal Table Handler Use Only.
1327: --
1328: procedure chk_rd_flag
1329: (p_person_id in per_all_people_f.person_id%TYPE
1330: ,p_registered_disabled_flag in per_all_people_f.registered_disabled_flag%TYPE
1331: ,p_effective_date in date
1332: ,p_validation_start_date in date
1333: ,p_validation_end_date in date
1334: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

Line 1334: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

1330: ,p_registered_disabled_flag in per_all_people_f.registered_disabled_flag%TYPE
1331: ,p_effective_date in date
1332: ,p_validation_start_date in date
1333: ,p_validation_end_date in date
1334: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1335: )
1336: is
1337: --
1338: l_proc varchar2(72) := g_package||'chk_rd_flag';

Line 1396: (p_associated_column1 => 'PER_ALL_PEOPLE_F.REGISTERED_DISABLED_FLAG'

1392: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1393: exception
1394: when app_exception.application_exception then
1395: if hr_multi_message.exception_add
1396: (p_associated_column1 => 'PER_ALL_PEOPLE_F.REGISTERED_DISABLED_FLAG'
1397: ) then
1398: hr_utility.set_location(' Leaving:'||l_proc, 50);
1399: raise;
1400: end if;

Line 1443: (p_person_id in per_all_people_f.person_id%TYPE

1439: -- Access Status:
1440: -- Internal Table Handler Use Only.
1441: --
1442: procedure chk_uses_tobacco
1443: (p_person_id in per_all_people_f.person_id%TYPE
1444: ,p_uses_tobacco_flag in per_all_people_f.uses_tobacco_flag%TYPE
1445: ,p_effective_date in date
1446: ,p_validation_start_date in date
1447: ,p_validation_end_date in date

Line 1444: ,p_uses_tobacco_flag in per_all_people_f.uses_tobacco_flag%TYPE

1440: -- Internal Table Handler Use Only.
1441: --
1442: procedure chk_uses_tobacco
1443: (p_person_id in per_all_people_f.person_id%TYPE
1444: ,p_uses_tobacco_flag in per_all_people_f.uses_tobacco_flag%TYPE
1445: ,p_effective_date in date
1446: ,p_validation_start_date in date
1447: ,p_validation_end_date in date
1448: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

Line 1448: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

1444: ,p_uses_tobacco_flag in per_all_people_f.uses_tobacco_flag%TYPE
1445: ,p_effective_date in date
1446: ,p_validation_start_date in date
1447: ,p_validation_end_date in date
1448: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1449: )
1450: is
1451: --
1452: l_proc varchar2(72) := g_package||'chk_uses_tobacco';

Line 1510: (p_associated_column1 => 'PER_ALL_PEOPLE_F.USES_TOBACCO_FLAG'

1506: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1507: exception
1508: when app_exception.application_exception then
1509: if hr_multi_message.exception_add
1510: (p_associated_column1 => 'PER_ALL_PEOPLE_F.USES_TOBACCO_FLAG'
1511: ) then
1512: hr_utility.set_location(' Leaving:'||l_proc, 50);
1513: raise;
1514: end if;