DBA Data[Home] [Help]

APPS.WF_ENGINE_RAC dependencies on WF_ITEM_TYPES

Line 68: FUNCTION Item_Is_RAC_Enabled (p_itemtype IN WF_ITEM_TYPES.NAME%TYPE)

64: return FALSE;
65: END IS_INSTID_PARTITIONED;
66:
67: -- Item_Is_RAC_Enabled. See specification file for details
68: FUNCTION Item_Is_RAC_Enabled (p_itemtype IN WF_ITEM_TYPES.NAME%TYPE)
69: return boolean RESULT_CACHE IS
70: l_dummy number;
71: Begin
72: select count(1) into l_dummy

Line 89: FUNCTION Process_Is_RAC_Enabled (p_itemtype IN WF_ITEM_TYPES.NAME%TYPE,

85: return FALSE;
86: End Item_Is_RAC_Enabled;
87:
88: -- Process_Is_RAC_Enabled. See specification file for details
89: FUNCTION Process_Is_RAC_Enabled (p_itemtype IN WF_ITEM_TYPES.NAME%TYPE,
90: p_processname IN WF_ITEMS.ROOT_ACTIVITY%TYPE)
91: return boolean RESULT_CACHE IS
92: l_dummy number;
93: l_string varchar2(100) := upper(p_itemtype)||':'||upper(p_processname);

Line 151: from WF_ITEM_TYPES_VL WITV,

147: TYPE Item_Type_Tab IS TABLE of WF_ITEMS.ITEM_TYPE%TYPE;
148: ItemsNum Item_Type_Tab := Item_Type_Tab();
149: cursor c_RACTypes is
150: select WITV.NAME
151: from WF_ITEM_TYPES_VL WITV,
152: (select unique(substr(LOOKUP_CODE,1, instr(LOOKUP_CODE,':',1)-1)) L_CODE
153: from FND_LOOKUP_VALUES_VL
154: where LOOKUP_TYPE='WF_RAC_ENABLED_TYPES'
155: and ENABLED_FLAG='Y') WFRAC