APPS.WMS_CAROUSEL_INTEGRATION_PVT dependencies on WMS_CAROUSEL_CONFIGURATION

Line 30: FROM wms_carousel_configuration

26: p_name IN VARCHAR2
27: )
28: IS
29: SELECT CONFIG_VALUE
30: FROM wms_carousel_configuration
31: WHERE CONFIG_NAME = p_name
32: AND NVL (NVL (device_type_id, p_device_type_id), 0) = NVL (p_device_type_id, 0)
33: AND NVL (NVL (business_event_id, p_business_event_id), 0) = NVL (p_business_event_id, 0)
34: AND NVL (NVL (sequence_id, p_sequence_id), 0) = NVL (p_sequence_id, 0)

Line 80: FROM WMS_CAROUSEL_CONFIGURATION

76: P_NAME IN VARCHAR2
77: )
78: IS
79: SELECT CONFIG_VALUE
80: FROM WMS_CAROUSEL_CONFIGURATION
81: WHERE CONFIG_NAME = P_NAME
82: AND DEVICE_TYPE_ID = P_DEVICE_TYPE_ID
83: AND BUSINESS_EVENT_ID = P_BUSINESS_EVENT_ID
84: AND SEQUENCE_ID = P_SEQUENCE_ID

Line 507: FROM wms_carousel_configuration wcc_dir, wms_carousel_configuration wcc_dev

503: -- bug10367675 only return sequences that have the correct device_id
504: CURSOR c_sequence_ids (p_device_type_id IN NUMBER, P_BUSINESS_EVENT_ID IN NUMBER, p_device_id in number)
505: IS
506: SELECT wcc_dir.sequence_id sequence_id, wcc_dir.config_value
507: FROM wms_carousel_configuration wcc_dir, wms_carousel_configuration wcc_dev
508: WHERE wcc_dir.CONFIG_NAME = 'DIRECTIVE'
509: AND wcc_dir.device_type_id = p_device_type_id
510: AND wcc_dir.BUSINESS_EVENT_ID = P_BUSINESS_EVENT_ID
511: AND wcc_dir.active_ind = 'Y'

Line 1419: FROM WMS_CAROUSEL_CONFIGURATION

1415: AND NVL(q.TASK_ID,0) = NVL(P_TASK_ID,NVL(q.TASK_ID,0))
1416: AND NVL (q.STATUS, 'P') IN ('C', 'P')
1417: AND q.DIRECTIVE IN
1418: (SELECT CONFIG_VALUE
1419: FROM WMS_CAROUSEL_CONFIGURATION
1420: WHERE CONFIG_NAME = NVL(p_config_name,'DIRECTIVE_QUEUE_UPDATE')
1421: AND DEVICE_TYPE_ID = q.DEVICE_TYPE_ID
1422: AND BUSINESS_EVENT_ID = q.BUSINESS_EVENT_ID
1423: AND SEQUENCE_ID = q.SEQUENCE_ID