1 PACKAGE Eng_Workflow_Pub AS
2 /* $Header: ENGBWKFS.pls 120.3 2006/04/11 17:59:48 mkimizuk noship $ */
3
4
5 -- NOT SUPPORTING IN 115.10
6 -- PROCEDURE CHECK_HEADER_OR_LINE
7 --
8 -- Check if this change object is header or line
9 --
10 -- IN
11 -- itemtype - type of the current item
12 -- itemkey - key of the current item
13 -- actid - process activity instance id
14 -- funcmode - function execution mode. this is set by the engine
15 -- as either 'RUN', 'CANCEL', 'TIMEOUT'
16 -- OUT
17 -- result
18 -- - COMPLETE
19 -- activity has completed
20 -- - COMPLETE:Y
21 -- Header
22 -- - COMPLETE:N
23 -- Line
24 --
25 PROCEDURE CHECK_HEADER_OR_LINE(
26 itemtype in varchar2,
27 itemkey in varchar2,
28 actid in number,
29 funcmode in varchar2,
30 result in out NOCOPY varchar2);
31
32
33 -- PROCEDURE SELECT_ADHOC_PARTY
34 --
35 -- Select Adhoc Party and Set users to Adhoc Role
36 --
37 -- IN
38 -- itemtype - type of the current item
39 -- itemkey - key of the current item
40 -- actid - process activity instance id
41 -- funcmode - function execution mode. this is set by the engine
42 -- as either 'RUN', 'CANCEL', 'TIMEOUT'
43 -- OUT
44 -- result
45 -- - COMPLETE
46 -- activity has completed
47 -- - COMPLETE:NONE
48 -- activity could not find any adhoc parties
49 PROCEDURE SELECT_ADHOC_PARTY(
50 itemtype in varchar2,
51 itemkey in varchar2,
52 actid in number,
53 funcmode in varchar2,
54 result in out NOCOPY varchar2);
55
56 -- PROCEDURE SELECT_ASSIGNEE
57 --
58 -- Select Assignees and Set the users to Assignee Role
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 -- result
67 -- - COMPLETE
68 -- activity has completed
69 -- - COMPLETE:NONE
70 -- activity could not find any parties
71 PROCEDURE SELECT_ASSIGNEE(
72 itemtype in varchar2,
73 itemkey in varchar2,
74 actid in number,
75 funcmode in varchar2,
76 result in out NOCOPY varchar2);
77
78
79 -- PROCEDURE SELECT_STD_REVIEWERS
80 --
81 -- Select Change Object Standard Reviewers
82 -- ( Assignee, Requestor and Creator)
83 -- and set Reviewer Role
84 --
85 -- IN
86 -- itemtype - type of the current item
87 -- itemkey - key of the current item
88 -- actid - process activity instance id
89 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
90 -- OUT
91 -- result
92 -- - COMPLETE
93 -- activity has completed
94 -- - COMPLETE:NONE
95 -- activity could not find any parties
96 PROCEDURE SELECT_STD_REVIEWERS(
97 itemtype in varchar2,
98 itemkey in varchar2,
99 actid in number,
100 funcmode in varchar2,
101 result in out NOCOPY varchar2);
102
103
104 -- PROCEDURE SELECT_REVIEWERS
105 --
106 -- Select Change Object Reviewers( Requestor and Creator)
107 -- and set Reviewer Role
108 --
109 -- IN
110 -- itemtype - type of the current item
111 -- itemkey - key of the current item
112 -- actid - process activity instance id
113 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
114 -- OUT
115 -- result
116 -- - COMPLETE
117 -- activity has completed
118 -- - COMPLETE:NONE
119 -- activity could not find any parties
120 PROCEDURE SELECT_REVIEWERS(
121 itemtype in varchar2,
122 itemkey in varchar2,
123 actid in number,
124 funcmode in varchar2,
125 result in out NOCOPY varchar2);
126
127
128 -- PROCEDURE SELECT_LINE_ASSIGNEE
129 --
130 -- Select Line Assignees and Set the users to Line Assignee Role
131 --
132 -- IN
133 -- itemtype - type of the current item
134 -- itemkey - key of the current item
135 -- actid - process activity instance id
136 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
137 -- OUT
138 -- result
139 -- - COMPLETE
140 -- activity has completed
141 -- - COMPLETE:NONE
142 -- activity could not find any parties
143 PROCEDURE SELECT_LINE_ASSIGNEE(
144 itemtype in varchar2,
145 itemkey in varchar2,
146 actid in number,
147 funcmode in varchar2,
148 result in out NOCOPY varchar2);
149
150
151 -- PROCEDURE SELECT_STD_LINE_REVIEWERS
152 --
153 -- Select Change Line Object Standard Reviewers
154 -- ( Line Assignee, Line Creator
155 -- Header Assignee, Header Requestor and Header Creator)
156 -- and set Line Reviewer Role
157 --
158 -- IN
159 -- itemtype - type of the current item
160 -- itemkey - key of the current item
161 -- actid - process activity instance id
162 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
163 -- OUT
164 -- result
165 -- - COMPLETE
166 -- activity has completed
167 -- - COMPLETE:NONE
168 -- activity could not find any parties
169 PROCEDURE SELECT_STD_LINE_REVIEWERS(
170 itemtype in varchar2,
171 itemkey in varchar2,
172 actid in number,
173 funcmode in varchar2,
174 result in out NOCOPY varchar2);
175
176
177 -- PROCEDURE SELECT_LINE_REVIEWERS
178 --
179 -- Select Change Line Object Reviewers
180 -- ( Line Creator
181 -- Header Assignee, Header Requestor and Header Creator)
182 -- and set Line Reviewer Role
183 --
184 -- IN
185 -- itemtype - type of the current item
186 -- itemkey - key of the current item
187 -- actid - process activity instance id
188 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
189 -- OUT
190 -- result
191 -- - COMPLETE
192 -- activity has completed
193 -- - COMPLETE:NONE
194 -- activity could not find any line parties
195 PROCEDURE SELECT_LINE_REVIEWERS(
196 itemtype in varchar2,
197 itemkey in varchar2,
198 actid in number,
199 funcmode in varchar2,
200 result in out NOCOPY varchar2);
201
202
203 -- PROCEDURE INITIATE_LINES
204 --
205 -- Start ENGCLACT: INITIATE_CHANGE Workflows for
206 -- the Change Object to initiate the lines
207 --
208 -- IN
209 -- itemtype - type of the current item
210 -- itemkey - key of the current item
211 -- actid - process activity instance id
212 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
213 -- OUT
214 -- result
215 -- - COMPLETE
216 -- activity has completed
217 PROCEDURE INITIATE_LINES(
218 itemtype in varchar2,
219 itemkey in varchar2,
220 actid in number,
221 funcmode in varchar2,
222 result in out NOCOPY varchar2);
223
224
225
226 -- PROCEDURE SELECT_ROUTE_PEOPLE
227 --
228 -- Select Route People and set to Role People Role
229 -- Route People: all route people in the route workflow
230 -- that have already been notified (i.e. completed or in process steps)
231 --
232 -- IN
233 -- itemtype - type of the current item
234 -- itemkey - key of the current item
235 -- actid - process activity instance id
236 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
237 -- OUT
238 -- result
239 -- - COMPLETE
240 -- activity has completed
241 -- - COMPLETE:NONE
242 -- activity could not find any adhoc parties
243 PROCEDURE SELECT_ROUTE_PEOPLE(
244 itemtype in varchar2,
245 itemkey in varchar2,
246 actid in number,
247 funcmode in varchar2,
248 result in out NOCOPY varchar2);
249
250
251 -- PROCEDURE SELECT_STEP_PEOPLE
252 --
253 -- Select Route Step People and set to Step People Role
254 --
255 -- IN
256 -- itemtype - type of the current item
257 -- itemkey - key of the current item
258 -- actid - process activity instance id
259 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
260 -- OUT
261 -- result
262 -- - COMPLETE
263 -- activity has completed
264 -- - COMPLETE:NONE
265 -- activity could not find any adhoc parties
266 PROCEDURE SELECT_STEP_PEOPLE(
267 itemtype in varchar2,
268 itemkey in varchar2,
269 actid in number,
270 funcmode in varchar2,
271 result in out NOCOPY varchar2);
272
273
274 -- PROCEDURE DELETE_ADHOC_ROLES_AND_USERS
275 --
276 -- Delete Workflow Adhoc Role and Local Users
277 --
278 -- IN
279 -- itemtype - type of the current item
280 -- itemkey - key of the current item
281 -- actid - process activity instance id
282 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
283 -- OUT
284 -- result
285 -- - COMPLETE
286 -- activity has completed
287 PROCEDURE DELETE_ADHOC_ROLES_AND_USERS(
288 itemtype in varchar2,
289 itemkey in varchar2,
290 actid in number,
291 funcmode in varchar2,
292 result in out NOCOPY varchar2);
293
294 -- PROCEDURE SET_REQUEST_OPTIONS
295 --
296 -- Set Action: Comment Request Request Option
297 --
298 -- IN
299 -- itemtype - type of the current item
300 -- itemkey - key of the current item
301 -- actid - process activity instance id
302 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
303 -- OUT
304 -- result
305 -- - COMPLETE
306 -- activity has completed
307 PROCEDURE SET_REQUEST_OPTIONS(
308 itemtype in varchar2,
309 itemkey in varchar2,
310 actid in number,
311 funcmode in varchar2,
312 result in out NOCOPY varchar2);
313
314
315 -- PROCEDURE SET_STEP_ACT_OPTIONS
316 --
317 -- Set Route Step Activity Options
318 --
319 -- IN
320 -- itemtype - type of the current item
321 -- itemkey - key of the current item
322 -- actid - process activity instance id
323 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
324 -- OUT
325 -- result
326 -- - COMPLETE
327 -- activity has completed
328 PROCEDURE SET_STEP_ACT_OPTIONS(
329 itemtype in varchar2,
330 itemkey in varchar2,
331 actid in number,
332 funcmode in varchar2,
333 result in out NOCOPY varchar2);
334
335
336 -- PROCEDURE RESPOND_TO_COMMENT_REQUEST
337 --
338 -- Process notification response to Comment Request
339 --
340 -- IN
341 -- itemtype - type of the current item
342 -- itemkey - key of the current item
343 -- actid - process activity instance id
344 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
345 -- OUT
346 -- result
347 -- - COMPLETE
348 -- activity has completed
349 PROCEDURE RESPOND_TO_COMMENT_REQUEST(
350 itemtype in varchar2,
351 itemkey in varchar2,
352 actid in number,
353 funcmode in varchar2,
354 result in out NOCOPY varchar2);
355
356
357 -- PROCEDURE RESPOND_TO_ROUTE_APPROVAL_REQ
358 --
359 -- Process notification response to seeded Route Approval Request
360 --
361 -- IN
362 -- itemtype - type of the current item
363 -- itemkey - key of the current item
364 -- actid - process activity instance id
365 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
366 -- OUT
367 -- result
368 -- - COMPLETE
369 -- activity has completed
370 PROCEDURE RESPOND_TO_ROUTE_APPROVAL_REQ(
371 itemtype in varchar2,
372 itemkey in varchar2,
373 actid in number,
374 funcmode in varchar2,
375 result in out NOCOPY varchar2);
376
377
378 -- PROCEDURE RESPOND_TO_ROUTE_COMMENT_REQUEST
379 --
380 -- Process notification response to seeded Route Comment Request
381 --
382 -- IN
383 -- itemtype - type of the current item
384 -- itemkey - key of the current item
385 -- actid - process activity instance id
386 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
387 -- OUT
388 -- result
389 -- - COMPLETE
390 -- activity has completed
391 PROCEDURE RESPOND_TO_ROUTE_COMMENT_REQ(
392 itemtype in varchar2,
393 itemkey in varchar2,
394 actid in number,
395 funcmode in varchar2,
396 result in out NOCOPY varchar2);
397
398
399 -- PROCEDURE RESPOND_TO_ROUTE_DEF_REQ
400 --
401 -- Process notification response to seeded Route Defintion Request
402 --
403 -- IN
404 -- itemtype - type of the current item
405 -- itemkey - key of the current item
406 -- actid - process activity instance id
407 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
408 -- OUT
409 -- result
410 -- - COMPLETE
411 -- activity has completed
412 PROCEDURE RESPOND_TO_ROUTE_DEF_REQ(
413 itemtype in varchar2,
414 itemkey in varchar2,
415 actid in number,
416 funcmode in varchar2,
417 result in out NOCOPY varchar2);
418
419
420 -- PROCEDURE RESPOND_TO_ROUTE_DEF_APPR_REQ
421 --
422 -- Process notification response to seeded Route Defintion and Approval Request
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 -- result
431 -- - COMPLETE
432 -- activity has completed
433 PROCEDURE RESPOND_TO_ROUTE_DEF_APPR_REQ(
434 itemtype in varchar2,
435 itemkey in varchar2,
436 actid in number,
437 funcmode in varchar2,
438 result in out NOCOPY varchar2);
439
440
441 -- PROCEDURE RESPOND_TO_ROUTE_CORRECT_REQ
442 --
443 -- Process notification response to seeded Route Correct Defintion Request
444 --
445 -- IN
446 -- itemtype - type of the current item
447 -- itemkey - key of the current item
448 -- actid - process activity instance id
449 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
450 -- OUT
451 -- result
452 -- - COMPLETE
453 -- activity has completed
454 PROCEDURE RESPOND_TO_ROUTE_CORRECT_REQ(
455 itemtype in varchar2,
456 itemkey in varchar2,
457 actid in number,
458 funcmode in varchar2,
459 result in out NOCOPY varchar2);
460
461
462
463
464 --
465 -- R12B
466 -- PROCEDURE RESPOND_TO_ROUTE_RESPONSE_REQ
467 --
468 -- Process notification response to seeded Route Response Request
469 --
470 -- IN
471 -- itemtype - type of the current item
472 -- itemkey - key of the current item
473 -- actid - process activity instance id
474 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
475 -- OUT
476 -- result
477 -- - COMPLETE
478 -- activity has completed
479 PROCEDURE RESPOND_TO_ROUTE_RESPONSE_REQ(
480 itemtype in varchar2,
481 itemkey in varchar2,
482 actid in number,
483 funcmode in varchar2,
484 result in out NOCOPY varchar2);
485
486
487
488 -- PROCEDURE START_ROUTE_STEP
489 --
490 -- Start Next Route Step
491 --
492 -- IN
493 -- itemtype - type of the current item
494 -- itemkey - key of the current item
495 -- actid - process activity instance id
496 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
497 -- OUT
498 -- result
499 -- - COMPLETE
500 -- activity has completed
501 -- - COMPLETE:NONE
502 -- activity could not find any adhoc parties
503 PROCEDURE START_ROUTE_STEP(
504 itemtype in varchar2,
505 itemkey in varchar2,
506 actid in number,
507 funcmode in varchar2,
508 result in out NOCOPY varchar2);
509
510
511
512 -- PROCEDURE CHECK_STEP_RESULT
513 --
514 -- Check Step Result
515 --
516 -- IN
517 -- itemtype - type of the current item
518 -- itemkey - key of the current item
519 -- actid - process activity instance id
520 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
521 -- OUT
522 -- result
523 -- - COMPLETE[:<ENG_CHANGE_ROUTE_STATUSES lookup codes>]
524 -- activity has completed with the step result
525 PROCEDURE CHECK_STEP_RESULT(
526 itemtype in varchar2,
527 itemkey in varchar2,
528 actid in number,
529 funcmode in varchar2,
530 result in out NOCOPY varchar2);
531
532
533 -- PROCEDURE CHECK_LINE_APPROVALS
534 --
535 -- Check if all lines are approved
536 --
537 -- IN
538 -- itemtype - type of the current item
539 -- itemkey - key of the current item
540 -- actid - process activity instance id
541 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
542 -- OUT
543 -- result
547 --
544 -- - COMPLETE[:<ENG_ECN_APPROVAL_STATUS lookup codes>]
545 -- If all lins are approved, return status 5: Approved
546 -- otherwise return else
548 PROCEDURE CHECK_LINE_APPROVALS(
549 itemtype in varchar2,
550 itemkey in varchar2,
551 actid in number,
552 funcmode in varchar2,
553 result in out NOCOPY varchar2);
554
555
556 -- PROCEDURE FIND_WAITING_STEP
557 --
558 -- Find waiting steps in this route
559 --
560 -- IN
561 -- itemtype - type of the current item
562 -- itemkey - key of the current item
563 -- actid - process activity instance id
564 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
565 -- OUT
566 -- result
567 -- - COMPLETE:Boolean(WFSTD_BOOLEAN)
568 -- activity has completed with the indicated result
569 PROCEDURE FIND_WAITING_STEP (
570 itemtype in varchar2,
571 itemkey in varchar2,
572 actid in number,
573 funcmode in varchar2,
574 result in out NOCOPY varchar2) ;
575
576 -- PROCEDURE ROUTE_APPROVE_CHANGE
577 --
578 -- Approve Change Object in Route
579 -- update Change Object Approval Status and Route Status
580 --
581 -- IN
582 -- itemtype - type of the current item
583 -- itemkey - key of the current item
584 -- actid - process activity instance id
585 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
586 -- OUT
587 -- result
588 -- - COMPLETE
589 -- activity has completed
590 PROCEDURE ROUTE_APPROVE_CHANGE(
591 itemtype in varchar2,
592 itemkey in varchar2,
593 actid in number,
594 funcmode in varchar2,
595 result in out NOCOPY varchar2);
596
597 -- PROCEDURE ROUTE_REJECT_CHANGE
598 --
599 -- Reject Change Object in Route
600 -- update Change Object Approval Status and Route Status
601 --
602 -- IN
603 -- itemtype - type of the current item
604 -- itemkey - key of the current item
605 -- actid - process activity instance id
606 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
607 -- OUT
608 -- result
609 -- - COMPLETE
610 -- activity has completed
611 PROCEDURE ROUTE_REJECT_CHANGE(
612 itemtype in varchar2,
613 itemkey in varchar2,
614 actid in number,
615 funcmode in varchar2,
616 result in out NOCOPY varchar2);
617
618
619
620 -- PROCEDURE ROUTE_SET_TIMEOUT
621 --
622 -- Set Route as Time Out
623 -- update Change Object Approval Status and Route Status
624 --
625 -- IN
626 -- itemtype - type of the current item
627 -- itemkey - key of the current item
628 -- actid - process activity instance id
629 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
630 -- OUT
631 -- result
632 -- - COMPLETE
633 -- activity has completed
634 PROCEDURE ROUTE_SET_TIMEOUT(
635 itemtype in varchar2,
636 itemkey in varchar2,
637 actid in number,
638 funcmode in varchar2,
639 result in out NOCOPY varchar2);
640
641
642 -- PROCEDURE STEP_COMPLETE_ACTIVITY
643 --
644 -- Set Step Activity as Completed
645 -- update Route Step Status
646 --
647 -- IN
648 -- itemtype - type of the current item
649 -- itemkey - key of the current item
650 -- actid - process activity instance id
651 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
652 -- OUT
653 -- result
654 -- - COMPLETE
655 -- activity has completed
656 PROCEDURE STEP_COMPLETE_ACTIVITY (
657 itemtype in varchar2,
658 itemkey in varchar2,
659 actid in number,
660 funcmode in varchar2,
661 result in out NOCOPY varchar2);
662
663
664 -- PROCEDURE STEP_APPROVE_CHANGE
665 --
666 -- Approve Change in Step
667 -- update Route Step Status
668 --
669 -- IN
670 -- itemtype - type of the current item
671 -- itemkey - key of the current item
672 -- actid - process activity instance id
673 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
674 -- OUT
675 -- result
676 -- - COMPLETE
677 -- activity has completed
678 PROCEDURE STEP_APPROVE_CHANGE(
679 itemtype in varchar2,
680 itemkey in varchar2,
681 actid in number,
682 funcmode in varchar2,
683 result in out NOCOPY varchar2);
684
685 -- PROCEDURE STEP_REJECT_CHANGE
686 --
687 -- Reject Change in Step
688 -- update Route Step Status
689 --
690 -- IN
691 -- itemtype - type of the current item
692 -- itemkey - key of the current item
693 -- actid - process activity instance id
694 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
695 -- OUT
696 -- result
697 -- - COMPLETE
698 -- activity has completed
699 PROCEDURE STEP_REJECT_CHANGE(
700 itemtype in varchar2,
701 itemkey in varchar2,
705
702 actid in number,
703 funcmode in varchar2,
704 result in out NOCOPY varchar2);
706 -- PROCEDURE STEP_SET_TIMEOUT
707 --
708 -- Set Step as Time Out
709 -- update Route Step Status
710 --
711 -- IN
712 -- itemtype - type of the current item
713 -- itemkey - key of the current item
714 -- actid - process activity instance id
715 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
716 -- OUT
717 -- result
718 -- - COMPLETE
719 -- activity has completed
720 PROCEDURE STEP_SET_TIMEOUT(
721 itemtype in varchar2,
722 itemkey in varchar2,
723 actid in number,
724 funcmode in varchar2,
725 result in out NOCOPY varchar2);
726
727
728
729 -- PROCEDURE GRANT_ROLE_TO_STEP_PEOPLE
730 --
731 -- Grant the role which is defined in process attr: DEFAULT_CHANGE_ROLE
732 -- to step people
733 --
734 -- IN
735 -- itemtype - type of the current item
736 -- itemkey - key of the current item
737 -- actid - process activity instance id
738 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
739 -- OUT
740 -- result
741 -- - COMPLETE
742 -- activity has completed
743 PROCEDURE GRANT_ROLE_TO_STEP_PEOPLE(
744 itemtype in varchar2,
745 itemkey in varchar2,
746 actid in number,
747 funcmode in varchar2,
748 result in out NOCOPY varchar2);
749
750
751 --
752 -- PROCEDURE CHECK_DEFINITIONS
753 --
754 -- Check Definitions
755 -- this is place folder customer can replace with own PL/SQL Function
756 -- By default, this Activity always returns TRUE
757 --
758 -- IN
759 -- itemtype - type of the current item
760 -- itemkey - key of the current item
761 -- actid - process activity instance id
762 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
763 -- OUT
764 -- - COMPLETE:Boolean(WFSTD_BOOLEAN)
765 -- activity has completed with the indicated result
766 PROCEDURE CHECK_DEFINITIONS(
767 itemtype in varchar2,
768 itemkey in varchar2,
769 actid in number,
770 funcmode in varchar2,
771 result in out NOCOPY varchar2);
772
773
774 --
775 -- PROCEDURE CHECK_ROUTE_OBJECT
776 --
777 -- Check Route Object
778 --
779 -- IN
780 -- itemtype - type of the current item
781 -- itemkey - key of the current item
782 -- actid - process activity instance id
783 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
784 -- OUT
785 -- result
786 -- - COMPLETE[:<ENG_CHANGE_OBJECTS lookup codes>]
787 -- based on Route Object
788 PROCEDURE CHECK_ROUTE_OBJECT(
789 itemtype in varchar2,
790 itemkey in varchar2,
791 actid in number,
792 funcmode in varchar2,
793 result in out NOCOPY varchar2);
794
795
796 --
797 -- PROCEDURE SYNC_CHANGE_LC_PHASE
798 --
799 -- Sync Change Management Lifecycle Phase
800 -- This activity calls Change Management Lifecycle Phase to integrate with LC Phase
801 --
802 -- IN
803 -- itemtype - type of the current item
804 -- itemkey - key of the current item
805 -- actid - process activity instance id
806 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
807 -- OUT
808 -- result
809 -- - COMPLETE
810 -- activity has completed
811 PROCEDURE SYNC_CHANGE_LC_PHASE(
812 itemtype in varchar2,
813 itemkey in varchar2,
814 actid in number,
815 funcmode in varchar2,
816 result in out NOCOPY varchar2);
817
818
819
820
821
822 --
823 -- PROCEDURE CHECK_BASE_CM_TYPE_CODE
824 --
825 -- Check Approval Status
826 -- Bug5136260
827 --
828 -- IN
829 -- itemtype - type of the current item
830 -- itemkey - key of the current item
831 -- actid - process activity instance id
832 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
833 -- OUT
834 -- result
835 -- - COMPLETE[:<ENG_BASE_CM_TYPE_CODES lookup codes>] or NULL
836 -- activity has completed with the step result
837 PROCEDURE CHECK_BASE_CM_TYPE_CODE(
838 itemtype in varchar2,
839 itemkey in varchar2,
840 actid in number,
841 funcmode in varchar2,
842 result in out NOCOPY varchar2);
843
844
845
846 --
847 -- PROCEDURE CHECK_CHANGE_APPR_STATUS
848 --
849 -- Check Approval Status
850 -- Bug5136260
851 --
852 -- IN
853 -- itemtype - type of the current item
854 -- itemkey - key of the current item
855 -- actid - process activity instance id
856 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
857 -- OUT
858 -- result
859 -- - COMPLETE[:<ENG_ECN_APPROVAL_STATUS lookup codes>] or NULL
860 -- activity has completed with the step result
861 PROCEDURE CHECK_CHANGE_APPR_STATUS(
865 funcmode in varchar2,
862 itemtype in varchar2,
863 itemkey in varchar2,
864 actid in number,
866 result in out NOCOPY varchar2);
867
868
869 --
870 -- PROCEDURE SET_CO_MRP_FLAG_ACTIVE
871 --
872 -- Set Change Order MRP Flag to Active
873 -- Bug5136260
874 --
875 -- IN
876 -- itemtype - type of the current item
877 -- itemkey - key of the current item
878 -- actid - process activity instance id
879 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
880 -- OUT
881 -- result
882 -- - COMPLETE
883 -- activity has completed
884 PROCEDURE SET_CO_MRP_FLAG_ACTIVE(
885 itemtype in varchar2,
886 itemkey in varchar2,
887 actid in number,
888 funcmode in varchar2,
889 result in out NOCOPY varchar2);
890
891
892 -- PROCEDURE SET_CO_MRP_FLAG_INACTIVE
893 --
894 -- Set Change Order MRP Flag to Inactive
895 -- Bug5136260
896 --
897 -- IN
898 -- itemtype - type of the current item
899 -- itemkey - key of the current item
900 -- actid - process activity instance id
901 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
902 -- OUT
903 -- result
904 -- - COMPLETE
905 -- activity has completed
906 PROCEDURE SET_CO_MRP_FLAG_INACTIVE(
907 itemtype in varchar2,
908 itemkey in varchar2,
909 actid in number,
910 funcmode in varchar2,
911 result in out NOCOPY varchar2);
912
913
914
915 -- PROCEDURE SET_ADMIN_STATUS_MONITOR_URL
916 --
917 -- Set WF Admin Status Monigor URL to Item Attribute: STATUS_MONITOR_URL
918 --
919 -- IN
920 -- itemtype - type of the current item
921 -- itemkey - key of the current item
922 -- actid - process activity instance id
923 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
924 -- OUT
925 -- result
926 -- - COMPLETE
927 -- activity has completed
928 PROCEDURE SET_ADMIN_STATUS_MONITOR_URL(
929 itemtype in varchar2,
930 itemkey in varchar2,
931 actid in number,
932 funcmode in varchar2,
933 result in out NOCOPY varchar2);
934
935
936 --
937 -- PROCEDURE SET_EVENT_CHANGE_OBJECT_INFO
938 --
939 -- Set Change Object information
940 --
941 -- IN
942 -- itemtype - type of the current item
943 -- itemkey - key of the current item
944 -- actid - process activity instance id
945 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
946 -- OUT
947 -- result
948 -- - COMPLETE
949 -- activity has completed
950 PROCEDURE SET_EVENT_CHANGE_OBJECT_INFO(
951 itemtype in varchar2,
952 itemkey in varchar2,
953 actid in number,
954 funcmode in varchar2,
955 result in out NOCOPY varchar2);
956
957
958 /**********************************
959 --
960 -- NOT SUPPORTING IN 115.10
961 -- PROCEDURE CONTINUE_HEADER_ROUTE
962 --
963 -- Signal Flow to continue to Header Route
964 --
965 -- IN
966 -- itemtype - type of the current item
967 -- itemkey - key of the current item
968 -- actid - process activity instance id
969 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
970 -- OUT
971 -- result
972 -- - COMPLETE
973 -- activity has completed
974 PROCEDURE CONTINUE_HEADER_ROUTE(
975 itemtype in varchar2,
976 itemkey in varchar2,
977 actid in number,
978 funcmode in varchar2,
979 result in out NOCOPY varchar2);
980
981
982
983 --
984 -- NOT SUPPORTING IN 115.10
985 -- PROCEDURE WAIT_FOR_LINE_ROUTE
986 --
987 -- Wait for Line Route flow to complete
988 --
989 -- IN
990 -- itemtype - type of the current item
991 -- itemkey - key of the current item
992 -- actid - process activity instance id
993 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
994 -- OUT
995 -- result
996 -- - NULL
997 -- activity has completed
998 PROCEDURE WAIT_FOR_LINE_ROUTE(
999 itemtype in varchar2,
1000 itemkey in varchar2,
1001 actid in number,
1002 funcmode in varchar2,
1003 result in out NOCOPY varchar2);
1004
1005 *****************************************/
1006
1007 END Eng_Workflow_Pub ;