APPS.WMS_WORKFLOW_WRAPPERS dependencies on DUAL

Line 14: select to_char(sysdate,'MM/DD/YYYY HH:MM:SS') INTO l_ts from dual;

10: l_msg VARCHAR2(5100);
11: l_ts VARCHAR2(30);
12: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
13: BEGIN
14: select to_char(sysdate,'MM/DD/YYYY HH:MM:SS') INTO l_ts from dual;
15:
16: l_msg:=l_ts||' '||msg;
17:
18: inv_mobile_helper_functions.tracelog

Line 990: SELECT WMS_DISPATCHED_TASKS_S.nextval INTO l_sequence_number FROM DUAL ;

986: END IF;
987:
988: -- generate item key using sequence number and concat with txnworkflow 'twflow'.
989: -- This is needed to create the workflow process
990: SELECT WMS_DISPATCHED_TASKS_S.nextval INTO l_sequence_number FROM DUAL ;
991:
992: l_item_key := 'twflow' || l_sequence_number ;
993: IF (l_debug = 1) THEN
994: mdebug('Item key is: '|| l_item_key);