DBA Data[Home] [Help]

APPS.MST_WORKFLOW_PKG dependencies on WF_NOTIFICATIONS

Line 171: UPDATE wf_notifications wn

167: CLOSE Cur_Delete_Activities;
168:
169: IF NVL(l_item_key_tab.LAST,0) > 0 THEN
170: FORALL i IN l_item_key_tab.FIRST..l_item_key_tab.LAST
171: UPDATE wf_notifications wn
172: SET wn.end_date = sysdate
173: WHERE wn.group_id IN (SELECT wias.notification_id
174: FROM wf_item_activity_statuses wias
175: WHERE wias.item_type = l_item_type