DBA Data[Home] [Help]

PACKAGE: APPS.WFJ_QUEUE

Source


1 package WFJ_QUEUE AUTHID CURRENT_USER as
2 /* $Header: wfjques.pls 115.5 2002/12/03 21:15:05 vebsingh noship $ */
3 
4     -- Default wait time for DequeuOutbound Operation
5     dequeueDelay INTEGER := 30;
6 
7     -- NAME: enqueueInbound
8     -- Provides a wrapper for the JAVA function to enqueue the
9     -- result of the function activity
10     -- Item Type
11     -- Item Key
12     -- Result
13     -- Attribute List
14     -- Correlation ID
15     -- Error Stack
16    procedure enqueueInbound(pItemType IN VARCHAR2, pItemKey IN VARCHAR2,
17                   pActID IN NUMBER, pResult IN VARCHAR2,
18                   pAttrList IN VARCHAR2,
19                   pCorrelation IN VARCHAR2, pErrorStack IN VARCHAR2);
20 
21 
22    -- NAME: dequeueOutbound
23    -- To remove a message from the Outbound Queue which will be a
24    -- request to execute an external funtion activity
25    -- The payload is seperated into the individuate data elements
26    -- Dequeu Mode
27    -- Navigation
28    -- Correlation ID
29    -- Item Type
30    -- Item Key
31    -- Payload.Item Type
32    -- Payload.Item Key
33    -- Payload.Activity ID
34    -- Payload.Function Name
35    -- Payload Parameter List
36    -- Payload.Result
37    -- Message Handle
38    -- Time Out
39    procedure dequeueOutbound(pDequeueMode IN NUMBER, pNavigation IN NUMBER,
40                    pCorrelation IN VARCHAR2, pItemType IN VARCHAR2,
41                    pPLItemType OUT NOCOPY VARCHAR2, pPLItemKey OUT NOCOPY VARCHAR2,
42                    pPLActID OUT NOCOPY NUMBER, pPLFunctionName OUT NOCOPY VARCHAR2,
43                    pPLParamList OUT NOCOPY VARCHAR2, pPLResult OUT NOCOPY VARCHAR2,
44                    pMessageHandle IN OUT NOCOPY VARCHAR2, pTimeOut OUT NOCOPY VARCHAR2);
45 
46    -- NAME: getEventData
47    -- To retrieve the CLOB data from the event message
48    -- Item Type
49    -- Item Key
50    -- Name of the Item Attribute containing the event
51    -- Event data to be returned.
52    procedure getEventData(p_item_type in VARCHAR2,
53                           p_item_key in VARCHAR2,
54                           p_name in VARCHAR2,
55                           p_event_data out NOCOPY CLOB);
56 
57    --For supporting webServices
58 
59    -- NAME: setEventData
60    -- To set the CLOB data on  the event message
61    -- Item Type
62    -- Item Key
63    -- Name of the Item Attribute containing the event
64    -- Event data to be set.
65    procedure setEventData(p_item_type in VARCHAR2,
66                           p_item_key in VARCHAR2,
67                           p_name in VARCHAR2,
68                           p_event_data in CLOB);
69 
70    function ApplyTransformation(itemtype in varchar2,
71                       itemkey in varchar2,
72                       srcName in varchar2,
73                       dstName in varchar2)
74    return ROWID;
75 
76    -- ====================================================================
77    -- NAME: setDequeueDelay
78    -- Provides a wrapper for the dequeueDelay spec variable
79    -- pDelay - The number of seconds the dequeue operation should block for
80    procedure setDequeueDelay(pDelay in INTEGER);
81 
82    -- ====================================================================
83    -- NAME: getDequeueDelay
84    -- Provides a wrapper for the dequeueDelay spec variable
85    function getDequeueDelay return integer;
86 
87 end WFJ_QUEUE;