Oracle Stored procedure help

CREATE OR REPLACE PROCEDURE test123(p_Le in varchar2,p_CHK in varchar2,p_Ty in varchar2,p_Po in varchar2,
p_Cl in varchar2,p_CA in varchar2,p_From_Date in date,p_To_Date in date,p_Number in varchar2,
p_recordset OUT SYS_REFCURSOR) as

sqlquery  varchar2(30000);

BEGIN

IF  p_Le = 'SUB' THEN

     IF  p_CHK ='TRUE' THEN

       sqlquery:= ( ' select type, sub_type, amount from (select rank() over(order by count(distinct(id)) desc) r,');

    ELSIF p_CHK='FALSE' THEN

        sqlquery:=('select');

     END IF;
         IF  p_Po='ALL' THEN

             IF   p_Cl = 'ALL' THEN

                   sqlquery:= sqlquery || 't.type, t.sub_type, count(distinct(id)) as amount from logged l, type t where t.category = '''|| p_CA ||''' and l.ftr_type_id = t.type_id and trunc(date) >=  '''|| p_From_Date ||'''  and trunc(date) <=   '''|| p_To_Date ||''' and t.type = '''|| p_Ty ||''' and substr(l.msisdn,1,4) in ('|| p_Number ||') and t.type <> ''Call'' group by t.type,t.sub_type order by t.type, t.sub_type';

OPEN p_recordset FOR sqlquery;

             END IF;

        END IF;

END IF;

END test123;
/