APPS.WMS_CAROUSEL_INTEGRATION_PKG dependencies on WMS_CAROUSEL_CONFIGURATION

Line 142: INSERT INTO WMS_CAROUSEL_CONFIGURATION

138: -- No PIPE_NAME config parameter created for the device. Hence create a default one
139: -- 4311016
140: v_pipename := p_device_id;
141: l_primary_device := p_device_id;
142: INSERT INTO WMS_CAROUSEL_CONFIGURATION
143: (
144: CAROUSEL_CONFIGURATION_ID
145: ,CONFIG_NAME
146: ,CONFIG_VALUE

Line 156: (WMS_CAROUSEL_CONFIGURATION_S.NEXTVAL

152: ,CREATED_BY
153: ,LAST_UPDATE_LOGIN
154: )
155: VALUES
156: (WMS_CAROUSEL_CONFIGURATION_S.NEXTVAL
157: ,'PIPE_NAME'
158: ,v_pipename
159: ,p_device_id
160: ,'Y'

Line 175: SELECT MIN(SEQUENCE_ID) into l_primary_device FROM WMS_CAROUSEL_CONFIGURATION

171: );
172: END IF;
173: ELSE
174: -- Get the first device in the group
175: SELECT MIN(SEQUENCE_ID) into l_primary_device FROM WMS_CAROUSEL_CONFIGURATION
176: WHERE CONFIG_NAME = 'PIPE_NAME'
177: AND CONFIG_VALUE = v_pipename;
178: END IF;
179:

Line 352: CURSOR C_PIPE_DEVICES IS SELECT SEQUENCE_ID FROM WMS_CAROUSEL_CONFIGURATION

348: END;
349:
350: PROCEDURE recreate_pipe_listeners
351: IS
352: CURSOR C_PIPE_DEVICES IS SELECT SEQUENCE_ID FROM WMS_CAROUSEL_CONFIGURATION
353: WHERE CONFIG_NAME = 'PIPE_NAME';
354: BEGIN
355: remove_pipe_listeners;
356: FOR v_job IN C_PIPE_DEVICES

Line 372: UPDATE WMS_CAROUSEL_CONFIGURATION c

368: PRAGMA AUTONOMOUS_TRANSACTION;
369: BEGIN
370: IF (p_device_id IS NULL) THEN
371: -- Switch on all listeners
372: UPDATE WMS_CAROUSEL_CONFIGURATION c
373: SET c.CONFIG_VALUE = 'ON'
374: WHERE c.CONFIG_NAME = 'PIPE_LISTENER_SWITCH';
375: IF (l_debug > 0) THEN
376: wms_carousel_integration_pvt.LOG (null,'All Pipe Listeners Switched ON');

Line 388: UPDATE WMS_CAROUSEL_CONFIGURATION c

384: ),
385: 'PIPE_NAME_' || p_device_id
386: );
387: -- Switch on
388: UPDATE WMS_CAROUSEL_CONFIGURATION c
389: SET c.CONFIG_VALUE = 'ON'
390: WHERE c.CONFIG_NAME = 'PIPE_LISTENER_SWITCH'
391: AND SEQUENCE_ID IN (SELECT SEQUENCE_ID FROM wms_carousel_configuration WHERE CONFIG_VALUE = v_pipename);
392: IF (l_debug > 0) THEN

Line 391: AND SEQUENCE_ID IN (SELECT SEQUENCE_ID FROM wms_carousel_configuration WHERE CONFIG_VALUE = v_pipename);

387: -- Switch on
388: UPDATE WMS_CAROUSEL_CONFIGURATION c
389: SET c.CONFIG_VALUE = 'ON'
390: WHERE c.CONFIG_NAME = 'PIPE_LISTENER_SWITCH'
391: AND SEQUENCE_ID IN (SELECT SEQUENCE_ID FROM wms_carousel_configuration WHERE CONFIG_VALUE = v_pipename);
392: IF (l_debug > 0) THEN
393: wms_carousel_integration_pvt.LOG (p_device_id,'Pipe Listener Switched ON: Pipe=IN_' || v_pipename);
394: END IF;
395: END IF;

Line 410: UPDATE WMS_CAROUSEL_CONFIGURATION c

406: PRAGMA AUTONOMOUS_TRANSACTION;
407: BEGIN
408: IF (p_device_id IS NULL) THEN
409: -- Switch off all listeners
410: UPDATE WMS_CAROUSEL_CONFIGURATION c
411: SET c.CONFIG_VALUE = 'OFF'
412: WHERE c.CONFIG_NAME = 'PIPE_LISTENER_SWITCH';
413: IF (l_debug > 0) THEN
414: WMS_CAROUSEL_INTEGRATION_PVT.LOG (null,'All Pipe Listeners Switched OFF');

Line 426: UPDATE WMS_CAROUSEL_CONFIGURATION c

422: ),
423: 'PIPE_NAME_' || p_device_id
424: );
425: -- Switch off
426: UPDATE WMS_CAROUSEL_CONFIGURATION c
427: SET c.CONFIG_VALUE = 'OFF'
428: WHERE c.CONFIG_NAME = 'PIPE_LISTENER_SWITCH'
429: AND SEQUENCE_ID IN (SELECT SEQUENCE_ID FROM WMS_CAROUSEL_CONFIGURATION WHERE CONFIG_VALUE = v_pipename);
430: IF (l_debug > 0) THEN

Line 429: AND SEQUENCE_ID IN (SELECT SEQUENCE_ID FROM WMS_CAROUSEL_CONFIGURATION WHERE CONFIG_VALUE = v_pipename);

425: -- Switch off
426: UPDATE WMS_CAROUSEL_CONFIGURATION c
427: SET c.CONFIG_VALUE = 'OFF'
428: WHERE c.CONFIG_NAME = 'PIPE_LISTENER_SWITCH'
429: AND SEQUENCE_ID IN (SELECT SEQUENCE_ID FROM WMS_CAROUSEL_CONFIGURATION WHERE CONFIG_VALUE = v_pipename);
430: IF (l_debug > 0) THEN
431: WMS_CAROUSEL_INTEGRATION_PVT.LOG (p_device_id,'Pipe Listener Switched OFF: Pipe=IN_' || v_pipename);
432: END IF;
433: END IF;