[Home] [Help]
19: * ARGUMENTS
20: * IN:
21: * p_cashpool_id Cashpool ID of the Notional Cash Pool
22: * that is being created or updated.
23: * p_bank_account_id Bank Account ID from CE_BANK_ACCOUNTS
24: * of the Concentration Account of the
25: * Cashpool.
26: * IN/OUT:
27: * x_return_status Return status after the call. The
36: * 01-26-2005 Rajesh Jose o Created.
37: *
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)
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
47: SELECT cashpool_id
79: * ARGUMENTS
80: * IN:
81: * p_cashpool_id Cashpool ID of the Notional Cash Pool
82: * that is being created or updated.
83: * p_bank_account_id Bank Account ID from CE_BANK_ACCOUNTS
84: * of the Concentration Account of the
85: * Cashpool.
86: * IN/OUT:
87: * x_return_status Return status after the call. The
93: * MODIFICATION HISTORY
94: *
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)
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
104: SELECT bank_code, party_code, currency, year_calc_type,
298: * ARGUMENTS
299: * IN:
300: * p_cashpool_id Cashpool ID of the Notional Cash Pool
301: * that is being created or updated.
302: * p_bank_account_id Bank Account ID from CE_BANK_ACCOUNTS
303: * of the Concentration Account of the
304: * Cashpool.
305: * IN/OUT:
306: * x_return_status Return status after the call. The
313: * MODIFICATION HISTORY
314: *
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)
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:
324: cursor account_changed IS
341: SELECT dealer_code
342: FROM xtr_dealer_codes
343: WHERE user_id = FND_GLOBAL.USER_ID;
344:
345: l_conc_account_id CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE;
346:
347: l_bank_code XTR_BANK_ACCOUNTS.BANK_CODE%TYPE;
348: l_year_calc_type XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE;
349: l_int_calc_basis XTR_BANK_ACCOUNTS.INTEREST_CALCULATION_BASIS%TYPE;