1 PACKAGE MSC_WS_NOTIFICATION_BPEL AS
2 /* $Header: MSCWNOTS.pls 120.1.12010000.2 2008/07/08 18:41:44 bnaghi ship $ */
3
4
5 -- =============================================================
6 -- Desc: This procedure is invoked from workflow to create an ad-hoc
7 -- role for the receiver. The input parameters are
8 -- itemtype: workflow name
9 -- itemkey: unique identifier of this workflow's instance
10 -- The possible return statuses are:
11 -- complete:y - meaning the procedure finished successfully
12 -- complete:n - meaning an error was encountered
13 -- =============================================================
14
15 PROCEDURE set_wf_approver_role
16 (itemtype IN VARCHAR2,
17 itemkey IN VARCHAR2,
18 actid IN NUMBER, funcmode IN VARCHAR2, result in out nocopy varchar2);
19
20 -- =============================================================
21 -- Desc: This procedure is invoked from workflow to translate
22 -- the activity type id into activity type name( uses mfg_lookups).
23 -- The input parameters are:
24 -- itemtype: workflow name
25 -- itemkey: unique identifier of this workflow's instance
26 -- The possible return statuses are:
27 -- complete:y - meaning the procedure finished successfully
28 -- complete:n - meaning an error was encountered
29 -- =============================================================
30
31 procedure Lookup
32 (itemtype IN VARCHAR2,
33 itemkey IN VARCHAR2,
34 actid IN NUMBER, funcmode IN VARCHAR2, result in out nocopy varchar2);
35
36 -- =============================================================
37 -- Desc: This procedure is invoked from workflow to translate
38 -- the plan id into plan name( uses msc_plans).
39 -- The input parameters are:
40 -- itemtype: workflow name
41 -- itemkey: unique identifier of this workflow's instance
42 -- The possible return statuses are:
43 -- complete:y - meaning the procedure finished successfully
44 -- complete:n - meaning an error was encountered
45 -- =============================================================
46
47 procedure Lookup_Plan
48 (itemtype IN VARCHAR2,
49 itemkey IN VARCHAR2,
50 actid IN NUMBER, funcmode IN VARCHAR2, result in out nocopy varchar2);
51
52 -- =============================================================
53 -- Desc: This procedure is invoked from workflow to translate
54 -- the excalation level id into escalation level name.
55 -- The input parameters are:
56 -- itemtype: workflow name
57 -- itemkey: unique identifier of this workflow's instance
58 -- The possible return statuses are:
59 -- complete:y - meaning the procedure finished successfully
60 -- complete:n - meaning an error was encountered
61 -- =============================================================
62 procedure Lookup_Escalation
63 (itemtype IN VARCHAR2,
64 itemkey IN VARCHAR2,
65 actid IN NUMBER, funcmode IN VARCHAR2, result in out nocopy varchar2);
66
67 -- =============================================================
68 -- Desc: This procedure is invoked from the Web Service to send
69 -- a notification from userId to receiver
70 -- The input parameters are:
71 -- userID: user id of the sender
72 -- respID: responsibility id of the sender
73 -- receiver : receiver of the notification
74 -- language: this parameter is for future use, right now not used
75 -- wfName: workflow name to be instantiated to send the notification
76 -- wfProcessName : provess name in the workflow, to be instantiated to send the notification
77 -- tokenValues : pairs of token_name - token_value. Token_name is a name that identifies
78 -- an attribute to be set; token_value is the string value of that attribute
79 -- The possible return statuses are:
80 -- SUCCESS- meaning the procedure finished successfully
81 -- UNKNOWN_ERROR - meaning an error was encountered and the notification was not send.
82 -- =============================================================
83
84 FUNCTION SendFYINotification (userID IN NUMBER, ---sender user id
85 respID in NUMBER, --sender resp id
86 receiver in varchar2,
87 language IN Varchar2,
88 wfName IN VARCHAR2,
89 wfProcessName IN varchar2,
90 tokenValues IN MsgTokenValuePairList)
91 return VARCHAR2;
92
93 FUNCTION SendFYINotificationPublic (
94 UserName IN VARCHAR2,
95 RespName IN VARCHAR2,
96 RespApplName IN VARCHAR2,
97 SecurityGroupName IN VARCHAR2,
98 receiver in varchar2,
99 language IN Varchar2,
100 wfName IN VARCHAR2,
101 wfProcessName IN varchar2,
102 tokenValues IN MsgTokenValuePairList)
103 return VARCHAR2;
104
105
106 END MSC_WS_NOTIFICATION_BPEL;
107
[Home] [Help]