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 DUAL

Line 40: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;

36: EXCEPTION
37: WHEN OTHERS THEN
38: diag_com_url := 'https://communities.oracle.com/portal/server.pt/community/Diagnosibility/242';
39: END;
40: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
41: note_component := CREATE_NOTE(footer_content, report_context);
42: link_component := CREATE_LINK('Community', diag_com_url, report_context);
43: note_component.set_link(temp, link_component);
44: footer_component := JTF_DIAG_FOOTER(exec_id,ui_node_id,footer_content,footer_note_id, 0);

Line 62: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;

58: VALIDATE_REPORT_CONTEXT(report_context);
59: IF header IS NOT NULL THEN
60: header_content := DBMS_XMLGEN.CONVERT(header,0);
61: exec_id := report_context.EXEC_ID;
62: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
63: header_component := JTF_DIAG_HEADER(exec_id,ui_node_id,header_content,0);
64: ELSE
65: RAISE_APPLICATION_ERROR(-20100,'The content provided for the header is null');
66: END IF;

Line 80: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;

76: VALIDATE_REPORT_CONTEXT(report_context);
77: IF heading IS NOT NULL THEN
78: section_heading := DBMS_XMLGEN.CONVERT(heading,0);
79: exec_id := report_context.EXEC_ID;
80: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
81: section_component := JTF_DIAG_SECTION(exec_id,ui_node_id,section_heading,0);
82: ELSE
83: RAISE_APPLICATION_ERROR(-20100,'Heading of the Section is null');
84: END IF;

Line 98: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;

94: VALIDATE_REPORT_CONTEXT(report_context);
95: IF message IS NOT NULL THEN
96: message_content := DBMS_XMLGEN.CONVERT(message,0);
97: exec_id := report_context.EXEC_ID;
98: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
99: IF message_type IS NOT NULL AND (message_type = 'info' OR message_type = 'warning' OR message_type = 'error' OR message_type = 'attention') THEN
100: message_component := JTF_DIAG_MESSAGE(exec_id,ui_node_id,message_content,message_type,null,0,0,0);
101: ELSE
102: RAISE_APPLICATION_ERROR(-20100,'The message type '|| message_type||' is wrong: It can only be info, warning or error');

Line 123: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;

119: VALIDATE_REPORT_CONTEXT(report_context);
120: IF note IS NOT NULL THEN
121: message_note_id := note.UI_NODE_ID;
122: exec_id := report_context.EXEC_ID;
123: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
124: IF message_type IS NOT NULL AND (message_type = 'info' OR message_type = 'warning' OR message_type = 'error' OR message_type = 'attention') THEN
125: message_component := JTF_DIAG_MESSAGE(exec_id,ui_node_id,message_content,message_type,null,message_note_id,0,0);
126: IF NOTE.ADDED_TO_PARENT <> 1 THEN
127: str := note.CONSTRUCT_NODE;

Line 160: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;

156: VALIDATE_REPORT_CONTEXT(report_context);
157: IF content IS NOT NULL THEN
158: hide_show_content := DBMS_XMLGEN.CONVERT(content,0);
159: exec_id := report_context.EXEC_ID;
160: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
161: hide_show_component := JTF_DIAG_HIDE_SHOW(exec_id,ui_node_id,hide_show_content,'Hide','Show',0);
162: ELSE
163: RAISE_APPLICATION_ERROR(-20100,'The content provided for the hide show is null');
164: END IF;

Line 178: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;

174: VALIDATE_REPORT_CONTEXT(report_context);
175: IF content IS NOT NULL THEN
176: raw_text_content := content;
177: exec_id := report_context.EXEC_ID;
178: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
179: raw_text_component := JTF_DIAG_RAW_TEXT(exec_id,ui_node_id,raw_text_content,0);
180: ELSE
181: RAISE_APPLICATION_ERROR(-20100,'The content provided for the raw text is null');
182: END IF;

Line 198: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;

194: IF linkText IS NOT NULL AND linkURL IS NOT NULL THEN
195: link_text_content := DBMS_XMLGEN.CONVERT(linkText,0);
196: link_url_content := DBMS_XMLGEN.CONVERT(linkURL,0);
197: exec_id := report_context.EXEC_ID;
198: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
199: link_component := JTF_DIAG_LINK(exec_id,ui_node_id,link_text_content,link_url_content,0);
200: ELSE
201: RAISE_APPLICATION_ERROR(-20100,'The content provided for the link is null');
202: END IF;

Line 218: select JTF_DIAGNOSTIC_REPORT_S.nextval into form_ui_node_id from dual;

