[Home] [Help]
266:
267: l_cr_rec ar_cash_receipts%ROWTYPE;
268: l_crh_rec ar_cash_receipt_history%ROWTYPE;
269: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
270: l_ps_rec ar_payment_schedules%ROWTYPE;
271: l_dist_rec ar_distributions%ROWTYPE;
272: l_crh_id_new ar_cash_receipt_history.cash_receipt_history_id%TYPE;
273: l_ra_id_unapp ar_receivable_applications.receivable_application_id%TYPE;
274: l_ra_id_unid ar_receivable_applications.receivable_application_id%TYPE;
341: l_source_type_new ar_distributions.source_type%TYPE;
342: l_creation_status_new ar_cash_receipt_history.status%TYPE;
343: l_acctd_amount_new ar_cash_receipt_history.acctd_amount%TYPE;
344: l_ccid_new ar_cash_receipt_history.account_code_combination_id%TYPE;
345: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
346: l_id_dummy NUMBER;
347: l_amount_changed BOOLEAN := FALSE;
348: l_rev_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
349: l_ra_unapp_ccid NUMBER;
846: -- deal with amount changes
847: -- -------------------------------------------------------------
848:
849: -- if the receipt status is APPROVED, we only update the amounts in
850: -- ar_cash_receipts, ar_cash_receipt_history, and ar_payment_schedules,
851: -- but not ar_receivable_applications, since this is being taken
852: -- care of by the applications form and its server-side code:
853:
854: