Apps CRM modules - Program Issue

  Hi all,

Can you please find the bug  in below code.. It's showing ORA-00936: missing expression error but,  query is working properly..

declare

TYPE refcursor IS REF CURSOR;

TYPE varchartable IS TABLE OF VARCHAR2(255);

    jobid        NUMBER;

    notcur       refcursor;

    lastrun      TIMESTAMP;

    errorcode    NUMBER := 0;

    errormessage VARCHAR2(1000);

    jobname      custom.job_master.job_name%TYPE;

    joblastrun   TIMESTAMP;

    insertcount  custom.job_history.insert_count%TYPE := 0;

    updatecount  custom.job_history.update_count%TYPE := 0;

    errorcount   custom.job_history.error_count%TYPE;

    -- Modified by vishal on 21 Jun 2010 to change server name

    --      mailhost         VARCHAR2 (30)                   := 'infomail.sify.net';

    --      mail_conn        UTL_SMTP.connection;

    --      sender           VARCHAR2 (30)               := 'sify.crm@sifycorp.com';