eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.CE_VALIDATE_BANKINFO

Source


1 PACKAGE CE_VALIDATE_BANKINFO AUTHID CURRENT_USER AS
2 /* $Header: cevlbnks.pls 120.26.12020000.5 2013/03/15 14:20:50 csutaria ship $ */
3 
4 l_DEBUG varchar2(1);
5 
6 FUNCTION CE_CHECK_NUMERIC(
7     CHECK_VALUE VARCHAR2,
8     POS_FROM    NUMBER,
9     POS_FOR     NUMBER
10 )RETURN VARCHAR2;
11 
12 FUNCTION CE_REMOVE_FORMATS(CHECK_VALUE VARCHAR2) RETURN VARCHAR2;
13 
14 PROCEDURE COMPARE_BANK_AND_BRANCH_NUM(
15     XI_BRANCH_NUM IN VARCHAR2,
16     XI_BANK_ID    IN NUMBER);
17 
18 FUNCTION COMPARE_ACCOUNT_NUM_AND_CD(
19     XI_ACCOUNT_NUM IN VARCHAR2,
20     XI_CD          IN NUMBER,
21     XI_CD_LENGTH   IN NUMBER,
22     XI_CD_POS_FROM_RIGHT IN NUMBER DEFAULT 0
23 ) RETURN BOOLEAN;
24 
25 -- Bug 10171134
26 FUNCTION CE_VAL_UNIQUE_TAX_PAYER_ID (
27     P_COUNTRY_CODE    IN  VARCHAR2,
28     P_TAXPAYER_ID     IN  VARCHAR2,
29     P_BANK_ID         IN varchar2
30 ) RETURN VARCHAR2;
31 
32 PROCEDURE CE_CHECK_CROSS_MODULE_TAX_ID(
33     P_COUNTRY_CODE     IN  VARCHAR2,
34     P_ENTITY_NAME      IN  VARCHAR2,
35     P_TAXPAYER_ID      IN  VARCHAR2,
36     P_RETURN_AR        OUT NOCOPY VARCHAR2,
37     P_RETURN_AP        OUT NOCOPY VARCHAR2,
38     P_RETURN_HR        OUT NOCOPY VARCHAR2,
39     P_RETURN_BK        OUT NOCOPY VARCHAR2);
40 
41 PROCEDURE CE_VALIDATE_BIC(
42     X_BIC_CODE       IN VARCHAR2,
43     P_INIT_MSG_LIST  IN VARCHAR2,
44     X_MSG_COUNT      OUT NOCOPY NUMBER,
45     X_MSG_DATA       OUT NOCOPY VARCHAR2,
46     X_RETURN_STATUS  IN OUT NOCOPY VARCHAR2);
47 
48 FUNCTION CE_TAX_ID_CHECK_ALGORITHM(
49     P_TAXPAYER_ID  IN VARCHAR2,
50     P_COUNTRY      IN VARCHAR2,
51     P_TAX_ID_CD    IN VARCHAR2
52 ) RETURN VARCHAR2;
53 
54 PROCEDURE CE_UNIQUE_BRANCH_NAME(
55     XI_COUNTRY_NAME IN VARCHAR2,
56     XI_BRANCH_NAME  IN VARCHAR2,
57     XI_BANK_ID      IN VARCHAR2,
58     XI_BRANCH_ID    IN VARCHAR2);
59 
60 PROCEDURE CE_UNIQUE_BRANCH_NUMBER(
61     XI_COUNTRY_NAME  IN VARCHAR2,
62     XI_BRANCH_NUMBER IN VARCHAR2,
63     XI_BANK_ID       IN VARCHAR2,
64     XI_BRANCH_ID     IN VARCHAR2);
65 
66 PROCEDURE CE_UNIQUE_BRANCH_NAME_ALT(
67     XI_COUNTRY_NAME     IN VARCHAR2,
68     XI_BRANCH_NAME_ALT  IN VARCHAR2,
69     XI_BANK_ID          IN VARCHAR2,
70     XI_BRANCH_ID        IN VARCHAR2);
71 
72 PROCEDURE CE_UNIQUE_ACCOUNT_NAME(
73     XI_ACCOUNT_NAME  IN VARCHAR2,
74     XI_BRANCH_ID     IN VARCHAR2,
75     XI_ACCOUNT_ID    IN VARCHAR2);
76 
77 /* --------------------------------------------------------------------
78 |  PRIVATE PROCEDURE                                                    |
79 |      CE_VALIDATE_*                                                    |
80  --------------------------------------------------------------------- */
81 PROCEDURE CE_VALIDATE_CD(
82     X_COUNTRY_NAME           IN VARCHAR2,
83     X_CD                     IN VARCHAR2,
84     X_BANK_NUMBER            IN VARCHAR2,
85     X_BRANCH_NUMBER          IN VARCHAR2,
86     X_ACCOUNT_NUMBER         IN VARCHAR2,
87     P_INIT_MSG_LIST          IN VARCHAR2,
88     X_MSG_COUNT              OUT NOCOPY NUMBER,
89     X_MSG_DATA               OUT NOCOPY VARCHAR2,
90     X_RETURN_STATUS          IN OUT NOCOPY VARCHAR2,
91     X_ACCOUNT_CLASSIFICATion IN VARCHAR2 DEFAULT NULL);
92 
93 PROCEDURE CE_VALIDATE_BRANCH(
94         X_COUNTRY_NAME            IN  VARCHAR2,
95         X_BANK_NUMBER             IN  VARCHAR2,
96         X_BRANCH_NUMBER           IN  VARCHAR2,
97         X_BANK_NAME               IN  VARCHAR2,
98         X_BRANCH_NAME             IN  VARCHAR2,
99         X_BRANCH_NAME_ALT         IN  VARCHAR2,
100         X_BANK_ID                 IN  NUMBER,
101         X_BRANCH_ID               IN  NUMBER,
102         P_INIT_MSG_LIST           IN  VARCHAR2,
103         X_MSG_COUNT               OUT NOCOPY NUMBER,
104         X_MSG_DATA                OUT NOCOPY VARCHAR2,
105         X_VALUE_OUT               OUT NOCOPY varchar2,
106         X_RETURN_STATUS           IN  OUT NOCOPY VARCHAR2,
107         X_ACCOUNT_CLASSIFICATION  IN  VARCHAR2 DEFAULT NULL,
108         X_BRANCH_TYPE             IN  VARCHAR2 DEFAULT NULL, -- 9218190 added
109         X_BRANCH_END_DATE         IN  DATE DEFAULT NULL); ---Bug 15958504
110 PROCEDURE CE_VALIDATE_ACCOUNT(
111         X_COUNTRY_NAME             IN VARCHAR2,
112         X_BANK_NUMBER              IN VARCHAR2,
113         X_BRANCH_NUMBER            IN VARCHAR2,
114         X_ACCOUNT_NUMBER           IN VARCHAR2,
115         X_BANK_ID                  IN NUMBER,
116         X_BRANCH_ID                IN NUMBER,
117         X_ACCOUNT_ID               IN NUMBER,
118         X_CURRENCY_CODE            IN VARCHAR2,
119         X_ACCOUNT_TYPE             IN VARCHAR2,
120         X_ACCOUNT_SUFFIX           IN VARCHAR2,
121         X_SECONDARY_ACCOUNT_REFERENCE    IN VARCHAR2,
122         X_ACCOUNT_NAME             IN VARCHAR2,
123         P_INIT_MSG_LIST            IN  VARCHAR2,
124         X_MSG_COUNT                OUT NOCOPY NUMBER,
125         X_MSG_DATA                 OUT NOCOPY VARCHAR2,
126         X_VALUE_OUT                OUT NOCOPY VARCHAR2,
127         X_RETURN_STATUS            IN OUT NOCOPY VARCHAR2,
128         X_ACCOUNT_CLASSIFICATION   IN VARCHAR2 DEFAULT NULL,
129         X_CD                       IN  VARCHAR2  DEFAULT NULL,
130         X_ELECTRONIC_ACCT_NUM      OUT NOCOPY VARCHAR2);
131 
132 PROCEDURE CE_VALIDATE_BANK(
133         X_COUNTRY_NAME           IN VARCHAR2,
134         X_BANK_NUMBER            IN VARCHAR2,
135         X_BANK_NAME              IN VARCHAR2,
136         X_BANK_NAME_ALT          IN VARCHAR2,
137         X_TAX_PAYER_ID           IN VARCHAR2,
138         X_BANK_ID                IN NUMBER,
139         p_init_msg_list          IN VARCHAR2,
140         x_msg_count              OUT NOCOPY NUMBER,
141         x_msg_data               OUT NOCOPY VARCHAR2,
142         X_VALUE_OUT              OUT NOCOPY Varchar2,
143         x_return_status          IN OUT NOCOPY VARCHAR2,
144         X_ACCOUNT_CLASSIFICATION IN VARCHAR2 DEFAULT NULL);
145 
146 /* --------------------------------------------------------------------
147 |  PRIVATE PROCEDURE                                                    |
148 |      CE_VALIDATE_CD_*                                                 |
149  --------------------------------------------------------------------- */
150 PROCEDURE CE_VALIDATE_CD_PT(
151     Xi_CD               VARCHAR2,
152     Xi_PASS_MAND_CHECK  VARCHAR2,
153     Xi_X_BANK_NUMBER    VARCHAR2,
154     Xi_X_BRANCH_NUMBER  VARCHAR2,
155     Xi_X_ACCOUNT_NUMBER VARCHAR2);
156 
157 PROCEDURE CE_VALIDATE_CD_ES(
158     Xi_CD               VARCHAR2,
159     Xi_PASS_MAND_CHECK  VARCHAR2,
160     Xi_X_BANK_NUMBER    VARCHAR2,
161     Xi_X_BRANCH_NUMBER  VARCHAR2,
162     Xi_X_ACCOUNT_NUMBER VARCHAR2);
163 
164 
165 PROCEDURE CE_VALIDATE_CD_FR(
166     Xi_CD               VARCHAR2,
167     Xi_PASS_MAND_CHECK  VARCHAR2,
168     Xi_X_BANK_NUMBER    VARCHAR2,
169     Xi_X_BRANCH_NUMBER  VARCHAR2,
170     Xi_X_ACCOUNT_NUMBER VARCHAR2);
171 
172 -- new validations for check digits 5/14/02
173 PROCEDURE CE_VALIDATE_CD_DE(
174     Xi_CD               IN VARCHAR2,
175     Xi_X_ACCOUNT_NUMBER IN VARCHAR2);
176 
177 PROCEDURE CE_VALIDATE_CD_GR(
178     Xi_CD               IN VARCHAR2,
179     Xi_PASS_MAND_CHECK  IN VARCHAR2,
180     Xi_X_BANK_NUMBER    IN VARCHAR2,
181     Xi_X_BRANCH_NUMBER  IN VARCHAR2,
182     Xi_X_ACCOUNT_NUMBER IN VARCHAR2);
183 
184 PROCEDURE CE_VALIDATE_CD_IS(
185     Xi_CD               IN VARCHAR2,
186     Xi_X_ACCOUNT_NUMBER IN VARCHAR2);
187 
188 PROCEDURE CE_VALIDATE_CD_IT(
189     Xi_CD               IN VARCHAR2,
190     Xi_PASS_MAND_CHECK  IN VARCHAR2,
191     Xi_X_BANK_NUMBER    IN VARCHAR2,
192     Xi_X_BRANCH_NUMBER  IN VARCHAR2,
193     Xi_X_ACCOUNT_NUMBER IN VARCHAR2);
194 
195 PROCEDURE CE_VALIDATE_CD_LU(
196     Xi_CD               IN VARCHAR2,
197     Xi_X_BANK_NUMBER    IN VARCHAR2,
198     Xi_X_BRANCH_NUMBER  IN VARCHAR2,
199     Xi_X_ACCOUNT_NUMBER IN VARCHAR2);
200 
201 PROCEDURE CE_VALIDATE_CD_SE(
202     Xi_CD               IN VARCHAR2,
203     Xi_X_ACCOUNT_NUMBER IN VARCHAR2);
204 
205 -- 9249372: Added ce_validate_cd_fi
206 PROCEDURE CE_VALIDATE_CD_FI(
207     Xi_CD               IN VARCHAR2,
208     Xi_X_BRANCH_NUMBER  IN VARCHAR2,
209     Xi_X_ACCOUNT_NUMBER IN VARCHAR2);
210 
211 /* --------------------------------------------------------------------
212 |  PRIVATE PROCEDURE                                                    |
213 |      CE_VALIDATE_BRANCH_*                                             |
214  --------------------------------------------------------------------- */
215 PROCEDURE CE_VALIDATE_BRANCH_AT(
216     Xi_BRANCH_NUMBER    VARCHAR2,
217     Xi_PASS_MAND_CHECK  VARCHAR2,
218     Xo_VALUE_OUT        OUT NOCOPY VARCHAR2);
219 
220 PROCEDURE CE_VALIDATE_BRANCH_PT(
221     Xi_BRANCH_NUMBER    VARCHAR2,
222     Xi_PASS_MAND_CHECK  VARCHAR2);
223 
224 PROCEDURE CE_VALIDATE_BRANCH_FR(
225     Xi_BRANCH_NUMBER    VARCHAR2,
226     Xi_PASS_MAND_CHECK  VARCHAR2,
227     Xo_VALUE_OUT        OUT NOCOPY VARCHAR2);
228 
229 PROCEDURE CE_VALIDATE_BRANCH_ES(
230     Xi_BRANCH_NUMBER    VARCHAR2,
231     Xi_PASS_MAND_CHECK  VARCHAR2,
232     Xo_VALUE_OUT        OUT NOCOPY varchar2);
233 
234 PROCEDURE CE_VALIDATE_BRANCH_BR(
235     Xi_BRANCH_NUMBER    VARCHAR2,
236     Xi_PASS_MAND_CHECK  VARCHAR2,
237     Xo_VALUE_OUT        OUT NOCOPY varchar2);
238 
239 -- new branch validations 5/14/02
240 PROCEDURE CE_VALIDATE_BRANCH_DE(
241     Xi_BRANCH_NUMBER  IN VARCHAR2,
242     Xi_BANK_ID        IN NUMBER);
243 
244 PROCEDURE CE_VALIDATE_BRANCH_GR(Xi_BRANCH_NUMBER IN VARCHAR2);
245 
246 PROCEDURE CE_VALIDATE_BRANCH_IS(
247     Xi_BRANCH_NUMBER  IN VARCHAR2,
248     Xi_BANK_ID        IN NUMBER,
249     Xo_VALUE_OUT      OUT NOCOPY VARCHAR2);
250 
251 PROCEDURE CE_VALIDATE_BRANCH_IE(
252     Xi_BRANCH_NUMBER  IN VARCHAR2,
253     Xi_BANK_ID        IN NUMBER);
254 
255 PROCEDURE CE_VALIDATE_BRANCH_IT(
256     Xi_BRANCH_NUMBER   IN VARCHAR2,
257     Xi_PASS_MAND_CHECK IN VARCHAR2);
258 
259 PROCEDURE CE_VALIDATE_BRANCH_LU(
260     Xi_BRANCH_NUMBER  IN VARCHAR2,
261     Xi_BANK_ID        IN NUMBER);
262 
263 PROCEDURE CE_VALIDATE_BRANCH_PL(
264     Xi_BRANCH_NUMBER  IN VARCHAR2,
265     Xi_BANK_ID        IN NUMBER);
266 
267 PROCEDURE CE_VALIDATE_BRANCH_SE(
268     Xi_BRANCH_NUMBER  IN VARCHAR2,
269     Xi_BANK_ID        IN NUMBER);
270 
271 PROCEDURE CE_VALIDATE_BRANCH_CH(
272     Xi_BRANCH_NUMBER  IN varchar2,
273     Xi_BANK_ID        IN NUMBER);
274 
275 PROCEDURE CE_VALIDATE_BRANCH_GB(
276     Xi_BRANCH_NUMBER  IN VARCHAR2,
277     Xi_BANK_ID        IN NUMBER);
278 
279 PROCEDURE CE_VALIDATE_BRANCH_US(
280     Xi_BRANCH_NUMBER    IN VARCHAR2,
281     Xi_PASS_MAND_CHECK  IN VARCHAR2,
282     Xo_VALUE_OUT        OUT NOCOPY VARCHAR2);
283 
284 -- new branch validations 10/19/04
285 PROCEDURE CE_VALIDATE_BRANCH_AU(
286     Xi_BRANCH_NUMBER    IN VARCHAR2,
287     Xi_BANK_ID          IN NUMBER,
288     Xi_PASS_MAND_CHECK  VARCHAR2);
289 
290 PROCEDURE CE_VALIDATE_BRANCH_IL(
291     Xi_BRANCH_NUMBER    IN VARCHAR2,
292     Xi_PASS_MAND_CHECK  VARCHAR2);
293 
294 PROCEDURE CE_VALIDATE_BRANCH_NZ(
295     Xi_BRANCH_NUMBER    IN VARCHAR2,
296     Xi_PASS_MAND_CHECK  VARCHAR2);
297 
298 PROCEDURE CE_VALIDATE_BRANCH_JP(
299     Xi_BRANCH_NUMBER    IN VARCHAR2,
300     Xi_BRANCH_NAME_ALT  IN VARCHAR2,
301     Xi_PASS_MAND_CHECK  VARCHAR2);
302 
303 -- 9249372: Added ce_validate_branch_fi
304 PROCEDURE CE_VALIDATE_BRANCH_FI(Xi_BRANCH_NUMBER IN VARCHAR2);
305 
306 /* --------------------------------------------------------------------
307 |  PRIVATE PROCEDURE                                                    |
308 |      CE_VALIDATE_ACCOUNT_*                                            |
309  --------------------------------------------------------------------- */
313     Xo_VALUE_OUT        OUT NOCOPY varchar2);
310 PROCEDURE CE_VALIDATE_ACCOUNT_AT(
311     Xi_ACCOUNT_NUMBER   VARCHAR2,
312     Xi_PASS_MAND_CHECK  VARCHAR2,
314 
315 PROCEDURE CE_VALIDATE_ACCOUNT_PT(
316     Xi_ACCOUNT_NUMBER   VARCHAR2,
317     Xi_PASS_MAND_CHECK  VARCHAR2,
318     Xo_VALUE_OUT        OUT NOCOPY varchar2);
319 
320 PROCEDURE CE_VALIDATE_ACCOUNT_BE(
321     Xi_ACCOUNT_NUMBER   VARCHAR2,
322     Xi_PASS_MAND_CHECK  VARCHAR2);
323 
324 PROCEDURE CE_VALIDATE_ACCOUNT_DK(
325     Xi_ACCOUNT_NUMBER   VARCHAR2,
326     Xi_PASS_MAND_CHECK  VARCHAR2,
327     Xo_VALUE_OUT        OUT NOCOPY varchar2);
328 
329 PROCEDURE CE_VALIDATE_ACCOUNT_FR(
330     Xi_ACCOUNT_NUMBER   VARCHAR2,
331     Xi_PASS_MAND_CHECK  VARCHAR2,
332     Xo_VALUE_OUT        OUT NOCOPY VARCHAR2);
333 
334 PROCEDURE CE_VALIDATE_ACCOUNT_NL(
335     Xi_ACCOUNT_NUMBER   VARCHAR2,
336     Xi_PASS_MAND_CHECK  VARCHAR2);
337 
338 PROCEDURE CE_VALIDATE_ACCOUNT_ES(
339     Xi_ACCOUNT_NUMBER   VARCHAR2,
340     Xi_PASS_MAND_CHECK  VARCHAR2,
341     Xo_VALUE_OUT        OUT NOCOPY VARCHAR2);
342 
343 PROCEDURE CE_VALIDATE_ACCOUNT_NO(
344     Xi_ACCOUNT_NUMBER   VARCHAR2,
345     Xi_PASS_MAND_CHECK  VARCHAR2);
346 
347 PROCEDURE CE_VALIDATE_ACCOUNT_FI(
348     Xi_ACCOUNT_NUMBER   VARCHAR2,
349     Xi_PASS_MAND_CHECK  VARCHAR2);
350 
351 -- new account validations 5/14/02
352 PROCEDURE CE_VALIDATE_ACCOUNT_DE(
353     Xi_ACCOUNT_NUMBER   IN VARCHAR2,
354     Xo_VALUE_OUT        OUT NOCOPY VARCHAR2);
355 
356 PROCEDURE CE_VALIDATE_ACCOUNT_GR(
357     Xi_ACCOUNT_NUMBER   IN VARCHAR2,
358     Xo_VALUE_OUT        OUT NOCOPY VARCHAR2);
359 
360 PROCEDURE CE_VALIDATE_ACCOUNT_IS(
361     Xi_ACCOUNT_NUMBER   IN VARCHAR2,
362     Xo_VALUE_OUT        OUT NOCOPY VARCHAR2);
363 
364 PROCEDURE CE_VALIDATE_ACCOUNT_IE(
365     Xi_ACCOUNT_NUMBER  IN VARCHAR2);
366 
367 PROCEDURE CE_VALIDATE_ACCOUNT_IT(
368     Xi_ACCOUNT_NUMBER   IN VARCHAR2,
369     Xo_VALUE_OUT        OUT NOCOPY VARCHAR2);
370 
371 PROCEDURE CE_VALIDATE_ACCOUNT_LU(Xi_ACCOUNT_NUMBER IN VARCHAR2);
372 
373 PROCEDURE CE_VALIDATE_ACCOUNT_PL(Xi_ACCOUNT_NUMBER IN VARCHAR2);
374 
375 PROCEDURE CE_VALIDATE_ACCOUNT_SE(Xi_ACCOUNT_NUMBER IN VARCHAR2);
376 
377 PROCEDURE CE_VALIDATE_ACCOUNT_CH(
378     Xi_ACCOUNT_NUMBER  IN VARCHAR2,
379     Xi_ACCOUNT_TYPE    IN VARCHAR2);
380 
381 PROCEDURE CE_VALIDATE_ACCOUNT_GB(
382     Xi_ACCOUNT_NUMBER   IN VARCHAR2,
383     Xi_BRANCH_NUMBER    IN VARCHAR2 default null,  ---Bug 16234978, 16468593
384     Xo_VALUE_OUT        OUT NOCOPY VARCHAR2);
385 
386 PROCEDURE CE_VALIDATE_ACCOUNT_BR(
387     Xi_ACCOUNT_NUMBER               IN VARCHAR2,
388     Xi_SECONDARY_ACCOUNT_REFERENCE  IN VARCHAR2);
389 
390 -- new account validations 10/19/04 Bug 6760446 added currency code
391 PROCEDURE CE_VALIDATE_ACCOUNT_AU(
392     Xi_ACCOUNT_NUMBER   IN VARCHAR2,
393     Xi_CURRENCY_CODE    IN VARCHAR2);
394 
395 PROCEDURE CE_VALIDATE_ACCOUNT_IL(Xi_ACCOUNT_NUMBER IN VARCHAR2);
396 
397 PROCEDURE CE_VALIDATE_ACCOUNT_NZ(
398     Xi_ACCOUNT_NUMBER  IN VARCHAR2,
399     Xi_ACCOUNT_SUFFIX  IN VARCHAR2);
400 
401 PROCEDURE CE_VALIDATE_ACCOUNT_JP(
402     Xi_ACCOUNT_NUMBER  IN VARCHAR2,
403     Xi_ACCOUNT_TYPE    IN VARCHAR2);
404 
405 /* --------------------------------------------------------------------
406 |  PRIVATE PROCEDURE                                                    |
407 |      CE_VALIDATE_BANK_*                                               |
408  --------------------------------------------------------------------- */
409 PROCEDURE CE_VALIDATE_BANK_ES(
410     Xi_BANK_NUMBER      VARCHAR2,
411     Xi_PASS_MAND_CHECK  VARCHAR2,
412     Xo_VALUE_OUT        OUT NOCOPY VARCHAR2);
413 
414 PROCEDURE CE_VALIDATE_BANK_FR(
415     Xi_BANK_NUMBER      VARCHAR2,
416     Xi_PASS_MAND_CHECK  VARCHAR2,
417     Xo_VALUE_OUT        OUT NOCOPY VARCHAR2);
418 
419 PROCEDURE CE_VALIDATE_BANK_PT(
420     Xi_BANK_NUMBER      VARCHAR2,
421     Xi_PASS_MAND_CHECK  VARCHAR2);
422 
423 
424 PROCEDURE CE_VALIDATE_BANK_BR(
425     Xi_BANK_NUMBER      VARCHAR2,
426     Xi_PASS_MAND_CHECK  VARCHAR2,
427     Xo_VALUE_OUT        OUT NOCOPY VARCHAR2);
428 
429 -- new bank validations 5/14/02
430 PROCEDURE CE_VALIDATE_BANK_DE(Xi_BANK_NUMBER IN VARCHAR2);
431 
432 PROCEDURE CE_VALIDATE_BANK_GR(Xi_BANK_NUMBER IN VARCHAR2);
433 
434 PROCEDURE CE_VALIDATE_BANK_IS(
435     Xi_BANK_NUMBER  IN VARCHAR2,
436     Xo_VALUE_OUT    OUT NOCOPY VARCHAR2);
437 
438 PROCEDURE CE_VALIDATE_BANK_IE(Xi_BANK_NUMBER IN VARCHAR2);
439 
440 PROCEDURE CE_VALIDATE_BANK_IT(
441     Xi_BANK_NUMBER      IN VARCHAR2,
442     Xi_PASS_MAND_CHECK  IN VARCHAR2);
443 
444 PROCEDURE CE_VALIDATE_BANK_LU(Xi_BANK_NUMBER IN VARCHAR2);
445 
446 PROCEDURE CE_VALIDATE_BANK_PL(Xi_BANK_NUMBER IN VARCHAR2);
447 
448 PROCEDURE CE_VALIDATE_BANK_SE(Xi_BANK_NUMBER IN VARCHAR2);
449 
450 PROCEDURE CE_VALIDATE_BANK_CH(Xi_BANK_NUMBER IN VARCHAR2);
451 
452 PROCEDURE CE_VALIDATE_BANK_GB(Xi_BANK_NUMBER IN VARCHAR2);
453 
454 -- Bug 10171134
455 PROCEDURE CE_VALIDATE_BANK_CO(
456     Xi_COUNTRY_NAME IN VARCHAR2,
457     Xi_BANK_NAME    IN VARCHAR2,
458     Xi_TAX_PAYER_ID IN VARCHAR2,
459     Xi_BANK_ID      IN VARCHAR2);
460 
461 -- new bank validations 10/19/04
462 PROCEDURE CE_VALIDATE_BANK_AU(
463     Xi_BANK_NUMBER  in varchar2);
464 
465 PROCEDURE CE_VALIDATE_BANK_IL(
466     Xi_BANK_NUMBER      IN VARCHAR2,
467     Xi_PASS_MAND_CHECK  IN VARCHAR2);
468 
469 PROCEDURE CE_VALIDATE_BANK_NZ(
470     Xi_BANK_NUMBER      IN VARCHAR2,
474     Xi_BANK_NUMBER      IN VARCHAR2,
471     Xi_PASS_MAND_CHECK  IN VARCHAR2);
472 
473 PROCEDURE CE_VALIDATE_BANK_JP(
475     Xi_BANK_NAME_ALT    IN VARCHAR2,
476     Xi_PASS_MAND_CHECK  IN VARCHAR2);
477 
478 -- 8266356: Added
479 PROCEDURE CE_VALIDATE_BANK_AT(
480     Xi_BANK_NUMBER      VARCHAR2,
481     Xi_PASS_MAND_CHECK  VARCHAR2,
482     Xo_VALUE_OUT        OUT NOCOPY varchar2);
483 
484 /* --------------------------------------------------------------------
485 |  PRIVATE PROCEDURE                                                    |
486 |      CE_VALIDATE_UNIQUE_ACCOUNT_*                                     |
487  --------------------------------------------------------------------- */
488 PROCEDURE CE_VALIDATE_UNIQUE_ACCOUNT(
489     Xi_ACCOUNT_NUMBER   IN VARCHAR2,
490     Xi_CURRENCY_CODE    IN VARCHAR2,
491     Xi_ACCOUNT_NAME     IN VARCHAR2,
492     Xi_BRANCH_ID        IN NUMBER,
493     Xi_ACCOUNT_ID       IN NUMBER);
494 
495 PROCEDURE CE_VALIDATE_UNIQUE_ACCOUNT_JP(
496     Xi_ACCOUNT_NUMBER   IN VARCHAR2,
497     Xi_CURRENCY_CODE    IN VARCHAR2,
498     Xi_ACCOUNT_TYPE     IN VARCHAR2,
499     Xi_ACCOUNT_NAME     IN VARCHAR2,
500     Xi_BRANCH_ID        IN NUMBER,
501     Xi_ACCOUNT_ID       IN NUMBER);
502 
503 PROCEDURE CE_VALIDATE_UNIQUE_ACCOUNT_NZ(
504     Xi_ACCOUNT_NUMBER   IN VARCHAR2,
505     Xi_CURRENCY_CODE    IN VARCHAR2,
506     Xi_ACCOUNT_SUFFIX   IN VARCHAR2,
507     Xi_ACCOUNT_NAME     IN VARCHAR2,
508     Xi_BRANCH_ID        IN NUMBER,
509     Xi_ACCOUNT_ID       IN NUMBER);
510 
511 /* ---------------------------------------------------------------------
512 |  PUBLIC PROCEDURE                                                     |
513 |   CE_FORMAT_ELECTRONIC_NUM                                            |
514 |    Description:  Format CE_BANK_ACCOUNTS.BANK_ACCOUNT_NUM_ELECTRONIC  |
515 |    CALLED BY:    CE_VALIDATE_ACCOUNT                                  |
516 |    Calls:        CE_FORMAT_ELECTRONIC_NUM_*                           |
517  --------------------------------------------------------------------- */
518 PROCEDURE CE_FORMAT_ELECTRONIC_NUM(
519     X_COUNTRY_NAME              IN VARCHAR2,
520     X_BANK_NUMBER               IN VARCHAR2,
521     X_BRANCH_NUMBER             IN VARCHAR2,
522     X_ACCOUNT_NUMBER            IN VARCHAR2,
523     X_CD                        IN  VARCHAR2  DEFAULT NULL,
524     X_ACCOUNT_SUFFIX            IN VARCHAR2,
525     X_SECONDARY_ACCOUNT_REFERENCE  IN varchar2,
526     X_ACCOUNT_CLASSIFICATION    IN VARCHAR2 DEFAULT NULL,
527     X_ELECTRONIC_ACCT_NUM       OUT NOCOPY varchar2,
528     p_init_msg_list             IN VARCHAR2,
529     x_msg_count                 OUT NOCOPY NUMBER,
530     x_msg_data                  OUT NOCOPY VARCHAR2,
531     x_return_status             IN OUT NOCOPY VARCHAR2);
532 
533 /* --------------------------------------------------------------------
534 |  PRIVATE PROCEDURE                                                    |
535 |      CE_VALIDATE_UNIQUE_BRANCH_*                                      |
536  --------------------------------------------------------------------- */
537 PROCEDURE CE_VALIDATE_UNIQUE_BRANCH(
538     Xi_COUNTRY_NAME   IN VARCHAR2,
539     Xi_BRANCH_NUMBER  IN VARCHAR2,
540     Xi_BRANCH_NAME    IN VARCHAR2,
541     Xi_BANK_ID        IN NUMBER,
542     Xi_BRANCH_ID      IN NUMBER);
543 
544 PROCEDURE CE_VALIDATE_UNIQUE_BRANCH_JP(
545     Xi_COUNTRY_NAME    IN VARCHAR2,
546     Xi_BRANCH_NUMBER   IN VARCHAR2,
547     Xi_BRANCH_NAME     IN VARCHAR2,
548     Xi_BRANCH_NAME_ALT IN VARCHAR2,
549     Xi_BANK_ID         IN NUMBER,
550     Xi_BRANCH_ID       IN NUMBER);
551 
552 PROCEDURE CE_VALIDATE_UNIQUE_BRANCH_DE(
553     Xi_BRANCH_NUMBER    IN VARCHAR2,
554     Xi_BRANCH_NAME      IN VARCHAR2,
555     Xi_BANK_ID          IN NUMBER,
556     Xi_BRANCH_ID        IN NUMBER);
557 
558 PROCEDURE CE_VALIDATE_UNIQUE_BRANCH_US(
559     Xi_BRANCH_NUMBER    IN VARCHAR2,
560     Xi_BRANCH_NAME      IN VARCHAR2,
561     Xi_BANK_ID          IN NUMBER,
562     Xi_BRANCH_ID        IN NUMBER);
563 
564 /* --------------------------------------------------------------------
565 |  PRIVATE PROCEDURE                                                    |
566 |      CE_VALIDATE_UNIQUE_BANK_*                                        |
567  --------------------------------------------------------------------- */
568 PROCEDURE CE_VALIDATE_UNIQUE_BANK_JP(
569     Xi_COUNTRY_NAME     IN VARCHAR2,
570     Xi_BANK_NUMBER      IN VARCHAR2,
571     Xi_BANK_NAME        IN VARCHAR2,
572     Xi_BANK_NAME_ALT    IN VARCHAR2,
573     Xi_BANK_ID          IN VARCHAR2);
574 
575 -- added 10/25/04
576 /* --------------------------------------------------------------------
577 |  PRIVATE PROCEDURE                                                    |
578 |      CE_VALIDATE_MISC_*   other misc validations
579  --------------------------------------------------------------------- */
580 PROCEDURE CE_VALIDATE_MISC_EFT_NUM(
581     X_COUNTRY_NAME  IN VARCHAR2,
582     X_EFT_NUMBER    IN VARCHAR2,
583     P_INIT_MSG_LIST IN VARCHAR2,
584     X_MSG_COUNT     OUT NOCOPY NUMBER,
585     X_MSG_DATA      OUT NOCOPY VARCHAR2,
586     X_RETURN_STATUS IN OUT NOCOPY VARCHAR2);
587 
588 PROCEDURE CE_VALIDATE_MISC_ACCT_HLDR_ALT(
589     X_COUNTRY_NAME          IN VARCHAR2,
590     X_ACCOUNT_HOLDER_ALT    IN VARCHAR2,
591     X_ACCOUNT_CLASSIFICATION    IN VARCHAR2,
592     P_INIT_MSG_LIST         IN VARCHAR2,
593     X_MSG_COUNT             OUT NOCOPY NUMBER,
594     X_MSG_DATA              OUT NOCOPY VARCHAR2,
595     X_RETURN_STATUS         IN OUT NOCOPY VARCHAR2);
596 
597 -- added 12/18/06
598 PROCEDURE CE_VALIDATE_BRANCH_IS_FORMAT(
599     Xi_BRANCH_NUMBER    IN VARCHAR2,
600     Xo_VALUE_OUT        OUT NOCOPY VARCHAR2);
601 
605     X_VALUE_OUT      OUT NOCOPY VARCHAR2,
602 PROCEDURE GET_BRANCH_NUM_FORMAT(
603     X_COUNTRY_NAME   IN VARCHAR2,
604     X_BRANCH_NUMBER  IN VARCHAR2,
606     P_INIT_MSG_LIST  IN VARCHAR2,
607     X_MSG_COUNT      OUT NOCOPY NUMBER,
608     X_MSG_DATA       OUT NOCOPY VARCHAR2,
609     X_RETURN_STATUS  IN OUT NOCOPY VARCHAR2);
610 
611 -- Bug 6856840: Added wrapper procedure for Branch Validations
612 PROCEDURE CE_VALIDATE_BRANCH_BANK (
613     Xi_COUNTRY     IN varchar2,
614     Xi_BRANCH_NUM  IN varchar2,
615     Xi_BANK_NUM    IN varchar2,
616     Xo_VALUE_OUT   OUT NOCOPY varchar2);
617 
618 /* 7582842: The following procedures are no longer used by CE:
619     1) UPD_BANK_UNIQUE
620     2) UPD_BANK_VALIDATE
621     3) UPD_BRANCH_UNIQUE
622     4) UPD_BRANCH_VALIDATE
623     5) UPD_ACCOUNT_UNIQUE
624     6) UPD_ACCOUNT_VALIDATE
625    But, these have been retained due to possible dependencies in IBY */
626 
627 /* -------------------------------------------------------------------
628 |  PUBLIC PROCEDURE                                                   |
629 |   UPD_ACCOUNT_UNIQUE                                                |
630 |    Description:  Bank Account uniqueness validation                 |
631 |    Usage: Bug 7582842 - No longer called by CE                      |
632 |    Calls:        CE_VALIDATE_UNIQUE_ACCOUNT_*                       |
633  --------------------------------------------------------------------*/
634 PROCEDURE UPD_ACCOUNT_UNIQUE(
635         X_COUNTRY_NAME    IN varchar2,
636         X_BANK_NUMBER     IN varchar2,
637         X_BRANCH_NUMBER   IN varchar2,
638         X_ACCOUNT_NUMBER  IN varchar2,
639         X_BANK_ID         IN number,
640         X_BRANCH_ID       IN number,
641         X_ACCOUNT_ID      IN number,
642         X_CURRENCY_CODE   IN varchar2,
643         X_ACCOUNT_TYPE    IN varchar2,
644         X_ACCOUNT_SUFFIX  IN varchar2,
645         X_SECONDARY_ACCOUNT_REFERENCE  IN varchar2,
646         X_ACCOUNT_NAME    IN varchar2,
647         p_init_msg_list   IN VARCHAR2,
648         x_msg_count       OUT NOCOPY NUMBER,
649         x_msg_data        OUT NOCOPY VARCHAR2,
650         X_VALUE_OUT       OUT NOCOPY varchar2,
651         x_return_status   IN OUT NOCOPY VARCHAR2,
652         X_ACCOUNT_CLASSIFICATION IN VARCHAR2 DEFAULT NULL);
653 
654 /* -------------------------------------------------------------------
655 |  PUBLIC PROCEDURE                                                   |
656 |   UPD_ACCOUNT_VALIDATE                                              |
657 |    Description:  Country specific Bank Account validation           |
658 |                  that does not include the uniqueness validations   |
659 |    Usage: Bug 7582842 - No longer called by CE                      |
660 |    Calls: CE_VALIDATE_ACCOUNT_*                                     |
661  --------------------------------------------------------------------*/
662 PROCEDURE UPD_ACCOUNT_VALIDATE(
663         X_COUNTRY_NAME              IN varchar2,
664         X_BANK_NUMBER               IN varchar2,
665         X_BRANCH_NUMBER             IN varchar2,
666         X_ACCOUNT_NUMBER            IN varchar2,
667         X_BANK_ID                   IN number,
668         X_BRANCH_ID                 IN number,
669         X_ACCOUNT_ID                IN number,
670         X_CURRENCY_CODE             IN varchar2,
671         X_ACCOUNT_TYPE              IN varchar2,
672         X_ACCOUNT_SUFFIX            IN varchar2,
673         X_SECONDARY_ACCOUNT_REFERENCE  IN varchar2,
674         X_ACCOUNT_NAME              IN VARCHAR2,
675         p_init_msg_list             IN  VARCHAR2,
676         x_msg_count                 OUT NOCOPY NUMBER,
677         x_msg_data                  OUT NOCOPY VARCHAR2,
678         X_VALUE_OUT                 OUT NOCOPY varchar2,
679         x_return_status             IN OUT NOCOPY VARCHAR2,
680         X_ACCOUNT_CLASSIFICATION    IN VARCHAR2 DEFAULT NULL,
681         X_CD                        IN  varchar2  DEFAULT NULL,
682         X_ELECTRONIC_ACCT_NUM       OUT NOCOPY varchar2);
683 
684 /* -------------------------------------------------------------------
685 |  PUBLIC PROCEDURE                                                   |
686 |   UPD_BRANCH_UNIQUE                                                 |
687 |    Description:  Branch uniqueness validation                       |
688 |    Usage:        Bug 7582842 - No longer called by CE               |
689 |    Calls:        CE_VALIDATE_UNIQUE_BRANCH_*                        |
690  ------------------------------------------------------------------- */
691 PROCEDURE UPD_BRANCH_UNIQUE(
692         X_COUNTRY_NAME     IN  varchar2,
693         X_BANK_NUMBER      IN  varchar2,
694         X_BRANCH_NUMBER    IN  varchar2,
695         X_BANK_NAME        IN  varchar2,
696         X_BRANCH_NAME      IN  varchar2,
697         X_BRANCH_NAME_ALT  IN  varchar2,
698         X_BANK_ID          IN  NUMBER,
699         X_BRANCH_ID        IN  NUMBER,
700         p_init_msg_list    IN  VARCHAR2,
701         x_msg_count        OUT NOCOPY NUMBER,
702         x_msg_data         OUT NOCOPY VARCHAR2,
703         X_VALUE_OUT        OUT NOCOPY varchar2,
704         x_return_status    IN OUT NOCOPY VARCHAR2,
705         X_ACCOUNT_CLASSIFICATION IN VARCHAR2 DEFAULT NULL);
706 
707 /* -------------------------------------------------------------------
708 |  PUBLIC PROCEDURE                                                   |
709 |   UPD_BRANCH_VALIDATE                                               |
710 |    Description:  Country specific Branch validation                 |
711 |                  that does not include the uniqueness validation    |
712 |    Usage:        Bug 7582842 - No longer called by CE               |
713 |    Calls:        CE_VALIDATE_BRANCH_*                               |
714  --------------------------------------------------------------------*/
715 PROCEDURE UPD_BRANCH_VALIDATE(
719         X_BANK_NAME        IN  VARCHAR2,
716         X_COUNTRY_NAME     IN  VARCHAR2,
717         X_BANK_NUMBER      IN  VARCHAR2,
718         X_BRANCH_NUMBER    IN  VARCHAR2,
720         X_BRANCH_NAME      IN  VARCHAR2,
721         X_BRANCH_NAME_ALT  IN  VARCHAR2,
722         X_BANK_ID          IN  NUMBER,
723         X_BRANCH_ID        IN  NUMBER,
724         p_init_msg_list    IN  VARCHAR2,
725         x_msg_count       OUT NOCOPY NUMBER,
726         x_msg_data        OUT NOCOPY VARCHAR2,
727         X_VALUE_OUT       OUT NOCOPY VARCHAR2,
728         x_return_status   IN OUT NOCOPY VARCHAR2,
729         X_ACCOUNT_CLASSIFICATION IN VARCHAR2 DEFAULT NULL,
730         X_BRANCH_TYPE IN VARCHAR2 DEFAULT NULL); -- 9218190 added
731 
732 /* -------------------------------------------------------------------
733 |  PUBLIC PROCEDURE                                                   |
734 |   UPD_BANK_UNIQUE                                                   |
735 |    Description:  Bank uniqueness validation                         |
736 |    Usage:        Bug 7582842 - No longer called by CE               |
737 |    Calls:        CE_VALIDATE_UNIQUE_BANK_*                          |
738  --------------------------------------------------------------------*/
739 PROCEDURE UPD_BANK_UNIQUE(
740         X_COUNTRY_NAME    IN varchar2,
741         X_BANK_NUMBER     IN varchar2,
742         X_BANK_NAME       IN varchar2,
743         X_BANK_NAME_ALT   IN varchar2,
744         X_TAX_PAYER_ID    IN varchar2,
745         X_BANK_ID         IN NUMBER,
746         p_init_msg_list   IN VARCHAR2,
747         x_msg_count      OUT NOCOPY NUMBER,
748         x_msg_data       OUT NOCOPY VARCHAR2,
749         X_VALUE_OUT      OUT NOCOPY varchar2,
750         x_return_status     IN OUT NOCOPY VARCHAR2,
751         X_ACCOUNT_CLASSIFICATION IN VARCHAR2 DEFAULT NULL);
752 
753 
754 /* -------------------------------------------------------------------
755 |  PUBLIC PROCEDURE                                                   |
756 |   UPD_BANK_VALIDATE                                                 |
757 |    Description:  Country specific Bank validation that does not     |
758 |                  include the uniqueness validations                 |
759 |    Usage:        Bug 7582842 - No longer called by CE               |
760 |    Calls:        CE_VALIDATE_BANK_*                                 |
761  --------------------------------------------------------------------*/
762 PROCEDURE UPD_BANK_VALIDATE(
763     X_COUNTRY_NAME    IN varchar2,
764     X_BANK_NUMBER     IN varchar2,
765     X_BANK_NAME       IN varchar2,
766     X_BANK_NAME_ALT   IN varchar2,
767     X_TAX_PAYER_ID    IN varchar2,
768     X_BANK_ID         IN NUMBER,
769     p_init_msg_list   IN VARCHAR2,
770     x_msg_count      OUT NOCOPY NUMBER,
771     x_msg_data       OUT NOCOPY VARCHAR2,
772     X_VALUE_OUT      OUT NOCOPY varchar2,
773     x_return_status   IN OUT NOCOPY VARCHAR2,
774     X_ACCOUNT_CLASSIFICATION IN VARCHAR2 DEFAULT NULL);
775 
776 /* 10172325 - Validation wrapper functions added for Migration validation */
777 FUNCTION is_IBAN_valid (p_in_IBAN IN VARCHAR2) RETURN VARCHAR2;
778 FUNCTION is_BIC_valid  (p_in_BIC  IN VARCHAR2) RETURN VARCHAR2;
779 
780 /* Bug 16234978 */
781 /* -------------------------------------------------------------------
782 |  PUBLIC PROCEDURE                                                   |
783 |    CE_VALIDATE_MOD_GB                                               |
784 |    Description:  Modulus check validation for UK Bank account       |
785 |                  numbers.                                           |
786 |    Called by  :  CE_VALIDATE_ACCOUNT_GB                             |
787  --------------------------------------------------------------------*/
788 procedure CE_VALIDATE_MOD_GB(Xi_ACCOUNT_NUMBER IN VARCHAR2,
789                              Xi_SORT_CODE      IN VARCHAR2,
790                              Xo_RETURN_STATUS  OUT NOCOPY VARCHAR2);
791 
792 END CE_VALIDATE_BANKINFO;