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_DIAGNOSTIC_ARG

Line 217: from jtf_diagnostic_arg

213: V_SIZE number;
214:
215: cursor arglist is
216: select argname, argvalue, rownumber, valuesetnumber
217: from jtf_diagnostic_arg
218: where TestClassName = P_TESTCLASSNAME
219: and groupname = P_GROUPNAME
220: and appid = P_APPID
221: order by rownumber;

Line 409: delete from jtf_diagnostic_arg

405:
406: delete from jtf_diagnostic_test
407: where appid = P_APP_NAME;
408:
409: delete from jtf_diagnostic_arg
410: where appid = P_APP_NAME;
411:
412: delete from jtf_diagnostic_prereq
413: where sourceappid = P_APP_NAME;

Line 622: -- from the jtf_diagnostic_arg table

618: end loop;
619: close TESTLIST;
620:
621: -- cleanup all information about this testcase (testcase arguments)
622: -- from the jtf_diagnostic_arg table
623:
624: delete from jtf_diagnostic_arg
625: where groupname = P_GROUP_NAME
626: and appid = P_APP_NAME

Line 624: delete from jtf_diagnostic_arg

620:
621: -- cleanup all information about this testcase (testcase arguments)
622: -- from the jtf_diagnostic_arg table
623:
624: delete from jtf_diagnostic_arg
625: where groupname = P_GROUP_NAME
626: and appid = P_APP_NAME
627: and testclassname = P_TEST_CLASS_NAME;
628:

Line 659: delete from jtf_diagnostic_arg

655: P_TEST_CLASS_NAME IN VARCHAR2
656: ) IS
657:
658: BEGIN
659: delete from jtf_diagnostic_arg
660: where testclassname = P_TEST_CLASS_NAME
661: and groupname = P_GROUP_NAME
662: and appid = P_APP_NAME;
663: END DELETE_ALL_ARGS_FOR_TEST;

Line 687: delete from jtf_diagnostic_arg

683: -- testcase where we get the rownumber from the UI / Java layer
684: -- where each rownumber corresponds to one combination of
685: -- arguments which we will just delete
686:
687: delete from jtf_diagnostic_arg
688: where testclassname = P_TEST_CLASS_NAME
689: and groupname = P_GROUP_NAME
690: and appid = P_APP_NAME
691: and rownumber = P_ARG_ROW_NUM;

Line 705: update jtf_diagnostic_arg

701: where testclassname = P_TEST_CLASS_NAME
702: and groupname = P_GROUP_NAME
703: and appid = P_APP_NAME;
704:
705: update jtf_diagnostic_arg
706: set rownumber = (rownumber - 1),
707: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
708: LAST_UPDATE_DATE = SYSDATE
709: where testclassname = P_TEST_CLASS_NAME

Line 944: update jtf_diagnostic_arg set

940:
941: loop
942: if p_argnames.EXISTS(v_index) AND p_argvalues.exists(v_index) then
943:
944: update jtf_diagnostic_arg set
945: argvalue = p_argvalues(v_index),
946: object_version_number = object_version_number + 1,
947: -- last_updated_by = UID,
948: last_updated_by = P_LUBID,

Line 1429: v_rownumber jtf_diagnostic_arg.rownumber%TYPE;

1425: p_arg_values in jtf_varchar2_table_4000,
1426: p_lubid in number) IS
1427:
1428: V_SOURCETYPE BINARY_INTEGER := 1;
1429: v_rownumber jtf_diagnostic_arg.rownumber%TYPE;
1430: v_valsetnumber jtf_diagnostic_arg.valuesetnumber%TYPE;
1431:
1432: BEGIN
1433: -- first check if the application is valid

Line 1430: v_valsetnumber jtf_diagnostic_arg.valuesetnumber%TYPE;

1426: p_lubid in number) IS
1427:
1428: V_SOURCETYPE BINARY_INTEGER := 1;
1429: v_rownumber jtf_diagnostic_arg.rownumber%TYPE;
1430: v_valsetnumber jtf_diagnostic_arg.valuesetnumber%TYPE;
1431:
1432: BEGIN
1433: -- first check if the application is valid
1434:

Line 1463: from jtf_diagnostic_arg where testclassname = p_test_class_name

1459: -- then get the max row number and increment it by 1
1460: -- max row number is for this testclassname only
1461:
1462: select max(rownumber) into v_rownumber
1463: from jtf_diagnostic_arg where testclassname = p_test_class_name
1464: and groupname = p_group_name and appid = p_appid;
1465:
1466: if sql%notfound or v_rownumber = 0 then
1467: v_rownumber := 1;

Line 1473: select JTF_DIAGNOSTIC_ARG_VAL_SET_S.nextval

1469: end if;
1470:
1471: -- now get the max valuesetnumber and increment it by 1
1472:
1473: select JTF_DIAGNOSTIC_ARG_VAL_SET_S.nextval
1474: into v_valsetnumber from dual;
1475:
1476: -- select max(valuesetnumber) into v_valsetnumber
1477: -- from jtf_diagnostic_arg;

Line 1477: -- from jtf_diagnostic_arg;

1473: select JTF_DIAGNOSTIC_ARG_VAL_SET_S.nextval
1474: into v_valsetnumber from dual;
1475:
1476: -- select max(valuesetnumber) into v_valsetnumber
1477: -- from jtf_diagnostic_arg;
1478:
1479: -- if sql%notfound or v_valsetnumber = 0 then
1480: -- v_valsetnumber := 1;
1481: -- else v_valsetnumber := v_valsetnumber + 1;

Line 1489: insert into jtf_diagnostic_arg(

1485: V_SOURCETYPE := 1;
1486: loop
1487: if p_arg_names.exists(v_sourcetype) then
1488:
1489: insert into jtf_diagnostic_arg(
1490: SEQUENCE, TESTCLASSNAME, GROUPNAME,
1491: APPID, ARGNAME, ARGVALUE,
1492: ROWNUMBER, VALUESETNUMBER, OBJECT_VERSION_NUMBER,
1493: CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,

Line 1496: JTF_DIAGNOSTIC_ARG_S.NEXTVAL, p_test_class_name, p_group_name,

1492: ROWNUMBER, VALUESETNUMBER, OBJECT_VERSION_NUMBER,
1493: CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
1494: LAST_UPDATE_LOGIN, CREATION_DATE)
1495: values(
1496: JTF_DIAGNOSTIC_ARG_S.NEXTVAL, p_test_class_name, p_group_name,
1497: p_appid, p_arg_names(v_sourcetype), p_arg_values(v_sourcetype),
1498: decode(v_rownumber, null, 1, v_rownumber), v_valsetnumber, 1,
1499: p_lubid, SYSDATE, p_lubid,
1500: NULL, SYSDATE);

Line 1718: -- jtf_diagnostic_test, jtf_diagnostic_arg, jtf_diagnostic_prereq

1714:
1715:
1716: -- if flow of control reaches here, it is alright to
1717: -- rename the group across jtf_diagnostic_group,
1718: -- jtf_diagnostic_test, jtf_diagnostic_arg, jtf_diagnostic_prereq
1719:
1720:
1721: update jtf_diagnostic_group
1722: set groupname = p_newgroupname,

Line 1737: update jtf_diagnostic_arg

1733: LAST_UPDATED_BY = P_LUBID
1734: where groupname = p_groupname
1735: and appid = p_appid;
1736:
1737: update jtf_diagnostic_arg
1738: set groupname = p_newgroupname,
1739: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
1740: LAST_UPDATE_DATE = SYSDATE,
1741: LAST_UPDATED_BY = P_LUBID

Line 2279: from jtf_diagnostic_arg

2275:
2276: begin
2277: select LAST_UPDATED_BY, LAST_UPDATE_DATE
2278: into db_luby, db_ludate
2279: from jtf_diagnostic_arg
2280: where appid = p_appid
2281: and groupname = p_groupname
2282: and testclassname = p_testclassname
2283: and argname = p_argname

Line 2297: update jtf_diagnostic_arg

2293: p_cust_mode))
2294: then*/
2295: -- seed data must not be changed by customers.Hence overwriting data always
2296: -- so that it covers up any changes by mistake
2297: update jtf_diagnostic_arg
2298: set last_updated_by = f_luby,
2299: argvalue = p_argvalue,
2300: VALUESETNUMBER = p_VALUESETNUMBER,
2301: last_update_date = f_ludate,

Line 2316: insert into jtf_diagnostic_arg(

2312:
2313: when no_data_found then
2314: -- Record doesn't exist - insert in all cases
2315:
2316: insert into jtf_diagnostic_arg(
2317: SEQUENCE,
2318: TESTCLASSNAME,
2319: GROUPNAME,
2320: APPID,

Line 2333: jtf_diagnostic_arg_s.nextval,

2329: LAST_UPDATE_LOGIN,
2330: CREATION_DATE,
2331: SECURITY_GROUP_ID)
2332: values(
2333: jtf_diagnostic_arg_s.nextval,
2334: p_testclassname,
2335: p_groupname,
2336: p_appid,
2337: p_argname,