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 178: P_GROUPNAMES IN JTF_VARCHAR2_TABLE_4000,

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,

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

Line 194: P_TESTCLASSNAMES IN JTF_VARCHAR2_TABLE_4000,

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,

Line 200: P_TESTCLASSNAMES IN JTF_VARCHAR2_TABLE_4000);

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

Line 211: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,

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(

Line 218: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,

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

Line 232: P_ARGNAMES IN JTF_VARCHAR2_TABLE_4000,

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

Line 233: P_ARGVALUES IN JTF_VARCHAR2_TABLE_4000,

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:

Line 242: P_ARGNAMES IN JTF_VARCHAR2_TABLE_4000,

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:

Line 243: P_ARGVALUES IN JTF_VARCHAR2_TABLE_4000,

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:

Line 255: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,

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(

Line 261: P_PREREQID IN JTF_VARCHAR2_TABLE_4000

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

Line 271: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,

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(

Line 278: P_PREREQID IN JTF_VARCHAR2_TABLE_4000

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:

Line 290: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,

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:

Line 298: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,

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

Line 337: p_arg_names in jtf_varchar2_table_4000,

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,
339: p_lubid in number);
340:
341: procedure INSERT_ARGVALUE_ROW(p_appid in varchar2,

Line 338: p_arg_values in jtf_varchar2_table_4000,

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,
339: p_lubid in number);
340:
341: procedure INSERT_ARGVALUE_ROW(p_appid in varchar2,
342: p_group_name in varchar2,

Line 344: p_arg_names in jtf_varchar2_table_4000,

340:
341: procedure INSERT_ARGVALUE_ROW(p_appid in varchar2,
342: p_group_name 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: ---------------------------------------------------------------------------

Line 345: p_arg_values in jtf_varchar2_table_4000);

341: procedure INSERT_ARGVALUE_ROW(p_appid in varchar2,
342: p_group_name 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

Line 370: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,

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(

Line 377: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,

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