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

spool INITIALIZE_SYSCODE_PAYMENT_FREQUENCY.log

set feedback off
set define off

begin
sys_code_pkg.delete_sys_code('PAYMENT_FREQUENCY');

sys_code_pkg.insert_sys_code('PAYMENT_FREQUENCY', '支付频率(回购)', '支付频率(回购)', '支付频率(回购)', 'ZHS', '');
sys_code_pkg.update_sys_code('PAYMENT_FREQUENCY', 'Payment_frequency', 'Payment_frequency', 'Payment_frequency', 'US', '');

sys_code_pkg.insert_sys_code_value('PAYMENT_FREQUENCY','MONTH','按月','ZHS','');
sys_code_pkg.update_sys_code_value('PAYMENT_FREQUENCY','MONTH','按月','US','');
sys_code_pkg.insert_sys_code_value('PAYMENT_FREQUENCY','IRREGULAR','不规则','ZHS','');
sys_code_pkg.update_sys_code_value('PAYMENT_FREQUENCY','IRREGULAR','不规则','US','');

end;
/
commit;
set feedback on
set define on


spool off

exit