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

Line 36: p_assignment_id in per_all_assignments_f.assignment_id%TYPE

32: --
33: -- ---------------------------------------------------------------------------+
34: procedure set_security_group_id
35: (
36: p_assignment_id in per_all_assignments_f.assignment_id%TYPE
37: ,p_associated_column1 in varchar2 default null
38: );
39: --
40: -- ---------------------------------------------------------------------------+

Line 370: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

366: -- Access Status:
367: -- Internal Table Handler Use Only.
368: --
369: procedure chk_application_id
370: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
371: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
372: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
373: ,p_assignment_sequence in per_all_assignments_f.assignment_sequence%TYPE
374: ,p_application_id in per_all_assignments_f.application_id%TYPE

Line 371: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

367: -- Internal Table Handler Use Only.
368: --
369: procedure chk_application_id
370: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
371: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
372: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
373: ,p_assignment_sequence in per_all_assignments_f.assignment_sequence%TYPE
374: ,p_application_id in per_all_assignments_f.application_id%TYPE
375: ,p_effective_date in date

Line 372: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

368: --
369: procedure chk_application_id
370: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
371: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
372: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
373: ,p_assignment_sequence in per_all_assignments_f.assignment_sequence%TYPE
374: ,p_application_id in per_all_assignments_f.application_id%TYPE
375: ,p_effective_date in date
376: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 373: ,p_assignment_sequence in per_all_assignments_f.assignment_sequence%TYPE

369: procedure chk_application_id
370: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
371: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
372: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
373: ,p_assignment_sequence in per_all_assignments_f.assignment_sequence%TYPE
374: ,p_application_id in per_all_assignments_f.application_id%TYPE
375: ,p_effective_date in date
376: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
377: ,p_validation_start_date in date

Line 374: ,p_application_id in per_all_assignments_f.application_id%TYPE

370: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
371: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
372: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
373: ,p_assignment_sequence in per_all_assignments_f.assignment_sequence%TYPE
374: ,p_application_id in per_all_assignments_f.application_id%TYPE
375: ,p_effective_date in date
376: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
377: ,p_validation_start_date in date
378: );

Line 376: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

372: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
373: ,p_assignment_sequence in per_all_assignments_f.assignment_sequence%TYPE
374: ,p_application_id in per_all_assignments_f.application_id%TYPE
375: ,p_effective_date in date
376: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
377: ,p_validation_start_date in date
378: );
379: --
380: -- --------------------------------------------------------------------------+

Line 429: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

425: -- Access Status:
426: -- Internal Table Handler Use Only.
427: --
428: procedure gen_chk_assignment_number
429: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
430: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
431: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
432: ,p_assignment_sequence in per_all_assignments_f.assignment_sequence%TYPE
433: ,p_assignment_number in out nocopy per_all_assignments_f.assignment_number%TYPE

Line 430: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

426: -- Internal Table Handler Use Only.
427: --
428: procedure gen_chk_assignment_number
429: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
430: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
431: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
432: ,p_assignment_sequence in per_all_assignments_f.assignment_sequence%TYPE
433: ,p_assignment_number in out nocopy per_all_assignments_f.assignment_number%TYPE
434: ,p_person_id in per_all_assignments_f.person_id%TYPE

Line 431: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

427: --
428: procedure gen_chk_assignment_number
429: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
430: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
431: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
432: ,p_assignment_sequence in per_all_assignments_f.assignment_sequence%TYPE
433: ,p_assignment_number in out nocopy per_all_assignments_f.assignment_number%TYPE
434: ,p_person_id in per_all_assignments_f.person_id%TYPE
435: ,p_effective_date in date

Line 432: ,p_assignment_sequence in per_all_assignments_f.assignment_sequence%TYPE

428: procedure gen_chk_assignment_number
429: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
430: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
431: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
432: ,p_assignment_sequence in per_all_assignments_f.assignment_sequence%TYPE
433: ,p_assignment_number in out nocopy per_all_assignments_f.assignment_number%TYPE
434: ,p_person_id in per_all_assignments_f.person_id%TYPE
435: ,p_effective_date in date
436: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 433: ,p_assignment_number in out nocopy per_all_assignments_f.assignment_number%TYPE

429: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
430: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
431: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
432: ,p_assignment_sequence in per_all_assignments_f.assignment_sequence%TYPE
433: ,p_assignment_number in out nocopy per_all_assignments_f.assignment_number%TYPE
434: ,p_person_id in per_all_assignments_f.person_id%TYPE
435: ,p_effective_date in date
436: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
437: );

Line 434: ,p_person_id in per_all_assignments_f.person_id%TYPE

430: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
431: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
432: ,p_assignment_sequence in per_all_assignments_f.assignment_sequence%TYPE
433: ,p_assignment_number in out nocopy per_all_assignments_f.assignment_number%TYPE
434: ,p_person_id in per_all_assignments_f.person_id%TYPE
435: ,p_effective_date in date
436: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
437: );
438: --

Line 436: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

432: ,p_assignment_sequence in per_all_assignments_f.assignment_sequence%TYPE
433: ,p_assignment_number in out nocopy per_all_assignments_f.assignment_number%TYPE
434: ,p_person_id in per_all_assignments_f.person_id%TYPE
435: ,p_effective_date in date
436: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
437: );
438: --
439: -- ---------------------------------------------------------------------------+
440: -- |----------------------< chk_assignment_status_type >----------------------|

Line 603: ,p_effective_date in per_all_assignments_f.effective_start_date%TYPE

599: -- Internal Table Handler Use Only.
600: --
601: procedure chk_assignment_status_type_id
602: (p_rec in per_asg_shd.g_rec_type
603: ,p_effective_date in per_all_assignments_f.effective_start_date%TYPE
604: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
605: );
606: --
607: -- ---------------------------------------------------------------------------

Line 604: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

600: --
601: procedure chk_assignment_status_type_id
602: (p_rec in per_asg_shd.g_rec_type
603: ,p_effective_date in per_all_assignments_f.effective_start_date%TYPE
604: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
605: );
606: --
607: -- ---------------------------------------------------------------------------
608: -- |-----------------------< chk_assignment_category >------------------------|

Line 649: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

645: -- Access Status:
646: -- Internal Table Handler Use Only.
647: --
648: PROCEDURE chk_assignment_category
649: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
650: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
651: ,p_effective_date in date
652: ,p_assignment_category in per_assignments_f.assignment_category%TYPE
653: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 650: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

646: -- Internal Table Handler Use Only.
647: --
648: PROCEDURE chk_assignment_category
649: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
650: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
651: ,p_effective_date in date
652: ,p_assignment_category in per_assignments_f.assignment_category%TYPE
653: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
654: ,p_validation_start_date in date

Line 653: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

649: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
650: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
651: ,p_effective_date in date
652: ,p_assignment_category in per_assignments_f.assignment_category%TYPE
653: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
654: ,p_validation_start_date in date
655: ,p_validation_end_date in date);
656: --
657: -- --------------------------------------------------------------------------+

Line 695: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

691: -- Access Status:
692: -- Internal Table Handler Use Only.
693: --
694: procedure chk_assignment_type
695: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
696: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
697: ,p_person_id in per_all_assignments_f.person_id%TYPE
698: ,p_effective_date in date
699: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 696: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

692: -- Internal Table Handler Use Only.
693: --
694: procedure chk_assignment_type
695: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
696: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
697: ,p_person_id in per_all_assignments_f.person_id%TYPE
698: ,p_effective_date in date
699: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
700: ,p_validation_start_date in date

Line 697: ,p_person_id in per_all_assignments_f.person_id%TYPE

693: --
694: procedure chk_assignment_type
695: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
696: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
697: ,p_person_id in per_all_assignments_f.person_id%TYPE
698: ,p_effective_date in date
699: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
700: ,p_validation_start_date in date
701: );

Line 699: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

695: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
696: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
697: ,p_person_id in per_all_assignments_f.person_id%TYPE
698: ,p_effective_date in date
699: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
700: ,p_validation_start_date in date
701: );
702: --
703: -- --------------------------------------------------------------------------+

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_change_reason
757: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
758: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
759: ,p_change_reason in per_all_assignments_f.change_reason%TYPE
760: ,p_effective_date in date
761: ,p_validation_start_date in date

Line 758: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

754: -- Internal Table Handler Use Only.
755: --
756: procedure chk_change_reason
757: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
758: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
759: ,p_change_reason in per_all_assignments_f.change_reason%TYPE
760: ,p_effective_date in date
761: ,p_validation_start_date in date
762: ,p_validation_end_date in date

Line 759: ,p_change_reason in per_all_assignments_f.change_reason%TYPE

755: --
756: procedure chk_change_reason
757: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
758: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
759: ,p_change_reason in per_all_assignments_f.change_reason%TYPE
760: ,p_effective_date in date
761: ,p_validation_start_date in date
762: ,p_validation_end_date in date
763: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 763: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

759: ,p_change_reason in per_all_assignments_f.change_reason%TYPE
760: ,p_effective_date in date
761: ,p_validation_start_date in date
762: ,p_validation_end_date in date
763: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
764: );
765: --
766: -- --------------------------------------------------------------------------+
767: -- |-------------------------< chk_contig_ass >------------------------------|

Line 796: (p_primary_flag in per_all_assignments_f.primary_flag%TYPE

792: -- Access Status:
793: -- Internal Table Handler Use Only.
794: --
795: procedure chk_contig_ass
796: (p_primary_flag in per_all_assignments_f.primary_flag%TYPE
797: ,p_person_id in per_all_assignments_f.person_id%TYPE
798: ,p_effective_date in date
799: ,p_datetrack_mode in varchar2
800: );

Line 797: ,p_person_id in per_all_assignments_f.person_id%TYPE

793: -- Internal Table Handler Use Only.
794: --
795: procedure chk_contig_ass
796: (p_primary_flag in per_all_assignments_f.primary_flag%TYPE
797: ,p_person_id in per_all_assignments_f.person_id%TYPE
798: ,p_effective_date in date
799: ,p_datetrack_mode in varchar2
800: );
801: --

Line 853: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

849: -- Access Status:
850: -- Internal Table Handler Use Only.
851: --
852: procedure chk_date_probation_end
853: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
854: ,p_date_probation_end in per_all_assignments_f.date_probation_end%TYPE
855: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
856: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
857: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE

Line 854: ,p_date_probation_end in per_all_assignments_f.date_probation_end%TYPE

850: -- Internal Table Handler Use Only.
851: --
852: procedure chk_date_probation_end
853: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
854: ,p_date_probation_end in per_all_assignments_f.date_probation_end%TYPE
855: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
856: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
857: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
858: ,p_validation_start_date in date

Line 855: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

851: --
852: procedure chk_date_probation_end
853: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
854: ,p_date_probation_end in per_all_assignments_f.date_probation_end%TYPE
855: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
856: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
857: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
858: ,p_validation_start_date in date
859: ,p_effective_date in date

Line 856: ,p_probation_period in per_all_assignments_f.probation_period%TYPE

852: procedure chk_date_probation_end
853: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
854: ,p_date_probation_end in per_all_assignments_f.date_probation_end%TYPE
855: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
856: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
857: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
858: ,p_validation_start_date in date
859: ,p_effective_date in date
860: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 857: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE

853: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
854: ,p_date_probation_end in per_all_assignments_f.date_probation_end%TYPE
855: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
856: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
857: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
858: ,p_validation_start_date in date
859: ,p_effective_date in date
860: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
861: );

Line 860: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

856: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
857: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
858: ,p_validation_start_date in date
859: ,p_effective_date in date
860: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
861: );
862: --
863: -- --------------------------------------------------------------------------+
864: -- |--------------------< chk_default_code_comb_id >-------------------------|

Line 913: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

909: -- Access Status:
910: -- Internal Table Handler Use Only
911: --
912: procedure chk_default_code_comb_id
913: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
914: ,p_default_code_comb_id in per_all_assignments_f.default_code_comb_id%TYPE
915: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
916: ,p_effective_date in date
917: ,p_validation_start_date in date

Line 914: ,p_default_code_comb_id in per_all_assignments_f.default_code_comb_id%TYPE

910: -- Internal Table Handler Use Only
911: --
912: procedure chk_default_code_comb_id
913: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
914: ,p_default_code_comb_id in per_all_assignments_f.default_code_comb_id%TYPE
915: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
916: ,p_effective_date in date
917: ,p_validation_start_date in date
918: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 915: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

911: --
912: procedure chk_default_code_comb_id
913: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
914: ,p_default_code_comb_id in per_all_assignments_f.default_code_comb_id%TYPE
915: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
916: ,p_effective_date in date
917: ,p_validation_start_date in date
918: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
919: );

Line 918: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

914: ,p_default_code_comb_id in per_all_assignments_f.default_code_comb_id%TYPE
915: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
916: ,p_effective_date in date
917: ,p_validation_start_date in date
918: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
919: );
920: --
921: -- --------------------------------------------------------------------------+
922: -- |----------------------< chk_del_organization_id >------------------------|

Line 951: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

947: -- Access Status:
948: -- Internal Table Handler Use Only.
949: --
950: procedure chk_del_organization_id
951: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
952: ,p_effective_date in date
953: ,p_manager_flag in per_all_assignments_f.manager_flag%TYPE
954: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
955: ,p_org_now_no_manager_warning in out nocopy boolean

Line 953: ,p_manager_flag in per_all_assignments_f.manager_flag%TYPE

949: --
950: procedure chk_del_organization_id
951: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
952: ,p_effective_date in date
953: ,p_manager_flag in per_all_assignments_f.manager_flag%TYPE
954: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
955: ,p_org_now_no_manager_warning in out nocopy boolean
956: );
957: -- --------------------------------------------------------------------------+

Line 954: ,p_organization_id in per_all_assignments_f.organization_id%TYPE

950: procedure chk_del_organization_id
951: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
952: ,p_effective_date in date
953: ,p_manager_flag in per_all_assignments_f.manager_flag%TYPE
954: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
955: ,p_org_now_no_manager_warning in out nocopy boolean
956: );
957: -- --------------------------------------------------------------------------+
958: -- |-----------------------< chk_employment_category >-----------------------|

Line 1001: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

997: -- Access Status:
998: -- Internal Table Handler Use Only.
999: --
1000: procedure chk_employment_category
1001: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1002: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1003: ,p_employment_category in per_all_assignments_f.employment_category%TYPE
1004: ,p_effective_date in date
1005: ,p_validation_start_date in date

Line 1002: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

998: -- Internal Table Handler Use Only.
999: --
1000: procedure chk_employment_category
1001: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1002: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1003: ,p_employment_category in per_all_assignments_f.employment_category%TYPE
1004: ,p_effective_date in date
1005: ,p_validation_start_date in date
1006: ,p_validation_end_date in date

Line 1003: ,p_employment_category in per_all_assignments_f.employment_category%TYPE

999: --
1000: procedure chk_employment_category
1001: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1002: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1003: ,p_employment_category in per_all_assignments_f.employment_category%TYPE
1004: ,p_effective_date in date
1005: ,p_validation_start_date in date
1006: ,p_validation_end_date in date
1007: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 1007: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1003: ,p_employment_category in per_all_assignments_f.employment_category%TYPE
1004: ,p_effective_date in date
1005: ,p_validation_start_date in date
1006: ,p_validation_end_date in date
1007: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1008: );
1009: --
1010: -- --------------------------------------------------------------------------+
1011: -- |-------------------------< chk_frequency >-------------------------------|

Line 1049: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1045: -- Access Status:
1046: -- Internal Table Handler Use Only.
1047: --
1048: procedure chk_frequency
1049: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1050: ,p_frequency in per_all_assignments_f.frequency%TYPE
1051: ,p_effective_date in date
1052: ,p_validation_start_date in date
1053: ,p_validation_end_date in date

Line 1050: ,p_frequency in per_all_assignments_f.frequency%TYPE

1046: -- Internal Table Handler Use Only.
1047: --
1048: procedure chk_frequency
1049: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1050: ,p_frequency in per_all_assignments_f.frequency%TYPE
1051: ,p_effective_date in date
1052: ,p_validation_start_date in date
1053: ,p_validation_end_date in date
1054: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 1054: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1050: ,p_frequency in per_all_assignments_f.frequency%TYPE
1051: ,p_effective_date in date
1052: ,p_validation_start_date in date
1053: ,p_validation_end_date in date
1054: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1055: );
1056: --
1057: -- --------------------------------------------------------------------------+
1058: -- |------------------------< chk_future_primary >---------------------------|

Line 1085: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1081: -- Access Status:
1082: -- Internal Table Handler Use Only.
1083: --
1084: procedure chk_future_primary
1085: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1086: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
1087: ,p_datetrack_mode in varchar2
1088: ,p_effective_date in date
1089: );

Line 1086: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE

1082: -- Internal Table Handler Use Only.
1083: --
1084: procedure chk_future_primary
1085: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1086: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
1087: ,p_datetrack_mode in varchar2
1088: ,p_effective_date in date
1089: );
1090: --

Line 1138: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1134: -- of the assignment.
1135: -- - the grade is not set but the special ceiling step is set.
1136: --
1137: procedure chk_grade_id
1138: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1139: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1140: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1141: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1142: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

