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_DECLARATIVE_DIAGNOSTIC dependencies on DBMS_SQL

Line 448: v_cursorID := DBMS_SQL.OPEN_CURSOR;

444: || '

', DETAILS_CLOB);
445:
446: -- addStringToClob('ERROR TYPE: ' || '
' || error_type, DETAILS_CLOB);
447:
448: v_cursorID := DBMS_SQL.OPEN_CURSOR;
449: DBMS_SQL.PARSE(v_cursorID, v_sqlstr, DBMS_SQL.V7);
450:
451: -- now bind the values for the column
452: -- values to be retrieved

Line 449: DBMS_SQL.PARSE(v_cursorID, v_sqlstr, DBMS_SQL.V7);

445:
446: -- addStringToClob('ERROR TYPE: ' || '
' || error_type, DETAILS_CLOB);
447:
448: v_cursorID := DBMS_SQL.OPEN_CURSOR;
449: DBMS_SQL.PARSE(v_cursorID, v_sqlstr, DBMS_SQL.V7);
450:
451: -- now bind the values for the column
452: -- values to be retrieved
453:

Line 460: DBMS_SQL.DEFINE_COLUMN(v_cursorID, v_count2, v_selectValue(v_count2), 3000);

456:
457: v_selectValue := JTF_VARCHAR2_TABLE_4000();
458: for v_count2 in 1 .. v_count loop
459: v_selectValue.extend;
460: DBMS_SQL.DEFINE_COLUMN(v_cursorID, v_count2, v_selectValue(v_count2), 3000);
461: end loop;
462:
463: -- execute the dynamically created SQL statement
464: v_dummy := dbms_sql.execute(v_cursorID);

Line 464: v_dummy := dbms_sql.execute(v_cursorID);

460: DBMS_SQL.DEFINE_COLUMN(v_cursorID, v_count2, v_selectValue(v_count2), 3000);
461: end loop;
462:
463: -- execute the dynamically created SQL statement
464: v_dummy := dbms_sql.execute(v_cursorID);
465:
466: -- at this time display the desired values
467: -- for the columns that should be matches
468: -- with the actual values

Line 504: if dbms_sql.fetch_rows(v_cursorID) = 0 then

500:
501: v_count3 := 0;
502: loop
503: -- fetch the rows into the buffer
504: if dbms_sql.fetch_rows(v_cursorID) = 0 then
505: exit;
506: end if;
507:
508: v_count3 := v_count3 + 1;

Line 513: dbms_sql.column_value(v_cursorID, v_count2, v_selectValue(v_count2));

509:
510: -- fetch the values in the datastructure for rendering
511: -- and comparison...
512: for v_count2 in 1 .. v_count loop
513: dbms_sql.column_value(v_cursorID, v_count2, v_selectValue(v_count2));
514: end loop;
515:
516:
517: -- for each row received compare the values

Line 653: dbms_sql.close_cursor(v_cursorID);

649: addStringToClob('', DETAILS_CLOB);
650:
651: SUMMARY_STRING := SUMMARY_STRING || '';
652: SUMMARY_STRING := SUMMARY_STRING || '';
653: dbms_sql.close_cursor(v_cursorID);
654:
655: EXCEPTION
656: when others then
657: -- close the cursor

Line 658: dbms_sql.close_cursor(v_cursorID);

654:
655: EXCEPTION
656: when others then
657: -- close the cursor
658: dbms_sql.close_cursor(v_cursorID);
659:
660: SUMMARY_STRING := SUMMARY_STRING || '';
661: SUMMARY_STRING := SUMMARY_STRING || '' || (ORDERNUMBER + 1) || '';
662: SUMMARY_STRING := SUMMARY_STRING || '' || teststpname || '';

Line 860: v_cursorID := DBMS_SQL.OPEN_CURSOR;

856: v_sqlstr := v_sqlstr || ' where ' || WHERE_CLAUSE_OR_SQL;
857: end if;
858: end if;
859:
860: v_cursorID := DBMS_SQL.OPEN_CURSOR;
861: DBMS_SQL.PARSE(v_cursorID, v_sqlstr, DBMS_SQL.V7);
862: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 1, v_count);
863: v_count := dbms_sql.execute(v_cursorID);
864:

Line 861: DBMS_SQL.PARSE(v_cursorID, v_sqlstr, DBMS_SQL.V7);

857: end if;
858: end if;
859:
860: v_cursorID := DBMS_SQL.OPEN_CURSOR;
861: DBMS_SQL.PARSE(v_cursorID, v_sqlstr, DBMS_SQL.V7);
862: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 1, v_count);
863: v_count := dbms_sql.execute(v_cursorID);
864:
865: loop

Line 862: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 1, v_count);

858: end if;
859:
860: v_cursorID := DBMS_SQL.OPEN_CURSOR;
861: DBMS_SQL.PARSE(v_cursorID, v_sqlstr, DBMS_SQL.V7);
862: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 1, v_count);
863: v_count := dbms_sql.execute(v_cursorID);
864:
865: loop
866: -- fetch the rows into the buffer

Line 863: v_count := dbms_sql.execute(v_cursorID);

859:
860: v_cursorID := DBMS_SQL.OPEN_CURSOR;
861: DBMS_SQL.PARSE(v_cursorID, v_sqlstr, DBMS_SQL.V7);
862: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 1, v_count);
863: v_count := dbms_sql.execute(v_cursorID);
864:
865: loop
866: -- fetch the rows into the buffer
867: if dbms_sql.fetch_rows(v_cursorID) = 0 then

Line 867: if dbms_sql.fetch_rows(v_cursorID) = 0 then

863: v_count := dbms_sql.execute(v_cursorID);
864:
865: loop
866: -- fetch the rows into the buffer
867: if dbms_sql.fetch_rows(v_cursorID) = 0 then
868: exit;
869: end if;
870: dbms_sql.column_value(v_cursorID, 1, v_count);
871: end loop;

Line 870: dbms_sql.column_value(v_cursorID, 1, v_count);

866: -- fetch the rows into the buffer
867: if dbms_sql.fetch_rows(v_cursorID) = 0 then
868: exit;
869: end if;
870: dbms_sql.column_value(v_cursorID, 1, v_count);
871: end loop;
872:
873:
874: v_header := '

1092: ||'">STEP NAME: ' || '

' || (ORDERNUMBER + 1)|| ': ' || teststpname;

Line 1089: v_count := DBMS_SQL.EXECUTE_AND_FETCH(v_cursorID);

1085: v_sqlstr := WHERE_CLAUSE_OR_SQL;
1086: v_cursorID := DBMS_SQL.OPEN_CURSOR;
1087:
1088: DBMS_SQL.PARSE(v_cursorID, v_sqlstr, DBMS_SQL.V7);
1089: v_count := DBMS_SQL.EXECUTE_AND_FETCH(v_cursorID);
1090:
1091: v_header := '

STEP NAME: ' || '

' || (ORDERNUMBER + 1)|| ': ' || teststpname;
1093:

Line 1167: dbms_sql.close_cursor(v_cursorID);

1163:
1164: DETAILS_STRING := DETAILS_STRING || v_sqlstr;
1165: DETAILS_STRING := DETAILS_STRING || '';
1166:
1167: dbms_sql.close_cursor(v_cursorID);
1168:
1169: END run_or_validate_rec_norec;
1170:
1171: