DBA Data[Home] [Help]

APPS.PER_PER_BUS1 dependencies on PER_ALL_PEOPLE_F

Line 68: (p_person_id in per_all_people_f.person_id%TYPE

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

Line 69: ,p_fast_path_employee in per_all_people_f.fast_path_employee%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

Line 70: ,p_order_name in per_all_people_f.order_name%TYPE

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

Line 71: ,p_projected_start_date in per_all_people_f.projected_start_date%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: );

Line 72: ,p_rehire_authorizor in per_all_people_f.rehire_authorizor%TYPE

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: --

Line 74: ,p_object_version_number in per_all_people_f.object_version_number%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: --
77: -- ---------------------------------------------------------------------------
78: -- |-----------------< chk_correspondence_language >-----------------------|

Line 104: (p_person_id in per_all_people_f.person_id%TYPE

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: );

Line 106: ,p_correspondence_language in per_all_people_f.correspondence_language%TYPE

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: -- ---------------------------------------------------------------------------

Line 107: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

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 >-----------------------|

Line 233: (p_person_id in per_all_people_f.person_id%TYPE

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: );

Line 235: ,p_fte_capacity in per_all_people_f.fte_capacity%TYPE

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: -- ---------------------------------------------------------------------------

Line 236: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

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 >-----------------------|

Line 278: (p_person_id in per_all_people_f.person_id%TYPE

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

Line 279: ,p_background_check_status in per_all_people_f.background_check_status%TYPE

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

Line 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 >----------------------------|

Line 325: (p_person_id in per_all_people_f.person_id%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

Line 326: ,p_blood_type in per_all_people_f.blood_type%TYPE

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

Line 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 >------------------------|

Line 372: (p_person_id in per_all_people_f.person_id%TYPE

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

Line 373: ,p_student_status in per_all_people_f.student_status%TYPE

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

Line 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 >-------------------------|

Line 419: (p_person_id in per_all_people_f.person_id%TYPE

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

Line 420: ,p_work_schedule in per_all_people_f.work_schedule%TYPE

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

Line 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 >---------------------|

Line 466: (p_person_id in per_all_people_f.person_id%TYPE

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

Line 467: ,p_rehire_recommendation in per_all_people_f.rehire_recommendation%TYPE

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

Line 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 >------------------------|

Line 505: (p_person_id in per_all_people_f.person_id%TYPE

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: );

Line 506: ,p_benefit_group_id in per_all_people_f.benefit_group_id%TYPE

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:

Line 508: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

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 >-------------------|

Line 544: (p_person_id in per_all_people_f.person_id%TYPE

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

Line 545: ,p_receipt_of_death_cert_date in per_all_people_f.receipt_of_death_cert_date%TYPE

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: );

Line 547: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

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: -- ---------------------------------------------------------------------------

Line 584: (p_person_id in per_all_people_f.person_id%TYPE

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

Line 585: ,p_dpdnt_adoption_date in per_all_people_f.dpdnt_adoption_date%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: );

Line 588: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

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: -- ---------------------------------------------------------------------------

Line 629: (p_person_id in per_all_people_f.person_id%TYPE

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

Line 630: ,p_registered_disabled_flag in per_all_people_f.registered_disabled_flag%TYPE

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

Line 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 >-------------------------|

Line 667: (p_person_id in per_all_people_f.person_id%TYPE

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

Line 668: ,p_date_of_death in per_all_people_f.date_of_death%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: );

Line 669: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE

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: --

Line 671: ,p_object_version_number in per_all_people_f.object_version_number%TYPE

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 >---------------------------|

Line 713: (p_person_id in per_all_people_f.person_id%TYPE

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

Line 714: ,p_uses_tobacco_flag in per_all_people_f.uses_tobacco_flag%TYPE

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

Line 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;