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

Line 4: , a1 JTF_NUMBER_TABLE

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
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_300

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_300
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_300

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_300
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 84: , p_tbl JTF_NUMBER_TABLE

80: procedure getmailitemcount(p_api_version_number NUMBER
81: , p_init_msg_list VARCHAR2
82: , p_commit VARCHAR2
83: , p_resource_id NUMBER
84: , p_tbl JTF_NUMBER_TABLE
85: , p5_a0 out nocopy JTF_NUMBER_TABLE
86: , p5_a1 out nocopy JTF_NUMBER_TABLE
87: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
88: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 85: , p5_a0 out nocopy JTF_NUMBER_TABLE

81: , p_init_msg_list VARCHAR2
82: , p_commit VARCHAR2
83: , p_resource_id NUMBER
84: , p_tbl JTF_NUMBER_TABLE
85: , p5_a0 out nocopy JTF_NUMBER_TABLE
86: , p5_a1 out nocopy JTF_NUMBER_TABLE
87: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
88: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
89: , p5_a4 out nocopy JTF_NUMBER_TABLE

Line 86: , p5_a1 out nocopy JTF_NUMBER_TABLE

82: , p_commit VARCHAR2
83: , p_resource_id NUMBER
84: , p_tbl JTF_NUMBER_TABLE
85: , p5_a0 out nocopy JTF_NUMBER_TABLE
86: , p5_a1 out nocopy JTF_NUMBER_TABLE
87: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
88: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
89: , p5_a4 out nocopy JTF_NUMBER_TABLE
90: , p5_a5 out nocopy JTF_NUMBER_TABLE

Line 89: , p5_a4 out nocopy JTF_NUMBER_TABLE

85: , p5_a0 out nocopy JTF_NUMBER_TABLE
86: , p5_a1 out nocopy JTF_NUMBER_TABLE
87: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
88: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
89: , p5_a4 out nocopy JTF_NUMBER_TABLE
90: , p5_a5 out nocopy JTF_NUMBER_TABLE
91: , p5_a6 out nocopy JTF_NUMBER_TABLE
92: , p5_a7 out nocopy JTF_NUMBER_TABLE
93: , p5_a8 out nocopy JTF_NUMBER_TABLE

Line 90: , p5_a5 out nocopy JTF_NUMBER_TABLE

86: , p5_a1 out nocopy JTF_NUMBER_TABLE
87: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
88: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
89: , p5_a4 out nocopy JTF_NUMBER_TABLE
90: , p5_a5 out nocopy JTF_NUMBER_TABLE
91: , p5_a6 out nocopy JTF_NUMBER_TABLE
92: , p5_a7 out nocopy JTF_NUMBER_TABLE
93: , p5_a8 out nocopy JTF_NUMBER_TABLE
94: , x_return_status out nocopy VARCHAR2

Line 91: , p5_a6 out nocopy JTF_NUMBER_TABLE

87: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
88: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
89: , p5_a4 out nocopy JTF_NUMBER_TABLE
90: , p5_a5 out nocopy JTF_NUMBER_TABLE
91: , p5_a6 out nocopy JTF_NUMBER_TABLE
92: , p5_a7 out nocopy JTF_NUMBER_TABLE
93: , p5_a8 out nocopy JTF_NUMBER_TABLE
94: , x_return_status out nocopy VARCHAR2
95: , x_msg_count out nocopy NUMBER

Line 92: , p5_a7 out nocopy JTF_NUMBER_TABLE

88: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
89: , p5_a4 out nocopy JTF_NUMBER_TABLE
90: , p5_a5 out nocopy JTF_NUMBER_TABLE
91: , p5_a6 out nocopy JTF_NUMBER_TABLE
92: , p5_a7 out nocopy JTF_NUMBER_TABLE
93: , p5_a8 out nocopy JTF_NUMBER_TABLE
94: , x_return_status out nocopy VARCHAR2
95: , x_msg_count out nocopy NUMBER
96: , x_msg_data out nocopy VARCHAR2

Line 93: , p5_a8 out nocopy JTF_NUMBER_TABLE

89: , p5_a4 out nocopy JTF_NUMBER_TABLE
90: , p5_a5 out nocopy JTF_NUMBER_TABLE
91: , p5_a6 out nocopy JTF_NUMBER_TABLE
92: , p5_a7 out nocopy JTF_NUMBER_TABLE
93: , p5_a8 out nocopy JTF_NUMBER_TABLE
94: , x_return_status out nocopy VARCHAR2
95: , x_msg_count out nocopy NUMBER
96: , x_msg_data out nocopy VARCHAR2
97: );

