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 643: -- from the jtf_diagnostic_arg table

639: end loop;
640: close TESTLIST;
641:
642: -- cleanup all information about this testcase (testcase arguments)
643: -- from the jtf_diagnostic_arg table
644:
645: delete from jtf_diagnostic_arg
646: where groupname = P_GROUP_NAME
647: and appid = P_APP_NAME

Line 645: delete from jtf_diagnostic_arg

641:
642: -- cleanup all information about this testcase (testcase arguments)
643: -- from the jtf_diagnostic_arg table
644:
645: delete from jtf_diagnostic_arg
646: where groupname = P_GROUP_NAME
647: and appid = P_APP_NAME
648: and testclassname = P_TEST_CLASS_NAME;
649:

Line 682: delete from jtf_diagnostic_arg

678: P_TEST_CLASS_NAME IN VARCHAR2
679: ) IS
680:
681: BEGIN
682: delete from jtf_diagnostic_arg
683: where testclassname = P_TEST_CLASS_NAME
684: and groupname = P_GROUP_NAME
685: and appid = P_APP_NAME;
686: END DELETE_ALL_ARGS_FOR_TEST;

Line 710: delete from jtf_diagnostic_arg

706: -- testcase where we get the rownumber from the UI / Java layer
707: -- where each rownumber corresponds to one combination of
708: -- arguments which we will just delete
709:
710: delete from jtf_diagnostic_arg
711: where testclassname = P_TEST_CLASS_NAME
712: and groupname = P_GROUP_NAME
713: and appid = P_APP_NAME
714: and rownumber = P_ARG_ROW_NUM;

Line 728: update jtf_diagnostic_arg

724: where testclassname = P_TEST_CLASS_NAME
725: and groupname = P_GROUP_NAME
726: and appid = P_APP_NAME;
727:
728: update jtf_diagnostic_arg
729: set rownumber = (rownumber - 1),
730: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
731: LAST_UPDATE_DATE = SYSDATE
732: where testclassname = P_TEST_CLASS_NAME

Line 1042: update jtf_diagnostic_arg set

1038:
1039: loop
1040: if p_argnames.EXISTS(v_index) AND p_argvalues.exists(v_index) then
1041:
1042: update jtf_diagnostic_arg set
1043: argvalue = p_argvalues(v_index),
1044: arg_date_value = p_arg_dates(v_index),
1045: arg_number_value = p_arg_numbers(v_index),
1046: object_version_number = object_version_number + 1,

Line 1091: update jtf_diagnostic_arg set

1087:
1088: loop
1089: if p_argnames.EXISTS(v_index) AND p_argvalues.exists(v_index) then
1090:
1091: update jtf_diagnostic_arg set
1092: argvalue = p_argvalues(v_index),
1093: object_version_number = object_version_number + 1,
1094: -- last_updated_by = UID,
1095: last_updated_by = P_LUBID,

Line 1589: v_rownumber jtf_diagnostic_arg.rownumber%TYPE;

1585: p_arg_values in jtf_varchar2_table_4000,
1586: p_lubid in number) IS
1587:
1588: V_SOURCETYPE BINARY_INTEGER := 1;
1589: v_rownumber jtf_diagnostic_arg.rownumber%TYPE;
1590: v_valsetnumber jtf_diagnostic_arg.valuesetnumber%TYPE;
1591:
1592: BEGIN
1593: -- first check if the application is valid

Line 1590: v_valsetnumber jtf_diagnostic_arg.valuesetnumber%TYPE;

1586: p_lubid in number) IS
1587:
1588: V_SOURCETYPE BINARY_INTEGER := 1;
1589: v_rownumber jtf_diagnostic_arg.rownumber%TYPE;
1590: v_valsetnumber jtf_diagnostic_arg.valuesetnumber%TYPE;
1591:
1592: BEGIN
1593: -- first check if the application is valid
1594:

Line 1623: from jtf_diagnostic_arg where testclassname = p_test_class_name

1619: -- then get the max row number and increment it by 1
1620: -- max row number is for this testclassname only
1621:
1622: select max(rownumber) into v_rownumber
1623: from jtf_diagnostic_arg where testclassname = p_test_class_name
1624: and groupname = p_group_name and appid = p_appid;
1625:
1626: if sql%notfound or v_rownumber = 0 then
1627: v_rownumber := 1;

Line 1633: select JTF_DIAGNOSTIC_ARG_VAL_SET_S.nextval

1629: end if;
1630:
1631: -- now get the max valuesetnumber and increment it by 1
1632:
1633: select JTF_DIAGNOSTIC_ARG_VAL_SET_S.nextval
1634: into v_valsetnumber from dual;
1635:
1636: -- select max(valuesetnumber) into v_valsetnumber
1637: -- from jtf_diagnostic_arg;

Line 1637: -- from jtf_diagnostic_arg;

1633: select JTF_DIAGNOSTIC_ARG_VAL_SET_S.nextval
1634: into v_valsetnumber from dual;
1635:
1636: -- select max(valuesetnumber) into v_valsetnumber
1637: -- from jtf_diagnostic_arg;
1638:
1639: -- if sql%notfound or v_valsetnumber = 0 then
1640: -- v_valsetnumber := 1;
1641: -- else v_valsetnumber := v_valsetnumber + 1;

Line 1649: insert into jtf_diagnostic_arg(

1645: V_SOURCETYPE := 1;
1646: loop
1647: if p_arg_names.exists(v_sourcetype) then
1648:
1649: insert into jtf_diagnostic_arg(
1650: SEQUENCE, TESTCLASSNAME, GROUPNAME,
1651: APPID, ARGNAME, ARGVALUE,
1652: ROWNUMBER, VALUESETNUMBER, OBJECT_VERSION_NUMBER,
1653: CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,

Line 1656: JTF_DIAGNOSTIC_ARG_S.NEXTVAL, p_test_class_name, p_group_name,

1652: ROWNUMBER, VALUESETNUMBER, OBJECT_VERSION_NUMBER,
1653: CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
1654: LAST_UPDATE_LOGIN, CREATION_DATE)
1655: values(
1656: JTF_DIAGNOSTIC_ARG_S.NEXTVAL, p_test_class_name, p_group_name,
1657: p_appid, p_arg_names(v_sourcetype), p_arg_values(v_sourcetype),
1658: decode(v_rownumber, null, 1, v_rownumber), v_valsetnumber, 1,
1659: p_lubid, SYSDATE, p_lubid,
1660: NULL, SYSDATE);

Line 1701: v_rownumber jtf_diagnostic_arg.rownumber%TYPE;

1697: p_arg_numbers in jtf_number_table,
1698: p_lubid in number) IS
1699:
1700: V_SOURCETYPE BINARY_INTEGER := 1;
1701: v_rownumber jtf_diagnostic_arg.rownumber%TYPE;
1702: v_valsetnumber jtf_diagnostic_arg.valuesetnumber%TYPE;
1703:
1704: BEGIN
1705: -- first check if the application is valid

Line 1702: v_valsetnumber jtf_diagnostic_arg.valuesetnumber%TYPE;

1698: p_lubid in number) IS
1699:
1700: V_SOURCETYPE BINARY_INTEGER := 1;
1701: v_rownumber jtf_diagnostic_arg.rownumber%TYPE;
1702: v_valsetnumber jtf_diagnostic_arg.valuesetnumber%TYPE;
1703:
1704: BEGIN
1705: -- first check if the application is valid
1706:

Line 1735: from jtf_diagnostic_arg where testclassname = p_test_class_name

1731: -- then get the max row number and increment it by 1
1732: -- max row number is for this testclassname only
1733:
1734: select max(rownumber) into v_rownumber
1735: from jtf_diagnostic_arg where testclassname = p_test_class_name
1736: and groupname = p_group_name and appid = p_appid;
1737:
1738: if sql%notfound or v_rownumber = 0 then
1739: v_rownumber := 1;

Line 1745: select JTF_DIAGNOSTIC_ARG_VAL_SET_S.nextval

1741: end if;
1742:
1743: -- now get the max valuesetnumber and increment it by 1
1744:
1745: select JTF_DIAGNOSTIC_ARG_VAL_SET_S.nextval
1746: into v_valsetnumber from dual;
1747:
1748: -- select max(valuesetnumber) into v_valsetnumber
1749: -- from jtf_diagnostic_arg;

Line 1749: -- from jtf_diagnostic_arg;

1745: select JTF_DIAGNOSTIC_ARG_VAL_SET_S.nextval
1746: into v_valsetnumber from dual;
1747:
1748: -- select max(valuesetnumber) into v_valsetnumber
1749: -- from jtf_diagnostic_arg;
1750:
1751: -- if sql%notfound or v_valsetnumber = 0 then
1752: -- v_valsetnumber := 1;
1753: -- else v_valsetnumber := v_valsetnumber + 1;

Line 1761: insert into jtf_diagnostic_arg(

1757: V_SOURCETYPE := 1;
1758: loop
1759: if p_arg_names.exists(v_sourcetype) then
1760:
1761: insert into jtf_diagnostic_arg(
1762: SEQUENCE, TESTCLASSNAME, GROUPNAME,
1763: APPID, ARGNAME, ARGVALUE,
1764: ARG_DATE_VALUE, ARG_NUMBER_VALUE,
1765: ROWNUMBER, VALUESETNUMBER, OBJECT_VERSION_NUMBER,

Line 1769: JTF_DIAGNOSTIC_ARG_S.NEXTVAL, p_test_class_name, p_group_name,

1765: ROWNUMBER, VALUESETNUMBER, OBJECT_VERSION_NUMBER,
1766: CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
1767: LAST_UPDATE_LOGIN, CREATION_DATE)
1768: values(
1769: JTF_DIAGNOSTIC_ARG_S.NEXTVAL, p_test_class_name, p_group_name,
1770: p_appid, p_arg_names(v_sourcetype), p_arg_values(v_sourcetype),
1771: p_arg_dates(v_sourcetype), p_arg_numbers(v_sourcetype),
1772: decode(v_rownumber, null, 1, v_rownumber), v_valsetnumber, 1,
1773: p_lubid, SYSDATE, p_lubid,

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 1995: update jtf_diagnostic_arg

1991: LAST_UPDATED_BY = P_LUBID
1992: where groupname = p_groupname
1993: and appid = p_appid;
1994:
1995: update jtf_diagnostic_arg
1996: set groupname = p_newgroupname,
1997: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
1998: LAST_UPDATE_DATE = SYSDATE,
1999: LAST_UPDATED_BY = P_LUBID

Line 2559: from jtf_diagnostic_arg

2555:
2556: begin
2557: select LAST_UPDATED_BY, LAST_UPDATE_DATE
2558: into db_luby, db_ludate
2559: from jtf_diagnostic_arg
2560: where appid = p_appid
2561: and groupname = p_groupname
2562: and testclassname = p_testclassname
2563: and argname = p_argname

Line 2577: update jtf_diagnostic_arg

2573: p_cust_mode))
2574: then*/
2575: -- seed data must not be changed by customers.Hence overwriting data always
2576: -- so that it covers up any changes by mistake
2577: update jtf_diagnostic_arg
2578: set last_updated_by = f_luby,
2579: argvalue = p_argvalue,
2580: VALUESETNUMBER = p_VALUESETNUMBER,
2581: last_update_date = f_ludate,

Line 2596: insert into jtf_diagnostic_arg(

2592:
2593: when no_data_found then
2594: -- Record doesn't exist - insert in all cases
2595:
2596: insert into jtf_diagnostic_arg(
2597: SEQUENCE,
2598: TESTCLASSNAME,
2599: GROUPNAME,
2600: APPID,

Line 2613: jtf_diagnostic_arg_s.nextval,

2609: LAST_UPDATE_LOGIN,
2610: CREATION_DATE,
2611: SECURITY_GROUP_ID)
2612: values(
2613: jtf_diagnostic_arg_s.nextval,
2614: p_testclassname,
2615: p_groupname,
2616: p_appid,
2617: p_argname,