DBA Data[Home] [Help]

APPS.WF_ITEM_ACTIVITY_STATUS dependencies on WF_ITEMS

Line 944: UPDATE WF_ITEMS SET

940: if (actid = rootid) then
941: if (status = wf_engine.eng_completed) then
942: l_result := WF_ITEM.SetEndDate(itemtype, itemkey);
943: elsif (status = wf_engine.eng_active) then
944: UPDATE WF_ITEMS SET
945: END_DATE = to_date(NULL)
946: WHERE ITEM_TYPE = itemtype
947: AND ITEM_KEY = itemkey;
948: end if;