APPS.WF_ITEM dependencies on WF_ITEMS

Line 93: from WF_ITEMS WI

89: select WI.ROOT_ACTIVITY, WI.ROOT_ACTIVITY_VERSION, WI.BEGIN_DATE,
90: WI.USER_KEY
91: into wf_item.c_root_activity, wf_item.c_root_activity_version,
92: wf_item.c_begin_date, wf_item.c_userkey
93: from WF_ITEMS WI
94: where WI.ITEM_TYPE = InitCache.itemtype
95: and WI.ITEM_KEY = InitCache.itemkey;
96:
97: -- Save cache key values

Line 189: update WF_ITEMS set

185: l_count number;
186: begin
187: begin
188: savepoint wf_loop_savepoint;
189: update WF_ITEMS set
190: PARENT_ITEM_TYPE = Set_Item_Parent.parent_itemtype,
191: PARENT_ITEM_KEY = Set_Item_Parent.parent_itemkey,
192: PARENT_CONTEXT = Set_Item_Parent.parent_context
193: where ITEM_TYPE = Set_Item_Parent.itemtype

Line 202: from WF_ITEMS

198: end if;
199:
200: -- bug 12850046: preventing a loop condition from being created
201: select count(1) into l_count
202: from WF_ITEMS
203: CONNECT BY PRIOR PARENT_ITEM_TYPE = ITEM_TYPE AND
204: PRIOR PARENT_ITEM_KEY = ITEM_KEY
205: start with ITEM_TYPE=Set_Item_Parent.itemtype AND
206: ITEM_KEY=Set_Item_Parent.itemkey;

Line 292: update WF_ITEMS WI set

288: is
289: begin
290:
291: -- Update owner column
292: update WF_ITEMS WI set
293: OWNER_ROLE = SetItemOwner.owner
294: where WI.ITEM_TYPE = SetItemOwner.itemtype
295: and WI.ITEM_KEY = SetItemOwner.itemkey;
296:

Line 327: update WF_ITEMS WI set

323: itemkey in varchar2,
324: userkey in varchar2)
325: is
326: begin
327: update WF_ITEMS WI set
328: USER_KEY = SetItemUserKey.userkey
329: where WI.ITEM_TYPE = SetItemUserKey.itemtype
330: and WI.ITEM_KEY = SetItemUserKey.itemkey;
331:

Line 379: from WF_ITEMS WI

375:
376: -- No cached value, go directly to the source
377: select USER_KEY
378: into buf
379: from WF_ITEMS WI
380: where WI.ITEM_TYPE = GetItemUserKey.itemtype
381: and WI.ITEM_KEY = GetItemUserKey.itemkey;
382:
383: return(buf);

Line 459: -- Create one row in the WF_ITEMS table with the given item type, item key

455: end Root_Process;
456:
457: --
458: -- Create_Item (PRIVATE)
459: -- Create one row in the WF_ITEMS table with the given item type, item key
460: -- and the root process name.
461: -- IN
462: -- itemtype - item type
463: -- itemkey - item key

Line 497: insert into WF_ITEMS (

493: rootversion := Wf_Activity.Version(itemtype, wflow, actdate);
494:
495: if (itemkey <> wf_engine.eng_synch) then
496: -- NORMAL: Insert new item and attributes directly in the db
497: insert into WF_ITEMS (
498: ITEM_TYPE,
499: ITEM_KEY,
500: ROOT_ACTIVITY,
501: ROOT_ACTIVITY_VERSION,

Line 637: --itemtype/itemkey ) in the wf_items table. It returns true if the lock

633: end Active_Date;
634:
635: --Function Acquire_lock (PRIVATE)
636: --This function tries to lock the particular item (for the give
637: --itemtype/itemkey ) in the wf_items table. It returns true if the lock
638: --acquired else returns false.
639:
640: --Here we will not do any error handling but return true/false
641: --for the case of lock_acquired or not . This leaves the caller

Line 655: from wf_items

651: --Bug 2607770
652: --Cursor for acquiring lock
653: cursor itemlock (itemtype varchar2, itemkey varchar2) is
654: select '1'
655: from wf_items
656: where item_type = itemtype
657: and item_key = itemkey
658: for update nowait;
659:

Line 729: UPDATE wf_items

725: pragma exception_init(ValTooLargeNew, -12899);
726: l_module varchar2(20) := 'SetEndDate';
727: l_context_label varchar2(40);
728: begin
729: UPDATE wf_items
730: SET end_date = sysdate
731: WHERE item_type = p_itemType
732: AND item_key = p_itemKey
733: AND end_date is NULL

Line 817: from wf_items wi

813:
814: -- Bug 10126650
815: -- Find active error children for this completing item and abort them
816: for c_abort in (select item_type, item_key
817: from wf_items wi
818: where wi.parent_item_type = p_itemtype
819: and wi.parent_item_key = p_itemkey
820: and wi.parent_item_type = (select wiav.text_value
821: from wf_item_attribute_values wiav