DBA Data[Home] [Help]

APPS.WF_PURGE dependencies on WF_NOTIFICATION_ATTRIBUTES

Line 361: delete from WF_NOTIFICATION_ATTRIBUTES WNA

357: if (l_nidListTAB.COUNT > 0) then
358: begin
359: FORALL i IN l_nidListTAB.FIRST..l_nidListTAB.LAST
360: -- now delete each notification
361: delete from WF_NOTIFICATION_ATTRIBUTES WNA
362: where WNA.NOTIFICATION_ID = l_nidListTAB(i);
363:
364: --
365: -- Delete the signatures related to this notification

Line 1149: delete from WF_NOTIFICATION_ATTRIBUTES WNA

1145: end if;
1146:
1147: -- Delete notification attributes
1148: FORALL j in l_nidListTAB.FIRST..l_nidListTAB.LAST
1149: delete from WF_NOTIFICATION_ATTRIBUTES WNA
1150: where WNA.NOTIFICATION_ID = l_nidListTAB(j);
1151:
1152: --
1153: -- Delete the signatures related to this notification