1 PACKAGE XDPSTATUS AUTHID CURRENT_USER AS
2 /* $Header: XDPSTATS.pls 120.1 2005/06/16 02:36:38 appldev $ */
3
4 e_NullValueException EXCEPTION;
5
6
7 x_ErrMsg VARCHAR2(2000);
8 x_DebugMsg VARCHAR2(32767);
9
10 Procedure SetFActionStatus (OrderID in number,
11 LineItemID in number,
12 WorkitemInstanceID in number,
13 FAInstanceID in number,
14 Caller in varchar2,
15 Event in varchar2,
16 Status in varchar2,
17 ItemType in varchar2,
18 Itemkey in varchar2,
19 ErrCode OUT NOCOPY number,
20 ErrStr OUT NOCOPY varchar2);
21
22 Procedure SetWorkitemStatus (itemtype in varchar2,
23 itemkey in varchar2);
24
25 Procedure SetStatusforFA(FAInstanceID in number,
26 Status in varchar2,
27 Event in varchar2);
28
29 Procedure SetStatusforWI(WorkitemInstanceID in number,
30 Status in varchar2,
31 Event in varchar2);
32
33 Procedure SetStatusForLine (OrderID in number,
34 WorkitemInstanceID in number,
35 LineItemID in number,
36 Status in varchar2,
37 Event in varchar2);
38 /*
39 Procedure SetStatusforLine(LineItemID in number,
40 Status in varchar2,
41 Event in varchar2);
42 */
43 Procedure SetStatusforOrder(OrderID in number,
44 Status in varchar2,
45 Event in varchar2);
46
47
48 -- SEND_FE_PROV_STATUS
49 -- Resultout
50 -- Activity Performed - Activity was completed without any errors
51 --
52 -- Your Description here:
53
54
55 Procedure SEND_FE_PROV_STATUS (itemtype in varchar2,
56 itemkey in varchar2,
57 actid in number,
58 funcmode in varchar2,
59 resultout OUT NOCOPY varchar2);
60
61
62
63 -- SEND_ORDER_STATUS
64 -- Resultout
65 -- Activity Performed - Activity was completed without any errors
66 --
67 -- Your Description here:
68
69
70 Procedure SEND_ORDER_STATUS (itemtype in varchar2,
71 itemkey in varchar2,
72 actid in number,
73 funcmode in varchar2,
74 resultout OUT NOCOPY varchar2);
75
76
77 -- SEND_LINE_STATUS
78 -- Resultout
79 -- Activity Performed - Activity was completed without any errors
80 --
81 -- Your Description here:
82
83
84 Procedure SEND_LINE_STATUS (itemtype in varchar2,
85 itemkey in varchar2,
86 actid in number,
87 funcmode in varchar2,
88 resultout OUT NOCOPY varchar2);
89
90
91
92 -- SEND_WORKITEM_STATUS
93 -- Resultout
94 -- Activity Performed - Activity was completed without any errors
95 --
96 -- Your Description here:
97
98
99 Procedure SEND_WORKITEM_STATUS (itemtype in varchar2,
100 itemkey in varchar2,
101 actid in number,
102 funcmode in varchar2,
103 resultout OUT NOCOPY varchar2);
104
105
106
107 -- SET_FA_STATUS
108 -- Resultout
109 -- Activity Performed - Activity was completed without any errors
110 --
111 -- Your Description here:
112
113
114 Procedure SET_FA_STATUS (itemtype in varchar2,
115 itemkey in varchar2,
116 actid in number,
117 funcmode in varchar2,
118 resultout OUT NOCOPY varchar2);
119
120
121
122 -- SET_FE_EXEC_STATUS
123 -- Resultout
124 -- Activity Performed - Activity was completed without any errors
125 --
126 -- Your Description here:
127
128
129 Procedure SET_FE_EXEC_STATUS (itemtype in varchar2,
130 itemkey in varchar2,
131 actid in number,
132 funcmode in varchar2,
133 resultout OUT NOCOPY varchar2);
134
135
136
137 -- SET_FE_PROV_STATE
138 -- Resultout
139 -- Activity Performed - Activity was completed without any errors
140 --
141 -- Your Description here:
142
143
144 Procedure SET_FE_PROV_STATE (itemtype in varchar2,
145 itemkey in varchar2,
146 actid in number,
147 funcmode in varchar2,
148 resultout OUT NOCOPY varchar2);
149
150
151
152 -- SET_ORDER_STATUS
153 -- Resultout
154 -- Activity Performed - Activity was completed without any errors
155 --
156 -- Your Description here:
157
158
159 Procedure SET_ORDER_STATUS (itemtype in varchar2,
160 itemkey in varchar2,
161 actid in number,
162 funcmode in varchar2,
163 resultout OUT NOCOPY varchar2);
164
165
166
167 -- SET_BUNDLE_STATUS
168 -- Resultout
169 -- Activity Performed - Activity was completed without any errors
170 --
171 -- Your Description here:
172
173
174 Procedure SET_BUNDLE_STATUS (itemtype in varchar2,
175 itemkey in varchar2,
176 actid in number,
177 funcmode in varchar2,
178 resultout OUT NOCOPY varchar2);
179
180
181 -- SET_LINE_STATUS
182 -- Resultout
183 -- Activity Performed - Activity was completed without any errors
184 --
185 -- Your Description here:
186
187
188 Procedure SET_LINE_STATUS (itemtype in varchar2,
189 itemkey in varchar2,
190 actid in number,
191 funcmode in varchar2,
192 resultout OUT NOCOPY varchar2);
193
194 -- SET_PACKAGE_STATUS
195 -- Resultout
196 -- Activity Performed - Activity was completed without any errors
197 --
198 -- Your Description here:
199
200
201 Procedure SET_PACKAGE_STATUS (itemtype in varchar2,
202 itemkey in varchar2,
203 actid in number,
204 funcmode in varchar2,
205 resultout OUT NOCOPY varchar2);
206
207
208 -- SET_WORKITEM_STATUS
209 -- Resultout
210 -- Activity Performed - Activity was completed without any errors
211 --
212 -- Your Description here:
213
214
215 Procedure SET_WORKITEM_STATUS (itemtype in varchar2,
216 itemkey in varchar2,
217 actid in number,
218 funcmode in varchar2,
219 resultout OUT NOCOPY varchar2);
220
221
222 -- SET_WI_STATUS_SUCCESS
223 -- Resultout
224 -- Activity Performed - Activity was completed without any errors
225 --
226 -- Your Description here:
227
228
229 Procedure SET_WI_STATUS_SUCCESS (itemtype in varchar2,
230 itemkey in varchar2,
231 actid in number,
232 funcmode in varchar2,
233 resultout OUT NOCOPY varchar2);
234
235
236 -- SAVE_WORKITEM
237 -- Resultout
238 -- Activity Performed - Activity was completed without any errors
239 --
240 -- Your Description here:
241
242
243 Procedure SAVE_WORKITEM (itemtype in varchar2,
244 itemkey in varchar2,
245 actid in number,
246 funcmode in varchar2,
247 resultout OUT NOCOPY varchar2);
248
249 -- SET_XDP_ERROR
250 -- Resultout
251 -- Activity Performed - Activity was completed without any errors
252 --
253 -- Your Description here:
254
255
256 Procedure SET_ERROR_STATUS (itemtype in varchar2,
257 itemkey in varchar2,
258 actid in number,
259 funcmode in varchar2,
260 resultout OUT NOCOPY varchar2);
261
262 --
263 -- Your Description here:
264
265 PROCEDURE UPDATE_XDP_ORDER_STATUS(p_status IN VARCHAR2,
266 p_order_id IN NUMBER);
267
268 -- Your Description here:
269
270 PROCEDURE UPDATE_XDP_ORDER_LINE_STATUS(p_status IN VARCHAR2,
271 p_line_item_id IN NUMBER);
272
273 --
274 -- Your Description here:
275
276 PROCEDURE UPDATE_XDP_WORKITEM_STATUS(p_status IN VARCHAR2,
277 p_workitem_instance_id IN NUMBER);
278
279 --
280 -- Your Description here:
281
282
283 PROCEDURE UPDATE_XDP_FA_STATUS(p_status IN VARCHAR2,
284 p_fa_instance_id IN NUMBER);
285
286 --
287 -- Your Description here:
288
289
290 PROCEDURE UPDATE_XDP_ORDER_BUNDLE_STATUS(p_status IN VARCHAR2,
291 p_order_id IN NUMBER,
292 p_bundle_id IN NUMBER) ;
293
294
295 -- IS_ORDER_IN_ERROR
296 -- Resultout
297 -- TRUE/FALSE
298 --
299 -- Your Description here:
300
301 FUNCTION IS_ORDER_IN_ERROR(p_order_id IN NUMBER) RETURN BOOLEAN;
302
303 -- IS_LINE_IN_ERROR
304 -- Resultout
305 -- TRUE/FALSE
306 --
307 -- Your Description here:
308
309 FUNCTION IS_LINE_IN_ERROR(p_lineitem_id IN NUMBER) RETURN BOOLEAN;
310
311 -- IS_WI_IN_ERROR
312 -- Resultout
313 -- TRUE/FALSE
314 --
315 -- Your Description here:
316
317 FUNCTION IS_WI_IN_ERROR(p_WIInstance_id IN NUMBER) RETURN BOOLEAN;
318
319 -- IS_FA_IN_ERROR
320 -- Resultout
321 -- TRUE/FALSE
322 --
323 -- Your Description here:
324
325 FUNCTION IS_FA_IN_ERROR(p_FAInstance_id IN NUMBER) RETURN BOOLEAN;
326
327 -- GET_WI_STATUS
328 -- Returns
329 -- VARCHAR2
330 --
331 -- Returns the status of Workitem
332 -- 1)If any of the FAs are in ERROR it returns error.
333 -- 2)IF any of the FAS are in SYSTEM HOLD it returns System Hold.
334 -- 3)If some FAs or in ERROR and some FAs are in SYSTEM HOLD then it
335 -- returns ERROR.
336
337 FUNCTION GET_WI_STATUS(p_WIInstance_id IN NUMBER) RETURN VARCHAR2;
338
339
340 -- GET_LINE_STATUS
341 -- Returns
342 -- VARCHAR2
343 --
344 -- Returns the status of LINE
345 -- 1)If any of the WIs are in ERROR it returns error.
346 -- 2)IF any of the FAs are in SYSTEM HOLD it returns System Hold.
347 -- 3)If some FAs or in ERROR and some FAs are in SYSTEM HOLD then it
348 -- returns ERROR.
349
350 FUNCTION GET_LINE_STATUS(p_line_item_id IN NUMBER) RETURN VARCHAR2;
351
352 -- GET_ORDER_STATUS
353 -- Returns
354 -- VARCHAR2
355 --
356 -- Returns the status of ORDER
357 -- 1)If any of the LINEs are in ERROR it returns error.
358 -- 2)If any of the WIs are in ERROR it returns error.
359 -- 3)IF any of the FAs are in SYSTEM HOLD it returns System Hold.
360 -- 4)If some FAs or in ERROR and some FAs are in SYSTEM HOLD then it
361 -- returns ERROR.
362
363 FUNCTION GET_ORDER_STATUS( p_order_id IN NUMBER) RETURN VARCHAR2;
364
365 Procedure SET_NODE_WI_STATUS(itemtype in varchar2,
366 itemkey in varchar2,
367 actid in number,
368 funcmode in varchar2,
369 resultout OUT NOCOPY varchar2 );
370
371 Procedure SET_NODE_LINE_STATUS(itemtype in varchar2,
372 itemkey in varchar2,
373 actid in number,
374 funcmode in varchar2,
375 resultout OUT NOCOPY varchar2 );
376
377 End XDPSTATUS;