1 PACKAGE JTF_DECLARATIVE_DIAGNOSTIC AUTHID CURRENT_USER AS
2 /* $Header: jtfdecl_diag_s.pls 120.2 2005/08/13 01:05:17 minxu noship $ */
3
4 PROCEDURE init;
5 PROCEDURE cleanup;
6
7 PROCEDURE runtest(inputs IN JTF_DIAG_INPUTTBL,
8 report OUT NOCOPY JTF_DIAG_REPORT,
9 reportClob OUT NOCOPY CLOB,
10 appshortname IN VARCHAR2,
11 groupname IN VARCHAR2,
12 testclassname IN VARCHAR2,
13 p_teststepname IN VARCHAR2,
14 p_teststeptype IN VARCHAR2,
15 p_stepDescription IN VARCHAR2,
16 p_errorType IN VARCHAR2,
17 p_errorMessage IN VARCHAR2,
18 p_fixInfo IN VARCHAR2,
19 p_tableViewName IN VARCHAR2,
20 p_logicalOperator IN VARCHAR2,
21 p_validationVal1 IN VARCHAR2,
22 p_validationVal2 IN VARCHAR2,
23 p_whereClauseOrSQL IN VARCHAR2,
24 sysParamNames IN JTF_VARCHAR2_TABLE_4000,
25 sysParamValues IN JTF_VARCHAR2_TABLE_4000,
26 p_ordernumber IN NUMBER);
27
28 PROCEDURE run_or_validate_count(
29 appshtname in varchar2,
30 grpname in varchar2,
31 testclsname in varchar2,
32 report out NOCOPY JTF_DIAG_REPORT,
33 teststpname IN VARCHAR2,
34 step_description IN VARCHAR2,
35 error_type IN VARCHAR2,
36 error_message IN VARCHAR2,
37 fix_info IN VARCHAR2,
38 table_view_name IN VARCHAR2,
39 logical_operator IN VARCHAR2,
40 validation_val1 IN VARCHAR2,
41 VALIDATION_VAL2 IN VARCHAR2,
42 WHERE_CLAUSE_OR_SQL IN VARCHAR2,
43 STEP_FAILED IN OUT NOCOPY BOOLEAN,
44 SUMMARY_STRING IN OUT NOCOPY VARCHAR2,
45 DETAILS_STRING IN OUT NOCOPY VARCHAR2,
46 ORDERNUMBER IN OUT NOCOPY NUMBER);
47
48 PROCEDURE run_or_validate_rec_norec(
49 appshtname in varchar2,
50 grpname in varchar2,
51 testclsname in varchar2,
52 report OUT NOCOPY JTF_DIAG_REPORT,
53 teststpname IN VARCHAR2,
54 step_description IN VARCHAR2,
55 error_type IN VARCHAR2,
56 error_message IN VARCHAR2,
57 fix_info IN VARCHAR2,
58 WHERE_CLAUSE_OR_SQL IN VARCHAR2,
59 STEP_FAILED IN OUT NOCOPY BOOLEAN,
60 SUMMARY_STRING IN OUT NOCOPY VARCHAR2,
61 DETAILS_STRING IN OUT NOCOPY VARCHAR2,
62 ORDERNUMBER IN OUT NOCOPY NUMBER,
63 STEPTYPE in VARCHAR2);
64
65 PROCEDURE run_system_parameter_step(
66 appshortname in varchar2,
67 groupname in varchar2,
68 testclassname in varchar2,
69 report OUT NOCOPY JTF_DIAG_REPORT,
70 teststpname in varchar2,
71 step_description in varchar2,
72 error_type in varchar2,
73 error_message in varchar2,
74 fix_info in varchar2,
75 table_view_name in varchar2,
76 logical_operator in varchar2,
77 validation_val1 in varchar2,
78 step_failed IN OUT NOCOPY BOOLEAN,
79 summary_String IN OUT NOCOPY VARCHAR2,
80 details_String IN OUT NOCOPY VARCHAR2,
81 ORDERNUMBER IN OUT NOCOPY NUMBER,
82 sysParamNames IN JTF_VARCHAR2_TABLE_4000,
83 sysParamValues IN JTF_VARCHAR2_TABLE_4000);
84
85 PROCEDURE run_or_validate_column(
86 appshtname in varchar2,
87 grpname in varchar2,
88 testclsname in varchar2,
89 report out NOCOPY JTF_DIAG_REPORT,
90 teststpname IN VARCHAR2,
91 step_description IN VARCHAR2,
92 error_type IN VARCHAR2,
93 error_message IN VARCHAR2,
94 fix_info IN VARCHAR2,
95 table_view_name IN VARCHAR2,
96 logical_operator IN VARCHAR2,
97 validation_val1 IN VARCHAR2,
98 VALIDATION_VAL2 IN VARCHAR2,
99 WHERE_CLAUSE_OR_SQL IN VARCHAR2,
100 STEP_FAILED IN OUT NOCOPY BOOLEAN,
101 SUMMARY_STRING IN OUT NOCOPY VARCHAR2,
102 DETAILS_CLOB IN OUT NOCOPY CLOB,
103 ORDERNUMBER IN OUT NOCOPY NUMBER);
104
105 PROCEDURE getComponentName(str OUT NOCOPY VARCHAR2);
106 PROCEDURE getTestName(str OUT NOCOPY VARCHAR2);
107 PROCEDURE getTestDesc(str OUT NOCOPY VARCHAR2);
108 PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL);
109 FUNCTION getTestMode RETURN INTEGER;
110
111 PROCEDURE insert_core_steps(
112 qAppID IN VARCHAR2,
113 newTestName IN VARCHAR2,
114 addToGroupName IN VARCHAR2,
115 stepType IN VARCHAR2,
116 newStepName IN VARCHAR2,
117 newStepDesc IN VARCHAR2,
118 errorType IN VARCHAR2,
119 newStepErrMsg IN VARCHAR2,
120 newStepFixInfo IN VARCHAR2,
121 newStepTableName IN VARCHAR2,
122 newStepQuery IN VARCHAR2,
123 logicalOperator IN VARCHAR2,
124 val1 IN VARCHAR2,
125 val2 IN VARCHAR2,
126 isUpdate IN VARCHAR2,
127 P_LUBID IN NUMBER);
128
129 PROCEDURE GET_TEST_STEPS(
130 p_appid IN VARCHAR2,
131 p_groupName IN VARCHAR2,
132 p_testclassname IN VARCHAR2,
133 p_teststepnames OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
134 p_teststepdesc OUT NOCOPY JTF_VARCHAR2_TABLE_4000);
135
136 PROCEDURE UPDATE_STEP_SEQ(
137 P_APPID IN VARCHAR2,
138 P_GROUPNAME IN VARCHAR2,
139 P_TESTCLASSNAME IN VARCHAR2,
140 P_STEPSEQARRAY IN JTF_VARCHAR2_TABLE_4000,
141 P_LUBID IN NUMBER);
142
143 PROCEDURE DELETE_STEPS(
144 P_APPID IN VARCHAR2,
145 P_GROUPNAME IN VARCHAR2,
146 P_TESTCLASSNAME IN VARCHAR2,
147 P_DELSTEPARRAY IN JTF_VARCHAR2_TABLE_4000);
148
149
150 PROCEDURE INSERT_COL_STEP_DATA(
151 P_APPID IN VARCHAR2,
152 P_GROUPNAME IN VARCHAR2,
153 P_TESTCLASSNAME IN VARCHAR2,
154 P_TESTSTEPNAME IN VARCHAR2,
155 P_COLNAMES_ARRAY IN JTF_VARCHAR2_TABLE_4000,
156 P_LOGOP_ARRAY IN JTF_VARCHAR2_TABLE_4000,
157 P_VAL1_ARRAY IN JTF_VARCHAR2_TABLE_4000,
158 P_VAL2_ARRAY IN JTF_VARCHAR2_TABLE_4000,
159 ISUPDATE IN VARCHAR2,
160 P_LUBID IN NUMBER);
161
162
163 PROCEDURE addStringToClob(reportStr IN LONG, detailsClob IN OUT NOCOPY CLOB);
164
165 END;