[Home] [Help]
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
18994: IF PG_DEBUG in ('Y', 'C') THEN
18995: msc_sch_wb.atp_debug('Call_Schedule_Remote: ' || 'Database Trace being enabled');
18996: END IF;
18997: C := DBMS_SQL.OPEN_CURSOR;
19020:
19021: END IF;
19022:
19023: IF PG_DEBUG in ('Y', 'C') THEN --bug3940999
19024: msc_sch_wb.atp_debug('Call_Schedule_Remote: ' || 'G_SESSION_ID : ' || order_sch_wb.debug_session_id);
19025: msc_sch_wb.atp_debug('***** Begin Call_Schedule_Remote Procedure *****');
19026: msc_sch_wb.atp_debug('Call_Schedule_Remote: ' || 'p_node_id : ' || p_node_id );
19027: msc_sch_wb.atp_debug('Call_Schedule_Remote: ' || 'p_session_id : ' || p_session_id );
19028: msc_sch_wb.atp_debug('Call_Schedule_Remote: ' || 'p_instance_id : ' || p_instance_id );
19147: END IF;
19148:
19149: msc_sch_wb.set_session_id(p_session_id);
19150: IF PG_DEBUG in ('Y', 'C') THEN
19151: msc_sch_wb.atp_debug('Call_Schedule_Remote: ' || 'G_SESSION_ID : ' || order_sch_wb.debug_session_id);
19152: END IF;
19153:
19154: -- 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
19155: IF p_atp_workflow IS NOT NULL THEN
19158: END IF;
19159:
19160: -- Bug 2387242 : krajan
19161: -- Set Sql Trace.
19162: IF order_sch_wb.mr_debug in ('T','C') THEN
19163: IF PG_DEBUG in ('Y', 'C') THEN
19164: msc_sch_wb.atp_debug('Call_Schedule_Remote: ' || 'Database Trace being enabled');
19165: END IF;
19166: C := DBMS_SQL.OPEN_CURSOR;
19370: END IF;
19371:
19372: -- Bug 2387242 : krajan
19373: -- Set Sql Trace.
19374: IF order_sch_wb.mr_debug in ('T','C') THEN
19375: IF PG_DEBUG in ('Y', 'C') THEN
19376: msc_sch_wb.atp_debug('Call_Schedule_Remote: ' || 'Database Trace disabled');
19377: END IF;
19378: C := DBMS_SQL.OPEN_CURSOR;