[Home] [Help]
PACKAGE: APPS.CE_BANK_PUB
Source
1 PACKAGE ce_bank_pub AUTHID CURRENT_USER AS
2 /*$Header: ceextbas.pls 120.7 2011/05/31 10:17:32 vnetan 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, -- Bug 9665618
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 | 05-MAR-2009 TALAPATI Added a new parameter p_country_validate |
266 | to enable or disable the country specific |
267 | validation.(Bug #8286747) |
268 +=======================================================================*/
269 PROCEDURE update_bank (
270 p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
271 p_bank_id IN NUMBER,
272 p_bank_name IN VARCHAR2,
273 p_bank_number IN VARCHAR2 DEFAULT NULL,
274 p_alternate_bank_name IN VARCHAR2 DEFAULT NULL,
275 p_short_bank_name IN VARCHAR2 DEFAULT NULL,
276 p_description IN VARCHAR2 DEFAULT NULL,
277 p_tax_payer_id IN VARCHAR2 DEFAULT NULL,
278 p_tax_registration_number IN VARCHAR2 DEFAULT NULL,
279 p_attribute_category IN VARCHAR2 DEFAULT NULL,
280 p_attribute1 IN VARCHAR2 DEFAULT NULL,
281 p_attribute2 IN VARCHAR2 DEFAULT NULL,
282 p_attribute3 IN VARCHAR2 DEFAULT NULL,
283 p_attribute4 IN VARCHAR2 DEFAULT NULL,
284 p_attribute5 IN VARCHAR2 DEFAULT NULL,
285 p_attribute6 IN VARCHAR2 DEFAULT NULL,
286 p_attribute7 IN VARCHAR2 DEFAULT NULL,
287 p_attribute8 IN VARCHAR2 DEFAULT NULL,
288 p_attribute9 IN VARCHAR2 DEFAULT NULL,
289 p_attribute10 IN VARCHAR2 DEFAULT NULL,
290 p_attribute11 IN VARCHAR2 DEFAULT NULL,
291 p_attribute12 IN VARCHAR2 DEFAULT NULL,
292 p_attribute13 IN VARCHAR2 DEFAULT NULL,
293 p_attribute14 IN VARCHAR2 DEFAULT NULL,
294 p_attribute15 IN VARCHAR2 DEFAULT NULL,
295 p_attribute16 IN VARCHAR2 DEFAULT NULL,
296 p_attribute17 IN VARCHAR2 DEFAULT NULL,
297 p_attribute18 IN VARCHAR2 DEFAULT NULL,
298 p_attribute19 IN VARCHAR2 DEFAULT NULL,
302 p_attribute23 IN VARCHAR2 DEFAULT NULL,
299 p_attribute20 IN VARCHAR2 DEFAULT NULL,
300 p_attribute21 IN VARCHAR2 DEFAULT NULL,
301 p_attribute22 IN VARCHAR2 DEFAULT NULL,
303 p_attribute24 IN VARCHAR2 DEFAULT NULL,
304 p_country_validate IN VARCHAR2 DEFAULT 'Y',
305 p_object_version_number IN OUT NOCOPY NUMBER,
306 x_return_status OUT NOCOPY VARCHAR2,
307 x_msg_count OUT NOCOPY NUMBER,
308 x_msg_data OUT NOCOPY VARCHAR2
309 );
310
311
312 /*=======================================================================+
313 | PUBLIC PROCEDURE set_bank_end_date |
314 | |
315 | DESCRIPTION |
316 | Set the end date of a bank. |
317 | |
318 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
319 | hz_bank_pub.update_bank |
320 | |
321 | ARGUMENTS |
322 | IN: |
323 | p_init_msg_list Initialize message stack if it is set to |
324 | FND_API.G_TRUE. Default is fnd_api.g_false
325 | p_bank_id Party ID of the bank to be updated. |
326 | p_end_date End date of the bank. |
327 | IN/OUT: |
328 | p_object_version_number Current object version number for the code|
329 | assignment for the bank institution type. |
330 | OUT: |
331 | x_return_status Return status after the call. The status can |
332 | be FND_API.G_RET_STS_SUCCESS (success), |
333 | fnd_api.g_ret_sts_error (error), |
334 | fnd_api.g_ret_sts_unexp_error (unexpected |
335 | error). |
336 | x_msg_count Number of messages in message stack. |
337 | x_msg_data Message text if x_msg_count is 1. |
338 | MODIFICATION HISTORY |
339 | 25-AUG-2004 Xin Wang Created. |
340 +=======================================================================*/
341 PROCEDURE set_bank_end_date (
342 p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
343 p_bank_id IN NUMBER,
344 p_end_date IN DATE,
345 p_object_version_number IN OUT NOCOPY NUMBER,
346 x_return_status OUT NOCOPY VARCHAR2,
347 x_msg_count OUT NOCOPY NUMBER,
348 x_msg_data OUT NOCOPY VARCHAR2
349 );
350
351
352 /*=======================================================================+
353 | PUBLIC PROCEDURE check_bank_exist |
354 | |
355 | DESCRIPTION |
356 | Check whether a bank already exists, if so, return the bank ID. |
357 | |
358 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
359 | |
360 | ARGUMENTS |
361 | IN: |
362 | p_country_code Country code. |
363 | p_bank_name Bank name. |
364 | p_bank_number Bank number. |
365 | IN/OUT: |
366 | OUT: |
367 | x_bank_id Bank Party ID if bank exists, |
368 | null if bank does not exist. |
369 | x_end_date End date of the bank. |
370 | |
371 | MODIFICATION HISTORY |
372 | 25-AUG-2004 Xin Wang Created. |
373 +=======================================================================*/
374 PROCEDURE check_bank_exist(
375 p_country_code IN VARCHAR2,
376 p_bank_name IN VARCHAR2,
377 p_bank_number IN VARCHAR2,
378 x_bank_id OUT NOCOPY NUMBER,
379 x_end_date OUT NOCOPY DATE
380 );
381
382
383
384 /*=======================================================================+
385 | PUBLIC PROCEDURE create_bank_branch |
386 | |
387 | DESCRIPTION |
388 | Create a bank branch as a TCA organization party. |
389 | |
393 | ARGUMENTS |
390 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
391 | hz_bank_pub.create_bank_branch |
392 | |
394 | IN: |
395 | p_init_msg_list Initialize message stack if it is set to |
396 | FND_API.G_TRUE. Default is fnd_api.g_false
397 | p_bank_party_id Party ID of the bank that the branch |
398 | belongs. |
399 | p_branch_name Bank branch name. |
400 | p_branch_number Bank branch number. |
401 | p_branch_type Bank branch type. |
402 | p_alternate_branch_name Alternate bank branch name. |
403 | p_description Description. |
404 | p_bic BIC (Bank Identification Code). |
405 | p_eft_number EFT number. |
406 | p_rfc_identifier Regional Finance Center Identifier. |
407 | IN/OUT: |
408 | OUT: |
409 | x_branch_id Party ID for the bank branch. |
410 | x_return_status Return status after the call. The status can |
411 | be FND_API.G_RET_STS_SUCCESS (success), |
412 | fnd_api.g_ret_sts_error (error), |
413 | fnd_api.g_ret_sts_unexp_error (unexpected |
414 | error). |
415 | x_msg_count Number of messages in message stack. |
416 | x_msg_data Message text if x_msg_count is 1. |
417 | MODIFICATION HISTORY |
418 | 25-AUG-2004 Xin Wang Created. |
419 +=======================================================================*/
420 PROCEDURE create_bank_branch (
421 p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
422 p_bank_id IN NUMBER,
423 p_branch_name IN VARCHAR2,
424 p_branch_number IN VARCHAR2 DEFAULT NULL,
425 p_branch_type IN VARCHAR2 DEFAULT NULL,
426 p_alternate_branch_name IN VARCHAR2 DEFAULT NULL,
427 p_description IN VARCHAR2 DEFAULT NULL,
428 p_bic IN VARCHAR2 DEFAULT NULL,
429 p_eft_number IN VARCHAR2 DEFAULT NULL,
430 p_rfc_identifier IN VARCHAR2 DEFAULT NULL,
431 p_attribute_category IN VARCHAR2 DEFAULT NULL,
432 p_attribute1 IN VARCHAR2 DEFAULT NULL,
433 p_attribute2 IN VARCHAR2 DEFAULT NULL,
434 p_attribute3 IN VARCHAR2 DEFAULT NULL,
435 p_attribute4 IN VARCHAR2 DEFAULT NULL,
436 p_attribute5 IN VARCHAR2 DEFAULT NULL,
437 p_attribute6 IN VARCHAR2 DEFAULT NULL,
438 p_attribute7 IN VARCHAR2 DEFAULT NULL,
439 p_attribute8 IN VARCHAR2 DEFAULT NULL,
440 p_attribute9 IN VARCHAR2 DEFAULT NULL,
441 p_attribute10 IN VARCHAR2 DEFAULT NULL,
442 p_attribute11 IN VARCHAR2 DEFAULT NULL,
443 p_attribute12 IN VARCHAR2 DEFAULT NULL,
444 p_attribute13 IN VARCHAR2 DEFAULT NULL,
445 p_attribute14 IN VARCHAR2 DEFAULT NULL,
446 p_attribute15 IN VARCHAR2 DEFAULT NULL,
447 p_attribute16 IN VARCHAR2 DEFAULT NULL,
448 p_attribute17 IN VARCHAR2 DEFAULT NULL,
449 p_attribute18 IN VARCHAR2 DEFAULT NULL,
450 p_attribute19 IN VARCHAR2 DEFAULT NULL,
451 p_attribute20 IN VARCHAR2 DEFAULT NULL,
452 p_attribute21 IN VARCHAR2 DEFAULT NULL,
453 p_attribute22 IN VARCHAR2 DEFAULT NULL,
454 p_attribute23 IN VARCHAR2 DEFAULT NULL,
455 p_attribute24 IN VARCHAR2 DEFAULT NULL,
456 x_branch_id OUT NOCOPY NUMBER,
457 x_return_status OUT NOCOPY VARCHAR2,
458 x_msg_count OUT NOCOPY NUMBER,
459 x_msg_data OUT NOCOPY VARCHAR2
460 );
461
462
463 /*=======================================================================+
464 | PUBLIC PROCEDURE update_bank_branch |
465 | |
466 | DESCRIPTION |
467 | Update a bank branch organization party in TCA. |
468 | |
469 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
470 | hz_bank_pub.update_bank_branch |
471 | |
472 | ARGUMENTS |
476 | p_branch_id Party ID of the branch to be updated. |
473 | IN: |
474 | p_init_msg_list Initialize message stack if it is set to |
475 | FND_API.G_TRUE. Default is fnd_api.g_false
477 | p_branch_name Bank branch name. |
478 | p_branch_number Bank branch number. |
479 | p_branch_type Bank branch type. |
480 | p_alternate_branch_name Alternate bank branch name. |
481 | p_description Description. |
482 | p_bic BIC (Bank Identification Code). |
483 | p_eft_number EFT number. |
484 | p_rfc_identifier RFC Identifier. |
485 | IN/OUT: |
486 | p_bch_object_version_number Current object version number for |
487 | the bank branch. |
488 | p_typ_object_version_number Current object version number for |
489 | bank branch type code assignment. |
490 | p_rfc_object_version_number Current object version number for |
491 | RFC code assignment. |
492 | p_eft_object_version_number Current object version number for |
493 | BIC(EFT) contact point. |
494 | OUT: |
495 | x_return_status Return status after the call. The status can |
496 | be FND_API.G_RET_STS_SUCCESS (success), |
497 | fnd_api.g_ret_sts_error (error), |
498 | fnd_api.g_ret_sts_unexp_error (unexpected |
499 | error). |
500 | x_msg_count Number of messages in message stack. |
501 | x_msg_data Message text if x_msg_count is 1. |
502 | MODIFICATION HISTORY |
503 | 25-AUG-2004 Xin Wang Created. |
504 | 05-MAR-2009 TALAPATI Added a new parameter p_country_validate |
505 | to enable or disable the country specific |
506 | validation.(Bug #8286747) |
507 +=======================================================================*/
508 PROCEDURE update_bank_branch (
509 p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
510 p_branch_id IN NUMBER,
511 p_branch_name IN VARCHAR2,
512 p_branch_number IN VARCHAR2 DEFAULT NULL,
513 p_branch_type IN VARCHAR2 DEFAULT NULL,
514 p_alternate_branch_name IN VARCHAR2 DEFAULT NULL,
515 p_description IN VARCHAR2 DEFAULT NULL,
516 p_bic IN VARCHAR2 DEFAULT NULL,
517 p_eft_number IN VARCHAR2 DEFAULT NULL,
518 p_rfc_identifier IN VARCHAR2 DEFAULT NULL,
519 p_attribute_category IN VARCHAR2 DEFAULT NULL,
520 p_attribute1 IN VARCHAR2 DEFAULT NULL,
521 p_attribute2 IN VARCHAR2 DEFAULT NULL,
522 p_attribute3 IN VARCHAR2 DEFAULT NULL,
523 p_attribute4 IN VARCHAR2 DEFAULT NULL,
524 p_attribute5 IN VARCHAR2 DEFAULT NULL,
525 p_attribute6 IN VARCHAR2 DEFAULT NULL,
526 p_attribute7 IN VARCHAR2 DEFAULT NULL,
527 p_attribute8 IN VARCHAR2 DEFAULT NULL,
528 p_attribute9 IN VARCHAR2 DEFAULT NULL,
529 p_attribute10 IN VARCHAR2 DEFAULT NULL,
530 p_attribute11 IN VARCHAR2 DEFAULT NULL,
531 p_attribute12 IN VARCHAR2 DEFAULT NULL,
532 p_attribute13 IN VARCHAR2 DEFAULT NULL,
533 p_attribute14 IN VARCHAR2 DEFAULT NULL,
534 p_attribute15 IN VARCHAR2 DEFAULT NULL,
535 p_attribute16 IN VARCHAR2 DEFAULT NULL,
536 p_attribute17 IN VARCHAR2 DEFAULT NULL,
537 p_attribute18 IN VARCHAR2 DEFAULT NULL,
538 p_attribute19 IN VARCHAR2 DEFAULT NULL,
539 p_attribute20 IN VARCHAR2 DEFAULT NULL,
540 p_attribute21 IN VARCHAR2 DEFAULT NULL,
541 p_attribute22 IN VARCHAR2 DEFAULT NULL,
542 p_attribute23 IN VARCHAR2 DEFAULT NULL,
543 p_attribute24 IN VARCHAR2 DEFAULT NULL,
544 p_country_validate IN VARCHAR2 DEFAULT 'Y',
545 p_bch_object_version_number IN OUT NOCOPY NUMBER,
546 p_typ_object_version_number IN OUT NOCOPY NUMBER,
547 p_rfc_object_version_number IN OUT NOCOPY NUMBER,
548 p_eft_object_version_number IN OUT NOCOPY NUMBER,
549 x_return_status OUT NOCOPY VARCHAR2,
550 x_msg_count OUT NOCOPY NUMBER,
551 x_msg_data OUT NOCOPY VARCHAR2
552 );
553
554
555 /*=======================================================================+
556 | PUBLIC PROCEDURE set_bank_branch_end_date |
560 | |
557 | |
558 | DESCRIPTION |
559 | Set the end date of a bank branch. |
561 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
562 | hz_bank_pub.update_bank |
563 | |
564 | ARGUMENTS |
565 | IN: |
566 | p_init_msg_list Initialize message stack if it is set to |
567 | FND_API.G_TRUE. Default is fnd_api.g_false
568 | p_branch_id Party ID of the branch to be inactivated.|
569 | p_end_date Inactive date of the bank branch. |
570 | IN/OUT: |
571 | p_object_version_number Current object version number for the |
572 | code assignment of the bank institution|
573 | type for the bank branch. |
574 | OUT: |
575 | x_return_status Return status after the call. The status can |
576 | be FND_API.G_RET_STS_SUCCESS (success), |
577 | fnd_api.g_ret_sts_error (error), |
578 | fnd_api.g_ret_sts_unexp_error (unexpected |
579 | error). |
580 | x_msg_count Number of messages in message stack. |
581 | x_msg_data Message text if x_msg_count is 1. |
582 | MODIFICATION HISTORY |
583 | 25-AUG-2004 Xin Wang Created. |
584 +=======================================================================*/
585 PROCEDURE set_bank_branch_end_date (
586 p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
587 p_branch_id IN NUMBER,
588 p_end_date IN DATE,
589 p_object_version_number IN OUT NOCOPY NUMBER,
590 x_return_status OUT NOCOPY VARCHAR2,
591 x_msg_count OUT NOCOPY NUMBER,
592 x_msg_data OUT NOCOPY VARCHAR2
593 );
594
595
596 /*=======================================================================+
597 | PUBLIC PROCEDURE check_branch_exist |
598 | |
599 | DESCRIPTION |
600 | Check whether a bank branch already exists. |
601 | |
602 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
603 | |
604 | ARGUMENTS |
605 | IN: |
606 | p_bank_id Bank Party ID. |
607 | p_branch_name Bank branch name. |
608 | IN/OUT: |
609 | OUT: |
610 | x_branch_id Bank branch Party ID if branch exists, |
611 | null if branch does not already exist. |
612 | |
613 | MODIFICATION HISTORY |
614 | 25-AUG-2004 Xin Wang Created. |
615 +=======================================================================*/
616 PROCEDURE check_branch_exist(
617 p_bank_id IN NUMBER,
618 p_branch_name IN VARCHAR2,
619 p_branch_number IN VARCHAR2,
620 x_branch_id OUT NOCOPY NUMBER,
621 x_end_date OUT NOCOPY DATE
622 );
623
624
625
626 /*=======================================================================+
627 | PUBLIC PROCEDURE create_bank_acct |
628 | |
629 | DESCRIPTION |
630 | Create an internal or subsidiary bank account. |
631 | |
632 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
633 | |
634 | ARGUMENTS |
635 | IN: |
636 | p_init_msg_list Initialize message stack if it is set to |
637 | FND_API.G_TRUE. Default is fnd_api.g_false |
638 | p_acct_rec Bank account record. |
639 | IN/OUT: |
640 | OUT: |
641 | x_acct_id Bank account ID. |
645 | fnd_api.g_ret_sts_unexp_error (unexpected |
642 | x_return_status Return status after the call. The status can |
643 | be FND_API.G_RET_STS_SUCCESS (success), |
644 | fnd_api.g_ret_sts_error (error), |
646 | error). |
647 | x_msg_count Number of messages in message stack. |
648 | x_msg_data Message text if x_msg_count is 1. |
649 | MODIFICATION HISTORY |
650 | 25-AUG-2004 Xin Wang Created. |
651 +=======================================================================*/
652 PROCEDURE create_bank_acct (
653 p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
654 p_acct_rec IN BankAcct_rec_type,
655 x_acct_id OUT NOCOPY NUMBER,
656 x_return_status OUT NOCOPY VARCHAR2,
657 x_msg_count OUT NOCOPY NUMBER,
658 x_msg_data OUT NOCOPY VARCHAR2
659 );
660
661
662 /*=======================================================================+
663 | PUBLIC PROCEDURE update_bank_acct |
664 | |
665 | DESCRIPTION |
666 | Update an internal or subsidiary bank account. |
667 | |
668 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
669 | |
670 | ARGUMENTS |
671 | IN: |
672 | p_init_msg_list Initialize message stack if it is set to |
673 | FND_API.G_TRUE. Default is fnd_api.g_false
674 | p_acct_rec External bank account record. |
675 | IN/OUT: |
676 | p_object_version_number Current object version number for the |
677 | bank account. |
678 | OUT: |
679 | x_return_status Return status after the call. The status can |
680 | be FND_API.G_RET_STS_SUCCESS (success), |
681 | fnd_api.g_ret_sts_error (error), |
682 | fnd_api.g_ret_sts_unexp_error (unexpected |
683 | error). |
684 | x_msg_count Number of messages in message stack. |
685 | x_msg_data Message text if x_msg_count is 1. |
686 | MODIFICATION HISTORY |
687 | 25-AUG-2004 Xin Wang Created. |
688 +=======================================================================*/
689 PROCEDURE update_bank_acct (
690 p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
691 p_acct_rec IN BankAcct_rec_type,
692 p_object_version_number IN OUT NOCOPY NUMBER,
693 x_return_status OUT NOCOPY VARCHAR2,
694 x_msg_count OUT NOCOPY NUMBER,
695 x_msg_data OUT NOCOPY VARCHAR2
696 );
697
698
699 PROCEDURE create_bank_acct_use (
700 p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
701 p_acct_use_rec IN BankAcct_use_rec_type,
702 x_acct_use_id OUT NOCOPY NUMBER,
703 x_return_status OUT NOCOPY VARCHAR2,
704 x_msg_count OUT NOCOPY NUMBER,
705 x_msg_data OUT NOCOPY VARCHAR2
706 );
707
708
709 PROCEDURE update_bank_acct_use (
710 p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
711 p_acct_use_rec IN BankAcct_use_rec_type,
712 p_use_ovn IN OUT NOCOPY NUMBER,
713 p_ccid_ovn IN OUT NOCOPY NUMBER,
714 x_return_status OUT NOCOPY VARCHAR2,
715 x_msg_count OUT NOCOPY NUMBER,
716 x_msg_data OUT NOCOPY VARCHAR2
717 );
718
722 | |
719 -- 12557352 : Added procedure
720 /*=======================================================================+
721 | PUBLIC PROCEDURE set_bank_acct_end_date |
723 | DESCRIPTION |
724 | Set the end date of an internal or subsidiary bank account. |
725 | |
726 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
727 | |
728 | ARGUMENTS |
729 | IN: |
730 | p_init_msg_list Initialize message stack if it is set to |
731 | FND_API.G_TRUE. Default is fnd_api.g_false|
732 | p_bank_acct_id ID of the Internal Bank account to be |
733 | inactivated. |
734 | p_end_date Inactive date of the bank account |
735 | |
736 | |
737 | IN/OUT: |
738 | p_object_version_number Current object version number for the |
739 | bank account. |
740 | OUT: |
741 | x_return_status Return status after the call. The status can |
742 | be FND_API.G_RET_STS_SUCCESS (success), |
743 | fnd_api.g_ret_sts_error (error), |
744 | fnd_api.g_ret_sts_unexp_error (unexpected |
745 | error). |
746 | x_msg_count Number of messages in message stack. |
747 | x_msg_data Message text if x_msg_count is 1. |
748 | MODIFICATION HISTORY |
749 | 18-MAY-2011 vnetan Created. |
750 +=======================================================================*/
751 PROCEDURE set_bank_acct_end_date (
752 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
753 p_bank_acct_id IN NUMBER,
754 p_end_date IN DATE,
755 p_object_version_number IN OUT NOCOPY NUMBER,
756 x_return_status OUT NOCOPY VARCHAR2,
757 x_msg_count OUT NOCOPY NUMBER,
758 x_msg_data OUT NOCOPY VARCHAR2
759 );
760
761 END ce_bank_pub;