[Home] [Help]
60: aba.check_digits,
61: csh.rowid,
62: NVL(csh.statement_complete_flag,'N')
63: FROM ce_bank_accts_gt_v aba, --ce_bank_accounts_v aba,
64: ce_statement_headers csh
65: WHERE aba.bank_account_id = NVL(p_bank_account_id,aba.bank_account_id)
66: AND aba.bank_account_id = csh.bank_account_id
67: AND csh.statement_number
68: BETWEEN NVL(p_statement_number_from,csh.statement_number)
104: decode(nvl(matching_against,'MISC'), 'MISC', 0,
105: to_char(sl.trx_date, 'J')) order_stmt_lns2
106: FROM --pay_payment_types ppt,
107: --ar_receipt_methods rm,
108: ce_statement_headers sh,
109: ce_transaction_codes cd,
110: ce_statement_lines sl
111: WHERE --rm.receipt_method_id(+) = cd.receipt_method_id
112: --nvl(cd.RECONCILIATION_SEQUENCE (+) ,1) = 1
5284: v.CE_BANK_ACCT_USE_ID,
5285: v.seq_id
5286: --FROM ce_222_transactions_v v, gl_daily_conversion_types glcc,
5287: FROM ce_available_transactions_tmp v, gl_daily_conversion_types glcc,
5288: ar_cash_receipt_history_all ar, ce_statement_headers h,
5289: ce_statement_reconcils_all r, ce_statement_lines l
5290: WHERE h.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
5291: AND nvl(l.bank_trx_number,'-9999') =
5292: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '-9999')
5399: v2.CE_BANK_ACCT_USE_ID,
5400: v2.seq_id
5401: --FROM ce_200_transactions_v v2, gl_daily_conversion_types glcc,
5402: FROM ce_available_transactions_tmp v2, gl_daily_conversion_types glcc,
5403: ce_statement_headers h,
5404: ce_statement_reconcils_all r, ce_statement_lines l
5405: WHERE h.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
5406: AND nvl(l.bank_trx_number,'-9999') =
5407: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '-9999')
6772: | REQUIRES |
6773: | lockhandle |
6774: --------------------------------------------------------------------- */
6775: FUNCTION lock_statement(lockhandle IN OUT NOCOPY VARCHAR2) RETURN BOOLEAN IS
6776: x_statement_header_id CE_STATEMENT_HEADERS.statement_header_id%TYPE;
6777: lock_status NUMBER;
6778: expiration_secs NUMBER;
6779: lockname VARCHAR2(128);
6780: lockmode NUMBER;
6784: cep_standard.debug('>>CE_AUTO_BANK_MATCH.lock_statement');
6785:
6786: SELECT statement_header_id
6787: INTO x_statement_header_id
6788: FROM ce_statement_headers
6789: WHERE rowid = CE_AUTO_BANK_MATCH.csh_rowid
6790: FOR UPDATE OF statement_header_id NOWAIT;
6791:
6792: cep_standard.debug('>>CE_AUTO_BANK_MATCH.Regular statement lock OK');
6888: | PRIVATE PROCEDURE |
6889: | update_gl_date |
6890: | |
6891: | DESCRIPTION |
6892: | Update the gl posting date on ce_statement_headers to the new |
6893: | one for this run. |
6894: | |
6895: | CALLED BY |
6896: | match_process |
6899: BEGIN
6900: cep_standard.debug('>>CE_AUTO_BANK_MATCH.update_gl_date');
6901: IF ((CE_AUTO_BANK_REC.find_gl_period(CE_AUTO_BANK_REC.G_gl_date, 200)) OR
6902: (CE_AUTO_BANK_REC.find_gl_period(CE_AUTO_BANK_REC.G_gl_date, 222))) THEN
6903: UPDATE ce_statement_headers
6904: SET gl_date = CE_AUTO_BANK_REC.G_gl_date
6905: WHERE rowid = CE_AUTO_BANK_MATCH.csh_rowid;
6906: END IF;
6907: cep_standard.debug('<
7499: l_je_entered_dr GL_JE_LINES.entered_dr%TYPE;
7500: l_je_entered_cr GL_JE_LINES.entered_cr%TYPE;
7501: l_je_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
7502: l_sl_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
7503: d_statement_header_id CE_STATEMENT_HEADERS.statement_header_id%TYPE;
7504: P_CURRENCY_CODE VARCHAR2(15);
7505: P_STATUS VARCHAR2(30);
7506: P_AMOUNT NUMBER;
7507: BEGIN
7774:
7775: select count(1)
7776: into l_cf
7777: from ce_statement_lines sl,
7778: ce_statement_headers sh
7779: where sl.statement_header_id = sh.statement_header_id
7780: and sh.bank_account_id = p_bank_account_id
7781: and sl.cashflow_id is not null;
7782: