DBA Data[Home] [Help]

APPS.CE_AUTO_BANK_MATCH dependencies on ARP_CASHBOOK

Line 218: AND rec.reference_type(+) = decode(arp_cashbook.receipt_debit_memo_reversed(crh.cash_receipt_id), 'Y', 'DM REVERSAL', 'RECEIPT')

214: ce_statement_reconcils_all rec
215: WHERE cr.cash_receipt_id = crh.cash_receipt_id
216: AND crh.rowid = trx_rowid
217: AND rec.reference_id(+) = crh.cash_receipt_history_id
218: AND rec.reference_type(+) = decode(arp_cashbook.receipt_debit_memo_reversed(crh.cash_receipt_id), 'Y', 'DM REVERSAL', 'RECEIPT')
219: AND NVL(rec.status_flag,X_call_mode) = X_call_mode
220: AND NVL(rec.current_record_flag,'Y') = 'Y'
221: FOR UPDATE OF crh.cash_receipt_history_id,
222: cr.cash_receipt_id NOWAIT;

Line 5781: ARP_CASHBOOK.unclear(

5777: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_MATCH.stmtline_match');
5778:
5779: elsif CE_AUTO_BANK_MATCH.csl_match_type = 'RECEIPT' then
5780:
5781: ARP_CASHBOOK.unclear(
5782: p_cr_id => CE_AUTO_BANK_MATCH.trx_cash_receipt_id,
5783: p_trx_date => CE_AUTO_BANK_MATCH.trx_date,
5784: p_gl_date => CE_AUTO_BANK_REC.G_gl_date,
5785: p_actual_value_date => CE_AUTO_BANK_MATCH.csl_effective_date,

Line 6029: ARP_CASHBOOK.unclear(

6025: X_REQUEST_ID => to_number(NULL),
6026: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_MATCH.stmtline_match');
6027:
6028: elsif (loc_match_type = 'RECEIPT') then
6029: ARP_CASHBOOK.unclear(
6030: p_cr_id => loc_cash_receipt_id,
6031: p_trx_date => loc_trx_date,
6032: p_gl_date => CE_AUTO_BANK_REC.G_gl_date,
6033: p_actual_value_date => CE_AUTO_BANK_MATCH.csl_effective_date,