DBA Data[Home] [Help]

APPS.FND_TRACE dependencies on DUAL

Line 67: SELECT USER INTO DBUSER FROM DUAL;

63: IF (FND_GLOBAL.CONC_REQUEST_ID > 0) then
64: IDENT_STRING_T:=IDENT_STRING_T||'_CR'||FND_GLOBAL.CONC_REQUEST_ID;
65: END IF;
66: ELSE
67: SELECT USER INTO DBUSER FROM DUAL;
68: IDENT_STRING_T:=substr(DBUSER,1,12);
69: END IF;
70:
71: IF(nvl(IDENT_STRING_G,' ') <> IDENT_STRING_T) THEN

Line 308: l_trc_cmd:='select sysdate into l_trc_cmd from dual';

304: ELSIF (TRACE_TYPE=10053) THEN
305: l_trc_cmd:='alter session set events=''10053 trace name context off''';
306: EXECUTE IMMEDIATE l_trc_cmd;
307: ELSE
308: l_trc_cmd:='select sysdate into l_trc_cmd from dual';
309: -- log message , should never fall thru to this branch.
310: END IF;
311: END;
312: