1 PACKAGE IGP_VW_GEN_002_PKG AS
2 /* $Header: IGSPVWBS.pls 120.0 2005/06/01 20:29:20 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 Business Events for Removing Portfolios from Access List |
14 | |
15 | NOTES |
16 | |
17 | DEPENDENCIES |
18 | |
19 | USAGE |
20 | |
21 | HISTORY |
22 | 04-APR-2001 ssawhney Created |
23 +=======================================================================+ */
24
25
26
27 -- create adhoc role for Career Center and assign
28 -- individual CC users from the static select for FND users holding that responsibility.
29 PROCEDURE Create_CC_Role(
30 itemtype IN VARCHAR2,
31 itemkey IN VARCHAR2
32 ) ;
33
34 -- write HTML message into CLOB for notification to go to Career Centre
35 -- standard format from WF team.
36 PROCEDURE Write_CC_Message
37 (
38 document_id IN VARCHAR2,
39 display_type IN VARCHAR2,
40 document IN OUT NOCOPY CLOB,
41 document_type IN OUT NOCOPY VARCHAR2
42 ) ;
43
44 --called from WF linked with inform CC about the removal of access from viewer.
45 PROCEDURE Get_Inform_Det (
46 itemtype IN VARCHAR2,
47 itemkey IN VARCHAR2,
48 actid IN NUMBER ,
49 funcmode IN VARCHAR2,
50 resultout OUT NOCOPY VARCHAR2);
51
52 -- this raise the inform CC for Removal of Assignment BE.
53 PROCEDURE Raise_Removal_Event_CC(
54 p_viewer_id IN varchar2,
55 p_portfolio_ids IN varchar2,
56 p_CC_user_name IN varchar2
57 );
58
59
60 -- this raise the inform Author for Removal of Assignment BE.
61 PROCEDURE Raise_Inform_Author_Event
62 (
63 p_viewer_id IN varchar2,
64 p_portfolio_ids IN varchar2,
65 p_CC_user_name IN varchar2
66 );
67
68
69 -- called from WF linked with inform author for removal of Assignment BE.
70 PROCEDURE Get_Author_Det (
71 itemtype IN VARCHAR2,
72 itemkey IN VARCHAR2,
73 actid IN NUMBER ,
74 funcmode IN VARCHAR2,
75 resultout OUT NOCOPY VARCHAR2);
76
77
78 --Procedure to check the action of the workflow.if it a removal workflow or an invalid assignment workflow.
79 PROCEDURE chk_action (
80 itemtype IN VARCHAR2,
81 itemkey IN VARCHAR2,
82 actid IN NUMBER ,
83 funcmode IN VARCHAR2,
84 resultout OUT NOCOPY VARCHAR2);
85
86 -- this raise the inform CC for invalid Assignments.
87 PROCEDURE Raise_invalid_assign_Event_CC(
88 p_invalid_assignments IN varchar2
89 );
90
91 PROCEDURE Get_invalid_assign_Det (
92 itemtype IN VARCHAR2,
93 itemkey IN VARCHAR2,
94 actid IN NUMBER ,
95 funcmode IN VARCHAR2,
96 resultout OUT NOCOPY VARCHAR2);
97
98 PROCEDURE Write_CC_invalid_assign_Mes
99 (
100 document_id IN VARCHAR2,
101 display_type IN VARCHAR2,
102 document IN OUT NOCOPY CLOB,
103 document_type IN OUT NOCOPY VARCHAR2
104 );
105
106 PROCEDURE chk_source (
107 itemtype IN VARCHAR2,
108 itemkey IN VARCHAR2,
109 actid IN NUMBER ,
110 funcmode IN VARCHAR2,
111 resultout OUT NOCOPY VARCHAR2);
112
113 END IGP_VW_GEN_002_PKG;