Line 102: , p_tbl JTF_NUMBER_TABLE

98: procedure getmailitemcount(p_api_version_number NUMBER
99: , p_init_msg_list VARCHAR2
100: , p_commit VARCHAR2
101: , p_resource_id NUMBER
102: , p_tbl JTF_NUMBER_TABLE
103: , p_email_account_id NUMBER
104: , p6_a0 out nocopy JTF_NUMBER_TABLE
105: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
106: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 104: , p6_a0 out nocopy JTF_NUMBER_TABLE

100: , p_commit VARCHAR2
101: , p_resource_id NUMBER
102: , p_tbl JTF_NUMBER_TABLE
103: , p_email_account_id NUMBER
104: , p6_a0 out nocopy JTF_NUMBER_TABLE
105: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
106: , p6_a2 out nocopy JTF_NUMBER_TABLE
107: , x_return_status out nocopy VARCHAR2
108: , x_msg_count out nocopy NUMBER

Line 106: , p6_a2 out nocopy JTF_NUMBER_TABLE

102: , p_tbl JTF_NUMBER_TABLE
103: , p_email_account_id NUMBER
104: , p6_a0 out nocopy JTF_NUMBER_TABLE
105: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
106: , p6_a2 out nocopy JTF_NUMBER_TABLE
107: , x_return_status out nocopy VARCHAR2
108: , x_msg_count out nocopy NUMBER
109: , x_msg_data out nocopy VARCHAR2
110: );

Line 115: , p4_a0 out nocopy JTF_NUMBER_TABLE

111: procedure getmailitemcount(p_api_version_number NUMBER
112: , p_init_msg_list VARCHAR2
113: , p_commit VARCHAR2
114: , p_email_account_id NUMBER
115: , p4_a0 out nocopy JTF_NUMBER_TABLE
116: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
117: , p4_a2 out nocopy JTF_NUMBER_TABLE
118: , x_return_status out nocopy VARCHAR2
119: , x_msg_count out nocopy NUMBER

Line 117: , p4_a2 out nocopy JTF_NUMBER_TABLE

113: , p_commit VARCHAR2
114: , p_email_account_id NUMBER
115: , p4_a0 out nocopy JTF_NUMBER_TABLE
116: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
117: , p4_a2 out nocopy JTF_NUMBER_TABLE
118: , x_return_status out nocopy VARCHAR2
119: , x_msg_count out nocopy NUMBER
120: , x_msg_data out nocopy VARCHAR2
121: );

Line 126: , p_tbl JTF_NUMBER_TABLE

122: procedure getmailitemcount(p_api_version_number NUMBER
123: , p_init_msg_list VARCHAR2
124: , p_commit VARCHAR2
125: , p_resource_id NUMBER
126: , p_tbl JTF_NUMBER_TABLE
127: , p_email_account_id NUMBER
128: , p_classification_id NUMBER
129: , x_count out nocopy NUMBER
130: , x_return_status out nocopy VARCHAR2

Line 138: , p_tbl JTF_NUMBER_TABLE

134: procedure getmailitem(p_api_version_number NUMBER
135: , p_init_msg_list VARCHAR2
136: , p_commit VARCHAR2
137: , p_resource_id NUMBER
138: , p_tbl JTF_NUMBER_TABLE
139: , p_rt_classification NUMBER
140: , p_account_id NUMBER
141: , p7_a0 out nocopy NUMBER
142: , p7_a1 out nocopy NUMBER

Line 193: , p_tbl JTF_NUMBER_TABLE

189: procedure getmailitem(p_api_version_number NUMBER
190: , p_init_msg_list VARCHAR2
191: , p_commit VARCHAR2
192: , p_resource_id NUMBER
193: , p_tbl JTF_NUMBER_TABLE
194: , p_rt_classification NUMBER
195: , p_account_id NUMBER
196: , p7_a0 out nocopy NUMBER
197: , p7_a1 out nocopy NUMBER

Line 305: , x_tbl out nocopy JTF_NUMBER_TABLE

301: procedure getgroupdetails(p_api_version_number NUMBER
302: , p_init_msg_list VARCHAR2
303: , p_commit VARCHAR2
304: , p_resource_id NUMBER
305: , x_tbl out nocopy JTF_NUMBER_TABLE
306: , x_return_status out nocopy VARCHAR2
307: , x_msg_count out nocopy NUMBER
308: , x_msg_data out nocopy VARCHAR2
309: );

Line 425: , p10_a0 out nocopy JTF_NUMBER_TABLE

421: , p_page_count NUMBER
422: , p_sort_by VARCHAR2
423: , p_sort_order NUMBER
424: , x_total_message out nocopy NUMBER
425: , p10_a0 out nocopy JTF_NUMBER_TABLE
426: , p10_a1 out nocopy JTF_NUMBER_TABLE
427: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
428: , p10_a3 out nocopy JTF_NUMBER_TABLE
429: , p10_a4 out nocopy JTF_NUMBER_TABLE

Line 426: , p10_a1 out nocopy JTF_NUMBER_TABLE

422: , p_sort_by VARCHAR2
423: , p_sort_order NUMBER
424: , x_total_message out nocopy NUMBER
425: , p10_a0 out nocopy JTF_NUMBER_TABLE
426: , p10_a1 out nocopy JTF_NUMBER_TABLE
427: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
428: , p10_a3 out nocopy JTF_NUMBER_TABLE
429: , p10_a4 out nocopy JTF_NUMBER_TABLE
430: , p10_a5 out nocopy JTF_NUMBER_TABLE

Line 428: , p10_a3 out nocopy JTF_NUMBER_TABLE

424: , x_total_message out nocopy NUMBER
425: , p10_a0 out nocopy JTF_NUMBER_TABLE
426: , p10_a1 out nocopy JTF_NUMBER_TABLE
427: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
428: , p10_a3 out nocopy JTF_NUMBER_TABLE
429: , p10_a4 out nocopy JTF_NUMBER_TABLE
430: , p10_a5 out nocopy JTF_NUMBER_TABLE
431: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
432: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 429: , p10_a4 out nocopy JTF_NUMBER_TABLE

425: , p10_a0 out nocopy JTF_NUMBER_TABLE
426: , p10_a1 out nocopy JTF_NUMBER_TABLE
427: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
428: , p10_a3 out nocopy JTF_NUMBER_TABLE
429: , p10_a4 out nocopy JTF_NUMBER_TABLE
430: , p10_a5 out nocopy JTF_NUMBER_TABLE
431: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
432: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_200
433: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_300

Line 430: , p10_a5 out nocopy JTF_NUMBER_TABLE

426: , p10_a1 out nocopy JTF_NUMBER_TABLE
427: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
428: , p10_a3 out nocopy JTF_NUMBER_TABLE
429: , p10_a4 out nocopy JTF_NUMBER_TABLE
430: , p10_a5 out nocopy JTF_NUMBER_TABLE
431: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
432: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_200
433: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_300
434: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 438: , p10_a13 out nocopy JTF_NUMBER_TABLE

434: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_100
435: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
436: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
437: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
438: , p10_a13 out nocopy JTF_NUMBER_TABLE
439: , p10_a14 out nocopy JTF_VARCHAR2_TABLE_100
440: , p10_a15 out nocopy JTF_VARCHAR2_TABLE_300
441: , x_return_status out nocopy VARCHAR2
442: , x_msg_count out nocopy NUMBER