[Home] [Help]
1798: l_fin_charge_date := p_fin_charge_date;
1799: l_worker_number := p_worker_number;
1800: l_total_workers := p_total_workers;
1801:
1802: /* The sum of credit amount is inserted into ar_late_charge_credits_gt.
1803: a) All Unapplied or On Account Receipts and the Open On Account Credit Memos
1804: constitute the credit amount
1805: b) Credits are inserted as positive amounts, for easiness of handling the applications
1806: c) Credits are calculated for a customer_id, site_use_id, currency_code and legal_entity_id
1806: c) Credits are calculated for a customer_id, site_use_id, currency_code and legal_entity_id
1807: combination
1808: */
1809:
1810: insert into ar_late_charge_credits_gt
1811: (customer_id,
1812: customer_site_use_id,
1813: currency_code,
1814: legal_entity_id,
2692: a.multiple_interest_rates_flag,
2693: a.hold_charged_invoices_flag,
2694: a.org_id,
2695: a.interest_fixed_amount)b,
2696: ar_late_charge_credits_gt credits
2697: where decode(b.hold_charged_invoices_flag,
2698: 'Y',decode(b.last_charge_date,
2699: NULL,b.fin_charge_charged,1),
2700: 0) = 0
6674: customer_site_use_id,
6675: currency_code,
6676: legal_entity_id,
6677: credit_amount
6678: from ar_late_charge_credits_gt
6679: order by customer_id,
6680: customer_site_use_id,
6681: currency_code,
6682: legal_entity_id;
7204: p_worker_number => l_worker_number,
7205: p_total_workers => l_total_workers);
7206:
7207: /* If the late charge document is Adjustment or Debit Memo, the credit amount is summed
7208: up and inserted into ar_late_charge_credits_gt . These amounts should later be adjusted
7209: against the open debit items in the order of oldest invoice first.*/
7210:
7211: insert_credit_amount(p_fin_charge_date => l_fin_charge_date,
7212: p_worker_number => l_worker_number,