APPS.CE_BANK_PUB dependencies on CE_BANK_ACCT_USES_ALL

Line 3059: FROM CE_BANK_ACCT_USES_ALL

3055: SELECT CE_BANK_ACCT_USES_S.nextval
3056: FROM sys.dual;
3057: CURSOR c_acct_use_rowid IS
3058: SELECT rowid
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

Line 3169: INSERT INTO CE_BANK_ACCT_USES_ALL (

3165: OPEN c_acct_use_id;
3166: FETCH c_acct_use_id INTO x_acct_use_id;
3167: CLOSE c_acct_use_id;
3168:
3169: INSERT INTO CE_BANK_ACCT_USES_ALL (
3170: BANK_ACCT_USE_ID,
3171: BANK_ACCOUNT_ID,
3172: PRIMARY_FLAG,
3173: ORG_ID,

Line 3406: FROM ce_bank_acct_uses_all

3402: CURSOR c_acct_org IS
3403: SELECT bank_account_id,
3404: org_id,
3405: legal_entity_id
3406: FROM ce_bank_acct_uses_all
3407: WHERE bank_acct_use_id = p_acct_use_rec.bank_acct_use_id;
3408:
3409: CURSOR c_use_ovn IS
3410: SELECT object_version_number

Line 3411: FROM ce_bank_acct_uses_all

3407: WHERE bank_acct_use_id = p_acct_use_rec.bank_acct_use_id;
3408:
3409: CURSOR c_use_ovn IS
3410: SELECT object_version_number
3411: FROM ce_bank_acct_uses_all
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

Line 3535: fnd_message.set_token('TABLE', 'CE_BANK_ACCT_USES_ALL');

3531: CLOSE c_use_ovn;
3532:
3533: IF l_old_use_ovn > p_use_ovn THEN
3534: fnd_message.set_name('CE', 'CE_API_RECORD_CHANGED');
3535: fnd_message.set_token('TABLE', 'CE_BANK_ACCT_USES_ALL');
3536: fnd_msg_pub.add;
3537: x_return_status := fnd_api.g_ret_sts_error;
3538: RAISE fnd_api.g_exc_error;
3539: END IF;

Line 3555: update ce_bank_acct_uses_all

3551: RAISE fnd_api.g_exc_error;
3552: END IF;
3553:
3554: -- update
3555: update ce_bank_acct_uses_all
3556: set primary_flag = p_acct_use_rec.primary_flag,
3557: ap_use_enable_flag = p_acct_use_rec.ap_use_enable_flag,
3558: ar_use_enable_flag = p_acct_use_rec.ar_use_enable_flag,
3559: xtr_use_enable_flag = p_acct_use_rec.xtr_use_enable_flag,