[Home] [Help]
41: aba.check_digits,
42: csh.rowid,
43: NVL(csh.statement_complete_flag,'N')
44: FROM ce_bank_accts_gt_v aba, --ce_bank_accounts_v aba,
45: ce_statement_headers csh
46: WHERE aba.bank_account_id = NVL(p_bank_account_id,aba.bank_account_id)
47: AND aba.bank_account_id = csh.bank_account_id
48: AND csh.statement_number
49: BETWEEN NVL(p_statement_number_from,csh.statement_number)
85: decode(nvl(matching_against,'MISC'), 'MISC', 0,
86: to_char(sl.trx_date, 'J')) order_stmt_lns2
87: FROM --pay_payment_types ppt,
88: --ar_receipt_methods rm,
89: ce_statement_headers sh,
90: ce_transaction_codes cd,
91: ce_statement_lines sl
92: WHERE --rm.receipt_method_id(+) = cd.receipt_method_id
93: --nvl(cd.RECONCILIATION_SEQUENCE (+) ,1) = 1
5531: v.CE_BANK_ACCT_USE_ID,
5532: v.seq_id
5533: --FROM ce_222_transactions_v v, gl_daily_conversion_types glcc,
5534: FROM ce_available_transactions_tmp v, gl_daily_conversion_types glcc,
5535: ar_cash_receipt_history_all ar, ce_statement_headers h,
5536: ce_statement_reconcils_all r, ce_statement_lines l
5537: WHERE h.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
5538: AND nvl(l.bank_trx_number,'-9999') =
5539: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '-9999')
5646: v2.CE_BANK_ACCT_USE_ID,
5647: v2.seq_id
5648: --FROM ce_200_transactions_v v2, gl_daily_conversion_types glcc,
5649: FROM ce_available_transactions_tmp v2, gl_daily_conversion_types glcc,
5650: ce_statement_headers h,
5651: ce_statement_reconcils_all r, ce_statement_lines l
5652: WHERE h.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
5653: AND nvl(l.bank_trx_number,'-9999') =
5654: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '-9999')
6983: | match_process |
6984: | |
6985: --------------------------------------------------------------------- */
6986: FUNCTION lock_statement RETURN BOOLEAN IS
6987: x_statement_header_id CE_STATEMENT_HEADERS.statement_header_id%TYPE;
6988: BEGIN
6989: cep_standard.debug('>>CE_AUTO_BANK_MATCH.lock_statement');
6990:
6991: SELECT statement_header_id
6989: cep_standard.debug('>>CE_AUTO_BANK_MATCH.lock_statement');
6990:
6991: SELECT statement_header_id
6992: INTO x_statement_header_id
6993: FROM ce_statement_headers
6994: WHERE rowid = CE_AUTO_BANK_MATCH.csh_rowid
6995: FOR UPDATE OF statement_header_id NOWAIT;
6996:
6997: cep_standard.debug('>>CE_AUTO_BANK_MATCH.Statement lock OK');
7077: | PRIVATE PROCEDURE |
7078: | update_gl_date |
7079: | |
7080: | DESCRIPTION |
7081: | Update the gl posting date on ce_statement_headers to the new |
7082: | one for this run. |
7083: | |
7084: | CALLED BY |
7085: | match_process |
7088: BEGIN
7089: cep_standard.debug('>>CE_AUTO_BANK_MATCH.update_gl_date');
7090: IF ((CE_AUTO_BANK_REC.find_gl_period(CE_AUTO_BANK_REC.G_gl_date, 200)) OR
7091: (CE_AUTO_BANK_REC.find_gl_period(CE_AUTO_BANK_REC.G_gl_date, 222))) THEN
7092: UPDATE ce_statement_headers
7093: SET gl_date = CE_AUTO_BANK_REC.G_gl_date
7094: WHERE rowid = CE_AUTO_BANK_MATCH.csh_rowid;
7095: END IF;
7096: cep_standard.debug('<
7730: l_je_entered_dr GL_JE_LINES.entered_dr%TYPE;
7731: l_je_entered_cr GL_JE_LINES.entered_cr%TYPE;
7732: l_je_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
7733: l_sl_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
7734: d_statement_header_id CE_STATEMENT_HEADERS.statement_header_id%TYPE;
7735: P_CURRENCY_CODE VARCHAR2(15);
7736: P_STATUS VARCHAR2(30);
7737: P_AMOUNT NUMBER;
7738: l_unclearing_gl_date DATE; -- 14725907: Added
8022:
8023: select count(1)
8024: into l_cf
8025: from ce_statement_lines sl,
8026: ce_statement_headers sh
8027: where sl.statement_header_id = sh.statement_header_id
8028: and sh.bank_account_id = p_bank_account_id
8029: and sl.cashflow_id is not null;
8030: