eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WF_ITEM dependencies on WF_ENGINE

Line 31: wf_engine.synch_attr_count := 0;

27:
28: --clear ondemand flag
29: wf_item.c_ondemand := null;
30: -- Clear the synch attribute cache too
31: wf_engine.synch_attr_count := 0;
32:
33: exception
34: when others then
35: Wf_Core.Context('Wf_Item', 'ClearCache');

Line 68: if (wf_item.c_itemkey = wf_engine.eng_synch) then

64: -- 2. The cached item is a synch process AND
65: -- 3. The cached item has not yet completed
66: -- then raise an error. Other items cannot be accessed until synch
67: -- item completes, because it can't be restarted from db
68: if (wf_item.c_itemkey = wf_engine.eng_synch) then
69: -- Get status of root process of cached item
70: -- Note: If process completed successfully, the last thing in the
71: -- WIAS runtime cache should be the root process, which is the
72: -- only reason this will work.

Line 81: if (nvl(status, 'x') <> wf_engine.eng_completed) then

77: exception
78: when others then
79: status := 'x'; -- Treat errors like incomplete process
80: end;
81: if (nvl(status, 'x') <> wf_engine.eng_completed) then
82: Wf_Core.Token('ITEMTYPE', itemtype);
83: Wf_Core.Token('ITEMKEY', itemkey);
84: Wf_Core.Raise('WFENG_SYNCH_ITEM');
85: end if;

Line 196: if (WF_ENGINE.AddToItemAttrNumber(parent_itemType, parent_itemKey,

192: end if;
193:
194: if (masterdetail) then
195: --Increment #WAITFORDETAIL master counter if it exists.
196: if (WF_ENGINE.AddToItemAttrNumber(parent_itemType, parent_itemKey,
197: '#WAITFORDETAIL', 1) is NOT NULL) then
198: if (parent_context is NOT null) then
199: --Increment/Create label counter.
200: if (length(parent_context) > 25) then

Line 205: elsif (WF_ENGINE.AddToItemAttrNumber(parent_itemType, parent_itemKey,

201: WF_CORE.Token('LABEL', parent_context);
202: WF_CORE.Token('LENGTH', '25');
203: WF_CORE.Raise('WFENG_LABEL_TOO_LARGE');
204:
205: elsif (WF_ENGINE.AddToItemAttrNumber(parent_itemType, parent_itemKey,
206: '#CNT_'||parent_context, 1)
207: is NULL) then
208: WF_ENGINE.AddItemAttr(itemType=>parent_itemType,
209: itemKey=>parent_itemKey,

Line 208: WF_ENGINE.AddItemAttr(itemType=>parent_itemType,

204:
205: elsif (WF_ENGINE.AddToItemAttrNumber(parent_itemType, parent_itemKey,
206: '#CNT_'||parent_context, 1)
207: is NULL) then
208: WF_ENGINE.AddItemAttr(itemType=>parent_itemType,
209: itemKey=>parent_itemKey,
210: aname=>'#CNT_'||parent_context,
211: number_value=>1);
212: end if; --Label Counter exists

Line 214: WF_ENGINE.AddItemAttr(itemType=>itemType, itemKey=>itemKey,

210: aname=>'#CNT_'||parent_context,
211: number_value=>1);
212: end if; --Label Counter exists
213:
214: WF_ENGINE.AddItemAttr(itemType=>itemType, itemKey=>itemKey,
215: aname=>'#LBL_'||parent_context,
216: text_value=>parent_context);
217:
218: else

Line 472: if (itemkey <> wf_engine.eng_synch) then

468: begin
469:
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,

Line 523: if (itemkey <> wf_engine.eng_synch) then

519: wf_item.c_ondemand := false;
520: end;
521:
522: -- Initialize item attributes
523: if (itemkey <> wf_engine.eng_synch) then
524: -- NORMAL: store attributes in table
525: if(not wf_item.c_ondemand) then
526: -- only popluate when the flag is false
527: insert into WF_ITEM_ATTRIBUTE_VALUES (

Line 621: --on , WF Engine will raise exception etc.

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
619: --the decision of what to do when a resource busy error occurs
620: --(ie FALSE) . For eg : Background engine will ignore it and move
621: --on , WF Engine will raise exception etc.
622:
623: function acquire_lock(itemtype in varchar2,
624: itemkey in varchar2,
625: raise_exception in boolean)

Line 714: if (WF_ENGINE.AddToItemAttrNumber(l_parent_itemType, l_parent_itemKey,

710:
711: --We need to perform some counter processing if they exist.
712: if ((l_parent_itemType is NOT null) and
713: (l_parent_itemKey is NOT null)) then
714: if (WF_ENGINE.AddToItemAttrNumber(l_parent_itemType, l_parent_itemKey,
715: '#WAITFORDETAIL', -1) is NOT null) then
716: if ((l_parent_context is NOT null) and
717: (WF_ENGINE.GetItemAttrText(p_itemType, p_itemKey,
718: '#LBL_'||l_parent_context, TRUE) is NOT NULL)) then

Line 717: (WF_ENGINE.GetItemAttrText(p_itemType, p_itemKey,

713: (l_parent_itemKey is NOT null)) then
714: if (WF_ENGINE.AddToItemAttrNumber(l_parent_itemType, l_parent_itemKey,
715: '#WAITFORDETAIL', -1) is NOT null) then
716: if ((l_parent_context is NOT null) and
717: (WF_ENGINE.GetItemAttrText(p_itemType, p_itemKey,
718: '#LBL_'||l_parent_context, TRUE) is NOT NULL)) then
719: if (WF_ENGINE.SetItemAttrText2(p_itemType, p_itemKey,
720: '#LBL_'||l_parent_context, NULL)) then
721: l_result := WF_ENGINE.AddToItemAttrNumber(l_parent_itemType,

Line 719: if (WF_ENGINE.SetItemAttrText2(p_itemType, p_itemKey,

715: '#WAITFORDETAIL', -1) is NOT null) then
716: if ((l_parent_context is NOT null) and
717: (WF_ENGINE.GetItemAttrText(p_itemType, p_itemKey,
718: '#LBL_'||l_parent_context, TRUE) is NOT NULL)) then
719: if (WF_ENGINE.SetItemAttrText2(p_itemType, p_itemKey,
720: '#LBL_'||l_parent_context, NULL)) then
721: l_result := WF_ENGINE.AddToItemAttrNumber(l_parent_itemType,
722: l_parent_itemKey,
723: '#CNT_'||l_parent_context,

Line 721: l_result := WF_ENGINE.AddToItemAttrNumber(l_parent_itemType,

717: (WF_ENGINE.GetItemAttrText(p_itemType, p_itemKey,
718: '#LBL_'||l_parent_context, TRUE) is NOT NULL)) then
719: if (WF_ENGINE.SetItemAttrText2(p_itemType, p_itemKey,
720: '#LBL_'||l_parent_context, NULL)) then
721: l_result := WF_ENGINE.AddToItemAttrNumber(l_parent_itemType,
722: l_parent_itemKey,
723: '#CNT_'||l_parent_context,
724: -1);
725: end if;

Line 737: if (WF_ENGINE.SetItemAttrText2(p_itemType, p_itemKey,

733: AND TEXT_VALUE is NOT null;
734:
735: if (attrNames.COUNT > 0) then
736: for i in attrNames.FIRST..attrNames.LAST loop
737: if (WF_ENGINE.SetItemAttrText2(p_itemType, p_itemKey,
738: '#LBL_'||attrNames(i), NULL)) then
739: l_result := WF_ENGINE.AddToItemAttrNumber(l_parent_itemtype,
740: l_parent_itemkey,
741: '#CNT_'||attrNames(i),

Line 739: l_result := WF_ENGINE.AddToItemAttrNumber(l_parent_itemtype,

735: if (attrNames.COUNT > 0) then
736: for i in attrNames.FIRST..attrNames.LAST loop
737: if (WF_ENGINE.SetItemAttrText2(p_itemType, p_itemKey,
738: '#LBL_'||attrNames(i), NULL)) then
739: l_result := WF_ENGINE.AddToItemAttrNumber(l_parent_itemtype,
740: l_parent_itemkey,
741: '#CNT_'||attrNames(i),
742: -1);
743: end if; --#LBL_ exists as expected.

Line 762: l_result := WF_ENGINE.AddToItemAttrNumber(l_parent_itemtype,

758: and wiav2.item_key = p_itemKey
759: and wiav2.name = REPLACE(wiav.name,'#CNT_','#LBL_'));
760: if (attrNames.COUNT > 0) then
761: for i in attrNames.FIRST..attrNames.LAST loop
762: l_result := WF_ENGINE.AddToItemAttrNumber(l_parent_itemtype,
763: l_parent_itemkey,
764: attrNames(i), -1);
765: end loop;
766: end if; --There were unvisited ContinueFlow() activites in the child.