CREATE OR REPLACE PROCEDURE test(
				v_repaircur OUT myVars.CommonCurTyp
                      			)
IS
BEGIN
     OPEN v_repaircur FOR
	SELECT (*variable_here*).ordernum FROM repair_detail;    
END;
/

CREATE OR REPLACE PROCEDURE jtest(
				v_repaircur OUT myVars.CommonCurTyp,
                                v_flag      IN  char
                    			)
IS
begin
declare 
	v_name varchar2(20); 
	BEGIN
  	if v_flag='O' then
  	   v_name:='ordernum';
  	else
  	   v_name:='partnum';
  	end if;
        OPEN v_repaircur FOR ('SELECT ' ||  v_name || ' FROM TO_BE_SHIPPED');    
        END;
END jtest;
/

CREATE OR REPLACE PROCEDURE jtest(
				v_repaircur OUT myVars.CommonCurTyp,
                                v_flag      IN  char
                    			)
IS
begin
declare 
	v_name varchar2(20); 
	BEGIN
  	if v_flag='O' then
  	    OPEN v_repaircur FOR SELECT ordernum FROM TO_BE_SHIPPED; 
  	else
  	    OPEN v_repaircur FOR SELECT partnum FROM TO_BE_SHIPPED; 
  	end if;  
        END;
END jtest;
/