APPS.MSD_WF dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 48: SELECT TEXT_VALUE INTO thisrole FROM WF_ITEM_ATTRIBUTE_VALUES

44: IF (funcmode = 'RUN') THEN
45: resultout :='COMPLETE:N';
46: SELECT ACTIVITY_NAME, PROCESS_NAME INTO ActEntry, Process FROM WF_PROCESS_ACTIVITIES
47: WHERE INSTANCE_ID=actid;
48: SELECT TEXT_VALUE INTO thisrole FROM WF_ITEM_ATTRIBUTE_VALUES
49: WHERE ITEM_KEY=itemkey AND ITEM_TYPE=itemtype AND NAME='ODPROLE';
50: express_server:=wf_engine.GetItemAttrText(Itemtype => ItemType,
51: Itemkey => ItemKey,
52: aname => 'EXPCONN');

Line 325: SELECT TEXT_VALUE INTO thisrole FROM WF_ITEM_ATTRIBUTE_VALUES

321: IF (funcmode = 'RUN') THEN
322: resultout :='COMPLETE:N';
323: SELECT ACTIVITY_NAME INTO ActEntry FROM WF_PROCESS_ACTIVITIES
324: WHERE INSTANCE_ID=actid;
325: SELECT TEXT_VALUE INTO thisrole FROM WF_ITEM_ATTRIBUTE_VALUES
326: WHERE ITEM_KEY=itemkey AND ITEM_TYPE=itemtype AND NAME='ODPROLE';
327: -- Inital default is "CONTINUE". Values are CYCLE, DONE, LAUNCH
328: -- LAUNCH means Make the call to launch a sub process.
329: -- DONE means all DB Assignments are complete.

Line 437: SELECT TEXT_VALUE INTO thisrole FROM WF_ITEM_ATTRIBUTE_VALUES

433: IF (funcmode = 'RUN') THEN
434: resultout :='COMPLETE:N';
435: SELECT ACTIVITY_NAME INTO ActEntry FROM WF_PROCESS_ACTIVITIES
436: WHERE INSTANCE_ID=actid;
437: SELECT TEXT_VALUE INTO thisrole FROM WF_ITEM_ATTRIBUTE_VALUES
438: WHERE ITEM_KEY=itemkey AND ITEM_TYPE=itemtype AND NAME='ODPROLE';
439: express_server := wf_engine.GetItemAttrText(Itemtype => ItemType,
440: Itemkey => ItemKey,
441: aname => 'EXPCONN');

Line 1185: SELECT TEXT_VALUE INTO thisrole FROM WF_ITEM_ATTRIBUTE_VALUES

1181:
1182: gItemType := ItemType;
1183: gItemKey := ItemKey;
1184:
1185: SELECT TEXT_VALUE INTO thisrole FROM WF_ITEM_ATTRIBUTE_VALUES
1186: WHERE ITEM_KEY=itemkey AND ITEM_TYPE=itemtype AND NAME='ODPROLE';
1187:
1188: express_server:=wf_engine.GetItemAttrText(Itemtype => ItemType,
1189: Itemkey => ItemKey,