SQL & PL/SQL

Hi,

Could you let me know how to achieve below from the Concurrent program.

In the Procedure, I need to sort the Query by input parameter value.

Parameter Values

==============

p_sortorder : vendor_id,vendor_name

p_sortorder : vendor_name,segment1

p_sortorder : vendor_id,last_updated_by

===================================================

PROCEDURE build_97(p_errbuff   OUT VARCHAR2

                                      ,p_retcode OUT NUMBER

                                      ,p_sortorder IN VARCHAR2)

IS

CURSOR cur_query(p_sortorder IN VARCHAR2)

IS

  SELECT vendor_id,vendor_name,segment1,last_updated_by

  FROM ap_suppliers

  WHERE 1=1

  GROUP BY vendor_id,vendor_name,segment1,last_updated_by

  ORDER BY p_sortorder;

BEGIN

-- other code

FOR rec_supp IN cur_query (p_sortorder)

LOOP

  -----

END LOOP;

END;

Thanks

Aj