[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.
294: THEN
295:
296: l_cus_open_bal := l_cus_open_bal + l_inv_open_bal ;
297:
298: INSERT INTO AR_CUSTOMER_BALANCE_ITF(Request_id,
299: as_of_date,
300: organization_name,
301: functional_currency_code,
302: customer_name,
435: - l_unapp_receipts ;
436:
437: IF ( l_unapp_receipts <> 0 ) OR ( l_on_acct_receipts <> 0 )
438: THEN
439: INSERT INTO AR_CUSTOMER_BALANCE_ITF(Request_id,
440: as_of_date,
441: organization_name,
442: functional_currency_code,
443: customer_name,