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.IEM_MAILITEM_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 18: , a2 JTF_VARCHAR2_TABLE_100

14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy iem_mailitem_pub.email_count_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE

Line 19: , a3 JTF_VARCHAR2_TABLE_100

15:
16: procedure rosetta_table_copy_in_p1(t out nocopy iem_mailitem_pub.email_count_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE

Line 53: , a2 out nocopy JTF_VARCHAR2_TABLE_100

49: end if;
50: end rosetta_table_copy_in_p1;
51: procedure rosetta_table_copy_out_p1(t iem_mailitem_pub.email_count_tbl, a0 out nocopy JTF_NUMBER_TABLE
52: , a1 out nocopy JTF_NUMBER_TABLE
53: , a2 out nocopy JTF_VARCHAR2_TABLE_100
54: , a3 out nocopy JTF_VARCHAR2_TABLE_100
55: , a4 out nocopy JTF_NUMBER_TABLE
56: , a5 out nocopy JTF_NUMBER_TABLE
57: , a6 out nocopy JTF_NUMBER_TABLE

Line 54: , a3 out nocopy JTF_VARCHAR2_TABLE_100

50: end rosetta_table_copy_in_p1;
51: procedure rosetta_table_copy_out_p1(t iem_mailitem_pub.email_count_tbl, a0 out nocopy JTF_NUMBER_TABLE
52: , a1 out nocopy JTF_NUMBER_TABLE
53: , a2 out nocopy JTF_VARCHAR2_TABLE_100
54: , a3 out nocopy JTF_VARCHAR2_TABLE_100
55: , a4 out nocopy JTF_NUMBER_TABLE
56: , a5 out nocopy JTF_NUMBER_TABLE
57: , a6 out nocopy JTF_NUMBER_TABLE
58: , a7 out nocopy JTF_NUMBER_TABLE

Line 66: a2 := JTF_VARCHAR2_TABLE_100();

62: begin
63: if t is null or t.count = 0 then
64: a0 := JTF_NUMBER_TABLE();
65: a1 := JTF_NUMBER_TABLE();
66: a2 := JTF_VARCHAR2_TABLE_100();
67: a3 := JTF_VARCHAR2_TABLE_100();
68: a4 := JTF_NUMBER_TABLE();
69: a5 := JTF_NUMBER_TABLE();
70: a6 := JTF_NUMBER_TABLE();

Line 67: a3 := JTF_VARCHAR2_TABLE_100();

63: if t is null or t.count = 0 then
64: a0 := JTF_NUMBER_TABLE();
65: a1 := JTF_NUMBER_TABLE();
66: a2 := JTF_VARCHAR2_TABLE_100();
67: a3 := JTF_VARCHAR2_TABLE_100();
68: a4 := JTF_NUMBER_TABLE();
69: a5 := JTF_NUMBER_TABLE();
70: a6 := JTF_NUMBER_TABLE();
71: a7 := JTF_NUMBER_TABLE();

Line 76: a2 := JTF_VARCHAR2_TABLE_100();

72: a8 := JTF_NUMBER_TABLE();
73: else
74: a0 := JTF_NUMBER_TABLE();
75: a1 := JTF_NUMBER_TABLE();
76: a2 := JTF_VARCHAR2_TABLE_100();
77: a3 := JTF_VARCHAR2_TABLE_100();
78: a4 := JTF_NUMBER_TABLE();
79: a5 := JTF_NUMBER_TABLE();
80: a6 := JTF_NUMBER_TABLE();

Line 77: a3 := JTF_VARCHAR2_TABLE_100();

73: else
74: a0 := JTF_NUMBER_TABLE();
75: a1 := JTF_NUMBER_TABLE();
76: a2 := JTF_VARCHAR2_TABLE_100();
77: a3 := JTF_VARCHAR2_TABLE_100();
78: a4 := JTF_NUMBER_TABLE();
79: a5 := JTF_NUMBER_TABLE();
80: a6 := JTF_NUMBER_TABLE();
81: a7 := JTF_NUMBER_TABLE();

Line 116: , a1 JTF_VARCHAR2_TABLE_100

112: end if;
113: end rosetta_table_copy_out_p1;
114:
115: procedure rosetta_table_copy_in_p3(t out nocopy iem_mailitem_pub.class_count_tbl, a0 JTF_NUMBER_TABLE
116: , a1 JTF_VARCHAR2_TABLE_100
117: , a2 JTF_NUMBER_TABLE
118: ) as
119: ddindx binary_integer; indx binary_integer;
120: begin

Line 139: , a1 out nocopy JTF_VARCHAR2_TABLE_100

135: end if;
136: end if;
137: end rosetta_table_copy_in_p3;
138: procedure rosetta_table_copy_out_p3(t iem_mailitem_pub.class_count_tbl, a0 out nocopy JTF_NUMBER_TABLE
139: , a1 out nocopy JTF_VARCHAR2_TABLE_100
140: , a2 out nocopy JTF_NUMBER_TABLE
141: ) as
142: ddindx binary_integer; indx binary_integer;
143: begin

Line 146: a1 := JTF_VARCHAR2_TABLE_100();

142: ddindx binary_integer; indx binary_integer;
143: begin
144: if t is null or t.count = 0 then
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_VARCHAR2_TABLE_100();
147: a2 := JTF_NUMBER_TABLE();
148: else
149: a0 := JTF_NUMBER_TABLE();
150: a1 := JTF_VARCHAR2_TABLE_100();

Line 150: a1 := JTF_VARCHAR2_TABLE_100();

146: a1 := JTF_VARCHAR2_TABLE_100();
147: a2 := JTF_NUMBER_TABLE();
148: else
149: a0 := JTF_NUMBER_TABLE();
150: a1 := JTF_VARCHAR2_TABLE_100();
151: a2 := JTF_NUMBER_TABLE();
152: if t.count > 0 then
153: a0.extend(t.count);
154: a1.extend(t.count);

Line 223: , a2 JTF_VARCHAR2_TABLE_100

219: end rosetta_table_copy_out_p4;
220:
221: procedure rosetta_table_copy_in_p6(t out nocopy iem_mailitem_pub.acq_email_info_tbl, a0 JTF_NUMBER_TABLE
222: , a1 JTF_NUMBER_TABLE
223: , a2 JTF_VARCHAR2_TABLE_100
224: , a3 JTF_NUMBER_TABLE
225: , a4 JTF_NUMBER_TABLE
226: , a5 JTF_NUMBER_TABLE
227: , a6 JTF_VARCHAR2_TABLE_100

Line 227: , a6 JTF_VARCHAR2_TABLE_100

223: , a2 JTF_VARCHAR2_TABLE_100
224: , a3 JTF_NUMBER_TABLE
225: , a4 JTF_NUMBER_TABLE
226: , a5 JTF_NUMBER_TABLE
227: , a6 JTF_VARCHAR2_TABLE_100
228: , a7 JTF_VARCHAR2_TABLE_200
229: , a8 JTF_VARCHAR2_TABLE_300
230: , a9 JTF_VARCHAR2_TABLE_100
231: , a10 JTF_VARCHAR2_TABLE_100

Line 230: , a9 JTF_VARCHAR2_TABLE_100

226: , a5 JTF_NUMBER_TABLE
227: , a6 JTF_VARCHAR2_TABLE_100
228: , a7 JTF_VARCHAR2_TABLE_200
229: , a8 JTF_VARCHAR2_TABLE_300
230: , a9 JTF_VARCHAR2_TABLE_100
231: , a10 JTF_VARCHAR2_TABLE_100
232: , a11 JTF_VARCHAR2_TABLE_100
233: , a12 JTF_VARCHAR2_TABLE_100
234: , a13 JTF_NUMBER_TABLE

Line 231: , a10 JTF_VARCHAR2_TABLE_100

227: , a6 JTF_VARCHAR2_TABLE_100
228: , a7 JTF_VARCHAR2_TABLE_200
229: , a8 JTF_VARCHAR2_TABLE_300
230: , a9 JTF_VARCHAR2_TABLE_100
231: , a10 JTF_VARCHAR2_TABLE_100
232: , a11 JTF_VARCHAR2_TABLE_100
233: , a12 JTF_VARCHAR2_TABLE_100
234: , a13 JTF_NUMBER_TABLE
235: , a14 JTF_VARCHAR2_TABLE_100

Line 232: , a11 JTF_VARCHAR2_TABLE_100

228: , a7 JTF_VARCHAR2_TABLE_200
229: , a8 JTF_VARCHAR2_TABLE_300
230: , a9 JTF_VARCHAR2_TABLE_100
231: , a10 JTF_VARCHAR2_TABLE_100
232: , a11 JTF_VARCHAR2_TABLE_100
233: , a12 JTF_VARCHAR2_TABLE_100
234: , a13 JTF_NUMBER_TABLE
235: , a14 JTF_VARCHAR2_TABLE_100
236: , a15 JTF_VARCHAR2_TABLE_300

Line 233: , a12 JTF_VARCHAR2_TABLE_100

229: , a8 JTF_VARCHAR2_TABLE_300
230: , a9 JTF_VARCHAR2_TABLE_100
231: , a10 JTF_VARCHAR2_TABLE_100
232: , a11 JTF_VARCHAR2_TABLE_100
233: , a12 JTF_VARCHAR2_TABLE_100
234: , a13 JTF_NUMBER_TABLE
235: , a14 JTF_VARCHAR2_TABLE_100
236: , a15 JTF_VARCHAR2_TABLE_300
237: ) as

Line 235: , a14 JTF_VARCHAR2_TABLE_100

231: , a10 JTF_VARCHAR2_TABLE_100
232: , a11 JTF_VARCHAR2_TABLE_100
233: , a12 JTF_VARCHAR2_TABLE_100
234: , a13 JTF_NUMBER_TABLE
235: , a14 JTF_VARCHAR2_TABLE_100
236: , a15 JTF_VARCHAR2_TABLE_300
237: ) as
238: ddindx binary_integer; indx binary_integer;
239: begin

Line 272: , a2 out nocopy JTF_VARCHAR2_TABLE_100

268: end if;
269: end rosetta_table_copy_in_p6;
270: procedure rosetta_table_copy_out_p6(t iem_mailitem_pub.acq_email_info_tbl, a0 out nocopy JTF_NUMBER_TABLE
271: , a1 out nocopy JTF_NUMBER_TABLE
272: , a2 out nocopy JTF_VARCHAR2_TABLE_100
273: , a3 out nocopy JTF_NUMBER_TABLE
274: , a4 out nocopy JTF_NUMBER_TABLE
275: , a5 out nocopy JTF_NUMBER_TABLE
276: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 276: , a6 out nocopy JTF_VARCHAR2_TABLE_100

272: , a2 out nocopy JTF_VARCHAR2_TABLE_100
273: , a3 out nocopy JTF_NUMBER_TABLE
274: , a4 out nocopy JTF_NUMBER_TABLE
275: , a5 out nocopy JTF_NUMBER_TABLE
276: , a6 out nocopy JTF_VARCHAR2_TABLE_100
277: , a7 out nocopy JTF_VARCHAR2_TABLE_200
278: , a8 out nocopy JTF_VARCHAR2_TABLE_300
279: , a9 out nocopy JTF_VARCHAR2_TABLE_100
280: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 279: , a9 out nocopy JTF_VARCHAR2_TABLE_100

275: , a5 out nocopy JTF_NUMBER_TABLE
276: , a6 out nocopy JTF_VARCHAR2_TABLE_100
277: , a7 out nocopy JTF_VARCHAR2_TABLE_200
278: , a8 out nocopy JTF_VARCHAR2_TABLE_300
279: , a9 out nocopy JTF_VARCHAR2_TABLE_100
280: , a10 out nocopy JTF_VARCHAR2_TABLE_100
281: , a11 out nocopy JTF_VARCHAR2_TABLE_100
282: , a12 out nocopy JTF_VARCHAR2_TABLE_100
283: , a13 out nocopy JTF_NUMBER_TABLE

Line 280: , a10 out nocopy JTF_VARCHAR2_TABLE_100

276: , a6 out nocopy JTF_VARCHAR2_TABLE_100
277: , a7 out nocopy JTF_VARCHAR2_TABLE_200
278: , a8 out nocopy JTF_VARCHAR2_TABLE_300
279: , a9 out nocopy JTF_VARCHAR2_TABLE_100
280: , a10 out nocopy JTF_VARCHAR2_TABLE_100
281: , a11 out nocopy JTF_VARCHAR2_TABLE_100
282: , a12 out nocopy JTF_VARCHAR2_TABLE_100
283: , a13 out nocopy JTF_NUMBER_TABLE
284: , a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 281: , a11 out nocopy JTF_VARCHAR2_TABLE_100

277: , a7 out nocopy JTF_VARCHAR2_TABLE_200
278: , a8 out nocopy JTF_VARCHAR2_TABLE_300
279: , a9 out nocopy JTF_VARCHAR2_TABLE_100
280: , a10 out nocopy JTF_VARCHAR2_TABLE_100
281: , a11 out nocopy JTF_VARCHAR2_TABLE_100
282: , a12 out nocopy JTF_VARCHAR2_TABLE_100
283: , a13 out nocopy JTF_NUMBER_TABLE
284: , a14 out nocopy JTF_VARCHAR2_TABLE_100
285: , a15 out nocopy JTF_VARCHAR2_TABLE_300

Line 282: , a12 out nocopy JTF_VARCHAR2_TABLE_100

278: , a8 out nocopy JTF_VARCHAR2_TABLE_300
279: , a9 out nocopy JTF_VARCHAR2_TABLE_100
280: , a10 out nocopy JTF_VARCHAR2_TABLE_100
281: , a11 out nocopy JTF_VARCHAR2_TABLE_100
282: , a12 out nocopy JTF_VARCHAR2_TABLE_100
283: , a13 out nocopy JTF_NUMBER_TABLE
284: , a14 out nocopy JTF_VARCHAR2_TABLE_100
285: , a15 out nocopy JTF_VARCHAR2_TABLE_300
286: ) as

Line 284: , a14 out nocopy JTF_VARCHAR2_TABLE_100

280: , a10 out nocopy JTF_VARCHAR2_TABLE_100
281: , a11 out nocopy JTF_VARCHAR2_TABLE_100
282: , a12 out nocopy JTF_VARCHAR2_TABLE_100
283: , a13 out nocopy JTF_NUMBER_TABLE
284: , a14 out nocopy JTF_VARCHAR2_TABLE_100
285: , a15 out nocopy JTF_VARCHAR2_TABLE_300
286: ) as
287: ddindx binary_integer; indx binary_integer;
288: begin

Line 292: a2 := JTF_VARCHAR2_TABLE_100();

288: begin
289: if t is null or t.count = 0 then
290: a0 := JTF_NUMBER_TABLE();
291: a1 := JTF_NUMBER_TABLE();
292: a2 := JTF_VARCHAR2_TABLE_100();
293: a3 := JTF_NUMBER_TABLE();
294: a4 := JTF_NUMBER_TABLE();
295: a5 := JTF_NUMBER_TABLE();
296: a6 := JTF_VARCHAR2_TABLE_100();

Line 296: a6 := JTF_VARCHAR2_TABLE_100();

292: a2 := JTF_VARCHAR2_TABLE_100();
293: a3 := JTF_NUMBER_TABLE();
294: a4 := JTF_NUMBER_TABLE();
295: a5 := JTF_NUMBER_TABLE();
296: a6 := JTF_VARCHAR2_TABLE_100();
297: a7 := JTF_VARCHAR2_TABLE_200();
298: a8 := JTF_VARCHAR2_TABLE_300();
299: a9 := JTF_VARCHAR2_TABLE_100();
300: a10 := JTF_VARCHAR2_TABLE_100();

Line 299: a9 := JTF_VARCHAR2_TABLE_100();

295: a5 := JTF_NUMBER_TABLE();
296: a6 := JTF_VARCHAR2_TABLE_100();
297: a7 := JTF_VARCHAR2_TABLE_200();
298: a8 := JTF_VARCHAR2_TABLE_300();
299: a9 := JTF_VARCHAR2_TABLE_100();
300: a10 := JTF_VARCHAR2_TABLE_100();
301: a11 := JTF_VARCHAR2_TABLE_100();
302: a12 := JTF_VARCHAR2_TABLE_100();
303: a13 := JTF_NUMBER_TABLE();

Line 300: a10 := JTF_VARCHAR2_TABLE_100();

296: a6 := JTF_VARCHAR2_TABLE_100();
297: a7 := JTF_VARCHAR2_TABLE_200();
298: a8 := JTF_VARCHAR2_TABLE_300();
299: a9 := JTF_VARCHAR2_TABLE_100();
300: a10 := JTF_VARCHAR2_TABLE_100();
301: a11 := JTF_VARCHAR2_TABLE_100();
302: a12 := JTF_VARCHAR2_TABLE_100();
303: a13 := JTF_NUMBER_TABLE();
304: a14 := JTF_VARCHAR2_TABLE_100();

Line 301: a11 := JTF_VARCHAR2_TABLE_100();

297: a7 := JTF_VARCHAR2_TABLE_200();
298: a8 := JTF_VARCHAR2_TABLE_300();
299: a9 := JTF_VARCHAR2_TABLE_100();
300: a10 := JTF_VARCHAR2_TABLE_100();
301: a11 := JTF_VARCHAR2_TABLE_100();
302: a12 := JTF_VARCHAR2_TABLE_100();
303: a13 := JTF_NUMBER_TABLE();
304: a14 := JTF_VARCHAR2_TABLE_100();
305: a15 := JTF_VARCHAR2_TABLE_300();

Line 302: a12 := JTF_VARCHAR2_TABLE_100();

298: a8 := JTF_VARCHAR2_TABLE_300();
299: a9 := JTF_VARCHAR2_TABLE_100();
300: a10 := JTF_VARCHAR2_TABLE_100();
301: a11 := JTF_VARCHAR2_TABLE_100();
302: a12 := JTF_VARCHAR2_TABLE_100();
303: a13 := JTF_NUMBER_TABLE();
304: a14 := JTF_VARCHAR2_TABLE_100();
305: a15 := JTF_VARCHAR2_TABLE_300();
306: else

Line 304: a14 := JTF_VARCHAR2_TABLE_100();

300: a10 := JTF_VARCHAR2_TABLE_100();
301: a11 := JTF_VARCHAR2_TABLE_100();
302: a12 := JTF_VARCHAR2_TABLE_100();
303: a13 := JTF_NUMBER_TABLE();
304: a14 := JTF_VARCHAR2_TABLE_100();
305: a15 := JTF_VARCHAR2_TABLE_300();
306: else
307: a0 := JTF_NUMBER_TABLE();
308: a1 := JTF_NUMBER_TABLE();

Line 309: a2 := JTF_VARCHAR2_TABLE_100();

305: a15 := JTF_VARCHAR2_TABLE_300();
306: else
307: a0 := JTF_NUMBER_TABLE();
308: a1 := JTF_NUMBER_TABLE();
309: a2 := JTF_VARCHAR2_TABLE_100();
310: a3 := JTF_NUMBER_TABLE();
311: a4 := JTF_NUMBER_TABLE();
312: a5 := JTF_NUMBER_TABLE();
313: a6 := JTF_VARCHAR2_TABLE_100();

Line 313: a6 := JTF_VARCHAR2_TABLE_100();

309: a2 := JTF_VARCHAR2_TABLE_100();
310: a3 := JTF_NUMBER_TABLE();
311: a4 := JTF_NUMBER_TABLE();
312: a5 := JTF_NUMBER_TABLE();
313: a6 := JTF_VARCHAR2_TABLE_100();
314: a7 := JTF_VARCHAR2_TABLE_200();
315: a8 := JTF_VARCHAR2_TABLE_300();
316: a9 := JTF_VARCHAR2_TABLE_100();
317: a10 := JTF_VARCHAR2_TABLE_100();

Line 316: a9 := JTF_VARCHAR2_TABLE_100();

312: a5 := JTF_NUMBER_TABLE();
313: a6 := JTF_VARCHAR2_TABLE_100();
314: a7 := JTF_VARCHAR2_TABLE_200();
315: a8 := JTF_VARCHAR2_TABLE_300();
316: a9 := JTF_VARCHAR2_TABLE_100();
317: a10 := JTF_VARCHAR2_TABLE_100();
318: a11 := JTF_VARCHAR2_TABLE_100();
319: a12 := JTF_VARCHAR2_TABLE_100();
320: a13 := JTF_NUMBER_TABLE();

Line 317: a10 := JTF_VARCHAR2_TABLE_100();

313: a6 := JTF_VARCHAR2_TABLE_100();
314: a7 := JTF_VARCHAR2_TABLE_200();
315: a8 := JTF_VARCHAR2_TABLE_300();
316: a9 := JTF_VARCHAR2_TABLE_100();
317: a10 := JTF_VARCHAR2_TABLE_100();
318: a11 := JTF_VARCHAR2_TABLE_100();
319: a12 := JTF_VARCHAR2_TABLE_100();
320: a13 := JTF_NUMBER_TABLE();
321: a14 := JTF_VARCHAR2_TABLE_100();

Line 318: a11 := JTF_VARCHAR2_TABLE_100();

314: a7 := JTF_VARCHAR2_TABLE_200();
315: a8 := JTF_VARCHAR2_TABLE_300();
316: a9 := JTF_VARCHAR2_TABLE_100();
317: a10 := JTF_VARCHAR2_TABLE_100();
318: a11 := JTF_VARCHAR2_TABLE_100();
319: a12 := JTF_VARCHAR2_TABLE_100();
320: a13 := JTF_NUMBER_TABLE();
321: a14 := JTF_VARCHAR2_TABLE_100();
322: a15 := JTF_VARCHAR2_TABLE_300();

Line 319: a12 := JTF_VARCHAR2_TABLE_100();

315: a8 := JTF_VARCHAR2_TABLE_300();
316: a9 := JTF_VARCHAR2_TABLE_100();
317: a10 := JTF_VARCHAR2_TABLE_100();
318: a11 := JTF_VARCHAR2_TABLE_100();
319: a12 := JTF_VARCHAR2_TABLE_100();
320: a13 := JTF_NUMBER_TABLE();
321: a14 := JTF_VARCHAR2_TABLE_100();
322: a15 := JTF_VARCHAR2_TABLE_300();
323: if t.count > 0 then

Line 321: a14 := JTF_VARCHAR2_TABLE_100();

317: a10 := JTF_VARCHAR2_TABLE_100();
318: a11 := JTF_VARCHAR2_TABLE_100();
319: a12 := JTF_VARCHAR2_TABLE_100();
320: a13 := JTF_NUMBER_TABLE();
321: a14 := JTF_VARCHAR2_TABLE_100();
322: a15 := JTF_VARCHAR2_TABLE_300();
323: if t.count > 0 then
324: a0.extend(t.count);
325: a1.extend(t.count);

Line 369: procedure rosetta_table_copy_in_p8(t out nocopy iem_mailitem_pub.keyvals_tbl_type, a0 JTF_VARCHAR2_TABLE_100

365: end if;
366: end if;
367: end rosetta_table_copy_out_p6;
368:
369: procedure rosetta_table_copy_in_p8(t out nocopy iem_mailitem_pub.keyvals_tbl_type, a0 JTF_VARCHAR2_TABLE_100
370: , a1 JTF_VARCHAR2_TABLE_300
371: , a2 JTF_VARCHAR2_TABLE_100
372: ) as
373: ddindx binary_integer; indx binary_integer;

Line 371: , a2 JTF_VARCHAR2_TABLE_100

367: end rosetta_table_copy_out_p6;
368:
369: procedure rosetta_table_copy_in_p8(t out nocopy iem_mailitem_pub.keyvals_tbl_type, a0 JTF_VARCHAR2_TABLE_100
370: , a1 JTF_VARCHAR2_TABLE_300
371: , a2 JTF_VARCHAR2_TABLE_100
372: ) as
373: ddindx binary_integer; indx binary_integer;
374: begin
375: if a0 is not null and a0.count > 0 then

Line 392: procedure rosetta_table_copy_out_p8(t iem_mailitem_pub.keyvals_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

388: end loop;
389: end if;
390: end if;
391: end rosetta_table_copy_in_p8;
392: procedure rosetta_table_copy_out_p8(t iem_mailitem_pub.keyvals_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
393: , a1 out nocopy JTF_VARCHAR2_TABLE_300
394: , a2 out nocopy JTF_VARCHAR2_TABLE_100
395: ) as
396: ddindx binary_integer; indx binary_integer;

Line 394: , a2 out nocopy JTF_VARCHAR2_TABLE_100

390: end if;
391: end rosetta_table_copy_in_p8;
392: procedure rosetta_table_copy_out_p8(t iem_mailitem_pub.keyvals_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
393: , a1 out nocopy JTF_VARCHAR2_TABLE_300
394: , a2 out nocopy JTF_VARCHAR2_TABLE_100
395: ) as
396: ddindx binary_integer; indx binary_integer;
397: begin
398: if t is null or t.count = 0 then

Line 399: a0 := JTF_VARCHAR2_TABLE_100();

395: ) as
396: ddindx binary_integer; indx binary_integer;
397: begin
398: if t is null or t.count = 0 then
399: a0 := JTF_VARCHAR2_TABLE_100();
400: a1 := JTF_VARCHAR2_TABLE_300();
401: a2 := JTF_VARCHAR2_TABLE_100();
402: else
403: a0 := JTF_VARCHAR2_TABLE_100();

Line 401: a2 := JTF_VARCHAR2_TABLE_100();

397: begin
398: if t is null or t.count = 0 then
399: a0 := JTF_VARCHAR2_TABLE_100();
400: a1 := JTF_VARCHAR2_TABLE_300();
401: a2 := JTF_VARCHAR2_TABLE_100();
402: else
403: a0 := JTF_VARCHAR2_TABLE_100();
404: a1 := JTF_VARCHAR2_TABLE_300();
405: a2 := JTF_VARCHAR2_TABLE_100();

Line 403: a0 := JTF_VARCHAR2_TABLE_100();

399: a0 := JTF_VARCHAR2_TABLE_100();
400: a1 := JTF_VARCHAR2_TABLE_300();
401: a2 := JTF_VARCHAR2_TABLE_100();
402: else
403: a0 := JTF_VARCHAR2_TABLE_100();
404: a1 := JTF_VARCHAR2_TABLE_300();
405: a2 := JTF_VARCHAR2_TABLE_100();
406: if t.count > 0 then
407: a0.extend(t.count);

Line 405: a2 := JTF_VARCHAR2_TABLE_100();

401: a2 := JTF_VARCHAR2_TABLE_100();
402: else
403: a0 := JTF_VARCHAR2_TABLE_100();
404: a1 := JTF_VARCHAR2_TABLE_300();
405: a2 := JTF_VARCHAR2_TABLE_100();
406: if t.count > 0 then
407: a0.extend(t.count);
408: a1.extend(t.count);
409: a2.extend(t.count);

Line 433: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100

429: , p_resource_id NUMBER
430: , p_tbl JTF_NUMBER_TABLE
431: , p5_a0 out nocopy JTF_NUMBER_TABLE
432: , p5_a1 out nocopy JTF_NUMBER_TABLE
433: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
434: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
435: , p5_a4 out nocopy JTF_NUMBER_TABLE
436: , p5_a5 out nocopy JTF_NUMBER_TABLE
437: , p5_a6 out nocopy JTF_NUMBER_TABLE

Line 434: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100

430: , p_tbl JTF_NUMBER_TABLE
431: , p5_a0 out nocopy JTF_NUMBER_TABLE
432: , p5_a1 out nocopy JTF_NUMBER_TABLE
433: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
434: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
435: , p5_a4 out nocopy JTF_NUMBER_TABLE
436: , p5_a5 out nocopy JTF_NUMBER_TABLE
437: , p5_a6 out nocopy JTF_NUMBER_TABLE
438: , p5_a7 out nocopy JTF_NUMBER_TABLE

Line 501: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

497: , p_resource_id NUMBER
498: , p_tbl JTF_NUMBER_TABLE
499: , p_email_account_id NUMBER
500: , p6_a0 out nocopy JTF_NUMBER_TABLE
501: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
502: , p6_a2 out nocopy JTF_NUMBER_TABLE
503: , x_return_status out nocopy VARCHAR2
504: , x_msg_count out nocopy NUMBER
505: , x_msg_data out nocopy VARCHAR2

Line 559: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

555: , p_init_msg_list VARCHAR2
556: , p_commit VARCHAR2
557: , p_email_account_id NUMBER
558: , p4_a0 out nocopy JTF_NUMBER_TABLE
559: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
560: , p4_a2 out nocopy JTF_NUMBER_TABLE
561: , x_return_status out nocopy VARCHAR2
562: , x_msg_count out nocopy NUMBER
563: , x_msg_data out nocopy VARCHAR2

Line 857: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100

853: , p7_a40 out nocopy VARCHAR2
854: , p7_a41 out nocopy VARCHAR2
855: , p7_a42 out nocopy VARCHAR2
856: , p7_a43 out nocopy NUMBER
857: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
858: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_300
859: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
860: , x_encrypted_id out nocopy VARCHAR2
861: , x_return_status out nocopy VARCHAR2

Line 859: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100

855: , p7_a42 out nocopy VARCHAR2
856: , p7_a43 out nocopy NUMBER
857: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
858: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_300
859: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
860: , x_encrypted_id out nocopy VARCHAR2
861: , x_return_status out nocopy VARCHAR2
862: , x_msg_count out nocopy NUMBER
863: , x_msg_data out nocopy VARCHAR2

Line 1424: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100

1420: , p_sort_order NUMBER
1421: , x_total_message out nocopy NUMBER
1422: , p10_a0 out nocopy JTF_NUMBER_TABLE
1423: , p10_a1 out nocopy JTF_NUMBER_TABLE
1424: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
1425: , p10_a3 out nocopy JTF_NUMBER_TABLE
1426: , p10_a4 out nocopy JTF_NUMBER_TABLE
1427: , p10_a5 out nocopy JTF_NUMBER_TABLE
1428: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 1428: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100

1424: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
1425: , p10_a3 out nocopy JTF_NUMBER_TABLE
1426: , p10_a4 out nocopy JTF_NUMBER_TABLE
1427: , p10_a5 out nocopy JTF_NUMBER_TABLE
1428: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
1429: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_200
1430: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_300
1431: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_100
1432: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 1431: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_100

1427: , p10_a5 out nocopy JTF_NUMBER_TABLE
1428: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
1429: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_200
1430: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_300
1431: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_100
1432: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
1433: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
1434: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
1435: , p10_a13 out nocopy JTF_NUMBER_TABLE

Line 1432: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100

1428: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
1429: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_200
1430: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_300
1431: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_100
1432: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
1433: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
1434: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
1435: , p10_a13 out nocopy JTF_NUMBER_TABLE
1436: , p10_a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 1433: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100

1429: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_200
1430: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_300
1431: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_100
1432: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
1433: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
1434: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
1435: , p10_a13 out nocopy JTF_NUMBER_TABLE
1436: , p10_a14 out nocopy JTF_VARCHAR2_TABLE_100
1437: , p10_a15 out nocopy JTF_VARCHAR2_TABLE_300

Line 1434: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100

1430: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_300
1431: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_100
1432: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
1433: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
1434: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
1435: , p10_a13 out nocopy JTF_NUMBER_TABLE
1436: , p10_a14 out nocopy JTF_VARCHAR2_TABLE_100
1437: , p10_a15 out nocopy JTF_VARCHAR2_TABLE_300
1438: , x_return_status out nocopy VARCHAR2

Line 1436: , p10_a14 out nocopy JTF_VARCHAR2_TABLE_100

1432: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
1433: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
1434: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
1435: , p10_a13 out nocopy JTF_NUMBER_TABLE
1436: , p10_a14 out nocopy JTF_VARCHAR2_TABLE_100
1437: , p10_a15 out nocopy JTF_VARCHAR2_TABLE_300
1438: , x_return_status out nocopy VARCHAR2
1439: , x_msg_count out nocopy NUMBER
1440: , x_msg_data out nocopy VARCHAR2

Line 1563: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100

1559: , p7_a40 out nocopy VARCHAR2
1560: , p7_a41 out nocopy VARCHAR2
1561: , p7_a42 out nocopy VARCHAR2
1562: , p7_a43 out nocopy NUMBER
1563: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
1564: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_300
1565: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
1566: , x_encrypted_id out nocopy VARCHAR2
1567: , x_return_status out nocopy VARCHAR2

Line 1565: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100

1561: , p7_a42 out nocopy VARCHAR2
1562: , p7_a43 out nocopy NUMBER
1563: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
1564: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_300
1565: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
1566: , x_encrypted_id out nocopy VARCHAR2
1567: , x_return_status out nocopy VARCHAR2
1568: , x_msg_count out nocopy NUMBER
1569: , x_msg_data out nocopy VARCHAR2