WHEN-NEW-BLOCK-INSTANCE detail block

---WHEN-NEW-BLOCK-INSTANCE  detail block

declare
    cursor c1 is
    select req_detail.itemcode,item.itemname,req_detail.qty from store.req_detail,store.item
    where item.itemcode=req_detail.itemcode
    and req_detail.reqno=:br_receipt_master.prs_no;
    a number;
begin
    a:=1;
    for cr in c1 loop
        :br_receipt_detail.sl_no :=a;
        :br_receipt_detail.itemcode :=cr.itemcode;
            :br_receipt_detail.itemname:=cr.itemname;
                :br_receipt_detail.qty:=cr.qty;
        a:=a+1;
    next_record;
    end loop;
    first_record;
                    end;

 ---WHEN-NEW-record-INSTANCE  detail block

:sl_no := :system.trigger_record; 

slno in oracle  forms
1
2
3
4
5