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_DECLARATIVE_DIAGNOSTIC dependencies on JTF_VARCHAR2_TABLE_4000

Line 18: P_COLNAMES_ARRAY IN JTF_VARCHAR2_TABLE_4000,

14: P_APPID IN VARCHAR2,
15: P_GROUPNAME IN VARCHAR2,
16: P_TESTCLASSNAME IN VARCHAR2,
17: P_TESTSTEPNAME IN VARCHAR2,
18: P_COLNAMES_ARRAY IN JTF_VARCHAR2_TABLE_4000,
19: P_LOGOP_ARRAY IN JTF_VARCHAR2_TABLE_4000,
20: P_VAL1_ARRAY IN JTF_VARCHAR2_TABLE_4000,
21: P_VAL2_ARRAY IN JTF_VARCHAR2_TABLE_4000,
22: ISUPDATE IN VARCHAR2,

Line 19: P_LOGOP_ARRAY IN JTF_VARCHAR2_TABLE_4000,

15: P_GROUPNAME IN VARCHAR2,
16: P_TESTCLASSNAME IN VARCHAR2,
17: P_TESTSTEPNAME IN VARCHAR2,
18: P_COLNAMES_ARRAY IN JTF_VARCHAR2_TABLE_4000,
19: P_LOGOP_ARRAY IN JTF_VARCHAR2_TABLE_4000,
20: P_VAL1_ARRAY IN JTF_VARCHAR2_TABLE_4000,
21: P_VAL2_ARRAY IN JTF_VARCHAR2_TABLE_4000,
22: ISUPDATE IN VARCHAR2,
23: P_LUBID IN NUMBER) IS

Line 20: P_VAL1_ARRAY IN JTF_VARCHAR2_TABLE_4000,

16: P_TESTCLASSNAME IN VARCHAR2,
17: P_TESTSTEPNAME IN VARCHAR2,
18: P_COLNAMES_ARRAY IN JTF_VARCHAR2_TABLE_4000,
19: P_LOGOP_ARRAY IN JTF_VARCHAR2_TABLE_4000,
20: P_VAL1_ARRAY IN JTF_VARCHAR2_TABLE_4000,
21: P_VAL2_ARRAY IN JTF_VARCHAR2_TABLE_4000,
22: ISUPDATE IN VARCHAR2,
23: P_LUBID IN NUMBER) IS
24:

Line 21: P_VAL2_ARRAY IN JTF_VARCHAR2_TABLE_4000,

17: P_TESTSTEPNAME IN VARCHAR2,
18: P_COLNAMES_ARRAY IN JTF_VARCHAR2_TABLE_4000,
19: P_LOGOP_ARRAY IN JTF_VARCHAR2_TABLE_4000,
20: P_VAL1_ARRAY IN JTF_VARCHAR2_TABLE_4000,
21: P_VAL2_ARRAY IN JTF_VARCHAR2_TABLE_4000,
22: ISUPDATE IN VARCHAR2,
23: P_LUBID IN NUMBER) IS
24:
25: V_INDEX NUMBER;

Line 121: sysParamNames IN JTF_VARCHAR2_TABLE_4000,

117: p_logicalOperator IN VARCHAR2,
118: p_validationVal1 IN VARCHAR2,
119: p_validationVal2 IN VARCHAR2,
120: p_whereClauseOrSQL IN VARCHAR2,
121: sysParamNames IN JTF_VARCHAR2_TABLE_4000,
122: sysParamValues IN JTF_VARCHAR2_TABLE_4000,
123: p_ordernumber IN NUMBER) IS
124:
125: reportStr LONG;

Line 122: sysParamValues IN JTF_VARCHAR2_TABLE_4000,

118: p_validationVal1 IN VARCHAR2,
119: p_validationVal2 IN VARCHAR2,
120: p_whereClauseOrSQL IN VARCHAR2,
121: sysParamNames IN JTF_VARCHAR2_TABLE_4000,
122: sysParamValues IN JTF_VARCHAR2_TABLE_4000,
123: p_ordernumber IN NUMBER) IS
124:
125: reportStr LONG;
126: statusStr VARCHAR2(50); -- SUCCESS or FAILURE

Line 349: v_selectValue JTF_VARCHAR2_TABLE_4000;

345: v_count3 number;
346: v_cursorID integer;
347: v_dummy INTEGER;
348:
349: v_selectValue JTF_VARCHAR2_TABLE_4000;
350: v_columnNames JTF_VARCHAR2_TABLE_4000;
351: v_logicalOp JTF_VARCHAR2_TABLE_4000;
352: v_validVal1 JTF_VARCHAR2_TABLE_4000;
353: v_validVal2 JTF_VARCHAR2_TABLE_4000;

