DBA Data[Home] [Help]

APPS.IEX_DEBUG_PUB dependencies on DUAL

Line 31: --into G_FILE from dual;

27:
28: if P_FILE is null then
29: -- select substr('l'|| substr(to_char(sysdate,'MI'),1,1)
30: -- || lpad(iex_debug_file_s.nextval,6,'0'),1,8) || '.IEX'
31: --into G_FILE from dual;
32:
33: SELECT DB_NAME || USERENV('SESSIONID') || '.IEX' into G_FILE
34: FROM DUAL;
35:

Line 34: FROM DUAL;

30: -- || lpad(iex_debug_file_s.nextval,6,'0'),1,8) || '.IEX'
31: --into G_FILE from dual;
32:
33: SELECT DB_NAME || USERENV('SESSIONID') || '.IEX' into G_FILE
34: FROM DUAL;
35:
36: G_FILE_PTR := utl_file.fopen(G_DIR, G_FILE, 'w');
37: else
38: G_FILE :=P_File;