[Home] [Help]
1407: l_fin_charge_date := p_fin_charge_date;
1408: l_worker_number := p_worker_number;
1409: l_total_workers := p_total_workers;
1410:
1411: /* The sum of credit amount is inserted into ar_late_charge_credits_gt.
1412: a) All Unapplied or On Account Receipts and the Open On Account Credit Memos
1413: constitute the credit amount
1414: b) Credits are inserted as positive amounts, for easiness of handling the applications
1415: c) Credits are calculated for a customer_id, site_use_id, currency_code and legal_entity_id
1415: c) Credits are calculated for a customer_id, site_use_id, currency_code and legal_entity_id
1416: combination
1417: */
1418:
1419: insert into ar_late_charge_credits_gt
1420: (customer_id,
1421: customer_site_use_id,
1422: currency_code,
1423: legal_entity_id,
2293: a.multiple_interest_rates_flag,
2294: a.hold_charged_invoices_flag,
2295: a.org_id,
2296: a.interest_fixed_amount)b,
2297: ar_late_charge_credits_gt credits
2298: where decode(b.hold_charged_invoices_flag,
2299: 'Y',decode(b.last_charge_date,
2300: NULL,b.fin_charge_charged,1),
2301: 0) = 0
6168: customer_site_use_id,
6169: currency_code,
6170: legal_entity_id,
6171: credit_amount
6172: from ar_late_charge_credits_gt
6173: order by customer_id,
6174: customer_site_use_id,
6175: currency_code,
6176: legal_entity_id;
6697: p_worker_number => l_worker_number,
6698: p_total_workers => l_total_workers);
6699:
6700: /* If the late charge document is Adjustment or Debit Memo, the credit amount is summed
6701: up and inserted into ar_late_charge_credits_gt . These amounts should later be adjusted
6702: against the open debit items in the order of oldest invoice first.*/
6703:
6704: insert_credit_amount(p_fin_charge_date => l_fin_charge_date,
6705: p_worker_number => l_worker_number,