APPS.PA_PROJECTS_MAINT_UTILS dependencies on JTF_CALENDARS_VL

Line 402: (p_calendar_id IN jtf_calendars_vl.calendar_id%TYPE

398: -- 18-AUG-2000 -- Sakthi/William - Created.
399: --
400: --
401: PROCEDURE CHECK_CALENDAR_NAME_OR_ID
402: (p_calendar_id IN jtf_calendars_vl.calendar_id%TYPE
403: ,p_calendar_name IN jtf_calendars_vl.calendar_name%TYPE
404: ,p_check_id_flag IN VARCHAR2
405: ,x_calendar_id OUT NOCOPY jtf_calendars_vl.calendar_id%TYPE --File.Sql.39 bug 4440895
406: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 403: ,p_calendar_name IN jtf_calendars_vl.calendar_name%TYPE

399: --
400: --
401: PROCEDURE CHECK_CALENDAR_NAME_OR_ID
402: (p_calendar_id IN jtf_calendars_vl.calendar_id%TYPE
403: ,p_calendar_name IN jtf_calendars_vl.calendar_name%TYPE
404: ,p_check_id_flag IN VARCHAR2
405: ,x_calendar_id OUT NOCOPY jtf_calendars_vl.calendar_id%TYPE --File.Sql.39 bug 4440895
406: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
407: ,x_error_msg_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 405: ,x_calendar_id OUT NOCOPY jtf_calendars_vl.calendar_id%TYPE --File.Sql.39 bug 4440895

401: PROCEDURE CHECK_CALENDAR_NAME_OR_ID
402: (p_calendar_id IN jtf_calendars_vl.calendar_id%TYPE
403: ,p_calendar_name IN jtf_calendars_vl.calendar_name%TYPE
404: ,p_check_id_flag IN VARCHAR2
405: ,x_calendar_id OUT NOCOPY jtf_calendars_vl.calendar_id%TYPE --File.Sql.39 bug 4440895
406: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
407: ,x_error_msg_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
408: IS
409: BEGIN

Line 422: FROM jtf_calendars_vl

418: END IF;
419: ELSE
420: SELECT calendar_id
421: INTO x_calendar_id
422: FROM jtf_calendars_vl
423: WHERE calendar_name = p_calendar_name;
424: END IF;
425: x_return_status:= FND_API.G_RET_STS_SUCCESS;
426: EXCEPTION