OPEN o_cur FOR 'select 1,2,3,4 FROM tbl_ name WHERE varenr = :i' USING i_varenr;      

CREATE OR REPLACE PROCEDURE get_my_cursor
                        (p_column IN  <your choice>,
                         p_table IN  <your choice>,
                         p_predicate IN <your choice>,
                         p_jobid  IN  dept.jobid%TYPE,
                         p_cursor OUT SYS_REFCURSOR)

sql_stmt VARCHAR2(1000);
job_rec  dept%ROWTYPE;

BEGIN

sql_stmt := 'SELECT job_name, :c
               FROM :t
              WHERE :w > :j';

 OPEN p_cursor FOR sql_stmt
    USING p_column, p_table, p_predicate, p_jobid;

 ..
END;