El error es porque le pones la variable "l_param_name" a todo
p_parm_name => l_param_names, p_parm_value => l_param_names,