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.

[Home] [Help]

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 7639: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

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

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

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

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

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

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

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

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

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

Line 7703: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

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

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

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

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

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

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

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

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

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

Line 7767: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

7763: --
7764: PROCEDURE terminate_apl_asg
7765: (p_validate IN BOOLEAN DEFAULT FALSE
7766: ,p_effective_date IN DATE
7767: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7768: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE DEFAULT NULL
7769: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
7770: ,p_status_change_comments IN irc_assignment_statuses.status_change_comments%TYPE DEFAULT NULL
7771: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE

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

7764: PROCEDURE terminate_apl_asg
7765: (p_validate IN BOOLEAN DEFAULT FALSE
7766: ,p_effective_date IN DATE
7767: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7768: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE DEFAULT NULL
7769: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
7770: ,p_status_change_comments IN irc_assignment_statuses.status_change_comments%TYPE DEFAULT NULL
7771: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7772: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

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

7765: (p_validate IN BOOLEAN DEFAULT FALSE
7766: ,p_effective_date IN DATE
7767: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7768: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE DEFAULT NULL
7769: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
7770: ,p_status_change_comments IN irc_assignment_statuses.status_change_comments%TYPE DEFAULT NULL
7771: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7772: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7773: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

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

7767: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7768: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE DEFAULT NULL
7769: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
7770: ,p_status_change_comments IN irc_assignment_statuses.status_change_comments%TYPE DEFAULT NULL
7771: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7772: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7773: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7774: );
7775: --

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

7768: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE DEFAULT NULL
7769: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
7770: ,p_status_change_comments IN irc_assignment_statuses.status_change_comments%TYPE DEFAULT NULL
7771: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7772: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7773: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7774: );
7775: --
7776: -- ----------------------------------------------------------------------------

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

7769: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
7770: ,p_status_change_comments IN irc_assignment_statuses.status_change_comments%TYPE DEFAULT NULL
7771: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7772: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7773: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7774: );
7775: --
7776: -- ----------------------------------------------------------------------------
7777: -- |---------------------------< set_new_primary_asg >------------------------|

Line 7832: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

7828: PROCEDURE set_new_primary_asg
7829: (p_validate IN BOOLEAN DEFAULT FALSE
7830: ,p_effective_date IN DATE
7831: ,p_person_id IN per_all_people_f.person_id%TYPE
7832: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7833: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7834: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7835: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7836: );

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

7829: (p_validate IN BOOLEAN DEFAULT FALSE
7830: ,p_effective_date IN DATE
7831: ,p_person_id IN per_all_people_f.person_id%TYPE
7832: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7833: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7834: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7835: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7836: );
7837: --

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

7830: ,p_effective_date IN DATE
7831: ,p_person_id IN per_all_people_f.person_id%TYPE
7832: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7833: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7834: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7835: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7836: );
7837: --
7838: -- ----------------------------------------------------------------------------

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

7831: ,p_person_id IN per_all_people_f.person_id%TYPE
7832: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7833: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7834: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7835: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7836: );
7837: --
7838: -- ----------------------------------------------------------------------------
7839: -- |-------------------------< set_new_primary_cwk_asg >----------------------|

Line 7895: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

7891: PROCEDURE set_new_primary_cwk_asg
7892: (p_validate IN BOOLEAN DEFAULT FALSE
7893: ,p_effective_date IN DATE
7894: ,p_person_id IN per_all_people_f.person_id%TYPE
7895: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7896: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7897: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7898: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7899: );

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

7892: (p_validate IN BOOLEAN DEFAULT FALSE
7893: ,p_effective_date IN DATE
7894: ,p_person_id IN per_all_people_f.person_id%TYPE
7895: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7896: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7897: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7898: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7899: );
7900: --

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

7893: ,p_effective_date IN DATE
7894: ,p_person_id IN per_all_people_f.person_id%TYPE
7895: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7896: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7897: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7898: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7899: );
7900: --
7901: -- ----------------------------------------------------------------------------

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

7894: ,p_person_id IN per_all_people_f.person_id%TYPE
7895: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7896: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7897: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7898: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7899: );
7900: --
7901: -- ----------------------------------------------------------------------------
7902: -- |----------------------------< interview1_apl_asg >------------------------|

Line 7968: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

7964: PROCEDURE interview1_apl_asg
7965: (p_validate IN BOOLEAN DEFAULT FALSE
7966: ,p_effective_date IN DATE
7967: ,p_datetrack_update_mode IN VARCHAR2
7968: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7969: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7970: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE DEFAULT hr_api.g_number
7971: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE DEFAULT hr_api.g_varchar2
7972: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

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

7965: (p_validate IN BOOLEAN DEFAULT FALSE
7966: ,p_effective_date IN DATE
7967: ,p_datetrack_update_mode IN VARCHAR2
7968: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7969: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7970: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE DEFAULT hr_api.g_number
7971: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE DEFAULT hr_api.g_varchar2
7972: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7973: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

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

7967: ,p_datetrack_update_mode IN VARCHAR2
7968: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7969: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7970: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE DEFAULT hr_api.g_number
7971: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE DEFAULT hr_api.g_varchar2
7972: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7973: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7974: );
7975: --

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

7968: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7969: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7970: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE DEFAULT hr_api.g_number
7971: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE DEFAULT hr_api.g_varchar2
7972: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7973: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7974: );
7975: --
7976: -- ----------------------------------------------------------------------------

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

7969: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
7970: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE DEFAULT hr_api.g_number
7971: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE DEFAULT hr_api.g_varchar2
7972: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
7973: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
7974: );
7975: --
7976: -- ----------------------------------------------------------------------------
7977: -- |----------------------------< interview2_apl_asg >------------------------|

Line 8043: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

8039: PROCEDURE interview2_apl_asg
8040: (p_validate IN BOOLEAN DEFAULT FALSE
8041: ,p_effective_date IN DATE
8042: ,p_datetrack_update_mode IN VARCHAR2
8043: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
8044: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
8045: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE DEFAULT hr_api.g_number
8046: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE DEFAULT hr_api.g_varchar2
8047: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

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

8040: (p_validate IN BOOLEAN DEFAULT FALSE
8041: ,p_effective_date IN DATE
8042: ,p_datetrack_update_mode IN VARCHAR2
8043: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
8044: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
8045: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE DEFAULT hr_api.g_number
8046: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE DEFAULT hr_api.g_varchar2
8047: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
8048: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

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

8042: ,p_datetrack_update_mode IN VARCHAR2
8043: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
8044: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
8045: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE DEFAULT hr_api.g_number
8046: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE DEFAULT hr_api.g_varchar2
8047: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
8048: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
8049: );
8050: --

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

8043: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
8044: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
8045: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE DEFAULT hr_api.g_number
8046: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE DEFAULT hr_api.g_varchar2
8047: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
8048: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
8049: );
8050: --
8051: --

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

8044: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
8045: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE DEFAULT hr_api.g_number
8046: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE DEFAULT hr_api.g_varchar2
8047: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
8048: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
8049: );
8050: --
8051: --
8052:

Line 8169: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

8165: PROCEDURE delete_assignment
8166: (p_validate IN boolean default false
8167: ,p_effective_date IN DATE
8168: ,p_datetrack_mode IN VARCHAR2
8169: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
8170: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
8171: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
8172: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
8173: ,p_loc_change_tax_issues OUT NOCOPY boolean

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

8166: (p_validate IN boolean default false
8167: ,p_effective_date IN DATE
8168: ,p_datetrack_mode IN VARCHAR2
8169: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
8170: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
8171: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
8172: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
8173: ,p_loc_change_tax_issues OUT NOCOPY boolean
8174: ,p_delete_asg_budgets OUT NOCOPY boolean

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

8167: ,p_effective_date IN DATE
8168: ,p_datetrack_mode IN VARCHAR2
8169: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
8170: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
8171: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
8172: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
8173: ,p_loc_change_tax_issues OUT NOCOPY boolean
8174: ,p_delete_asg_budgets OUT NOCOPY boolean
8175: ,p_org_now_no_manager_warning OUT NOCOPY boolean

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

8168: ,p_datetrack_mode IN VARCHAR2
8169: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
8170: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
8171: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
8172: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
8173: ,p_loc_change_tax_issues OUT NOCOPY boolean
8174: ,p_delete_asg_budgets OUT NOCOPY boolean
8175: ,p_org_now_no_manager_warning OUT NOCOPY boolean
8176: ,p_element_salary_warning OUT NOCOPY boolean