APPS.ARI_DB_UTILITIES dependencies on IBY_EXT_BANKACCT_PUB

Line 1298: l_ext_bank_rec IBY_EXT_BANKACCT_PUB.extbank_rec_type;

1294: l_api_version NUMBER := 1.0;
1295: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;
1296: l_bank_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1297: l_branch_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1298: l_ext_bank_rec IBY_EXT_BANKACCT_PUB.extbank_rec_type;
1299: l_ext_branch_rec IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type;
1300: l_bank_party_id ce_bank_branches_v.bank_party_id%TYPE;
1301: l_branch_party_id ce_bank_branches_v.branch_party_id%TYPE;
1302: l_import_new_banks_only varchar2(1);

Line 1299: l_ext_branch_rec IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type;

1295: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;
1296: l_bank_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1297: l_branch_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1298: l_ext_bank_rec IBY_EXT_BANKACCT_PUB.extbank_rec_type;
1299: l_ext_branch_rec IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type;
1300: l_bank_party_id ce_bank_branches_v.bank_party_id%TYPE;
1301: l_branch_party_id ce_bank_branches_v.branch_party_id%TYPE;
1302: l_import_new_banks_only varchar2(1);
1303:

Line 1376: iby_ext_bankacct_pub.set_ext_bank_branch_end_date (

1372: IF (ce_bank_branch_cur%FOUND) THEN -- If routing number exists in CE
1373: CLOSE ce_bank_branch_cur;
1374:
1375: -- end date the existing routing number
1376: iby_ext_bankacct_pub.set_ext_bank_branch_end_date (
1377: -- IN parameters
1378: p_api_version => l_api_version,
1379: p_init_msg_list => l_init_msg_list,
1380: p_branch_id => ce_bank_branch_rec.branch_party_id,

Line 1433: iby_ext_bankacct_pub.update_ext_bank_branch (

1429: l_ext_branch_rec.branch_type := 'ABA';
1430: l_ext_branch_rec.bch_object_version_number :=l_obj_ver_num;
1431: l_ext_branch_rec.typ_object_version_number :=l_obj_ver_num;
1432:
1433: iby_ext_bankacct_pub.update_ext_bank_branch (
1434: -- IN parameters
1435: p_api_version => l_api_version,
1436: p_init_msg_list => l_init_msg_list,
1437: p_ext_bank_branch_rec => l_ext_branch_rec,

Line 1512: iby_ext_bankacct_pub.create_ext_bank(

1508: l_ext_bank_rec.institution_type := 'BANK';
1509: l_ext_bank_rec.country_code := ar_bank_branch_rec.country;
1510: l_ext_bank_rec.object_version_number := '1';
1511:
1512: iby_ext_bankacct_pub.create_ext_bank(
1513: -- IN parameters
1514: p_api_version => l_api_version,
1515: p_init_msg_list => l_init_msg_list,
1516: p_ext_bank_rec => l_ext_bank_rec,

Line 1540: iby_ext_bankacct_pub.create_ext_bank_branch(

1536: l_ext_branch_rec.branch_type := 'ABA';
1537: l_ext_branch_rec.bch_object_version_number :='1';
1538: l_ext_branch_rec.typ_object_version_number :='1';
1539:
1540: iby_ext_bankacct_pub.create_ext_bank_branch(
1541: -- IN parameters
1542: p_api_version => l_api_version,
1543: p_init_msg_list => l_init_msg_list,
1544: p_ext_bank_branch_rec => l_ext_branch_rec,

Line 1579: iby_ext_bankacct_pub.create_ext_bank_branch(

1575: l_ext_branch_rec.branch_type := 'ABA';
1576: l_ext_branch_rec.bch_object_version_number :='1';
1577: l_ext_branch_rec.typ_object_version_number :='1';
1578:
1579: iby_ext_bankacct_pub.create_ext_bank_branch(
1580: -- IN parameters
1581: p_api_version => l_api_version,
1582: p_init_msg_list => l_init_msg_list,
1583: p_ext_bank_branch_rec => l_ext_branch_rec,