1: PACKAGE BODY CE_AUTO_BANK_IMPORT AS
2: /* $Header: ceabrimb.pls 120.32.12020000.3 2013/01/17 07:44:54 rtumati ship $ */
3: l_DEBUG varchar2(1) := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
4: --l_DEBUG varchar2(1) := 'Y';
5:
151: ce_statement_lines_interface l
152: WHERE curr.currency_code(+) = l.currency_code
153: AND gt.user_conversion_type(+) = l.user_exchange_rate_type
154: AND ctc.trx_code(+) = l.trx_code
155: AND ctc.bank_account_id(+) = CE_AUTO_BANK_IMPORT.G_bank_account_id
156: AND nvl(ctc.Reconciliation_Sequence,1) = (SELECT nvl(min(ctc2.Reconciliation_Sequence),1)-- Code added for bug 7531187
157: FROM ce_Transaction_Codes ctc2
158: WHERE ctc2.Bank_Account_Id (+) =CE_AUTO_BANK_IMPORT.G_bank_account_id
159: AND ctc2.trx_Code (+) = l.trx_Code
154: AND ctc.trx_code(+) = l.trx_code
155: AND ctc.bank_account_id(+) = CE_AUTO_BANK_IMPORT.G_bank_account_id
156: AND nvl(ctc.Reconciliation_Sequence,1) = (SELECT nvl(min(ctc2.Reconciliation_Sequence),1)-- Code added for bug 7531187
157: FROM ce_Transaction_Codes ctc2
158: WHERE ctc2.Bank_Account_Id (+) =CE_AUTO_BANK_IMPORT.G_bank_account_id
159: AND ctc2.trx_Code (+) = l.trx_Code
160: AND ((CE_AUTO_BANK_IMPORT.G_cshi_statement_date BETWEEN --8928828 start
161: Nvl(ctc2.start_date,CE_AUTO_BANK_IMPORT.G_cshi_statement_date)
162: AND Nvl(ctc2.end_date,CE_AUTO_BANK_IMPORT.G_cshi_statement_date))
156: AND nvl(ctc.Reconciliation_Sequence,1) = (SELECT nvl(min(ctc2.Reconciliation_Sequence),1)-- Code added for bug 7531187
157: FROM ce_Transaction_Codes ctc2
158: WHERE ctc2.Bank_Account_Id (+) =CE_AUTO_BANK_IMPORT.G_bank_account_id
159: AND ctc2.trx_Code (+) = l.trx_Code
160: AND ((CE_AUTO_BANK_IMPORT.G_cshi_statement_date BETWEEN --8928828 start
161: Nvl(ctc2.start_date,CE_AUTO_BANK_IMPORT.G_cshi_statement_date)
162: AND Nvl(ctc2.end_date,CE_AUTO_BANK_IMPORT.G_cshi_statement_date))
163: OR
164: (NOT EXISTS (SELECT 1 FROM ce_transaction_codes tc
157: FROM ce_Transaction_Codes ctc2
158: WHERE ctc2.Bank_Account_Id (+) =CE_AUTO_BANK_IMPORT.G_bank_account_id
159: AND ctc2.trx_Code (+) = l.trx_Code
160: AND ((CE_AUTO_BANK_IMPORT.G_cshi_statement_date BETWEEN --8928828 start
161: Nvl(ctc2.start_date,CE_AUTO_BANK_IMPORT.G_cshi_statement_date)
162: AND Nvl(ctc2.end_date,CE_AUTO_BANK_IMPORT.G_cshi_statement_date))
163: OR
164: (NOT EXISTS (SELECT 1 FROM ce_transaction_codes tc
165: WHERE tc.trx_code = l.trx_code
158: WHERE ctc2.Bank_Account_Id (+) =CE_AUTO_BANK_IMPORT.G_bank_account_id
159: AND ctc2.trx_Code (+) = l.trx_Code
160: AND ((CE_AUTO_BANK_IMPORT.G_cshi_statement_date BETWEEN --8928828 start
161: Nvl(ctc2.start_date,CE_AUTO_BANK_IMPORT.G_cshi_statement_date)
162: AND Nvl(ctc2.end_date,CE_AUTO_BANK_IMPORT.G_cshi_statement_date))
163: OR
164: (NOT EXISTS (SELECT 1 FROM ce_transaction_codes tc
165: WHERE tc.trx_code = l.trx_code
166: AND tc. bank_account_id = CE_AUTO_BANK_IMPORT.G_bank_account_id
162: AND Nvl(ctc2.end_date,CE_AUTO_BANK_IMPORT.G_cshi_statement_date))
163: OR
164: (NOT EXISTS (SELECT 1 FROM ce_transaction_codes tc
165: WHERE tc.trx_code = l.trx_code
166: AND tc. bank_account_id = CE_AUTO_BANK_IMPORT.G_bank_account_id
167: AND CE_AUTO_BANK_IMPORT.G_cshi_statement_date BETWEEN
168: NVL(tc.start_date, CE_AUTO_BANK_IMPORT.G_cshi_statement_date)
169: AND NVL(tc.end_date, CE_AUTO_BANK_IMPORT.G_cshi_statement_date)))) --8928828
170: ) -- End of Code for bug 7531187
163: OR
164: (NOT EXISTS (SELECT 1 FROM ce_transaction_codes tc
165: WHERE tc.trx_code = l.trx_code
166: AND tc. bank_account_id = CE_AUTO_BANK_IMPORT.G_bank_account_id
167: AND CE_AUTO_BANK_IMPORT.G_cshi_statement_date BETWEEN
168: NVL(tc.start_date, CE_AUTO_BANK_IMPORT.G_cshi_statement_date)
169: AND NVL(tc.end_date, CE_AUTO_BANK_IMPORT.G_cshi_statement_date)))) --8928828
170: ) -- End of Code for bug 7531187
171: AND l.statement_number = p_statement_number
164: (NOT EXISTS (SELECT 1 FROM ce_transaction_codes tc
165: WHERE tc.trx_code = l.trx_code
166: AND tc. bank_account_id = CE_AUTO_BANK_IMPORT.G_bank_account_id
167: AND CE_AUTO_BANK_IMPORT.G_cshi_statement_date BETWEEN
168: NVL(tc.start_date, CE_AUTO_BANK_IMPORT.G_cshi_statement_date)
169: AND NVL(tc.end_date, CE_AUTO_BANK_IMPORT.G_cshi_statement_date)))) --8928828
170: ) -- End of Code for bug 7531187
171: AND l.statement_number = p_statement_number
172: AND l.bank_account_num = p_bank_account_num
165: WHERE tc.trx_code = l.trx_code
166: AND tc. bank_account_id = CE_AUTO_BANK_IMPORT.G_bank_account_id
167: AND CE_AUTO_BANK_IMPORT.G_cshi_statement_date BETWEEN
168: NVL(tc.start_date, CE_AUTO_BANK_IMPORT.G_cshi_statement_date)
169: AND NVL(tc.end_date, CE_AUTO_BANK_IMPORT.G_cshi_statement_date)))) --8928828
170: ) -- End of Code for bug 7531187
171: AND l.statement_number = p_statement_number
172: AND l.bank_account_num = p_bank_account_num
173: ORDER BY l.line_number;
197:
198: FUNCTION header_error (error_name VARCHAR2) RETURN BOOLEAN IS
199: BEGIN
200: IF l_DEBUG in ('Y', 'C') THEN
201: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.header_error');
202: END IF;
203: CE_HEADER_INTERFACE_ERRORS_PKG.insert_row(CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
204: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num, error_name);
205: IF l_DEBUG in ('Y', 'C') THEN
199: BEGIN
200: IF l_DEBUG in ('Y', 'C') THEN
201: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.header_error');
202: END IF;
203: CE_HEADER_INTERFACE_ERRORS_PKG.insert_row(CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
204: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num, error_name);
205: IF l_DEBUG in ('Y', 'C') THEN
206: cep_standard.debug('<
200: IF l_DEBUG in ('Y', 'C') THEN
201: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.header_error');
202: END IF;
203: CE_HEADER_INTERFACE_ERRORS_PKG.insert_row(CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
204: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num, error_name);
205: IF l_DEBUG in ('Y', 'C') THEN
206: cep_standard.debug('<
208: RETURN TRUE;
202: END IF;
203: CE_HEADER_INTERFACE_ERRORS_PKG.insert_row(CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
204: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num, error_name);
205: IF l_DEBUG in ('Y', 'C') THEN
206: cep_standard.debug('<
208: RETURN TRUE;
209: END header_error;
210:
218: FUNCTION line_error (line_number NUMBER, error_name VARCHAR2) RETURN BOOLEAN IS
219: x_rowid VARCHAR2(100);
220: BEGIN
221: IF l_DEBUG in ('Y', 'C') THEN
222: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.line_error');
223: END IF;
224: CE_LINE_INTERFACE_ERRORS_PKG.insert_row(
225: x_rowid,
226: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
222: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.line_error');
223: END IF;
224: CE_LINE_INTERFACE_ERRORS_PKG.insert_row(
225: x_rowid,
226: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
227: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num,
228: line_number,
229: error_name);
230: IF l_DEBUG in ('Y', 'C') THEN
223: END IF;
224: CE_LINE_INTERFACE_ERRORS_PKG.insert_row(
225: x_rowid,
226: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
227: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num,
228: line_number,
229: error_name);
230: IF l_DEBUG in ('Y', 'C') THEN
231: cep_standard.debug('<
227: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num,
228: line_number,
229: error_name);
230: IF l_DEBUG in ('Y', 'C') THEN
231: cep_standard.debug('<
233: RETURN TRUE;
234: END line_error;
235:
257: SELECT 1
258: INTO l_return
259: FROM CE_BANK_ACCT_BALANCES
260: WHERE BANK_ACCOUNT_ID = p_bank_account_id
261: AND BALANCE_DATE = trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date)
262: AND NVL(LEDGER_BALANCE,0) = NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,0)
263: AND NVL(AVAILABLE_BALANCE,0) = NVL(CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,0)
264: AND NVL(VALUE_DATED_BALANCE,0) = NVL(CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,0);
265:
258: INTO l_return
259: FROM CE_BANK_ACCT_BALANCES
260: WHERE BANK_ACCOUNT_ID = p_bank_account_id
261: AND BALANCE_DATE = trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date)
262: AND NVL(LEDGER_BALANCE,0) = NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,0)
263: AND NVL(AVAILABLE_BALANCE,0) = NVL(CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,0)
264: AND NVL(VALUE_DATED_BALANCE,0) = NVL(CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,0);
265:
266: return l_return;
259: FROM CE_BANK_ACCT_BALANCES
260: WHERE BANK_ACCOUNT_ID = p_bank_account_id
261: AND BALANCE_DATE = trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date)
262: AND NVL(LEDGER_BALANCE,0) = NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,0)
263: AND NVL(AVAILABLE_BALANCE,0) = NVL(CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,0)
264: AND NVL(VALUE_DATED_BALANCE,0) = NVL(CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,0);
265:
266: return l_return;
267: EXCEPTION
260: WHERE BANK_ACCOUNT_ID = p_bank_account_id
261: AND BALANCE_DATE = trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date)
262: AND NVL(LEDGER_BALANCE,0) = NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,0)
263: AND NVL(AVAILABLE_BALANCE,0) = NVL(CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,0)
264: AND NVL(VALUE_DATED_BALANCE,0) = NVL(CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,0);
265:
266: return l_return;
267: EXCEPTION
268: WHEN OTHERS THEN
285: bu_error_found boolean;
286:
287: BEGIN
288: IF l_DEBUG in ('Y', 'C') THEN
289: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.xtr_shared_account'||
290: 'P_ORG_ID = '|| CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID ||
291: ', G_BANK_ACCOUNT_ID = '|| CE_AUTO_BANK_IMPORT.G_bank_account_id||
292: ' G_cshi_currency_code = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
293: END IF;
286:
287: BEGIN
288: IF l_DEBUG in ('Y', 'C') THEN
289: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.xtr_shared_account'||
290: 'P_ORG_ID = '|| CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID ||
291: ', G_BANK_ACCOUNT_ID = '|| CE_AUTO_BANK_IMPORT.G_bank_account_id||
292: ' G_cshi_currency_code = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
293: END IF;
294:
287: BEGIN
288: IF l_DEBUG in ('Y', 'C') THEN
289: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.xtr_shared_account'||
290: 'P_ORG_ID = '|| CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID ||
291: ', G_BANK_ACCOUNT_ID = '|| CE_AUTO_BANK_IMPORT.G_bank_account_id||
292: ' G_cshi_currency_code = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
293: END IF;
294:
295: XTR_WRAPPER_API_P.bank_account_verification(
288: IF l_DEBUG in ('Y', 'C') THEN
289: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.xtr_shared_account'||
290: 'P_ORG_ID = '|| CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID ||
291: ', G_BANK_ACCOUNT_ID = '|| CE_AUTO_BANK_IMPORT.G_bank_account_id||
292: ' G_cshi_currency_code = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
293: END IF;
294:
295: XTR_WRAPPER_API_P.bank_account_verification(
296: P_ORG_ID => CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID, --CE_AUTO_BANK_IMPORT.G_cshi_org_id,
292: ' G_cshi_currency_code = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
293: END IF;
294:
295: XTR_WRAPPER_API_P.bank_account_verification(
296: P_ORG_ID => CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID, --CE_AUTO_BANK_IMPORT.G_cshi_org_id,
297: P_CE_BANK_ACCOUNT_ID => CE_AUTO_BANK_IMPORT.G_bank_account_id,
298: P_CURRENCY_CODE => CE_AUTO_BANK_IMPORT.G_cshi_currency_code,
299: P_RESULT => X_RESULT,
300: P_ERROR_MSG => X_ERROR_MSG);
293: END IF;
294:
295: XTR_WRAPPER_API_P.bank_account_verification(
296: P_ORG_ID => CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID, --CE_AUTO_BANK_IMPORT.G_cshi_org_id,
297: P_CE_BANK_ACCOUNT_ID => CE_AUTO_BANK_IMPORT.G_bank_account_id,
298: P_CURRENCY_CODE => CE_AUTO_BANK_IMPORT.G_cshi_currency_code,
299: P_RESULT => X_RESULT,
300: P_ERROR_MSG => X_ERROR_MSG);
301:
294:
295: XTR_WRAPPER_API_P.bank_account_verification(
296: P_ORG_ID => CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID, --CE_AUTO_BANK_IMPORT.G_cshi_org_id,
297: P_CE_BANK_ACCOUNT_ID => CE_AUTO_BANK_IMPORT.G_bank_account_id,
298: P_CURRENCY_CODE => CE_AUTO_BANK_IMPORT.G_cshi_currency_code,
299: P_RESULT => X_RESULT,
300: P_ERROR_MSG => X_ERROR_MSG);
301:
302: X_ACCOUNT_RESULT := X_RESULT;
308:
309: if (x_account_result = 'XTR1_NOT_SETUP' ) then
310: FND_FILE.put_line(FND_FILE.LOG, X_ERROR_MSG);
311: set_warning :=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Check log file for warning messages');
312: bu_error_found := CE_AUTO_BANK_IMPORT.header_error('CE_XTR_ACCT_NOT_SETUP');
313: update_header_status('E');
314: end if;
315:
316: IF l_DEBUG in ('Y', 'C') THEN
313: update_header_status('E');
314: end if;
315:
316: IF l_DEBUG in ('Y', 'C') THEN
317: cep_standard.debug('<
319:
320: EXCEPTION
321: WHEN OTHERS THEN
319:
320: EXCEPTION
321: WHEN OTHERS THEN
322: IF l_DEBUG in ('Y', 'C') THEN
323: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.xtr_shared_account');
324: END IF;
325: RAISE;
326: END xtr_shared_account;
327:
338: bu_error_found boolean;
339: set_warning boolean;
340: BEGIN
341: IF l_DEBUG in ('Y', 'C') THEN
342: cep_standard.debug('>> CE_AUTO_BANK_IMPORT.transfer_bank_balances');
343: cep_standard.debug('transfer_bank_balances G_CSHI_ORG_ID = '|| CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID);
344: cep_standard.debug('transfer_bank_balances G_BANK_ACCOUNT_ID = '|| CE_AUTO_BANK_IMPORT.G_bank_account_id);
345: cep_standard.debug('transfer_bank_balances G_CSHI_CURRENCY_CODE = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
346: cep_standard.debug('transfer_bank_balances G_CSHI_STATEMENT_DATE = '|| CE_AUTO_BANK_IMPORT.G_cshi_statement_date);
339: set_warning boolean;
340: BEGIN
341: IF l_DEBUG in ('Y', 'C') THEN
342: cep_standard.debug('>> CE_AUTO_BANK_IMPORT.transfer_bank_balances');
343: cep_standard.debug('transfer_bank_balances G_CSHI_ORG_ID = '|| CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID);
344: cep_standard.debug('transfer_bank_balances G_BANK_ACCOUNT_ID = '|| CE_AUTO_BANK_IMPORT.G_bank_account_id);
345: cep_standard.debug('transfer_bank_balances G_CSHI_CURRENCY_CODE = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
346: cep_standard.debug('transfer_bank_balances G_CSHI_STATEMENT_DATE = '|| CE_AUTO_BANK_IMPORT.G_cshi_statement_date);
347: cep_standard.debug('transfer_bank_balances G_CSHI_CONTROL_END_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance);
340: BEGIN
341: IF l_DEBUG in ('Y', 'C') THEN
342: cep_standard.debug('>> CE_AUTO_BANK_IMPORT.transfer_bank_balances');
343: cep_standard.debug('transfer_bank_balances G_CSHI_ORG_ID = '|| CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID);
344: cep_standard.debug('transfer_bank_balances G_BANK_ACCOUNT_ID = '|| CE_AUTO_BANK_IMPORT.G_bank_account_id);
345: cep_standard.debug('transfer_bank_balances G_CSHI_CURRENCY_CODE = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
346: cep_standard.debug('transfer_bank_balances G_CSHI_STATEMENT_DATE = '|| CE_AUTO_BANK_IMPORT.G_cshi_statement_date);
347: cep_standard.debug('transfer_bank_balances G_CSHI_CONTROL_END_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance);
348: cep_standard.debug('transfer_bank_balances G_CSHI_CASHFLOW_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance);
341: IF l_DEBUG in ('Y', 'C') THEN
342: cep_standard.debug('>> CE_AUTO_BANK_IMPORT.transfer_bank_balances');
343: cep_standard.debug('transfer_bank_balances G_CSHI_ORG_ID = '|| CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID);
344: cep_standard.debug('transfer_bank_balances G_BANK_ACCOUNT_ID = '|| CE_AUTO_BANK_IMPORT.G_bank_account_id);
345: cep_standard.debug('transfer_bank_balances G_CSHI_CURRENCY_CODE = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
346: cep_standard.debug('transfer_bank_balances G_CSHI_STATEMENT_DATE = '|| CE_AUTO_BANK_IMPORT.G_cshi_statement_date);
347: cep_standard.debug('transfer_bank_balances G_CSHI_CONTROL_END_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance);
348: cep_standard.debug('transfer_bank_balances G_CSHI_CASHFLOW_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance);
349: cep_standard.debug('transfer_bank_balances G_CSHI_INT_CALC_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance);
342: cep_standard.debug('>> CE_AUTO_BANK_IMPORT.transfer_bank_balances');
343: cep_standard.debug('transfer_bank_balances G_CSHI_ORG_ID = '|| CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID);
344: cep_standard.debug('transfer_bank_balances G_BANK_ACCOUNT_ID = '|| CE_AUTO_BANK_IMPORT.G_bank_account_id);
345: cep_standard.debug('transfer_bank_balances G_CSHI_CURRENCY_CODE = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
346: cep_standard.debug('transfer_bank_balances G_CSHI_STATEMENT_DATE = '|| CE_AUTO_BANK_IMPORT.G_cshi_statement_date);
347: cep_standard.debug('transfer_bank_balances G_CSHI_CONTROL_END_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance);
348: cep_standard.debug('transfer_bank_balances G_CSHI_CASHFLOW_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance);
349: cep_standard.debug('transfer_bank_balances G_CSHI_INT_CALC_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance);
350: cep_standard.debug('transfer_bank_balances G_CSHI_ONE_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_one_day_float);
343: cep_standard.debug('transfer_bank_balances G_CSHI_ORG_ID = '|| CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID);
344: cep_standard.debug('transfer_bank_balances G_BANK_ACCOUNT_ID = '|| CE_AUTO_BANK_IMPORT.G_bank_account_id);
345: cep_standard.debug('transfer_bank_balances G_CSHI_CURRENCY_CODE = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
346: cep_standard.debug('transfer_bank_balances G_CSHI_STATEMENT_DATE = '|| CE_AUTO_BANK_IMPORT.G_cshi_statement_date);
347: cep_standard.debug('transfer_bank_balances G_CSHI_CONTROL_END_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance);
348: cep_standard.debug('transfer_bank_balances G_CSHI_CASHFLOW_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance);
349: cep_standard.debug('transfer_bank_balances G_CSHI_INT_CALC_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance);
350: cep_standard.debug('transfer_bank_balances G_CSHI_ONE_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_one_day_float);
351: cep_standard.debug('transfer_bank_balances G_CSHI_TWO_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_two_day_float);
344: cep_standard.debug('transfer_bank_balances G_BANK_ACCOUNT_ID = '|| CE_AUTO_BANK_IMPORT.G_bank_account_id);
345: cep_standard.debug('transfer_bank_balances G_CSHI_CURRENCY_CODE = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
346: cep_standard.debug('transfer_bank_balances G_CSHI_STATEMENT_DATE = '|| CE_AUTO_BANK_IMPORT.G_cshi_statement_date);
347: cep_standard.debug('transfer_bank_balances G_CSHI_CONTROL_END_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance);
348: cep_standard.debug('transfer_bank_balances G_CSHI_CASHFLOW_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance);
349: cep_standard.debug('transfer_bank_balances G_CSHI_INT_CALC_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance);
350: cep_standard.debug('transfer_bank_balances G_CSHI_ONE_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_one_day_float);
351: cep_standard.debug('transfer_bank_balances G_CSHI_TWO_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_two_day_float);
352: END IF;
345: cep_standard.debug('transfer_bank_balances G_CSHI_CURRENCY_CODE = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
346: cep_standard.debug('transfer_bank_balances G_CSHI_STATEMENT_DATE = '|| CE_AUTO_BANK_IMPORT.G_cshi_statement_date);
347: cep_standard.debug('transfer_bank_balances G_CSHI_CONTROL_END_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance);
348: cep_standard.debug('transfer_bank_balances G_CSHI_CASHFLOW_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance);
349: cep_standard.debug('transfer_bank_balances G_CSHI_INT_CALC_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance);
350: cep_standard.debug('transfer_bank_balances G_CSHI_ONE_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_one_day_float);
351: cep_standard.debug('transfer_bank_balances G_CSHI_TWO_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_two_day_float);
352: END IF;
353:
346: cep_standard.debug('transfer_bank_balances G_CSHI_STATEMENT_DATE = '|| CE_AUTO_BANK_IMPORT.G_cshi_statement_date);
347: cep_standard.debug('transfer_bank_balances G_CSHI_CONTROL_END_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance);
348: cep_standard.debug('transfer_bank_balances G_CSHI_CASHFLOW_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance);
349: cep_standard.debug('transfer_bank_balances G_CSHI_INT_CALC_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance);
350: cep_standard.debug('transfer_bank_balances G_CSHI_ONE_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_one_day_float);
351: cep_standard.debug('transfer_bank_balances G_CSHI_TWO_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_two_day_float);
352: END IF;
353:
354: bu_error_found := FALSE;
347: cep_standard.debug('transfer_bank_balances G_CSHI_CONTROL_END_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance);
348: cep_standard.debug('transfer_bank_balances G_CSHI_CASHFLOW_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance);
349: cep_standard.debug('transfer_bank_balances G_CSHI_INT_CALC_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance);
350: cep_standard.debug('transfer_bank_balances G_CSHI_ONE_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_one_day_float);
351: cep_standard.debug('transfer_bank_balances G_CSHI_TWO_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_two_day_float);
352: END IF;
353:
354: bu_error_found := FALSE;
355:
355:
356:
357:
358: XTR_WRAPPER_API_P.bank_balance_upload(
359: P_ORG_ID => CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID, --CE_AUTO_BANK_IMPORT.G_cshi_org_id,
360: P_CE_BANK_ACCOUNT_ID => CE_AUTO_BANK_IMPORT.G_bank_account_id,
361: P_CURRENCY_CODE => CE_AUTO_BANK_IMPORT.G_cshi_currency_code,
362: P_BALANCE_DATE => CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
363: P_BALANCE_AMOUNT_A => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
356:
357:
358: XTR_WRAPPER_API_P.bank_balance_upload(
359: P_ORG_ID => CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID, --CE_AUTO_BANK_IMPORT.G_cshi_org_id,
360: P_CE_BANK_ACCOUNT_ID => CE_AUTO_BANK_IMPORT.G_bank_account_id,
361: P_CURRENCY_CODE => CE_AUTO_BANK_IMPORT.G_cshi_currency_code,
362: P_BALANCE_DATE => CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
363: P_BALANCE_AMOUNT_A => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
364: P_BALANCE_AMOUNT_B => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
357:
358: XTR_WRAPPER_API_P.bank_balance_upload(
359: P_ORG_ID => CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID, --CE_AUTO_BANK_IMPORT.G_cshi_org_id,
360: P_CE_BANK_ACCOUNT_ID => CE_AUTO_BANK_IMPORT.G_bank_account_id,
361: P_CURRENCY_CODE => CE_AUTO_BANK_IMPORT.G_cshi_currency_code,
362: P_BALANCE_DATE => CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
363: P_BALANCE_AMOUNT_A => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
364: P_BALANCE_AMOUNT_B => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
365: P_BALANCE_AMOUNT_C => CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
358: XTR_WRAPPER_API_P.bank_balance_upload(
359: P_ORG_ID => CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID, --CE_AUTO_BANK_IMPORT.G_cshi_org_id,
360: P_CE_BANK_ACCOUNT_ID => CE_AUTO_BANK_IMPORT.G_bank_account_id,
361: P_CURRENCY_CODE => CE_AUTO_BANK_IMPORT.G_cshi_currency_code,
362: P_BALANCE_DATE => CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
363: P_BALANCE_AMOUNT_A => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
364: P_BALANCE_AMOUNT_B => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
365: P_BALANCE_AMOUNT_C => CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
366: P_ONE_DAY_FLOAT => CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
359: P_ORG_ID => CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID, --CE_AUTO_BANK_IMPORT.G_cshi_org_id,
360: P_CE_BANK_ACCOUNT_ID => CE_AUTO_BANK_IMPORT.G_bank_account_id,
361: P_CURRENCY_CODE => CE_AUTO_BANK_IMPORT.G_cshi_currency_code,
362: P_BALANCE_DATE => CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
363: P_BALANCE_AMOUNT_A => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
364: P_BALANCE_AMOUNT_B => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
365: P_BALANCE_AMOUNT_C => CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
366: P_ONE_DAY_FLOAT => CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
367: P_TWO_DAY_FLOAT => CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
360: P_CE_BANK_ACCOUNT_ID => CE_AUTO_BANK_IMPORT.G_bank_account_id,
361: P_CURRENCY_CODE => CE_AUTO_BANK_IMPORT.G_cshi_currency_code,
362: P_BALANCE_DATE => CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
363: P_BALANCE_AMOUNT_A => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
364: P_BALANCE_AMOUNT_B => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
365: P_BALANCE_AMOUNT_C => CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
366: P_ONE_DAY_FLOAT => CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
367: P_TWO_DAY_FLOAT => CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
368: P_RESULT => X_RESULT,
361: P_CURRENCY_CODE => CE_AUTO_BANK_IMPORT.G_cshi_currency_code,
362: P_BALANCE_DATE => CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
363: P_BALANCE_AMOUNT_A => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
364: P_BALANCE_AMOUNT_B => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
365: P_BALANCE_AMOUNT_C => CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
366: P_ONE_DAY_FLOAT => CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
367: P_TWO_DAY_FLOAT => CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
368: P_RESULT => X_RESULT,
369: P_ERROR_MSG => X_ERROR_MSG);
362: P_BALANCE_DATE => CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
363: P_BALANCE_AMOUNT_A => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
364: P_BALANCE_AMOUNT_B => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
365: P_BALANCE_AMOUNT_C => CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
366: P_ONE_DAY_FLOAT => CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
367: P_TWO_DAY_FLOAT => CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
368: P_RESULT => X_RESULT,
369: P_ERROR_MSG => X_ERROR_MSG);
370: IF l_DEBUG in ('Y', 'C') THEN
363: P_BALANCE_AMOUNT_A => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
364: P_BALANCE_AMOUNT_B => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
365: P_BALANCE_AMOUNT_C => CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
366: P_ONE_DAY_FLOAT => CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
367: P_TWO_DAY_FLOAT => CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
368: P_RESULT => X_RESULT,
369: P_ERROR_MSG => X_ERROR_MSG);
370: IF l_DEBUG in ('Y', 'C') THEN
371: cep_standard.debug('transfer_bank_balances x_result = '|| x_result);
379: return TRUE;
380: else /* do not import */
381: FND_FILE.put_line(FND_FILE.LOG, X_ERROR_MSG);
382: set_warning :=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Check log file for warning messages');
383: bu_error_found := CE_AUTO_BANK_IMPORT.header_error('CE_BU_FAILED');
384: update_header_status('E');
385: return FALSE;
386: end if;
387: IF l_DEBUG in ('Y', 'C') THEN
384: update_header_status('E');
385: return FALSE;
386: end if;
387: IF l_DEBUG in ('Y', 'C') THEN
388: cep_standard.debug('<
390: EXCEPTION
391: WHEN OTHERS THEN
392: IF l_DEBUG in ('Y', 'C') THEN
389: END IF;
390: EXCEPTION
391: WHEN OTHERS THEN
392: IF l_DEBUG in ('Y', 'C') THEN
393: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.transfer_bank_balances');
394: END IF;
395: RAISE;
396: END transfer_bank_balances;
397:
408: -----------------------------------------------------------------------*/
409: PROCEDURE purge_data IS
410: BEGIN
411: IF l_DEBUG in ('Y', 'C') THEN
412: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.purge_data');
413: END IF;
414: DELETE FROM ce_statement_headers_int sh
415: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid;
416:
411: IF l_DEBUG in ('Y', 'C') THEN
412: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.purge_data');
413: END IF;
414: DELETE FROM ce_statement_headers_int sh
415: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid;
416:
417: DELETE FROM ce_statement_lines_interface sl
418: WHERE sl.bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num
419: AND sl.statement_number = CE_AUTO_BANK_IMPORT.G_cshi_statement_number;
414: DELETE FROM ce_statement_headers_int sh
415: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid;
416:
417: DELETE FROM ce_statement_lines_interface sl
418: WHERE sl.bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num
419: AND sl.statement_number = CE_AUTO_BANK_IMPORT.G_cshi_statement_number;
420: IF l_DEBUG in ('Y', 'C') THEN
421: cep_standard.debug('<
415: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid;
416:
417: DELETE FROM ce_statement_lines_interface sl
418: WHERE sl.bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num
419: AND sl.statement_number = CE_AUTO_BANK_IMPORT.G_cshi_statement_number;
420: IF l_DEBUG in ('Y', 'C') THEN
421: cep_standard.debug('<
423: EXCEPTION
417: DELETE FROM ce_statement_lines_interface sl
418: WHERE sl.bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num
419: AND sl.statement_number = CE_AUTO_BANK_IMPORT.G_cshi_statement_number;
420: IF l_DEBUG in ('Y', 'C') THEN
421: cep_standard.debug('<
423: EXCEPTION
424: WHEN others THEN
425: IF l_DEBUG in ('Y', 'C') THEN
422: END IF;
423: EXCEPTION
424: WHEN others THEN
425: IF l_DEBUG in ('Y', 'C') THEN
426: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.purge_data' );
427: RAISE;
428: END IF;
429: END purge_data;
430:
440: --------------------------------------------------------------------- */
441: PROCEDURE archive_lines IS
442: BEGIN
443: IF l_DEBUG in ('Y', 'C') THEN
444: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.archive_lines');
445: END IF;
446: INSERT INTO ce_arch_interface_lines
447: (bank_account_num,
448: statement_number,
520: attribute13,
521: attribute14,
522: attribute15
523: FROM ce_statement_lines_interface
524: WHERE statement_number = CE_AUTO_BANK_IMPORT.G_cshi_statement_number
525: AND bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num;
526: IF l_DEBUG in ('Y', 'C') THEN
527: cep_standard.debug('<
521: attribute14,
522: attribute15
523: FROM ce_statement_lines_interface
524: WHERE statement_number = CE_AUTO_BANK_IMPORT.G_cshi_statement_number
525: AND bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num;
526: IF l_DEBUG in ('Y', 'C') THEN
527: cep_standard.debug('<
529: EXCEPTION
523: FROM ce_statement_lines_interface
524: WHERE statement_number = CE_AUTO_BANK_IMPORT.G_cshi_statement_number
525: AND bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num;
526: IF l_DEBUG in ('Y', 'C') THEN
527: cep_standard.debug('<
529: EXCEPTION
530: WHEN OTHERS THEN
531: IF l_DEBUG in ('Y', 'C') THEN
528: END IF;
529: EXCEPTION
530: WHEN OTHERS THEN
531: IF l_DEBUG in ('Y', 'C') THEN
532: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.archive_lines');
533: END IF;
534: RAISE;
535: END archive_lines;
536:
546: ---------------------------------------------------------------------- */
547: PROCEDURE archive_header IS
548: BEGIN
549: IF l_DEBUG in ('Y', 'C') THEN
550: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.archive_header');
551: END IF;
552: INSERT INTO ce_arch_interface_headers
553: (statement_number,
554: bank_account_num,
640: last_updated_by,
641: last_update_date
642: --org_id
643: FROM ce_statement_headers_int
644: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid;
645: IF l_DEBUG in ('Y', 'C') THEN
646: cep_standard.debug('<
648: EXCEPTION
642: --org_id
643: FROM ce_statement_headers_int
644: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid;
645: IF l_DEBUG in ('Y', 'C') THEN
646: cep_standard.debug('<
648: EXCEPTION
649: WHEN OTHERS THEN
650: IF l_DEBUG in ('Y', 'C') THEN
647: END IF;
648: EXCEPTION
649: WHEN OTHERS THEN
650: IF l_DEBUG in ('Y', 'C') THEN
651: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.archive_header');
652: END IF;
653: RAISE;
654: END archive_header;
655:
673: seq_value IN OUT NOCOPY NUMBER) RETURN BOOLEAN IS
674: l_return_code NUMBER;
675: BEGIN
676: IF l_DEBUG in ('Y', 'C') THEN
677: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.get_sequence_info' );
678: END IF;
679: IF (CE_AUTO_BANK_REC.G_sequence_numbering IN ('A','P')) THEN
680: --
681: -- bug# 1062247
690: seq_id,
691: 'N', 'N');
692:
693: IF l_DEBUG in ('Y', 'C') THEN
694: cep_standard.debug('get_sequence_info: ' || '>>CE_AUTO_BANK_IMPORT.dbseqname: '|| seq_name || '----------' ||
695: 'get_sequence_info: ' || '>>CE_AUTO_BANK_IMPORT.seq_id: '|| TO_CHAR( seq_id ) || '----------' ||
696: 'get_sequence_info: ' || '>>CE_AUTO_BANK_IMPORT.doc_seq_value: '|| TO_CHAR( seq_value ) );
697: END IF;
698: END IF;
691: 'N', 'N');
692:
693: IF l_DEBUG in ('Y', 'C') THEN
694: cep_standard.debug('get_sequence_info: ' || '>>CE_AUTO_BANK_IMPORT.dbseqname: '|| seq_name || '----------' ||
695: 'get_sequence_info: ' || '>>CE_AUTO_BANK_IMPORT.seq_id: '|| TO_CHAR( seq_id ) || '----------' ||
696: 'get_sequence_info: ' || '>>CE_AUTO_BANK_IMPORT.doc_seq_value: '|| TO_CHAR( seq_value ) );
697: END IF;
698: END IF;
699: IF (((NVL(seq_value,0) = 0) OR l_return_code <> 0)
692:
693: IF l_DEBUG in ('Y', 'C') THEN
694: cep_standard.debug('get_sequence_info: ' || '>>CE_AUTO_BANK_IMPORT.dbseqname: '|| seq_name || '----------' ||
695: 'get_sequence_info: ' || '>>CE_AUTO_BANK_IMPORT.seq_id: '|| TO_CHAR( seq_id ) || '----------' ||
696: 'get_sequence_info: ' || '>>CE_AUTO_BANK_IMPORT.doc_seq_value: '|| TO_CHAR( seq_value ) );
697: END IF;
698: END IF;
699: IF (((NVL(seq_value,0) = 0) OR l_return_code <> 0)
700: AND (CE_AUTO_BANK_REC.G_sequence_numbering = 'A' )) THEN
702: ELSE
703: RETURN TRUE;
704: END IF;
705: IF l_DEBUG in ('Y', 'C') THEN
706: cep_standard.debug('<
708: EXCEPTION
709: WHEN OTHERS THEN
710: IF (CE_AUTO_BANK_REC.G_sequence_numbering= 'A') THEN
727: FUNCTION lock_statement RETURN BOOLEAN IS
728: X_statement_number CE_STATEMENT_HEADERS_INT.statement_number%TYPE;
729: BEGIN
730: IF l_DEBUG in ('Y', 'C') THEN
731: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.lock_statement');
732: END IF;
733: SELECT statement_number
734: INTO X_statement_number
735: FROM ce_statement_headers_int
732: END IF;
733: SELECT statement_number
734: INTO X_statement_number
735: FROM ce_statement_headers_int
736: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid
737: FOR UPDATE OF statement_number NOWAIT;
738:
739: IF l_DEBUG in ('Y', 'C') THEN
740: cep_standard.debug('<
736: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid
737: FOR UPDATE OF statement_number NOWAIT;
738:
739: IF l_DEBUG in ('Y', 'C') THEN
740: cep_standard.debug('<
742: RETURN(TRUE);
743: EXCEPTION
744: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
742: RETURN(TRUE);
743: EXCEPTION
744: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
745: IF l_DEBUG in ('Y', 'C') THEN
746: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.lock_statement STATEMENT LOCKED');
747: END IF;
748: return(FALSE);
749: WHEN OTHERS THEN
750: IF l_DEBUG in ('Y', 'C') THEN
747: END IF;
748: return(FALSE);
749: WHEN OTHERS THEN
750: IF l_DEBUG in ('Y', 'C') THEN
751: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.lock_statement');
752: END IF;
753: RAISE;
754: return(FALSE);
755: END lock_statement;
767: FUNCTION lock_statement_line(csli_rowid IN VARCHAR2) RETURN BOOLEAN IS
768: csli_amount CE_STATEMENT_LINES.amount%TYPE;
769: BEGIN
770: IF l_DEBUG in ('Y', 'C') THEN
771: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.lock_statement_line');
772: END IF;
773: SELECT amount
774: INTO csli_amount
775: FROM ce_statement_lines_interface
775: FROM ce_statement_lines_interface
776: WHERE rowid = csli_rowid
777: FOR UPDATE OF bank_account_num NOWAIT;
778: IF l_DEBUG in ('Y', 'C') THEN
779: cep_standard.debug('<
781: RETURN(TRUE);
782: EXCEPTION
783: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
781: RETURN(TRUE);
782: EXCEPTION
783: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
784: IF l_DEBUG in ('Y', 'C') THEN
785: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.lock_statement_line STATEMENT LOCKED');
786: END IF;
787: return(FALSE);
788: WHEN OTHERS THEN
789: IF l_DEBUG in ('Y', 'C') THEN
786: END IF;
787: return(FALSE);
788: WHEN OTHERS THEN
789: IF l_DEBUG in ('Y', 'C') THEN
790: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.lock_statement_line');
791: END IF;
792: RAISE;
793: return(FALSE);
794: END lock_statement_line;
815: curr_relation VARCHAR2(30);
816:
817: BEGIN
818: IF l_DEBUG in ('Y', 'C') THEN
819: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.transfer_lines');
820: cep_standard.debug('func: '||CE_AUTO_BANK_REC.G_functional_currency);
821: END IF;
822:
823: IF (G_cshi_intra_day_flag = 'Y' AND CE_AUTO_BANK_REC.G_intra_day_flag = 'Y') THEN
910: aba.bank_account_id
911: AND csli.statement_number = G_cshi_statement_number
912: AND csli.bank_account_num = aba.bank_account_num
913: AND aba.bank_account_id = G_bank_account_id
914: AND ctc.reconciliation_sequence = CE_AUTO_BANK_IMPORT.G_trx_recon_seq_id; -- Bug 8965556 Added condition
915: ELSIF (nvl(G_cshi_intra_day_flag,'N') <> 'Y' AND CE_AUTO_BANK_REC.G_intra_day_flag <> 'Y') THEN
916: --Bug 6710502: Added an nvl to subsisdiary flag to handle records upgraded from 11i to R12
917: IF ( nvl(G_cshi_subsidiary_flag,'N') = 'N' ) THEN
918: INSERT INTO ce_statement_lines
956: attribute13,
957: attribute14,
958: attribute15)
959: SELECT ce_statement_lines_s.nextval,
960: CE_AUTO_BANK_IMPORT.G_cshi_statement_header_id,
961: csli.line_number,
962: csli.trx_date,
963: (select distinct ctc.trx_type
964: from ce_transaction_codes ctc
1019: --AND ctc.trx_code(+) = csli.trx_code
1020: --AND NVL(ctc.bank_account_id,aba.bank_account_id) =
1021: -- aba.bank_account_id
1022: AND csli.statement_number =
1023: CE_AUTO_BANK_IMPORT.G_cshi_statement_number
1024: AND csli.bank_account_num = aba.bank_account_num
1025: AND aba.bank_account_id = CE_AUTO_BANK_IMPORT.G_bank_account_id;
1026: END IF;
1027: END IF;
1021: -- aba.bank_account_id
1022: AND csli.statement_number =
1023: CE_AUTO_BANK_IMPORT.G_cshi_statement_number
1024: AND csli.bank_account_num = aba.bank_account_num
1025: AND aba.bank_account_id = CE_AUTO_BANK_IMPORT.G_bank_account_id;
1026: END IF;
1027: END IF;
1028: IF l_DEBUG in ('Y', 'C') THEN
1029: cep_standard.debug('<
1025: AND aba.bank_account_id = CE_AUTO_BANK_IMPORT.G_bank_account_id;
1026: END IF;
1027: END IF;
1028: IF l_DEBUG in ('Y', 'C') THEN
1029: cep_standard.debug('<
1031: EXCEPTION
1032: WHEN OTHERS THEN
1033: IF l_DEBUG in ('Y', 'C') THEN
1030: END IF;
1031: EXCEPTION
1032: WHEN OTHERS THEN
1033: IF l_DEBUG in ('Y', 'C') THEN
1034: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.transfer_lines');
1035: END IF;
1036: RAISE;
1037: END transfer_lines;
1038:
1065: X_bank_acct_balance_id NUMBER;
1066:
1067: BEGIN
1068: IF l_DEBUG in ('Y', 'C') THEN
1069: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.transfer_header '||
1070: ' CE_AUTO_BANK_IMPORT.aba_bank_account_id : '|| aba_bank_account_id||
1071: ', CE_AUTO_BANK_IMPORT.aba_bank_account_name : '|| aba_bank_account_name);
1072: END IF;
1073: --
1066:
1067: BEGIN
1068: IF l_DEBUG in ('Y', 'C') THEN
1069: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.transfer_header '||
1070: ' CE_AUTO_BANK_IMPORT.aba_bank_account_id : '|| aba_bank_account_id||
1071: ', CE_AUTO_BANK_IMPORT.aba_bank_account_name : '|| aba_bank_account_name);
1072: END IF;
1073: --
1074: -- Call the AOL sequence numbering routine to get Seq. number
1067: BEGIN
1068: IF l_DEBUG in ('Y', 'C') THEN
1069: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.transfer_header '||
1070: ' CE_AUTO_BANK_IMPORT.aba_bank_account_id : '|| aba_bank_account_id||
1071: ', CE_AUTO_BANK_IMPORT.aba_bank_account_name : '|| aba_bank_account_name);
1072: END IF;
1073: --
1074: -- Call the AOL sequence numbering routine to get Seq. number
1075: --
1072: END IF;
1073: --
1074: -- Call the AOL sequence numbering routine to get Seq. number
1075: --
1076: l_valid_seq := CE_AUTO_BANK_IMPORT.get_sequence_info(260,
1077: aba_bank_account_name,
1078: CE_AUTO_BANK_REC.G_set_of_books_id,
1079: 'A',
1080: CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
1076: l_valid_seq := CE_AUTO_BANK_IMPORT.get_sequence_info(260,
1077: aba_bank_account_name,
1078: CE_AUTO_BANK_REC.G_set_of_books_id,
1079: 'A',
1080: CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
1081: l_dbseqname,
1082: l_doc_seq_id,
1083: l_doc_seq_value );
1084:
1089: IF l_DEBUG in ('Y', 'C') THEN
1090: cep_standard.debug('transfer_header not l_valid_seq ');
1091: END IF;
1092:
1093: l_valid_seq := CE_AUTO_BANK_IMPORT.header_error('CE_DOC_SEQUENCE_HEADER_ERR');
1094: update_header_status('E');
1095: return FALSE;
1096: ELSE
1097: CE_AUTO_BANK_IMPORT.G_cshi_statement_header_id := NULL;
1093: l_valid_seq := CE_AUTO_BANK_IMPORT.header_error('CE_DOC_SEQUENCE_HEADER_ERR');
1094: update_header_status('E');
1095: return FALSE;
1096: ELSE
1097: CE_AUTO_BANK_IMPORT.G_cshi_statement_header_id := NULL;
1098: IF l_DEBUG in ('Y', 'C') THEN
1099: cep_standard.debug('G_cshi_intra_day_flag '|| G_cshi_intra_day_flag ||
1100: ', CE_AUTO_BANK_REC.G_intra_day_flag '|| CE_AUTO_BANK_REC.G_intra_day_flag);
1101: END IF;
1208:
1209: --check if statement date is less than sysdate
1210: -- cannot import statements with date greater than or equal to sysdate
1211: -- Bug 8726869
1212: if (trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date) > trunc(sysdate)) then
1213: l_dup_balance:= CE_AUTO_BANK_IMPORT.header_error('CE_LOD_STATEMENT_DATE');
1214: update_header_status('E'); --9958271
1215: RETURN FALSE;
1216: end if;
1209: --check if statement date is less than sysdate
1210: -- cannot import statements with date greater than or equal to sysdate
1211: -- Bug 8726869
1212: if (trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date) > trunc(sysdate)) then
1213: l_dup_balance:= CE_AUTO_BANK_IMPORT.header_error('CE_LOD_STATEMENT_DATE');
1214: update_header_status('E'); --9958271
1215: RETURN FALSE;
1216: end if;
1217:
1218: select count(1)
1219: into x_bal_count
1220: from ce_bank_acct_balances
1221: where bank_account_id = aba_bank_account_id
1222: and balance_date = trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date);
1223:
1224: IF x_bal_count > 0 THEN
1225: x_flag:='YI'; --balance already exist when inserting through loader
1226: --check if all the balance values are same, if yes then no log message required
1224: IF x_bal_count > 0 THEN
1225: x_flag:='YI'; --balance already exist when inserting through loader
1226: --check if all the balance values are same, if yes then no log message required
1227: if ( check_balance_values(aba_bank_account_id)=0)then
1228: l_dup_balance:=CE_AUTO_BANK_IMPORT.header_error('CE_DUP_BALANCE');
1229: end if;
1230: ELSE
1231: x_flag:='N';
1232: END IF;
1235: -- flag would be null.
1236: IF ( NVL(G_cshi_subsidiary_flag,'N') = 'N' ) THEN
1237: CE_STAT_HDRS_DML_PKG.insert_row (
1238: X_rowid => x_temp_rowid,
1239: X_statement_header_id => CE_AUTO_BANK_IMPORT.G_cshi_statement_header_id,
1240: X_bank_account_id => aba_bank_account_id,
1241: X_statement_number => CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1242: X_statement_date => trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date),
1243: X_check_digits => CE_AUTO_BANK_IMPORT.G_cshi_check_digits,
1237: CE_STAT_HDRS_DML_PKG.insert_row (
1238: X_rowid => x_temp_rowid,
1239: X_statement_header_id => CE_AUTO_BANK_IMPORT.G_cshi_statement_header_id,
1240: X_bank_account_id => aba_bank_account_id,
1241: X_statement_number => CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1242: X_statement_date => trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date),
1243: X_check_digits => CE_AUTO_BANK_IMPORT.G_cshi_check_digits,
1244: X_control_begin_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1245: X_control_end_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1238: X_rowid => x_temp_rowid,
1239: X_statement_header_id => CE_AUTO_BANK_IMPORT.G_cshi_statement_header_id,
1240: X_bank_account_id => aba_bank_account_id,
1241: X_statement_number => CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1242: X_statement_date => trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date),
1243: X_check_digits => CE_AUTO_BANK_IMPORT.G_cshi_check_digits,
1244: X_control_begin_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1245: X_control_end_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1246: X_cashflow_balance => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1239: X_statement_header_id => CE_AUTO_BANK_IMPORT.G_cshi_statement_header_id,
1240: X_bank_account_id => aba_bank_account_id,
1241: X_statement_number => CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1242: X_statement_date => trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date),
1243: X_check_digits => CE_AUTO_BANK_IMPORT.G_cshi_check_digits,
1244: X_control_begin_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1245: X_control_end_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1246: X_cashflow_balance => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1247: X_int_calc_balance => CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1240: X_bank_account_id => aba_bank_account_id,
1241: X_statement_number => CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1242: X_statement_date => trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date),
1243: X_check_digits => CE_AUTO_BANK_IMPORT.G_cshi_check_digits,
1244: X_control_begin_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1245: X_control_end_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1246: X_cashflow_balance => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1247: X_int_calc_balance => CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1248: X_one_day_float => CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1241: X_statement_number => CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1242: X_statement_date => trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date),
1243: X_check_digits => CE_AUTO_BANK_IMPORT.G_cshi_check_digits,
1244: X_control_begin_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1245: X_control_end_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1246: X_cashflow_balance => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1247: X_int_calc_balance => CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1248: X_one_day_float => CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1249: X_two_day_float => CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1242: X_statement_date => trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date),
1243: X_check_digits => CE_AUTO_BANK_IMPORT.G_cshi_check_digits,
1244: X_control_begin_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1245: X_control_end_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1246: X_cashflow_balance => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1247: X_int_calc_balance => CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1248: X_one_day_float => CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1249: X_two_day_float => CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1250: X_control_total_dr => CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1243: X_check_digits => CE_AUTO_BANK_IMPORT.G_cshi_check_digits,
1244: X_control_begin_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1245: X_control_end_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1246: X_cashflow_balance => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1247: X_int_calc_balance => CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1248: X_one_day_float => CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1249: X_two_day_float => CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1250: X_control_total_dr => CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1251: X_control_total_cr => CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,
1244: X_control_begin_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1245: X_control_end_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1246: X_cashflow_balance => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1247: X_int_calc_balance => CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1248: X_one_day_float => CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1249: X_two_day_float => CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1250: X_control_total_dr => CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1251: X_control_total_cr => CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,
1252: X_control_dr_line_count => CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,
1245: X_control_end_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1246: X_cashflow_balance => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1247: X_int_calc_balance => CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1248: X_one_day_float => CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1249: X_two_day_float => CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1250: X_control_total_dr => CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1251: X_control_total_cr => CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,
1252: X_control_dr_line_count => CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,
1253: X_control_cr_line_count => CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,
1246: X_cashflow_balance => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1247: X_int_calc_balance => CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1248: X_one_day_float => CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1249: X_two_day_float => CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1250: X_control_total_dr => CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1251: X_control_total_cr => CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,
1252: X_control_dr_line_count => CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,
1253: X_control_cr_line_count => CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,
1254: X_doc_sequence_id => l_doc_seq_id,
1247: X_int_calc_balance => CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1248: X_one_day_float => CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1249: X_two_day_float => CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1250: X_control_total_dr => CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1251: X_control_total_cr => CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,
1252: X_control_dr_line_count => CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,
1253: X_control_cr_line_count => CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,
1254: X_doc_sequence_id => l_doc_seq_id,
1255: X_doc_sequence_value => l_doc_seq_value,
1248: X_one_day_float => CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1249: X_two_day_float => CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1250: X_control_total_dr => CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1251: X_control_total_cr => CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,
1252: X_control_dr_line_count => CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,
1253: X_control_cr_line_count => CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,
1254: X_doc_sequence_id => l_doc_seq_id,
1255: X_doc_sequence_value => l_doc_seq_value,
1256: X_created_by => NVL(FND_GLOBAL.user_id,-1),
1249: X_two_day_float => CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1250: X_control_total_dr => CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1251: X_control_total_cr => CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,
1252: X_control_dr_line_count => CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,
1253: X_control_cr_line_count => CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,
1254: X_doc_sequence_id => l_doc_seq_id,
1255: X_doc_sequence_value => l_doc_seq_value,
1256: X_created_by => NVL(FND_GLOBAL.user_id,-1),
1257: X_creation_date => sysdate,
1256: X_created_by => NVL(FND_GLOBAL.user_id,-1),
1257: X_creation_date => sysdate,
1258: X_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
1259: X_last_update_date => sysdate,
1260: X_attribute_category => CE_AUTO_BANK_IMPORT.G_cshi_attribute_category ,
1261: X_attribute1 => CE_AUTO_BANK_IMPORT.G_cshi_attribute1,
1262: X_attribute2 => CE_AUTO_BANK_IMPORT.G_cshi_attribute2,
1263: X_attribute3 => CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1264: X_attribute4 => CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1257: X_creation_date => sysdate,
1258: X_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
1259: X_last_update_date => sysdate,
1260: X_attribute_category => CE_AUTO_BANK_IMPORT.G_cshi_attribute_category ,
1261: X_attribute1 => CE_AUTO_BANK_IMPORT.G_cshi_attribute1,
1262: X_attribute2 => CE_AUTO_BANK_IMPORT.G_cshi_attribute2,
1263: X_attribute3 => CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1264: X_attribute4 => CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1265: X_attribute5 => CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1258: X_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
1259: X_last_update_date => sysdate,
1260: X_attribute_category => CE_AUTO_BANK_IMPORT.G_cshi_attribute_category ,
1261: X_attribute1 => CE_AUTO_BANK_IMPORT.G_cshi_attribute1,
1262: X_attribute2 => CE_AUTO_BANK_IMPORT.G_cshi_attribute2,
1263: X_attribute3 => CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1264: X_attribute4 => CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1265: X_attribute5 => CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1266: X_attribute6 => CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1259: X_last_update_date => sysdate,
1260: X_attribute_category => CE_AUTO_BANK_IMPORT.G_cshi_attribute_category ,
1261: X_attribute1 => CE_AUTO_BANK_IMPORT.G_cshi_attribute1,
1262: X_attribute2 => CE_AUTO_BANK_IMPORT.G_cshi_attribute2,
1263: X_attribute3 => CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1264: X_attribute4 => CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1265: X_attribute5 => CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1266: X_attribute6 => CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1267: X_attribute7 => CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1260: X_attribute_category => CE_AUTO_BANK_IMPORT.G_cshi_attribute_category ,
1261: X_attribute1 => CE_AUTO_BANK_IMPORT.G_cshi_attribute1,
1262: X_attribute2 => CE_AUTO_BANK_IMPORT.G_cshi_attribute2,
1263: X_attribute3 => CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1264: X_attribute4 => CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1265: X_attribute5 => CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1266: X_attribute6 => CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1267: X_attribute7 => CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1268: X_attribute8 => CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1261: X_attribute1 => CE_AUTO_BANK_IMPORT.G_cshi_attribute1,
1262: X_attribute2 => CE_AUTO_BANK_IMPORT.G_cshi_attribute2,
1263: X_attribute3 => CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1264: X_attribute4 => CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1265: X_attribute5 => CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1266: X_attribute6 => CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1267: X_attribute7 => CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1268: X_attribute8 => CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1269: X_attribute9 => CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1262: X_attribute2 => CE_AUTO_BANK_IMPORT.G_cshi_attribute2,
1263: X_attribute3 => CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1264: X_attribute4 => CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1265: X_attribute5 => CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1266: X_attribute6 => CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1267: X_attribute7 => CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1268: X_attribute8 => CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1269: X_attribute9 => CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1270: X_attribute10 => CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1263: X_attribute3 => CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1264: X_attribute4 => CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1265: X_attribute5 => CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1266: X_attribute6 => CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1267: X_attribute7 => CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1268: X_attribute8 => CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1269: X_attribute9 => CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1270: X_attribute10 => CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1271: X_attribute11 => CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1264: X_attribute4 => CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1265: X_attribute5 => CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1266: X_attribute6 => CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1267: X_attribute7 => CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1268: X_attribute8 => CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1269: X_attribute9 => CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1270: X_attribute10 => CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1271: X_attribute11 => CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1272: X_attribute12 => CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1265: X_attribute5 => CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1266: X_attribute6 => CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1267: X_attribute7 => CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1268: X_attribute8 => CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1269: X_attribute9 => CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1270: X_attribute10 => CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1271: X_attribute11 => CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1272: X_attribute12 => CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1273: X_attribute13 => CE_AUTO_BANK_IMPORT.G_cshi_attribute13,
1266: X_attribute6 => CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1267: X_attribute7 => CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1268: X_attribute8 => CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1269: X_attribute9 => CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1270: X_attribute10 => CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1271: X_attribute11 => CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1272: X_attribute12 => CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1273: X_attribute13 => CE_AUTO_BANK_IMPORT.G_cshi_attribute13,
1274: X_attribute14 => CE_AUTO_BANK_IMPORT.G_cshi_attribute14,
1267: X_attribute7 => CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1268: X_attribute8 => CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1269: X_attribute9 => CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1270: X_attribute10 => CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1271: X_attribute11 => CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1272: X_attribute12 => CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1273: X_attribute13 => CE_AUTO_BANK_IMPORT.G_cshi_attribute13,
1274: X_attribute14 => CE_AUTO_BANK_IMPORT.G_cshi_attribute14,
1275: X_attribute15 => CE_AUTO_BANK_IMPORT.G_cshi_attribute15,
1268: X_attribute8 => CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1269: X_attribute9 => CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1270: X_attribute10 => CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1271: X_attribute11 => CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1272: X_attribute12 => CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1273: X_attribute13 => CE_AUTO_BANK_IMPORT.G_cshi_attribute13,
1274: X_attribute14 => CE_AUTO_BANK_IMPORT.G_cshi_attribute14,
1275: X_attribute15 => CE_AUTO_BANK_IMPORT.G_cshi_attribute15,
1276: X_auto_loaded_flag => 'Y',
1269: X_attribute9 => CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1270: X_attribute10 => CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1271: X_attribute11 => CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1272: X_attribute12 => CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1273: X_attribute13 => CE_AUTO_BANK_IMPORT.G_cshi_attribute13,
1274: X_attribute14 => CE_AUTO_BANK_IMPORT.G_cshi_attribute14,
1275: X_attribute15 => CE_AUTO_BANK_IMPORT.G_cshi_attribute15,
1276: X_auto_loaded_flag => 'Y',
1277: X_statement_complete_flag => 'N',
1270: X_attribute10 => CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1271: X_attribute11 => CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1272: X_attribute12 => CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1273: X_attribute13 => CE_AUTO_BANK_IMPORT.G_cshi_attribute13,
1274: X_attribute14 => CE_AUTO_BANK_IMPORT.G_cshi_attribute14,
1275: X_attribute15 => CE_AUTO_BANK_IMPORT.G_cshi_attribute15,
1276: X_auto_loaded_flag => 'Y',
1277: X_statement_complete_flag => 'N',
1278: X_gl_date => nvl(CE_AUTO_BANK_REC.G_gl_date, G_cshi_statement_date), --Bug 16085695 added nvl clause to g_gl_parameter
1271: X_attribute11 => CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1272: X_attribute12 => CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1273: X_attribute13 => CE_AUTO_BANK_IMPORT.G_cshi_attribute13,
1274: X_attribute14 => CE_AUTO_BANK_IMPORT.G_cshi_attribute14,
1275: X_attribute15 => CE_AUTO_BANK_IMPORT.G_cshi_attribute15,
1276: X_auto_loaded_flag => 'Y',
1277: X_statement_complete_flag => 'N',
1278: X_gl_date => nvl(CE_AUTO_BANK_REC.G_gl_date, G_cshi_statement_date), --Bug 16085695 added nvl clause to g_gl_parameter
1279: X_balance_flag => x_flag,
1276: X_auto_loaded_flag => 'Y',
1277: X_statement_complete_flag => 'N',
1278: X_gl_date => nvl(CE_AUTO_BANK_REC.G_gl_date, G_cshi_statement_date), --Bug 16085695 added nvl clause to g_gl_parameter
1279: X_balance_flag => x_flag,
1280: X_average_close_ledger_mtd => CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1281: X_average_close_ledger_ytd => CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1282: X_average_close_available_mtd => CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1283: X_average_close_available_ytd => CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1284: -- 5916290 : GDF Changes
1277: X_statement_complete_flag => 'N',
1278: X_gl_date => nvl(CE_AUTO_BANK_REC.G_gl_date, G_cshi_statement_date), --Bug 16085695 added nvl clause to g_gl_parameter
1279: X_balance_flag => x_flag,
1280: X_average_close_ledger_mtd => CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1281: X_average_close_ledger_ytd => CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1282: X_average_close_available_mtd => CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1283: X_average_close_available_ytd => CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1284: -- 5916290 : GDF Changes
1285: X_bank_acct_balance_id => NULL,
1278: X_gl_date => nvl(CE_AUTO_BANK_REC.G_gl_date, G_cshi_statement_date), --Bug 16085695 added nvl clause to g_gl_parameter
1279: X_balance_flag => x_flag,
1280: X_average_close_ledger_mtd => CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1281: X_average_close_ledger_ytd => CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1282: X_average_close_available_mtd => CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1283: X_average_close_available_ytd => CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1284: -- 5916290 : GDF Changes
1285: X_bank_acct_balance_id => NULL,
1286: X_global_att_category => NULL,
1279: X_balance_flag => x_flag,
1280: X_average_close_ledger_mtd => CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1281: X_average_close_ledger_ytd => CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1282: X_average_close_available_mtd => CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1283: X_average_close_available_ytd => CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1284: -- 5916290 : GDF Changes
1285: X_bank_acct_balance_id => NULL,
1286: X_global_att_category => NULL,
1287: X_global_attribute1 => NULL,
1331: object_version_number)
1332: values
1333: (X_bank_acct_balance_id,
1334: aba_bank_account_id,
1335: trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date),
1336: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1337: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1338: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1339: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1332: values
1333: (X_bank_acct_balance_id,
1334: aba_bank_account_id,
1335: trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date),
1336: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1337: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1338: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1339: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1340: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1333: (X_bank_acct_balance_id,
1334: aba_bank_account_id,
1335: trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date),
1336: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1337: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1338: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1339: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1340: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1341: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1334: aba_bank_account_id,
1335: trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date),
1336: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1337: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1338: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1339: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1340: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1341: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1342: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1335: trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date),
1336: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1337: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1338: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1339: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1340: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1341: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1342: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1343: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1336: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1337: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1338: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1339: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1340: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1341: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1342: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1343: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1344: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1337: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1338: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1339: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1340: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1341: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1342: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1343: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1344: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1345: sysdate,
1338: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1339: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1340: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1341: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1342: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1343: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1344: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1345: sysdate,
1346: NVL(FND_GLOBAL.user_id,-1),
1339: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1340: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1341: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1342: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1343: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1344: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1345: sysdate,
1346: NVL(FND_GLOBAL.user_id,-1),
1347: sysdate,
1340: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1341: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1342: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1343: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1344: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1345: sysdate,
1346: NVL(FND_GLOBAL.user_id,-1),
1347: sysdate,
1348: NVL(FND_GLOBAL.user_id,-1),
1359: RETURN FALSE;
1360: END IF;
1361: END IF;
1362: IF l_DEBUG in ('Y', 'C') THEN
1363: cep_standard.debug('<
1365: EXCEPTION
1366: WHEN APP_EXCEPTION.application_exception THEN
1367: IF l_DEBUG in ('Y', 'C') THEN
1364: END IF;
1365: EXCEPTION
1366: WHEN APP_EXCEPTION.application_exception THEN
1367: IF l_DEBUG in ('Y', 'C') THEN
1368: cep_standard.debug('EXCEPTION:CE_AUTO_BANK_IMPORT.transfer_header-APP_EXCEPTION');
1369: END IF;
1370: l_encoded_message := FND_MESSAGE.GET_ENCODED;
1371: IF (l_encoded_message IS NOT NULL) THEN
1372: FND_MESSAGE.parse_encoded(l_encoded_message,l_app_short_name,l_message_name);
1375: cep_standard.debug('transfer_header: ' || 'No messages on stack');
1376: END IF;
1377: l_message_name := 'OTHER_APP_ERROR';
1378: END IF;
1379: l_valid_seq := CE_AUTO_BANK_IMPORT.header_error('CE_DOC_SEQUENCE_HEADER_ERR');
1380: update_header_status('E');
1381: return FALSE;
1382: WHEN OTHERS THEN
1383: IF l_DEBUG in ('Y', 'C') THEN
1380: update_header_status('E');
1381: return FALSE;
1382: WHEN OTHERS THEN
1383: IF l_DEBUG in ('Y', 'C') THEN
1384: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.transfer_header');
1385: END IF;
1386: RAISE;
1387: END transfer_header;
1388:
1405: --------------------------------------------------------------------- */
1406: PROCEDURE update_header_status(p_status VARCHAR2) IS
1407: BEGIN
1408: IF l_DEBUG in ('Y', 'C') THEN
1409: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.update_header_status');
1410: END IF;
1411: UPDATE ce_statement_headers_int
1412: SET record_status_flag = p_status
1413: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid;
1409: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.update_header_status');
1410: END IF;
1411: UPDATE ce_statement_headers_int
1412: SET record_status_flag = p_status
1413: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid;
1414: IF l_DEBUG in ('Y', 'C') THEN
1415: cep_standard.debug('<
1417: EXCEPTION
1411: UPDATE ce_statement_headers_int
1412: SET record_status_flag = p_status
1413: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid;
1414: IF l_DEBUG in ('Y', 'C') THEN
1415: cep_standard.debug('<
1417: EXCEPTION
1418: WHEN OTHERS THEN
1419: IF l_DEBUG in ('Y', 'C') THEN
1416: END IF;
1417: EXCEPTION
1418: WHEN OTHERS THEN
1419: IF l_DEBUG in ('Y', 'C') THEN
1420: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.update_header_status');
1421: END IF;
1422: RAISE;
1423: END update_header_status;
1424:
1440: FUNCTION validate_control_totals RETURN BOOLEAN IS
1441: error_found BOOLEAN;
1442: BEGIN
1443: IF l_DEBUG in ('Y', 'C') THEN
1444: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.validate_control_totals');
1445: END IF;
1446: error_found := FALSE;
1447: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,CE_AUTO_BANK_IMPORT.G_dr_sum) <> CE_AUTO_BANK_IMPORT.G_dr_sum) THEN
1448: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_DR_TOTAL');
1443: IF l_DEBUG in ('Y', 'C') THEN
1444: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.validate_control_totals');
1445: END IF;
1446: error_found := FALSE;
1447: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,CE_AUTO_BANK_IMPORT.G_dr_sum) <> CE_AUTO_BANK_IMPORT.G_dr_sum) THEN
1448: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_DR_TOTAL');
1449: END IF;
1450: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,CE_AUTO_BANK_IMPORT.G_cr_sum) <> CE_AUTO_BANK_IMPORT.G_cr_sum) THEN
1451: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_CR_TOTAL');
1444: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.validate_control_totals');
1445: END IF;
1446: error_found := FALSE;
1447: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,CE_AUTO_BANK_IMPORT.G_dr_sum) <> CE_AUTO_BANK_IMPORT.G_dr_sum) THEN
1448: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_DR_TOTAL');
1449: END IF;
1450: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,CE_AUTO_BANK_IMPORT.G_cr_sum) <> CE_AUTO_BANK_IMPORT.G_cr_sum) THEN
1451: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_CR_TOTAL');
1452: END IF;
1446: error_found := FALSE;
1447: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,CE_AUTO_BANK_IMPORT.G_dr_sum) <> CE_AUTO_BANK_IMPORT.G_dr_sum) THEN
1448: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_DR_TOTAL');
1449: END IF;
1450: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,CE_AUTO_BANK_IMPORT.G_cr_sum) <> CE_AUTO_BANK_IMPORT.G_cr_sum) THEN
1451: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_CR_TOTAL');
1452: END IF;
1453: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,CE_AUTO_BANK_IMPORT.G_dr_count) <> CE_AUTO_BANK_IMPORT.G_dr_count) THEN
1454: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_DR_LINE_COUNT');
1447: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,CE_AUTO_BANK_IMPORT.G_dr_sum) <> CE_AUTO_BANK_IMPORT.G_dr_sum) THEN
1448: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_DR_TOTAL');
1449: END IF;
1450: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,CE_AUTO_BANK_IMPORT.G_cr_sum) <> CE_AUTO_BANK_IMPORT.G_cr_sum) THEN
1451: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_CR_TOTAL');
1452: END IF;
1453: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,CE_AUTO_BANK_IMPORT.G_dr_count) <> CE_AUTO_BANK_IMPORT.G_dr_count) THEN
1454: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_DR_LINE_COUNT');
1455: END IF;
1449: END IF;
1450: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,CE_AUTO_BANK_IMPORT.G_cr_sum) <> CE_AUTO_BANK_IMPORT.G_cr_sum) THEN
1451: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_CR_TOTAL');
1452: END IF;
1453: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,CE_AUTO_BANK_IMPORT.G_dr_count) <> CE_AUTO_BANK_IMPORT.G_dr_count) THEN
1454: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_DR_LINE_COUNT');
1455: END IF;
1456: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,CE_AUTO_BANK_IMPORT.G_cr_count) <> CE_AUTO_BANK_IMPORT.G_cr_count) THEN
1457: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CR_LINE_COUNT');
1450: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,CE_AUTO_BANK_IMPORT.G_cr_sum) <> CE_AUTO_BANK_IMPORT.G_cr_sum) THEN
1451: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_CR_TOTAL');
1452: END IF;
1453: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,CE_AUTO_BANK_IMPORT.G_dr_count) <> CE_AUTO_BANK_IMPORT.G_dr_count) THEN
1454: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_DR_LINE_COUNT');
1455: END IF;
1456: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,CE_AUTO_BANK_IMPORT.G_cr_count) <> CE_AUTO_BANK_IMPORT.G_cr_count) THEN
1457: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CR_LINE_COUNT');
1458: END IF;
1452: END IF;
1453: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,CE_AUTO_BANK_IMPORT.G_dr_count) <> CE_AUTO_BANK_IMPORT.G_dr_count) THEN
1454: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_DR_LINE_COUNT');
1455: END IF;
1456: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,CE_AUTO_BANK_IMPORT.G_cr_count) <> CE_AUTO_BANK_IMPORT.G_cr_count) THEN
1457: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CR_LINE_COUNT');
1458: END IF;
1459: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,0) -
1460: NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,0) +
1453: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,CE_AUTO_BANK_IMPORT.G_dr_count) <> CE_AUTO_BANK_IMPORT.G_dr_count) THEN
1454: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_DR_LINE_COUNT');
1455: END IF;
1456: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,CE_AUTO_BANK_IMPORT.G_cr_count) <> CE_AUTO_BANK_IMPORT.G_cr_count) THEN
1457: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CR_LINE_COUNT');
1458: END IF;
1459: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,0) -
1460: NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,0) +
1461: NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,0) <> NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,0)) THEN
1455: END IF;
1456: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,CE_AUTO_BANK_IMPORT.G_cr_count) <> CE_AUTO_BANK_IMPORT.G_cr_count) THEN
1457: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CR_LINE_COUNT');
1458: END IF;
1459: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,0) -
1460: NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,0) +
1461: NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,0) <> NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,0)) THEN
1462: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_END_BALANCE');
1463: END IF;
1456: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,CE_AUTO_BANK_IMPORT.G_cr_count) <> CE_AUTO_BANK_IMPORT.G_cr_count) THEN
1457: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CR_LINE_COUNT');
1458: END IF;
1459: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,0) -
1460: NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,0) +
1461: NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,0) <> NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,0)) THEN
1462: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_END_BALANCE');
1463: END IF;
1464: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_line_count,CE_AUTO_BANK_IMPORT.G_total_count) <> CE_AUTO_BANK_IMPORT.G_total_count) THEN
1457: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CR_LINE_COUNT');
1458: END IF;
1459: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,0) -
1460: NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,0) +
1461: NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,0) <> NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,0)) THEN
1462: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_END_BALANCE');
1463: END IF;
1464: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_line_count,CE_AUTO_BANK_IMPORT.G_total_count) <> CE_AUTO_BANK_IMPORT.G_total_count) THEN
1465: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_LINE_COUNT');
1458: END IF;
1459: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,0) -
1460: NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,0) +
1461: NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,0) <> NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,0)) THEN
1462: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_END_BALANCE');
1463: END IF;
1464: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_line_count,CE_AUTO_BANK_IMPORT.G_total_count) <> CE_AUTO_BANK_IMPORT.G_total_count) THEN
1465: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_LINE_COUNT');
1466: END IF;
1460: NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,0) +
1461: NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,0) <> NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,0)) THEN
1462: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_END_BALANCE');
1463: END IF;
1464: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_line_count,CE_AUTO_BANK_IMPORT.G_total_count) <> CE_AUTO_BANK_IMPORT.G_total_count) THEN
1465: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_LINE_COUNT');
1466: END IF;
1467: IF l_DEBUG in ('Y', 'C') THEN
1468: cep_standard.debug('<
1461: NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,0) <> NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,0)) THEN
1462: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_END_BALANCE');
1463: END IF;
1464: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_line_count,CE_AUTO_BANK_IMPORT.G_total_count) <> CE_AUTO_BANK_IMPORT.G_total_count) THEN
1465: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_LINE_COUNT');
1466: END IF;
1467: IF l_DEBUG in ('Y', 'C') THEN
1468: cep_standard.debug('<
1464: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_line_count,CE_AUTO_BANK_IMPORT.G_total_count) <> CE_AUTO_BANK_IMPORT.G_total_count) THEN
1465: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_LINE_COUNT');
1466: END IF;
1467: IF l_DEBUG in ('Y', 'C') THEN
1468: cep_standard.debug('<
1470: return error_found;
1471: EXCEPTION
1472: WHEN OTHERS THEN
1469: END IF;
1470: return error_found;
1471: EXCEPTION
1472: WHEN OTHERS THEN
1473: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.validate_control_totals');
1474: RAISE;
1475: END validate_control_totals;
1476:
1477: /* ---------------------------------------------------------------------
1487: trx_code_count NUMBER;
1488: aba_bank_account_id NUMBER;
1489: BEGIN
1490: IF l_DEBUG in ('Y', 'C') THEN
1491: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.validate_bank_account');
1492: END IF;
1493: --
1494: -- Bank and bank branch name validations
1495: -- NOTE: We just check for the 'INTERNAL' accounts
1500: INTO aba_bank_account_id
1501: FROM ap_bank_branches abb,
1502: ap_bank_accounts aba
1503: WHERE aba.bank_branch_id = abb.bank_branch_id
1504: AND abb.bank_name = nvl(CE_AUTO_BANK_IMPORT.G_cshi_bank_name, abb.bank_name)
1505: AND abb.bank_branch_name = nvl(CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,abb.bank_branch_name)
1506: AND aba.bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num
1507: AND aba.account_type = 'INTERNAL';
1508: */
1501: FROM ap_bank_branches abb,
1502: ap_bank_accounts aba
1503: WHERE aba.bank_branch_id = abb.bank_branch_id
1504: AND abb.bank_name = nvl(CE_AUTO_BANK_IMPORT.G_cshi_bank_name, abb.bank_name)
1505: AND abb.bank_branch_name = nvl(CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,abb.bank_branch_name)
1506: AND aba.bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num
1507: AND aba.account_type = 'INTERNAL';
1508: */
1509: --
1502: ap_bank_accounts aba
1503: WHERE aba.bank_branch_id = abb.bank_branch_id
1504: AND abb.bank_name = nvl(CE_AUTO_BANK_IMPORT.G_cshi_bank_name, abb.bank_name)
1505: AND abb.bank_branch_name = nvl(CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,abb.bank_branch_name)
1506: AND aba.bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num
1507: AND aba.account_type = 'INTERNAL';
1508: */
1509: --
1510: -- Check for existence of the Transaction codes
1512: --
1513: SELECT count(*)
1514: INTO trx_code_count
1515: FROM ce_transaction_codes
1516: WHERE bank_account_id = CE_AUTO_BANK_IMPORT.G_bank_account_id;
1517: IF (trx_code_count = 0) THEN
1518: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_NO_TRX_CODES');
1519: END IF;
1520: --
1514: INTO trx_code_count
1515: FROM ce_transaction_codes
1516: WHERE bank_account_id = CE_AUTO_BANK_IMPORT.G_bank_account_id;
1517: IF (trx_code_count = 0) THEN
1518: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_NO_TRX_CODES');
1519: END IF;
1520: --
1521: -- Bank account currency code validation
1522: --
1519: END IF;
1520: --
1521: -- Bank account currency code validation
1522: --
1523: IF (aba_bank_currency <> NVL(CE_AUTO_BANK_IMPORT.G_cshi_currency_code,aba_bank_currency)) THEN
1524: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_FOREIGN_CURRENCY');
1525: END IF;
1526: --
1527: -- Check digits validation -- bug 7214921
1520: --
1521: -- Bank account currency code validation
1522: --
1523: IF (aba_bank_currency <> NVL(CE_AUTO_BANK_IMPORT.G_cshi_currency_code,aba_bank_currency)) THEN
1524: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_FOREIGN_CURRENCY');
1525: END IF;
1526: --
1527: -- Check digits validation -- bug 7214921
1528: If CE_AUTO_BANK_IMPORT.G_cshi_check_digits is not null and aba_bank_check_digits is not null Then
1524: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_FOREIGN_CURRENCY');
1525: END IF;
1526: --
1527: -- Check digits validation -- bug 7214921
1528: If CE_AUTO_BANK_IMPORT.G_cshi_check_digits is not null and aba_bank_check_digits is not null Then
1529: IF ( CE_AUTO_BANK_IMPORT.G_cshi_check_digits <> aba_bank_check_digits ) THEN
1530: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CHECK_DIGITS');
1531: END IF;
1532: End If ;
1525: END IF;
1526: --
1527: -- Check digits validation -- bug 7214921
1528: If CE_AUTO_BANK_IMPORT.G_cshi_check_digits is not null and aba_bank_check_digits is not null Then
1529: IF ( CE_AUTO_BANK_IMPORT.G_cshi_check_digits <> aba_bank_check_digits ) THEN
1530: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CHECK_DIGITS');
1531: END IF;
1532: End If ;
1533:
1526: --
1527: -- Check digits validation -- bug 7214921
1528: If CE_AUTO_BANK_IMPORT.G_cshi_check_digits is not null and aba_bank_check_digits is not null Then
1529: IF ( CE_AUTO_BANK_IMPORT.G_cshi_check_digits <> aba_bank_check_digits ) THEN
1530: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CHECK_DIGITS');
1531: END IF;
1532: End If ;
1533:
1534: IF l_DEBUG in ('Y', 'C') THEN
1531: END IF;
1532: End If ;
1533:
1534: IF l_DEBUG in ('Y', 'C') THEN
1535: cep_standard.debug('<
1537: EXCEPTION
1538: WHEN OTHERS THEN
1539: IF (SQL%NOTFOUND) THEN
1536: END IF;
1537: EXCEPTION
1538: WHEN OTHERS THEN
1539: IF (SQL%NOTFOUND) THEN
1540: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_INVALID_BANK');
1541: IF l_DEBUG in ('Y', 'C') THEN
1542: cep_standard.debug('validate_bank_account: ' || 'error: BANK NOT FOUND');
1543: END IF;
1544: ELSIF (SQL%ROWCOUNT > 0) THEN
1541: IF l_DEBUG in ('Y', 'C') THEN
1542: cep_standard.debug('validate_bank_account: ' || 'error: BANK NOT FOUND');
1543: END IF;
1544: ELSIF (SQL%ROWCOUNT > 0) THEN
1545: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_DUP_BANK');
1546: IF l_DEBUG in ('Y', 'C') THEN
1547: cep_standard.debug('validate_bank_account: ' || 'error: DUPLICATE BANK');
1548: END IF;
1549: ELSE
1581: error_found BOOLEAN;
1582: account_type VARCHAR2(25);
1583: BEGIN
1584: IF l_DEBUG in ('Y', 'C') THEN
1585: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.header_validation');
1586: END IF;
1587: error_found := FALSE;
1588: bank_error := FALSE;
1589: duplicate_found := FALSE;
1595: INTO account_type
1596: FROM ce_bank_branches_v abb,
1597: ce_bank_accts_gt_v aba --ce_bank_accounts_v aba
1598: WHERE aba.bank_branch_id = abb.branch_party_id
1599: AND abb.bank_name = nvl(CE_AUTO_BANK_IMPORT.G_cshi_bank_name, abb.bank_name)
1600: AND abb.bank_branch_name = nvl(CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,abb.bank_branch_name)
1601: AND aba.bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num
1602: AND aba.bank_account_id = aba_bank_account_id;
1603: */
1596: FROM ce_bank_branches_v abb,
1597: ce_bank_accts_gt_v aba --ce_bank_accounts_v aba
1598: WHERE aba.bank_branch_id = abb.branch_party_id
1599: AND abb.bank_name = nvl(CE_AUTO_BANK_IMPORT.G_cshi_bank_name, abb.bank_name)
1600: AND abb.bank_branch_name = nvl(CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,abb.bank_branch_name)
1601: AND aba.bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num
1602: AND aba.bank_account_id = aba_bank_account_id;
1603: */
1604: --
1597: ce_bank_accts_gt_v aba --ce_bank_accounts_v aba
1598: WHERE aba.bank_branch_id = abb.branch_party_id
1599: AND abb.bank_name = nvl(CE_AUTO_BANK_IMPORT.G_cshi_bank_name, abb.bank_name)
1600: AND abb.bank_branch_name = nvl(CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,abb.bank_branch_name)
1601: AND aba.bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num
1602: AND aba.bank_account_id = aba_bank_account_id;
1603: */
1604: --
1605: -- 1. Bank account
1612: -- If the bank account is also used for xtr or payroll, do not check GL DATE
1613:
1614: IF (CE_AUTO_BANK_REC.G_intra_day_flag <> 'Y') THEN
1615: --IF (account_type <> 'PAYROLL') THEN
1616: IF (CE_AUTO_BANK_IMPORT.G_xtr_use_allowed_flag = 'N' and
1617: CE_AUTO_BANK_IMPORT.G_pay_use_allowed_flag = 'N') THEN
1618: gl_date_found :=
1619: (CE_AUTO_BANK_REC.find_gl_period(nvl(CE_AUTO_BANK_REC.G_gl_date, G_cshi_statement_date), 222) --Bug 16085695 added nvl clause to g_gl_parameter
1620: OR CE_AUTO_BANK_REC.find_gl_period(nvl(CE_AUTO_BANK_REC.G_gl_date, G_cshi_statement_date), 200)); --Bug 16085695 added nvl clause to g_gl_parameter
1613:
1614: IF (CE_AUTO_BANK_REC.G_intra_day_flag <> 'Y') THEN
1615: --IF (account_type <> 'PAYROLL') THEN
1616: IF (CE_AUTO_BANK_IMPORT.G_xtr_use_allowed_flag = 'N' and
1617: CE_AUTO_BANK_IMPORT.G_pay_use_allowed_flag = 'N') THEN
1618: gl_date_found :=
1619: (CE_AUTO_BANK_REC.find_gl_period(nvl(CE_AUTO_BANK_REC.G_gl_date, G_cshi_statement_date), 222) --Bug 16085695 added nvl clause to g_gl_parameter
1620: OR CE_AUTO_BANK_REC.find_gl_period(nvl(CE_AUTO_BANK_REC.G_gl_date, G_cshi_statement_date), 200)); --Bug 16085695 added nvl clause to g_gl_parameter
1621: IF (NOT gl_date_found) THEN
1618: gl_date_found :=
1619: (CE_AUTO_BANK_REC.find_gl_period(nvl(CE_AUTO_BANK_REC.G_gl_date, G_cshi_statement_date), 222) --Bug 16085695 added nvl clause to g_gl_parameter
1620: OR CE_AUTO_BANK_REC.find_gl_period(nvl(CE_AUTO_BANK_REC.G_gl_date, G_cshi_statement_date), 200)); --Bug 16085695 added nvl clause to g_gl_parameter
1621: IF (NOT gl_date_found) THEN
1622: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_INVALID_PERIOD');
1623: END IF;
1624: END IF;
1625: END IF;
1626: --
1627: -- 3. Already existing in the CE_STATEMENT_HEADERS
1628: --
1629: IF (CE_AUTO_BANK_REC.G_intra_day_flag <> 'Y') THEN
1630: IF (r_statement_number IS NOT NULL) THEN
1631: duplicate_found := CE_AUTO_BANK_IMPORT.header_error('CE_PREV_IMPORT');
1632: END IF;
1633: END IF;
1634:
1635: IF (bank_error) THEN
1641: END IF;
1642: END IF;
1643:
1644: IF l_DEBUG in ('Y', 'C') THEN
1645: cep_standard.debug('<
1647: RETURN error_found;
1648: EXCEPTION
1649: WHEN OTHERS THEN
1647: RETURN error_found;
1648: EXCEPTION
1649: WHEN OTHERS THEN
1650: IF l_DEBUG in ('Y', 'C') THEN
1651: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.header_validation');
1652: END IF;
1653: RAISE;
1654: RETURN FALSE;
1655: END header_validation;
1687: fixed_rate_yn VARCHAR2(30);
1688:
1689: BEGIN
1690: IF l_DEBUG in ('Y', 'C') THEN
1691: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.line_validation');
1692: END IF;
1693: error_found := FALSE;
1694: --
1695: -- 1. Line Amount
1694: --
1695: -- 1. Line Amount
1696: --
1697: IF (csli_amount IS NULL) THEN
1698: error_found := CE_AUTO_BANK_IMPORT.line_error(csli_line_number, 'CE_NO_AMOUNT');
1699: END IF;
1700:
1701: --
1702: -- 2. Trx Code
1704: -- Null csli_trx_code indicates that the statement interface line is missing
1705: -- a transaction code.
1706: --
1707: IF (csli_trx_code IS NULL) THEN
1708: error_found := CE_AUTO_BANK_IMPORT.line_error( csli_line_number, 'CE_MISSING_TRX_NUM');
1709:
1710: --
1711: -- Non-Null csli_trx_code and null r_trx_code_id indicate transaction code is not
1712: -- defined for the bank.
1714: -- bug 4435028 BAT, we cannot do this validation because there are multiple rows with same trx_code
1715:
1716: --7194081 Uncommented.
1717: ELSIF (r_trx_code_id IS NULL) THEN
1718: error_found := CE_AUTO_BANK_IMPORT.line_error( csli_line_number, 'CE_INVALID_TRX_NUM');
1719:
1720: --
1721: -- Check effective date of this transaction code.
1722: -- defined for the bank.
1726:
1727: --8928828 Validation can be done as only one valid trx code has been considered in
1728: --lines_cursor if multiple trx_codes exists
1729: --Lines_cursor is modified to get start_date and end_date
1730: ELSIF ( CE_AUTO_BANK_IMPORT.G_cshi_statement_date NOT BETWEEN
1731: NVL(r_start_date, CE_AUTO_BANK_IMPORT.G_cshi_statement_date) AND
1732: NVL(r_end_date, CE_AUTO_BANK_IMPORT.G_cshi_statement_date)) THEN
1733:
1734: error_found := CE_AUTO_BANK_IMPORT.line_error( csli_line_number, 'CE_INVALID_TRX_NUM_DATE');
1727: --8928828 Validation can be done as only one valid trx code has been considered in
1728: --lines_cursor if multiple trx_codes exists
1729: --Lines_cursor is modified to get start_date and end_date
1730: ELSIF ( CE_AUTO_BANK_IMPORT.G_cshi_statement_date NOT BETWEEN
1731: NVL(r_start_date, CE_AUTO_BANK_IMPORT.G_cshi_statement_date) AND
1732: NVL(r_end_date, CE_AUTO_BANK_IMPORT.G_cshi_statement_date)) THEN
1733:
1734: error_found := CE_AUTO_BANK_IMPORT.line_error( csli_line_number, 'CE_INVALID_TRX_NUM_DATE');
1735:
1728: --lines_cursor if multiple trx_codes exists
1729: --Lines_cursor is modified to get start_date and end_date
1730: ELSIF ( CE_AUTO_BANK_IMPORT.G_cshi_statement_date NOT BETWEEN
1731: NVL(r_start_date, CE_AUTO_BANK_IMPORT.G_cshi_statement_date) AND
1732: NVL(r_end_date, CE_AUTO_BANK_IMPORT.G_cshi_statement_date)) THEN
1733:
1734: error_found := CE_AUTO_BANK_IMPORT.line_error( csli_line_number, 'CE_INVALID_TRX_NUM_DATE');
1735:
1736: END IF;
1730: ELSIF ( CE_AUTO_BANK_IMPORT.G_cshi_statement_date NOT BETWEEN
1731: NVL(r_start_date, CE_AUTO_BANK_IMPORT.G_cshi_statement_date) AND
1732: NVL(r_end_date, CE_AUTO_BANK_IMPORT.G_cshi_statement_date)) THEN
1733:
1734: error_found := CE_AUTO_BANK_IMPORT.line_error( csli_line_number, 'CE_INVALID_TRX_NUM_DATE');
1735:
1736: END IF;
1737:
1738: --
1738: --
1739: -- 3.Exchange rate type
1740: --
1741: IF (csli_user_exchange_rate_type IS NOT NULL AND r_user_conversion_type IS NULL) THEN
1742: error_found := CE_AUTO_BANK_IMPORT.line_error( csli_line_number, 'CE_INVALID_EXCHANGE_TYPE');
1743: END IF;
1744:
1745: --
1746: -- 4. Currency code
1745: --
1746: -- 4. Currency code
1747: --
1748: IF (csli_currency_code IS NOT NULL AND r_currency_code IS NULL) THEN
1749: error_found := CE_AUTO_BANK_IMPORT.line_error( csli_line_number, 'CE_INVALID_CURRENCY');
1750: END IF;
1751:
1752: --
1753: -- 5. EMU Fixed type is only for valid curr and xdate
1772: CE_AUTO_BANK_REC.G_interface_archive_flag
1773: FROM CE_SYSTEM_PARAMETERS_ALL s,
1774: GL_SETS_OF_BOOKS g,
1775: ce_bank_accts_gt_v ba --ce_bank_accounts_v ba
1776: WHERE ba.bank_account_id = CE_AUTO_BANK_IMPORT.G_bank_account_id
1777: and ba.ACCOUNT_OWNER_ORG_ID = s.legal_entity_id
1778: and s.set_of_books_id = g.set_of_books_id;
1779:
1780: END IF;
1801: error_found := line_error(csli_line_number, 'CE_EMU_FIXED_NOT_ALLOWED');
1802: END IF;
1803:
1804: IF l_DEBUG in ('Y', 'C') THEN
1805: cep_standard.debug('<
1807: RETURN error_found;
1808:
1809: EXCEPTION
1808:
1809: EXCEPTION
1810: WHEN OTHERS THEN
1811: IF l_DEBUG in ('Y', 'C') THEN
1812: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.line_validation');
1813: END IF;
1814: RAISE;
1815: RETURN FALSE;
1816: END line_validation;
1871:
1872: --FND_FILE.put_line(FND_FILE.LOG, 'ceabrimb');
1873:
1874: IF l_DEBUG in ('Y', 'C') THEN
1875: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.import_process ');
1876: END IF;
1877:
1878: -- populate ce_security_profiles_tmp table with ce_security_procfiles_v
1879: CEP_STANDARD.init_security;
1880:
1881: OPEN branch_cursor( CE_AUTO_BANK_REC.G_bank_branch_id,
1882: CE_AUTO_BANK_REC.G_bank_account_id );
1883: LOOP
1884: FETCH branch_cursor INTO CE_AUTO_BANK_IMPORT.G_bank_account_id,
1885: CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID,
1886: CE_AUTO_BANK_IMPORT.G_xtr_use_allowed_flag,
1887: CE_AUTO_BANK_IMPORT.G_pay_use_allowed_flag;
1888: aba_bank_account_id := CE_AUTO_BANK_IMPORT.G_bank_account_id;
1881: OPEN branch_cursor( CE_AUTO_BANK_REC.G_bank_branch_id,
1882: CE_AUTO_BANK_REC.G_bank_account_id );
1883: LOOP
1884: FETCH branch_cursor INTO CE_AUTO_BANK_IMPORT.G_bank_account_id,
1885: CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID,
1886: CE_AUTO_BANK_IMPORT.G_xtr_use_allowed_flag,
1887: CE_AUTO_BANK_IMPORT.G_pay_use_allowed_flag;
1888: aba_bank_account_id := CE_AUTO_BANK_IMPORT.G_bank_account_id;
1889:
1882: CE_AUTO_BANK_REC.G_bank_account_id );
1883: LOOP
1884: FETCH branch_cursor INTO CE_AUTO_BANK_IMPORT.G_bank_account_id,
1885: CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID,
1886: CE_AUTO_BANK_IMPORT.G_xtr_use_allowed_flag,
1887: CE_AUTO_BANK_IMPORT.G_pay_use_allowed_flag;
1888: aba_bank_account_id := CE_AUTO_BANK_IMPORT.G_bank_account_id;
1889:
1890: -- 1/20/05 Did not enter organization (le_id and org_id missing)
1883: LOOP
1884: FETCH branch_cursor INTO CE_AUTO_BANK_IMPORT.G_bank_account_id,
1885: CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID,
1886: CE_AUTO_BANK_IMPORT.G_xtr_use_allowed_flag,
1887: CE_AUTO_BANK_IMPORT.G_pay_use_allowed_flag;
1888: aba_bank_account_id := CE_AUTO_BANK_IMPORT.G_bank_account_id;
1889:
1890: -- 1/20/05 Did not enter organization (le_id and org_id missing)
1891: -- BUG 4914608
1884: FETCH branch_cursor INTO CE_AUTO_BANK_IMPORT.G_bank_account_id,
1885: CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID,
1886: CE_AUTO_BANK_IMPORT.G_xtr_use_allowed_flag,
1887: CE_AUTO_BANK_IMPORT.G_pay_use_allowed_flag;
1888: aba_bank_account_id := CE_AUTO_BANK_IMPORT.G_bank_account_id;
1889:
1890: -- 1/20/05 Did not enter organization (le_id and org_id missing)
1891: -- BUG 4914608
1892: /* IF (CE_AUTO_BANK_REC.G_legal_entity_id is null and CE_AUTO_BANK_REC.G_org_id is null) THEN
1895: from ce_BANK_ACCOUNTS
1896: where BANK_ACCOUNT_ID = aba_bank_account_id; */
1897: --IF (CE_AUTO_BANK_REC.G_legal_entity_id is null and CE_AUTO_BANK_REC.G_org_id is null) THEN
1898: IF (CE_AUTO_BANK_REC.G_legal_entity_id is null) and
1899: (CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID is not null) THEN
1900:
1901: CE_SYSTEM_PARAMETERS1_PKG.select_columns(CE_AUTO_BANK_REC.G_rowid,
1902: CE_AUTO_BANK_REC.G_set_of_books_id,
1903: CE_AUTO_BANK_REC.G_cashbook_begin_date,
1915: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
1916: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
1917: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,
1918: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE,
1919: CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID
1920: );
1921: END IF;
1922:
1923: IF l_DEBUG in ('Y', 'C') THEN
1929: OPEN bank_cursor(CE_AUTO_BANK_REC.G_statement_number_from,
1930: CE_AUTO_BANK_REC.G_statement_number_to,
1931: CE_AUTO_BANK_REC.G_statement_date_from,
1932: CE_AUTO_BANK_REC.G_statement_date_to,
1933: CE_AUTO_BANK_IMPORT.G_bank_account_id);
1934: LOOP
1935: FETCH bank_cursor INTO CE_AUTO_BANK_IMPORT.G_cshi_rowid,
1936: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1937: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num,
1931: CE_AUTO_BANK_REC.G_statement_date_from,
1932: CE_AUTO_BANK_REC.G_statement_date_to,
1933: CE_AUTO_BANK_IMPORT.G_bank_account_id);
1934: LOOP
1935: FETCH bank_cursor INTO CE_AUTO_BANK_IMPORT.G_cshi_rowid,
1936: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1937: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num,
1938: CE_AUTO_BANK_IMPORT.G_cshi_check_digits,
1939: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1932: CE_AUTO_BANK_REC.G_statement_date_to,
1933: CE_AUTO_BANK_IMPORT.G_bank_account_id);
1934: LOOP
1935: FETCH bank_cursor INTO CE_AUTO_BANK_IMPORT.G_cshi_rowid,
1936: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1937: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num,
1938: CE_AUTO_BANK_IMPORT.G_cshi_check_digits,
1939: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1940: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1933: CE_AUTO_BANK_IMPORT.G_bank_account_id);
1934: LOOP
1935: FETCH bank_cursor INTO CE_AUTO_BANK_IMPORT.G_cshi_rowid,
1936: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1937: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num,
1938: CE_AUTO_BANK_IMPORT.G_cshi_check_digits,
1939: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1940: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1941: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1934: LOOP
1935: FETCH bank_cursor INTO CE_AUTO_BANK_IMPORT.G_cshi_rowid,
1936: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1937: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num,
1938: CE_AUTO_BANK_IMPORT.G_cshi_check_digits,
1939: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1940: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1941: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1942: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1935: FETCH bank_cursor INTO CE_AUTO_BANK_IMPORT.G_cshi_rowid,
1936: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1937: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num,
1938: CE_AUTO_BANK_IMPORT.G_cshi_check_digits,
1939: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1940: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1941: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1942: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1943: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1936: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1937: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num,
1938: CE_AUTO_BANK_IMPORT.G_cshi_check_digits,
1939: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1940: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1941: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1942: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1943: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1944: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1937: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num,
1938: CE_AUTO_BANK_IMPORT.G_cshi_check_digits,
1939: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1940: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1941: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1942: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1943: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1944: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1945: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1938: CE_AUTO_BANK_IMPORT.G_cshi_check_digits,
1939: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1940: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1941: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1942: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1943: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1944: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1945: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1946: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1939: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1940: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1941: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1942: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1943: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1944: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1945: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1946: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1947: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1940: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1941: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1942: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1943: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1944: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1945: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1946: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1947: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1948: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1941: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1942: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1943: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1944: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1945: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1946: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1947: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1948: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1949: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag,
1942: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1943: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1944: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1945: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1946: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1947: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1948: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1949: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag,
1950: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag,
1943: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1944: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1945: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1946: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1947: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1948: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1949: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag,
1950: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag,
1951: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1944: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1945: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1946: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1947: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1948: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1949: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag,
1950: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag,
1951: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1952: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,
1945: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1946: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1947: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1948: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1949: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag,
1950: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag,
1951: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1952: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,
1953: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,
1946: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1947: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1948: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1949: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag,
1950: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag,
1951: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1952: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,
1953: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,
1954: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,
1947: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1948: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1949: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag,
1950: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag,
1951: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1952: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,
1953: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,
1954: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,
1955: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count,
1948: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1949: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag,
1950: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag,
1951: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1952: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,
1953: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,
1954: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,
1955: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count,
1956: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category,
1949: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag,
1950: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag,
1951: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1952: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,
1953: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,
1954: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,
1955: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count,
1956: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category,
1957: CE_AUTO_BANK_IMPORT.G_cshi_attribute1,
1950: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag,
1951: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1952: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,
1953: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,
1954: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,
1955: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count,
1956: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category,
1957: CE_AUTO_BANK_IMPORT.G_cshi_attribute1,
1958: CE_AUTO_BANK_IMPORT.G_cshi_attribute2,
1951: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1952: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,
1953: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,
1954: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,
1955: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count,
1956: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category,
1957: CE_AUTO_BANK_IMPORT.G_cshi_attribute1,
1958: CE_AUTO_BANK_IMPORT.G_cshi_attribute2,
1959: CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1952: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,
1953: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,
1954: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,
1955: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count,
1956: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category,
1957: CE_AUTO_BANK_IMPORT.G_cshi_attribute1,
1958: CE_AUTO_BANK_IMPORT.G_cshi_attribute2,
1959: CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1960: CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1953: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,
1954: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,
1955: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count,
1956: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category,
1957: CE_AUTO_BANK_IMPORT.G_cshi_attribute1,
1958: CE_AUTO_BANK_IMPORT.G_cshi_attribute2,
1959: CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1960: CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1961: CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1954: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,
1955: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count,
1956: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category,
1957: CE_AUTO_BANK_IMPORT.G_cshi_attribute1,
1958: CE_AUTO_BANK_IMPORT.G_cshi_attribute2,
1959: CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1960: CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1961: CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1962: CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1955: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count,
1956: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category,
1957: CE_AUTO_BANK_IMPORT.G_cshi_attribute1,
1958: CE_AUTO_BANK_IMPORT.G_cshi_attribute2,
1959: CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1960: CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1961: CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1962: CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1963: CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1956: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category,
1957: CE_AUTO_BANK_IMPORT.G_cshi_attribute1,
1958: CE_AUTO_BANK_IMPORT.G_cshi_attribute2,
1959: CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1960: CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1961: CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1962: CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1963: CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1964: CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1957: CE_AUTO_BANK_IMPORT.G_cshi_attribute1,
1958: CE_AUTO_BANK_IMPORT.G_cshi_attribute2,
1959: CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1960: CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1961: CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1962: CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1963: CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1964: CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1965: CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1958: CE_AUTO_BANK_IMPORT.G_cshi_attribute2,
1959: CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1960: CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1961: CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1962: CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1963: CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1964: CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1965: CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1966: CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1959: CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1960: CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1961: CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1962: CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1963: CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1964: CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1965: CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1966: CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1967: CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1960: CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1961: CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1962: CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1963: CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1964: CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1965: CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1966: CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1967: CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1968: CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1961: CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1962: CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1963: CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1964: CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1965: CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1966: CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1967: CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1968: CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1969: CE_AUTO_BANK_IMPORT.G_cshi_attribute13,
1962: CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1963: CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1964: CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1965: CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1966: CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1967: CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1968: CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1969: CE_AUTO_BANK_IMPORT.G_cshi_attribute13,
1970: CE_AUTO_BANK_IMPORT.G_cshi_attribute14,
1963: CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1964: CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1965: CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1966: CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1967: CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1968: CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1969: CE_AUTO_BANK_IMPORT.G_cshi_attribute13,
1970: CE_AUTO_BANK_IMPORT.G_cshi_attribute14,
1971: CE_AUTO_BANK_IMPORT.G_cshi_attribute15,
1964: CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1965: CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1966: CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1967: CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1968: CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1969: CE_AUTO_BANK_IMPORT.G_cshi_attribute13,
1970: CE_AUTO_BANK_IMPORT.G_cshi_attribute14,
1971: CE_AUTO_BANK_IMPORT.G_cshi_attribute15,
1972: CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
1965: CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1966: CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1967: CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1968: CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1969: CE_AUTO_BANK_IMPORT.G_cshi_attribute13,
1970: CE_AUTO_BANK_IMPORT.G_cshi_attribute14,
1971: CE_AUTO_BANK_IMPORT.G_cshi_attribute15,
1972: CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
1973: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,
1966: CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1967: CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1968: CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1969: CE_AUTO_BANK_IMPORT.G_cshi_attribute13,
1970: CE_AUTO_BANK_IMPORT.G_cshi_attribute14,
1971: CE_AUTO_BANK_IMPORT.G_cshi_attribute15,
1972: CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
1973: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,
1974: CE_AUTO_BANK_IMPORT.G_cshi_bank_name,
1967: CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1968: CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1969: CE_AUTO_BANK_IMPORT.G_cshi_attribute13,
1970: CE_AUTO_BANK_IMPORT.G_cshi_attribute14,
1971: CE_AUTO_BANK_IMPORT.G_cshi_attribute15,
1972: CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
1973: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,
1974: CE_AUTO_BANK_IMPORT.G_cshi_bank_name,
1975: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,
1968: CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1969: CE_AUTO_BANK_IMPORT.G_cshi_attribute13,
1970: CE_AUTO_BANK_IMPORT.G_cshi_attribute14,
1971: CE_AUTO_BANK_IMPORT.G_cshi_attribute15,
1972: CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
1973: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,
1974: CE_AUTO_BANK_IMPORT.G_cshi_bank_name,
1975: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,
1976: CE_AUTO_BANK_IMPORT.G_cshi_currency_code,
1969: CE_AUTO_BANK_IMPORT.G_cshi_attribute13,
1970: CE_AUTO_BANK_IMPORT.G_cshi_attribute14,
1971: CE_AUTO_BANK_IMPORT.G_cshi_attribute15,
1972: CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
1973: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,
1974: CE_AUTO_BANK_IMPORT.G_cshi_bank_name,
1975: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,
1976: CE_AUTO_BANK_IMPORT.G_cshi_currency_code,
1977: --CE_AUTO_BANK_IMPORT.G_cshi_org_id,
1970: CE_AUTO_BANK_IMPORT.G_cshi_attribute14,
1971: CE_AUTO_BANK_IMPORT.G_cshi_attribute15,
1972: CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
1973: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,
1974: CE_AUTO_BANK_IMPORT.G_cshi_bank_name,
1975: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,
1976: CE_AUTO_BANK_IMPORT.G_cshi_currency_code,
1977: --CE_AUTO_BANK_IMPORT.G_cshi_org_id,
1978: r_statement_number,
1971: CE_AUTO_BANK_IMPORT.G_cshi_attribute15,
1972: CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
1973: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,
1974: CE_AUTO_BANK_IMPORT.G_cshi_bank_name,
1975: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,
1976: CE_AUTO_BANK_IMPORT.G_cshi_currency_code,
1977: --CE_AUTO_BANK_IMPORT.G_cshi_org_id,
1978: r_statement_number,
1979: aba_bank_account_name,
1972: CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
1973: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,
1974: CE_AUTO_BANK_IMPORT.G_cshi_bank_name,
1975: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,
1976: CE_AUTO_BANK_IMPORT.G_cshi_currency_code,
1977: --CE_AUTO_BANK_IMPORT.G_cshi_org_id,
1978: r_statement_number,
1979: aba_bank_account_name,
1980: aba_bank_currency,
1973: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,
1974: CE_AUTO_BANK_IMPORT.G_cshi_bank_name,
1975: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,
1976: CE_AUTO_BANK_IMPORT.G_cshi_currency_code,
1977: --CE_AUTO_BANK_IMPORT.G_cshi_org_id,
1978: r_statement_number,
1979: aba_bank_account_name,
1980: aba_bank_currency,
1981: aba_bank_check_digits;
1979: aba_bank_account_name,
1980: aba_bank_currency,
1981: aba_bank_check_digits;
1982: IF l_DEBUG in ('Y', 'C') THEN
1983: cep_standard.debug('CE_AUTO_BANK_IMPORT.G_cshi_statement_number ='||CE_AUTO_BANK_IMPORT.G_cshi_statement_number);
1984: END IF;
1985:
1986:
1987: EXIT WHEN bank_cursor%NOTFOUND OR bank_cursor%NOTFOUND IS NULL;
1993: header_error_found := FALSE;
1994: lock_error_found := FALSE;
1995: control_error_found := FALSE;
1996: CE_HEADER_INTERFACE_ERRORS_PKG.delete_row(
1997: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1998: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num );
1999: CE_LINE_INTERFACE_ERRORS_PKG.delete_row(
2000: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
2001: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num, NULL);
1994: lock_error_found := FALSE;
1995: control_error_found := FALSE;
1996: CE_HEADER_INTERFACE_ERRORS_PKG.delete_row(
1997: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1998: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num );
1999: CE_LINE_INTERFACE_ERRORS_PKG.delete_row(
2000: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
2001: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num, NULL);
2002: IF (lock_statement) THEN
1996: CE_HEADER_INTERFACE_ERRORS_PKG.delete_row(
1997: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1998: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num );
1999: CE_LINE_INTERFACE_ERRORS_PKG.delete_row(
2000: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
2001: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num, NULL);
2002: IF (lock_statement) THEN
2003: IF l_DEBUG in ('Y', 'C') THEN
2004: cep_standard.debug('aba_bank_account_id =' ||aba_bank_account_id);
1997: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1998: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num );
1999: CE_LINE_INTERFACE_ERRORS_PKG.delete_row(
2000: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
2001: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num, NULL);
2002: IF (lock_statement) THEN
2003: IF l_DEBUG in ('Y', 'C') THEN
2004: cep_standard.debug('aba_bank_account_id =' ||aba_bank_account_id);
2005: END IF;
2007: header_error_found := header_validation(r_statement_number,
2008: aba_bank_currency,
2009: aba_bank_check_digits,
2010: aba_bank_account_id);
2011: CE_AUTO_BANK_IMPORT.G_dr_sum := 0;
2012: CE_AUTO_BANK_IMPORT.G_cr_sum := 0;
2013: CE_AUTO_BANK_IMPORT.G_dr_count := 0;
2014: CE_AUTO_BANK_IMPORT.G_cr_count := 0;
2015: CE_AUTO_BANK_IMPORT.G_total_count := 0;
2008: aba_bank_currency,
2009: aba_bank_check_digits,
2010: aba_bank_account_id);
2011: CE_AUTO_BANK_IMPORT.G_dr_sum := 0;
2012: CE_AUTO_BANK_IMPORT.G_cr_sum := 0;
2013: CE_AUTO_BANK_IMPORT.G_dr_count := 0;
2014: CE_AUTO_BANK_IMPORT.G_cr_count := 0;
2015: CE_AUTO_BANK_IMPORT.G_total_count := 0;
2016: OPEN lines_cursor(CE_AUTO_BANK_IMPORT.G_cshi_statement_number, CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num);
2009: aba_bank_check_digits,
2010: aba_bank_account_id);
2011: CE_AUTO_BANK_IMPORT.G_dr_sum := 0;
2012: CE_AUTO_BANK_IMPORT.G_cr_sum := 0;
2013: CE_AUTO_BANK_IMPORT.G_dr_count := 0;
2014: CE_AUTO_BANK_IMPORT.G_cr_count := 0;
2015: CE_AUTO_BANK_IMPORT.G_total_count := 0;
2016: OPEN lines_cursor(CE_AUTO_BANK_IMPORT.G_cshi_statement_number, CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num);
2017: LOOP
2010: aba_bank_account_id);
2011: CE_AUTO_BANK_IMPORT.G_dr_sum := 0;
2012: CE_AUTO_BANK_IMPORT.G_cr_sum := 0;
2013: CE_AUTO_BANK_IMPORT.G_dr_count := 0;
2014: CE_AUTO_BANK_IMPORT.G_cr_count := 0;
2015: CE_AUTO_BANK_IMPORT.G_total_count := 0;
2016: OPEN lines_cursor(CE_AUTO_BANK_IMPORT.G_cshi_statement_number, CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num);
2017: LOOP
2018: FETCH lines_cursor INTO csli_rowid,
2011: CE_AUTO_BANK_IMPORT.G_dr_sum := 0;
2012: CE_AUTO_BANK_IMPORT.G_cr_sum := 0;
2013: CE_AUTO_BANK_IMPORT.G_dr_count := 0;
2014: CE_AUTO_BANK_IMPORT.G_cr_count := 0;
2015: CE_AUTO_BANK_IMPORT.G_total_count := 0;
2016: OPEN lines_cursor(CE_AUTO_BANK_IMPORT.G_cshi_statement_number, CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num);
2017: LOOP
2018: FETCH lines_cursor INTO csli_rowid,
2019: csli_line_number,
2012: CE_AUTO_BANK_IMPORT.G_cr_sum := 0;
2013: CE_AUTO_BANK_IMPORT.G_dr_count := 0;
2014: CE_AUTO_BANK_IMPORT.G_cr_count := 0;
2015: CE_AUTO_BANK_IMPORT.G_total_count := 0;
2016: OPEN lines_cursor(CE_AUTO_BANK_IMPORT.G_cshi_statement_number, CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num);
2017: LOOP
2018: FETCH lines_cursor INTO csli_rowid,
2019: csli_line_number,
2020: csli_amount,
2027: csli_dr_count,
2028: csli_cr_sum,
2029: csli_cr_count,
2030: r_trx_code_id,
2031: CE_AUTO_BANK_IMPORT.G_trx_recon_seq_id , -- Bug 8965556
2032: r_start_date,
2033: r_end_date,
2034: r_exchange_rate_type,
2035: r_user_conversion_type,
2034: r_exchange_rate_type,
2035: r_user_conversion_type,
2036: r_currency_code;
2037: EXIT WHEN lines_cursor%NOTFOUND OR lines_cursor%NOTFOUND IS NULL;
2038: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.fetch line: ' || csli_line_number);
2039: CE_AUTO_BANK_IMPORT.G_dr_sum := CE_AUTO_BANK_IMPORT.G_dr_sum + csli_dr_sum;
2040: CE_AUTO_BANK_IMPORT.G_cr_sum := CE_AUTO_BANK_IMPORT.G_cr_sum + csli_cr_sum;
2041: CE_AUTO_BANK_IMPORT.G_dr_count := CE_AUTO_BANK_IMPORT.G_dr_count + csli_dr_count;
2042: CE_AUTO_BANK_IMPORT.G_cr_count := CE_AUTO_BANK_IMPORT.G_cr_count + csli_cr_count;
2035: r_user_conversion_type,
2036: r_currency_code;
2037: EXIT WHEN lines_cursor%NOTFOUND OR lines_cursor%NOTFOUND IS NULL;
2038: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.fetch line: ' || csli_line_number);
2039: CE_AUTO_BANK_IMPORT.G_dr_sum := CE_AUTO_BANK_IMPORT.G_dr_sum + csli_dr_sum;
2040: CE_AUTO_BANK_IMPORT.G_cr_sum := CE_AUTO_BANK_IMPORT.G_cr_sum + csli_cr_sum;
2041: CE_AUTO_BANK_IMPORT.G_dr_count := CE_AUTO_BANK_IMPORT.G_dr_count + csli_dr_count;
2042: CE_AUTO_BANK_IMPORT.G_cr_count := CE_AUTO_BANK_IMPORT.G_cr_count + csli_cr_count;
2043: CE_AUTO_BANK_IMPORT.G_total_count := CE_AUTO_BANK_IMPORT.G_total_count + 1;
2036: r_currency_code;
2037: EXIT WHEN lines_cursor%NOTFOUND OR lines_cursor%NOTFOUND IS NULL;
2038: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.fetch line: ' || csli_line_number);
2039: CE_AUTO_BANK_IMPORT.G_dr_sum := CE_AUTO_BANK_IMPORT.G_dr_sum + csli_dr_sum;
2040: CE_AUTO_BANK_IMPORT.G_cr_sum := CE_AUTO_BANK_IMPORT.G_cr_sum + csli_cr_sum;
2041: CE_AUTO_BANK_IMPORT.G_dr_count := CE_AUTO_BANK_IMPORT.G_dr_count + csli_dr_count;
2042: CE_AUTO_BANK_IMPORT.G_cr_count := CE_AUTO_BANK_IMPORT.G_cr_count + csli_cr_count;
2043: CE_AUTO_BANK_IMPORT.G_total_count := CE_AUTO_BANK_IMPORT.G_total_count + 1;
2044: IF (lock_statement_line(csli_rowid)) THEN
2037: EXIT WHEN lines_cursor%NOTFOUND OR lines_cursor%NOTFOUND IS NULL;
2038: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.fetch line: ' || csli_line_number);
2039: CE_AUTO_BANK_IMPORT.G_dr_sum := CE_AUTO_BANK_IMPORT.G_dr_sum + csli_dr_sum;
2040: CE_AUTO_BANK_IMPORT.G_cr_sum := CE_AUTO_BANK_IMPORT.G_cr_sum + csli_cr_sum;
2041: CE_AUTO_BANK_IMPORT.G_dr_count := CE_AUTO_BANK_IMPORT.G_dr_count + csli_dr_count;
2042: CE_AUTO_BANK_IMPORT.G_cr_count := CE_AUTO_BANK_IMPORT.G_cr_count + csli_cr_count;
2043: CE_AUTO_BANK_IMPORT.G_total_count := CE_AUTO_BANK_IMPORT.G_total_count + 1;
2044: IF (lock_statement_line(csli_rowid)) THEN
2045: l_error_found := line_validation( csli_amount,
2038: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.fetch line: ' || csli_line_number);
2039: CE_AUTO_BANK_IMPORT.G_dr_sum := CE_AUTO_BANK_IMPORT.G_dr_sum + csli_dr_sum;
2040: CE_AUTO_BANK_IMPORT.G_cr_sum := CE_AUTO_BANK_IMPORT.G_cr_sum + csli_cr_sum;
2041: CE_AUTO_BANK_IMPORT.G_dr_count := CE_AUTO_BANK_IMPORT.G_dr_count + csli_dr_count;
2042: CE_AUTO_BANK_IMPORT.G_cr_count := CE_AUTO_BANK_IMPORT.G_cr_count + csli_cr_count;
2043: CE_AUTO_BANK_IMPORT.G_total_count := CE_AUTO_BANK_IMPORT.G_total_count + 1;
2044: IF (lock_statement_line(csli_rowid)) THEN
2045: l_error_found := line_validation( csli_amount,
2046: csli_user_exchange_rate_type,
2039: CE_AUTO_BANK_IMPORT.G_dr_sum := CE_AUTO_BANK_IMPORT.G_dr_sum + csli_dr_sum;
2040: CE_AUTO_BANK_IMPORT.G_cr_sum := CE_AUTO_BANK_IMPORT.G_cr_sum + csli_cr_sum;
2041: CE_AUTO_BANK_IMPORT.G_dr_count := CE_AUTO_BANK_IMPORT.G_dr_count + csli_dr_count;
2042: CE_AUTO_BANK_IMPORT.G_cr_count := CE_AUTO_BANK_IMPORT.G_cr_count + csli_cr_count;
2043: CE_AUTO_BANK_IMPORT.G_total_count := CE_AUTO_BANK_IMPORT.G_total_count + 1;
2044: IF (lock_statement_line(csli_rowid)) THEN
2045: l_error_found := line_validation( csli_amount,
2046: csli_user_exchange_rate_type,
2047: csli_currency_code,
2059: IF (l_error_found) THEN
2060: line_error_found := TRUE;
2061: END IF;
2062: ELSE
2063: line_error_found := CE_AUTO_BANK_IMPORT.line_error(csli_line_number, 'CE_STATEMENT_LINT_LOCK');
2064: END IF;
2065: END LOOP; -- lines_cursor
2066: close lines_cursor;
2067: control_error_found := validate_control_totals;
2065: END LOOP; -- lines_cursor
2066: close lines_cursor;
2067: control_error_found := validate_control_totals;
2068: ELSE -- Statement header is locked
2069: lock_error_found := CE_AUTO_BANK_IMPORT.header_error('CE_STATEMENT_HINT_LOCK');
2070: END IF; -- Statement header lock
2071: IF (header_error_found OR line_error_found OR lock_error_found) THEN
2072: IF (lock_error_found) THEN
2073: NULL;
2082:
2083: xtr_shared_account(x_account_result);
2084:
2085: IF ((x_account_result = 'XTR1_SHARED' AND nvl(G_cshi_intra_day_flag,'N') <> 'Y') or
2086: (CE_AUTO_BANK_IMPORT.G_xtr_use_allowed_flag = 'Y' AND nvl(G_cshi_intra_day_flag,'N') <> 'Y')) THEN
2087: IF (transfer_bank_balances) THEN
2088: IF (transfer_header(aba_bank_account_id,aba_bank_account_name)) THEN
2089: transfer_lines;
2090: -- Bug 9278367
2103: XTR_REPLICATE_BANK_BALANCES.VALIDATE_OD_LIMIT_BALANCE(
2104: p_xtr_company_code,
2105: p_branch_id,
2106: aba_bank_account_id,
2107: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
2108: x_return_status,
2109: x_msg_count,
2110: x_msg_data );
2111: cep_standard.debug('>> After VALIDATE_OD_LIMIT_BALANCE import_process '||x_msg_data);
2112: if(x_return_status <>'S') then
2113: cep_standard.debug('>> Inside the validate information block <> s ');
2114: FND_FILE.put_line(FND_FILE.LOG, x_msg_data);
2115: set_warning :=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Check log file for warning messages');
2116: bu_error_found :=CE_AUTO_BANK_IMPORT.header_error('CE_OD_LIMIT_FAIL_INFO');
2117: end if;
2118: IF (CE_AUTO_BANK_REC.G_interface_archive_flag = 'Y') THEN
2119: archive_header;
2120: archive_lines;
2124: END IF;
2125: END IF;
2126: END IF;
2127: --ELSIF (x_account_result = 'XTR1_AP' OR nvl(G_cshi_intra_day_flag,'N') = 'Y') THEN
2128: ELSIF (CE_AUTO_BANK_IMPORT.G_xtr_use_allowed_flag = 'N' OR nvl(G_cshi_intra_day_flag,'N') = 'Y') THEN
2129: IF (transfer_header(aba_bank_account_id,aba_bank_account_name)) THEN
2130: transfer_lines;
2131: IF (CE_AUTO_BANK_REC.G_interface_archive_flag = 'Y') THEN
2132: archive_header;
2140:
2141: END IF; -- error_found
2142:
2143: -- bug 2732755
2144: CE_AUTO_BANK_IMPORT.G_cshi_rowid := null;
2145: CE_AUTO_BANK_IMPORT.G_cshi_statement_number := null;
2146: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num := null;
2147: CE_AUTO_BANK_IMPORT.G_cshi_check_digits := null;
2148: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance := null;
2141: END IF; -- error_found
2142:
2143: -- bug 2732755
2144: CE_AUTO_BANK_IMPORT.G_cshi_rowid := null;
2145: CE_AUTO_BANK_IMPORT.G_cshi_statement_number := null;
2146: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num := null;
2147: CE_AUTO_BANK_IMPORT.G_cshi_check_digits := null;
2148: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance := null;
2149: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance := null;
2142:
2143: -- bug 2732755
2144: CE_AUTO_BANK_IMPORT.G_cshi_rowid := null;
2145: CE_AUTO_BANK_IMPORT.G_cshi_statement_number := null;
2146: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num := null;
2147: CE_AUTO_BANK_IMPORT.G_cshi_check_digits := null;
2148: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance := null;
2149: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance := null;
2150: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance := null;
2143: -- bug 2732755
2144: CE_AUTO_BANK_IMPORT.G_cshi_rowid := null;
2145: CE_AUTO_BANK_IMPORT.G_cshi_statement_number := null;
2146: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num := null;
2147: CE_AUTO_BANK_IMPORT.G_cshi_check_digits := null;
2148: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance := null;
2149: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance := null;
2150: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance := null;
2151: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance := null;
2144: CE_AUTO_BANK_IMPORT.G_cshi_rowid := null;
2145: CE_AUTO_BANK_IMPORT.G_cshi_statement_number := null;
2146: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num := null;
2147: CE_AUTO_BANK_IMPORT.G_cshi_check_digits := null;
2148: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance := null;
2149: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance := null;
2150: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance := null;
2151: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance := null;
2152: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd := null;
2145: CE_AUTO_BANK_IMPORT.G_cshi_statement_number := null;
2146: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num := null;
2147: CE_AUTO_BANK_IMPORT.G_cshi_check_digits := null;
2148: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance := null;
2149: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance := null;
2150: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance := null;
2151: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance := null;
2152: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd := null;
2153: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd := null;
2146: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num := null;
2147: CE_AUTO_BANK_IMPORT.G_cshi_check_digits := null;
2148: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance := null;
2149: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance := null;
2150: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance := null;
2151: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance := null;
2152: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd := null;
2153: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd := null;
2154: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd := null;
2147: CE_AUTO_BANK_IMPORT.G_cshi_check_digits := null;
2148: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance := null;
2149: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance := null;
2150: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance := null;
2151: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance := null;
2152: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd := null;
2153: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd := null;
2154: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd := null;
2155: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd := null;
2148: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance := null;
2149: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance := null;
2150: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance := null;
2151: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance := null;
2152: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd := null;
2153: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd := null;
2154: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd := null;
2155: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd := null;
2156: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float := null;
2149: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance := null;
2150: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance := null;
2151: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance := null;
2152: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd := null;
2153: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd := null;
2154: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd := null;
2155: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd := null;
2156: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float := null;
2157: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float := null;
2150: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance := null;
2151: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance := null;
2152: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd := null;
2153: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd := null;
2154: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd := null;
2155: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd := null;
2156: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float := null;
2157: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float := null;
2158: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag := null;
2151: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance := null;
2152: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd := null;
2153: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd := null;
2154: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd := null;
2155: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd := null;
2156: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float := null;
2157: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float := null;
2158: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag := null;
2159: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag := null;
2152: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd := null;
2153: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd := null;
2154: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd := null;
2155: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd := null;
2156: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float := null;
2157: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float := null;
2158: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag := null;
2159: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag := null;
2160: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr := null;
2153: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd := null;
2154: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd := null;
2155: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd := null;
2156: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float := null;
2157: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float := null;
2158: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag := null;
2159: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag := null;
2160: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr := null;
2161: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr := null;
2154: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd := null;
2155: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd := null;
2156: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float := null;
2157: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float := null;
2158: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag := null;
2159: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag := null;
2160: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr := null;
2161: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr := null;
2162: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count := null;
2155: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd := null;
2156: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float := null;
2157: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float := null;
2158: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag := null;
2159: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag := null;
2160: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr := null;
2161: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr := null;
2162: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count := null;
2163: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count := null;
2156: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float := null;
2157: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float := null;
2158: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag := null;
2159: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag := null;
2160: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr := null;
2161: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr := null;
2162: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count := null;
2163: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count := null;
2164: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count := null;
2157: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float := null;
2158: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag := null;
2159: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag := null;
2160: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr := null;
2161: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr := null;
2162: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count := null;
2163: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count := null;
2164: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count := null;
2165: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category := null;
2158: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag := null;
2159: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag := null;
2160: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr := null;
2161: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr := null;
2162: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count := null;
2163: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count := null;
2164: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count := null;
2165: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category := null;
2166: CE_AUTO_BANK_IMPORT.G_cshi_attribute1 := null;
2159: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag := null;
2160: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr := null;
2161: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr := null;
2162: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count := null;
2163: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count := null;
2164: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count := null;
2165: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category := null;
2166: CE_AUTO_BANK_IMPORT.G_cshi_attribute1 := null;
2167: CE_AUTO_BANK_IMPORT.G_cshi_attribute2 := null;
2160: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr := null;
2161: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr := null;
2162: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count := null;
2163: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count := null;
2164: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count := null;
2165: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category := null;
2166: CE_AUTO_BANK_IMPORT.G_cshi_attribute1 := null;
2167: CE_AUTO_BANK_IMPORT.G_cshi_attribute2 := null;
2168: CE_AUTO_BANK_IMPORT.G_cshi_attribute3 := null;
2161: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr := null;
2162: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count := null;
2163: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count := null;
2164: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count := null;
2165: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category := null;
2166: CE_AUTO_BANK_IMPORT.G_cshi_attribute1 := null;
2167: CE_AUTO_BANK_IMPORT.G_cshi_attribute2 := null;
2168: CE_AUTO_BANK_IMPORT.G_cshi_attribute3 := null;
2169: CE_AUTO_BANK_IMPORT.G_cshi_attribute4 := null;
2162: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count := null;
2163: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count := null;
2164: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count := null;
2165: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category := null;
2166: CE_AUTO_BANK_IMPORT.G_cshi_attribute1 := null;
2167: CE_AUTO_BANK_IMPORT.G_cshi_attribute2 := null;
2168: CE_AUTO_BANK_IMPORT.G_cshi_attribute3 := null;
2169: CE_AUTO_BANK_IMPORT.G_cshi_attribute4 := null;
2170: CE_AUTO_BANK_IMPORT.G_cshi_attribute5 := null;
2163: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count := null;
2164: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count := null;
2165: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category := null;
2166: CE_AUTO_BANK_IMPORT.G_cshi_attribute1 := null;
2167: CE_AUTO_BANK_IMPORT.G_cshi_attribute2 := null;
2168: CE_AUTO_BANK_IMPORT.G_cshi_attribute3 := null;
2169: CE_AUTO_BANK_IMPORT.G_cshi_attribute4 := null;
2170: CE_AUTO_BANK_IMPORT.G_cshi_attribute5 := null;
2171: CE_AUTO_BANK_IMPORT.G_cshi_attribute6 := null;
2164: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count := null;
2165: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category := null;
2166: CE_AUTO_BANK_IMPORT.G_cshi_attribute1 := null;
2167: CE_AUTO_BANK_IMPORT.G_cshi_attribute2 := null;
2168: CE_AUTO_BANK_IMPORT.G_cshi_attribute3 := null;
2169: CE_AUTO_BANK_IMPORT.G_cshi_attribute4 := null;
2170: CE_AUTO_BANK_IMPORT.G_cshi_attribute5 := null;
2171: CE_AUTO_BANK_IMPORT.G_cshi_attribute6 := null;
2172: CE_AUTO_BANK_IMPORT.G_cshi_attribute7 := null;
2165: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category := null;
2166: CE_AUTO_BANK_IMPORT.G_cshi_attribute1 := null;
2167: CE_AUTO_BANK_IMPORT.G_cshi_attribute2 := null;
2168: CE_AUTO_BANK_IMPORT.G_cshi_attribute3 := null;
2169: CE_AUTO_BANK_IMPORT.G_cshi_attribute4 := null;
2170: CE_AUTO_BANK_IMPORT.G_cshi_attribute5 := null;
2171: CE_AUTO_BANK_IMPORT.G_cshi_attribute6 := null;
2172: CE_AUTO_BANK_IMPORT.G_cshi_attribute7 := null;
2173: CE_AUTO_BANK_IMPORT.G_cshi_attribute8 := null;
2166: CE_AUTO_BANK_IMPORT.G_cshi_attribute1 := null;
2167: CE_AUTO_BANK_IMPORT.G_cshi_attribute2 := null;
2168: CE_AUTO_BANK_IMPORT.G_cshi_attribute3 := null;
2169: CE_AUTO_BANK_IMPORT.G_cshi_attribute4 := null;
2170: CE_AUTO_BANK_IMPORT.G_cshi_attribute5 := null;
2171: CE_AUTO_BANK_IMPORT.G_cshi_attribute6 := null;
2172: CE_AUTO_BANK_IMPORT.G_cshi_attribute7 := null;
2173: CE_AUTO_BANK_IMPORT.G_cshi_attribute8 := null;
2174: CE_AUTO_BANK_IMPORT.G_cshi_attribute9 := null;
2167: CE_AUTO_BANK_IMPORT.G_cshi_attribute2 := null;
2168: CE_AUTO_BANK_IMPORT.G_cshi_attribute3 := null;
2169: CE_AUTO_BANK_IMPORT.G_cshi_attribute4 := null;
2170: CE_AUTO_BANK_IMPORT.G_cshi_attribute5 := null;
2171: CE_AUTO_BANK_IMPORT.G_cshi_attribute6 := null;
2172: CE_AUTO_BANK_IMPORT.G_cshi_attribute7 := null;
2173: CE_AUTO_BANK_IMPORT.G_cshi_attribute8 := null;
2174: CE_AUTO_BANK_IMPORT.G_cshi_attribute9 := null;
2175: CE_AUTO_BANK_IMPORT.G_cshi_attribute10 := null;
2168: CE_AUTO_BANK_IMPORT.G_cshi_attribute3 := null;
2169: CE_AUTO_BANK_IMPORT.G_cshi_attribute4 := null;
2170: CE_AUTO_BANK_IMPORT.G_cshi_attribute5 := null;
2171: CE_AUTO_BANK_IMPORT.G_cshi_attribute6 := null;
2172: CE_AUTO_BANK_IMPORT.G_cshi_attribute7 := null;
2173: CE_AUTO_BANK_IMPORT.G_cshi_attribute8 := null;
2174: CE_AUTO_BANK_IMPORT.G_cshi_attribute9 := null;
2175: CE_AUTO_BANK_IMPORT.G_cshi_attribute10 := null;
2176: CE_AUTO_BANK_IMPORT.G_cshi_attribute11 := null;
2169: CE_AUTO_BANK_IMPORT.G_cshi_attribute4 := null;
2170: CE_AUTO_BANK_IMPORT.G_cshi_attribute5 := null;
2171: CE_AUTO_BANK_IMPORT.G_cshi_attribute6 := null;
2172: CE_AUTO_BANK_IMPORT.G_cshi_attribute7 := null;
2173: CE_AUTO_BANK_IMPORT.G_cshi_attribute8 := null;
2174: CE_AUTO_BANK_IMPORT.G_cshi_attribute9 := null;
2175: CE_AUTO_BANK_IMPORT.G_cshi_attribute10 := null;
2176: CE_AUTO_BANK_IMPORT.G_cshi_attribute11 := null;
2177: CE_AUTO_BANK_IMPORT.G_cshi_attribute12 := null;
2170: CE_AUTO_BANK_IMPORT.G_cshi_attribute5 := null;
2171: CE_AUTO_BANK_IMPORT.G_cshi_attribute6 := null;
2172: CE_AUTO_BANK_IMPORT.G_cshi_attribute7 := null;
2173: CE_AUTO_BANK_IMPORT.G_cshi_attribute8 := null;
2174: CE_AUTO_BANK_IMPORT.G_cshi_attribute9 := null;
2175: CE_AUTO_BANK_IMPORT.G_cshi_attribute10 := null;
2176: CE_AUTO_BANK_IMPORT.G_cshi_attribute11 := null;
2177: CE_AUTO_BANK_IMPORT.G_cshi_attribute12 := null;
2178: CE_AUTO_BANK_IMPORT.G_cshi_attribute13 := null;
2171: CE_AUTO_BANK_IMPORT.G_cshi_attribute6 := null;
2172: CE_AUTO_BANK_IMPORT.G_cshi_attribute7 := null;
2173: CE_AUTO_BANK_IMPORT.G_cshi_attribute8 := null;
2174: CE_AUTO_BANK_IMPORT.G_cshi_attribute9 := null;
2175: CE_AUTO_BANK_IMPORT.G_cshi_attribute10 := null;
2176: CE_AUTO_BANK_IMPORT.G_cshi_attribute11 := null;
2177: CE_AUTO_BANK_IMPORT.G_cshi_attribute12 := null;
2178: CE_AUTO_BANK_IMPORT.G_cshi_attribute13 := null;
2179: CE_AUTO_BANK_IMPORT.G_cshi_attribute14 := null;
2172: CE_AUTO_BANK_IMPORT.G_cshi_attribute7 := null;
2173: CE_AUTO_BANK_IMPORT.G_cshi_attribute8 := null;
2174: CE_AUTO_BANK_IMPORT.G_cshi_attribute9 := null;
2175: CE_AUTO_BANK_IMPORT.G_cshi_attribute10 := null;
2176: CE_AUTO_BANK_IMPORT.G_cshi_attribute11 := null;
2177: CE_AUTO_BANK_IMPORT.G_cshi_attribute12 := null;
2178: CE_AUTO_BANK_IMPORT.G_cshi_attribute13 := null;
2179: CE_AUTO_BANK_IMPORT.G_cshi_attribute14 := null;
2180: CE_AUTO_BANK_IMPORT.G_cshi_attribute15 := null;
2173: CE_AUTO_BANK_IMPORT.G_cshi_attribute8 := null;
2174: CE_AUTO_BANK_IMPORT.G_cshi_attribute9 := null;
2175: CE_AUTO_BANK_IMPORT.G_cshi_attribute10 := null;
2176: CE_AUTO_BANK_IMPORT.G_cshi_attribute11 := null;
2177: CE_AUTO_BANK_IMPORT.G_cshi_attribute12 := null;
2178: CE_AUTO_BANK_IMPORT.G_cshi_attribute13 := null;
2179: CE_AUTO_BANK_IMPORT.G_cshi_attribute14 := null;
2180: CE_AUTO_BANK_IMPORT.G_cshi_attribute15 := null;
2181: CE_AUTO_BANK_IMPORT.G_cshi_statement_date := null;
2174: CE_AUTO_BANK_IMPORT.G_cshi_attribute9 := null;
2175: CE_AUTO_BANK_IMPORT.G_cshi_attribute10 := null;
2176: CE_AUTO_BANK_IMPORT.G_cshi_attribute11 := null;
2177: CE_AUTO_BANK_IMPORT.G_cshi_attribute12 := null;
2178: CE_AUTO_BANK_IMPORT.G_cshi_attribute13 := null;
2179: CE_AUTO_BANK_IMPORT.G_cshi_attribute14 := null;
2180: CE_AUTO_BANK_IMPORT.G_cshi_attribute15 := null;
2181: CE_AUTO_BANK_IMPORT.G_cshi_statement_date := null;
2182: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name := null;
2175: CE_AUTO_BANK_IMPORT.G_cshi_attribute10 := null;
2176: CE_AUTO_BANK_IMPORT.G_cshi_attribute11 := null;
2177: CE_AUTO_BANK_IMPORT.G_cshi_attribute12 := null;
2178: CE_AUTO_BANK_IMPORT.G_cshi_attribute13 := null;
2179: CE_AUTO_BANK_IMPORT.G_cshi_attribute14 := null;
2180: CE_AUTO_BANK_IMPORT.G_cshi_attribute15 := null;
2181: CE_AUTO_BANK_IMPORT.G_cshi_statement_date := null;
2182: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name := null;
2183: CE_AUTO_BANK_IMPORT.G_cshi_bank_name := null;
2176: CE_AUTO_BANK_IMPORT.G_cshi_attribute11 := null;
2177: CE_AUTO_BANK_IMPORT.G_cshi_attribute12 := null;
2178: CE_AUTO_BANK_IMPORT.G_cshi_attribute13 := null;
2179: CE_AUTO_BANK_IMPORT.G_cshi_attribute14 := null;
2180: CE_AUTO_BANK_IMPORT.G_cshi_attribute15 := null;
2181: CE_AUTO_BANK_IMPORT.G_cshi_statement_date := null;
2182: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name := null;
2183: CE_AUTO_BANK_IMPORT.G_cshi_bank_name := null;
2184: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name := null;
2177: CE_AUTO_BANK_IMPORT.G_cshi_attribute12 := null;
2178: CE_AUTO_BANK_IMPORT.G_cshi_attribute13 := null;
2179: CE_AUTO_BANK_IMPORT.G_cshi_attribute14 := null;
2180: CE_AUTO_BANK_IMPORT.G_cshi_attribute15 := null;
2181: CE_AUTO_BANK_IMPORT.G_cshi_statement_date := null;
2182: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name := null;
2183: CE_AUTO_BANK_IMPORT.G_cshi_bank_name := null;
2184: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name := null;
2185: CE_AUTO_BANK_IMPORT.G_cshi_currency_code := null;
2178: CE_AUTO_BANK_IMPORT.G_cshi_attribute13 := null;
2179: CE_AUTO_BANK_IMPORT.G_cshi_attribute14 := null;
2180: CE_AUTO_BANK_IMPORT.G_cshi_attribute15 := null;
2181: CE_AUTO_BANK_IMPORT.G_cshi_statement_date := null;
2182: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name := null;
2183: CE_AUTO_BANK_IMPORT.G_cshi_bank_name := null;
2184: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name := null;
2185: CE_AUTO_BANK_IMPORT.G_cshi_currency_code := null;
2186: CE_AUTO_BANK_IMPORT.G_trx_recon_seq_id := NULL; -- Bug 8965556
2179: CE_AUTO_BANK_IMPORT.G_cshi_attribute14 := null;
2180: CE_AUTO_BANK_IMPORT.G_cshi_attribute15 := null;
2181: CE_AUTO_BANK_IMPORT.G_cshi_statement_date := null;
2182: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name := null;
2183: CE_AUTO_BANK_IMPORT.G_cshi_bank_name := null;
2184: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name := null;
2185: CE_AUTO_BANK_IMPORT.G_cshi_currency_code := null;
2186: CE_AUTO_BANK_IMPORT.G_trx_recon_seq_id := NULL; -- Bug 8965556
2187: --CE_AUTO_BANK_IMPORT.G_cshi_org_id := null;
2180: CE_AUTO_BANK_IMPORT.G_cshi_attribute15 := null;
2181: CE_AUTO_BANK_IMPORT.G_cshi_statement_date := null;
2182: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name := null;
2183: CE_AUTO_BANK_IMPORT.G_cshi_bank_name := null;
2184: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name := null;
2185: CE_AUTO_BANK_IMPORT.G_cshi_currency_code := null;
2186: CE_AUTO_BANK_IMPORT.G_trx_recon_seq_id := NULL; -- Bug 8965556
2187: --CE_AUTO_BANK_IMPORT.G_cshi_org_id := null;
2188: r_statement_number := null;
2181: CE_AUTO_BANK_IMPORT.G_cshi_statement_date := null;
2182: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name := null;
2183: CE_AUTO_BANK_IMPORT.G_cshi_bank_name := null;
2184: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name := null;
2185: CE_AUTO_BANK_IMPORT.G_cshi_currency_code := null;
2186: CE_AUTO_BANK_IMPORT.G_trx_recon_seq_id := NULL; -- Bug 8965556
2187: --CE_AUTO_BANK_IMPORT.G_cshi_org_id := null;
2188: r_statement_number := null;
2189: aba_bank_account_name := null;
2182: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name := null;
2183: CE_AUTO_BANK_IMPORT.G_cshi_bank_name := null;
2184: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name := null;
2185: CE_AUTO_BANK_IMPORT.G_cshi_currency_code := null;
2186: CE_AUTO_BANK_IMPORT.G_trx_recon_seq_id := NULL; -- Bug 8965556
2187: --CE_AUTO_BANK_IMPORT.G_cshi_org_id := null;
2188: r_statement_number := null;
2189: aba_bank_account_name := null;
2190: aba_bank_currency := null;
2183: CE_AUTO_BANK_IMPORT.G_cshi_bank_name := null;
2184: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name := null;
2185: CE_AUTO_BANK_IMPORT.G_cshi_currency_code := null;
2186: CE_AUTO_BANK_IMPORT.G_trx_recon_seq_id := NULL; -- Bug 8965556
2187: --CE_AUTO_BANK_IMPORT.G_cshi_org_id := null;
2188: r_statement_number := null;
2189: aba_bank_account_name := null;
2190: aba_bank_currency := null;
2191: aba_bank_check_digits := null;
2207: IF lines_cursor%ISOPEN THEN
2208: close lines_cursor;
2209: END IF;
2210: IF l_DEBUG in ('Y', 'C') THEN
2211: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.import_process');
2212: END IF;
2213: RAISE;
2214: END import_process;
2215:
2212: END IF;
2213: RAISE;
2214: END import_process;
2215:
2216: END CE_AUTO_BANK_IMPORT;