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

spool INITIALIZE_SYSCODE_CSH_TRANSACTION.log

set feedback off
set define off

<!--授信状态字段-->

BEGIN

sys_code_pkg.delete_sys_code('CREDIT_STATUS');
sys_code_pkg.insert_sys_code('CREDIT_STATUS', '授信状态', '授信状态', '授信状态', 'ZHS', '');
sys_code_pkg.insert_sys_code_value('CREDIT_STATUS','ENABLE','启用','ZHS','');
sys_code_pkg.insert_sys_code_value('CREDIT_STATUS','FREZZING','审批冻结','ZHS','');
sys_code_pkg.insert_sys_code_value('CREDIT_STATUS','DISABLE','停用','ZHS','');
sys_code_pkg.insert_sys_code_value('CREDIT_STATUS','REFUSE','审批拒绝','ZHS','');

END;
/
set feedback on
set define on


spool off

exit