64: -- Access Status:
65: -- Internal Table Handler Use Only.
66: --
67: procedure chk_unsupported_attributes
68: (p_person_id in per_all_people_f.person_id%TYPE
69: ,p_fast_path_employee in per_all_people_f.fast_path_employee%TYPE
70: ,p_order_name in per_all_people_f.order_name%TYPE
71: ,p_projected_start_date in per_all_people_f.projected_start_date%TYPE
72: ,p_rehire_authorizor in per_all_people_f.rehire_authorizor%TYPE
65: -- Internal Table Handler Use Only.
66: --
67: procedure chk_unsupported_attributes
68: (p_person_id in per_all_people_f.person_id%TYPE
69: ,p_fast_path_employee in per_all_people_f.fast_path_employee%TYPE
70: ,p_order_name in per_all_people_f.order_name%TYPE
71: ,p_projected_start_date in per_all_people_f.projected_start_date%TYPE
72: ,p_rehire_authorizor in per_all_people_f.rehire_authorizor%TYPE
73: ,p_effective_date in date
66: --
67: procedure chk_unsupported_attributes
68: (p_person_id in per_all_people_f.person_id%TYPE
69: ,p_fast_path_employee in per_all_people_f.fast_path_employee%TYPE
70: ,p_order_name in per_all_people_f.order_name%TYPE
71: ,p_projected_start_date in per_all_people_f.projected_start_date%TYPE
72: ,p_rehire_authorizor in per_all_people_f.rehire_authorizor%TYPE
73: ,p_effective_date in date
74: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
67: procedure chk_unsupported_attributes
68: (p_person_id in per_all_people_f.person_id%TYPE
69: ,p_fast_path_employee in per_all_people_f.fast_path_employee%TYPE
70: ,p_order_name in per_all_people_f.order_name%TYPE
71: ,p_projected_start_date in per_all_people_f.projected_start_date%TYPE
72: ,p_rehire_authorizor in per_all_people_f.rehire_authorizor%TYPE
73: ,p_effective_date in date
74: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
75: );
68: (p_person_id in per_all_people_f.person_id%TYPE
69: ,p_fast_path_employee in per_all_people_f.fast_path_employee%TYPE
70: ,p_order_name in per_all_people_f.order_name%TYPE
71: ,p_projected_start_date in per_all_people_f.projected_start_date%TYPE
72: ,p_rehire_authorizor in per_all_people_f.rehire_authorizor%TYPE
73: ,p_effective_date in date
74: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
75: );
76: --
70: ,p_order_name in per_all_people_f.order_name%TYPE
71: ,p_projected_start_date in per_all_people_f.projected_start_date%TYPE
72: ,p_rehire_authorizor in per_all_people_f.rehire_authorizor%TYPE
73: ,p_effective_date in date
74: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
75: );
76: --
77: -- ---------------------------------------------------------------------------
78: -- |-----------------< chk_correspondence_language >-----------------------|
100: -- Access Status:
101: -- Internal Table Handler Use Only.
102: --
103: procedure chk_correspondence_language
104: (p_person_id in per_all_people_f.person_id%TYPE
105: ,p_effective_date in date
106: ,p_correspondence_language in per_all_people_f.correspondence_language%TYPE
107: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
108: );
102: --
103: procedure chk_correspondence_language
104: (p_person_id in per_all_people_f.person_id%TYPE
105: ,p_effective_date in date
106: ,p_correspondence_language in per_all_people_f.correspondence_language%TYPE
107: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
108: );
109: --
110: -- ---------------------------------------------------------------------------
103: procedure chk_correspondence_language
104: (p_person_id in per_all_people_f.person_id%TYPE
105: ,p_effective_date in date
106: ,p_correspondence_language in per_all_people_f.correspondence_language%TYPE
107: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
108: );
109: --
110: -- ---------------------------------------------------------------------------
111: -- |-----------------< chk_coord_ben_med_cvg_dates >-----------------------|
229: -- Access Status:
230: -- Internal Table Handler Use Only.
231: --
232: procedure chk_fte_capacity
233: (p_person_id in per_all_people_f.person_id%TYPE
234: ,p_effective_date in date
235: ,p_fte_capacity in per_all_people_f.fte_capacity%TYPE
236: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
237: );
231: --
232: procedure chk_fte_capacity
233: (p_person_id in per_all_people_f.person_id%TYPE
234: ,p_effective_date in date
235: ,p_fte_capacity in per_all_people_f.fte_capacity%TYPE
236: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
237: );
238: --
239: -- ---------------------------------------------------------------------------
232: procedure chk_fte_capacity
233: (p_person_id in per_all_people_f.person_id%TYPE
234: ,p_effective_date in date
235: ,p_fte_capacity in per_all_people_f.fte_capacity%TYPE
236: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
237: );
238: --
239: -- ---------------------------------------------------------------------------
240: -- |-----------------< chk_background_check_status >-----------------------|
274: -- Access Status:
275: -- Internal Table Handler Use Only.
276: --
277: procedure chk_background_check_status
278: (p_person_id in per_all_people_f.person_id%TYPE
279: ,p_background_check_status in per_all_people_f.background_check_status%TYPE
280: ,p_effective_date in date
281: ,p_validation_start_date in date
282: ,p_validation_end_date in date
275: -- Internal Table Handler Use Only.
276: --
277: procedure chk_background_check_status
278: (p_person_id in per_all_people_f.person_id%TYPE
279: ,p_background_check_status in per_all_people_f.background_check_status%TYPE
280: ,p_effective_date in date
281: ,p_validation_start_date in date
282: ,p_validation_end_date in date
283: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
279: ,p_background_check_status in per_all_people_f.background_check_status%TYPE
280: ,p_effective_date in date
281: ,p_validation_start_date in date
282: ,p_validation_end_date in date
283: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
284: );
285: --
286: -- ---------------------------------------------------------------------------
287: -- |-------------------------< chk_blood_type >----------------------------|
321: -- Access Status:
322: -- Internal Table Handler Use Only.
323: --
324: procedure chk_blood_type
325: (p_person_id in per_all_people_f.person_id%TYPE
326: ,p_blood_type in per_all_people_f.blood_type%TYPE
327: ,p_effective_date in date
328: ,p_validation_start_date in date
329: ,p_validation_end_date in date
322: -- Internal Table Handler Use Only.
323: --
324: procedure chk_blood_type
325: (p_person_id in per_all_people_f.person_id%TYPE
326: ,p_blood_type in per_all_people_f.blood_type%TYPE
327: ,p_effective_date in date
328: ,p_validation_start_date in date
329: ,p_validation_end_date in date
330: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
326: ,p_blood_type in per_all_people_f.blood_type%TYPE
327: ,p_effective_date in date
328: ,p_validation_start_date in date
329: ,p_validation_end_date in date
330: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
331: );
332: --
333: -- ---------------------------------------------------------------------------
334: -- |-------------------------< chk_student_status >------------------------|
368: -- Access Status:
369: -- Internal Table Handler Use Only.
370: --
371: procedure chk_student_status
372: (p_person_id in per_all_people_f.person_id%TYPE
373: ,p_student_status in per_all_people_f.student_status%TYPE
374: ,p_effective_date in date
375: ,p_validation_start_date in date
376: ,p_validation_end_date in date
369: -- Internal Table Handler Use Only.
370: --
371: procedure chk_student_status
372: (p_person_id in per_all_people_f.person_id%TYPE
373: ,p_student_status in per_all_people_f.student_status%TYPE
374: ,p_effective_date in date
375: ,p_validation_start_date in date
376: ,p_validation_end_date in date
377: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
373: ,p_student_status in per_all_people_f.student_status%TYPE
374: ,p_effective_date in date
375: ,p_validation_start_date in date
376: ,p_validation_end_date in date
377: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
378: );
379: --
380: -- ---------------------------------------------------------------------------
381: -- |-------------------------< chk_work_schedule >-------------------------|
415: -- Access Status:
416: -- Internal Table Handler Use Only.
417: --
418: procedure chk_work_schedule
419: (p_person_id in per_all_people_f.person_id%TYPE
420: ,p_work_schedule in per_all_people_f.work_schedule%TYPE
421: ,p_effective_date in date
422: ,p_validation_start_date in date
423: ,p_validation_end_date in date
416: -- Internal Table Handler Use Only.
417: --
418: procedure chk_work_schedule
419: (p_person_id in per_all_people_f.person_id%TYPE
420: ,p_work_schedule in per_all_people_f.work_schedule%TYPE
421: ,p_effective_date in date
422: ,p_validation_start_date in date
423: ,p_validation_end_date in date
424: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
420: ,p_work_schedule in per_all_people_f.work_schedule%TYPE
421: ,p_effective_date in date
422: ,p_validation_start_date in date
423: ,p_validation_end_date in date
424: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
425: );
426: --
427: -- ---------------------------------------------------------------------------
428: -- |---------------------< chk_rehire_recommendation >---------------------|
462: -- Access Status:
463: -- Internal Table Handler Use Only.
464: --
465: procedure chk_rehire_recommendation
466: (p_person_id in per_all_people_f.person_id%TYPE
467: ,p_rehire_recommendation in per_all_people_f.rehire_recommendation%TYPE
468: ,p_effective_date in date
469: ,p_validation_start_date in date
470: ,p_validation_end_date in date
463: -- Internal Table Handler Use Only.
464: --
465: procedure chk_rehire_recommendation
466: (p_person_id in per_all_people_f.person_id%TYPE
467: ,p_rehire_recommendation in per_all_people_f.rehire_recommendation%TYPE
468: ,p_effective_date in date
469: ,p_validation_start_date in date
470: ,p_validation_end_date in date
471: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
467: ,p_rehire_recommendation in per_all_people_f.rehire_recommendation%TYPE
468: ,p_effective_date in date
469: ,p_validation_start_date in date
470: ,p_validation_end_date in date
471: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
472: );
473: --
474: -- ---------------------------------------------------------------------------
475: -- |-------------------------< chk_benefit_group_id >------------------------|
501: -- Access Status:
502: -- Internal Table Handler Use Only.
503: --
504: procedure chk_benefit_group_id
505: (p_person_id in per_all_people_f.person_id%TYPE
506: ,p_benefit_group_id in per_all_people_f.benefit_group_id%TYPE
507: ,p_effective_date in date
508: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
509: );
502: -- Internal Table Handler Use Only.
503: --
504: procedure chk_benefit_group_id
505: (p_person_id in per_all_people_f.person_id%TYPE
506: ,p_benefit_group_id in per_all_people_f.benefit_group_id%TYPE
507: ,p_effective_date in date
508: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
509: );
510:
504: procedure chk_benefit_group_id
505: (p_person_id in per_all_people_f.person_id%TYPE
506: ,p_benefit_group_id in per_all_people_f.benefit_group_id%TYPE
507: ,p_effective_date in date
508: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
509: );
510:
511: -- ---------------------------------------------------------------------------
512: -- |--------------------< chk_date_death_and_rcpt_cert >-------------------|
540: -- Access Status:
541: -- Internal Table Handler Use Only.
542: --
543: procedure chk_date_death_and_rcpt_cert
544: (p_person_id in per_all_people_f.person_id%TYPE
545: ,p_receipt_of_death_cert_date in per_all_people_f.receipt_of_death_cert_date%TYPE
546: ,p_effective_date in date
547: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
548: ,p_date_of_death in date
541: -- Internal Table Handler Use Only.
542: --
543: procedure chk_date_death_and_rcpt_cert
544: (p_person_id in per_all_people_f.person_id%TYPE
545: ,p_receipt_of_death_cert_date in per_all_people_f.receipt_of_death_cert_date%TYPE
546: ,p_effective_date in date
547: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
548: ,p_date_of_death in date
549: );
543: procedure chk_date_death_and_rcpt_cert
544: (p_person_id in per_all_people_f.person_id%TYPE
545: ,p_receipt_of_death_cert_date in per_all_people_f.receipt_of_death_cert_date%TYPE
546: ,p_effective_date in date
547: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
548: ,p_date_of_death in date
549: );
550:
551: -- ---------------------------------------------------------------------------
580: -- Access Status:
581: -- Internal Table Handler Use Only.
582: --
583: procedure chk_birth_adoption_date
584: (p_person_id in per_all_people_f.person_id%TYPE
585: ,p_dpdnt_adoption_date in per_all_people_f.dpdnt_adoption_date%TYPE
586: ,p_date_of_birth in date
587: ,p_effective_date in date
588: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
581: -- Internal Table Handler Use Only.
582: --
583: procedure chk_birth_adoption_date
584: (p_person_id in per_all_people_f.person_id%TYPE
585: ,p_dpdnt_adoption_date in per_all_people_f.dpdnt_adoption_date%TYPE
586: ,p_date_of_birth in date
587: ,p_effective_date in date
588: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
589: );
584: (p_person_id in per_all_people_f.person_id%TYPE
585: ,p_dpdnt_adoption_date in per_all_people_f.dpdnt_adoption_date%TYPE
586: ,p_date_of_birth in date
587: ,p_effective_date in date
588: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
589: );
590: -- ---------------------------------------------------------------------------
591: -- |-------------------------< chk_rd_flag >-------------------|
592: -- ---------------------------------------------------------------------------
625: -- Access Status:
626: -- Internal Table Handler Use Only.
627: --
628: procedure chk_rd_flag
629: (p_person_id in per_all_people_f.person_id%TYPE
630: ,p_registered_disabled_flag in per_all_people_f.registered_disabled_flag%TYPE
631: ,p_effective_date in date
632: ,p_validation_start_date in date
633: ,p_validation_end_date in date
626: -- Internal Table Handler Use Only.
627: --
628: procedure chk_rd_flag
629: (p_person_id in per_all_people_f.person_id%TYPE
630: ,p_registered_disabled_flag in per_all_people_f.registered_disabled_flag%TYPE
631: ,p_effective_date in date
632: ,p_validation_start_date in date
633: ,p_validation_end_date in date
634: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
630: ,p_registered_disabled_flag in per_all_people_f.registered_disabled_flag%TYPE
631: ,p_effective_date in date
632: ,p_validation_start_date in date
633: ,p_validation_end_date in date
634: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
635: );
636:
637: -- ---------------------------------------------------------------------------
638: -- |-------------------------< chk_date_of_death >-------------------------|
663: -- Access Status:
664: -- Internal Table Handler Use Only.
665: --
666: procedure chk_date_of_death
667: (p_person_id in per_all_people_f.person_id%TYPE
668: ,p_date_of_death in per_all_people_f.date_of_death%TYPE
669: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
670: ,p_effective_date in date
671: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
664: -- Internal Table Handler Use Only.
665: --
666: procedure chk_date_of_death
667: (p_person_id in per_all_people_f.person_id%TYPE
668: ,p_date_of_death in per_all_people_f.date_of_death%TYPE
669: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
670: ,p_effective_date in date
671: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
672: );
665: --
666: procedure chk_date_of_death
667: (p_person_id in per_all_people_f.person_id%TYPE
668: ,p_date_of_death in per_all_people_f.date_of_death%TYPE
669: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
670: ,p_effective_date in date
671: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
672: );
673: --
667: (p_person_id in per_all_people_f.person_id%TYPE
668: ,p_date_of_death in per_all_people_f.date_of_death%TYPE
669: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
670: ,p_effective_date in date
671: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
672: );
673: --
674: -- ---------------------------------------------------------------------------
675: -- |-------------------------< chk_uses_tobacco >---------------------------|
709: -- Access Status:
710: -- Internal Table Handler Use Only.
711: --
712: procedure chk_uses_tobacco
713: (p_person_id in per_all_people_f.person_id%TYPE
714: ,p_uses_tobacco_flag in per_all_people_f.uses_tobacco_flag%TYPE
715: ,p_effective_date in date
716: ,p_validation_start_date in date
717: ,p_validation_end_date in date
710: -- Internal Table Handler Use Only.
711: --
712: procedure chk_uses_tobacco
713: (p_person_id in per_all_people_f.person_id%TYPE
714: ,p_uses_tobacco_flag in per_all_people_f.uses_tobacco_flag%TYPE
715: ,p_effective_date in date
716: ,p_validation_start_date in date
717: ,p_validation_end_date in date
718: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
714: ,p_uses_tobacco_flag in per_all_people_f.uses_tobacco_flag%TYPE
715: ,p_effective_date in date
716: ,p_validation_start_date in date
717: ,p_validation_end_date in date
718: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
719: );
720: --
721: end per_per_bus1;