[Home] [Help]
PACKAGE BODY: APPS.ASO_APR_WF_INT
Source
1 PACKAGE BODY aso_apr_wf_int AS
2 /* $Header: asoiapwb.pls 120.1 2005/06/29 12:32:15 appldev noship $ */
3
4
5 PROCEDURE submit_approval (
6 itemtype IN VARCHAR2,
7 itemkey IN VARCHAR2,
8 actid IN NUMBER,
9 funcmode IN VARCHAR2,
10 resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
11 ) is
12 BEGIN
13 IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
14 aso_debug_pub.ADD ('Before calling aso_apr_wf_pvt.submit_approval ',1,'N');
15
16 END IF;
17 aso_apr_wf_pvt.submit_approval(itemtype,
18 itemkey,
19 actid,
20 funcmode,
21 resultout);
22 IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
23 aso_debug_pub.ADD ('After calling aso_apr_wf_pvt.submit_approval ',1,'N');
24
25 END IF;
26
27 END;
28
29
30 PROCEDURE check_rejected (
31 itemtype IN VARCHAR2,
32 itemkey IN VARCHAR2,
33 actid IN NUMBER,
34 funcmode IN VARCHAR2,
35 resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
36 ) IS
37 BEGIN
38
39 IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
40 aso_debug_pub.ADD ('Before calling aso_apr_wf_pvt.check_rejected ',1,'N');
41
42 END IF;
43
44 aso_apr_wf_pvt.check_rejected(itemtype,
45 itemkey,
46 actid,
47 funcmode,
48 resultout);
49
50 IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
51 aso_debug_pub.ADD ('After calling aso_apr_wf_pvt.check_rejected ',1,'N');
52
53 END IF;
54
55 END;
56
57
58 PROCEDURE submit_next_batch (
59 itemtype IN VARCHAR2,
60 itemkey IN VARCHAR2,
61 actid IN NUMBER,
62 funcmode IN VARCHAR2,
63 resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
64 ) IS
65
66 BEGIN
67
68 IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
69 aso_debug_pub.ADD ('Before calling aso_apr_wf_pvt.submit_next_batch ',1,'N');
70
71 END IF;
72
73 aso_apr_wf_pvt.submit_next_batch(itemtype,
74 itemkey,
75 actid,
76 funcmode,
77 resultout);
78
79 IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
80 aso_debug_pub.ADD ('After calling aso_apr_wf_pvt.submit_next_batch ',1,'N');
81
82 END IF;
83
84 END;
85
86
87
88
89 PROCEDURE approved (
90 itemtype IN VARCHAR2,
91 itemkey IN VARCHAR2,
92 actid IN NUMBER,
93 funcmode IN VARCHAR2,
94 resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
95 ) IS
96 BEGIN
97 IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
98 aso_debug_pub.ADD ('Before calling aso_apr_wf_pvt.approved ',1,'N');
99
100 END IF;
101
102 aso_apr_wf_pvt.approved(itemtype,
103 itemkey,
104 actid,
105 funcmode,
106 resultout);
107
108 IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
109 aso_debug_pub.ADD ('After calling aso_apr_wf_pvt.approved ',1,'N');
110
111 END IF;
112
113 END;
114
115
116
117
118 PROCEDURE rejected (
119 itemtype IN VARCHAR2,
120 itemkey IN VARCHAR2,
121 actid IN NUMBER,
122 funcmode IN VARCHAR2,
123 resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
124 ) IS
125 BEGIN
126
127 IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
128 aso_debug_pub.ADD ('Before calling aso_apr_wf_pvt.rejected ',1,'N');
129
130 END IF;
131
132 aso_apr_wf_pvt.rejected(itemtype,
133 itemkey,
134 actid,
135 funcmode,
136 resultout);
137
138 IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
139 aso_debug_pub.ADD ('After calling aso_apr_wf_pvt.rejected ',1,'N');
140
141 END IF;
142
143 END;
144
145
146 PROCEDURE timedout (
147 itemtype IN VARCHAR2,
148 itemkey IN VARCHAR2,
149 actid IN NUMBER,
150 funcmode IN VARCHAR2,
151 resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
152 ) IS
153 BEGIN
154
155 IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
156 aso_debug_pub.ADD ('Before calling aso_apr_wf_pvt.timedout ',1,'N');
157
158 END IF;
159
160 aso_apr_wf_pvt.timedout(itemtype,
161 itemkey,
162 actid,
163 funcmode,
164 resultout);
165
166 IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
167 aso_debug_pub.ADD ('After calling aso_apr_wf_pvt.timedout ',1,'N');
168
169 END IF;
170
171 END;
172
173
174 PROCEDURE send_notification (
175 itemtype IN VARCHAR2,
176 itemkey IN VARCHAR2,
177 actid IN NUMBER,
178 funcmode IN VARCHAR2,
179 resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
180 )IS
181 BEGIN
182
183 IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
184 aso_debug_pub.ADD ('Before calling aso_apr_wf_pvt.send_notification ',1,'N');
185
186 END IF;
187
188 aso_apr_wf_pvt.send_notification(itemtype,
189 itemkey,
190 actid,
191 funcmode,
192 resultout);
193
194 IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
195 aso_debug_pub.ADD ('After calling aso_apr_wf_pvt.send_notification ',1,'N');
196
197 END IF;
198
199
200 END;
201
202 PROCEDURE send_cancel_notification (
203 itemtype IN VARCHAR2,
204 itemkey IN VARCHAR2,
205 actid IN NUMBER,
206 funcmode IN VARCHAR2,
207 resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
208 )IS
209 BEGIN
210
211 IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
212 aso_debug_pub.ADD ('Before calling aso_apr_wf_pvt.send_cancel_notification ',1,'N');
213
214 END IF;
215 aso_apr_wf_pvt.send_cancel_notification(itemtype,
216 itemkey,
217 actid,
218 funcmode,
219 resultout);
220
221
222 IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
223 aso_debug_pub.ADD ('After calling aso_apr_wf_pvt.send_cancel_notification ',1,'N');
224
225 END IF;
226
227 END;
228
229 /* The following APIs are for Quoting Specific use and
230 should NOT be used by any other applications */
231
232 PROCEDURE approver_details_doc (
233 document_id IN VARCHAR2,
234 display_type IN VARCHAR2,
235 document IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
236 document_type IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
237 ) IS
238 BEGIN
239
240 IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
241 aso_debug_pub.ADD ('Before calling aso_apr_wf_pvt.approver_details_doc ',1,'N');
242
243 END IF;
244
245 aso_apr_wf_pvt.approver_details_doc(document_id,
246 display_type,
247 document,
248 document_type);
249
250 IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
251 aso_debug_pub.ADD ('After calling aso_apr_wf_pvt.approver_details_doc ',1,'N');
252
253 END IF;
254
255 END;
256
257 PROCEDURE quote_summary_doc (
258 document_id IN VARCHAR2,
259 display_type IN VARCHAR2,
260 document IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
261 document_type IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
262 ) IS
263 BEGIN
264
265 IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
266 aso_debug_pub.ADD ('Before calling aso_apr_wf_pvt.quote_summary_doc ',1,'N');
267
268 END IF;
269
270 aso_apr_wf_pvt.quote_summary_doc(document_id,
271 display_type,
272 document,
273 document_type);
274
275 IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
276 aso_debug_pub.ADD ('After calling aso_apr_wf_pvt.quote_summary_doc ',1,'N');
277
278 END IF;
279
280 END;
281
282 PROCEDURE requester_comments_doc (
283 document_id IN VARCHAR2,
284 display_type IN VARCHAR2,
285 document IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
286 document_type IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
287 ) IS
288 BEGIN
289
290 IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
291 aso_debug_pub.ADD ('Before calling aso_apr_wf_pvt.requester_comments_doc ',1,'N');
292
293 END IF;
294
295 aso_apr_wf_pvt.requester_comments_doc(document_id,
296 display_type,
297 document,
298 document_type);
299
300 IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
301 aso_debug_pub.ADD ('After calling aso_apr_wf_pvt.requester_comments_doc ',1,'N');
302
303 END IF;
304
305 END;
306
307 PROCEDURE rule_details_doc (
308 document_id IN VARCHAR2,
309 display_type IN VARCHAR2,
310 document IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
311 document_type IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
312 ) IS
313 BEGIN
314
315 IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
316 aso_debug_pub.ADD ('Before calling aso_apr_wf_pvt.rule_details_doc ',1,'N');
317
318 END IF;
319
320 aso_apr_wf_pvt.rule_details_doc(document_id,
321 display_type,
322 document,
323 document_type);
324
325 IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
326 aso_debug_pub.ADD ('After calling aso_apr_wf_pvt.rule_details_doc ',1,'N');
327
328 END IF;
329
330 END;
331
332 PROCEDURE quote_detail_url (
333 document_id IN VARCHAR2,
334 display_type IN VARCHAR2,
335 document IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
336 document_type IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
337 ) IS
338 BEGIN
339
340 IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
341 aso_debug_pub.ADD ('Before calling aso_apr_wf_pvt.quote_detail_url ',1,'N');
342
343 END IF;
344
345 aso_apr_wf_pvt.quote_detail_url(document_id,
346 display_type,
347 document,
348 document_type);
349
350 IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
351 aso_debug_pub.ADD ('After calling aso_apr_wf_pvt.quote_detail_url ',1,'N');
352
353 END IF;
354
355
356 END;
357
358 PROCEDURE set_attributes (
359 itemtype IN VARCHAR2,
360 itemkey IN VARCHAR2,
361 actid IN NUMBER,
362 funcmode IN VARCHAR2,
363 resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
364 ) IS
365 BEGIN
366
367 IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
368 aso_debug_pub.ADD ('Before calling aso_apr_wf_pvt.set_attributes ',1,'N');
369
370 END IF;
371
372 aso_apr_wf_pvt. set_attributes(itemtype,
373 itemkey,
374 actid,
375 funcmode,
376 resultout);
377
378 IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
379 aso_debug_pub.ADD ('After calling aso_apr_wf_pvt.set_attributes ',1,'N');
380
381 END IF;
382
383
384 END;
385
386 PROCEDURE update_entity (
387 itemtype IN VARCHAR2,
388 itemkey IN VARCHAR2,
389 actid IN NUMBER,
390 funcmode IN VARCHAR2,
391 resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
392 ) IS
393 BEGIN
394
395 IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
396 aso_debug_pub.ADD ('Before calling aso_apr_wf_pvt.update_entity ',1,'N');
397
398 END IF;
399
400 aso_apr_wf_pvt.update_entity(itemtype,
401 itemkey,
402 actid,
403 funcmode,
404 resultout);
405
406 IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
407 aso_debug_pub.ADD ('After calling aso_apr_wf_pvt.update_entity ',1,'N');
408
409 END IF;
410
411 END;
412
413 END aso_apr_wf_int;