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,
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,
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:
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;
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:
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,
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:
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;
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:
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,
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:
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;
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:
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,
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:
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;
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:
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,
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:
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;
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:
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,
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:
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;
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:
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,
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:
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:
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,
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,
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:
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;
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:
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:
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;
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:
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:
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;
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:
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:
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;
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:
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:
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;
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:
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:
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:
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:
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,
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:
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:
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:
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,
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:
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;