APPS.JTF_CALENDAR_PUB dependencies on JTF_CALENDARS_VL

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

450: l_unit_of_time_value NUMBER;
451: l_begin_time VARCHAR2(5);
452: l_end_time VARCHAR2(5);
453: l_calendar_id NUMBER;
454: l_calendar_name jtf_calendars_vl.calendar_name%TYPE; --bug # 2493461 VARCHAR2(240)
455: l_calendar_start_date DATE;
456: l_shifts_total_duration NUMBER;
457: l_left_days NUMBER;
458: l_availability VARCHAR2(40);

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

960: l_left_days number;
961: l_calendar_id number;
962: l_shift_id number;
963:
964: l_calendar_name jtf_calendars_vl.calendar_name%TYPE; -- bug # 2493461 varchar2(100)
965: l_calendar_start_date date;
966: l_exp_flg varchar2(1) := 'N';
967: l_start_date_time date;
968: l_st_time date;

Line 1040: jtf_calendars_vl b

1036: BEGIN --(1)
1037: select a.calendar_id,b.calendar_name,b.start_date_active,a.start_date_time
1038: into l_calendar_id,l_calendar_name,l_calendar_start_date,l_start_date_time
1039: from jtf_cal_resource_assign a,
1040: jtf_calendars_vl b
1041: where a.resource_id = p_resource_id
1042: and a.resource_type_code = p_resource_type
1043: and a.calendar_id = b.calendar_id
1044: and a.primary_calendar_flag = 'Y'

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

1474: l_left_days number;
1475: l_calendar_id number;
1476: l_shift_id number;
1477:
1478: l_calendar_name jtf_calendars_vl.calendar_name%TYPE; -- bug # 2493461 varchar2(100)
1479: l_calendar_start_date date;
1480: l_exp_flg varchar2(1) := 'N';
1481: l_start_date_time date;
1482: l_st_time date;

Line 1555: jtf_calendars_vl b

1551: begin --(1)
1552: select a.calendar_id,b.calendar_name,b.start_date_active,a.start_date_time
1553: into l_calendar_id,l_calendar_name,l_calendar_start_date,l_start_date_time
1554: from jtf_cal_resource_assign a,
1555: jtf_calendars_vl b
1556: where a.resource_id = p_resource_id
1557: and a.resource_type_code = p_resource_type
1558: and a.calendar_id = b.calendar_id
1559: and a.primary_calendar_flag = 'Y'

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

2143: j INTEGER := 0;
2144: l_shift_id NUMBER;
2145: l_unit_of_time_value NUMBER;
2146: l_calendar_id NUMBER;
2147: l_calendar_name jtf_calendars_vl.calendar_name%TYPE; -- bug # 2493461 VARCHAR2(240)
2148: l_calendar_start_date DATE;
2149: l_shifts_total_duration NUMBER;
2150: l_left_days NUMBER;
2151: l_shift_date DATE;

Line 2216: jtf_calendars_vl b

2212: begin --(1)
2213: select a.calendar_id,b.calendar_name,b.start_date_active
2214: into l_calendar_id,l_calendar_name,l_calendar_start_date
2215: from jtf_cal_resource_assign a,
2216: jtf_calendars_vl b
2217: where a.resource_id = p_resource_id
2218: and a.resource_type_code = p_resource_type
2219: and a.calendar_id = b.calendar_id
2220: and a.primary_calendar_flag = 'Y'