APPS.JTF_CALENDAR_PUB dependencies on JTF_CAL_SHIFT_ASSIGN

Line 316: from jtf_cal_shift_assign

312: -- and requested_date
313:
314: cursor shift_info(p_calendar_id NUMBER) is
315: select shift_id,(shift_end_date - shift_start_date) shift_duration
316: from jtf_cal_shift_assign
317: where calendar_id = p_calendar_id
318: order by shift_sequence_number;
319:
320: -- Based on the shift_id corresponding shift construction is found.

Line 530: from jtf_cal_shift_assign

526: --
527: begin --(2)
528: select sum(shift_end_date - shift_start_date)
529: into l_shifts_total_duration
530: from jtf_cal_shift_assign
531: where calendar_id = l_calendar_id;
532:
533: -- Based on the mod value the shift is selected. This happens when two shifts are attached to the
534: -- calendar and a pattern of two in sequence is required.

Line 903: from jtf_cal_shift_assign

899: type tbl_type is table of rec_type index by binary_integer;
900:
901: cursor shift_info(p_calendar_id NUMBER) is
902: select shift_id,(shift_end_date - shift_start_date) shift_duration
903: from jtf_cal_shift_assign
904: where calendar_id = p_calendar_id
905: order by shift_sequence_number;
906:
907: cursor c_cal_shift_constr(p_shift_id NUMBER, p_day date, p_uot_value NUMBER) is

Line 1062: from jtf_cal_shift_assign

1058:
1059: BEGIN --(2)
1060: select sum(shift_end_date - shift_start_date)
1061: into l_shifts_total_duration
1062: from jtf_cal_shift_assign
1063: where calendar_id = l_calendar_id;
1064:
1065: l_left_days := mod((l_shift_date - l_calendar_start_date),l_shifts_total_duration);
1066:

Line 1393: from jtf_cal_shift_assign

1389: type tbl_attributes_type is table of rec_attributes_type index by binary_integer;
1390:
1391: cursor shift_info(p_calendar_id NUMBER) is
1392: select shift_id,(shift_end_date - shift_start_date) shift_duration
1393: from jtf_cal_shift_assign
1394: where calendar_id = p_calendar_id
1395: order by shift_sequence_number;
1396:
1397: cursor c_cal_shift_constr(p_shift_id NUMBER, p_day date, p_uot_value NUMBER) is

Line 1575: from jtf_cal_shift_assign

1571: -- This check is not necessary. Can be removed after testing.
1572: begin --(2)
1573: select sum(shift_end_date - shift_start_date)
1574: into l_shifts_total_duration
1575: from jtf_cal_shift_assign
1576: where calendar_id = l_calendar_id;
1577:
1578: l_left_days := mod((l_shift_date - l_calendar_start_date),l_shifts_total_duration);
1579:

Line 2033: from jtf_cal_shift_assign

2029: l_api_version CONSTANT NUMBER := 1.0;
2030: --
2031: cursor shift_info(p_calendar_id NUMBER) is
2032: select shift_id,(shift_end_date - shift_start_date) shift_duration
2033: from jtf_cal_shift_assign
2034: where calendar_id = p_calendar_id
2035: order by shift_sequence_number;
2036: --
2037: cursor work_hrs(p_shift_id NUMBER, p_day date, p_uot_value NUMBER) is

Line 2233: from jtf_cal_shift_assign

2229: --
2230: begin --(2)
2231: select sum(shift_end_date - shift_start_date)
2232: into l_shifts_total_duration
2233: from jtf_cal_shift_assign
2234: where calendar_id = l_calendar_id;
2235:
2236: select mod((l_shift_date - l_calendar_start_date),l_shifts_total_duration)
2237: into l_left_days