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 440: select testclassname from jtf_diagnostic_test

436: -- SKHEMANI Use the cursor to cleanup the
437: -- entry in the JTF_DIAGNOSTIC_KB table
438:
439: CURSOR TSTLIST IS
440: select testclassname from jtf_diagnostic_test
441: where appid = P_APP_NAME
442: and groupname = P_GROUP_NAME;
443:
444: CURSOR GRPLIST (c_ordernumber number) IS

Line 531: V_ORDERNUM jtf_diagnostic_test.ordernumber%TYPE;

527: P_GROUP_NAME IN VARCHAR2,
528: P_TEST_CLASS_NAME IN VARCHAR2
529: ) IS
530:
531: V_ORDERNUM jtf_diagnostic_test.ordernumber%TYPE;
532: V_SEQUENCE jtf_diagnostic_test.sequence%TYPE;
533:
534: l_testclassname varchar2(1500);
535: l_ordernumber number;

Line 532: V_SEQUENCE jtf_diagnostic_test.sequence%TYPE;

528: P_TEST_CLASS_NAME IN VARCHAR2
529: ) IS
530:
531: V_ORDERNUM jtf_diagnostic_test.ordernumber%TYPE;
532: V_SEQUENCE jtf_diagnostic_test.sequence%TYPE;
533:
534: l_testclassname varchar2(1500);
535: l_ordernumber number;
536: l_object_version_number number;

Line 540: from jtf_diagnostic_test

536: l_object_version_number number;
537:
538: CURSOR TESTLIST (c_ordernumber number) IS
539: select testclassname, ordernumber, object_version_number
540: from jtf_diagnostic_test
541: where appid = P_APP_NAME
542: and groupname = P_GROUP_NAME
543: and ordernumber > c_ordernumber
544: order by ordernumber;

Line 549: from jtf_diagnostic_test

545:
546: BEGIN
547:
548: select count(*) into V_ORDERNUM
549: from jtf_diagnostic_test
550: where APPID = P_APP_NAME
551: and groupname = P_GROUP_NAME
552: and testclassname = P_TEST_CLASS_NAME
553: and rownum <= 1;

Line 568: from jtf_diagnostic_test

564: -- great... we will use this sequence number to cleanup the
565: -- entry in the JTF_DIAGNOSTIC_KB table
566:
567: select sequence into V_SEQUENCE
568: from jtf_diagnostic_test
569: where APPID = P_APP_NAME
570: and groupname = P_GROUP_NAME
571: and testclassname = P_TEST_CLASS_NAME
572: and rownum <= 1;

Line 588: from jtf_diagnostic_test

584: -- they should all be deleted since a group should have the same testclassname
585: -- appearing once in it
586:
587: select ordernumber into V_ORDERNUM
588: from jtf_diagnostic_test
589: where APPID = P_APP_NAME
590: and groupname = P_GROUP_NAME
591: and testclassname = P_TEST_CLASS_NAME
592: and rownum <= 1;

Line 596: -- from the jtf_diagnostic_test table

592: and rownum <= 1;
593:
594:
595: -- cleanup all information about this test
596: -- from the jtf_diagnostic_test table
597:
598: delete from jtf_diagnostic_test
599: where groupname = P_GROUP_NAME
600: and appid = P_APP_NAME

Line 598: delete from jtf_diagnostic_test

594:
595: -- cleanup all information about this test
596: -- from the jtf_diagnostic_test table
597:
598: delete from jtf_diagnostic_test
599: where groupname = P_GROUP_NAME
600: and appid = P_APP_NAME
601: and testclassname = P_TEST_CLASS_NAME;
602:

Line 611: update jtf_diagnostic_test

607: loop
608: fetch TESTLIST into l_testclassname, l_ordernumber,
609: l_object_version_number;
610: exit when (TESTLIST%notfound);
611: update jtf_diagnostic_test
612: set ordernumber = (l_ordernumber - 1),
613: OBJECT_VERSION_NUMBER = l_OBJECT_VERSION_NUMBER + 1,
614: LAST_UPDATE_DATE = SYSDATE
615: where testclassname = l_testclassname

Line 694: -- number of argument rows for jtf_diagnostic_test

690: and appid = P_APP_NAME
691: and rownumber = P_ARG_ROW_NUM;
692:
693: -- If a row was deleted, then bump down the
694: -- number of argument rows for jtf_diagnostic_test
695:
696: IF NOT SQL%NOTFOUND THEN
697: update jtf_diagnostic_test
698: set totalargumentrows = (totalargumentrows - 1),

Line 697: update jtf_diagnostic_test

693: -- If a row was deleted, then bump down the
694: -- number of argument rows for jtf_diagnostic_test
695:
696: IF NOT SQL%NOTFOUND THEN
697: update jtf_diagnostic_test
698: set totalargumentrows = (totalargumentrows - 1),
699: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
700: LAST_UPDATE_DATE = SYSDATE
701: where testclassname = P_TEST_CLASS_NAME

Line 812: FROM jtf_diagnostic_test

808: BEGIN
809:
810: SELECT COUNT(*)
811: INTO v_numofrows
812: FROM jtf_diagnostic_test
813: WHERE appid = P_APPID AND
814: groupname = P_GROUPNAME;
815:
816: IF P_TESTCLASSNAMES.COUNT <> v_numofrows THEN

Line 826: UPDATE jtf_diagnostic_test

822:
823: LOOP
824: IF P_TESTCLASSNAMES.EXISTS(v_index) THEN
825:
826: UPDATE jtf_diagnostic_test
827: SET ordernumber = v_index * -1
828: WHERE appid = P_APPID AND
829: groupname = p_groupname and
830: ordernumber = v_index;

Line 833: UPDATE jtf_diagnostic_test

829: groupname = p_groupname and
830: ordernumber = v_index;
831:
832:
833: UPDATE jtf_diagnostic_test
834: SET OrderNumber = v_index,
835: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
836: LAST_UPDATE_DATE = SYSDATE
837: --LAST_UPDATED_BY = P_LUBID

Line 1308: v_ordernumber jtf_diagnostic_test.ordernumber%TYPE;

1304: p_valid_apps_xml in varchar2,
1305: p_lubid in number) IS
1306:
1307: V_SOURCETYPE BINARY_INTEGER := 2;
1308: v_ordernumber jtf_diagnostic_test.ordernumber%TYPE;
1309: l_sensitivity number;
1310:
1311: BEGIN
1312:

Line 1326: from jtf_diagnostic_test

1322: -- the table. The same testcase should not exist 2 times in the
1323: -- group
1324:
1325: select count(*) into V_SOURCETYPE
1326: from jtf_diagnostic_test
1327: where appid = p_appid and groupname = p_group_name
1328: and testclassname = p_testclassname
1329: and rownum <= 1;
1330:

Line 1354: from jtf_diagnostic_test where appid = p_appid

1350: -- in the group and add this to the end. If there are no tests
1351: -- then make sure that this gets the first order number
1352:
1353: select MAX(ordernumber) into v_ordernumber
1354: from jtf_diagnostic_test where appid = p_appid
1355: and groupname = p_group_name;
1356:
1357: if sql%notfound or v_ordernumber = 0 then
1358: v_ordernumber := 1;

Line 1362: insert into jtf_diagnostic_test(

1358: v_ordernumber := 1;
1359: else v_ordernumber := v_ordernumber + 1;
1360: end if;
1361:
1362: insert into jtf_diagnostic_test(
1363: SEQUENCE, GROUPNAME, APPID,
1364: ORDERNUMBER, TESTTYPE, TESTCLASSNAME,
1365: TOTALARGUMENTROWS,
1366: SENSITIVITY,

Line 1371: JTF_DIAGNOSTIC_TEST_S.NEXTVAL, p_group_name, p_appid,

1367: OBJECT_VERSION_NUMBER, CREATED_BY,
1368: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
1369: CREATION_DATE,VALID_APPLICATIONS)
1370: values(
1371: JTF_DIAGNOSTIC_TEST_S.NEXTVAL, p_group_name, p_appid,
1372: decode(v_ordernumber, null, 1, v_ordernumber),
1373: p_test_type, p_testclassname,
1374: 0, l_sensitivity, 1, p_lubid,
1375: SYSDATE, p_lubid, NULL,

Line 1446: from jtf_diagnostic_test where appid = p_appid

1442:
1443: -- then check if the testclassname is valid
1444:
1445: select count(*) into v_sourcetype
1446: from jtf_diagnostic_test where appid = p_appid
1447: and groupname = p_group_name
1448: and testclassname = p_test_class_name
1449: and rownum <= 1;
1450:

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 1729: update jtf_diagnostic_test

1725: LAST_UPDATED_BY = P_LUBID
1726: where groupname = p_groupname
1727: and appid = p_appid;
1728:
1729: update jtf_diagnostic_test
1730: set groupname = p_newgroupname,
1731: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
1732: LAST_UPDATE_DATE = SYSDATE,
1733: LAST_UPDATED_BY = P_LUBID

Line 2033: from JTF_DIAGNOSTIC_TEST

2029: instr(TESTCLASSNAME,'.',1,2)+1,
2030: instr(TESTCLASSNAME,'.',1,3) -
2031: instr(TESTCLASSNAME,'.',1,2) - 1),
2032: testclassname
2033: from JTF_DIAGNOSTIC_TEST
2034: where GROUPNAME = l_groupname
2035: and APPID = l_appid
2036: and testclassname <> l_testclassname
2037: and substr(TESTCLASSNAME,

Line 2067: from jtf_diagnostic_test

2063:
2064: begin
2065: select LAST_UPDATED_BY, LAST_UPDATE_DATE
2066: into db_luby, db_ludate
2067: from jtf_diagnostic_test
2068: where appid = p_appid and
2069: groupname = p_groupname
2070: and testclassname = p_testclassname;
2071:

Line 2087: update jtf_diagnostic_test

2083:
2084: -- if valid_applications is not null, insert valid_applications in to table
2085: -- else ignore the valid_applications while inserting
2086: if P_VALID_APPLICATIONS is not null and P_VALID_APPLICATIONS <> empty_clob() then
2087: update jtf_diagnostic_test
2088: set last_updated_by = f_luby,
2089: last_update_date = sysdate,--f_ludate,
2090: object_version_number = object_version_number + 1,
2091: TOTALARGUMENTROWS = p_TOTALARGUMENTROWS,

Line 2100: update jtf_diagnostic_test

2096: where appid = p_appid and groupname = p_groupname
2097: and testclassname = p_testclassname;
2098: else
2099:
2100: update jtf_diagnostic_test
2101: set last_updated_by = f_luby,
2102: last_update_date = sysdate,--f_ludate,
2103: object_version_number = object_version_number + 1,
2104: TOTALARGUMENTROWS = p_TOTALARGUMENTROWS,

Line 2151: from jtf_diagnostic_test where appid = p_appid

2147:
2148: if DOINSERT then
2149: --6599133
2150: select MAX(ordernumber) into v_num
2151: from jtf_diagnostic_test where appid = p_appid
2152: and groupname = p_groupname;
2153:
2154: if sql%notfound or v_num = 0 or v_num is null then
2155: v_num := 1;

Line 2162: insert into jtf_diagnostic_test(

2158:
2159: -- if valid_applications is not null, insert valid_applications in to table
2160: -- else ignore the valid_applications while inserting
2161: if P_VALID_APPLICATIONS is not null and P_VALID_APPLICATIONS <> empty_clob() then
2162: insert into jtf_diagnostic_test(
2163: SEQUENCE,
2164: GROUPNAME,
2165: APPID,
2166: ORDERNUMBER,

Line 2180: jtf_diagnostic_test_s.nextval,

2176: CREATION_DATE,
2177: security_group_id,
2178: valid_applications)
2179: values(
2180: jtf_diagnostic_test_s.nextval,
2181: p_groupname,
2182: p_appid,
2183: v_num,
2184: p_testtype,

Line 2197: insert into jtf_diagnostic_test(

2193: f_ludate,
2194: to_number(P_SEC_GRP_ID),
2195: xmltype(P_VALID_APPLICATIONS));
2196: else
2197: insert into jtf_diagnostic_test(
2198: SEQUENCE,
2199: GROUPNAME,
2200: APPID,
2201: ORDERNUMBER,

Line 2214: jtf_diagnostic_test_s.nextval,

2210: LAST_UPDATE_LOGIN,
2211: CREATION_DATE,
2212: security_group_id)
2213: values(
2214: jtf_diagnostic_test_s.nextval,
2215: p_groupname,
2216: p_appid,
2217: v_num,
2218: p_testtype,

Line 2895: from jtf_diagnostic_test

2891: -- as test table is updated before kb table, this should work
2892: begin
2893: select SEQUENCE
2894: into seq
2895: from jtf_diagnostic_test
2896: where appid = p_appid and
2897: groupname = p_groupname and
2898: testclassname = p_testclassname;
2899: end;

Line 3066: from jtf_diagnostic_testset

3062:
3063: begin
3064: select LAST_UPDATED_BY, LAST_UPDATE_DATE
3065: into db_luby, db_ludate
3066: from jtf_diagnostic_testset
3067: where name = p_name;
3068:
3069: -- Update record only as per standard
3070:

Line 3111: update jtf_diagnostic_testset

3107: P_LAST_UPDATED_BY IN NUMBER,
3108: P_LAST_UPDATED_DATE IN DATE) IS
3109:
3110: BEGIN
3111: update jtf_diagnostic_testset
3112: set description = P_DESCRIPTION,
3113: xml = XMLTYPE(P_XML),
3114: last_updated_by = P_LAST_UPDATED_BY,
3115: last_update_date = P_LAST_UPDATED_DATE

Line 3142: insert into jtf_diagnostic_testset

3138: P_LAST_UPDATED_BY IN NUMBER,
3139: P_LAST_UPDATED_DATE IN DATE) IS
3140:
3141: BEGIN
3142: insert into jtf_diagnostic_testset
3143: (NAME, DESCRIPTION, XML, CREATED_BY, CREATION_DATE,
3144: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, LAST_UPDATE_DATE)
3145: values
3146: ( P_NAME , P_DESCRIPTION, XMLType(P_XML), P_CREATED_BY, P_CREATION_DATE,

Line 3180: UPDATE JTF_DIAGNOSTIC_TEST

3176: P_LAST_UPDATED_DATE IN DATE) IS
3177:
3178: BEGIN
3179:
3180: UPDATE JTF_DIAGNOSTIC_TEST
3181: SET VALID_APPLICATIONS = XMLTYPE(P_VALIDAPPS),
3182: LAST_UPDATED_BY = P_LAST_UPDATED_BY,
3183: LAST_UPDATE_DATE = P_LAST_UPDATED_DATE
3184: WHERE APPID = P_APPSHORTNAME