INITIALIZE_SYSCODE_CREDIT_STATUS.sql 739 Bytes
Newer Older
stone's avatar
stone committed
1 2 3 4 5 6 7 8
WHENEVER SQLERROR EXIT FAILURE ROLLBACK;
WHENEVER OSERROR  EXIT FAILURE ROLLBACK;

spool INITIALIZE_SYSCODE_CSH_TRANSACTION.log

set feedback off
set define off

9
<!--授信状态字段-->
stone's avatar
stone committed
10

stone's avatar
stone committed
11
BEGIN
stone's avatar
stone committed
12

stone's avatar
stone committed
13 14 15 16 17
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','');
stone's avatar
stone committed
18
sys_code_pkg.insert_sys_code_value('CREDIT_STATUS','REFUSE','审批拒绝','ZHS','');
stone's avatar
stone committed
19 20 21 22 23 24 25 26 27 28

END;
/
set feedback on
set define on


spool off

exit