1 PACKAGE JTF_DIAGNOSTIC AUTHID CURRENT_USER AS
2 /* $Header: jtfdiagnostic_s.pls 120.18 2011/03/07 15:45:38 tshort 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 -- Updates a tests end date in the database
134 -- ----------------------------------------------------------------------
135
136 procedure UPDATE_TEST_END_DATE(
137 P_APP_NAME IN VARCHAR2,
138 P_GROUP_NAME IN VARCHAR2,
139 P_TEST_NAME IN VARCHAR2,
140 P_END_DATE IN DATE default null,
141 P_LUBID IN NUMBER
142 );
143
144 -- ----------------------------------------------------------------------
145 -- Delete all information about a testcase given an application short
146 -- name and a group. This includes all all arguments related to
147 -- the test in the group and any prereqs
148 -- ----------------------------------------------------------------------
149
150 procedure DELETE_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 -- ----------------------------------------------------------------------
160 -- Delete all arguments pertaining to a testcase.
161 -- ----------------------------------------------------------------------
162 procedure DELETE_ALL_ARGS_FOR_TEST(
163 P_APP_NAME IN VARCHAR2,
164 P_GROUP_NAME IN VARCHAR2,
165 P_TEST_CLASS_NAME IN VARCHAR2
166 );
167
168
169
170 -- ----------------------------------------------------------------------
171 -- Delete an argument combination pertaining to a testcase. We use the
172 -- argument row number to identify a combination for a test case
173 -- ----------------------------------------------------------------------
174
175 procedure DELETE_ARG_SET(
176 P_APP_NAME IN VARCHAR2,
177 P_GROUP_NAME IN VARCHAR2,
178 P_TEST_CLASS_NAME IN VARCHAR2,
179 P_ARG_ROW_NUM IN NUMBER
180 );
181
182
183 -- ----------------------------------------------------------------------
184 -- Delete a decl test step and it's decl test step columns
185 -- ----------------------------------------------------------------------
186
187 procedure DELETE_DECL_TEST_STEP(
188 P_APPID IN VARCHAR2,
189 P_GROUPNAME IN VARCHAR2,
190 P_TESTCLASSNAME IN VARCHAR2,
191 P_TESTSTEPNAME IN VARCHAR2
192 );
193
194 -- ----------------------------------------------------------------------
195 -- Update sequences of groups given an appid and the given array of
196 -- complete group names which should be valid groupnames
197 -- and an array of corresponding sequence numbers
198 -- ----------------------------------------------------------------------
199
200 procedure UPDATE_GROUP_SEQ(
201 P_APPID IN VARCHAR2,
202 P_GROUPNAMES IN JTF_VARCHAR2_TABLE_4000,
203 P_LUBID IN NUMBER);
204
205 procedure UPDATE_GROUP_SEQ(
206 P_APPID IN VARCHAR2,
207 P_GROUPNAMES IN JTF_VARCHAR2_TABLE_4000);
208
209 -- ----------------------------------------------------------------------
210 -- Update sequences of testname given an appid and groupname and given
211 -- array of complete testclassnames which should be valid groupnames
212 -- and corresponding array of sequence numbers
213 -- ----------------------------------------------------------------------
214
215 procedure UPDATE_TEST_SEQ(
216 P_APPID IN VARCHAR2,
217 P_GROUPNAME IN VARCHAR2,
218 P_TESTCLASSNAMES IN JTF_VARCHAR2_TABLE_4000,
219 P_LUBID IN NUMBER);
220
221 procedure UPDATE_TEST_SEQ(
222 P_APPID IN VARCHAR2,
223 P_GROUPNAME IN VARCHAR2,
224 P_TESTCLASSNAMES IN JTF_VARCHAR2_TABLE_4000);
225
226 -- ----------------------------------------------------------------------
227 -- Update prereqs of an application or a group within the application.
228 -- In either case (app or group), you should provide the appname
229 -- and an array of prereqs and the type (1 or 2)
230 -- ----------------------------------------------------------------------
231
232 procedure UPDATE_PREREQS(
233 P_SOURCEID IN VARCHAR2,
234 P_SOURCEAPPID IN VARCHAR2,
235 P_PREREQID IN JTF_VARCHAR2_TABLE_4000,
236 P_SOURCETYPE IN NUMBER,
237 P_LUBID IN NUMBER);
238
239 procedure UPDATE_PREREQS(
240 P_SOURCEID IN VARCHAR2,
241 P_SOURCEAPPID IN VARCHAR2,
242 P_PREREQID IN JTF_VARCHAR2_TABLE_4000,
243 P_SOURCETYPE IN NUMBER);
244
245 -- ----------------------------------------------------------------------
246 -- Update argument values of a testcase
247 -- You should provide the appname, testclassname, groupname, array of
248 -- argument names and corresponding argument values and the rownumber that
249 -- it corresponds with on the UI
250 -- ----------------------------------------------------------------------
251
252 procedure UPDATE_ARG_VALUES(
253 P_TESTCLASSNAME IN VARCHAR2,
254 P_GROUPNAME IN VARCHAR2,
255 P_APPID IN VARCHAR2,
256 P_ARGNAMES IN JTF_VARCHAR2_TABLE_4000,
257 P_ARGVALUES IN JTF_VARCHAR2_TABLE_4000,
258 P_ROWNUMBER IN NUMBER,
259 P_LUBID IN NUMBER
260 );
261
262 procedure UPDATE_ARG_VALUES(
263 P_TESTCLASSNAME IN VARCHAR2,
264 P_GROUPNAME IN VARCHAR2,
265 P_APPID IN VARCHAR2,
266 P_ARGNAMES IN JTF_VARCHAR2_TABLE_4000,
267 P_ARGVALUES IN JTF_VARCHAR2_TABLE_4000,
268 P_ROWNUMBER IN NUMBER
269 );
270
271 --mls
272 procedure UPDATE_ARG_VALUES(
273 P_TESTCLASSNAME IN VARCHAR2,
274 P_GROUPNAME IN VARCHAR2,
275 P_APPID IN VARCHAR2,
276 P_ARGNAMES IN JTF_VARCHAR2_TABLE_4000,
277 P_ARGVALUES IN JTF_VARCHAR2_TABLE_4000,
278 p_arg_dates in jtf_date_table,
279 p_arg_numbers in jtf_number_table,
280 P_ROWNUMBER IN NUMBER,
281 P_LUBID IN NUMBER
282 );
283
284
285 -- ----------------------------------------------------------------------
286 -- Insert an app into the framework with or without prereqs
287 -- ----------------------------------------------------------------------
288
289 procedure INSERT_APP(
290 P_APPID IN VARCHAR2,
291 P_PREREQID IN JTF_VARCHAR2_TABLE_4000,
292 P_LUBID IN NUMBER
293 );
294
295 procedure INSERT_APP(
296 P_APPID IN VARCHAR2,
297 P_PREREQID IN JTF_VARCHAR2_TABLE_4000
298 );
299
300 -- ----------------------------------------------------------------------
301 -- Insert Group with or without prereqs
302 -- ----------------------------------------------------------------------
303
304 procedure INSERT_GRP(
305 P_NEW_GROUP IN VARCHAR2,
306 P_APP IN VARCHAR2,
307 P_PREREQID IN JTF_VARCHAR2_TABLE_4000,
308 P_LUBID IN NUMBER
309 );
310
311 procedure INSERT_GRP(
312 P_NEW_GROUP IN VARCHAR2,
313 P_APP IN VARCHAR2,
314 P_PREREQID IN JTF_VARCHAR2_TABLE_4000
315 );
316
317
318
319 -- ----------------------------------------------------------------------
323 procedure INSERT_GROUP(
320 -- Insert Group with or without prereqs - deprecated
321 -- ----------------------------------------------------------------------
322
324 P_NEW_GROUP IN VARCHAR2,
325 P_APP IN VARCHAR2,
326 P_PREREQID IN JTF_VARCHAR2_TABLE_4000,
327 P_SENSITIVITY IN NUMBER,
328 P_LUBID IN NUMBER
329 );
330
331 procedure INSERT_GROUP(
332 P_NEW_GROUP IN VARCHAR2,
333 P_APP IN VARCHAR2,
334 P_PREREQID IN JTF_VARCHAR2_TABLE_4000,
335 P_SENSITIVITY IN NUMBER
336 );
337
338 -- ----------------------------------------------------------------------
339 -- Insert testcase to a group within an application
340 -- ----------------------------------------------------------------------
341
342 procedure GET_GROUP_SENSITIVITY(p_appid in varchar2,
343 p_group_name in varchar2,
344 p_sensitivity out NOCOPY number);
345
346 procedure INSERT_TESTCASE(p_testclassname in varchar2,
347 p_group_name in varchar2,
348 p_appid in varchar2,
349 p_test_type in varchar2,
350 P_SENSITIVITY IN NUMBER,
351 p_valid_apps_xml in varchar2,
352 p_end_date in date default null,
353 p_meta_data in varchar2,
354 p_lubid in number);
355
356 procedure INSERT_TESTCASE(p_testclassname in varchar2,
357 p_group_name in varchar2,
358 p_appid in varchar2,
359 p_test_type in varchar2,
360 p_lubid in number);
361
362 procedure INSERT_TESTCASE(p_testclassname in varchar2,
363 p_group_name in varchar2,
364 p_appid in varchar2,
365 p_test_type in varchar2);
366
367
368 -- ----------------------------------------------------------------------
369 -- Insert argument values for a testcase but one row only
370 -- ----------------------------------------------------------------------
371
372 procedure INSERT_ARGVALUE_ROW(p_appid in varchar2,
373 p_group_name in varchar2,
374 p_test_class_name in varchar2,
375 p_arg_names in jtf_varchar2_table_4000,
376 p_arg_values in jtf_varchar2_table_4000,
377 p_lubid in number);
378
379 procedure INSERT_ARGVALUE_ROW(p_appid in varchar2,
380 p_group_name in varchar2,
381 p_test_class_name in varchar2,
382 p_arg_names in jtf_varchar2_table_4000,
383 p_arg_values in jtf_varchar2_table_4000);
384
385 --mls
386 procedure INSERT_ARGVALUE_ROW(p_appid in varchar2,
387 p_group_name in varchar2,
388 p_test_class_name in varchar2,
389 p_arg_names in jtf_varchar2_table_4000,
390 p_arg_values in jtf_varchar2_table_4000,
391 p_arg_dates in jtf_date_table,
392 p_arg_numbers in jtf_number_table,
393 p_lubid in number);
394 --mls
395
396 ---------------------------------------------------------------------------
397 -- Checks if a group or application is valid. If application, it should
398 -- be registered with the diagnostic framework. If group then it should be
399 -- registered within the application
400 ---------------------------------------------------------------------------
401
402 procedure CHECK_APP_OR_GROUP_VALIDITY(
403 P_SOURCEID IN VARCHAR2,
404 P_SOURCEAPPID IN VARCHAR2,
405 P_SOURCETYPE IN NUMBER);
406
407
408 ---------------------------------------------------------------------------
409 -- Inserts array of applications or groups into the database but makes
410 -- sure that the application or group does not prereq itself and is
411 -- registered (application with the framework and group with the application)
412 ---------------------------------------------------------------------------
413
414
415 procedure PREREQ_INSERTION(
416 P_SOURCEID IN VARCHAR2,
417 P_SOURCEAPPID IN VARCHAR2,
418 P_PREREQID IN JTF_VARCHAR2_TABLE_4000,
419 P_SOURCETYPE IN NUMBER,
420 P_LUBID IN NUMBER);
421
422 procedure PREREQ_INSERTION(
423 P_SOURCEID IN VARCHAR2,
424 P_SOURCEAPPID IN VARCHAR2,
425 P_PREREQID IN JTF_VARCHAR2_TABLE_4000,
426 P_SOURCETYPE IN NUMBER);
427
428
429 ---------------------------------------------------------------------------
430 -- Rename a group within an application. This procedure makes sure that the
431 -- new group name does not clash with another name in the same application
432 ---------------------------------------------------------------------------
433
437 P_NEWGROUPNAME IN VARCHAR2,
434 procedure RENAME_GROUP(
435 P_APPID IN VARCHAR2,
436 P_GROUPNAME IN VARCHAR2,
438 P_LUBID IN NUMBER);
439
440
441 procedure RENAME_GROUP(
442 P_APPID IN VARCHAR2,
443 P_GROUPNAME IN VARCHAR2,
444 P_NEWGROUPNAME IN VARCHAR2);
445
446
447 ---------------------------------------------------------------------------
448 -- Upload an application row from the ldt file
449 ---------------------------------------------------------------------------
450
451 PROCEDURE LOAD_ROW_APP(
452 P_APPID IN VARCHAR2,
453 P_LUDATE IN VARCHAR2,
454 P_SEC_GRP_ID IN VARCHAR2,
455 P_CUST_MODE IN VARCHAR2,
456 P_OWNER IN VARCHAR2);
457
458
459 ---------------------------------------------------------------------------
460 -- Upload an application group row from the ldt file
461 ---------------------------------------------------------------------------
462
463 PROCEDURE LOAD_ROW_GROUP(
464 P_APPID IN VARCHAR2,
465 P_GROUPNAME IN VARCHAR2,
466 P_SENSITIVITY IN VARCHAR2,
467 P_LUDATE IN VARCHAR2,
468 P_SEC_GRP_ID IN VARCHAR2,
469 P_CUST_MODE IN VARCHAR2,
470 P_OWNER IN VARCHAR2);
471
472
473 ---------------------------------------------------------------------------
474 -- Upload an application group test row from the ldt file
475 ---------------------------------------------------------------------------
476
477 PROCEDURE LOAD_ROW_TEST(
478 P_APPID IN VARCHAR2,
479 P_GROUPNAME IN VARCHAR2,
480 P_TESTCLASSNAME IN VARCHAR2,
481 P_TESTTYPE IN VARCHAR2,
482 P_TOTALARGUMENTROWS IN VARCHAR2,
483 P_SENSITIVITY IN VARCHAR2,
484 P_LUDATE IN VARCHAR2,
485 P_SEC_GRP_ID IN VARCHAR2,
486 P_CUST_MODE IN VARCHAR2,
487 P_VALID_APPLICATIONS IN CLOB,
488 P_END_DATE IN VARCHAR2,
489 P_META_DATA IN VARCHAR2,
490 P_OWNER IN VARCHAR2);
491
492
493 ---------------------------------------------------------------------------
494 -- Upload arguments of a testcase from the ldt file
495 ---------------------------------------------------------------------------
496
497 PROCEDURE LOAD_ROW_ARG(
498 P_APPID IN VARCHAR2,
499 P_GROUPNAME IN VARCHAR2,
500 P_TESTCLASSNAME IN VARCHAR2,
501 P_ARGNAME IN VARCHAR2,
502 P_ROWNUMBER IN VARCHAR2,
503 P_ARGVALUE IN VARCHAR2,
504 P_VALUESETNUMBER IN VARCHAR2,
505 P_LUDATE IN VARCHAR2,
506 P_SEC_GRP_ID IN VARCHAR2,
507 P_CUST_MODE IN VARCHAR2,
508 P_OWNER IN VARCHAR2);
509
510
511 ---------------------------------------------------------------------------
512 -- Upload application or group prerequisites from the ldt file
513 ---------------------------------------------------------------------------
514
515 PROCEDURE LOAD_ROW_PREREQ(
516 P_SOURCEID IN VARCHAR2,
517 P_PREREQID IN VARCHAR2,
518 P_SOURCEAPPID IN VARCHAR2,
519 P_TYPE IN VARCHAR2,
520 P_LUDATE IN VARCHAR2,
521 P_SEC_GRP_ID IN VARCHAR2,
522 P_CUST_MODE IN VARCHAR2,
523 P_OWNER IN VARCHAR2);
524
525
526 PROCEDURE LOAD_ROW_TEST_STEPS(
527 P_APPID IN VARCHAR2,
528 P_GROUPNAME IN VARCHAR2,
529 P_TESTCLASSNAME IN VARCHAR2,
530 P_TESTSTEPNAME IN VARCHAR2,
531 P_EXECUTION_SEQUENCE IN VARCHAR2,
532 P_STEP_TYPE IN VARCHAR2,
533 P_STEP_DESCRIPTION IN VARCHAR2,
534 P_ERROR_TYPE IN VARCHAR2,
535 P_ERROR_MESSAGE IN VARCHAR2,
536 P_FIX_INFO IN VARCHAR2,
537 P_MULTI_ORG IN VARCHAR2,
538 P_TABLE_VIEW_NAME IN VARCHAR2,
539 P_WHERE_CLAUSE_OR_SQL IN VARCHAR2,
540 P_PROFILE_NAME IN VARCHAR2,
541 P_PROFILE_VALUE IN VARCHAR2,
542 P_LOGICAL_OPERATOR IN VARCHAR2,
543 P_FUNCTION_NAME IN VARCHAR2,
544 P_VALIDATION_VAL1 IN VARCHAR2,
545 P_VALIDATION_VAL2 IN VARCHAR2,
546 P_LAST_UPDATE_DATE IN VARCHAR2,
547 P_SECURITY_GROUP_ID IN VARCHAR2,
548 P_CUST_MODE IN VARCHAR2,
549 P_OWNER IN VARCHAR2);
550
551
552 PROCEDURE LOAD_ROW_STEP_COLS(
553 P_APPID IN VARCHAR2,
554 P_GROUPNAME IN VARCHAR2,
555 P_TESTCLASSNAME IN VARCHAR2,
556 P_TESTSTEPNAME IN VARCHAR2,
557 P_COLUMN_NAME IN VARCHAR2,
558 P_LOGICAL_OPERATOR IN VARCHAR2,
559 P_VALIDATION_VAL1 IN VARCHAR2,
560 P_VALIDATION_VAL2 IN VARCHAR2,
561 P_LAST_UPDATE_DATE IN VARCHAR2,
562 P_SECURITY_GROUP_ID IN VARCHAR2,
563 P_CUST_MODE IN VARCHAR2,
567 ---------------------------------------------------------------------------
564 P_OWNER IN VARCHAR2);
565
566
568 -- Upload a test's alert information row from the ldt file
569 ---------------------------------------------------------------------------
570
571 PROCEDURE LOAD_ROW_ALERT(
572 P_APPID IN VARCHAR2,
573 P_GROUPNAME IN VARCHAR2,
574 P_TESTCLASSNAME IN VARCHAR2,
575 P_TYPE IN VARCHAR2,
576 P_LEVEL_VALUE IN VARCHAR2,
577 P_LUDATE IN VARCHAR2,
578 P_SEC_GRP_ID IN VARCHAR2,
579 P_CUST_MODE IN VARCHAR2,
580 P_OWNER IN VARCHAR2);
581
582
583 ---------------------------------------------------------------------------
584 -- Upload a knowledge base information row from the ldt file
585 ---------------------------------------------------------------------------
586
587 PROCEDURE LOAD_ROW_KB(
588 P_APPID IN VARCHAR2,
589 P_GROUPNAME IN VARCHAR2,
590 P_TESTCLASSNAME IN VARCHAR2,
591 P_USER_TEST_NAME IN VARCHAR2,
592 P_METALINK_NOTE IN VARCHAR2,
593 P_COMPETENCY IN VARCHAR2,
594 P_SUBCOMPETENCY IN VARCHAR2,
595 P_PRODUCTS IN VARCHAR2,
596 P_TEST_TYPE IN VARCHAR2,
597 P_ANALYSIS_SCOPE IN VARCHAR2,
598 P_DESCRIPTION IN VARCHAR2,
599 P_SHORT_DESCR IN VARCHAR2,
600 P_USAGE_DESCR IN VARCHAR2,
601 P_KEYWORDS IN VARCHAR2,
602 P_COMPONENT IN VARCHAR2,
603 P_SUBCOMPONENT IN VARCHAR2,
604 P_HIGH_PRODUCT_VERSION IN VARCHAR2,
605 P_LOW_PRODUCT_VERSION IN VARCHAR2,
606 P_HIGH_PATCHSET IN VARCHAR2,
607 P_LOW_PATCHSET IN VARCHAR2,
608 P_LUDATE IN VARCHAR2,
609 P_SEC_GRP_ID IN VARCHAR2,
610 P_CUST_MODE IN VARCHAR2,
611 P_OWNER IN VARCHAR2);
612
613 ------------------------------------------------------------
614 -- procedure PARSE TEST CLASS NAME
615 ------------------------------------------------------------
616
617 procedure PARSE_TESTCLASSNAME(
618 P_TESTCLASSNAME IN VARCHAR2,
619 V_PRODUCT OUT NOCOPY VARCHAR2,
620 V_FILENAME OUT NOCOPY VARCHAR2);
621
622 -- ----------------------------------------------------------------------
623 -- Procedure to seed a test set from the ldt
624 -- ----------------------------------------------------------------------
625 PROCEDURE SEED_TESTSET(
626 P_NAME IN VARCHAR2,
627 P_DESCRIPTION IN VARCHAR2,
628 P_XML IN CLOB,
629 P_LUDATE IN VARCHAR2,
630 P_CUST_MODE IN VARCHAR2,
631 P_OWNER IN VARCHAR2);
632 -- ----------------------------------------------------------------------
633 -- Procedure to update a test set. The last updated date would be the
634 -- system date and the user info will be taken from FND_GLOBAL.user_id
635 -- ----------------------------------------------------------------------
636 PROCEDURE UPDATE_TESTSET(
637 P_NAME IN VARCHAR2,
638 P_DESCRIPTION IN VARCHAR2,
639 P_XML IN CLOB);
640 -- ----------------------------------------------------------------------
641 -- Procedure to update a test set providing the last updated information
642 -- ----------------------------------------------------------------------
643 PROCEDURE UPDATE_TESTSET(
644 P_NAME IN VARCHAR2,
645 P_DESCRIPTION IN VARCHAR2,
646 P_XML IN CLOB,
647 P_LAST_UPDATED_BY IN NUMBER,
648 P_LAST_UPDATED_DATE IN DATE);
649 -- ----------------------------------------------------------------------
650 -- Procedure to insert a test set. The last updated date, creation_date
651 -- would be the system date and the user info will be taken
652 -- from FND_GLOBAL.user_id
653 -- ----------------------------------------------------------------------
654 PROCEDURE INSERT_TESTSET(
655 P_NAME IN VARCHAR2,
656 P_DESCRIPTION IN VARCHAR2,
657 P_XML IN CLOB);
658 -- ----------------------------------------------------------------------
659 -- Procedure to insert a test set providing the creation and last updated
660 -- information
661 -- ----------------------------------------------------------------------
662 PROCEDURE INSERT_TESTSET(
663 P_NAME IN VARCHAR2,
664 P_DESCRIPTION IN VARCHAR2,
665 P_XML IN CLOB,
666 P_CREATED_BY IN NUMBER,
667 P_CREATION_DATE IN DATE,
668 P_LAST_UPDATE_LOGIN IN NUMBER,
669 P_LAST_UPDATED_BY IN NUMBER,
670 P_LAST_UPDATED_DATE IN DATE);
671
672 -- ---------------------------------------------------------------------------------------
673 -- Procedure to update valid applications for the test. The last updated date would be the
674 -- system date and the user info will be taken from FND_GLOBAL.user_id
675 -- ---------------------------------------------------------------------------------------
676 PROCEDURE UPDATE_VALID_APPS(
677 P_APPSHORTNAME IN VARCHAR2,
678 P_GROUPNAME IN VARCHAR2,
679 P_TESTCLASSNAME IN VARCHAR2,
680 P_VALIDAPPS IN VARCHAR2);
681 -- ------------------------------------------------------------------------------------------
682 -- Procedure to update valid applications for the test providing the last updated information
683 -- ------------------------------------------------------------------------------------------
684 PROCEDURE UPDATE_VALID_APPS(
685 P_APPSHORTNAME IN VARCHAR2,
686 P_GROUPNAME IN VARCHAR2,
687 P_TESTCLASSNAME IN VARCHAR2,
688 P_VALIDAPPS IN VARCHAR2,
689 P_LAST_UPDATED_BY IN NUMBER,
690 P_LAST_UPDATED_DATE IN DATE);
691
692 -- ------------------------------------------------------------------------------------------
693 -- Function used to validate whether the user is having the privilege to execute the test
694 -- or not. This function takes sensitivity & valid applications at test level as parameters
695 -- and checks if user is having the privilege to execute the test
696 -- ------------------------------------------------------------------------------------------
697 FUNCTION VALIDATE_APPLICATIONS(
698 P_SENSITIVITY NUMBER,
699 P_VALID_APPS_XML XMLTYPE)
700 RETURN NUMBER;
701
702 -- ------------------------------------------------------------------------------------------
703 -- Function to return an arraylist of custom applications w.r.t seeded application
704 -- ------------------------------------------------------------------------------------------
705 FUNCTION GET_CUSTOM_APPS(SEEDED_APP VARCHAR2)
706 RETURN JTF_DIAG_ARRAYLIST;
707
708 -- ------------------------------------------------------------------------------------------
709 -- Function to return an app id from app short name
710 -- ------------------------------------------------------------------------------------------
711 FUNCTION GET_APP_ID(APP_SHORT_NAME VARCHAR2)
712 RETURN INTEGER;
713
714 -- ------------------------------------------------------------------------------------------
715 -- Function to return an array of custom applications w.r.t seeded application
716 -- ------------------------------------------------------------------------------------------
717 FUNCTION GET_CUSTOM_APPS_ARRAY(APP_SHORT_NAME VARCHAR2)
718 RETURN jtf_varchar2_table_100;
719
720 END JTF_DIAGNOSTIC;