APPS.IEM_EMAILACCOUNT_PUB_W dependencies on JTF_NUMBER_TABLE

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: IEMVEMAS.pls 120.5 2011/12/25 17:36:06 lkullamb 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: , a9 JTF_VARCHAR2_TABLE_100

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: , a9 JTF_VARCHAR2_TABLE_100
64: );
65: procedure rosetta_table_copy_out_p8(t iem_emailaccount_pub.acntdetails_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300

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: , a9 JTF_VARCHAR2_TABLE_100
64: );
65: procedure rosetta_table_copy_out_p8(t iem_emailaccount_pub.acntdetails_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
66: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 70: , a5 out nocopy JTF_NUMBER_TABLE

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

Line 72: , a7 out nocopy JTF_NUMBER_TABLE

68: , a3 out nocopy JTF_VARCHAR2_TABLE_300
69: , a4 out nocopy JTF_VARCHAR2_TABLE_100
70: , a5 out nocopy JTF_NUMBER_TABLE
71: , a6 out nocopy JTF_VARCHAR2_TABLE_300
72: , a7 out nocopy JTF_NUMBER_TABLE
73: , a8 out nocopy JTF_NUMBER_TABLE
74: , a9 out nocopy JTF_VARCHAR2_TABLE_100
75: );
76:

Line 73: , a8 out nocopy JTF_NUMBER_TABLE

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

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

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

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

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

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

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

Line 91: , a1 JTF_NUMBER_TABLE

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

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

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

Line 100: , a1 out nocopy JTF_NUMBER_TABLE

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

Line 119: , p7_a3 out nocopy JTF_NUMBER_TABLE

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

Line 125: , p4_a0 out nocopy JTF_NUMBER_TABLE

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

Line 135: , p4_a10 out nocopy JTF_NUMBER_TABLE

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

Line 145: , p7_a0 out nocopy JTF_NUMBER_TABLE

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

Line 146: , p7_a1 out nocopy JTF_NUMBER_TABLE

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

Line 161: , p7_a0 out nocopy JTF_NUMBER_TABLE

157: , p_resource_id NUMBER
158: , x_return_status out nocopy VARCHAR2
159: , x_msg_count out nocopy NUMBER
160: , x_msg_data out nocopy VARCHAR2
161: , p7_a0 out nocopy JTF_NUMBER_TABLE
162: , p7_a1 out nocopy JTF_NUMBER_TABLE
163: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
164: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
165: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 162: , p7_a1 out nocopy JTF_NUMBER_TABLE

158: , x_return_status out nocopy VARCHAR2
159: , x_msg_count out nocopy NUMBER
160: , x_msg_data out nocopy VARCHAR2
161: , p7_a0 out nocopy JTF_NUMBER_TABLE
162: , p7_a1 out nocopy JTF_NUMBER_TABLE
163: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
164: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
165: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
166: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 185: , p15_a0 out nocopy JTF_NUMBER_TABLE

181: , x_return_status out nocopy VARCHAR2
182: , x_msg_count out nocopy NUMBER
183: , x_search_count out nocopy NUMBER
184: , x_msg_data out nocopy VARCHAR2
185: , p15_a0 out nocopy JTF_NUMBER_TABLE
186: , p15_a1 out nocopy JTF_VARCHAR2_TABLE_300
187: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_300
188: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
189: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 203: , p7_a5 out nocopy JTF_NUMBER_TABLE

199: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
200: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
201: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
202: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
203: , p7_a5 out nocopy JTF_NUMBER_TABLE
204: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
205: , p7_a7 out nocopy JTF_NUMBER_TABLE
206: , p7_a8 out nocopy JTF_NUMBER_TABLE
207: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 205: , p7_a7 out nocopy JTF_NUMBER_TABLE

201: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
202: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
203: , p7_a5 out nocopy JTF_NUMBER_TABLE
204: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
205: , p7_a7 out nocopy JTF_NUMBER_TABLE
206: , p7_a8 out nocopy JTF_NUMBER_TABLE
207: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
208: );
209: end iem_emailaccount_pub_w;

Line 206: , p7_a8 out nocopy JTF_NUMBER_TABLE

202: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
203: , p7_a5 out nocopy JTF_NUMBER_TABLE
204: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
205: , p7_a7 out nocopy JTF_NUMBER_TABLE
206: , p7_a8 out nocopy JTF_NUMBER_TABLE
207: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
208: );
209: end iem_emailaccount_pub_w;