DBA Data[Home] [Help]

APPS.MSC_ATP_PVT dependencies on V$PARAMETER

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

18985: IF PG_DEBUG in ('Y', 'C') THEN
18986: --ATP Debug Workflow
18987: select ltrim(rtrim(substr(value, instr(value,',',-1,1)+1)))
18988: into x_session_loc_des
18989: from v$parameter where name= 'utl_file_dir';
18990: END IF;
18991: msc_sch_wb.set_session_id(p_session_id);
18992: --bug3940999 This code used to be down, moved it up
18993: IF order_sch_wb.mr_debug in ('T','C') THEN

Line 19014: from v$parameter

19010: x_spid_des := l_spid; --ATP Debug Workflow
19011:
19012: SELECT value
19013: INTO x_trace_loc_des
19014: from v$parameter
19015: WHERE name = 'user_dump_dest'; --ATP Debug Workflow
19016:
19017: IF PG_DEBUG in ('Y', 'C') THEN
19018: msc_sch_wb.atp_debug('Call_Schedule_Remote: ' || 'spid: ' || l_spid);