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 24: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;

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
27: RAISE_APPLICATION_ERROR(-20100,'The content provided for the footer is null');
28: END IF;

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

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
45: RAISE_APPLICATION_ERROR(-20100,'The content provided for the header is null');
46: END IF;

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

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
63: RAISE_APPLICATION_ERROR(-20100,'Heading of the Section is null');
64: END IF;

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

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);
81: ELSE
82: RAISE_APPLICATION_ERROR(-20100,'The message type '|| message_type||' is wrong: It can only be info, warning or error');

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

99: VALIDATE_REPORT_CONTEXT(report_context);
100: IF note IS NOT NULL THEN
101: message_note_id := note.UI_NODE_ID;
102: exec_id := report_context.EXEC_ID;
103: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
104: IF message_type IS NOT NULL AND (message_type = 'info' OR message_type = 'warning' OR message_type = 'error' OR message_type = 'attention') THEN
105: message_component := JTF_DIAG_MESSAGE(exec_id,ui_node_id,message_content,message_type,null,message_note_id,0,0);
106: IF NOTE.ADDED_TO_PARENT <> 1 THEN
107: str := note.CONSTRUCT_NODE;

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

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
143: RAISE_APPLICATION_ERROR(-20100,'The content provided for the hide show is null');
144: END IF;

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

154: VALIDATE_REPORT_CONTEXT(report_context);
155: IF content IS NOT NULL THEN
156: raw_text_content := content;
157: exec_id := report_context.EXEC_ID;
158: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
159: raw_text_component := JTF_DIAG_RAW_TEXT(exec_id,ui_node_id,raw_text_content,0);
160: ELSE
161: RAISE_APPLICATION_ERROR(-20100,'The content provided for the raw text is null');
162: END IF;

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

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
181: RAISE_APPLICATION_ERROR(-20100,'The content provided for the link is null');
182: END IF;

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

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);
201: form_component := JTF_DIAG_FORM(exec_id,form_ui_node_id,form_heading,form_keys,form_values,form_data_component,0);
202: ELSE

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

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);
201: form_component := JTF_DIAG_FORM(exec_id,form_ui_node_id,form_heading,form_keys,form_values,form_data_component,0);
202: ELSE
203: RAISE_APPLICATION_ERROR(-20100,'The content provided for the form is null');

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

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;
224: FOR x IN column_headers.FIRST .. column_headers.LAST
225: LOOP
226: no_of_cols := no_of_cols + 1;
227: END LOOP;

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

283: ELSE
284: RAISE_APPLICATION_ERROR(-20100,'The content provided for the column header in table is null');
285: END IF;
286: exec_id := report_context.EXEC_ID;
287: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
288: FOR x IN table_column_headers.FIRST .. table_column_headers.LAST
289: LOOP
290: no_of_cols := no_of_cols + 1;
291: END LOOP;

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

313: END IF;
314: table_column_headers := GET_COLUMN_NAMES(sql_query);
315:
316: exec_id := report_context.EXEC_ID;
317: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
318: FOR x IN table_column_headers.FIRST .. table_column_headers.LAST
319: LOOP
320: no_of_cols := no_of_cols + 1;
321: END LOOP;

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

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

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

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
373: RAISE_APPLICATION_ERROR(-20100,'The content provided for the tree is null');
374: END IF;

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

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
390: RAISE_APPLICATION_ERROR(-20100,'The content provided for the tree node is null');
391: 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: 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
410: link_ids := JTF_VARCHAR2_TABLE_4000();
411: FOR x IN 1 .. no_of_links

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

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
444: RAISE_APPLICATION_ERROR(-20100,'The content provided for the link is null');
445: END IF;