214: VALIDATE_REPORT_CONTEXT(report_context);
215: IF heading IS NOT NULL THEN
216: form_heading := DBMS_XMLGEN.CONVERT(heading,0);
217: exec_id := report_context.EXEC_ID;
218: select JTF_DIAGNOSTIC_REPORT_S.nextval into form_ui_node_id from dual;
219: select JTF_DIAGNOSTIC_REPORT_S.nextval into form_data_ui_node_id from dual;
220: form_data_component := JTF_DIAG_FORMDATA(exec_id,form_data_ui_node_id,form_values,0);
221: form_component := JTF_DIAG_FORM(exec_id,form_ui_node_id,form_heading,form_keys,form_values,form_data_component,0);
222: ELSE

Line 219: select JTF_DIAGNOSTIC_REPORT_S.nextval into form_data_ui_node_id from dual;

215: IF heading IS NOT NULL THEN
216: form_heading := DBMS_XMLGEN.CONVERT(heading,0);
217: exec_id := report_context.EXEC_ID;
218: select JTF_DIAGNOSTIC_REPORT_S.nextval into form_ui_node_id from dual;
219: select JTF_DIAGNOSTIC_REPORT_S.nextval into form_data_ui_node_id from dual;
220: form_data_component := JTF_DIAG_FORMDATA(exec_id,form_data_ui_node_id,form_values,0);
221: form_component := JTF_DIAG_FORM(exec_id,form_ui_node_id,form_heading,form_keys,form_values,form_data_component,0);
222: ELSE
223: RAISE_APPLICATION_ERROR(-20100,'The content provided for the form is null');

Line 243: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;

239: table_heading := DBMS_XMLGEN.CONVERT(heading,0);
240: END IF;
241: IF column_headers IS NOT NULL THEN
242: exec_id := report_context.EXEC_ID;
243: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
244: FOR x IN column_headers.FIRST .. column_headers.LAST
245: LOOP
246: no_of_cols := no_of_cols + 1;
247: END LOOP;

Line 307: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;

303: ELSE
304: RAISE_APPLICATION_ERROR(-20100,'The content provided for the column header in table is null');
305: END IF;
306: exec_id := report_context.EXEC_ID;
307: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
308: FOR x IN table_column_headers.FIRST .. table_column_headers.LAST
309: LOOP
310: no_of_cols := no_of_cols + 1;
311: END LOOP;

Line 337: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;

333: END IF;
334: table_column_headers := GET_COLUMN_NAMES(sql_query);
335:
336: exec_id := report_context.EXEC_ID;
337: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
338: FOR x IN table_column_headers.FIRST .. table_column_headers.LAST
339: LOOP
340: no_of_cols := no_of_cols + 1;
341: END LOOP;

Line 375: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;

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

Line 390: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;

386: VALIDATE_REPORT_CONTEXT(report_context);
387: IF heading IS NOT NULL THEN
388: tree_heading := DBMS_XMLGEN.CONVERT(heading,0);
389: exec_id := report_context.EXEC_ID;
390: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
391: tree_component := JTF_DIAG_TREE(exec_id,ui_node_id,tree_heading,0);
392: ELSE
393: RAISE_APPLICATION_ERROR(-20100,'The content provided for the tree is null');
394: END IF;

Line 407: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;

403: VALIDATE_REPORT_CONTEXT(report_context);
404: IF content IS NOT NULL THEN
405: tree_content := DBMS_XMLGEN.CONVERT(content,0);
406: exec_id := report_context.EXEC_ID;
407: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
408: tree_node_component := JTF_DIAG_TREE_NODE(exec_id,ui_node_id,tree_content,0);
409: ELSE
410: RAISE_APPLICATION_ERROR(-20100,'The content provided for the tree node is null');
411: END IF;

Line 427: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;

423: VALIDATE_REPORT_CONTEXT(report_context);
424: IF content IS NOT NULL THEN
425: note_content := DBMS_XMLGEN.CONVERT(content,0);
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

Line 461: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;

457: metalink_url := FND_PROFILE.value('OAM_DIAG_METALINK_URL');
458: metalink_url := metalink_url || note_id;
459: link_url_content := DBMS_XMLGEN.CONVERT(metalink_url,0);
460: exec_id := report_context.EXEC_ID;
461: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
462: link_component := JTF_DIAG_LINK(exec_id,ui_node_id,link_text_content,link_url_content,0);
463: ELSE
464: RAISE_APPLICATION_ERROR(-20100,'The content provided for the link is null');
465: END IF;