Line 1139: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

1135: -- - the grade is not set but the special ceiling step is set.
1136: --
1137: procedure chk_grade_id
1138: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1139: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1140: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1141: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1142: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1143: ,p_special_ceiling_step_id in per_all_assignments_f.special_ceiling_step_id%TYPE

Line 1140: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

1136: --
1137: procedure chk_grade_id
1138: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1139: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1140: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1141: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1142: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1143: ,p_special_ceiling_step_id in per_all_assignments_f.special_ceiling_step_id%TYPE
1144: ,p_effective_date in date

Line 1141: ,p_grade_id in per_all_assignments_f.grade_id%TYPE

1137: procedure chk_grade_id
1138: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1139: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1140: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1141: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1142: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1143: ,p_special_ceiling_step_id in per_all_assignments_f.special_ceiling_step_id%TYPE
1144: ,p_effective_date in date
1145: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

Line 1142: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

1138: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1139: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1140: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1141: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1142: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1143: ,p_special_ceiling_step_id in per_all_assignments_f.special_ceiling_step_id%TYPE
1144: ,p_effective_date in date
1145: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1146: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

Line 1143: ,p_special_ceiling_step_id in per_all_assignments_f.special_ceiling_step_id%TYPE

1139: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1140: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1141: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1142: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1143: ,p_special_ceiling_step_id in per_all_assignments_f.special_ceiling_step_id%TYPE
1144: ,p_effective_date in date
1145: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1146: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1147: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 1145: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

1141: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1142: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1143: ,p_special_ceiling_step_id in per_all_assignments_f.special_ceiling_step_id%TYPE
1144: ,p_effective_date in date
1145: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1146: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1147: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1148: );
1149: --

Line 1146: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

1142: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1143: ,p_special_ceiling_step_id in per_all_assignments_f.special_ceiling_step_id%TYPE
1144: ,p_effective_date in date
1145: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1146: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1147: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1148: );
1149: --
1150: -- --------------------------------------------------------------------------+

Line 1147: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1143: ,p_special_ceiling_step_id in per_all_assignments_f.special_ceiling_step_id%TYPE
1144: ,p_effective_date in date
1145: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1146: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1147: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1148: );
1149: --
1150: -- --------------------------------------------------------------------------+
1151: -- |-----------------------------< chk_job_id >------------------------------|

Line 1194: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1190: -- Access Status:
1191: -- Internal Table Handler Use Only.
1192: --
1193: procedure chk_job_id
1194: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1195: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1196: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1197: ,p_job_id in per_all_assignments_f.job_id%TYPE
1198: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

Line 1195: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

1191: -- Internal Table Handler Use Only.
1192: --
1193: procedure chk_job_id
1194: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1195: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1196: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1197: ,p_job_id in per_all_assignments_f.job_id%TYPE
1198: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1199: ,p_effective_date in date

Line 1196: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

1192: --
1193: procedure chk_job_id
1194: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1195: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1196: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1197: ,p_job_id in per_all_assignments_f.job_id%TYPE
1198: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1199: ,p_effective_date in date
1200: ,p_validation_start_date in date

Line 1197: ,p_job_id in per_all_assignments_f.job_id%TYPE

1193: procedure chk_job_id
1194: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1195: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1196: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1197: ,p_job_id in per_all_assignments_f.job_id%TYPE
1198: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1199: ,p_effective_date in date
1200: ,p_validation_start_date in date
1201: ,p_validation_end_date in date

Line 1198: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

1194: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1195: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1196: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1197: ,p_job_id in per_all_assignments_f.job_id%TYPE
1198: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1199: ,p_effective_date in date
1200: ,p_validation_start_date in date
1201: ,p_validation_end_date in date
1202: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 1202: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1198: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1199: ,p_effective_date in date
1200: ,p_validation_start_date in date
1201: ,p_validation_end_date in date
1202: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1203: );
1204: --
1205: -- --------------------------------------------------------------------------+
1206: -- |----------------------< chk_job_id_grade_id >----------------------------|

Line 1242: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1238: -- and are not modified in this
1239: -- transaction.
1240: --
1241: procedure chk_job_id_grade_id
1242: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1243: ,p_job_id in per_all_assignments_f.job_id%TYPE
1244: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1245: ,p_effective_date in date
1246: ,p_validation_start_date in date

Line 1243: ,p_job_id in per_all_assignments_f.job_id%TYPE

