APPS.XTR_NOTIONAL_BANK_ACCOUNTS dependencies on CE_CASHPOOLS

Line 42: p_cashpool_id IN CE_CASHPOOLS.CASHPOOL_ID%TYPE,

38: */
39:
40: -- R12 Modified the reference to AP_BANK_ACCOUNTS and AP_BANK_ACCOUNT_ID to CE_BANK_ACCOUNTS and CE_BANK_ACCOUNT_ID
41: PROCEDURE modify_xtr_bank_accounts(
42: p_cashpool_id IN CE_CASHPOOLS.CASHPOOL_ID%TYPE,
43: p_bank_account_id IN CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE,
44: x_return_status IN OUT NOCOPY VARCHAR2)
45: IS
46: cursor cashpool_exists IS

Line 51: l_cashpool_id CE_CASHPOOLS.CASHPOOL_ID%TYPE;

47: SELECT cashpool_id
48: FROM xtr_bank_accounts
49: WHERE cashpool_id = p_cashpool_id
50: AND setoff_account_yn = 'Y';
51: l_cashpool_id CE_CASHPOOLS.CASHPOOL_ID%TYPE;
52: BEGIN
53: OPEN CASHPOOL_EXISTS;
54: FETCH CASHPOOL_EXISTS INTO l_cashpool_id;
55: IF CASHPOOL_EXISTS%FOUND THEN

Line 99: p_cashpool_id IN CE_CASHPOOLS.CASHPOOL_ID%TYPE,

95: * 01-26-2005 Rajesh Jose o Created.
96: */
97: -- R12 Modified the reference to AP_BANK_ACCOUNTS_ALL and AP_BANK_ACCOUNT_ID to CE_BANK_ACCOUNTS and CE_BANK_ACCOUNT_ID
98: PROCEDURE create_xtr_bank_account(
99: p_cashpool_id IN CE_CASHPOOLS.CASHPOOL_ID%TYPE,
100: p_bank_account_id IN CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE,
101: x_return_status IN OUT NOCOPY VARCHAR2)
102: IS
103: cursor account_details IS

Line 121: FROM ce_cashpools

117: AND party_code = p_party_code;
118:
119: cursor cashpool_details IS
120: SELECT substrb(name,1,80), substrb(UPPER(name),1,20)
121: FROM ce_cashpools
122: WHERE cashpool_id = p_cashpool_id;
123:
124: cursor dealer_details IS
125: SELECT dealer_code

Line 319: p_cashpool_id IN CE_CASHPOOLS.CASHPOOL_ID%TYPE,

315: * 01-26-2005 Rajesh Jose o Created.
316: */
317: -- R12 Modified the reference to AP_BANK_ACCOUNTS and AP_BANK_ACCOUNT_ID to CE_BANK_ACCOUNTS and CE_BANK_ACCOUNT_ID
318: PROCEDURE update_xtr_bank_account(
319: p_cashpool_id IN CE_CASHPOOLS.CASHPOOL_ID%TYPE,
320: p_bank_account_id IN CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE,
321: x_return_status IN OUT NOCOPY VARCHAR2)
322: IS
323:

Line 326: FROM CE_CASHPOOLS

322: IS
323:
324: cursor account_changed IS
325: SELECT conc_account_id
326: FROM CE_CASHPOOLS
327: WHERE cashpool_id = p_cashpool_id;
328:
329: cursor changed_account_details IS
330: SELECT xba.bank_code, xba.year_calc_type,