1 package WF_ENGINE_RAC AUTHID DEFINER as
2 /* $Header: wfengrcs.pls 120.4 2011/08/10 17:59:07 alsosa noship $ */
3
4 -- WF_RUNTIME_TABLE_POLICY
5 -- Function to set the VPD policy for WF Runtime tables WF_ITEMS,
6 -- WF_ITEM_ACTIVITY_STATUSES, WF_ITEM_ACTIVITY_STATUSES_H, and
7 -- WF_ITEM_ATTRIBUTE_VALUES for RAC affinity
8 FUNCTION WF_RUNTIME_TABLE_POLICY(Owner in VARCHAR2, Objname in VARCHAR2) RETURN VARCHAR2;
9
10 -- WF_QUEUE_TABLE_POLICY
11 -- Function to set the VPD policy for WF queue table
12 -- WF_DEFERRED_TABLE_M for RAC affinity
13 FUNCTION WF_QUEUE_TABLE_POLICY(Owner in VARCHAR2, Objname in VARCHAR2) RETURN VARCHAR2;
14
15 -- SET_CONTEXT
16 -- This procedure sets the values for context WF_ENGINE_RAC
17 -- Current parameters set by this context are:
18 -- WF_ENGINE_RAC: This is the value of the INST_ID in a RAC environment
19 PROCEDURE SET_CONTEXT (p_name in varchar2, p_value in varchar2);
20
21 -- IS_INSTID_PARTITIONED
22 -- This function determines whether the WF Engine Runtime tables
23 -- have beeen or not partitition. This will be checked from several
24 -- places to activate certain RAC-related functionality.
25 FUNCTION IS_INSTID_PARTITIONED return BOOLEAN;
26
27 -- Item_Is_RAC_Enabled
28 -- This function returns true of the given item type has been defined as a RAC-enabled
29 -- one. This is done by checking FND lookup WF_RAC_ENABLED_TYPES.
30 -- If not registered there then will return FALSE.
31 FUNCTION Item_Is_RAC_Enabled (p_itemtype IN WF_ITEM_TYPES.NAME%TYPE) return boolean
32 RESULT_CACHE;
33
34 -- Process_Is_RAC_Enabled
35 -- This function returns true of the given combination of process and item type has
36 -- been defined as a RAC-enabled one. This is done by checking FND lookup
37 -- WF_RAC_ENABLED_TYPES. If not registered there then will return FALSE.
38 FUNCTION Process_Is_RAC_Enabled (p_itemtype IN WF_ITEM_TYPES.NAME%TYPE,
39 p_processname IN WF_ITEMS.ROOT_ACTIVITY%TYPE) return boolean
40 RESULT_CACHE;
41
42 -- Number_Of_Partitions
43 -- This function determines the number of partitions in the WF Runtime tables
44 -- so that other functionality works aware of such number
45 FUNCTION Number_Of_Partitions return number;
46
47 -- BackgroundConcurrent (PUBLIC)
48 -- Run background process for deferred and/or timeout activities
49 -- from Concurrent Manager.
50 -- This is a cover of Background() with different argument types to
51 -- be used by the Concurrent Manager.
52 -- IN
53 -- errbuf - CPM error message
54 -- retcode - CPM return code (0 = success, 1 = warning, 2 = error)
55 -- itemtype - Item type to process. If null process all item types.
56 -- minthreshold - Minimum cost activity to process. No minimum if null.
57 -- maxthreshold - Maximum cost activity to process. No maximum if null.
58 -- process_deferred - Run deferred or waiting processes
59 -- process_timeout - Handle timeout errors
60 -- process_stuck - Handle stuck process errors
61 --
62 procedure BackgroundConcurrent (
63 errbuf out NOCOPY varchar2,
64 retcode out NOCOPY varchar2,
65 itemtype in varchar2 default '',
66 minthreshold in varchar2 default '',
67 maxthreshold in varchar2 default '',
68 process_deferred in varchar2 default 'Y',
69 process_timeout in varchar2 default 'Y',
70 process_stuck in varchar2 default 'N',
71 partition_number in varchar2 default '');
72
73 end WF_ENGINE_RAC;
[Home] [Help]