Code To Use For Adding Sequence In Oracle Forms

Code To Use For Adding Sequence In Oracle Forms 

CODE to use while creating customized forms with sequence.

Put the code in data block level in pre-insert trigger.

declare

l_seq  number;

begin

FND_STANDARD.SET_WHO();

select t_seq.nextval into l_seq from dual;

:TEACHER.TID:=l_seq;

EXCEPTION WHEN OTHERS THEN

l_seq:=NULL;

end;