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 DBMS_XMLGEN

Line 22: footer_content := DBMS_XMLGEN.CONVERT(footer,0);

18: footer_content VARCHAR2(2000);
19: BEGIN
20: VALIDATE_REPORT_CONTEXT(report_context);
21: IF footer IS NOT NULL THEN
22: footer_content := DBMS_XMLGEN.CONVERT(footer,0);
23: exec_id := report_context.EXEC_ID;
24: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
25: footer_component := JTF_DIAG_FOOTER(exec_id,ui_node_id,footer_content,0);
26: ELSE

Line 40: header_content := DBMS_XMLGEN.CONVERT(header,0);

36: header_content VARCHAR2(2000);
37: BEGIN
38: VALIDATE_REPORT_CONTEXT(report_context);
39: IF header IS NOT NULL THEN
40: header_content := DBMS_XMLGEN.CONVERT(header,0);
41: exec_id := report_context.EXEC_ID;
42: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
43: header_component := JTF_DIAG_HEADER(exec_id,ui_node_id,header_content,0);
44: ELSE

Line 58: section_heading := DBMS_XMLGEN.CONVERT(heading,0);

54: section_heading VARCHAR2(2000);
55: BEGIN
56: VALIDATE_REPORT_CONTEXT(report_context);
57: IF heading IS NOT NULL THEN
58: section_heading := DBMS_XMLGEN.CONVERT(heading,0);
59: exec_id := report_context.EXEC_ID;
60: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
61: section_component := JTF_DIAG_SECTION(exec_id,ui_node_id,section_heading,0);
62: ELSE

Line 76: message_content := DBMS_XMLGEN.CONVERT(message,0);

72: message_content VARCHAR2(2000);
73: BEGIN
74: VALIDATE_REPORT_CONTEXT(report_context);
75: IF message IS NOT NULL THEN
76: message_content := DBMS_XMLGEN.CONVERT(message,0);
77: exec_id := report_context.EXEC_ID;
78: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
79: IF message_type IS NOT NULL AND (message_type = 'info' OR message_type = 'warning' OR message_type = 'error' OR message_type = 'attention') THEN
80: message_component := JTF_DIAG_MESSAGE(exec_id,ui_node_id,message_content,message_type,null,0,0,0);

Line 138: hide_show_content := DBMS_XMLGEN.CONVERT(content,0);

134: hide_show_content VARCHAR2(20000);
135: BEGIN
136: VALIDATE_REPORT_CONTEXT(report_context);
137: IF content IS NOT NULL THEN
138: hide_show_content := DBMS_XMLGEN.CONVERT(content,0);
139: exec_id := report_context.EXEC_ID;
140: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
141: hide_show_component := JTF_DIAG_HIDE_SHOW(exec_id,ui_node_id,hide_show_content,'Hide','Show',0);
142: ELSE

Line 175: link_text_content := DBMS_XMLGEN.CONVERT(linkText,0);

171: link_url_content VARCHAR2(20000);
172: BEGIN
173: VALIDATE_REPORT_CONTEXT(report_context);
174: IF linkText IS NOT NULL AND linkURL IS NOT NULL THEN
175: link_text_content := DBMS_XMLGEN.CONVERT(linkText,0);
176: link_url_content := DBMS_XMLGEN.CONVERT(linkURL,0);
177: exec_id := report_context.EXEC_ID;
178: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
179: link_component := JTF_DIAG_LINK(exec_id,ui_node_id,link_text_content,link_url_content,0);

Line 176: link_url_content := DBMS_XMLGEN.CONVERT(linkURL,0);

172: BEGIN
173: VALIDATE_REPORT_CONTEXT(report_context);
174: IF linkText IS NOT NULL AND linkURL IS NOT NULL THEN
175: link_text_content := DBMS_XMLGEN.CONVERT(linkText,0);
176: link_url_content := DBMS_XMLGEN.CONVERT(linkURL,0);
177: exec_id := report_context.EXEC_ID;
178: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
179: link_component := JTF_DIAG_LINK(exec_id,ui_node_id,link_text_content,link_url_content,0);
180: ELSE

Line 196: form_heading := DBMS_XMLGEN.CONVERT(heading,0);

192: form_heading VARCHAR2(2000);
193: BEGIN
194: VALIDATE_REPORT_CONTEXT(report_context);
195: IF heading IS NOT NULL THEN
196: form_heading := DBMS_XMLGEN.CONVERT(heading,0);
197: exec_id := report_context.EXEC_ID;
198: select JTF_DIAGNOSTIC_REPORT_S.nextval into form_ui_node_id from dual;
199: select JTF_DIAGNOSTIC_REPORT_S.nextval into form_data_ui_node_id from dual;
200: form_data_component := JTF_DIAG_FORMDATA(exec_id,form_data_ui_node_id,form_values,0);

Line 219: table_heading := DBMS_XMLGEN.CONVERT(heading,0);

215: VALIDATE_REPORT_CONTEXT(report_context);
216: IF heading IS NULL THEN
217: table_heading := ' ';
218: ELSE
219: table_heading := DBMS_XMLGEN.CONVERT(heading,0);
220: END IF;
221: IF column_headers IS NOT NULL THEN
222: exec_id := report_context.EXEC_ID;
223: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;

Line 273: table_heading := DBMS_XMLGEN.CONVERT(heading,0);

269: END IF;
270: IF heading IS NULL THEN
271: table_heading := ' ';
272: ELSE
273: table_heading := DBMS_XMLGEN.CONVERT(heading,0);
274: END IF;
275: table_column_headers := GET_COLUMN_NAMES(sql_query);
276: --Check if the column_headers provided by the user is consistent with the query
277: IF column_headers IS NOT NULL THEN

Line 312: table_heading := DBMS_XMLGEN.CONVERT(heading,0);

308: END IF;
309: IF heading IS NULL THEN
310: table_heading := ' ';
311: ELSE
312: table_heading := DBMS_XMLGEN.CONVERT(heading,0);
313: END IF;
314: table_column_headers := GET_COLUMN_NAMES(sql_query);
315:
316: exec_id := report_context.EXEC_ID;

Line 368: tree_heading := DBMS_XMLGEN.CONVERT(heading,0);

364: tree_heading VARCHAR2(20000);
365: BEGIN
366: VALIDATE_REPORT_CONTEXT(report_context);
367: IF heading IS NOT NULL THEN
368: tree_heading := DBMS_XMLGEN.CONVERT(heading,0);
369: exec_id := report_context.EXEC_ID;
370: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
371: tree_component := JTF_DIAG_TREE(exec_id,ui_node_id,tree_heading,0);
372: ELSE

Line 385: tree_content := DBMS_XMLGEN.CONVERT(content,0);

381: tree_content VARCHAR2(20000);
382: BEGIN
383: VALIDATE_REPORT_CONTEXT(report_context);
384: IF content IS NOT NULL THEN
385: tree_content := DBMS_XMLGEN.CONVERT(content,0);
386: exec_id := report_context.EXEC_ID;
387: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
388: tree_node_component := JTF_DIAG_TREE_NODE(exec_id,ui_node_id,tree_content,0);
389: ELSE

Line 405: note_content := DBMS_XMLGEN.CONVERT(content,0);

401: content_lenght NUMBER;
402: BEGIN
403: VALIDATE_REPORT_CONTEXT(report_context);
404: IF content IS NOT NULL THEN
405: note_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: no_of_links := length(content)-length(replace(content,'?',''));
409: IF no_of_links > 0 THEN

Line 436: link_text_content := DBMS_XMLGEN.CONVERT(linkText,0);

432: metalink_url VARCHAR2(20000);
433: BEGIN
434: VALIDATE_REPORT_CONTEXT(report_context);
435: IF linkText IS NOT NULL AND note_id IS NOT NULL THEN
436: link_text_content := DBMS_XMLGEN.CONVERT(linkText,0);
437: metalink_url := FND_PROFILE.value('OAM_DIAG_METALINK_URL');
438: metalink_url := metalink_url || note_id;
439: link_url_content := DBMS_XMLGEN.CONVERT(metalink_url,0);
440: exec_id := report_context.EXEC_ID;

Line 439: link_url_content := DBMS_XMLGEN.CONVERT(metalink_url,0);

435: IF linkText IS NOT NULL AND note_id IS NOT NULL THEN
436: link_text_content := DBMS_XMLGEN.CONVERT(linkText,0);
437: metalink_url := FND_PROFILE.value('OAM_DIAG_METALINK_URL');
438: metalink_url := metalink_url || note_id;
439: link_url_content := DBMS_XMLGEN.CONVERT(metalink_url,0);
440: exec_id := report_context.EXEC_ID;
441: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
442: link_component := JTF_DIAG_LINK(exec_id,ui_node_id,link_text_content,link_url_content,0);
443: ELSE