APPS.JTF_CALENDAR_PUB dependencies on JTF_CALENDARS_VL

Line 412: l_calendar_name jtf_calendars_vl.calendar_name%TYPE; --bug # 2493461 VARCHAR2(240)

408: l_unit_of_time_value NUMBER;
409: l_begin_time VARCHAR2(5);
410: l_end_time VARCHAR2(5);
411: l_calendar_id NUMBER;
412: l_calendar_name jtf_calendars_vl.calendar_name%TYPE; --bug # 2493461 VARCHAR2(240)
413: l_calendar_start_date DATE;
414: l_shifts_total_duration NUMBER;
415: l_left_days NUMBER;
416: l_availability VARCHAR2(40);

Line 922: l_calendar_name jtf_calendars_vl.calendar_name%TYPE; -- bug # 2493461 varchar2(100)

918: l_left_days number;
919: l_calendar_id number;
920: l_shift_id number;
921:
922: l_calendar_name jtf_calendars_vl.calendar_name%TYPE; -- bug # 2493461 varchar2(100)
923: l_calendar_start_date date;
924: l_exp_flg varchar2(1) := 'N';
925: l_start_date_time date;
926: l_st_time date;

Line 998: jtf_calendars_vl b

994: BEGIN --(1)
995: select a.calendar_id,b.calendar_name,b.start_date_active,a.start_date_time
996: into l_calendar_id,l_calendar_name,l_calendar_start_date,l_start_date_time
997: from jtf_cal_resource_assign a,
998: jtf_calendars_vl b
999: where a.resource_id = p_resource_id
1000: and a.resource_type_code = p_resource_type
1001: and a.calendar_id = b.calendar_id
1002: and a.primary_calendar_flag = 'Y'

Line 1433: l_calendar_name jtf_calendars_vl.calendar_name%TYPE; -- bug # 2493461 varchar2(100)

1429: l_left_days number;
1430: l_calendar_id number;
1431: l_shift_id number;
1432:
1433: l_calendar_name jtf_calendars_vl.calendar_name%TYPE; -- bug # 2493461 varchar2(100)
1434: l_calendar_start_date date;
1435: l_exp_flg varchar2(1) := 'N';
1436: l_start_date_time date;
1437: l_st_time date;

Line 1510: jtf_calendars_vl b

1506: begin --(1)
1507: select a.calendar_id,b.calendar_name,b.start_date_active,a.start_date_time
1508: into l_calendar_id,l_calendar_name,l_calendar_start_date,l_start_date_time
1509: from jtf_cal_resource_assign a,
1510: jtf_calendars_vl b
1511: where a.resource_id = p_resource_id
1512: and a.resource_type_code = p_resource_type
1513: and a.calendar_id = b.calendar_id
1514: and a.primary_calendar_flag = 'Y'

Line 2097: l_calendar_name jtf_calendars_vl.calendar_name%TYPE; -- bug # 2493461 VARCHAR2(240)

2093: j INTEGER := 0;
2094: l_shift_id NUMBER;
2095: l_unit_of_time_value NUMBER;
2096: l_calendar_id NUMBER;
2097: l_calendar_name jtf_calendars_vl.calendar_name%TYPE; -- bug # 2493461 VARCHAR2(240)
2098: l_calendar_start_date DATE;
2099: l_shifts_total_duration NUMBER;
2100: l_left_days NUMBER;
2101: l_shift_date DATE;

Line 2166: jtf_calendars_vl b

2162: begin --(1)
2163: select a.calendar_id,b.calendar_name,b.start_date_active
2164: into l_calendar_id,l_calendar_name,l_calendar_start_date
2165: from jtf_cal_resource_assign a,
2166: jtf_calendars_vl b
2167: where a.resource_id = p_resource_id
2168: and a.resource_type_code = p_resource_type
2169: and a.calendar_id = b.calendar_id
2170: and a.primary_calendar_flag = 'Y'