eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_ATP_PVT dependencies on DBMS_SQL

Line 18123: C := DBMS_SQL.OPEN_CURSOR;

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;
18124: -- STATEMENT := 'ALTER SESSION SET SQL_TRACE=TRUE';
18125: STATEMENT := 'ALTER SESSION SET events ' || '''' || '10046 trace name context forever, level 12' || '''' ;
18126: DBMS_SQL.PARSE(C, STATEMENT, DBMS_SQL.NATIVE);
18127: ROWS_PROCESSED := DBMS_SQL.EXECUTE(C);

Line 18126: DBMS_SQL.PARSE(C, STATEMENT, DBMS_SQL.NATIVE);

18122: END IF;
18123: C := DBMS_SQL.OPEN_CURSOR;
18124: -- STATEMENT := 'ALTER SESSION SET SQL_TRACE=TRUE';
18125: STATEMENT := 'ALTER SESSION SET events ' || '''' || '10046 trace name context forever, level 12' || '''' ;
18126: DBMS_SQL.PARSE(C, STATEMENT, DBMS_SQL.NATIVE);
18127: ROWS_PROCESSED := DBMS_SQL.EXECUTE(C);
18128: DBMS_SQL.CLOSE_CURSOR(C);
18129:
18130: -- rajjain 12/20/2002

Line 18127: ROWS_PROCESSED := DBMS_SQL.EXECUTE(C);

18123: C := DBMS_SQL.OPEN_CURSOR;
18124: -- STATEMENT := 'ALTER SESSION SET SQL_TRACE=TRUE';
18125: STATEMENT := 'ALTER SESSION SET events ' || '''' || '10046 trace name context forever, level 12' || '''' ;
18126: DBMS_SQL.PARSE(C, STATEMENT, DBMS_SQL.NATIVE);
18127: ROWS_PROCESSED := DBMS_SQL.EXECUTE(C);
18128: DBMS_SQL.CLOSE_CURSOR(C);
18129:
18130: -- rajjain 12/20/2002
18131: SELECT spid

Line 18128: DBMS_SQL.CLOSE_CURSOR(C);

18124: -- STATEMENT := 'ALTER SESSION SET SQL_TRACE=TRUE';
18125: STATEMENT := 'ALTER SESSION SET events ' || '''' || '10046 trace name context forever, level 12' || '''' ;
18126: DBMS_SQL.PARSE(C, STATEMENT, DBMS_SQL.NATIVE);
18127: ROWS_PROCESSED := DBMS_SQL.EXECUTE(C);
18128: DBMS_SQL.CLOSE_CURSOR(C);
18129:
18130: -- rajjain 12/20/2002
18131: SELECT spid
18132: INTO l_spid

Line 18286: C := DBMS_SQL.OPEN_CURSOR;

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;
18287: -- STATEMENT := 'ALTER SESSION SET SQL_TRACE=TRUE';
18288: STATEMENT := 'ALTER SESSION SET events ' || '''' || '10046 trace name context forever, level 12' || '''' ;
18289: DBMS_SQL.PARSE(C, STATEMENT, DBMS_SQL.NATIVE);
18290: ROWS_PROCESSED := DBMS_SQL.EXECUTE(C);

Line 18289: DBMS_SQL.PARSE(C, STATEMENT, DBMS_SQL.NATIVE);

18285: END IF;
18286: C := DBMS_SQL.OPEN_CURSOR;
18287: -- STATEMENT := 'ALTER SESSION SET SQL_TRACE=TRUE';
18288: STATEMENT := 'ALTER SESSION SET events ' || '''' || '10046 trace name context forever, level 12' || '''' ;
18289: DBMS_SQL.PARSE(C, STATEMENT, DBMS_SQL.NATIVE);
18290: ROWS_PROCESSED := DBMS_SQL.EXECUTE(C);
18291: DBMS_SQL.CLOSE_CURSOR(C);
18292:
18293: -- rajjain 12/20/2002

Line 18290: ROWS_PROCESSED := DBMS_SQL.EXECUTE(C);

18286: C := DBMS_SQL.OPEN_CURSOR;
18287: -- STATEMENT := 'ALTER SESSION SET SQL_TRACE=TRUE';
18288: STATEMENT := 'ALTER SESSION SET events ' || '''' || '10046 trace name context forever, level 12' || '''' ;
18289: DBMS_SQL.PARSE(C, STATEMENT, DBMS_SQL.NATIVE);
18290: ROWS_PROCESSED := DBMS_SQL.EXECUTE(C);
18291: DBMS_SQL.CLOSE_CURSOR(C);
18292:
18293: -- rajjain 12/20/2002
18294: SELECT spid

Line 18291: DBMS_SQL.CLOSE_CURSOR(C);

18287: -- STATEMENT := 'ALTER SESSION SET SQL_TRACE=TRUE';
18288: STATEMENT := 'ALTER SESSION SET events ' || '''' || '10046 trace name context forever, level 12' || '''' ;
18289: DBMS_SQL.PARSE(C, STATEMENT, DBMS_SQL.NATIVE);
18290: ROWS_PROCESSED := DBMS_SQL.EXECUTE(C);
18291: DBMS_SQL.CLOSE_CURSOR(C);
18292:
18293: -- rajjain 12/20/2002
18294: SELECT spid
18295: INTO l_spid

Line 18498: C := DBMS_SQL.OPEN_CURSOR;

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;
18499: STATEMENT := 'ALTER SESSION SET SQL_TRACE=FALSE';
18500: DBMS_SQL.PARSE(C, STATEMENT, DBMS_SQL.NATIVE);
18501: ROWS_PROCESSED := DBMS_SQL.EXECUTE(C);
18502: DBMS_SQL.CLOSE_CURSOR(C);

Line 18500: DBMS_SQL.PARSE(C, STATEMENT, DBMS_SQL.NATIVE);

18496: msc_sch_wb.atp_debug('Call_Schedule_Remote: ' || 'Database Trace disabled');
18497: END IF;
18498: C := DBMS_SQL.OPEN_CURSOR;
18499: STATEMENT := 'ALTER SESSION SET SQL_TRACE=FALSE';
18500: DBMS_SQL.PARSE(C, STATEMENT, DBMS_SQL.NATIVE);
18501: ROWS_PROCESSED := DBMS_SQL.EXECUTE(C);
18502: DBMS_SQL.CLOSE_CURSOR(C);
18503: END IF;
18504:

Line 18501: ROWS_PROCESSED := DBMS_SQL.EXECUTE(C);

18497: END IF;
18498: C := DBMS_SQL.OPEN_CURSOR;
18499: STATEMENT := 'ALTER SESSION SET SQL_TRACE=FALSE';
18500: DBMS_SQL.PARSE(C, STATEMENT, DBMS_SQL.NATIVE);
18501: ROWS_PROCESSED := DBMS_SQL.EXECUTE(C);
18502: DBMS_SQL.CLOSE_CURSOR(C);
18503: END IF;
18504:
18505: IF PG_DEBUG in ('Y', 'C') THEN

Line 18502: DBMS_SQL.CLOSE_CURSOR(C);

18498: C := DBMS_SQL.OPEN_CURSOR;
18499: STATEMENT := 'ALTER SESSION SET SQL_TRACE=FALSE';
18500: DBMS_SQL.PARSE(C, STATEMENT, DBMS_SQL.NATIVE);
18501: ROWS_PROCESSED := DBMS_SQL.EXECUTE(C);
18502: DBMS_SQL.CLOSE_CURSOR(C);
18503: END IF;
18504:
18505: IF PG_DEBUG in ('Y', 'C') THEN
18506: msc_sch_wb.atp_debug('***** End Call_Schedule_Remote Procedure *****');