If I have a package body like the following. Is p_num considered a bind variable in this situation, or should I be rewriting this:

CREATE PACKAGE BODY dummy_pg
AS

PROCEDURE do_something(p_in IN NUMBER)
IS
CURSOR conn_csr (p_num VARCHAR2) IS
SELECT *
FROM dual
WHERE 1 = p_num;

search_num number;
BEGIN
FOR user_rec IN conn_csr(p_in) LOOP
--do something
END LOOP;
END;
END;

-Chuck

Yes, that's a bind variable.