[Home] [Help]
412:
413: -- ASSUMPTIONS:
414: -- A Task can appear only once for a given visit (ahl_visit_tasks_b)
415: -- A Department can have only one shift (ahl_department_shifts)
416: -- Shift_Num is unique in bom_shift_times
417:
418: -- Validate Visit Id
419: IF (p_visit_id IS NULL) THEN
420: Fnd_Message.Set_Name('AHL','AHL_LTP_VISIT_ID_NULL');
3381: SELECT calendar_code, shift_num FROM ahl_department_shifts
3382: WHERE department_id = p_department_id;
3383:
3384: CURSOR l_shift_times_csr(p_calendar_code IN VARCHAR2, p_shift_num IN NUMBER) IS
3385: SELECT FROM_TIME, TO_TIME FROM bom_shift_times
3386: WHERE CALENDAR_CODE = p_calendar_code AND
3387: SHIFT_NUM = p_shift_num;
3388:
3389: CURSOR l_workday_pattern_csr(p_calendar_code IN VARCHAR2, p_shift_num IN NUMBER) IS
4053: SELECT calendar_code, shift_num FROM ahl_department_shifts
4054: WHERE department_id = p_department_id;
4055:
4056: CURSOR l_shift_times_csr(p_calendar_code IN VARCHAR2, p_shift_num IN NUMBER) IS
4057: SELECT FROM_TIME, TO_TIME FROM bom_shift_times
4058: WHERE CALENDAR_CODE = p_calendar_code AND
4059: SHIFT_NUM = p_shift_num;
4060:
4061: CURSOR l_workday_pattern_csr(p_calendar_code IN VARCHAR2, p_shift_num IN NUMBER) IS
4346: IS
4347:
4348: CURSOR l_shift_details_csr(p_resource_id NUMBER) IS
4349: SELECT from_time, to_time
4350: FROM bom_shift_times st, bom_resource_shifts rs
4351: WHERE st.shift_num = rs.shift_num AND
4352: rs.resource_id = p_resource_id;
4353:
4354: l_shift_start NUMBER := 0;