eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XTR_NOTIONAL_BANK_ACCOUNTS dependencies on XTR_BANK_ACCOUNTS

Line 9: * PROCEDURE modify_xtr_bank_accounts

5: -- declaration of public procedures and functions
6: --------------------------------------
7:
8: /**
9: * PROCEDURE modify_xtr_bank_accounts
10: *
11: * DESCRIPTION
12: * This procedure creates a dummy bank account in xtr_bank_accounts
13: * if the cash pool is being created.

Line 12: * This procedure creates a dummy bank account in xtr_bank_accounts

8: /**
9: * PROCEDURE modify_xtr_bank_accounts
10: *
11: * DESCRIPTION
12: * This procedure creates a dummy bank account in xtr_bank_accounts
13: * if the cash pool is being created.
14: * If an existing cash pool is being updated, then the corresponding
15: * dummy bank account in xtr_bank_accounts will be updated.
16: *

Line 15: * dummy bank account in xtr_bank_accounts will be updated.

11: * DESCRIPTION
12: * This procedure creates a dummy bank account in xtr_bank_accounts
13: * if the cash pool is being created.
14: * If an existing cash pool is being updated, then the corresponding
15: * dummy bank account in xtr_bank_accounts will be updated.
16: *
17: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
18: *
19: * ARGUMENTS

Line 41: PROCEDURE modify_xtr_bank_accounts(

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)
45: IS

Line 48: FROM xtr_bank_accounts

44: x_return_status IN OUT NOCOPY VARCHAR2)
45: IS
46: cursor cashpool_exists IS
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

Line 75: * Creates dummy account in XTR_BANK_ACCOUNTS

71: /**
72: * PROCEDURE create_xtr_bank_account
73: *
74: * DESCRIPTION
75: * Creates dummy account in XTR_BANK_ACCOUNTS
76: *
77: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
78: *
79: * ARGUMENTS

Line 107: FROM XTR_BANK_ACCOUNTS

103: cursor account_details IS
104: SELECT bank_code, party_code, currency, year_calc_type,
105: portfolio_code, interest_calculation_basis,
106: rounding_type, day_count_type, code_combination_id
107: FROM XTR_BANK_ACCOUNTS
108: WHERE ce_bank_account_id
109: = p_bank_account_id;
110:
111: cursor acct_number_exists(

Line 112: p_acct_number XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE,

108: WHERE ce_bank_account_id
109: = p_bank_account_id;
110:
111: cursor acct_number_exists(
112: p_acct_number XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE,
113: p_party_code XTR_BANK_ACCOUNTS.PARTY_CODE%TYPE) IS
114: SELECT account_number
115: FROM XTR_BANK_ACCOUNTS
116: WHERE account_number = p_acct_number

Line 113: p_party_code XTR_BANK_ACCOUNTS.PARTY_CODE%TYPE) IS

109: = p_bank_account_id;
110:
111: cursor acct_number_exists(
112: p_acct_number XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE,
113: p_party_code XTR_BANK_ACCOUNTS.PARTY_CODE%TYPE) IS
114: SELECT account_number
115: FROM XTR_BANK_ACCOUNTS
116: WHERE account_number = p_acct_number
117: AND party_code = p_party_code;

Line 115: FROM XTR_BANK_ACCOUNTS

111: cursor acct_number_exists(
112: p_acct_number XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE,
113: p_party_code XTR_BANK_ACCOUNTS.PARTY_CODE%TYPE) IS
114: SELECT account_number
115: FROM XTR_BANK_ACCOUNTS
116: WHERE account_number = p_acct_number
117: AND party_code = p_party_code;
118:
119: cursor cashpool_details IS

Line 129: l_bank_code XTR_BANK_ACCOUNTS.BANK_CODE%TYPE;

125: SELECT dealer_code
126: FROM xtr_dealer_codes
127: WHERE user_id = FND_GLOBAL.USER_ID;
128:
129: l_bank_code XTR_BANK_ACCOUNTS.BANK_CODE%TYPE;
130: l_party_code XTR_BANK_ACCOUNTS.PARTY_CODE%TYPE;
131: l_currency XTR_BANK_ACCOUNTS.CURRENCY%TYPE;
132: l_year_calc_type XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE;
133: l_portfolio_code XTR_BANK_ACCOUNTS.PORTFOLIO_CODE%TYPE;

Line 130: l_party_code XTR_BANK_ACCOUNTS.PARTY_CODE%TYPE;

126: FROM xtr_dealer_codes
127: WHERE user_id = FND_GLOBAL.USER_ID;
128:
129: l_bank_code XTR_BANK_ACCOUNTS.BANK_CODE%TYPE;
130: l_party_code XTR_BANK_ACCOUNTS.PARTY_CODE%TYPE;
131: l_currency XTR_BANK_ACCOUNTS.CURRENCY%TYPE;
132: l_year_calc_type XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE;
133: l_portfolio_code XTR_BANK_ACCOUNTS.PORTFOLIO_CODE%TYPE;
134: l_int_calc_basis XTR_BANK_ACCOUNTS.INTEREST_CALCULATION_BASIS%TYPE;

Line 131: l_currency XTR_BANK_ACCOUNTS.CURRENCY%TYPE;

127: WHERE user_id = FND_GLOBAL.USER_ID;
128:
129: l_bank_code XTR_BANK_ACCOUNTS.BANK_CODE%TYPE;
130: l_party_code XTR_BANK_ACCOUNTS.PARTY_CODE%TYPE;
131: l_currency XTR_BANK_ACCOUNTS.CURRENCY%TYPE;
132: l_year_calc_type XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE;
133: l_portfolio_code XTR_BANK_ACCOUNTS.PORTFOLIO_CODE%TYPE;
134: l_int_calc_basis XTR_BANK_ACCOUNTS.INTEREST_CALCULATION_BASIS%TYPE;
135: l_rounding_type XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE;

Line 132: l_year_calc_type XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE;

128:
129: l_bank_code XTR_BANK_ACCOUNTS.BANK_CODE%TYPE;
130: l_party_code XTR_BANK_ACCOUNTS.PARTY_CODE%TYPE;
131: l_currency XTR_BANK_ACCOUNTS.CURRENCY%TYPE;
132: l_year_calc_type XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE;
133: l_portfolio_code XTR_BANK_ACCOUNTS.PORTFOLIO_CODE%TYPE;
134: l_int_calc_basis XTR_BANK_ACCOUNTS.INTEREST_CALCULATION_BASIS%TYPE;
135: l_rounding_type XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE;
136: l_day_count_type XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE;

Line 133: l_portfolio_code XTR_BANK_ACCOUNTS.PORTFOLIO_CODE%TYPE;

129: l_bank_code XTR_BANK_ACCOUNTS.BANK_CODE%TYPE;
130: l_party_code XTR_BANK_ACCOUNTS.PARTY_CODE%TYPE;
131: l_currency XTR_BANK_ACCOUNTS.CURRENCY%TYPE;
132: l_year_calc_type XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE;
133: l_portfolio_code XTR_BANK_ACCOUNTS.PORTFOLIO_CODE%TYPE;
134: l_int_calc_basis XTR_BANK_ACCOUNTS.INTEREST_CALCULATION_BASIS%TYPE;
135: l_rounding_type XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE;
136: l_day_count_type XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE;
137: l_code_combination_id XTR_BANK_ACCOUNTS.CODE_COMBINATION_ID%TYPE;

Line 134: l_int_calc_basis XTR_BANK_ACCOUNTS.INTEREST_CALCULATION_BASIS%TYPE;

130: l_party_code XTR_BANK_ACCOUNTS.PARTY_CODE%TYPE;
131: l_currency XTR_BANK_ACCOUNTS.CURRENCY%TYPE;
132: l_year_calc_type XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE;
133: l_portfolio_code XTR_BANK_ACCOUNTS.PORTFOLIO_CODE%TYPE;
134: l_int_calc_basis XTR_BANK_ACCOUNTS.INTEREST_CALCULATION_BASIS%TYPE;
135: l_rounding_type XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE;
136: l_day_count_type XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE;
137: l_code_combination_id XTR_BANK_ACCOUNTS.CODE_COMBINATION_ID%TYPE;
138:

Line 135: l_rounding_type XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE;

131: l_currency XTR_BANK_ACCOUNTS.CURRENCY%TYPE;
132: l_year_calc_type XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE;
133: l_portfolio_code XTR_BANK_ACCOUNTS.PORTFOLIO_CODE%TYPE;
134: l_int_calc_basis XTR_BANK_ACCOUNTS.INTEREST_CALCULATION_BASIS%TYPE;
135: l_rounding_type XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE;
136: l_day_count_type XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE;
137: l_code_combination_id XTR_BANK_ACCOUNTS.CODE_COMBINATION_ID%TYPE;
138:
139: l_account_number XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE;

Line 136: l_day_count_type XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE;

132: l_year_calc_type XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE;
133: l_portfolio_code XTR_BANK_ACCOUNTS.PORTFOLIO_CODE%TYPE;
134: l_int_calc_basis XTR_BANK_ACCOUNTS.INTEREST_CALCULATION_BASIS%TYPE;
135: l_rounding_type XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE;
136: l_day_count_type XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE;
137: l_code_combination_id XTR_BANK_ACCOUNTS.CODE_COMBINATION_ID%TYPE;
138:
139: l_account_number XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
140:

Line 137: l_code_combination_id XTR_BANK_ACCOUNTS.CODE_COMBINATION_ID%TYPE;

133: l_portfolio_code XTR_BANK_ACCOUNTS.PORTFOLIO_CODE%TYPE;
134: l_int_calc_basis XTR_BANK_ACCOUNTS.INTEREST_CALCULATION_BASIS%TYPE;
135: l_rounding_type XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE;
136: l_day_count_type XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE;
137: l_code_combination_id XTR_BANK_ACCOUNTS.CODE_COMBINATION_ID%TYPE;
138:
139: l_account_number XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
140:
141: l_bank_short_code XTR_BANK_ACCOUNTS.BANK_SHORT_CODE%TYPE;

Line 139: l_account_number XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE;

135: l_rounding_type XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE;
136: l_day_count_type XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE;
137: l_code_combination_id XTR_BANK_ACCOUNTS.CODE_COMBINATION_ID%TYPE;
138:
139: l_account_number XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
140:
141: l_bank_short_code XTR_BANK_ACCOUNTS.BANK_SHORT_CODE%TYPE;
142: l_new_acct_number XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
143:

Line 141: l_bank_short_code XTR_BANK_ACCOUNTS.BANK_SHORT_CODE%TYPE;

137: l_code_combination_id XTR_BANK_ACCOUNTS.CODE_COMBINATION_ID%TYPE;
138:
139: l_account_number XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
140:
141: l_bank_short_code XTR_BANK_ACCOUNTS.BANK_SHORT_CODE%TYPE;
142: l_new_acct_number XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
143:
144: l_created_by XTR_DEALER_CODES.DEALER_CODE%TYPE;
145: l_updated_by XTR_DEALER_CODES.DEALER_CODE%TYPE;

Line 142: l_new_acct_number XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE;

138:
139: l_account_number XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
140:
141: l_bank_short_code XTR_BANK_ACCOUNTS.BANK_SHORT_CODE%TYPE;
142: l_new_acct_number XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
143:
144: l_created_by XTR_DEALER_CODES.DEALER_CODE%TYPE;
145: l_updated_by XTR_DEALER_CODES.DEALER_CODE%TYPE;
146:

Line 260: INSERT INTO XTR_BANK_ACCOUNTS(

256: EXIT WHEN ACCT_NUMBER_EXISTS%NOTFOUND;
257: END LOOP;
258:
259: BEGIN
260: INSERT INTO XTR_BANK_ACCOUNTS(
261: account_number, setoff_account_yn,
262: bank_code, party_code, bank_short_code,
263: currency, location, street, year_calc_type,
264: portfolio_code, interest_calculation_basis,

Line 294: * Updates the dummy account in XTR_BANK_ACCOUNTS

290: /**
291: * FUNCTION update_xtr_bank_account
292: *
293: * DESCRIPTION
294: * Updates the dummy account in XTR_BANK_ACCOUNTS
295: *
296: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
297: *
298: * ARGUMENTS

Line 334: FROM XTR_BANK_ACCOUNTS xba, XTR_PARTY_INFO xpin

330: SELECT xba.bank_code, xba.year_calc_type,
331: xba.interest_calculation_basis, xba.rounding_type,
332: xba.day_count_type, xba.code_combination_id,
333: xpin.set_of_books_id
334: FROM XTR_BANK_ACCOUNTS xba, XTR_PARTY_INFO xpin
335: WHERE ce_bank_account_id =
336: p_bank_account_id
337: AND xpin.party_code = xba.party_code
338: AND xpin.party_type = 'C';

Line 347: l_bank_code XTR_BANK_ACCOUNTS.BANK_CODE%TYPE;

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;
350: l_rounding_type XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE;
351: l_day_count_type XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE;

Line 348: l_year_calc_type XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE;

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;
350: l_rounding_type XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE;
351: l_day_count_type XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE;
352: l_code_combination_id XTR_BANK_ACCOUNTS.CODE_COMBINATION_ID%TYPE;

Line 349: l_int_calc_basis XTR_BANK_ACCOUNTS.INTEREST_CALCULATION_BASIS%TYPE;

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;
350: l_rounding_type XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE;
351: l_day_count_type XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE;
352: l_code_combination_id XTR_BANK_ACCOUNTS.CODE_COMBINATION_ID%TYPE;
353: l_party_code XTR_BANK_ACCOUNTS.PARTY_CODE%TYPE;

Line 350: l_rounding_type XTR_BANK_ACCOUNTS.ROUNDING_TYPE%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;
350: l_rounding_type XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE;
351: l_day_count_type XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE;
352: l_code_combination_id XTR_BANK_ACCOUNTS.CODE_COMBINATION_ID%TYPE;
353: l_party_code XTR_BANK_ACCOUNTS.PARTY_CODE%TYPE;
354:

Line 351: l_day_count_type XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE;

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;
350: l_rounding_type XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE;
351: l_day_count_type XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE;
352: l_code_combination_id XTR_BANK_ACCOUNTS.CODE_COMBINATION_ID%TYPE;
353: l_party_code XTR_BANK_ACCOUNTS.PARTY_CODE%TYPE;
354:
355: l_orig_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;

Line 352: l_code_combination_id XTR_BANK_ACCOUNTS.CODE_COMBINATION_ID%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;
350: l_rounding_type XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE;
351: l_day_count_type XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE;
352: l_code_combination_id XTR_BANK_ACCOUNTS.CODE_COMBINATION_ID%TYPE;
353: l_party_code XTR_BANK_ACCOUNTS.PARTY_CODE%TYPE;
354:
355: l_orig_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;
356: l_new_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;

Line 353: l_party_code XTR_BANK_ACCOUNTS.PARTY_CODE%TYPE;

349: l_int_calc_basis XTR_BANK_ACCOUNTS.INTEREST_CALCULATION_BASIS%TYPE;
350: l_rounding_type XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE;
351: l_day_count_type XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE;
352: l_code_combination_id XTR_BANK_ACCOUNTS.CODE_COMBINATION_ID%TYPE;
353: l_party_code XTR_BANK_ACCOUNTS.PARTY_CODE%TYPE;
354:
355: l_orig_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;
356: l_new_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;
357:

Line 378: FROM XTR_PARTY_INFO xpin, XTR_BANK_ACCOUNTS xba

374:
375: BEGIN
376: SELECT set_of_books_id
377: INTO l_orig_set_of_books_id
378: FROM XTR_PARTY_INFO xpin, XTR_BANK_ACCOUNTS xba
379: WHERE xpin.party_code = xba.party_code
380: AND ce_bank_account_id
381: = l_conc_account_id
382: AND xpin.party_type = 'C';

Line 396: UPDATE XTR_BANK_ACCOUNTS

392: CLOSE DEALER_DETAILS;
393:
394: IF l_new_set_of_books_id = l_orig_set_of_books_id THEN
395: BEGIN
396: UPDATE XTR_BANK_ACCOUNTS
397: SET bank_code = l_bank_code,
398: year_calc_type = l_year_calc_type,
399: interest_calculation_basis = l_int_calc_basis,
400: rounding_type = l_rounding_type,

Line 415: UPDATE XTR_BANK_ACCOUNTS

411: RAISE FND_API.G_EXC_ERROR;
412: END;
413: ELSE
414: BEGIN
415: UPDATE XTR_BANK_ACCOUNTS
416: SET bank_code = l_bank_code,
417: year_calc_type = l_year_calc_type,
418: interest_calculation_basis = l_int_calc_basis,
419: rounding_type = l_rounding_type,