[Home] [Help]
1: PACKAGE BODY JTF_DIAG_REPORT_FACTORY AS
2: /* $Header: jtf_diag_report_factory_b.pls 120.3.12010000.6 2009/08/05 13:33:35 rudas ship $*/
3:
4:
5: PROCEDURE VALIDATE_REPORT_CONTEXT(report_context JTF_DIAG_REPORT_CONTEXT)
6: IS
7: BEGIN
8: IF report_context IS NULL THEN
9: RAISE_APPLICATION_ERROR(-20100,'ReportContext provided to instantiate the component is null');
9: RAISE_APPLICATION_ERROR(-20100,'ReportContext provided to instantiate the component is null');
10: END IF;
11: END VALIDATE_REPORT_CONTEXT;
12:
13: FUNCTION CREATE_FOOTER(footer VARCHAR2,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_FOOTER
14: IS
15: footer_component JTF_DIAG_FOOTER;
16: exec_id NUMBER;
17: ui_node_id NUMBER;
47: RAISE_APPLICATION_ERROR(-20100,'The content provided for the footer is null');
48: END IF;
49: RETURN footer_component;
50: END CREATE_FOOTER;
51: FUNCTION CREATE_HEADER(header VARCHAR2,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_HEADER
52: IS
53: header_component JTF_DIAG_HEADER;
54: exec_id NUMBER;
55: ui_node_id NUMBER;
65: RAISE_APPLICATION_ERROR(-20100,'The content provided for the header is null');
66: END IF;
67: RETURN header_component;
68: END CREATE_HEADER;
69: FUNCTION CREATE_SECTION(heading VARCHAR2,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_SECTION
70: IS
71: section_component JTF_DIAG_SECTION;
72: exec_id NUMBER;
73: ui_node_id NUMBER;
83: RAISE_APPLICATION_ERROR(-20100,'Heading of the Section is null');
84: END IF;
85: RETURN section_component;
86: END CREATE_SECTION;
87: FUNCTION CREATE_MESSAGE(message VARCHAR2,message_type VARCHAR2,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_MESSAGE
88: IS
89: message_component JTF_DIAG_MESSAGE;
90: exec_id NUMBER;
91: ui_node_id NUMBER;
106: END IF;
107: RETURN message_component;
108: END CREATE_MESSAGE;
109:
110: FUNCTION CREATE_MESSAGE(note in out nocopy JTF_DIAG_NOTE,message_type VARCHAR2,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_MESSAGE
111: IS
112: message_component JTF_DIAG_MESSAGE;
113: exec_id NUMBER;
114: ui_node_id NUMBER;
145: END IF;
146: RETURN message_component;
147: END CREATE_MESSAGE;
148:
149: FUNCTION CREATE_HIDE_SHOW(content VARCHAR2,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_HIDE_SHOW
150: IS
151: hide_show_component JTF_DIAG_HIDE_SHOW;
152: exec_id NUMBER;
153: ui_node_id NUMBER;
163: RAISE_APPLICATION_ERROR(-20100,'The content provided for the hide show is null');
164: END IF;
165: RETURN hide_show_component;
166: END CREATE_HIDE_SHOW;
167: FUNCTION CREATE_RAW_TEXT(content VARCHAR2,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_RAW_TEXT
168: IS
169: raw_text_component JTF_DIAG_RAW_TEXT;
170: exec_id NUMBER;
171: ui_node_id NUMBER;
181: RAISE_APPLICATION_ERROR(-20100,'The content provided for the raw text is null');
182: END IF;
183: RETURN raw_text_component;
184: END CREATE_RAW_TEXT;
185: FUNCTION CREATE_LINK(linkText VARCHAR2, linkURL VARCHAR2,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_LINK
186: IS
187: link_component JTF_DIAG_LINK;
188: exec_id NUMBER;
189: ui_node_id NUMBER;
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;
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;
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;
312: table_component := JTF_DIAG_TABLE(exec_id,ui_node_id,table_column_headers,table_heading,sql_query,1,no_of_cols,0,0,null);
313: RETURN table_component;
314: END CREATE_TABLE;
315:
316: FUNCTION CREATE_TABLE(heading VARCHAR2, sql_query VARCHAR2, report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_TABLE
317: IS
318: table_component JTF_DIAG_TABLE;
319: exec_id NUMBER;
320: ui_node_id NUMBER;
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;
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;
356: table_component := CREATE_TABLE(null,column_headers,sql_query,report_context);
357: RETURN table_component;
358: END CREATE_TABLE;
359:
360: FUNCTION CREATE_TABLE(sql_query VARCHAR2, report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_TABLE IS
361: table_component JTF_DIAG_TABLE;
362: BEGIN
363: table_component := CREATE_TABLE(' ',sql_query,report_context);
364: RETURN table_component;
363: table_component := CREATE_TABLE(' ',sql_query,report_context);
364: RETURN table_component;
365: END CREATE_TABLE;
366:
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;
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
381: tree_component JTF_DIAG_TREE;
382: exec_id NUMBER;
383: ui_node_id NUMBER;
384: tree_heading VARCHAR2(20000);
393: RAISE_APPLICATION_ERROR(-20100,'The content provided for the tree is null');
394: END IF;
395: RETURN tree_component;
396: END CREATE_TREE;
397: FUNCTION CREATE_TREE_NODE(content VARCHAR2,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_TREE_NODE IS
398: tree_node_component JTF_DIAG_TREE_NODE;
399: exec_id NUMBER;
400: ui_node_id NUMBER;
401: tree_content VARCHAR2(20000);
410: RAISE_APPLICATION_ERROR(-20100,'The content provided for the tree node is null');
411: END IF;
412: RETURN tree_node_component;
413: END CREATE_TREE_NODE;
414: FUNCTION CREATE_NOTE(content VARCHAR2,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_NOTE IS
415: note_component JTF_DIAG_NOTE;
416: exec_id NUMBER;
417: ui_node_id NUMBER;
418: no_of_links NUMBER;
441: END IF;
442: RETURN note_component;
443: END CREATE_NOTE;
444:
445: FUNCTION CREATE_METALINK(linkText VARCHAR2, note_id VARCHAR2,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_LINK
446: IS
447: link_component JTF_DIAG_LINK;
448: exec_id NUMBER;
449: ui_node_id NUMBER;
465: END IF;
466: RETURN link_component;
467: END CREATE_METALINK;
468:
469: FUNCTION CREATE_METALINK(note_id VARCHAR2,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_LINK
470: IS
471: link_component JTF_DIAG_LINK;
472: BEGIN
473: link_component := CREATE_METALINK(note_id,note_id,report_context);