APPS.WMS_TASK_DISPATCH_DEVICE dependencies on WMS_DEVICE_ASSIGNMENT_TEMP

Line 50: SELECT WMS_DEVICE_ASSIGNMENT_TEMP_S.nextval

46: IF (l_debug = 1) THEN
47: mydebug('In insert_device');
48: END IF;
49:
50: SELECT WMS_DEVICE_ASSIGNMENT_TEMP_S.nextval
51: INTO l_assign_temp_id
52: FROM DUAL;
53:
54: INSERT INTO WMS_DEVICE_ASSIGNMENT_TEMP

Line 54: INSERT INTO WMS_DEVICE_ASSIGNMENT_TEMP

50: SELECT WMS_DEVICE_ASSIGNMENT_TEMP_S.nextval
51: INTO l_assign_temp_id
52: FROM DUAL;
53:
54: INSERT INTO WMS_DEVICE_ASSIGNMENT_TEMP
55: ( ASSIGNMENT_TEMP_ID,
56: EMPLOYEE_ID,
57: ORGANIZATION_ID,
58: DEVICE_ID,

Line 134: FROM wms_device_assignment_temp

130: l_device_id NUMBER;
131:
132: CURSOR get_devices_to_cleanup IS
133: SELECT device_id
134: FROM wms_device_assignment_temp
135: WHERE Employee_Id=p_employee_id
136: AND organization_id=p_org_id;
137: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
138: l_wcs_enabled VARCHAR2(1);

Line 194: DELETE FROM WMS_DEVICE_ASSIGNMENT_TEMP

190:
191: CLOSE get_devices_to_cleanup;
192:
193: -- signed off all the devices for this person
194: DELETE FROM WMS_DEVICE_ASSIGNMENT_TEMP
195: WHERE Employee_Id=p_Employee_Id
196: AND organization_id=p_org_id;
197:
198: IF p_retain_dispatched_tasks ='N' or SQL%ROWCOUNT >1 THEN

Line 228: Deleting From Wms_device_assignment_temp &

224: /*
225: This is the overloaded procedure
226: It takes one additional parameter p_device_id
227: The call to sync_device
228: Deleting From Wms_device_assignment_temp &
229: Deleting or Updating WDT
230: will be only for that particular device
231: */
232: PROCEDURE cleanup_device_and_tasks

Line 246: FROM wms_device_assignment_temp

242: l_device_id NUMBER;
243:
244: CURSOR get_devices_to_cleanup IS
245: SELECT device_id
246: FROM wms_device_assignment_temp
247: WHERE Employee_Id=p_employee_id
248: AND organization_id=p_org_id
249: AND device_id = p_device_id;
250: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 307: DELETE FROM WMS_DEVICE_ASSIGNMENT_TEMP

303:
304: CLOSE get_devices_to_cleanup;
305:
306: -- signed off all the devices for this person
307: DELETE FROM WMS_DEVICE_ASSIGNMENT_TEMP
308: WHERE Employee_Id=p_Employee_Id
309: AND organization_id=p_org_id
310: AND device_id = p_device_id;
311:

Line 402: FROM WMS_DEVICE_ASSIGNMENT_TEMP wda,

398: IF l_device_type_id = 6 THEN
399: BEGIN
400: SELECT 1
401: INTO l_signed_onto_wrk_stn
402: FROM WMS_DEVICE_ASSIGNMENT_TEMP wda,
403: WMS_DEVICES_VL wvl
404: WHERE wda.device_id = wvl.device_id
405: AND wvl.organization_id = p_organization_id
406: AND wda.employee_id = p_emp_id

Line 423: FROM WMS_DEVICE_ASSIGNMENT_TEMP wda

419: SELECT 1
420: , wvl.description
421: INTO l_is_device_signed
422: , x_device_desc
423: FROM WMS_DEVICE_ASSIGNMENT_TEMP wda
424: , WMS_DEVICES_VL wvl
425: WHERE wda.device_id = wvl.device_id
426: AND (wvl.subinventory_code IS NOT NULL OR device_type_id = 100)
427: AND l_is_multi_signon_dev <> 'Y'