DBA Data[Home] [Help]

APPS.AR_IREC_PAYMENTS dependencies on IBY_EXT_BANK_ACCOUNTS

Line 911: p_branch_id IN iby_ext_bank_accounts.BRANCH_ID%TYPE,

907: *=======================================================================*/
908: PROCEDURE update_expiration_date( p_bank_account_id IN NUMBER,
909: p_expiration_date IN DATE,
910: p_payment_instrument IN VARCHAR2,
911: p_branch_id IN iby_ext_bank_accounts.BRANCH_ID%TYPE,
912: p_bank_id IN iby_ext_bank_accounts.BANK_ID%TYPE,
913: p_bank_account_num IN iby_ext_bank_accounts.BANK_ACCOUNT_NUM%TYPE,
914: p_currency IN iby_ext_bank_accounts.CURRENCY_CODE%TYPE,
915: p_object_version_number IN iby_ext_bank_accounts.OBJECT_VERSION_NUMBER%TYPE,

Line 912: p_bank_id IN iby_ext_bank_accounts.BANK_ID%TYPE,

908: PROCEDURE update_expiration_date( p_bank_account_id IN NUMBER,
909: p_expiration_date IN DATE,
910: p_payment_instrument IN VARCHAR2,
911: p_branch_id IN iby_ext_bank_accounts.BRANCH_ID%TYPE,
912: p_bank_id IN iby_ext_bank_accounts.BANK_ID%TYPE,
913: p_bank_account_num IN iby_ext_bank_accounts.BANK_ACCOUNT_NUM%TYPE,
914: p_currency IN iby_ext_bank_accounts.CURRENCY_CODE%TYPE,
915: p_object_version_number IN iby_ext_bank_accounts.OBJECT_VERSION_NUMBER%TYPE,
916: x_return_status OUT NOCOPY VARCHAR,

Line 913: p_bank_account_num IN iby_ext_bank_accounts.BANK_ACCOUNT_NUM%TYPE,

909: p_expiration_date IN DATE,
910: p_payment_instrument IN VARCHAR2,
911: p_branch_id IN iby_ext_bank_accounts.BRANCH_ID%TYPE,
912: p_bank_id IN iby_ext_bank_accounts.BANK_ID%TYPE,
913: p_bank_account_num IN iby_ext_bank_accounts.BANK_ACCOUNT_NUM%TYPE,
914: p_currency IN iby_ext_bank_accounts.CURRENCY_CODE%TYPE,
915: p_object_version_number IN iby_ext_bank_accounts.OBJECT_VERSION_NUMBER%TYPE,
916: x_return_status OUT NOCOPY VARCHAR,
917: x_msg_count OUT NOCOPY NUMBER,

Line 914: p_currency IN iby_ext_bank_accounts.CURRENCY_CODE%TYPE,

910: p_payment_instrument IN VARCHAR2,
911: p_branch_id IN iby_ext_bank_accounts.BRANCH_ID%TYPE,
912: p_bank_id IN iby_ext_bank_accounts.BANK_ID%TYPE,
913: p_bank_account_num IN iby_ext_bank_accounts.BANK_ACCOUNT_NUM%TYPE,
914: p_currency IN iby_ext_bank_accounts.CURRENCY_CODE%TYPE,
915: p_object_version_number IN iby_ext_bank_accounts.OBJECT_VERSION_NUMBER%TYPE,
916: x_return_status OUT NOCOPY VARCHAR,
917: x_msg_count OUT NOCOPY NUMBER,
918: x_msg_data OUT NOCOPY VARCHAR2,

Line 915: p_object_version_number IN iby_ext_bank_accounts.OBJECT_VERSION_NUMBER%TYPE,

911: p_branch_id IN iby_ext_bank_accounts.BRANCH_ID%TYPE,
912: p_bank_id IN iby_ext_bank_accounts.BANK_ID%TYPE,
913: p_bank_account_num IN iby_ext_bank_accounts.BANK_ACCOUNT_NUM%TYPE,
914: p_currency IN iby_ext_bank_accounts.CURRENCY_CODE%TYPE,
915: p_object_version_number IN iby_ext_bank_accounts.OBJECT_VERSION_NUMBER%TYPE,
916: x_return_status OUT NOCOPY VARCHAR,
917: x_msg_count OUT NOCOPY NUMBER,
918: x_msg_data OUT NOCOPY VARCHAR2,
919: p_customer_id IN NUMBER,

Line 1263: iby_ext_bank_accounts bank,

1259: FROM hz_cust_accounts cust,
1260: hz_party_preferences pp1,
1261: iby_external_payers_all p,
1262: iby_pmt_instr_uses_all u,
1263: iby_ext_bank_accounts bank,
1264: hz_organization_profiles bapr,
1265: hz_organization_profiles brpr,
1266: iby_account_owners ow
1267: WHERE cust.cust_account_id = p_customer_id

Line 1365: iby_ext_bank_accounts bank,

1361: FROM
1362: hz_cust_accounts cust,
1363: iby_external_payers_all p,
1364: iby_pmt_instr_uses_all u,
1365: iby_ext_bank_accounts bank,
1366: hz_organization_profiles bapr,
1367: hz_organization_profiles brpr,
1368: iby_account_owners ow
1369:

Line 1896: FROM iby_ext_bank_accounts_v ba

1892: AND IBY.CARD_HOLDER_NAME <> p_account_holder_name;
1893:
1894: CURSOR ba_cur IS
1895: SELECT count(1) ba_exists
1896: FROM iby_ext_bank_accounts_v ba
1897: WHERE ba.branch_number = p_routing_number
1898: AND ba.bank_account_number = p_bank_account_number
1899: AND ROWNUM = 1
1900: AND ba.bank_account_name <> p_account_holder_name;

Line 2976: l_bank_account_id iby_ext_bank_accounts_v.bank_account_id%TYPE;

2972:
2973: l_api_version NUMBER := 1.0;
2974: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;
2975: l_commit VARCHAR2(30) DEFAULT FND_API.G_FALSE;
2976: l_bank_account_id iby_ext_bank_accounts_v.bank_account_id%TYPE;
2977: l_start_date iby_ext_bank_accounts_v.start_date%TYPE;
2978: l_end_date iby_ext_bank_accounts_v.end_date%TYPE;
2979: l_bank_acct_response iby_fndcpt_common_pub.result_rec_type;
2980: l_bank_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;

Line 2977: l_start_date iby_ext_bank_accounts_v.start_date%TYPE;

2973: l_api_version NUMBER := 1.0;
2974: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;
2975: l_commit VARCHAR2(30) DEFAULT FND_API.G_FALSE;
2976: l_bank_account_id iby_ext_bank_accounts_v.bank_account_id%TYPE;
2977: l_start_date iby_ext_bank_accounts_v.start_date%TYPE;
2978: l_end_date iby_ext_bank_accounts_v.end_date%TYPE;
2979: l_bank_acct_response iby_fndcpt_common_pub.result_rec_type;
2980: l_bank_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2981: l_branch_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;

Line 2978: l_end_date iby_ext_bank_accounts_v.end_date%TYPE;

2974: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;
2975: l_commit VARCHAR2(30) DEFAULT FND_API.G_FALSE;
2976: l_bank_account_id iby_ext_bank_accounts_v.bank_account_id%TYPE;
2977: l_start_date iby_ext_bank_accounts_v.start_date%TYPE;
2978: l_end_date iby_ext_bank_accounts_v.end_date%TYPE;
2979: l_bank_acct_response iby_fndcpt_common_pub.result_rec_type;
2980: l_bank_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2981: l_branch_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2982: l_ext_bank_rec IBY_EXT_BANKACCT_PUB.extbank_rec_type;

Line 3195: -- select EXT_BANK_ACCOUNT_ID into l_bank_account_id from iby_ext_bank_accounts where BANK_ACCOUNT_NUM = p_account_number;

3191: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3192: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Inside when l_bank_branch_cur_exists = '||l_bank_branch_cur_exists);
3193: end if;
3194:
3195: -- select EXT_BANK_ACCOUNT_ID into l_bank_account_id from iby_ext_bank_accounts where BANK_ACCOUNT_NUM = p_account_number;
3196: --l_bank_id := l_bank_party_id; --bug 8915943
3197: -- l_branch_id := l_branch_party_id;
3198: begin
3199: select ext_bank_account_id into l_bank_account_id from iby_ext_bank_accounts where BANK_ACCOUNT_NUM = p_account_number and bank_id = l_bank_id and branch_id = l_branch_id;

Line 3199: select ext_bank_account_id into l_bank_account_id from iby_ext_bank_accounts where BANK_ACCOUNT_NUM = p_account_number and bank_id = l_bank_id and branch_id = l_branch_id;

3195: -- select EXT_BANK_ACCOUNT_ID into l_bank_account_id from iby_ext_bank_accounts where BANK_ACCOUNT_NUM = p_account_number;
3196: --l_bank_id := l_bank_party_id; --bug 8915943
3197: -- l_branch_id := l_branch_party_id;
3198: begin
3199: select ext_bank_account_id into l_bank_account_id from iby_ext_bank_accounts where BANK_ACCOUNT_NUM = p_account_number and bank_id = l_bank_id and branch_id = l_branch_id;
3200:
3201: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3202: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Inside when l_bank_branch_cur_exists,l_bank_account_id = '||l_bank_account_id);
3203: end if;