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_ASG_BUS3 dependencies on PER_ALL_ASSIGNMENTS_F

Line 353: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

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

Line 354: ,p_assignment_type IN per_all_assignments_f.assignment_type%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);

Line 355: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE

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

Line 357: ,p_object_version_number IN per_all_assignments_f.object_version_number%TYPE

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

Line 395: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

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

Line 396: ,p_assignment_type IN per_all_assignments_f.assignment_type%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);

Line 397: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE

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

Line 399: ,p_object_version_number IN per_all_assignments_f.object_version_number%TYPE

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

Line 461: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

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

Line 462: ,p_business_group_id IN per_all_assignments_f.business_group_id%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

Line 463: ,p_person_id IN per_all_assignments_f.person_id%TYPE

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

Line 464: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE

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

Line 469: ,p_object_version_number IN per_all_assignments_f.object_version_number%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
469: ,p_object_version_number IN per_all_assignments_f.object_version_number%TYPE
470: );
471: --
472: -- --------------------------------------------------------------------------+
473: -- |--------------------< chk_cagr_grade_def_id >---------------------------|

Line 505: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

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

Line 507: ,p_object_version_number in per_all_assignments_f.object_version_number%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: );

Line 508: ,p_cagr_grade_def_id in per_all_assignments_f.cagr_grade_def_id%TYPE

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

Line 509: ,p_collective_agreement_id in per_all_assignments_f.collective_agreement_id%TYPE

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

Line 510: ,p_cagr_id_flex_num in per_all_assignments_f.cagr_id_flex_num%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: -- --------------------------------------------------------------------------+
514: -- |--------------------< chk_cagr_id_flex_num >----------------------------|

Line 542: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

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

Line 544: ,p_object_version_number in per_all_assignments_f.object_version_number%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: --

Line 545: ,p_cagr_id_flex_num in per_all_assignments_f.cagr_id_flex_num%TYPE

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

Line 546: ,p_collective_agreement_id in per_all_assignments_f.collective_agreement_id%TYPE

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

Line 580: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

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

Line 582: ,p_object_version_number in per_all_assignments_f.object_version_number%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

Line 583: ,p_contract_id in per_all_assignments_f.contract_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: );

Line 584: ,p_person_id in per_all_assignments_f.person_id%TYPE

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

Line 586: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

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

Line 619: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

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

Line 621: ,p_object_version_number in per_all_assignments_f.object_version_number%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: );

Line 622: ,p_collective_agreement_id in per_all_assignments_f.collective_agreement_id%TYPE

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

Line 623: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

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

Line 624: ,p_establishment_id in per_all_assignments_f.establishment_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 >-----------------------------|
628: -- --------------------------------------------------------------------------+

Line 655: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

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

Line 657: ,p_object_version_number in per_all_assignments_f.object_version_number%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: );

Line 658: ,p_establishment_id in per_all_assignments_f.establishment_id%TYPE

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:

Line 659: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

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

Line 660: ,p_business_group_id in per_all_assignments_f.business_group_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: -- --------------------------------------------------------------------------+
664: -- |--------------------< chk_notice_period >-----------------------------|

Line 690: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

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

Line 691: ,p_notice_period in per_all_assignments_f.notice_period%TYPE

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

Line 722: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

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

Line 723: ,p_notice_period in per_all_assignments_f.notice_period%TYPE

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

Line 724: ,p_notice_period_uom in per_all_assignments_f.notice_period_uom%TYPE

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

Line 757: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

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

Line 758: ,p_work_at_home in per_all_assignments_f.work_at_home%TYPE

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

Line 791: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

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

Line 792: ,p_employee_category in per_all_assignments_f.employee_category%TYPE

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

Line 826: ( p_grade_id in per_all_assignments_f.grade_id%TYPE

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

Line 827: ,p_grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%TYPE

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

Line 828: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

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