Bi publisher data template for e-business suite

 Hi,I am trying to create the lexical paramter but i am facing issue and can any body please look into this issue

CREATE OR REPLACE package APPS.xxdemolex is

whereas varchar2(1000);

p_from number;

p_to number;

function before_report return boolean ;

end xxdemolex;

CREATE OR REPLACE package body APPS.xxdemolex is

function before_report return boolean is

begin

if p_from is not null and p_to is not null then

whereas:='and scott.emp.deptno between p_from and p_to';

end if;

if p_from is not null and p_to is  null then

whereas:='and scott.emp.deptno >= p_from';