DBA Data[Home] [Help]

APPS.WMS_CAROUSEL_INTEGRATION_PVT dependencies on WMS_CAROUSEL_DIRECTIVE_QUEUE_S

Line 802: VALUES (WMS_CAROUSEL_DIRECTIVE_QUEUE_S.NEXTVAL, p_task.request_id, p_task.task_id,

798: ,CREATED_BY
799: ,LAST_UPDATE_LOGIN
800: ,business_event_id
801: )
802: VALUES (WMS_CAROUSEL_DIRECTIVE_QUEUE_S.NEXTVAL, p_task.request_id, p_task.task_id,
803: p_directive.sequence_id, p_directive.subinventory,
804: p_directive.directive, p_directive.prev_id,
805: p_directive.request, p_directive.response,
806: p_directive.response_timeout, p_directive.max_attempts,

Line 1026: v_status wms_carousel_directive_queue.status%TYPE;

1022: )
1023: ORDER BY CAROUSEL_DIRECTIVE_QUEUE_ID
1024: FOR UPDATE;
1025:
1026: v_status wms_carousel_directive_queue.status%TYPE;
1027: v_count NUMBER := 1;
1028: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1029: l_exec_action VARCHAR2 (4000);
1030: l_directive_pause_delay NUMBER;