1 PACKAGE IGP_VW_GEN_001_PKG AS
2 /* $Header: IGSPVWAS.pls 120.0 2005/06/01 12:33:06 appldev noship $ */
3
4 /* +=======================================================================+
5 | Copyright (c) 2000 Oracle Corporation, Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +=======================================================================+
8 | NAME |
9 | IGPVW01B.pls |
10 | |
11 | DESCRIPTION |
12 | This package provides service functions and procedures to |
13 | support user name generation WF |
14 | |
15 | NOTES |
16 | |
17 | DEPENDENCIES |
18 | |
19 | USAGE |
20 | |
21 | HISTORY |
22 | 04-APR-2001 ssawhney Created |
23 +=======================================================================+ */
24
25 g_message_text VARCHAR2(32000);
26
27 -- create adhoc role for viewers and assign
28 -- individual viewers from the list p_viewer_ids
29 PROCEDURE Create_Viewers_Role(
30 itemtype IN VARCHAR2,
31 itemkey IN VARCHAR2,
32 p_viewer_ids IN varchar2,
33 p_portfolio_ids IN varchar2 ) ;
34
35 -- write viewer HTML message into CLOB for notification
36 -- standard format from WF team.
37 PROCEDURE Write_Viewer_Message
38 (
39 document_id IN VARCHAR2,
40 display_type IN VARCHAR2,
41 document IN OUT NOCOPY CLOB,
42 document_type IN OUT NOCOPY VARCHAR2
43 ) ;
44
45 --called from WF linked with inform viewer BE.
46 PROCEDURE Get_Viewer_Inform_Det (
47 itemtype IN VARCHAR2,
48 itemkey IN VARCHAR2,
49 actid IN NUMBER ,
50 funcmode IN VARCHAR2,
51 resultout OUT NOCOPY VARCHAR2);
52
53 -- this raise the inform Viewer for Assignment BE.
54 PROCEDURE Raise_Assign_Event(
55 p_viewer_ids IN varchar2,
56 p_portfolio_ids IN varchar2,
57 p_access_exp_date IN varchar2
58 );
59
60 -- create static HTML for author.
61 PROCEDURE Create_Author_Message
62 (p_viewer_ids IN VARCHAR2,
63 p_message_text OUT NOCOPY VARCHAR) ;
64
65 -- this raise the inform Author for Assignment BE.
66 PROCEDURE Raise_Inform_Author_Event
67 (
68 p_viewer_ids IN varchar2,
69 p_portfolio_ids IN varchar2
70 );
71
72 -- write author HTML message into CLOB for notification
73 -- standard format from WF team.
74 PROCEDURE Write_Author_Message
75 (
76 document_id IN VARCHAR2,
77 display_type IN VARCHAR2,
78 document IN OUT NOCOPY CLOB,
79 document_type IN OUT NOCOPY VARCHAR2
80 ) ;
81
82 -- called from WF linked with inform author BE.
83 PROCEDURE Get_Author_Det (
84 itemtype IN VARCHAR2,
85 itemkey IN VARCHAR2,
86 actid IN NUMBER ,
87 funcmode IN VARCHAR2,
88 resultout OUT NOCOPY VARCHAR2);
89
90
91
92 END IGP_VW_GEN_001_PKG;