[Home] [Help]
3358: l_xla_ev_rec arp_xla_events.xla_events_type;
3359: l_xla_doc_table VARCHAR2(20);
3360:
3361:
3362: l_receipt_info_rec AR_AUTOREC_API.receipt_info_rec;
3363:
3364: l_old_ps_rec ar_payment_schedules%ROWTYPE; /* jrautiai BR implementation */
3365: l_new_ps_rec ar_payment_schedules%ROWTYPE; /* jrautiai BR implementation */
3366: l_source_type ar_distributions.source_type%TYPE; /* jrautiai BR implementation */
3520: Check if the payment schedule of this transaction is over applied and
3521: the transaction type does not allow overapplication */
3522:
3523: IF nvl(p_called_from,'NONE') IN ('AUTORECAPI','AUTORECAPI2') THEN
3524: ar_autorec_api.populate_cached_data( l_receipt_info_rec );
3525: l_inv_bal_amount := l_receipt_info_rec.inv_bal_amount;
3526: l_inv_orig_amount := l_receipt_info_rec.inv_orig_amount;
3527: l_allow_over_application := l_receipt_info_rec.allow_overappln_flag;
3528:
3579: for performance issue */
3580: /* Removing the ce_bank_acct_uses table from the select statement for bug 5571095 by gnramasa on 06/10/2006 */
3581: --BUG 6660834
3582: IF nvl(p_called_from,'NONE') IN ('AUTORECAPI','AUTORECAPI2') THEN
3583: ar_autorec_api.populate_cached_data( l_receipt_info_rec );
3584:
3585: ln_batch_id := l_receipt_info_rec.batch_id;
3586: l_rec_ra_rec.cash_receipt_id := l_receipt_info_rec.cash_receipt_id;
3587: l_rec_ra_rec.code_combination_id := l_receipt_info_rec.unapplied_ccid;
4399: , l_rec_ra_rec.cash_receipt_id);
4400:
4401: -- Update the batch status if receipt has a batch.
4402: -- Bug 8974877 : If the batch is an automatic receipt batch, we need not update the batch for each
4403: -- and every receipt. The batch status will be updated finally in the AR_AUTOREC_API.
4404: IF (ln_batch_id IS NOT NULL AND nvl(p_called_from,'NONE') NOT IN ('AUTORECAPI','AUTORECAPI2')) THEN
4405: arp_rw_batches_check_pkg.update_batch_status(ln_batch_id,p_called_from); --Bug7194951
4406: END IF;
4407: