[Home] [Help]
PACKAGE: APPS.CE_BANK_PUB
Source
1 PACKAGE ce_bank_pub AS
2 /*$Header: ceextbas.pls 120.3.12010000.2 2008/10/02 16:26:28 csutaria ship $ */
3
4 TYPE BankAcct_rec_type IS RECORD (
5 bank_account_id NUMBER(15), -- required for update
6 branch_id NUMBER(15), -- required for create
7 bank_id NUMBER(15),
8 account_owner_party_id NUMBER(15),
9 account_owner_org_id NUMBER(15), -- required for create (cannot be updated)
10 account_classification VARCHAR2(30), -- required
11 bank_account_name VARCHAR2(80), -- required
12 bank_account_num VARCHAR2(100), -- required
13 currency VARCHAR2(15),
14 iban VARCHAR2(50),
15 check_digits VARCHAR2(30),
16 eft_requester_id VARCHAR2(25),
17 secondary_account_reference VARCHAR2(30),
18 multi_currency_allowed_flag VARCHAR2(1),
19 alternate_acct_name VARCHAR2(320),
20 short_account_name VARCHAR2(30),
21 acct_type VARCHAR2(25),
22 acct_suffix VARCHAR2(30),
23 description_code1 VARCHAR2(60),
24 description_code2 VARCHAR2(60),
25 description VARCHAR2(240),
26 agency_location_code VARCHAR2(30),
27 ap_use_allowed_flag VARCHAR2(1),
28 ar_use_allowed_flag VARCHAR2(1),
29 xtr_use_allowed_flag VARCHAR2(1),
30 pay_use_allowed_flag VARCHAR2(1),
31 payment_multi_currency_flag VARCHAR2(1),
32 receipt_multi_currency_flag VARCHAR2(1),
33 zero_amount_allowed VARCHAR2(1),
34 max_outlay NUMBER(15),
35 max_check_amount NUMBER(15),
36 min_check_amount NUMBER(15),
37 ap_amount_tolerance NUMBER(15),
38 ar_amount_tolerance NUMBER(15),
39 xtr_amount_tolerance NUMBER(15),
40 pay_amount_tolerance NUMBER(15),
41 ce_amount_tolerance NUMBER(15),
42 ap_percent_tolerance NUMBER(15),
43 ar_percent_tolerance NUMBER(15),
44 xtr_percent_tolerance NUMBER(15),
45 pay_percent_tolerance NUMBER(15),
46 ce_percent_tolerance NUMBER(15),
47 start_date DATE,
48 end_date DATE,
49 account_holder_name_alt VARCHAR2(150),
50 account_holder_name VARCHAR2(240),
51 cashflow_display_order NUMBER(15),
52 pooled_flag VARCHAR2(1),
53 min_target_balance NUMBER(15),
54 max_target_balance NUMBER(15),
55 eft_user_num VARCHAR2(30),
56 masked_account_num VARCHAR2(100),
57 masked_iban VARCHAR2(50),
58 interest_schedule_id NUMBER(15),
59 asset_code_combination_id NUMBER(15),
60 cash_clearing_ccid NUMBER(15),
61 bank_charges_ccid NUMBER(15),
62 bank_errors_ccid NUMBER(15),
63 cashpool_min_payment_amt NUMBER,
64 cashpool_min_receipt_amt NUMBER,
65 cashpool_round_factor NUMBER(15),
66 cashpool_round_rule VARCHAR2(4),
67 attribute_category VARCHAR2(150),
68 attribute1 VARCHAR2(150),
69 attribute2 VARCHAR2(150),
70 attribute3 VARCHAR2(150),
71 attribute4 VARCHAR2(150),
72 attribute5 VARCHAR2(150),
73 attribute6 VARCHAR2(150),
74 attribute7 VARCHAR2(150),
75 attribute8 VARCHAR2(150),
76 attribute9 VARCHAR2(150),
77 attribute10 VARCHAR2(150),
78 attribute11 VARCHAR2(150),
79 attribute12 VARCHAR2(150),
80 attribute13 VARCHAR2(150),
81 attribute14 VARCHAR2(150),
82 attribute15 VARCHAR2(150),
83 xtr_bank_account_reference VARCHAR2(20)
84 );
85
86
87 TYPE BankAcct_use_rec_type IS RECORD (
88 bank_acct_use_id NUMBER(15), -- required for update
89 bank_account_id NUMBER(15), -- required for create
90 org_type VARCHAR2(2), -- required, valid values: LE, OU, BG
91 primary_flag VARCHAR2(1),
92 org_id NUMBER(15), -- required if OU or BG
93 org_party_id NUMBER(15),
94 ap_use_enable_flag VARCHAR2(1),
95 ar_use_enable_flag VARCHAR2(1),
96 xtr_use_enable_flag VARCHAR2(1),
97 pay_use_enable_flag VARCHAR2(1),
98 edisc_receivables_trx_id NUMBER(15),
99 unedisc_receivables_trx_id NUMBER(15),
100 end_date DATE,
101 br_std_receivables_trx_id NUMBER(15),
102 legal_entity_id NUMBER(15), -- required if LE
103 investment_limit_code VARCHAR2(7),
104 funding_limit_code VARCHAR2(7),
105 ap_default_settlement_flag VARCHAR2(1),
106 xtr_default_settlement_flag VARCHAR2(1),
107 payroll_bank_account_id NUMBER(15),
108 pricing_model VARCHAR2(30),
109 authorized_flag VARCHAR2(1),
110 eft_script_name VARCHAR2(50),
111 default_account_flag VARCHAR2(1),
112 portfolio_code VARCHAR2(7),
113 attribute_category VARCHAR2(150),
114 attribute1 VARCHAR2(150),
115 attribute2 VARCHAR2(150),
116 attribute3 VARCHAR2(150),
117 attribute4 VARCHAR2(150),
118 attribute5 VARCHAR2(150),
119 attribute6 VARCHAR2(150),
120 attribute7 VARCHAR2(150),
121 attribute8 VARCHAR2(150),
122 attribute9 VARCHAR2(150),
123 attribute10 VARCHAR2(150),
124 attribute11 VARCHAR2(150),
125 attribute12 VARCHAR2(150),
126 attribute13 VARCHAR2(150),
127 attribute14 VARCHAR2(150),
128 attribute15 VARCHAR2(150),
129 asset_code_combination_id NUMBER(15), -- required for AP and AR use
130 ap_asset_ccid NUMBER(15),
131 ar_asset_ccid NUMBER(15),
132 cash_clearing_ccid NUMBER(15),
133 bank_charges_ccid NUMBER(15),
134 bank_errors_ccid NUMBER(15),
135 gain_code_combination_id NUMBER(15),
136 loss_code_combination_id NUMBER(15),
137 on_account_ccid NUMBER(15),
138 unapplied_ccid NUMBER(15),
139 unidentified_ccid NUMBER(15),
140 factor_ccid NUMBER(15),
141 receipt_clearing_ccid NUMBER(15),
142 remittance_ccid NUMBER(15),
143 ar_short_term_deposit_ccid NUMBER(15),
144 br_short_term_deposit_ccid NUMBER(15),
145 future_dated_payment_ccid NUMBER(15),
146 br_remittance_ccid NUMBER(15),
147 br_factor_ccid NUMBER(15),
148 bank_interest_expense_ccid NUMBER(15),
149 bank_interest_income_ccid NUMBER(15),
150 xtr_asset_ccid NUMBER(15),
151 ar_bank_charges_ccid NUMBER(15) --7437641
152 );
153
154
155
156 /*=======================================================================+
157 | PUBLIC PROCEDURE create_bank |
158 | |
159 | DESCRIPTION |
160 | Create a bank as a TCA organization party. |
161 | |
162 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
163 | hz_bank_pub.create_bank |
164 | |
165 | ARGUMENTS |
166 | IN: |
167 | p_init_msg_list Initialize message stack if it is set to |
168 | FND_API.G_TRUE. Default is fnd_api.g_false
169 | p_country_code Country code of the bank. |
170 | p_bank_name Bank name. |
171 | p_bank_number Bank number. |
172 | p_alternate_bank_name Alternate bank name. |
173 | p_short_bank_name Short bank name. |
174 | p_description Description. |
175 | p_tax_payer_id Tax payer ID. |
176 | p_tax_registration_number Tax registration number |
177 | IN/OUT: |
178 | OUT: |
179 | x_bank_id Party ID for the bank. |
180 | x_return_status Return status after the call. The status can |
181 | be FND_API.G_RET_STS_SUCCESS (success), |
182 | fnd_api.g_ret_sts_error (error), |
183 | fnd_api.g_ret_sts_unexp_error (unexpected |
184 | error). |
185 | x_msg_count Number of messages in message stack. |
186 | x_msg_data Message text if x_msg_count is 1. |
187 | MODIFICATION HISTORY |
188 | 25-AUG-2004 Xin Wang Created. |
189 +=======================================================================*/
190 PROCEDURE create_bank (
191 p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
192 p_country_code IN VARCHAR2,
193 p_bank_name IN VARCHAR2,
194 p_bank_number IN VARCHAR2 DEFAULT NULL,
195 p_alternate_bank_name IN VARCHAR2 DEFAULT NULL,
196 p_short_bank_name IN VARCHAR2 DEFAULT NULL,
197 p_description IN VARCHAR2 DEFAULT NULL,
198 p_tax_payer_id IN VARCHAR2 DEFAULT NULL,
199 p_tax_registration_number IN VARCHAR2 DEFAULT NULL,
200 p_attribute_category IN VARCHAR2 DEFAULT NULL,
201 p_attribute1 IN VARCHAR2 DEFAULT NULL,
202 p_attribute2 IN VARCHAR2 DEFAULT NULL,
203 p_attribute3 IN VARCHAR2 DEFAULT NULL,
204 p_attribute4 IN VARCHAR2 DEFAULT NULL,
205 p_attribute5 IN VARCHAR2 DEFAULT NULL,
206 p_attribute6 IN VARCHAR2 DEFAULT NULL,
207 p_attribute7 IN VARCHAR2 DEFAULT NULL,
208 p_attribute8 IN VARCHAR2 DEFAULT NULL,
209 p_attribute9 IN VARCHAR2 DEFAULT NULL,
210 p_attribute10 IN VARCHAR2 DEFAULT NULL,
211 p_attribute11 IN VARCHAR2 DEFAULT NULL,
212 p_attribute12 IN VARCHAR2 DEFAULT NULL,
213 p_attribute13 IN VARCHAR2 DEFAULT NULL,
214 p_attribute14 IN VARCHAR2 DEFAULT NULL,
215 p_attribute15 IN VARCHAR2 DEFAULT NULL,
216 p_attribute16 IN VARCHAR2 DEFAULT NULL,
217 p_attribute17 IN VARCHAR2 DEFAULT NULL,
218 p_attribute18 IN VARCHAR2 DEFAULT NULL,
219 p_attribute19 IN VARCHAR2 DEFAULT NULL,
220 p_attribute20 IN VARCHAR2 DEFAULT NULL,
221 p_attribute21 IN VARCHAR2 DEFAULT NULL,
222 p_attribute22 IN VARCHAR2 DEFAULT NULL,
223 p_attribute23 IN VARCHAR2 DEFAULT NULL,
224 p_attribute24 IN VARCHAR2 DEFAULT NULL,
225 x_bank_id OUT NOCOPY NUMBER,
226 x_return_status OUT NOCOPY VARCHAR2,
227 x_msg_count OUT NOCOPY NUMBER,
228 x_msg_data OUT NOCOPY VARCHAR2
229 );
230
231
232 /*=======================================================================+
233 | PUBLIC PROCEDURE update_bank |
234 | |
235 | DESCRIPTION |
236 | Update a bank organization. |
237 | |
238 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
239 | hz_bank_pub.update_bank |
240 | |
241 | ARGUMENTS |
242 | IN: |
243 | p_init_msg_list Initialize message stack if it is set to |
244 | FND_API.G_TRUE. Default is fnd_api.g_false
245 | p_bank_id Party ID of the bank to be updated. |
246 | p_bank_name Bank name. |
247 | p_bank_number Bank number. |
248 | p_alternate_bank_name Alternate bank name. |
249 | p_short_bank_name Short bank name. |
250 | p_description Description. |
251 | p_tax_payer_id Tax payer ID. |
252 | p_tax_registration_number Tax registration number |
253 | IN/OUT: |
254 | p_object_version_number Current object version number for the bank|
255 | OUT: |
256 | x_return_status Return status after the call. The status can |
257 | be FND_API.G_RET_STS_SUCCESS (success), |
258 | fnd_api.g_ret_sts_error (error), |
259 | fnd_api.g_ret_sts_unexp_error (unexpected |
260 | error). |
261 | x_msg_count Number of messages in message stack. |
262 | x_msg_data Message text if x_msg_count is 1. |
263 | MODIFICATION HISTORY |
264 | 25-AUG-2004 Xin Wang Created. |
265 +=======================================================================*/
266 PROCEDURE update_bank (
267 p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
268 p_bank_id IN NUMBER,
269 p_bank_name IN VARCHAR2,
270 p_bank_number IN VARCHAR2 DEFAULT NULL,
271 p_alternate_bank_name IN VARCHAR2 DEFAULT NULL,
272 p_short_bank_name IN VARCHAR2 DEFAULT NULL,
273 p_description IN VARCHAR2 DEFAULT NULL,
274 p_tax_payer_id IN VARCHAR2 DEFAULT NULL,
275 p_tax_registration_number IN VARCHAR2 DEFAULT NULL,
276 p_attribute_category IN VARCHAR2 DEFAULT NULL,
277 p_attribute1 IN VARCHAR2 DEFAULT NULL,
278 p_attribute2 IN VARCHAR2 DEFAULT NULL,
279 p_attribute3 IN VARCHAR2 DEFAULT NULL,
280 p_attribute4 IN VARCHAR2 DEFAULT NULL,
281 p_attribute5 IN VARCHAR2 DEFAULT NULL,
282 p_attribute6 IN VARCHAR2 DEFAULT NULL,
283 p_attribute7 IN VARCHAR2 DEFAULT NULL,
284 p_attribute8 IN VARCHAR2 DEFAULT NULL,
285 p_attribute9 IN VARCHAR2 DEFAULT NULL,
286 p_attribute10 IN VARCHAR2 DEFAULT NULL,
287 p_attribute11 IN VARCHAR2 DEFAULT NULL,
288 p_attribute12 IN VARCHAR2 DEFAULT NULL,
289 p_attribute13 IN VARCHAR2 DEFAULT NULL,
290 p_attribute14 IN VARCHAR2 DEFAULT NULL,
291 p_attribute15 IN VARCHAR2 DEFAULT NULL,
292 p_attribute16 IN VARCHAR2 DEFAULT NULL,
293 p_attribute17 IN VARCHAR2 DEFAULT NULL,
294 p_attribute18 IN VARCHAR2 DEFAULT NULL,
295 p_attribute19 IN VARCHAR2 DEFAULT NULL,
296 p_attribute20 IN VARCHAR2 DEFAULT NULL,
297 p_attribute21 IN VARCHAR2 DEFAULT NULL,
298 p_attribute22 IN VARCHAR2 DEFAULT NULL,
302 x_return_status OUT NOCOPY VARCHAR2,
299 p_attribute23 IN VARCHAR2 DEFAULT NULL,
300 p_attribute24 IN VARCHAR2 DEFAULT NULL,
301 p_object_version_number IN OUT NOCOPY NUMBER,
303 x_msg_count OUT NOCOPY NUMBER,
304 x_msg_data OUT NOCOPY VARCHAR2
305 );
306
307
308 /*=======================================================================+
309 | PUBLIC PROCEDURE set_bank_end_date |
310 | |
311 | DESCRIPTION |
312 | Set the end date of a bank. |
313 | |
314 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
315 | hz_bank_pub.update_bank |
316 | |
317 | ARGUMENTS |
318 | IN: |
319 | p_init_msg_list Initialize message stack if it is set to |
320 | FND_API.G_TRUE. Default is fnd_api.g_false
321 | p_bank_id Party ID of the bank to be updated. |
322 | p_end_date End date of the bank. |
323 | IN/OUT: |
324 | p_object_version_number Current object version number for the code|
325 | assignment for the bank institution type. |
326 | OUT: |
327 | x_return_status Return status after the call. The status can |
328 | be FND_API.G_RET_STS_SUCCESS (success), |
329 | fnd_api.g_ret_sts_error (error), |
330 | fnd_api.g_ret_sts_unexp_error (unexpected |
331 | error). |
332 | x_msg_count Number of messages in message stack. |
333 | x_msg_data Message text if x_msg_count is 1. |
334 | MODIFICATION HISTORY |
335 | 25-AUG-2004 Xin Wang Created. |
336 +=======================================================================*/
337 PROCEDURE set_bank_end_date (
338 p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
339 p_bank_id IN NUMBER,
340 p_end_date IN DATE,
341 p_object_version_number IN OUT NOCOPY NUMBER,
342 x_return_status OUT NOCOPY VARCHAR2,
343 x_msg_count OUT NOCOPY NUMBER,
344 x_msg_data OUT NOCOPY VARCHAR2
345 );
346
347
348 /*=======================================================================+
349 | PUBLIC PROCEDURE check_bank_exist |
350 | |
351 | DESCRIPTION |
352 | Check whether a bank already exists, if so, return the bank ID. |
353 | |
354 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
355 | |
356 | ARGUMENTS |
357 | IN: |
358 | p_country_code Country code. |
359 | p_bank_name Bank name. |
360 | p_bank_number Bank number. |
361 | IN/OUT: |
362 | OUT: |
363 | x_bank_id Bank Party ID if bank exists, |
364 | null if bank does not exist. |
365 | x_end_date End date of the bank. |
366 | |
367 | MODIFICATION HISTORY |
368 | 25-AUG-2004 Xin Wang Created. |
369 +=======================================================================*/
370 PROCEDURE check_bank_exist(
371 p_country_code IN VARCHAR2,
372 p_bank_name IN VARCHAR2,
373 p_bank_number IN VARCHAR2,
374 x_bank_id OUT NOCOPY NUMBER,
375 x_end_date OUT NOCOPY DATE
376 );
377
378
379
380 /*=======================================================================+
381 | PUBLIC PROCEDURE create_bank_branch |
382 | |
383 | DESCRIPTION |
384 | Create a bank branch as a TCA organization party. |
385 | |
386 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
387 | hz_bank_pub.create_bank_branch |
388 | |
389 | ARGUMENTS |
393 | p_bank_party_id Party ID of the bank that the branch |
390 | IN: |
391 | p_init_msg_list Initialize message stack if it is set to |
392 | FND_API.G_TRUE. Default is fnd_api.g_false
394 | belongs. |
395 | p_branch_name Bank branch name. |
396 | p_branch_number Bank branch number. |
397 | p_branch_type Bank branch type. |
398 | p_alternate_branch_name Alternate bank branch name. |
399 | p_description Description. |
400 | p_bic BIC (Bank Identification Code). |
401 | p_eft_number EFT number. |
402 | p_rfc_identifier Regional Finance Center Identifier. |
403 | IN/OUT: |
404 | OUT: |
405 | x_branch_id Party ID for the bank branch. |
406 | x_return_status Return status after the call. The status can |
407 | be FND_API.G_RET_STS_SUCCESS (success), |
408 | fnd_api.g_ret_sts_error (error), |
409 | fnd_api.g_ret_sts_unexp_error (unexpected |
410 | error). |
411 | x_msg_count Number of messages in message stack. |
412 | x_msg_data Message text if x_msg_count is 1. |
413 | MODIFICATION HISTORY |
414 | 25-AUG-2004 Xin Wang Created. |
415 +=======================================================================*/
416 PROCEDURE create_bank_branch (
417 p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
418 p_bank_id IN NUMBER,
419 p_branch_name IN VARCHAR2,
420 p_branch_number IN VARCHAR2 DEFAULT NULL,
421 p_branch_type IN VARCHAR2 DEFAULT NULL,
422 p_alternate_branch_name IN VARCHAR2 DEFAULT NULL,
423 p_description IN VARCHAR2 DEFAULT NULL,
424 p_bic IN VARCHAR2 DEFAULT NULL,
425 p_eft_number IN VARCHAR2 DEFAULT NULL,
426 p_rfc_identifier IN VARCHAR2 DEFAULT NULL,
427 p_attribute_category IN VARCHAR2 DEFAULT NULL,
428 p_attribute1 IN VARCHAR2 DEFAULT NULL,
429 p_attribute2 IN VARCHAR2 DEFAULT NULL,
430 p_attribute3 IN VARCHAR2 DEFAULT NULL,
431 p_attribute4 IN VARCHAR2 DEFAULT NULL,
432 p_attribute5 IN VARCHAR2 DEFAULT NULL,
433 p_attribute6 IN VARCHAR2 DEFAULT NULL,
434 p_attribute7 IN VARCHAR2 DEFAULT NULL,
435 p_attribute8 IN VARCHAR2 DEFAULT NULL,
436 p_attribute9 IN VARCHAR2 DEFAULT NULL,
437 p_attribute10 IN VARCHAR2 DEFAULT NULL,
438 p_attribute11 IN VARCHAR2 DEFAULT NULL,
439 p_attribute12 IN VARCHAR2 DEFAULT NULL,
440 p_attribute13 IN VARCHAR2 DEFAULT NULL,
441 p_attribute14 IN VARCHAR2 DEFAULT NULL,
442 p_attribute15 IN VARCHAR2 DEFAULT NULL,
443 p_attribute16 IN VARCHAR2 DEFAULT NULL,
444 p_attribute17 IN VARCHAR2 DEFAULT NULL,
445 p_attribute18 IN VARCHAR2 DEFAULT NULL,
446 p_attribute19 IN VARCHAR2 DEFAULT NULL,
447 p_attribute20 IN VARCHAR2 DEFAULT NULL,
448 p_attribute21 IN VARCHAR2 DEFAULT NULL,
449 p_attribute22 IN VARCHAR2 DEFAULT NULL,
450 p_attribute23 IN VARCHAR2 DEFAULT NULL,
451 p_attribute24 IN VARCHAR2 DEFAULT NULL,
452 x_branch_id OUT NOCOPY NUMBER,
453 x_return_status OUT NOCOPY VARCHAR2,
454 x_msg_count OUT NOCOPY NUMBER,
455 x_msg_data OUT NOCOPY VARCHAR2
456 );
457
458
459 /*=======================================================================+
460 | PUBLIC PROCEDURE update_bank_branch |
461 | |
462 | DESCRIPTION |
463 | Update a bank branch organization party in TCA. |
464 | |
465 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
466 | hz_bank_pub.update_bank_branch |
467 | |
468 | ARGUMENTS |
469 | IN: |
470 | p_init_msg_list Initialize message stack if it is set to |
471 | FND_API.G_TRUE. Default is fnd_api.g_false
472 | p_branch_id Party ID of the branch to be updated. |
473 | p_branch_name Bank branch name. |
477 | p_description Description. |
474 | p_branch_number Bank branch number. |
475 | p_branch_type Bank branch type. |
476 | p_alternate_branch_name Alternate bank branch name. |
478 | p_bic BIC (Bank Identification Code). |
479 | p_eft_number EFT number. |
480 | p_rfc_identifier RFC Identifier. |
481 | IN/OUT: |
482 | p_bch_object_version_number Current object version number for |
483 | the bank branch. |
484 | p_typ_object_version_number Current object version number for |
485 | bank branch type code assignment. |
486 | p_rfc_object_version_number Current object version number for |
487 | RFC code assignment. |
488 | p_eft_object_version_number Current object version number for |
489 | BIC(EFT) contact point. |
490 | OUT: |
491 | x_return_status Return status after the call. The status can |
492 | be FND_API.G_RET_STS_SUCCESS (success), |
493 | fnd_api.g_ret_sts_error (error), |
494 | fnd_api.g_ret_sts_unexp_error (unexpected |
495 | error). |
496 | x_msg_count Number of messages in message stack. |
497 | x_msg_data Message text if x_msg_count is 1. |
498 | MODIFICATION HISTORY |
499 | 25-AUG-2004 Xin Wang Created. |
500 +=======================================================================*/
501 PROCEDURE update_bank_branch (
502 p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
503 p_branch_id IN NUMBER,
504 p_branch_name IN VARCHAR2,
505 p_branch_number IN VARCHAR2 DEFAULT NULL,
506 p_branch_type IN VARCHAR2 DEFAULT NULL,
507 p_alternate_branch_name IN VARCHAR2 DEFAULT NULL,
508 p_description IN VARCHAR2 DEFAULT NULL,
509 p_bic IN VARCHAR2 DEFAULT NULL,
510 p_eft_number IN VARCHAR2 DEFAULT NULL,
511 p_rfc_identifier IN VARCHAR2 DEFAULT NULL,
512 p_attribute_category IN VARCHAR2 DEFAULT NULL,
513 p_attribute1 IN VARCHAR2 DEFAULT NULL,
514 p_attribute2 IN VARCHAR2 DEFAULT NULL,
515 p_attribute3 IN VARCHAR2 DEFAULT NULL,
516 p_attribute4 IN VARCHAR2 DEFAULT NULL,
517 p_attribute5 IN VARCHAR2 DEFAULT NULL,
518 p_attribute6 IN VARCHAR2 DEFAULT NULL,
519 p_attribute7 IN VARCHAR2 DEFAULT NULL,
520 p_attribute8 IN VARCHAR2 DEFAULT NULL,
521 p_attribute9 IN VARCHAR2 DEFAULT NULL,
522 p_attribute10 IN VARCHAR2 DEFAULT NULL,
523 p_attribute11 IN VARCHAR2 DEFAULT NULL,
524 p_attribute12 IN VARCHAR2 DEFAULT NULL,
525 p_attribute13 IN VARCHAR2 DEFAULT NULL,
526 p_attribute14 IN VARCHAR2 DEFAULT NULL,
527 p_attribute15 IN VARCHAR2 DEFAULT NULL,
528 p_attribute16 IN VARCHAR2 DEFAULT NULL,
529 p_attribute17 IN VARCHAR2 DEFAULT NULL,
530 p_attribute18 IN VARCHAR2 DEFAULT NULL,
531 p_attribute19 IN VARCHAR2 DEFAULT NULL,
532 p_attribute20 IN VARCHAR2 DEFAULT NULL,
533 p_attribute21 IN VARCHAR2 DEFAULT NULL,
534 p_attribute22 IN VARCHAR2 DEFAULT NULL,
535 p_attribute23 IN VARCHAR2 DEFAULT NULL,
536 p_attribute24 IN VARCHAR2 DEFAULT NULL,
537 p_bch_object_version_number IN OUT NOCOPY NUMBER,
538 p_typ_object_version_number IN OUT NOCOPY NUMBER,
539 p_rfc_object_version_number IN OUT NOCOPY NUMBER,
540 p_eft_object_version_number IN OUT NOCOPY NUMBER,
541 x_return_status OUT NOCOPY VARCHAR2,
542 x_msg_count OUT NOCOPY NUMBER,
543 x_msg_data OUT NOCOPY VARCHAR2
544 );
545
546
547 /*=======================================================================+
548 | PUBLIC PROCEDURE set_bank_branch_end_date |
549 | |
550 | DESCRIPTION |
551 | Set the end date of a bank branch. |
552 | |
553 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
554 | hz_bank_pub.update_bank |
555 | |
556 | ARGUMENTS |
560 | p_branch_id Party ID of the branch to be inactivated.|
557 | IN: |
558 | p_init_msg_list Initialize message stack if it is set to |
559 | FND_API.G_TRUE. Default is fnd_api.g_false
561 | p_end_date Inactive date of the bank branch. |
562 | IN/OUT: |
563 | p_object_version_number Current object version number for the |
564 | code assignment of the bank institution|
565 | type for the bank branch. |
566 | OUT: |
567 | x_return_status Return status after the call. The status can |
568 | be FND_API.G_RET_STS_SUCCESS (success), |
569 | fnd_api.g_ret_sts_error (error), |
570 | fnd_api.g_ret_sts_unexp_error (unexpected |
571 | error). |
572 | x_msg_count Number of messages in message stack. |
573 | x_msg_data Message text if x_msg_count is 1. |
574 | MODIFICATION HISTORY |
575 | 25-AUG-2004 Xin Wang Created. |
576 +=======================================================================*/
577 PROCEDURE set_bank_branch_end_date (
578 p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
579 p_branch_id IN NUMBER,
580 p_end_date IN DATE,
581 p_object_version_number IN OUT NOCOPY NUMBER,
582 x_return_status OUT NOCOPY VARCHAR2,
583 x_msg_count OUT NOCOPY NUMBER,
584 x_msg_data OUT NOCOPY VARCHAR2
585 );
586
587
588 /*=======================================================================+
589 | PUBLIC PROCEDURE check_branch_exist |
590 | |
591 | DESCRIPTION |
592 | Check whether a bank branch already exists. |
593 | |
594 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
595 | |
596 | ARGUMENTS |
597 | IN: |
598 | p_bank_id Bank Party ID. |
599 | p_branch_name Bank branch name. |
600 | IN/OUT: |
601 | OUT: |
602 | x_branch_id Bank branch Party ID if branch exists, |
603 | null if branch does not already exist. |
604 | |
605 | MODIFICATION HISTORY |
606 | 25-AUG-2004 Xin Wang Created. |
607 +=======================================================================*/
608 PROCEDURE check_branch_exist(
609 p_bank_id IN NUMBER,
610 p_branch_name IN VARCHAR2,
611 p_branch_number IN VARCHAR2,
612 x_branch_id OUT NOCOPY NUMBER,
613 x_end_date OUT NOCOPY DATE
614 );
615
616
617
618 /*=======================================================================+
619 | PUBLIC PROCEDURE create_bank_acct |
620 | |
621 | DESCRIPTION |
622 | Create an internal or subsidiary bank account. |
623 | |
624 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
625 | |
626 | ARGUMENTS |
627 | IN: |
628 | p_init_msg_list Initialize message stack if it is set to |
629 | FND_API.G_TRUE. Default is fnd_api.g_false |
630 | p_acct_rec Bank account record. |
631 | IN/OUT: |
632 | OUT: |
633 | x_acct_id Bank account ID. |
634 | x_return_status Return status after the call. The status can |
635 | be FND_API.G_RET_STS_SUCCESS (success), |
636 | fnd_api.g_ret_sts_error (error), |
637 | fnd_api.g_ret_sts_unexp_error (unexpected |
638 | error). |
639 | x_msg_count Number of messages in message stack. |
640 | x_msg_data Message text if x_msg_count is 1. |
641 | MODIFICATION HISTORY |
642 | 25-AUG-2004 Xin Wang Created. |
643 +=======================================================================*/
644 PROCEDURE create_bank_acct (
645 p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
646 p_acct_rec IN BankAcct_rec_type,
647 x_acct_id OUT NOCOPY NUMBER,
648 x_return_status OUT NOCOPY VARCHAR2,
649 x_msg_count OUT NOCOPY NUMBER,
650 x_msg_data OUT NOCOPY VARCHAR2
651 );
652
653
654 /*=======================================================================+
655 | PUBLIC PROCEDURE update_bank_acct |
656 | |
657 | DESCRIPTION |
658 | Update an internal or subsidiary bank account. |
659 | |
660 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
661 | |
662 | ARGUMENTS |
663 | IN: |
664 | p_init_msg_list Initialize message stack if it is set to |
665 | FND_API.G_TRUE. Default is fnd_api.g_false
666 | p_acct_rec External bank account record. |
667 | IN/OUT: |
668 | p_object_version_number Current object version number for the |
669 | bank account. |
670 | OUT: |
671 | x_return_status Return status after the call. The status can |
672 | be FND_API.G_RET_STS_SUCCESS (success), |
673 | fnd_api.g_ret_sts_error (error), |
674 | fnd_api.g_ret_sts_unexp_error (unexpected |
675 | error). |
676 | x_msg_count Number of messages in message stack. |
677 | x_msg_data Message text if x_msg_count is 1. |
678 | MODIFICATION HISTORY |
679 | 25-AUG-2004 Xin Wang Created. |
680 +=======================================================================*/
681 PROCEDURE update_bank_acct (
682 p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
683 p_acct_rec IN BankAcct_rec_type,
684 p_object_version_number IN OUT NOCOPY NUMBER,
685 x_return_status OUT NOCOPY VARCHAR2,
686 x_msg_count OUT NOCOPY NUMBER,
687 x_msg_data OUT NOCOPY VARCHAR2
688 );
689
690
691 PROCEDURE create_bank_acct_use (
692 p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
693 p_acct_use_rec IN BankAcct_use_rec_type,
694 x_acct_use_id OUT NOCOPY NUMBER,
695 x_return_status OUT NOCOPY VARCHAR2,
696 x_msg_count OUT NOCOPY NUMBER,
697 x_msg_data OUT NOCOPY VARCHAR2
698 );
699
700
701 PROCEDURE update_bank_acct_use (
702 p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
703 p_acct_use_rec IN BankAcct_use_rec_type,
704 p_use_ovn IN OUT NOCOPY NUMBER,
705 p_ccid_ovn IN OUT NOCOPY NUMBER,
706 x_return_status OUT NOCOPY VARCHAR2,
707 x_msg_count OUT NOCOPY NUMBER,
708 x_msg_data OUT NOCOPY VARCHAR2
709 );
710
711
712
713 END ce_bank_pub;