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 727: P_GROUPNAMES IN JTF_VARCHAR2_TABLE_4000,

723:
724:
725: procedure UPDATE_GROUP_SEQ(
726: P_APPID IN VARCHAR2,
727: P_GROUPNAMES IN JTF_VARCHAR2_TABLE_4000,
728: P_LUBID IN NUMBER) is
729:
730: v_numofrows NUMBER;
731: v_index BINARY_INTEGER := 1;

Line 782: P_GROUPNAMES IN JTF_VARCHAR2_TABLE_4000

778: -- deprecated, please use the one above
779:
780: procedure UPDATE_GROUP_SEQ(
781: P_APPID IN VARCHAR2,
782: P_GROUPNAMES IN JTF_VARCHAR2_TABLE_4000
783: ) IS
784:
785: BEGIN
786:

Line 802: P_TESTCLASSNAMES IN JTF_VARCHAR2_TABLE_4000,

798:
799: procedure UPDATE_TEST_SEQ(
800: P_APPID IN VARCHAR2,
801: P_GROUPNAME IN VARCHAR2,
802: P_TESTCLASSNAMES IN JTF_VARCHAR2_TABLE_4000,
803: P_LUBID IN NUMBER) is
804:
805: v_numofrows NUMBER;
806: v_index BINARY_INTEGER := 1;

Line 859: P_TESTCLASSNAMES IN JTF_VARCHAR2_TABLE_4000

855:
856: procedure UPDATE_TEST_SEQ(
857: P_APPID IN VARCHAR2,
858: P_GROUPNAME IN VARCHAR2,
859: P_TESTCLASSNAMES IN JTF_VARCHAR2_TABLE_4000
860: ) IS
861:
862: BEGIN
863:

Line 879: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,

875:
876: procedure UPDATE_PREREQS(
877: P_SOURCEID IN VARCHAR2,
878: P_SOURCEAPPID IN VARCHAR2,
879: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,
880: P_SOURCETYPE IN NUMBER,
881: P_LUBID IN NUMBER) IS
882:
883: v_index BINARY_INTEGER := 1;

Line 910: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,

906: -- deprecated, please use procedure above
907: procedure UPDATE_PREREQS(
908: P_SOURCEID IN VARCHAR2,
909: P_SOURCEAPPID IN VARCHAR2,
910: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,
911: P_SOURCETYPE IN NUMBER) IS
912:
913: BEGIN
914:

Line 932: P_ARGNAMES IN JTF_VARCHAR2_TABLE_4000,

928: procedure UPDATE_ARG_VALUES(
929: P_TESTCLASSNAME IN VARCHAR2,
930: P_GROUPNAME IN VARCHAR2,
931: P_APPID IN VARCHAR2,
932: P_ARGNAMES IN JTF_VARCHAR2_TABLE_4000,
933: P_ARGVALUES IN JTF_VARCHAR2_TABLE_4000,
934: P_ROWNUMBER IN NUMBER,
935: P_LUBID IN NUMBER) is
936:

Line 933: P_ARGVALUES IN JTF_VARCHAR2_TABLE_4000,

929: P_TESTCLASSNAME IN VARCHAR2,
930: P_GROUPNAME IN VARCHAR2,
931: P_APPID IN VARCHAR2,
932: P_ARGNAMES IN JTF_VARCHAR2_TABLE_4000,
933: P_ARGVALUES IN JTF_VARCHAR2_TABLE_4000,
934: P_ROWNUMBER IN NUMBER,
935: P_LUBID IN NUMBER) is
936:
937: v_index BINARY_INTEGER := 1;

Line 979: P_ARGNAMES IN JTF_VARCHAR2_TABLE_4000,

975: procedure UPDATE_ARG_VALUES(
976: P_TESTCLASSNAME IN VARCHAR2,
977: P_GROUPNAME IN VARCHAR2,
978: P_APPID IN VARCHAR2,
979: P_ARGNAMES IN JTF_VARCHAR2_TABLE_4000,
980: P_ARGVALUES IN JTF_VARCHAR2_TABLE_4000,
981: P_ROWNUMBER IN NUMBER
982: ) IS
983:

Line 980: P_ARGVALUES IN JTF_VARCHAR2_TABLE_4000,

976: P_TESTCLASSNAME IN VARCHAR2,
977: P_GROUPNAME IN VARCHAR2,
978: P_APPID IN VARCHAR2,
979: P_ARGNAMES IN JTF_VARCHAR2_TABLE_4000,
980: P_ARGVALUES IN JTF_VARCHAR2_TABLE_4000,
981: P_ROWNUMBER IN NUMBER
982: ) IS
983:
984: BEGIN

Line 1002: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,

998: -- ----------------------------------------------------------------------
999:
1000: procedure INSERT_APP(
1001: P_APPID IN VARCHAR2,
1002: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,
1003: P_LUBID IN NUMBER) IS
1004:
1005: -- v_asn fnd_application.application_short_name%TYPE;
1006: V_SOURCETYPE BINARY_INTEGER := 1;

Line 1061: P_PREREQID IN JTF_VARCHAR2_TABLE_4000

1057:
1058: -- deprecated, please use procedure above
1059: procedure INSERT_APP(
1060: P_APPID IN VARCHAR2,
1061: P_PREREQID IN JTF_VARCHAR2_TABLE_4000
1062: ) IS
1063:
1064: BEGIN
1065:

Line 1081: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,

1077:
1078: procedure INSERT_GRP(
1079: P_NEW_GROUP IN VARCHAR2,
1080: P_APP IN VARCHAR2,
1081: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,
1082: P_LUBID IN NUMBER) IS
1083:
1084: v_groupname jtf_diagnostic_group.groupname%TYPE;
1085: V_SOURCETYPE BINARY_INTEGER := 2;

Line 1165: P_PREREQID IN JTF_VARCHAR2_TABLE_4000

1161:
1162: procedure INSERT_GRP(
1163: P_NEW_GROUP IN VARCHAR2,
1164: P_APP IN VARCHAR2,
1165: P_PREREQID IN JTF_VARCHAR2_TABLE_4000
1166: ) IS
1167:
1168: BEGIN
1169:

Line 1184: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,

1180:
1181: procedure INSERT_GROUP(
1182: P_NEW_GROUP IN VARCHAR2,
1183: P_APP IN VARCHAR2,
1184: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,
1185: P_SENSITIVITY IN NUMBER,
1186: P_LUBID IN NUMBER) IS
1187:
1188: v_groupname jtf_diagnostic_group.groupname%TYPE;

Line 1269: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,

1265:
1266: procedure INSERT_GROUP(
1267: P_NEW_GROUP IN VARCHAR2,
1268: P_APP IN VARCHAR2,
1269: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,
1270: P_SENSITIVITY IN NUMBER
1271: ) IS
1272:
1273: BEGIN

Line 1424: p_arg_names in jtf_varchar2_table_4000,

1420:
1421: procedure INSERT_ARGVALUE_ROW(p_appid in varchar2,
1422: p_group_name in varchar2,
1423: p_test_class_name in varchar2,
1424: p_arg_names in jtf_varchar2_table_4000,
1425: p_arg_values in jtf_varchar2_table_4000,
1426: p_lubid in number) IS
1427:
1428: V_SOURCETYPE BINARY_INTEGER := 1;

Line 1425: p_arg_values in jtf_varchar2_table_4000,

1421: procedure INSERT_ARGVALUE_ROW(p_appid in varchar2,
1422: p_group_name in varchar2,
1423: p_test_class_name in varchar2,
1424: p_arg_names in jtf_varchar2_table_4000,
1425: p_arg_values in jtf_varchar2_table_4000,
1426: p_lubid in number) IS
1427:
1428: V_SOURCETYPE BINARY_INTEGER := 1;
1429: v_rownumber jtf_diagnostic_arg.rownumber%TYPE;

Line 1515: p_arg_names in jtf_varchar2_table_4000,

1511:
1512: procedure INSERT_ARGVALUE_ROW(p_appid in varchar2,
1513: p_group_name in varchar2,
1514: p_test_class_name in varchar2,
1515: p_arg_names in jtf_varchar2_table_4000,
1516: p_arg_values in jtf_varchar2_table_4000
1517: ) IS
1518:
1519: BEGIN

Line 1516: p_arg_values in jtf_varchar2_table_4000

1512: procedure INSERT_ARGVALUE_ROW(p_appid in varchar2,
1513: p_group_name in varchar2,
1514: p_test_class_name in varchar2,
1515: p_arg_names in jtf_varchar2_table_4000,
1516: p_arg_values in jtf_varchar2_table_4000
1517: ) IS
1518:
1519: BEGIN
1520:

Line 1577: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,

1573:
1574: procedure PREREQ_INSERTION(
1575: P_SOURCEID IN VARCHAR2,
1576: P_SOURCEAPPID IN VARCHAR2,
1577: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,
1578: P_SOURCETYPE IN NUMBER,
1579: P_LUBID IN NUMBER) IS
1580:
1581: v_index BINARY_INTEGER := 1;

Line 1654: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,

1650: -- deprecated, please use procedure above
1651: procedure PREREQ_INSERTION(
1652: P_SOURCEID IN VARCHAR2,
1653: P_SOURCEAPPID IN VARCHAR2,
1654: P_PREREQID IN JTF_VARCHAR2_TABLE_4000,
1655: P_SOURCETYPE IN NUMBER) IS
1656:
1657: BEGIN
1658: