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 205: 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

201: RAISE_APPLICATION_ERROR(-20100,'The content provided for the link is null');
202: END IF;
203: RETURN link_component;
204: END CREATE_LINK;
205: 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
206: IS
207: form_component JTF_DIAG_FORM;
208: form_data_component JTF_DIAG_FORMDATA;
209: exec_id NUMBER;

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

223: RAISE_APPLICATION_ERROR(-20100,'The content provided for the form is null');
224: END IF;
225: RETURN form_component;
226: END CREATE_FORM;
227: FUNCTION CREATE_TABLE(heading VARCHAR2, column_headers JTF_VARCHAR2_TABLE_4000,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_TABLE
228: IS
229: table_component JTF_DIAG_TABLE;
230: exec_id NUMBER;
231: ui_node_id NUMBER;

Line 255: FUNCTION GET_COLUMN_NAMES(sql_query VARCHAR2) RETURN JTF_VARCHAR2_TABLE_4000

251: END IF;
252: RETURN table_component;
253: END CREATE_TABLE;
254:
255: FUNCTION GET_COLUMN_NAMES(sql_query VARCHAR2) RETURN JTF_VARCHAR2_TABLE_4000
256: IS
257: cursor_id number;
258: columns_describe dbms_sql.desc_tab;
259: column_count number;

Line 261: column_headers JTF_VARCHAR2_TABLE_4000;

257: cursor_id number;
258: columns_describe dbms_sql.desc_tab;
259: column_count number;
260: loop_counter number;
261: column_headers JTF_VARCHAR2_TABLE_4000;
262: BEGIN
263: column_headers := JTF_VARCHAR2_TABLE_4000();
264: cursor_id := DBMS_SQL.OPEN_CURSOR;
265: DBMS_SQL.PARSE(cursor_id, sql_query, DBMS_SQL.V7);

Line 263: column_headers := JTF_VARCHAR2_TABLE_4000();

259: column_count number;
260: loop_counter number;
261: column_headers JTF_VARCHAR2_TABLE_4000;
262: BEGIN
263: column_headers := JTF_VARCHAR2_TABLE_4000();
264: cursor_id := DBMS_SQL.OPEN_CURSOR;
265: DBMS_SQL.PARSE(cursor_id, sql_query, DBMS_SQL.V7);
266: DBMS_SQL.DESCRIBE_COLUMNS(cursor_id, column_count, columns_describe);
267: FOR loop_counter in 1..column_count

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

273: RETURN column_headers;
274: END GET_COLUMN_NAMES;
275:
276:
277: FUNCTION CREATE_TABLE(heading VARCHAR2, column_headers JTF_VARCHAR2_TABLE_4000, sql_query VARCHAR2, report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_TABLE
278: IS
279: table_component JTF_DIAG_TABLE;
280: exec_id NUMBER;
281: ui_node_id NUMBER;

Line 284: table_column_headers JTF_VARCHAR2_TABLE_4000;

280: exec_id NUMBER;
281: ui_node_id NUMBER;
282: no_of_cols NUMBER :=0;
283: table_heading VARCHAR2(4000);
284: table_column_headers JTF_VARCHAR2_TABLE_4000;
285: BEGIN
286: VALIDATE_REPORT_CONTEXT(report_context);
287: IF sql_query IS NULL THEN
288: RAISE_APPLICATION_ERROR(-20100,'The sql query provided for the table is null');

Line 323: table_column_headers JTF_VARCHAR2_TABLE_4000;

319: exec_id NUMBER;
320: ui_node_id NUMBER;
321: no_of_cols NUMBER :=0;
322: table_heading VARCHAR2(4000);
323: table_column_headers JTF_VARCHAR2_TABLE_4000;
324: BEGIN
325: VALIDATE_REPORT_CONTEXT(report_context);
326: IF sql_query IS NULL THEN
327: RAISE_APPLICATION_ERROR(-20100,'The sql query provided for the table is null');

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

342: table_component := JTF_DIAG_TABLE(exec_id,ui_node_id,table_column_headers,table_heading,sql_query,1,no_of_cols,0,0,null);
343: RETURN table_component;
344: END CREATE_TABLE;
345:
346: FUNCTION CREATE_TABLE(column_headers JTF_VARCHAR2_TABLE_4000,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_TABLE IS
347: table_component JTF_DIAG_TABLE;
348: BEGIN
349: table_component := CREATE_TABLE(null,column_headers,report_context);
350: RETURN table_component;

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

349: table_component := CREATE_TABLE(null,column_headers,report_context);
350: RETURN table_component;
351: END CREATE_TABLE;
352:
353: FUNCTION CREATE_TABLE(column_headers JTF_VARCHAR2_TABLE_4000, sql_query VARCHAR2, report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_TABLE IS
354: table_component JTF_DIAG_TABLE;
355: BEGIN
356: table_component := CREATE_TABLE(null,column_headers,sql_query,report_context);
357: RETURN table_component;

Line 371: --cols JTF_VARCHAR2_TABLE_4000;

367: FUNCTION CREATE_ROW(report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_ROW IS
368: row_component JTF_DIAG_ROW;
369: exec_id NUMBER;
370: ui_node_id NUMBER;
371: --cols JTF_VARCHAR2_TABLE_4000;
372: BEGIN
373: VALIDATE_REPORT_CONTEXT(report_context);
374: exec_id := report_context.EXEC_ID;
375: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;

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

372: BEGIN
373: VALIDATE_REPORT_CONTEXT(report_context);
374: exec_id := report_context.EXEC_ID;
375: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
376: --cols := JTF_VARCHAR2_TABLE_4000('');
377: row_component := JTF_DIAG_ROW(exec_id,ui_node_id,NULL,0);
378: RETURN row_component;
379: END CREATE_ROW;
380: FUNCTION CREATE_TREE(heading VARCHAR2,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_TREE IS

Line 419: link_ids JTF_VARCHAR2_TABLE_4000;

415: note_component JTF_DIAG_NOTE;
416: exec_id NUMBER;
417: ui_node_id NUMBER;
418: no_of_links NUMBER;
419: link_ids JTF_VARCHAR2_TABLE_4000;
420: note_content VARCHAR2(20000);
421: content_lenght NUMBER;
422: BEGIN
423: VALIDATE_REPORT_CONTEXT(report_context);

Line 430: link_ids := JTF_VARCHAR2_TABLE_4000();

426: exec_id := report_context.EXEC_ID;
427: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
428: no_of_links := length(content)-length(replace(content,'?',''));
429: IF no_of_links > 0 THEN
430: link_ids := JTF_VARCHAR2_TABLE_4000();
431: FOR x IN 1 .. no_of_links
432: LOOP
433: link_ids.EXTEND;
434: link_ids(x) := '0';