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_GROUP

Line 72: from jtf_diagnostic_group

68:
69: /* 5953806 - changed select to get last_updated_by instead of created_by */
70: cursor grouplist is
71: select groupName, sensitivity, last_updated_by
72: from jtf_diagnostic_group
73: where appID like P_APPNAME
74: order by orderNumber;
75:
76: BEGIN

Line 328: UPDATE jtf_diagnostic_group

324: ) IS
325:
326: BEGIN
327:
328: UPDATE jtf_diagnostic_group
329: SET sensitivity = P_GRP_SENSITIVITY,
330: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
331: LAST_UPDATE_DATE = SYSDATE,
332: LAST_UPDATED_BY = P_LUBID

Line 403: delete from jtf_diagnostic_group

399:
400: delete from jtf_diagnostic_app
401: where appid = P_APP_NAME;
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;

Line 430: V_ORDERNUM jtf_diagnostic_group.ordernumber%TYPE;

426: P_APP_NAME IN VARCHAR2,
427: P_GROUP_NAME IN VARCHAR2
428: ) IS
429:
430: V_ORDERNUM jtf_diagnostic_group.ordernumber%TYPE;
431:
432: l_groupname varchar2(500);
433: l_ordernumber number;
434: l_object_version_number number;

Line 454: from jtf_diagnostic_group

450: and groupname = P_GROUP_NAME;
451:
452: CURSOR GRPLIST (c_ordernumber number) IS
453: select groupname, ordernumber, object_version_number
454: from jtf_diagnostic_group
455: where appid = P_APP_NAME
456: and ordernumber > c_ordernumber
457: order by ordernumber;
458:

Line 465: from jtf_diagnostic_group

461: -- populate the variable v_ordernum
462: -- so that we can use this for resequencing
463:
464: select distinct count(*) into V_ORDERNUM
465: from jtf_diagnostic_group
466: where APPID = P_APP_NAME and groupname = P_GROUP_NAME;
467:
468: -- if the ordernumber not found then no point continuing with
469: -- the rest, just raise an exception

Line 481: from jtf_diagnostic_group

477: -- get the right order number into the variable
478: -- for further processing
479:
480: select distinct ordernumber into V_ORDERNUM
481: from jtf_diagnostic_group
482: where APPID = P_APP_NAME and groupname = P_GROUP_NAME;
483:
484: -- if flow of control reaches here,
485: -- cleanup all information about this group

Line 486: -- from the jtf_diagnostic_group table

482: where APPID = P_APP_NAME and groupname = P_GROUP_NAME;
483:
484: -- if flow of control reaches here,
485: -- cleanup all information about this group
486: -- from the jtf_diagnostic_group table
487:
488: delete from jtf_diagnostic_group
489: where groupname = P_GROUP_NAME
490: and appid = P_APP_NAME;

Line 488: delete from jtf_diagnostic_group

484: -- if flow of control reaches here,
485: -- cleanup all information about this group
486: -- from the jtf_diagnostic_group table
487:
488: delete from jtf_diagnostic_group
489: where groupname = P_GROUP_NAME
490: and appid = P_APP_NAME;
491:
492: -- Resequence the groups to make sure there are no holes in the

Line 499: update jtf_diagnostic_group

495: open GRPLIST(V_ORDERNUM);
496: loop
497: fetch GRPLIST into l_groupname, l_ordernumber, l_object_version_number;
498: exit when (GRPLIST%notfound);
499: update jtf_diagnostic_group
500: set ordernumber = (l_ordernumber - 1),
501: OBJECT_VERSION_NUMBER = l_OBJECT_VERSION_NUMBER + 1,
502: LAST_UPDATE_DATE = SYSDATE
503: where groupname = l_groupname

Line 834: FROM jtf_diagnostic_group

830: BEGIN
831:
832: SELECT COUNT(*)
833: INTO v_numofrows
834: FROM jtf_diagnostic_group
835: WHERE appid = P_APPID;
836:
837: IF P_GROUPNAMES.COUNT <> v_numofrows THEN
838: --RAISE_APPLICATION_ERROR(-20000, 'Cant Update - Mismatch');

Line 847: UPDATE jtf_diagnostic_group

843:
844: LOOP
845: IF P_GROUPNAMES.EXISTS(v_index) THEN
846:
847: UPDATE jtf_diagnostic_group
848: SET ordernumber = v_index * -1
849: WHERE appid = P_APPID AND
850: ordernumber = v_index;
851:

Line 852: UPDATE jtf_diagnostic_group

848: SET ordernumber = v_index * -1
849: WHERE appid = P_APPID AND
850: ordernumber = v_index;
851:
852: UPDATE jtf_diagnostic_group
853: SET ordernumber = v_index,
854: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
855: LAST_UPDATE_DATE = SYSDATE
856: --LAST_UPDATED_BY = P_LUBID

