1 PACKAGE CS_WF_ACTIVITIES_PKG AUTHID CURRENT_USER as
2 /* $Header: cswfacts.pls 115.4 2002/11/26 05:29:11 rmanabat ship $ */
3
4 Audit_Comments VARCHAR2(2000);
5
6 -- ***************************************************************************
7 -- * *
8 -- * Service Request Item Type *
9 -- * *
10 -- ***************************************************************************
11
12 ------------------------------------------------------------------------------
13 -- Servereq_Selector
14 -- Item Type Callback Function. It sets the database session context before
15 -- the engine begins to execute process activities.
16 ------------------------------------------------------------------------------
17
18 PROCEDURE Servereq_Selector
19 ( itemtype IN VARCHAR2,
20 itemkey IN VARCHAR2,
21 actid IN NUMBER,
22 funcmode IN VARCHAR2,
23 result OUT NOCOPY VARCHAR2
24 );
25
26
27 -- ---------------------------------------------------------------------------
28 -- Initialize_Request
29 -- This procedure corresponds to the INITIALIZE_REQUEST function activity.
30 -- It initializes the item attributes that will remain constant over the
31 -- duration of the workflow.
32 -- ---------------------------------------------------------------------------
33
34 PROCEDURE Initialize_Request( itemtype VARCHAR2,
35 itemkey VARCHAR2,
36 actid NUMBER,
37 funmode VARCHAR2,
38 result OUT NOCOPY VARCHAR2 );
39
40
41 -- ---------------------------------------------------------------------------
42 -- Update_Request_Info
43 -- This procedure corresponds to the UPDATE_REQUEST_INFORMATION function
44 -- activity. It updates the service request item attributes with the
45 -- most current values in the database. This procedure is used to keep
46 -- the item attributes in sync with the state of the database.
47 -- ---------------------------------------------------------------------------
48
49 PROCEDURE Update_Request_Info( itemtype VARCHAR2,
50 itemkey VARCHAR2,
51 actid NUMBER,
52 funmode VARCHAR2,
53 result OUT NOCOPY VARCHAR2 );
54
55
56 -- ---------------------------------------------------------------------------
57 -- Select_Supervisor
58 -- This procedure corresponds to the SELECT_SUPERVISOR function activity.
59 -- It gets the name, employee_id, and Workflow role name of the supervisor
60 -- of the current owner and updates the following corresponding item
61 -- attributes: SUPERVISOR_NAME, SUPERVISOR_ID, and SUPERVISOR_ROLE.
62 -- ---------------------------------------------------------------------------
63
64 PROCEDURE Select_Supervisor( itemtype VARCHAR2,
65 itemkey VARCHAR2,
66 actid NUMBER,
67 funmode VARCHAR2,
68 result OUT NOCOPY VARCHAR2 );
69
70
71 -- ---------------------------------------------------------------------------
72 -- Update_Owner
73 -- This procedure corresponds to the UPDATE_OWNER function activity.
74 -- It reassigns the service request to the employee specified by the given
75 -- employee ID. It also updates the OWNER_ID, OWNER_NAME, and OWNER_ROLE
76 -- item attributes.
77 -- ---------------------------------------------------------------------------
78
79 PROCEDURE Update_Owner( itemtype VARCHAR2,
80 itemkey VARCHAR2,
81 actid NUMBER,
82 funmode VARCHAR2,
83 result OUT NOCOPY VARCHAR2 );
84
85
86 -- ---------------------------------------------------------------------------
87 -- Update_Status
88 -- This procedure corresponds to the UPDATE_STATUS function activity. It
89 -- updates the status of the service request to the value given by the
90 -- STATUS activity attribute.
91 -- ---------------------------------------------------------------------------
92
93 PROCEDURE Update_Status( itemtype VARCHAR2,
94 itemkey VARCHAR2,
95 actid NUMBER,
96 funmode VARCHAR2,
97 result OUT NOCOPY VARCHAR2 );
98
99
100 -- ---------------------------------------------------------------------------
101 -- Validate_Response_Deadline
102 -- This procedure corresponds to the VALIDATE_RESPONSE_DEADLINE function
103 -- activity. It verifies that the RESPONSE_DEADLINE item attribute is
104 -- valid.
105 -- ---------------------------------------------------------------------------
106
107 PROCEDURE Validate_Response_Deadline( itemtype VARCHAR2,
108 itemkey VARCHAR2,
109 actid NUMBER,
110 funmode VARCHAR2,
111 result OUT NOCOPY VARCHAR2 );
112
113
114 -- ---------------------------------------------------------------------------
115 -- Reset_Response_Deadline
116 -- This procedure corresponds to the RESET_RESPONSE_DEADLINE function
117 -- activity. It resets the RESPONSE_DEADLINE item attribute back to NULL.
118 -- ---------------------------------------------------------------------------
119
120 PROCEDURE Reset_Response_Deadline( itemtype VARCHAR2,
121 itemkey VARCHAR2,
122 actid NUMBER,
123 funmode VARCHAR2,
124 result OUT NOCOPY VARCHAR2 );
125
126
127 -- ***************************************************************************
128 -- * *
129 -- * System: Error Item Type *
130 -- * *
131 -- * Following activities are used in the Service Request Error Process *
132 -- * *
133 -- ***************************************************************************
134
135
136 -- ---------------------------------------------------------------------------
137 -- Initialize_Errors
138 -- This procedure corresponds to the SERVEREQ_INIT_ERROR function activity.
139 -- It retrieves the error messages from the service request process that
140 -- errored out and store them in the item attributes of the error process.
141 -- ---------------------------------------------------------------------------
142
143 PROCEDURE Initialize_Errors( itemtype VARCHAR2,
144 itemkey VARCHAR2,
145 actid NUMBER,
146 funmode VARCHAR2,
147 result OUT NOCOPY VARCHAR2 );
148
149
150 -- ***************************************************************************
151 -- * *
152 -- * Service Request Action Item Type *
153 -- * *
154 -- ***************************************************************************
155
156 ------------------------------------------------------------------------------
157 -- Action_Selector
158 -- Item Type Callback Function. It sets the database session context before
159 -- the engine begins to execute process activities.
160 ------------------------------------------------------------------------------
161
162 PROCEDURE Action_Selector
163 ( itemtype IN VARCHAR2,
164 itemkey IN VARCHAR2,
165 actid IN NUMBER,
166 funcmode IN VARCHAR2,
167 result OUT NOCOPY VARCHAR2
168 );
169
170
171 ------------------------------------------------------------------------------
172 -- Initialize_Action
173 -- This procedure corresponds to the INITIALIZE_ACTION function activity.
174 -- It initializes the item attributes that will remain constant over the
175 -- duration of the workflow.
176 ------------------------------------------------------------------------------
177
178 /*PROCEDURE Initialize_Action
179 ( itemtype IN VARCHAR2,
180 itemkey IN VARCHAR2,
181 actid IN NUMBER,
182 funcmode IN VARCHAR2,
183 result OUT VARCHAR2
184 );*/
185
186
187 ------------------------------------------------------------------------------
188 -- Is_Launched_From_Dispatch
189 -- This procedure corresponds to the IS_LAUNCHED_FROM_DISPATCH function
190 -- activity. It determines if the workflow process is launched from the
191 -- Field Service Dispatch window.
192 ------------------------------------------------------------------------------
193
194 PROCEDURE Is_Launched_From_Dispatch
195 ( itemtype IN VARCHAR2,
196 itemkey IN VARCHAR2,
197 actid IN NUMBER,
198 funcmode IN VARCHAR2,
199 result OUT NOCOPY VARCHAR2
200 );
201
202
203 ------------------------------------------------------------------------------
204 -- Get_Dispatcher_Info
205 -- This procedure corresponds to the GET_DISPATCHER_INFO function
206 -- activity. It updates the service request action item attributes with the
207 -- dispatcher information stored in the database.
208 ------------------------------------------------------------------------------
209
210 /*PROCEDURE Get_Dispatcher_Info
211 ( itemtype IN VARCHAR2,
212 itemkey IN VARCHAR2,
213 actid IN NUMBER,
214 funcmode IN VARCHAR2,
215 result OUT VARCHAR2
216 );*/
217
218
219 --- **** Following three procedures are added to support field service workflow
220 -- **** Tinoway integration
221
222 ------------------------------------------------------------------------------
223 -- FS_INTERFACE
224 -- This procedure corresponds to the FIELD SERVICE INTERFACE function
225 -- activity. It creates/updates an interface record into the field service interface
226 -- table.
227 ------------------------------------------------------------------------------
228
229
230 PROCEDURE IS_MOBILE_INSTALLED (
231 itemtype IN VARCHAR2,
232 itemkey IN VARCHAR2,
233 actid IN NUMBER,
234 funcmode IN VARCHAR2,
235 result OUT NOCOPY VARCHAR2
236 );
237
238 /*PROCEDURE IS_ACTION_CLOSED (
239 itemtype IN VARCHAR2,
240 itemkey IN VARCHAR2,
241 actid IN NUMBER,
242 funcmode IN VARCHAR2,
243 result OUT VARCHAR2
244 );*/
245
246 PROCEDURE IS_FS_INSERT (
247 itemtype IN VARCHAR2,
248 itemkey IN VARCHAR2,
249 actid IN NUMBER,
250 funcmode IN VARCHAR2,
251 result OUT NOCOPY VARCHAR2
252 );
253
254 /*PROCEDURE INSERT_FS_INTERFACE (
255 itemtype IN VARCHAR2,
256 itemkey IN VARCHAR2,
257 actid IN NUMBER,
258 funcmode IN VARCHAR2,
259 result OUT VARCHAR2
260 );
261
262 PROCEDURE UPDATE_FS_INTERFACE (
263 itemtype IN VARCHAR2,
264 itemkey IN VARCHAR2,
265 actid IN NUMBER,
266 funcmode IN VARCHAR2,
267 result OUT NOCOPY VARCHAR2
268 );
269
270 PROCEDURE SET_FS_WF_RESPONSE(
271 p_incident_number IN NUMBER,
272 p_action_number IN NUMBER,
273 p_response IN VARCHAR2,
274 x_return_status OUT NOCOPY VARCHAR2,
275 x_msg_data OUT NOCOPY VARCHAR2
276 );*/
277
278
279
280 END CS_WF_ACTIVITIES_PKG;