Soft deletion is done if we want to retain the record and the user wants to delete it. In soft deletion, when a delete operation is triggered on a table by the user, a flag is updated instead of deleting the record altogether. All queries on this table use the flag column to display only the records for which the flag has not been set. The query in the Slice & Dice region uses this flag (
"OEHR_EMPLOYEES"."DELETE_FLAG" = 'N') to display only the records which have not been deleted by the user.
Let us now understand the process of creating a link on a column to soft delete a record. The AJAX emp delete column of the Slice & Dice region has
<img src="#IMAGE_PREFIX#del.gif" alt="APP_PROC_DELETE"> ...