APPS.WMS_CAROUSEL_INTEGRATION_PKG SQL Statements

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

Line: 38

      wms_device_integration_pub.update_request
                                              (p_request_id       => p_request_id,
                                               p_device_id        => p_device_id,
                                               p_status_code      => x_status_code,
                                               p_status_msg       => x_device_status
                                              );

Line: 120

         SELECT d.device_id, d.subinventory_code
           FROM wms_devices_b d
           WHERE d.device_id = p_primary_device;

Line: 142

      INSERT INTO WMS_CAROUSEL_CONFIGURATION
	(
	CAROUSEL_CONFIGURATION_ID
	,CONFIG_NAME
	,CONFIG_VALUE
	,SEQUENCE_ID
	,ACTIVE_IND
	,LAST_UPDATE_DATE
	,LAST_UPDATED_BY
	,CREATION_DATE
	,CREATED_BY
	,LAST_UPDATE_LOGIN
	)
      VALUES
        (WMS_CAROUSEL_CONFIGURATION_S.NEXTVAL
	,'PIPE_NAME'
	,v_pipename
	,p_device_id
	,'Y'
	,SYSDATE
	,fnd_global.user_id
	,SYSDATE
	,fnd_global.user_id
	,fnd_global.login_id
	);

Line: 175

	SELECT MIN(SEQUENCE_ID) into l_primary_device FROM WMS_CAROUSEL_CONFIGURATION
	WHERE CONFIG_NAME = 'PIPE_NAME'
	AND CONFIG_VALUE = v_pipename;

Line: 187

		select 1 INTO l_dummy from (
		 SELECT job,what, (substr(what, instr(what,'''',-1,2)+1, (instr(what,'''',-1,1) - instr(what,'''',-1,2) - 1))) pipe_name
		   FROM user_jobs
		  WHERE UPPER (what) LIKE '%WMS_CAROUSEL_INTEGRATION_PKG.PIPE_LISTENER_LOOP%')
		where pipe_name = v_pipename;

Line: 239

        select distinct * from (
         SELECT job,what, (substr(what, instr(what,'''',-1,2)+1, (instr(what,'''',-1,1) - instr(what,'''',-1,2) - 1))) pipe_name
           FROM user_jobs
          WHERE UPPER (what) LIKE '%WMS_CAROUSEL_INTEGRATION_PKG.PIPE_LISTENER_LOOP%')
        where pipe_name = nvl(p_pipe_name, pipe_name);

Line: 282

        select * from (
         SELECT job,what, (substr(what, instr(what,'''',-1,2)+1, (instr(what,'''',-1,1) - instr(what,'''',-1,2) - 1))) pipe_name
           FROM user_jobs
          WHERE UPPER (what) LIKE '%WMS_CAROUSEL_INTEGRATION_PKG.PIPE_LISTENER_LOOP%')
        where pipe_name = nvl(p_pipe_name, pipe_name);

Line: 326

         SELECT job, what
           FROM user_jobs
          WHERE UPPER (what) LIKE '%WMS_CAROUSEL_INTEGRATION_PKG.PIPE_LISTENER_LOOP%';

Line: 352

     CURSOR C_PIPE_DEVICES IS SELECT SEQUENCE_ID FROM WMS_CAROUSEL_CONFIGURATION
     WHERE CONFIG_NAME = 'PIPE_NAME';

Line: 372

	UPDATE WMS_CAROUSEL_CONFIGURATION c
	SET c.CONFIG_VALUE = 'ON'
	WHERE c.CONFIG_NAME = 'PIPE_LISTENER_SWITCH';

Line: 388

	UPDATE WMS_CAROUSEL_CONFIGURATION c
	SET c.CONFIG_VALUE = 'ON'
	WHERE c.CONFIG_NAME = 'PIPE_LISTENER_SWITCH'
	AND SEQUENCE_ID IN (SELECT SEQUENCE_ID FROM wms_carousel_configuration WHERE CONFIG_VALUE = v_pipename);

Line: 410

	UPDATE WMS_CAROUSEL_CONFIGURATION c
	SET c.CONFIG_VALUE = 'OFF'
	WHERE c.CONFIG_NAME = 'PIPE_LISTENER_SWITCH';

Line: 426

	UPDATE WMS_CAROUSEL_CONFIGURATION c
	SET c.CONFIG_VALUE = 'OFF'
	WHERE c.CONFIG_NAME = 'PIPE_LISTENER_SWITCH'
	AND SEQUENCE_ID IN (SELECT SEQUENCE_ID FROM WMS_CAROUSEL_CONFIGURATION WHERE CONFIG_VALUE = v_pipename);

Line: 445

			SELECT  1 FROM WMS_DISPATCHED_TASKS wdt
			WHERE	organization_id 	 = p_organization_id
			AND device_id			 = p_device_id
			AND PERSON_ID           = p_emp_id
			AND status = 9;

Line: 463

		  DELETE FROM wms_device_assignment_temp WHERE device_id = p_device_id and EMPLOYEE_ID = p_emp_id;