APPS.CE_BANK_PUB dependencies on CE_GL_ACCOUNTS_CCID

Line 3063: FROM CE_GL_ACCOUNTS_CCID

3059: FROM CE_BANK_ACCT_USES_ALL
3060: WHERE bank_acct_use_id = x_acct_use_id;
3061: CURSOR c_gl_ccid_rowid IS
3062: SELECT rowid
3063: FROM CE_GL_ACCOUNTS_CCID
3064: WHERE bank_acct_use_id = x_acct_use_id;
3065:
3066: l_acct_use_rowid VARCHAR2(100);
3067: l_gl_ccid_rowid VARCHAR2(100);

Line 3264: INSERT INTO CE_GL_ACCOUNTS_CCID (

3260: sysdate,
3261: NVL(FND_GLOBAL.user_id,-1),
3262: 1);
3263:
3264: INSERT INTO CE_GL_ACCOUNTS_CCID (
3265: BANK_ACCT_USE_ID,
3266: ASSET_CODE_COMBINATION_ID,
3267: AP_ASSET_CCID,
3268: AR_ASSET_CCID,

Line 3416: FROM ce_gl_accounts_ccid

3412: WHERE bank_acct_use_id = p_acct_use_rec.bank_acct_use_id;
3413:
3414: CURSOR c_ccid_ovn IS
3415: SELECT object_version_number
3416: FROM ce_gl_accounts_ccid
3417: WHERE bank_acct_use_id = p_acct_use_rec.bank_acct_use_id;
3418:
3419: l_acct_id NUMBER(15);
3420: l_org_id NUMBER(15);

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

3544: CLOSE c_ccid_ovn;
3545:
3546: IF l_old_ccid_ovn is not null AND l_old_ccid_ovn > p_ccid_ovn THEN
3547: fnd_message.set_name('CE', 'CE_API_RECORD_CHANGED');
3548: fnd_message.set_token('TABLE', 'CE_GL_ACCOUNTS_CCID');
3549: fnd_msg_pub.add;
3550: x_return_status := fnd_api.g_ret_sts_error;
3551: RAISE fnd_api.g_exc_error;
3552: END IF;

Line 3606: update ce_gl_accounts_ccid

3602: p_use_ovn := l_old_use_ovn + 1;
3603:
3604: -- update ccid table
3605: IF l_old_ccid_ovn is not null THEN
3606: update ce_gl_accounts_ccid
3607: set asset_code_combination_id = p_acct_use_rec.asset_code_combination_id,
3608: ap_asset_ccid = p_acct_use_rec.ap_asset_ccid,
3609: ar_asset_ccid = p_acct_use_rec.ar_asset_ccid,
3610: cash_clearing_ccid = p_acct_use_rec.cash_clearing_ccid,