APPS.WF_QUEUE dependencies on WF_ITEM_ACTIVITY_STATUS

Line 148: wf_item_activity_status.status(itemtype,itemkey,actid,status);

144:
145: colon:= instr(p_payload.result,':');
146: if colon=0 or p_payload.result is null then
147: -- check if activity is already complete
148: wf_item_activity_status.status(itemtype,itemkey,actid,status);
149: if (status is not null)
150: and (status <> 'COMPLETE') then
151: -- mark activity as Complete:
152: wf_engine.CB(command => 'COMPLETE',

Line 402: Wf_Item_Activity_Status.Create_Status(itemtype, itemkey, actid,

398: minthreshold in number,
399: maxthreshold in number)
400: as
401: begin
402: Wf_Item_Activity_Status.Create_Status(itemtype, itemkey, actid,
403: wf_engine.eng_active, null, null, null);
404:
405: -- Continue processing on activity
406: begin

Line 446: Wf_Item_Activity_Status.Set_Error(itemtype, itemkey, actid,

442: -- **note the error stack will refer to the actid that has been
443: -- rolled back!
444: Wf_Core.Context('Wf_Queue', 'ProcessDeferredEvent', itemtype,
445: to_char(minthreshold), to_char(maxthreshold));
446: Wf_Item_Activity_Status.Set_Error(itemtype, itemkey, actid,
447: wf_engine.eng_exception, FALSE);
448: Wf_Engine_Util.Execute_Error_Process(itemtype, itemkey,
449: actid, wf_engine.eng_exception);
450: Wf_Core.Clear;

Line 839: FROM WF_ITEM_ACTIVITY_STATUSES CWIAS,

835: -- check begin date as well
836: -- move the BEGIN_DATE, SYSDATE comparion to a separate clause
837: SELECT CWA.COST, CWIAS.BEGIN_DATE
838: into cost, l_begdate
839: FROM WF_ITEM_ACTIVITY_STATUSES CWIAS,
840: WF_PROCESS_ACTIVITIES CWPA,
841: WF_ITEMS WI,
842: WF_ACTIVITIES CWA
843: where CWIAS.ACTIVITY_STATUS = 'DEFERRED'

Line 942: from wf_item_activity_statuses_h

938: (g_ActivityHistoryCount(g_Key).ACTID <> enqueue_event.actid)) then
939:
940: select count(process_activity)
941: into l_background_occurrence
942: from wf_item_activity_statuses_h
943: where item_type = enqueue_event.itemtype
944: and item_key = enqueue_event.itemkey
945: and process_activity = enqueue_event.actid
946: and begin_date >= g_background_begin_date;