[Home] [Help]
1: PACKAGE BODY JTF_DIAG_REPORT_FACTORY AS
2: /* $Header: jtf_diag_report_factory_b.pls 120.3.12010000.4 2008/10/10 06:24:03 sramados 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;
27: RAISE_APPLICATION_ERROR(-20100,'The content provided for the footer is null');
28: END IF;
29: RETURN footer_component;
30: END CREATE_FOOTER;
31: FUNCTION CREATE_HEADER(header VARCHAR2,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_HEADER
32: IS
33: header_component JTF_DIAG_HEADER;
34: exec_id NUMBER;
35: ui_node_id NUMBER;
45: RAISE_APPLICATION_ERROR(-20100,'The content provided for the header is null');
46: END IF;
47: RETURN header_component;
48: END CREATE_HEADER;
49: FUNCTION CREATE_SECTION(heading VARCHAR2,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_SECTION
50: IS
51: section_component JTF_DIAG_SECTION;
52: exec_id NUMBER;
53: ui_node_id NUMBER;
63: RAISE_APPLICATION_ERROR(-20100,'Heading of the Section is null');
64: END IF;
65: RETURN section_component;
66: END CREATE_SECTION;
67: FUNCTION CREATE_MESSAGE(message VARCHAR2,message_type VARCHAR2,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_MESSAGE
68: IS
69: message_component JTF_DIAG_MESSAGE;
70: exec_id NUMBER;
71: ui_node_id NUMBER;
86: END IF;
87: RETURN message_component;
88: END CREATE_MESSAGE;
89:
90: FUNCTION CREATE_MESSAGE(note in out nocopy JTF_DIAG_NOTE,message_type VARCHAR2,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_MESSAGE
91: IS
92: message_component JTF_DIAG_MESSAGE;
93: exec_id NUMBER;
94: ui_node_id NUMBER;
125: END IF;
126: RETURN message_component;
127: END CREATE_MESSAGE;
128:
129: FUNCTION CREATE_HIDE_SHOW(content VARCHAR2,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_HIDE_SHOW
130: IS
131: hide_show_component JTF_DIAG_HIDE_SHOW;
132: exec_id NUMBER;
133: ui_node_id NUMBER;
143: RAISE_APPLICATION_ERROR(-20100,'The content provided for the hide show is null');
144: END IF;
145: RETURN hide_show_component;
146: END CREATE_HIDE_SHOW;
147: FUNCTION CREATE_RAW_TEXT(content VARCHAR2,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_RAW_TEXT
148: IS
149: raw_text_component JTF_DIAG_RAW_TEXT;
150: exec_id NUMBER;
151: ui_node_id NUMBER;
161: RAISE_APPLICATION_ERROR(-20100,'The content provided for the raw text is null');
162: END IF;
163: RETURN raw_text_component;
164: END CREATE_RAW_TEXT;
165: FUNCTION CREATE_LINK(linkText VARCHAR2, linkURL VARCHAR2,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_LINK
166: IS
167: link_component JTF_DIAG_LINK;
168: exec_id NUMBER;
169: ui_node_id NUMBER;
181: RAISE_APPLICATION_ERROR(-20100,'The content provided for the link is null');
182: END IF;
183: RETURN link_component;
184: END CREATE_LINK;
185: 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
186: IS
187: form_component JTF_DIAG_FORM;
188: form_data_component JTF_DIAG_FORMDATA;
189: exec_id NUMBER;
203: RAISE_APPLICATION_ERROR(-20100,'The content provided for the form is null');
204: END IF;
205: RETURN form_component;
206: END CREATE_FORM;
207: FUNCTION CREATE_TABLE(heading VARCHAR2, column_headers JTF_VARCHAR2_TABLE_4000,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_TABLE
208: IS
209: table_component JTF_DIAG_TABLE;
210: exec_id NUMBER;
211: ui_node_id NUMBER;
253: RETURN column_headers;
254: END GET_COLUMN_NAMES;
255:
256:
257: FUNCTION CREATE_TABLE(heading VARCHAR2, column_headers JTF_VARCHAR2_TABLE_4000, sql_query VARCHAR2, report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_TABLE
258: IS
259: table_component JTF_DIAG_TABLE;
260: exec_id NUMBER;
261: ui_node_id NUMBER;
292: table_component := JTF_DIAG_TABLE(exec_id,ui_node_id,table_column_headers,table_heading,sql_query,1,no_of_cols,0,0,null);
293: RETURN table_component;
294: END CREATE_TABLE;
295:
296: FUNCTION CREATE_TABLE(heading VARCHAR2, sql_query VARCHAR2, report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_TABLE
297: IS
298: table_component JTF_DIAG_TABLE;
299: exec_id NUMBER;
300: ui_node_id NUMBER;
322: table_component := JTF_DIAG_TABLE(exec_id,ui_node_id,table_column_headers,table_heading,sql_query,1,no_of_cols,0,0,null);
323: RETURN table_component;
324: END CREATE_TABLE;
325:
326: FUNCTION CREATE_TABLE(column_headers JTF_VARCHAR2_TABLE_4000,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_TABLE IS
327: table_component JTF_DIAG_TABLE;
328: BEGIN
329: table_component := CREATE_TABLE(null,column_headers,report_context);
330: RETURN table_component;
329: table_component := CREATE_TABLE(null,column_headers,report_context);
330: RETURN table_component;
331: END CREATE_TABLE;
332:
333: FUNCTION CREATE_TABLE(column_headers JTF_VARCHAR2_TABLE_4000, sql_query VARCHAR2, report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_TABLE IS
334: table_component JTF_DIAG_TABLE;
335: BEGIN
336: table_component := CREATE_TABLE(null,column_headers,sql_query,report_context);
337: RETURN table_component;
336: table_component := CREATE_TABLE(null,column_headers,sql_query,report_context);
337: RETURN table_component;
338: END CREATE_TABLE;
339:
340: FUNCTION CREATE_TABLE(sql_query VARCHAR2, report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_TABLE IS
341: table_component JTF_DIAG_TABLE;
342: BEGIN
343: table_component := CREATE_TABLE(' ',sql_query,report_context);
344: RETURN table_component;
343: table_component := CREATE_TABLE(' ',sql_query,report_context);
344: RETURN table_component;
345: END CREATE_TABLE;
346:
347: FUNCTION CREATE_ROW(report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_ROW IS
348: row_component JTF_DIAG_ROW;
349: exec_id NUMBER;
350: ui_node_id NUMBER;
351: --cols JTF_VARCHAR2_TABLE_4000;
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;
360: FUNCTION CREATE_TREE(heading VARCHAR2,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_TREE IS
361: tree_component JTF_DIAG_TREE;
362: exec_id NUMBER;
363: ui_node_id NUMBER;
364: tree_heading VARCHAR2(20000);
373: RAISE_APPLICATION_ERROR(-20100,'The content provided for the tree is null');
374: END IF;
375: RETURN tree_component;
376: END CREATE_TREE;
377: FUNCTION CREATE_TREE_NODE(content VARCHAR2,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_TREE_NODE IS
378: tree_node_component JTF_DIAG_TREE_NODE;
379: exec_id NUMBER;
380: ui_node_id NUMBER;
381: tree_content VARCHAR2(20000);
390: RAISE_APPLICATION_ERROR(-20100,'The content provided for the tree node is null');
391: END IF;
392: RETURN tree_node_component;
393: END CREATE_TREE_NODE;
394: FUNCTION CREATE_NOTE(content VARCHAR2,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_NOTE IS
395: note_component JTF_DIAG_NOTE;
396: exec_id NUMBER;
397: ui_node_id NUMBER;
398: no_of_links NUMBER;
421: END IF;
422: RETURN note_component;
423: END CREATE_NOTE;
424:
425: FUNCTION CREATE_METALINK(linkText VARCHAR2, note_id VARCHAR2,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_LINK
426: IS
427: link_component JTF_DIAG_LINK;
428: exec_id NUMBER;
429: ui_node_id NUMBER;
445: END IF;
446: RETURN link_component;
447: END CREATE_METALINK;
448:
449: FUNCTION CREATE_METALINK(note_id VARCHAR2,report_context JTF_DIAG_REPORT_CONTEXT) RETURN JTF_DIAG_LINK
450: IS
451: link_component JTF_DIAG_LINK;
452: BEGIN
453: link_component := CREATE_METALINK(note_id,note_id,report_context);