INITIALIZE_SYSCODE_CLAIM_STATUS.sql

WHENEVER SQLERROR EXIT FAILURE ROLLBACK;
WHENEVER OSERROR  EXIT FAILURE ROLLBACK;

spool INITIALIZE_SYSCODE_CLAIM_STATUS.log

set feedback off
set define off

begin
    sys_code_pkg.delete_sys_code('claim_status');
    sys_code_pkg.insert_sys_code('claim_status','认领状态','认领状态','认领状态','ZHS','');
    sys_code_pkg.insert_sys_code_value('claim_status','UNCLAIMED','未认领','ZHS');
    sys_code_pkg.insert_sys_code_value('claim_status','CLAIMING','认领中','ZHS');
    sys_code_pkg.insert_sys_code_value('claim_status','CONFIRMED','已确认','ZHS');
    sys_code_pkg.insert_sys_code_value('claim_status','RETURN','认领退回','ZHS');
end;
/
commit;
set feedback on
set define on


spool off

exit