APPS.PA_CALENDAR_UTILS dependencies on JTF_CALENDARS_VL

Line 580: ( p_calendar_id IN JTF_CALENDARS_VL.calendar_id%TYPE

576: -- Out parameters
577: -- X_Calendar_Id NUMBER YES It stores the validated calenda id
578: --
579: PROCEDURE Check_Calendar_Name_Or_Id
580: ( p_calendar_id IN JTF_CALENDARS_VL.calendar_id%TYPE
581: ,p_calendar_name IN JTF_CALENDARS_VL.calendar_name%TYPE
582: ,p_check_id_flag IN VARCHAR2 := 'A'
583: ,x_calendar_id OUT NOCOPY JTF_CALENDARS_VL.calendar_id%TYPE --File.Sql.39 bug 4440895
584: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 581: ,p_calendar_name IN JTF_CALENDARS_VL.calendar_name%TYPE

577: -- X_Calendar_Id NUMBER YES It stores the validated calenda id
578: --
579: PROCEDURE Check_Calendar_Name_Or_Id
580: ( p_calendar_id IN JTF_CALENDARS_VL.calendar_id%TYPE
581: ,p_calendar_name IN JTF_CALENDARS_VL.calendar_name%TYPE
582: ,p_check_id_flag IN VARCHAR2 := 'A'
583: ,x_calendar_id OUT NOCOPY JTF_CALENDARS_VL.calendar_id%TYPE --File.Sql.39 bug 4440895
584: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
585: ,x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895

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

579: PROCEDURE Check_Calendar_Name_Or_Id
580: ( p_calendar_id IN JTF_CALENDARS_VL.calendar_id%TYPE
581: ,p_calendar_name IN JTF_CALENDARS_VL.calendar_name%TYPE
582: ,p_check_id_flag IN VARCHAR2 := 'A'
583: ,x_calendar_id OUT NOCOPY JTF_CALENDARS_VL.calendar_id%TYPE --File.Sql.39 bug 4440895
584: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
585: ,x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
586:
587: l_current_id NUMBER := NULL;

Line 593: FROM jtf_calendars_vl

589: l_id_found_flag VARCHAR(1) := 'N';
590:
591: CURSOR c_ids IS
592: SELECT calendar_id
593: FROM jtf_calendars_vl
594: WHERE calendar_name = p_calendar_name;
595: BEGIN
596:
597: /* Bug 2887390 : Added the following condition */

Line 610: FROM jtf_calendars_b -- 4370086: FROM jtf_calendars_vl

606: IF (p_check_id_flag = 'Y') THEN
607: -- Validate ID
608: SELECT calendar_id
609: INTO x_calendar_id
610: FROM jtf_calendars_b -- 4370086: FROM jtf_calendars_vl
611: WHERE calendar_id = p_calendar_id;
612: ELSIF (p_check_id_flag = 'N') THEN
613: -- No ID validation necessary
614: x_calendar_id := p_calendar_id;

Line 650: FROM jtf_calendars_vl

646: ELSE -- Find ID since it was not passed.
647: IF (p_calendar_name IS NOT NULL) THEN
648: SELECT calendar_id
649: INTO x_calendar_id
650: FROM jtf_calendars_vl
651: WHERE calendar_name = p_calendar_name;
652: ELSE
653: x_calendar_id := NULL;
654: END IF;