1239: -- transaction.
1240: --
1241: procedure chk_job_id_grade_id
1242: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1243: ,p_job_id in per_all_assignments_f.job_id%TYPE
1244: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1245: ,p_effective_date in date
1246: ,p_validation_start_date in date
1247: ,p_validation_end_date in date

Line 1244: ,p_grade_id in per_all_assignments_f.grade_id%TYPE

1240: --
1241: procedure chk_job_id_grade_id
1242: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1243: ,p_job_id in per_all_assignments_f.job_id%TYPE
1244: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1245: ,p_effective_date in date
1246: ,p_validation_start_date in date
1247: ,p_validation_end_date in date
1248: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 1248: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1244: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1245: ,p_effective_date in date
1246: ,p_validation_start_date in date
1247: ,p_validation_end_date in date
1248: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1249: ,p_inv_job_grade_warning out nocopy boolean
1250: );
1251: -- --------------------------------------------------------------------------+
1252: -- |--------------------------< chk_location_id >----------------------------|

Line 1290: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1286: -- Access Status
1287: -- Internal Table Handler Use Only.
1288: --
1289: procedure chk_location_id
1290: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1291: ,p_location_id in per_all_assignments_f.location_id%TYPE
1292: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1293: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1294: ,p_effective_date in date

Line 1291: ,p_location_id in per_all_assignments_f.location_id%TYPE

1287: -- Internal Table Handler Use Only.
1288: --
1289: procedure chk_location_id
1290: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1291: ,p_location_id in per_all_assignments_f.location_id%TYPE
1292: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1293: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1294: ,p_effective_date in date
1295: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

Line 1292: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

1288: --
1289: procedure chk_location_id
1290: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1291: ,p_location_id in per_all_assignments_f.location_id%TYPE
1292: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1293: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1294: ,p_effective_date in date
1295: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1296: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

Line 1293: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

1289: procedure chk_location_id
1290: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1291: ,p_location_id in per_all_assignments_f.location_id%TYPE
1292: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1293: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1294: ,p_effective_date in date
1295: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1296: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1297: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 1295: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

1291: ,p_location_id in per_all_assignments_f.location_id%TYPE
1292: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1293: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1294: ,p_effective_date in date
1295: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1296: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1297: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1298: );
1299: --

Line 1296: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

1292: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1293: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1294: ,p_effective_date in date
1295: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1296: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1297: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1298: );
1299: --
1300: -- --------------------------------------------------------------------------+

Line 1297: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1293: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1294: ,p_effective_date in date
1295: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1296: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1297: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1298: );
1299: --
1300: -- --------------------------------------------------------------------------+
1301: -- |-------------------------< chk_manager_flag >----------------------------|

Line 1343: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1339: -- Access Status:
1340: -- Internal Table Handler Use Only.
1341: --
1342: procedure chk_manager_flag
1343: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1344: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1345: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1346: ,p_manager_flag in per_all_assignments_f.manager_flag%TYPE
1347: ,p_effective_date in date

Line 1344: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

1340: -- Internal Table Handler Use Only.
1341: --
1342: procedure chk_manager_flag
1343: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1344: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1345: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1346: ,p_manager_flag in per_all_assignments_f.manager_flag%TYPE
1347: ,p_effective_date in date
1348: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 1345: ,p_organization_id in per_all_assignments_f.organization_id%TYPE

1341: --
1342: procedure chk_manager_flag
1343: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1344: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1345: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1346: ,p_manager_flag in per_all_assignments_f.manager_flag%TYPE
1347: ,p_effective_date in date
1348: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1349: ,p_other_manager_warning in out nocopy boolean

Line 1346: ,p_manager_flag in per_all_assignments_f.manager_flag%TYPE

1342: procedure chk_manager_flag
1343: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1344: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1345: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1346: ,p_manager_flag in per_all_assignments_f.manager_flag%TYPE
1347: ,p_effective_date in date
1348: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1349: ,p_other_manager_warning in out nocopy boolean
1350: ,p_no_managers_warning in out nocopy boolean

Line 1348: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1344: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1345: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1346: ,p_manager_flag in per_all_assignments_f.manager_flag%TYPE
1347: ,p_effective_date in date
1348: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1349: ,p_other_manager_warning in out nocopy boolean
1350: ,p_no_managers_warning in out nocopy boolean
1351: );
1352: --

