----------Script: TRAVEL_5.6.0.004_4_S_API_PRIVILEGE_GENERATOR.sql

create or replace PROCEDURE API_PRIVILEGE_GENERATOR(code IN varchar2, module IN varchar2 )
IS
    v_query varchar2(4000);
BEGIN
    v_query:= 'INSERT INTO CMT_SYSTEM_PRIVILEGES (SPR_ID, SPR_CODE, SPR_NAME, SPR_ORDER, SPR_DESCRIPTION, SPR_MODULE)';
    v_query:= v_query || ' VALUES(CMS_SPR_ID.nextval,';
    v_query:= v_query || ' ''' || code || ''', ''' || code || ''',';
    v_query:= v_query || ' (select COALESCE(max(SPR_ORDER), 0) from CMT_SYSTEM_PRIVILEGES WHERE SPR_AUDIT_RD IS NULL AND SPR_PRG_ID IS NULL) + 1, ';
    v_query:= v_query || ' ''' || code || ''', ''' || module || ''')';
    EXECUTE IMMEDIATE v_query;
    COMMIT;
END;
/
----------Script end: TRAVEL_5.6.0.004_4_S_API_PRIVILEGE_GENERATOR.sql

----------Script: TRAVEL_5.6.0.005_0_S_CMT_SYSTEM_PRIVILEGES.sql

ALTER TABLE CMT_SYSTEM_PRIVILEGES DROP COLUMN spr_order;

----------Script end: TRAVEL_5.6.0.005_0_S_CMT_SYSTEM_PRIVILEGES.sql