[Home] [Help]
208: CURSOR lock_222 (X_call_mode VARCHAR2,trx_rowid VARCHAR2) IS
209: SELECT crh.cash_receipt_history_id,
210: cr.cash_receipt_id,
211: NVL(crh.current_record_flag,'N')
212: FROM ar_cash_receipts_all cr,
213: ar_cash_receipt_history_all crh,
214: ce_statement_reconcils_all rec
215: WHERE cr.cash_receipt_id = crh.cash_receipt_id
216: AND crh.rowid = trx_rowid
242: CURSOR clear_lock_222 (X_call_mode VARCHAR2,trx_rowid VARCHAR2) IS
243: SELECT crh.cash_receipt_history_id,
244: cr.cash_receipt_id,
245: NVL(crh.current_record_flag,'N')
246: FROM ar_cash_receipts_all cr,
247: ar_cash_receipt_history_all crh
248: WHERE cr.cash_receipt_id = crh.cash_receipt_id
249: AND crh.rowid = trx_rowid
250: FOR UPDATE OF crh.cash_receipt_history_id,
325: CURSOR LOCK_BATCH_RECEIPTS (trx_rowid VARCHAR2) IS
326: SELECT crh.cash_receipt_history_id,
327: cr.cash_receipt_id,
328: b.batch_id batch_id
329: FROM AR_CASH_RECEIPTS_all CR,
330: AR_CASH_RECEIPT_HISTORY_all CRH,
331: AR_CASH_RECEIPT_HISTORY_all CRH2,
332: AR_BATCHES_all B
333: WHERE b.rowid = trx_rowid
2300: ce_bank_accounts ba,
2301: ce_bank_acct_uses_ou_v aba2,
2302: ce_bank_accounts ba2,
2303: ar_cash_receipt_history_all crh,
2304: ar_cash_receipts_all cr,
2305: ar_receivable_applications_all ra,
2306: ar_payment_schedules_all ps
2307: WHERE sob.set_of_books_id = sp.set_of_books_id
2308: AND nvl(rec.status_flag, 'U') = 'U'
2586: ce_statement_reconcils_all rec,
2587: ce_bank_accounts ba,
2588: ce_bank_acct_uses_ou_v aba,
2589: ar_cash_receipt_history_all crh,
2590: ar_cash_receipts_all cr,
2591: ar_receivable_applications_all ra,
2592: --ra_customers rc,
2593: HZ_CUST_ACCOUNTS CU,
2594: hz_parties hp,
6465: CE_AUTO_BANK_MATCH.nsf_info_flag := 'Y';
6466: else
6467: cep_standard.debug('Create a misc receipt for NSF line with tolerance.');
6468: declare
6469: p_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
6470: begin
6471:
6472: --
6473: -- bug# 1180124