[Home] [Help]
22: new_lul IN NUMBER,
23: touch_hist_and_dist IN BOOLEAN DEFAULT TRUE,
24: crh_id_out OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE)
25: IS
26: CURSOR cr_info (cr_id AR_CASH_RECEIPTS.CASH_RECEIPT_ID%TYPE) IS
27: SELECT cr.cash_receipt_id cash_receipt_id,
28: cr.set_of_books_id set_of_books_id,
29: cr.currency_code currency_code,
30: cr.receipt_method_id receipt_method_id,
35: rma.unapplied_ccid unapplied_ccid,
36: rma.unidentified_ccid unidentified_ccid,
37: cr.tax_rate tax_rate,
38: cr.receivables_trx_id receivables_trx_id
39: FROM ar_cash_receipts cr,
40: ar_payment_schedules ps,
41: ar_receipt_method_accounts rma,
42: gl_sets_of_books sob
43: WHERE cr.cash_receipt_id = cr_id
97: FROM AR_MISC_CASH_DISTRIBUTIONS
98: WHERE CASH_RECEIPT_ID = cr_id
99: AND REVERSAL_GL_DATE IS NULL;
100:
101: CURSOR rec_app_info (cr_id AR_CASH_RECEIPTS.CASH_RECEIPT_ID%TYPE) IS
102: SELECT *
103: FROM AR_RECEIVABLE_APPLICATIONS
104: WHERE CASH_RECEIPT_ID = cr_id
105: AND REVERSAL_GL_DATE IS NULL
216: upd_ra_rec AR_RECEIVABLE_APPLICATIONS%ROWTYPE;
217: net_ra_rec AR_RECEIVABLE_APPLICATIONS%ROWTYPE;
218:
219: -- Added for 11.5 VAT changes
220: l_cr_rec ar_cash_receipts%ROWTYPE;
221: l_dist_rec ar_distributions%ROWTYPE;
222: l_dummy ar_distributions.line_id%TYPE;
223: l_app_id ar_receivable_applications.receivable_application_id%TYPE;
224: l_ae_doc_rec ae_doc_rec_type;
1610: /*-------------------------------------------------------------*
1611: |Bug 1832122 - If the new write-off accounted amount exceeds |
1612: |maximum write-off amount at system level,then we leave the |
1613: |write-off record as unapplied. In that case, we have to open the|
1614: |receipt PS and ar_cash_receipts record |
1615: *-------------------------------------------------------------*/
1616: --Since in this case we are not re-creating the write-off record
1617: --we should not update the amounts in PS only status needs to be
1618: --opened.