DBA Data[Home] [Help]

APPS.JTF_UM_APPROVAL_REQUESTS_PVT dependencies on WF_FWKMON

Line 409: from (SELECT wf_fwkmon.getitemstatus(WorkflowItemEO.ITEM_TYPE, WorkflowItemEO.ITEM_KEY, WorkflowItemEO.END_DATE, WorkflowItemEO.ROOT_ACTIVITY, WorkflowItemEO.ROOT_ACTIVITY_VERSION) STATUS_CODE

405: status_code varchar2(100);
406: begin
407: begin
408: select x.STATUS_CODE into status_code
409: from (SELECT wf_fwkmon.getitemstatus(WorkflowItemEO.ITEM_TYPE, WorkflowItemEO.ITEM_KEY, WorkflowItemEO.END_DATE, WorkflowItemEO.ROOT_ACTIVITY, WorkflowItemEO.ROOT_ACTIVITY_VERSION) STATUS_CODE
410: FROM WF_ITEMS WorkflowItemEO,
411: WF_ITEM_TYPES_VL WorkflowItemTypeEO,
412: WF_ACTIVITIES_VL ActivityEO
413: WHERE WorkflowItemEO.ITEM_TYPE = WorkflowItemTypeEO.NAME AND