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.CE_BANK_PUB dependencies on CE_BANK_ACCOUNTS

Line 1644: FROM ce_bank_accounts

1640:
1641: -- 12557532: renamed cursor c_account => c_internal_accounts
1642: CURSOR c_internal_account IS
1643: SELECT bank_account_id, start_date, end_date, object_version_number
1644: FROM ce_bank_accounts
1645: WHERE bank_branch_id = p_branch_id;
1646:
1647: -- 12557532: Added cursor c_external_account
1648: CURSOR c_external_account IS

Line 2049: SELECT CE_BANK_ACCOUNTS_S.nextval

2045: x_msg_count OUT NOCOPY NUMBER,
2046: x_msg_data OUT NOCOPY VARCHAR2
2047: ) IS
2048: CURSOR c_acct_id IS
2049: SELECT CE_BANK_ACCOUNTS_S.nextval
2050: FROM sys.dual;
2051: CURSOR c_acct_rowid IS
2052: SELECT rowid
2053: FROM CE_BANK_ACCOUNTS

Line 2053: FROM CE_BANK_ACCOUNTS

2049: SELECT CE_BANK_ACCOUNTS_S.nextval
2050: FROM sys.dual;
2051: CURSOR c_acct_rowid IS
2052: SELECT rowid
2053: FROM CE_BANK_ACCOUNTS
2054: WHERE bank_account_id = x_acct_id;
2055: CURSOR c_branch IS
2056: SELECT bank_or_branch_number
2057: FROM hz_organization_profiles

Line 2226: -- insert data into ce_bank_accounts table

2222: ELSE -- set the account number for subsidiary accounts
2223: l_account_number := p_acct_rec.bank_account_num;
2224: END IF; -- subsidiary accounts
2225:
2226: -- insert data into ce_bank_accounts table
2227: OPEN c_acct_id;
2228: FETCH c_acct_id INTO x_acct_id;
2229: CLOSE c_acct_id;
2230:

Line 2231: INSERT INTO CE_BANK_ACCOUNTS (

2227: OPEN c_acct_id;
2228: FETCH c_acct_id INTO x_acct_id;
2229: CLOSE c_acct_id;
2230:
2231: INSERT INTO CE_BANK_ACCOUNTS (
2232: BANK_ACCOUNT_ID,
2233: BANK_BRANCH_ID,
2234: BANK_ID,
2235: ACCOUNT_OWNER_PARTY_ID,

Line 2627: FROM ce_bank_accounts

2623: x_msg_data OUT NOCOPY VARCHAR2
2624: ) IS
2625: CURSOR c_branch_id IS
2626: SELECT bank_branch_id
2627: FROM ce_bank_accounts
2628: WHERE bank_account_id = p_acct_rec.bank_account_id;
2629:
2630: CURSOR c_branch_num(l_branch_id NUMBER) IS
2631: SELECT bank_or_branch_number

Line 2639: FROM ce_bank_accounts

2635: AND party_id = l_branch_id;
2636:
2637: CURSOR c_ovn IS
2638: SELECT object_version_number
2639: FROM ce_bank_accounts
2640: WHERE bank_account_id = p_acct_rec.bank_account_id;
2641:
2642: CURSOR c_bank_account IS
2643: SELECT *

Line 2644: FROM ce_bank_accounts

2640: WHERE bank_account_id = p_acct_rec.bank_account_id;
2641:
2642: CURSOR c_bank_account IS
2643: SELECT *
2644: FROM ce_bank_accounts
2645: WHERE bank_account_id = p_acct_rec.bank_account_id;
2646:
2647: l_iban VARCHAR2(50) := null;
2648: l_alc VARCHAR2(30) := null;

Line 2659: l_bank_acct_rec_master CE_BANK_ACCOUNTS%ROWTYPE;

2655: l_branch_id NUMBER(15);
2656: l_old_ovn NUMBER(15);
2657: X_ELECTRONIC_ACCT_NUM VARCHAR2(100) := null;
2658: --Bug 8407297
2659: l_bank_acct_rec_master CE_BANK_ACCOUNTS%ROWTYPE;
2660: l_ap_use_allowed_flag VARCHAR2(1);
2661: l_ar_use_allowed_flag VARCHAR2(1);
2662: l_xtr_use_allowed_flag VARCHAR2(1);
2663: l_pay_use_allowed_flag VARCHAR2(1);

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

2891: CLOSE c_ovn;
2892:
2893: IF l_old_ovn > p_object_version_number THEN
2894: fnd_message.set_name('CE', 'CE_API_RECORD_CHANGED');
2895: fnd_message.set_token('TABLE', 'CE_BANK_ACCOUNTS');
2896: fnd_msg_pub.add;
2897: x_return_status := fnd_api.g_ret_sts_error;
2898: RAISE fnd_api.g_exc_error;
2899: END IF;

Line 2909: update ce_bank_accounts

2905: l_masked_bank_acct_num:= p_acct_rec.masked_account_num;
2906: end if;
2907:
2908: -- update
2909: update ce_bank_accounts
2910: set bank_account_name = p_acct_rec.bank_account_name,
2911: bank_account_num = l_account_number,
2912: --currency_code = p_acct_rec.currency, --Bug 8407297
2913: iban_number = l_iban,

Line 3164: -- insert data into ce_bank_accounts table

3160: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3161: RAISE fnd_api.g_exc_error;
3162: END IF;
3163:
3164: -- insert data into ce_bank_accounts table
3165: OPEN c_acct_use_id;
3166: FETCH c_acct_use_id INTO x_acct_use_id;
3167: CLOSE c_acct_use_id;
3168:

Line 3727: l_old_ovn CE_BANK_ACCOUNTS.object_version_number%TYPE;

3723: x_return_status OUT NOCOPY VARCHAR2,
3724: x_msg_count OUT NOCOPY NUMBER,
3725: x_msg_data OUT NOCOPY VARCHAR2
3726: ) AS
3727: l_old_ovn CE_BANK_ACCOUNTS.object_version_number%TYPE;
3728: BEGIN
3729: SAVEPOINT set_bank_acct_end_date;
3730:
3731: IF l_DEBUG in ('Y', 'C') THEN

Line 3751: FROM ce_bank_accounts

3747: -- check object version number to make sure the record has not been updated
3748: BEGIN
3749: SELECT object_version_number
3750: INTO l_old_ovn
3751: FROM ce_bank_accounts
3752: WHERE bank_account_id = p_bank_acct_id;
3753: EXCEPTION
3754: WHEN NO_DATA_FOUND THEN
3755: fnd_message.set_name('CE', 'CE_API_NO_ACCOUNT');

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

3759: END;
3760:
3761: IF l_old_ovn > p_object_version_number THEN
3762: fnd_message.set_name('CE', 'CE_API_RECORD_CHANGED');
3763: fnd_message.set_token('TABLE', 'CE_BANK_ACCOUNTS');
3764: fnd_msg_pub.add;
3765: x_return_status := fnd_api.g_ret_sts_error;
3766: RAISE fnd_api.g_exc_error;
3767: END IF;

Line 3770: UPDATE ce_bank_accounts

3766: RAISE fnd_api.g_exc_error;
3767: END IF;
3768:
3769: -- set the end date of the account
3770: UPDATE ce_bank_accounts
3771: SET end_date = p_end_date,
3772: object_version_number = l_old_ovn + 1
3773: WHERE bank_account_id = p_bank_acct_id;
3774: