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
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
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
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
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();
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();
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();
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();
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
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
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();
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);
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
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_2000
230: , a9 JTF_VARCHAR2_TABLE_100
231: , a10 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_2000
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
227: , a6 JTF_VARCHAR2_TABLE_100
228: , a7 JTF_VARCHAR2_TABLE_200
229: , a8 JTF_VARCHAR2_TABLE_2000
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
228: , a7 JTF_VARCHAR2_TABLE_200
229: , a8 JTF_VARCHAR2_TABLE_2000
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
229: , a8 JTF_VARCHAR2_TABLE_2000
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
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
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
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_2000
279: , a9 out nocopy JTF_VARCHAR2_TABLE_100
280: , a10 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_2000
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
276: , a6 out nocopy JTF_VARCHAR2_TABLE_100
277: , a7 out nocopy JTF_VARCHAR2_TABLE_200
278: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
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
277: , a7 out nocopy JTF_VARCHAR2_TABLE_200
278: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
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
278: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
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
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
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();
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_2000();
299: a9 := JTF_VARCHAR2_TABLE_100();
300: a10 := 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_2000();
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();
296: a6 := JTF_VARCHAR2_TABLE_100();
297: a7 := JTF_VARCHAR2_TABLE_200();
298: a8 := JTF_VARCHAR2_TABLE_2000();
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();
297: a7 := JTF_VARCHAR2_TABLE_200();
298: a8 := JTF_VARCHAR2_TABLE_2000();
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();
298: a8 := JTF_VARCHAR2_TABLE_2000();
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
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();
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();
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_2000();
316: a9 := JTF_VARCHAR2_TABLE_100();
317: a10 := 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_2000();
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();
313: a6 := JTF_VARCHAR2_TABLE_100();
314: a7 := JTF_VARCHAR2_TABLE_200();
315: a8 := JTF_VARCHAR2_TABLE_2000();
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();
314: a7 := JTF_VARCHAR2_TABLE_200();
315: a8 := JTF_VARCHAR2_TABLE_2000();
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();
315: a8 := JTF_VARCHAR2_TABLE_2000();
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
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);
367: end rosetta_table_copy_out_p6;
368:
369: procedure rosetta_table_copy_in_p8(t out nocopy iem_mailitem_pub.queue_email_info_tbl, a0 JTF_NUMBER_TABLE
370: , a1 JTF_NUMBER_TABLE
371: , a2 JTF_VARCHAR2_TABLE_100
372: , a3 JTF_NUMBER_TABLE
373: , a4 JTF_VARCHAR2_TABLE_200
374: , a5 JTF_VARCHAR2_TABLE_2000
375: , a6 JTF_VARCHAR2_TABLE_100
371: , a2 JTF_VARCHAR2_TABLE_100
372: , a3 JTF_NUMBER_TABLE
373: , a4 JTF_VARCHAR2_TABLE_200
374: , a5 JTF_VARCHAR2_TABLE_2000
375: , a6 JTF_VARCHAR2_TABLE_100
376: , a7 JTF_NUMBER_TABLE
377: , a8 JTF_VARCHAR2_TABLE_400
378: , a9 JTF_NUMBER_TABLE
379: , a10 JTF_NUMBER_TABLE
376: , a7 JTF_NUMBER_TABLE
377: , a8 JTF_VARCHAR2_TABLE_400
378: , a9 JTF_NUMBER_TABLE
379: , a10 JTF_NUMBER_TABLE
380: , a11 JTF_VARCHAR2_TABLE_100
381: , a12 JTF_VARCHAR2_TABLE_100
382: , a13 JTF_VARCHAR2_TABLE_100
383: ) as
384: ddindx binary_integer; indx binary_integer;
377: , a8 JTF_VARCHAR2_TABLE_400
378: , a9 JTF_NUMBER_TABLE
379: , a10 JTF_NUMBER_TABLE
380: , a11 JTF_VARCHAR2_TABLE_100
381: , a12 JTF_VARCHAR2_TABLE_100
382: , a13 JTF_VARCHAR2_TABLE_100
383: ) as
384: ddindx binary_integer; indx binary_integer;
385: begin
378: , a9 JTF_NUMBER_TABLE
379: , a10 JTF_NUMBER_TABLE
380: , a11 JTF_VARCHAR2_TABLE_100
381: , a12 JTF_VARCHAR2_TABLE_100
382: , a13 JTF_VARCHAR2_TABLE_100
383: ) as
384: ddindx binary_integer; indx binary_integer;
385: begin
386: if a0 is not null and a0.count > 0 then
412: end if;
413: end rosetta_table_copy_in_p8;
414: procedure rosetta_table_copy_out_p8(t iem_mailitem_pub.queue_email_info_tbl, a0 out nocopy JTF_NUMBER_TABLE
415: , a1 out nocopy JTF_NUMBER_TABLE
416: , a2 out nocopy JTF_VARCHAR2_TABLE_100
417: , a3 out nocopy JTF_NUMBER_TABLE
418: , a4 out nocopy JTF_VARCHAR2_TABLE_200
419: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
420: , a6 out nocopy JTF_VARCHAR2_TABLE_100
416: , a2 out nocopy JTF_VARCHAR2_TABLE_100
417: , a3 out nocopy JTF_NUMBER_TABLE
418: , a4 out nocopy JTF_VARCHAR2_TABLE_200
419: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
420: , a6 out nocopy JTF_VARCHAR2_TABLE_100
421: , a7 out nocopy JTF_NUMBER_TABLE
422: , a8 out nocopy JTF_VARCHAR2_TABLE_400
423: , a9 out nocopy JTF_NUMBER_TABLE
424: , a10 out nocopy JTF_NUMBER_TABLE
421: , a7 out nocopy JTF_NUMBER_TABLE
422: , a8 out nocopy JTF_VARCHAR2_TABLE_400
423: , a9 out nocopy JTF_NUMBER_TABLE
424: , a10 out nocopy JTF_NUMBER_TABLE
425: , a11 out nocopy JTF_VARCHAR2_TABLE_100
426: , a12 out nocopy JTF_VARCHAR2_TABLE_100
427: , a13 out nocopy JTF_VARCHAR2_TABLE_100
428: ) as
429: ddindx binary_integer; indx binary_integer;
422: , a8 out nocopy JTF_VARCHAR2_TABLE_400
423: , a9 out nocopy JTF_NUMBER_TABLE
424: , a10 out nocopy JTF_NUMBER_TABLE
425: , a11 out nocopy JTF_VARCHAR2_TABLE_100
426: , a12 out nocopy JTF_VARCHAR2_TABLE_100
427: , a13 out nocopy JTF_VARCHAR2_TABLE_100
428: ) as
429: ddindx binary_integer; indx binary_integer;
430: begin
423: , a9 out nocopy JTF_NUMBER_TABLE
424: , a10 out nocopy JTF_NUMBER_TABLE
425: , a11 out nocopy JTF_VARCHAR2_TABLE_100
426: , a12 out nocopy JTF_VARCHAR2_TABLE_100
427: , a13 out nocopy JTF_VARCHAR2_TABLE_100
428: ) as
429: ddindx binary_integer; indx binary_integer;
430: begin
431: if t is null or t.count = 0 then
430: begin
431: if t is null or t.count = 0 then
432: a0 := JTF_NUMBER_TABLE();
433: a1 := JTF_NUMBER_TABLE();
434: a2 := JTF_VARCHAR2_TABLE_100();
435: a3 := JTF_NUMBER_TABLE();
436: a4 := JTF_VARCHAR2_TABLE_200();
437: a5 := JTF_VARCHAR2_TABLE_2000();
438: a6 := JTF_VARCHAR2_TABLE_100();
434: a2 := JTF_VARCHAR2_TABLE_100();
435: a3 := JTF_NUMBER_TABLE();
436: a4 := JTF_VARCHAR2_TABLE_200();
437: a5 := JTF_VARCHAR2_TABLE_2000();
438: a6 := JTF_VARCHAR2_TABLE_100();
439: a7 := JTF_NUMBER_TABLE();
440: a8 := JTF_VARCHAR2_TABLE_400();
441: a9 := JTF_NUMBER_TABLE();
442: a10 := JTF_NUMBER_TABLE();
439: a7 := JTF_NUMBER_TABLE();
440: a8 := JTF_VARCHAR2_TABLE_400();
441: a9 := JTF_NUMBER_TABLE();
442: a10 := JTF_NUMBER_TABLE();
443: a11 := JTF_VARCHAR2_TABLE_100();
444: a12 := JTF_VARCHAR2_TABLE_100();
445: a13 := JTF_VARCHAR2_TABLE_100();
446: else
447: a0 := JTF_NUMBER_TABLE();
440: a8 := JTF_VARCHAR2_TABLE_400();
441: a9 := JTF_NUMBER_TABLE();
442: a10 := JTF_NUMBER_TABLE();
443: a11 := JTF_VARCHAR2_TABLE_100();
444: a12 := JTF_VARCHAR2_TABLE_100();
445: a13 := JTF_VARCHAR2_TABLE_100();
446: else
447: a0 := JTF_NUMBER_TABLE();
448: a1 := JTF_NUMBER_TABLE();
441: a9 := JTF_NUMBER_TABLE();
442: a10 := JTF_NUMBER_TABLE();
443: a11 := JTF_VARCHAR2_TABLE_100();
444: a12 := JTF_VARCHAR2_TABLE_100();
445: a13 := JTF_VARCHAR2_TABLE_100();
446: else
447: a0 := JTF_NUMBER_TABLE();
448: a1 := JTF_NUMBER_TABLE();
449: a2 := JTF_VARCHAR2_TABLE_100();
445: a13 := JTF_VARCHAR2_TABLE_100();
446: else
447: a0 := JTF_NUMBER_TABLE();
448: a1 := JTF_NUMBER_TABLE();
449: a2 := JTF_VARCHAR2_TABLE_100();
450: a3 := JTF_NUMBER_TABLE();
451: a4 := JTF_VARCHAR2_TABLE_200();
452: a5 := JTF_VARCHAR2_TABLE_2000();
453: a6 := JTF_VARCHAR2_TABLE_100();
449: a2 := JTF_VARCHAR2_TABLE_100();
450: a3 := JTF_NUMBER_TABLE();
451: a4 := JTF_VARCHAR2_TABLE_200();
452: a5 := JTF_VARCHAR2_TABLE_2000();
453: a6 := JTF_VARCHAR2_TABLE_100();
454: a7 := JTF_NUMBER_TABLE();
455: a8 := JTF_VARCHAR2_TABLE_400();
456: a9 := JTF_NUMBER_TABLE();
457: a10 := JTF_NUMBER_TABLE();
454: a7 := JTF_NUMBER_TABLE();
455: a8 := JTF_VARCHAR2_TABLE_400();
456: a9 := JTF_NUMBER_TABLE();
457: a10 := JTF_NUMBER_TABLE();
458: a11 := JTF_VARCHAR2_TABLE_100();
459: a12 := JTF_VARCHAR2_TABLE_100();
460: a13 := JTF_VARCHAR2_TABLE_100();
461: if t.count > 0 then
462: a0.extend(t.count);
455: a8 := JTF_VARCHAR2_TABLE_400();
456: a9 := JTF_NUMBER_TABLE();
457: a10 := JTF_NUMBER_TABLE();
458: a11 := JTF_VARCHAR2_TABLE_100();
459: a12 := JTF_VARCHAR2_TABLE_100();
460: a13 := JTF_VARCHAR2_TABLE_100();
461: if t.count > 0 then
462: a0.extend(t.count);
463: a1.extend(t.count);
456: a9 := JTF_NUMBER_TABLE();
457: a10 := JTF_NUMBER_TABLE();
458: a11 := JTF_VARCHAR2_TABLE_100();
459: a12 := JTF_VARCHAR2_TABLE_100();
460: a13 := JTF_VARCHAR2_TABLE_100();
461: if t.count > 0 then
462: a0.extend(t.count);
463: a1.extend(t.count);
464: a2.extend(t.count);
499: end if;
500: end if;
501: end rosetta_table_copy_out_p8;
502:
503: procedure rosetta_table_copy_in_p10(t out nocopy iem_mailitem_pub.keyvals_tbl_type, a0 JTF_VARCHAR2_TABLE_100
504: , a1 JTF_VARCHAR2_TABLE_300
505: , a2 JTF_VARCHAR2_TABLE_100
506: ) as
507: ddindx binary_integer; indx binary_integer;
501: end rosetta_table_copy_out_p8;
502:
503: procedure rosetta_table_copy_in_p10(t out nocopy iem_mailitem_pub.keyvals_tbl_type, a0 JTF_VARCHAR2_TABLE_100
504: , a1 JTF_VARCHAR2_TABLE_300
505: , a2 JTF_VARCHAR2_TABLE_100
506: ) as
507: ddindx binary_integer; indx binary_integer;
508: begin
509: if a0 is not null and a0.count > 0 then
522: end loop;
523: end if;
524: end if;
525: end rosetta_table_copy_in_p10;
526: procedure rosetta_table_copy_out_p10(t iem_mailitem_pub.keyvals_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
527: , a1 out nocopy JTF_VARCHAR2_TABLE_300
528: , a2 out nocopy JTF_VARCHAR2_TABLE_100
529: ) as
530: ddindx binary_integer; indx binary_integer;
524: end if;
525: end rosetta_table_copy_in_p10;
526: procedure rosetta_table_copy_out_p10(t iem_mailitem_pub.keyvals_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
527: , a1 out nocopy JTF_VARCHAR2_TABLE_300
528: , a2 out nocopy JTF_VARCHAR2_TABLE_100
529: ) as
530: ddindx binary_integer; indx binary_integer;
531: begin
532: if t is null or t.count = 0 then
529: ) as
530: ddindx binary_integer; indx binary_integer;
531: begin
532: if t is null or t.count = 0 then
533: a0 := JTF_VARCHAR2_TABLE_100();
534: a1 := JTF_VARCHAR2_TABLE_300();
535: a2 := JTF_VARCHAR2_TABLE_100();
536: else
537: a0 := JTF_VARCHAR2_TABLE_100();
531: begin
532: if t is null or t.count = 0 then
533: a0 := JTF_VARCHAR2_TABLE_100();
534: a1 := JTF_VARCHAR2_TABLE_300();
535: a2 := JTF_VARCHAR2_TABLE_100();
536: else
537: a0 := JTF_VARCHAR2_TABLE_100();
538: a1 := JTF_VARCHAR2_TABLE_300();
539: a2 := JTF_VARCHAR2_TABLE_100();
533: a0 := JTF_VARCHAR2_TABLE_100();
534: a1 := JTF_VARCHAR2_TABLE_300();
535: a2 := JTF_VARCHAR2_TABLE_100();
536: else
537: a0 := JTF_VARCHAR2_TABLE_100();
538: a1 := JTF_VARCHAR2_TABLE_300();
539: a2 := JTF_VARCHAR2_TABLE_100();
540: if t.count > 0 then
541: a0.extend(t.count);
535: a2 := JTF_VARCHAR2_TABLE_100();
536: else
537: a0 := JTF_VARCHAR2_TABLE_100();
538: a1 := JTF_VARCHAR2_TABLE_300();
539: a2 := JTF_VARCHAR2_TABLE_100();
540: if t.count > 0 then
541: a0.extend(t.count);
542: a1.extend(t.count);
543: a2.extend(t.count);
563: , p_resource_id NUMBER
564: , p_tbl JTF_NUMBER_TABLE
565: , p5_a0 out nocopy JTF_NUMBER_TABLE
566: , p5_a1 out nocopy JTF_NUMBER_TABLE
567: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
568: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
569: , p5_a4 out nocopy JTF_NUMBER_TABLE
570: , p5_a5 out nocopy JTF_NUMBER_TABLE
571: , p5_a6 out nocopy JTF_NUMBER_TABLE
564: , p_tbl JTF_NUMBER_TABLE
565: , p5_a0 out nocopy JTF_NUMBER_TABLE
566: , p5_a1 out nocopy JTF_NUMBER_TABLE
567: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
568: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
569: , p5_a4 out nocopy JTF_NUMBER_TABLE
570: , p5_a5 out nocopy JTF_NUMBER_TABLE
571: , p5_a6 out nocopy JTF_NUMBER_TABLE
572: , p5_a7 out nocopy JTF_NUMBER_TABLE
631: , p_resource_id NUMBER
632: , p_tbl JTF_NUMBER_TABLE
633: , p_email_account_id NUMBER
634: , p6_a0 out nocopy JTF_NUMBER_TABLE
635: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
636: , p6_a2 out nocopy JTF_NUMBER_TABLE
637: , x_return_status out nocopy VARCHAR2
638: , x_msg_count out nocopy NUMBER
639: , x_msg_data out nocopy VARCHAR2
689: , p_init_msg_list VARCHAR2
690: , p_commit VARCHAR2
691: , p_email_account_id NUMBER
692: , p4_a0 out nocopy JTF_NUMBER_TABLE
693: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
694: , p4_a2 out nocopy JTF_NUMBER_TABLE
695: , x_return_status out nocopy VARCHAR2
696: , x_msg_count out nocopy NUMBER
697: , x_msg_data out nocopy VARCHAR2
987: , p7_a40 out nocopy VARCHAR2
988: , p7_a41 out nocopy VARCHAR2
989: , p7_a42 out nocopy VARCHAR2
990: , p7_a43 out nocopy NUMBER
991: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
992: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_300
993: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
994: , x_encrypted_id out nocopy VARCHAR2
995: , x_return_status out nocopy VARCHAR2
989: , p7_a42 out nocopy VARCHAR2
990: , p7_a43 out nocopy NUMBER
991: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
992: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_300
993: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
994: , x_encrypted_id out nocopy VARCHAR2
995: , x_return_status out nocopy VARCHAR2
996: , x_msg_count out nocopy NUMBER
997: , x_msg_data out nocopy VARCHAR2
1554: , p_sort_order NUMBER
1555: , x_total_message out nocopy NUMBER
1556: , p10_a0 out nocopy JTF_NUMBER_TABLE
1557: , p10_a1 out nocopy JTF_NUMBER_TABLE
1558: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
1559: , p10_a3 out nocopy JTF_NUMBER_TABLE
1560: , p10_a4 out nocopy JTF_NUMBER_TABLE
1561: , p10_a5 out nocopy JTF_NUMBER_TABLE
1562: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
1558: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
1559: , p10_a3 out nocopy JTF_NUMBER_TABLE
1560: , p10_a4 out nocopy JTF_NUMBER_TABLE
1561: , p10_a5 out nocopy JTF_NUMBER_TABLE
1562: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
1563: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_200
1564: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_2000
1565: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_100
1566: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
1561: , p10_a5 out nocopy JTF_NUMBER_TABLE
1562: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
1563: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_200
1564: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_2000
1565: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_100
1566: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
1567: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
1568: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
1569: , p10_a13 out nocopy JTF_NUMBER_TABLE
1562: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
1563: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_200
1564: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_2000
1565: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_100
1566: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
1567: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
1568: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
1569: , p10_a13 out nocopy JTF_NUMBER_TABLE
1570: , p10_a14 out nocopy JTF_VARCHAR2_TABLE_100
1563: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_200
1564: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_2000
1565: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_100
1566: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
1567: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
1568: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
1569: , p10_a13 out nocopy JTF_NUMBER_TABLE
1570: , p10_a14 out nocopy JTF_VARCHAR2_TABLE_100
1571: , p10_a15 out nocopy JTF_VARCHAR2_TABLE_300
1564: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_2000
1565: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_100
1566: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
1567: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
1568: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
1569: , p10_a13 out nocopy JTF_NUMBER_TABLE
1570: , p10_a14 out nocopy JTF_VARCHAR2_TABLE_100
1571: , p10_a15 out nocopy JTF_VARCHAR2_TABLE_300
1572: , x_return_status out nocopy VARCHAR2
1566: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
1567: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
1568: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
1569: , p10_a13 out nocopy JTF_NUMBER_TABLE
1570: , p10_a14 out nocopy JTF_VARCHAR2_TABLE_100
1571: , p10_a15 out nocopy JTF_VARCHAR2_TABLE_300
1572: , x_return_status out nocopy VARCHAR2
1573: , x_msg_count out nocopy NUMBER
1574: , x_msg_data out nocopy VARCHAR2
1654: , p_sort_order NUMBER
1655: , x_total_message out nocopy NUMBER
1656: , p10_a0 out nocopy JTF_NUMBER_TABLE
1657: , p10_a1 out nocopy JTF_NUMBER_TABLE
1658: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
1659: , p10_a3 out nocopy JTF_NUMBER_TABLE
1660: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_200
1661: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_2000
1662: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
1658: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
1659: , p10_a3 out nocopy JTF_NUMBER_TABLE
1660: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_200
1661: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_2000
1662: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
1663: , p10_a7 out nocopy JTF_NUMBER_TABLE
1664: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_400
1665: , p10_a9 out nocopy JTF_NUMBER_TABLE
1666: , p10_a10 out nocopy JTF_NUMBER_TABLE
1663: , p10_a7 out nocopy JTF_NUMBER_TABLE
1664: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_400
1665: , p10_a9 out nocopy JTF_NUMBER_TABLE
1666: , p10_a10 out nocopy JTF_NUMBER_TABLE
1667: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
1668: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
1669: , p10_a13 out nocopy JTF_VARCHAR2_TABLE_100
1670: , x_return_status out nocopy VARCHAR2
1671: , x_msg_count out nocopy NUMBER
1664: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_400
1665: , p10_a9 out nocopy JTF_NUMBER_TABLE
1666: , p10_a10 out nocopy JTF_NUMBER_TABLE
1667: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
1668: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
1669: , p10_a13 out nocopy JTF_VARCHAR2_TABLE_100
1670: , x_return_status out nocopy VARCHAR2
1671: , x_msg_count out nocopy NUMBER
1672: , x_msg_data out nocopy VARCHAR2
1665: , p10_a9 out nocopy JTF_NUMBER_TABLE
1666: , p10_a10 out nocopy JTF_NUMBER_TABLE
1667: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
1668: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
1669: , p10_a13 out nocopy JTF_VARCHAR2_TABLE_100
1670: , x_return_status out nocopy VARCHAR2
1671: , x_msg_count out nocopy NUMBER
1672: , x_msg_data out nocopy VARCHAR2
1673: )
1789: , p7_a40 out nocopy VARCHAR2
1790: , p7_a41 out nocopy VARCHAR2
1791: , p7_a42 out nocopy VARCHAR2
1792: , p7_a43 out nocopy NUMBER
1793: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
1794: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_300
1795: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
1796: , x_encrypted_id out nocopy VARCHAR2
1797: , x_return_status out nocopy VARCHAR2
1791: , p7_a42 out nocopy VARCHAR2
1792: , p7_a43 out nocopy NUMBER
1793: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
1794: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_300
1795: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
1796: , x_encrypted_id out nocopy VARCHAR2
1797: , x_return_status out nocopy VARCHAR2
1798: , x_msg_count out nocopy NUMBER
1799: , x_msg_data out nocopy VARCHAR2