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 988: SELECT WMS_DISPATCHED_TASKS_S.nextval INTO l_sequence_number FROM DUAL ;

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