[Home] [Help]
PACKAGE: APPS.IEM_MAILITEM_PUB_W
Source
1 package iem_mailitem_pub_w AUTHID CURRENT_USER as
2 /* $Header: IEMPMICS.pls 120.4.12020000.3 2012/10/05 06:18:28 lkullamb ship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy iem_mailitem_pub.email_count_tbl, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_VARCHAR2_TABLE_100
6 , a3 JTF_VARCHAR2_TABLE_100
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_NUMBER_TABLE
12 );
13 procedure rosetta_table_copy_out_p1(t iem_mailitem_pub.email_count_tbl, a0 out nocopy JTF_NUMBER_TABLE
14 , a1 out nocopy JTF_NUMBER_TABLE
15 , a2 out nocopy JTF_VARCHAR2_TABLE_100
16 , a3 out nocopy JTF_VARCHAR2_TABLE_100
17 , a4 out nocopy JTF_NUMBER_TABLE
18 , a5 out nocopy JTF_NUMBER_TABLE
19 , a6 out nocopy JTF_NUMBER_TABLE
20 , a7 out nocopy JTF_NUMBER_TABLE
21 , a8 out nocopy JTF_NUMBER_TABLE
22 );
23
24 procedure rosetta_table_copy_in_p3(t out nocopy iem_mailitem_pub.class_count_tbl, a0 JTF_NUMBER_TABLE
25 , a1 JTF_VARCHAR2_TABLE_100
26 , a2 JTF_NUMBER_TABLE
27 );
28 procedure rosetta_table_copy_out_p3(t iem_mailitem_pub.class_count_tbl, a0 out nocopy JTF_NUMBER_TABLE
29 , a1 out nocopy JTF_VARCHAR2_TABLE_100
30 , a2 out nocopy JTF_NUMBER_TABLE
31 );
32
33 procedure rosetta_table_copy_in_p4(t out nocopy iem_mailitem_pub.t_number_table, a0 JTF_NUMBER_TABLE);
34 procedure rosetta_table_copy_out_p4(t iem_mailitem_pub.t_number_table, a0 out nocopy JTF_NUMBER_TABLE);
35
36 procedure rosetta_table_copy_in_p6(t out nocopy iem_mailitem_pub.acq_email_info_tbl, a0 JTF_NUMBER_TABLE
37 , a1 JTF_NUMBER_TABLE
38 , a2 JTF_VARCHAR2_TABLE_100
39 , a3 JTF_NUMBER_TABLE
40 , a4 JTF_NUMBER_TABLE
41 , a5 JTF_NUMBER_TABLE
42 , a6 JTF_VARCHAR2_TABLE_100
43 , a7 JTF_VARCHAR2_TABLE_200
44 , a8 JTF_VARCHAR2_TABLE_2000
45 , a9 JTF_VARCHAR2_TABLE_100
46 , a10 JTF_VARCHAR2_TABLE_100
47 , a11 JTF_VARCHAR2_TABLE_100
48 , a12 JTF_VARCHAR2_TABLE_100
49 , a13 JTF_NUMBER_TABLE
50 , a14 JTF_VARCHAR2_TABLE_100
51 , a15 JTF_VARCHAR2_TABLE_300
52 );
53 procedure rosetta_table_copy_out_p6(t iem_mailitem_pub.acq_email_info_tbl, a0 out nocopy JTF_NUMBER_TABLE
54 , a1 out nocopy JTF_NUMBER_TABLE
55 , a2 out nocopy JTF_VARCHAR2_TABLE_100
56 , a3 out nocopy JTF_NUMBER_TABLE
57 , a4 out nocopy JTF_NUMBER_TABLE
58 , a5 out nocopy JTF_NUMBER_TABLE
59 , a6 out nocopy JTF_VARCHAR2_TABLE_100
60 , a7 out nocopy JTF_VARCHAR2_TABLE_200
61 , a8 out nocopy JTF_VARCHAR2_TABLE_2000
62 , a9 out nocopy JTF_VARCHAR2_TABLE_100
63 , a10 out nocopy JTF_VARCHAR2_TABLE_100
64 , a11 out nocopy JTF_VARCHAR2_TABLE_100
65 , a12 out nocopy JTF_VARCHAR2_TABLE_100
66 , a13 out nocopy JTF_NUMBER_TABLE
67 , a14 out nocopy JTF_VARCHAR2_TABLE_100
68 , a15 out nocopy JTF_VARCHAR2_TABLE_300
69 );
70
71 procedure rosetta_table_copy_in_p8(t out nocopy iem_mailitem_pub.queue_email_info_tbl, a0 JTF_NUMBER_TABLE
72 , a1 JTF_NUMBER_TABLE
73 , a2 JTF_VARCHAR2_TABLE_100
74 , a3 JTF_NUMBER_TABLE
75 , a4 JTF_VARCHAR2_TABLE_200
76 , a5 JTF_VARCHAR2_TABLE_2000
77 , a6 JTF_VARCHAR2_TABLE_100
78 , a7 JTF_NUMBER_TABLE
79 , a8 JTF_VARCHAR2_TABLE_400
80 , a9 JTF_NUMBER_TABLE
81 , a10 JTF_NUMBER_TABLE
82 , a11 JTF_VARCHAR2_TABLE_100
83 , a12 JTF_VARCHAR2_TABLE_100
84 , a13 JTF_VARCHAR2_TABLE_100
85 );
86 procedure rosetta_table_copy_out_p8(t iem_mailitem_pub.queue_email_info_tbl, a0 out nocopy JTF_NUMBER_TABLE
87 , a1 out nocopy JTF_NUMBER_TABLE
88 , a2 out nocopy JTF_VARCHAR2_TABLE_100
89 , a3 out nocopy JTF_NUMBER_TABLE
90 , a4 out nocopy JTF_VARCHAR2_TABLE_200
91 , a5 out nocopy JTF_VARCHAR2_TABLE_2000
92 , a6 out nocopy JTF_VARCHAR2_TABLE_100
93 , a7 out nocopy JTF_NUMBER_TABLE
94 , a8 out nocopy JTF_VARCHAR2_TABLE_400
95 , a9 out nocopy JTF_NUMBER_TABLE
96 , a10 out nocopy JTF_NUMBER_TABLE
97 , a11 out nocopy JTF_VARCHAR2_TABLE_100
98 , a12 out nocopy JTF_VARCHAR2_TABLE_100
99 , a13 out nocopy JTF_VARCHAR2_TABLE_100
100 );
101
102 procedure rosetta_table_copy_in_p10(t out nocopy iem_mailitem_pub.keyvals_tbl_type, a0 JTF_VARCHAR2_TABLE_100
103 , a1 JTF_VARCHAR2_TABLE_300
104 , a2 JTF_VARCHAR2_TABLE_100
105 );
106 procedure rosetta_table_copy_out_p10(t iem_mailitem_pub.keyvals_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
107 , a1 out nocopy JTF_VARCHAR2_TABLE_300
108 , a2 out nocopy JTF_VARCHAR2_TABLE_100
109 );
110
111 procedure getmailitemcount(p_api_version_number NUMBER
112 , p_init_msg_list VARCHAR2
113 , p_commit VARCHAR2
114 , p_resource_id NUMBER
115 , p_tbl JTF_NUMBER_TABLE
116 , p5_a0 out nocopy JTF_NUMBER_TABLE
117 , p5_a1 out nocopy JTF_NUMBER_TABLE
118 , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
119 , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
120 , p5_a4 out nocopy JTF_NUMBER_TABLE
121 , p5_a5 out nocopy JTF_NUMBER_TABLE
122 , p5_a6 out nocopy JTF_NUMBER_TABLE
123 , p5_a7 out nocopy JTF_NUMBER_TABLE
124 , p5_a8 out nocopy JTF_NUMBER_TABLE
125 , x_return_status out nocopy VARCHAR2
126 , x_msg_count out nocopy NUMBER
127 , x_msg_data out nocopy VARCHAR2
128 );
129 procedure getmailitemcount(p_api_version_number NUMBER
130 , p_init_msg_list VARCHAR2
131 , p_commit VARCHAR2
132 , p_resource_id NUMBER
133 , p_tbl JTF_NUMBER_TABLE
134 , p_email_account_id NUMBER
135 , p6_a0 out nocopy JTF_NUMBER_TABLE
136 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
137 , p6_a2 out nocopy JTF_NUMBER_TABLE
138 , x_return_status out nocopy VARCHAR2
139 , x_msg_count out nocopy NUMBER
140 , x_msg_data out nocopy VARCHAR2
141 );
142 procedure getmailitemcount(p_api_version_number NUMBER
143 , p_init_msg_list VARCHAR2
144 , p_commit VARCHAR2
145 , p_email_account_id NUMBER
146 , p4_a0 out nocopy JTF_NUMBER_TABLE
147 , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
148 , p4_a2 out nocopy JTF_NUMBER_TABLE
149 , x_return_status out nocopy VARCHAR2
150 , x_msg_count out nocopy NUMBER
151 , x_msg_data out nocopy VARCHAR2
152 );
153 procedure getmailitemcount(p_api_version_number NUMBER
154 , p_init_msg_list VARCHAR2
155 , p_commit VARCHAR2
156 , p_resource_id NUMBER
157 , p_tbl JTF_NUMBER_TABLE
158 , p_email_account_id NUMBER
159 , p_classification_id NUMBER
160 , x_count out nocopy NUMBER
161 , x_return_status out nocopy VARCHAR2
162 , x_msg_count out nocopy NUMBER
163 , x_msg_data out nocopy VARCHAR2
164 );
165 procedure getmailitem(p_api_version_number NUMBER
166 , p_init_msg_list VARCHAR2
167 , p_commit VARCHAR2
168 , p_resource_id NUMBER
169 , p_tbl JTF_NUMBER_TABLE
170 , p_rt_classification NUMBER
171 , p_account_id NUMBER
172 , p7_a0 out nocopy NUMBER
173 , p7_a1 out nocopy NUMBER
174 , p7_a2 out nocopy NUMBER
175 , p7_a3 out nocopy NUMBER
176 , p7_a4 out nocopy NUMBER
177 , p7_a5 out nocopy VARCHAR2
178 , p7_a6 out nocopy DATE
179 , p7_a7 out nocopy NUMBER
180 , p7_a8 out nocopy NUMBER
181 , p7_a9 out nocopy NUMBER
182 , p7_a10 out nocopy NUMBER
183 , p7_a11 out nocopy NUMBER
184 , p7_a12 out nocopy NUMBER
185 , p7_a13 out nocopy VARCHAR2
186 , p7_a14 out nocopy VARCHAR2
187 , p7_a15 out nocopy VARCHAR2
188 , p7_a16 out nocopy VARCHAR2
189 , p7_a17 out nocopy VARCHAR2
190 , p7_a18 out nocopy NUMBER
191 , p7_a19 out nocopy NUMBER
192 , p7_a20 out nocopy VARCHAR2
193 , p7_a21 out nocopy VARCHAR2
194 , p7_a22 out nocopy NUMBER
195 , p7_a23 out nocopy NUMBER
196 , p7_a24 out nocopy DATE
197 , p7_a25 out nocopy NUMBER
198 , p7_a26 out nocopy DATE
199 , p7_a27 out nocopy NUMBER
200 , p7_a28 out nocopy VARCHAR2
201 , p7_a29 out nocopy VARCHAR2
202 , p7_a30 out nocopy VARCHAR2
203 , p7_a31 out nocopy VARCHAR2
204 , p7_a32 out nocopy VARCHAR2
205 , p7_a33 out nocopy VARCHAR2
206 , p7_a34 out nocopy VARCHAR2
207 , p7_a35 out nocopy VARCHAR2
208 , p7_a36 out nocopy VARCHAR2
209 , p7_a37 out nocopy VARCHAR2
210 , p7_a38 out nocopy VARCHAR2
211 , p7_a39 out nocopy VARCHAR2
212 , p7_a40 out nocopy VARCHAR2
213 , p7_a41 out nocopy VARCHAR2
214 , p7_a42 out nocopy VARCHAR2
215 , p7_a43 out nocopy NUMBER
216 , x_return_status out nocopy VARCHAR2
217 , x_msg_count out nocopy NUMBER
218 , x_msg_data out nocopy VARCHAR2
219 );
220 procedure getmailitem(p_api_version_number NUMBER
221 , p_init_msg_list VARCHAR2
222 , p_commit VARCHAR2
223 , p_resource_id NUMBER
224 , p_tbl JTF_NUMBER_TABLE
225 , p_rt_classification NUMBER
226 , p_account_id NUMBER
227 , p7_a0 out nocopy NUMBER
228 , p7_a1 out nocopy NUMBER
229 , p7_a2 out nocopy NUMBER
230 , p7_a3 out nocopy NUMBER
231 , p7_a4 out nocopy NUMBER
232 , p7_a5 out nocopy VARCHAR2
233 , p7_a6 out nocopy DATE
234 , p7_a7 out nocopy NUMBER
235 , p7_a8 out nocopy NUMBER
236 , p7_a9 out nocopy NUMBER
237 , p7_a10 out nocopy NUMBER
238 , p7_a11 out nocopy NUMBER
239 , p7_a12 out nocopy NUMBER
240 , p7_a13 out nocopy VARCHAR2
241 , p7_a14 out nocopy VARCHAR2
242 , p7_a15 out nocopy VARCHAR2
243 , p7_a16 out nocopy VARCHAR2
244 , p7_a17 out nocopy VARCHAR2
245 , p7_a18 out nocopy NUMBER
246 , p7_a19 out nocopy NUMBER
247 , p7_a20 out nocopy VARCHAR2
248 , p7_a21 out nocopy VARCHAR2
249 , p7_a22 out nocopy NUMBER
250 , p7_a23 out nocopy NUMBER
251 , p7_a24 out nocopy DATE
252 , p7_a25 out nocopy NUMBER
253 , p7_a26 out nocopy DATE
254 , p7_a27 out nocopy NUMBER
255 , p7_a28 out nocopy VARCHAR2
256 , p7_a29 out nocopy VARCHAR2
257 , p7_a30 out nocopy VARCHAR2
258 , p7_a31 out nocopy VARCHAR2
259 , p7_a32 out nocopy VARCHAR2
260 , p7_a33 out nocopy VARCHAR2
261 , p7_a34 out nocopy VARCHAR2
262 , p7_a35 out nocopy VARCHAR2
263 , p7_a36 out nocopy VARCHAR2
264 , p7_a37 out nocopy VARCHAR2
265 , p7_a38 out nocopy VARCHAR2
266 , p7_a39 out nocopy VARCHAR2
267 , p7_a40 out nocopy VARCHAR2
268 , p7_a41 out nocopy VARCHAR2
269 , p7_a42 out nocopy VARCHAR2
270 , p7_a43 out nocopy NUMBER
271 , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
272 , p8_a1 out nocopy JTF_VARCHAR2_TABLE_300
273 , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
274 , x_encrypted_id out nocopy VARCHAR2
275 , x_return_status out nocopy VARCHAR2
276 , x_msg_count out nocopy NUMBER
277 , x_msg_data out nocopy VARCHAR2
278 );
279 procedure getmailitem(p_api_version_number NUMBER
280 , p_init_msg_list VARCHAR2
281 , p_commit VARCHAR2
282 , p_resource_id NUMBER
283 , p_acct_rt_class_id NUMBER
284 , p5_a0 out nocopy NUMBER
285 , p5_a1 out nocopy NUMBER
286 , p5_a2 out nocopy NUMBER
287 , p5_a3 out nocopy NUMBER
288 , p5_a4 out nocopy NUMBER
289 , p5_a5 out nocopy VARCHAR2
290 , p5_a6 out nocopy DATE
291 , p5_a7 out nocopy NUMBER
292 , p5_a8 out nocopy NUMBER
293 , p5_a9 out nocopy NUMBER
294 , p5_a10 out nocopy NUMBER
295 , p5_a11 out nocopy NUMBER
296 , p5_a12 out nocopy NUMBER
297 , p5_a13 out nocopy VARCHAR2
298 , p5_a14 out nocopy VARCHAR2
299 , p5_a15 out nocopy VARCHAR2
300 , p5_a16 out nocopy VARCHAR2
301 , p5_a17 out nocopy VARCHAR2
302 , p5_a18 out nocopy NUMBER
303 , p5_a19 out nocopy NUMBER
304 , p5_a20 out nocopy VARCHAR2
305 , p5_a21 out nocopy VARCHAR2
306 , p5_a22 out nocopy NUMBER
307 , p5_a23 out nocopy NUMBER
308 , p5_a24 out nocopy DATE
309 , p5_a25 out nocopy NUMBER
310 , p5_a26 out nocopy DATE
311 , p5_a27 out nocopy NUMBER
312 , p5_a28 out nocopy VARCHAR2
313 , p5_a29 out nocopy VARCHAR2
314 , p5_a30 out nocopy VARCHAR2
315 , p5_a31 out nocopy VARCHAR2
316 , p5_a32 out nocopy VARCHAR2
317 , p5_a33 out nocopy VARCHAR2
318 , p5_a34 out nocopy VARCHAR2
319 , p5_a35 out nocopy VARCHAR2
320 , p5_a36 out nocopy VARCHAR2
321 , p5_a37 out nocopy VARCHAR2
322 , p5_a38 out nocopy VARCHAR2
323 , p5_a39 out nocopy VARCHAR2
324 , p5_a40 out nocopy VARCHAR2
325 , p5_a41 out nocopy VARCHAR2
326 , p5_a42 out nocopy VARCHAR2
327 , p5_a43 out nocopy NUMBER
328 , x_return_status out nocopy VARCHAR2
329 , x_msg_count out nocopy NUMBER
330 , x_msg_data out nocopy VARCHAR2
331 );
332 procedure getgroupdetails(p_api_version_number NUMBER
333 , p_init_msg_list VARCHAR2
334 , p_commit VARCHAR2
335 , p_resource_id NUMBER
336 , x_tbl out nocopy JTF_NUMBER_TABLE
337 , x_return_status out nocopy VARCHAR2
338 , x_msg_count out nocopy NUMBER
339 , x_msg_data out nocopy VARCHAR2
340 );
341 procedure updatemailitem(p_api_version_number NUMBER
342 , p_init_msg_list VARCHAR2
343 , p_commit VARCHAR2
344 , p3_a0 NUMBER
345 , p3_a1 NUMBER
346 , p3_a2 NUMBER
347 , p3_a3 NUMBER
348 , p3_a4 NUMBER
349 , p3_a5 VARCHAR2
350 , p3_a6 DATE
351 , p3_a7 NUMBER
352 , p3_a8 NUMBER
353 , p3_a9 NUMBER
354 , p3_a10 NUMBER
355 , p3_a11 NUMBER
356 , p3_a12 NUMBER
357 , p3_a13 VARCHAR2
358 , p3_a14 VARCHAR2
359 , p3_a15 VARCHAR2
360 , p3_a16 VARCHAR2
361 , p3_a17 VARCHAR2
362 , p3_a18 NUMBER
363 , p3_a19 NUMBER
364 , p3_a20 VARCHAR2
365 , p3_a21 VARCHAR2
366 , p3_a22 NUMBER
367 , p3_a23 NUMBER
368 , p3_a24 DATE
369 , p3_a25 NUMBER
370 , p3_a26 DATE
371 , p3_a27 NUMBER
372 , p3_a28 VARCHAR2
373 , p3_a29 VARCHAR2
374 , p3_a30 VARCHAR2
375 , p3_a31 VARCHAR2
376 , p3_a32 VARCHAR2
377 , p3_a33 VARCHAR2
378 , p3_a34 VARCHAR2
379 , p3_a35 VARCHAR2
380 , p3_a36 VARCHAR2
381 , p3_a37 VARCHAR2
382 , p3_a38 VARCHAR2
383 , p3_a39 VARCHAR2
384 , p3_a40 VARCHAR2
385 , p3_a41 VARCHAR2
386 , p3_a42 VARCHAR2
387 , p3_a43 NUMBER
388 , x_return_status out nocopy VARCHAR2
389 , x_msg_count out nocopy NUMBER
390 , x_msg_data out nocopy VARCHAR2
391 );
392 procedure getmailiteminfo(p_api_version_number NUMBER
393 , p_init_msg_list VARCHAR2
394 , p_commit VARCHAR2
395 , p_message_id NUMBER
396 , p_account_id NUMBER
397 , p_agent_id NUMBER
398 , p6_a0 out nocopy NUMBER
399 , p6_a1 out nocopy NUMBER
400 , p6_a2 out nocopy NUMBER
401 , p6_a3 out nocopy NUMBER
402 , p6_a4 out nocopy NUMBER
403 , p6_a5 out nocopy VARCHAR2
404 , p6_a6 out nocopy DATE
405 , p6_a7 out nocopy NUMBER
406 , p6_a8 out nocopy NUMBER
407 , p6_a9 out nocopy NUMBER
408 , p6_a10 out nocopy NUMBER
409 , p6_a11 out nocopy NUMBER
410 , p6_a12 out nocopy NUMBER
411 , p6_a13 out nocopy VARCHAR2
412 , p6_a14 out nocopy VARCHAR2
413 , p6_a15 out nocopy VARCHAR2
414 , p6_a16 out nocopy VARCHAR2
415 , p6_a17 out nocopy VARCHAR2
416 , p6_a18 out nocopy NUMBER
417 , p6_a19 out nocopy NUMBER
418 , p6_a20 out nocopy VARCHAR2
419 , p6_a21 out nocopy VARCHAR2
420 , p6_a22 out nocopy NUMBER
421 , p6_a23 out nocopy NUMBER
422 , p6_a24 out nocopy DATE
423 , p6_a25 out nocopy NUMBER
424 , p6_a26 out nocopy DATE
425 , p6_a27 out nocopy NUMBER
426 , p6_a28 out nocopy VARCHAR2
427 , p6_a29 out nocopy VARCHAR2
428 , p6_a30 out nocopy VARCHAR2
429 , p6_a31 out nocopy VARCHAR2
430 , p6_a32 out nocopy VARCHAR2
431 , p6_a33 out nocopy VARCHAR2
432 , p6_a34 out nocopy VARCHAR2
433 , p6_a35 out nocopy VARCHAR2
434 , p6_a36 out nocopy VARCHAR2
435 , p6_a37 out nocopy VARCHAR2
436 , p6_a38 out nocopy VARCHAR2
437 , p6_a39 out nocopy VARCHAR2
438 , p6_a40 out nocopy VARCHAR2
439 , p6_a41 out nocopy VARCHAR2
440 , p6_a42 out nocopy VARCHAR2
441 , p6_a43 out nocopy NUMBER
442 , x_return_status out nocopy VARCHAR2
443 , x_msg_count out nocopy NUMBER
444 , x_msg_data out nocopy VARCHAR2
445 );
446 procedure getemailheaders(p_api_version_number NUMBER
447 , p_init_msg_list VARCHAR2
448 , p_commit VARCHAR2
449 , p_resource_id NUMBER
453 , p_sort_by VARCHAR2
450 , p_email_account_id NUMBER
451 , p_display_size NUMBER
452 , p_page_count NUMBER
454 , p_sort_order NUMBER
455 , x_total_message out nocopy NUMBER
456 , p10_a0 out nocopy JTF_NUMBER_TABLE
457 , p10_a1 out nocopy JTF_NUMBER_TABLE
458 , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
459 , p10_a3 out nocopy JTF_NUMBER_TABLE
460 , p10_a4 out nocopy JTF_NUMBER_TABLE
461 , p10_a5 out nocopy JTF_NUMBER_TABLE
462 , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
463 , p10_a7 out nocopy JTF_VARCHAR2_TABLE_200
464 , p10_a8 out nocopy JTF_VARCHAR2_TABLE_2000
465 , p10_a9 out nocopy JTF_VARCHAR2_TABLE_100
466 , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
467 , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
468 , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
469 , p10_a13 out nocopy JTF_NUMBER_TABLE
470 , p10_a14 out nocopy JTF_VARCHAR2_TABLE_100
471 , p10_a15 out nocopy JTF_VARCHAR2_TABLE_300
472 , x_return_status out nocopy VARCHAR2
473 , x_msg_count out nocopy NUMBER
474 , x_msg_data out nocopy VARCHAR2
475 );
476 procedure getunreademailheaders(p_api_version_number NUMBER
477 , p_init_msg_list VARCHAR2
478 , p_commit VARCHAR2
479 , p_resource_id NUMBER
480 , p_email_account_id NUMBER
481 , p_display_size NUMBER
482 , p_page_count NUMBER
483 , p_sort_by VARCHAR2
484 , p_sort_order NUMBER
485 , x_total_message out nocopy NUMBER
486 , p10_a0 out nocopy JTF_NUMBER_TABLE
487 , p10_a1 out nocopy JTF_NUMBER_TABLE
488 , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
489 , p10_a3 out nocopy JTF_NUMBER_TABLE
490 , p10_a4 out nocopy JTF_VARCHAR2_TABLE_200
491 , p10_a5 out nocopy JTF_VARCHAR2_TABLE_2000
492 , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
493 , p10_a7 out nocopy JTF_NUMBER_TABLE
494 , p10_a8 out nocopy JTF_VARCHAR2_TABLE_400
495 , p10_a9 out nocopy JTF_NUMBER_TABLE
496 , p10_a10 out nocopy JTF_NUMBER_TABLE
497 , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
498 , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
499 , p10_a13 out nocopy JTF_VARCHAR2_TABLE_100
500 , x_return_status out nocopy VARCHAR2
501 , x_msg_count out nocopy NUMBER
502 , x_msg_data out nocopy VARCHAR2
503 );
504 procedure getqueueitemdata(p_api_version_number NUMBER
505 , p_init_msg_list VARCHAR2
506 , p_commit VARCHAR2
507 , p_message_id NUMBER
508 , p_from_agent_id NUMBER
509 , p_to_agent_id NUMBER
510 , p_mail_item_status VARCHAR2
511 , p7_a0 out nocopy NUMBER
512 , p7_a1 out nocopy NUMBER
513 , p7_a2 out nocopy NUMBER
514 , p7_a3 out nocopy NUMBER
515 , p7_a4 out nocopy NUMBER
516 , p7_a5 out nocopy VARCHAR2
517 , p7_a6 out nocopy DATE
518 , p7_a7 out nocopy NUMBER
519 , p7_a8 out nocopy NUMBER
520 , p7_a9 out nocopy NUMBER
521 , p7_a10 out nocopy NUMBER
522 , p7_a11 out nocopy NUMBER
523 , p7_a12 out nocopy NUMBER
524 , p7_a13 out nocopy VARCHAR2
525 , p7_a14 out nocopy VARCHAR2
526 , p7_a15 out nocopy VARCHAR2
527 , p7_a16 out nocopy VARCHAR2
528 , p7_a17 out nocopy VARCHAR2
529 , p7_a18 out nocopy NUMBER
530 , p7_a19 out nocopy NUMBER
531 , p7_a20 out nocopy VARCHAR2
532 , p7_a21 out nocopy VARCHAR2
533 , p7_a22 out nocopy NUMBER
534 , p7_a23 out nocopy NUMBER
535 , p7_a24 out nocopy DATE
536 , p7_a25 out nocopy NUMBER
537 , p7_a26 out nocopy DATE
538 , p7_a27 out nocopy NUMBER
539 , p7_a28 out nocopy VARCHAR2
540 , p7_a29 out nocopy VARCHAR2
541 , p7_a30 out nocopy VARCHAR2
542 , p7_a31 out nocopy VARCHAR2
543 , p7_a32 out nocopy VARCHAR2
544 , p7_a33 out nocopy VARCHAR2
545 , p7_a34 out nocopy VARCHAR2
546 , p7_a35 out nocopy VARCHAR2
547 , p7_a36 out nocopy VARCHAR2
548 , p7_a37 out nocopy VARCHAR2
549 , p7_a38 out nocopy VARCHAR2
550 , p7_a39 out nocopy VARCHAR2
551 , p7_a40 out nocopy VARCHAR2
552 , p7_a41 out nocopy VARCHAR2
553 , p7_a42 out nocopy VARCHAR2
554 , p7_a43 out nocopy NUMBER
555 , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
556 , p8_a1 out nocopy JTF_VARCHAR2_TABLE_300
557 , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
558 , x_encrypted_id out nocopy VARCHAR2
559 , x_return_status out nocopy VARCHAR2
560 , x_msg_count out nocopy NUMBER
561 , x_msg_data out nocopy VARCHAR2
562 );
563 end iem_mailitem_pub_w;