DBA Data[Home] [Help]

APPS.MSDWF dependencies on WF_PROCESS_ACTIVITIES

Line 36: SELECT ACTIVITY_NAME, PROCESS_NAME INTO ActEntry, Process FROM WF_PROCESS_ACTIVITIES

32:
33: BEGIN
34: IF (funcmode = 'RUN') THEN
35: resultout :='COMPLETE:N';
36: SELECT ACTIVITY_NAME, PROCESS_NAME INTO ActEntry, Process FROM WF_PROCESS_ACTIVITIES
37: WHERE INSTANCE_ID=actid;
38: SELECT TEXT_VALUE INTO thisrole FROM WF_ITEM_ATTRIBUTE_VALUES
39: WHERE ITEM_KEY=itemkey AND ITEM_TYPE=itemtype AND NAME='ODPROLE';
40: express_server:=wf_engine.GetItemAttrText(Itemtype => ItemType,

Line 268: SELECT ACTIVITY_NAME INTO ActEntry FROM WF_PROCESS_ACTIVITIES

264: AttachDBName varchar2(240);
265: BEGIN
266: IF (funcmode = 'RUN') THEN
267: resultout :='COMPLETE:N';
268: SELECT ACTIVITY_NAME INTO ActEntry FROM WF_PROCESS_ACTIVITIES
269: WHERE INSTANCE_ID=actid;
270: SELECT TEXT_VALUE INTO thisrole FROM WF_ITEM_ATTRIBUTE_VALUES
271: WHERE ITEM_KEY=itemkey AND ITEM_TYPE=itemtype AND NAME='ODPROLE';
272: -- Inital default is "CONTINUE". Values are CYCLE, DONE, LAUNCH

Line 372: SELECT ACTIVITY_NAME INTO ActEntry FROM WF_PROCESS_ACTIVITIES

368: PlanID varchar2(200);
369: BEGIN
370: IF (funcmode = 'RUN') THEN
371: resultout :='COMPLETE:N';
372: SELECT ACTIVITY_NAME INTO ActEntry FROM WF_PROCESS_ACTIVITIES
373: WHERE INSTANCE_ID=actid;
374: SELECT TEXT_VALUE INTO thisrole FROM WF_ITEM_ATTRIBUTE_VALUES
375: WHERE ITEM_KEY=itemkey AND ITEM_TYPE=itemtype AND NAME='ODPROLE';
376: express_server := wf_engine.GetItemAttrText(Itemtype => ItemType,