APPS.PA_SCHEDULE_PUB dependencies on JTF_CALENDARS_VL

Line 2281: FROM jtf_calendars_vl

2277: IF (p_calendar_id IS NULL ) THEN
2278: BEGIN
2279: SELECT calendar_id
2280: INTO l_calendar_id
2281: FROM jtf_calendars_vl
2282: WHERE calendar_name = p_calendar_name;
2283:
2284:
2285: x_msg_count := FND_MSG_PUB.Count_Msg;

Line 3105: jtf_calendars_vl cal1

3101: cal1.calendar_name
3102: INTO x_calendar_id ,
3103: x_calendar_name
3104: FROM hr_organization_information hr1,
3105: jtf_calendars_vl cal1
3106: --WHERE cal1.calendar_id = TO_NUMBER(hr1.org_information2) BUG 3530529
3107: -- WHERE TO_CHAR(cal1.calendar_id) = hr1.org_information2
3108: WHERE TO_CHAR(cal1.calendar_id) = hr1.org_information1
3109: AND hr1.organization_id = l_t_carrying_out_org_id

Line 3142: FROM jtf_calendars_vl

3138: BEGIN
3139: SELECT
3140: calendar_name
3141: INTO x_calendar_name
3142: FROM jtf_calendars_vl
3143: WHERE calendar_id = TO_NUMBER(l_temp_calendar_id);
3144:
3145: x_calendar_id := TO_NUMBER(l_temp_calendar_id);
3146: EXCEPTION

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

3148: x_msg_data := 'Not a valid calendar assigned to profile option ';
3149: PA_SCHEDULE_UTILS.log_message(1,'Not a valid calendar assigned to profile option ');
3150: RAISE l_invalid_default_calendar;
3151: WHEN OTHERS THEN
3152: PA_SCHEDULE_UTILS.log_message(1,'ERROR while excuting select on jtf_calendars_vl.... '||sqlerrm);
3153: RAISE;
3154: END;
3155:
3156: END IF;

Line 3256: FROM JTF_CALENDARS_VL

3252:
3253: -- This cursor will select only those records which are matching in the start and end calendar name
3254: -- or coming between them
3255: CURSOR C1 IS SELECT calendar_id,calendar_name
3256: FROM JTF_CALENDARS_VL
3257: WHERE calendar_name BETWEEN l_t_start_calendar_name AND l_t_end_calendar_name;
3258: l_msg_index_out NUMBER;
3259: l_exception EXCEPTION;
3260: l_debug_mode VARCHAR2(20) := 'N';

Line 3283: FROM JTF_CALENDARS_VL;

3279: IF (p_start_calendar_name IS NULL ) THEN
3280:
3281: SELECT MIN(calendar_name)
3282: INTO l_t_start_calendar_name
3283: FROM JTF_CALENDARS_VL;
3284: ELSE
3285: l_t_start_calendar_name := p_start_calendar_name;
3286: END IF;
3287:

Line 3293: FROM JTF_CALENDARS_VL;

3289: IF (p_end_calendar_name IS NULL ) THEN
3290:
3291: SELECT MAX(calendar_name)
3292: INTO l_t_end_calendar_name
3293: FROM JTF_CALENDARS_VL;
3294: ELSE
3295: l_t_end_calendar_name := p_end_calendar_name;
3296: END IF;
3297: