DBA Data[Home] [Help]

APPS.MST_WORKFLOW_PKG dependencies on WF_ITEMS

Line 151: FROM wf_items wi

147:
148: CURSOR Cur_Delete_Activities (l_item_type in varchar2, l_plan_char in varchar2)
149: IS
150: SELECT wi.item_key
151: FROM wf_items wi
152: WHERE wi.item_type = l_item_type
153: AND wi.item_key like l_plan_char;
154:
155: TYPE varchar2_tab_type IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;

Line 184: UPDATE wf_items wi

180: WHERE wiah.item_type = l_item_type
181: AND wiah.item_key = l_item_key_tab(i));
182:
183: FORALL i IN l_item_key_tab.FIRST..l_item_key_tab.LAST
184: UPDATE wf_items wi
185: SET wi.end_date = sysdate
186: WHERE wi.item_type = l_item_type
187: AND wi.item_key = l_item_key_tab(i);
188: