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: -- Start changes for bug 11063182

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: -- Start changes for bug 11063182
1301: -- Overloaded procedure with parameter p_business_group_id

Line 1304: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1300: -- Start changes for bug 11063182
1301: -- Overloaded procedure with parameter p_business_group_id
1302: --
1303: procedure chk_location_id
1304: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1305: ,p_location_id in per_all_assignments_f.location_id%TYPE
1306: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1307: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1308: ,p_effective_date in date

Line 1305: ,p_location_id in per_all_assignments_f.location_id%TYPE

1301: -- Overloaded procedure with parameter p_business_group_id
1302: --
1303: procedure chk_location_id
1304: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1305: ,p_location_id in per_all_assignments_f.location_id%TYPE
1306: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1307: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1308: ,p_effective_date in date
1309: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

Line 1306: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

1302: --
1303: procedure chk_location_id
1304: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1305: ,p_location_id in per_all_assignments_f.location_id%TYPE
1306: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1307: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1308: ,p_effective_date in date
1309: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1310: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

Line 1307: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

1303: procedure chk_location_id
1304: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1305: ,p_location_id in per_all_assignments_f.location_id%TYPE
1306: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1307: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1308: ,p_effective_date in date
1309: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1310: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1311: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 1309: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

1305: ,p_location_id in per_all_assignments_f.location_id%TYPE
1306: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1307: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1308: ,p_effective_date in date
1309: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1310: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1311: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1312: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1313: );

Line 1310: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

1306: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1307: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1308: ,p_effective_date in date
1309: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1310: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1311: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1312: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1313: );
1314: --

Line 1311: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1307: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1308: ,p_effective_date in date
1309: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1310: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1311: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1312: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1313: );
1314: --
1315: -- --------------------------------------------------------------------------+

Line 1312: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

1308: ,p_effective_date in date
1309: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1310: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1311: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1312: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1313: );
1314: --
1315: -- --------------------------------------------------------------------------+
1316: -- |-------------------------< chk_manager_flag >----------------------------|

Line 1358: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1354: -- Access Status:
1355: -- Internal Table Handler Use Only.
1356: --
1357: procedure chk_manager_flag
1358: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1359: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1360: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1361: ,p_manager_flag in per_all_assignments_f.manager_flag%TYPE
1362: ,p_effective_date in date

Line 1359: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

1355: -- Internal Table Handler Use Only.
1356: --
1357: procedure chk_manager_flag
1358: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1359: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1360: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1361: ,p_manager_flag in per_all_assignments_f.manager_flag%TYPE
1362: ,p_effective_date in date
1363: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 1360: ,p_organization_id in per_all_assignments_f.organization_id%TYPE

1356: --
1357: procedure chk_manager_flag
1358: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1359: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1360: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1361: ,p_manager_flag in per_all_assignments_f.manager_flag%TYPE
1362: ,p_effective_date in date
1363: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1364: ,p_other_manager_warning in out nocopy boolean

Line 1361: ,p_manager_flag in per_all_assignments_f.manager_flag%TYPE

1357: procedure chk_manager_flag
1358: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1359: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1360: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1361: ,p_manager_flag in per_all_assignments_f.manager_flag%TYPE
1362: ,p_effective_date in date
1363: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1364: ,p_other_manager_warning in out nocopy boolean
1365: ,p_no_managers_warning in out nocopy boolean

Line 1363: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1359: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1360: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1361: ,p_manager_flag in per_all_assignments_f.manager_flag%TYPE
1362: ,p_effective_date in date
1363: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1364: ,p_other_manager_warning in out nocopy boolean
1365: ,p_no_managers_warning in out nocopy boolean
1366: );
1367: --

Line 1402: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1398: -- Access Status:
1399: -- Internal Table Handler Use Only
1400: --
1401: procedure chk_frequency_normal_hours
1402: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1403: ,p_frequency in per_all_assignments_f.frequency%TYPE
1404: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
1405: ,p_effective_date in date
1406: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 1403: ,p_frequency in per_all_assignments_f.frequency%TYPE

1399: -- Internal Table Handler Use Only
1400: --
1401: procedure chk_frequency_normal_hours
1402: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1403: ,p_frequency in per_all_assignments_f.frequency%TYPE
1404: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
1405: ,p_effective_date in date
1406: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1407: );

Line 1404: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE

1400: --
1401: procedure chk_frequency_normal_hours
1402: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1403: ,p_frequency in per_all_assignments_f.frequency%TYPE
1404: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
1405: ,p_effective_date in date
1406: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1407: );
1408: -- --------------------------------------------------------------------------+

Line 1406: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1402: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1403: ,p_frequency in per_all_assignments_f.frequency%TYPE
1404: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
1405: ,p_effective_date in date
1406: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1407: );
1408: -- --------------------------------------------------------------------------+
1409: -- |-----------------------< chk_organization_id >---------------------------|
1410: -- --------------------------------------------------------------------------+

