INITIALIZE_SYSCODE_SEAL_NUMBER.sql 1.01 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
WHENEVER SQLERROR EXIT FAILURE ROLLBACK;
WHENEVER OSERROR  EXIT FAILURE ROLLBACK;

spool INITIALIZE_SYSCODE_SEAL_NUMBER.log

set feedback off
set define off

begin
sys_code_pkg.delete_sys_code('SEAL_NUMBER');

sys_code_pkg.insert_sys_code('SEAL_NUMBER', '文书部数', '文书部数', '文书部数', 'ZHS', '');
sys_code_pkg.update_sys_code('SEAL_NUMBER', 'Seal Number', 'Seal Number', 'Seal Number', 'US', '');

sys_code_pkg.insert_sys_code_value('SEAL_NUMBER','SEAL_O_TW_NUMBER','一式两份','ZHS','');
sys_code_pkg.update_sys_code_value('SEAL_NUMBER','SEAL_O_TW_NUMBER','一式两份','US','');
17 18 19

sys_code_pkg.insert_sys_code_value('SEAL_NUMBER','SEAL_O_TH_NUMBER','一式三份','ZHS','');
sys_code_pkg.update_sys_code_value('SEAL_NUMBER','SEAL_O_TH_NUMBER','一式三份','US','');
20

21 22 23
sys_code_pkg.insert_sys_code_value('SEAL_NUMBER','SEAL_O_F_NUMBER','一式四份','ZHS','');
sys_code_pkg.update_sys_code_value('SEAL_NUMBER','SEAL_O_F_NUMBER','一式四份','US','');

24 25 26 27 28 29 30 31 32 33
end;
/
commit;
set feedback on
set define on


spool off

exit