DBA Data[Home] [Help]

PACKAGE: APPS.WF_REPOPULATE_AQ

Source


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;