Line 1387: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1383: -- Access Status:
1384: -- Internal Table Handler Use Only
1385: --
1386: procedure chk_frequency_normal_hours
1387: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1388: ,p_frequency in per_all_assignments_f.frequency%TYPE
1389: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
1390: ,p_effective_date in date
1391: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 1388: ,p_frequency in per_all_assignments_f.frequency%TYPE

1384: -- Internal Table Handler Use Only
1385: --
1386: procedure chk_frequency_normal_hours
1387: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1388: ,p_frequency in per_all_assignments_f.frequency%TYPE
1389: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
1390: ,p_effective_date in date
1391: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1392: );

Line 1389: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE

1385: --
1386: procedure chk_frequency_normal_hours
1387: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1388: ,p_frequency in per_all_assignments_f.frequency%TYPE
1389: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
1390: ,p_effective_date in date
1391: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1392: );
1393: -- --------------------------------------------------------------------------+

Line 1391: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1387: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1388: ,p_frequency in per_all_assignments_f.frequency%TYPE
1389: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
1390: ,p_effective_date in date
1391: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1392: );
1393: -- --------------------------------------------------------------------------+
1394: -- |-----------------------< chk_organization_id >---------------------------|
1395: -- --------------------------------------------------------------------------+

Line 1465: (p_primary_flag in per_all_assignments_f.primary_flag%TYPE

1461: -- Access Status:
1462: -- Internal Table Handler Use Only.
1463: --
1464: procedure chk_organization_id
1465: (p_primary_flag in per_all_assignments_f.primary_flag%TYPE
1466: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1467: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1468: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1469: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

Line 1466: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1462: -- Internal Table Handler Use Only.
1463: --
1464: procedure chk_organization_id
1465: (p_primary_flag in per_all_assignments_f.primary_flag%TYPE
1466: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1467: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1468: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1469: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1470: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

Line 1467: ,p_organization_id in per_all_assignments_f.organization_id%TYPE

1463: --
1464: procedure chk_organization_id
1465: (p_primary_flag in per_all_assignments_f.primary_flag%TYPE
1466: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1467: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1468: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1469: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1470: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1471: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

Line 1468: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

1464: procedure chk_organization_id
1465: (p_primary_flag in per_all_assignments_f.primary_flag%TYPE
1466: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1467: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1468: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1469: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1470: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1471: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1472: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

Line 1469: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

1465: (p_primary_flag in per_all_assignments_f.primary_flag%TYPE
1466: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1467: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1468: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1469: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1470: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1471: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1472: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1473: ,p_effective_date in date

Line 1470: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

1466: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1467: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1468: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1469: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1470: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1471: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1472: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1473: ,p_effective_date in date
1474: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 1471: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

1467: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1468: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1469: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1470: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1471: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1472: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1473: ,p_effective_date in date
1474: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1475: ,p_manager_flag in per_all_assignments_f.manager_flag%TYPE

Line 1472: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

1468: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1469: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1470: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1471: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1472: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1473: ,p_effective_date in date
1474: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1475: ,p_manager_flag in per_all_assignments_f.manager_flag%TYPE
1476: ,p_org_now_no_manager_warning in out nocopy boolean

Line 1474: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1470: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1471: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1472: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1473: ,p_effective_date in date
1474: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1475: ,p_manager_flag in per_all_assignments_f.manager_flag%TYPE
1476: ,p_org_now_no_manager_warning in out nocopy boolean
1477: ,p_other_manager_warning in out nocopy boolean
1478: );

Line 1475: ,p_manager_flag in per_all_assignments_f.manager_flag%TYPE

1471: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1472: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1473: ,p_effective_date in date
1474: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1475: ,p_manager_flag in per_all_assignments_f.manager_flag%TYPE
1476: ,p_org_now_no_manager_warning in out nocopy boolean
1477: ,p_other_manager_warning in out nocopy boolean
1478: );
1479: --

Line 1512: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1508: -- Internal Table Handler Use Only
1509: --
1510: --
1511: procedure chk_bargaining_unit_code
1512: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1513: ,p_bargaining_unit_code in per_all_assignments_f.bargaining_unit_code%TYPE
1514: ,p_effective_date in date
1515: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1516: ,p_validation_start_date in date

Line 1513: ,p_bargaining_unit_code in per_all_assignments_f.bargaining_unit_code%TYPE

1509: --
1510: --
1511: procedure chk_bargaining_unit_code
1512: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1513: ,p_bargaining_unit_code in per_all_assignments_f.bargaining_unit_code%TYPE
1514: ,p_effective_date in date
1515: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1516: ,p_validation_start_date in date
1517: ,p_validation_end_date in date

Line 1515: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1511: procedure chk_bargaining_unit_code
1512: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1513: ,p_bargaining_unit_code in per_all_assignments_f.bargaining_unit_code%TYPE
1514: ,p_effective_date in date
1515: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1516: ,p_validation_start_date in date
1517: ,p_validation_end_date in date
1518: );
1519: --

Line 1555: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1551: -- Internal Table Handler Use Only
1552: --
1553: --
1554: procedure chk_hourly_salaried_code
1555: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1556: ,p_hourly_salaried_code in per_all_assignments_f.hourly_salaried_code%TYPE
1557: ,p_effective_date in date
1558: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1559: ,p_validation_start_date in date

Line 1556: ,p_hourly_salaried_code in per_all_assignments_f.hourly_salaried_code%TYPE

1552: --
1553: --
1554: procedure chk_hourly_salaried_code
1555: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1556: ,p_hourly_salaried_code in per_all_assignments_f.hourly_salaried_code%TYPE
1557: ,p_effective_date in date
1558: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1559: ,p_validation_start_date in date
1560: ,p_validation_end_date in date

Line 1558: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1554: procedure chk_hourly_salaried_code
1555: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1556: ,p_hourly_salaried_code in per_all_assignments_f.hourly_salaried_code%TYPE
1557: ,p_effective_date in date
1558: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1559: ,p_validation_start_date in date
1560: ,p_validation_end_date in date
1561: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
1562: ,p_hourly_salaried_warning in out nocopy boolean

Line 1561: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE

1557: ,p_effective_date in date
1558: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1559: ,p_validation_start_date in date
1560: ,p_validation_end_date in date
1561: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
1562: ,p_hourly_salaried_warning in out nocopy boolean
1563: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1564: );
1565: --

Line 1563: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

1559: ,p_validation_start_date in date
1560: ,p_validation_end_date in date
1561: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
1562: ,p_hourly_salaried_warning in out nocopy boolean
1563: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1564: );
1565: --
1566: -- --------------------------------------------------------------------------+
1567: -- |---------------------< return_legislation_code >-------------------------|

Line 1623: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1619: -- Access Status:
1620: -- Internal Table Handler Use Only
1621: --
1622: procedure chk_frozen_single_pos
1623: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1624: ,p_position_id in per_all_assignments_f.position_id%TYPE
1625: ,p_effective_date in date
1626: ,p_assignment_type in varchar2 default 'E'
1627: );

Line 1624: ,p_position_id in per_all_assignments_f.position_id%TYPE

1620: -- Internal Table Handler Use Only
1621: --
1622: procedure chk_frozen_single_pos
1623: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1624: ,p_position_id in per_all_assignments_f.position_id%TYPE
1625: ,p_effective_date in date
1626: ,p_assignment_type in varchar2 default 'E'
1627: );
1628: --

Line 1658: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1654: -- Access Status:
1655: -- Internal Table Handler Use Only
1656: --
1657: procedure chk_single_position
1658: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1659: ,p_position_id in per_all_assignments_f.position_id%TYPE
1660: ,p_effective_date in date
1661: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1662: ,p_assignment_type in per_all_assignments_f.assignment_type%type default 'E'

Line 1659: ,p_position_id in per_all_assignments_f.position_id%TYPE

1655: -- Internal Table Handler Use Only
1656: --
1657: procedure chk_single_position
1658: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1659: ,p_position_id in per_all_assignments_f.position_id%TYPE
1660: ,p_effective_date in date
1661: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1662: ,p_assignment_type in per_all_assignments_f.assignment_type%type default 'E'
1663: );

Line 1661: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1657: procedure chk_single_position
1658: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1659: ,p_position_id in per_all_assignments_f.position_id%TYPE
1660: ,p_effective_date in date
1661: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1662: ,p_assignment_type in per_all_assignments_f.assignment_type%type default 'E'
1663: );
1664: --
1665: --

Line 1662: ,p_assignment_type in per_all_assignments_f.assignment_type%type default 'E'

1658: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1659: ,p_position_id in per_all_assignments_f.position_id%TYPE
1660: ,p_effective_date in date
1661: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1662: ,p_assignment_type in per_all_assignments_f.assignment_type%type default 'E'
1663: );
1664: --
1665: --
1666: --