1 PACKAGE BODY IEM_IM_SETUP_PVT as
2 /* $Header: iemvimsb.pls 120.0 2006/06/13 19:54:12 chtang noship $*/
3
4 -- *****************************************************
5 -- Start of Comments
6 -- Package name : IEM_IM_SETUP_PVT
7 -- Purpose : APIs that are used to setup email accounts and various folders.
8 -- History : June 13, 2006 All the procedures have been obsoleted in R12. Stubbed out all the procedures
9 -- instead of removing the package due to the CRM Resource Manager dependency
10 -- on this package. Please see bug 5303797
11 -- NOTE :
12 -- End of Comments
13 -- *****************************************************
14
15 g_statement_log boolean; -- Statement Level Logging
16 G_PKG_NAME CONSTANT varchar2(30) :='IEM_IM_SETUP_PVT ';
17
18 -- Start of Comments
19 -- API name : create_item
20 -- Type : Private
21 -- Function : This procedure create a record in the table IEM_EMAIL_ACCOUNTS
22 -- Pre-reqs : None.
23 -- Parameters :
24 -- IN
25 -- p_api_version_number IN NUMBER Required
26 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
27 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
28 -- p_account_name IN VARCHAR2,
29 -- p_email_user IN VARCHAR2,
30 -- p_domain IN VARCHAR2,
31 -- p_email_password IN VARCHAR2,
32 -- p_account_profile IN VARCHAR2,
33 -- p_db_server_id IN NUMBER,
34 -- p_server_group_id IN NUMBER,
35 -- SETSUP VARIOUS FOLDERS and CALLS ICENTER SETUP
36 -- OUT
37 -- x_return_status OUT VARCHAR2
38 -- x_msg_count OUT NUMBER
39 -- x_msg_data OUT VARCHAR2
40 --
41 -- Version : 1.0
42 -- Notes :
43 --
44 -- End of comments
45 -- **********************************************************
46
47 PROCEDURE imAccountSetup (p_api_version_number IN NUMBER,
48 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
49 p_commit IN VARCHAR2 := FND_API.G_FALSE,
50 p_email_user IN VARCHAR2,
51 p_domain IN VARCHAR2,
52 p_password IN VARCHAR2,
53
54 x_return_status OUT NOCOPY VARCHAR2,
55 x_msg_count OUT NOCOPY NUMBER,
56 x_msg_data OUT NOCOPY VARCHAR2
57 ) is
58
59 BEGIN
60 null;
61
62 END;
63
64 PROCEDURE oesAccountSetup (p_api_version_number IN NUMBER,
65 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
66 p_commit IN VARCHAR2 := FND_API.G_FALSE,
67 p_email_user IN VARCHAR2,
68 p_domain IN VARCHAR2,
69 p_password IN VARCHAR2,
70
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2
74 ) is
75
76 BEGIN
77 null;
78
79 END;
80
81
82 PROCEDURE autoackAccountSetup (p_api_version_number IN NUMBER,
83 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
84 p_commit IN VARCHAR2 := FND_API.G_FALSE,
85 p_email_user IN VARCHAR2,
86 p_domain IN VARCHAR2,
87 p_password IN VARCHAR2,
88
89 x_return_status OUT NOCOPY VARCHAR2,
90 x_msg_count OUT NOCOPY NUMBER,
91 x_msg_data OUT NOCOPY VARCHAR2
92 ) is
93
94 BEGIN
95 null;
96
97 END;
98
99
100 -- Start of Comments
101 -- API name : imDeleteRules
102 -- Type : Private
103 -- Function : This procedure removes the IM Rule from the table OM_SERVER_RULES in OES via db link
104 -- Pre-reqs : None.
105 -- Parameters :
106 -- IN
107 -- p_api_version_number IN NUMBER Required
108 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
109 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
110 -- p_account_id IN NUMBER,
111 -- OUT
112 -- x_return_status OUT VARCHAR2
113 -- x_msg_count OUT NUMBER
114 -- x_msg_data OUT VARCHAR2
115 --
116 -- Version : 1.0
117 -- Notes :
118 --
119 -- End of comments
120 -- **********************************************************
121
122 PROCEDURE imDeleteRules (p_api_version_number IN NUMBER,
123 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
124 p_commit IN VARCHAR2 := FND_API.G_FALSE,
125 p_account_id IN NUMBER,
126
127 x_return_status OUT NOCOPY VARCHAR2,
128 x_msg_count OUT NOCOPY NUMBER,
129 x_msg_data OUT NOCOPY VARCHAR2
130 ) is
131
132
133 BEGIN
134 null;
135
136 END;
137
138
139 -- Start of Comments
140 -- API name : delete_item
141 -- Type : Private
142 -- Function : This procedure delete a record in the table IEM_EMAIL_ACCOUNTS
143 -- Pre-reqs : None.
144 -- Parameters :
145 -- IN
146 -- p_api_version_number IN NUMBER Required
147 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
148 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
149 -- p_email_account_id in number,
150 -- p_account_name IN VARCHAR2 ,
151
152 -- OUT
153 -- x_return_status OUT VARCHAR2
154 -- x_msg_count OUT NUMBER
155 -- x_msg_data OUT VARCHAR2
156 --
157 -- Version : 1.0
158 -- Notes :
159 --
160 -- End of comments
161 -- **********************************************************
162
163 PROCEDURE imAcntPasswdSync (p_api_version_number IN NUMBER,
164 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165 p_commit IN VARCHAR2 := FND_API.G_FALSE,
166 p_email_account_id in number,
167 x_return_status OUT NOCOPY VARCHAR2,
168 x_msg_count OUT NOCOPY NUMBER,
169 x_msg_data OUT NOCOPY VARCHAR2
170 ) is
171
172
173 BEGIN
174
175
176 NULL;
177
178
179
180 END;
181
182
183
184
185 -- Start of Comments
186 -- API name : update_item
187 -- Type : Private
188 -- Function : This procedure update a record in the table IEM_EMAIL_ACCOUNTS
189 -- Pre-reqs : None.
190 -- Parameters :
191 -- IN
192 -- p_api_version_number IN NUMBER Required
193 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
194 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
195 --p_email_account_id IN NUMBER,
196 -- p_account_name IN VARCHAR2,
197 -- p_email_user IN VARCHAR2,
198 -- p_domain IN VARCHAR2,
199 -- p_email_password IN VARCHAR2,
200 -- p_account_profile IN VARCHAR2,
201 -- p_db_server_id IN NUMBER,
202 -- p_server_group_id IN NUMBER,
203 --
204 -- OUT
205 -- x_return_status OUT VARCHAR2
206 -- x_msg_count OUT NUMBER
207 -- x_msg_data OUT VARCHAR2
208 --
209 -- Version : 1.0
210 -- Notes :
211 --
212 -- End of comments
213 -- **********************************************************
214
215 PROCEDURE createAgntFolder (
216 x_return_status OUT NOCOPY VARCHAR2
217
218 ) is
219
220 BEGIN
221
222 x_return_status := FND_API.G_RET_STS_SUCCESS;
223
224 END;
225
226
227
228
229
230 PROCEDURE deleteAgntFolder (
231 x_return_status OUT NOCOPY VARCHAR2
232
233 ) is
234
235
236 BEGIN
237 x_return_status := FND_API.G_RET_STS_SUCCESS;
238
239 END;
240
241 PROCEDURE getEmailAgents (p_email_account_id IN NUMBER,
242 p_resource_id_table OUT NOCOPY resource_id_table
243 ) is
244
245
246 BEGIN
247 null;
248
249 END;
250
251 PROCEDURE getEmailAccounts (
252 p_user_name IN VARCHAR,
253 p_email_account_id_table OUT NOCOPY email_account_id_table
254 ) is
255
256 begin
257
258 null;
259
260 end;
261
262 -- Start of Comments
263 -- API name : createAccount
264 -- Type : Private
265 -- Function : This procedure creates an account in the OES database
266 -- Pre-reqs : None.
267 -- Parameters :
268 -- IN
269 -- p_api_version_number IN NUMBER Required
270 -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
271 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
272 -- p_oo_link IN VARCHAR2 Required
273 -- p_admin_id IN VARCHAR2 Required
274 -- p_admin_pass IN VARCHAR2 Required
275 -- P_account_id IN VARCHAR2 Required
276 -- P_account_first IN VARCHAR2 Required
277 -- P_account_last IN VARCHAR2 Required
278 -- P_account_pass IN VARCHAR2 Required
279 -- p_domain IN VARCHAR2 Required
280 -- p_node IN VARCHAR2 Required
281 -- p_oes_database IN VARCHAR2 Required
282 -- OUT
283 -- x_return_status OUT VARCHAR2
284 -- x_msg_count OUT NUMBER
285 -- x_msg_data OUT VARCHAR2
286 --
287 -- Version : 1.0
288 -- Notes :
289 --
290 -- End of comments
291 -- **********************************************************
292
293 PROCEDURE createAccount(p_api_version_number IN NUMBER,
294 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
295 p_commit IN VARCHAR2 := FND_API.G_FALSE,
296 p_oo_link IN VARCHAR2:=null,
297 p_admin_id IN VARCHAR2:=null,
298 p_admin_pass IN VARCHAR2:=null,
299 p_account_id IN VARCHAR2:=null,
300 p_account_first IN VARCHAR2:=null,
301 p_account_last IN VARCHAR2:=null,
302 p_account_pass IN VARCHAR2:=null,
303 p_domain IN VARCHAR2:=null,
304 p_node IN VARCHAR2:=null,
305 p_oes_database IN VARCHAR2:=null,
306 x_return_status OUT NOCOPY VARCHAR2,
307 x_msg_count OUT NOCOPY NUMBER,
308 x_msg_data OUT NOCOPY VARCHAR2
309 ) is
310
311 BEGIN
312 x_return_status := FND_API.G_RET_STS_SUCCESS;
313
314 END;
315
316 -- Start of Comments
317 -- API name : deleteAccount
318 -- Type : Private
319 -- Function : This procedure deletes an account in the OES database
320 -- Pre-reqs : None.
321 -- Parameters :
322 -- IN
323 -- p_api_version_number IN NUMBER Required
324 -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
325 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
326 -- p_oo_link IN VARCHAR2 Required
327 -- p_admin_id IN VARCHAR2 Required
328 -- p_admin_pass IN VARCHAR2 Required
329 -- P_account_id IN VARCHAR2 Required
330 -- p_domain IN VARCHAR2 Required
331 -- p_oes_database IN VARCHAR2 Required
332 -- OUT
333 -- x_return_status OUT VARCHAR2
334 -- x_msg_count OUT NUMBER
335 -- x_msg_data OUT VARCHAR2
336 --
337 -- Version : 1.0
338 -- Notes :
339 --
340 -- End of comments
341 -- **********************************************************
342
343 PROCEDURE deleteAccount(p_api_version_number IN NUMBER,
344 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
345 p_commit IN VARCHAR2 := FND_API.G_FALSE,
346 p_oo_link IN VARCHAR2:=null,
347 p_admin_id IN VARCHAR2:=null,
348 p_admin_pass IN VARCHAR2:=null,
349 p_account_id IN VARCHAR2:=null,
350 p_domain IN VARCHAR2:=null,
351 p_oes_database IN VARCHAR2:=null,
352 x_return_status OUT NOCOPY VARCHAR2,
353 x_msg_count OUT NOCOPY NUMBER,
354 x_msg_data OUT NOCOPY VARCHAR2
355 ) is
356
357 BEGIN
358
359 x_return_status := FND_API.G_RET_STS_SUCCESS;
360
361 END;
362
363 PROCEDURE createAgntAccount (
364 x_return_status OUT NOCOPY VARCHAR2
365 ) is
366
367
368 BEGIN
369
370 x_return_status := FND_API.G_RET_STS_SUCCESS;
371 END;
372
373 PROCEDURE iem_logger(l_level in varchar2,
374 l_logmessage in varchar2) IS
375 begin
376 null;
377 end iem_logger;
378
379
380 PROCEDURE deleteAgntAccount (
381 x_return_status OUT NOCOPY VARCHAR2
382
383 ) is
384
385
386
387 BEGIN
388 x_return_status := FND_API.G_RET_STS_SUCCESS;
389 END;
390
391
392 END IEM_IM_SETUP_PVT;