1 PACKAGE ZPB_WF_NTF AS
2 /* $Header: zpbwfntf.pls 120.3 2007/12/04 16:23:42 mbhat ship $ */
3
4
5 PROCEDURE SETROLE (AdHocRole in varchar2, ExpDays in number, RoleDisplay in varchar2 default NULL);
6
7 PROCEDURE REMUSER (AdHocRole in varchar2,
8 UserList in varchar2) ;
9
10 -- REMALL cleans up wf_local_roles. It is called from OES by ntf.purgerole
11 -- ntf.purgerole also calls wf_purge.notificatons and wf_purgeItem
12 -- along with this so all expired notifications are cleaned.
13 -- These are called by expiration_date.
14 --
15 PROCEDURE REMALL (AdHocRole in varchar2);
16
17 function MakeRoleName (ACID in Number, TaskID in Number, UserID in Number default NULL) return varchar2;
18
19 FUNCTION GetFNDResp (RespKey in Varchar2) return varchar2;
20
21 procedure SET_ATTRIBUTES (itemtype in varchar2,
22 itemkey in varchar2,
23 actid in number,
24 funcmode in varchar2,
25 resultout out nocopy varchar2);
26
27 procedure SET_PAUSE (itemtype in varchar2,
28 itemkey in varchar2,
29 actid in number,
30 funcmode in varchar2,
31 resultout out nocopy varchar2);
32
33 function Get_EPB_Users (RespKey in Varchar2) return clob;
34
35 function NotifyForTask (TaskID in Number) return varchar2;
36
37 procedure NOTIFY_ON_DELETE (numericID in number, IDType in Varchar2 default 'TASK');
38
39 procedure VALIDATE_BUS_AREA (itemtype in varchar2,
40 itemkey in varchar2,
41 actid in number,
42 funcmode in varchar2,
43 resultout out nocopy varchar2);
44
45 Function SET_USERS_TO_NOTIFY (taskID in number,
46 itemkey in varchar2,
47 workflowprocess in varchar2,
48 relative in number,
49 thisOwner in varchar2,
50 thisOwnerID in number) return varchar2;
51
52 Procedure Set_EPB_Users (rolename in Varchar2, RespKey in Varchar2);
53
54 function update_Role_with_Shadows (roleName in Varchar2, thisUser Varchar2) return varchar2;
55
56 function ID_to_FNDUser (userID in number) return varchar2;
57
58 function FNDUser_to_ID (fndUser in varchar2) return number;
59
60 procedure ADD_SHADOW (rolename in varchar2, UserId in Number);
61
62 function USER_IN_ROLE (rolename in varchar2, UserName in varchar2) return varchar2;
63
64 Function HAS_SHADOW (userId in Number) return varchar2;
65
66 function OLD_STYLE_USERS(instanceID in number, taskID in number, thisOwner in varchar2, thisOwnerID in number, relative in number DEFAULT 0, UserList in varchar2 DEFAULT NULL) return varchar2;
67
68 procedure sendmsg(p_userid in number,
69 p_subject in varchar2,
70 p_message in varchar2);
71
72 -- added for b 5251227 and 5301285
73 procedure SHADOWS_FOR_EPBPERFORMER (itemtype in varchar2,
74 itemkey in varchar2,
75 actid in number,
76 funcmode in varchar2,
77 resultout out nocopy varchar2);
78
79 -- added for b 4948928
80 procedure SendExpiredUserMsg(p_BPOwnerID in number, p_taskID in number, p_itemtype in varchar2);
81
82 function Get_Active_User (p_BPOwnerID in number, p_BAID in number) return varchar2;
83
84 function FindSecurityAdmin (p_BAID in number,
85 p_roleName in varchar2,
86 p_respID in number) return varchar2;
87
88 procedure Build_ExpiredUser_list (p_nid in number);
89
90 end ZPB_WF_NTF;