1 package IEM_Mailpreprocwf_PUB AUTHID CURRENT_USER as
2 /* $Header: iempwfps.pls 115.11 2002/12/05 19:39:06 sboorela shipped $*/
3 G_STAT varchar2(1):='S';
4
5 -- PROCEDURE IEM_STARTPROCESS
6 --
7 -- Starts The Workflow Application
8 --
9 -- IN
10 -- Workflowprocess - Name Of The Process
11 -- Item_Type - type of the current item
12 -- ItemKey Itemkey for the workflow process
13 -- p_itemuserkey itemuserkey to identify the wf status
14 -- p_msgid Message Id
15 -- p_msgsize Message Size
16 -- p_sender Sender name
17 -- p_username User name
18 -- p_domain Domain
19 -- p_priority Message priority
20 -- p_msg_status Message status
21 -- OUT
22 -- None
23 -- result
24 -- - COMPLETE[:<result>]
25 -- activity has completed with the indicated result
26 -- - WAITING
27 -- activity is waiting for additional transitions
28 -- - DEFERED
29 -- execution should be defered to background
30 -- - NOTIFIED[:<notification_id>:<assigned_user>]
31 -- activity has notified an external entity that this
32 -- step must be performed. A call to wf_engine.CompleteActivty
33 -- will signal when this step is complete. Optional
34 -- return of notification ID and assigned user.
35 -- - ERROR[:<error_code>]
36 -- function encountered an error.
37
38 PROCEDURE IEM_STARTPROCESS(
39 WorkflowProcess IN VARCHAR2,
40 ItemType in VARCHAR2 ,
41 ItemKey in number,
42 p_itemuserkey in varchar2,
43 p_msgid in varchar2,
44 p_msgsize in number,
45 p_sender in varchar2,
46 p_username in varchar2,
47 p_domain in varchar2,
48 p_priority in varchar2,
49 p_msg_status in varchar2,
50 p_email_account_id in number,
51 p_flow in varchar2,
52 x_outval out nocopy varchar2,
53 x_process OUT NOCOPY varchar2);
54
55
56 -- PROCEDURE IEM_WF_CHKAUTH
57 --
58 -- Check The User Authentication
59 --
60 -- IN
61 -- itemtype - type of the current item
62 -- itemkey - key of the current item
63 -- actid - process activity instance id
64 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
65 -- OUT
66 -- None
67 -- result
68 -- - COMPLETE[:<result>]
69 -- activity has completed with the indicated result
70 -- - WAITING
71 -- activity is waiting for additional transitions
72 -- - DEFERED
73 -- execution should be defered to background
74 -- - NOTIFIED[:<notification_id>:<assigned_user>]
75 -- activity has notified an external entity that this
76 -- step must be performed. A call to wf_engine.CompleteActivty
77 -- will signal when this step is complete. Optional
78 -- return of notification ID and assigned user.
79 -- - ERROR[:<error_code>]
80 -- function encountered an error.
81
82 procedure IEM_WF_CHKAUTH(
83 itemtype in varchar2,
84 itemkey in varchar2,
85 actid in number,
86 funcmode in varchar2,
87 result in out nocopy varchar2);
88
89 -- PROCEDURE IEM_WF_MSGHDR
90 --
91 -- Process The Message To get the standard Header and populate the attribute
92 --
93 -- IN
94 -- itemtype - type of the current item
95 -- itemkey - key of the current item
96 -- actid - process activity instance id
97 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
98 -- OUT
99 -- None
100 -- result
101 -- - COMPLETE[:<result>]
102 -- activity has completed with the indicated result
103 -- - WAITING
104 -- activity is waiting for additional transitions
105 -- - DEFERED
106 -- execution should be defered to background
107 -- - NOTIFIED[:<notification_id>:<assigned_user>]
108 -- activity has notified an external entity that this
109 -- step must be performed. A call to wf_engine.CompleteActivty
110 -- will signal when this step is complete. Optional
111 -- return of notification ID and assigned user.
112 -- - ERROR[:<error_code>]
113 -- function encountered an error.
114
115 procedure IEM_WF_MSGHDR(
116 itemtype in varchar2,
117 itemkey in varchar2,
118 actid in number,
119 funcmode in varchar2,
120 result in out nocopy varchar2);
121
122 -- PROCEDURE IEM_AUTH_FAILED
123 --
124 -- Indicate That User Authentication Is Failed
125 --
126 -- IN
127 -- itemtype - type of the current item
128 -- itemkey - key of the current item
129 -- actid - process activity instance id
130 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
131 -- OUT
132 -- None
133 -- result
134 -- - COMPLETE[:<result>]
135 -- activity has completed with the indicated result
136 -- - WAITING
137 -- activity is waiting for additional transitions
138 -- - DEFERED
139 -- execution should be defered to background
140 -- - NOTIFIED[:<notification_id>:<assigned_user>]
141 -- activity has notified an external entity that this
142 -- step must be performed. A call to wf_engine.CompleteActivty
143 -- will signal when this step is complete. Optional
144 -- return of notification ID and assigned user.
145 -- - ERROR[:<error_code>]
146 -- function encountered an error.
147
148 procedure IEM_WF_AUTHFAILED(
149 itemtype in varchar2,
150 itemkey in varchar2,
151 actid in number,
152 funcmode in varchar2,
153 result in out nocopy varchar2);
154
155 -- PROCEDURE IEM_WF_CHKUSERGRP
156 --
157 -- Check The User Group and Branch into the corresponding activity.
158 --
159 -- IN
160 -- itemtype - type of the current item
161 -- itemkey - key of the current item
162 -- actid - process activity instance id
163 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
164 -- OUT
165 -- None
166 -- result
167 -- - COMPLETE[:<result>]
168 -- activity has completed with the indicated result
169 -- - WAITING
170 -- activity is waiting for additional transitions
171 -- - DEFERED
172 -- execution should be defered to background
173 -- - NOTIFIED[:<notification_id>:<assigned_user>]
174 -- activity has notified an external entity that this
175 -- step must be performed. A call to wf_engine.CompleteActivty
176 -- will signal when this step is complete. Optional
177 -- return of notification ID and assigned user.
178 -- - ERROR[:<error_code>]
179 -- function encountered an error.
180
181 procedure IEM_WF_CHKUSERGRP(
182 itemtype in varchar2,
183 itemkey in varchar2,
184 actid in number,
185 funcmode in varchar2,
186 result in out nocopy varchar2);
187
188 -- PROCEDURE IEM_WF_GETEXTHEADER
189 --
190 -- Perform The Extended Header Processing
191 --
192 -- IN
193 -- itemtype - type of the current item
194 -- itemkey - key of the current item
195 -- actid - process activity instance id
196 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
197 -- OUT
198 -- None
199 -- result
200 -- - COMPLETE[:<result>]
201 -- activity has completed with the indicated result
202 -- - WAITING
203 -- activity is waiting for additional transitions
204 -- - DEFERED
205 -- execution should be defered to background
206 -- - NOTIFIED[:<notification_id>:<assigned_user>]
207 -- activity has notified an external entity that this
208 -- step must be performed. A call to wf_engine.CompleteActivty
209 -- will signal when this step is complete. Optional
210 -- return of notification ID and assigned user.
211 -- - ERROR[:<error_code>]
212 -- function encountered an error.
213
214 procedure IEM_WF_GETEXTHEADER(
215 itemtype in varchar2,
216 itemkey in varchar2,
217 actid in number,
218 funcmode in varchar2,
219 result in out nocopy varchar2);
220
221 -- PROCEDURE IEM_WF_GETPART
222 --
223 -- Get The Message Part.
224
225 -- IN
226 -- itemtype - type of the current item
227 -- itemkey - key of the current item
228 -- actid - process activity instance id
229 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
230 -- OUT
231 -- None
232 -- result
233 -- - COMPLETE[:<result>]
234 -- activity has completed with the indicated result
235 -- - WAITING
236 -- activity is waiting for additional transitions
237 -- - DEFERED
238 -- execution should be defered to background
239 -- - NOTIFIED[:<notification_id>:<assigned_user>]
240 -- activity has notified an external entity that this
241 -- step must be performed. A call to wf_engine.CompleteActivty
242 -- will signal when this step is complete. Optional
243 -- return of notification ID and assigned user.
244 -- - ERROR[:<error_code>]
245 -- function encountered an error.
246
247 procedure IEM_WF_GETPART(
248 itemtype in varchar2,
249 itemkey in varchar2,
250 actid in number,
251 funcmode in varchar2,
252 result in out nocopy varchar2);
253
254 -- PROCEDURE IEM_WF_ENQUEUE
255 --
256 -- Enqueue the process mail into AQ2
257 --
258 -- IN
259 -- itemtype - type of the current item
260 -- itemkey - key of the current item
261 -- actid - process activity instance id
262 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
263 -- OUT
264 -- None
265 -- result
266 -- - COMPLETE[:<result>]
267 -- activity has completed with the indicated result
268 -- - WAITING
269 -- activity is waiting for additional transitions
270 -- - DEFERED
271 -- execution should be defered to background
272 -- - NOTIFIED[:<notification_id>:<assigned_user>]
273 -- activity has notified an external entity that this
274 -- step must be performed. A call to wf_engine.CompleteActivty
275 -- will signal when this step is complete. Optional
276 -- return of notification ID and assigned user.
277 -- - ERROR[:<error_code>]
278 -- function encountered an error.
279
280 procedure IEM_WF_ENQUEUE(
281 itemtype in varchar2,
282 itemkey in varchar2,
283 actid in number,
284 funcmode in varchar2,
285 result in out nocopy varchar2);
286
287 -- PROCEDURE IEM_WF_NOGRP
288 --
289 -- Process The mail when no user group are defined for the mail.
290 --
291 -- IN
292 -- itemtype - type of the current item
293 -- itemkey - key of the current item
294 -- actid - process activity instance id
295 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
296 -- OUT
297 -- None
298 -- result
299 -- - COMPLETE[:<result>]
300 -- activity has completed with the indicated result
301 -- - WAITING
302 -- activity is waiting for additional transitions
303 -- - DEFERED
304 -- execution should be defered to background
305 -- - NOTIFIED[:<notification_id>:<assigned_user>]
306 -- activity has notified an external entity that this
307 -- step must be performed. A call to wf_engine.CompleteActivty
308 -- will signal when this step is complete. Optional
309 -- return of notification ID and assigned user.
310 -- - ERROR[:<error_code>]
311 -- function encountered an error.
312
313 procedure IEM_WF_NOGRP(
314 itemtype in varchar2,
315 itemkey in varchar2,
316 actid in number,
317 funcmode in varchar2,
318 result in out nocopy varchar2);
319
320 -- PROCEDURE IEM_WF_IS_STRUCT
321 --
322 -- Check The mail Whether Structured or Not .
323 --
324 -- IN
325 -- itemtype - type of the current item
326 -- itemkey - key of the current item
327 -- actid - process activity instance id
328 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
329 -- OUT
330 -- None
331 -- result
332 -- - COMPLETE[:<result>]
333 -- activity has completed with the indicated result
334 -- - WAITING
335 -- activity is waiting for additional transitions
336 -- - DEFERED
337 -- execution should be defered to background
338 -- - NOTIFIED[:<notification_id>:<assigned_user>]
339 -- activity has notified an external entity that this
340 -- step must be performed. A call to wf_engine.CompleteActivty
341 -- will signal when this step is complete. Optional
342 -- return of notification ID and assigned user.
343 -- - ERROR[:<error_code>]
344 -- function encountered an error.
345
346 procedure IEM_WF_IS_STRUCT(
347 itemtype in varchar2,
348 itemkey in varchar2,
349 actid in number,
350 funcmode in varchar2,
351 result in out nocopy varchar2);
352
353 -- PROCEDURE IEM_WF_STRUCT_PROC
354 --
355 -- Node For Processing Structured Mail. This Will call another workflow start
356 -- process for processing structured e-mail.
357 --
358 -- IN
359 -- itemtype - type of the current item
360 -- itemkey - key of the current item
361 -- actid - process activity instance id
362 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
363 -- OUT
364 -- None
365 -- result
366 -- - COMPLETE[:<result>]
367 -- activity has completed with the indicated result
368 -- - WAITING
369 -- activity is waiting for additional transitions
370 -- - DEFERED
371 -- execution should be defered to background
372 -- - NOTIFIED[:<notification_id>:<assigned_user>]
373 -- activity has notified an external entity that this
374 -- step must be performed. A call to wf_engine.CompleteActivty
375 -- will signal when this step is complete. Optional
376 -- return of notification ID and assigned user.
377 -- - ERROR[:<error_code>]
378 -- function encountered an error.
379
380 procedure IEM_WF_STRUCT_PROC(
381 itemtype in varchar2,
382 itemkey in varchar2,
383 actid in number,
384 funcmode in varchar2,
385 result in out nocopy varchar2);
386
387
388 -- PROCEDURE IEM_WF_BCC_TO
389 --
390 -- Node For BCC The mail to a reciepient .
391 --
392 -- IN
393 -- itemtype - type of the current item
394 -- itemkey - key of the current item
395 -- actid - process activity instance id
396 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
397 -- OUT
398 -- None
399 -- result
400 -- - COMPLETE[:<result>]
401 -- activity has completed with the indicated result
402 -- - WAITING
403 -- activity is waiting for additional transitions
404 -- - DEFERED
405 -- execution should be defered to background
406 -- - NOTIFIED[:<notification_id>:<assigned_user>]
407 -- activity has notified an external entity that this
408 -- step must be performed. A call to wf_engine.CompleteActivty
409 -- will signal when this step is complete. Optional
410 -- return of notification ID and assigned user.
411 -- - ERROR[:<error_code>]
412 -- function encountered an error.
413
414 procedure IEM_WF_BCC_TO(
415 itemtype in varchar2,
419 result in out nocopy varchar2);
416 itemkey in varchar2,
417 actid in number,
418 funcmode in varchar2,
420 -- PROCEDURE IEM_WF_DELETE_MSG
421 --
422 -- Delete The current Message .
423 --
424 -- IN
425 -- itemtype - type of the current item
426 -- itemkey - key of the current item
427 -- actid - process activity instance id
428 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
429 -- OUT
430 -- None
431 -- result
432 -- - COMPLETE[:<result>]
433 -- activity has completed with the indicated result
434 -- - WAITING
435 -- activity is waiting for additional transitions
436 -- - DEFERED
437 -- execution should be defered to background
438 -- - NOTIFIED[:<notification_id>:<assigned_user>]
439 -- activity has notified an external entity that this
440 -- step must be performed. A call to wf_engine.CompleteActivty
441 -- will signal when this step is complete. Optional
442 -- return of notification ID and assigned user.
443 -- - ERROR[:<error_code>]
444 -- function encountered an error.
445
446 procedure IEM_WF_DELETEMSG(
447 itemtype in varchar2,
448 itemkey in varchar2,
449 actid in number,
450 funcmode in varchar2,
451 result in out nocopy varchar2);
452
453 -- PROCEDURE IEM_WF_MOVETO
454 --
455 -- Move The Message To The Specified Folder
456 --
457 -- IN
458 -- itemtype - type of the current item
459 -- itemkey - key of the current item
460 -- actid - process activity instance id
461 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
462 -- OUT
463 -- None
464 -- result
465 -- - COMPLETE[:<result>]
466 -- activity has completed with the indicated result
467 -- - WAITING
468 -- activity is waiting for additional transitions
469 -- - DEFERED
470 -- execution should be defered to background
471 -- - NOTIFIED[:<notification_id>:<assigned_user>]
472 -- activity has notified an external entity that this
473 -- step must be performed. A call to wf_engine.CompleteActivty
474 -- will signal when this step is complete. Optional
475 -- return of notification ID and assigned user.
476 -- - ERROR[:<error_code>]
477 -- function encountered an error.
478
479 procedure IEM_WF_MOVETO(
480 itemtype in varchar2,
481 itemkey in varchar2,
482 actid in number,
483 funcmode in varchar2,
484 result in out nocopy varchar2);
485
486 -- PROCEDURE IEM_WF_COPYTO
487 --
488 -- Copy the Messaage To the given folder
489 --
490 -- IN
491 -- itemtype - type of the current item
492 -- itemkey - key of the current item
493 -- actid - process activity instance id
494 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
495 -- OUT
496 -- None
497 -- result
498 -- - COMPLETE[:<result>]
499 -- activity has completed with the indicated result
500 -- - WAITING
501 -- activity is waiting for additional transitions
502 -- - DEFERED
503 -- execution should be defered to background
504 -- - NOTIFIED[:<notification_id>:<assigned_user>]
505 -- activity has notified an external entity that this
506 -- step must be performed. A call to wf_engine.CompleteActivty
507 -- will signal when this step is complete. Optional
508 -- return of notification ID and assigned user.
509 -- - ERROR[:<error_code>]
510 -- function encountered an error.
511
512 procedure IEM_WF_COPYTO(
513 itemtype in varchar2,
514 itemkey in varchar2,
515 actid in number,
516 funcmode in varchar2,
517 result in out nocopy varchar2);
518
519 -- PROCEDURE IEM_WF_FORWARDTO
520 --
521 -- Forward the Messaage with a notes attached
522 --
523 -- IN
524 -- itemtype - type of the current item
525 -- itemkey - key of the current item
526 -- actid - process activity instance id
527 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
528 -- OUT
529 -- None
530 -- result
531 -- - COMPLETE[:<result>]
532 -- activity has completed with the indicated result
533 -- - WAITING
534 -- activity is waiting for additional transitions
535 -- - DEFERED
536 -- execution should be defered to background
537 -- - NOTIFIED[:<notification_id>:<assigned_user>]
538 -- activity has notified an external entity that this
539 -- step must be performed. A call to wf_engine.CompleteActivty
540 -- will signal when this step is complete. Optional
541 -- return of notification ID and assigned user.
542 -- - ERROR[:<error_code>]
543 -- function encountered an error.
544
545 procedure IEM_WF_FORWARDTO(
546 itemtype in varchar2,
547 itemkey in varchar2,
548 actid in number,
549 funcmode in varchar2,
550 result in out nocopy varchar2);
551 -- PROCEDURE IEM_WF_SIMPLESEARCH
552 --
553 -- Search The KB Repository
554 --
555 -- IN
559 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
556 -- itemtype - type of the current item
557 -- itemkey - key of the current item
558 -- actid - process activity instance id
560 -- OUT
561 -- None
562 -- result
563 -- - COMPLETE[:<result>]
564 -- activity has completed with the indicated result
565 -- - WAITING
566 -- activity is waiting for additional transitions
567 -- - DEFERED
568 -- execution should be defered to background
569 -- - NOTIFIED[:<notification_id>:<assigned_user>]
570 -- activity has notified an external entity that this
571 -- step must be performed. A call to wf_engine.CompleteActivty
572 -- will signal when this step is complete. Optional
573 -- return of notification ID and assigned user.
574 -- - ERROR[:<error_code>]
575 -- function encountered an error.
576
577 procedure IEM_WF_SIMPLESEARCH(
578 itemtype in varchar2,
579 itemkey in varchar2,
580 actid in number,
581 funcmode in varchar2,
582 result in out nocopy varchar2);
583
584 -- PROCEDURE IEM_WF_SPECIFICSEARCH
585 --
586 -- Do a specific search on the KB Repository
587 --
588 -- IN
589 -- itemtype - type of the current item
590 -- itemkey - key of the current item
591 -- actid - process activity instance id
592 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
593 -- OUT
594 -- None
595 -- result
596 -- - COMPLETE[:<result>]
597 -- activity has completed with the indicated result
598 -- - WAITING
599 -- activity is waiting for additional transitions
600 -- - DEFERED
601 -- execution should be defered to background
602 -- - NOTIFIED[:<notification_id>:<assigned_user>]
603 -- activity has notified an external entity that this
604 -- step must be performed. A call to wf_engine.CompleteActivty
605 -- will signal when this step is complete. Optional
606 -- return of notification ID and assigned user.
607 -- - ERROR[:<error_code>]
608 -- function encountered an error.
609
610 procedure IEM_WF_SPECIFICSEARCH(
611 itemtype in varchar2,
612 itemkey in varchar2,
613 actid in number,
614 funcmode in varchar2,
615 result in out nocopy varchar2);
616
617 -- PROCEDURE IEM_WF_SEARCHMESSAGE
618 --
619 -- Based on the search criteria looks for the content in Message
620 --
621 -- IN
622 -- itemtype - type of the current item
623 -- itemkey - key of the current item
624 -- actid - process activity instance id
625 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
626 -- OUT
627 -- None
628 -- result
629 -- - COMPLETE[:<result>]
630 -- activity has completed with the indicated result
631 -- - WAITING
632 -- activity is waiting for additional transitions
633 -- - DEFERED
634 -- execution should be defered to background
635 -- - NOTIFIED[:<notification_id>:<assigned_user>]
636 -- activity has notified an external entity that this
637 -- step must be performed. A call to wf_engine.CompleteActivty
638 -- will signal when this step is complete. Optional
639 -- return of notification ID and assigned user.
640 -- - ERROR[:<error_code>]
641 -- function encountered an error.
642
643 procedure IEM_WF_SEARCHMESSAGE(
644 itemtype in varchar2,
645 itemkey in varchar2,
646 actid in number,
647 funcmode in varchar2,
648 result in out nocopy varchar2);
649
650 -- PROCEDURE IEM_WF_PROCTHEMEREPOS
651 --
652 -- Generate the Theme and classification Repository
653 --
654 -- IN
655 -- itemtype - type of the current item
656 -- itemkey - key of the current item
657 -- actid - process activity instance id
658 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
659 -- OUT
660 -- None
661 -- result
662 -- - COMPLETE[:<result>]
663 -- activity has completed with the indicated result
664 -- - WAITING
665 -- activity is waiting for additional transitions
666 -- - DEFERED
667 -- execution should be defered to background
668 -- - NOTIFIED[:<notification_id>:<assigned_user>]
669 -- activity has notified an external entity that this
670 -- step must be performed. A call to wf_engine.CompleteActivty
671 -- will signal when this step is complete. Optional
672 -- return of notification ID and assigned user.
673 -- - ERROR[:<error_code>]
674 -- function encountered an error.
675
676 procedure IEM_WF_STORETHEME(
677 itemtype in varchar2,
678 itemkey in varchar2,
679 actid in number,
680 funcmode in varchar2,
681 result in out nocopy varchar2);
682
683 -- PROCEDURE IEM_WF_THEMEPROC
684 --
685 -- Process the Theme for each classification and keep max seven classification
686 --
687 -- IN
688 -- itemtype - type of the current item
689 -- itemkey - key of the current item
690 -- actid - process activity instance id
694 -- result
691 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
692 -- OUT
693 -- None
695 -- - COMPLETE[:<result>]
696 -- activity has completed with the indicated result
697 -- - WAITING
698 -- activity is waiting for additional transitions
699 -- - DEFERED
700 -- execution should be defered to background
701 -- - NOTIFIED[:<notification_id>:<assigned_user>]
702 -- activity has notified an external entity that this
703 -- step must be performed. A call to wf_engine.CompleteActivty
704 -- will signal when this step is complete. Optional
705 -- return of notification ID and assigned user.
706 -- - ERROR[:<error_code>]
707 -- function encountered an error.
708
709 procedure IEM_WF_THEMEPROC(
710 itemtype in varchar2,
711 itemkey in varchar2,
712 actid in number,
713 funcmode in varchar2,
714 result in out nocopy varchar2);
715 -- PROCEDURE IEM_WF_KEYVAL
716 --
717 -- Process the Theme for each classification and keep max seven classification
718 --
719 -- IN
720 -- itemtype - type of the current item
721 -- itemkey - key of the current item
722 -- actid - process activity instance id
723 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
724 -- OUT
725 -- None
726 -- result
727 -- - COMPLETE[:<result>]
728 -- activity has completed with the indicated result
729 -- - WAITING
730 -- activity is waiting for additional transitions
731 -- - DEFERED
732 -- execution should be defered to background
733 -- - NOTIFIED[:<notification_id>:<assigned_user>]
734 -- activity has notified an external entity that this
735 -- step must be performed. A call to wf_engine.CompleteActivty
736 -- will signal when this step is complete. Optional
737 -- return of notification ID and assigned user.
738 -- - ERROR[:<error_code>]
739 -- function encountered an error.
740 procedure IEM_WF_KEYVAL(
741 itemtype in varchar2,
742 itemkey in varchar2,
743 actid in number,
744 funcmode in varchar2,
745 result in out nocopy varchar2);
746
747 -- PROCEDURE IEM_WF_CLASSRULE
748 --
749 -- Check the classification score with the thresh hold score and return T/F
750 --
751 -- IN
752 -- itemtype - type of the current item
753 -- itemkey - key of the current item
754 -- actid - process activity instance id
755 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
756 -- OUT
757 -- None
758 -- result
759 -- - COMPLETE[:<result>]
760 -- activity has completed with the indicated result
761 -- - WAITING
762 -- activity is waiting for additional transitions
763 -- - DEFERED
764 -- execution should be defered to background
765 -- - NOTIFIED[:<notification_id>:<assigned_user>]
766 -- activity has notified an external entity that this
767 -- step must be performed. A call to wf_engine.CompleteActivty
768 -- will signal when this step is complete. Optional
769 -- return of notification ID and assigned user.
770 -- - ERROR[:<error_code>]
771 -- function encountered an error.
772 procedure IEM_WF_CLASSRULE(
773 itemtype in varchar2,
774 itemkey in varchar2,
775 actid in number,
776 funcmode in varchar2,
777 result in out nocopy varchar2);
778
779 -- PROCEDURE IEM_WF_CHKAUTO
780 --
781 -- Check the classification score with the thresh hold score and return T/F
782 --
783 -- IN
784 -- itemtype - type of the current item
785 -- itemkey - key of the current item
786 -- actid - process activity instance id
787 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
788 -- OUT
789 -- None
790 -- result
791 -- - COMPLETE[:<result>]
792 -- activity has completed with the indicated result
793 -- - WAITING
794 -- activity is waiting for additional transitions
795 -- - DEFERED
796 -- execution should be defered to background
797 -- - NOTIFIED[:<notification_id>:<assigned_user>]
798 -- activity has notified an external entity that this
799 -- step must be performed. A call to wf_engine.CompleteActivty
800 -- will signal when this step is complete. Optional
801 -- return of notification ID and assigned user.
802 -- - ERROR[:<error_code>]
803 -- function encountered an error.
804
805 procedure IEM_WF_CHKAUTO(
806 itemtype in varchar2,
807 itemkey in varchar2,
808 actid in number,
809 funcmode in varchar2,
810 result in out nocopy varchar2);
811
812 -- PROCEDURE IEM_WF_AUTORESP
813 --
814 -- Auto respond a set of documnets to the sender
815 --
816 -- IN
817 -- itemtype - type of the current item
818 -- itemkey - key of the current item
819 -- actid - process activity instance id
820 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
821 -- OUT
822 -- None
823 -- result
824 -- - COMPLETE[:<result>]
825 -- activity has completed with the indicated result
826 -- - WAITING
827 -- activity is waiting for additional transitions
828 -- - DEFERED
829 -- execution should be defered to background
830 -- - NOTIFIED[:<notification_id>:<assigned_user>]
831 -- activity has notified an external entity that this
832 -- step must be performed. A call to wf_engine.CompleteActivty
833 -- will signal when this step is complete. Optional
834 -- return of notification ID and assigned user.
835 -- - ERROR[:<error_code>]
836 -- function encountered an error.
837
838 procedure IEM_WF_AUTORESP(
839 itemtype in varchar2,
840 itemkey in varchar2,
841 actid in number,
842 funcmode in varchar2,
843 result in out nocopy varchar2);
844
845 -- PROCEDURE IEM_WF_ORDSTAT
846 --
847 -- Auto respond the order status to the sender
848 --
849 -- IN
850 -- itemtype - type of the current item
851 -- itemkey - key of the current item
852 -- actid - process activity instance id
853 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
854 -- OUT
855 -- None
856 -- result
857 -- - COMPLETE[:<result>]
858 -- activity has completed with the indicated result
859 -- - WAITING
860 -- activity is waiting for additional transitions
861 -- - DEFERED
862 -- execution should be defered to background
863 -- - NOTIFIED[:<notification_id>:<assigned_user>]
864 -- activity has notified an external entity that this
865 -- step must be performed. A call to wf_engine.CompleteActivty
866 -- will signal when this step is complete. Optional
867 -- return of notification ID and assigned user.
868 -- - ERROR[:<error_code>]
869 -- function encountered an error.
870
871 procedure IEM_WF_ORDSTAT(
872 itemtype in varchar2,
873 itemkey in varchar2,
874 actid in number,
875 funcmode in varchar2,
876 result in out nocopy varchar2);
878 end IEM_Mailpreprocwf_PUB;
877