Oracle Workflow Guide
Release 2.6.2

Part Number A95265-02
Previous Next       Contents Index Glossary
         Previous  Next          Contents  Index  Glossary

Notifications

Syntax

procedure Notifications

    (itemtype in varchar2 default null,
     enddate in date default sysdate);

Description

Deletes old eligible notifications from the tables WF_NOTIFICATION_ATTRIBUTES and WF_NOTIFICATIONS that are associated with the specified item type, have an END_DATE less than or equal to the specified end date and are not referenced by an existing item.

Note: You should call Items( ) before calling Notifications( ) to avoid having obsolete item references prevent obsolete notifications from being deleted.

Arguments (input)

itemtype Item type associated with the notifications you want to delete. Leave this argument null to delete notifications for all item types.
enddate Specified date to delete up to.


         Previous  Next          Contents  Index  Glossary


Oracle
Copyright © 2002 Oracle Corporation.

All Rights Reserved.