DBA Data[Home] [Help]

APPS.JTF_DIAGNOSTIC dependencies on JTF_NUMBER_TABLE

Line 64: P_GRP_SENSITIVITY OUT NOCOPY JTF_NUMBER_TABLE,

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;
68:

Line 65: P_GRP_LAST_UPDATED_BY OUT NOCOPY JTF_NUMBER_TABLE) is

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;
68:
69: /* 5953806 - changed select to get last_updated_by instead of created_by */

Line 79: P_GRP_SENSITIVITY := JTF_NUMBER_TABLE();

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;
83:

Line 80: P_GRP_LAST_UPDATED_BY := JTF_NUMBER_TABLE();

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;
83:
84: FOR x in grouplist

Line 112: P_TOTALARGROWS OUT NOCOPY JTF_NUMBER_TABLE,

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
116:

Line 113: P_TST_SENSITIVITY OUT NOCOPY JTF_NUMBER_TABLE,

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
116:
117:

Line 114: P_TEST_LAST_UPDATED_BY OUT NOCOPY JTF_NUMBER_TABLE

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
116:
117:
118: V_SIZE number;

Line 132: P_TOTALARGROWS := JTF_NUMBER_TABLE();

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:
136: V_SIZE := 0;

Line 133: P_TST_SENSITIVITY := JTF_NUMBER_TABLE();

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:
136: V_SIZE := 0;
137:

Line 134: P_TEST_LAST_UPDATED_BY := JTF_NUMBER_TABLE();

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:
136: V_SIZE := 0;
137:
138: FOR x in TESTLIST

Line 160: P_TOTALARGROWS OUT NOCOPY JTF_NUMBER_TABLE,

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:
164:

Line 161: P_TEST_LAST_UPDATED_BY OUT NOCOPY JTF_NUMBER_TABLE

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:
164:
165: V_SIZE number;

Line 179: P_TOTALARGROWS := JTF_NUMBER_TABLE();

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;
183:

Line 180: P_TEST_LAST_UPDATED_BY := JTF_NUMBER_TABLE();

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;
183:
184: FOR x in TESTLIST

Line 210: P_ROWNUMBERS OUT NOCOPY JTF_NUMBER_TABLE,

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;
214:

Line 211: P_VALUESETNUM OUT NOCOPY JTF_NUMBER_TABLE) is

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;
214:
215: cursor arglist is

Line 227: P_ROWNUMBERS := JTF_NUMBER_TABLE();

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;
231:

Line 228: P_VALUESETNUM := JTF_NUMBER_TABLE();

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;
231:
232: FOR x in arglist