18111: IF PG_DEBUG in ('Y', 'C') THEN
18112: --ATP Debug Workflow
18113: select ltrim(rtrim(substr(value, instr(value,',',-1,1)+1)))
18114: into x_session_loc_des
18115: from v$parameter where name= 'utl_file_dir';
18116: END IF;
18117: msc_sch_wb.set_session_id(p_session_id);
18118: --bug3940999 This code used to be down, moved it up
18119: IF order_sch_wb.mr_debug in ('T','C') THEN
18136: x_spid_des := l_spid; --ATP Debug Workflow
18137:
18138: SELECT value
18139: INTO x_trace_loc_des
18140: from v$parameter
18141: WHERE name = 'user_dump_dest'; --ATP Debug Workflow
18142:
18143: IF PG_DEBUG in ('Y', 'C') THEN
18144: msc_sch_wb.atp_debug('Call_Schedule_Remote: ' || 'spid: ' || l_spid);