115: -- 18-AUG-2000 -- Sakthi/William - Created.
116: --
117: --
118: PROCEDURE CHECK_CALENDAR_NAME_OR_ID
119: (p_calendar_id IN jtf_calendars_vl.calendar_id%TYPE
120: ,p_calendar_name IN jtf_calendars_vl.calendar_name%TYPE
121: ,p_check_id_flag IN VARCHAR2
122: ,x_calendar_id OUT NOCOPY jtf_calendars_vl.calendar_id%TYPE --File.Sql.39 bug 4440895
123: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
116: --
117: --
118: PROCEDURE CHECK_CALENDAR_NAME_OR_ID
119: (p_calendar_id IN jtf_calendars_vl.calendar_id%TYPE
120: ,p_calendar_name IN jtf_calendars_vl.calendar_name%TYPE
121: ,p_check_id_flag IN VARCHAR2
122: ,x_calendar_id OUT NOCOPY jtf_calendars_vl.calendar_id%TYPE --File.Sql.39 bug 4440895
123: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
124: ,x_error_msg_code OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
118: PROCEDURE CHECK_CALENDAR_NAME_OR_ID
119: (p_calendar_id IN jtf_calendars_vl.calendar_id%TYPE
120: ,p_calendar_name IN jtf_calendars_vl.calendar_name%TYPE
121: ,p_check_id_flag IN VARCHAR2
122: ,x_calendar_id OUT NOCOPY jtf_calendars_vl.calendar_id%TYPE --File.Sql.39 bug 4440895
123: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
124: ,x_error_msg_code OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
125:
126: -- API name : get_project_manager