APPS.MSDWF dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 38: SELECT TEXT_VALUE INTO thisrole FROM WF_ITEM_ATTRIBUTE_VALUES

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,
41: Itemkey => ItemKey,
42: aname => 'EXPCONN');

Line 270: SELECT TEXT_VALUE INTO thisrole FROM WF_ITEM_ATTRIBUTE_VALUES

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
273: -- LAUNCH means Make the call to launch a sub process.
274: -- DONE means all DB Assignments are complete.

Line 374: SELECT TEXT_VALUE INTO thisrole FROM WF_ITEM_ATTRIBUTE_VALUES

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,
377: Itemkey => ItemKey,
378: aname => 'EXPCONN');