1 PACKAGE JTF_DIAGNOSTIC_ADAPTUTIL AS
2 /* $Header: jtfdiagadptutl_s.pls 120.8 2008/03/11 10:01:40 sramados noship $ */
3
4 HIDDEN INTEGER := 0;
5 VISIBLE INTEGER := 1;
6
7 /* Different types of test mode. In BASIC_MODE, the test should be able to run
8 with default parameters defined in it, or the test should be able to run
9 without parameters. In ADVANCE_MODE, the test can accept parameters
10 which will be set by the driver. In BOTH_MODE the test is visible
11 on both basic and advanced pages in the UI.
12 */
13 BASIC_MODE INTEGER := 0;
14 ADVANCED_MODE INTEGER := 1;
15 BOTH_MODE INTEGER := 2;
16
17 b_html_on BOOLEAN;
18 reportClob CLOB;
19
20 FUNCTION checkValidAPI(packageName IN VARCHAR2) RETURN INTEGER;
21 FUNCTION checkValidPackage(packageName IN VARCHAR2) RETURN INTEGER;
22 FUNCTION checkPackageExists(packageName IN VARCHAR2) RETURN INTEGER;
23 FUNCTION initInputTable RETURN JTF_DIAG_INPUTTBL;
24 FUNCTION initReportTable RETURN JTF_DIAG_REPORTTBL;
25 FUNCTION initReportClob RETURN CLOB;
26 FUNCTION getReportClob RETURN CLOB;
27 FUNCTION compareResults(oper IN VARCHAR2,arg1 IN VARCHAR2,arg2 IN VARCHAR2) RETURN BOOLEAN;
28 FUNCTION compareResults(oper IN VARCHAR2,arg1 IN INTEGER,arg2 IN INTEGER) RETURN BOOLEAN;
29 FUNCTION extractVersion(versionStr IN VARCHAR2) RETURN VARCHAR2;
30 FUNCTION constructReport(status IN VARCHAR2 DEFAULT 'FAILED',
31 errStr IN VARCHAR2 DEFAULT 'Internal Error',
32 fixInfo IN VARCHAR2 DEFAULT 'No Fix Information Available',
33 isFatal IN VARCHAR2 DEFAULT 'FALSE') RETURN JTF_DIAG_REPORT;
34 FUNCTION getInputValue(argName IN VARCHAR2,inputs IN JTF_DIAG_INPUTTBL) RETURN VARCHAR2;
35 FUNCTION getVersion(packageName IN VARCHAR2) RETURN VARCHAR2;
36 FUNCTION addInput(inputs IN JTF_DIAG_INPUTTBL,var IN VARCHAR2,val IN VARCHAR2) RETURN JTF_DIAG_INPUTTBL;
37 FUNCTION addInput(inputs IN JTF_DIAG_INPUTTBL,var IN VARCHAR2,val IN VARCHAR2,showValue IN BOOLEAN) RETURN JTF_DIAG_INPUTTBL;
38 PROCEDURE setUpVars;
39 PROCEDURE addStringToReport (reportStr IN LONG);
40 FUNCTION getTestMethodsForPkg(pkgName VARCHAR2) RETURN JTF_VARCHAR2_TABLE_4000;
41 FUNCTION getTestPackages(pkgName VARCHAR2) RETURN JTF_VARCHAR2_TABLE_4000;
42 FUNCTION getUnitTestPackages(pkgName VARCHAR2) RETURN JTF_VARCHAR2_TABLE_4000;
43 PROCEDURE assert(message VARCHAR2,condition BOOLEAN);
44 PROCEDURE fail(message VARCHAR2);
45 PROCEDURE assertTrue(message VARCHAR2, condition BOOLEAN);
46 PROCEDURE assertTrue(message VARCHAR2, operand VARCHAR2,arg1 VARCHAR2,arg2 VARCHAR2);
47 PROCEDURE assertTrue(message VARCHAR2, operand VARCHAR2,arg1 NUMBER,arg2 NUMBER);
48 PROCEDURE assertEquals(message VARCHAR2,arg1 NUMBER,arg2 NUMBER);
49 PROCEDURE assertEquals(message VARCHAR2,arg1 VARCHAR2,arg2 VARCHAR2);
50 PROCEDURE assertEquals(message VARCHAR2,arg1 CLOB,arg2 CLOB);
51 PROCEDURE assertNotNull(message VARCHAR2,arg1 VARCHAR2);
52 PROCEDURE assertNull(message VARCHAR2,arg1 VARCHAR2);
53 PROCEDURE failNotEquals(message VARCHAR2,arg1 VARCHAR2,arg2 VARCHAR2);
54 PROCEDURE failNotEquals(message VARCHAR2,arg1 NUMBER,arg2 NUMBER);
55 PROCEDURE failNotEquals(message VARCHAR2,arg1 CLOB,arg2 CLOB);
56 PROCEDURE failFormatted(message VARCHAR2,expected VARCHAR2,actual VARCHAR2);
57 PROCEDURE failFormatted(message VARCHAR2,expected NUMBER,actual NUMBER);
58
59 ----------------------------
60 --- PipeLining APIs
61 ----------------------------
62 FUNCTION addOutput(outputs IN JTF_DIAG_OUTPUTTBL,var IN VARCHAR2,val IN VARCHAR2) RETURN JTF_DIAG_OUTPUTTBL;
63 FUNCTION initOutputTable RETURN JTF_DIAG_OUTPUTTBL;
64
65 FUNCTION addDependency(dependencies IN JTF_DIAG_DEPENDTBL, val IN VARCHAR2) RETURN JTF_DIAG_DEPENDTBL;
66 FUNCTION initDependencyTable RETURN JTF_DIAG_DEPENDTBL;
67
68
69 ----------------------------
70 --- Deprecated APIs
71 ----------------------------
72 PROCEDURE setUpVars(reportClob OUT NOCOPY CLOB);
73 PROCEDURE addStringToReport(reportClob IN OUT NOCOPY CLOB,reportStr IN LONG);
74
75 ---------------------------
76 -- Procedure to add xml unsafe strings to report
77 ---------------------------
78 Procedure addSafeStringToReport(reportStr IN LONG);
79
80 --------------------------------------------
81 -- new API to initialise inputs and add them
82 --------------------------------------------
83 FUNCTION addInput(inputs IN JTF_DIAG_TEST_INPUTS,
84 name IN VARCHAR2,
85 value IN VARCHAR2,
86 isConfidential IN VARCHAR2 default 'FALSE',
87 defaultValue IN VARCHAR2 default null,
88 tip IN VARCHAR2 default null,
89 isMandatory IN VARCHAR2 default 'FALSE',
90 isDate IN VARCHAR2 default 'FALSE',
91 isNumber IN VARCHAR2 default 'FALSE') RETURN JTF_DIAG_TEST_INPUTS;
92
93
94 FUNCTION initialiseInput RETURN JTF_DIAG_TEST_INPUTS;
95
96
97 FUNCTION GET_SITE_DATE_FORMAT RETURN VARCHAR2;
98 FUNCTION GET_DATE_FORMAT(user_id IN number) RETURN VARCHAR2;
99 END JTF_DIAGNOSTIC_ADAPTUTIL;