DBA Data[Home] [Help]

APPS.WF_PURGE dependencies on WF_NOTIFICATION_ATTRIBUTES

Line 355: delete from WF_NOTIFICATION_ATTRIBUTES WNA

351: if (l_nidListTAB.COUNT > 0) then
352: begin
353: FORALL i IN l_nidListTAB.FIRST..l_nidListTAB.LAST
354: -- now delete each notification
355: delete from WF_NOTIFICATION_ATTRIBUTES WNA
356: where WNA.NOTIFICATION_ID = l_nidListTAB(i);
357:
358: --
359: -- Delete the signatures related to this notification

Line 1164: delete from WF_NOTIFICATION_ATTRIBUTES WNA

1160: end if;
1161:
1162: -- Delete notification attributes
1163: FORALL j in l_nidListTAB.FIRST..l_nidListTAB.LAST
1164: delete from WF_NOTIFICATION_ATTRIBUTES WNA
1165: where WNA.NOTIFICATION_ID = l_nidListTAB(j);
1166:
1167: --
1168: -- Delete the signatures related to this notification