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_VARCHAR2_TABLE_4000

Line 10: P_APPS OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

6: ------------------------------
7:
8:
9: procedure GET_APPS(
10: P_APPS OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
11: P_APPNAMES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
12: P_SIZE OUT NOCOPY NUMBER) is
13:
14:

Line 11: P_APPNAMES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

7:
8:
9: procedure GET_APPS(
10: P_APPS OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
11: P_APPNAMES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
12: P_SIZE OUT NOCOPY NUMBER) is
13:
14:
15: CURSOR APPLIST IS

Line 27: P_APPS := JTF_VARCHAR2_TABLE_4000();

23:
24: BEGIN
25:
26: P_SIZE := 0;
27: P_APPS := JTF_VARCHAR2_TABLE_4000();
28: P_APPNAMES := JTF_VARCHAR2_TABLE_4000();
29:
30: -- Add the first application that does not show up
31: -- in the database fnd tables, 'HTML Platform'

Line 28: P_APPNAMES := JTF_VARCHAR2_TABLE_4000();

24: BEGIN
25:
26: P_SIZE := 0;
27: P_APPS := JTF_VARCHAR2_TABLE_4000();
28: P_APPNAMES := JTF_VARCHAR2_TABLE_4000();
29:
30: -- Add the first application that does not show up
31: -- in the database fnd tables, 'HTML Platform'
32:

Line 63: P_GROUPNAMES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

59:
60:
61: procedure GET_GROUPS(
62: P_APPNAME in VARCHAR2,
63: P_GROUPNAMES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
64: P_GRP_SENSITIVITY OUT NOCOPY JTF_NUMBER_TABLE,
65: P_GRP_LAST_UPDATED_BY OUT NOCOPY JTF_NUMBER_TABLE) is
66:
67: V_SIZE NUMBER;

Line 78: P_GROUPNAMES := JTF_VARCHAR2_TABLE_4000();

74: order by orderNumber;
75:
76: BEGIN
77:
78: P_GROUPNAMES := JTF_VARCHAR2_TABLE_4000();
79: P_GRP_SENSITIVITY := JTF_NUMBER_TABLE();
80: P_GRP_LAST_UPDATED_BY := JTF_NUMBER_TABLE();
81:
82: V_SIZE := 0;

Line 110: P_TESTCLASSNAMES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

106:
107: procedure GET_TESTS(
108: P_APPNAME IN VARCHAR2,
109: P_GROUPNAME IN VARCHAR2,
110: P_TESTCLASSNAMES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
111: P_TESTTYPES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
112: P_TOTALARGROWS OUT NOCOPY JTF_NUMBER_TABLE,
113: P_TST_SENSITIVITY OUT NOCOPY JTF_NUMBER_TABLE,
114: P_TEST_LAST_UPDATED_BY OUT NOCOPY JTF_NUMBER_TABLE

Line 111: P_TESTTYPES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

107: procedure GET_TESTS(
108: P_APPNAME IN VARCHAR2,
109: P_GROUPNAME IN VARCHAR2,
110: P_TESTCLASSNAMES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
111: P_TESTTYPES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
112: P_TOTALARGROWS OUT NOCOPY JTF_NUMBER_TABLE,
113: P_TST_SENSITIVITY OUT NOCOPY JTF_NUMBER_TABLE,
114: P_TEST_LAST_UPDATED_BY OUT NOCOPY JTF_NUMBER_TABLE
115: ) IS

Line 130: P_TESTCLASSNAMES := JTF_VARCHAR2_TABLE_4000();

126: order by orderNumber;
127:
128: BEGIN
129:
130: P_TESTCLASSNAMES := JTF_VARCHAR2_TABLE_4000();
131: P_TESTTYPES := JTF_VARCHAR2_TABLE_4000();
132: P_TOTALARGROWS := JTF_NUMBER_TABLE();
133: P_TST_SENSITIVITY := JTF_NUMBER_TABLE();
134: P_TEST_LAST_UPDATED_BY := JTF_NUMBER_TABLE();

Line 131: P_TESTTYPES := JTF_VARCHAR2_TABLE_4000();

127:
128: BEGIN
129:
130: P_TESTCLASSNAMES := JTF_VARCHAR2_TABLE_4000();
131: P_TESTTYPES := JTF_VARCHAR2_TABLE_4000();
132: P_TOTALARGROWS := JTF_NUMBER_TABLE();
133: P_TST_SENSITIVITY := JTF_NUMBER_TABLE();
134: P_TEST_LAST_UPDATED_BY := JTF_NUMBER_TABLE();
135:

Line 158: P_TESTCLASSNAMES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

154: -- deprecated don't use if you have test level sensitivity
155: procedure GET_TESTS(
156: P_APPNAME IN VARCHAR2,
157: P_GROUPNAME IN VARCHAR2,
158: P_TESTCLASSNAMES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
159: P_TESTTYPES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
160: P_TOTALARGROWS OUT NOCOPY JTF_NUMBER_TABLE,
161: P_TEST_LAST_UPDATED_BY OUT NOCOPY JTF_NUMBER_TABLE
162: ) IS

Line 159: P_TESTTYPES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

155: procedure GET_TESTS(
156: P_APPNAME IN VARCHAR2,
157: P_GROUPNAME IN VARCHAR2,
158: P_TESTCLASSNAMES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
159: P_TESTTYPES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
160: P_TOTALARGROWS OUT NOCOPY JTF_NUMBER_TABLE,
161: P_TEST_LAST_UPDATED_BY OUT NOCOPY JTF_NUMBER_TABLE
162: ) IS
163:

Line 177: P_TESTCLASSNAMES := JTF_VARCHAR2_TABLE_4000();

173: order by orderNumber;
174:
175: BEGIN
176:
177: P_TESTCLASSNAMES := JTF_VARCHAR2_TABLE_4000();
178: P_TESTTYPES := JTF_VARCHAR2_TABLE_4000();
179: P_TOTALARGROWS := JTF_NUMBER_TABLE();
180: P_TEST_LAST_UPDATED_BY := JTF_NUMBER_TABLE();
181:

Line 178: P_TESTTYPES := JTF_VARCHAR2_TABLE_4000();

174:
175: BEGIN
176:
177: P_TESTCLASSNAMES := JTF_VARCHAR2_TABLE_4000();
178: P_TESTTYPES := JTF_VARCHAR2_TABLE_4000();
179: P_TOTALARGROWS := JTF_NUMBER_TABLE();
180: P_TEST_LAST_UPDATED_BY := JTF_NUMBER_TABLE();
181:
182: V_SIZE := 0;

Line 208: P_ARGNAMES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

204: procedure GET_ARGS(
205: P_APPID IN VARCHAR2,
206: P_GROUPNAME IN VARCHAR2,
207: P_TESTCLASSNAME IN VARCHAR2,
208: P_ARGNAMES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
209: P_ARGVALUES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
210: P_ROWNUMBERS OUT NOCOPY JTF_NUMBER_TABLE,
211: P_VALUESETNUM OUT NOCOPY JTF_NUMBER_TABLE) is
212:

Line 209: P_ARGVALUES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

205: P_APPID IN VARCHAR2,
206: P_GROUPNAME IN VARCHAR2,
207: P_TESTCLASSNAME IN VARCHAR2,
208: P_ARGNAMES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
209: P_ARGVALUES OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
210: P_ROWNUMBERS OUT NOCOPY JTF_NUMBER_TABLE,
211: P_VALUESETNUM OUT NOCOPY JTF_NUMBER_TABLE) is
212:
213: V_SIZE number;

Line 225: P_ARGNAMES := jtf_varchar2_table_4000();

221: order by rownumber;
222:
223: BEGIN
224:
225: P_ARGNAMES := jtf_varchar2_table_4000();
226: P_ARGVALUES := jtf_varchar2_table_4000();
227: P_ROWNUMBERS := JTF_NUMBER_TABLE();
228: P_VALUESETNUM := JTF_NUMBER_TABLE();
229:

Line 226: P_ARGVALUES := jtf_varchar2_table_4000();

222:
223: BEGIN
224:
225: P_ARGNAMES := jtf_varchar2_table_4000();
226: P_ARGVALUES := jtf_varchar2_table_4000();
227: P_ROWNUMBERS := JTF_NUMBER_TABLE();
228: P_VALUESETNUM := JTF_NUMBER_TABLE();
229:
230: V_SIZE := 0;

Line 260: P_PREREQ_IDS OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

256:
257: procedure GET_PREREQS(
258: P_APP_OR_GROUP_NAME IN VARCHAR2,
259: P_APPNAME IN VARCHAR2,
260: P_PREREQ_IDS OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
261: P_PREREQ_NAMES OUT NOCOPY JTF_VARCHAR2_TABLE_4000
262: ) IS
263:
264: V_SIZE NUMBER;

Line 261: P_PREREQ_NAMES OUT NOCOPY JTF_VARCHAR2_TABLE_4000

257: procedure GET_PREREQS(
258: P_APP_OR_GROUP_NAME IN VARCHAR2,
259: P_APPNAME IN VARCHAR2,
260: P_PREREQ_IDS OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
261: P_PREREQ_NAMES OUT NOCOPY JTF_VARCHAR2_TABLE_4000
262: ) IS
263:
264: V_SIZE NUMBER;
265: V_TEMP_NAME VARCHAR2(256);

Line 277: P_PREREQ_IDS := JTF_VARCHAR2_TABLE_4000();

273:
274:
275: BEGIN
276: V_SIZE := 0;
277: P_PREREQ_IDS := JTF_VARCHAR2_TABLE_4000();
278: P_PREREQ_NAMES := JTF_VARCHAR2_TABLE_4000();
279: V_TEMP_NAME := '';
280: V_TEMP_TYPE := 0;
281:

Line 278: P_PREREQ_NAMES := JTF_VARCHAR2_TABLE_4000();

274:
275: BEGIN
276: V_SIZE := 0;
277: P_PREREQ_IDS := JTF_VARCHAR2_TABLE_4000();
278: P_PREREQ_NAMES := JTF_VARCHAR2_TABLE_4000();
279: V_TEMP_NAME := '';
280: V_TEMP_TYPE := 0;
281:
282: FOR x in prereqlist

Line 823: P_GROUPNAMES IN JTF_VARCHAR2_TABLE_4000,

819:
820:
821: procedure UPDATE_GROUP_SEQ(
822: P_APPID IN VARCHAR2,
823: P_GROUPNAMES IN JTF_VARCHAR2_TABLE_4000,
824: P_LUBID IN NUMBER) is
825:
826: v_numofrows NUMBER;
827: v_index BINARY_INTEGER := 1;

Line 878: P_GROUPNAMES IN JTF_VARCHAR2_TABLE_4000

874: -- deprecated, please use the one above
875:
876: procedure UPDATE_GROUP_SEQ(
877: P_APPID IN VARCHAR2,
878: P_GROUPNAMES IN JTF_VARCHAR2_TABLE_4000
879: ) IS
880:
881: BEGIN
882:

Line 898: P_TESTCLASSNAMES IN JTF_VARCHAR2_TABLE_4000,

894:
895: procedure UPDATE_TEST_SEQ(
896: P_APPID IN VARCHAR2,
897: P_GROUPNAME IN VARCHAR2,
898: P_TESTCLASSNAMES IN JTF_VARCHAR2_TABLE_4000,
899: P_LUBID IN NUMBER) is
900:
901: v_numofrows NUMBER;
902: v_index BINARY_INTEGER := 1;

Line 955: P_TESTCLASSNAMES IN JTF_VARCHAR2_TABLE_4000

951:
952: procedure UPDATE_TEST_SEQ(
953: P_APPID IN VARCHAR2,
954: P_GROUPNAME IN VARCHAR2,
955: P_TESTCLASSNAMES IN JTF_VARCHAR2_TABLE_4000
956: ) IS
957:
958: BEGIN
959:

Line 975: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,

971:
972: procedure UPDATE_PREREQS(
973: P_SOURCEID IN VARCHAR2,
974: P_SOURCEAPPID IN VARCHAR2,
975: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,
976: P_SOURCETYPE IN NUMBER,
977: P_LUBID IN NUMBER) IS
978:
979: v_index BINARY_INTEGER := 1;

Line 1006: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,

1002: -- deprecated, please use procedure above
1003: procedure UPDATE_PREREQS(
1004: P_SOURCEID IN VARCHAR2,
1005: P_SOURCEAPPID IN VARCHAR2,
1006: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,
1007: P_SOURCETYPE IN NUMBER) IS
1008:
1009: BEGIN
1010:

Line 1028: P_ARGNAMES IN JTF_VARCHAR2_TABLE_4000,

1024: procedure UPDATE_ARG_VALUES(
1025: P_TESTCLASSNAME IN VARCHAR2,
1026: P_GROUPNAME IN VARCHAR2,
1027: P_APPID IN VARCHAR2,
1028: P_ARGNAMES IN JTF_VARCHAR2_TABLE_4000,
1029: P_ARGVALUES IN JTF_VARCHAR2_TABLE_4000,
1030: p_arg_dates in jtf_date_table,
1031: p_arg_numbers in jtf_number_table,
1032: P_ROWNUMBER IN NUMBER,

Line 1029: P_ARGVALUES IN JTF_VARCHAR2_TABLE_4000,

1025: P_TESTCLASSNAME IN VARCHAR2,
1026: P_GROUPNAME IN VARCHAR2,
1027: P_APPID IN VARCHAR2,
1028: P_ARGNAMES IN JTF_VARCHAR2_TABLE_4000,
1029: P_ARGVALUES IN JTF_VARCHAR2_TABLE_4000,
1030: p_arg_dates in jtf_date_table,
1031: p_arg_numbers in jtf_number_table,
1032: P_ROWNUMBER IN NUMBER,
1033: P_LUBID IN NUMBER) is

Line 1079: P_ARGNAMES IN JTF_VARCHAR2_TABLE_4000,

1075: procedure UPDATE_ARG_VALUES(
1076: P_TESTCLASSNAME IN VARCHAR2,
1077: P_GROUPNAME IN VARCHAR2,
1078: P_APPID IN VARCHAR2,
1079: P_ARGNAMES IN JTF_VARCHAR2_TABLE_4000,
1080: P_ARGVALUES IN JTF_VARCHAR2_TABLE_4000,
1081: P_ROWNUMBER IN NUMBER,
1082: P_LUBID IN NUMBER) is
1083:

Line 1080: P_ARGVALUES IN JTF_VARCHAR2_TABLE_4000,

1076: P_TESTCLASSNAME IN VARCHAR2,
1077: P_GROUPNAME IN VARCHAR2,
1078: P_APPID IN VARCHAR2,
1079: P_ARGNAMES IN JTF_VARCHAR2_TABLE_4000,
1080: P_ARGVALUES IN JTF_VARCHAR2_TABLE_4000,
1081: P_ROWNUMBER IN NUMBER,
1082: P_LUBID IN NUMBER) is
1083:
1084: v_index BINARY_INTEGER := 1;

Line 1126: P_ARGNAMES IN JTF_VARCHAR2_TABLE_4000,

1122: procedure UPDATE_ARG_VALUES(
1123: P_TESTCLASSNAME IN VARCHAR2,
1124: P_GROUPNAME IN VARCHAR2,
1125: P_APPID IN VARCHAR2,
1126: P_ARGNAMES IN JTF_VARCHAR2_TABLE_4000,
1127: P_ARGVALUES IN JTF_VARCHAR2_TABLE_4000,
1128: P_ROWNUMBER IN NUMBER
1129: ) IS
1130:

Line 1127: P_ARGVALUES IN JTF_VARCHAR2_TABLE_4000,

1123: P_TESTCLASSNAME IN VARCHAR2,
1124: P_GROUPNAME IN VARCHAR2,
1125: P_APPID IN VARCHAR2,
1126: P_ARGNAMES IN JTF_VARCHAR2_TABLE_4000,
1127: P_ARGVALUES IN JTF_VARCHAR2_TABLE_4000,
1128: P_ROWNUMBER IN NUMBER
1129: ) IS
1130:
1131: BEGIN

Line 1149: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,

1145: -- ----------------------------------------------------------------------
1146:
1147: procedure INSERT_APP(
1148: P_APPID IN VARCHAR2,
1149: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,
1150: P_LUBID IN NUMBER) IS
1151:
1152: -- v_asn fnd_application.application_short_name%TYPE;
1153: V_SOURCETYPE BINARY_INTEGER := 1;

Line 1208: P_PREREQID IN JTF_VARCHAR2_TABLE_4000

1204:
1205: -- deprecated, please use procedure above
1206: procedure INSERT_APP(
1207: P_APPID IN VARCHAR2,
1208: P_PREREQID IN JTF_VARCHAR2_TABLE_4000
1209: ) IS
1210:
1211: BEGIN
1212:

Line 1228: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,

1224:
1225: procedure INSERT_GRP(
1226: P_NEW_GROUP IN VARCHAR2,
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;

Line 1312: P_PREREQID IN JTF_VARCHAR2_TABLE_4000

1308:
1309: procedure INSERT_GRP(
1310: P_NEW_GROUP IN VARCHAR2,
1311: P_APP IN VARCHAR2,
1312: P_PREREQID IN JTF_VARCHAR2_TABLE_4000
1313: ) IS
1314:
1315: BEGIN
1316:

Line 1331: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,

1327:
1328: procedure INSERT_GROUP(
1329: P_NEW_GROUP IN VARCHAR2,
1330: P_APP IN VARCHAR2,
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;

Line 1416: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,

1412:
1413: procedure INSERT_GROUP(
1414: P_NEW_GROUP IN VARCHAR2,
1415: P_APP IN VARCHAR2,
1416: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,
1417: P_SENSITIVITY IN NUMBER
1418: ) IS
1419:
1420: BEGIN

Line 1584: p_arg_names in jtf_varchar2_table_4000,

1580:
1581: procedure INSERT_ARGVALUE_ROW(p_appid in varchar2,
1582: p_group_name in varchar2,
1583: p_test_class_name in varchar2,
1584: p_arg_names in jtf_varchar2_table_4000,
1585: p_arg_values in jtf_varchar2_table_4000,
1586: p_lubid in number) IS
1587:
1588: V_SOURCETYPE BINARY_INTEGER := 1;

Line 1585: p_arg_values in jtf_varchar2_table_4000,

1581: procedure INSERT_ARGVALUE_ROW(p_appid in varchar2,
1582: p_group_name in varchar2,
1583: p_test_class_name in varchar2,
1584: p_arg_names in jtf_varchar2_table_4000,
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;

Line 1675: p_arg_names in jtf_varchar2_table_4000,

1671:
1672: procedure INSERT_ARGVALUE_ROW(p_appid in varchar2,
1673: p_group_name in varchar2,
1674: p_test_class_name in varchar2,
1675: p_arg_names in jtf_varchar2_table_4000,
1676: p_arg_values in jtf_varchar2_table_4000
1677: ) IS
1678:
1679: BEGIN

Line 1676: p_arg_values in jtf_varchar2_table_4000

1672: procedure INSERT_ARGVALUE_ROW(p_appid in varchar2,
1673: p_group_name in varchar2,
1674: p_test_class_name in varchar2,
1675: p_arg_names in jtf_varchar2_table_4000,
1676: p_arg_values in jtf_varchar2_table_4000
1677: ) IS
1678:
1679: BEGIN
1680:

Line 1694: p_arg_names in jtf_varchar2_table_4000,

1690: --mls
1691: procedure INSERT_ARGVALUE_ROW(p_appid in varchar2,
1692: p_group_name in varchar2,
1693: p_test_class_name in varchar2,
1694: p_arg_names in jtf_varchar2_table_4000,
1695: p_arg_values in jtf_varchar2_table_4000,
1696: p_arg_dates in jtf_date_table,
1697: p_arg_numbers in jtf_number_table,
1698: p_lubid in number) IS

Line 1695: p_arg_values in jtf_varchar2_table_4000,

1691: procedure INSERT_ARGVALUE_ROW(p_appid in varchar2,
1692: p_group_name in varchar2,
1693: p_test_class_name in varchar2,
1694: p_arg_names in jtf_varchar2_table_4000,
1695: p_arg_values in jtf_varchar2_table_4000,
1696: p_arg_dates in jtf_date_table,
1697: p_arg_numbers in jtf_number_table,
1698: p_lubid in number) IS
1699:

Line 1835: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,

1831:
1832: procedure PREREQ_INSERTION(
1833: P_SOURCEID IN VARCHAR2,
1834: P_SOURCEAPPID IN VARCHAR2,
1835: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,
1836: P_SOURCETYPE IN NUMBER,
1837: P_LUBID IN NUMBER) IS
1838:
1839: v_index BINARY_INTEGER := 1;

Line 1912: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,

1908: -- deprecated, please use procedure above
1909: procedure PREREQ_INSERTION(
1910: P_SOURCEID IN VARCHAR2,
1911: P_SOURCEAPPID IN VARCHAR2,
1912: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,
1913: P_SOURCETYPE IN NUMBER) IS
1914:
1915: BEGIN
1916: