First error - "OPEN x FOR" x must be a cursor.
http://www.csee.umbc.edu/help/oracle..._ora.htm#40414 and preceding pages.

Second error - unpaired () on line you indicate. Just like the error message says! Why complicate the counting by using unecessary () pairs? Try:
Code:
and (RESERVED_CODER_ID=" " OR P_RESERVED_CODER_ID = RESERVED_CODER_ID) 
and (COMPANY_ID=0 OR P_COMPANY_ID = COMPANY_ID)
and (JOB_ID=0 OR P_JOB_ID = CODING_JOB_ID);