CREATE OR REPLACE procedure sort_proc IS

TYPE cur_typ IS REF CURSOR;
c                  cur_typ;
v_sqlquery         varchar2(1400);
v_entity_name      varchar2(400);
v_sql_sort         varchar2(1400);
g_errm             varchar2(400);
cnt                number(6);
cursor c1 is 
select * from parm_search order by priority,entity_name;

BEGIN
EXECUTE IMMEDIATE 'truncate table demand_out';
----------------
cnt:=0;
   for r_c1 in  c1 loop
   begin
     cnt:=cnt+1;
     EXECUTE IMMEDIATE 'truncate table temp_sort';
     EXECUTE IMMEDIATE 'insert into temp_sort select  * from demand where ' || r_c1.MAP_DEMND || '=:PLAN_UNIT_CODE'
               USING r_c1.entity_name;
             commit;
     EXECUTE IMMEDIATE 'DELETE FROM demand WHERE ' || r_c1.MAP_DEMND || '=:PLAN_UNIT_CODE'
               USING r_c1.entity_name;
              commit;
     
-------------- here  DEMAND_OUT_SEQ.NEXTVAL  doesnot  work and throws error
 
EXECUTE IMMEDIATE'insert into demand_out select  DEMAND_OUT_SEQ.NEXTVAL  as sort_ordr ,PLN_DMND_NAME ||''~''||PLN_CAT 
||''~''||DMND_SHIP_NAME ||''~''||DUE_DATE 
||''~''||ADJ_DUE_DATE_TIME||''~''||DMND_LINE_ITEM_NAME 
||''~''||REQ_ITEM||''~''||REQ_QTY||''~''||DC ||''~''||
       BA_LIMIT||''~''||BL_LIMIT ||''~''||SORT_KEY||''~''||CUST_NO 
||''~''||DOMN_NAME||''~''||SEQ_CTR||''~''||STYLE_COLOR
as text,'''||cnt||'_FILE_NM_'|| r_c1.MAP_DEMND ||
''' from temp_sort order by '|| r_c1.srt_order1||','||r_c1.srt_order2||','||r_c1.srt_order3||
','||r_c1.srt_order4||','||r_c1.srt_order5||','||r_c1.srt_order6
||','||r_c1.srt_order7;

commit;
     exception
           WHEN OTHERS THEN
           g_errm := SUBSTR(SQLERRM, 1 , 64); 
          dbms_output.put_line(  g_errm ||r_c1.entity_name);  
  
            
      end;            
    end loop;

-------------- here  DEMAND_OUT_SEQ.NEXTVAL  works fine 

insert into demand_out select  DEMAND_OUT_SEQ.NEXTVAL  as sort_ordr ,PLN_DMND_NAME ||'~'||PLN_CAT ||'~'||
DMND_SHIP_NAME ||'~'||DUE_DATE ||'~'||ADJ_DUE_DATE_TIME||'~'||DMND_LINE_ITEM_NAME ||'~'||
REQ_ITEM||'~'||REQ_QTY||'~'||DC ||'~'||
       BA_LIMIT||'~'||BL_LIMIT ||'~'||SORT_KEY||'~'||
CUST_NO ||'~'||DOMN_NAME||'~'||SEQ_CTR||'~'||STYLE_COLOR  as text,'999_file_nm_demand'
        from demand;
commit;
EXECUTE IMMEDIATE 'truncate table demand';


 
END;
/
show errors

ORA-02287: sequence number not allowed hereARJ
ORA-02287: sequence number not allowed hereDPA
ORA-02287: sequence number not allowed hereF02
ORA-02287: sequence number not allowed hereFG2
ORA-02287: sequence number not allowed hereIPA
ORA-02287: sequence number not allowed hereIPC
ORA-02287: sequence number not allowed here050
ORA-02287: sequence number not allowed here390
ORA-02287: sequence number not allowed here15
ORA-02287: sequence number not allowed hereC6
ORA-02287: sequence number not allowed hereF4
ORA-02287: sequence number not allowed hereFC
ORA-02287: sequence number not allowed here01
ORA-02287: sequence number not allowed here02
ORA-02287: sequence number not allowed here04
ORA-02287: sequence number not allowed here05
ORA-02287: sequence number not allowed here17
ORA-02287: sequence number not allowed here20
ORA-02287: sequence number not allowed here47
ORA-02287: sequence number not allowed here53
ORA-02287: sequence number not allowed here54
ORA-02287: sequence number not allowed here64
ORA-02287: sequence number not allowed here5
ORA-02287: sequence number not allowed hereD
ORA-02287: sequence number not allowed hereL
ORA-02287: sequence number not allowed hereN

PL/SQL procedure successfully completed

SQL>