Line 1231: v_groupname jtf_diagnostic_group.groupname%TYPE;

1227: P_APP IN VARCHAR2,
1228: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,
1229: P_LUBID IN NUMBER) IS
1230:
1231: v_groupname jtf_diagnostic_group.groupname%TYPE;
1232: V_SOURCETYPE BINARY_INTEGER := 2;
1233: v_ordernumber jtf_diagnostic_group.ordernumber%TYPE;
1234:
1235:

Line 1233: v_ordernumber jtf_diagnostic_group.ordernumber%TYPE;

1229: P_LUBID IN NUMBER) IS
1230:
1231: v_groupname jtf_diagnostic_group.groupname%TYPE;
1232: V_SOURCETYPE BINARY_INTEGER := 2;
1233: v_ordernumber jtf_diagnostic_group.ordernumber%TYPE;
1234:
1235:
1236: BEGIN
1237:

Line 1251: from jtf_diagnostic_group

1247: -- not already there in the tables for the application
1248: -- and if yes it should not be reentered
1249:
1250: select count(*) into v_sourcetype
1251: from jtf_diagnostic_group
1252: where appid = P_APP and groupname = p_new_group
1253: and rownum <= 1;
1254:
1255: -- if anything found then raise an application error since the

Line 1274: from jtf_diagnostic_group where appid = p_app;

1270: -- and add this to the end. If there are no groups
1271: -- then make sure that this gets the first order number
1272:
1273: select MAX(ordernumber) into v_ordernumber
1274: from jtf_diagnostic_group where appid = p_app;
1275:
1276: if sql%notfound or v_ordernumber = 0 then
1277: v_ordernumber := 1;
1278: else v_ordernumber := v_ordernumber + 1;

Line 1283: insert into jtf_diagnostic_group(

1279:
1280: end if;
1281:
1282:
1283: insert into jtf_diagnostic_group(
1284: SEQUENCE, GROUPNAME,
1285: APPID, ORDERNUMBER,
1286: OBJECT_VERSION_NUMBER, CREATED_BY,
1287: LAST_UPDATE_DATE, LAST_UPDATED_BY,

Line 1290: JTF_DIAGNOSTIC_GROUP_S.NEXTVAL, P_NEW_GROUP,

1286: OBJECT_VERSION_NUMBER, CREATED_BY,
1287: LAST_UPDATE_DATE, LAST_UPDATED_BY,
1288: LAST_UPDATE_LOGIN, CREATION_DATE)
1289: values(
1290: JTF_DIAGNOSTIC_GROUP_S.NEXTVAL, P_NEW_GROUP,
1291: P_APP, DECODE(v_ordernumber,null,1,v_ordernumber),
1292: 1, P_LUBID,
1293: SYSDATE, P_LUBID,
1294: NULL, SYSDATE);

Line 1335: v_groupname jtf_diagnostic_group.groupname%TYPE;

1331: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,
1332: P_SENSITIVITY IN NUMBER,
1333: P_LUBID IN NUMBER) IS
1334:
1335: v_groupname jtf_diagnostic_group.groupname%TYPE;
1336: V_SOURCETYPE BINARY_INTEGER := 2;
1337: v_ordernumber jtf_diagnostic_group.ordernumber%TYPE;
1338:
1339:

Line 1337: v_ordernumber jtf_diagnostic_group.ordernumber%TYPE;

1333: P_LUBID IN NUMBER) IS
1334:
1335: v_groupname jtf_diagnostic_group.groupname%TYPE;
1336: V_SOURCETYPE BINARY_INTEGER := 2;
1337: v_ordernumber jtf_diagnostic_group.ordernumber%TYPE;
1338:
1339:
1340: BEGIN
1341:

Line 1355: from jtf_diagnostic_group

1351: -- not already there in the tables for the application
1352: -- and if yes it should not be reentered
1353:
1354: select count(*) into v_sourcetype
1355: from jtf_diagnostic_group
1356: where appid = P_APP and groupname = p_new_group
1357: and rownum <= 1;
1358:
1359: -- if anything found then raise an application error since the

Line 1378: from jtf_diagnostic_group where appid = p_app;

1374: -- and add this to the end. If there are no groups
1375: -- then make sure that this gets the first order number
1376:
1377: select MAX(ordernumber) into v_ordernumber
1378: from jtf_diagnostic_group where appid = p_app;
1379:
1380: if sql%notfound or v_ordernumber = 0 then
1381: v_ordernumber := 1;
1382: else v_ordernumber := v_ordernumber + 1;

