INITIALIZE_CSH_TRANSACTION_PROMPT.sql 11.1 KB
Newer Older
1 2 3 4 5 6 7 8
WHENEVER SQLERROR EXIT FAILURE ROLLBACK;
WHENEVER OSERROR  EXIT FAILURE ROLLBACK;

spool CSH_TRANSACTION_PROMPT.log

set feedback off
set define off
begin
9 10 11 12
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH511.CSH_TRANSACTION.RETURNED_AMOUNT',
                                  p_language => 'ZHS',
                                  p_description => '已退款金额',
                                  p_created_by => 1);
13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.TRANSACTION_AMOUNT_FROM',
                                  p_language => 'ZHS',
                                  p_description => '收款金额从',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.TRANSACTION_AMOUNT_TO',
                                  p_language => 'ZHS',
                                  p_description => '收款金额到',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.MY_ACCOUNT_NAME',
                                  p_language => 'ZHS',
                                  p_description => '我方账户户名',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.MY_BANK_NAME',
                                  p_language => 'ZHS',
                                  p_description => '我方银行名称',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.MY_ACCOUNT_USERNAME',
                                  p_language => 'ZHS',
                                  p_description => '我方账户账号',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.BANK_CASH_CODE',
                                  p_language => 'ZHS',
                                  p_description => '银行流水号',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.YOUR_ACCOUNT_NAME',
                                  p_language => 'ZHS',
                                  p_description => '对方账户户名',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.YOUR_BANK_NAME',
                                  p_language => 'ZHS',
                                  p_description => '对方银行名称',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.YOUR_ACCOUNT_USERNAME',
                                  p_language => 'ZHS',
                                  p_description => '对方账户账号',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.BUSINESS_PARTNER',
                                  p_language => 'ZHS',
                                  p_description => '商业伙伴',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.BILL_STATUS',
                                  p_language => 'ZHS',
                                  p_description => '单据状态',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.WRITTEN_OFF_STATUS',
                                  p_language => 'ZHS',
                                  p_description => '核销状态',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.PURPOSE_OF_FUNDS',
                                  p_language => 'ZHS',
                                  p_description => '款项用途',
                                  p_created_by => 1);
  sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.RECEIVE_MONEY_IMPORT_BTN',
                                  p_language => 'ZHS',
                                  p_description => '收款导入',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.MONEY_HAND_ADD_BTN',
                                  p_language => 'ZHS',
                                  p_description => '收款手动新增',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.APPLY_NEW_BTN',
                                  p_language => 'ZHS',
                                  p_description => '新增申请',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.DROP_BTN',
                                  p_language => 'ZHS',
                                  p_description => '作废',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'HLS.DOCUMENT_CONFIRMED_BY',
                                  p_language => 'ZHS',
                                  p_description => '确认人',
                                  p_created_by => 1);
85 86 87 88
 sys_message_pkg.delete_message('E_NO_THIS_ACCOUNT');
  sys_message_pkg.insert_message('E_NO_THIS_ACCOUNT',
                                 '错误',
                                 '我方没有此银行账号!','ZHS');
89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.CSH_TRANSACTION_NUM',
                                  p_language => 'ZHS',
                                  p_description => '现金事务编号',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.RECEIPT_TYPE',
                                  p_language => 'ZHS',
                                  p_description => '收款类型',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.RECEIPT_AMOUNT',
                                  p_language => 'ZHS',
                                  p_description => '收款金额',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.RETURN_AMOUNT',
                                  p_language => 'ZHS',
                                  p_description => '退款金额',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.USEFUL_AMOUNT',
                                  p_language => 'ZHS',
                                  p_description => '可用金额',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.DESCRIPTION',
                                  p_language => 'ZHS',
                                  p_description => '摘要',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.MY_ACCOUNT',
                                  p_language => 'ZHS',
                                  p_description => '我方账户',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.YOUR_ACCOUNT',
                                  p_language => 'ZHS',
                                  p_description => '对方账户',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.ACCOUNT_NAME',
                                  p_language => 'ZHS',
                                  p_description => '户名',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.ACCOUNT_BANK',
                                  p_language => 'ZHS',
                                  p_description => '银行',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.ACCOUNT_NUM',
                                  p_language => 'ZHS',
                                  p_description => '账号',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.DEPT_CONFIRMER',
                                  p_language => 'ZHS',
                                  p_description => '债权确认人',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.ACCT_CONFIRMER',
                                  p_language => 'ZHS',
                                  p_description => '会计确认人',
                                  p_created_by => 1);
141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH509.CSH_RECEIPT_CONFIRM.NEW_APPLY_BTN',
                                  p_language => 'ZHS',
                                  p_description => '新增确认',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH509.CSH_RECEIPT_CONFIRM.REFUSE_BTN',
                                  p_language => 'ZHS',
                                  p_description => '新增驳回',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH509.CSH_RECEIPT_CONFIRM.DROP_BTN',
                                  p_language => 'ZHS',
                                  p_description => '作废',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH509.CSH_RECEIPT_CONFIRM.QUERY_BTN',
                                  p_language => 'ZHS',
                                  p_description => '查询',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH511.CSH_TRANSACTION.MANUAL_ADD',
                                  p_language => 'ZHS',
                                  p_description => '收款手动新增',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH511.CSH_TRANSACTION.CLASS_DESC',
                                  p_language => 'ZHS',
                                  p_description => '款项分类',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH511.CSH_TRANSACTION.STATEMENT',
                                  p_language => 'ZHS',
                                  p_description => '备注',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH511.CSH_TRANSACTION.BANK_INFO',
                                  p_language => 'ZHS',
                                  p_description => '账户信息',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH511.CSH_TRANSACTION.ATTACHMENT',
                                  p_language => 'ZHS',
                                  p_description => '附件',
                                  p_created_by => 1);

178 179 180 181 182 183 184 185 186
end;
/
commit;
set feedback on
set define on

spool off

exit