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('CONFIRMED_FLAG'); sys_code_pkg.insert_sys_code('CONFIRMED_FLAG', '单据状态', '单据状态', '单据状态', 'ZHS', ''); sys_code_pkg.insert_sys_code_value('CONFIRMED_FLAG','NEW','未提交','ZHS',''); sys_code_pkg.insert_sys_code_value('CONFIRMED_FLAG','APPROVED','新增确认','ZHS',''); sys_code_pkg.insert_sys_code_value('CONFIRMED_FLAG','REJECTED','新增退回','ZHS',''); sys_code_pkg.insert_sys_code_value('CONFIRMED_FLAG','ACCAUDITING','会计新增确认中','ZHS',''); sys_code_pkg.insert_sys_code_value('CONFIRMED_FLAG','CANCELLED','已作废','ZHS',''); sys_code_pkg.insert_sys_code_value('CONFIRMED_FLAG','DEBTAUDITING','债权新增确认中','ZHS',''); sys_code_pkg.delete_sys_code('PAID_BYOTHER_FLAG'); sys_code_pkg.insert_sys_code('PAID_BYOTHER_FLAG', '代付', '代付', '代付', 'ZHS', ''); sys_code_pkg.insert_sys_code_value('PAID_BYOTHER_FLAG','T','是','ZHS',''); sys_code_pkg.insert_sys_code_value('PAID_BYOTHER_FLAG','F','否','ZHS',''); sys_code_pkg.delete_sys_code('WRITE_OFF_FLAG'); sys_code_pkg.insert_sys_code('WRITE_OFF_FLAG', '核销状态', '核销状态', '核销状态', 'ZHS', ''); sys_code_pkg.insert_sys_code_value('WRITE_OFF_FLAG','NOT','未核销','ZHS',''); sys_code_pkg.insert_sys_code_value('WRITE_OFF_FLAG','FULL','全部核销','ZHS',''); sys_code_pkg.insert_sys_code_value('WRITE_OFF_FLAG','DEPOSIT','保证金','ZHS',''); sys_code_pkg.insert_sys_code_value('WRITE_OFF_FLAG','ADVRECEIVED','预收款','ZHS',''); sys_code_pkg.insert_sys_code_value('WRITE_OFF_FLAG','DISABLED','不可用','ZHS',''); end; / commit; set feedback on set define on spool off exit