[Home] [Help]
PACKAGE: APPS.CE_VALIDATE_BANKINFO_UPG
Source
1 PACKAGE CE_VALIDATE_BANKINFO_UPG AUTHID CURRENT_USER AS
2 /* $Header: cevlbkus.pls 120.1 2005/03/09 21:47:13 eliu noship $ */
3
4
5 FUNCTION ce_check_numeric(check_value VARCHAR2,
6 pos_from NUMBER,
7 pos_for NUMBER ) RETURN VARCHAR2;
8
9
10 PROCEDURE COMPARE_BANK_AND_BRANCH_NUM(Xi_branch_num IN VARCHAR2,
11 Xi_BANK_ID IN NUMBER);
12
13 FUNCTION COMPARE_ACCOUNT_NUM_AND_CD(Xi_account_num IN VARCHAR2,
14 Xi_CD IN NUMBER,
15 Xi_CD_length in number,
16 Xi_CD_pos_from_right IN Number default 0) RETURN BOOLEAN;
17
18
19 FUNCTION CE_VAL_UNIQUE_TAX_PAYER_ID (p_country_code IN VARCHAR2,
20 p_taxpayer_id IN VARCHAR2
21 ) RETURN VARCHAR2;
22
23 PROCEDURE ce_check_cross_module_tax_id(p_country_code IN VARCHAR2,
24 p_entity_name IN VARCHAR2,
25 p_taxpayer_id IN VARCHAR2,
26 p_return_ar OUT NOCOPY VARCHAR2,
27 p_return_ap OUT NOCOPY VARCHAR2,
28 p_return_hr OUT NOCOPY VARCHAR2,
29 p_return_bk OUT NOCOPY VARCHAR2);
30
31 FUNCTION ce_tax_id_check_algorithm(p_taxpayer_id IN VARCHAR2,
32 p_country IN VARCHAR2,
33 p_tax_id_cd IN VARCHAR2) RETURN VARCHAR2;
34
35
36
37 /* --------------------------------------------------------------------
38 | PRIVATE PROCEDURE |
39 | CE_VALIDATE_* |
40 --------------------------------------------------------------------- */
41
42 PROCEDURE CE_VALIDATE_CD(X_COUNTRY_NAME IN varchar2,
43 X_CD IN varchar2,
44 X_BANK_NUMBER IN varchar2,
45 X_BRANCH_NUMBER IN varchar2,
46 X_ACCOUNT_NUMBER IN varchar2);
47 --p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48 --x_msg_count OUT NOCOPY NUMBER,
49 --x_msg_data OUT NOCOPY VARCHAR2);
50 --X_VALUE_OUT OUT NOCOPY varchar2);
51
52 PROCEDURE CE_VALIDATE_BRANCH(X_COUNTRY_NAME IN varchar2,
53 --X_BANK_NUMBER IN varchar2,
54 X_BRANCH_NUMBER IN varchar2,
55 --X_BANK_NAME IN varchar2,
56 --X_BRANCH_NAME IN varchar2,
57 X_BRANCH_NAME_ALT IN varchar2,
58 X_BANK_ID IN NUMBER,
59 --X_BRANCH_ID IN NUMBER,
60 X_VALIDATION_TYPE IN varchar2 := 'ALL',
61 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
62 x_msg_count OUT NOCOPY NUMBER,
63 x_msg_data OUT NOCOPY VARCHAR2,
64 X_VALUE_OUT OUT NOCOPY varchar2,
65 x_message_name_all OUT NOCOPY varchar2);
66
67 PROCEDURE CE_VALIDATE_ACCOUNT(X_COUNTRY_NAME IN varchar2,
68 X_BANK_NUMBER IN varchar2,
69 X_BRANCH_NUMBER IN varchar2,
70 X_ACCOUNT_NUMBER IN varchar2,
71 --X_BANK_ID IN number,
72 --X_BRANCH_ID IN number,
73 --X_ACCOUNT_ID IN number,
74 --X_CURRENCY_CODE IN varchar2,
75 X_ACCOUNT_TYPE IN varchar2,
76 X_ACCOUNT_SUFFIX IN varchar2,
77 X_SECONDARY_ACCOUNT_REFERENCE IN varchar2,
78 X_ACCOUNT_NAME IN varchar2,
79 X_CD IN varchar2,
80 X_VALIDATION_TYPE IN varchar2 := 'ALL',
81 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2,
84 X_VALUE_OUT OUT NOCOPY varchar2,
85 x_message_name_all OUT NOCOPY varchar2);
86
87 PROCEDURE CE_VALIDATE_BANK( X_COUNTRY_NAME IN varchar2,
88 X_BANK_NUMBER IN varchar2,
89 X_BANK_NAME IN varchar2,
90 X_BANK_NAME_ALT IN varchar2,
91 X_TAX_PAYER_ID IN varchar2,
92 --X_BANK_ID IN NUMBER,
93 X_VALIDATION_TYPE IN varchar2 := 'ALL',
94 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
95 x_msg_count OUT NOCOPY NUMBER,
96 x_msg_data OUT NOCOPY VARCHAR2,
97 X_VALUE_OUT OUT NOCOPY varchar2,
98 x_message_name_all OUT NOCOPY varchar2);
99
100 /* --------------------------------------------------------------------
101 | PRIVATE PROCEDURE |
102 | CE_VALIDATE_CD_* |
103 --------------------------------------------------------------------- */
104
105 PROCEDURE ce_validate_cd_pt(Xi_CD VARCHAR2,
106 Xi_PASS_MAND_CHECK VARCHAR2,
107 Xi_X_BANK_NUMBER VARCHAR2,
108 Xi_X_BRANCH_NUMBER VARCHAR2,
109 Xi_X_ACCOUNT_NUMBER VARCHAR2);
110
111 PROCEDURE ce_validate_cd_es(Xi_CD VARCHAR2,
112 Xi_PASS_MAND_CHECK VARCHAR2,
113 Xi_X_BANK_NUMBER VARCHAR2,
114 Xi_X_BRANCH_NUMBER VARCHAR2,
115 Xi_X_ACCOUNT_NUMBER VARCHAR2);
116
117
118 PROCEDURE ce_validate_cd_fr(Xi_CD VARCHAR2,
119 Xi_PASS_MAND_CHECK VARCHAR2,
120 Xi_X_BANK_NUMBER VARCHAR2,
121 Xi_X_BRANCH_NUMBER VARCHAR2,
122 Xi_X_ACCOUNT_NUMBER VARCHAR2);
123
124 -- new validations for check digits 5/14/02
125
126 procedure CE_VALIDATE_CD_DE(Xi_CD in varchar2,
127 Xi_X_ACCOUNT_NUMBER in varchar2);
128
129 procedure CE_VALIDATE_CD_GR(Xi_CD in varchar2,
130 Xi_PASS_MAND_CHECK in varchar2,
131 Xi_X_BANK_NUMBER in varchar2,
132 Xi_X_BRANCH_NUMBER in varchar2,
133 Xi_X_ACCOUNT_NUMBER in varchar2);
134
135 procedure CE_VALIDATE_CD_IS(Xi_CD in varchar2,
136 Xi_X_ACCOUNT_NUMBER in varchar2);
137
138 procedure CE_VALIDATE_CD_IT(Xi_CD in varchar2,
139 Xi_PASS_MAND_CHECK in varchar2,
140 Xi_X_BANK_NUMBER in varchar2,
141 Xi_X_BRANCH_NUMBER in varchar2,
142 Xi_X_ACCOUNT_NUMBER in varchar2);
143
144 procedure CE_VALIDATE_CD_LU(Xi_CD in varchar2,
145 Xi_X_BANK_NUMBER in varchar2,
146 Xi_X_BRANCH_NUMBER in varchar2,
147 Xi_X_ACCOUNT_NUMBER in varchar2);
148 --Xo_VALUE_OUT OUT NOCOPY varchar2);
149
150 procedure CE_VALIDATE_CD_SE(Xi_CD in varchar2,
151 Xi_X_ACCOUNT_NUMBER in varchar2);
152
153 /* --------------------------------------------------------------------
154 | PRIVATE PROCEDURE |
155 | CE_VALIDATE_BRANCH_* |
156 --------------------------------------------------------------------- */
157
158
159 PROCEDURE ce_validate_branch_at(Xi_BRANCH_NUMBER VARCHAR2,
160 Xi_PASS_MAND_CHECK VARCHAR2,
161 Xo_VALUE_OUT OUT NOCOPY varchar2);
162
163 PROCEDURE ce_validate_branch_pt(Xi_BRANCH_NUMBER VARCHAR2,
164 Xi_PASS_MAND_CHECK VARCHAR2);
165
166 PROCEDURE ce_validate_branch_fr(Xi_BRANCH_NUMBER VARCHAR2,
167 Xi_PASS_MAND_CHECK VARCHAR2,
168 Xo_VALUE_OUT OUT NOCOPY varchar2);
169
170
171 PROCEDURE ce_validate_branch_es(Xi_BRANCH_NUMBER VARCHAR2,
172 Xi_PASS_MAND_CHECK VARCHAR2,
173 Xo_VALUE_OUT OUT NOCOPY varchar2);
174
175
176
177 PROCEDURE ce_validate_branch_br(Xi_BRANCH_NUMBER VARCHAR2,
178 Xi_PASS_MAND_CHECK VARCHAR2,
179 Xo_VALUE_OUT OUT NOCOPY varchar2);
180
181 -- new branch validations 5/14/02
182
183 procedure CE_VALIDATE_BRANCH_DE(Xi_BRANCH_NUMBER in varchar2,
184 Xi_BANK_ID in NUMBER);
185
186 procedure CE_VALIDATE_BRANCH_GR(Xi_BRANCH_NUMBER in varchar2);
187
188 procedure CE_VALIDATE_BRANCH_IS(Xi_BRANCH_NUMBER in varchar2,
189 Xi_BANK_ID in NUMBER,
190 Xo_VALUE_OUT OUT NOCOPY varchar2);
191
192
193 procedure CE_VALIDATE_BRANCH_IE(Xi_BRANCH_NUMBER in varchar2,
194 Xi_BANK_ID in NUMBER);
195
196 procedure CE_VALIDATE_BRANCH_IT(Xi_BRANCH_NUMBER in varchar2,
197 Xi_PASS_MAND_CHECK in varchar2);
198
199 procedure CE_VALIDATE_BRANCH_LU(Xi_BRANCH_NUMBER in varchar2,
200 Xi_BANK_ID in NUMBER);
201
202
203 procedure CE_VALIDATE_BRANCH_PL(Xi_BRANCH_NUMBER in varchar2,
204 Xi_BANK_ID in NUMBER);
205
206
207 procedure CE_VALIDATE_BRANCH_SE(Xi_BRANCH_NUMBER in varchar2,
208 Xi_BANK_ID in NUMBER);
209
210
211 procedure CE_VALIDATE_BRANCH_CH(Xi_BRANCH_NUMBER in varchar2,
212 Xi_BANK_ID in NUMBER);
213
214
215 procedure CE_VALIDATE_BRANCH_GB(Xi_BRANCH_NUMBER in varchar2,
216 Xi_BANK_ID in NUMBER);
217
218
219 procedure CE_VALIDATE_BRANCH_US(Xi_BRANCH_NUMBER in varchar2,
220 Xi_PASS_MAND_CHECK in varchar2,
221 Xo_VALUE_OUT OUT NOCOPY varchar2);
222
223
224 -- new branch validations 10/19/04
225
226 procedure CE_VALIDATE_BRANCH_AU(Xi_BRANCH_NUMBER in varchar2,
227 Xi_BANK_ID in NUMBER,
228 Xi_PASS_MAND_CHECK VARCHAR2);
229
230 procedure CE_VALIDATE_BRANCH_IL(Xi_BRANCH_NUMBER in varchar2,
231 Xi_PASS_MAND_CHECK VARCHAR2);
232
233
234 procedure CE_VALIDATE_BRANCH_NZ(Xi_BRANCH_NUMBER in varchar2,
235 Xi_PASS_MAND_CHECK VARCHAR2);
236
237 procedure CE_VALIDATE_BRANCH_JP(Xi_BRANCH_NUMBER in varchar2,
238 Xi_BRANCH_NAME_ALT in varchar2,
239 Xi_PASS_MAND_CHECK VARCHAR2,
240 Xi_VALIDATION_TYPE in varchar2);
241
242
243
244 /* --------------------------------------------------------------------
245 | PRIVATE PROCEDURE |
246 | CE_VALIDATE_ACCOUNT_* |
247 --------------------------------------------------------------------- */
248
249 PROCEDURE ce_validate_account_at(Xi_ACCOUNT_NUMBER VARCHAR2,
250 Xi_PASS_MAND_CHECK VARCHAR2,
251 Xo_VALUE_OUT OUT NOCOPY varchar2);
252
253
254 PROCEDURE ce_validate_account_pt(Xi_ACCOUNT_NUMBER VARCHAR2,
255 Xi_PASS_MAND_CHECK VARCHAR2,
256 Xo_VALUE_OUT OUT NOCOPY varchar2);
257
258 PROCEDURE ce_validate_account_be(Xi_ACCOUNT_NUMBER VARCHAR2,
259 Xi_PASS_MAND_CHECK VARCHAR2);
260
261
262 PROCEDURE ce_validate_account_dk(Xi_ACCOUNT_NUMBER VARCHAR2,
263 Xi_PASS_MAND_CHECK VARCHAR2,
264 Xo_VALUE_OUT OUT NOCOPY varchar2);
265
266
267 PROCEDURE ce_validate_account_fr(Xi_ACCOUNT_NUMBER VARCHAR2,
268 Xi_PASS_MAND_CHECK VARCHAR2,
269 Xo_VALUE_OUT OUT NOCOPY varchar2);
270
271
272 PROCEDURE ce_validate_account_nl(Xi_ACCOUNT_NUMBER VARCHAR2,
273 Xi_PASS_MAND_CHECK VARCHAR2);
274
275
276 PROCEDURE ce_validate_account_es(Xi_ACCOUNT_NUMBER VARCHAR2,
277 Xi_PASS_MAND_CHECK VARCHAR2,
278 Xo_VALUE_OUT OUT NOCOPY varchar2);
279
280
281 PROCEDURE ce_validate_account_no(Xi_ACCOUNT_NUMBER VARCHAR2,
282 Xi_PASS_MAND_CHECK VARCHAR2);
283
284
285 PROCEDURE ce_validate_account_fi(Xi_ACCOUNT_NUMBER VARCHAR2,
286 Xi_PASS_MAND_CHECK VARCHAR2);
287
288
289 -- new account validations 5/14/02
290
291 procedure CE_VALIDATE_ACCOUNT_DE(Xi_ACCOUNT_NUMBER in varchar2,
292 Xo_VALUE_OUT OUT NOCOPY varchar2);
293
294 procedure CE_VALIDATE_ACCOUNT_GR(Xi_ACCOUNT_NUMBER in varchar2,
295 Xo_VALUE_OUT OUT NOCOPY varchar2);
296
297
298 procedure CE_VALIDATE_ACCOUNT_IS(Xi_ACCOUNT_NUMBER in varchar2,
299 Xo_VALUE_OUT OUT NOCOPY varchar2);
300
301
302 procedure CE_VALIDATE_ACCOUNT_IE(Xi_ACCOUNT_NUMBER in varchar2);
303
304
305 procedure CE_VALIDATE_ACCOUNT_IT(Xi_ACCOUNT_NUMBER in varchar2,
306 Xo_VALUE_OUT OUT NOCOPY varchar2);
307
308 procedure CE_VALIDATE_ACCOUNT_LU(Xi_ACCOUNT_NUMBER in varchar2);
309
310 procedure CE_VALIDATE_ACCOUNT_PL(Xi_ACCOUNT_NUMBER in varchar2);
311
312 procedure CE_VALIDATE_ACCOUNT_SE(Xi_ACCOUNT_NUMBER in varchar2);
313
314 procedure CE_VALIDATE_ACCOUNT_CH(Xi_ACCOUNT_NUMBER in varchar2,
315 Xi_ACCOUNT_TYPE in varchar2,
316 Xi_VALIDATION_TYPE in varchar2 );
317
318 procedure CE_VALIDATE_ACCOUNT_GB(Xi_ACCOUNT_NUMBER in varchar2,
319 Xo_VALUE_OUT OUT NOCOPY varchar2);
320
321 procedure CE_VALIDATE_ACCOUNT_BR(Xi_ACCOUNT_NUMBER in varchar2,
322 Xi_SECONDARY_ACCOUNT_REFERENCE in varchar2);
323
324 -- new account validations 10/19/04
325
326 procedure CE_VALIDATE_ACCOUNT_AU(Xi_ACCOUNT_NUMBER in varchar2);
327 procedure CE_VALIDATE_ACCOUNT_IL(Xi_ACCOUNT_NUMBER in varchar2);
328 procedure CE_VALIDATE_ACCOUNT_NZ(Xi_ACCOUNT_NUMBER in varchar2,
329 Xi_ACCOUNT_SUFFIX in varchar2,
330 Xi_VALIDATION_TYPE in varchar2);
331
332 procedure CE_VALIDATE_ACCOUNT_JP(Xi_ACCOUNT_NUMBER in varchar2,
333 Xi_ACCOUNT_TYPE in varchar2,
334 Xi_VALIDATION_TYPE in varchar2);
335
336
337
338 /* --------------------------------------------------------------------
339 | PRIVATE PROCEDURE |
340 | CE_VALIDATE_BANK_* |
341 --------------------------------------------------------------------- */
342
343 PROCEDURE ce_validate_bank_es(Xi_BANK_NUMBER VARCHAR2,
344 Xi_PASS_MAND_CHECK VARCHAR2,
345 Xo_VALUE_OUT OUT NOCOPY varchar2);
346
347
348 PROCEDURE ce_validate_bank_fr(Xi_BANK_NUMBER VARCHAR2,
349 Xi_PASS_MAND_CHECK VARCHAR2,
350 Xo_VALUE_OUT OUT NOCOPY varchar2);
351
352
353 PROCEDURE ce_validate_bank_pt(Xi_BANK_NUMBER VARCHAR2,
354 Xi_PASS_MAND_CHECK VARCHAR2);
355
356
360
357 PROCEDURE ce_validate_bank_br(Xi_BANK_NUMBER VARCHAR2,
358 Xi_PASS_MAND_CHECK VARCHAR2,
359 Xo_VALUE_OUT OUT NOCOPY varchar2);
361 -- new bank validations 5/14/02
362
363
364 procedure CE_VALIDATE_BANK_DE(Xi_BANK_NUMBER in varchar2);
365
366 procedure CE_VALIDATE_BANK_GR(Xi_BANK_NUMBER in varchar2);
367
368 procedure CE_VALIDATE_BANK_IS(Xi_BANK_NUMBER in varchar2,
369 Xo_VALUE_OUT OUT NOCOPY varchar2);
370
371 procedure CE_VALIDATE_BANK_IE(Xi_BANK_NUMBER in varchar2);
372
373 procedure CE_VALIDATE_BANK_IT(Xi_BANK_NUMBER in varchar2,
374 Xi_PASS_MAND_CHECK in varchar2);
375
376 procedure CE_VALIDATE_BANK_LU(Xi_BANK_NUMBER in varchar2);
377
378
379 procedure CE_VALIDATE_BANK_PL(Xi_BANK_NUMBER in varchar2);
380
381 procedure CE_VALIDATE_BANK_SE(Xi_BANK_NUMBER in varchar2);
382
383 procedure CE_VALIDATE_BANK_CH(Xi_BANK_NUMBER in varchar2);
384
385
386 procedure CE_VALIDATE_BANK_GB(Xi_BANK_NUMBER in varchar2);
387
388
389 procedure CE_VALIDATE_BANK_CO(Xi_COUNTRY_NAME in varchar2,
390 Xi_BANK_NAME in varchar2,
391 Xi_TAX_PAYER_ID in varchar2);
392
393 -- new bank validations 10/19/04
394
395 procedure CE_VALIDATE_BANK_AU(Xi_BANK_NUMBER in varchar2);
396 procedure CE_VALIDATE_BANK_IL(Xi_BANK_NUMBER in varchar2,
397 Xi_PASS_MAND_CHECK in varchar2);
398 procedure CE_VALIDATE_BANK_NZ(Xi_BANK_NUMBER in varchar2,
399 Xi_PASS_MAND_CHECK in varchar2);
400
401 procedure CE_VALIDATE_BANK_JP(Xi_BANK_NUMBER in varchar2,
402 Xi_BANK_NAME_ALT in varchar2,
403 Xi_PASS_MAND_CHECK in varchar2,
404 Xi_VALIDATION_TYPE in varchar2);
405
406 -- added 10/25/04
407 /* --------------------------------------------------------------------
408 | PRIVATE PROCEDURE |
409 | CE_VALIDATE_MISC_* other misc validations
410 --------------------------------------------------------------------- */
411
412 procedure CE_VALIDATE_MISC_EFT_NUM(X_COUNTRY_NAME in varchar2,
413 X_EFT_NUMBER in varchar2,
414 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
415 x_msg_count OUT NOCOPY NUMBER,
416 x_msg_data OUT NOCOPY VARCHAR2,
417 x_return_status IN OUT NOCOPY VARCHAR2);
418
419 procedure CE_VALIDATE_MISC_ACCT_HLDR_ALT(X_COUNTRY_NAME in varchar2,
420 X_ACCOUNT_HOLDER_ALT in varchar2,
421 X_ACCOUNT_CLASSIFICATION in varchar2,
422 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
423 x_msg_count OUT NOCOPY NUMBER,
424 x_msg_data OUT NOCOPY VARCHAR2,
425 x_return_status IN OUT NOCOPY VARCHAR2);
426
427 END CE_VALIDATE_BANKINFO_UPG;