1 PACKAGE IEM_CLIENT_PUB as
2 /* $Header: iempclts.pls 120.1 2006/04/27 11:49:00 txliu noship $*/
3
4
5 PROCEDURE getWork (p_api_version_number IN NUMBER,
6 p_init_msg_list IN VARCHAR2,
7 p_commit IN VARCHAR2,
8 p_resource_id IN NUMBER,
9 p_email_account_id IN NUMBER,
10 p_classification_id IN NUMBER,
11 x_return_status OUT NOCOPY VARCHAR2,
12 x_msg_count OUT NOCOPY NUMBER,
13 x_msg_data OUT NOCOPY VARCHAR2,
14 x_rt_media_item_id OUT NOCOPY NUMBER,
15 x_email_account_id OUT NOCOPY NUMBER,
16 x_oes_id OUT NOCOPY NUMBER,
17 x_folder_name OUT NOCOPY VARCHAR2,
18 x_folder_uid OUT NOCOPY NUMBER,
19 x_rt_interaction_id OUT NOCOPY NUMBER,
20 x_customer_id OUT NOCOPY NUMBER,
21 x_rfc822_message_id OUT NOCOPY VARCHAR2,
22 x_route_classification OUT NOCOPY VARCHAR2,
23 x_mdt_message_id OUT NOCOPY NUMBER,
24 x_service_request_id OUT NOCOPY NUMBER,
25 x_contact_id OUT NOCOPY NUMBER,
26 x_classification_id OUT NOCOPY NUMBER,
27 x_lead_id OUT NOCOPY NUMBER,
28 x_relationship_id OUT NOCOPY NUMBER
29 );
30
31
32
33 PROCEDURE getIHID (p_api_version_number IN NUMBER,
34 p_init_msg_list IN VARCHAR2,
35 p_commit IN VARCHAR2,
36 p_action IN VARCHAR2,
37 p_action_id IN NUMBER,
38 p_rt_media_item_id IN NUMBER,
39 p_version IN NUMBER,
40 p_customer_id IN NUMBER,
41 p_activity_type_id IN NUMBER,
42 p_outcome_id IN NUMBER,
43 p_result_id IN NUMBER,
44 p_reason_id IN NUMBER,
45 p_resource_id IN NUMBER,
46 x_return_status OUT NOCOPY VARCHAR2,
47 x_msg_count OUT NOCOPY NUMBER,
48 x_msg_data OUT NOCOPY VARCHAR2,
49 x_interaction_id OUT NOCOPY NUMBER,
50 x_sr_id OUT NOCOPY NUMBER,
51 x_lead_id OUT NOCOPY NUMBER
52 );
53
54 PROCEDURE wrapUp (p_api_version_number IN NUMBER,
55 p_init_msg_list IN VARCHAR2,
56 p_commit IN VARCHAR2,
57 p_action IN VARCHAR2,
58 p_action_id IN NUMBER,
59 p_rt_media_item_id IN NUMBER,
60 p_version IN NUMBER,
61 p_customer_id IN NUMBER,
62 p_activity_type_id IN NUMBER,
63 p_outcome_id IN NUMBER,
64 p_result_id IN NUMBER,
65 p_reason_id IN NUMBER,
66 p_to_resource_id IN NUMBER,
67 p_subject IN VARCHAR2,
68 p_to_address IN VARCHAR2,
69 p_transfer_msg_flag IN VARCHAR2,
70 p_to_account_id IN NUMBER,
71 p_to_classi_id IN NUMBER,
72 p_reroute_type IN NUMBER,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2
76 );
77
78
79 PROCEDURE recoverCompose (p_api_version_number IN NUMBER,
80 p_init_msg_list IN VARCHAR2,
81 p_commit IN VARCHAR2,
82 p_resource_id IN NUMBER,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2,
86 x_rfc822_message_id OUT NOCOPY VARCHAR2,
87 x_account_id OUT NOCOPY NUMBER,
88 x_account_type OUT NOCOPY VARCHAR2,
89 x_email_type OUT NOCOPY VARCHAR2,
90 x_status OUT NOCOPY VARCHAR2,
91 x_version OUT NOCOPY NUMBER,
92 x_rt_media_item_id OUT NOCOPY NUMBER,
93 x_rt_interaction_id OUT NOCOPY NUMBER,
94 x_oes_id OUT NOCOPY NUMBER,
95 x_folder_name OUT NOCOPY VARCHAR2,
96 x_folder_uid OUT NOCOPY NUMBER,
97 x_customer_id OUT NOCOPY NUMBER
98 );
99
100 PROCEDURE getMediaDetails (p_api_version_number IN NUMBER,
101 p_init_msg_list IN VARCHAR2,
102 p_commit IN VARCHAR2,
103 p_rt_media_item_id IN NUMBER,
104 p_version IN NUMBER,
105 p_email_type IN VARCHAR2,
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2,
109 x_rfc822_message_id OUT NOCOPY VARCHAR2,
110 x_account_id OUT NOCOPY NUMBER,
111 x_account_type OUT NOCOPY VARCHAR2,
112 x_email_type OUT NOCOPY VARCHAR2,
113 x_status OUT NOCOPY VARCHAR2,
114 x_version OUT NOCOPY NUMBER,
115 x_rt_media_item_id OUT NOCOPY NUMBER,
116 x_rt_interaction_id OUT NOCOPY NUMBER,
117 x_oes_id OUT NOCOPY NUMBER,
118 x_folder_name OUT NOCOPY VARCHAR2,
119 x_message_id OUT NOCOPY NUMBER, -- change to iem_rt_proc_emails.message_id since 11.5.11
120 x_customer_id OUT NOCOPY NUMBER,
121 x_interaction_id OUT NOCOPY NUMBER,
122 x_service_request_id OUT NOCOPY NUMBER,
123 x_mc_parameter_id OUT NOCOPY NUMBER,
124 x_service_request_action OUT NOCOPY VARCHAR2,
125 x_contact_id OUT NOCOPY NUMBER,
126 x_parent_ih_id OUT NOCOPY NUMBER,
127 x_tag_id OUT NOCOPY VARCHAR2,
128 x_edit_mode OUT NOCOPY VARCHAR2,
129 x_lead_id OUT NOCOPY NUMBER,
130 x_resource_id OUT NOCOPY NUMBER,
131 x_relationship_id OUT NOCOPY NUMBER,
132 x_ih_media_id OUT NOCOPY NUMBER
133 );
134
135
136 PROCEDURE getSearchDetails (p_api_version_number IN NUMBER,
137 p_init_msg_list IN VARCHAR2,
138 p_commit IN VARCHAR2,
139 p_agentAccount_id IN NUMBER,
140 p_message_id IN NUMBER,
141 p_folder_name IN VARCHAR2,
142 p_email_type IN VARCHAR2,
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_msg_count OUT NOCOPY NUMBER,
145 x_msg_data OUT NOCOPY VARCHAR2,
146 x_rfc822_message_id OUT NOCOPY VARCHAR2,
147 x_account_id OUT NOCOPY NUMBER,
148 x_account_type OUT NOCOPY VARCHAR2,
149 x_email_type OUT NOCOPY VARCHAR2,
150 x_status OUT NOCOPY VARCHAR2,
151 x_version OUT NOCOPY NUMBER,
152 x_rt_media_item_id OUT NOCOPY NUMBER,
153 x_rt_interaction_id OUT NOCOPY NUMBER,
154 x_oes_id OUT NOCOPY NUMBER,
155 x_folder_name OUT NOCOPY VARCHAR2,
156 x_folder_uid OUT NOCOPY NUMBER,
157 x_customer_id OUT NOCOPY NUMBER,
158 x_route_classification OUT NOCOPY VARCHAR2,
159 x_route_classification_id OUT NOCOPY NUMBER,
160 x_mdt_message_id OUT NOCOPY NUMBER,
161 x_interaction_id OUT NOCOPY NUMBER,
162 x_service_request_id OUT NOCOPY NUMBER,
163 x_mc_parameter_id OUT NOCOPY NUMBER,
164 x_service_request_action OUT NOCOPY VARCHAR,
165 x_contact_id OUT NOCOPY NUMBER,
166 x_parent_interaction_id OUT NOCOPY NUMBER,
167 x_tag_id OUT NOCOPY VARCHAR,
168 x_lead_id OUT NOCOPY NUMBER
169 );
170
171
172 PROCEDURE createMediaDetails (p_api_version_number IN NUMBER,
173 p_init_msg_list IN VARCHAR2,
174 p_commit IN VARCHAR2,
175 p_resource_id IN NUMBER,
176 p_rfc822_message_id IN VARCHAR2,
177 p_folder_name IN VARCHAR2,
178 p_folder_uid IN NUMBER,
179 p_account_id IN NUMBER,
180 p_account_type IN VARCHAR2,
181 p_status IN VARCHAR2,
182 p_customer_id IN NUMBER,
183 p_rt_media_item_id IN NUMBER,
184 p_subject IN VARCHAR2,
185 p_interaction_id IN NUMBER,
186 p_service_request_id IN NUMBER,
187 p_mc_parameter_id IN NUMBER,
188 p_service_request_action IN VARCHAR,
189 p_contact_id IN NUMBER,
190 p_lead_id IN NUMBER,
191 p_parent_ih_id IN NUMBER,
192 p_action_id IN NUMBER,
193 p_relationship_id IN NUMBER,
194 x_return_status OUT NOCOPY VARCHAR2,
195 x_msg_count OUT NOCOPY NUMBER,
196 x_msg_data OUT NOCOPY VARCHAR2,
197 x_version OUT NOCOPY NUMBER,
198 x_rt_media_item_id OUT NOCOPY NUMBER,
199 x_rt_interaction_id OUT NOCOPY NUMBER
200 );
201
202 PROCEDURE updateMediaDetails (p_api_version_number IN NUMBER,
203 p_init_msg_list IN VARCHAR2,
204 p_commit IN VARCHAR2,
205 p_rfc822_message_id IN VARCHAR2,
206 p_folder_name IN VARCHAR2,
207 p_folder_uid IN NUMBER,
208 p_account_id IN NUMBER,
209 p_account_type IN VARCHAR2,
210 p_status IN VARCHAR2,
211 p_customer_id IN NUMBER,
212 p_rt_media_item_id IN NUMBER,
213 p_version IN NUMBER,
214 p_interaction_id IN NUMBER,
215 p_service_request_id IN NUMBER,
216 p_mc_parameter_id IN NUMBER,
217 p_service_request_action IN VARCHAR2,
218 p_contact_id IN NUMBER,
219 p_parent_interaction_id IN NUMBER,
220 p_tag_id IN VARCHAR2,
221 p_edit_mode IN VARCHAR2,
222 p_lead_id IN NUMBER,
223 p_relationship_id IN NUMBER,
224 x_return_status OUT NOCOPY VARCHAR2,
225 x_msg_count OUT NOCOPY NUMBER,
226 x_msg_data OUT NOCOPY VARCHAR2,
227 x_version OUT NOCOPY NUMBER
228 );
229
230 PROCEDURE purgeOutbound (p_api_version_number IN NUMBER,
231 p_init_msg_list IN VARCHAR2,
232 p_commit IN VARCHAR2,
233 x_return_status OUT NOCOPY VARCHAR2,
234 x_msg_count OUT NOCOPY NUMBER,
235 x_msg_data OUT NOCOPY VARCHAR2
236 );
237
238
239 PROCEDURE assignMsg (p_api_version_number IN NUMBER,
240 p_init_msg_list IN VARCHAR2,
241 p_commit IN VARCHAR2,
242 p_message_id IN NUMBER,
243 p_to_resource_id IN NUMBER,
244 p_from_resource_id IN NUMBER,
245 x_return_status OUT NOCOPY VARCHAR2,
246 x_msg_count OUT NOCOPY NUMBER,
247 x_msg_data OUT NOCOPY VARCHAR2,
248 x_rt_media_item_id OUT NOCOPY NUMBER,
249 x_email_account_id OUT NOCOPY NUMBER,
250 x_oes_id OUT NOCOPY NUMBER,
251 x_folder_name OUT NOCOPY VARCHAR2,
252 x_folder_uid OUT NOCOPY NUMBER,
253 x_rt_interaction_id OUT NOCOPY NUMBER,
254 x_customer_id OUT NOCOPY NUMBER,
255 x_rfc822_message_id OUT NOCOPY VARCHAR2,
256 x_route_classification OUT NOCOPY VARCHAR2,
257 x_mdt_message_id OUT NOCOPY NUMBER,
258 x_service_request_id OUT NOCOPY NUMBER,
259 x_contact_id OUT NOCOPY NUMBER,
260 x_lead_id OUT NOCOPY NUMBER,
261 x_relationship_id OUT NOCOPY NUMBER
262 );
263
264 PROCEDURE queueToOutbox (p_api_version_number IN NUMBER,
265 p_init_msg_list IN VARCHAR2,
266 p_commit IN VARCHAR2,
267 p_action IN VARCHAR2,
268 p_action_id IN NUMBER,
269 p_rt_media_item_id IN NUMBER,
270 p_version IN NUMBER,
271 p_customer_id IN NUMBER,
272 p_activity_type_id IN NUMBER,
273 p_outcome_id IN NUMBER,
274 p_result_id IN NUMBER,
275 p_reason_id IN NUMBER,
276 p_to_resource_id IN NUMBER,
280 x_msg_data OUT NOCOPY VARCHAR2
277 p_status IN VARCHAR2,
278 x_return_status OUT NOCOPY VARCHAR2,
279 x_msg_count OUT NOCOPY NUMBER,
281 );
282
283 PROCEDURE getNextOutboxItem (p_api_version_number IN NUMBER,
284 p_init_msg_list IN VARCHAR2,
285 p_commit IN VARCHAR2,
286 p_failed IN VARCHAR2, -- 'T' or 'F'
287 x_return_status OUT NOCOPY VARCHAR2,
288 x_msg_count OUT NOCOPY NUMBER,
289 x_msg_data OUT NOCOPY VARCHAR2,
290 x_rfc822_message_id OUT NOCOPY VARCHAR2,
291 x_account_id OUT NOCOPY NUMBER,
292 x_account_type OUT NOCOPY VARCHAR2,
293 x_email_type OUT NOCOPY VARCHAR2,
294 x_status OUT NOCOPY VARCHAR2,
295 x_version OUT NOCOPY NUMBER,
296 x_rt_media_item_id OUT NOCOPY NUMBER,
297 x_rt_interaction_id OUT NOCOPY NUMBER,
298 x_oes_id OUT NOCOPY NUMBER,
299 x_folder_name OUT NOCOPY VARCHAR2,
300 x_folder_uid OUT NOCOPY NUMBER,
301 x_customer_id OUT NOCOPY NUMBER,
302 x_interaction_id OUT NOCOPY NUMBER,
303 x_service_request_id OUT NOCOPY NUMBER,
304 x_mc_parameter_id OUT NOCOPY NUMBER,
305 x_service_request_action OUT NOCOPY VARCHAR,
306 x_contact_id OUT NOCOPY NUMBER,
307 x_parent_ih_id OUT NOCOPY NUMBER,
308 x_tag_id OUT NOCOPY VARCHAR,
309 x_rt_ih_status OUT NOCOPY VARCHAR,
310 x_action_id OUT NOCOPY NUMBER,
311 x_action_item_id OUT NOCOPY NUMBER,
312 x_result_id OUT NOCOPY NUMBER,
313 x_reason_id OUT NOCOPY NUMBER,
314 x_outcome_id OUT NOCOPY NUMBER,
315 x_to_resource_id OUT NOCOPY NUMBER,
316 x_resource_id OUT NOCOPY NUMBER,
317 x_lead_id OUT NOCOPY NUMBER
318 );
319
320 PROCEDURE createRTItem (p_api_version_number IN NUMBER,
321 p_init_msg_list IN VARCHAR2,
322 p_commit IN VARCHAR2,
323 p_message_id IN NUMBER, -- iem_post_mdts.message_id
324 p_to_resource_id IN NUMBER, -- agent id you want to stamp to iem_post_mdts.agent_id
325 p_from_resource_id IN NUMBER, -- agent id you want to stamp to iem_post_mdts.from_agent_id
326 p_status IN VARCHAR2, -- this will be stamp to iem_post_mdts.mail_item_status
327 p_reason IN VARCHAR2, -- 'O' for auto-route
328 p_interaction_id IN NUMBER,
329 x_return_status OUT NOCOPY VARCHAR2,
330 x_msg_count OUT NOCOPY NUMBER,
331 x_msg_data OUT NOCOPY VARCHAR2,
332 x_rt_media_item_id OUT NOCOPY NUMBER,
333 x_rt_interaction_id OUT NOCOPY NUMBER
334 );
335
336 PROCEDURE isAgentInboxClean(p_api_version_number IN NUMBER,
337 p_init_msg_list IN VARCHAR2,
338 p_commit IN VARCHAR2,
339 p_resource_id IN NUMBER,
340 p_email_account_id IN NUMBER,
341 x_is_clean OUT NOCOPY BOOLEAN,
342 x_return_status OUT NOCOPY VARCHAR2,
343 x_msg_count OUT NOCOPY NUMBER,
344 x_msg_data OUT NOCOPY VARCHAR2
345 );
346
347 PROCEDURE updateOutboundMessageID(p_api_version_number IN NUMBER,
348 p_init_msg_list IN VARCHAR2,
349 p_commit IN VARCHAR2,
350 p_rt_media_item_id IN NUMBER,
351 p_message_id IN NUMBER,
352 x_return_status OUT NOCOPY VARCHAR2,
353 x_msg_count OUT NOCOPY NUMBER,
354 x_msg_data OUT NOCOPY VARCHAR2
355 );
356
357 END IEM_CLIENT_PUB;