Saturday, 31 August 2013

When clicking on report link populate confirm dialogue box and then process the record

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#}})

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: