DBA Data[Home] [Help]

APPS.MST_WORKFLOW_PKG dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 174: FROM wf_item_activity_statuses wias

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
176: AND wias.item_key = l_item_key_tab(i)
177: UNION ALL
178: SELECT wiah.notification_id

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 190: UPDATE wf_item_activity_statuses wias

186: WHERE wi.item_type = l_item_type
187: AND wi.item_key = l_item_key_tab(i);
188:
189: FORALL i IN l_item_key_tab.FIRST..l_item_key_tab.LAST
190: UPDATE wf_item_activity_statuses wias
191: SET wias.end_date = sysdate
192: WHERE wias.item_type = l_item_type
193: AND wias.item_key = l_item_key_tab(i);
194:

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: