DBA Data[Home] [Help]

APPS.PA_CALENDAR_UTILS dependencies on JTF_CALENDARS_VL

Line 67: ( p_calendar_id IN JTF_CALENDARS_VL.calendar_id%TYPE

63: -- p_sch_record_tab - Table of Schedule details Records
64: -- x_sch_record_tab - Table of Schedule details Records
65:
66: PROCEDURE Check_Calendar_Name_Or_Id
67: ( p_calendar_id IN JTF_CALENDARS_VL.calendar_id%TYPE
68: ,p_calendar_name IN JTF_CALENDARS_VL.calendar_name%TYPE
69: ,p_check_id_flag IN VARCHAR2 := 'A'
70: ,x_calendar_id OUT NOCOPY JTF_CALENDARS_VL.calendar_id%TYPE --File.Sql.39 bug 4440895
71: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 68: ,p_calendar_name IN JTF_CALENDARS_VL.calendar_name%TYPE

64: -- x_sch_record_tab - Table of Schedule details Records
65:
66: PROCEDURE Check_Calendar_Name_Or_Id
67: ( p_calendar_id IN JTF_CALENDARS_VL.calendar_id%TYPE
68: ,p_calendar_name IN JTF_CALENDARS_VL.calendar_name%TYPE
69: ,p_check_id_flag IN VARCHAR2 := 'A'
70: ,x_calendar_id OUT NOCOPY JTF_CALENDARS_VL.calendar_id%TYPE --File.Sql.39 bug 4440895
71: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
72: ,x_error_message_code OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895

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

66: PROCEDURE Check_Calendar_Name_Or_Id
67: ( p_calendar_id IN JTF_CALENDARS_VL.calendar_id%TYPE
68: ,p_calendar_name IN JTF_CALENDARS_VL.calendar_name%TYPE
69: ,p_check_id_flag IN VARCHAR2 := 'A'
70: ,x_calendar_id OUT NOCOPY JTF_CALENDARS_VL.calendar_id%TYPE --File.Sql.39 bug 4440895
71: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
72: ,x_error_message_code OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
73:
74: --

Line 76: -- Purpose : This procedure validate the calendar Id or Calendar name against the JTF_CALENDARS_VL table

72: ,x_error_message_code OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
73:
74: --
75: -- Procedure : Check_Name_Or_Id
76: -- Purpose : This procedure validate the calendar Id or Calendar name against the JTF_CALENDARS_VL table
77: --
78: -- Parameters :
79: --
80: