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

484: --
485: begin --(2)
486: select sum(shift_end_date - shift_start_date)
487: into l_shifts_total_duration
488: from jtf_cal_shift_assign
489: where calendar_id = l_calendar_id;
490:
491: -- Based on the mod value the shift is selected. This happens when two shifts are attached to the
492: -- calendar and a pattern of two in sequence is required.

Line 861: from jtf_cal_shift_assign

857: type tbl_type is table of rec_type index by binary_integer;
858:
859: cursor shift_info(p_calendar_id NUMBER) is
860: select shift_id,(shift_end_date - shift_start_date) shift_duration
861: from jtf_cal_shift_assign
862: where calendar_id = p_calendar_id
863: order by shift_sequence_number;
864:
865: cursor c_cal_shift_constr(p_shift_id NUMBER, p_day date, p_uot_value NUMBER) is

Line 1020: from jtf_cal_shift_assign

1016:
1017: BEGIN --(2)
1018: select sum(shift_end_date - shift_start_date)
1019: into l_shifts_total_duration
1020: from jtf_cal_shift_assign
1021: where calendar_id = l_calendar_id;
1022:
1023: l_left_days := mod((l_shift_date - l_calendar_start_date),l_shifts_total_duration);
1024:

Line 1348: from jtf_cal_shift_assign

1344: type tbl_attributes_type is table of rec_attributes_type index by binary_integer;
1345:
1346: cursor shift_info(p_calendar_id NUMBER) is
1347: select shift_id,(shift_end_date - shift_start_date) shift_duration
1348: from jtf_cal_shift_assign
1349: where calendar_id = p_calendar_id
1350: order by shift_sequence_number;
1351:
1352: cursor c_cal_shift_constr(p_shift_id NUMBER, p_day date, p_uot_value NUMBER) is

Line 1530: from jtf_cal_shift_assign

1526: -- This check is not necessary. Can be removed after testing.
1527: begin --(2)
1528: select sum(shift_end_date - shift_start_date)
1529: into l_shifts_total_duration
1530: from jtf_cal_shift_assign
1531: where calendar_id = l_calendar_id;
1532:
1533: l_left_days := mod((l_shift_date - l_calendar_start_date),l_shifts_total_duration);
1534:

Line 1983: from jtf_cal_shift_assign

1979: l_api_version CONSTANT NUMBER := 1.0;
1980: --
1981: cursor shift_info(p_calendar_id NUMBER) is
1982: select shift_id,(shift_end_date - shift_start_date) shift_duration
1983: from jtf_cal_shift_assign
1984: where calendar_id = p_calendar_id
1985: order by shift_sequence_number;
1986: --
1987: cursor work_hrs(p_shift_id NUMBER, p_day date, p_uot_value NUMBER) is

Line 2183: from jtf_cal_shift_assign

2179: --
2180: begin --(2)
2181: select sum(shift_end_date - shift_start_date)
2182: into l_shifts_total_duration
2183: from jtf_cal_shift_assign
2184: where calendar_id = l_calendar_id;
2185:
2186: select mod((l_shift_date - l_calendar_start_date),l_shifts_total_duration)
2187: into l_left_days