DBA Data[Home] [Help]

APPS.AZW_UTIL dependencies on WF_ITEMS

Line 369: act_name WF_ITEMS.ROOT_ACTIVITY%TYPE;

365: task_ctxt_id number;
366: task_ctxt_id_txt varchar2(2000);
367: resp_ctxt_id number;
368:
369: act_name WF_ITEMS.ROOT_ACTIVITY%TYPE;
370: bg_id per_business_groups.BUSINESS_GROUP_ID%TYPE;
371: ou_id HR_OPERATING_UNITS.ORGANIZATION_ID%TYPE;
372: io_id ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_ID%TYPE;
373: BEGIN

Line 390: from wf_items

386: context_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'AZW_IA_CTXTNAME');
387: --context_type := wf_engine.GetItemAttrText(itemtype, itemkey, 'AZW_IA_CTXTYP');
388:
389: select root_activity into act_name
390: from wf_items
391: where item_type = itemtype
392: and item_key = itemkey;
393:
394: select waav.TEXT_DEFAULT into context_type