DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_DEVICE dependencies on DUAL

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

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

Line 52: FROM DUAL;

48: END IF;
49:
50: SELECT WMS_DEVICE_ASSIGNMENT_TEMP_S.nextval
51: INTO l_assign_temp_id
52: FROM DUAL;
53:
54: INSERT INTO WMS_DEVICE_ASSIGNMENT_TEMP
55: ( ASSIGNMENT_TEMP_ID,
56: EMPLOYEE_ID,