DBA Data[Home] [Help]

APPS.PO_REQAPPROVAL_INIT1 dependencies on WF_ITEMS

Line 819: FROM wf_items

815: -- if it has, don't create process again.
816: BEGIN
817: SELECT COUNT(*)
818: INTO x_wf_created
819: FROM wf_items
820: WHERE item_type = l_itemtype
821: AND item_key = l_itemkey;
822: EXCEPTION
823: WHEN OTHERS THEN

Line 7269: FROM wf_items

7265: l_item_key :=wf_engine.GetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'ERROR_ITEM_KEY');
7266: l_count := wf_engine.GetItemAttrNumber ( itemtype => itemtype, itemkey => itemkey, aname => 'RETRY_COUNT');
7267: SELECT COUNT(*)
7268: INTO l_error_count
7269: FROM wf_items
7270: WHERE parent_item_type=l_item_type
7271: AND parent_item_key = l_item_key;
7272: IF (l_error_count <= l_count) THEN
7273: resultout :='COMPLETE:'||'Y'; -- retry