APPS.FUN_TRX_PVT dependencies on WF_NOTIFICATION

Line 4522: ' wf_notifications notif ' ||

4518: -- Once transactions have gone into GL, AP and AR workflows,
4519: -- they cannot be deleted
4520: l_sql := ' SELECT notif.notification_id ' ||
4521: ' FROM wf_item_activity_statuses wias, ' ||
4522: ' wf_notifications notif ' ||
4523: ' WHERE wias.item_type IN (''FUNRMAIN'', ''FUNIMAIN'', ' ||
4524: ' ''FUNRTVAL'') ' ||
4525: ' AND wias.notification_id = notif.notification_id ' ||
4526: ' AND notif.status = ''OPEN''';

Line 4546: wf_notification.cancel

4542: IF l_notif_tbl.COUNT > 0
4543: THEN
4544: FOR i IN l_notif_tbl.FIRST..l_notif_tbl.LAST
4545: LOOP
4546: wf_notification.cancel
4547: (l_notif_tbl(i),
4548: 'Transaction Deleted');
4549:
4550: END LOOP;