DBA Data[Home] [Help]

APPS.CLN_DEBUG_PUB dependencies on DUAL

Line 13: from dual;

9: G_DEBUG_MODE := 'FILE';
10: if G_FILE is null then
11: select substr('cln-' || to_char(sysdate,'dd-mon-yyyy') || '-' || lpad(cln_debug_s.nextval,6,'0'),1,22) || '.dbg'
12: into G_FILE
13: from dual;
14: G_FILE_PTR := utl_file.fopen(G_DIR, G_FILE, 'a');
15: end if;
16: rtn_val := G_DIR || '/' || g_file;
17: elsif P_MODE = 'CONC' then