APPS.WF_ENGINE_BULK dependencies on WF_ITEMS

Line 86: -- Create rows in bulk in the WF_ITEMS table with the given item type

82: end Current_Schema;
83:
84: --
85: -- BulkCreateItems (PRIVATE)
86: -- Create rows in bulk in the WF_ITEMS table with the given item type
87: -- , item key list
88: -- and the root process name.
89: -- IN
90: -- itemtype - item type

Line 125: insert into WF_ITEMS (

121: --insert depending on whether user_keys and owner_roles are null or not
122: if user_keys.count > 0 and owner_roles.count > 0 then
123: forall arrInd in itemkeys.FIRST..itemkeys.LAST SAVE EXCEPTIONS
124: -- NORMAL: Insert new item and attributes directly in the db
125: insert into WF_ITEMS (
126: ITEM_TYPE,
127: ITEM_KEY,
128: ROOT_ACTIVITY,
129: ROOT_ACTIVITY_VERSION,

Line 152: insert into WF_ITEMS (

148: user_keys(arrInd)
149: );
150: elsif user_keys.count>0 and owner_roles.count=0 then
151: forall arrInd in itemkeys.FIRST..itemkeys.LAST SAVE EXCEPTIONS
152: insert into WF_ITEMS (
153: ITEM_TYPE,
154: ITEM_KEY,
155: ROOT_ACTIVITY,
156: ROOT_ACTIVITY_VERSION,

Line 177: insert into WF_ITEMS (

173: user_keys(arrInd)
174: );
175: elsif owner_roles.count>0 and user_keys.count=0 then
176: forall arrInd in itemkeys.FIRST..itemkeys.LAST SAVE EXCEPTIONS
177: insert into WF_ITEMS (
178: ITEM_TYPE,
179: ITEM_KEY,
180: ROOT_ACTIVITY,
181: ROOT_ACTIVITY_VERSION,

Line 202: insert into WF_ITEMS (

198: to_date(NULL)
199: );
200: elsif owner_roles.count=0 and user_keys.count=0 then
201: forall arrInd in itemkeys.FIRST..itemkeys.LAST SAVE EXCEPTIONS
202: insert into WF_ITEMS (
203: ITEM_TYPE,
204: ITEM_KEY,
205: ROOT_ACTIVITY,
206: ROOT_ACTIVITY_VERSION,

Line 1181: from WF_ITEMS WI

1177: g_successItems.DELETE;
1178: begin
1179: select WI.ROOT_ACTIVITY, WI.ROOT_ACTIVITY_VERSION
1180: into process,version
1181: from WF_ITEMS WI
1182: where WI.ITEM_TYPE = itemtype
1183: and WI.ITEM_KEY = l_itemkeys(1);
1184: exception
1185: when no_Data_found then

Line 1691: from WF_ITEMS WI

1687: -- only for the first itemkey in the list.
1688: begin
1689: select WI.ROOT_ACTIVITY_VERSION
1690: into version
1691: from WF_ITEMS WI
1692: where WI.ITEM_TYPE = itemtype
1693: and WI.ITEM_KEY = l_itemkeys(1)
1694: and WI.ROOT_ACTIVITY=process;
1695: exception