APPS.CE_BANK_PUB dependencies on CE_GL_ACCOUNTS_CCID

Line 2696: FROM CE_GL_ACCOUNTS_CCID

2692: FROM CE_BANK_ACCT_USES_ALL
2693: WHERE bank_acct_use_id = x_acct_use_id;
2694: CURSOR c_gl_ccid_rowid IS
2695: SELECT rowid
2696: FROM CE_GL_ACCOUNTS_CCID
2697: WHERE bank_acct_use_id = x_acct_use_id;
2698:
2699: l_acct_use_rowid VARCHAR2(100);
2700: l_gl_ccid_rowid VARCHAR2(100);

Line 2898: INSERT INTO CE_GL_ACCOUNTS_CCID (

2894: sysdate,
2895: NVL(FND_GLOBAL.user_id,-1),
2896: 1);
2897:
2898: INSERT INTO CE_GL_ACCOUNTS_CCID (
2899: BANK_ACCT_USE_ID,
2900: ASSET_CODE_COMBINATION_ID,
2901: AP_ASSET_CCID,
2902: AR_ASSET_CCID,

Line 3050: FROM ce_gl_accounts_ccid

3046: WHERE bank_acct_use_id = p_acct_use_rec.bank_acct_use_id;
3047:
3048: CURSOR c_ccid_ovn IS
3049: SELECT object_version_number
3050: FROM ce_gl_accounts_ccid
3051: WHERE bank_acct_use_id = p_acct_use_rec.bank_acct_use_id;
3052:
3053: l_acct_id NUMBER(15);
3054: l_org_id NUMBER(15);

Line 3186: fnd_message.set_token('TABLE', 'CE_GL_ACCOUNTS_CCID');

3182: CLOSE c_ccid_ovn;
3183:
3184: IF l_old_ccid_ovn is not null AND l_old_ccid_ovn > p_ccid_ovn THEN
3185: fnd_message.set_name('CE', 'CE_API_RECORD_CHANGED');
3186: fnd_message.set_token('TABLE', 'CE_GL_ACCOUNTS_CCID');
3187: fnd_msg_pub.add;
3188: x_return_status := fnd_api.g_ret_sts_error;
3189: RAISE fnd_api.g_exc_error;
3190: END IF;

Line 3244: update ce_gl_accounts_ccid

3240: p_use_ovn := l_old_use_ovn + 1;
3241:
3242: -- update ccid table
3243: IF l_old_ccid_ovn is not null THEN
3244: update ce_gl_accounts_ccid
3245: set asset_code_combination_id = p_acct_use_rec.asset_code_combination_id,
3246: ap_asset_ccid = p_acct_use_rec.ap_asset_ccid,
3247: ar_asset_ccid = p_acct_use_rec.ar_asset_ccid,
3248: cash_clearing_ccid = p_acct_use_rec.cash_clearing_ccid,