DBA Data[Home] [Help]

APPS.MSC_WF_ALLOC_ATP dependencies on V$PARAMETER

Line 32: from v$parameter where name= 'utl_file_dir';

28: END IF;
29:
30: select ltrim(rtrim(substr(value, instr(value,',',-1,1)+1)))
31: into DEBUG_LOC_SRC
32: from v$parameter where name= 'utl_file_dir';
33:
34: IF PG_DEBUG in ('Y', 'C') THEN
35: msc_sch_wb.atp_debug('debug_wf: ' || DEBUG_LOC_SRC );
36: END IF;

Line 46: FROM v$parameter

42: WHERE addr = (SELECT paddr FROM v$session
43: WHERE audsid=userenv('SESSIONID'));
44: SELECT value
45: INTO TRACE_LOC_SRC
46: FROM v$parameter
47: WHERE name = 'user_dump_dest';
48: END IF;
49:
50: