1 PACKAGE XTR_REPLICATE_BANK_ACCOUNTS_P AUTHID CURRENT_USER AS
2 /* | $Header: xtrrbacs.pls 120.1.12010000.2 2009/07/28 12:38:23 nipant ship $ | */
3
4 /* This package is used to replicate the Internal Bank accounts created in CE into XTR tables.
5 */
6
7 /**
8 * PROCEDURE replicate_bank_accounts
9 *
10 * DESCRIPTION
11 * This is the main procedure that is called by CE to replicate the
12 * Bank/Bank Branch and Bank account data created in CE into XTR tables.
13 *
14 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
15 *
16 * ARGUMENTS
17 * IN:
18 * p_xtr_bank_account_rec Record type of XTR_BANK_ACCOUNTS
19 * This record type contains the Bank Account
20 * related information.
21 * p_action_flag Indicates wether Bank account information needs
22 * to be inserted or updated.
23 * 'I' - Insert,'U' - Update
24 * IN/OUT:
25 *
26 * OUT:
27 * x_return_status Return status after the call. The
28 * status can be
29 * FND_API.G_RET_STS_SUCCESS - for success
30 * FND_API.G_RET_STS_ERR - for expected error
31 * FND_API.G_RET_STS_UNEXP_ERR - for unexpected error
32 * x_msg_count To return the number of error messages
33 * in stack
34 * x_msg_data To return the error message if
35 * x_msg_count = 1.
36 * NOTES
37 *
38 * MODIFICATION HISTORY
39 *
40 * 05-19-2005 Bhargav Adireddy o Created.
41 *
42 */
43
44
45 PROCEDURE REPLICATE_BANK_ACCOUNTS
46 (p_xtr_bank_account_rec IN XTR_BANK_ACCOUNTS%ROWTYPE,
47 p_action_flag IN VARCHAR2,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2
51 );
52
53
54 PROCEDURE REPLICATE_BANK_ACCOUNTS
55 (p_account_number IN XTR_BANK_ACCOUNTS.account_number%TYPE,
56 p_authorised IN XTR_BANK_ACCOUNTS.authorised%TYPE,
57 p_party_code IN XTR_BANK_ACCOUNTS.party_code%TYPE,
58 p_party_type IN XTR_BANK_ACCOUNTS.party_type%TYPE,
59 p_bank_code IN XTR_BANK_ACCOUNTS.bank_code%TYPE,
60 p_currency IN XTR_BANK_ACCOUNTS.currency%TYPE,
61 p_bank_short_code IN XTR_BANK_ACCOUNTS.bank_short_code%TYPE,
62 p_default_acct IN XTR_BANK_ACCOUNTS.default_acct%TYPE,
63 p_eft_script_name IN XTR_BANK_ACCOUNTS.eft_script_name%TYPE,
64 p_code_combination_id IN XTR_BANK_ACCOUNTS.code_combination_id%TYPE,
65 p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.interest_calculation_basis%TYPE,
66 p_location IN XTR_BANK_ACCOUNTS.location%TYPE,
67 p_portfolio_code IN XTR_BANK_ACCOUNTS.portfolio_code%TYPE,
68 p_primary_settlement_method IN XTR_BANK_ACCOUNTS.primary_settlement_method%TYPE,
69 p_street IN XTR_BANK_ACCOUNTS.street%TYPE,
70 p_year_calc_type IN XTR_BANK_ACCOUNTS.year_calc_type%TYPE,
71 p_swift_id IN XTR_BANK_ACCOUNTS.swift_id%TYPE,
72 p_attribute_category IN XTR_BANK_ACCOUNTS.attribute_category%TYPE,
73 p_attribute1 IN XTR_BANK_ACCOUNTS.attribute1%TYPE,
74 p_attribute2 IN XTR_BANK_ACCOUNTS.attribute2%TYPE,
75 p_attribute3 IN XTR_BANK_ACCOUNTS.attribute3%TYPE,
76 p_attribute4 IN XTR_BANK_ACCOUNTS.attribute4%TYPE,
77 p_attribute5 IN XTR_BANK_ACCOUNTS.attribute5%TYPE,
78 p_attribute6 IN XTR_BANK_ACCOUNTS.attribute6%TYPE,
79 p_attribute7 IN XTR_BANK_ACCOUNTS.attribute7%TYPE,
80 p_attribute8 IN XTR_BANK_ACCOUNTS.attribute8%TYPE,
81 p_attribute9 IN XTR_BANK_ACCOUNTS.attribute9%TYPE,
82 p_attribute10 IN XTR_BANK_ACCOUNTS.attribute10%TYPE,
83 p_attribute11 IN XTR_BANK_ACCOUNTS.attribute11%TYPE,
84 p_attribute12 IN XTR_BANK_ACCOUNTS.attribute12%TYPE,
85 p_attribute13 IN XTR_BANK_ACCOUNTS.attribute13%TYPE,
86 p_attribute14 IN XTR_BANK_ACCOUNTS.attribute14%TYPE,
87 p_attribute15 IN XTR_BANK_ACCOUNTS.attribute15%TYPE,
88 p_pricing_model IN XTR_BANK_ACCOUNTS.pricing_model%TYPE,
89 p_legal_account_name IN XTR_BANK_ACCOUNTS.legal_account_name%TYPE,
90 p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,
91 p_bank_branch_id IN XTR_BANK_ACCOUNTS.bank_branch_id%TYPE,
92 p_bank_acct_use_id IN XTR_BANK_ACCOUNTS.bank_acct_use_id%TYPE,
93 p_action_flag IN VARCHAR2,
94 x_return_status OUT NOCOPY VARCHAR2,
95 x_msg_count OUT NOCOPY NUMBER,
96 x_msg_data OUT NOCOPY VARCHAR2,
97 p_iban_number IN XTR_BANK_ACCOUNTS.iban%TYPE -- ER 6391546
98 );
99
100 /**
101 * PROCEDURE insert_bank_accounts
102 *
103 * DESCRIPTION
104 * This procedure is called in replicate_bank_accounts to insert
105 * the bank account related data into XTR tables. This procedure is
106 * called when p_action_flag = 'I'
107 *
108 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
109 *
110 * ARGUMENTS
111 * IN:
112 * p_xtr_bank_account_rec Record type of XTR_BANK_ACCOUNTS
113 * This record type contains the Bank Account
114 * related information.
115 * IN/OUT:
116 *
117 * OUT:
118 * x_return_status Return status after the call. The
119 * status can be
120 * FND_API.G_RET_STS_SUCCESS - for success
121 * FND_API.G_RET_STS_ERR - for expected error
122 * FND_API.G_RET_STS_UNEXP_ERR - for unexpected error
123 * NOTES
124 *
125 * MODIFICATION HISTORY
126 *
127 * 05-19-2005 Bhargav Adireddy o Created.
128 *
129 */
130 PROCEDURE INSERT_BANK_ACCOUNTS
131 ( p_xtr_bank_account_rec IN XTR_BANK_ACCOUNTS%ROWTYPE,
132 x_return_status OUT NOCOPY VARCHAR2
133 );
134
135 /**
136 * PROCEDURE update_bank_accounts
137 *
138 * DESCRIPTION
139 * This procedure is called in replicate_bank_accounts to update
140 * the bank account related data into XTR tables. This procedure is
141 * called when p_action_flag = 'I'
142 *
143 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
144 *
145 * ARGUMENTS
146 * IN:
147 *
148 * p_xtr_bank_account_rec Record type of XTR_BANK_ACCOUNTS
149 * This record type contains the Bank Account
150 * related information.
151 * IN/OUT:
152 *
153 * OUT:
154 * x_return_status Return status after the call. The
155 * status can be
156 * FND_API.G_RET_STS_SUCCESS - for success
157 * FND_API.G_RET_STS_ERR - for expected error
158 * FND_API.G_RET_STS_UNEXP_ERR - for unexpected error
159 * NOTES
160 *
161 * MODIFICATION HISTORY
162 *
163 * 05-19-2005 Bhargav Adireddy o Created.
164 *
165 */
166
167 PROCEDURE UPDATE_BANK_ACCOUNTS
168 ( p_xtr_bank_account_rec IN XTR_BANK_ACCOUNTS%ROWTYPE,
169 x_return_status OUT NOCOPY VARCHAR2
170 );
171
172
173 /**
174 * PROCEDURE validate_bank_accounts
175 *
176 * This procedure is used to validate the Bank account related data before
177 * it is inserted/updated into XTR_BANK_ACCOUNTS. This procedure will
178 * perform the required validations and puts the corresponding error
179 * messages into list
180 *
181 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
182 *
183 * ARGUMENTS
184 * IN:
185 * p_xtr_bank_account_rec Record type of XTR_BANK_ACCOUNTS
186 * This record type contains the Bank Account
187 * related information.
188 * IN/OUT:
189 *
190 * OUT:
191 * x_return_status Return status after the call. The
192 * status can be
193 * FND_API.G_RET_STS_SUCCESS - for success
194 * FND_API.G_RET_STS_ERR - for expected error
195 * FND_API.G_RET_STS_UNEXP_ERR - for unexpected error
196 * NOTES
197 *
198 * MODIFICATION HISTORY
199 *
200 * 05-19-2005 Bhargav Adireddy o Created.
201 *
202 */
203
204
205 PROCEDURE VALIDATE_BANK_ACCOUNTS
206 ( p_xtr_bank_account_rec IN XTR_BANK_ACCOUNTS%ROWTYPE,
207 x_return_status IN OUT NOCOPY VARCHAR2
208 );
209
210 /**
211 * PROCEDURE modify_bank_accounts
212 *
213 * DESCRIPTION
214 * This procedure will insert/update XTR_BANK_ACCOUNTS table with the
215 * Bank account data passed form CE. It will insert if p_action_flag = 'I'
216 * and update if p_action_flag = 'U'
217 *
218 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
219 *
220 * ARGUMENTS
221 * IN:
222 * p_xtr_bank_account_rec Record type of XTR_BANK_ACCOUNTS
223 * This record type contains the Bank Account
224 * p_action_flag Indicates wether Bank account information needs
225 * to be inserted or updated.
226 * 'I' - Insert,'U' - Update related information.
227 * IN/OUT:
228 *
229 * OUT:
230 * x_return_status Return status after the call. The
231 * status can be
232 * FND_API.G_RET_STS_SUCCESS - for success
233 * FND_API.G_RET_STS_ERR - for expected error
234 * FND_API.G_RET_STS_UNEXP_ERR - for unexpected error
235 * NOTES
236 *
237 * MODIFICATION HISTORY
238 *
239 * 05-19-2005 Bhargav Adireddy o Created.
240 *
241 */
242
243
244 PROCEDURE MODIFY_BANK_ACCOUNTS
245 ( p_xtr_bank_account_rec IN XTR_BANK_ACCOUNTS%ROWTYPE,
246 p_action_flag IN VARCHAR2,
247 x_return_status IN OUT NOCOPY VARCHAR2
248 );
249 /**
250 * PROCEDURE log_err_msg
251 *
252 * DESCRIPTION
253 * This procedure will attach the tokens with the error messages and puts
254 * all the error messages into a list. CE can extract the error messages
255 * from this list and show them to the user.
256 *
257 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
258 *
259 * ARGUMENTS
260 * IN:
261 * p_error_code This will pass the message_name
262 * which has to be put into the list.
263 * p_field_name This will pass the token which has to be
264 * attached with the error message.
265 * IN/OUT:
266 *
267 * OUT:
268 *
269 * NOTES
270 *
271 * MODIFICATION HISTORY
272 *
273 * 05-19-2005 Bhargav Adireddy o Created.
274 *
275 */
276 PROCEDURE LOG_ERR_MSG
277 ( p_error_code IN VARCHAR2,
278 p_field_name IN VARCHAR2 default null,
279 p_field_name2 IN VARCHAR2 default null
280 );
281
282 /**
283 * PROCEDURE replicate_interest_schedules
284 *
285 * DESCRIPTION
286 * This is the main procedure that is called by CE to replicate the
287 * interest schedules data created in CE into XTR tables.
288 *
289 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
290 *
291 * ARGUMENTS
292 * IN:
293 * p_ce_bank_account_id This is the CE_BANK_ACCOUNT_ID in XTR_PARTY_INFO.
294 * CE will pass this parameter. This will tell us
295 * which Bank Account is attached with the interest
296 * schedule being updated.
297 * p_interest_rounding This is the ROUNDING_TYPE in XTR_BANK_ACCOUNTS.
298 * CE will pass this parameter. This will tell us
299 * what is the updated interest rounding.
300 * p_interest_includes This is the DAY_COUNT_TYPE in XTR_BANK_ACCOUNTS.
301 * CE will pass this parameter. This will tell us
302 * what is the updated Interest Includes.
303 * p_interest_calculation
304 * _basis This is the BASIS in XTR_BANK_ACCOUNTS.
305 * CE will pass this parameter. This will tell us
306 * what is the updated BASIS.
307 * p_day_count_basis This is the DAY_COUNT_BASIS in XTR_BANK_ACCOUNTS.
308 * CE will pass this parameter. This will tell us
309 * what is the updated day count basis.
310 * IN/OUT:
311 *
312 * OUT:
313 * x_return_status Return status after the call. The
314 * status can be
315 * FND_API.G_RET_STS_SUCCESS - for success
316 * FND_API.G_RET_STS_ERR - for expected error
317 * FND_API.G_RET_STS_UNEXP_ERR - for unexpected error
318 * x_msg_count To return the number of error messages
319 * in stack
320 * x_msg_data To return the error message if
321 * x_msg_count = 1.
322 * NOTES
323 *
324 * MODIFICATION HISTORY
325 *
326 * 05-19-2005 Bhargav Adireddy o Created.
327 *
328 */
329
330
331 PROCEDURE REPLICATE_INTEREST_SCHEDULES
332 ( p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,--Chnage this to bank_account_id
333 p_interest_rounding IN XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE,
334 p_interest_includes IN XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE,
335 p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.INTEREST_CALCULATION_BASIS%TYPE,
336 p_day_count_basis IN XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE,
337 x_return_status OUT NOCOPY VARCHAR2,
338 x_msg_count OUT NOCOPY NUMBER,
339 x_msg_data OUT NOCOPY VARCHAR2
340 );
341
342
343 END XTR_REPLICATE_BANK_ACCOUNTS_P; -- Package spec
344