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.HR_ASSIGNMENT_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 42: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

38: --
39: -- {End of Comments}
40: --
41: FUNCTION last_apl_asg
42: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
43: ,p_effective_date IN DATE
44: )
45: RETURN BOOLEAN;
46: --

Line 7636: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

7632: PROCEDURE activate_apl_asg
7633: (p_validate IN BOOLEAN DEFAULT FALSE
7634: ,p_effective_date IN DATE
7635: ,p_datetrack_update_mode IN VARCHAR2
7636: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7637: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7638: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE DEFAULT hr_api.g_number
7639: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE DEFAULT hr_api.g_varchar2
7640: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

Line 7637: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE

7633: (p_validate IN BOOLEAN DEFAULT FALSE
7634: ,p_effective_date IN DATE
7635: ,p_datetrack_update_mode IN VARCHAR2
7636: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7637: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7638: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE DEFAULT hr_api.g_number
7639: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE DEFAULT hr_api.g_varchar2
7640: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7641: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

Line 7639: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE DEFAULT hr_api.g_varchar2

7635: ,p_datetrack_update_mode IN VARCHAR2
7636: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7637: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7638: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE DEFAULT hr_api.g_number
7639: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE DEFAULT hr_api.g_varchar2
7640: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7641: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7642: );
7643: --

Line 7640: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

7636: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7637: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7638: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE DEFAULT hr_api.g_number
7639: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE DEFAULT hr_api.g_varchar2
7640: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7641: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7642: );
7643: --
7644: -- ----------------------------------------------------------------------------

Line 7641: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

7637: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7638: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE DEFAULT hr_api.g_number
7639: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE DEFAULT hr_api.g_varchar2
7640: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7641: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7642: );
7643: --
7644: -- ----------------------------------------------------------------------------
7645: -- |----------------------------< terminate_apl_asg >-------------------------|

Line 7700: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

7696: --
7697: PROCEDURE terminate_apl_asg
7698: (p_validate IN BOOLEAN DEFAULT FALSE
7699: ,p_effective_date IN DATE
7700: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7701: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE DEFAULT NULL
7702: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7703: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7704: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

Line 7701: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE DEFAULT NULL

7697: PROCEDURE terminate_apl_asg
7698: (p_validate IN BOOLEAN DEFAULT FALSE
7699: ,p_effective_date IN DATE
7700: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7701: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE DEFAULT NULL
7702: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7703: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7704: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7705: );

Line 7702: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE

7698: (p_validate IN BOOLEAN DEFAULT FALSE
7699: ,p_effective_date IN DATE
7700: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7701: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE DEFAULT NULL
7702: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7703: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7704: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7705: );
7706: -- -----------------------------------------------------------------------------

Line 7703: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

7699: ,p_effective_date IN DATE
7700: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7701: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE DEFAULT NULL
7702: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7703: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7704: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7705: );
7706: -- -----------------------------------------------------------------------------
7707: -- |-------------------------< terminate_apl_asg >-----------------------------|

Line 7704: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

7700: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7701: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE DEFAULT NULL
7702: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7703: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7704: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7705: );
7706: -- -----------------------------------------------------------------------------
7707: -- |-------------------------< terminate_apl_asg >-----------------------------|
7708: -- -----------------------------------------------------------------------------

Line 7763: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

7759: --
7760: PROCEDURE terminate_apl_asg
7761: (p_validate IN BOOLEAN DEFAULT FALSE
7762: ,p_effective_date IN DATE
7763: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7764: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE DEFAULT NULL
7765: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
7766: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7767: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

Line 7764: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE DEFAULT NULL

7760: PROCEDURE terminate_apl_asg
7761: (p_validate IN BOOLEAN DEFAULT FALSE
7762: ,p_effective_date IN DATE
7763: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7764: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE DEFAULT NULL
7765: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
7766: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7767: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7768: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

Line 7765: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579

7761: (p_validate IN BOOLEAN DEFAULT FALSE
7762: ,p_effective_date IN DATE
7763: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7764: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE DEFAULT NULL
7765: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
7766: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7767: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7768: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7769: );

Line 7766: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE

7762: ,p_effective_date IN DATE
7763: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7764: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE DEFAULT NULL
7765: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
7766: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7767: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7768: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7769: );
7770: --

Line 7767: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

7763: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7764: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE DEFAULT NULL
7765: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
7766: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7767: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7768: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7769: );
7770: --
7771: -- ----------------------------------------------------------------------------

Line 7768: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

7764: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE DEFAULT NULL
7765: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
7766: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7767: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7768: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7769: );
7770: --
7771: -- ----------------------------------------------------------------------------
7772: -- |---------------------------< set_new_primary_asg >------------------------|

Line 7827: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

7823: PROCEDURE set_new_primary_asg
7824: (p_validate IN BOOLEAN DEFAULT FALSE
7825: ,p_effective_date IN DATE
7826: ,p_person_id IN per_all_people_f.person_id%TYPE
7827: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7828: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7829: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7830: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7831: );

Line 7828: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE

7824: (p_validate IN BOOLEAN DEFAULT FALSE
7825: ,p_effective_date IN DATE
7826: ,p_person_id IN per_all_people_f.person_id%TYPE
7827: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7828: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7829: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7830: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7831: );
7832: --

Line 7829: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

7825: ,p_effective_date IN DATE
7826: ,p_person_id IN per_all_people_f.person_id%TYPE
7827: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7828: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7829: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7830: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7831: );
7832: --
7833: -- ----------------------------------------------------------------------------

Line 7830: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

7826: ,p_person_id IN per_all_people_f.person_id%TYPE
7827: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7828: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7829: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7830: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7831: );
7832: --
7833: -- ----------------------------------------------------------------------------
7834: -- |-------------------------< set_new_primary_cwk_asg >----------------------|

Line 7890: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

7886: PROCEDURE set_new_primary_cwk_asg
7887: (p_validate IN BOOLEAN DEFAULT FALSE
7888: ,p_effective_date IN DATE
7889: ,p_person_id IN per_all_people_f.person_id%TYPE
7890: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7891: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7892: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7893: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7894: );

Line 7891: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE

7887: (p_validate IN BOOLEAN DEFAULT FALSE
7888: ,p_effective_date IN DATE
7889: ,p_person_id IN per_all_people_f.person_id%TYPE
7890: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7891: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7892: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7893: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7894: );
7895: --

Line 7892: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

7888: ,p_effective_date IN DATE
7889: ,p_person_id IN per_all_people_f.person_id%TYPE
7890: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7891: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7892: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7893: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7894: );
7895: --
7896: -- ----------------------------------------------------------------------------

Line 7893: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

7889: ,p_person_id IN per_all_people_f.person_id%TYPE
7890: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7891: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7892: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7893: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7894: );
7895: --
7896: -- ----------------------------------------------------------------------------
7897: -- |----------------------------< interview1_apl_asg >------------------------|

Line 7963: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

7959: PROCEDURE interview1_apl_asg
7960: (p_validate IN BOOLEAN DEFAULT FALSE
7961: ,p_effective_date IN DATE
7962: ,p_datetrack_update_mode IN VARCHAR2
7963: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7964: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7965: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE DEFAULT hr_api.g_number
7966: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE DEFAULT hr_api.g_varchar2
7967: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

Line 7964: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE

7960: (p_validate IN BOOLEAN DEFAULT FALSE
7961: ,p_effective_date IN DATE
7962: ,p_datetrack_update_mode IN VARCHAR2
7963: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7964: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7965: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE DEFAULT hr_api.g_number
7966: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE DEFAULT hr_api.g_varchar2
7967: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7968: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

Line 7966: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE DEFAULT hr_api.g_varchar2

7962: ,p_datetrack_update_mode IN VARCHAR2
7963: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7964: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7965: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE DEFAULT hr_api.g_number
7966: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE DEFAULT hr_api.g_varchar2
7967: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7968: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7969: );
7970: --

Line 7967: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

7963: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7964: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7965: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE DEFAULT hr_api.g_number
7966: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE DEFAULT hr_api.g_varchar2
7967: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7968: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7969: );
7970: --
7971: -- ----------------------------------------------------------------------------

Line 7968: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

7964: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7965: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE DEFAULT hr_api.g_number
7966: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE DEFAULT hr_api.g_varchar2
7967: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7968: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7969: );
7970: --
7971: -- ----------------------------------------------------------------------------
7972: -- |----------------------------< interview2_apl_asg >------------------------|

Line 8038: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

8034: PROCEDURE interview2_apl_asg
8035: (p_validate IN BOOLEAN DEFAULT FALSE
8036: ,p_effective_date IN DATE
8037: ,p_datetrack_update_mode IN VARCHAR2
8038: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
8039: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
8040: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE DEFAULT hr_api.g_number
8041: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE DEFAULT hr_api.g_varchar2
8042: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

Line 8039: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE

8035: (p_validate IN BOOLEAN DEFAULT FALSE
8036: ,p_effective_date IN DATE
8037: ,p_datetrack_update_mode IN VARCHAR2
8038: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
8039: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
8040: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE DEFAULT hr_api.g_number
8041: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE DEFAULT hr_api.g_varchar2
8042: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
8043: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

Line 8041: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE DEFAULT hr_api.g_varchar2

8037: ,p_datetrack_update_mode IN VARCHAR2
8038: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
8039: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
8040: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE DEFAULT hr_api.g_number
8041: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE DEFAULT hr_api.g_varchar2
8042: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
8043: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
8044: );
8045: --

Line 8042: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

8038: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
8039: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
8040: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE DEFAULT hr_api.g_number
8041: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE DEFAULT hr_api.g_varchar2
8042: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
8043: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
8044: );
8045: --
8046: --

Line 8043: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

8039: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
8040: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE DEFAULT hr_api.g_number
8041: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE DEFAULT hr_api.g_varchar2
8042: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
8043: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
8044: );
8045: --
8046: --
8047:

Line 8164: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

8160: PROCEDURE delete_assignment
8161: (p_validate IN boolean default false
8162: ,p_effective_date IN DATE
8163: ,p_datetrack_mode IN VARCHAR2
8164: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
8165: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
8166: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
8167: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
8168: ,p_loc_change_tax_issues OUT NOCOPY boolean

Line 8165: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE

8161: (p_validate IN boolean default false
8162: ,p_effective_date IN DATE
8163: ,p_datetrack_mode IN VARCHAR2
8164: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
8165: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
8166: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
8167: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
8168: ,p_loc_change_tax_issues OUT NOCOPY boolean
8169: ,p_delete_asg_budgets OUT NOCOPY boolean

Line 8166: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

8162: ,p_effective_date IN DATE
8163: ,p_datetrack_mode IN VARCHAR2
8164: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
8165: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
8166: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
8167: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
8168: ,p_loc_change_tax_issues OUT NOCOPY boolean
8169: ,p_delete_asg_budgets OUT NOCOPY boolean
8170: ,p_org_now_no_manager_warning OUT NOCOPY boolean

Line 8167: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

8163: ,p_datetrack_mode IN VARCHAR2
8164: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
8165: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
8166: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
8167: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
8168: ,p_loc_change_tax_issues OUT NOCOPY boolean
8169: ,p_delete_asg_budgets OUT NOCOPY boolean
8170: ,p_org_now_no_manager_warning OUT NOCOPY boolean
8171: ,p_element_salary_warning OUT NOCOPY boolean