APPS.IEM_EMAILACCOUNT_PUB_W dependencies on JTF_NUMBER_TABLE

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: IEMVEMAS.pls 120.3 2006/05/16 08:41 txliu ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy iem_emailaccount_pub.emacnt_tbl_type, a0 JTF_VARCHAR2_TABLE_300
4: , a1 JTF_VARCHAR2_TABLE_300
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_NUMBER_TABLE
7: );
8: procedure rosetta_table_copy_out_p1(t iem_emailaccount_pub.emacnt_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
9: , a1 out nocopy JTF_VARCHAR2_TABLE_300
10: , a2 out nocopy JTF_VARCHAR2_TABLE_200

Line 11: , a3 out nocopy JTF_NUMBER_TABLE

7: );
8: procedure rosetta_table_copy_out_p1(t iem_emailaccount_pub.emacnt_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
9: , a1 out nocopy JTF_VARCHAR2_TABLE_300
10: , a2 out nocopy JTF_VARCHAR2_TABLE_200
11: , a3 out nocopy JTF_NUMBER_TABLE
12: );
13:
14: procedure rosetta_table_copy_in_p4(t out nocopy iem_emailaccount_pub.msg_header_table, a0 JTF_NUMBER_TABLE
15: , a1 JTF_VARCHAR2_TABLE_300

Line 14: procedure rosetta_table_copy_in_p4(t out nocopy iem_emailaccount_pub.msg_header_table, a0 JTF_NUMBER_TABLE

10: , a2 out nocopy JTF_VARCHAR2_TABLE_200
11: , a3 out nocopy JTF_NUMBER_TABLE
12: );
13:
14: procedure rosetta_table_copy_in_p4(t out nocopy iem_emailaccount_pub.msg_header_table, a0 JTF_NUMBER_TABLE
15: , a1 JTF_VARCHAR2_TABLE_300
16: , a2 JTF_VARCHAR2_TABLE_200
17: , a3 JTF_DATE_TABLE
18: , a4 JTF_VARCHAR2_TABLE_100

Line 24: , a10 JTF_NUMBER_TABLE

20: , a6 JTF_VARCHAR2_TABLE_100
21: , a7 JTF_VARCHAR2_TABLE_300
22: , a8 JTF_VARCHAR2_TABLE_300
23: , a9 JTF_VARCHAR2_TABLE_300
24: , a10 JTF_NUMBER_TABLE
25: , a11 JTF_VARCHAR2_TABLE_300
26: );
27: procedure rosetta_table_copy_out_p4(t iem_emailaccount_pub.msg_header_table, a0 out nocopy JTF_NUMBER_TABLE
28: , a1 out nocopy JTF_VARCHAR2_TABLE_300

Line 27: procedure rosetta_table_copy_out_p4(t iem_emailaccount_pub.msg_header_table, a0 out nocopy JTF_NUMBER_TABLE

23: , a9 JTF_VARCHAR2_TABLE_300
24: , a10 JTF_NUMBER_TABLE
25: , a11 JTF_VARCHAR2_TABLE_300
26: );
27: procedure rosetta_table_copy_out_p4(t iem_emailaccount_pub.msg_header_table, a0 out nocopy JTF_NUMBER_TABLE
28: , a1 out nocopy JTF_VARCHAR2_TABLE_300
29: , a2 out nocopy JTF_VARCHAR2_TABLE_200
30: , a3 out nocopy JTF_DATE_TABLE
31: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 37: , a10 out nocopy JTF_NUMBER_TABLE

33: , a6 out nocopy JTF_VARCHAR2_TABLE_100
34: , a7 out nocopy JTF_VARCHAR2_TABLE_300
35: , a8 out nocopy JTF_VARCHAR2_TABLE_300
36: , a9 out nocopy JTF_VARCHAR2_TABLE_300
37: , a10 out nocopy JTF_NUMBER_TABLE
38: , a11 out nocopy JTF_VARCHAR2_TABLE_300
39: );
40:
41: procedure rosetta_table_copy_in_p6(t out nocopy iem_emailaccount_pub.account_info_table, a0 JTF_VARCHAR2_TABLE_100

Line 44: , a3 JTF_NUMBER_TABLE

40:
41: procedure rosetta_table_copy_in_p6(t out nocopy iem_emailaccount_pub.account_info_table, a0 JTF_VARCHAR2_TABLE_100
42: , a1 JTF_VARCHAR2_TABLE_100
43: , a2 JTF_VARCHAR2_TABLE_200
44: , a3 JTF_NUMBER_TABLE
45: , a4 JTF_NUMBER_TABLE
46: );
47: procedure rosetta_table_copy_out_p6(t iem_emailaccount_pub.account_info_table, a0 out nocopy JTF_VARCHAR2_TABLE_100
48: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 45: , a4 JTF_NUMBER_TABLE

41: procedure rosetta_table_copy_in_p6(t out nocopy iem_emailaccount_pub.account_info_table, a0 JTF_VARCHAR2_TABLE_100
42: , a1 JTF_VARCHAR2_TABLE_100
43: , a2 JTF_VARCHAR2_TABLE_200
44: , a3 JTF_NUMBER_TABLE
45: , a4 JTF_NUMBER_TABLE
46: );
47: procedure rosetta_table_copy_out_p6(t iem_emailaccount_pub.account_info_table, a0 out nocopy JTF_VARCHAR2_TABLE_100
48: , a1 out nocopy JTF_VARCHAR2_TABLE_100
49: , a2 out nocopy JTF_VARCHAR2_TABLE_200

Line 50: , a3 out nocopy JTF_NUMBER_TABLE

46: );
47: procedure rosetta_table_copy_out_p6(t iem_emailaccount_pub.account_info_table, a0 out nocopy JTF_VARCHAR2_TABLE_100
48: , a1 out nocopy JTF_VARCHAR2_TABLE_100
49: , a2 out nocopy JTF_VARCHAR2_TABLE_200
50: , a3 out nocopy JTF_NUMBER_TABLE
51: , a4 out nocopy JTF_NUMBER_TABLE
52: );
53:
54: procedure rosetta_table_copy_in_p8(t out nocopy iem_emailaccount_pub.acntdetails_tbl_type, a0 JTF_VARCHAR2_TABLE_300

Line 51: , a4 out nocopy JTF_NUMBER_TABLE

47: procedure rosetta_table_copy_out_p6(t iem_emailaccount_pub.account_info_table, a0 out nocopy JTF_VARCHAR2_TABLE_100
48: , a1 out nocopy JTF_VARCHAR2_TABLE_100
49: , a2 out nocopy JTF_VARCHAR2_TABLE_200
50: , a3 out nocopy JTF_NUMBER_TABLE
51: , a4 out nocopy JTF_NUMBER_TABLE
52: );
53:
54: procedure rosetta_table_copy_in_p8(t out nocopy iem_emailaccount_pub.acntdetails_tbl_type, a0 JTF_VARCHAR2_TABLE_300
55: , a1 JTF_VARCHAR2_TABLE_100

Line 59: , a5 JTF_NUMBER_TABLE

55: , a1 JTF_VARCHAR2_TABLE_100
56: , a2 JTF_VARCHAR2_TABLE_200
57: , a3 JTF_VARCHAR2_TABLE_300
58: , a4 JTF_VARCHAR2_TABLE_100
59: , a5 JTF_NUMBER_TABLE
60: , a6 JTF_VARCHAR2_TABLE_300
61: , a7 JTF_NUMBER_TABLE
62: , a8 JTF_NUMBER_TABLE
63: );

Line 61: , a7 JTF_NUMBER_TABLE

57: , a3 JTF_VARCHAR2_TABLE_300
58: , a4 JTF_VARCHAR2_TABLE_100
59: , a5 JTF_NUMBER_TABLE
60: , a6 JTF_VARCHAR2_TABLE_300
61: , a7 JTF_NUMBER_TABLE
62: , a8 JTF_NUMBER_TABLE
63: );
64: procedure rosetta_table_copy_out_p8(t iem_emailaccount_pub.acntdetails_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
65: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 62: , a8 JTF_NUMBER_TABLE

58: , a4 JTF_VARCHAR2_TABLE_100
59: , a5 JTF_NUMBER_TABLE
60: , a6 JTF_VARCHAR2_TABLE_300
61: , a7 JTF_NUMBER_TABLE
62: , a8 JTF_NUMBER_TABLE
63: );
64: procedure rosetta_table_copy_out_p8(t iem_emailaccount_pub.acntdetails_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
65: , a1 out nocopy JTF_VARCHAR2_TABLE_100
66: , a2 out nocopy JTF_VARCHAR2_TABLE_200

Line 69: , a5 out nocopy JTF_NUMBER_TABLE

65: , a1 out nocopy JTF_VARCHAR2_TABLE_100
66: , a2 out nocopy JTF_VARCHAR2_TABLE_200
67: , a3 out nocopy JTF_VARCHAR2_TABLE_300
68: , a4 out nocopy JTF_VARCHAR2_TABLE_100
69: , a5 out nocopy JTF_NUMBER_TABLE
70: , a6 out nocopy JTF_VARCHAR2_TABLE_300
71: , a7 out nocopy JTF_NUMBER_TABLE
72: , a8 out nocopy JTF_NUMBER_TABLE
73: );

Line 71: , a7 out nocopy JTF_NUMBER_TABLE

67: , a3 out nocopy JTF_VARCHAR2_TABLE_300
68: , a4 out nocopy JTF_VARCHAR2_TABLE_100
69: , a5 out nocopy JTF_NUMBER_TABLE
70: , a6 out nocopy JTF_VARCHAR2_TABLE_300
71: , a7 out nocopy JTF_NUMBER_TABLE
72: , a8 out nocopy JTF_NUMBER_TABLE
73: );
74:
75: procedure rosetta_table_copy_in_p10(t out nocopy iem_emailaccount_pub.agntacntdetails_tbl_type, a0 JTF_NUMBER_TABLE

Line 72: , a8 out nocopy JTF_NUMBER_TABLE

68: , a4 out nocopy JTF_VARCHAR2_TABLE_100
69: , a5 out nocopy JTF_NUMBER_TABLE
70: , a6 out nocopy JTF_VARCHAR2_TABLE_300
71: , a7 out nocopy JTF_NUMBER_TABLE
72: , a8 out nocopy JTF_NUMBER_TABLE
73: );
74:
75: procedure rosetta_table_copy_in_p10(t out nocopy iem_emailaccount_pub.agntacntdetails_tbl_type, a0 JTF_NUMBER_TABLE
76: , a1 JTF_VARCHAR2_TABLE_300

Line 75: procedure rosetta_table_copy_in_p10(t out nocopy iem_emailaccount_pub.agntacntdetails_tbl_type, a0 JTF_NUMBER_TABLE

71: , a7 out nocopy JTF_NUMBER_TABLE
72: , a8 out nocopy JTF_NUMBER_TABLE
73: );
74:
75: procedure rosetta_table_copy_in_p10(t out nocopy iem_emailaccount_pub.agntacntdetails_tbl_type, a0 JTF_NUMBER_TABLE
76: , a1 JTF_VARCHAR2_TABLE_300
77: , a2 JTF_VARCHAR2_TABLE_300
78: , a3 JTF_VARCHAR2_TABLE_100
79: , a4 JTF_VARCHAR2_TABLE_300

Line 81: procedure rosetta_table_copy_out_p10(t iem_emailaccount_pub.agntacntdetails_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

77: , a2 JTF_VARCHAR2_TABLE_300
78: , a3 JTF_VARCHAR2_TABLE_100
79: , a4 JTF_VARCHAR2_TABLE_300
80: );
81: procedure rosetta_table_copy_out_p10(t iem_emailaccount_pub.agntacntdetails_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
82: , a1 out nocopy JTF_VARCHAR2_TABLE_300
83: , a2 out nocopy JTF_VARCHAR2_TABLE_300
84: , a3 out nocopy JTF_VARCHAR2_TABLE_100
85: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 88: procedure rosetta_table_copy_in_p12(t out nocopy iem_emailaccount_pub.agentacnt_tbl_type, a0 JTF_NUMBER_TABLE

84: , a3 out nocopy JTF_VARCHAR2_TABLE_100
85: , a4 out nocopy JTF_VARCHAR2_TABLE_300
86: );
87:
88: procedure rosetta_table_copy_in_p12(t out nocopy iem_emailaccount_pub.agentacnt_tbl_type, a0 JTF_NUMBER_TABLE
89: , a1 JTF_NUMBER_TABLE
90: , a2 JTF_VARCHAR2_TABLE_300
91: , a3 JTF_VARCHAR2_TABLE_300
92: , a4 JTF_VARCHAR2_TABLE_300

Line 89: , a1 JTF_NUMBER_TABLE

85: , a4 out nocopy JTF_VARCHAR2_TABLE_300
86: );
87:
88: procedure rosetta_table_copy_in_p12(t out nocopy iem_emailaccount_pub.agentacnt_tbl_type, a0 JTF_NUMBER_TABLE
89: , a1 JTF_NUMBER_TABLE
90: , a2 JTF_VARCHAR2_TABLE_300
91: , a3 JTF_VARCHAR2_TABLE_300
92: , a4 JTF_VARCHAR2_TABLE_300
93: , a5 JTF_VARCHAR2_TABLE_300

Line 97: procedure rosetta_table_copy_out_p12(t iem_emailaccount_pub.agentacnt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

93: , a5 JTF_VARCHAR2_TABLE_300
94: , a6 JTF_VARCHAR2_TABLE_300
95: , a7 JTF_VARCHAR2_TABLE_300
96: );
97: procedure rosetta_table_copy_out_p12(t iem_emailaccount_pub.agentacnt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
98: , a1 out nocopy JTF_NUMBER_TABLE
99: , a2 out nocopy JTF_VARCHAR2_TABLE_300
100: , a3 out nocopy JTF_VARCHAR2_TABLE_300
101: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 98: , a1 out nocopy JTF_NUMBER_TABLE

94: , a6 JTF_VARCHAR2_TABLE_300
95: , a7 JTF_VARCHAR2_TABLE_300
96: );
97: procedure rosetta_table_copy_out_p12(t iem_emailaccount_pub.agentacnt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
98: , a1 out nocopy JTF_NUMBER_TABLE
99: , a2 out nocopy JTF_VARCHAR2_TABLE_300
100: , a3 out nocopy JTF_VARCHAR2_TABLE_300
101: , a4 out nocopy JTF_VARCHAR2_TABLE_300
102: , a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 117: , p7_a3 out nocopy JTF_NUMBER_TABLE

113: , x_msg_data out nocopy VARCHAR2
114: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_300
115: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_300
116: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
117: , p7_a3 out nocopy JTF_NUMBER_TABLE
118: );
119: procedure getemailheaders(p_agentname VARCHAR2
120: , p_top_n INTEGER
121: , p_top_option INTEGER

Line 123: , p4_a0 out nocopy JTF_NUMBER_TABLE

119: procedure getemailheaders(p_agentname VARCHAR2
120: , p_top_n INTEGER
121: , p_top_option INTEGER
122: , p_folder_path VARCHAR2
123: , p4_a0 out nocopy JTF_NUMBER_TABLE
124: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_300
125: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_200
126: , p4_a3 out nocopy JTF_DATE_TABLE
127: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 133: , p4_a10 out nocopy JTF_NUMBER_TABLE

129: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
130: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
131: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_300
132: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_300
133: , p4_a10 out nocopy JTF_NUMBER_TABLE
134: , p4_a11 out nocopy JTF_VARCHAR2_TABLE_300
135: );
136: procedure listagentaccounts(p_api_version_number NUMBER
137: , p_init_msg_list VARCHAR2

Line 143: , p7_a0 out nocopy JTF_NUMBER_TABLE

139: , p_resource_id NUMBER
140: , x_return_status out nocopy VARCHAR2
141: , x_msg_count out nocopy NUMBER
142: , x_msg_data out nocopy VARCHAR2
143: , p7_a0 out nocopy JTF_NUMBER_TABLE
144: , p7_a1 out nocopy JTF_NUMBER_TABLE
145: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
146: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
147: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 144: , p7_a1 out nocopy JTF_NUMBER_TABLE

140: , x_return_status out nocopy VARCHAR2
141: , x_msg_count out nocopy NUMBER
142: , x_msg_data out nocopy VARCHAR2
143: , p7_a0 out nocopy JTF_NUMBER_TABLE
144: , p7_a1 out nocopy JTF_NUMBER_TABLE
145: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
146: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
147: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
148: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 167: , p15_a0 out nocopy JTF_NUMBER_TABLE

163: , x_return_status out nocopy VARCHAR2
164: , x_msg_count out nocopy NUMBER
165: , x_search_count out nocopy NUMBER
166: , x_msg_data out nocopy VARCHAR2
167: , p15_a0 out nocopy JTF_NUMBER_TABLE
168: , p15_a1 out nocopy JTF_VARCHAR2_TABLE_300
169: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_300
170: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
171: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 185: , p7_a5 out nocopy JTF_NUMBER_TABLE

181: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
182: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
183: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
184: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
185: , p7_a5 out nocopy JTF_NUMBER_TABLE
186: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
187: , p7_a7 out nocopy JTF_NUMBER_TABLE
188: , p7_a8 out nocopy JTF_NUMBER_TABLE
189: );

Line 187: , p7_a7 out nocopy JTF_NUMBER_TABLE

183: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
184: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
185: , p7_a5 out nocopy JTF_NUMBER_TABLE
186: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
187: , p7_a7 out nocopy JTF_NUMBER_TABLE
188: , p7_a8 out nocopy JTF_NUMBER_TABLE
189: );
190: end iem_emailaccount_pub_w;

Line 188: , p7_a8 out nocopy JTF_NUMBER_TABLE

184: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
185: , p7_a5 out nocopy JTF_NUMBER_TABLE
186: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
187: , p7_a7 out nocopy JTF_NUMBER_TABLE
188: , p7_a8 out nocopy JTF_NUMBER_TABLE
189: );
190: end iem_emailaccount_pub_w;