[Home] [Help]
PACKAGE: APPS.CE_VALIDATE_BANKINFO
Source
1 PACKAGE CE_VALIDATE_BANKINFO AS
2 /* $Header: cevlbnks.pls 120.18 2008/02/29 11:52:42 vnetan ship $ */
3
4 l_DEBUG varchar2(1);
5
6 FUNCTION ce_check_numeric(check_value VARCHAR2,
7 pos_from NUMBER,
8 pos_for NUMBER ) RETURN VARCHAR2;
9
10 function ce_remove_formats(check_value VARCHAR2)
11 RETURN VARCHAR2;
12
13
14 PROCEDURE COMPARE_BANK_AND_BRANCH_NUM(Xi_branch_num IN VARCHAR2,
15 Xi_BANK_ID IN NUMBER);
16
17 FUNCTION COMPARE_ACCOUNT_NUM_AND_CD(Xi_account_num IN VARCHAR2,
18 Xi_CD IN NUMBER,
19 Xi_CD_length in number,
20 Xi_CD_pos_from_right IN Number default 0) RETURN BOOLEAN;
21
22
23 FUNCTION CE_VAL_UNIQUE_TAX_PAYER_ID (p_country_code IN VARCHAR2,
24 p_taxpayer_id IN VARCHAR2
25 ) RETURN VARCHAR2;
26
27 PROCEDURE ce_check_cross_module_tax_id(p_country_code IN VARCHAR2,
28 p_entity_name IN VARCHAR2,
29 p_taxpayer_id IN VARCHAR2,
30 p_return_ar OUT NOCOPY VARCHAR2,
31 p_return_ap OUT NOCOPY VARCHAR2,
32 p_return_hr OUT NOCOPY VARCHAR2,
33 p_return_bk OUT NOCOPY VARCHAR2);
34
35 PROCEDURE CE_VALIDATE_BIC( X_BIC_CODE IN varchar2,
36 p_init_msg_list IN VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2,
39 x_return_status IN OUT NOCOPY VARCHAR2
40 ) ;
41
42 FUNCTION ce_tax_id_check_algorithm(p_taxpayer_id IN VARCHAR2,
43 p_country IN VARCHAR2,
44 p_tax_id_cd IN VARCHAR2) RETURN VARCHAR2;
45
46 PROCEDURE CE_UNIQUE_BRANCH_NAME(Xi_COUNTRY_NAME IN varchar2,
47 Xi_BRANCH_NAME IN varchar2,
48 Xi_BANK_ID IN varchar2,
49 Xi_BRANCH_ID IN varchar2);
50
51 PROCEDURE CE_UNIQUE_BRANCH_NUMBER(Xi_COUNTRY_NAME IN varchar2,
52 Xi_BRANCH_NUMBER IN varchar2,
53 Xi_BANK_ID IN varchar2,
54 Xi_BRANCH_ID IN varchar2);
55
56 PROCEDURE CE_UNIQUE_BRANCH_NAME_ALT(Xi_COUNTRY_NAME IN varchar2,
57 Xi_BRANCH_NAME_ALT IN varchar2,
58 Xi_BANK_ID IN varchar2,
59 Xi_BRANCH_ID IN varchar2);
60
61 PROCEDURE CE_UNIQUE_ACCOUNT_NAME(Xi_ACCOUNT_NAME IN varchar2,
62 Xi_BRANCH_ID IN varchar2,
63 Xi_ACCOUNT_ID IN varchar2);
64
65
66 /* --------------------------------------------------------------------
67 | PRIVATE PROCEDURE |
68 | CE_VALIDATE_* |
69 --------------------------------------------------------------------- */
70
71 PROCEDURE CE_VALIDATE_CD(X_COUNTRY_NAME IN varchar2,
72 X_CD IN varchar2,
73 X_BANK_NUMBER IN varchar2,
74 X_BRANCH_NUMBER IN varchar2,
75 X_ACCOUNT_NUMBER IN varchar2,
76 p_init_msg_list IN VARCHAR2,
77 x_msg_count OUT NOCOPY NUMBER,
78 x_msg_data OUT NOCOPY VARCHAR2,
79 x_return_status IN OUT NOCOPY VARCHAR2,
80 X_ACCOUNT_CLASSIFICATION IN VARCHAR2 DEFAULT NULL);
81 --X_VALUE_OUT OUT NOCOPY varchar2);
82
83 PROCEDURE CE_VALIDATE_BRANCH(X_COUNTRY_NAME IN varchar2,
84 X_BANK_NUMBER IN varchar2,
85 X_BRANCH_NUMBER IN varchar2,
86 X_BANK_NAME IN varchar2,
87 X_BRANCH_NAME IN varchar2,
88 X_BRANCH_NAME_ALT IN varchar2,
89 X_BANK_ID IN NUMBER,
90 X_BRANCH_ID IN NUMBER,
91 p_init_msg_list IN VARCHAR2,
92 x_msg_count OUT NOCOPY NUMBER,
93 x_msg_data OUT NOCOPY VARCHAR2,
94 X_VALUE_OUT OUT NOCOPY varchar2,
95 x_return_status IN OUT NOCOPY VARCHAR2,
96 X_ACCOUNT_CLASSIFICATION IN VARCHAR2 DEFAULT NULL);
97
98 PROCEDURE CE_VALIDATE_ACCOUNT(X_COUNTRY_NAME IN varchar2,
99 X_BANK_NUMBER IN varchar2,
100 X_BRANCH_NUMBER IN varchar2,
101 X_ACCOUNT_NUMBER IN varchar2,
102 X_BANK_ID IN NUMBER,
103 X_BRANCH_ID IN NUMBER,
104 X_ACCOUNT_ID IN NUMBER,
105 X_CURRENCY_CODE IN varchar2,
106 X_ACCOUNT_TYPE IN varchar2,
107 X_ACCOUNT_SUFFIX IN varchar2,
108 X_SECONDARY_ACCOUNT_REFERENCE IN varchar2,
109 X_ACCOUNT_NAME IN varchar2,
110 p_init_msg_list IN VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2,
113 X_VALUE_OUT OUT NOCOPY varchar2,
114 x_return_status IN OUT NOCOPY VARCHAR2,
115 X_ACCOUNT_CLASSIFICATION IN VARCHAR2 DEFAULT NULL,
116 X_CD IN varchar2 DEFAULT NULL,
117 X_ELECTRONIC_ACCT_NUM OUT NOCOPY varchar2
118 );
119
120 PROCEDURE CE_VALIDATE_BANK( X_COUNTRY_NAME IN varchar2,
121 X_BANK_NUMBER IN varchar2,
122 X_BANK_NAME IN varchar2,
123 X_BANK_NAME_ALT IN varchar2,
124 X_TAX_PAYER_ID IN varchar2,
125 X_BANK_ID IN NUMBER,
126 p_init_msg_list IN VARCHAR2,
127 x_msg_count OUT NOCOPY NUMBER,
128 x_msg_data OUT NOCOPY VARCHAR2,
129 X_VALUE_OUT OUT NOCOPY varchar2,
130 x_return_status IN OUT NOCOPY VARCHAR2,
131 X_ACCOUNT_CLASSIFICATION IN VARCHAR2 DEFAULT NULL);
132
133 /* --------------------------------------------------------------------
134 | PRIVATE PROCEDURE |
135 | CE_VALIDATE_CD_* |
136 --------------------------------------------------------------------- */
137
138 PROCEDURE ce_validate_cd_pt(Xi_CD VARCHAR2,
139 Xi_PASS_MAND_CHECK VARCHAR2,
140 Xi_X_BANK_NUMBER VARCHAR2,
141 Xi_X_BRANCH_NUMBER VARCHAR2,
142 Xi_X_ACCOUNT_NUMBER VARCHAR2);
143
144 PROCEDURE ce_validate_cd_es(Xi_CD VARCHAR2,
145 Xi_PASS_MAND_CHECK VARCHAR2,
146 Xi_X_BANK_NUMBER VARCHAR2,
147 Xi_X_BRANCH_NUMBER VARCHAR2,
148 Xi_X_ACCOUNT_NUMBER VARCHAR2);
149
150
151 PROCEDURE ce_validate_cd_fr(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 -- new validations for check digits 5/14/02
158
159 procedure CE_VALIDATE_CD_DE(Xi_CD in varchar2,
160 Xi_X_ACCOUNT_NUMBER in varchar2);
161
162 procedure CE_VALIDATE_CD_GR(Xi_CD in varchar2,
163 Xi_PASS_MAND_CHECK in varchar2,
164 Xi_X_BANK_NUMBER in varchar2,
165 Xi_X_BRANCH_NUMBER in varchar2,
166 Xi_X_ACCOUNT_NUMBER in varchar2);
167
168 procedure CE_VALIDATE_CD_IS(Xi_CD in varchar2,
169 Xi_X_ACCOUNT_NUMBER in varchar2);
170
171 procedure CE_VALIDATE_CD_IT(Xi_CD in varchar2,
172 Xi_PASS_MAND_CHECK in varchar2,
173 Xi_X_BANK_NUMBER in varchar2,
174 Xi_X_BRANCH_NUMBER in varchar2,
175 Xi_X_ACCOUNT_NUMBER in varchar2);
176
177 procedure CE_VALIDATE_CD_LU(Xi_CD in varchar2,
178 Xi_X_BANK_NUMBER in varchar2,
179 Xi_X_BRANCH_NUMBER in varchar2,
180 Xi_X_ACCOUNT_NUMBER in varchar2);
181 --Xo_VALUE_OUT OUT NOCOPY varchar2);
182
183 procedure CE_VALIDATE_CD_SE(Xi_CD in varchar2,
184 Xi_X_ACCOUNT_NUMBER in varchar2);
185
186 /* --------------------------------------------------------------------
187 | PRIVATE PROCEDURE |
188 | CE_VALIDATE_BRANCH_* |
189 --------------------------------------------------------------------- */
190
191
192 PROCEDURE ce_validate_branch_at(Xi_BRANCH_NUMBER VARCHAR2,
193 Xi_PASS_MAND_CHECK VARCHAR2,
194 Xo_VALUE_OUT OUT NOCOPY varchar2);
195
196 PROCEDURE ce_validate_branch_pt(Xi_BRANCH_NUMBER VARCHAR2,
197 Xi_PASS_MAND_CHECK VARCHAR2);
198
199 PROCEDURE ce_validate_branch_fr(Xi_BRANCH_NUMBER VARCHAR2,
200 Xi_PASS_MAND_CHECK VARCHAR2,
201 Xo_VALUE_OUT OUT NOCOPY varchar2);
202
203
204 PROCEDURE ce_validate_branch_es(Xi_BRANCH_NUMBER VARCHAR2,
205 Xi_PASS_MAND_CHECK VARCHAR2,
206 Xo_VALUE_OUT OUT NOCOPY varchar2);
207
208
209
210 PROCEDURE ce_validate_branch_br(Xi_BRANCH_NUMBER VARCHAR2,
211 Xi_PASS_MAND_CHECK VARCHAR2,
212 Xo_VALUE_OUT OUT NOCOPY varchar2);
213
214 -- new branch validations 5/14/02
215
216 procedure CE_VALIDATE_BRANCH_DE(Xi_BRANCH_NUMBER in varchar2,
217 Xi_BANK_ID in NUMBER);
218
219 procedure CE_VALIDATE_BRANCH_GR(Xi_BRANCH_NUMBER in varchar2);
220
221 procedure CE_VALIDATE_BRANCH_IS(Xi_BRANCH_NUMBER in varchar2,
222 Xi_BANK_ID in NUMBER,
223 Xo_VALUE_OUT OUT NOCOPY varchar2);
224
225
226 procedure CE_VALIDATE_BRANCH_IE(Xi_BRANCH_NUMBER in varchar2,
227 Xi_BANK_ID in NUMBER);
228
229 procedure CE_VALIDATE_BRANCH_IT(Xi_BRANCH_NUMBER in varchar2,
230 Xi_PASS_MAND_CHECK in varchar2);
231
232 procedure CE_VALIDATE_BRANCH_LU(Xi_BRANCH_NUMBER in varchar2,
233 Xi_BANK_ID in NUMBER);
234
235
236 procedure CE_VALIDATE_BRANCH_PL(Xi_BRANCH_NUMBER in varchar2,
237 Xi_BANK_ID in NUMBER);
238
239
240 procedure CE_VALIDATE_BRANCH_SE(Xi_BRANCH_NUMBER in varchar2,
241 Xi_BANK_ID in NUMBER);
242
243
244 procedure CE_VALIDATE_BRANCH_CH(Xi_BRANCH_NUMBER in varchar2,
245 Xi_BANK_ID in NUMBER);
246
247
248 procedure CE_VALIDATE_BRANCH_GB(Xi_BRANCH_NUMBER in varchar2,
249 Xi_BANK_ID in NUMBER);
250
251
252 procedure CE_VALIDATE_BRANCH_US(Xi_BRANCH_NUMBER in varchar2,
253 Xi_PASS_MAND_CHECK in varchar2,
254 Xo_VALUE_OUT OUT NOCOPY varchar2);
255
256 -- new branch validations 10/19/04
257
258 procedure CE_VALIDATE_BRANCH_AU(Xi_BRANCH_NUMBER in varchar2,
259 Xi_BANK_ID in NUMBER,
260 Xi_PASS_MAND_CHECK VARCHAR2);
261
262 procedure CE_VALIDATE_BRANCH_IL(Xi_BRANCH_NUMBER in varchar2,
263 Xi_PASS_MAND_CHECK VARCHAR2);
264
265
266 procedure CE_VALIDATE_BRANCH_NZ(Xi_BRANCH_NUMBER in varchar2,
267 Xi_PASS_MAND_CHECK VARCHAR2);
268
269 procedure CE_VALIDATE_BRANCH_JP(Xi_BRANCH_NUMBER in varchar2,
270 Xi_BRANCH_NAME_ALT in varchar2,
271 Xi_PASS_MAND_CHECK VARCHAR2);
272
273
274
275 /* --------------------------------------------------------------------
276 | PRIVATE PROCEDURE |
277 | CE_VALIDATE_ACCOUNT_* |
278 --------------------------------------------------------------------- */
279
280 PROCEDURE ce_validate_account_at(Xi_ACCOUNT_NUMBER VARCHAR2,
281 Xi_PASS_MAND_CHECK VARCHAR2,
282 Xo_VALUE_OUT OUT NOCOPY varchar2);
283
284
285 PROCEDURE ce_validate_account_pt(Xi_ACCOUNT_NUMBER VARCHAR2,
286 Xi_PASS_MAND_CHECK VARCHAR2,
287 Xo_VALUE_OUT OUT NOCOPY varchar2);
288
289 PROCEDURE ce_validate_account_be(Xi_ACCOUNT_NUMBER VARCHAR2,
290 Xi_PASS_MAND_CHECK VARCHAR2);
291
292
293 PROCEDURE ce_validate_account_dk(Xi_ACCOUNT_NUMBER VARCHAR2,
294 Xi_PASS_MAND_CHECK VARCHAR2,
295 Xo_VALUE_OUT OUT NOCOPY varchar2);
296
297
298 PROCEDURE ce_validate_account_fr(Xi_ACCOUNT_NUMBER VARCHAR2,
299 Xi_PASS_MAND_CHECK VARCHAR2,
300 Xo_VALUE_OUT OUT NOCOPY varchar2);
301
302
303 PROCEDURE ce_validate_account_nl(Xi_ACCOUNT_NUMBER VARCHAR2,
304 Xi_PASS_MAND_CHECK VARCHAR2);
305
306
307 PROCEDURE ce_validate_account_es(Xi_ACCOUNT_NUMBER VARCHAR2,
308 Xi_PASS_MAND_CHECK VARCHAR2,
309 Xo_VALUE_OUT OUT NOCOPY varchar2);
310
311
312 PROCEDURE ce_validate_account_no(Xi_ACCOUNT_NUMBER VARCHAR2,
313 Xi_PASS_MAND_CHECK VARCHAR2);
314
315
316 PROCEDURE ce_validate_account_fi(Xi_ACCOUNT_NUMBER VARCHAR2,
317 Xi_PASS_MAND_CHECK VARCHAR2);
318
319
320 -- new account validations 5/14/02
321
322 procedure CE_VALIDATE_ACCOUNT_DE(Xi_ACCOUNT_NUMBER in varchar2,
323 Xo_VALUE_OUT OUT NOCOPY varchar2);
324
325 procedure CE_VALIDATE_ACCOUNT_GR(Xi_ACCOUNT_NUMBER in varchar2,
326 Xo_VALUE_OUT OUT NOCOPY varchar2);
327
328
329 procedure CE_VALIDATE_ACCOUNT_IS(Xi_ACCOUNT_NUMBER in varchar2,
330 Xo_VALUE_OUT OUT NOCOPY varchar2);
331
332
333 procedure CE_VALIDATE_ACCOUNT_IE(Xi_ACCOUNT_NUMBER in varchar2);
334
335
336 procedure CE_VALIDATE_ACCOUNT_IT(Xi_ACCOUNT_NUMBER in varchar2,
337 Xo_VALUE_OUT OUT NOCOPY varchar2);
338
339 procedure CE_VALIDATE_ACCOUNT_LU(Xi_ACCOUNT_NUMBER in varchar2);
340
341 procedure CE_VALIDATE_ACCOUNT_PL(Xi_ACCOUNT_NUMBER in varchar2);
342
343 procedure CE_VALIDATE_ACCOUNT_SE(Xi_ACCOUNT_NUMBER in varchar2);
344
345 procedure CE_VALIDATE_ACCOUNT_CH(Xi_ACCOUNT_NUMBER in varchar2,
346 Xi_ACCOUNT_TYPE in varchar2);
347
348 procedure CE_VALIDATE_ACCOUNT_GB(Xi_ACCOUNT_NUMBER in varchar2,
349 Xo_VALUE_OUT OUT NOCOPY varchar2);
350
351 procedure CE_VALIDATE_ACCOUNT_BR(Xi_ACCOUNT_NUMBER in varchar2,
352 Xi_SECONDARY_ACCOUNT_REFERENCE in varchar2);
353
357 procedure CE_VALIDATE_ACCOUNT_IL(Xi_ACCOUNT_NUMBER in varchar2);
354 -- new account validations 10/19/04 Bug 6760446 added currency code
355
356 procedure CE_VALIDATE_ACCOUNT_AU(Xi_ACCOUNT_NUMBER in varchar2, Xi_CURRENCY_CODE in varchar2);
358 procedure CE_VALIDATE_ACCOUNT_NZ(Xi_ACCOUNT_NUMBER in varchar2,
359 Xi_ACCOUNT_SUFFIX in varchar2);
360
361 procedure CE_VALIDATE_ACCOUNT_JP(Xi_ACCOUNT_NUMBER in varchar2,
362 Xi_ACCOUNT_TYPE in varchar2);
363
364 /* --------------------------------------------------------------------
365 | PRIVATE PROCEDURE |
366 | CE_VALIDATE_BANK_* |
367 --------------------------------------------------------------------- */
368
369 PROCEDURE ce_validate_bank_es(Xi_BANK_NUMBER VARCHAR2,
370 Xi_PASS_MAND_CHECK VARCHAR2,
371 Xo_VALUE_OUT OUT NOCOPY varchar2);
372
373
374 PROCEDURE ce_validate_bank_fr(Xi_BANK_NUMBER VARCHAR2,
375 Xi_PASS_MAND_CHECK VARCHAR2,
376 Xo_VALUE_OUT OUT NOCOPY varchar2);
377
378
379 PROCEDURE ce_validate_bank_pt(Xi_BANK_NUMBER VARCHAR2,
380 Xi_PASS_MAND_CHECK VARCHAR2);
381
382
383 PROCEDURE ce_validate_bank_br(Xi_BANK_NUMBER VARCHAR2,
384 Xi_PASS_MAND_CHECK VARCHAR2,
385 Xo_VALUE_OUT OUT NOCOPY varchar2);
386
387 -- new bank validations 5/14/02
388
389
390 procedure CE_VALIDATE_BANK_DE(Xi_BANK_NUMBER in varchar2);
391
392 procedure CE_VALIDATE_BANK_GR(Xi_BANK_NUMBER in varchar2);
393
394 procedure CE_VALIDATE_BANK_IS(Xi_BANK_NUMBER in varchar2,
395 Xo_VALUE_OUT OUT NOCOPY varchar2);
396
397 procedure CE_VALIDATE_BANK_IE(Xi_BANK_NUMBER in varchar2);
398
399 procedure CE_VALIDATE_BANK_IT(Xi_BANK_NUMBER in varchar2,
400 Xi_PASS_MAND_CHECK in varchar2);
401
402 procedure CE_VALIDATE_BANK_LU(Xi_BANK_NUMBER in varchar2);
403
404
405 procedure CE_VALIDATE_BANK_PL(Xi_BANK_NUMBER in varchar2);
406
407 procedure CE_VALIDATE_BANK_SE(Xi_BANK_NUMBER in varchar2);
408
409 procedure CE_VALIDATE_BANK_CH(Xi_BANK_NUMBER in varchar2);
410
411
412 procedure CE_VALIDATE_BANK_GB(Xi_BANK_NUMBER in varchar2);
413
414
415 procedure CE_VALIDATE_BANK_CO(Xi_COUNTRY_NAME in varchar2,
416 Xi_BANK_NAME in varchar2,
417 Xi_TAX_PAYER_ID in varchar2);
418
419 -- new bank validations 10/19/04
420
421 procedure CE_VALIDATE_BANK_AU(Xi_BANK_NUMBER in varchar2);
422 procedure CE_VALIDATE_BANK_IL(Xi_BANK_NUMBER in varchar2,
423 Xi_PASS_MAND_CHECK in varchar2);
424 procedure CE_VALIDATE_BANK_NZ(Xi_BANK_NUMBER in varchar2,
425 Xi_PASS_MAND_CHECK in varchar2);
426
427 procedure CE_VALIDATE_BANK_JP(Xi_BANK_NUMBER in varchar2,
428 Xi_BANK_NAME_ALT in varchar2,
429 Xi_PASS_MAND_CHECK in varchar2);
430
431
432 /* -------------------------------------------------------------------
433 | PUBLIC PROCEDURE |
434 | UPD_ACCOUNT_UNIQUE |
435 | Description: Bank Account uniqueness validation |
436 | Usage: Called in update flow due to the Upgrade changes |
437 | Calls: CE_VALIDATE_UNIQUE_ACCOUNT_* |
438 --------------------------------------------------------------------- */
439 PROCEDURE UPD_ACCOUNT_UNIQUE
440 (X_COUNTRY_NAME IN varchar2,
441 X_BANK_NUMBER IN varchar2,
442 X_BRANCH_NUMBER IN varchar2,
443 X_ACCOUNT_NUMBER IN varchar2,
444 X_BANK_ID IN number,
445 X_BRANCH_ID IN number,
446 X_ACCOUNT_ID IN number,
447 X_CURRENCY_CODE IN varchar2,
448 X_ACCOUNT_TYPE IN varchar2,
449 X_ACCOUNT_SUFFIX IN varchar2,
450 X_SECONDARY_ACCOUNT_REFERENCE IN varchar2,
451 X_ACCOUNT_NAME IN varchar2,
452 p_init_msg_list IN VARCHAR2,
453 x_msg_count OUT NOCOPY NUMBER,
454 x_msg_data OUT NOCOPY VARCHAR2,
455 X_VALUE_OUT OUT NOCOPY varchar2,
456 x_return_status IN OUT NOCOPY VARCHAR2,
457 X_ACCOUNT_CLASSIFICATION IN VARCHAR2 DEFAULT NULL);
458
459
460 /* -------------------------------------------------------------------
461 | PUBLIC PROCEDURE |
462 | UPD_ACCOUNT_VALIDATE |
463 | Description: Country specific Bank Account validation |
464 | that does not include the uniqueness validations |
465 | Usage: Called in update flow due to the Upgrade changes |
466 | errors found in this API are treated as warnings |
467 | Calls: CE_VALIDATE_ACCOUNT_* |
471 X_BANK_NUMBER IN varchar2,
468 --------------------------------------------------------------------- */
469 PROCEDURE UPD_ACCOUNT_VALIDATE
470 (X_COUNTRY_NAME IN varchar2,
472 X_BRANCH_NUMBER IN varchar2,
473 X_ACCOUNT_NUMBER IN varchar2,
474 X_BANK_ID IN number,
475 X_BRANCH_ID IN number,
476 X_ACCOUNT_ID IN number,
477 X_CURRENCY_CODE IN varchar2,
478 X_ACCOUNT_TYPE IN varchar2,
479 X_ACCOUNT_SUFFIX IN varchar2,
480 X_SECONDARY_ACCOUNT_REFERENCE IN varchar2,
481 X_ACCOUNT_NAME IN varchar2,
482 p_init_msg_list IN VARCHAR2,
483 x_msg_count OUT NOCOPY NUMBER,
484 x_msg_data OUT NOCOPY VARCHAR2,
485 X_VALUE_OUT OUT NOCOPY varchar2,
486 x_return_status IN OUT NOCOPY VARCHAR2,
487 X_ACCOUNT_CLASSIFICATION IN VARCHAR2 DEFAULT NULL,
488 X_CD IN varchar2 DEFAULT NULL,
489 X_ELECTRONIC_ACCT_NUM OUT NOCOPY varchar2
490 );
491
492
493
494 /* --------------------------------------------------------------------
495 | PRIVATE PROCEDURE |
496 | CE_VALIDATE_UNIQUE_ACCOUNT_* |
497 --------------------------------------------------------------------- */
498
499 procedure CE_VALIDATE_UNIQUE_ACCOUNT( Xi_ACCOUNT_NUMBER in varchar2,
500 Xi_CURRENCY_CODE in varchar2,
501 Xi_ACCOUNT_NAME in varchar2,
502 Xi_BRANCH_ID in NUMBER,
503 Xi_ACCOUNT_ID in NUMBER);
504
505
506 procedure CE_VALIDATE_UNIQUE_ACCOUNT_JP(Xi_ACCOUNT_NUMBER in varchar2,
507 Xi_CURRENCY_CODE in varchar2,
508 Xi_ACCOUNT_TYPE in varchar2,
509 Xi_ACCOUNT_NAME in varchar2,
510 Xi_BRANCH_ID in NUMBER,
511 Xi_ACCOUNT_ID in NUMBER);
512
513
514 procedure CE_VALIDATE_UNIQUE_ACCOUNT_NZ(Xi_ACCOUNT_NUMBER in varchar2,
515 Xi_CURRENCY_CODE in varchar2,
516 Xi_ACCOUNT_SUFFIX in varchar2,
517 Xi_ACCOUNT_NAME in varchar2,
518 Xi_BRANCH_ID in NUMBER,
519 Xi_ACCOUNT_ID in NUMBER);
520
521 /* -------------------------------------------------------------------
522 | PUBLIC PROCEDURE |
523 | CE_FORMAT_ELECTRONIC_NUM |
524 | Description: Format CE_BANK_ACCOUNTS.BANK_ACCOUNT_NUM_ELECTRONIC
525 | CALLED BY: CE_VALIDATE_ACCOUNT
526 | Calls: CE_FORMAT_ELECTRONIC_NUM_* |
527 --------------------------------------------------------------------- */
528
529 PROCEDURE CE_FORMAT_ELECTRONIC_NUM(X_COUNTRY_NAME IN varchar2,
530 X_BANK_NUMBER IN varchar2,
531 X_BRANCH_NUMBER IN varchar2,
532 X_ACCOUNT_NUMBER IN varchar2,
533 X_CD IN varchar2 DEFAULT NULL,
534 X_ACCOUNT_SUFFIX IN varchar2,
535 X_SECONDARY_ACCOUNT_REFERENCE IN varchar2,
536 X_ACCOUNT_CLASSIFICATION IN VARCHAR2 DEFAULT NULL,
537 X_ELECTRONIC_ACCT_NUM OUT NOCOPY varchar2,
538 p_init_msg_list IN VARCHAR2,
539 x_msg_count OUT NOCOPY NUMBER,
540 x_msg_data OUT NOCOPY VARCHAR2,
541 x_return_status IN OUT NOCOPY VARCHAR2
542 );
543
544
545 /* -------------------------------------------------------------------
546 | PUBLIC PROCEDURE |
547 | UPD_BRANCH_UNIQUE |
548 | Description: Branch uniqueness validation |
549 | Usage: Called in update flow due to the Upgrade changes |
550 | Calls: CE_VALIDATE_UNIQUE_BRANCH_* |
551 --------------------------------------------------------------------- */
552 PROCEDURE UPD_BRANCH_UNIQUE
553 (X_COUNTRY_NAME IN varchar2,
554 X_BANK_NUMBER IN varchar2,
555 X_BRANCH_NUMBER IN varchar2,
556 X_BANK_NAME IN varchar2,
557 X_BRANCH_NAME IN varchar2,
558 X_BRANCH_NAME_ALT IN varchar2,
559 X_BANK_ID IN NUMBER,
560 X_BRANCH_ID IN NUMBER,
561 p_init_msg_list IN VARCHAR2,
562 x_msg_count OUT NOCOPY NUMBER,
563 x_msg_data OUT NOCOPY VARCHAR2,
564 X_VALUE_OUT OUT NOCOPY varchar2,
565 x_return_status IN OUT NOCOPY VARCHAR2,
569 /* -------------------------------------------------------------------
566 X_ACCOUNT_CLASSIFICATION IN VARCHAR2 DEFAULT NULL);
567
568
570 | PUBLIC PROCEDURE |
571 | UPD_BRANCH_VALIDATE |
572 | Description: Country specific Branch validation |
573 | that does not include the uniqueness validation |
574 | Usage: Called in update flow due to the Upgrade changes |
575 | errors found in this API are treated as warnings |
576 | Calls: CE_VALIDATE_BRANCH_* |
577 --------------------------------------------------------------------- */
578 PROCEDURE UPD_BRANCH_VALIDATE
579 (X_COUNTRY_NAME IN varchar2,
580 X_BANK_NUMBER IN varchar2,
581 X_BRANCH_NUMBER IN varchar2,
582 X_BANK_NAME IN varchar2,
583 X_BRANCH_NAME IN varchar2,
584 X_BRANCH_NAME_ALT IN varchar2,
585 X_BANK_ID IN NUMBER,
586 X_BRANCH_ID IN NUMBER,
587 p_init_msg_list IN VARCHAR2,
588 x_msg_count OUT NOCOPY NUMBER,
589 x_msg_data OUT NOCOPY VARCHAR2,
590 X_VALUE_OUT OUT NOCOPY varchar2,
591 x_return_status IN OUT NOCOPY VARCHAR2,
592 X_ACCOUNT_CLASSIFICATION IN VARCHAR2 DEFAULT NULL);
593
594
595 /* --------------------------------------------------------------------
596 | PRIVATE PROCEDURE |
597 | CE_VALIDATE_UNIQUE_BRANCH_* |
598 --------------------------------------------------------------------- */
599
600 procedure CE_VALIDATE_UNIQUE_BRANCH(Xi_COUNTRY_NAME in varchar2,
601 Xi_BRANCH_NUMBER in varchar2,
602 Xi_BRANCH_NAME in varchar2,
603 Xi_BANK_ID in NUMBER,
604 Xi_BRANCH_ID in NUMBER);
605
606
607 procedure CE_VALIDATE_UNIQUE_BRANCH_JP(Xi_COUNTRY_NAME in varchar2,
608 Xi_BRANCH_NUMBER in varchar2,
609 Xi_BRANCH_NAME in varchar2,
610 Xi_BRANCH_NAME_ALT in varchar2,
611 Xi_BANK_ID in NUMBER,
612 Xi_BRANCH_ID in NUMBER);
613
614
615 procedure CE_VALIDATE_UNIQUE_BRANCH_DE(Xi_BRANCH_NUMBER in varchar2,
616 Xi_BRANCH_NAME in varchar2,
617 Xi_BANK_ID in NUMBER,
618 Xi_BRANCH_ID in NUMBER);
619
620 procedure CE_VALIDATE_UNIQUE_BRANCH_US(Xi_BRANCH_NUMBER in varchar2,
621 Xi_BRANCH_NAME in varchar2,
622 Xi_BANK_ID in NUMBER,
623 Xi_BRANCH_ID in NUMBER);
624
625
626 /* -------------------------------------------------------------------
627 | PUBLIC PROCEDURE |
628 | UPD_BANK_UNIQUE |
629 | Description: Bank uniqueness validation |
630 | Usage: Called in update flow due to the Upgrade changes |
631 | Calls: CE_VALIDATE_UNIQUE_BANK_* |
632 --------------------------------------------------------------------- */
633 PROCEDURE UPD_BANK_UNIQUE
634 ( X_COUNTRY_NAME IN varchar2,
635 X_BANK_NUMBER IN varchar2,
636 X_BANK_NAME IN varchar2,
637 X_BANK_NAME_ALT IN varchar2,
638 X_TAX_PAYER_ID IN varchar2,
639 X_BANK_ID IN NUMBER,
640 p_init_msg_list IN VARCHAR2,
641 x_msg_count OUT NOCOPY NUMBER,
642 x_msg_data OUT NOCOPY VARCHAR2,
643 X_VALUE_OUT OUT NOCOPY varchar2,
644 x_return_status IN OUT NOCOPY VARCHAR2,
645 X_ACCOUNT_CLASSIFICATION IN VARCHAR2 DEFAULT NULL);
646
647
648 /* -------------------------------------------------------------------
649 | PUBLIC PROCEDURE |
650 | UPD_BANK_VALIDATE |
651 | Description: Country specific Bank validation that does not |
652 | include the uniqueness validations |
653 | Usage: Called in update flow due to the Upgrade changes |
654 | errors found in this API are treated as warnings |
655 | Calls: CE_VALIDATE_BANK_* |
656 --------------------------------------------------------------------- */
657 PROCEDURE UPD_BANK_VALIDATE
658 ( X_COUNTRY_NAME IN varchar2,
659 X_BANK_NUMBER IN varchar2,
660 X_BANK_NAME IN varchar2,
661 X_BANK_NAME_ALT IN varchar2,
662 X_TAX_PAYER_ID IN varchar2,
663 X_BANK_ID IN NUMBER,
667 X_VALUE_OUT OUT NOCOPY varchar2,
664 p_init_msg_list IN VARCHAR2,
665 x_msg_count OUT NOCOPY NUMBER,
666 x_msg_data OUT NOCOPY VARCHAR2,
668 x_return_status IN OUT NOCOPY VARCHAR2,
669 X_ACCOUNT_CLASSIFICATION IN VARCHAR2 DEFAULT NULL);
670
671
672 /* --------------------------------------------------------------------
673 | PRIVATE PROCEDURE |
674 | CE_VALIDATE_UNIQUE_BANK_* |
675 --------------------------------------------------------------------- */
676
677 procedure CE_VALIDATE_UNIQUE_BANK_JP(Xi_COUNTRY_NAME in varchar2,
678 Xi_BANK_NUMBER in varchar2,
679 Xi_BANK_NAME in varchar2,
680 Xi_BANK_NAME_ALT in varchar2,
681 Xi_BANK_ID in varchar2);
682
683 -- added 10/25/04
684 /* --------------------------------------------------------------------
685 | PRIVATE PROCEDURE |
686 | CE_VALIDATE_MISC_* other misc validations
687 --------------------------------------------------------------------- */
688
689 procedure CE_VALIDATE_MISC_EFT_NUM(X_COUNTRY_NAME in varchar2,
690 X_EFT_NUMBER in varchar2,
691 p_init_msg_list IN VARCHAR2,
692 x_msg_count OUT NOCOPY NUMBER,
693 x_msg_data OUT NOCOPY VARCHAR2,
694 x_return_status IN OUT NOCOPY VARCHAR2);
695
696 procedure CE_VALIDATE_MISC_ACCT_HLDR_ALT(X_COUNTRY_NAME in varchar2,
697 X_ACCOUNT_HOLDER_ALT in varchar2,
698 X_ACCOUNT_CLASSIFICATION in varchar2,
699 p_init_msg_list IN VARCHAR2,
700 x_msg_count OUT NOCOPY NUMBER,
701 x_msg_data OUT NOCOPY VARCHAR2,
702 x_return_status IN OUT NOCOPY VARCHAR2);
703
704 -- added 12/18/06
705
706 procedure CE_VALIDATE_BRANCH_IS_FORMAT(Xi_BRANCH_NUMBER in varchar2,
707 Xo_VALUE_OUT OUT NOCOPY varchar2);
708
709
710 PROCEDURE GET_BRANCH_NUM_FORMAT(X_COUNTRY_NAME IN varchar2,
711 X_BRANCH_NUMBER IN varchar2,
712 X_VALUE_OUT OUT NOCOPY varchar2,
713 p_init_msg_list IN VARCHAR2,
714 x_msg_count OUT NOCOPY NUMBER,
715 x_msg_data OUT NOCOPY VARCHAR2,
716 x_return_status IN OUT NOCOPY VARCHAR2);
717
718 -- Bug 6856840: Added wrapper procedure for Branch Validations
719 PROCEDURE CE_VALIDATE_BRANCH_BANK (
720 Xi_COUNTRY IN varchar2,
721 Xi_BRANCH_NUM IN varchar2,
722 Xi_BANK_NUM IN varchar2,
723 Xo_VALUE_OUT OUT NOCOPY varchar2);
724
725
726 END CE_VALIDATE_BANKINFO;