Showing lov conditionally in oracle forms

Showing lov conditionally in oracle forms

declare
V_LOV    Boolean;
BEGIN
if :Block_name.Column_name  = 'X' THEN   
  V_LOV := SHOW_LOV('LOV45');
ELSE IF :Block_name.Column_name  = 'Y' THEN
  V_LOV :=  SHOW_LOV('LOV47');
ELSE
:Block_name.Column_name := 'NOLOV' ;  END IF ;
end if ;
end;