[Home] [Help]
PACKAGE: APPS.IEM_ROUTE_PVT
Source
1 PACKAGE IEM_ROUTE_PVT AUTHID CURRENT_USER AS
2 /* $Header: iemvrous.pls 115.9 2002/12/04 20:20:38 liangxia noship $ */
3 --
4 --
5 -- Purpose: Mantain route related operations
6 --
7 -- MODIFICATION HISTORY
8 -- Person Date Comments
9 -- Liang Xia 4/24/2001 Created
10 -- Liang Xia 6/7/2001 added checking duplication on IEM_ROUTES.name for PROCEDURE
11 -- create_item_routes and update_item_route
12 -- added updating priority in IEM_ACCOUNT_ROUTES for delete_item_batch
13 -- Liang Xia 6/7/2002 added validation for dynamic Route
14 -- Liang Xia 11/6/2002 release the validation for ALL_EMAILS and fixed part of "No MISS.." GSCC warning.
15 -- Liang Xia 12/2/2002 Fixed PLSQL standard: "No MISS.." "NOCOPY" GSCC warning.
16 -- --------- ------ ------------------------------------------
17
18
19 -- Start of Comments
20 -- API name : delete_item_batch
21 -- Type : Private
22 -- Function : This procedure delete a batch of records in the table IEM_ROUTES
23 -- Pre-reqs : None.
24 -- Parameters :
25
26 -- IN
27 -- p_api_version_number IN NUMBER Required
28
29 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
30 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
31 -- p_route_ids_tbl IN jtf_varchar2_Table_100 Required
32 -- p_account_name IN VARCHAR2 :=FND_API.G_MISS_CHAR,
33
34 -- OUT
35 -- x_return_status OUT VARCHAR2
36 -- x_msg_count OUT NUMBER
37 -- x_msg_data OUT VARCHAR2
38 --
39 -- Version : 1.0
40
41 -- Notes :
42
43 --
44 -- End of comments
45 -- ***************************************************************************
46 /* $Header: iemvrous.pls 115.9 2002/12/04 20:20:38 liangxia noship $ */
47 PROCEDURE delete_item_batch
48 (p_api_version_number IN NUMBER,
49 P_init_msg_list IN VARCHAR2 := null,
50 p_commit IN VARCHAR2 := null,
51 p_route_ids_tbl IN jtf_varchar2_Table_100,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2);
55
56
57
58 -- Start of Comments
59 -- API name : delete_acct_route_by_acct
60 -- Type : Private
61 -- Function : This procedure delete records in the table IEM_ACCOUT_ROUTES based on email_account_id
62 -- Pre-reqs : None.
63 -- Parameters :
64
65 -- IN
66 -- p_api_version_number IN NUMBER Required
67 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
68 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
69 -- p_email_account_id IN NUMBER Required
70
71
72 -- OUT
73 -- x_return_status OUT VARCHAR2
74 -- x_msg_count OUT NUMBER
75 -- x_msg_data OUT VARCHAR2
76 --
77 -- Version : 1.0
78
79 -- Notes :
80 --
81 -- End of comments
82 -- ***************************************************************************
83 PROCEDURE delete_acct_route_by_acct
84 (p_api_version_number IN NUMBER,
85 P_init_msg_list IN VARCHAR2 := null,
86 p_commit IN VARCHAR2 := null,
87 p_email_account_id IN NUMBER,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2);
91
92
93
94 -- transfer display date format to canonical date format
95 -- ***************************************************************************
96
97 FUNCTION displayDT_to_canonical ( displayDT IN VARCHAR2 )return varchar2;
98
99 -- ***************************************************************************
100 -- Start of Comments
101 -- API name : create_item_wrap
102
103 -- Type : Private
104 -- Function : This procedure is a wrap function to create route involved
105 -- inserting tuple in iem_routes table and iem_route_rules table
106 -- Pre-reqs : None.
107 -- Parameters :
108 -- IN
109 -- p_api_version_number IN NUMBER Required
110
111 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
112 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
113 -- p_route_name IN VARCHAR2 Required
114 -- p_route_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
115 -- p_route_boolean_type_code IN jtf_varchar2_Table_100 Optional Default = jtf_varchar2_Table_100
116 -- Post 11.5.7 MP-O For static route: AND, OR
117 -- For dynamic route: DYNAMIC
118
119 -- p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100 Optional Default = jtf_varchar2_Table_100
120
121 -- p_rule_value_tbl IN jtf_varchar2_Table_300 Optional Default = jtf_varchar2_Table_300
122
123 -- OUT
124 -- x_return_status OUT VARCHAR2
125 -- x_msg_count OUT NUMBER
126 -- x_msg_data OUT VARCHAR2
127
128 --
129 -- Version : 1.0
130 -- Notes :
131 --
132 -- End of comments
133 -- ***********************************************************************
134 PROCEDURE create_item_wrap (
135
136 p_api_version_number IN NUMBER,
137 p_init_msg_list IN VARCHAR2 := null,
138 p_commit IN VARCHAR2 := null,
139 p_route_name IN VARCHAR2,
140 p_route_description IN VARCHAR2:= null,
141 p_route_boolean_type_code IN VARCHAR2,
142 p_proc_name IN VARCHAR2 := null,
143 p_all_email IN VARCHAR2:= null,
144 p_rule_key_typecode_tbl IN jtf_varchar2_Table_100,
145 p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100,
146 p_rule_value_tbl IN jtf_varchar2_Table_300,
147 x_return_status OUT NOCOPY VARCHAR2,
148 x_msg_count OUT NOCOPY NUMBER,
149 x_msg_data OUT NOCOPY VARCHAR2 );
150
151
152
153
154
155 -- ************************************************************************
156
157 -- Start of Comments
158 -- API name : create_item_routes
159 -- Type : Private
160 -- Function : This procedure create a route in iem_routes table
161 -- Pre-reqs : None.
162 -- Parameters :
163 -- IN
164 -- p_api_version_number IN NUMBER Required
165
166 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
167 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
168 -- p_name IN VARCHAR2 Required
169 -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
170
171 -- p_boolean_type_code IN VARCHAR2, Required
172 -- p_proc_name IN VARCHAR2 FND_API.G_MISS_CHAR,
173 -- 11.5.7(MP-O) For Dynamic Route
174 -- OUT
175 -- x_return_status OUT VARCHAR2
176 -- x_msg_count OUT NUMBER
177 -- x_msg_data OUT VARCHAR2
178 --
179 -- Version : 1.0
180 -- Notes :
181
182 --
183 -- End of comments
184 -- **********************************************************
185
186 PROCEDURE create_item_routes (
187 p_api_version_number IN NUMBER,
188 p_init_msg_list IN VARCHAR2 := null,
189 p_commit IN VARCHAR2 := null,
190 p_name IN VARCHAR2,
191 p_description IN VARCHAR2:= null,
192 p_boolean_type_code IN VARCHAR2,
193 p_proc_name IN VARCHAR2 := null,
194 p_all_email IN VARCHAR2 := null,
195 p_return_type IN VARCHAR2 := null,
196 x_return_status OUT NOCOPY VARCHAR2,
197 x_msg_count OUT NOCOPY NUMBER,
198 x_msg_data OUT NOCOPY VARCHAR2
199 );
200
201
202
203
204 -- ************************************************************************
205 -- Start of Comments
206 -- API name : create_item_route_rules
207 -- Type : Private
208 -- Function : This procedure create a route in iem_route_rules table
209 -- Pre-reqs : None.
210 -- Parameters :
211
212 -- IN
213 -- p_api_version_number IN NUMBER Required
214 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
215
216 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
217 -- p_route_id IN VARCHAR2 Required
218 -- p_key_type_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
219 -- p_operator_type_code IN VARCHAR2, Required
220 -- p_value IN VARCHAR2, Required
221
222 -- OUT
223 -- x_return_status OUT VARCHAR2
224 -- x_msg_count OUT NUMBER
225 -- x_msg_data OUT VARCHAR2
226
227 --
228 -- Version : 1.0
229
230 -- Notes :
231 --
232 -- End of comments
233 -- *********************************************************************************************
234 PROCEDURE create_item_route_rules (
235 p_api_version_number IN NUMBER,
236 p_init_msg_list IN VARCHAR2 := null,
237 p_commit IN VARCHAR2 := null,
238 p_route_id IN NUMBER,
239 p_key_type_code IN VARCHAR2,
240 p_operator_type_code IN VARCHAR2,
241 p_value IN VARCHAR2,
242 x_return_status OUT NOCOPY VARCHAR2,
243 x_msg_count OUT NOCOPY NUMBER,
244 x_msg_data OUT NOCOPY VARCHAR2
245 );
246
247
248
249 -- ************************************************************************
250 -- Start of Comments
251 -- API name : create_item_accout_routes
252 -- Type : Private
253
254 -- Function : This procedure create a tuple in iem_account_routes table
255
256 -- Pre-reqs : None.
257 -- Parameters :
258 -- IN
259 -- p_api_version_number IN NUMBER Required
260 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
261 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
262 -- p_email_account_id IN VARCHAR2 Required
263 -- p_route_id IN VARCHAR2 Required
264 -- p_destination_group_id IN VARCHAR2, Required
265 -- p_default_grp_id IN VARCHAR2, Required
266 -- p_enabled_flag IN VARCHAR2, Required
267 -- p_priority IN VARCHAR2, Required
268
269
270 -- OUT
271 -- x_return_status OUT VARCHAR2
272 -- x_msg_count OUT NUMBER
273 -- x_msg_data OUT VARCHAR2
274 --
275 -- Version : 1.0
276 -- Notes :
277 --
278 -- End of comments
279 -- **********************************************************
280 PROCEDURE create_item_account_routes (
281 p_api_version_number IN NUMBER,
282 p_init_msg_list IN VARCHAR2 := null,
283 p_commit IN VARCHAR2 := null,
284 p_email_account_id IN NUMBER,
285 p_route_id IN NUMBER,
286 p_destination_group_id IN NUMBER,
287 p_default_grp_id IN NUMBER,
288 p_enabled_flag IN VARCHAR2,
289 p_priority IN NUMBER,
290 x_return_status OUT NOCOPY VARCHAR2,
291 x_msg_count OUT NOCOPY NUMBER,
292 x_msg_data OUT NOCOPY VARCHAR2
293 );
294
295
296
297 -- ************************************************************************
298 -- Start of Comments
299 -- API name : update_item_wrap
300 -- Type : Private
301 -- Function : This procedure is a update wraper, involved updating iem_routes table,
302 -- updating iem_route_rules table, insert new item into iem_route_rules table, deleting
303 -- from iem_route_rules table.
304 -- Pre-reqs : None.
305 -- Parameters :
306 -- IN
307 -- p_api_version_number IN NUMBER Required
308 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
309
310
311 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
312 -- p_route_id IN NUMBER:=FND_API.G_MISS_NUM,
313 -- p_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
314 -- p_ruling_chain IN VARCHAR2:=FND_API.G_MISS_CHAR,
315 -- p_description IN VARCHAR2:=FND_API.G_MISS_CHAR,
316 -- p_update_rule_ids_tbl IN jtf_varchar2_Table_100,
317 -- p_update_rule_keys_tbl IN jtf_varchar2_Table_100,
318 -- p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
319 -- p_update_rule_values_tbl IN jtf_varchar2_Table_300,
320 -- p_new_rule_keys_tbl IN jtf_varchar2_Table_100,
321 -- p_new_rule_operators_tbl IN jtf_varchar2_Table_100,
322 -- p_new_rule_values_tbl IN jtf_varchar2_Table_300,
323
324 -- p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,
325
326
327 -- OUT
328 -- x_return_status OUT VARCHAR2
329 -- x_msg_count OUT NUMBER
330 -- x_msg_data OUT VARCHAR2
331 --
332 -- Version : 1.0
333 -- Notes :
334 --
335 -- End of comments
336 -- **********************************************************
337
338 PROCEDURE update_item_wrap (p_api_version_number IN NUMBER,
339 p_init_msg_list IN VARCHAR2 := null,
340 p_commit IN VARCHAR2 := null,
341 p_route_id IN NUMBER,
342 p_name IN VARCHAR2:= null,
343 p_ruling_chain IN VARCHAR2:= null,
344 p_description IN VARCHAR2:= null,
345 p_procedure_name IN VARCHAR2:= null,
346 p_all_emails IN VARCHAR2:= null,
347 --below is the data for update
348 p_update_rule_ids_tbl IN jtf_varchar2_Table_100,
349 p_update_rule_keys_tbl IN jtf_varchar2_Table_100,
350 p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
351
352 p_update_rule_values_tbl IN jtf_varchar2_Table_300,
353 -- below is the data for insert
354 p_new_rule_keys_tbl IN jtf_varchar2_Table_100,
355
356 p_new_rule_operators_tbl IN jtf_varchar2_Table_100,
357 p_new_rule_values_tbl IN jtf_varchar2_Table_300,
358 --below is the data to be removed
362 x_msg_count OUT NOCOPY NUMBER,
359 p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,
360
361 x_return_status OUT NOCOPY VARCHAR2,
363 x_msg_data OUT NOCOPY VARCHAR2 );
364
365
366
367
368 -- ************************************************************************
369 -- Start of Comments
370 -- API name : update_item_route
371 -- Type : Private
372 -- Function : This procedure update route in iem_routes table
373 -- Pre-reqs : None.
374 -- Parameters :
375 -- IN
376 -- p_api_version_number IN NUMBER Required
377 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
378 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
379
380 -- p_route_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
381 -- p_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
382 -- p_description IN VARCHAR2, Optional Default = FND_API.G_MISS_CHAR
383
384 -- p_ruling_chain IN VARCHAR2, Optional Default = FND_API.G_MISS_CHAR
385 -- p_proc_name IN VARCHAR2, Optional Default = FND_API.G_MISS_CHAR
386 -- this is procedure name for dynamic route ( 11.5.7)
387 -- OUT
388 -- x_return_status OUT VARCHAR2
389 -- x_msg_count OUT NUMBER
390 -- x_msg_data OUT VARCHAR2
391 --
392 -- Version : 1.0
393 -- Notes :
394
395 --
396 -- End of comments
397 -- **********************************************************
398 PROCEDURE update_item_route (
399 p_api_version_number IN NUMBER,
400 p_init_msg_list IN VARCHAR2 := null,
401 p_commit IN VARCHAR2 := null,
402 p_route_id IN NUMBER,
403 p_name IN VARCHAR2:= null,
404 p_description IN VARCHAR2:= null,
405 p_all_emails IN VARCHAR2:= null,
406 p_proc_name IN VARCHAR2:= null,
407 p_return_type IN VARCHAR2:= null,
408 p_ruling_chain IN VARCHAR2:= null,
409 x_return_status OUT NOCOPY VARCHAR2,
410 x_msg_count OUT NOCOPY NUMBER,
411 x_msg_data OUT NOCOPY VARCHAR2
412 ) ;
413
414
415
416
417 -- ************************************************************************
418 -- Start of Comments
419 -- API name : update_item_rule
420 -- Type : Private
421 -- Function : This procedure update route in iem_routes table
422 -- Pre-reqs : None.
423
424 -- Parameters :
425 -- IN
426 -- p_api_version_number IN NUMBER Required
427 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
428 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
429
430 -- p_key_type_code IN NUMBER Optional Default = FND_API.G_MISS_NUM
431 -- p_key_type_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
432 -- p_operator_type_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
433 -- p_value IN VARCHAR2, Optional Default = FND_API.G_MISS_CHAR
434
435 -- OUT
436 -- x_return_status OUT VARCHAR2
437
438 -- x_msg_count OUT NUMBER
439 -- x_msg_data OUT VARCHAR2
440 --
441 -- Version : 1.0
442 -- Notes :
443 --
444
445 -- End of comments
446 -- **********************************************************
447 PROCEDURE update_item_rule
448 (p_api_version_number IN NUMBER,
449 p_init_msg_list IN VARCHAR2 := null,
450 p_commit IN VARCHAR2 := null,
451 p_route_rule_id IN NUMBER := null,
452 p_key_type_code IN VARCHAR2:= null,
453 p_operator_type_code IN VARCHAR2:= null,
454 p_value IN VARCHAR2:= null,
455 x_return_status OUT NOCOPY VARCHAR2,
456 x_msg_count OUT NOCOPY NUMBER,
457 x_msg_data OUT NOCOPY VARCHAR2
458 ) ;
459
460
461
462
463 -- ************************************************************************
464 -- Start of Comments
465 -- API name : create_wrap_account_routes
466 -- Type : Private
467 -- Function : This procedure is a wrap function to create account_route in iem_account_routes table
468 -- Pre-reqs : None.
469 -- Parameters :
470
471 -- IN
472 -- p_api_version_number IN NUMBER Required
473 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
474 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
475 -- p_email_account_id IN NUMBER Required
476
480 -- p_enabled_flag IN VARCHAR2 Required
477 -- p_route_id IN NUMBER Requred
478 -- p_destination_group_id IN NUMBER, Required
479 -- p_default_grp_id IN NUMBER, Required
481 -- p_priority IN NUMBER Required
482
483 -- OUT
484 -- x_return_status OUT VARCHAR2
485
486 -- x_msg_count OUT NUMBER
487 -- x_msg_data OUT VARCHAR2
488 --
489 -- Version : 1.0
490
491 -- Notes :
492 --
493 -- End of comments
494 -- *********************************************************************************************
495 PROCEDURE create_wrap_account_routes (
496 p_api_version_number IN NUMBER,
497 p_init_msg_list IN VARCHAR2 := null,
498 p_commit IN VARCHAR2 := null,
499 p_email_account_id IN NUMBER,
500 p_route_id IN NUMBER,
501 p_destination_group_id IN NUMBER,
502 p_default_grp_id IN NUMBER,
503 p_enabled_flag IN VARCHAR2,
504 p_priority IN NUMBER,
505 x_return_status OUT NOCOPY VARCHAR2,
506 x_msg_count OUT NOCOPY NUMBER,
507 x_msg_data OUT NOCOPY VARCHAR2
508 );
509
510
511 -- ************************************************************************
512 -- Start of Comments
513 -- API name : update_account_routes
514 -- Type : Private
515
516 -- Function : This procedure update iem_account_routes table
517 -- Pre-reqs : None.
518 -- Parameters :
519 -- IN
520 -- p_api_version_number IN NUMBER Required
521 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
522 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
523 -- p_route_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
524 -- p_email_account_id IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
525
526 -- p_default_grp_id IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
527 -- p_enabled_flag IN VARCHAR2, Optional Default = FND_API.G_MISS_CHAR
528 -- p_priority IN NUMBER Optional Default = FND_API.G_MISS_NUM
529
530 -- OUT
531 -- x_return_status OUT VARCHAR2
532 -- x_msg_count OUT NUMBER
533 -- x_msg_data OUT VARCHAR2
534 --
535 -- Version : 1.0
536 -- Notes :
537 --
538 -- End of comments
539 -- **********************************************************
540
541 PROCEDURE update_account_routes(p_api_version_number IN NUMBER,
542 p_init_msg_list IN VARCHAR2 := null,
543 p_commit IN VARCHAR2 := null,
544 p_route_id IN NUMBER,
545 p_email_account_id IN NUMBER,
546 p_destination_grp_id IN VARCHAR2:= null,
547 p_default_grp_id IN VARCHAR2:= null,
548 p_enabled_flag IN VARCHAR2:= null,
549 p_priority IN VARCHAR2:= null,
550 x_return_status OUT NOCOPY VARCHAR2,
551 x_msg_count OUT NOCOPY NUMBER,
552 x_msg_data OUT NOCOPY VARCHAR2
553 );
554
555
556
557
558 -- ************************************************************************
559 -- Start of Comments
560 -- API name : delete_acct_route_batch
561 -- Type : Private
562 -- Function : This procedure delete items from iem_account_routes table
563 -- Pre-reqs : None.
564 -- Parameters :
565 -- IN
566 -- p_api_version_number IN NUMBER Required
567 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
568
569 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
570
571 -- p_route_ids_tbl IN jtf_varchar2_Table_100,
572 -- OUT
573 -- x_return_status OUT VARCHAR2
574 -- x_msg_count OUT NUMBER
575 -- x_msg_data OUT VARCHAR2
576 --
577 -- Version : 1.0
578 -- Notes :
579 --
580 -- End of comments
581 -- **********************************************************
582 PROCEDURE delete_acct_route_batch
583 (p_api_version_number IN NUMBER,
584 P_init_msg_list IN VARCHAR2 := null,
585 p_commit IN VARCHAR2 := null,
586 p_route_ids_tbl IN jtf_varchar2_Table_100,
587 p_account_id IN NUMBER,
588 x_return_status OUT NOCOPY VARCHAR2,
589 x_msg_count OUT NOCOPY NUMBER,
590 x_msg_data OUT NOCOPY VARCHAR2);
591
592
593 -- ************************************************************************
594 -- Start of Comments
595
596
597 -- API name : update_wrap_account_routes
601 -- Pre-reqs : None.
598 -- Type : Private
599 -- Function : This procedure is a wrap function to update account_route in iem_account_routes table
600 -- involved in update iem_account_routes table and delete from iem_account_routes table
602 -- Parameters :
603 -- IN
604 -- p_api_version_number IN NUMBER Required
605 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
606 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
607 -- p_email_account_id IN NUMBER Required
608 -- p_route_id IN NUMBER Requred
609 -- p_destination_group_id IN NUMBER, Required
610
611
612 -- p_default_grp_id IN NUMBER, Required
613 -- p_enabled_flag IN VARCHAR2 Required
614 -- p_priority IN NUMBER Required
615
616 -- OUT
617 -- x_return_status OUT VARCHAR2
618 -- x_msg_count OUT NUMBER
619 -- x_msg_data OUT VARCHAR2
620 --
621 -- Version : 1.0
622 -- Notes :
623 --
624
625 -- End of comments
626
627 -- *********************************************************************************************
628 PROCEDURE update_wrap_account_routes
629 (p_api_version_number IN NUMBER,
630 p_init_msg_list IN VARCHAR2 := null,
631 p_commit IN VARCHAR2 := null,
632 p_email_account_id IN NUMBER,
633 p_route_ids_tbl IN jtf_varchar2_Table_100,
634 p_upd_dest_ids_tbl IN jtf_varchar2_Table_100,
635
636 p_upd_default_ids_tbl IN jtf_varchar2_Table_100,
637 p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,
638 --p_upd_priority_tbl IN jtf_varchar2_Table_100,
639
640 p_delete_route_ids_tbl IN jtf_varchar2_Table_100,
641
642 x_return_status OUT NOCOPY VARCHAR2,
643 x_msg_count OUT NOCOPY NUMBER,
644 x_msg_data OUT NOCOPY VARCHAR2
645 ) ;
646 END IEM_ROUTE_PVT;