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.

APPS.ARP_EXT_BANK_PKG dependencies on IBY_EXT_BANK_ACCOUNTS_V

Line 20: p_credit_card_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE,

16: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
17: g_default_country ar_system_parameters.default_country%type;
18:
19: PROCEDURE strip_white_spaces(
20: p_credit_card_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
21: p_stripped_cc_num OUT NOCOPY iby_ext_bank_accounts_v.bank_account_number%TYPE
22: ) IS
23:
24: TYPE character_tab_typ IS TABLE of char(1) INDEX BY BINARY_INTEGER;

Line 21: p_stripped_cc_num OUT NOCOPY iby_ext_bank_accounts_v.bank_account_number%TYPE

17: g_default_country ar_system_parameters.default_country%type;
18:
19: PROCEDURE strip_white_spaces(
20: p_credit_card_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
21: p_stripped_cc_num OUT NOCOPY iby_ext_bank_accounts_v.bank_account_number%TYPE
22: ) IS
23:
24: TYPE character_tab_typ IS TABLE of char(1) INDEX BY BINARY_INTEGER;
25: len_credit_card_num number := 0;

Line 324: p_bank_account_name in iby_ext_bank_accounts_v.bank_account_name%type,

320: | |
321: +===========================================================================*/
322:
323: procedure insert_bank_account(
324: p_bank_account_name in iby_ext_bank_accounts_v.bank_account_name%type,
325: p_bank_account_num in iby_ext_bank_accounts_v.bank_account_number%type,
326: p_bank_party_id in iby_ext_bank_accounts_v.bank_party_id%type,
327: p_branch_party_id in iby_ext_bank_accounts_v.branch_party_id%type,
328: p_customer_id in iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,

Line 325: p_bank_account_num in iby_ext_bank_accounts_v.bank_account_number%type,

321: +===========================================================================*/
322:
323: procedure insert_bank_account(
324: p_bank_account_name in iby_ext_bank_accounts_v.bank_account_name%type,
325: p_bank_account_num in iby_ext_bank_accounts_v.bank_account_number%type,
326: p_bank_party_id in iby_ext_bank_accounts_v.bank_party_id%type,
327: p_branch_party_id in iby_ext_bank_accounts_v.branch_party_id%type,
328: p_customer_id in iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,
329: p_description in iby_ext_bank_accounts_v.description%type,

Line 326: p_bank_party_id in iby_ext_bank_accounts_v.bank_party_id%type,

322:
323: procedure insert_bank_account(
324: p_bank_account_name in iby_ext_bank_accounts_v.bank_account_name%type,
325: p_bank_account_num in iby_ext_bank_accounts_v.bank_account_number%type,
326: p_bank_party_id in iby_ext_bank_accounts_v.bank_party_id%type,
327: p_branch_party_id in iby_ext_bank_accounts_v.branch_party_id%type,
328: p_customer_id in iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,
329: p_description in iby_ext_bank_accounts_v.description%type,
330: p_currency_code in iby_ext_bank_accounts_v.currency_code%type DEFAULT NULL,

Line 327: p_branch_party_id in iby_ext_bank_accounts_v.branch_party_id%type,

323: procedure insert_bank_account(
324: p_bank_account_name in iby_ext_bank_accounts_v.bank_account_name%type,
325: p_bank_account_num in iby_ext_bank_accounts_v.bank_account_number%type,
326: p_bank_party_id in iby_ext_bank_accounts_v.bank_party_id%type,
327: p_branch_party_id in iby_ext_bank_accounts_v.branch_party_id%type,
328: p_customer_id in iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,
329: p_description in iby_ext_bank_accounts_v.description%type,
330: p_currency_code in iby_ext_bank_accounts_v.currency_code%type DEFAULT NULL,
331: p_start_date in DATE,

Line 328: p_customer_id in iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,

324: p_bank_account_name in iby_ext_bank_accounts_v.bank_account_name%type,
325: p_bank_account_num in iby_ext_bank_accounts_v.bank_account_number%type,
326: p_bank_party_id in iby_ext_bank_accounts_v.bank_party_id%type,
327: p_branch_party_id in iby_ext_bank_accounts_v.branch_party_id%type,
328: p_customer_id in iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,
329: p_description in iby_ext_bank_accounts_v.description%type,
330: p_currency_code in iby_ext_bank_accounts_v.currency_code%type DEFAULT NULL,
331: p_start_date in DATE,
332: x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%type,

Line 329: p_description in iby_ext_bank_accounts_v.description%type,

325: p_bank_account_num in iby_ext_bank_accounts_v.bank_account_number%type,
326: p_bank_party_id in iby_ext_bank_accounts_v.bank_party_id%type,
327: p_branch_party_id in iby_ext_bank_accounts_v.branch_party_id%type,
328: p_customer_id in iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,
329: p_description in iby_ext_bank_accounts_v.description%type,
330: p_currency_code in iby_ext_bank_accounts_v.currency_code%type DEFAULT NULL,
331: p_start_date in DATE,
332: x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%type,
333: x_return_status OUT NOCOPY VARCHAR2 -- bug 5594142

Line 330: p_currency_code in iby_ext_bank_accounts_v.currency_code%type DEFAULT NULL,

326: p_bank_party_id in iby_ext_bank_accounts_v.bank_party_id%type,
327: p_branch_party_id in iby_ext_bank_accounts_v.branch_party_id%type,
328: p_customer_id in iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,
329: p_description in iby_ext_bank_accounts_v.description%type,
330: p_currency_code in iby_ext_bank_accounts_v.currency_code%type DEFAULT NULL,
331: p_start_date in DATE,
332: x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%type,
333: x_return_status OUT NOCOPY VARCHAR2 -- bug 5594142
334: ) IS

Line 332: x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%type,

328: p_customer_id in iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,
329: p_description in iby_ext_bank_accounts_v.description%type,
330: p_currency_code in iby_ext_bank_accounts_v.currency_code%type DEFAULT NULL,
331: p_start_date in DATE,
332: x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%type,
333: x_return_status OUT NOCOPY VARCHAR2 -- bug 5594142
334: ) IS
335:
336: l_bank_account_id iby_ext_bank_accounts_v.bank_account_id%TYPE;

Line 336: l_bank_account_id iby_ext_bank_accounts_v.bank_account_id%TYPE;

332: x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%type,
333: x_return_status OUT NOCOPY VARCHAR2 -- bug 5594142
334: ) IS
335:
336: l_bank_account_id iby_ext_bank_accounts_v.bank_account_id%TYPE;
337: l_ext_bank_acct_rec iby_ext_bankacct_pub.extbankacct_rec_type;
338: l_bank_acct_response iby_fndcpt_common_pub.result_rec_type;
339: l_party_id iby_ext_bank_accounts_v.primary_acct_owner_party_id%type;
340:

Line 339: l_party_id iby_ext_bank_accounts_v.primary_acct_owner_party_id%type;

335:
336: l_bank_account_id iby_ext_bank_accounts_v.bank_account_id%TYPE;
337: l_ext_bank_acct_rec iby_ext_bankacct_pub.extbankacct_rec_type;
338: l_bank_acct_response iby_fndcpt_common_pub.result_rec_type;
339: l_party_id iby_ext_bank_accounts_v.primary_acct_owner_party_id%type;
340:
341: l_api_version NUMBER := 1.0;
342: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;
343: l_commit VARCHAR2(30) DEFAULT FND_API.G_FALSE;

Line 449: p_account_number IN iby_ext_bank_accounts_v.bank_account_number%TYPE,

445: +===========================================================================*/
446:
447: procedure check_bank_account(
448: p_routing_number IN ce_bank_branches_v.branch_number%TYPE,
449: p_account_number IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
450: p_bank_party_id IN iby_ext_bank_accounts_v.bank_party_id%type,
451: p_branch_party_id IN iby_ext_bank_accounts_v.branch_party_id%type,
452: p_currency_code IN iby_ext_bank_accounts_v.currency_code%type DEFAULT NULL,
453: x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%TYPE,

Line 450: p_bank_party_id IN iby_ext_bank_accounts_v.bank_party_id%type,

446:
447: procedure check_bank_account(
448: p_routing_number IN ce_bank_branches_v.branch_number%TYPE,
449: p_account_number IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
450: p_bank_party_id IN iby_ext_bank_accounts_v.bank_party_id%type,
451: p_branch_party_id IN iby_ext_bank_accounts_v.branch_party_id%type,
452: p_currency_code IN iby_ext_bank_accounts_v.currency_code%type DEFAULT NULL,
453: x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%TYPE,
454: x_start_date OUT NOCOPY iby_ext_bank_accounts_v.start_date%TYPE,

Line 451: p_branch_party_id IN iby_ext_bank_accounts_v.branch_party_id%type,

447: procedure check_bank_account(
448: p_routing_number IN ce_bank_branches_v.branch_number%TYPE,
449: p_account_number IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
450: p_bank_party_id IN iby_ext_bank_accounts_v.bank_party_id%type,
451: p_branch_party_id IN iby_ext_bank_accounts_v.branch_party_id%type,
452: p_currency_code IN iby_ext_bank_accounts_v.currency_code%type DEFAULT NULL,
453: x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%TYPE,
454: x_start_date OUT NOCOPY iby_ext_bank_accounts_v.start_date%TYPE,
455: x_end_date OUT NOCOPY iby_ext_bank_accounts_v.end_date%TYPE,

Line 452: p_currency_code IN iby_ext_bank_accounts_v.currency_code%type DEFAULT NULL,

448: p_routing_number IN ce_bank_branches_v.branch_number%TYPE,
449: p_account_number IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
450: p_bank_party_id IN iby_ext_bank_accounts_v.bank_party_id%type,
451: p_branch_party_id IN iby_ext_bank_accounts_v.branch_party_id%type,
452: p_currency_code IN iby_ext_bank_accounts_v.currency_code%type DEFAULT NULL,
453: x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%TYPE,
454: x_start_date OUT NOCOPY iby_ext_bank_accounts_v.start_date%TYPE,
455: x_end_date OUT NOCOPY iby_ext_bank_accounts_v.end_date%TYPE,
456: x_return_status OUT NOCOPY VARCHAR2 -- 5594142

Line 453: x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%TYPE,

449: p_account_number IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
450: p_bank_party_id IN iby_ext_bank_accounts_v.bank_party_id%type,
451: p_branch_party_id IN iby_ext_bank_accounts_v.branch_party_id%type,
452: p_currency_code IN iby_ext_bank_accounts_v.currency_code%type DEFAULT NULL,
453: x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%TYPE,
454: x_start_date OUT NOCOPY iby_ext_bank_accounts_v.start_date%TYPE,
455: x_end_date OUT NOCOPY iby_ext_bank_accounts_v.end_date%TYPE,
456: x_return_status OUT NOCOPY VARCHAR2 -- 5594142
457: ) IS

Line 454: x_start_date OUT NOCOPY iby_ext_bank_accounts_v.start_date%TYPE,

450: p_bank_party_id IN iby_ext_bank_accounts_v.bank_party_id%type,
451: p_branch_party_id IN iby_ext_bank_accounts_v.branch_party_id%type,
452: p_currency_code IN iby_ext_bank_accounts_v.currency_code%type DEFAULT NULL,
453: x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%TYPE,
454: x_start_date OUT NOCOPY iby_ext_bank_accounts_v.start_date%TYPE,
455: x_end_date OUT NOCOPY iby_ext_bank_accounts_v.end_date%TYPE,
456: x_return_status OUT NOCOPY VARCHAR2 -- 5594142
457: ) IS
458:

Line 455: x_end_date OUT NOCOPY iby_ext_bank_accounts_v.end_date%TYPE,

451: p_branch_party_id IN iby_ext_bank_accounts_v.branch_party_id%type,
452: p_currency_code IN iby_ext_bank_accounts_v.currency_code%type DEFAULT NULL,
453: x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%TYPE,
454: x_start_date OUT NOCOPY iby_ext_bank_accounts_v.start_date%TYPE,
455: x_end_date OUT NOCOPY iby_ext_bank_accounts_v.end_date%TYPE,
456: x_return_status OUT NOCOPY VARCHAR2 -- 5594142
457: ) IS
458:
459: l_bank_account_id iby_ext_bank_accounts_v.bank_account_id%TYPE;

Line 459: l_bank_account_id iby_ext_bank_accounts_v.bank_account_id%TYPE;

455: x_end_date OUT NOCOPY iby_ext_bank_accounts_v.end_date%TYPE,
456: x_return_status OUT NOCOPY VARCHAR2 -- 5594142
457: ) IS
458:
459: l_bank_account_id iby_ext_bank_accounts_v.bank_account_id%TYPE;
460: l_start_date iby_ext_bank_accounts_v.start_date%TYPE;
461: l_end_date iby_ext_bank_accounts_v.end_date%TYPE;
462: l_bank_acct_response iby_fndcpt_common_pub.result_rec_type;
463:

Line 460: l_start_date iby_ext_bank_accounts_v.start_date%TYPE;

456: x_return_status OUT NOCOPY VARCHAR2 -- 5594142
457: ) IS
458:
459: l_bank_account_id iby_ext_bank_accounts_v.bank_account_id%TYPE;
460: l_start_date iby_ext_bank_accounts_v.start_date%TYPE;
461: l_end_date iby_ext_bank_accounts_v.end_date%TYPE;
462: l_bank_acct_response iby_fndcpt_common_pub.result_rec_type;
463:
464: l_api_version NUMBER := 1.0;

Line 461: l_end_date iby_ext_bank_accounts_v.end_date%TYPE;

457: ) IS
458:
459: l_bank_account_id iby_ext_bank_accounts_v.bank_account_id%TYPE;
460: l_start_date iby_ext_bank_accounts_v.start_date%TYPE;
461: l_end_date iby_ext_bank_accounts_v.end_date%TYPE;
462: l_bank_acct_response iby_fndcpt_common_pub.result_rec_type;
463:
464: l_api_version NUMBER := 1.0;
465: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;

Line 554: p_account_number IN iby_ext_bank_accounts_v.bank_account_number%TYPE,

550: | |
551: +===========================================================================*/
552: PROCEDURE create_bank_branch_acc(
553: p_routing_number IN OUT NOCOPY ce_bank_branches_v.branch_number%TYPE,
554: p_account_number IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
555: p_description IN iby_ext_bank_accounts_v.description%type,
556: p_customer_id IN iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,
557: p_currency_code IN iby_ext_bank_accounts_v.currency_code%type DEFAULT NULL,
558: p_start_date IN DATE,

Line 555: p_description IN iby_ext_bank_accounts_v.description%type,

551: +===========================================================================*/
552: PROCEDURE create_bank_branch_acc(
553: p_routing_number IN OUT NOCOPY ce_bank_branches_v.branch_number%TYPE,
554: p_account_number IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
555: p_description IN iby_ext_bank_accounts_v.description%type,
556: p_customer_id IN iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,
557: p_currency_code IN iby_ext_bank_accounts_v.currency_code%type DEFAULT NULL,
558: p_start_date IN DATE,
559: x_bank_party_id OUT NOCOPY ce_bank_branches_v.bank_party_id%TYPE,

Line 556: p_customer_id IN iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,

552: PROCEDURE create_bank_branch_acc(
553: p_routing_number IN OUT NOCOPY ce_bank_branches_v.branch_number%TYPE,
554: p_account_number IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
555: p_description IN iby_ext_bank_accounts_v.description%type,
556: p_customer_id IN iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,
557: p_currency_code IN iby_ext_bank_accounts_v.currency_code%type DEFAULT NULL,
558: p_start_date IN DATE,
559: x_bank_party_id OUT NOCOPY ce_bank_branches_v.bank_party_id%TYPE,
560: x_branch_party_id OUT NOCOPY ce_bank_branches_v.branch_party_id%TYPE,

Line 557: p_currency_code IN iby_ext_bank_accounts_v.currency_code%type DEFAULT NULL,

553: p_routing_number IN OUT NOCOPY ce_bank_branches_v.branch_number%TYPE,
554: p_account_number IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
555: p_description IN iby_ext_bank_accounts_v.description%type,
556: p_customer_id IN iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,
557: p_currency_code IN iby_ext_bank_accounts_v.currency_code%type DEFAULT NULL,
558: p_start_date IN DATE,
559: x_bank_party_id OUT NOCOPY ce_bank_branches_v.bank_party_id%TYPE,
560: x_branch_party_id OUT NOCOPY ce_bank_branches_v.branch_party_id%TYPE,
561: x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%TYPE,

Line 561: x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%TYPE,

557: p_currency_code IN iby_ext_bank_accounts_v.currency_code%type DEFAULT NULL,
558: p_start_date IN DATE,
559: x_bank_party_id OUT NOCOPY ce_bank_branches_v.bank_party_id%TYPE,
560: x_branch_party_id OUT NOCOPY ce_bank_branches_v.branch_party_id%TYPE,
561: x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%TYPE,
562: x_return_status OUT NOCOPY VARCHAR2) IS -- bug5594142
563:
564: /*-----------------------------------------------------+
565: | Cursor to fetch bank branch based on routing number |

Line 576: l_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE;

572: l_routing_number ce_bank_branches_v.bank_number%TYPE;
573: bank_branch_rec bank_branch_cur%ROWTYPE;
574: l_bank_party_id ce_bank_branches_v.bank_party_id%TYPE;
575: l_branch_party_id ce_bank_branches_v.branch_party_id%TYPE;
576: l_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE;
577: l_bank_account_id iby_ext_bank_accounts_v.bank_account_id%TYPE;
578: l_start_date iby_ext_bank_accounts_v.start_date%TYPE;
579: l_end_date iby_ext_bank_accounts_v.end_date%TYPE;
580: l_return_status VARCHAR2(30) ;

Line 577: l_bank_account_id iby_ext_bank_accounts_v.bank_account_id%TYPE;

573: bank_branch_rec bank_branch_cur%ROWTYPE;
574: l_bank_party_id ce_bank_branches_v.bank_party_id%TYPE;
575: l_branch_party_id ce_bank_branches_v.branch_party_id%TYPE;
576: l_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE;
577: l_bank_account_id iby_ext_bank_accounts_v.bank_account_id%TYPE;
578: l_start_date iby_ext_bank_accounts_v.start_date%TYPE;
579: l_end_date iby_ext_bank_accounts_v.end_date%TYPE;
580: l_return_status VARCHAR2(30) ;
581: l_assign_id NUMBER;

Line 578: l_start_date iby_ext_bank_accounts_v.start_date%TYPE;

574: l_bank_party_id ce_bank_branches_v.bank_party_id%TYPE;
575: l_branch_party_id ce_bank_branches_v.branch_party_id%TYPE;
576: l_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE;
577: l_bank_account_id iby_ext_bank_accounts_v.bank_account_id%TYPE;
578: l_start_date iby_ext_bank_accounts_v.start_date%TYPE;
579: l_end_date iby_ext_bank_accounts_v.end_date%TYPE;
580: l_return_status VARCHAR2(30) ;
581: l_assign_id NUMBER;
582: l_party_id NUMBER;

Line 579: l_end_date iby_ext_bank_accounts_v.end_date%TYPE;

575: l_branch_party_id ce_bank_branches_v.branch_party_id%TYPE;
576: l_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE;
577: l_bank_account_id iby_ext_bank_accounts_v.bank_account_id%TYPE;
578: l_start_date iby_ext_bank_accounts_v.start_date%TYPE;
579: l_end_date iby_ext_bank_accounts_v.end_date%TYPE;
580: l_return_status VARCHAR2(30) ;
581: l_assign_id NUMBER;
582: l_party_id NUMBER;
583: l_count NUMBER;