APPS.CE_BANK_PUB dependencies on CE_BANK_ACCOUNTS

Line 1553: FROM ce_bank_accounts

1549: FROM hz_parties
1550: WHERE party_id = p_branch_id;
1551: CURSOR c_account IS
1552: SELECT bank_account_id, start_date, end_date, object_version_number
1553: FROM ce_bank_accounts
1554: WHERE bank_branch_id = p_branch_id;
1555: CURSOR c_rfc_ovn IS
1556: SELECT object_version_number
1557: FROM hz_code_assignments

Line 1910: SELECT CE_BANK_ACCOUNTS_S.nextval

1906: x_msg_count OUT NOCOPY NUMBER,
1907: x_msg_data OUT NOCOPY VARCHAR2
1908: ) IS
1909: CURSOR c_acct_id IS
1910: SELECT CE_BANK_ACCOUNTS_S.nextval
1911: FROM sys.dual;
1912: CURSOR c_acct_rowid IS
1913: SELECT rowid
1914: FROM CE_BANK_ACCOUNTS

Line 1914: FROM CE_BANK_ACCOUNTS

1910: SELECT CE_BANK_ACCOUNTS_S.nextval
1911: FROM sys.dual;
1912: CURSOR c_acct_rowid IS
1913: SELECT rowid
1914: FROM CE_BANK_ACCOUNTS
1915: WHERE bank_account_id = x_acct_id;
1916: CURSOR c_branch IS
1917: SELECT bank_or_branch_number
1918: FROM hz_organization_profiles

Line 2078: -- insert data into ce_bank_accounts table

2074: ELSE -- set the account number for subsidiary accounts
2075: l_account_number := p_acct_rec.bank_account_num;
2076: END IF; -- subsidiary accounts
2077:
2078: -- insert data into ce_bank_accounts table
2079: OPEN c_acct_id;
2080: FETCH c_acct_id INTO x_acct_id;
2081: CLOSE c_acct_id;
2082:

Line 2083: INSERT INTO CE_BANK_ACCOUNTS (

2079: OPEN c_acct_id;
2080: FETCH c_acct_id INTO x_acct_id;
2081: CLOSE c_acct_id;
2082:
2083: INSERT INTO CE_BANK_ACCOUNTS (
2084: BANK_ACCOUNT_ID,
2085: BANK_BRANCH_ID,
2086: BANK_ID,
2087: ACCOUNT_OWNER_PARTY_ID,

Line 2349: FROM ce_bank_accounts

2345: x_msg_data OUT NOCOPY VARCHAR2
2346: ) IS
2347: CURSOR c_branch_id IS
2348: SELECT bank_branch_id
2349: FROM ce_bank_accounts
2350: WHERE bank_account_id = p_acct_rec.bank_account_id;
2351:
2352: CURSOR c_branch_num(l_branch_id NUMBER) IS
2353: SELECT bank_or_branch_number

Line 2361: FROM ce_bank_accounts

2357: AND party_id = l_branch_id;
2358:
2359: CURSOR c_ovn IS
2360: SELECT object_version_number
2361: FROM ce_bank_accounts
2362: WHERE bank_account_id = p_acct_rec.bank_account_id;
2363:
2364: l_iban VARCHAR2(50) := null;
2365: l_alc VARCHAR2(30) := null;

Line 2535: fnd_message.set_token('TABLE', 'CE_BANK_ACCOUNTS');

2531: CLOSE c_ovn;
2532:
2533: IF l_old_ovn > p_object_version_number THEN
2534: fnd_message.set_name('CE', 'CE_API_RECORD_CHANGED');
2535: fnd_message.set_token('TABLE', 'CE_BANK_ACCOUNTS');
2536: fnd_msg_pub.add;
2537: x_return_status := fnd_api.g_ret_sts_error;
2538: RAISE fnd_api.g_exc_error;
2539: END IF;

Line 2542: update ce_bank_accounts

2538: RAISE fnd_api.g_exc_error;
2539: END IF;
2540:
2541: -- update
2542: update ce_bank_accounts
2543: set bank_account_name = p_acct_rec.bank_account_name,
2544: bank_account_num = l_account_number,
2545: currency_code = p_acct_rec.currency,
2546: iban_number = l_iban,

Line 2798: -- insert data into ce_bank_accounts table

2794: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2795: RAISE fnd_api.g_exc_error;
2796: END IF;
2797:
2798: -- insert data into ce_bank_accounts table
2799: OPEN c_acct_use_id;
2800: FETCH c_acct_use_id INTO x_acct_use_id;
2801: CLOSE c_acct_use_id;
2802: