Issues in using wrapper for QP_PREQ_PUB.PRICE_REQUEST API in a select statement

Hi,

I am referring to PRICE_REQUEST_API_EXAMPLE.sql file and created a wrapper function on top of it to fetch the unit price for the passed parameters.

I need to call this wrapper function in select statement but it is not worked.

Call to wrapper function works in begin end block.

What should be the return type of variable for the function to return unit price.

Here is the script : It looks like the assignment to x_price variable does not work. Please help.

FUNCTION f_get_price(

      p_pricelist_id              IN  NUMBER,

      p_inventory_item_id    IN  NUMBER,