FACE |
109 |
8.467 |
2001 |
select count(*) |
|
|
|
|
|
|
|
|
|
|
|
UA_DOC |
251 |
2.469 |
8004 |
if
self.checkRangeLen(p_value=>v_payer_account,minLen=>1,maxLen=>14,fieldName=>'Payer
Account', required=>true) and |
|
UA_LCY_DOC |
211 |
1.543 |
4002 |
setPaymentOrderNumber ; |
|
UA_DOC |
264 |
1.534 |
6003 |
if
self.checkRangeLen(p_value=>v_amount,minLen=>1,maxLen=>16,fieldName=>'Amount',
required=>true) and |
|
UA_LCY_DOC |
352 |
1.523 |
2001 |
RETURN; |
|
UA_LCY_DOC |
217 |
1.506 |
4002 |
setPayerBankCode ; |
|
UA_LCY_DOC |
224 |
1.464 |
4002 |
setBenBankCode; |
|
UA_LCY_DOC |
221 |
1.392 |
4002 |
setBenCompanyCode; |
|
UA_LCY_DOC |
214 |
1.381 |
4002 |
setPayerCode ; |
|
UA_LCY_DOC |
226 |
1.352 |
4002 |
setBenAccount; |
|
UA_LCY_DOC |
213 |
1.348 |
4002 |
setValueDate ; |
|
UA_LCY_DOC |
241 |
1.334 |
4002 |
validateBenAccountAndBae; |
|
UA_LCY_DOC |
216 |
1.333 |
4002 |
setCountryCode ; |
|
UA_LCY_DOC |
229 |
1.331 |
4002 |
setUniquePaymentId; |
|
UA_LCY_DOC |
215 |
1.329 |
4002 |
setCustomerName ; |
|
UA_LCY_DOC |
237 |
1.323 |
4002 |
validateDates; |
|
UA_LCY_DOC |
228 |
1.323 |
4002 |
setDetails; |
|
UA_LCY_DOC |
222 |
1.322 |
4002 |
setBenName; |
|
UA_LCY_DOC |
223 |
1.319 |
4002 |
setBenCountryCode; |
|
UA_LCY_DOC |
246 |
1.304 |
4002 |
validateBenCodeAndCountry; |
|
UA_LCY_DOC |
245 |
1.291 |
4002 |
validatePayerCodeAndCountry; |
|
UA_LCY_DOC |
230 |
1.208 |
4002 |
setUserKeyId1; |
|
UA_LCY_DOC |
231 |
1.183 |
4002 |
setKeySign1; |
|
UA_LCY_DOC |
233 |
1.178 |
4002 |
setKeySign2; |
|
UA_LCY_DOC |
232 |
1.164 |
4002 |
setUserKeyId2; |
|
UA_LCY_DOC |
235 |
1.08 |
4002 |
self.validatePaymentOrderNumber; |
|
UA_LCY_DOC |
255 |
0.973 |
4002 |
self.setDerivedData; |
|
UA_LCY_DOC |
250 |
0.929 |
4002 |
self.validateAccountAgainstCustomer; |
|
UA_DOC |
44 |
0.789 |
32016 |
end; |
|
FACE |
493 |
0.787 |
4002 |
select acc_cust_id into v_cust_id
from accounts where acc_acct_no=p_acc_no; |
|
UA_DOC |
274 |
0.783 |
4002 |
BenBankName:=substr(self.extract,1,70); |
|
UA_DOC |
301 |
0.78 |
4002 |
if not
self.checkBaeAndAccount(PayerBankCode, PayerAccount, 'Payer') then |
|
UA_DOC |
235 |
0.777 |
4002 |
DocDate:=self.convertDate(v_doc_date,'Document
Date'); |
|
UA_LCY_DOC |
218 |
0.774 |
4002 |
self.setPayerBankName ; |
|
UA_DOC |
234 |
0.773 |
4002 |
if
self.checkRangeLen(p_value=>v_doc_date,minLen=>10,maxLen=>10,fieldName=>'Document
Date', required=>true) then |
|
UA_DOC |
250 |
0.767 |
4002 |
v_payer_account:=self.extract; |
|
UA_DOC |
263 |
0.76 |
4002 |
v_amount:=self.extract; |
|
UA_DOC |
233 |
0.745 |
4002 |
v_doc_date:=self.extract; |
|
PROCESS_UPLOADEDFILE_UA |
89 |
0.738 |
84042 |
p_doc.setNextValue(v_token); |
|
UA_LCY_DOC |
227 |
0.737 |
4002 |
self.setAmountInWords; |
|
UA_LCY_DOC |
225 |
0.736 |
4002 |
self.setBenBankName; |
|
UA_LCY_DOC |
220 |
0.729 |
4002 |
self.setAmount ; |
|
UA_LCY_DOC |
240 |
0.722 |
4002 |
self.validatePayerAccountAndBae; |
|
UA_LCY_DOC |
219 |
0.708 |
4002 |
self.setPayerAccount ; |
|
UA_LCY_DOC |
212 |
0.696 |
4002 |
self.setDocDate ; |
|
FACE |
222 |
0.653 |
4002 |
select BANK_NAME_EN into lbank_name |
|
UA_DOC |
18 |
0.572 |
34017 |
return
substr(trim(process_uploadedfile_ua.FIELDS_WORK(indExtr)),1,1024); |
|
UA_LCY_DOC |
200 |
0.313 |
4002 |
end ; |
|
PROCESS_UPLOADEDFILE_UA |
57 |
0.295 |
44022 |
v_next_offset :=
instr(p_line,chr(9),offset,1); |
|
UA_DOC |
132 |
0.295 |
2001 |
fetch c_startup_bae into v_dumb; |
|
UA_DOC |
127 |
0.271 |
4002 |
cursor c_startup_bae(v_bae varchar2)
is select t.st_bae from startup_bae t where t.st_bae=v_bae; |
|
PROCESS_UPLOADEDFILE_UA |
44 |
0.27 |
46024 |
end; |
|
UA_DOC |
148 |
0.258 |
4002 |
cursor c_account (v_account_no
varchar2) is select t.acc_acct_no
from accounts t where t.acc_acct_no=v_account_no and t.acc_status=2; |
UA_DOC |
75 |
0.232 |
46023 |
end; |
|
UA_DOC |
20 |
0.218 |
38019 |
end; |
|
SS_CONTROLS |
85 |
0.213 |
43355 |
v_result :=
to_number(substr(v_account,i,1))*to_number(substr(v_weights,i+5,1)); |
|
UA_DOC |
9 |
0.188 |
76038 |
end; |
|
PROCESS_UPLOADEDFILE_UA |
72 |
0.161 |
46024 |
end; |
|
UA_DOC |
14 |
0.159 |
34017 |
indExtr:=indExtr+1; |
|
UA_DOC |
153 |
0.157 |
2001 |
fetch c_account into v_dump; |
|
UA_LCY_DOC |
78 |
0.153 |
8004 |
if
self.checkRangeLen(p_value=>v_cust_bae,minLen=>6,maxLen=>6,fieldName=>'Payer
Bank Code', required=>true) and |
|
UA_LCY_DOC |
97 |
0.144 |
8004 |
if
self.checkRangeLen(p_value=>v_ben_cust_cod,minLen=>0,maxLen=>10,fieldName=>'Beneficiary
Company Id', required=>false) and |
UA_LCY_DOC |
40 |
0.142 |
8004 |
if |
|
SS_CONTROLS |
142 |
0.13 |
8004 |
END ua_check_account; |
|
SS_CONTROLS |
176 |
0.113 |
23345 |
v_sum := v_sum +
(to_number(substr(v_code,i+1,1))*v_weights(i)); |
|
PROCESS_UPLOADEDFILE_UA |
68 |
0.109 |
40020 |
v_result:=substr(p_line,offset,v_ammount); |
|
UA_LCY_DOC |
134 |
0.106 |
6003 |
if
self.checkRangeLen(p_value=>v_ben_bank_code,minLen=>6,maxLen=>6,fieldName=>'Beneficiary
Bank Code', required=>true) and |
SS_CONTROLS |
86 |
0.102 |
43355 |
v_sum := v_sum + MOD(v_result,10); |
|
PROCESS_UPLOADEDFILE_UA |
87 |
0.101 |
88044 |
v_token:=readToken(v_line,v_token_offset); |
|
UA_LCY_DOC |
148 |
0.1 |
6003 |
if
self.checkRangeLen(p_value=>v_ben_account,maxLen=>14,fieldName=>'Beneficiary
Account', required=>true) and |
|
UA_DOC |
52 |
0.099 |
32016 |
v_value:=trim(p_value); |
|
UA_DOC |
26 |
0.097 |
4002 |
v_date:=to_date (
p_date,'DD.MM.YYYY') ; |
|
UA_LCY_DOC |
121 |
0.095 |
6003 |
if
self.checkRangeLen(p_value=>v_ben_cont_code,minLen=>0,maxLen=>10,fieldName=>'Beneficiary
Country Code', required=>false) and |
UA_LCY_DOC |
66 |
0.093 |
6003 |
if
self.checkRangeLen(p_value=>v_country_code,minLen=>3,maxLen=>3,fieldName=>'Payer
Country Code', required=>false) and |
|
UA_LCY_DOC |
282 |
0.09 |
4002 |
if not
self.checkBaeAndAccount(BenBankCode, BenAccount, 'Beneficiary') then |
|
SS_CONTROLS |
79 |
0.089 |
20010 |
v_result :=
to_number(substr(v_bae,i,1))*to_number(substr(v_weights,i,1)); |
|
UA_DOC |
7 |
0.087 |
42021 |
process_uploadedfile_ua.FIELDS_WORK(ind):=p_value; |
|
UA_LCY_DOC |
257 |
0.087 |
4002 |
end; |
|
UA_LCY_DOC |
290 |
0.086 |
4002 |
if not
self.checkCustAndCountryCode(PayerCode, CountryCode,'Payer') then |
|
UA_LCY_DOC |
110 |
0.084 |
4002 |
v_ben_name:=self.extract; |
|
UA_DOC |
257 |
0.083 |
4002 |
end ; |
|
UA_LCY_DOC |
54 |
0.083 |
4002 |
v_customer_name:=self.extract; |
|
UA_LCY_DOC |
299 |
0.082 |
4002 |
if not
self.checkCustAndCountryCode(BenCompanyCode, BenCountryCode,'Beneficiary')
then |
|
UA_LCY_DOC |
147 |
0.081 |
4002 |
v_ben_account:=self.extract; |
|
UA_LCY_DOC |
96 |
0.08 |
4002 |
v_ben_cust_cod:=self.extract; |
|
UA_LCY_DOC |
39 |
0.079 |
4002 |
v_payer_code :=self.extract; |
|
UA_LCY_DOC |
120 |
0.079 |
4002 |
v_ben_cont_code:=self.extract; |
|
UA_LCY_DOC |
161 |
0.079 |
4002 |
v_details := self.extract; |
|
UA_LCY_DOC |
172 |
0.079 |
4002 |
v_payment_id := self.extract; |
|
UA_LCY_DOC |
133 |
0.078 |
4002 |
v_ben_bank_code:=self.extract; |
|
UA_LCY_DOC |
84 |
0.077 |
4002 |
end ; |
|
UA_LCY_DOC |
14 |
0.077 |
4002 |
v_orderNumber:=self.extract; |
|
UA_LCY_DOC |
77 |
0.077 |
4002 |
v_cust_bae:=self.extract; |
|
UA_LCY_DOC |
29 |
0.077 |
4002 |
v_value_date:=self.extract; |
|
UA_DOC |
82 |
0.076 |
20010 |
if
(instr(translate(p_value,'0123456789*','**********X'),'*',1,length(p_value))>0)
then |
|
UA_LCY_DOC |
65 |
0.076 |
4002 |
v_country_code:=self.extract; |
|
SS_CONTROLS |
164 |
0.076 |
3335 |
FOR i IN 0..9 LOOP v_weights(i) :=
0; END LOOP; |
|
UA_LCY_DOC |
33 |
0.074 |
4002 |
end ; |
|
UA_LCY_DOC |
58 |
0.073 |
4002 |
end ; |
|
UA_LCY_DOC |
114 |
0.073 |
4002 |
end; |
|
UA_DOC |
244 |
0.072 |
4002 |
end ; |
|
UA_LCY_DOC |
71 |
0.072 |
4002 |
end ; |
|
PROCESS_UPLOADEDFILE_UA |
11 |
0.071 |
4002 |
return ua_lcy_doc(); |
|
UA_DOC |
296 |
0.069 |
4002 |
end; |
|
UA_LCY_DOC |
139 |
0.067 |
4002 |
end ; |
|
UA_DOC |
134 |
0.066 |
2001 |
close c_startup_bae; |
|
UA_LCY_DOC |
19 |
0.065 |
4002 |
end; |
|
UA_LCY_DOC |
126 |
0.064 |
4002 |
end ; |
|
PROCESS_UPLOADEDFILE_UA |
262 |
0.064 |
2001 |
end PROCESS_UPLOADEDFILE_UA; |
|
SS_CONTROLS |
80 |
0.063 |
20010 |
v_sum := v_sum + MOD(v_result,10); |
|
UA_DOC |
88 |
0.063 |
16008 |
end ; |
|
UA_DOC |
6 |
0.06 |
42021 |
ind:=ind+1; |
|
UA_LCY_DOC |
104 |
0.06 |
4002 |
end ; |
|
UA_LCY_DOC |
47 |
0.059 |
4002 |
end ; |
|
UA_LCY_DOC |
154 |
0.059 |
4002 |
end ; |
|
UA_LCY_DOC |
166 |
0.057 |
4002 |
end ; |
|
UA_LCY_DOC |
276 |
0.054 |
4002 |
end; |
|
UA_DOC |
269 |
0.054 |
4002 |
end ; |
|
UA_LCY_DOC |
173 |
0.053 |
4002 |
if
self.checkRangeLen(p_value=>v_payment_id,maxLen=>10,fieldName=>'Unique
Payment ID', required=>false) then |
|
UA_LCY_DOC |
162 |
0.053 |
4002 |
if
self.checkRangeLen(p_value=>v_details,minLen=>0,maxLen=>160,fieldName=>'Details',
required=>true) then |
|
UA_LCY_DOC |
30 |
0.053 |
4002 |
if
self.checkRangeLen(p_value=>v_value_date,minLen=>10,maxLen=>10,fieldName=>'Value
Date', required=>true) then |
|
UA_LCY_DOC |
111 |
0.052 |
4002 |
if
self.checkRangeLen(p_value=>v_ben_name,minLen=>0,maxLen=>38,fieldName=>'Beneficiary
Name', required=>true) then |
|
UA_LCY_DOC |
55 |
0.052 |
4002 |
if
self.checkRangeLen(p_value=>v_customer_name,minLen=>1,maxLen=>38,fieldName=>'Customer
Name', required=>true) then |
|
UA_LCY_DOC |
15 |
0.05 |
4002 |
if
self.checkRangeLen(p_value=>v_orderNumber,maxLen=>8,fieldName=>'Payment
Order Number', required=>false) then |
|
PROCESS_UPLOADEDFILE_UA |
127 |
0.05 |
4002 |
if v_doc.hasError then |
|
UA_DOC |
282 |
0.05 |
4002 |
end ; |
|
UA_DOC |
305 |
0.05 |
4002 |
end; |
|
UA_DOC |
226 |
0.05 |
4002 |
end; |
|
PROCESS_UPLOADEDFILE_UA |
70 |
0.049 |
42021 |
offset:=v_next_offset+1; |
|
PROCESS_UPLOADEDFILE_UA |
122 |
0.049 |
4002 |
v_doc.validateData; |
|
SS_CONTROLS |
189 |
0.048 |
9338 |
v_sum := v_sum +
(to_number(substr(v_code,i+1,1))*v_weights(i)); |
|
SS_CONTROLS |
74 |
0.048 |
4002 |
v_acc_chksum PLS_INTEGER :=
to_number(substr(v_account,5,1)); |
|
UA_LCY_DOC |
269 |
0.047 |
4002 |
if
DocDate<trunc(sysdate) or |
|
LOGPACK |
6 |
0.047 |
40 |
insert into ACTION_LOG |
|
UA_LCY_DOC |
286 |
0.046 |
4002 |
end; |
|
UA_DOC |
100 |
0.045 |
6003 |
end; |
|
SS_CONTROLS |
63 |
0.045 |
4002 |
end bg_Bulstat; |
|
UA_LCY_DOC |
294 |
0.044 |
4002 |
end; |
|
UA_LCY_DOC |
124 |
0.044 |
4002 |
BenCountryCode:=self.getCountryCod
(v_ben_cont_code, 'Beneficiary' ); |
|
UA_LCY_DOC |
31 |
0.043 |
4002 |
ValueDate:=self.convertDate(v_value_date,'Value
Date'); |
|
UA_LCY_DOC |
69 |
0.043 |
4002 |
CountryCode:=self.getCountryCod
(v_country_code, 'Payer' ); |
|
UA_DOC |
113 |
0.042 |
8004 |
end; |
|
UA_DOC |
15 |
0.041 |
34017 |
if indExtr>ind then |
|
PROCESS_UPLOADEDFILE_UA |
66 |
0.04 |
42021 |
v_ammount:=v_next_offset-offset; |
|
UA_DOC |
173 |
0.04 |
6003 |
end; |
|
UA_DOC |
123 |
0.038 |
6003 |
end; |
|
SS_CONTROLS |
167 |
0.038 |
2668 |
FOR i IN 0..6 LOOP v_weights(i) :=
i+1; END LOOP; -- original: i+1 |
|
PROCESS_UPLOADEDFILE_UA |
71 |
0.037 |
42021 |
return v_result; |
|
UA_DOC |
62 |
0.036 |
32016 |
if minLen=maxLen and
len<>minLen and len<>0 then |
|
UA_DOC |
161 |
0.036 |
4002 |
end ; |
|
PROCESS_UPLOADEDFILE_UA |
58 |
0.035 |
44022 |
if v_next_offset is null or
v_next_offset=0 then |
|
UA_DOC |
191 |
0.034 |
4002 |
select t.curr_code_alpha from
countries_currencies t where t.curr_code_alpha = p_curr; |
|
UA_DOC |
66 |
0.032 |
32016 |
if len<minLen and len>0 then |
|
UA_DOC |
60 |
0.032 |
28014 |
len:= length(p_value); |
|
UA_DOC |
314 |
0.032 |
4002 |
end; |
|
ACTION_AUTOINC |
2 |
0.031 |
40 |
SELECT ACTIONLOG_SEQ.nextval |
|
SS_CONTROLS |
178 |
0.03 |
3335 |
check_digit := MOD(v_sum,11); |
|
PROCESS_UPLOADEDFILE_UA |
88 |
0.029 |
44022 |
exit when v_token_offset=-1; |
|
UA_DOC |
238 |
0.029 |
4002 |
end ; |
|
SS_CONTROLS |
83 |
0.028 |
51359 |
FOR i IN 1..v_acc_length LOOP |
|
UA_DOC |
95 |
0.028 |
2001 |
v_amount :=
to_number(replace(p_value,',','.')); |
|
PROCESS_UPLOADEDFILE_UA |
124 |
0.026 |
2001 |
if (mod(v_doc_index,50)=0) then |
|
UA_DOC |
292 |
0.024 |
8004 |
if
face.is_cust_refno_unique(face.get_acc_cust_id(PayerAccount)
,sysdate,'NEW',PaymentOrderNumber)<>1 then |
|
UA_DOC |
53 |
0.023 |
32016 |
if v_value is null and required then |
|
UA_DOC |
275 |
0.023 |
4002 |
end ; |
|
UA_DOC |
267 |
0.023 |
2001 |
Amount:=to_number(replace(v_amount,',','.')); |
|
SS_CONTROLS |
183 |
0.021 |
1334 |
FOR i IN 0..6 LOOP v_weights(i) :=
i+3; END LOOP; -- original:i+3 |
|
UA_DOC |
70 |
0.02 |
32016 |
if len>maxLen then |
|
PROCESS_UPLOADEDFILE_UA |
29 |
0.019 |
4004 |
v_next_offset :=
DBMS_LOB.INSTR(p_blob,hextoraw('0A'),offset,1); |
|
SS_CONTROLS |
91 |
0.019 |
4002 |
v_sum := MOD((MOD(v_sum,10)*7),10); |
|
UA_DOC |
107 |
0.017 |
8004 |
if
(ss_controls.ua_check_account(baeValue,accountValue)=0) then |
|
PROCESS_UPLOADEDFILE_UA |
38 |
0.017 |
2001 |
v_ammount:=v_next_offset-offset-1; |
|
SS_CONTROLS |
78 |
0.016 |
24012 |
FOR i IN 1..5 LOOP |
|
UA_DOC |
31 |
0.016 |
4002 |
end; |
|
PROCESS_UPLOADEDFILE_UA |
40 |
0.016 |
4002 |
DBMS_LOB.READ(p_blob,v_ammount,offset,v_result); |
|
UA_DOC |
143 |
0.016 |
4002 |
end; |
|
SS_CONTROLS |
160 |
0.016 |
3335 |
IF length(v_code) = 3 OR
to_number(v_code) = 99999 THEN |
|
UA_DOC |
243 |
0.016 |
2001 |
indExtr:=indExtr+1; |
|
UA_DOC |
179 |
0.015 |
8004 |
if
ss_controls.ua_check_code(custCode) =1 then |
|
SS_CONTROLS |
292 |
0.015 |
4002 |
END ua_check_code; |
|
SS_CONTROLS |
84 |
0.014 |
47357 |
IF i <> 5 THEN |
|
PROCESS_UPLOADEDFILE_UA |
67 |
0.014 |
42021 |
if v_ammount>0 then |
|
SS_CONTROLS |
175 |
0.014 |
26680 |
FOR i IN REVERSE 0..6 LOOP |
|
FACE |
225 |
0.014 |
4002 |
return lbank_name; |
|
PROCESS_UPLOADEDFILE_UA |
43 |
0.014 |
4002 |
return
utl_raw.cast_to_varchar2(v_result); |
|
UA_DOC |
311 |
0.014 |
4002 |
if
(CustomerId!=face.get_acc_cust_id(PayerAccount)) then |
|
FACE |
496 |
0.013 |
4002 |
return v_cust_id; |
|
PROCESS_UPLOADEDFILE_UA |
21 |
0.013 |
2002 |
end; |
|
PROCESS_UPLOADEDFILE_UA |
50 |
0.012 |
44022 |
v_result varchar2(1024):=null; |
|
UA_DOC |
74 |
0.012 |
32016 |
return true; |
|
PROCESS_UPLOADEDFILE_UA |
85 |
0.012 |
4002 |
p_doc:=createDocument; |
|
PROCESS_UPLOADEDFILE_UA |
53 |
0.011 |
44022 |
if p_line is null then |
|
PROCESS_UPLOADEDFILE_UA |
81 |
0.011 |
4004 |
v_line := readLine( p_blob ,
OFFSET); |
|
UA_DOC |
118 |
0.011 |
4002 |
if ((countyCodeValue is
null)=(custCodeValue is null)) then |
|
SS_CONTROLS |
72 |
0.011 |
4002 |
v_acc_length PLS_INTEGER :=
length(v_account); |
|
UA_DOC |
209 |
0.011 |
2001 |
select t.c_iso_did from contries t
where t.c_iso_did=p_contry; |
|
PROCESS_UPLOADEDFILE_UA |
42 |
0.011 |
2001 |
offset:=v_next_offset+1; |
|
UA_DOC |
318 |
0.01 |
4002 |
AmountInWords:=
iclbank.conv_to_words.FN_SummaWithWords(amount); |
|
FACE |
484 |
0.01 |
4002 |
end get_acc_bae_name; |
|
FACE |
130 |
0.01 |
2001 |
end is_cust_refno_unique; |
|
UA_DOC |
281 |
0.01 |
2001 |
indExtr:=indExtr+1; |
|
FACE |
121 |
0.01 |
2001 |
if v_count=0 then |
|
UA_DOC |
185 |
0.009 |
4002 |
end; |
|
UA_DOC |
220 |
0.009 |
4002 |
end ; |
|
UA_LCY_DOC |
176 |
0.009 |
4002 |
end ; |
|
UA_DOC |
166 |
0.009 |
4002 |
if (face.get_bank_name(bae) is null)
then |
|
FACE |
214 |
0.009 |
4002 |
end get_cust_id; |
|
PROCESS_UPLOADEDFILE_UA |
80 |
0.009 |
2002 |
p_doc:=null; |
|
UA_DOC |
81 |
0.008 |
14007 |
if p_value is null then return true;
end if; |
|
UA_DOC |
319 |
0.008 |
4002 |
PayerBankName:=face.get_bank_name(PayerBankCode); |
|
SS_CONTROLS |
69 |
0.008 |
4002 |
v_weights VARCHAR2(30) :=
'1371337137137137137137137'; |
|
UA_DOC |
321 |
0.008 |
2001 |
end; |
|
FACE |
232 |
0.007 |
4002 |
end ; |
|
FACE |
502 |
0.007 |
4002 |
end get_acc_cust_id; |
|
SS_CONTROLS |
166 |
0.007 |
3335 |
IF to_number(v_code) < 30000000
OR to_number(v_code) > 60000000 THEN |
|
UA_LCY_DOC |
344 |
0.007 |
2001 |
end; |
|
PROCESS_UPLOADEDFILE_UA |
133 |
0.007 |
2001 |
v_doc_index:=v_doc_index+1; |
|
LOGPACK |
14 |
0.007 |
40 |
commit; |
|
SS_CONTROLS |
188 |
0.006 |
10672 |
FOR i IN REVERSE 0..6 LOOP |
|
UA_DOC |
83 |
0.006 |
10005 |
return true; |
|
SS_CONTROLS |
154 |
0.006 |
4002 |
IF length(v_code) < 1 THEN |
|
PROCESS_UPLOADEDFILE_UA |
92 |
0.006 |
2003 |
end; |
|
PROCESS_UPLOADEDFILE_UA |
30 |
0.006 |
2002 |
if v_next_offset=0 then |
|
FACE |
99 |
0.006 |
2001 |
end get_next_cust_refno; |
|
SS_CONTROLS |
201 |
0.006 |
2001 |
IF check_digit =
to_number(substr(v_code,8,1)) THEN |
|
FACE |
122 |
0.006 |
2001 |
return 1; |
|
SS_CONTROLS |
169 |
0.006 |
667 |
FOR i IN 1..6 LOOP v_weights(i) :=
i; END LOOP; -- original: i |
|
UA_DOC |
57 |
0.005 |
32016 |
if v_value is null then |
|
SS_CONTROLS |
165 |
0.005 |
3335 |
v_weights(0) := 7; |
|
UA_DOC |
133 |
0.005 |
2001 |
v_correct:=c_startup_bae%found; |
|
PROCESS_UPLOADEDFILE_UA |
123 |
0.005 |
2001 |
v_doc.error_line:=v_doc_index; |
|
UA_DOC |
154 |
0.005 |
2001 |
v_correct:=c_account%found; |
|
SS_CONTROLS |
191 |
0.005 |
1334 |
check_digit := MOD(v_sum,11); |
|
SS_CONTROLS |
93 |
0.004 |
4002 |
IF v_acc_chksum <> v_sum THEN |
|
SS_CONTROLS |
73 |
0.004 |
4002 |
v_sum NUMBER := 0; |
|
UA_DOC |
27 |
0.004 |
4002 |
return v_date; |
|
SS_CONTROLS |
156 |
0.004 |
4002 |
ELSIF length(v_code) > 8 THEN |
|
UA_DOC |
106 |
0.004 |
4002 |
if baeValue is null or accountValue
is null then return true; end if; |
|
UA_DOC |
212 |
0.004 |
4002 |
if countryCode is null then return
null;end if; |
|
PROCESS_UPLOADEDFILE_UA |
15 |
0.004 |
2001 |
end ; |
|
PROCESS_UPLOADEDFILE_UA |
59 |
0.004 |
2001 |
v_next_offset:= length(p_line); |
|
UA_DOC |
225 |
0.004 |
2001 |
return error_message is not null; |
|
UA_DOC |
255 |
0.004 |
2001 |
PayerAccount:=v_payer_account; |
|
UA_LCY_DOC |
303 |
0.004 |
2001 |
end; |
|
PROCESS_UPLOADEDFILE_UA |
9 |
0.004 |
2001 |
case DOC_TYPE_CREATE |
|
SS_CONTROLS |
194 |
0.004 |
1334 |
ELSIF check_digit =
to_number(substr(v_code,8,1)) THEN |
|
PROCESS_UPLOADEDFILE_UA |
120 |
0.003 |
4004 |
while readNextObject(v_blob,v_doc)
loop |
|
UA_LCY_DOC |
182 |
0.003 |
4002 |
end ; |
|
UA_LCY_DOC |
188 |
0.003 |
4002 |
end ; |
|
SS_CONTROLS |
172 |
0.003 |
3335 |
IF length(v_code) = 8 THEN |
|
SS_CONTROLS |
179 |
0.003 |
3335 |
IF check_digit = 10 THEN |
|
UA_LCY_DOC |
350 |
0.003 |
2001 |
ind:=0; |
|
UA_LCY_DOC |
353 |
0.003 |
2001 |
END; |
|
UA_LCY_DOC |
209 |
0.003 |
2001 |
self.indExtr:=0; |
|
UA_DOC |
180 |
0.002 |
4002 |
return true; |
|
SS_CONTROLS |
70 |
0.002 |
4002 |
v_bae VARCHAR2(30):= p_bank_code; |
|
SS_CONTROLS |
96 |
0.002 |
4002 |
RETURN 1; |
|
SS_CONTROLS |
90 |
0.002 |
4002 |
v_sum := v_sum + v_acc_length; |
|
SS_CONTROLS |
147 |
0.002 |
4002 |
v_code VARCHAR2(10) := p_code; |
|
UA_DOC |
111 |
0.002 |
4002 |
return true; |
|
UA_DOC |
58 |
0.002 |
4002 |
len:=0; |
|
UA_LCY_DOC |
194 |
0.002 |
4002 |
end ; |
|
PROCESS_UPLOADEDFILE_UA |
82 |
0.002 |
2002 |
if (v_line is null ) then |
|
PROCESS_UPLOADEDFILE_UA |
77 |
0.002 |
2002 |
v_token_offset integer:=1; |
|
UA_DOC |
152 |
0.002 |
2001 |
open c_account(account); |
|
UA_DOC |
131 |
0.002 |
2001 |
open c_startup_bae(bae); |
|
PROCESS_UPLOADEDFILE_UA |
91 |
0.002 |
2001 |
return true; |
|
UA_LCY_DOC |
82 |
0.002 |
2001 |
PayerBankCode:=v_cust_bae; |
|
PROCESS_UPLOADEDFILE_UA |
61 |
0.002 |
2001 |
offset:=-1; |
|
PROCESS_UPLOADEDFILE_UA |
39 |
0.002 |
2001 |
if v_ammount>0 then |
|
PROCESS_UPLOADEDFILE_UA |
121 |
0.002 |
2001 |
v_doc.CustomerID:=p_cust_id; |
|
UA_DOC |
170 |
0.002 |
2001 |
return true; |
|
SS_CONTROLS |
182 |
0.002 |
1334 |
IF to_number(v_code) < 30000000
OR to_number(v_code) > 60000000 THEN |
|
SS_CONTROLS |
181 |
0.002 |
1334 |
v_weights(0) := 9; |
|
UA_DOC |
178 |
0.001 |
4002 |
if custCode is null then return
true; end if; |
|
UA_DOC |
122 |
0.001 |
4002 |
return true; |
|
SS_CONTROLS |
71 |
0.001 |
4002 |
v_account VARCHAR2(30) :=
p_account_no; |
|
SS_CONTROLS |
174 |
0.001 |
3335 |
v_sum := 0; |
|
PROCESS_UPLOADEDFILE_UA |
26 |
0.001 |
2002 |
v_result raw(4000):=null; |
|
SS_CONTROLS |
202 |
0.001 |
2001 |
RETURN 1; |
|
FACE |
105 |
0.001 |
2001 |
if p_cref is null then |
|
UA_LCY_DOC |
112 |
0.001 |
2001 |
BenName:=v_ben_name; |
|
UA_LCY_DOC |
45 |
0.001 |
2001 |
PayerCode:=v_payer_code; |
|
UA_LCY_DOC |
351 |
0.001 |
2001 |
indExtr:=0; |
|
UA_DOC |
96 |
0.001 |
2001 |
return true; |
|
PROCESS_UPLOADEDFILE_UA |
62 |
0.001 |
2001 |
return null; |
|
UA_LCY_DOC |
174 |
0.001 |
2001 |
UniquePaymentId:=v_payment_id; |
|
UA_LCY_DOC |
16 |
0.001 |
2001 |
PaymentOrderNumber := v_orderNumber; |
|
UA_LCY_DOC |
164 |
0.001 |
2001 |
Details:=v_details; |
|
UA_LCY_DOC |
137 |
0.001 |
2001 |
BenBankCode:=v_ben_bank_code; |
|
UA_LCY_DOC |
152 |
0.001 |
2001 |
BenAccount:=v_ben_account; |
|
PROCESS_UPLOADEDFILE_UA |
60 |
0.001 |
2001 |
if v_next_offset<=offset then |
|
UA_LCY_DOC |
102 |
0.001 |
2001 |
BenCompanyCode:=v_ben_cust_cod; |
|
UA_LCY_DOC |
56 |
0.001 |
2001 |
CustomerName:=v_customer_name; |
|
UA_DOC |
286 |
0.001 |
2001 |
if PaymentOrderNumber is null then |
|
UA_DOC |
156 |
0.001 |
2001 |
return true; |
|
UA_DOC |
135 |
0.001 |
2001 |
if v_correct then |
|
UA_DOC |
136 |
0.001 |
2001 |
return true; |
|
UA_DOC |
155 |
0.001 |
2001 |
if v_correct then |
|
SS_CONTROLS |
192 |
0.001 |
1334 |
IF check_digit = 10 THEN |
|
SS_CONTROLS |
195 |
0.001 |
1334 |
RETURN 1; |
|
SS_CONTROLS |
157 |
0.001 |
667 |
RETURN 1; |
|
SS_CONTROLS |
187 |
0 |
1334 |
v_sum := 0; |
|
PROCESS_UPLOADEDFILE_UA |
125 |
0 |
40 |
logpack.log(v_doc_index); |
|
LOGPACK |
17 |
0 |
40 |
end; |
|
PROCESS_UPLOADEDFILE_UA |
143 |
0 |
2 |
end; |
|
PROCESS_UPLOADEDFILE_UA |
155 |
0 |
2 |
v_result:=readFileInStructure(p_doc_id,
v_doc_array,p_cust) ; |
|
PROCESS_UPLOADEDFILE_UA |
31 |
0 |
2 |
v_next_offset:=
DBMS_LOB.getlength(p_blob); |
|
ANONYMOUS BLOCK |
3 |
0 |
2 |
|
PROCESS_UPLOADEDFILE_UA |
156 |
0 |
1 |
v_doc_array:=null; |
|
PROCESS_UPLOADEDFILE_UA |
158 |
0 |
1 |
end; |
|
PROCESS_UPLOADEDFILE_UA |
157 |
0 |
1 |
return v_result; |
|
PROCESS_UPLOADEDFILE_UA |
107 |
0 |
1 |
v_doc_index integer:=1; |
|
PROCESS_UPLOADEDFILE_UA |
108 |
0 |
1 |
isCorrect integer:=1; |
|
PROCESS_UPLOADEDFILE_UA |
113 |
0 |
1 |
select blob_content into v_blob from
doc_container |
|
PROCESS_UPLOADEDFILE_UA |
83 |
0 |
1 |
return false; |
|
PROCESS_UPLOADEDFILE_UA |
32 |
0 |
1 |
if v_next_offset<=offset then |
|
PROCESS_UPLOADEDFILE_UA |
33 |
0 |
1 |
offset:=-1; |
|
PROCESS_UPLOADEDFILE_UA |
34 |
0 |
1 |
return null; |
|
PROCESS_UPLOADEDFILE_UA |
138 |
0 |
1 |
return isCorrect; |
|
PROCESS_UPLOADEDFILE_UA |
153 |
0 |
1 |
DOC_TYPE_CREATE:=1; |
|
PROCESS_UPLOADEDFILE_UA |
154 |
0 |
1 |
v_doc_array:= ua_doc_array(); |
|
PROCESS_UPLOADEDFILE_UA |
136 |
0 |
1 |
DBMS_LOB.close(v_blob); |
|
PROCESS_UPLOADEDFILE_UA |
117 |
0 |
1 |
DBMS_LOB.OPEN (v_blob,
DBMS_LOB.LOB_READONLY); |
|
PROCESS_UPLOADEDFILE_UA |
118 |
0 |
1 |
v_line_offset:=1; |
|
PROCESS_UPLOADEDFILE_UA |
119 |
0 |
1 |
OFFSET:=1; |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|