DBA Data[Home] [Help]

APPS.MST_WORKFLOW_PKG dependencies on WF_ITEM_ACTIVITY_STATUSES_H

Line 179: FROM wf_item_activity_statuses_h wiah

175: WHERE wias.item_type = l_item_type
176: AND wias.item_key = l_item_key_tab(i)
177: UNION ALL
178: SELECT wiah.notification_id
179: FROM wf_item_activity_statuses_h wiah
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

Line 196: UPDATE wf_item_activity_statuses_h wiah

192: WHERE wias.item_type = l_item_type
193: AND wias.item_key = l_item_key_tab(i);
194:
195: FORALL i IN l_item_key_tab.FIRST..l_item_key_tab.LAST
196: UPDATE wf_item_activity_statuses_h wiah
197: SET wiah.end_date = sysdate
198: WHERE wiah.item_type = l_item_type
199: AND wiah.item_key = l_item_key_tab(i);
200: