DBA Data[Home] [Help]

APPS.UMX_LOGIN_HELP_PVT dependencies on WF_ITEM_TYPES

Line 23: g_itemtype wf_item_types.name%type := 'UMXLHELP';

19: -- Person Date Comments
20: -- --------- ------ ------------------------------------------
21: -- Enter procedure, function bodies as shown below
22:
23: g_itemtype wf_item_types.name%type := 'UMXLHELP';
24:
25: g_def_no_max_request pls_integer := 5;
26:
27:

Line 130: WF_ITEM_TYPES_VL WorkflowItemTypeEO,

126: WorkflowItemEO.ITEM_KEY,
127: wf_fwkmon.getitemstatus(WorkflowItemEO.ITEM_TYPE, WorkflowItemEO.ITEM_KEY, WorkflowItemEO.END_DATE,
128: WorkflowItemEO.ROOT_ACTIVITY, WorkflowItemEO.ROOT_ACTIVITY_VERSION) STATUS_CODE
129: FROM WF_ITEMS WorkflowItemEO,
130: WF_ITEM_TYPES_VL WorkflowItemTypeEO,
131: WF_ACTIVITIES_VL ActivityEO,
132: WF_ITEM_ATTRIBUTE_VALUES attrib
133: WHERE WorkflowItemEO.ITEM_TYPE = WorkflowItemTypeEO.NAME
134: AND ActivityEO.ITEM_TYPE = WorkflowItemEO.ITEM_TYPE