eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZPB_WF dependencies on WF_PURGE

Line 1126: WF_PURGE.Total(v_ItemKey.item_Type, v_ItemKey.item_key);

1122:
1123: wf_engine.ItemStatus(v_ItemKey.item_type, v_ItemKey.item_key, currStatus, result);
1124:
1125: if UPPER(RTRIM(currStatus)) = 'COMPLETE' then
1126: WF_PURGE.Total(v_ItemKey.item_Type, v_ItemKey.item_key);
1127: elsif UPPER(RTRIM(currStatus)) = 'ERROR' or UPPER(RTRIM(currStatus)) = 'ACTIVE' then
1128: WF_ENGINE.AbortProcess(v_ItemKey.item_Type, v_ItemKey.item_key);
1129: WF_PURGE.Total(v_ItemKey.item_Type, v_ItemKey.item_key);
1130: elsif UPPER(RTRIM(currStatus)) = 'SUSPENDED' then

Line 1129: WF_PURGE.Total(v_ItemKey.item_Type, v_ItemKey.item_key);

1125: if UPPER(RTRIM(currStatus)) = 'COMPLETE' then
1126: WF_PURGE.Total(v_ItemKey.item_Type, v_ItemKey.item_key);
1127: elsif UPPER(RTRIM(currStatus)) = 'ERROR' or UPPER(RTRIM(currStatus)) = 'ACTIVE' then
1128: WF_ENGINE.AbortProcess(v_ItemKey.item_Type, v_ItemKey.item_key);
1129: WF_PURGE.Total(v_ItemKey.item_Type, v_ItemKey.item_key);
1130: elsif UPPER(RTRIM(currStatus)) = 'SUSPENDED' then
1131: NULL;
1132: else
1133: retcode := '2';

Line 1174: -- The default date setting for exec wf_purge.adhocdirectory is sysdate.

1170:
1171: -- find all workflows for this ACID or instance, abort and purge.
1172: ZPB_WF.DeleteWorkflow(errbuf, retcode, inACID, ACIDType);
1173:
1174: -- The default date setting for exec wf_purge.adhocdirectory is sysdate.
1175: -- This will purge out any ad hoc roles or users I've generated based on the expiration_date
1176: -- set in wf_directory.CreateAdHocRole. This is a standard WF API.
1177: wf_purge.adhocdirectory;
1178:

Line 1177: wf_purge.adhocdirectory;

1173:
1174: -- The default date setting for exec wf_purge.adhocdirectory is sysdate.
1175: -- This will purge out any ad hoc roles or users I've generated based on the expiration_date
1176: -- set in wf_directory.CreateAdHocRole. This is a standard WF API.
1177: wf_purge.adhocdirectory;
1178:
1179: -- Delete task rows from zpb_excp_results, zpb_exp_explanations by instance
1180:
1181: if ACIDType = 'I' then