APPS.CE_BANK_PUB dependencies on CE_BANK_ACCT_USES_ALL

Line 2692: FROM CE_BANK_ACCT_USES_ALL

2688: SELECT CE_BANK_ACCT_USES_S.nextval
2689: FROM sys.dual;
2690: CURSOR c_acct_use_rowid IS
2691: SELECT rowid
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

Line 2803: INSERT INTO CE_BANK_ACCT_USES_ALL (

2799: OPEN c_acct_use_id;
2800: FETCH c_acct_use_id INTO x_acct_use_id;
2801: CLOSE c_acct_use_id;
2802:
2803: INSERT INTO CE_BANK_ACCT_USES_ALL (
2804: BANK_ACCT_USE_ID,
2805: BANK_ACCOUNT_ID,
2806: PRIMARY_FLAG,
2807: ORG_ID,

Line 3040: FROM ce_bank_acct_uses_all

3036: CURSOR c_acct_org IS
3037: SELECT bank_account_id,
3038: org_id,
3039: legal_entity_id
3040: FROM ce_bank_acct_uses_all
3041: WHERE bank_acct_use_id = p_acct_use_rec.bank_acct_use_id;
3042:
3043: CURSOR c_use_ovn IS
3044: SELECT object_version_number

Line 3045: FROM ce_bank_acct_uses_all

3041: WHERE bank_acct_use_id = p_acct_use_rec.bank_acct_use_id;
3042:
3043: CURSOR c_use_ovn IS
3044: SELECT object_version_number
3045: FROM ce_bank_acct_uses_all
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

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

3169: CLOSE c_use_ovn;
3170:
3171: IF l_old_use_ovn > p_use_ovn THEN
3172: fnd_message.set_name('CE', 'CE_API_RECORD_CHANGED');
3173: fnd_message.set_token('TABLE', 'CE_BANK_ACCT_USES_ALL');
3174: fnd_msg_pub.add;
3175: x_return_status := fnd_api.g_ret_sts_error;
3176: RAISE fnd_api.g_exc_error;
3177: END IF;

Line 3193: update ce_bank_acct_uses_all

3189: RAISE fnd_api.g_exc_error;
3190: END IF;
3191:
3192: -- update
3193: update ce_bank_acct_uses_all
3194: set primary_flag = p_acct_use_rec.primary_flag,
3195: ap_use_enable_flag = p_acct_use_rec.ap_use_enable_flag,
3196: ar_use_enable_flag = p_acct_use_rec.ar_use_enable_flag,
3197: xtr_use_enable_flag = p_acct_use_rec.xtr_use_enable_flag,