When clicking on report link populate confirm dialogue box and then process the record :
Create a report with delete option :
Create one text item to hold the selected empno when click on report link (delete) ex : P1_DELETE_EMP
Go to report attributes > 'Delete' column attributes >
Add below java script in URL field :
javascript:apex.confirm('Are you sure you want to delete this record', {request:
'DELETE',SET : {'P1_DELETE_EMP': #EMPNO#}})
'DELETE',SET : {'P1_DELETE_EMP': #EMPNO#}})
Write a PL/SQL process to delete the selected record :
Add condition to the process :
Request = Expression1
Expressoin : 'DELETE'
That's it, when you click on delete report link you can see the confirm dialogue box and clicking on 'OK', Record will be deleted.





No comments:
Post a Comment