Line 350: v_columnNames JTF_VARCHAR2_TABLE_4000;

346: v_cursorID integer;
347: v_dummy INTEGER;
348:
349: v_selectValue JTF_VARCHAR2_TABLE_4000;
350: v_columnNames JTF_VARCHAR2_TABLE_4000;
351: v_logicalOp JTF_VARCHAR2_TABLE_4000;
352: v_validVal1 JTF_VARCHAR2_TABLE_4000;
353: v_validVal2 JTF_VARCHAR2_TABLE_4000;
354:

Line 351: v_logicalOp JTF_VARCHAR2_TABLE_4000;

347: v_dummy INTEGER;
348:
349: v_selectValue JTF_VARCHAR2_TABLE_4000;
350: v_columnNames JTF_VARCHAR2_TABLE_4000;
351: v_logicalOp JTF_VARCHAR2_TABLE_4000;
352: v_validVal1 JTF_VARCHAR2_TABLE_4000;
353: v_validVal2 JTF_VARCHAR2_TABLE_4000;
354:
355: cursor datalist is

Line 352: v_validVal1 JTF_VARCHAR2_TABLE_4000;

348:
349: v_selectValue JTF_VARCHAR2_TABLE_4000;
350: v_columnNames JTF_VARCHAR2_TABLE_4000;
351: v_logicalOp JTF_VARCHAR2_TABLE_4000;
352: v_validVal1 JTF_VARCHAR2_TABLE_4000;
353: v_validVal2 JTF_VARCHAR2_TABLE_4000;
354:
355: cursor datalist is
356: select COLUMN_NAME, LOGICAL_OPERATOR,

Line 353: v_validVal2 JTF_VARCHAR2_TABLE_4000;

349: v_selectValue JTF_VARCHAR2_TABLE_4000;
350: v_columnNames JTF_VARCHAR2_TABLE_4000;
351: v_logicalOp JTF_VARCHAR2_TABLE_4000;
352: v_validVal1 JTF_VARCHAR2_TABLE_4000;
353: v_validVal2 JTF_VARCHAR2_TABLE_4000;
354:
355: cursor datalist is
356: select COLUMN_NAME, LOGICAL_OPERATOR,
357: VALIDATION_VAL1, VALIDATION_VAL2

Line 379: v_columnNames := JTF_VARCHAR2_TABLE_4000();

375: -- DETAILS_STRING:= DETAILS_STRING || '';
376: -- instantiate the data structures for
377: -- loading data, etc
378:
379: v_columnNames := JTF_VARCHAR2_TABLE_4000();
380: v_logicalOp := JTF_VARCHAR2_TABLE_4000();
381: v_validVal1 := JTF_VARCHAR2_TABLE_4000();
382: v_validVal2 := JTF_VARCHAR2_TABLE_4000();
383:

Line 380: v_logicalOp := JTF_VARCHAR2_TABLE_4000();

376: -- instantiate the data structures for
377: -- loading data, etc
378:
379: v_columnNames := JTF_VARCHAR2_TABLE_4000();
380: v_logicalOp := JTF_VARCHAR2_TABLE_4000();
381: v_validVal1 := JTF_VARCHAR2_TABLE_4000();
382: v_validVal2 := JTF_VARCHAR2_TABLE_4000();
383:
384: FOR x in datalist

Line 381: v_validVal1 := JTF_VARCHAR2_TABLE_4000();

377: -- loading data, etc
378:
379: v_columnNames := JTF_VARCHAR2_TABLE_4000();
380: v_logicalOp := JTF_VARCHAR2_TABLE_4000();
381: v_validVal1 := JTF_VARCHAR2_TABLE_4000();
382: v_validVal2 := JTF_VARCHAR2_TABLE_4000();
383:
384: FOR x in datalist
385: LOOP

Line 382: v_validVal2 := JTF_VARCHAR2_TABLE_4000();

378:
379: v_columnNames := JTF_VARCHAR2_TABLE_4000();
380: v_logicalOp := JTF_VARCHAR2_TABLE_4000();
381: v_validVal1 := JTF_VARCHAR2_TABLE_4000();
382: v_validVal2 := JTF_VARCHAR2_TABLE_4000();
383:
384: FOR x in datalist
385: LOOP
386: v_count := v_count + 1;

Line 457: v_selectValue := JTF_VARCHAR2_TABLE_4000();

