[Home] [Help]
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
18120: IF PG_DEBUG in ('Y', 'C') THEN
18121: msc_sch_wb.atp_debug('Call_Schedule_Remote: ' || 'Database Trace being enabled');
18122: END IF;
18123: C := DBMS_SQL.OPEN_CURSOR;
18146:
18147: END IF;
18148:
18149: IF PG_DEBUG in ('Y', 'C') THEN --bug3940999
18150: msc_sch_wb.atp_debug('Call_Schedule_Remote: ' || 'G_SESSION_ID : ' || order_sch_wb.debug_session_id);
18151: msc_sch_wb.atp_debug('***** Begin Call_Schedule_Remote Procedure *****');
18152: msc_sch_wb.atp_debug('Call_Schedule_Remote: ' || 'p_node_id : ' || p_node_id );
18153: msc_sch_wb.atp_debug('Call_Schedule_Remote: ' || 'p_session_id : ' || p_session_id );
18154: msc_sch_wb.atp_debug('Call_Schedule_Remote: ' || 'p_instance_id : ' || p_instance_id );
18267: END IF;
18268:
18269: msc_sch_wb.set_session_id(p_session_id);
18270: IF PG_DEBUG in ('Y', 'C') THEN
18271: msc_sch_wb.atp_debug('Call_Schedule_Remote: ' || 'G_SESSION_ID : ' || order_sch_wb.debug_session_id);
18272: END IF;
18273:
18274: -- Fixed as part of Fix for Bug 3444096, need to set profile value as it is queried again in msc_wf_alloc_atp.start_mscatp_wf
18275: IF p_atp_workflow IS NOT NULL THEN
18278: END IF;
18279:
18280: -- Bug 2387242 : krajan
18281: -- Set Sql Trace.
18282: IF order_sch_wb.mr_debug in ('T','C') THEN
18283: IF PG_DEBUG in ('Y', 'C') THEN
18284: msc_sch_wb.atp_debug('Call_Schedule_Remote: ' || 'Database Trace being enabled');
18285: END IF;
18286: C := DBMS_SQL.OPEN_CURSOR;
18490: END IF;
18491:
18492: -- Bug 2387242 : krajan
18493: -- Set Sql Trace.
18494: IF order_sch_wb.mr_debug in ('T','C') THEN
18495: IF PG_DEBUG in ('Y', 'C') THEN
18496: msc_sch_wb.atp_debug('Call_Schedule_Remote: ' || 'Database Trace disabled');
18497: END IF;
18498: C := DBMS_SQL.OPEN_CURSOR;