1: package iem_mailitem_pub_w as
2: /* $Header: IEMPMICS.pls 120.2 2006/05/16 08:52 txliu noship $ */
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
1: package iem_mailitem_pub_w as
2: /* $Header: IEMPMICS.pls 120.2 2006/05/16 08:52 txliu noship $ */
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
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
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
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:
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
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
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
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
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.keyvals_tbl_type, a0 JTF_VARCHAR2_TABLE_100
72: , a1 JTF_VARCHAR2_TABLE_300
73: , a2 JTF_VARCHAR2_TABLE_100
74: );
75: procedure rosetta_table_copy_out_p8(t iem_mailitem_pub.keyvals_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
71: procedure rosetta_table_copy_in_p8(t out nocopy iem_mailitem_pub.keyvals_tbl_type, a0 JTF_VARCHAR2_TABLE_100
72: , a1 JTF_VARCHAR2_TABLE_300
73: , a2 JTF_VARCHAR2_TABLE_100
74: );
75: procedure rosetta_table_copy_out_p8(t iem_mailitem_pub.keyvals_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
76: , a1 out nocopy JTF_VARCHAR2_TABLE_300
77: , a2 out nocopy JTF_VARCHAR2_TABLE_100
78: );
79:
500: , x_return_status out nocopy VARCHAR2
501: , x_msg_count out nocopy NUMBER
502: , x_msg_data out nocopy VARCHAR2
503: );
504: end iem_mailitem_pub_w;