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.JTF_DIAGNOSTIC_ADAPTUTIL dependencies on DUAL

Line 484: select vsize(tempReportStr) into strSize from dual;

480: tempReportStr := concat('',tempReportStr);
481: tempReportStr := concat(tempReportStr, '');
482:
483: dbms_lob.createTemporary(tempClob,true,dbms_lob.call);
484: select vsize(tempReportStr) into strSize from dual;
485: dbms_lob.write(tempClob,strSize,1,tempReportStr);
486: dbms_lob.append(reportClob,tempClob);
487: END IF;
488: END IF;

Line 513: select vsize(tmpReportStr) into strSize from dual;

509: b_html_on := TRUE;
510: END IF;
511: dbms_lob.createTemporary(tempClob,true,dbms_lob.call);
512: tmpReportStr := reportStr;
513: select vsize(tmpReportStr) into strSize from dual;
514: dbms_lob.write(tempClob,strSize,1,tmpReportStr);
515: dbms_lob.append(reportClob,tempClob);
516: END IF;
517: EXCEPTION

Line 777: select dbms_lob.getlength(arg1) into strSizeArg1 from dual;

773: retval INTEGER;
774: strSizeArg1 INTEGER;
775: strSizeArg2 INTEGER;
776: BEGIN
777: select dbms_lob.getlength(arg1) into strSizeArg1 from dual;
778: select dbms_lob.getlength(arg2) into strSizeArg2 from dual;
779: retval := dbms_lob.compare(arg1,arg2,strSizeArg1,1,1);
780: IF (retval = 0) THEN
781: assert(message,TRUE);

Line 778: select dbms_lob.getlength(arg2) into strSizeArg2 from dual;

774: strSizeArg1 INTEGER;
775: strSizeArg2 INTEGER;
776: BEGIN
777: select dbms_lob.getlength(arg1) into strSizeArg1 from dual;
778: select dbms_lob.getlength(arg2) into strSizeArg2 from dual;
779: retval := dbms_lob.compare(arg1,arg2,strSizeArg1,1,1);
780: IF (retval = 0) THEN
781: assert(message,TRUE);
782: ELSE

Line 859: select dbms_lob.getlength(arg1) into strSizeArg1 from dual;

855: retval INTEGER;
856: strSizeArg1 INTEGER;
857: strSizeArg2 INTEGER;
858: BEGIN
859: select dbms_lob.getlength(arg1) into strSizeArg1 from dual;
860: select dbms_lob.getlength(arg2) into strSizeArg2 from dual;
861: retval := dbms_lob.compare(arg1,arg2,strSizeArg1,1,1);
862: IF (retval = 0) THEN
863: assert(message,TRUE);

Line 860: select dbms_lob.getlength(arg2) into strSizeArg2 from dual;

856: strSizeArg1 INTEGER;
857: strSizeArg2 INTEGER;
858: BEGIN
859: select dbms_lob.getlength(arg1) into strSizeArg1 from dual;
860: select dbms_lob.getlength(arg2) into strSizeArg2 from dual;
861: retval := dbms_lob.compare(arg1,arg2,strSizeArg1,1,1);
862: IF (retval = 0) THEN
863: assert(message,TRUE);
864: ELSE