Display Procedures Parameters expanding Types if any

//Display Procedure with arguments expanding the types within it

SELECT
argument_name,
in_out,
data_type,
data_length,
sequence,
default_value
FROM
user_arguments
WHERE
object_name = 'CREATE_MOVE_ORDER_LINES'
and
package_name ='INV_MOVE_ORDER_PUB'
order by sequence;

// Display only type names without expanding record types
SELECT
argument_name,
in_out,
data_type,
data_length,
sequence,
default_value
FROM
user_arguments
WHERE
object_name = 'CREATE_MOVE_ORDER_LINES'
and
package_name ='INV_MOVE_ORDER_PUB'
and data_level=0
order by sequence;

Note : data_level=0 - says that display only plain data types