APPS.FUN_TRX_PVT dependencies on WF_NOTIFICATION

Line 4842: ' wf_notifications notif ' ||

4838: -- Once transactions have gone into GL, AP and AR workflows,
4839: -- they cannot be deleted
4840: l_sql := ' SELECT notif.notification_id ' ||
4841: ' FROM wf_item_activity_statuses wias, ' ||
4842: ' wf_notifications notif ' ||
4843: ' WHERE wias.item_type IN (''FUNRMAIN'', ''FUNIMAIN'', ' ||
4844: ' ''FUNRTVAL'') ' ||
4845: ' AND wias.notification_id = notif.notification_id ' ||
4846: ' AND notif.status = ''OPEN''';

Line 4866: wf_notification.cancel

4862: IF l_notif_tbl.COUNT > 0
4863: THEN
4864: FOR i IN l_notif_tbl.FIRST..l_notif_tbl.LAST
4865: LOOP
4866: wf_notification.cancel
4867: (l_notif_tbl(i),
4868: 'Transaction Deleted');
4869:
4870: END LOOP;