1 PACKAGE JTF_DIAGNOSTIC AS
2 /* $Header: jtfdiagnostic_s.pls 120.11.12010000.3 2008/10/30 10:05:01 nandral ship $ */
3
4
5 -- ----------------------------------------------------------------------
6 -- Get all application names registered with the diagnostic framework
7 -- ----------------------------------------------------------------------
8
9 procedure GET_APPS(
10 P_APPS OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
11 P_APPNAMES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
12 P_SIZE OUT NOCOPY NUMBER
13 );
14
15 -- ----------------------------------------------------------------------
16 -- Get all the group names associated with a particular application
17 -- ----------------------------------------------------------------------
18
19 /* 5953806 - changed p_grp_created_by to be p_grp_last_updated_by */
20 procedure GET_GROUPS(
21 P_APPNAME in VARCHAR2,
22 P_GROUPNAMES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
23 P_GRP_SENSITIVITY OUT NOCOPY JTF_NUMBER_TABLE,
24 P_GRP_LAST_UPDATED_BY OUT NOCOPY JTF_NUMBER_TABLE
25 );
26
27 -- ----------------------------------------------------------------------
28 -- Get all the test case information associated with the
29 -- group and application
30 -- ----------------------------------------------------------------------
31
32 /* 5953806 - changed p_test_created_by to be p_test_last_updated_by */
33 procedure GET_TESTS(
34 P_APPNAME IN VARCHAR2,
35 P_GROUPNAME IN VARCHAR2,
36 P_TESTCLASSNAMES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
37 P_TESTTYPES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
38 P_TOTALARGROWS OUT NOCOPY JTF_NUMBER_TABLE,
39 P_TST_SENSITIVITY OUT NOCOPY JTF_NUMBER_TABLE,
40 P_TEST_LAST_UPDATED_BY OUT NOCOPY JTF_NUMBER_TABLE
41 );
42
43 -- deprecated don't use if you have test level sensitivity
44 procedure GET_TESTS(
45 P_APPNAME IN VARCHAR2,
46 P_GROUPNAME IN VARCHAR2,
47 P_TESTCLASSNAMES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
48 P_TESTTYPES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
49 P_TOTALARGROWS OUT NOCOPY JTF_NUMBER_TABLE,
50 P_TEST_LAST_UPDATED_BY OUT NOCOPY JTF_NUMBER_TABLE
51 );
52
53 -- ----------------------------------------------------------------------
54 -- Get all argument information associated with the testclassname,
55 -- the groupname and the application name
56 -- ----------------------------------------------------------------------
57
58 procedure GET_ARGS(
59 P_APPID IN VARCHAR2,
60 P_GROUPNAME IN VARCHAR2,
61 P_TESTCLASSNAME IN VARCHAR2,
62 P_ARGNAMES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
63 P_ARGVALUES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
64 P_ROWNUMBERS OUT NOCOPY JTF_NUMBER_TABLE,
65 P_VALUESETNUM OUT NOCOPY JTF_NUMBER_TABLE
66 );
67
68 -- ----------------------------------------------------------------------
69 -- Get all the prerequisites for a given group or an application
70 -- in anycase there should be an application name received
71 -- whether or not it is already an application or not
72 -- ----------------------------------------------------------------------
73
74 procedure GET_PREREQS(
75 P_APP_OR_GROUP_NAME IN VARCHAR2,
76 P_APPNAME IN VARCHAR2,
77 P_PREREQ_IDS OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
78 P_PREREQ_NAMES OUT NOCOPY JTF_VARCHAR2_TABLE_4000
79 );
80
81
82 -- ----------------------------------------------------------------------
83 -- Delete all information about an app given an application short name.
84 -- This includes all groups, tests related to the groups, all arguments related to
85 -- every test in the group and any prereqs
86 -- ----------------------------------------------------------------------
87
88 procedure DELETE_APP(
89 P_APP_NAME IN VARCHAR2
90 );
91
92 -- ----------------------------------------------------------------------
93 -- Delete all information about a group given an application short name.
94 -- This includes all tests related to the group, all arguments related to
95 -- every test in the group and any prereqs
96 -- ----------------------------------------------------------------------
97
98 procedure DELETE_GROUP(
99 P_APP_NAME IN VARCHAR2,
100 P_GROUP_NAME IN VARCHAR2
101 );
102
103 -- ----------------------------------------------------------------------
104 -- Updates a groups sensitivity in the database
105 -- ----------------------------------------------------------------------
106
107 procedure UPDATE_GROUP_SENSITIVITY(
108 P_APP_NAME IN VARCHAR2,
109 P_GROUP_NAME IN VARCHAR2,
110 P_GRP_SENSITIVITY IN NUMBER,
111 P_LUBID IN NUMBER
112 );
113
114 procedure UPDATE_GROUP_SENSITIVITY(
115 P_APP_NAME IN VARCHAR2,
116 P_GROUP_NAME IN VARCHAR2,
117 P_GRP_SENSITIVITY IN NUMBER
118 );
119
120 -- ----------------------------------------------------------------------
121 -- Updates a tests sensitivity in the database
122 -- ----------------------------------------------------------------------
123
124 procedure UPDATE_TEST_SENSITIVITY(
125 P_APP_NAME IN VARCHAR2,
126 P_GROUP_NAME IN VARCHAR2,
127 P_TEST_NAME IN VARCHAR2,
128 P_TST_SENSITIVITY IN NUMBER,
129 P_LUBID IN NUMBER
130 );
131
132 -- ----------------------------------------------------------------------
133 -- Delete all information about a testcase given an application short
134 -- name and a group. This includes all all arguments related to
135 -- the test in the group and any prereqs
136 -- ----------------------------------------------------------------------
137
138 procedure DELETE_TEST(
139 P_APP_NAME IN VARCHAR2,
140 P_GROUP_NAME IN VARCHAR2,
141 P_TEST_CLASS_NAME IN VARCHAR2
142 );
143
144
145
146
147 -- ----------------------------------------------------------------------
148 -- Delete all arguments pertaining to a testcase.
149 -- ----------------------------------------------------------------------
150 procedure DELETE_ALL_ARGS_FOR_TEST(
151 P_APP_NAME IN VARCHAR2,
152 P_GROUP_NAME IN VARCHAR2,
153 P_TEST_CLASS_NAME IN VARCHAR2
154 );
155
156
157
158 -- ----------------------------------------------------------------------
159 -- Delete an argument combination pertaining to a testcase. We use the
160 -- argument row number to identify a combination for a test case
161 -- ----------------------------------------------------------------------
162
163 procedure DELETE_ARG_SET(
164 P_APP_NAME IN VARCHAR2,
165 P_GROUP_NAME IN VARCHAR2,
166 P_TEST_CLASS_NAME IN VARCHAR2,
167 P_ARG_ROW_NUM IN NUMBER
168 );
169
170 -- ----------------------------------------------------------------------
171 -- Update sequences of groups given an appid and the given array of
172 -- complete group names which should be valid groupnames
173 -- and an array of corresponding sequence numbers
174 -- ----------------------------------------------------------------------
175
176 procedure UPDATE_GROUP_SEQ(
177 P_APPID IN VARCHAR2,
178 P_GROUPNAMES IN JTF_VARCHAR2_TABLE_4000,
179 P_LUBID IN NUMBER);
180
181 procedure UPDATE_GROUP_SEQ(
182 P_APPID IN VARCHAR2,
183 P_GROUPNAMES IN JTF_VARCHAR2_TABLE_4000);
184
185 -- ----------------------------------------------------------------------
186 -- Update sequences of testname given an appid and groupname and given
187 -- array of complete testclassnames which should be valid groupnames
188 -- and corresponding array of sequence numbers
189 -- ----------------------------------------------------------------------
190
191 procedure UPDATE_TEST_SEQ(
192 P_APPID IN VARCHAR2,
193 P_GROUPNAME IN VARCHAR2,
194 P_TESTCLASSNAMES IN JTF_VARCHAR2_TABLE_4000,
195 P_LUBID IN NUMBER);
196
197 procedure UPDATE_TEST_SEQ(
198 P_APPID IN VARCHAR2,
199 P_GROUPNAME IN VARCHAR2,
200 P_TESTCLASSNAMES IN JTF_VARCHAR2_TABLE_4000);
201
202 -- ----------------------------------------------------------------------
203 -- Update prereqs of an application or a group within the application.
204 -- In either case (app or group), you should provide the appname
205 -- and an array of prereqs and the type (1 or 2)
206 -- ----------------------------------------------------------------------
207
208 procedure UPDATE_PREREQS(
209 P_SOURCEID IN VARCHAR2,
210 P_SOURCEAPPID IN VARCHAR2,
211 P_PREREQID IN JTF_VARCHAR2_TABLE_4000,
212 P_SOURCETYPE IN NUMBER,
213 P_LUBID IN NUMBER);
214
215 procedure UPDATE_PREREQS(
216 P_SOURCEID IN VARCHAR2,
217 P_SOURCEAPPID IN VARCHAR2,
218 P_PREREQID IN JTF_VARCHAR2_TABLE_4000,
219 P_SOURCETYPE IN NUMBER);
220
221 -- ----------------------------------------------------------------------
222 -- Update argument values of a testcase
223 -- You should provide the appname, testclassname, groupname, array of
224 -- argument names and corresponding argument values and the rownumber that
225 -- it corresponds with on the UI
226 -- ----------------------------------------------------------------------
227
228 procedure UPDATE_ARG_VALUES(
229 P_TESTCLASSNAME IN VARCHAR2,
230 P_GROUPNAME IN VARCHAR2,
231 P_APPID IN VARCHAR2,
232 P_ARGNAMES IN JTF_VARCHAR2_TABLE_4000,
233 P_ARGVALUES IN JTF_VARCHAR2_TABLE_4000,
234 P_ROWNUMBER IN NUMBER,
235 P_LUBID IN NUMBER
236 );
237
238 procedure UPDATE_ARG_VALUES(
239 P_TESTCLASSNAME IN VARCHAR2,
240 P_GROUPNAME IN VARCHAR2,
241 P_APPID IN VARCHAR2,
242 P_ARGNAMES IN JTF_VARCHAR2_TABLE_4000,
243 P_ARGVALUES IN JTF_VARCHAR2_TABLE_4000,
244 P_ROWNUMBER IN NUMBER
245 );
246
247
248
249 -- ----------------------------------------------------------------------
250 -- Insert an app into the framework with or without prereqs
251 -- ----------------------------------------------------------------------
252
253 procedure INSERT_APP(
254 P_APPID IN VARCHAR2,
255 P_PREREQID IN JTF_VARCHAR2_TABLE_4000,
256 P_LUBID IN NUMBER
257 );
258
259 procedure INSERT_APP(
260 P_APPID IN VARCHAR2,
261 P_PREREQID IN JTF_VARCHAR2_TABLE_4000
262 );
263
264 -- ----------------------------------------------------------------------
265 -- Insert Group with or without prereqs
266 -- ----------------------------------------------------------------------
267
268 procedure INSERT_GRP(
269 P_NEW_GROUP IN VARCHAR2,
270 P_APP IN VARCHAR2,
271 P_PREREQID IN JTF_VARCHAR2_TABLE_4000,
272 P_LUBID IN NUMBER
273 );
274
275 procedure INSERT_GRP(
276 P_NEW_GROUP IN VARCHAR2,
277 P_APP IN VARCHAR2,
278 P_PREREQID IN JTF_VARCHAR2_TABLE_4000
279 );
280
281
282
283 -- ----------------------------------------------------------------------
284 -- Insert Group with or without prereqs - deprecated
285 -- ----------------------------------------------------------------------
286
287 procedure INSERT_GROUP(
288 P_NEW_GROUP IN VARCHAR2,
289 P_APP IN VARCHAR2,
290 P_PREREQID IN JTF_VARCHAR2_TABLE_4000,
291 P_SENSITIVITY IN NUMBER,
292 P_LUBID IN NUMBER
293 );
294
295 procedure INSERT_GROUP(
296 P_NEW_GROUP IN VARCHAR2,
297 P_APP IN VARCHAR2,
298 P_PREREQID IN JTF_VARCHAR2_TABLE_4000,
299 P_SENSITIVITY IN NUMBER
300 );
301
302 -- ----------------------------------------------------------------------
303 -- Insert testcase to a group within an application
304 -- ----------------------------------------------------------------------
305
306 procedure GET_GROUP_SENSITIVITY(p_appid in varchar2,
307 p_group_name in varchar2,
308 p_sensitivity out NOCOPY number);
309
310 procedure INSERT_TESTCASE(p_testclassname in varchar2,
311 p_group_name in varchar2,
312 p_appid in varchar2,
313 p_test_type in varchar2,
314 P_SENSITIVITY IN NUMBER,
315 p_valid_apps_xml in varchar2,
316 p_lubid in number);
317
318 procedure INSERT_TESTCASE(p_testclassname in varchar2,
319 p_group_name in varchar2,
320 p_appid in varchar2,
321 p_test_type in varchar2,
322 p_lubid in number);
323
324 procedure INSERT_TESTCASE(p_testclassname in varchar2,
325 p_group_name in varchar2,
326 p_appid in varchar2,
327 p_test_type in varchar2);
328
329
330 -- ----------------------------------------------------------------------
331 -- Insert argument values for a testcase but one row only
332 -- ----------------------------------------------------------------------
333
334 procedure INSERT_ARGVALUE_ROW(p_appid in varchar2,
335 p_group_name in varchar2,
336 p_test_class_name in varchar2,
337 p_arg_names in jtf_varchar2_table_4000,
338 p_arg_values in jtf_varchar2_table_4000,
342 p_group_name in varchar2,
339 p_lubid in number);
340
341 procedure INSERT_ARGVALUE_ROW(p_appid in varchar2,
343 p_test_class_name in varchar2,
344 p_arg_names in jtf_varchar2_table_4000,
345 p_arg_values in jtf_varchar2_table_4000);
346
347
348 ---------------------------------------------------------------------------
349 -- Checks if a group or application is valid. If application, it should
350 -- be registered with the diagnostic framework. If group then it should be
351 -- registered within the application
352 ---------------------------------------------------------------------------
353
354 procedure CHECK_APP_OR_GROUP_VALIDITY(
355 P_SOURCEID IN VARCHAR2,
356 P_SOURCEAPPID IN VARCHAR2,
357 P_SOURCETYPE IN NUMBER);
358
359
360 ---------------------------------------------------------------------------
361 -- Inserts array of applications or groups into the database but makes
362 -- sure that the application or group does not prereq itself and is
363 -- registered (application with the framework and group with the application)
364 ---------------------------------------------------------------------------
365
366
367 procedure PREREQ_INSERTION(
368 P_SOURCEID IN VARCHAR2,
369 P_SOURCEAPPID IN VARCHAR2,
370 P_PREREQID IN JTF_VARCHAR2_TABLE_4000,
371 P_SOURCETYPE IN NUMBER,
372 P_LUBID IN NUMBER);
373
374 procedure PREREQ_INSERTION(
375 P_SOURCEID IN VARCHAR2,
376 P_SOURCEAPPID IN VARCHAR2,
377 P_PREREQID IN JTF_VARCHAR2_TABLE_4000,
378 P_SOURCETYPE IN NUMBER);
379
380
381 ---------------------------------------------------------------------------
382 -- Rename a group within an application. This procedure makes sure that the
383 -- new group name does not clash with another name in the same application
384 ---------------------------------------------------------------------------
385
386 procedure RENAME_GROUP(
387 P_APPID IN VARCHAR2,
388 P_GROUPNAME IN VARCHAR2,
389 P_NEWGROUPNAME IN VARCHAR2,
390 P_LUBID IN NUMBER);
391
392
393 procedure RENAME_GROUP(
394 P_APPID IN VARCHAR2,
395 P_GROUPNAME IN VARCHAR2,
396 P_NEWGROUPNAME IN VARCHAR2);
397
398
399 ---------------------------------------------------------------------------
400 -- Upload an application row from the ldt file
401 ---------------------------------------------------------------------------
402
403 PROCEDURE LOAD_ROW_APP(
404 P_APPID IN VARCHAR2,
405 P_LUDATE IN VARCHAR2,
406 P_SEC_GRP_ID IN VARCHAR2,
407 P_CUST_MODE IN VARCHAR2,
408 P_OWNER IN VARCHAR2);
409
410
411 ---------------------------------------------------------------------------
412 -- Upload an application group row from the ldt file
413 ---------------------------------------------------------------------------
414
415 PROCEDURE LOAD_ROW_GROUP(
416 P_APPID IN VARCHAR2,
417 P_GROUPNAME IN VARCHAR2,
418 P_SENSITIVITY IN VARCHAR2,
419 P_LUDATE IN VARCHAR2,
420 P_SEC_GRP_ID IN VARCHAR2,
421 P_CUST_MODE IN VARCHAR2,
422 P_OWNER IN VARCHAR2);
423
424
425 ---------------------------------------------------------------------------
426 -- Upload an application group test row from the ldt file
427 ---------------------------------------------------------------------------
428
429 PROCEDURE LOAD_ROW_TEST(
430 P_APPID IN VARCHAR2,
431 P_GROUPNAME IN VARCHAR2,
432 P_TESTCLASSNAME IN VARCHAR2,
433 P_TESTTYPE IN VARCHAR2,
434 P_TOTALARGUMENTROWS IN VARCHAR2,
435 P_SENSITIVITY IN VARCHAR2,
436 P_LUDATE IN VARCHAR2,
437 P_SEC_GRP_ID IN VARCHAR2,
438 P_CUST_MODE IN VARCHAR2,
439 P_VALID_APPLICATIONS IN CLOB,
440 P_OWNER IN VARCHAR2);
441
442
443 ---------------------------------------------------------------------------
444 -- Upload arguments of a testcase from the ldt file
445 ---------------------------------------------------------------------------
446
447 PROCEDURE LOAD_ROW_ARG(
448 P_APPID IN VARCHAR2,
449 P_GROUPNAME IN VARCHAR2,
450 P_TESTCLASSNAME IN VARCHAR2,
451 P_ARGNAME IN VARCHAR2,
452 P_ROWNUMBER IN VARCHAR2,
453 P_ARGVALUE IN VARCHAR2,
454 P_VALUESETNUMBER IN VARCHAR2,
455 P_LUDATE IN VARCHAR2,
456 P_SEC_GRP_ID IN VARCHAR2,
457 P_CUST_MODE IN VARCHAR2,
458 P_OWNER IN VARCHAR2);
459
460
461 ---------------------------------------------------------------------------
462 -- Upload application or group prerequisites from the ldt file
463 ---------------------------------------------------------------------------
464
465 PROCEDURE LOAD_ROW_PREREQ(
466 P_SOURCEID IN VARCHAR2,
467 P_PREREQID IN VARCHAR2,
468 P_SOURCEAPPID IN VARCHAR2,
469 P_TYPE IN VARCHAR2,
470 P_LUDATE IN VARCHAR2,
471 P_SEC_GRP_ID IN VARCHAR2,
475
472 P_CUST_MODE IN VARCHAR2,
473 P_OWNER IN VARCHAR2);
474
476 PROCEDURE LOAD_ROW_TEST_STEPS(
477 P_APPID IN VARCHAR2,
478 P_GROUPNAME IN VARCHAR2,
479 P_TESTCLASSNAME IN VARCHAR2,
480 P_TESTSTEPNAME IN VARCHAR2,
481 P_EXECUTION_SEQUENCE IN VARCHAR2,
482 P_STEP_TYPE IN VARCHAR2,
483 P_STEP_DESCRIPTION IN VARCHAR2,
484 P_ERROR_TYPE IN VARCHAR2,
485 P_ERROR_MESSAGE IN VARCHAR2,
486 P_FIX_INFO IN VARCHAR2,
487 P_MULTI_ORG IN VARCHAR2,
488 P_TABLE_VIEW_NAME IN VARCHAR2,
489 P_WHERE_CLAUSE_OR_SQL IN VARCHAR2,
490 P_PROFILE_NAME IN VARCHAR2,
491 P_PROFILE_VALUE IN VARCHAR2,
492 P_LOGICAL_OPERATOR IN VARCHAR2,
493 P_FUNCTION_NAME IN VARCHAR2,
494 P_VALIDATION_VAL1 IN VARCHAR2,
495 P_VALIDATION_VAL2 IN VARCHAR2,
496 P_LAST_UPDATE_DATE IN VARCHAR2,
497 P_SECURITY_GROUP_ID IN VARCHAR2,
498 P_CUST_MODE IN VARCHAR2,
499 P_OWNER IN VARCHAR2);
500
501
502 PROCEDURE LOAD_ROW_STEP_COLS(
503 P_APPID IN VARCHAR2,
504 P_GROUPNAME IN VARCHAR2,
505 P_TESTCLASSNAME IN VARCHAR2,
506 P_TESTSTEPNAME IN VARCHAR2,
507 P_COLUMN_NAME IN VARCHAR2,
508 P_LOGICAL_OPERATOR IN VARCHAR2,
509 P_VALIDATION_VAL1 IN VARCHAR2,
510 P_VALIDATION_VAL2 IN VARCHAR2,
511 P_LAST_UPDATE_DATE IN VARCHAR2,
512 P_SECURITY_GROUP_ID IN VARCHAR2,
513 P_CUST_MODE IN VARCHAR2,
514 P_OWNER IN VARCHAR2);
515
516
517 ---------------------------------------------------------------------------
518 -- Upload a test's alert information row from the ldt file
519 ---------------------------------------------------------------------------
520
521 PROCEDURE LOAD_ROW_ALERT(
522 P_APPID IN VARCHAR2,
523 P_GROUPNAME IN VARCHAR2,
524 P_TESTCLASSNAME IN VARCHAR2,
525 P_TYPE IN VARCHAR2,
526 P_LEVEL_VALUE IN VARCHAR2,
527 P_LUDATE IN VARCHAR2,
528 P_SEC_GRP_ID IN VARCHAR2,
529 P_CUST_MODE IN VARCHAR2,
530 P_OWNER IN VARCHAR2);
531
532
533 ---------------------------------------------------------------------------
534 -- Upload a knowledge base information row from the ldt file
535 ---------------------------------------------------------------------------
536
537 PROCEDURE LOAD_ROW_KB(
538 P_APPID IN VARCHAR2,
539 P_GROUPNAME IN VARCHAR2,
540 P_TESTCLASSNAME IN VARCHAR2,
541 P_USER_TEST_NAME IN VARCHAR2,
542 P_METALINK_NOTE IN VARCHAR2,
543 P_COMPETENCY IN VARCHAR2,
544 P_SUBCOMPETENCY IN VARCHAR2,
545 P_PRODUCTS IN VARCHAR2,
546 P_TEST_TYPE IN VARCHAR2,
547 P_ANALYSIS_SCOPE IN VARCHAR2,
548 P_DESCRIPTION IN VARCHAR2,
549 P_SHORT_DESCR IN VARCHAR2,
550 P_USAGE_DESCR IN VARCHAR2,
551 P_KEYWORDS IN VARCHAR2,
552 P_COMPONENT IN VARCHAR2,
553 P_SUBCOMPONENT IN VARCHAR2,
554 P_HIGH_PRODUCT_VERSION IN VARCHAR2,
555 P_LOW_PRODUCT_VERSION IN VARCHAR2,
556 P_HIGH_PATCHSET IN VARCHAR2,
557 P_LOW_PATCHSET IN VARCHAR2,
558 P_LUDATE IN VARCHAR2,
559 P_SEC_GRP_ID IN VARCHAR2,
560 P_CUST_MODE IN VARCHAR2,
561 P_OWNER IN VARCHAR2);
562
563 ------------------------------------------------------------
564 -- procedure PARSE TEST CLASS NAME
565 ------------------------------------------------------------
566
567 procedure PARSE_TESTCLASSNAME(
568 P_TESTCLASSNAME IN VARCHAR2,
569 V_PRODUCT OUT NOCOPY VARCHAR2,
573 -- Procedure to seed a test set from the ldt
570 V_FILENAME OUT NOCOPY VARCHAR2);
571
572 -- ----------------------------------------------------------------------
574 -- ----------------------------------------------------------------------
575 PROCEDURE SEED_TESTSET(
576 P_NAME IN VARCHAR2,
577 P_DESCRIPTION IN VARCHAR2,
578 P_XML IN CLOB,
579 P_LUDATE IN VARCHAR2,
580 P_CUST_MODE IN VARCHAR2,
581 P_OWNER IN VARCHAR2);
582 -- ----------------------------------------------------------------------
583 -- Procedure to update a test set. The last updated date would be the
584 -- system date and the user info will be taken from FND_GLOBAL.user_id
585 -- ----------------------------------------------------------------------
586 PROCEDURE UPDATE_TESTSET(
587 P_NAME IN VARCHAR2,
588 P_DESCRIPTION IN VARCHAR2,
589 P_XML IN CLOB);
590 -- ----------------------------------------------------------------------
591 -- Procedure to update a test set providing the last updated information
592 -- ----------------------------------------------------------------------
593 PROCEDURE UPDATE_TESTSET(
594 P_NAME IN VARCHAR2,
595 P_DESCRIPTION IN VARCHAR2,
596 P_XML IN CLOB,
597 P_LAST_UPDATED_BY IN NUMBER,
598 P_LAST_UPDATED_DATE IN DATE);
599 -- ----------------------------------------------------------------------
600 -- Procedure to insert a test set. The last updated date, creation_date
601 -- would be the system date and the user info will be taken
602 -- from FND_GLOBAL.user_id
603 -- ----------------------------------------------------------------------
604 PROCEDURE INSERT_TESTSET(
605 P_NAME IN VARCHAR2,
606 P_DESCRIPTION IN VARCHAR2,
607 P_XML IN CLOB);
608 -- ----------------------------------------------------------------------
609 -- Procedure to insert a test set providing the creation and last updated
610 -- information
611 -- ----------------------------------------------------------------------
612 PROCEDURE INSERT_TESTSET(
613 P_NAME IN VARCHAR2,
614 P_DESCRIPTION IN VARCHAR2,
615 P_XML IN CLOB,
616 P_CREATED_BY IN NUMBER,
617 P_CREATION_DATE IN DATE,
618 P_LAST_UPDATE_LOGIN IN NUMBER,
619 P_LAST_UPDATED_BY IN NUMBER,
620 P_LAST_UPDATED_DATE IN DATE);
621
622 -- ---------------------------------------------------------------------------------------
623 -- Procedure to update valid applications for the test. The last updated date would be the
624 -- system date and the user info will be taken from FND_GLOBAL.user_id
625 -- ---------------------------------------------------------------------------------------
626 PROCEDURE UPDATE_VALID_APPS(
627 P_APPSHORTNAME IN VARCHAR2,
628 P_GROUPNAME IN VARCHAR2,
629 P_TESTCLASSNAME IN VARCHAR2,
630 P_VALIDAPPS IN VARCHAR2);
631 -- ------------------------------------------------------------------------------------------
632 -- Procedure to update valid applications for the test providing the last updated information
633 -- ------------------------------------------------------------------------------------------
634 PROCEDURE UPDATE_VALID_APPS(
635 P_APPSHORTNAME IN VARCHAR2,
636 P_GROUPNAME IN VARCHAR2,
637 P_TESTCLASSNAME IN VARCHAR2,
638 P_VALIDAPPS IN VARCHAR2,
639 P_LAST_UPDATED_BY IN NUMBER,
640 P_LAST_UPDATED_DATE IN DATE);
641
642 -- ------------------------------------------------------------------------------------------
643 -- Function used to validate whether the user is having the privilege to execute the test
644 -- or not. This function takes sensitivity & valid applications at test level as parameters
645 -- and checks if user is having the privilege to execute the test
646 -- ------------------------------------------------------------------------------------------
647 FUNCTION VALIDATE_APPLICATIONS(
648 P_SENSITIVITY NUMBER,
649 P_VALID_APPS_XML XMLTYPE)
650 RETURN NUMBER;
651
652 -- ------------------------------------------------------------------------------------------
653 -- Function to return an arraylist of custom applications w.r.t seeded application
654 -- ------------------------------------------------------------------------------------------
655 FUNCTION GET_CUSTOM_APPS(SEEDED_APP VARCHAR2)
656 RETURN JTF_DIAG_ARRAYLIST;
657
658 -- ------------------------------------------------------------------------------------------
659 -- Function to return an app id from app short name
660 -- ------------------------------------------------------------------------------------------
661 FUNCTION GET_APP_ID(APP_SHORT_NAME VARCHAR2)
662 RETURN INTEGER;
663
664 -- ------------------------------------------------------------------------------------------
665 -- Function to return an array of custom applications w.r.t seeded application
666 -- ------------------------------------------------------------------------------------------
667 FUNCTION GET_CUSTOM_APPS_ARRAY(APP_SHORT_NAME VARCHAR2)
668 RETURN jtf_varchar2_table_100;
669
670 END JTF_DIAGNOSTIC;