eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_DIAGNOSTIC dependencies on JTF_VARCHAR2_TABLE_4000

Line 10: P_APPS OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

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:

Line 11: P_APPNAMES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

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: -- ----------------------------------------------------------------------

Line 22: P_GROUPNAMES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

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:

Line 36: P_TESTCLASSNAMES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

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

Line 37: P_TESTTYPES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

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: );

Line 47: P_TESTCLASSNAMES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

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: );

Line 48: P_TESTTYPES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

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:

Line 62: P_ARGNAMES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

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: );

Line 63: P_ARGVALUES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

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:

Line 77: P_PREREQ_IDS OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

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:

Line 78: P_PREREQ_NAMES OUT NOCOPY JTF_VARCHAR2_TABLE_4000

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: -- ----------------------------------------------------------------------

Line 202: P_GROUPNAMES IN JTF_VARCHAR2_TABLE_4000,

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,

Line 207: 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

Line 218: P_TESTCLASSNAMES IN JTF_VARCHAR2_TABLE_4000,

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,

Line 224: P_TESTCLASSNAMES IN JTF_VARCHAR2_TABLE_4000);

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

Line 235: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,

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(

Line 242: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,

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

Line 256: P_ARGNAMES IN JTF_VARCHAR2_TABLE_4000,

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: );

Line 257: P_ARGVALUES IN JTF_VARCHAR2_TABLE_4000,

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:

Line 266: P_ARGNAMES IN JTF_VARCHAR2_TABLE_4000,

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:

Line 267: P_ARGVALUES IN JTF_VARCHAR2_TABLE_4000,

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

Line 276: P_ARGNAMES IN JTF_VARCHAR2_TABLE_4000,

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,

Line 277: P_ARGVALUES IN JTF_VARCHAR2_TABLE_4000,

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

Line 291: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,

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(

Line 297: P_PREREQID IN JTF_VARCHAR2_TABLE_4000

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

Line 307: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,

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(

Line 314: P_PREREQID IN JTF_VARCHAR2_TABLE_4000

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:

Line 326: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,

322:
323: procedure INSERT_GROUP(
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:

Line 334: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,

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: -- ----------------------------------------------------------------------

Line 375: p_arg_names in jtf_varchar2_table_4000,

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,

Line 376: p_arg_values in jtf_varchar2_table_4000,

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,

Line 382: p_arg_names in jtf_varchar2_table_4000,

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,

Line 383: p_arg_values in jtf_varchar2_table_4000);

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,

Line 389: p_arg_names in jtf_varchar2_table_4000,

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);

Line 390: p_arg_values in jtf_varchar2_table_4000,

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

Line 418: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,

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(

Line 425: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,

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: ---------------------------------------------------------------------------