Oracle Forms Book Reference

go through this link..


https://books.google.co.in/books?id=j8OnBQAAQBAJ&pg=PA7&lpg=PA7&dq=post+query+code+in+oracle+forms&source=bl&ots=dBONFmoka2&sig=FgDc0KdhTSF07rvj6444QuuIHD0&hl=en&sa=X&ved=0CD4Q6AEwBWoVChMI3NrqvbijyAIVxJGOCh1KSwNg#v=onepage&q=WHEN-NEW-FORM-INSTANCE&f=false



to move loop:

WHEN-NEW-FORM-INSTANCE trigger in oracle forms

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;