Event Trigger not working with multiple selection and null value passed

Summary

Event Trigger not working with multiple selection and null value passed

Content

In bip report we using multiple selection and null value passed parameter type, for data model this parameter is working fine but for event trigger query the parameter with multiple selection option is causing the issue, it is not accepting the parameter.

The parameter join which we are using in our query are:

AND    (   ittv.transaction_type_name IN(:ptransactiontype)
        OR 'All' IN(   :ptransactiontype
                    || 'All'))
AND    (   imt.organization_id IN(:porganization)
        OR 'All' IN(   :porganization
                    || 'All'))
AND    (   imt.subinventory_code IN(:psubinventory)
        OR 'All' IN(   :psubinventory
                    || 'All'))