45: wf_activity.c_event_name := '';
46: wf_activity.c_direction := '';
47: exception
48: when others then
49: Wf_Core.Context('Wf_Activity', 'ClearCache');
50: raise;
51: end ClearCache;
52:
53: --
152: wf_activity.c_actdate := actdate;
153:
154: exception
155: when others then
156: Wf_Core.Context('Wf_Activity', 'InitCache', to_char(actid),
157: to_char(actdate));
158: raise;
159: end InitCache;
160:
177: return(wf_activity.c_type);
178:
179: exception
180: when NO_DATA_FOUND then
181: Wf_Core.Context('Wf_Activity', 'Instance_Type', to_char(actid),
182: to_char(actdate));
183: Wf_Core.Token('ACTID', to_char(actid));
184: Wf_Core.Token('DATE', to_char(actdate));
185: Wf_Core.Raise('WFENG_ACTID');
179: exception
180: when NO_DATA_FOUND then
181: Wf_Core.Context('Wf_Activity', 'Instance_Type', to_char(actid),
182: to_char(actdate));
183: Wf_Core.Token('ACTID', to_char(actid));
184: Wf_Core.Token('DATE', to_char(actdate));
185: Wf_Core.Raise('WFENG_ACTID');
186: when OTHERS then
187: Wf_Core.Context('Wf_Activity', 'Instance_Type', to_char(actid),
180: when NO_DATA_FOUND then
181: Wf_Core.Context('Wf_Activity', 'Instance_Type', to_char(actid),
182: to_char(actdate));
183: Wf_Core.Token('ACTID', to_char(actid));
184: Wf_Core.Token('DATE', to_char(actdate));
185: Wf_Core.Raise('WFENG_ACTID');
186: when OTHERS then
187: Wf_Core.Context('Wf_Activity', 'Instance_Type', to_char(actid),
188: to_char(actdate));
181: Wf_Core.Context('Wf_Activity', 'Instance_Type', to_char(actid),
182: to_char(actdate));
183: Wf_Core.Token('ACTID', to_char(actid));
184: Wf_Core.Token('DATE', to_char(actdate));
185: Wf_Core.Raise('WFENG_ACTID');
186: when OTHERS then
187: Wf_Core.Context('Wf_Activity', 'Instance_Type', to_char(actid),
188: to_char(actdate));
189: raise;
183: Wf_Core.Token('ACTID', to_char(actid));
184: Wf_Core.Token('DATE', to_char(actdate));
185: Wf_Core.Raise('WFENG_ACTID');
186: when OTHERS then
187: Wf_Core.Context('Wf_Activity', 'Instance_Type', to_char(actid),
188: to_char(actdate));
189: raise;
190: end Instance_Type;
191:
246: exception
247: when NO_DATA_FOUND then
248: return '';
249: when OTHERS then
250: Wf_Core.Context('Wf_Activity', 'Type', itemtype, activity,
251: to_char(actdate));
252: raise;
253: end Type;
254:
282:
283:
284: exception
285: when NO_DATA_FOUND then
286: Wf_Core.Context('Wf_Activity', 'Info', to_char(actid), to_char(actdate));
287: Wf_Core.Token('ACTID', to_char(actid));
288: Wf_Core.Token('DATE', to_char(actdate));
289: Wf_Core.Raise('WFENG_ACTID');
290: when OTHERS then
283:
284: exception
285: when NO_DATA_FOUND then
286: Wf_Core.Context('Wf_Activity', 'Info', to_char(actid), to_char(actdate));
287: Wf_Core.Token('ACTID', to_char(actid));
288: Wf_Core.Token('DATE', to_char(actdate));
289: Wf_Core.Raise('WFENG_ACTID');
290: when OTHERS then
291: Wf_Core.Context('Wf_Activity', 'Info', to_char(actid), to_char(actdate));
284: exception
285: when NO_DATA_FOUND then
286: Wf_Core.Context('Wf_Activity', 'Info', to_char(actid), to_char(actdate));
287: Wf_Core.Token('ACTID', to_char(actid));
288: Wf_Core.Token('DATE', to_char(actdate));
289: Wf_Core.Raise('WFENG_ACTID');
290: when OTHERS then
291: Wf_Core.Context('Wf_Activity', 'Info', to_char(actid), to_char(actdate));
292: raise;
285: when NO_DATA_FOUND then
286: Wf_Core.Context('Wf_Activity', 'Info', to_char(actid), to_char(actdate));
287: Wf_Core.Token('ACTID', to_char(actid));
288: Wf_Core.Token('DATE', to_char(actdate));
289: Wf_Core.Raise('WFENG_ACTID');
290: when OTHERS then
291: Wf_Core.Context('Wf_Activity', 'Info', to_char(actid), to_char(actdate));
292: raise;
293: end Info;
287: Wf_Core.Token('ACTID', to_char(actid));
288: Wf_Core.Token('DATE', to_char(actdate));
289: Wf_Core.Raise('WFENG_ACTID');
290: when OTHERS then
291: Wf_Core.Context('Wf_Activity', 'Info', to_char(actid), to_char(actdate));
292: raise;
293: end Info;
294:
295: --
313: end if;
314:
315: exception
316: when NO_DATA_FOUND then
317: Wf_Core.Context('Wf_Activity', 'Ending', to_char(actid), to_char(actdate));
318: Wf_Core.Token('ACTID', to_char(actid));
319: Wf_Core.Token('DATE', to_char(actdate));
320: Wf_Core.Raise('WFENG_ACTID');
321: when OTHERS then
314:
315: exception
316: when NO_DATA_FOUND then
317: Wf_Core.Context('Wf_Activity', 'Ending', to_char(actid), to_char(actdate));
318: Wf_Core.Token('ACTID', to_char(actid));
319: Wf_Core.Token('DATE', to_char(actdate));
320: Wf_Core.Raise('WFENG_ACTID');
321: when OTHERS then
322: Wf_Core.Context('Wf_Activity', 'Ending', to_char(actid), to_char(actdate));
315: exception
316: when NO_DATA_FOUND then
317: Wf_Core.Context('Wf_Activity', 'Ending', to_char(actid), to_char(actdate));
318: Wf_Core.Token('ACTID', to_char(actid));
319: Wf_Core.Token('DATE', to_char(actdate));
320: Wf_Core.Raise('WFENG_ACTID');
321: when OTHERS then
322: Wf_Core.Context('Wf_Activity', 'Ending', to_char(actid), to_char(actdate));
323: raise;
316: when NO_DATA_FOUND then
317: Wf_Core.Context('Wf_Activity', 'Ending', to_char(actid), to_char(actdate));
318: Wf_Core.Token('ACTID', to_char(actid));
319: Wf_Core.Token('DATE', to_char(actdate));
320: Wf_Core.Raise('WFENG_ACTID');
321: when OTHERS then
322: Wf_Core.Context('Wf_Activity', 'Ending', to_char(actid), to_char(actdate));
323: raise;
324: end Ending;
318: Wf_Core.Token('ACTID', to_char(actid));
319: Wf_Core.Token('DATE', to_char(actdate));
320: Wf_Core.Raise('WFENG_ACTID');
321: when OTHERS then
322: Wf_Core.Context('Wf_Activity', 'Ending', to_char(actid), to_char(actdate));
323: raise;
324: end Ending;
325:
326: --
353: end if;
354:
355: exception
356: when NO_DATA_FOUND then
357: Wf_Core.Context('Wf_Activity', 'Error_Process', to_char(actid),
358: to_char(actdate));
359: Wf_Core.Token('ACTID', to_char(actid));
360: Wf_Core.Token('DATE', to_char(actdate));
361: Wf_Core.Raise('WFENG_ACTID');
355: exception
356: when NO_DATA_FOUND then
357: Wf_Core.Context('Wf_Activity', 'Error_Process', to_char(actid),
358: to_char(actdate));
359: Wf_Core.Token('ACTID', to_char(actid));
360: Wf_Core.Token('DATE', to_char(actdate));
361: Wf_Core.Raise('WFENG_ACTID');
362: when OTHERS then
363: Wf_Core.Context('Wf_Activity', 'Error_Process', to_char(actid),
356: when NO_DATA_FOUND then
357: Wf_Core.Context('Wf_Activity', 'Error_Process', to_char(actid),
358: to_char(actdate));
359: Wf_Core.Token('ACTID', to_char(actid));
360: Wf_Core.Token('DATE', to_char(actdate));
361: Wf_Core.Raise('WFENG_ACTID');
362: when OTHERS then
363: Wf_Core.Context('Wf_Activity', 'Error_Process', to_char(actid),
364: to_char(actdate));
357: Wf_Core.Context('Wf_Activity', 'Error_Process', to_char(actid),
358: to_char(actdate));
359: Wf_Core.Token('ACTID', to_char(actid));
360: Wf_Core.Token('DATE', to_char(actdate));
361: Wf_Core.Raise('WFENG_ACTID');
362: when OTHERS then
363: Wf_Core.Context('Wf_Activity', 'Error_Process', to_char(actid),
364: to_char(actdate));
365: raise;
359: Wf_Core.Token('ACTID', to_char(actid));
360: Wf_Core.Token('DATE', to_char(actdate));
361: Wf_Core.Raise('WFENG_ACTID');
362: when OTHERS then
363: Wf_Core.Context('Wf_Activity', 'Error_Process', to_char(actid),
364: to_char(actdate));
365: raise;
366: end Error_Process;
367:
384: Wf_Activity.InitCache(actid, actdate);
385: return(wf_activity.c_function);
386: exception
387: when others then
388: Wf_Core.Context('Wf_Activity', 'Activity_Function', itemtype, itemkey,
389: to_char(actid));
390: raise;
391: end Activity_Function;
392:
409: Wf_Activity.InitCache(actid, actdate);
410: return(wf_activity.c_function_type);
411: exception
412: when others then
413: Wf_Core.Context('Wf_Activity', 'Activity_Function_Type', itemtype, itemkey,
414: to_char(actid));
415: raise;
416: end Activity_Function_type;
417:
446: expand_role := wf_activity.c_expand_role;
447:
448: exception
449: when no_data_found then
450: Wf_Core.Context('Wf_Activity', 'Notification_Info', itemtype, itemkey,
451: to_char(actid));
452: Wf_Core.Token('TYPE', itemtype);
453: Wf_Core.Token('KEY', itemkey);
454: Wf_Core.Token('ACTID', to_char(actid));
448: exception
449: when no_data_found then
450: Wf_Core.Context('Wf_Activity', 'Notification_Info', itemtype, itemkey,
451: to_char(actid));
452: Wf_Core.Token('TYPE', itemtype);
453: Wf_Core.Token('KEY', itemkey);
454: Wf_Core.Token('ACTID', to_char(actid));
455: Wf_Core.Raise('WFENG_ITEM_ACTIVITY_STATUS');
456: when others then
449: when no_data_found then
450: Wf_Core.Context('Wf_Activity', 'Notification_Info', itemtype, itemkey,
451: to_char(actid));
452: Wf_Core.Token('TYPE', itemtype);
453: Wf_Core.Token('KEY', itemkey);
454: Wf_Core.Token('ACTID', to_char(actid));
455: Wf_Core.Raise('WFENG_ITEM_ACTIVITY_STATUS');
456: when others then
457: Wf_Core.Context('Wf_Activity', 'Notification_Info', itemtype, itemkey,
450: Wf_Core.Context('Wf_Activity', 'Notification_Info', itemtype, itemkey,
451: to_char(actid));
452: Wf_Core.Token('TYPE', itemtype);
453: Wf_Core.Token('KEY', itemkey);
454: Wf_Core.Token('ACTID', to_char(actid));
455: Wf_Core.Raise('WFENG_ITEM_ACTIVITY_STATUS');
456: when others then
457: Wf_Core.Context('Wf_Activity', 'Notification_Info', itemtype, itemkey,
458: to_char(actid));
451: to_char(actid));
452: Wf_Core.Token('TYPE', itemtype);
453: Wf_Core.Token('KEY', itemkey);
454: Wf_Core.Token('ACTID', to_char(actid));
455: Wf_Core.Raise('WFENG_ITEM_ACTIVITY_STATUS');
456: when others then
457: Wf_Core.Context('Wf_Activity', 'Notification_Info', itemtype, itemkey,
458: to_char(actid));
459: raise;
453: Wf_Core.Token('KEY', itemkey);
454: Wf_Core.Token('ACTID', to_char(actid));
455: Wf_Core.Raise('WFENG_ITEM_ACTIVITY_STATUS');
456: when others then
457: Wf_Core.Context('Wf_Activity', 'Notification_Info', itemtype, itemkey,
458: to_char(actid));
459: raise;
460: end Notification_Info;
461:
486: direction := wf_activity.c_direction;
487:
488: exception
489: when no_data_found then
490: Wf_Core.Context('Wf_Activity', 'Event_Info', itemtype, itemkey,
491: to_char(actid));
492: Wf_Core.Token('TYPE', itemtype);
493: Wf_Core.Token('KEY', itemkey);
494: Wf_Core.Token('ACTID', to_char(actid));
488: exception
489: when no_data_found then
490: Wf_Core.Context('Wf_Activity', 'Event_Info', itemtype, itemkey,
491: to_char(actid));
492: Wf_Core.Token('TYPE', itemtype);
493: Wf_Core.Token('KEY', itemkey);
494: Wf_Core.Token('ACTID', to_char(actid));
495: Wf_Core.Raise('WFENG_ITEM_ACTIVITY_STATUS');
496: when others then
489: when no_data_found then
490: Wf_Core.Context('Wf_Activity', 'Event_Info', itemtype, itemkey,
491: to_char(actid));
492: Wf_Core.Token('TYPE', itemtype);
493: Wf_Core.Token('KEY', itemkey);
494: Wf_Core.Token('ACTID', to_char(actid));
495: Wf_Core.Raise('WFENG_ITEM_ACTIVITY_STATUS');
496: when others then
497: Wf_Core.Context('Wf_Activity', 'Event_Info', itemtype, itemkey,
490: Wf_Core.Context('Wf_Activity', 'Event_Info', itemtype, itemkey,
491: to_char(actid));
492: Wf_Core.Token('TYPE', itemtype);
493: Wf_Core.Token('KEY', itemkey);
494: Wf_Core.Token('ACTID', to_char(actid));
495: Wf_Core.Raise('WFENG_ITEM_ACTIVITY_STATUS');
496: when others then
497: Wf_Core.Context('Wf_Activity', 'Event_Info', itemtype, itemkey,
498: to_char(actid));
491: to_char(actid));
492: Wf_Core.Token('TYPE', itemtype);
493: Wf_Core.Token('KEY', itemkey);
494: Wf_Core.Token('ACTID', to_char(actid));
495: Wf_Core.Raise('WFENG_ITEM_ACTIVITY_STATUS');
496: when others then
497: Wf_Core.Context('Wf_Activity', 'Event_Info', itemtype, itemkey,
498: to_char(actid));
499: raise;
493: Wf_Core.Token('KEY', itemkey);
494: Wf_Core.Token('ACTID', to_char(actid));
495: Wf_Core.Raise('WFENG_ITEM_ACTIVITY_STATUS');
496: when others then
497: Wf_Core.Context('Wf_Activity', 'Event_Info', itemtype, itemkey,
498: to_char(actid));
499: raise;
500: end Event_Info;
501:
552:
553: return(performrole);
554: exception
555: when no_data_found then
556: Wf_Core.Context('Wf_Activity', 'Perform_Role', itemtype, itemkey,
557: to_char(actid));
558: Wf_Core.Token('TYPE', itemtype);
559: Wf_Core.Token('KEY', itemkey);
560: Wf_Core.Token('ACTID', to_char(actid));
554: exception
555: when no_data_found then
556: Wf_Core.Context('Wf_Activity', 'Perform_Role', itemtype, itemkey,
557: to_char(actid));
558: Wf_Core.Token('TYPE', itemtype);
559: Wf_Core.Token('KEY', itemkey);
560: Wf_Core.Token('ACTID', to_char(actid));
561: Wf_Core.Raise('WFENG_ITEM_ACTIVITY_STATUS');
562: when others then
555: when no_data_found then
556: Wf_Core.Context('Wf_Activity', 'Perform_Role', itemtype, itemkey,
557: to_char(actid));
558: Wf_Core.Token('TYPE', itemtype);
559: Wf_Core.Token('KEY', itemkey);
560: Wf_Core.Token('ACTID', to_char(actid));
561: Wf_Core.Raise('WFENG_ITEM_ACTIVITY_STATUS');
562: when others then
563: Wf_Core.Context('Wf_Activity', 'Perform_Role', itemtype, itemkey,
556: Wf_Core.Context('Wf_Activity', 'Perform_Role', itemtype, itemkey,
557: to_char(actid));
558: Wf_Core.Token('TYPE', itemtype);
559: Wf_Core.Token('KEY', itemkey);
560: Wf_Core.Token('ACTID', to_char(actid));
561: Wf_Core.Raise('WFENG_ITEM_ACTIVITY_STATUS');
562: when others then
563: Wf_Core.Context('Wf_Activity', 'Perform_Role', itemtype, itemkey,
564: to_char(actid));
557: to_char(actid));
558: Wf_Core.Token('TYPE', itemtype);
559: Wf_Core.Token('KEY', itemkey);
560: Wf_Core.Token('ACTID', to_char(actid));
561: Wf_Core.Raise('WFENG_ITEM_ACTIVITY_STATUS');
562: when others then
563: Wf_Core.Context('Wf_Activity', 'Perform_Role', itemtype, itemkey,
564: to_char(actid));
565: raise;
559: Wf_Core.Token('KEY', itemkey);
560: Wf_Core.Token('ACTID', to_char(actid));
561: Wf_Core.Raise('WFENG_ITEM_ACTIVITY_STATUS');
562: when others then
563: Wf_Core.Context('Wf_Activity', 'Perform_Role', itemtype, itemkey,
564: to_char(actid));
565: raise;
566: end Perform_Role;
567:
622: return (WF_CACHE.Activities(waIND).VERSION);
623:
624: exception
625: when NO_DATA_FOUND then
626: Wf_Core.Context('Wf_Activity', 'Version', itemtype, activity,
627: to_char(actdate));
628: Wf_Core.Token('TYPE', itemtype);
629: Wf_Core.Token('NAME', activity);
630: Wf_Core.Token('DATE', to_char(actdate));
624: exception
625: when NO_DATA_FOUND then
626: Wf_Core.Context('Wf_Activity', 'Version', itemtype, activity,
627: to_char(actdate));
628: Wf_Core.Token('TYPE', itemtype);
629: Wf_Core.Token('NAME', activity);
630: Wf_Core.Token('DATE', to_char(actdate));
631: Wf_Core.Raise('WFENG_ACTIVITY');
632: when OTHERS then
625: when NO_DATA_FOUND then
626: Wf_Core.Context('Wf_Activity', 'Version', itemtype, activity,
627: to_char(actdate));
628: Wf_Core.Token('TYPE', itemtype);
629: Wf_Core.Token('NAME', activity);
630: Wf_Core.Token('DATE', to_char(actdate));
631: Wf_Core.Raise('WFENG_ACTIVITY');
632: when OTHERS then
633: Wf_Core.Context('Wf_Activity', 'Version', itemtype, activity,
626: Wf_Core.Context('Wf_Activity', 'Version', itemtype, activity,
627: to_char(actdate));
628: Wf_Core.Token('TYPE', itemtype);
629: Wf_Core.Token('NAME', activity);
630: Wf_Core.Token('DATE', to_char(actdate));
631: Wf_Core.Raise('WFENG_ACTIVITY');
632: when OTHERS then
633: Wf_Core.Context('Wf_Activity', 'Version', itemtype, activity,
634: to_char(actdate));
627: to_char(actdate));
628: Wf_Core.Token('TYPE', itemtype);
629: Wf_Core.Token('NAME', activity);
630: Wf_Core.Token('DATE', to_char(actdate));
631: Wf_Core.Raise('WFENG_ACTIVITY');
632: when OTHERS then
633: Wf_Core.Context('Wf_Activity', 'Version', itemtype, activity,
634: to_char(actdate));
635: raise;
629: Wf_Core.Token('NAME', activity);
630: Wf_Core.Token('DATE', to_char(actdate));
631: Wf_Core.Raise('WFENG_ACTIVITY');
632: when OTHERS then
633: Wf_Core.Context('Wf_Activity', 'Version', itemtype, activity,
634: to_char(actdate));
635: raise;
636: end Version;
637: