APPS.IEM_MAILITEM_PUB_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy iem_mailitem_pub.email_count_tbl, a0 JTF_NUMBER_TABLE

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

Line 4: , a1 JTF_NUMBER_TABLE

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

Line 7: , a4 JTF_NUMBER_TABLE

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

Line 8: , a5 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: );

Line 9: , a6 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

Line 10: , a7 JTF_NUMBER_TABLE

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

Line 11: , a8 JTF_NUMBER_TABLE

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

Line 13: procedure rosetta_table_copy_out_p1(t iem_mailitem_pub.email_count_tbl, a0 out nocopy 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

Line 14: , a1 out nocopy 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

Line 17: , a4 out nocopy JTF_NUMBER_TABLE

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

Line 18: , a5 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: );

Line 19: , a6 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:

Line 20: , a7 out nocopy JTF_NUMBER_TABLE

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

Line 21: , a8 out nocopy JTF_NUMBER_TABLE

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

Line 24: procedure rosetta_table_copy_in_p3(t out nocopy iem_mailitem_pub.class_count_tbl, a0 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

Line 26: , a2 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

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

Line 30: , a2 out nocopy JTF_NUMBER_TABLE

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);

Line 33: procedure rosetta_table_copy_in_p4(t out nocopy iem_mailitem_pub.t_number_table, a0 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

Line 34: procedure rosetta_table_copy_out_p4(t iem_mailitem_pub.t_number_table, a0 out nocopy 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

Line 36: procedure rosetta_table_copy_in_p6(t out nocopy iem_mailitem_pub.acq_email_info_tbl, a0 JTF_NUMBER_TABLE

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

Line 37: , a1 JTF_NUMBER_TABLE

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

Line 39: , a3 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

Line 40: , a4 JTF_NUMBER_TABLE

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

Line 41: , a5 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

Line 49: , a13 JTF_NUMBER_TABLE

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

Line 53: procedure rosetta_table_copy_out_p6(t iem_mailitem_pub.acq_email_info_tbl, a0 out nocopy 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

Line 54: , a1 out nocopy 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

Line 56: , a3 out nocopy JTF_NUMBER_TABLE

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

Line 57: , a4 out nocopy JTF_NUMBER_TABLE

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

Line 58: , a5 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

Line 66: , a13 out nocopy JTF_NUMBER_TABLE

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:

Line 71: procedure rosetta_table_copy_in_p8(t out nocopy iem_mailitem_pub.queue_email_info_tbl, a0 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

Line 72: , a1 JTF_NUMBER_TABLE

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

Line 74: , a3 JTF_NUMBER_TABLE

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

Line 78: , a7 JTF_NUMBER_TABLE

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

Line 80: , a9 JTF_NUMBER_TABLE

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

Line 81: , a10 JTF_NUMBER_TABLE

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

Line 86: procedure rosetta_table_copy_out_p8(t iem_mailitem_pub.queue_email_info_tbl, a0 out nocopy 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

Line 87: , a1 out nocopy JTF_NUMBER_TABLE

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

Line 89: , a3 out nocopy JTF_NUMBER_TABLE

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

Line 93: , a7 out nocopy JTF_NUMBER_TABLE

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

Line 95: , a9 out nocopy JTF_NUMBER_TABLE

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

Line 96: , a10 out nocopy JTF_NUMBER_TABLE

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

Line 115: , p_tbl JTF_NUMBER_TABLE

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

Line 116: , p5_a0 out nocopy JTF_NUMBER_TABLE

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

Line 117: , p5_a1 out nocopy JTF_NUMBER_TABLE

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

Line 120: , p5_a4 out nocopy 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

Line 121: , p5_a5 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

Line 122: , p5_a6 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

Line 123: , p5_a7 out nocopy JTF_NUMBER_TABLE

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

Line 124: , p5_a8 out nocopy JTF_NUMBER_TABLE

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

Line 133: , p_tbl JTF_NUMBER_TABLE

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

Line 135: , p6_a0 out nocopy JTF_NUMBER_TABLE

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

Line 137: , p6_a2 out nocopy JTF_NUMBER_TABLE

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

Line 146: , p4_a0 out nocopy JTF_NUMBER_TABLE

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

Line 148: , p4_a2 out nocopy JTF_NUMBER_TABLE

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

Line 157: , p_tbl JTF_NUMBER_TABLE

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

Line 169: , p_tbl JTF_NUMBER_TABLE

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

Line 224: , p_tbl JTF_NUMBER_TABLE

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

Line 336: , x_tbl out nocopy JTF_NUMBER_TABLE

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

Line 456: , p10_a0 out nocopy JTF_NUMBER_TABLE

452: , p_page_count NUMBER
453: , p_sort_by VARCHAR2
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

Line 457: , p10_a1 out nocopy JTF_NUMBER_TABLE

453: , p_sort_by VARCHAR2
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

Line 459: , p10_a3 out nocopy JTF_NUMBER_TABLE

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

Line 460: , p10_a4 out nocopy JTF_NUMBER_TABLE

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

Line 461: , p10_a5 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

Line 469: , p10_a13 out nocopy JTF_NUMBER_TABLE

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

Line 486: , p10_a0 out nocopy JTF_NUMBER_TABLE

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

Line 487: , p10_a1 out nocopy JTF_NUMBER_TABLE

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

Line 489: , p10_a3 out nocopy JTF_NUMBER_TABLE

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

Line 493: , p10_a7 out nocopy JTF_NUMBER_TABLE

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

Line 495: , p10_a9 out nocopy JTF_NUMBER_TABLE

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

Line 496: , p10_a10 out nocopy JTF_NUMBER_TABLE

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