1 PACKAGE IEM_ROUTE_CLASS_PVT AUTHID CURRENT_USER AS
2 /* $Header: iemvclxs.pls 120.0 2005/06/02 13:38:07 appldev noship $ */
3
4 --
5 --
6 -- Purpose: Mantain route related operations
7 --
8 -- MODIFICATION HISTORY
9 -- Person Date Comments
10 -- Liang Xia 5/27/2001 added functions
11 -- Liang Xia 6/20/2001 added creating folder on OES when association between
12 -- email account and classifcation is created
13 -- Kris Beagle 01/11/2005 updated for 11i compliance
14 -- --------- ------ ------------------------------------------
15
16
17 type t_routeClassification is table of varchar2(30) index by binary_integer;
18
19 PROCEDURE getRouteClassifications(
20 p_api_version_number IN NUMBER,
21 P_init_msg_list IN VARCHAR2 := null,
22 p_commit IN VARCHAR2 := null,
23
24 emailAccountId IN NUMBER,
25 routeClassifications OUT NOCOPY t_routeClassification,
26 numberOfClassifications OUT NOCOPY NUMBER,
27 x_return_status OUT NOCOPY VARCHAR2,
28 x_msg_count OUT NOCOPY NUMBER,
29 x_msg_data OUT NOCOPY VARCHAR2);
30
31
32
33 PROCEDURE delete_item_batch
34 (p_api_version_number IN NUMBER,
35 P_init_msg_list IN VARCHAR2 := null,
36 p_commit IN VARCHAR2 := null,
37 p_class_ids_tbl IN jtf_varchar2_Table_100,
38 x_return_status OUT NOCOPY VARCHAR2,
39 x_msg_count OUT NOCOPY NUMBER,
40 x_msg_data OUT NOCOPY VARCHAR2);
41
42
43
44
45 -- Start of Comments
46 -- API name : create_item_wrap
47 -- Type : Private
48 -- Function : This procedure is a wrap function to create route involved
49 -- inserting tuple in iem_route_classifications table and iem_route_class_rules table
50 -- Pre-reqs : None.
51 -- Parameters :
52 -- IN
53 -- p_api_version_number IN NUMBER Required
54 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
55 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
56 -- p_class_id IN VARCHAR2 Required
57
58
59 -- p_key_type_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
60 -- p_operator_type_code IN VARCHAR2, Required
61 -- p_value IN VARCHAR2, Required
62
63 -- OUT
64 -- x_return_status OUT VARCHAR2
65 -- x_msg_count OUT NUMBER
66 -- x_msg_data OUT VARCHAR2
67 --
68 -- Version : 1.0
69 -- Notes :
70 --
71 -- End of comments
72
73
74 -- ***********************************************************************
75 PROCEDURE create_item_wrap (
76 p_api_version_number IN NUMBER,
77 p_init_msg_list IN VARCHAR2 := null,
78 p_commit IN VARCHAR2 := null,
79
80 p_class_name IN VARCHAR2,
81 p_class_description IN VARCHAR2:= null,
82 p_class_boolean_type_code IN VARCHAR2,
83 p_proc_name IN VARCHAR2 := null,
84
85 p_rule_key_typecode_tbl IN jtf_varchar2_Table_100,
86 p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100,
87 p_rule_value_tbl IN jtf_varchar2_Table_300,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2 ) ;
91
92
93 -- Start of Comments
94 -- API name : create_item_class
95 -- Type : Private
96 -- Function : This procedure create a route in iem_route_classes table
97 -- Pre-reqs : None.
98 -- Parameters :
99 -- IN
100 -- p_api_version_number IN NUMBER Required
101
102 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
103 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
104
105 -- p_name IN VARCHAR2 Required
106 -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
107 -- p_boolean_type_code IN VARCHAR2, Required
108
109 -- OUT
110 -- x_return_status OUT VARCHAR2
111 -- x_msg_count OUT NUMBER
112 -- x_msg_data OUT VARCHAR2
113 --
114 -- Version : 1.0
115
116 -- Notes :
117 --
118 -- End of comments
119
120 -- **********************************************************
121 PROCEDURE create_item_class (
122 p_api_version_number IN NUMBER,
123 p_init_msg_list IN VARCHAR2 := null,
124 p_commit IN VARCHAR2 := null,
125 p_name IN VARCHAR2,
126 p_description IN VARCHAR2:= null,
127 p_boolean_type_code IN VARCHAR2,
128 p_is_sss IN VARCHAR2 := null,
129 p_proc_name IN VARCHAR2 := null,
130 p_return_type IN VARCHAR2 := null,
131 x_return_status OUT NOCOPY VARCHAR2,
132 x_msg_count OUT NOCOPY NUMBER,
133 x_msg_data OUT NOCOPY VARCHAR2
134 ) ;
135
136
137
138 -- Start of Comments
139 -- API name : create_item_class_rules
140 -- Type : Private
141 -- Function : This procedure create a route in iem_route_rules table
142 -- Pre-reqs : None.
143 -- Parameters :
144 -- IN
145
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_class_id IN VARCHAR2 Required
150 -- p_key_type_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
151
152 -- p_operator_type_code IN VARCHAR2, Required
153 -- p_value IN VARCHAR2, Required
154
155 -- OUT
156 -- x_return_status OUT VARCHAR2
157 -- x_msg_count OUT NUMBER
158 -- x_msg_data OUT VARCHAR2
159
160 --
161 -- Version : 1.0
162 -- Notes :
163 --
164 -- End of comments
165 -- *********************************************************************************************
166
167 PROCEDURE create_item_class_rules (
168 p_api_version_number IN NUMBER,
169 p_init_msg_list IN VARCHAR2 := null,
170 p_commit IN VARCHAR2 := null,
171 p_class_id IN NUMBER,
172 p_key_type_code IN VARCHAR2,
173 p_operator_type_code IN VARCHAR2,
174
175 p_value IN VARCHAR2,
176 x_return_status OUT NOCOPY VARCHAR2,
177 x_msg_count OUT NOCOPY NUMBER,
178 x_msg_data OUT NOCOPY VARCHAR2
179 );
180
181
182 -- Start of Comments
183 -- API name : update_item_wrap
184 -- Type : Private
185 -- Function : This procedure update items in iem_route_classifications and iem_route_class_rules table
186 -- Pre-reqs : None.
187 -- Parameters :
188
189 -- IN
190 -- p_api_version_number IN NUMBER Required
191 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
192 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
193 -- p_class_id IN Optional NUMBER:=FND_API.G_MISS_NUM,
194 -- p_name IN Optional VARCHAR2:=FND_API.G_MISS_CHAR,
195 -- p_ruling_chain IN Optional VARCHAR2:=FND_API.G_MISS_CHAR,
196 -- p_description IN Optional VARCHAR2:=FND_API.G_MISS_CHAR,
197 -- p_update_rule_ids_tbl IN Optional jtf_varchar2_Table_100,
198 -- p_update_rule_keys_tbl IN Optional jtf_varchar2_Table_100,
199 -- p_update_rule_operators_tbl IN Optional jtf_varchar2_Table_100,
200 -- p_update_rule_values_tbl IN Optional jtf_varchar2_Table_300,
201 -- p_new_rule_keys_tbl IN Optional jtf_varchar2_Table_100,
202
203 -- p_new_rule_operators_tbl IN Optional jtf_varchar2_Table_100,
204 -- p_new_rule_values_tbl IN Optional jtf_varchar2_Table_300,
205 -- p_remove_rule_ids_tbl IN Optional jtf_varchar2_Table_100,
206
207 -- OUT
208 -- x_return_status OUT VARCHAR2
209 -- x_msg_count OUT NUMBER
210 -- x_msg_data OUT VARCHAR2
211 --
212 -- Version : 1.0
213 -- Notes :
214 --
215 -- End of comments
216
217 -- *********************************************************************************************
218 PROCEDURE update_item_wrap (p_api_version_number IN NUMBER,
219 p_init_msg_list IN VARCHAR2 := null,
220 p_commit IN VARCHAR2 := null,
221 p_class_id IN NUMBER ,
222 p_name IN VARCHAR2:= null,
223 p_ruling_chain IN VARCHAR2:= null,
224 p_description IN VARCHAR2:= null,
225 p_procedure_name IN VARCHAR2:= null,
226 --below is the data for update
227 p_update_rule_ids_tbl IN jtf_varchar2_Table_100,
228 p_update_rule_keys_tbl IN jtf_varchar2_Table_100,
229 p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
230 p_update_rule_values_tbl IN jtf_varchar2_Table_300,
231 --below is the data for insert
232 p_new_rule_keys_tbl IN jtf_varchar2_Table_100,
233 p_new_rule_operators_tbl IN jtf_varchar2_Table_100,
234 p_new_rule_values_tbl IN jtf_varchar2_Table_300,
235 --below is the data to be removed
236 p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,
237 x_return_status OUT NOCOPY VARCHAR2,
238 x_msg_count OUT NOCOPY NUMBER,
239 x_msg_data OUT NOCOPY VARCHAR2 );
240
241
242
243 -- Start of Comments
244 -- API name : update_item_class
245 -- Type : Private
246 -- Function : This procedure create a classification in iem_route_classifications table
247 -- Pre-reqs : None.
248 -- Parameters :
249 -- IN
250 -- p_api_version_number IN NUMBER Required
251 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
252 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
253 -- p_class_id IN NUMBER
254 -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
255
256 -- p_ruling_chain IN VARCHAR2, Optional Default = FND_API.G_MISS_CHAR
257 -- OUT
258 -- x_return_status OUT VARCHAR2
259 -- x_msg_count OUT NUMBER
260 -- x_msg_data OUT VARCHAR2
261 --
262 -- Version : 1.0
263 -- Notes :
264 --
265 -- End of comments
266 -- *********************************************************************************************
267 PROCEDURE update_item_class (
268 p_api_version_number IN NUMBER,
269 p_init_msg_list IN VARCHAR2 := null,
270 p_commit IN VARCHAR2 := null,
271 p_class_id IN NUMBER ,
272 p_proc_name IN VARCHAR2:= null,
273 p_return_type IN VARCHAR2:= null,
274 p_description IN VARCHAR2:= null,
275 p_ruling_chain IN VARCHAR2:= null,
276 x_return_status OUT NOCOPY VARCHAR2,
277 x_msg_count OUT NOCOPY NUMBER,
278 x_msg_data OUT NOCOPY VARCHAR2
279 ) ;
280
281 -- Start of Comments
282 -- API name : update_item_rule
283
284 -- Type : Private
285 -- Function : This procedure create rule for classification in iem_route_class_rules table
286 -- Pre-reqs : None.
287 -- Parameters :
288
289 -- IN
290 -- p_api_version_number IN NUMBER Required
291 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
292 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
293 -- p_route_class_rule_id IN NUMBER Optional FND_API.G_MISS_NUM,
294 -- p_key_type_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
295 -- p_operator_type_code IN VARCHAR2, Optional VARCHAR2 =FND_API.G_MISS_CHAR,
296 -- p_value IN VARCHAR2, Optional VARCHAR2 =FND_API.G_MISS_CHAR,
297
298
299 -- OUT
300 -- x_return_status OUT VARCHAR2
301 -- x_msg_count OUT NUMBER
302 -- x_msg_data OUT VARCHAR2
303 --
304 -- Version : 1.0
305 -- Notes :
306 --
307 -- End of comments
308 -- *********************************************************************************************
309 PROCEDURE update_item_rule (p_api_version_number IN NUMBER,
310 p_init_msg_list IN VARCHAR2 := null,
311 p_commit IN VARCHAR2 := null,
312
313 p_route_class_rule_id IN NUMBER ,
314 p_key_type_code IN VARCHAR2:= null,
315 p_operator_type_code IN VARCHAR2:=null,
316 p_value IN VARCHAR2:=null,
317
318 x_return_status OUT NOCOPY VARCHAR2,
319 x_msg_count OUT NOCOPY NUMBER,
320 x_msg_data OUT NOCOPY VARCHAR2
321 );
322
323
324
325
326 -- Start of Comments
327 -- API name : create_wrap_acct_rt_class
328 -- Type : Private
329 -- Function : This procedure is wrap function to create assocation between email account and classification
330 -- Pre-reqs : None.
331 -- Parameters :
332
333 -- IN
334 -- p_api_version_number IN NUMBER Required
335 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
336 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
337 -- p_email_account_id IN NUMBER Required
338
339 -- p_enabled_flag IN NUMBER Required
340 -- p_priority IN NUMBER, Required
341
342 -- OUT
343 -- x_return_status OUT VARCHAR2
344 -- x_msg_count OUT NUMBER
345 -- x_msg_data OUT VARCHAR2
346 --
347 -- Version : 1.0
348 -- Notes :
349 --
350 -- End of comments
351 -- *********************************************************************************************
352
356 p_commit IN VARCHAR2 := null,
353 PROCEDURE create_wrap_acct_rt_class (
354 p_api_version_number IN NUMBER,
355 p_init_msg_list IN VARCHAR2 := null,
357 p_email_account_id IN NUMBER,
358 p_class_id IN NUMBER,
359 p_enabled_flag IN VARCHAR2,
360 p_priority IN NUMBER,
361
362 x_return_status OUT NOCOPY VARCHAR2,
363 x_msg_count OUT NOCOPY NUMBER,
364 x_msg_data OUT NOCOPY VARCHAR2
365 ) ;
366
367
368
369 -- Start of Comments
370 -- API name : create_wrap_acct_rt_class
371 -- Type : Private
372 -- Function : This procedure is to insert data in iem_account_route_class
373 -- Pre-reqs : None.
374 -- Parameters :
375
376 -- IN
377 -- p_api_version_number IN NUMBER Required
378 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
379 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
380
381 -- p_email_account_id IN NUMBER Required
382 -- p_class_id IN NUMBER Required
383 -- p_enabled_flag IN NUMBER, Required
384 -- p_priority IN NUMBER, Required
385 -- OUT
386 -- x_return_status OUT VARCHAR2
387 -- x_msg_count OUT NUMBER
388 -- x_msg_data OUT VARCHAR2
389 --
390 -- Version : 1.0
391 -- Notes :
392 --
393 -- End of comments
394
395 -- *********************************************************************************************
396 PROCEDURE create_item_account_class (
397 p_api_version_number IN NUMBER,
398 p_init_msg_list IN VARCHAR2 := null,
399 p_commit IN VARCHAR2 := null,
400 p_email_account_id IN NUMBER,
401 p_class_id IN NUMBER,
402 p_enabled_flag IN VARCHAR2,
403 p_priority IN NUMBER,
404 x_return_status OUT NOCOPY VARCHAR2,
405 x_msg_count OUT NOCOPY NUMBER,
406 x_msg_data OUT NOCOPY VARCHAR2
407
408 );
409
410 -- Start of Comments
411 -- API name : update_wrap_account_class
412 -- Type : Private
413 -- Function : This procedure is to update association between email account and classification
414 -- Pre-reqs : None.
415 -- Parameters :
416
417 -- IN
418 -- p_api_version_number IN NUMBER Required
419 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
420 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
421
422 -- p_email_account_id IN NUMBER Required
423 -- p_class_ids_tbl IN jtf_varchar2_Table_100 Required
424 -- p_upd_enable_flag_tbl IN jtf_varchar2_Table_100 Required
425 -- p_delete_class_ids_tbl IN jtf_varchar2_Table_100 Required
426 -- OUT
427 -- x_return_status OUT VARCHAR2
428 -- x_msg_count OUT NUMBER
429 -- x_msg_data OUT VARCHAR2
430 --
431 -- Version : 1.0
432 -- Notes :
433 --
434 -- End of comments
435
436 -- *********************************************************************************************
437 PROCEDURE update_wrap_account_class (p_api_version_number IN NUMBER,
438 p_init_msg_list IN VARCHAR2 := null,
439 p_commit IN VARCHAR2 := null,
440
441 p_email_account_id IN NUMBER,
442 p_class_ids_tbl IN jtf_varchar2_Table_100,
443 p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,
444 --p_upd_priority_tbl IN jtf_varchar2_Table_100,
445 p_delete_class_ids_tbl IN jtf_varchar2_Table_100,
446 x_return_status OUT NOCOPY VARCHAR2,
447 x_msg_count OUT NOCOPY NUMBER,
448 x_msg_data OUT NOCOPY VARCHAR2
449
450 );
451
452 -- Start of Comments
453 -- API name : update_account_class
454 -- Type : Private
455 -- Function : This procedure is to update data in iem_account_route_class
456 -- Pre-reqs : None.
457 -- Parameters :
458
459
460 -- IN
461 -- p_api_version_number IN NUMBER Required
462 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
463 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
464 -- p_email_account_id IN NUMBER Required
465 -- p_class_id IN NUMBER Required
466 -- p_enabled_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
467 -- p_priority IN VARCHAR2 Optional Default =FND_API.G_MISS_NUM,
468 -- OUT
469 -- x_return_status OUT VARCHAR2
470 -- x_msg_count OUT NUMBER
471 -- x_msg_data OUT VARCHAR2
472 --
473
474 -- Version : 1.0
475 -- Notes :
476 --
480 p_init_msg_list IN VARCHAR2 := null,
477 -- End of comments
478 -- *********************************************************************************************
479 PROCEDURE update_account_class(p_api_version_number IN NUMBER,
481 p_commit IN VARCHAR2 := null,
482 p_class_id IN NUMBER ,
483 p_email_account_id IN NUMBER,
484 p_enabled_flag IN VARCHAR2:= null,
485 p_priority IN VARCHAR2:= null,
486 x_return_status OUT NOCOPY VARCHAR2,
487 x_msg_count OUT NOCOPY NUMBER,
488 x_msg_data OUT NOCOPY VARCHAR2
489 ) ;
490
491 -- Start of Comments
492 -- API name : delete_acct_class_batch
493 -- Type : Private
494 -- Function : This procedure is to delete data in iem_account_route_class
495 -- Pre-reqs : None.
496 -- Parameters :
497
498
499 -- IN
500 -- p_api_version_number IN NUMBER Required
501 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
502 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
503 -- p_class_ids_tbl IN jtf_varchar2_Table_100 Required
504 -- p_account_id IN NUMBER Required
505 -- OUT
506 -- x_return_status OUT VARCHAR2
507 -- x_msg_count OUT NUMBER
508 -- x_msg_data OUT VARCHAR2
509 --
510 -- Version : 1.0
511 -- Notes :
512
513 --
514 -- End of comments
515 -- *********************************************************************************************
516 PROCEDURE delete_acct_class_batch
517 (p_api_version_number IN NUMBER,
518 P_init_msg_list IN VARCHAR2 := NULL,
519
520 p_commit IN VARCHAR2 := NULL,
521 p_class_ids_tbl IN jtf_varchar2_Table_100,
522 p_account_id IN NUMBER,
523 x_return_status OUT NOCOPY VARCHAR2,
524 x_msg_count OUT NOCOPY NUMBER,
525 x_msg_data OUT NOCOPY VARCHAR2);
526
527
528 /*
529 -- ***** Removed for 11i compliancd *****
530 -- Start of Comments
531 -- API name : create_folder
532 -- Type : Private
533 -- Function : This procedure is to create classifcation folder on OES for the email account
534 -- Pre-reqs : None.
535 -- Parameters :
536
537 -- IN
538 -- p_api_version_number IN NUMBER Required
539 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
540 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
541
542 -- p_email_account_id IN NUMBER Required
543 -- p_classification_name IN VARCHAR2 Required
544 -- OUT
545 -- x_return_status OUT VARCHAR2
546 -- x_msg_count OUT NUMBER
547 -- x_msg_data OUT VARCHAR2
548 --
549 -- Version : 1.0
550 -- Notes :
551 --
552 -- End of comments
553 -- *********************************************************************************************
554 PROCEDURE create_folder (
555
556 p_api_version_number IN NUMBER,
557 p_init_msg_list IN VARCHAR2 := null,
558 p_commit IN VARCHAR2 := null,
559 p_email_account_id IN NUMBER,
560 p_classification_name IN VARCHAR2,
561 x_return_status OUT NOCOPY VARCHAR2,
562 x_msg_count OUT NOCOPY NUMBER,
563 x_msg_data OUT NOCOPY VARCHAR2
564 ) ;
565
566 -- Start of Comments
567 -- API name : delete_folder
568 -- Type : Private
569
570 -- Function : This procedure is to delete classifcation folder on OES
571 -- Pre-reqs : None.
572 -- Parameters :
573
574 -- IN
575 -- p_api_version_number IN NUMBER Required
576 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
577 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
578 -- p_email_account_id IN NUMBER Required
579 -- p_class_id IN NUMBER Required
580 -- OUT
581 -- x_return_status OUT VARCHAR2
582 -- x_msg_count OUT NUMBER
583
584 -- x_msg_data OUT VARCHAR2
585 --
586 -- Version : 1.0
587 -- Notes :
588 --
589 -- End of comments
590 -- *********************************************************************************************
591 */
592 /*
593 -- ***** Removed for 11i compliance *****
594 PROCEDURE delete_folder (
595 p_api_version_number IN NUMBER,
596 p_init_msg_list IN VARCHAR2 := null,
597 p_commit IN VARCHAR2 := null,
598 p_email_account_id IN NUMBER,
599 p_class_id IN NUMBER,
600 x_return_status OUT NOCOPY VARCHAR2,
601 x_msg_count OUT NOCOPY NUMBER,
602 x_msg_data OUT NOCOPY VARCHAR2
603 );
604
605 -- Start of Comments
609 -- with the classifcation
606 -- API name : delete_folder_on_classId
607 -- Type : Private
608 -- Function : This procedure is delete classifcation folder for all email account which associated
610 -- Pre-reqs : None.
611 -- Parameters :
612
613
614 -- IN
615 -- p_api_version_number IN NUMBER Required
616 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
617 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
618 -- p_classification_id IN NUMBER Required
619 -- OUT
620 -- x_return_status OUT VARCHAR2
621 -- x_msg_count OUT NUMBER
622 -- x_msg_data OUT VARCHAR2
623 --
624 -- Version : 1.0
625 -- Notes :
626 --
627
628 -- End of comments
629 -- *********************************************************************************************
630 */
631 /*
632 -- ***** Removed for 11i compliance *****
633 PROCEDURE delete_folder_on_classId
634 (p_api_version_number IN NUMBER,
635 P_init_msg_list IN VARCHAR2 := null,
636 p_commit IN VARCHAR2 := null,
637 p_classification_id IN NUMBER,
638 x_return_status OUT NOCOPY VARCHAR2,
639 x_msg_count OUT NOCOPY NUMBER,
640 x_msg_data OUT NOCOPY VARCHAR2);
641
642 -- Start of Comments
643 -- API name : delete_association_on_acctId
644
645 -- Type : Private
646 -- Function : This procedure is delete association of the email account with classifcations,
647 -- including delete classification folders and associations
648 -- Pre-reqs : None.
649 -- Parameters :
650
651 -- IN
652 -- p_api_version_number IN NUMBER Required
653 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
654 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
655 -- p_email_account_id IN NUMBER Required
656 -- OUT
657 -- x_return_status OUT VARCHAR2
658
659 -- x_msg_count OUT NUMBER
660 -- x_msg_data OUT VARCHAR2
661 --
662 -- Version : 1.0
663 -- Notes :
664 --
665 -- End of comments
666 -- *********************************************************************************************
667 */
668 PROCEDURE delete_association_on_acctId
669 (p_api_version_number IN NUMBER,
670 P_init_msg_list IN VARCHAR2 := null,
671 p_commit IN VARCHAR2 := null,
672 p_email_account_id IN NUMBER,
673
674 x_return_status OUT NOCOPY VARCHAR2,
675 x_msg_count OUT NOCOPY NUMBER,
676 x_msg_data OUT NOCOPY VARCHAR2);
677
678 END IEM_ROUTE_CLASS_PVT; -- Package Specification IEM_ROUTE_CLASS_PVT
679