349: -- Access Status:
350: -- Internal Table Handler Use Only.
351: --
352: PROCEDURE chk_vendor_employee_number
353: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
354: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
355: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
356: ,p_business_group_id IN per_assignments_f.business_group_id%TYPE
357: ,p_object_version_number IN per_all_assignments_f.object_version_number%TYPE
350: -- Internal Table Handler Use Only.
351: --
352: PROCEDURE chk_vendor_employee_number
353: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
354: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
355: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
356: ,p_business_group_id IN per_assignments_f.business_group_id%TYPE
357: ,p_object_version_number IN per_all_assignments_f.object_version_number%TYPE
358: ,p_effective_date IN DATE);
351: --
352: PROCEDURE chk_vendor_employee_number
353: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
354: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
355: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
356: ,p_business_group_id IN per_assignments_f.business_group_id%TYPE
357: ,p_object_version_number IN per_all_assignments_f.object_version_number%TYPE
358: ,p_effective_date IN DATE);
359: --
353: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
354: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
355: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
356: ,p_business_group_id IN per_assignments_f.business_group_id%TYPE
357: ,p_object_version_number IN per_all_assignments_f.object_version_number%TYPE
358: ,p_effective_date IN DATE);
359: --
360: -- ---------------------------------------------------------------------------
361: -- |----------------------< chk_vendor_assignment_number >-------------------|
391: -- Access Status:
392: -- Internal Table Handler Use Only.
393: --
394: PROCEDURE chk_vendor_assignment_number
395: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
396: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
397: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
398: ,p_business_group_id IN per_assignments_f.business_group_id%TYPE
399: ,p_object_version_number IN per_all_assignments_f.object_version_number%TYPE
392: -- Internal Table Handler Use Only.
393: --
394: PROCEDURE chk_vendor_assignment_number
395: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
396: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
397: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
398: ,p_business_group_id IN per_assignments_f.business_group_id%TYPE
399: ,p_object_version_number IN per_all_assignments_f.object_version_number%TYPE
400: ,p_effective_date IN DATE);
393: --
394: PROCEDURE chk_vendor_assignment_number
395: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
396: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
397: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
398: ,p_business_group_id IN per_assignments_f.business_group_id%TYPE
399: ,p_object_version_number IN per_all_assignments_f.object_version_number%TYPE
400: ,p_effective_date IN DATE);
401: --
395: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
396: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
397: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
398: ,p_business_group_id IN per_assignments_f.business_group_id%TYPE
399: ,p_object_version_number IN per_all_assignments_f.object_version_number%TYPE
400: ,p_effective_date IN DATE);
401: --
402: -- ---------------------------------------------------------------------------
403: -- |---------------------------< chk_pop_date_start >------------------------|
457: -- Access Status:
458: -- Internal Table Handler Use Only.
459: --
460: PROCEDURE chk_pop_date_start
461: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
462: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
463: ,p_person_id IN per_all_assignments_f.person_id%TYPE
464: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
465: ,p_pop_date_start IN per_periods_of_placement.date_start%TYPE
458: -- Internal Table Handler Use Only.
459: --
460: PROCEDURE chk_pop_date_start
461: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
462: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
463: ,p_person_id IN per_all_assignments_f.person_id%TYPE
464: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
465: ,p_pop_date_start IN per_periods_of_placement.date_start%TYPE
466: ,p_validation_start_date IN DATE
459: --
460: PROCEDURE chk_pop_date_start
461: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
462: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
463: ,p_person_id IN per_all_assignments_f.person_id%TYPE
464: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
465: ,p_pop_date_start IN per_periods_of_placement.date_start%TYPE
466: ,p_validation_start_date IN DATE
467: ,p_validation_end_date IN DATE
460: PROCEDURE chk_pop_date_start
461: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
462: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
463: ,p_person_id IN per_all_assignments_f.person_id%TYPE
464: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
465: ,p_pop_date_start IN per_periods_of_placement.date_start%TYPE
466: ,p_validation_start_date IN DATE
467: ,p_validation_end_date IN DATE
468: ,p_effective_date IN DATE
465: ,p_pop_date_start IN per_periods_of_placement.date_start%TYPE
466: ,p_validation_start_date IN DATE
467: ,p_validation_end_date IN DATE
468: ,p_effective_date IN DATE
469: ,p_object_version_number IN per_all_assignments_f.object_version_number%TYPE
470: );
471: --
472: -- --------------------------------------------------------------------------+
473: -- |--------------------< chk_cagr_grade_def_id >---------------------------|
501: -- Access Status:
502: -- Internal Table Handler Use Only.
503: --
504: procedure chk_cagr_grade_def_id
505: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
506: ,p_effective_date in date
507: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
508: ,p_cagr_grade_def_id in per_all_assignments_f.cagr_grade_def_id%TYPE
509: ,p_collective_agreement_id in per_all_assignments_f.collective_agreement_id%TYPE
503: --
504: procedure chk_cagr_grade_def_id
505: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
506: ,p_effective_date in date
507: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
508: ,p_cagr_grade_def_id in per_all_assignments_f.cagr_grade_def_id%TYPE
509: ,p_collective_agreement_id in per_all_assignments_f.collective_agreement_id%TYPE
510: ,p_cagr_id_flex_num in per_all_assignments_f.cagr_id_flex_num%TYPE
511: );
504: procedure chk_cagr_grade_def_id
505: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
506: ,p_effective_date in date
507: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
508: ,p_cagr_grade_def_id in per_all_assignments_f.cagr_grade_def_id%TYPE
509: ,p_collective_agreement_id in per_all_assignments_f.collective_agreement_id%TYPE
510: ,p_cagr_id_flex_num in per_all_assignments_f.cagr_id_flex_num%TYPE
511: );
512: --
505: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
506: ,p_effective_date in date
507: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
508: ,p_cagr_grade_def_id in per_all_assignments_f.cagr_grade_def_id%TYPE
509: ,p_collective_agreement_id in per_all_assignments_f.collective_agreement_id%TYPE
510: ,p_cagr_id_flex_num in per_all_assignments_f.cagr_id_flex_num%TYPE
511: );
512: --
513: -- --------------------------------------------------------------------------+
506: ,p_effective_date in date
507: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
508: ,p_cagr_grade_def_id in per_all_assignments_f.cagr_grade_def_id%TYPE
509: ,p_collective_agreement_id in per_all_assignments_f.collective_agreement_id%TYPE
510: ,p_cagr_id_flex_num in per_all_assignments_f.cagr_id_flex_num%TYPE
511: );
512: --
513: -- --------------------------------------------------------------------------+
514: -- |--------------------< chk_cagr_id_flex_num >----------------------------|
538: -- Access Status:
539: -- Internal Table Handler Use Only.
540: --
541: procedure chk_cagr_id_flex_num
542: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
543: ,p_effective_date in date
544: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
545: ,p_cagr_id_flex_num in per_all_assignments_f.cagr_id_flex_num%TYPE
546: ,p_collective_agreement_id in per_all_assignments_f.collective_agreement_id%TYPE
540: --
541: procedure chk_cagr_id_flex_num
542: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
543: ,p_effective_date in date
544: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
545: ,p_cagr_id_flex_num in per_all_assignments_f.cagr_id_flex_num%TYPE
546: ,p_collective_agreement_id in per_all_assignments_f.collective_agreement_id%TYPE
547: );
548: --
541: procedure chk_cagr_id_flex_num
542: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
543: ,p_effective_date in date
544: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
545: ,p_cagr_id_flex_num in per_all_assignments_f.cagr_id_flex_num%TYPE
546: ,p_collective_agreement_id in per_all_assignments_f.collective_agreement_id%TYPE
547: );
548: --
549: -- --------------------------------------------------------------------------+
542: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
543: ,p_effective_date in date
544: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
545: ,p_cagr_id_flex_num in per_all_assignments_f.cagr_id_flex_num%TYPE
546: ,p_collective_agreement_id in per_all_assignments_f.collective_agreement_id%TYPE
547: );
548: --
549: -- --------------------------------------------------------------------------+
550: -- |--------------------< chk_contract_id >----------------------------------|
576: -- Access Status:
577: -- Internal Table Handler Use Only.
578: --
579: procedure chk_contract_id
580: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
581: ,p_effective_date in date
582: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
583: ,p_contract_id in per_all_assignments_f.contract_id%TYPE
584: ,p_person_id in per_all_assignments_f.person_id%TYPE
578: --
579: procedure chk_contract_id
580: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
581: ,p_effective_date in date
582: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
583: ,p_contract_id in per_all_assignments_f.contract_id%TYPE
584: ,p_person_id in per_all_assignments_f.person_id%TYPE
585: ,p_validation_start_date in date
586: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
579: procedure chk_contract_id
580: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
581: ,p_effective_date in date
582: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
583: ,p_contract_id in per_all_assignments_f.contract_id%TYPE
584: ,p_person_id in per_all_assignments_f.person_id%TYPE
585: ,p_validation_start_date in date
586: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
587: );
580: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
581: ,p_effective_date in date
582: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
583: ,p_contract_id in per_all_assignments_f.contract_id%TYPE
584: ,p_person_id in per_all_assignments_f.person_id%TYPE
585: ,p_validation_start_date in date
586: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
587: );
588: --
582: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
583: ,p_contract_id in per_all_assignments_f.contract_id%TYPE
584: ,p_person_id in per_all_assignments_f.person_id%TYPE
585: ,p_validation_start_date in date
586: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
587: );
588: --
589: -- --------------------------------------------------------------------------+
590: -- |--------------------< chk_collective_agreement_id >----------------------|
615: -- Access Status:
616: -- Internal Table Handler Use Only.
617: --
618: procedure chk_collective_agreement_id
619: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
620: ,p_effective_date in date
621: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
622: ,p_collective_agreement_id in per_all_assignments_f.collective_agreement_id%TYPE
623: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
617: --
618: procedure chk_collective_agreement_id
619: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
620: ,p_effective_date in date
621: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
622: ,p_collective_agreement_id in per_all_assignments_f.collective_agreement_id%TYPE
623: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
624: ,p_establishment_id in per_all_assignments_f.establishment_id%TYPE
625: );
618: procedure chk_collective_agreement_id
619: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
620: ,p_effective_date in date
621: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
622: ,p_collective_agreement_id in per_all_assignments_f.collective_agreement_id%TYPE
623: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
624: ,p_establishment_id in per_all_assignments_f.establishment_id%TYPE
625: );
626: -- --------------------------------------------------------------------------+
619: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
620: ,p_effective_date in date
621: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
622: ,p_collective_agreement_id in per_all_assignments_f.collective_agreement_id%TYPE
623: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
624: ,p_establishment_id in per_all_assignments_f.establishment_id%TYPE
625: );
626: -- --------------------------------------------------------------------------+
627: -- |--------------------< chk_establishment_id >-----------------------------|
620: ,p_effective_date in date
621: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
622: ,p_collective_agreement_id in per_all_assignments_f.collective_agreement_id%TYPE
623: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
624: ,p_establishment_id in per_all_assignments_f.establishment_id%TYPE
625: );
626: -- --------------------------------------------------------------------------+
627: -- |--------------------< chk_establishment_id >-----------------------------|
628: -- --------------------------------------------------------------------------+
651: -- Access Status:
652: -- Internal Table Handler Use Only.
653: --
654: procedure chk_establishment_id
655: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
656: ,p_effective_date in date
657: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
658: ,p_establishment_id in per_all_assignments_f.establishment_id%TYPE
659: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
653: --
654: procedure chk_establishment_id
655: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
656: ,p_effective_date in date
657: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
658: ,p_establishment_id in per_all_assignments_f.establishment_id%TYPE
659: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
660: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
661: );
654: procedure chk_establishment_id
655: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
656: ,p_effective_date in date
657: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
658: ,p_establishment_id in per_all_assignments_f.establishment_id%TYPE
659: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
660: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
661: );
662:
655: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
656: ,p_effective_date in date
657: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
658: ,p_establishment_id in per_all_assignments_f.establishment_id%TYPE
659: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
660: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
661: );
662:
663: -- --------------------------------------------------------------------------+
656: ,p_effective_date in date
657: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
658: ,p_establishment_id in per_all_assignments_f.establishment_id%TYPE
659: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
660: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
661: );
662:
663: -- --------------------------------------------------------------------------+
664: -- |--------------------< chk_notice_period >-----------------------------|
686: -- Access Status:
687: -- Internal Table Handler Use Only.
688: --
689: procedure chk_notice_period
690: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
691: ,p_notice_period in per_all_assignments_f.notice_period%TYPE
692: );
693:
694: -- --------------------------------------------------------------------------+
687: -- Internal Table Handler Use Only.
688: --
689: procedure chk_notice_period
690: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
691: ,p_notice_period in per_all_assignments_f.notice_period%TYPE
692: );
693:
694: -- --------------------------------------------------------------------------+
695: -- |--------------------< chk_notice_period_uom >-----------------------------|
718: -- Access Status:
719: -- Internal Table Handler Use Only.
720: --
721: procedure chk_notice_period_uom
722: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
723: ,p_notice_period in per_all_assignments_f.notice_period%TYPE
724: ,p_notice_period_uom in per_all_assignments_f.notice_period_uom%TYPE
725: ,p_effective_date in date
726: ,p_validation_start_date IN DATE
719: -- Internal Table Handler Use Only.
720: --
721: procedure chk_notice_period_uom
722: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
723: ,p_notice_period in per_all_assignments_f.notice_period%TYPE
724: ,p_notice_period_uom in per_all_assignments_f.notice_period_uom%TYPE
725: ,p_effective_date in date
726: ,p_validation_start_date IN DATE
727: ,P_VALIDATION_END_DATE IN DATE
720: --
721: procedure chk_notice_period_uom
722: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
723: ,p_notice_period in per_all_assignments_f.notice_period%TYPE
724: ,p_notice_period_uom in per_all_assignments_f.notice_period_uom%TYPE
725: ,p_effective_date in date
726: ,p_validation_start_date IN DATE
727: ,P_VALIDATION_END_DATE IN DATE
728: );
753: -- Access Status:
754: -- Internal Table Handler Use Only.
755: --
756: procedure chk_work_at_home
757: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
758: ,p_work_at_home in per_all_assignments_f.work_at_home%TYPE
759: ,p_effective_date in date
760: ,p_validation_start_date IN DATE
761: ,P_VALIDATION_END_DATE IN DATE
754: -- Internal Table Handler Use Only.
755: --
756: procedure chk_work_at_home
757: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
758: ,p_work_at_home in per_all_assignments_f.work_at_home%TYPE
759: ,p_effective_date in date
760: ,p_validation_start_date IN DATE
761: ,P_VALIDATION_END_DATE IN DATE
762: );
787: -- Access Status:
788: -- Internal Table Handler Use Only.
789: --
790: procedure chk_employee_category
791: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
792: ,p_employee_category in per_all_assignments_f.employee_category%TYPE
793: ,p_effective_date in date
794: ,p_validation_start_date IN DATE
795: ,P_VALIDATION_END_DATE IN DATE
788: -- Internal Table Handler Use Only.
789: --
790: procedure chk_employee_category
791: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
792: ,p_employee_category in per_all_assignments_f.employee_category%TYPE
793: ,p_effective_date in date
794: ,p_validation_start_date IN DATE
795: ,P_VALIDATION_END_DATE IN DATE
796: );
822: -- Access Status:
823: -- Internal Table Handler Use Only.
824: --
825: procedure chk_grade_ladder_pgm_id
826: ( p_grade_id in per_all_assignments_f.grade_id%TYPE
827: ,p_grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%TYPE
828: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
829: ,p_effective_date in date
830: ) ;
823: -- Internal Table Handler Use Only.
824: --
825: procedure chk_grade_ladder_pgm_id
826: ( p_grade_id in per_all_assignments_f.grade_id%TYPE
827: ,p_grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%TYPE
828: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
829: ,p_effective_date in date
830: ) ;
831: --
824: --
825: procedure chk_grade_ladder_pgm_id
826: ( p_grade_id in per_all_assignments_f.grade_id%TYPE
827: ,p_grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%TYPE
828: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
829: ,p_effective_date in date
830: ) ;
831: --
832: -- --------------------------------------------------------------------------+