APPS.MSD_WF dependencies on WF_PROCESS_ACTIVITIES

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

42: gItemKey := ItemKey;
43:
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,

Line 323: SELECT ACTIVITY_NAME INTO ActEntry FROM WF_PROCESS_ACTIVITIES

319: script varchar2(2000);
320: BEGIN
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

Line 435: SELECT ACTIVITY_NAME INTO ActEntry FROM WF_PROCESS_ACTIVITIES

431: gItemKey := ItemKey;
432:
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,