APPS.WF_ENGINE_RAC dependencies on WF_ITEMS

Line 52: table_name in ('WF_ITEMS',

48: FROM DUAL
49: WHERE 4=(select count(1)
50: from dba_tab_partitions
51: where table_owner=l_applsys and
52: table_name in ('WF_ITEMS',
53: 'WF_ITEM_ATTRIBUTE_VALUES',
54: 'WF_ITEM_ACTIVITY_STATUSES',
55: 'WF_ITEM_ACTIVITY_STATUSES_H')
56: and partition_name='INST_ID1');

Line 90: p_processname IN WF_ITEMS.ROOT_ACTIVITY%TYPE)

86: End Item_Is_RAC_Enabled;
87:
88: -- Process_Is_RAC_Enabled. See specification file for details
89: FUNCTION Process_Is_RAC_Enabled (p_itemtype IN WF_ITEM_TYPES.NAME%TYPE,
90: p_processname IN WF_ITEMS.ROOT_ACTIVITY%TYPE)
91: return boolean RESULT_CACHE IS
92: l_dummy number;
93: l_string varchar2(100) := upper(p_itemtype)||':'||upper(p_processname);
94: Begin

Line 116: where table_name='WF_ITEMS' and

112: l_num_partitions number;
113: begin
114: select count(1) into l_num_partitions
115: from dba_tab_partitions
116: where table_name='WF_ITEMS' and
117: table_owner=wf_core.translate('WF_SCHEMA');
118: return l_num_partitions;
119: exception
120: when others then

Line 147: TYPE Item_Type_Tab IS TABLE of WF_ITEMS.ITEM_TYPE%TYPE;

143: errmsg varchar2(2000);
144: errstack varchar2(4000);
145: rac_req_id number;
146: n_partitions number := WF_ENGINE_RAC.Number_Of_Partitions;
147: TYPE Item_Type_Tab IS TABLE of WF_ITEMS.ITEM_TYPE%TYPE;
148: ItemsNum Item_Type_Tab := Item_Type_Tab();
149: cursor c_RACTypes is
150: select WITV.NAME
151: from WF_ITEM_TYPES_VL WITV,