1 PACKAGE EGO_GROUP_WF_PKG AUTHID CURRENT_USER AS
2 /* $Header: EGOPGWFS.pls 115.3 2003/09/19 10:53:35 srajapar noship $ */
3
4 TYPE VARCHAR_TBL_TYPE IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
5
6 ----------------------------------------------------------------------------
7 -- 1. Start_Add_Group_Member_Process
8 ----------------------------------------------------------------------------
9 PROCEDURE Start_Add_Group_Member_Process
10 (
11 p_group_id IN NUMBER,
12 p_group_name IN VARCHAR2,
13 p_member_id IN NUMBER,
14 p_member_name IN VARCHAR2,
15 p_name_value_pairs IN VARCHAR2
16 );
17
18 ------------------------------------------------------------------------
19 -- Start OF comments
20 -- API name : Start_Add_Group_Member_Process
21 -- TYPE : Public
22 -- Pre-reqs : None
23 -- FUNCTION : Starts the workflow process to Add Group Member.
24 --
25 -- Parameters:
26 -- IN : p_group_id IN NUMBER (Required)
27 -- Group Id
28 --
29 -- IN : p_group_name IN VARCHAR2 (Required)
30 -- Group Name
31 -- used to set the Workflow item attribute
32 --
33 -- IN : p_member_id IN NUMBER (Required)
34 -- Member Id
35 --
36 -- IN : p_member_name IN VARCHAR2 (Required)
37 -- Member Name
38 -- used to set the Workflow item attribute
39 -- IN : p_name_value_pairs IN VARCHAR2 (Optional)
40 -- Name value pairs provided as XML string
41 -- This is parsed by : Parse_Name_Value_Pairs_Msg
42 -- which creates a x_name_tbl and x_value_tbl
43 -- These are used to set the item attributes for the
44 -- EGOGROUP workflow item type
45 --
46 -- HISTORY
47 -- 22-JUL-2002 Sridhar Rajaparthi Created
48 --
49 -- Notes :
50 --
51 -- END OF comments
52 ------------------------------------------------------------------------
53
54
55 ----------------------------------------------------------------------------
56 -- 2. Start_Rem_Group_Member_Process
57 ----------------------------------------------------------------------------
58
59 PROCEDURE Start_Rem_Group_Member_Process
60 (
61 p_group_id IN NUMBER,
62 p_group_name IN VARCHAR2,
63 p_member_id IN NUMBER,
64 p_member_name IN VARCHAR2,
65 p_name_value_pairs IN VARCHAR2
66 );
67 ------------------------------------------------------------------------
68 -- Start OF comments
69 -- API name : Start_Rem_Group_Member_Process
70 -- TYPE : Public
71 -- Pre-reqs : None
72 -- FUNCTION : Starts the workflow process to Remove Group Member.
73 --
74 -- Parameters:
75 -- IN : p_group_id IN NUMBER (Required)
76 -- Group Id
77 --
78 -- IN : p_group_name IN VARCHAR2 (Required)
79 -- Group Name
80 -- used to set the Workflow item attribute
81 --
82 -- IN : p_member_id IN NUMBER (Required)
83 -- Member Id
84 --
85 -- IN : p_member_name IN VARCHAR2 (Required)
86 -- Member Name
87 -- used to set the Workflow item attribute
88 --
89 -- IN : p_name_value_pairs IN VARCHAR2 (Optional)
90 -- Name value pairs provided as XML string
91 -- This is parsed by : Parse_Name_Value_Pairs_Msg
92 -- which creates a x_name_tbl and x_value_tbl
93 -- These are used to set the item attributes for the
94 -- EGOGROUP workflow item type
95 --
96 -- HISTORY
97 -- 22-JUL-2002 Sridhar Rajaparthi Created
98 --
99 -- Notes :
100 --
101 -- END OF comments
102 ------------------------------------------------------------------------
103
104 ----------------------------------------------------------------------------
105 -- 4. Start_Delete_Group_Process
106 ----------------------------------------------------------------------------
107 PROCEDURE Start_Delete_Group_Process
108 (
109 p_group_id IN NUMBER,
110 p_group_name IN VARCHAR2,
111 p_name_value_pairs IN VARCHAR2
112 );
113
114 ------------------------------------------------------------------------
115 -- Start OF comments
116 -- API name : Start_Delete_Group_Process
117 -- TYPE : Public
118 -- Pre-reqs : None
119 -- FUNCTION : Starts the workflow process to Delete Group.
120 --
121 --
122 -- Parameters:
123 -- IN : p_group_id IN NUMBER (Required)
124 -- Group Id
125 --
126 -- IN : p_group_name IN VARCHAR2 (Required)
127 -- Group Name
128 -- used to set the Workflow item attribute
129 --
130 -- IN : p_name_value_pairs IN VARCHAR2 (Optional)
131 -- Name value pairs provided as XML string
132 -- This is parsed by :
133 -- IPD_DM_FND_PUB.Parse_Name_Value_Pairs_Msg
134 -- which creates a x_name_tbl and x_value_tbl
135 -- These are used to set the item attributes for the
136 -- IPDGROUP workflow item type
137 --
138 -- HISTORY
139 -- 22-JUL-2002 Sridhar Rajaparthi Created
140 --
141 -- Notes :
142 --
143 -- END OF comments
144 ------------------------------------------------------------------------
145
146
147 ----------------------------------------------------------------------------
148 -- 5. Start_Unsub_Owner_Notf_Process
149 ----------------------------------------------------------------------------
150 PROCEDURE Start_Unsub_Owner_Notf_Process
151 (
152 p_group_id IN NUMBER,
153 p_group_name IN VARCHAR2,
154 p_member_id IN NUMBER,
155 p_member_name IN VARCHAR2,
156 p_name_value_pairs IN VARCHAR2
157 );
158 ------------------------------------------------------------------------
159 -- Start OF comments
160 -- API name : Start_Unsub_Owner_Notf_Process
161 -- TYPE : Public
162 -- Pre-reqs : None
163 -- FUNCTION : Starts the workflow process to Remove Group Member.
164 --
165 --
166 -- Parameters:
167 -- IN : p_group_id IN NUMBER (Required)
168 -- Group Id
169 --
170 -- IN : p_group_name IN VARCHAR2 (Required)
171 -- Group Name
172 -- used to set the Workflow item attribute
173 --
174 -- IN : p_member_id IN NUMBER (Required)
175 -- Member Id
176 --
177 -- IN : p_member_name IN VARCHAR2 (Required)
178 -- Member Name
179 -- used to set the Workflow item attribute
180 --
181 -- IN : p_name_value_pairs IN VARCHAR2 (Optional)
182 -- Name value pairs provided as XML string
183 -- This is parsed by :
184 -- IPD_DM_FND_PUB.Parse_Name_Value_Pairs_Msg
185 -- which creates a x_name_tbl and x_value_tbl
186 -- These are used to set the item attributes for the
187 -- IPDGROUP workflow item type
188 --
189 -- HISTORY
190 -- 22-JUL-2002 Sridhar Rajaparthi Created
191 --
192 -- Notes :
193 --
194 -- END OF comments
195 ------------------------------------------------------------------------
196
197
198 ----------------------------------------------------------------------------
199 -- 6. Start_Subsc_Owner_Notf_Process
200 ----------------------------------------------------------------------------
201 PROCEDURE Start_Subsc_Owner_Notf_Process
202 (
203 p_group_id IN NUMBER,
204 p_group_name IN VARCHAR2,
205 p_member_id IN NUMBER,
206 p_member_name IN VARCHAR2,
207 p_name_value_pairs IN VARCHAR2
208 );
209 ------------------------------------------------------------------------
210 -- Start OF comments
211 -- API name : Start_Subsc_Owner_Notf_Process
212 -- TYPE : Public
213 -- Pre-reqs : None
214 -- FUNCTION : Starts the workflow process to Remove Group Member.
215 --
216 --
217 -- Parameters:
218 -- IN : p_group_id IN NUMBER (Required)
219 -- Group Id
220 --
221 -- IN : p_group_name IN VARCHAR2 (Required)
222 -- Group Name
223 -- used to set the Workflow item attribute
224 --
225 -- IN : p_member_id IN NUMBER (Required)
226 -- Member Id
227 --
228 -- IN : p_member_name IN VARCHAR2 (Required)
229 -- Member Name
230 -- used to set the Workflow item attribute
231 --
232 -- IN : p_name_value_pairs IN VARCHAR2 (Optional)
233 -- Name value pairs provided as XML string
234 -- This is parsed by :
235 -- IPD_DM_FND_PUB.Parse_Name_Value_Pairs_Msg
236 -- which creates a x_name_tbl and x_value_tbl
237 -- These are used to set the item attributes for the
238 -- IPDGROUP workflow item type
239 --
240 -- HISTORY
241 -- 22-JUL-2002 Sridhar Rajaparthi Created
242 --
243 -- Notes :
244 --
245 -- END OF comments
246 ------------------------------------------------------------------------
247
248
249 ----------------------------------------------------------------------------
250 -- 7. Add_Group_Member
251 ----------------------------------------------------------------------------
252 PROCEDURE Add_Group_Member
253 (
254 p_item_type IN VARCHAR2,
255 p_item_key IN VARCHAR2,
259 );
256 p_actid IN NUMBER,
257 p_funcmode IN VARCHAR2,
258 x_result OUT NOCOPY VARCHAR2
260 ------------------------------------------------------------------------
261 -- Start OF comments
262 -- API name : Add_Group_Member
263 -- TYPE : Public
264 -- Pre-reqs : None
265 -- FUNCTION : Adds the group member (called after 'Approval' from
266 -- the owner of the group)
267 --
268 -- Parameters:
269 -- IN : p_item_type IN VARCHAR2 (Required)
270 -- Item type of the workflow
271 --
272 -- IN : p_item_key IN VARCHAR2 (Required)
273 -- Item key of the workflow
274 --
275 -- IN : p_actid IN NUMBER (Required)
276 -- action
277 --
278 -- IN : p_funcmode IN VARCHAR2 (Required)
279 -- function mode
280 --
281 -- OUT :
282 -- x_result OUT VARCHAR2
283 -- Status of the workflow activity.
284 -- x_result can be 'COMPLETE','WAITING','ERROR','NOTIFIED','SUSPENDED','DEFERRED' .
285 --
286 --
287 -- called from:
288 -- Workflow - ADD_GROUP_MEMBER function
289 --
290 -- HISTORY
291 -- 22-JUL-2002 Sridhar Rajaparthi Created
292 --
293 -- Notes :
294 --
295 -- END OF comments
296 ------------------------------------------------------------------------
297
298
299 ----------------------------------------------------------------------------
300 -- 8. Remove_Group_Member
301 ----------------------------------------------------------------------------
302 PROCEDURE Remove_Group_Member
303 (
304 p_item_type IN VARCHAR2,
305 p_item_key IN VARCHAR2,
306 p_actid IN NUMBER,
307 p_funcmode IN VARCHAR2,
308 x_result OUT NOCOPY VARCHAR2
309 );
310 ------------------------------------------------------------------------
311 -- Start OF comments
312 -- API name : Remove_Group_Member
313 -- TYPE : Public
314 -- Pre-reqs : None
315 -- FUNCTION : Removes the group member (called after 'Approval' from
316 -- the owner of the group)
317 --
318 --
319 -- Parameters:
320 -- IN : p_item_type IN VARCHAR2 (Required)
321 -- Item type of the workflow
322 --
323 -- IN : p_item_key IN VARCHAR2 (Required)
324 -- Item key of the workflow
325 --
326 -- IN : p_actid IN NUMBER (Required)
327 -- action
328 --
329 -- IN : p_funcmode IN VARCHAR2 (Required)
330 -- function mode
331 --
332 -- OUT :
333 -- x_result OUT VARCHAR2
334 -- Status of the workflow activity.
335 -- x_result can be 'COMPLETE','WAITING','ERROR','NOTIFIED','SUSPENDED','DEFERRED' .
336 --
337 --
338 -- called from:
339 -- Workflow - REMOVE_GROUP_MEMBER function
340 --
341 --
342 -- HISTORY
343 -- 22-JUL-2002 Sridhar Rajaparthi Created
344 --
345 -- Notes :
346 --
347 -- END OF comments
348 ------------------------------------------------------------------------
349
350
351 ----------------------------------------------------------------------------
352 -- 9. Delete_Group
353 ----------------------------------------------------------------------------
354 PROCEDURE Delete_Group
355 (
356 p_item_type IN VARCHAR2,
357 p_item_key IN VARCHAR2,
358 p_actid IN NUMBER,
359 p_funcmode IN VARCHAR2,
360 x_result OUT NOCOPY VARCHAR2
361 );
362 ------------------------------------------------------------------------
366 -- Pre-reqs : None
363 -- Start OF comments
364 -- API name : Delete_Group
365 -- TYPE : Public
367 -- FUNCTION : Deletes a group
368 --
369 --
370 -- Parameters:
371 -- IN : p_item_type IN VARCHAR2 (Required)
372 -- Item type of the workflow
373 --
374 -- IN : p_item_key IN VARCHAR2 (Required)
375 -- Item key of the workflow
376 --
377 -- IN : p_actid IN NUMBER (Required)
378 -- action
379 --
380 -- IN : p_funcmode IN VARCHAR2 (Required)
381 -- function mode
382 --
383 -- OUT :
384 -- x_result OUT VARCHAR2
385 -- Status of the workflow activity.
386 -- x_result can be 'COMPLETE','WAITING','ERROR','NOTIFIED','SUSPENDED','DEFERRED' .
387 --
388 --
389 -- called from:
390 -- Workflow - DELETE_GROUP function
391 --
392 --
393 -- HISTORY
394 -- 22-JUL-2002 Sridhar Rajaparthi Created
395 --
396 -- Notes :
397 --
398 -- END OF comments
399 ------------------------------------------------------------------------
400
401
402 ----------------------------------------------------------------------------
403 -- 10. Group_Del_Ntf_All_Members
404 ----------------------------------------------------------------------------
405 PROCEDURE Group_Del_Ntf_All_Members
406 (
407 p_item_type IN VARCHAR2,
408 p_item_key IN VARCHAR2,
409 p_actid IN NUMBER,
410 p_funcmode IN VARCHAR2,
411 x_result OUT NOCOPY VARCHAR2
412 );
413 ------------------------------------------------------------------------
414 -- Start OF comments
415 -- API name : Group_Del_Ntf_All_Members
416 -- TYPE : Public
417 -- Pre-reqs : None
418 -- FUNCTION : Notifies all members of a group
419 --
420 --
421 --
422 -- Parameters:
423 -- IN : p_item_type IN VARCHAR2 (Required)
424 -- Item type of the workflow
425 --
426 -- IN : p_item_key IN VARCHAR2 (Required)
427 -- Item key of the workflow
428 --
429 -- IN : p_actid IN NUMBER (Required)
430 -- action
431 --
432 -- IN : p_funcmode IN VARCHAR2 (Required)
433 -- function mode
434 --
435 -- OUT :
436 -- x_result OUT VARCHAR2
437 -- Status of the workflow activity.
438 -- x_result can be 'COMPLETE','WAITING','ERROR','NOTIFIED','SUSPENDED','DEFERRED' .
439 --
440 --
441 -- called from:
442 -- Workflow - GROUP_DEL_NTF_ALL_MEMBERS function
443 --
444 --
445 -- HISTORY
446 -- 22-JUL-2002 Sridhar Rajaparthi Created
447 --
448 -- Notes :
449 --
450 -- END OF comments
451 ------------------------------------------------------------------------
452
453
457 PROCEDURE Add_GrpMem_Approval_Req_Doc
454 ----------------------------------------------------------------------------
455 -- 11. Add_GrpMem_Approval_Req_Doc
456 ----------------------------------------------------------------------------
458 (
459 document_id IN VARCHAR2,
460 display_type IN VARCHAR2,
461 document IN OUT NOCOPY VARCHAR2,
462 document_type IN OUT NOCOPY VARCHAR2
463 );
464 ------------------------------------------------------------------------
465 -- Start OF comments
466 -- API name : Add_GrpMem_Approval_Req_Doc
467 -- TYPE : Public
468 -- Pre-reqs : None
469 -- FUNCTION : Prepares Message Document
470 --
471 -- Called through following format:
472 -- PLSQL:<package.procedure>/<Document ID>
473 --
474 -- A PL/SQL Document is generated with display type of 'text/html'
475 -- when the message is viewed through web page. Else it is 'text/plain'
476 --
477 --
478 -- Parameters:
479 -- IN : document_id IN VARCHAR2 (Required)
480 -- document id
481 --
482 -- IN : display_type IN VARCHAR2 (Required)
483 -- display type is either 'text/html' or 'text/plain'
484 --
485 -- OUT :
486 -- : document IN VARCHAR2 (Required)
487 --
488 -- : document_type IN VARCHAR2 (Required)
489 -- document type is either 'text/html' or 'text/plain'
490 --
491 -- called from:
492 -- Workflow - SUBSCRIPTION_REQUEST function
493 --
494 -- HISTORY
495 -- 22-JUL-2002 Sridhar Rajaparthi Created
496 --
497 -- Notes :
498 --
499 -- END OF comments
500 ------------------------------------------------------------------------
501
502 ----------------------------------------------------------------------------
503 -- 12. Add_GrpMem_Reject_Msg_Doc
504 ----------------------------------------------------------------------------
505 PROCEDURE Add_GrpMem_Reject_Msg_Doc
506 (
507 document_id IN VARCHAR2,
508 display_type IN VARCHAR2,
509 document IN OUT NOCOPY VARCHAR2,
510 document_type IN OUT NOCOPY VARCHAR2
511 );
512 ------------------------------------------------------------------------
513 -- Start OF comments
514 -- API name : Add_GrpMem_Reject_Msg_Doc
515 -- TYPE : Public
516 -- Pre-reqs : None
517 -- FUNCTION : Prepares Message Document
518 --
519 -- Called through following format:
520 -- PLSQL:<package.procedure>/<Document ID>
521 --
522 -- A PL/SQL Document is generated with display type of 'text/html'
523 -- when the message is viewed through web page. Else it is 'text/plain'
524 --
525 --
526 -- Parameters:
527 -- IN : document_id IN VARCHAR2 (Required)
528 -- document id
529 --
530 -- IN : display_type IN VARCHAR2 (Required)
531 -- display type is either 'text/html' or 'text/plain'
532 --
533 -- OUT :
534 -- : document IN VARCHAR2 (Required)
535 --
536 -- : document_type IN VARCHAR2 (Required)
537 -- document type is either 'text/html' or 'text/plain'
538 --
539 -- called from:
540 -- Workflow - SUBSCRIPTION_REQUEST function
541 --
542 -- HISTORY
543 -- 01-SEP-2003 Sridhar Rajaparthi Created
544 --
545 -- Notes :
546 --
547 -- END OF comments
548 ------------------------------------------------------------------------
549
550 ----------------------------------------------------------------------------
551 -- 13. Add_GrpMem_Approval_Msg_Doc
552 ----------------------------------------------------------------------------
553 PROCEDURE Add_GrpMem_Approval_Msg_Doc
554 (
555 document_id IN VARCHAR2,
556 display_type IN VARCHAR2,
557 document IN OUT NOCOPY VARCHAR2,
558 document_type IN OUT NOCOPY VARCHAR2
559 );
560 ------------------------------------------------------------------------
561 -- Start OF comments
562 -- API name : Add_GrpMem_Approval_Msg_Doc
563 -- TYPE : Public
564 -- Pre-reqs : None
565 -- FUNCTION : Prepares Message Document
566 --
567 -- Called through following format:
571 -- when the message is viewed through web page. Else it is 'text/plain'
568 -- PLSQL:<package.procedure>/<Document ID>
569 --
570 -- A PL/SQL Document is generated with display type of 'text/html'
572 --
573 --
574 -- Parameters:
575 -- IN : document_id IN VARCHAR2 (Required)
576 -- document id
577 --
578 -- IN : display_type IN VARCHAR2 (Required)
579 -- display type is either 'text/html' or 'text/plain'
580 --
581 -- OUT :
582 -- : document IN VARCHAR2 (Required)
583 --
584 -- : document_type IN VARCHAR2 (Required)
585 -- document type is either 'text/html' or 'text/plain'
586 --
587 -- called from:
588 -- Workflow - SUBSCRIPTION_REQUEST function
589 --
590 -- HISTORY
591 -- 01-SEP-2003 Sridhar Rajaparthi Created
592 --
593 -- Notes : Created as a part of BUG 3096076
594 --
595 -- END OF comments
596 ------------------------------------------------------------------------
597
598 ----------------------------------------------------------------------------
599 -- 14. Unsub_Member_Owner_FYI_Doc
600 ----------------------------------------------------------------------------
601 PROCEDURE Unsub_Member_Owner_FYI_Doc
602 (
603 document_id IN VARCHAR2,
604 display_type IN VARCHAR2,
605 document IN OUT NOCOPY VARCHAR2,
606 document_type IN OUT NOCOPY VARCHAR2
607 );
608 ------------------------------------------------------------------------
609 -- Start OF comments
610 -- API name : Unsub_Member_Owner_FYI_Doc
611 -- TYPE : Public
612 -- Pre-reqs : None
613 -- FUNCTION : Prepares Message Document
614 --
615 -- Called through following format:
616 -- PLSQL:<package.procedure>/<Document ID>
617 --
618 -- A PL/SQL Document is generated with display type of 'text/html'
619 -- when the message is viewed through web page. Else it is 'text/plain'
620 --
621 --
622 -- Parameters:
623 -- IN : document_id IN VARCHAR2 (Required)
624 -- document id
625 --
626 -- IN : display_type IN VARCHAR2 (Required)
627 -- display type is either 'text/html' or 'text/plain'
628 --
629 -- OUT :
630 -- : document IN VARCHAR2 (Required)
631 --
632 -- : document_type IN VARCHAR2 (Required)
633 -- document type is either 'text/html' or 'text/plain'
634 --
635 -- called from:
636 -- Workflow - SUBSCRIPTION_REQUEST function
637 --
638 -- HISTORY
639 -- 01-SEP-2003 Sridhar Rajaparthi Created
640 --
641 -- Notes : Created as a part of BUG 3096076
642 --
643 -- END OF comments
647 -- 15. Unsub_Member_Conf_Mem_Doc
644 ------------------------------------------------------------------------
645
646 ----------------------------------------------------------------------------
648 ----------------------------------------------------------------------------
649 PROCEDURE Unsub_Member_Conf_Mem_Doc
650 (
651 document_id IN VARCHAR2,
652 display_type IN VARCHAR2,
653 document IN OUT NOCOPY VARCHAR2,
654 document_type IN OUT NOCOPY VARCHAR2
655 );
656
657 ------------------------------------------------------------------------
658 -- Start OF comments
659 -- API name : Unsub_Member_Conf_Mem_Doc
660 -- TYPE : Public
661 -- Pre-reqs : None
662 -- FUNCTION : Prepares Message Document
663 --
664 -- Called through following format:
665 -- PLSQL:<package.procedure>/<Document ID>
666 --
667 -- A PL/SQL Document is generated with display type of 'text/html'
668 -- when the message is viewed through web page. Else it is 'text/plain'
669 --
670 --
671 -- Parameters:
672 -- IN : document_id IN VARCHAR2 (Required)
673 -- document id
674 --
675 -- IN : display_type IN VARCHAR2 (Required)
676 -- display type is either 'text/html' or 'text/plain'
677 --
678 -- OUT :
679 -- : document IN VARCHAR2 (Required)
680 --
681 -- : document_type IN VARCHAR2 (Required)
682 -- document type is either 'text/html' or 'text/plain'
683 --
684 -- called from:
685 -- Workflow - SUBSCRIPTION_REQUEST function
686 --
687 -- HISTORY
688 -- 01-SEP-2003 Sridhar Rajaparthi Created
689 --
690 -- Notes : Created as a part of BUG 3096076
691 --
692 -- END OF comments
693 ------------------------------------------------------------------------
694
695 ----------------------------------------------------------------------------
696 -- 16. Del_Grp_Admin_Notif_Doc
697 ----------------------------------------------------------------------------
698 PROCEDURE Del_Grp_Admin_Notif_Doc
699 (
700 document_id IN VARCHAR2,
701 display_type IN VARCHAR2,
702 document IN OUT NOCOPY VARCHAR2,
703 document_type IN OUT NOCOPY VARCHAR2
704 );
705 ------------------------------------------------------------------------
706 -- Start OF comments
707 -- API name : Del_Grp_Admin_Notif_Doc
708 -- TYPE : Public
709 -- Pre-reqs : None
710 -- FUNCTION : Prepares Message Document
711 --
712 -- Called through following format:
713 -- PLSQL:<package.procedure>/<Document ID>
714 --
715 -- A PL/SQL Document is generated with display type of 'text/html'
716 -- when the message is viewed through web page. Else it is 'text/plain'
717 --
718 --
719 -- Parameters:
720 -- IN : document_id IN VARCHAR2 (Required)
721 -- document id
722 --
723 -- IN : display_type IN VARCHAR2 (Required)
724 -- display type is either 'text/html' or 'text/plain'
725 --
726 -- OUT :
727 -- : document IN VARCHAR2 (Required)
728 --
729 -- : document_type IN VARCHAR2 (Required)
730 -- document type is either 'text/html' or 'text/plain'
731 --
732 -- called from:
733 -- Workflow - SUBSCRIPTION_REQUEST function
734 --
735 -- HISTORY
736 -- 01-SEP-2003 Sridhar Rajaparthi Created
737 --
738 -- Notes : Created as a part of BUG 3096076
739 --
740 -- END OF comments
741 ------------------------------------------------------------------------
742
743 ----------------------------------------------------------------------------
744 -- 17. Del_Grp_Mem_Notif_Doc
745 ----------------------------------------------------------------------------
746 PROCEDURE Del_Grp_Mem_Notif_Doc
747 (
748 document_id IN VARCHAR2,
749 display_type IN VARCHAR2,
750 document IN OUT NOCOPY VARCHAR2,
754 -- Start OF comments
751 document_type IN OUT NOCOPY VARCHAR2
752 );
753 ------------------------------------------------------------------------
755 -- API name : Del_Grp_Mem_Notif_Doc
756 -- TYPE : Public
757 -- Pre-reqs : None
758 -- FUNCTION : Prepares Message Document
759 --
760 -- Called through following format:
761 -- PLSQL:<package.procedure>/<Document ID>
762 --
763 -- A PL/SQL Document is generated with display type of 'text/html'
764 -- when the message is viewed through web page. Else it is 'text/plain'
765 --
766 --
767 -- Parameters:
768 -- IN : document_id IN VARCHAR2 (Required)
769 -- document id
770 --
771 -- IN : display_type IN VARCHAR2 (Required)
772 -- display type is either 'text/html' or 'text/plain'
773 --
774 -- OUT :
775 -- : document IN VARCHAR2 (Required)
776 --
777 -- : document_type IN VARCHAR2 (Required)
778 -- document type is either 'text/html' or 'text/plain'
779 --
780 -- called from:
781 -- Workflow - SUBSCRIPTION_REQUEST function
782 --
783 -- HISTORY
784 -- 01-SEP-2003 Sridhar Rajaparthi Created
785 --
786 -- Notes : Created as a part of BUG 3096076
787 --
788 -- END OF comments
789 ------------------------------------------------------------------------
790
794 PROCEDURE Get_Responder_name
791 ----------------------------------------------------------------------------
792 -- 18. Get_Responder_Name
793 ----------------------------------------------------------------------------
795 (itemtype IN VARCHAR2 ,
796 itemkey IN VARCHAR2 ,
797 actid IN NUMBER ,
798 funcmode IN VARCHAR2 ,
799 resultout OUT NOCOPY VARCHAR2
800 );
801 ------------------------------------------------------------------------
802 -- Start OF comments
803 -- API name : Get_Responder_name
804 -- TYPE : Public
805 -- Pre-reqs : None
806 -- FUNCTION : Get the responder's name and store the same in
807 -- WF Attribute
808 --
809 -- Parameters:
810 -- IN : itemtype IN VARCHAR2 (Required)
811 -- Item type of the workflow
812 --
813 -- IN : itemkey IN VARCHAR2 (Required)
814 -- Item key of the workflow
815 --
816 -- IN : actid IN NUMBER (Required)
817 -- action
818 --
819 -- IN : funcmode IN VARCHAR2 (Required)
820 -- function mode
821 --
822 -- OUT : resultout OUT VARCHAR2
823 -- Status of the workflow activity.
824 --
825 --
826 -- called from:
827 -- Workflow - processes
828 --
829 -- HISTORY
830 -- 13-FEB-2003 Sridhar Rajaparthi Created
831 --
832 -- Notes : Created as a part of BUG 3096076
833 --
834 -- END OF comments
835 ------------------------------------------------------------------------
836
837 ----------------------------------------------------------------------------
838 -- 19. Create_Grp_Admin_WF_Role
839 ----------------------------------------------------------------------------
840 PROCEDURE create_grp_admin_wf_role
841 (itemtype IN VARCHAR2 ,
842 itemkey IN VARCHAR2 ,
843 actid IN NUMBER ,
844 funcmode IN VARCHAR2 ,
845 resultout OUT NOCOPY VARCHAR2
846 );
847 ------------------------------------------------------------------------
848 -- Start OF comments
849 -- API name : create_wf_role
850 -- TYPE : Public
851 -- Pre-reqs : None
852 -- FUNCTION : Crates a dynamic role of the group administrators
853 --
854 -- Parameters:
855 -- IN : itemtype IN VARCHAR2 (Required)
856 -- Item type of the workflow
857 --
858 -- IN : itemkey IN VARCHAR2 (Required)
859 -- Item key of the workflow
860 --
861 -- IN : actid IN NUMBER (Required)
862 -- action
863 --
864 -- IN : funcmode IN VARCHAR2 (Required)
865 -- function mode
866 --
867 -- OUT : resultout OUT VARCHAR2
868 -- Status of the workflow activity.
869 --
870 --
871 -- called from:
872 -- Workflow - processes
873 --
874 -- HISTORY
875 -- 13-FEB-2003 Sridhar Rajaparthi Created
876 --
877 -- Notes :
878 --
879 -- END OF comments
880 ------------------------------------------------------------------------
881
882 END EGO_GROUP_WF_PKG;
[Home] [Help]