Line 1480: (p_primary_flag in per_all_assignments_f.primary_flag%TYPE

1476: -- Access Status:
1477: -- Internal Table Handler Use Only.
1478: --
1479: procedure chk_organization_id
1480: (p_primary_flag in per_all_assignments_f.primary_flag%TYPE
1481: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1482: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1483: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1484: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

Line 1481: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1477: -- Internal Table Handler Use Only.
1478: --
1479: procedure chk_organization_id
1480: (p_primary_flag in per_all_assignments_f.primary_flag%TYPE
1481: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1482: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1483: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1484: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1485: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

Line 1482: ,p_organization_id in per_all_assignments_f.organization_id%TYPE

1478: --
1479: procedure chk_organization_id
1480: (p_primary_flag in per_all_assignments_f.primary_flag%TYPE
1481: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1482: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1483: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1484: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1485: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1486: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

Line 1483: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

1479: procedure chk_organization_id
1480: (p_primary_flag in per_all_assignments_f.primary_flag%TYPE
1481: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1482: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1483: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1484: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1485: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1486: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1487: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

Line 1484: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

1480: (p_primary_flag in per_all_assignments_f.primary_flag%TYPE
1481: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1482: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1483: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1484: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1485: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1486: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1487: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1488: ,p_effective_date in date

Line 1485: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

1481: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1482: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1483: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1484: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1485: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1486: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1487: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1488: ,p_effective_date in date
1489: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 1486: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

1482: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1483: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1484: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1485: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1486: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1487: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1488: ,p_effective_date in date
1489: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1490: ,p_manager_flag in per_all_assignments_f.manager_flag%TYPE

Line 1487: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

1483: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1484: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1485: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1486: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1487: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1488: ,p_effective_date in date
1489: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1490: ,p_manager_flag in per_all_assignments_f.manager_flag%TYPE
1491: ,p_org_now_no_manager_warning in out nocopy boolean

Line 1489: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1485: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1486: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1487: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1488: ,p_effective_date in date
1489: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1490: ,p_manager_flag in per_all_assignments_f.manager_flag%TYPE
1491: ,p_org_now_no_manager_warning in out nocopy boolean
1492: ,p_other_manager_warning in out nocopy boolean
1493: );

Line 1490: ,p_manager_flag in per_all_assignments_f.manager_flag%TYPE

1486: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1487: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1488: ,p_effective_date in date
1489: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1490: ,p_manager_flag in per_all_assignments_f.manager_flag%TYPE
1491: ,p_org_now_no_manager_warning in out nocopy boolean
1492: ,p_other_manager_warning in out nocopy boolean
1493: );
1494: --

Line 1527: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1523: -- Internal Table Handler Use Only
1524: --
1525: --
1526: procedure chk_bargaining_unit_code
1527: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1528: ,p_bargaining_unit_code in per_all_assignments_f.bargaining_unit_code%TYPE
1529: ,p_effective_date in date
1530: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1531: ,p_validation_start_date in date

Line 1528: ,p_bargaining_unit_code in per_all_assignments_f.bargaining_unit_code%TYPE

1524: --
1525: --
1526: procedure chk_bargaining_unit_code
1527: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1528: ,p_bargaining_unit_code in per_all_assignments_f.bargaining_unit_code%TYPE
1529: ,p_effective_date in date
1530: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1531: ,p_validation_start_date in date
1532: ,p_validation_end_date in date

Line 1530: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1526: procedure chk_bargaining_unit_code
1527: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1528: ,p_bargaining_unit_code in per_all_assignments_f.bargaining_unit_code%TYPE
1529: ,p_effective_date in date
1530: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1531: ,p_validation_start_date in date
1532: ,p_validation_end_date in date
1533: );
1534: --

Line 1570: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1566: -- Internal Table Handler Use Only
1567: --
1568: --
1569: procedure chk_hourly_salaried_code
1570: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1571: ,p_hourly_salaried_code in per_all_assignments_f.hourly_salaried_code%TYPE
1572: ,p_effective_date in date
1573: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1574: ,p_validation_start_date in date

Line 1571: ,p_hourly_salaried_code in per_all_assignments_f.hourly_salaried_code%TYPE

1567: --
1568: --
1569: procedure chk_hourly_salaried_code
1570: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1571: ,p_hourly_salaried_code in per_all_assignments_f.hourly_salaried_code%TYPE
1572: ,p_effective_date in date
1573: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1574: ,p_validation_start_date in date
1575: ,p_validation_end_date in date

Line 1573: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1569: procedure chk_hourly_salaried_code
1570: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1571: ,p_hourly_salaried_code in per_all_assignments_f.hourly_salaried_code%TYPE
1572: ,p_effective_date in date
1573: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1574: ,p_validation_start_date in date
1575: ,p_validation_end_date in date
1576: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
1577: ,p_hourly_salaried_warning in out nocopy boolean

Line 1576: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE

1572: ,p_effective_date in date
1573: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1574: ,p_validation_start_date in date
1575: ,p_validation_end_date in date
1576: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
1577: ,p_hourly_salaried_warning in out nocopy boolean
1578: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1579: );
1580: --

Line 1578: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

1574: ,p_validation_start_date in date
1575: ,p_validation_end_date in date
1576: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
1577: ,p_hourly_salaried_warning in out nocopy boolean
1578: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1579: );
1580: --
1581: -- --------------------------------------------------------------------------+
1582: -- |---------------------< return_legislation_code >-------------------------|

Line 1638: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1634: -- Access Status:
1635: -- Internal Table Handler Use Only
1636: --
1637: procedure chk_frozen_single_pos
1638: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1639: ,p_position_id in per_all_assignments_f.position_id%TYPE
1640: ,p_effective_date in date
1641: ,p_assignment_type in varchar2 default 'E'
1642: );

Line 1639: ,p_position_id in per_all_assignments_f.position_id%TYPE

1635: -- Internal Table Handler Use Only
1636: --
1637: procedure chk_frozen_single_pos
1638: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1639: ,p_position_id in per_all_assignments_f.position_id%TYPE
1640: ,p_effective_date in date
1641: ,p_assignment_type in varchar2 default 'E'
1642: );
1643: --

Line 1649: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1645: -- Start changes for bug 10220040
1646: -- Overloaded procedure to perform validation on effective_end_date
1647: --
1648: procedure chk_frozen_single_pos
1649: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1650: ,p_position_id in per_all_assignments_f.position_id%TYPE
1651: ,p_effective_date in date
1652: ,p_effective_end_date in date
1653: ,p_assignment_type in varchar2 default 'E'

Line 1650: ,p_position_id in per_all_assignments_f.position_id%TYPE

1646: -- Overloaded procedure to perform validation on effective_end_date
1647: --
1648: procedure chk_frozen_single_pos
1649: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1650: ,p_position_id in per_all_assignments_f.position_id%TYPE
1651: ,p_effective_date in date
1652: ,p_effective_end_date in date
1653: ,p_assignment_type in varchar2 default 'E'
1654: );

Line 1687: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1683: -- Access Status:
1684: -- Internal Table Handler Use Only
1685: --
1686: procedure chk_single_position
1687: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1688: ,p_position_id in per_all_assignments_f.position_id%TYPE
1689: ,p_effective_date in date
1690: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1691: ,p_assignment_type in per_all_assignments_f.assignment_type%type default 'E'

Line 1688: ,p_position_id in per_all_assignments_f.position_id%TYPE

1684: -- Internal Table Handler Use Only
1685: --
1686: procedure chk_single_position
1687: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1688: ,p_position_id in per_all_assignments_f.position_id%TYPE
1689: ,p_effective_date in date
1690: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1691: ,p_assignment_type in per_all_assignments_f.assignment_type%type default 'E'
1692: );

Line 1690: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1686: procedure chk_single_position
1687: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1688: ,p_position_id in per_all_assignments_f.position_id%TYPE
1689: ,p_effective_date in date
1690: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1691: ,p_assignment_type in per_all_assignments_f.assignment_type%type default 'E'
1692: );
1693: --
1694:

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

1687: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1688: ,p_position_id in per_all_assignments_f.position_id%TYPE
1689: ,p_effective_date in date
1690: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1691: ,p_assignment_type in per_all_assignments_f.assignment_type%type default 'E'
1692: );
1693: --
1694:
1695: -- Start changes for bug 10220040

Line 1699: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1695: -- Start changes for bug 10220040
1696: -- Overloaded procedure to perform validation on effective_end_date
1697: --
1698: procedure chk_single_position
1699: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1700: ,p_position_id in per_all_assignments_f.position_id%TYPE
1701: ,p_effective_date in date
1702: ,p_effective_end_date in date
1703: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 1700: ,p_position_id in per_all_assignments_f.position_id%TYPE

1696: -- Overloaded procedure to perform validation on effective_end_date
1697: --
1698: procedure chk_single_position
1699: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1700: ,p_position_id in per_all_assignments_f.position_id%TYPE
1701: ,p_effective_date in date
1702: ,p_effective_end_date in date
1703: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1704: ,p_assignment_type in per_all_assignments_f.assignment_type%type default 'E'

Line 1703: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1699: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1700: ,p_position_id in per_all_assignments_f.position_id%TYPE
1701: ,p_effective_date in date
1702: ,p_effective_end_date in date
1703: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1704: ,p_assignment_type in per_all_assignments_f.assignment_type%type default 'E'
1705: );
1706: --
1707: -- End changes for bug 10220040

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

1700: ,p_position_id in per_all_assignments_f.position_id%TYPE
1701: ,p_effective_date in date
1702: ,p_effective_end_date in date
1703: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1704: ,p_assignment_type in per_all_assignments_f.assignment_type%type default 'E'
1705: );
1706: --
1707: -- End changes for bug 10220040
1708: