[Home] [Help]
1583: -- Move_To_History (PRIVATE)
1584: -- Move the item activity status row from WF_ITEM_ACTIVITY_STATUSES to
1585: -- WF_ITEM_ACTIVITY_STATUSES_H table.
1586: -- IN
1587: -- itemtype - A valid item type from (WF_ITEM_TYPES table).
1588: -- itemkey - A string generated from the application object's primary key.
1589: -- actid - The activity instance id.
1590: --
1591: procedure move_to_history(itemtype in varchar2,
1703: --
1704: -- Execute_Activity (PRIVATE)
1705: -- Execute a notification or function activity and process the result.
1706: -- IN
1707: -- itemtype - A valid item type from (WF_ITEM_TYPES table).
1708: -- itemkey - A string generated from the application object's primary key.
1709: -- actid - The activity instance id.
1710: -- funmode - function mode (RUN/CANCEL/TIMEOUT)
1711: --
1875: -- Call an arbitrary function using dynamic sql.
1876: -- The function must conform to Workflow interface standard.
1877: -- IN
1878: -- funname - The name of the function that is going to be executed.
1879: -- itemtype - A valid item type from (WF_ITEM_TYPES table).
1880: -- itemkey - A string generated from the application object's primary key.
1881: -- actid - The activity instance id.
1882: -- funmode - Function mode (RUN/CANCEL/TIMEOUT)
1883: -- OUT
2086: if (status <> WF_CACHE.task_SUCCESS) then
2087:
2088: SELECT NAME, WF_SELECTOR
2089: INTO WF_CACHE.ItemTypes(witIND)
2090: FROM WF_ITEM_TYPES
2091: WHERE NAME = itemtype;
2092:
2093: end if;
2094: