107: itemkeys wf_engine_bulk.itemkeytabtype;
108:
109: begin
110:
111: rootversion := Wf_Activity.Version(itemtype, wflow, actdate);
112: --initialize the table of itemkeys from the list of successful items.
113: if g_SuccessItems.COUNT=0 then
114: return;
115: else
890: -- calling create_item to avoid foreign key problems during the insert.
891: -- The check that the process is runnable can't be done until AFTER
892: -- create_item so the date has been established.
893: actdate := sysdate;
894: typ := Wf_Activity.Type(itemtype, root, actdate);
895: if ((typ is null) or (typ <> wf_engine.eng_process)) then
896:
897: g_FailedItems:=l_itemkeys;
898:
1113: AND WPA.PROCESS_VERSION = version
1114: AND WPA.START_END = wf_engine.eng_start
1115: AND NOT EXISTS (
1116: SELECT NULL
1117: FROM WF_ACTIVITY_TRANSITIONS WAT
1118: WHERE WAT.TO_PROCESS_ACTIVITY = WPA.INSTANCE_ID);
1119:
1120: TYPE DateTabType is table of DATE index by binary_integer;
1121: TYPE NumTabType is table of NUMBER index by binary_integer;
1375: begin
1376:
1377:
1378: -- calculate the activity function name and type
1379: act_fname:= Wf_Activity.activity_function(itemtype,l_itemkeys(l_itemkeys.FIRST),childarr(i));
1380: act_ftype:= Wf_Activity.activity_function_type(itemtype,l_itemkeys(l_itemkeys.FIRST),childarr(i));
1381:
1382:
1383: --depending on the activity function, enqueue on the proper queue.
1376:
1377:
1378: -- calculate the activity function name and type
1379: act_fname:= Wf_Activity.activity_function(itemtype,l_itemkeys(l_itemkeys.FIRST),childarr(i));
1380: act_ftype:= Wf_Activity.activity_function_type(itemtype,l_itemkeys(l_itemkeys.FIRST),childarr(i));
1381:
1382:
1383: --depending on the activity function, enqueue on the proper queue.
1384:
1796: -- defer and enqueue the given activity across all itemkeys
1797: begin
1798:
1799: -- calculate the activity function name and type
1800: act_fname:= Wf_Activity.activity_function(itemtype,l_itemkeys(l_itemkeys.first),actid);
1801: act_ftype:= Wf_Activity.activity_function_type(itemtype,l_itemkeys(l_itemkeys.first),actid);
1802:
1803:
1804:
1797: begin
1798:
1799: -- calculate the activity function name and type
1800: act_fname:= Wf_Activity.activity_function(itemtype,l_itemkeys(l_itemkeys.first),actid);
1801: act_ftype:= Wf_Activity.activity_function_type(itemtype,l_itemkeys(l_itemkeys.first),actid);
1802:
1803:
1804:
1805: if l_itemkeys.COUNT <=0 then