WHEN-NEW-FORM-INSTANCE trigger will work when you are opening form this will fetch all records available in your table and fetch into your block.
go_block('XXCAD_SR_REFUND_NOTIFICATIONS');
if :XXCAD_SR_REFUND_NOTIFICATIONS.task_status = 'Open'
then
do_key('execute_query');
else
fnd_message.set_string ('There is no Open SRs in your Bin');
fnd_message.show;
end if;
Nice learning from your blog
ReplyDeleteThanks