pkg_a_基金征集.sql

oracle后台加密办法

130 a 0
fa 9 0
120 a 0
10f 1 a
d0 8 0
86 5 0
64 4 0
3e 3 0
4e 3 0
2 0 1
e8 8 0
14 2 0
52 3 0
18 2 0
ae 7 0
c8 8 0
32 3 0
4 2 0
118 a 0
cc 8 0
3a 3 0
c 2 0
36 3 0
12c a 0
11c a 0
e0 8 0
b6 7 0
74 4 0
128 a 0
d8 8 0
6c 4 0
63 1 4
110 a 0
1c 2 0
142 b 0
d4 8 0
9c 6 0
8a 5 0
68 4 0
46 3 0
20 2 0
85 1 5
8 2 0
10 2 0
fe 9 0
146 b 0
0

/
create or replace package body PKG_A_基金征集 wrapped 
0
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
3
b
9200000
1
4
0 
1af
2 :e:
1PACKAGE:
1BODY:
1PKG_A_基金征集:
1TYPE:
1TYP_REC_AB01:
1RECORD:
1AAE002:
1AB01:
1AAB019:
1AAB020:
1AAB021:
1AAB022:
1AAB024:
1AAB025:
1AAB026:
1AAE011:
1TYP_TAB_AB08:
1AB08:
1ROWTYPE:
1BINARY_INTEGER:
1TYP_TAB_AB09:
1AB09:
1TYP_TAB_AB10:
1AB10:
1GV_REC_AB01:
1GV_TAB_AB08:
1GV_TAB_AB09:
1GV_TAB_AB10:
1PRC_A_CONSTRUCTOR:
1LREC_AB01:
1DELETE:
1PRC_A_根据基金科目置流水号:
1PRM_单位编号:
1VARCHAR2:
1PRM_基金科目:
1PRM_结算期:
1PRM_对应结算期:
1PRM_批次号:
1NUMBER:
1PRM_基金来源:
1PRM_缴费类型:
1PRM_征集通知流水号:
1PRM_APPCODE:
1OUT:
1PRM_ERRORMSG:
1PKG_A_MACRO:
1DEF_OK:
1AAE063:
1AAB001:
1=:
1AAA060:
1AAE003:
1BAB221:
1AAE143:
1BAA082:
1AAB166:
10:
1IS NULL:
1NO_DATA_FOUND:
1DEF_WARNING:
1没有找到符合条件的未征集信息!:
1OTHERS:
1DEF_ERR:
1按照基金科目预置AB08中的征集通知流水号失败！：:
1||:
1SQLERRM:
1PRC_A_根据险种置征集通知流水号:
1PRM_个人编号:
1PRM_征集通知类型:
1PRM_险种类型:
1PRM_统一征集标志:
1PRM_统一征集类型:
12:
11:
1AAB033:
1AAE140:
1SUBSTR:
1AAC001:
1!=:
1NOTFOUND:
1单位编号为:
1RETURN:
1PRC_A_取消基金征集:
1按照险种类型预置AB08中的征集通知流水号失败！：:
1PRC_A_取单位基本信息:
1CURSOR:
1CUR_AB01:
1AV_DEPTCODE:
1LV_DEPTCODE:
1AC01:
1OPEN:
1CLOSE:
1没有找到符合单位：:
1条件的单位基本信息!:
1ISOPEN:
1取单位基本信息失败！错误原因：!:
1PRC_A_修改欠缴信息征集通知标志:
1修改单位欠缴信息中的征集通知标志失败！：:
1PRC_A_保存征集通知明细信息:
1I:
1COUNT:
1LOOP:
1AAB170:
1+:
1NVL:
1BAA063:
1DUAL:
1保存征集通知明细信息系统错误,错误代码:: :
1PRC_A_保存征集通知单据信息:
1AAB180:
1AAB031:
1AAE111:
1AAE036:
1BAB201:
1BAB203:
1BAB204:
1BAE011:
1BAE036:
1保存征集通知单据信息ab10失败！：:
1PRC_A_基金征集处理:
1PRM_征集批次号:
1PRM_合单标志:
1PRM_经办人:
1CUR_AB08:
1AV_征集通知类型:
1AN_征集通知流水号:
1N_行号:
16:
1N_存在标志:
1REC_AB08:
1没有检索到符合:::
1 征集通知类型:::
1 征集通知流水号:::
1 的应征信息!:
1J:
1AAB156:
1-:
1AAB210:
1EXIT:
1BAC201:
15:
1:
1K:
1SYSDATE:
1DEF_FALSE:
1基金征集失败！：:
1PRC_A_基金征集不对应欠款:
1PRM_险种串:
1PRM_金额串:
1LN_ARRAYCOUNT:
1ARRAY_AAE140:
1PKG_A_COMM:
1TYP_TAB_STR:
1ARRAY_JE:
1LN_ZJE:
112:
1FUN_A_STRINGTOARRARY:
1,:
18:
1N_数量:
1AB13:
1>:
1该征集通知单已经到帐,不能取消基金征集！：:
1取消基金征集,修改单位欠缴信息中的征集通知标志失败！：:
1取消基金征集,清除征集通知明细信息失败！：:
1取消基金征集,清除征集通知单据信息失败！：:
1取消基金征集失败！：:
1PRC_A_置打印标志:
1置打印标志失败！：:
1PRC_A_批量基金征集处理:
1PRM_流水号:
1CUR_T_GGYWSTR:
1AV_流水号:
1T_GGYWSTR:
1SEQ:
118:
1LA_SEQ:
1ARRAY2:
1LN_ARRAYYCOUNT:
1LV_FLAG:
13:
1LL_TMP:
19:
1T_ERRORLOG:
12401:
1999:
1批量处理业务中:
1COMMIT:
1REC_GGYWSTR:
1STR:
1ROLLBACK:
1ROLLBACK_NR:
1插入错误失败：:
1NEXT1:
14:
17:
1APPCODE:
1批量基金征集失败！：:
1PRC_A_征缴数据固化:
1PRM_FLAG:
1PRM_AAE002:
1CUR_DW_6:
1AV_AAE002:
1AAB004:
1SUM:
1AAC008:
101:
121101:
111101:
1AAB120:
121:
111:
1ZJ:
1DECODE:
102:
103:
1/:
1TJ:
122:
1DJ:
131:
141:
1GJ:
1MAX:
1AAB083:
1ZR:
131201:
1TR:
1GZR:
1GTR:
1LJQF:
1AB17:
1AAB240:
1DZJJ:
1GTDZJJ:
1BS:
1BJ:
1CE:
106:
1TS:
104:
105:
113:
114:
1QT:
1JFBL:
1HXJE:
1(+):
1rule :
1CUR_DW_3:
1QF:
1<:
1CUR_AB17:
1AV_AAB001:
1AV_AAE140:
1CUR_DW_5:
191:
1CUR_DW_10:
1AV_BAB221:
1AV_BAB221_PRE:
1STR_AAB001:
1STR_AAE140:
109:
110:
1>=:
1CUR_QKBJ:
1AAC123:
1AC13:
1AAE114:
1TYP_REC_SAVE:
1TYP_REC_QK:
1TYP_TAB_SAVE:
1TYP_TAB_QK:
1LV_TAB_SAVE:
1LV_TAB_QK:
1LS_AAE002:
1LS_AAE002_PRE:
1LN_BL:
1LN_ROW:
1LN_ROW_QK:
1LN_BAB221:
1LN_BAB221_PRE:
1N_LJQF:
1N_DZJJ:
1REC_DW_3:
1REC_DW_6:
151:
1TO_CHAR:
1ROUND:
1*:
1100:
1%:
1.:
1TO_NUMBER:
1010000000000:
1REC_DW_10:
1REC_QKBJ:
1REC_DW_5:
1EXISTS:
1REC_AB17:
1T_ROOT_FEEAUDIT_Q_AB08:
1ZZJFRS:
1LTXJFRS:
1ZZJFJS:
1LTXJFJS:
1YJJEGR:
1YJJEDW:
1QFLJ:
1TZJE:
1QTJE:
1固化数据失败！：:
1PRC_A_银行信息:
1PRM_银行行号:
1PRM_银行名称:
1PRM_银行性质:
1PRM_联网标志:
1PRM_地址:
1PRM_邮政编码:
1PRM_联系人姓名:
1PRM_联系电话:
1STRING:
1AB52:
1AAE008:
1AAB340:
1BAB008:
1BAB009:
1AAE006:
1AAE007:
1AAE004:
1AAE005:
1保存数据失败！：:
1PRC_A_银行托收打印:
1PRM_SEQ:
1PRM_AAE140S:
1CUR_DW_2:
1AV_SEQ:
1T_YHTS_MX:
1AV_AAE063:
1index:
1A:
1B:
1C:
1D:
1E:
1CUR_DW_13:
1T_YHTS_PRINT:
1LN_COUNT:
1LA_AAE140:
1LS_AAE010:
140:
1LS_AAB340:
150:
1LS_AAE008:
1LS_AAB300:
1LS_MARK:
1LI_SUMACCOUNT:
1LI_AAB025:
1LI_AAE063:
1LI_AAB026:
1LI_AAB340:
1TYP_TAB_YHTS_PRINT:
1LTAB_YHTS_PRINT:
1SUMACCOUNT:
1REC_DW_2:
1AAE010:
1AAB300:
1AB56:
1DWJN_YANG:
1GRJN_YANG:
1BJ_YANG:
1ZNJ_YANG:
1HJ_YANG:
1DWJN_SHI:
1GRJN_SHI:
1BJ_SHI:
1ZNJ_SHI:
1HJ_SHI:
1DWJN_YI:
1GRJN_YI:
1BJ_YI:
1ZNJ_YI:
1HJ_YI:
1DWJN_GONG:
1GRJN_GONG:
1BJ_GONG:
1ZNJ_GONG:
1HJ_GONG:
1DWJN_SHENG:
1GRJN_SHENG:
1BJ_SHENG:
1ZNJ_SHENG:
1HJ_SHENG:
1CASE_NOT_FOUND:
1QC_1:
1ZHHDZ_1:
1KHYH_1:
1HH:
132:
1BZ:
1公务员补助:
1:::
1ELSIF:
133:
1大病救助:
1QC:
1NO:
1ZHHDZ:
1KHYH:
1WSJE:
1WTRQ_Y:
1yyyy:
1WTRQ_M:
1mm:
1WTRQ_D:
1dd:
1LENGTH:
1 :
1F:
1Y:
1S:
1Q:
1W:
1SW:
1BW:
1QW:
1LI_I:
1AAE140_5:
1AAE140_4:
1AAE140_3:
1AAE140_2:
1AAE140_1:
0

0
0
2ac9
2
0 :2 a0 97 a0 9d a0 a3 :2 a0
6b :2 a0 f 1c b0 81 a3 :2 a0
6b :2 a0 f 1c b0 81 a3 :2 a0
6b :2 a0 f 1c b0 81 a3 :2 a0
6b :2 a0 f 1c b0 81 a3 :2 a0
6b :2 a0 f 1c b0 81 a3 :2 a0
6b :2 a0 f 1c b0 81 a3 :2 a0
6b :2 a0 f 1c b0 81 a3 :2 a0
6b :2 a0 f 1c b0 81 a3 :2 a0
6b :2 a0 f 1c b0 81 60 77
a0 9d :2 a0 f 1c a0 1c 40
a8 c 77 a0 9d :2 a0 f 1c
a0 1c 40 a8 c 77 a0 9d
:2 a0 f 1c a0 1c 40 a8 c
77 a3 a0 1c 81 b0 a3 a0
1c 81 b0 a3 a0 1c 81 b0
a3 a0 1c 81 b0 9a b4 55
6a a3 a0 1c 81 b0 :2 a0 d
:2 a0 6b 57 b3 :2 a0 6b 57 b3
:2 a0 6b 57 b3 b7 a4 b1 11
68 4f 9a 8f a0 b0 3d 8f
a0 b0 3d 8f a0 b0 3d 8f
a0 b0 3d 8f a0 b0 3d 8f
a0 b0 3d 8f a0 b0 3d 8f
a0 b0 3d 96 :2 a0 b0 54 96
:2 a0 b0 54 b4 55 6a :3 a0 6b
d :3 a0 e7 :2 a0 7e b4 2e :2 a0