453:
454: -- again loop and bind the column values
455: -- to the datastructure for retrieval
456:
457: v_selectValue := JTF_VARCHAR2_TABLE_4000();
458: for v_count2 in 1 .. v_count loop
459: v_selectValue.extend;
460: DBMS_SQL.DEFINE_COLUMN(v_cursorID, v_count2, v_selectValue(v_count2), 3000);
461: end loop;

Line 701: sysParamNames IN JTF_VARCHAR2_TABLE_4000,

697: step_failed IN OUT NOCOPY BOOLEAN,
698: summary_String IN OUT NOCOPY VARCHAR2,
699: DETAILS_STRING IN OUT NOCOPY VARCHAR2,
700: ORDERNUMBER IN OUT NOCOPY NUMBER,
701: sysParamNames IN JTF_VARCHAR2_TABLE_4000,
702: sysParamValues IN JTF_VARCHAR2_TABLE_4000) IS
703:
704: v_detailsstr VARCHAR2(4000);
705: v_header VARCHAR2(300);

Line 702: sysParamValues IN JTF_VARCHAR2_TABLE_4000) IS

698: summary_String IN OUT NOCOPY VARCHAR2,
699: DETAILS_STRING IN OUT NOCOPY VARCHAR2,
700: ORDERNUMBER IN OUT NOCOPY NUMBER,
701: sysParamNames IN JTF_VARCHAR2_TABLE_4000,
702: sysParamValues IN JTF_VARCHAR2_TABLE_4000) IS
703:
704: v_detailsstr VARCHAR2(4000);
705: v_header VARCHAR2(300);
706: v_count integer;

Line 1177: P_STEPSEQARRAY IN JTF_VARCHAR2_TABLE_4000,

1173: PROCEDURE UPDATE_STEP_SEQ(
1174: P_APPID IN VARCHAR2,
1175: P_GROUPNAME IN VARCHAR2,
1176: P_TESTCLASSNAME IN VARCHAR2,
1177: P_STEPSEQARRAY IN JTF_VARCHAR2_TABLE_4000,
1178: P_LUBID IN NUMBER) IS
1179:
1180: v_numofrows NUMBER;
1181: v_index BINARY_INTEGER := 1;

Line 1436: p_teststepnames OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

1432: PROCEDURE GET_TEST_STEPS(
1433: p_appid IN VARCHAR2,
1434: p_groupName IN VARCHAR2,
1435: p_testclassname IN VARCHAR2,
1436: p_teststepnames OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
1437: p_teststepdesc OUT NOCOPY JTF_VARCHAR2_TABLE_4000) IS
1438:
1439: V_SIZE NUMBER;
1440:

Line 1437: p_teststepdesc OUT NOCOPY JTF_VARCHAR2_TABLE_4000) IS

1433: p_appid IN VARCHAR2,
1434: p_groupName IN VARCHAR2,
1435: p_testclassname IN VARCHAR2,
1436: p_teststepnames OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
1437: p_teststepdesc OUT NOCOPY JTF_VARCHAR2_TABLE_4000) IS
1438:
1439: V_SIZE NUMBER;
1440:
1441: cursor testlist is

Line 1451: p_teststepnames := JTF_VARCHAR2_TABLE_4000();

1447: and TESTCLASSNAME = p_TESTCLASSNAME
1448: order by EXECUTION_SEQUENCE;
1449:
1450: BEGIN
1451: p_teststepnames := JTF_VARCHAR2_TABLE_4000();
1452: p_teststepdesc := JTF_VARCHAR2_TABLE_4000();
1453:
1454: V_SIZE := 0;
1455:

Line 1452: p_teststepdesc := JTF_VARCHAR2_TABLE_4000();

1448: order by EXECUTION_SEQUENCE;
1449:
1450: BEGIN
1451: p_teststepnames := JTF_VARCHAR2_TABLE_4000();
1452: p_teststepdesc := JTF_VARCHAR2_TABLE_4000();
1453:
1454: V_SIZE := 0;
1455:
1456: FOR x in testlist

Line 1474: P_DELSTEPARRAY IN JTF_VARCHAR2_TABLE_4000) IS

1470: PROCEDURE DELETE_STEPS(
1471: P_APPID IN VARCHAR2,
1472: P_GROUPNAME IN VARCHAR2,
1473: P_TESTCLASSNAME IN VARCHAR2,
1474: P_DELSTEPARRAY IN JTF_VARCHAR2_TABLE_4000) IS
1475:
1476: v_index BINARY_INTEGER := 1;
1477: v_execution_sequence number;
1478: v_step_type varchar2(100);