[Home] [Help]
PACKAGE: APPS.IEM_EMAILACCOUNT_PUB_W
Source
1 package iem_emailaccount_pub_w AUTHID CURRENT_USER as
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
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
19 , a5 JTF_VARCHAR2_TABLE_300
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
29 , a2 out nocopy JTF_VARCHAR2_TABLE_200
30 , a3 out nocopy JTF_DATE_TABLE
31 , a4 out nocopy JTF_VARCHAR2_TABLE_100
32 , a5 out nocopy JTF_VARCHAR2_TABLE_300
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
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
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
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
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
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
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
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
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
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
105 , a6 out nocopy JTF_VARCHAR2_TABLE_300
106 , a7 out nocopy JTF_VARCHAR2_TABLE_300
107 );
108
109 procedure get_emailaccount_list(p_api_version_number NUMBER
110 , p_init_msg_list VARCHAR2
111 , p_commit VARCHAR2
112 , p_resource_id NUMBER
113 , x_return_status out nocopy VARCHAR2
114 , x_msg_count out nocopy NUMBER
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
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
130 , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
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
140 , p_commit VARCHAR2
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
150 , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
151 , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
152 , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300
153 );
154 procedure listagentcpaccounts(p_api_version_number NUMBER
155 , p_init_msg_list VARCHAR2
156 , p_commit VARCHAR2
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
166 , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
167 , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
168 , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300
169 );
170 procedure listagentaccountdetails(p_api_version_number NUMBER
171 , p_init_msg_list VARCHAR2
172 , p_commit VARCHAR2
173 , p_email_account_id NUMBER
174 , p_roleid NUMBER
175 , p_resource_id NUMBER
176 , p_search_criteria VARCHAR2
177 , p_display_size NUMBER
178 , p_page_count NUMBER
179 , p_sort_by VARCHAR2
180 , p_sort_order NUMBER
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
190 );
191 procedure listaccountdetails(p_api_version_number NUMBER
192 , p_init_msg_list VARCHAR2
193 , p_commit VARCHAR2
194 , p_email_account_id NUMBER
195 , x_return_status out nocopy VARCHAR2
196 , x_msg_count out nocopy NUMBER
197 , x_msg_data out nocopy VARCHAR2
198 , p7_a0 out nocopy JTF_VARCHAR2_TABLE_300
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
208 );
209 end iem_emailaccount_pub_w;