APPS.JTF_CALENDAR_PUB_24HR dependencies on JTF_CAL_SHIFT_ASSIGN

Line 216: from jtf_cal_shift_assign

212: -- and requested_date
213:
214: cursor shift_info(p_calendar_id NUMBER) is
215: select shift_id,(shift_end_date - shift_start_date) shift_duration
216: from jtf_cal_shift_assign
217: where calendar_id = p_calendar_id
218: order by shift_sequence_number;
219:
220: -- Based on the shift_id corresponding shift construction is found.

Line 1094: from jtf_cal_shift_assign

1090: type tbl_type is table of rec_type index by binary_integer;
1091:
1092: cursor shift_info(p_calendar_id NUMBER) is
1093: select shift_id,(shift_end_date - shift_start_date) shift_duration
1094: from jtf_cal_shift_assign
1095: where calendar_id = p_calendar_id
1096: order by shift_sequence_number;
1097:
1098: -- cursor c_cal_shift_constr(p_shift_id NUMBER, p_day date, p_uot_value NUMBER) is

Line 1266: from jtf_cal_shift_assign

1262:
1263: BEGIN -- (2)
1264: select sum(shift_end_date - shift_start_date)
1265: into l_shifts_total_duration
1266: from jtf_cal_shift_assign
1267: where calendar_id = l_calendar_id;
1268:
1269: l_left_days := mod((l_shift_date - l_calendar_start_date),l_shifts_total_duration);
1270:

Line 1654: from jtf_cal_shift_assign

1650: type tbl_type is table of rec_type index by binary_integer; */
1651:
1652: cursor shift_info(p_calendar_id NUMBER) is
1653: select shift_id,(shift_end_date - shift_start_date) shift_duration
1654: from jtf_cal_shift_assign
1655: where calendar_id = p_calendar_id
1656: order by shift_sequence_number;
1657:
1658: -- cursor c_cal_shift_constr(p_shift_id NUMBER, p_day date, p_uot_value NUMBER) is

Line 1863: from jtf_cal_shift_assign

1859:
1860: BEGIN --(2)
1861: select sum(shift_end_date - shift_start_date)
1862: into l_shifts_total_duration
1863: from jtf_cal_shift_assign
1864: where calendar_id = l_calendar_id;
1865:
1866: l_left_days := mod((l_shift_date - l_calendar_start_date),l_shifts_total_duration);
1867:

Line 2459: from jtf_cal_shift_assign

2455: l_shift SHIFT_TBL_TYPE;
2456: --
2457: cursor shift_info(p_calendar_id NUMBER) is
2458: select shift_id,(shift_end_date - shift_start_date) shift_duration
2459: from jtf_cal_shift_assign
2460: where calendar_id = p_calendar_id
2461: order by shift_sequence_number;
2462:
2463: cursor work_hrs(p_shift_id NUMBER, p_day date, p_uot_value date) is

Line 2684: from jtf_cal_shift_assign

2680: --
2681: begin --(2)
2682: select sum(shift_end_date - shift_start_date)
2683: into l_shifts_total_duration
2684: from jtf_cal_shift_assign
2685: where calendar_id = l_calendar_id;
2686: --
2687: select mod((l_shift_date - l_calendar_start_date),l_shifts_total_duration)
2688: into l_left_days