DBA Data[Home] [Help]

APPS.AR_IREC_PAYMENTS dependencies on IBY_EXT_BANK_ACCOUNTS

Line 896: p_branch_id IN iby_ext_bank_accounts.BRANCH_ID%TYPE,

892: *=======================================================================*/
893: PROCEDURE update_expiration_date( p_bank_account_id IN NUMBER,
894: p_expiration_date IN DATE,
895: p_payment_instrument IN VARCHAR2,
896: p_branch_id IN iby_ext_bank_accounts.BRANCH_ID%TYPE,
897: p_bank_id IN iby_ext_bank_accounts.BANK_ID%TYPE,
898: p_bank_account_num IN iby_ext_bank_accounts.BANK_ACCOUNT_NUM%TYPE,
899: p_currency IN iby_ext_bank_accounts.CURRENCY_CODE%TYPE,
900: p_object_version_number IN iby_ext_bank_accounts.OBJECT_VERSION_NUMBER%TYPE,

Line 897: p_bank_id IN iby_ext_bank_accounts.BANK_ID%TYPE,

893: PROCEDURE update_expiration_date( p_bank_account_id IN NUMBER,
894: p_expiration_date IN DATE,
895: p_payment_instrument IN VARCHAR2,
896: p_branch_id IN iby_ext_bank_accounts.BRANCH_ID%TYPE,
897: p_bank_id IN iby_ext_bank_accounts.BANK_ID%TYPE,
898: p_bank_account_num IN iby_ext_bank_accounts.BANK_ACCOUNT_NUM%TYPE,
899: p_currency IN iby_ext_bank_accounts.CURRENCY_CODE%TYPE,
900: p_object_version_number IN iby_ext_bank_accounts.OBJECT_VERSION_NUMBER%TYPE,
901: x_return_status OUT NOCOPY VARCHAR,

Line 898: p_bank_account_num IN iby_ext_bank_accounts.BANK_ACCOUNT_NUM%TYPE,

894: p_expiration_date IN DATE,
895: p_payment_instrument IN VARCHAR2,
896: p_branch_id IN iby_ext_bank_accounts.BRANCH_ID%TYPE,
897: p_bank_id IN iby_ext_bank_accounts.BANK_ID%TYPE,
898: p_bank_account_num IN iby_ext_bank_accounts.BANK_ACCOUNT_NUM%TYPE,
899: p_currency IN iby_ext_bank_accounts.CURRENCY_CODE%TYPE,
900: p_object_version_number IN iby_ext_bank_accounts.OBJECT_VERSION_NUMBER%TYPE,
901: x_return_status OUT NOCOPY VARCHAR,
902: x_msg_count OUT NOCOPY NUMBER,

Line 899: p_currency IN iby_ext_bank_accounts.CURRENCY_CODE%TYPE,

895: p_payment_instrument IN VARCHAR2,
896: p_branch_id IN iby_ext_bank_accounts.BRANCH_ID%TYPE,
897: p_bank_id IN iby_ext_bank_accounts.BANK_ID%TYPE,
898: p_bank_account_num IN iby_ext_bank_accounts.BANK_ACCOUNT_NUM%TYPE,
899: p_currency IN iby_ext_bank_accounts.CURRENCY_CODE%TYPE,
900: p_object_version_number IN iby_ext_bank_accounts.OBJECT_VERSION_NUMBER%TYPE,
901: x_return_status OUT NOCOPY VARCHAR,
902: x_msg_count OUT NOCOPY NUMBER,
903: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 900: p_object_version_number IN iby_ext_bank_accounts.OBJECT_VERSION_NUMBER%TYPE,

896: p_branch_id IN iby_ext_bank_accounts.BRANCH_ID%TYPE,
897: p_bank_id IN iby_ext_bank_accounts.BANK_ID%TYPE,
898: p_bank_account_num IN iby_ext_bank_accounts.BANK_ACCOUNT_NUM%TYPE,
899: p_currency IN iby_ext_bank_accounts.CURRENCY_CODE%TYPE,
900: p_object_version_number IN iby_ext_bank_accounts.OBJECT_VERSION_NUMBER%TYPE,
901: x_return_status OUT NOCOPY VARCHAR,
902: x_msg_count OUT NOCOPY NUMBER,
903: x_msg_data OUT NOCOPY VARCHAR2) IS
904:

Line 909: l_acct_holder_name iby_ext_bank_accounts.BANK_ACCOUNT_NAME%TYPE;

905: l_create_credit_card IBY_FNDCPT_SETUP_PUB.CreditCard_rec_type;
906: l_ext_bank_acct_rec IBY_EXT_BANKACCT_PUB.ExtBankAcct_rec_type;
907: l_result_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
908: l_procedure_name VARCHAR2(30);
909: l_acct_holder_name iby_ext_bank_accounts.BANK_ACCOUNT_NAME%TYPE;
910: l_acct_type iby_ext_bank_accounts.BANK_ACCOUNT_TYPE%TYPE;
911: l_start_date DATE;
912: BEGIN
913:

Line 910: l_acct_type iby_ext_bank_accounts.BANK_ACCOUNT_TYPE%TYPE;

906: l_ext_bank_acct_rec IBY_EXT_BANKACCT_PUB.ExtBankAcct_rec_type;
907: l_result_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
908: l_procedure_name VARCHAR2(30);
909: l_acct_holder_name iby_ext_bank_accounts.BANK_ACCOUNT_NAME%TYPE;
910: l_acct_type iby_ext_bank_accounts.BANK_ACCOUNT_TYPE%TYPE;
911: l_start_date DATE;
912: BEGIN
913:
914: l_procedure_name := '.update_expiration_date';

Line 950: FROM IBY_EXT_BANK_ACCOUNTS WHERE EXT_BANK_ACCOUNT_ID = p_bank_account_id AND BRANCH_ID = p_branch_id AND BANK_ID = p_bank_id

946:
947: WRITE_DEBUG_AND_LOG('In BA expiration date update');
948:
949: SELECT BANK_ACCOUNT_NAME, BANK_ACCOUNT_TYPE, START_DATE INTO l_acct_holder_name, l_acct_type, l_start_date
950: FROM IBY_EXT_BANK_ACCOUNTS WHERE EXT_BANK_ACCOUNT_ID = p_bank_account_id AND BRANCH_ID = p_branch_id AND BANK_ID = p_bank_id
951: AND BANK_ACCOUNT_NUM = p_bank_account_num AND CURRENCY_CODE = p_currency AND OBJECT_VERSION_NUMBER = p_object_version_number;
952: l_ext_bank_acct_rec.branch_id := p_branch_id;
953: l_ext_bank_acct_rec.bank_id := p_bank_id;
954: l_ext_bank_acct_rec.bank_account_num := p_bank_account_num;

Line 1192: iby_ext_bank_accounts bank,

1188: FROM hz_cust_accounts cust,
1189: hz_party_preferences pp1,
1190: iby_external_payers_all p,
1191: iby_pmt_instr_uses_all u,
1192: iby_ext_bank_accounts bank,
1193: hz_organization_profiles bapr,
1194: hz_organization_profiles brpr,
1195: iby_account_owners ow
1196: WHERE cust.cust_account_id = p_customer_id

Line 1297: iby_ext_bank_accounts bank,

1293: FROM
1294: hz_cust_accounts cust,
1295: iby_external_payers_all p,
1296: iby_pmt_instr_uses_all u,
1297: iby_ext_bank_accounts bank,
1298: hz_organization_profiles bapr,
1299: hz_organization_profiles brpr,
1300: iby_account_owners ow
1301:

Line 1822: FROM iby_ext_bank_accounts_v ba

1818: AND IBY.CARD_HOLDER_NAME <> p_account_holder_name;
1819:
1820: CURSOR ba_cur IS
1821: SELECT count(1) ba_exists
1822: FROM iby_ext_bank_accounts_v ba
1823: WHERE ba.branch_number = p_routing_number
1824: AND ba.bank_account_number = p_bank_account_number
1825: AND ROWNUM = 1
1826: AND ba.bank_account_name <> p_account_holder_name;