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 1027: from jtf_cal_shift_assign

1023: type tbl_type is table of rec_type index by binary_integer;
1024:
1025: cursor shift_info(p_calendar_id NUMBER) is
1026: select shift_id,(shift_end_date - shift_start_date) shift_duration
1027: from jtf_cal_shift_assign
1028: where calendar_id = p_calendar_id
1029: order by shift_sequence_number;
1030:
1031: -- cursor c_cal_shift_constr(p_shift_id NUMBER, p_day date, p_uot_value NUMBER) is

Line 1199: from jtf_cal_shift_assign

1195:
1196: BEGIN -- (2)
1197: select sum(shift_end_date - shift_start_date)
1198: into l_shifts_total_duration
1199: from jtf_cal_shift_assign
1200: where calendar_id = l_calendar_id;
1201:
1202: l_left_days := mod((l_shift_date - l_calendar_start_date),l_shifts_total_duration);
1203:

Line 1587: from jtf_cal_shift_assign

1583: type tbl_type is table of rec_type index by binary_integer; */
1584:
1585: cursor shift_info(p_calendar_id NUMBER) is
1586: select shift_id,(shift_end_date - shift_start_date) shift_duration
1587: from jtf_cal_shift_assign
1588: where calendar_id = p_calendar_id
1589: order by shift_sequence_number;
1590:
1591: -- cursor c_cal_shift_constr(p_shift_id NUMBER, p_day date, p_uot_value NUMBER) is

Line 1796: from jtf_cal_shift_assign

1792:
1793: BEGIN --(2)
1794: select sum(shift_end_date - shift_start_date)
1795: into l_shifts_total_duration
1796: from jtf_cal_shift_assign
1797: where calendar_id = l_calendar_id;
1798:
1799: l_left_days := mod((l_shift_date - l_calendar_start_date),l_shifts_total_duration);
1800:

Line 2389: from jtf_cal_shift_assign

2385: l_shift SHIFT_TBL_TYPE;
2386: --
2387: cursor shift_info(p_calendar_id NUMBER) is
2388: select shift_id,(shift_end_date - shift_start_date) shift_duration
2389: from jtf_cal_shift_assign
2390: where calendar_id = p_calendar_id
2391: order by shift_sequence_number;
2392:
2393: cursor work_hrs(p_shift_id NUMBER, p_day date, p_uot_value date) is

Line 2614: from jtf_cal_shift_assign

2610: --
2611: begin --(2)
2612: select sum(shift_end_date - shift_start_date)
2613: into l_shifts_total_duration
2614: from jtf_cal_shift_assign
2615: where calendar_id = l_calendar_id;
2616: --
2617: select mod((l_shift_date - l_calendar_start_date),l_shifts_total_duration)
2618: into l_left_days