APPS.WMS_TASK_DISPATCH_DEVICE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 34

PROCEDURE insert_device
  (p_Employee_Id     IN NUMBER,
   p_device_id       IN NUMBER,
   p_org_id          IN NUMBER,
   x_return_status   OUT  NOCOPY VARCHAR2) IS
      l_assign_temp_id number;

Line: 47

      mydebug('In insert_device');

Line: 50

   SELECT WMS_DEVICE_ASSIGNMENT_TEMP_S.nextval
     INTO l_assign_temp_id
     FROM DUAL;

Line: 54

   INSERT INTO WMS_DEVICE_ASSIGNMENT_TEMP
     ( 	ASSIGNMENT_TEMP_ID,
	EMPLOYEE_ID,
	ORGANIZATION_ID,
	DEVICE_ID,
	CREATION_DATE,
	CREATED_BY,
	LAST_UPDATE_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_LOGIN)
     VALUES
     (    l_assign_temp_id,
	  p_Employee_Id,
	  p_org_id,
	  p_device_id,
	  sysdate,
	  FND_GLOBAL.USER_ID,
	  sysdate,
	  FND_GLOBAL.USER_ID,
	  FND_GLOBAL.LOGIN_ID );

Line: 116

END insert_device;

Line: 133

	 SELECT device_id
	   FROM wms_device_assignment_temp
	   WHERE Employee_Id=p_employee_id
	   AND organization_id=p_org_id;

Line: 194

   DELETE FROM WMS_DEVICE_ASSIGNMENT_TEMP
     WHERE Employee_Id=p_Employee_Id
     AND organization_id=p_org_id;

Line: 200

   DELETE FROM WMS_DISPATCHED_TASKS
     WHERE person_id = p_Employee_Id
     and organization_id = p_org_id
     and task_type IN (1, 3, 4, 5, 6)
     and status IN (1,3,9); -- delete the Active task too, patchset I

Line: 206

       UPDATE WMS_DISPATCHED_TASKS
       SET status = 3
       WHERE status = 9
         and person_id = p_Employee_ID
         and organization_id = p_org_id
         and task_type IN (1,3,4,5,6);

Line: 245

	 SELECT device_id
	   FROM wms_device_assignment_temp
	   WHERE Employee_Id=p_employee_id
	   AND organization_id=p_org_id
           AND device_id = p_device_id;

Line: 307

   DELETE FROM WMS_DEVICE_ASSIGNMENT_TEMP
     WHERE Employee_Id=p_Employee_Id
     AND organization_id=p_org_id
     AND device_id = p_device_id;

Line: 314

   DELETE FROM WMS_DISPATCHED_TASKS
     WHERE person_id = p_Employee_Id
     and organization_id = p_org_id
     and device_id = p_device_id
     and task_type IN (1, 3, 4, 5, 6)
     and status IN (1,3,9); -- delete the Active task too, patchset I

Line: 321

       UPDATE WMS_DISPATCHED_TASKS
       SET status = 3
       WHERE status = 9
         and person_id = p_Employee_ID
         and organization_id = p_org_id
         and device_id = p_device_id
         and task_type IN (1,3,4,5,6);

Line: 383

         SELECT nvl(device_type_id, -1)
           INTO l_device_type_id
           FROM wms_devices_vl wdv
          WHERE wdv.organization_id = p_organization_id
            AND wdv.name            = p_device_name;

Line: 400

              SELECT 1
                INTO l_signed_onto_wrk_stn
                FROM WMS_DEVICE_ASSIGNMENT_TEMP wda,
                     WMS_DEVICES_VL wvl
               WHERE wda.device_id = wvl.device_id
                 AND wvl.organization_id   = p_organization_id
                 AND wda.employee_id       = p_emp_id
                 AND device_type_id = 100;

Line: 419

      SELECT 1
           , wvl.description
        INTO l_is_device_signed
           , x_device_desc
        FROM WMS_DEVICE_ASSIGNMENT_TEMP wda
           , WMS_DEVICES_VL wvl
       WHERE wda.device_id = wvl.device_id
         AND (wvl.subinventory_code IS NOT NULL OR device_type_id = 100)
         AND l_is_multi_signon_dev <> 'Y'
         AND wvl.organization_id	  = p_organization_id
         AND wvl.name              = p_device_name
         AND device_type_id <> 7 ;

Line: 439

           SELECT device_type
                , description
                , device_id
                , subinventory_code
             INTO x_device_type
                , x_device_desc
                , x_device_id
                , x_subinventory
             FROM WMS_DEVICES_VL
            WHERE (subinventory_code IS NOT NULL OR device_type_id = 100)
              AND organization_id = p_organization_id
              AND name            = p_device_name
              AND device_type_id <> 7 ;

Line: 483

SELECT device_id
  INTO l_device_id
  FROM (
  SELECT wbed.DEVICE_ID
          FROM wms_bus_event_devices wbed  , wms_devices_b wd
	  WHERE wd.device_id = wbed.device_id
          AND WBED.organization_id = WD.organization_id
          AND wd.ENABLED_FLAG = 'Y'
          AND decode (level_type, 200,wbed.subinventory_code,level_value) =
	            decode(level_type,200,p_subinventory,100,p_organization_id ,300, p_locator_id,400,
                      FND_GLOBAL.USER_ID,level_value)
          AND Nvl(wbed.organization_id,-1) = Nvl(p_organization_id ,Nvl(wbed.organization_id ,-1))
         --AND wbed.AUTO_ENABLED_FLAG = decode('Y','Y','Y','N')
	  AND wbed.business_event_id = wms_device_integration_pvt.wms_be_pick_load
          ORDER BY level_type desc
       )
 WHERE rownum < 2;