SQL & PL/SQL

Hi Everyone,

The user will select multiple pick value from screen like 100, 101, 102 etc
and those values need to be passed to the below query and generate the
o/p for further processing.
Can some one please tell how can i pass multiple values to a bind parameter in a query having a equal to sign?

SELECT tab1.PICKLIST_KEY icrggq_0, NULL icrggq_1, 0 icrggq_2
FROM tab1
WHERE dc_code = 942
AND tab1.pick_value = :p_pick_value;

There are hundereds of queries like this and we will not be able to modify all of them manually.
Is it possible to be done by plsql procedure or function ?
We are receving the multiple values through front end Oracle Forms screen.

Thanks
Gautam