1 PACKAGE WF_Repopulate_AQ AUTHID CURRENT_USER AS
2 /* $Header: WFAQREPS.pls 120.1 2005/07/02 04:26:09 appldev ship $ */
3
4 --
5 -- Procedure
6 -- PopulateAQforItem
7 --
8 -- Purpose
9 -- Repopulates the smtp and/or deferred queue with actions related to a
10 -- particular item, item type, or all items. Note: It does not clear
11 -- off existing actions already on the queues...instead we rely on the
12 -- runtime code to verify actions still need to be done.
13 --
14 -- Arguments:
15 -- ItemType -- set to null for all items.
16 -- ItemKey -- set to null for all items in type.
17 -- SMTPFlag -- Y/N: repopulate smtp aq?
18 -- DeferredFlag -- Y/N: repopulate deferred aq?
19 --
20 Procedure PopulateAQforItem( ItemType in VARCHAR2,
21 ItemKey in VARCHAR2,
22 SMTPFlag in VARCHAR2 default 'Y',
23 DeferredFlag in VARCHAR2 default 'Y');
24
25 END WF_Repopulate_AQ;