[Home] [Help]
PACKAGE: APPS.IEM_IM_SETUP_PVT
Source
1 PACKAGE IEM_IM_SETUP_PVT AUTHID CURRENT_USER as
2 /* $Header: iemvimss.pls 120.0 2006/06/13 19:53:14 chtang noship $*/
3
4 -- Start of Comments
5 -- API name : create_item
6 -- Type : Private
7 -- Function : This procedure create a record in the table IEM_EMAIL_ACCOUNTS
8 -- Pre-reqs : None.
9 -- Parameters :
10 -- IN
11 -- p_api_version_number IN NUMBER Required
12 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
13 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
14 -- p_account_name IN VARCHAR2,
15 -- p_email_user IN VARCHAR2,
16 -- p_domain IN VARCHAR2,
17 -- p_email_password IN VARCHAR2,
18 -- p_account_profile IN VARCHAR2,
19 -- p_db_server_id IN NUMBER,
20 -- p_server_group_id IN NUMBER,
21 -- SETSUP VARIOUS FOLDERS and CALLS ICENTER SETUP
22 -- OUT
23 -- x_return_status OUT VARCHAR2
24 -- x_msg_count OUT NUMBER
25 -- x_msg_data OUT VARCHAR2
26 --
27 -- Version : 1.0
28 -- Notes :
29 --
30 -- End of comments
31 -- **********************************************************
32 --G_DBLINK_NAME CONSTANT VARCHAR2(100):= 'domlink';
33 G_AdminFldrName constant VARCHAR2(30) := 'Admin';
34 G_RetryFldrName constant VARCHAR2(30) := 'Retry';
35 G_ResolvedFldrName constant VARCHAR2(30) := 'Resolved';
36 TYPE resource_id_table is TABLE of INTEGER INDEX BY BINARY_INTEGER;
37
38 type email_account_id_table is TABLE of INTEGER INDEX BY BINARY_INTEGER;
39
40 PROCEDURE imAccountSetup (p_api_version_number IN NUMBER,
41 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
42 p_commit IN VARCHAR2 := FND_API.G_FALSE,
43 p_email_user IN VARCHAR2,
44 p_domain IN VARCHAR2,
45 p_password IN VARCHAR2,
46 x_return_status OUT NOCOPY VARCHAR2,
47 x_msg_count OUT NOCOPY NUMBER,
48 x_msg_data OUT NOCOPY VARCHAR2
49 );
50
51 PROCEDURE oesAccountSetup (p_api_version_number IN NUMBER,
52 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
53 p_commit IN VARCHAR2 := FND_API.G_FALSE,
54 p_email_user IN VARCHAR2,
55 p_domain IN VARCHAR2,
56 p_password IN VARCHAR2,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2
60 );
61
62 PROCEDURE autoackAccountSetup (p_api_version_number IN NUMBER,
63 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
64 p_commit IN VARCHAR2 := FND_API.G_FALSE,
65 p_email_user IN VARCHAR2,
66 p_domain IN VARCHAR2,
67 p_password IN VARCHAR2,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_msg_count OUT NOCOPY NUMBER,
70 x_msg_data OUT NOCOPY VARCHAR2
71 );
72
73 PROCEDURE imDeleteRules (p_api_version_number IN NUMBER,
74 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
75 p_commit IN VARCHAR2 := FND_API.G_FALSE,
76 p_account_id IN NUMBER,
77
78 x_return_status OUT NOCOPY VARCHAR2,
79 x_msg_count OUT NOCOPY NUMBER,
80 x_msg_data OUT NOCOPY VARCHAR2
81 );
82
83
84 -- Start of Comments
85 -- API name : delete_item
86 -- Type : Private
87 -- Function : This procedure delete a record in the table IEM_EMAIL_ACCOUNTS
88 -- Pre-reqs : None.
89 -- Parameters :
90 -- IN
91 -- p_api_version_number IN NUMBER Required
92 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
93 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
94 -- p_email_account_id in number,
95 -- p_account_name IN VARCHAR2 ,
96
97 -- OUT
98 -- x_return_status OUT VARCHAR2
99 -- x_msg_count OUT NUMBER
100 -- x_msg_data OUT VARCHAR2
101 --
102 -- Version : 1.0
103 -- Notes :
104 --
105 -- End of comments
106 -- **********************************************************
107
108 PROCEDURE imAcntPasswdSync (p_api_version_number IN NUMBER,
109 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
110 p_commit IN VARCHAR2 := FND_API.G_FALSE,
111 p_email_account_id in number,
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2
115 );
116 -- Start of Comments
117 -- API name : update_item
118 -- Type : Private
119 -- Function : This procedure update a record in the table IEM_EMAIL_ACCOUNTS
120 -- Pre-reqs : None.
121 -- Parameters :
122 -- IN
123 -- p_api_version_number IN NUMBER Required
124 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
125 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
126 --p_email_account_id IN NUMBER,
127 -- p_account_name IN VARCHAR2,
128 -- p_email_user IN VARCHAR2,
129 -- p_domain IN VARCHAR2,
130 -- p_email_password IN VARCHAR2,
131 -- p_account_profile IN VARCHAR2,
132 -- p_db_server_id IN NUMBER,
133 -- p_server_group_id IN NUMBER,
134 --
135 -- OUT
136 -- x_return_status OUT VARCHAR2
137 -- x_msg_count OUT NUMBER
138 -- x_msg_data OUT VARCHAR2
139 --
140 -- Version : 1.0
141 -- Notes :
142 --
143 -- End of comments
144 -- **********************************************************
145
146 PROCEDURE createAgntFolder (
147 x_return_status OUT NOCOPY VARCHAR2
148 );
149
150 PROCEDURE createAgntAccount(
151 x_return_status OUT NOCOPY VARCHAR2
152 );
153
154 PROCEDURE deleteAgntFolder (
155 x_return_status OUT NOCOPY VARCHAR2
156 );
157
158 PROCEDURE deleteAgntAccount (
159 x_return_status OUT NOCOPY VARCHAR2
160 );
161
162 PROCEDURE getEmailAgents (
163 p_email_account_id IN NUMBER,
164 p_resource_id_table OUT NOCOPY resource_id_table
165 );
166
167 PROCEDURE getEmailAccounts (
168 p_user_name IN VARCHAR,
169 p_email_account_id_table OUT NOCOPY email_account_id_table
170 );
171
172 -- Start of Comments
173 -- API name : createAccount
174 -- Type : Private
175 -- Function : This procedure creates an account in the OES database
176 -- Pre-reqs : None.
177 -- Parameters :
178 -- IN
179 -- p_api_version_number IN NUMBER Required
180 -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
181 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
182 -- p_admin_id IN VARCHAR2 Required
183 -- p_admin_pass IN VARCHAR2 Required
184 -- P_account_id IN VARCHAR2 Required
185 -- P_account_first IN VARCHAR2 Required
186 -- P_account_last IN VARCHAR2 Required
187 -- P_account_pass IN VARCHAR2 Required
188 -- p_oo_link IN VARCHAR2 Required
189 -- p_domain IN VARCHAR2 Required
190 -- p_node IN VARCHAR2 Required
191 -- p_oes_database IN VARCHAR2 Required
192
193 -- OUT
194 -- x_return_status OUT VARCHAR2
195 -- x_msg_count OUT NUMBER
196 -- x_msg_data OUT VARCHAR2
197 --
198 -- Version : 1.0
199 -- Notes :
200 --
201 -- End of comments
202 -- **********************************************************
203
204 PROCEDURE createAccount(p_api_version_number IN NUMBER,
205 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
206 p_commit IN VARCHAR2 := FND_API.G_FALSE,
207 p_oo_link IN VARCHAR2:=null,
208 p_admin_id IN VARCHAR2:=null,
209 p_admin_pass IN VARCHAR2:=null,
210 p_account_id IN VARCHAR2:=null,
211 p_account_first IN VARCHAR2:=null,
212 p_account_last IN VARCHAR2:=null,
213 p_account_pass IN VARCHAR2:=null,
214 p_domain IN VARCHAR2:=null,
215 p_node IN VARCHAR2:=null,
216 p_oes_database IN VARCHAR2:=null,
217 x_return_status OUT NOCOPY VARCHAR2,
218 x_msg_count OUT NOCOPY NUMBER,
219 x_msg_data OUT NOCOPY VARCHAR2
220 );
221
222 -- Start of Comments
223 -- API name : deleteAccount
224 -- Type : Private
225 -- Function : This procedure deletes an account in the OES database
226 -- Pre-reqs : None.
227 -- Parameters :
228 -- IN
229 -- p_api_version_number IN NUMBER Required
230 -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
231 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
232 -- p_admin_id IN VARCHAR2 Required
233 -- p_admin_pass IN VARCHAR2 Required
234 -- P_account_id IN VARCHAR2 Required
235 -- p_domain IN VARCHAR2 Required
236 -- p_oo_link IN VARCHAR2 Required
237 -- p_oes_database IN VARCHAR2 Required
238
239 -- OUT
240 -- x_return_status OUT VARCHAR2
241 -- x_msg_count OUT NUMBER
242 -- x_msg_data OUT VARCHAR2
243 --
244 -- Version : 1.0
245 -- Notes :
246 --
247 -- End of comments
248 PROCEDURE deleteAccount(p_api_version_number IN NUMBER,
249 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
250 p_commit IN VARCHAR2 := FND_API.G_FALSE,
251 p_oo_link IN VARCHAR2:=null,
252 p_admin_id IN VARCHAR2:=null,
253 p_admin_pass IN VARCHAR2:=null,
254 p_account_id IN VARCHAR2:=null,
255 p_domain IN VARCHAR2:=null,
256 p_oes_database IN VARCHAR2:=null,
257 x_return_status OUT NOCOPY VARCHAR2,
258 x_msg_count OUT NOCOPY NUMBER,
259 x_msg_data OUT NOCOPY VARCHAR2
260 );
261 PROCEDURE iem_logger(l_level in varchar2,
262 l_logmessage in varchar2);
263
264 END IEM_IM_SETUP_PVT;