[Home] [Help]
3: /*------------------------------------------------------------------------------
4: Procedure AR_GET_CUSTOMER_BALANCE calulates the customer balance
5: based on the parameters entered. It then inserts one row for each invoice,
6: credit memo, unapplied receipts,on account receipts and uncleared receipts
7: used for calculating the customer balance into the table AR_CUSTOMER_BALANCE_ITF
8: --------------------------------------------------------------------------------*/
9:
10: /* bug2466471 : Re-create PROCEDURE ar_get_customer_balance.
11:
16: Also, get unapplied and on-account receipts of which gl_date is earlier than p_as_of_date. (Of course, don't get application , unapplied and on-account information of uncleared receipt if p_uncleared_receipts is not 'Y'.)
17:
18: And get customer balance on basis of unapplied and on-account receipts and invoice balance as of p_as_of_date.
19:
20: Finally, insert these record into AR_CUSTOMER_BALANCE_ITF table.
21: */
22:
23: /* bug 2657118 Changed the logic, instead of comparing as_of_date with gl_date of
24: transactions and as well as receipts , we'll now compare as_of_date with trx_date and apply_date whatever may be applicable.
296: THEN
297:
298: l_cus_open_bal := l_cus_open_bal + l_inv_open_bal ;
299:
300: INSERT INTO AR_CUSTOMER_BALANCE_ITF(Request_id,
301: as_of_date,
302: organization_name,
303: functional_currency_code,
304: customer_name,
438: - l_unapp_receipts ;
439:
440: IF ( l_unapp_receipts <> 0 ) OR ( l_on_acct_receipts <> 0 )
441: THEN
442: INSERT INTO AR_CUSTOMER_BALANCE_ITF(Request_id,
443: as_of_date,
444: organization_name,
445: functional_currency_code,
446: customer_name,