Line 1387: insert into jtf_diagnostic_group(

1383:
1384: end if;
1385:
1386:
1387: insert into jtf_diagnostic_group(
1388: SEQUENCE, GROUPNAME,
1389: APPID, ORDERNUMBER,
1390: OBJECT_VERSION_NUMBER, CREATED_BY,
1391: LAST_UPDATE_DATE, LAST_UPDATED_BY,

Line 1394: JTF_DIAGNOSTIC_GROUP_S.NEXTVAL, P_NEW_GROUP,

1390: OBJECT_VERSION_NUMBER, CREATED_BY,
1391: LAST_UPDATE_DATE, LAST_UPDATED_BY,
1392: LAST_UPDATE_LOGIN, CREATION_DATE, SENSITIVITY)
1393: values(
1394: JTF_DIAGNOSTIC_GROUP_S.NEXTVAL, P_NEW_GROUP,
1395: P_APP, DECODE(v_ordernumber,null,1,v_ordernumber),
1396: 1, P_LUBID,
1397: SYSDATE, P_LUBID,
1398: NULL, SYSDATE, P_SENSITIVITY);

Line 1440: from jtf_diagnostic_group

1436: p_sensitivity out NOCOPY number) IS
1437:
1438: begin
1439: select sensitivity into p_sensitivity
1440: from jtf_diagnostic_group
1441: where appid = p_appid and
1442: groupname = p_group_name;
1443: end GET_GROUP_SENSITIVITY;
1444:

Line 1811: select count(*) into v_data_found from jtf_diagnostic_group

1807: if p_sourcetype = 1 then
1808: select count(*) into v_data_found from jtf_diagnostic_app
1809: where appid = p_sourceid;
1810: elsif p_sourcetype = 2 then
1811: select count(*) into v_data_found from jtf_diagnostic_group
1812: where appid = p_sourceappid and
1813: groupname = p_sourceid;
1814: else
1815: raise_application_error(-20000, 'Invalid data type received');

Line 1868: select sequence into v_data_found from jtf_diagnostic_group

1864: select sequence into v_data_found from jtf_diagnostic_app
1865: where appid = P_PREREQID(v_index)
1866: and rownum <= 1;
1867: elsif p_sourcetype = 2 then
1868: select sequence into v_data_found from jtf_diagnostic_group
1869: where groupname = P_PREREQID(v_index)
1870: and appid = p_sourceappid
1871: and rownum <= 1;
1872:

Line 1941: from jtf_diagnostic_group

1937:
1938: BEGIN
1939:
1940: select count(*) into v_data_found
1941: from jtf_diagnostic_group
1942: where appid = p_appid
1943: and groupname = p_groupname;
1944:
1945: if v_data_found = 0 or sql%notfound then

Line 1964: from jtf_diagnostic_group

1960:
1961: v_data_found := 1;
1962:
1963: select count(*) into v_data_found
1964: from jtf_diagnostic_group
1965: where appid = p_appid
1966: and groupname = p_newgroupname;
1967:
1968: if v_data_found > 0 then

Line 1975: -- rename the group across jtf_diagnostic_group,

1971: end if;
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

Line 1979: update jtf_diagnostic_group

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,
1981: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
1982: LAST_UPDATE_DATE = SYSDATE,
1983: LAST_UPDATED_BY = P_LUBID

Line 2187: from jtf_diagnostic_group

2183:
2184: begin
2185: select LAST_UPDATED_BY, LAST_UPDATE_DATE
2186: into db_luby, db_ludate
2187: from jtf_diagnostic_group
2188: where appid = p_appid and
2189: groupname = p_groupname;
2190:
2191: -- Update record only as per standard

Line 2202: update jtf_diagnostic_group

2198: p_cust_mode))
2199: then*/
2200: -- seed data must not be changed by customers.Hence overwriting data always
2201: -- so that it covers up any changes by mistake
2202: update jtf_diagnostic_group
2203: set sensitivity = v_sensitivity,
2204: last_updated_by = f_luby,
2205: last_update_date = f_ludate,
2206: object_version_number = object_version_number + 1,

Line 2218: from jtf_diagnostic_group where

2214: when no_data_found then
2215: -- Record doesn't exist - insert in all cases
2216:
2217: select nvl(max(ordernumber)+1,1) into v_num
2218: from jtf_diagnostic_group where
2219: appid = p_appid;
2220:
2221: insert into jtf_diagnostic_group(
2222: sequence,

Line 2221: insert into jtf_diagnostic_group(

2217: select nvl(max(ordernumber)+1,1) into v_num
2218: from jtf_diagnostic_group where
2219: appid = p_appid;
2220:
2221: insert into jtf_diagnostic_group(
2222: sequence,
2223: groupname,
2224: appid,
2225: sensitivity,

Line 2235: jtf_diagnostic_group_s.nextval,

2231: last_updated_by,
2232: creation_date,
2233: security_group_id)
2234: values(
2235: jtf_diagnostic_group_s.nextval,
2236: p_groupname,
2237: p_appid,
2238: v_sensitivity,
2239: v_num,