APPS.PA_SCHEDULE_PUB dependencies on JTF_CALENDARS_VL

Line 2753: FROM jtf_calendars_vl

2749: IF (p_calendar_id IS NULL ) THEN
2750: BEGIN
2751: SELECT calendar_id
2752: INTO l_calendar_id
2753: FROM jtf_calendars_vl
2754: WHERE calendar_name = p_calendar_name;
2755:
2756:
2757: x_msg_count := FND_MSG_PUB.Count_Msg;

Line 3585: jtf_calendars_vl cal1

3581: cal1.calendar_name
3582: INTO x_calendar_id ,
3583: x_calendar_name
3584: FROM hr_organization_information hr1,
3585: jtf_calendars_vl cal1
3586: --WHERE cal1.calendar_id = TO_NUMBER(hr1.org_information2) BUG 3530529
3587: -- WHERE TO_CHAR(cal1.calendar_id) = hr1.org_information2
3588: WHERE TO_CHAR(cal1.calendar_id) = hr1.org_information1
3589: AND hr1.organization_id = l_t_carrying_out_org_id

Line 3622: FROM jtf_calendars_vl

3618: BEGIN
3619: SELECT
3620: calendar_name
3621: INTO x_calendar_name
3622: FROM jtf_calendars_vl
3623: WHERE calendar_id = TO_NUMBER(l_temp_calendar_id);
3624:
3625: x_calendar_id := TO_NUMBER(l_temp_calendar_id);
3626: EXCEPTION

Line 3632: PA_SCHEDULE_UTILS.log_message(1,'ERROR while excuting select on jtf_calendars_vl.... '||sqlerrm);

3628: x_msg_data := 'Not a valid calendar assigned to profile option ';
3629: PA_SCHEDULE_UTILS.log_message(1,'Not a valid calendar assigned to profile option ');
3630: RAISE l_invalid_default_calendar;
3631: WHEN OTHERS THEN
3632: PA_SCHEDULE_UTILS.log_message(1,'ERROR while excuting select on jtf_calendars_vl.... '||sqlerrm);
3633: RAISE;
3634: END;
3635:
3636: END IF;

Line 3736: FROM JTF_CALENDARS_VL

3732:
3733: -- This cursor will select only those records which are matching in the start and end calendar name
3734: -- or coming between them
3735: CURSOR C1 IS SELECT calendar_id,calendar_name
3736: FROM JTF_CALENDARS_VL
3737: WHERE calendar_name BETWEEN l_t_start_calendar_name AND l_t_end_calendar_name;
3738: l_msg_index_out NUMBER;
3739: l_exception EXCEPTION;
3740: l_debug_mode VARCHAR2(20) := 'N';

Line 3763: FROM JTF_CALENDARS_VL;

3759: IF (p_start_calendar_name IS NULL ) THEN
3760:
3761: SELECT MIN(calendar_name)
3762: INTO l_t_start_calendar_name
3763: FROM JTF_CALENDARS_VL;
3764: ELSE
3765: l_t_start_calendar_name := p_start_calendar_name;
3766: END IF;
3767:

Line 3773: FROM JTF_CALENDARS_VL;

3769: IF (p_end_calendar_name IS NULL ) THEN
3770:
3771: SELECT MAX(calendar_name)
3772: INTO l_t_end_calendar_name
3773: FROM JTF_CALENDARS_VL;
3774: ELSE
3775: l_t_end_calendar_name := p_end_calendar_name;
3776: END IF;
3777: