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 DBMS_LOB

Line 250: dbms_lob.createTemporary(temp,true,dbms_lob.call);

246:
247: FUNCTION initReportClob RETURN CLOB IS
248: temp CLOB;
249: BEGIN
250: dbms_lob.createTemporary(temp,true,dbms_lob.call);
251: return temp;
252: EXCEPTION
253: WHEN others THEN
254: -- logging here

Line 483: dbms_lob.createTemporary(tempClob,true,dbms_lob.call);

479:
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;

Line 485: dbms_lob.write(tempClob,strSize,1,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;
489: EXCEPTION

Line 486: dbms_lob.append(reportClob,tempClob);

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;
489: EXCEPTION
490: WHEN others THEN

Line 508: IF (UPPER(reportStr) = UPPER('@HTML')) AND (DBMS_LOB.GETLENGTH(reportClob) = 0) THEN

504: strSize INTEGER;
505: tmpReportStr LONG;
506: BEGIN
507: IF reportStr IS NOT NULL THEN
508: IF (UPPER(reportStr) = UPPER('@HTML')) AND (DBMS_LOB.GETLENGTH(reportClob) = 0) THEN
509: b_html_on := TRUE;
510: END IF;
511: dbms_lob.createTemporary(tempClob,true,dbms_lob.call);
512: tmpReportStr := reportStr;

Line 511: dbms_lob.createTemporary(tempClob,true,dbms_lob.call);

507: IF reportStr IS NOT NULL THEN
508: IF (UPPER(reportStr) = UPPER('@HTML')) AND (DBMS_LOB.GETLENGTH(reportClob) = 0) THEN
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);

Line 514: dbms_lob.write(tempClob,strSize,1,tmpReportStr);

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
518: WHEN others THEN

Line 515: dbms_lob.append(reportClob,tempClob);

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
518: WHEN others THEN
519: -- logging here...

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 779: retval := dbms_lob.compare(arg1,arg2,strSizeArg1,1,1);

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
783: assert(message,FALSE);

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

Line 861: retval := dbms_lob.compare(arg1,arg2,strSizeArg1,1,1);

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
865: assert(message,FALSE);