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 183: update WF_ITEMS set

179: ValTooLarge EXCEPTION;
180: pragma exception_init(ValTooLarge, -01401);
181:
182: begin
183: update WF_ITEMS set
184: PARENT_ITEM_TYPE = Set_Item_Parent.parent_itemtype,
185: PARENT_ITEM_KEY = Set_Item_Parent.parent_itemkey,
186: PARENT_CONTEXT = Set_Item_Parent.parent_context
187: where ITEM_TYPE = Set_Item_Parent.itemtype

Line 269: update WF_ITEMS WI set

265: is
266: begin
267:
268: -- Update owner column
269: update WF_ITEMS WI set
270: OWNER_ROLE = SetItemOwner.owner
271: where WI.ITEM_TYPE = SetItemOwner.itemtype
272: and WI.ITEM_KEY = SetItemOwner.itemkey;
273:

Line 304: update WF_ITEMS WI set

300: itemkey in varchar2,
301: userkey in varchar2)
302: is
303: begin
304: update WF_ITEMS WI set
305: USER_KEY = SetItemUserKey.userkey
306: where WI.ITEM_TYPE = SetItemUserKey.itemtype
307: and WI.ITEM_KEY = SetItemUserKey.itemkey;
308:

Line 356: from WF_ITEMS WI

352:
353: -- No cached value, go directly to the source
354: select USER_KEY
355: into buf
356: from WF_ITEMS WI
357: where WI.ITEM_TYPE = GetItemUserKey.itemtype
358: and WI.ITEM_KEY = GetItemUserKey.itemkey;
359:
360: return(buf);

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

432: end Root_Process;
433:
434: --
435: -- Create_Item (PRIVATE)
436: -- Create one row in the WF_ITEMS table with the given item type, item key
437: -- and the root process name.
438: -- IN
439: -- itemtype - item type
440: -- itemkey - item key

Line 474: insert into WF_ITEMS (

470: rootversion := Wf_Activity.Version(itemtype, wflow, actdate);
471:
472: if (itemkey <> wf_engine.eng_synch) then
473: -- NORMAL: Insert new item and attributes directly in the db
474: insert into WF_ITEMS (
475: ITEM_TYPE,
476: ITEM_KEY,
477: ROOT_ACTIVITY,
478: ROOT_ACTIVITY_VERSION,

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

610: end Active_Date;
611:
612: --Function Acquire_lock (PRIVATE)
613: --This function tries to lock the particular item (for the give
614: --itemtype/itemkey ) in the wf_items table. It returns true if the lock
615: --acquired else returns false.
616:
617: --Here we will not do any error handling but return true/false
618: --for the case of lock_acquired or not . This leaves the caller

Line 632: from wf_items

628: --Bug 2607770
629: --Cursor for acquiring lock
630: cursor itemlock (itemtype varchar2, itemkey varchar2) is
631: select '1'
632: from wf_items
633: where item_type = itemtype
634: and item_key = itemkey
635: for update nowait;
636:

Line 699: UPDATE wf_items

695:
696: l_result NUMBER;
697: i NUMBER;
698: begin
699: UPDATE wf_items
700: SET end_date = sysdate
701: WHERE item_type = p_itemType
702: AND item_key = p_itemKey
703: AND end_date is NULL