DBA Data[Home] [Help]

APPS.MSD_DPE dependencies on WF_ENGINE

Line 459: wf_engine.ItemStatus(itemType, v_ItemKey.item_key, currStatus, result);

455: retcode := '0';
456:
457: -- Check activity process for current plan
458: for v_ItemKey in c_ItemKeys loop
459: wf_engine.ItemStatus(itemType, v_ItemKey.item_key, currStatus, result);
460: if RTRIM(currStatus) = 'ACTIVE' then
461: retcode := '2';
462: errbuf:='Cannot purge. The plan has an ACTIVE Workflow Process.';
463: exit;

Line 660: wf_engine.ItemStatus(itemType, v_ItemKey.item_key, currStatus, result);

656:
657: -- Check activity process for current plan
658: for v_ItemKey in c_ItemKeys loop
659:
660: wf_engine.ItemStatus(itemType, v_ItemKey.item_key, currStatus, result);
661:
662: if UPPER(RTRIM(currStatus)) = 'COMPLETE' then
663: WF_PURGE.Total(itemType, v_ItemKey.item_key);
664: elsif UPPER(RTRIM(currStatus)) = 'ERROR' or UPPER(RTRIM(currStatus)) = 'ACTIVE' then

Line 665: WF_ENGINE.AbortProcess(itemType, v_ItemKey.item_key);

661:
662: if UPPER(RTRIM(currStatus)) = 'COMPLETE' then
663: WF_PURGE.Total(itemType, v_ItemKey.item_key);
664: elsif UPPER(RTRIM(currStatus)) = 'ERROR' or UPPER(RTRIM(currStatus)) = 'ACTIVE' then
665: WF_ENGINE.AbortProcess(itemType, v_ItemKey.item_key);
666: WF_PURGE.Total(itemType, v_ItemKey.item_key);
667: elsif UPPER(RTRIM(currStatus)) = 'SUSPENDED' then
668: NULL;
669: else