219: -- Initial version : 1.0
220: --
221: PROCEDURE create_ext_bank (
222: p_api_version IN NUMBER,
223: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
224: p_ext_bank_rec IN ExtBank_rec_type,
225: x_bank_id OUT NOCOPY NUMBER,
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,
241: -- Initial version : 1.0
242: --
243: PROCEDURE update_ext_bank (
244: p_api_version IN NUMBER,
245: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
246: p_ext_bank_rec IN ExtBank_rec_type,
247: x_return_status OUT NOCOPY VARCHAR2,
248: x_msg_count OUT NOCOPY NUMBER,
249: x_msg_data OUT NOCOPY VARCHAR2,
262: -- Initial version : 1.0
263: --
264: PROCEDURE set_bank_end_date (
265: p_api_version IN NUMBER,
266: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
267: p_bank_id IN NUMBER,
268: p_end_date IN DATE,
269: x_return_status OUT NOCOPY VARCHAR2,
270: x_msg_count OUT NOCOPY NUMBER,
285: -- Initial version : 1.0
286: --
287: PROCEDURE check_bank_exist (
288: p_api_version IN NUMBER,
289: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
290: p_country_code IN VARCHAR2,
291: p_bank_name IN VARCHAR2,
292: p_bank_number IN VARCHAR2,
293: x_return_status OUT NOCOPY VARCHAR2,
310: -- Initial version : 1.0
311: --
312: PROCEDURE create_ext_bank_branch (
313: p_api_version IN NUMBER,
314: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
315: p_ext_bank_branch_rec IN ExtBankBranch_rec_type,
316: x_branch_id OUT NOCOPY NUMBER,
317: x_return_status OUT NOCOPY VARCHAR2,
318: x_msg_count OUT NOCOPY NUMBER,
332: -- Initial version : 1.0
333: --
334: PROCEDURE update_ext_bank_branch (
335: p_api_version IN NUMBER,
336: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
337: p_ext_bank_branch_rec IN OUT NOCOPY ExtBankBranch_rec_type,
338: x_return_status OUT NOCOPY VARCHAR2,
339: x_msg_count OUT NOCOPY NUMBER,
340: x_msg_data OUT NOCOPY VARCHAR2,
353: -- Initial version : 1.0
354: --
355: PROCEDURE set_ext_bank_branch_end_date (
356: p_api_version IN NUMBER,
357: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
358: p_branch_id IN NUMBER,
359: p_end_date IN DATE,
360: x_return_status OUT NOCOPY VARCHAR2,
361: x_msg_count OUT NOCOPY NUMBER,
376: -- Initial version : 1.0
377: --
378: PROCEDURE check_ext_bank_branch_exist (
379: p_api_version IN NUMBER,
380: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
381: p_bank_id IN NUMBER,
382: p_branch_name IN VARCHAR2,
383: p_branch_number IN VARCHAR2,
384: x_return_status OUT NOCOPY VARCHAR2,
401: -- Initial version : 1.0
402: --
403: PROCEDURE create_ext_bank_acct (
404: p_api_version IN NUMBER,
405: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
406: p_ext_bank_acct_rec IN ExtBankAcct_rec_type,
407: x_acct_id OUT NOCOPY NUMBER,
408: x_return_status OUT NOCOPY VARCHAR2,
409: x_msg_count OUT NOCOPY NUMBER,
440: -- Initial version : 1.0
441: --
442: PROCEDURE update_ext_bank_acct (
443: p_api_version IN NUMBER,
444: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
445: p_ext_bank_acct_rec IN OUT NOCOPY ExtBankAcct_rec_type,
446: x_return_status OUT NOCOPY VARCHAR2,
447: x_msg_count OUT NOCOPY NUMBER,
448: x_msg_data OUT NOCOPY VARCHAR2,
461: -- Initial version : 1.0
462: --
463: PROCEDURE get_ext_bank_acct (
464: p_api_version IN NUMBER,
465: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
466: p_bankacct_id IN NUMBER,
467: x_return_status OUT NOCOPY VARCHAR2,
468: x_msg_count OUT NOCOPY NUMBER,
469: x_msg_data OUT NOCOPY VARCHAR2,
484: -- Initial version : 1.0
485: --
486: PROCEDURE get_ext_bank_acct (
487: p_api_version IN NUMBER,
488: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
489: p_bankacct_id IN NUMBER,
490: p_sec_key IN VARCHAR2,
491: x_return_status OUT NOCOPY VARCHAR2,
492: x_msg_count OUT NOCOPY NUMBER,
507: -- Initial version : 1.0
508: --
509: PROCEDURE set_ext_bank_acct_dates (
510: p_api_version IN NUMBER,
511: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
512: p_acct_id IN NUMBER,
513: p_start_date IN DATE,
514: p_end_date IN DATE,
515: p_object_version_number IN OUT NOCOPY NUMBER,
533: -- Initial version : 1.0
534: --
535: PROCEDURE check_ext_acct_exist(
536: p_api_version IN NUMBER,
537: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
538: p_ext_bank_acct_rec IN ExtBankAcct_rec_type,
539: x_acct_id OUT NOCOPY NUMBER,
540: x_start_date OUT NOCOPY DATE,
541: x_end_date OUT NOCOPY DATE,
567: -- Initial version : 1.0
568: --
569: PROCEDURE check_ext_acct_exist(
570: p_api_version IN NUMBER,
571: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
572: p_bank_id IN varchar2,
573: p_branch_id IN NUMBER,
574: p_acct_number IN VARCHAR2,
575: p_acct_name IN VARCHAR2,
596: -- Initial version : 1.0
597: --
598: PROCEDURE create_intermediary_acct (
599: p_api_version IN NUMBER,
600: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
601: p_intermed_acct_rec IN IntermediaryAcct_rec_type,
602: x_intermediary_acct_id OUT NOCOPY NUMBER,
603: x_return_status OUT NOCOPY VARCHAR2,
604: x_msg_count OUT NOCOPY NUMBER,
618: -- Initial version : 1.0
619: --
620: PROCEDURE update_intermediary_acct (
621: p_api_version IN NUMBER,
622: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
623: p_intermed_acct_rec IN OUT NOCOPY IntermediaryAcct_rec_type,
624: x_return_status OUT NOCOPY VARCHAR2,
625: x_msg_count OUT NOCOPY NUMBER,
626: x_msg_data OUT NOCOPY VARCHAR2,
639: -- Initial version : 1.0
640: --
641: PROCEDURE add_joint_account_owner (
642: p_api_version IN NUMBER,
643: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
644: p_bank_account_id IN NUMBER,
645: p_acct_owner_party_id IN NUMBER,
646: x_joint_acct_owner_id OUT NOCOPY NUMBER,
647: x_return_status OUT NOCOPY VARCHAR2,
662: -- Initial version : 1.0
663: --
664: PROCEDURE set_joint_acct_owner_end_date (
665: p_api_version IN NUMBER,
666: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
667: p_acct_owner_id IN NUMBER,
668: p_end_date IN DATE,
669: p_object_version_number IN OUT NOCOPY NUMBER,
670: x_return_status OUT NOCOPY VARCHAR2,
685: -- Initial version : 1.0
686: --
687: PROCEDURE change_primary_acct_owner (
688: p_api_version IN NUMBER,
689: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
690: p_bank_acct_id IN NUMBER,
691: p_acct_owner_party_id IN NUMBER,
692: x_return_status OUT NOCOPY VARCHAR2,
693: x_msg_count OUT NOCOPY NUMBER,
708: -- Initial version : 1.0
709: --
710: PROCEDURE check_bank_acct_owner (
711: p_api_version IN NUMBER,
712: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
713: p_bank_acct_id IN NUMBER,
714: p_acct_owner_party_id IN NUMBER,
715: x_return_status OUT NOCOPY VARCHAR2,
716: x_msg_count OUT NOCOPY NUMBER,
772: -- Type : Private
773: -- Purpose : Remasks secured bank account attributes
774: --
775: PROCEDURE Remask_Accounts
776: (p_commit IN VARCHAR2 := FND_API.G_TRUE,
777: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE
778: );
779:
780: -- 104. Encrypt_Accounts