1 PACKAGE AR_CMGT_AGING AUTHID CURRENT_USER AS
2 /* $Header: ARCMAGES.pls 115.4 2003/06/21 01:54:50 msenthil noship $ */
3
4 PROCEDURE calc_aging_buckets (
5 p_party_id IN NUMBER,
6 p_customer_id IN NUMBER,
7 p_site_use_id IN NUMBER,
8 p_currency_code IN VARCHAR2,
9 p_credit_option IN VARCHAR2,
10 p_bucket_name IN VARCHAR2,
11 p_org_id IN NUMBER,
12 p_exchange_rate_type IN VARCHAR2,
13 p_source IN VARCHAR2 default NULL,
14 p_outstanding_balance IN OUT NOCOPY NUMBER,
15 p_bucket_titletop_0 OUT NOCOPY VARCHAR2,
16 p_bucket_titlebottom_0 OUT NOCOPY VARCHAR2,
17 p_bucket_amount_0 IN OUT NOCOPY NUMBER,
18 p_bucket_titletop_1 OUT NOCOPY VARCHAR2,
19 p_bucket_titlebottom_1 OUT NOCOPY VARCHAR2,
20 p_bucket_amount_1 IN OUT NOCOPY NUMBER,
21 p_bucket_titletop_2 OUT NOCOPY VARCHAR2,
22 p_bucket_titlebottom_2 OUT NOCOPY VARCHAR2,
23 p_bucket_amount_2 IN OUT NOCOPY NUMBER,
24 p_bucket_titletop_3 OUT NOCOPY VARCHAR2,
25 p_bucket_titlebottom_3 OUT NOCOPY VARCHAR2,
26 p_bucket_amount_3 IN OUT NOCOPY NUMBER,
27 p_bucket_titletop_4 OUT NOCOPY VARCHAR2,
28 p_bucket_titlebottom_4 OUT NOCOPY VARCHAR2,
29 p_bucket_amount_4 IN OUT NOCOPY NUMBER,
30 p_bucket_titletop_5 OUT NOCOPY VARCHAR2,
31 p_bucket_titlebottom_5 OUT NOCOPY VARCHAR2,
32 p_bucket_amount_5 IN OUT NOCOPY NUMBER,
33 p_bucket_titletop_6 OUT NOCOPY VARCHAR2,
34 p_bucket_titlebottom_6 OUT NOCOPY VARCHAR2,
35 p_bucket_amount_6 IN OUT NOCOPY NUMBER
36 );
37
38 END AR_CMGT_AGING;
[Home] [Help]