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 18997: C := DBMS_SQL.OPEN_CURSOR;

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

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

18996: END IF;
18997: C := DBMS_SQL.OPEN_CURSOR;
18998: -- STATEMENT := 'ALTER SESSION SET SQL_TRACE=TRUE';
18999: STATEMENT := 'ALTER SESSION SET events ' || '''' || '10046 trace name context forever, level 12' || '''' ;
19000: DBMS_SQL.PARSE(C, STATEMENT, DBMS_SQL.NATIVE);
19001: ROWS_PROCESSED := DBMS_SQL.EXECUTE(C);
19002: DBMS_SQL.CLOSE_CURSOR(C);
19003:
19004: -- rajjain 12/20/2002

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

18997: C := DBMS_SQL.OPEN_CURSOR;
18998: -- STATEMENT := 'ALTER SESSION SET SQL_TRACE=TRUE';
18999: STATEMENT := 'ALTER SESSION SET events ' || '''' || '10046 trace name context forever, level 12' || '''' ;
19000: DBMS_SQL.PARSE(C, STATEMENT, DBMS_SQL.NATIVE);
19001: ROWS_PROCESSED := DBMS_SQL.EXECUTE(C);
19002: DBMS_SQL.CLOSE_CURSOR(C);
19003:
19004: -- rajjain 12/20/2002
19005: SELECT spid

Line 19002: DBMS_SQL.CLOSE_CURSOR(C);

18998: -- STATEMENT := 'ALTER SESSION SET SQL_TRACE=TRUE';
18999: STATEMENT := 'ALTER SESSION SET events ' || '''' || '10046 trace name context forever, level 12' || '''' ;
19000: DBMS_SQL.PARSE(C, STATEMENT, DBMS_SQL.NATIVE);
19001: ROWS_PROCESSED := DBMS_SQL.EXECUTE(C);
19002: DBMS_SQL.CLOSE_CURSOR(C);
19003:
19004: -- rajjain 12/20/2002
19005: SELECT spid
19006: INTO l_spid

Line 19166: C := DBMS_SQL.OPEN_CURSOR;

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

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

19165: END IF;
19166: C := DBMS_SQL.OPEN_CURSOR;
19167: -- STATEMENT := 'ALTER SESSION SET SQL_TRACE=TRUE';
19168: STATEMENT := 'ALTER SESSION SET events ' || '''' || '10046 trace name context forever, level 12' || '''' ;
19169: DBMS_SQL.PARSE(C, STATEMENT, DBMS_SQL.NATIVE);
19170: ROWS_PROCESSED := DBMS_SQL.EXECUTE(C);
19171: DBMS_SQL.CLOSE_CURSOR(C);
19172:
19173: -- rajjain 12/20/2002

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

19166: C := DBMS_SQL.OPEN_CURSOR;
19167: -- STATEMENT := 'ALTER SESSION SET SQL_TRACE=TRUE';
19168: STATEMENT := 'ALTER SESSION SET events ' || '''' || '10046 trace name context forever, level 12' || '''' ;
19169: DBMS_SQL.PARSE(C, STATEMENT, DBMS_SQL.NATIVE);
19170: ROWS_PROCESSED := DBMS_SQL.EXECUTE(C);
19171: DBMS_SQL.CLOSE_CURSOR(C);
19172:
19173: -- rajjain 12/20/2002
19174: SELECT spid

Line 19171: DBMS_SQL.CLOSE_CURSOR(C);

19167: -- STATEMENT := 'ALTER SESSION SET SQL_TRACE=TRUE';
19168: STATEMENT := 'ALTER SESSION SET events ' || '''' || '10046 trace name context forever, level 12' || '''' ;
19169: DBMS_SQL.PARSE(C, STATEMENT, DBMS_SQL.NATIVE);
19170: ROWS_PROCESSED := DBMS_SQL.EXECUTE(C);
19171: DBMS_SQL.CLOSE_CURSOR(C);
19172:
19173: -- rajjain 12/20/2002
19174: SELECT spid
19175: INTO l_spid

Line 19378: C := DBMS_SQL.OPEN_CURSOR;

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;
19379: STATEMENT := 'ALTER SESSION SET SQL_TRACE=FALSE';
19380: DBMS_SQL.PARSE(C, STATEMENT, DBMS_SQL.NATIVE);
19381: ROWS_PROCESSED := DBMS_SQL.EXECUTE(C);
19382: DBMS_SQL.CLOSE_CURSOR(C);

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

19376: msc_sch_wb.atp_debug('Call_Schedule_Remote: ' || 'Database Trace disabled');
19377: END IF;
19378: C := DBMS_SQL.OPEN_CURSOR;
19379: STATEMENT := 'ALTER SESSION SET SQL_TRACE=FALSE';
19380: DBMS_SQL.PARSE(C, STATEMENT, DBMS_SQL.NATIVE);
19381: ROWS_PROCESSED := DBMS_SQL.EXECUTE(C);
19382: DBMS_SQL.CLOSE_CURSOR(C);
19383: END IF;
19384:

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

19377: END IF;
19378: C := DBMS_SQL.OPEN_CURSOR;
19379: STATEMENT := 'ALTER SESSION SET SQL_TRACE=FALSE';
19380: DBMS_SQL.PARSE(C, STATEMENT, DBMS_SQL.NATIVE);
19381: ROWS_PROCESSED := DBMS_SQL.EXECUTE(C);
19382: DBMS_SQL.CLOSE_CURSOR(C);
19383: END IF;
19384:
19385: IF PG_DEBUG in ('Y', 'C') THEN

Line 19382: DBMS_SQL.CLOSE_CURSOR(C);

19378: C := DBMS_SQL.OPEN_CURSOR;
19379: STATEMENT := 'ALTER SESSION SET SQL_TRACE=FALSE';
19380: DBMS_SQL.PARSE(C, STATEMENT, DBMS_SQL.NATIVE);
19381: ROWS_PROCESSED := DBMS_SQL.EXECUTE(C);
19382: DBMS_SQL.CLOSE_CURSOR(C);
19383: END IF;
19384:
19385: IF PG_DEBUG in ('Y', 'C') THEN
19386: msc_sch_wb.atp_debug('***** End Call_Schedule_Remote Procedure *****');