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_TEST

Line 123: from jtf_diagnostic_test

119:
120: /* 5953806 - changed select to get last_updated_by instead of created_by */
121: cursor testlist is
122: select testClassName, testtype, totalargumentrows, sensitivity, last_updated_by
123: from jtf_diagnostic_test
124: where appID like P_APPNAME
125: and groupname like P_GROUPNAME
126: order by orderNumber;
127:

Line 170: from jtf_diagnostic_test

166:
167: /* 5953806 - changed select to get last_updated_by instead of created_by */
168: cursor testlist is
169: select testClassName, testtype, totalargumentrows, last_updated_by
170: from jtf_diagnostic_test
171: where appID like P_APPNAME
172: and groupname like P_GROUPNAME
173: order by orderNumber;
174:

Line 373: UPDATE jtf_diagnostic_test

369: P_LUBID IN NUMBER
370: ) IS
371: BEGIN
372:
373: UPDATE jtf_diagnostic_test
374: SET sensitivity = P_TST_SENSITIVITY,
375: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
376: LAST_UPDATE_DATE = SYSDATE,
377: LAST_UPDATED_BY = P_LUBID

Line 406: delete from jtf_diagnostic_test

402:
403: delete from jtf_diagnostic_group
404: where appid = P_APP_NAME;
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;

Line 448: select testclassname from jtf_diagnostic_test

444: where appid = P_APP_NAME
445: and groupname = P_GROUP_NAME;
446:
447: CURSOR TSTLIST IS
448: select testclassname from jtf_diagnostic_test
449: where appid = P_APP_NAME
450: and groupname = P_GROUP_NAME;
451:
452: CURSOR GRPLIST (c_ordernumber number) IS

Line 550: V_ORDERNUM jtf_diagnostic_test.ordernumber%TYPE;

546: P_GROUP_NAME IN VARCHAR2,
547: P_TEST_CLASS_NAME IN VARCHAR2
548: ) IS
549:
550: V_ORDERNUM jtf_diagnostic_test.ordernumber%TYPE;
551: V_SEQUENCE jtf_diagnostic_test.sequence%TYPE;
552:
553: l_testclassname varchar2(1500);
554: l_ordernumber number;

Line 551: V_SEQUENCE jtf_diagnostic_test.sequence%TYPE;

547: P_TEST_CLASS_NAME IN VARCHAR2
548: ) IS
549:
550: V_ORDERNUM jtf_diagnostic_test.ordernumber%TYPE;
551: V_SEQUENCE jtf_diagnostic_test.sequence%TYPE;
552:
553: l_testclassname varchar2(1500);
554: l_ordernumber number;
555: l_object_version_number number;

Line 561: from jtf_diagnostic_test

557: check_extraneous_only boolean := false;
558:
559: CURSOR TESTLIST (c_ordernumber number) IS
560: select testclassname, ordernumber, object_version_number
561: from jtf_diagnostic_test
562: where appid = P_APP_NAME
563: and groupname = P_GROUP_NAME
564: and ordernumber > c_ordernumber
565: order by ordernumber;

Line 570: from jtf_diagnostic_test

566:
567: BEGIN
568:
569: select count(*) into V_ORDERNUM
570: from jtf_diagnostic_test
571: where APPID = P_APP_NAME
572: and groupname = P_GROUP_NAME
573: and testclassname = P_TEST_CLASS_NAME
574: and rownum <= 1;

Line 589: from jtf_diagnostic_test

585: -- great... we will use this sequence number to cleanup the
586: -- entry in the JTF_DIAGNOSTIC_KB table
587:
588: select sequence into V_SEQUENCE
589: from jtf_diagnostic_test
590: where APPID = P_APP_NAME
591: and groupname = P_GROUP_NAME
592: and testclassname = P_TEST_CLASS_NAME
593: and rownum <= 1;

Line 609: from jtf_diagnostic_test

605: -- they should all be deleted since a group should have the same testclassname
606: -- appearing once in it
607:
608: select ordernumber into V_ORDERNUM
609: from jtf_diagnostic_test
610: where APPID = P_APP_NAME
611: and groupname = P_GROUP_NAME
612: and testclassname = P_TEST_CLASS_NAME
613: and rownum <= 1;

Line 617: -- from the jtf_diagnostic_test table

613: and rownum <= 1;
614:
615:
616: -- cleanup all information about this test
617: -- from the jtf_diagnostic_test table
618:
619: delete from jtf_diagnostic_test
620: where groupname = P_GROUP_NAME
621: and appid = P_APP_NAME

