APPS.WMS_CAROUSEL_INTEGRATION_PVT dependencies on WMS_CAROUSEL_DIRECTIVE_QUEUE_S

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

808: ,CREATED_BY
809: ,LAST_UPDATE_LOGIN
810: ,business_event_id
811: )
812: VALUES (WMS_CAROUSEL_DIRECTIVE_QUEUE_S.NEXTVAL, p_task.request_id, p_task.task_id,
813: p_directive.sequence_id, p_directive.subinventory,
814: p_directive.directive, p_directive.prev_id,
815: p_directive.request, p_directive.response,
816: p_directive.response_timeout, p_directive.max_attempts,

Line 1036: v_status wms_carousel_directive_queue.status%TYPE;

1032: )
1033: ORDER BY CAROUSEL_DIRECTIVE_QUEUE_ID
1034: FOR UPDATE;
1035:
1036: v_status wms_carousel_directive_queue.status%TYPE;
1037: v_count NUMBER := 1;
1038: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1039: l_exec_action VARCHAR2 (4000);
1040: l_directive_pause_delay NUMBER;