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_DIAG_REPORT_FACTORY dependencies on JTF_VARCHAR2_TABLE_4000

Line 185: FUNCTION CREATE_FORM(heading VARCHAR2,form_keys JTF_VARCHAR2_TABLE_4000, form_values JTF_VARCHAR2_TABLE_4000,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_FORM

181: RAISE_APPLICATION_ERROR(-20100,'The content provided for the link is null');
182: END IF;
183: RETURN link_component;
184: END CREATE_LINK;
185: FUNCTION CREATE_FORM(heading VARCHAR2,form_keys JTF_VARCHAR2_TABLE_4000, form_values JTF_VARCHAR2_TABLE_4000,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_FORM
186: IS
187: form_component JTF_DIAG_FORM;
188: form_data_component JTF_DIAG_FORMDATA;
189: exec_id NUMBER;

Line 207: FUNCTION CREATE_TABLE(heading VARCHAR2, column_headers JTF_VARCHAR2_TABLE_4000,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_TABLE

203: RAISE_APPLICATION_ERROR(-20100,'The content provided for the form is null');
204: END IF;
205: RETURN form_component;
206: END CREATE_FORM;
207: FUNCTION CREATE_TABLE(heading VARCHAR2, column_headers JTF_VARCHAR2_TABLE_4000,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_TABLE
208: IS
209: table_component JTF_DIAG_TABLE;
210: exec_id NUMBER;
211: ui_node_id NUMBER;

Line 235: FUNCTION GET_COLUMN_NAMES(sql_query VARCHAR2) RETURN JTF_VARCHAR2_TABLE_4000

231: END IF;
232: RETURN table_component;
233: END CREATE_TABLE;
234:
235: FUNCTION GET_COLUMN_NAMES(sql_query VARCHAR2) RETURN JTF_VARCHAR2_TABLE_4000
236: IS
237: cursor_id number;
238: columns_describe dbms_sql.desc_tab;
239: column_count number;

Line 241: column_headers JTF_VARCHAR2_TABLE_4000;

237: cursor_id number;
238: columns_describe dbms_sql.desc_tab;
239: column_count number;
240: loop_counter number;
241: column_headers JTF_VARCHAR2_TABLE_4000;
242: BEGIN
243: column_headers := JTF_VARCHAR2_TABLE_4000();
244: cursor_id := DBMS_SQL.OPEN_CURSOR;
245: DBMS_SQL.PARSE(cursor_id, sql_query, DBMS_SQL.V7);

Line 243: column_headers := JTF_VARCHAR2_TABLE_4000();

239: column_count number;
240: loop_counter number;
241: column_headers JTF_VARCHAR2_TABLE_4000;
242: BEGIN
243: column_headers := JTF_VARCHAR2_TABLE_4000();
244: cursor_id := DBMS_SQL.OPEN_CURSOR;
245: DBMS_SQL.PARSE(cursor_id, sql_query, DBMS_SQL.V7);
246: DBMS_SQL.DESCRIBE_COLUMNS(cursor_id, column_count, columns_describe);
247: FOR loop_counter in 1..column_count

Line 257: FUNCTION CREATE_TABLE(heading VARCHAR2, column_headers JTF_VARCHAR2_TABLE_4000, sql_query VARCHAR2, report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_TABLE

253: RETURN column_headers;
254: END GET_COLUMN_NAMES;
255:
256:
257: FUNCTION CREATE_TABLE(heading VARCHAR2, column_headers JTF_VARCHAR2_TABLE_4000, sql_query VARCHAR2, report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_TABLE
258: IS
259: table_component JTF_DIAG_TABLE;
260: exec_id NUMBER;
261: ui_node_id NUMBER;

Line 264: table_column_headers JTF_VARCHAR2_TABLE_4000;

260: exec_id NUMBER;
261: ui_node_id NUMBER;
262: no_of_cols NUMBER :=0;
263: table_heading VARCHAR2(4000);
264: table_column_headers JTF_VARCHAR2_TABLE_4000;
265: BEGIN
266: VALIDATE_REPORT_CONTEXT(report_context);
267: IF sql_query IS NULL THEN
268: RAISE_APPLICATION_ERROR(-20100,'The sql query provided for the table is null');

Line 303: table_column_headers JTF_VARCHAR2_TABLE_4000;

299: exec_id NUMBER;
300: ui_node_id NUMBER;
301: no_of_cols NUMBER :=0;
302: table_heading VARCHAR2(4000);
303: table_column_headers JTF_VARCHAR2_TABLE_4000;
304: BEGIN
305: VALIDATE_REPORT_CONTEXT(report_context);
306: IF sql_query IS NULL THEN
307: RAISE_APPLICATION_ERROR(-20100,'The sql query provided for the table is null');

Line 326: FUNCTION CREATE_TABLE(column_headers JTF_VARCHAR2_TABLE_4000,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_TABLE IS

322: table_component := JTF_DIAG_TABLE(exec_id,ui_node_id,table_column_headers,table_heading,sql_query,1,no_of_cols,0,0,null);
323: RETURN table_component;
324: END CREATE_TABLE;
325:
326: FUNCTION CREATE_TABLE(column_headers JTF_VARCHAR2_TABLE_4000,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_TABLE IS
327: table_component JTF_DIAG_TABLE;
328: BEGIN
329: table_component := CREATE_TABLE(null,column_headers,report_context);
330: RETURN table_component;

Line 333: FUNCTION CREATE_TABLE(column_headers JTF_VARCHAR2_TABLE_4000, sql_query VARCHAR2, report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_TABLE IS

329: table_component := CREATE_TABLE(null,column_headers,report_context);
330: RETURN table_component;
331: END CREATE_TABLE;
332:
333: FUNCTION CREATE_TABLE(column_headers JTF_VARCHAR2_TABLE_4000, sql_query VARCHAR2, report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_TABLE IS
334: table_component JTF_DIAG_TABLE;
335: BEGIN
336: table_component := CREATE_TABLE(null,column_headers,sql_query,report_context);
337: RETURN table_component;

Line 351: --cols JTF_VARCHAR2_TABLE_4000;

347: FUNCTION CREATE_ROW(report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_ROW IS
348: row_component JTF_DIAG_ROW;
349: exec_id NUMBER;
350: ui_node_id NUMBER;
351: --cols JTF_VARCHAR2_TABLE_4000;
352: BEGIN
353: VALIDATE_REPORT_CONTEXT(report_context);
354: exec_id := report_context.EXEC_ID;
355: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;

Line 356: --cols := JTF_VARCHAR2_TABLE_4000('');

352: BEGIN
353: VALIDATE_REPORT_CONTEXT(report_context);
354: exec_id := report_context.EXEC_ID;
355: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
356: --cols := JTF_VARCHAR2_TABLE_4000('');
357: row_component := JTF_DIAG_ROW(exec_id,ui_node_id,NULL,0);
358: RETURN row_component;
359: END CREATE_ROW;
360: FUNCTION CREATE_TREE(heading VARCHAR2,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_TREE IS

Line 399: link_ids JTF_VARCHAR2_TABLE_4000;

395: note_component JTF_DIAG_NOTE;
396: exec_id NUMBER;
397: ui_node_id NUMBER;
398: no_of_links NUMBER;
399: link_ids JTF_VARCHAR2_TABLE_4000;
400: note_content VARCHAR2(20000);
401: content_lenght NUMBER;
402: BEGIN
403: VALIDATE_REPORT_CONTEXT(report_context);

Line 410: link_ids := JTF_VARCHAR2_TABLE_4000();

406: exec_id := report_context.EXEC_ID;
407: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
408: no_of_links := length(content)-length(replace(content,'?',''));
409: IF no_of_links > 0 THEN
410: link_ids := JTF_VARCHAR2_TABLE_4000();
411: FOR x IN 1 .. no_of_links
412: LOOP
413: link_ids.EXTEND;
414: link_ids(x) := '0';