1 PACKAGE QA_QWB_WRAPPER_PKG AS
2 /* $Header: qaqwbws.pls 120.3.12010000.1 2008/07/25 09:20:25 appldev ship $ */
3
4 /*
5 * This Package is an API to inetrface with
6 * Quality Work Bench. It has wrapper functions
7 * that take in the resultString split into 66
8 * segments each of 500 Chars. These are then
9 * concatenated to form the final resultstring,
10 * which is then passed to the actual functions.
11 * This has been done to overcome the 4K size
12 * limitation imposed while binding VARCHAR2
13 * values while making a JDBC call
14 */
15
16
17 -- Wrapper function over
18 -- QA_PARENT_CHILD_PKG.APPLICABLE_CHILD_PLANS,
19 -- ntungare Tue Apr 18 22:17:12 PDT 2006
20 --
21 FUNCTION APPLICABLE_CHILD_PLANS (p_plan_id IN NUMBER,
22 p_string1 IN VARCHAR2,
23 p_string2 IN VARCHAR2,
24 p_string3 IN VARCHAR2,
25 p_string4 IN VARCHAR2,
26 p_string5 IN VARCHAR2,
27 p_string6 IN VARCHAR2,
28 p_string7 IN VARCHAR2,
29 p_string8 IN VARCHAR2,
30 p_string9 IN VARCHAR2,
31 p_string10 IN VARCHAR2,
32 p_string11 IN VARCHAR2,
33 p_string12 IN VARCHAR2,
34 p_string13 IN VARCHAR2,
35 p_string14 IN VARCHAR2,
36 p_string15 IN VARCHAR2,
37 p_string16 IN VARCHAR2,
38 p_string17 IN VARCHAR2,
39 p_string18 IN VARCHAR2,
40 p_string19 IN VARCHAR2,
41 p_string20 IN VARCHAR2,
42 p_string21 IN VARCHAR2,
43 p_string22 IN VARCHAR2,
44 p_string23 IN VARCHAR2,
45 p_string24 IN VARCHAR2,
46 p_string25 IN VARCHAR2,
47 p_string26 IN VARCHAR2,
48 p_string27 IN VARCHAR2,
49 p_string28 IN VARCHAR2,
50 p_string29 IN VARCHAR2,
51 p_string30 IN VARCHAR2,
52 p_string31 IN VARCHAR2,
53 p_string32 IN VARCHAR2,
54 p_string33 IN VARCHAR2,
55 p_string34 IN VARCHAR2,
56 p_string35 IN VARCHAR2,
57 p_string36 IN VARCHAR2,
58 p_string37 IN VARCHAR2,
59 p_string38 IN VARCHAR2,
60 p_string39 IN VARCHAR2,
61 p_string40 IN VARCHAR2,
62 p_string41 IN VARCHAR2,
63 p_string42 IN VARCHAR2,
64 p_string43 IN VARCHAR2,
65 p_string44 IN VARCHAR2,
66 p_string45 IN VARCHAR2,
67 p_string46 IN VARCHAR2,
68 p_string47 IN VARCHAR2,
69 p_string48 IN VARCHAR2,
70 p_string49 IN VARCHAR2,
71 p_string50 IN VARCHAR2,
72 p_string51 IN VARCHAR2,
73 p_string52 IN VARCHAR2,
74 p_string53 IN VARCHAR2,
75 p_string54 IN VARCHAR2,
76 p_string55 IN VARCHAR2,
77 p_string56 IN VARCHAR2,
78 p_string57 IN VARCHAR2,
79 p_string58 IN VARCHAR2,
80 p_string59 IN VARCHAR2,
81 p_string60 IN VARCHAR2,
82 p_string61 IN VARCHAR2,
83 p_string62 IN VARCHAR2,
84 p_string63 IN VARCHAR2,
85 p_string64 IN VARCHAR2,
86 p_string65 IN VARCHAR2,
87 p_string66 IN VARCHAR2)
88 RETURN VARCHAR2;
89
90 -- Wrapper function over
91 -- QA_PARENT_CHILD_PKG.APPLICABLE_CHILD_PLANS_EQR
92 -- ntungare Tue Apr 18 22:17:12 PDT 2006
93 --
94 FUNCTION APPLICABLE_CHILD_PLANS_EQR (p_plan_id IN NUMBER,
95 p_string1 IN VARCHAR2,
96 p_string2 IN VARCHAR2,
97 p_string3 IN VARCHAR2,
98 p_string4 IN VARCHAR2,
99 p_string5 IN VARCHAR2,
100 p_string6 IN VARCHAR2,
101 p_string7 IN VARCHAR2,
102 p_string8 IN VARCHAR2,
103 p_string9 IN VARCHAR2,
104 p_string10 IN VARCHAR2,
105 p_string11 IN VARCHAR2,
106 p_string12 IN VARCHAR2,
107 p_string13 IN VARCHAR2,
108 p_string14 IN VARCHAR2,
109 p_string15 IN VARCHAR2,
110 p_string16 IN VARCHAR2,
111 p_string17 IN VARCHAR2,
112 p_string18 IN VARCHAR2,
113 p_string19 IN VARCHAR2,
114 p_string20 IN VARCHAR2,
115 p_string21 IN VARCHAR2,
116 p_string22 IN VARCHAR2,
117 p_string23 IN VARCHAR2,
118 p_string24 IN VARCHAR2,
119 p_string25 IN VARCHAR2,
120 p_string26 IN VARCHAR2,
121 p_string27 IN VARCHAR2,
122 p_string28 IN VARCHAR2,
123 p_string29 IN VARCHAR2,
124 p_string30 IN VARCHAR2,
125 p_string31 IN VARCHAR2,
126 p_string32 IN VARCHAR2,
127 p_string33 IN VARCHAR2,
128 p_string34 IN VARCHAR2,
129 p_string35 IN VARCHAR2,
130 p_string36 IN VARCHAR2,
131 p_string37 IN VARCHAR2,
132 p_string38 IN VARCHAR2,
133 p_string39 IN VARCHAR2,
134 p_string40 IN VARCHAR2,
135 p_string41 IN VARCHAR2,
136 p_string42 IN VARCHAR2,
137 p_string43 IN VARCHAR2,
138 p_string44 IN VARCHAR2,
139 p_string45 IN VARCHAR2,
140 p_string46 IN VARCHAR2,
141 p_string47 IN VARCHAR2,
142 p_string48 IN VARCHAR2,
143 p_string49 IN VARCHAR2,
144 p_string50 IN VARCHAR2,
145 p_string51 IN VARCHAR2,
146 p_string52 IN VARCHAR2,
147 p_string53 IN VARCHAR2,
148 p_string54 IN VARCHAR2,
149 p_string55 IN VARCHAR2,
150 p_string56 IN VARCHAR2,
151 p_string57 IN VARCHAR2,
152 p_string58 IN VARCHAR2,
153 p_string59 IN VARCHAR2,
154 p_string60 IN VARCHAR2,
155 p_string61 IN VARCHAR2,
156 p_string62 IN VARCHAR2,
157 p_string63 IN VARCHAR2,
158 p_string64 IN VARCHAR2,
159 p_string65 IN VARCHAR2,
160 p_string66 IN VARCHAR2)
161 RETURN VARCHAR2;
162
163 -- Wrapper function over
164 -- QA_SS_RESULTS.SSQR_VALIDATE_ROW
165 -- ntungare Tue Apr 18 22:17:12 PDT 2006
166 --
167 --
168 -- 12.1 QWB Usability Improvements
169 -- Added 2 ne wparameters one to rerurn a comma separated
170 -- list of the HC elements and the other to return a comma
171 -- separated list of the Normalized Ids
172 --
173 FUNCTION SSQR_VALIDATE_ROW (p_occurrence IN OUT NOCOPY NUMBER,
174 p_org_id IN NUMBER,
175 p_plan_id IN NUMBER,
176 p_spec_id IN NUMBER,
177 p_collection_id IN NUMBER,
178 p_result1 IN VARCHAR2,
179 p_result2 IN VARCHAR2,
180 p_enabled IN INTEGER,
181 p_committed IN INTEGER,
182 p_transaction_number IN NUMBER,
183 p_transaction_id IN NUMBER DEFAULT 0,
184 p_string1 IN VARCHAR2,
185 p_string2 IN VARCHAR2,
186 p_string3 IN VARCHAR2,
187 p_string4 IN VARCHAR2,
188 p_string5 IN VARCHAR2,
189 p_string6 IN VARCHAR2,
190 p_string7 IN VARCHAR2,
191 p_string8 IN VARCHAR2,
192 p_string9 IN VARCHAR2,
193 p_string10 IN VARCHAR2,
194 p_string11 IN VARCHAR2,
195 p_string12 IN VARCHAR2,
196 p_string13 IN VARCHAR2,
197 p_string14 IN VARCHAR2,
198 p_string15 IN VARCHAR2,
199 p_string16 IN VARCHAR2,
200 p_string17 IN VARCHAR2,
201 p_string18 IN VARCHAR2,
202 p_string19 IN VARCHAR2,
203 p_string20 IN VARCHAR2,
204 p_string21 IN VARCHAR2,
205 p_string22 IN VARCHAR2,
206 p_string23 IN VARCHAR2,
207 p_string24 IN VARCHAR2,
208 p_string25 IN VARCHAR2,
209 p_string26 IN VARCHAR2,
210 p_string27 IN VARCHAR2,
211 p_string28 IN VARCHAR2,
212 p_string29 IN VARCHAR2,
213 p_string30 IN VARCHAR2,
214 p_string31 IN VARCHAR2,
215 p_string32 IN VARCHAR2,
216 p_string33 IN VARCHAR2,
217 p_string34 IN VARCHAR2,
218 p_string35 IN VARCHAR2,
219 p_string36 IN VARCHAR2,
220 p_string37 IN VARCHAR2,
221 p_string38 IN VARCHAR2,
222 p_string39 IN VARCHAR2,
223 p_string40 IN VARCHAR2,
224 p_string41 IN VARCHAR2,
225 p_string42 IN VARCHAR2,
226 p_string43 IN VARCHAR2,
227 p_string44 IN VARCHAR2,
228 p_string45 IN VARCHAR2,
229 p_string46 IN VARCHAR2,
230 p_string47 IN VARCHAR2,
231 p_string48 IN VARCHAR2,
232 p_string49 IN VARCHAR2,
233 p_string50 IN VARCHAR2,
234 p_string51 IN VARCHAR2,
235 p_string52 IN VARCHAR2,
236 p_string53 IN VARCHAR2,
237 p_string54 IN VARCHAR2,
238 p_string55 IN VARCHAR2,
239 p_string56 IN VARCHAR2,
240 p_string57 IN VARCHAR2,
241 p_string58 IN VARCHAR2,
242 p_string59 IN VARCHAR2,
243 p_string60 IN VARCHAR2,
244 p_string61 IN VARCHAR2,
245 p_string62 IN VARCHAR2,
246 p_string63 IN VARCHAR2,
247 p_string64 IN VARCHAR2,
248 p_string65 IN VARCHAR2,
249 p_string66 IN VARCHAR2,
250 x_messages OUT NOCOPY VARCHAR2,
251 x_charid_str OUT NOCOPY VARCHAR2,
252 x_id_str OUT NOCOPY VARCHAR2)
253 RETURN INTEGER ;
254
255 -- Wrapper function over
256 -- QA_SS_RESULTS.SSQR_POST_RESULT
257 -- ntungare Tue Apr 18 22:17:12 PDT 2006
258 --
259 -- 12.1 QWB Usability Improvements
260 -- added 2 new elements, one a comma separated list of the
261 -- Parent collection elements that would receive aggregated
262 -- values and the other a comma separated list of the
263 -- aggregated values.
264 --
265 FUNCTION SSQR_POST_RESULT(x_occurrence IN OUT NOCOPY NUMBER,
266 x_org_id IN NUMBER,
267 x_plan_id IN NUMBER,
268 x_spec_id IN NUMBER,
269 x_collection_id IN NUMBER,
270 x_txn_header_id IN NUMBER,
271 x_par_plan_id IN NUMBER,
272 x_par_col_id IN NUMBER,
273 x_par_occ IN NUMBER,
274 x_result1 IN VARCHAR2,
275 x_result2 IN VARCHAR2,
276 x_enabled IN INTEGER,
277 x_committed IN INTEGER,
278 x_transaction_number IN NUMBER,
282 p_string4 IN VARCHAR2,
279 p_string1 IN VARCHAR2,
280 p_string2 IN VARCHAR2,
281 p_string3 IN VARCHAR2,
283 p_string5 IN VARCHAR2,
284 p_string6 IN VARCHAR2,
285 p_string7 IN VARCHAR2,
286 p_string8 IN VARCHAR2,
287 p_string9 IN VARCHAR2,
288 p_string10 IN VARCHAR2,
289 p_string11 IN VARCHAR2,
290 p_string12 IN VARCHAR2,
291 p_string13 IN VARCHAR2,
292 p_string14 IN VARCHAR2,
293 p_string15 IN VARCHAR2,
294 p_string16 IN VARCHAR2,
295 p_string17 IN VARCHAR2,
296 p_string18 IN VARCHAR2,
297 p_string19 IN VARCHAR2,
298 p_string20 IN VARCHAR2,
299 p_string21 IN VARCHAR2,
300 p_string22 IN VARCHAR2,
301 p_string23 IN VARCHAR2,
302 p_string24 IN VARCHAR2,
303 p_string25 IN VARCHAR2,
304 p_string26 IN VARCHAR2,
305 p_string27 IN VARCHAR2,
306 p_string28 IN VARCHAR2,
307 p_string29 IN VARCHAR2,
308 p_string30 IN VARCHAR2,
309 p_string31 IN VARCHAR2,
310 p_string32 IN VARCHAR2,
311 p_string33 IN VARCHAR2,
312 p_string34 IN VARCHAR2,
313 p_string35 IN VARCHAR2,
314 p_string36 IN VARCHAR2,
315 p_string37 IN VARCHAR2,
316 p_string38 IN VARCHAR2,
317 p_string39 IN VARCHAR2,
318 p_string40 IN VARCHAR2,
319 p_string41 IN VARCHAR2,
320 p_string42 IN VARCHAR2,
321 p_string43 IN VARCHAR2,
322 p_string44 IN VARCHAR2,
323 p_string45 IN VARCHAR2,
324 p_string46 IN VARCHAR2,
325 p_string47 IN VARCHAR2,
326 p_string48 IN VARCHAR2,
327 p_string49 IN VARCHAR2,
328 p_string50 IN VARCHAR2,
329 p_string51 IN VARCHAR2,
330 p_string52 IN VARCHAR2,
331 p_string53 IN VARCHAR2,
332 p_string54 IN VARCHAR2,
333 p_string55 IN VARCHAR2,
334 p_string56 IN VARCHAR2,
335 p_string57 IN VARCHAR2,
336 p_string58 IN VARCHAR2,
337 p_string59 IN VARCHAR2,
338 p_string60 IN VARCHAR2,
339 p_string61 IN VARCHAR2,
340 p_string62 IN VARCHAR2,
341 p_string63 IN VARCHAR2,
342 p_string64 IN VARCHAR2,
343 p_string65 IN VARCHAR2,
344 p_string66 IN VARCHAR2,
345 x_messages OUT NOCOPY VARCHAR2,
346 x_agg_elements OUT NOCOPY VARCHAR2,
347 x_agg_val OUT NOCOPY VARCHAR2,
348 p_last_update_date IN DATE DEFAULT SYSDATE)
349 RETURN INTEGER;
350
351 -- Wrapper function over
352 -- QA_SS_RESULTS.SSQR_UPDATE_RESULT,
353 -- ntungare Tue Apr 18 22:17:12 PDT 2006
354 --
355 --
356 -- Bug 6881303
357 -- added 2 new elements, one a comma separated list of the
358 -- Parent collection elements that would receive aggregated
359 -- values and the other a comma separated list of the
360 -- aggregated values.
361 -- ntungare Fri Mar 21 01:19:03 PDT 2008
362 --
363 FUNCTION SSQR_UPDATE_RESULT(x_occurrence IN NUMBER,
364 x_org_id IN NUMBER,
365 x_plan_id IN NUMBER,
366 x_spec_id IN NUMBER,
367 x_collection_id IN NUMBER,
368 x_txn_header_id IN NUMBER,
369 x_par_plan_id IN NUMBER,
370 x_par_col_id IN NUMBER,
371 x_par_occ IN NUMBER,
372 x_result1 IN VARCHAR2,
373 x_result2 IN VARCHAR2,
374 x_enabled IN INTEGER,
375 x_committed IN INTEGER,
376 x_transaction_number IN NUMBER,
377 p_string1 IN VARCHAR2,
378 p_string2 IN VARCHAR2,
379 p_string3 IN VARCHAR2,
380 p_string4 IN VARCHAR2,
381 p_string5 IN VARCHAR2,
382 p_string6 IN VARCHAR2,
386 p_string10 IN VARCHAR2,
383 p_string7 IN VARCHAR2,
384 p_string8 IN VARCHAR2,
385 p_string9 IN VARCHAR2,
387 p_string11 IN VARCHAR2,
388 p_string12 IN VARCHAR2,
389 p_string13 IN VARCHAR2,
390 p_string14 IN VARCHAR2,
391 p_string15 IN VARCHAR2,
392 p_string16 IN VARCHAR2,
393 p_string17 IN VARCHAR2,
394 p_string18 IN VARCHAR2,
395 p_string19 IN VARCHAR2,
396 p_string20 IN VARCHAR2,
397 p_string21 IN VARCHAR2,
398 p_string22 IN VARCHAR2,
399 p_string23 IN VARCHAR2,
400 p_string24 IN VARCHAR2,
401 p_string25 IN VARCHAR2,
402 p_string26 IN VARCHAR2,
403 p_string27 IN VARCHAR2,
404 p_string28 IN VARCHAR2,
405 p_string29 IN VARCHAR2,
406 p_string30 IN VARCHAR2,
407 p_string31 IN VARCHAR2,
408 p_string32 IN VARCHAR2,
409 p_string33 IN VARCHAR2,
410 p_string34 IN VARCHAR2,
411 p_string35 IN VARCHAR2,
412 p_string36 IN VARCHAR2,
413 p_string37 IN VARCHAR2,
414 p_string38 IN VARCHAR2,
415 p_string39 IN VARCHAR2,
416 p_string40 IN VARCHAR2,
417 p_string41 IN VARCHAR2,
418 p_string42 IN VARCHAR2,
419 p_string43 IN VARCHAR2,
420 p_string44 IN VARCHAR2,
421 p_string45 IN VARCHAR2,
422 p_string46 IN VARCHAR2,
423 p_string47 IN VARCHAR2,
424 p_string48 IN VARCHAR2,
425 p_string49 IN VARCHAR2,
426 p_string50 IN VARCHAR2,
427 p_string51 IN VARCHAR2,
428 p_string52 IN VARCHAR2,
429 p_string53 IN VARCHAR2,
430 p_string54 IN VARCHAR2,
431 p_string55 IN VARCHAR2,
432 p_string56 IN VARCHAR2,
433 p_string57 IN VARCHAR2,
434 p_string58 IN VARCHAR2,
435 p_string59 IN VARCHAR2,
436 p_string60 IN VARCHAR2,
437 p_string61 IN VARCHAR2,
438 p_string62 IN VARCHAR2,
439 p_string63 IN VARCHAR2,
440 p_string64 IN VARCHAR2,
441 p_string65 IN VARCHAR2,
442 p_string66 IN VARCHAR2,
443 x_messages OUT NOCOPY VARCHAR2,
444 x_agg_elements OUT NOCOPY VARCHAR2,
445 x_agg_val OUT NOCOPY VARCHAR2,
446 p_last_update_date IN DATE DEFAULT SYSDATE)
447 RETURN INTEGER;
448
449 END;