Line 619: delete from jtf_diagnostic_test

615:
616: -- cleanup all information about this test
617: -- from the jtf_diagnostic_test table
618:
619: delete from jtf_diagnostic_test
620: where groupname = P_GROUP_NAME
621: and appid = P_APP_NAME
622: and testclassname = P_TEST_CLASS_NAME;
623:

Line 632: update jtf_diagnostic_test

628: loop
629: fetch TESTLIST into l_testclassname, l_ordernumber,
630: l_object_version_number;
631: exit when (TESTLIST%notfound);
632: update jtf_diagnostic_test
633: set ordernumber = (l_ordernumber - 1),
634: OBJECT_VERSION_NUMBER = l_OBJECT_VERSION_NUMBER + 1,
635: LAST_UPDATE_DATE = SYSDATE
636: where testclassname = l_testclassname

Line 717: -- number of argument rows for jtf_diagnostic_test

713: and appid = P_APP_NAME
714: and rownumber = P_ARG_ROW_NUM;
715:
716: -- If a row was deleted, then bump down the
717: -- number of argument rows for jtf_diagnostic_test
718:
719: IF NOT SQL%NOTFOUND THEN
720: update jtf_diagnostic_test
721: set totalargumentrows = (totalargumentrows - 1),

Line 720: update jtf_diagnostic_test

716: -- If a row was deleted, then bump down the
717: -- number of argument rows for jtf_diagnostic_test
718:
719: IF NOT SQL%NOTFOUND THEN
720: update jtf_diagnostic_test
721: set totalargumentrows = (totalargumentrows - 1),
722: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
723: LAST_UPDATE_DATE = SYSDATE
724: where testclassname = P_TEST_CLASS_NAME

Line 908: FROM jtf_diagnostic_test

904: BEGIN
905:
906: SELECT COUNT(*)
907: INTO v_numofrows
908: FROM jtf_diagnostic_test
909: WHERE appid = P_APPID AND
910: groupname = P_GROUPNAME;
911:
912: IF P_TESTCLASSNAMES.COUNT <> v_numofrows THEN

Line 922: UPDATE jtf_diagnostic_test

918:
919: LOOP
920: IF P_TESTCLASSNAMES.EXISTS(v_index) THEN
921:
922: UPDATE jtf_diagnostic_test
923: SET ordernumber = v_index * -1
924: WHERE appid = P_APPID AND
925: groupname = p_groupname and
926: ordernumber = v_index;

Line 929: UPDATE jtf_diagnostic_test

925: groupname = p_groupname and
926: ordernumber = v_index;
927:
928:
929: UPDATE jtf_diagnostic_test
930: SET OrderNumber = v_index,
931: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
932: LAST_UPDATE_DATE = SYSDATE
933: --LAST_UPDATED_BY = P_LUBID

Line 1457: v_ordernumber jtf_diagnostic_test.ordernumber%TYPE;

1453: p_meta_data in varchar2,
1454: p_lubid in number) IS
1455:
1456: V_SOURCETYPE BINARY_INTEGER := 2;
1457: v_ordernumber jtf_diagnostic_test.ordernumber%TYPE;
1458: l_sensitivity number;
1459: f_end_date date;
1460: f_meta_data xmltype;
1461:

Line 1477: from jtf_diagnostic_test

1473: -- the table. The same testcase should not exist 2 times in the
1474: -- group
1475:
1476: select count(*) into V_SOURCETYPE
1477: from jtf_diagnostic_test
1478: where appid = p_appid and groupname = p_group_name
1479: and testclassname = p_testclassname
1480: and rownum <= 1;
1481:

Line 1514: from jtf_diagnostic_test where appid = p_appid

1510: -- in the group and add this to the end. If there are no tests
1511: -- then make sure that this gets the first order number
1512:
1513: select MAX(ordernumber) into v_ordernumber
1514: from jtf_diagnostic_test where appid = p_appid
1515: and groupname = p_group_name;
1516:
1517: if sql%notfound or v_ordernumber = 0 then
1518: v_ordernumber := 1;

Line 1522: insert into jtf_diagnostic_test(

1518: v_ordernumber := 1;
1519: else v_ordernumber := v_ordernumber + 1;
1520: end if;
1521:
1522: insert into jtf_diagnostic_test(
1523: SEQUENCE, GROUPNAME, APPID,
1524: ORDERNUMBER, TESTTYPE, TESTCLASSNAME,
1525: TOTALARGUMENTROWS,
1526: SENSITIVITY,

Line 1531: JTF_DIAGNOSTIC_TEST_S.NEXTVAL, p_group_name, p_appid,

1527: OBJECT_VERSION_NUMBER, CREATED_BY,
1528: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
1529: CREATION_DATE,VALID_APPLICATIONS,END_DATE,TEST_METADATA)
1530: values(
1531: JTF_DIAGNOSTIC_TEST_S.NEXTVAL, p_group_name, p_appid,
1532: decode(v_ordernumber, null, 1, v_ordernumber),
1533: p_test_type, p_testclassname,
1534: 0, l_sensitivity, 1, p_lubid,
1535: SYSDATE, p_lubid, NULL,

Line 1606: from jtf_diagnostic_test where appid = p_appid

1602:
1603: -- then check if the testclassname is valid
1604:
1605: select count(*) into v_sourcetype
1606: from jtf_diagnostic_test where appid = p_appid
1607: and groupname = p_group_name
1608: and testclassname = p_test_class_name
1609: and rownum <= 1;
1610:

Line 1718: from jtf_diagnostic_test where appid = p_appid

1714:
1715: -- then check if the testclassname is valid
1716:
1717: select count(*) into v_sourcetype
1718: from jtf_diagnostic_test where appid = p_appid
1719: and groupname = p_group_name
1720: and testclassname = p_test_class_name
1721: and rownum <= 1;
1722:

Line 1976: -- jtf_diagnostic_test, jtf_diagnostic_arg, jtf_diagnostic_prereq

1972:
1973:
1974: -- if flow of control reaches here, it is alright to
1975: -- rename the group across jtf_diagnostic_group,
1976: -- jtf_diagnostic_test, jtf_diagnostic_arg, jtf_diagnostic_prereq
1977:
1978:
1979: update jtf_diagnostic_group
1980: set groupname = p_newgroupname,

Line 1987: update jtf_diagnostic_test

1983: LAST_UPDATED_BY = P_LUBID
1984: where groupname = p_groupname
1985: and appid = p_appid;
1986:
1987: update jtf_diagnostic_test
1988: set groupname = p_newgroupname,
1989: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
1990: LAST_UPDATE_DATE = SYSDATE,
1991: LAST_UPDATED_BY = P_LUBID

Line 2295: from JTF_DIAGNOSTIC_TEST

2291: instr(TESTCLASSNAME,'.',1,2)+1,
2292: instr(TESTCLASSNAME,'.',1,3) -
2293: instr(TESTCLASSNAME,'.',1,2) - 1),
2294: testclassname
2295: from JTF_DIAGNOSTIC_TEST
2296: where GROUPNAME = l_groupname
2297: and APPID = l_appid
2298: and testclassname <> l_testclassname
2299: and substr(TESTCLASSNAME,

Line 2336: from jtf_diagnostic_test

2332:
2333: begin
2334: select LAST_UPDATED_BY, LAST_UPDATE_DATE
2335: into db_luby, db_ludate
2336: from jtf_diagnostic_test
2337: where appid = p_appid and
2338: groupname = p_groupname
2339: and testclassname = p_testclassname;
2340:

Line 2356: update jtf_diagnostic_test

2352:
2353: -- if valid_applications is not null, insert valid_applications in to table
2354: -- else ignore the valid_applications while inserting
2355: if P_VALID_APPLICATIONS is not null and P_VALID_APPLICATIONS <> empty_clob() then
2356: update jtf_diagnostic_test
2357: set last_updated_by = f_luby,
2358: last_update_date = sysdate,--f_ludate,
2359: object_version_number = object_version_number + 1,
2360: TOTALARGUMENTROWS = p_TOTALARGUMENTROWS,

Line 2371: update jtf_diagnostic_test

2367: where appid = p_appid and groupname = p_groupname
2368: and testclassname = p_testclassname;
2369: else
2370:
2371: update jtf_diagnostic_test
2372: set last_updated_by = f_luby,
2373: last_update_date = sysdate,--f_ludate,
2374: object_version_number = object_version_number + 1,
2375: TOTALARGUMENTROWS = p_TOTALARGUMENTROWS,

Line 2424: from jtf_diagnostic_test where appid = p_appid

2420:
2421: if DOINSERT then
2422: --6599133
2423: select MAX(ordernumber) into v_num
2424: from jtf_diagnostic_test where appid = p_appid
2425: and groupname = p_groupname;
2426:
2427: if sql%notfound or v_num = 0 or v_num is null then
2428: v_num := 1;

Line 2435: insert into jtf_diagnostic_test(

2431:
2432: -- if valid_applications is not null, insert valid_applications in to table
2433: -- else ignore the valid_applications while inserting
2434: if P_VALID_APPLICATIONS is not null and P_VALID_APPLICATIONS <> empty_clob() then
2435: insert into jtf_diagnostic_test(
2436: SEQUENCE,
2437: GROUPNAME,
2438: APPID,
2439: ORDERNUMBER,

Line 2455: jtf_diagnostic_test_s.nextval,

2451: valid_applications,
2452: end_date,
2453: test_metadata)
2454: values(
2455: jtf_diagnostic_test_s.nextval,
2456: p_groupname,
2457: p_appid,
2458: v_num,
2459: p_testtype,

Line 2474: insert into jtf_diagnostic_test(

2470: xmltype(P_VALID_APPLICATIONS),
2471: f_end_date,
2472: f_meta_data);
2473: else
2474: insert into jtf_diagnostic_test(
2475: SEQUENCE,
2476: GROUPNAME,
2477: APPID,
2478: ORDERNUMBER,

Line 2493: jtf_diagnostic_test_s.nextval,

2489: security_group_id,
2490: end_date,
2491: test_metadata)
2492: values(
2493: jtf_diagnostic_test_s.nextval,
2494: p_groupname,
2495: p_appid,
2496: v_num,
2497: p_testtype,

Line 3175: from jtf_diagnostic_test

3171: -- as test table is updated before kb table, this should work
3172: begin
3173: select SEQUENCE
3174: into seq
3175: from jtf_diagnostic_test
3176: where appid = p_appid and
3177: groupname = p_groupname and
3178: testclassname = p_testclassname;
3179: end;

Line 3346: from jtf_diagnostic_testset

3342:
3343: begin
3344: select LAST_UPDATED_BY, LAST_UPDATE_DATE
3345: into db_luby, db_ludate
3346: from jtf_diagnostic_testset
3347: where name = p_name;
3348:
3349: -- Update record only as per standard
3350:

Line 3391: update jtf_diagnostic_testset

3387: P_LAST_UPDATED_BY IN NUMBER,
3388: P_LAST_UPDATED_DATE IN DATE) IS
3389:
3390: BEGIN
3391: update jtf_diagnostic_testset
3392: set description = P_DESCRIPTION,
3393: xml = XMLTYPE(P_XML),
3394: last_updated_by = P_LAST_UPDATED_BY,
3395: last_update_date = P_LAST_UPDATED_DATE

Line 3422: insert into jtf_diagnostic_testset

3418: P_LAST_UPDATED_BY IN NUMBER,
3419: P_LAST_UPDATED_DATE IN DATE) IS
3420:
3421: BEGIN
3422: insert into jtf_diagnostic_testset
3423: (NAME, DESCRIPTION, XML, CREATED_BY, CREATION_DATE,
3424: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, LAST_UPDATE_DATE)
3425: values
3426: ( P_NAME , P_DESCRIPTION, XMLType(P_XML), P_CREATED_BY, P_CREATION_DATE,

Line 3460: UPDATE JTF_DIAGNOSTIC_TEST

3456: P_LAST_UPDATED_DATE IN DATE) IS
3457:
3458: BEGIN
3459:
3460: UPDATE JTF_DIAGNOSTIC_TEST
3461: SET VALID_APPLICATIONS = XMLTYPE(P_VALIDAPPS),
3462: LAST_UPDATED_BY = P_LAST_UPDATED_BY,
3463: LAST_UPDATE_DATE = P_LAST_UPDATED_DATE
3464: WHERE APPID = P_APPSHORTNAME

Line 3636: UPDATE jtf_diagnostic_test

3632: IF P_END_DATE IS NOT NULL THEN
3633: --F_END_DATE := to_date(P_END_DATE, JTF_DIAGNOSTIC_ADAPTUTIL.GET_SITE_DATE_FORMAT());
3634: F_END_DATE := P_END_DATE;
3635: END IF;
3636: UPDATE jtf_diagnostic_test
3637: SET end_date = F_END_DATE,
3638: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
3639: LAST_UPDATE_DATE = SYSDATE,
3640: LAST_UPDATED_BY = P_LUBID