1 PACKAGE ARP_CUSTOMER_AGING AUTHID CURRENT_USER AS
2 /* $Header: ARCWAGES.pls 115.7 2002/11/15 02:30:24 anukumar ship $ */
3
4 PROCEDURE calc_aging_buckets (
5 p_customer_id IN NUMBER,
6 p_customer_site_use_id IN NUMBER,
7 p_as_of_date IN DATE,
8 p_currency_code IN VARCHAR2,
9 p_credit_option IN VARCHAR2,
10 p_invoice_type_low IN VARCHAR2,
11 p_invoice_type_high IN VARCHAR2,
12 p_ps_max_id IN NUMBER DEFAULT 0,
13 p_app_max_id IN NUMBER DEFAULT 0,
14 p_bucket_name IN VARCHAR2,
15 p_outstanding_balance IN OUT NOCOPY NUMBER,
16 p_bucket_titletop_0 OUT NOCOPY VARCHAR2,
17 p_bucket_titlebottom_0 OUT NOCOPY VARCHAR2,
18 p_bucket_amount_0 IN OUT NOCOPY NUMBER,
19 p_bucket_titletop_1 OUT NOCOPY VARCHAR2,
20 p_bucket_titlebottom_1 OUT NOCOPY VARCHAR2,
21 p_bucket_amount_1 IN OUT NOCOPY NUMBER,
22 p_bucket_titletop_2 OUT NOCOPY VARCHAR2,
23 p_bucket_titlebottom_2 OUT NOCOPY VARCHAR2,
24 p_bucket_amount_2 IN OUT NOCOPY NUMBER,
25 p_bucket_titletop_3 OUT NOCOPY VARCHAR2,
26 p_bucket_titlebottom_3 OUT NOCOPY VARCHAR2,
27 p_bucket_amount_3 IN OUT NOCOPY NUMBER,
28 p_bucket_titletop_4 OUT NOCOPY VARCHAR2,
29 p_bucket_titlebottom_4 OUT NOCOPY VARCHAR2,
30 p_bucket_amount_4 IN OUT NOCOPY NUMBER,
31 p_bucket_titletop_5 OUT NOCOPY VARCHAR2,
32 p_bucket_titlebottom_5 OUT NOCOPY VARCHAR2,
33 p_bucket_amount_5 IN OUT NOCOPY NUMBER,
34 p_bucket_titletop_6 OUT NOCOPY VARCHAR2,
35 p_bucket_titlebottom_6 OUT NOCOPY VARCHAR2,
36 p_bucket_amount_6 IN OUT NOCOPY NUMBER
37 );
38 --
39 PROCEDURE calc_credits (
40 p_customer_id IN NUMBER,
41 p_customer_site_use_id IN NUMBER,
42 p_as_of_date IN DATE,
43 p_currency_code IN VARCHAR2,
44 p_ps_max_id IN NUMBER DEFAULT 0,
45 p_credits OUT NOCOPY NUMBER
46 );
47 --
48 PROCEDURE calc_receipts (
49 p_customer_id IN NUMBER,
50 p_customer_site_use_id IN NUMBER,
51 p_as_of_date IN DATE,
52 p_currency_code IN VARCHAR2,
53 p_app_max_id IN NUMBER DEFAULT 0,
54 p_unapplied_cash OUT NOCOPY NUMBER,
55 p_onacct_cash OUT NOCOPY NUMBER,
56 p_cash_claims OUT NOCOPY NUMBER,
57 p_prepayments OUT NOCOPY NUMBER
58 );
59 --
60 PROCEDURE calc_risk_receipts (
61 p_customer_id IN NUMBER,
62 p_customer_site_use_id IN NUMBER,
63 p_as_of_date IN DATE,
64 p_currency_code IN VARCHAR2,
65 p_ps_max_id IN NUMBER DEFAULT 0,
66 p_risk_receipts OUT NOCOPY NUMBER
67 );
68 --
69 PROCEDURE calc_dispute (
70 p_customer_id IN NUMBER,
71 p_customer_site_use_id IN NUMBER,
72 p_as_of_date IN DATE,
73 p_currency_code IN VARCHAR2,
74 p_ps_max_id IN NUMBER DEFAULT 0,
75 p_dispute OUT NOCOPY NUMBER
76 );
77 --
78 PROCEDURE calc_pending_adj (
79 p_customer_id IN NUMBER,
80 p_customer_site_use_id IN NUMBER,
81 p_as_of_date IN DATE,
82 p_currency_code IN VARCHAR2,
83 p_ps_max_id IN NUMBER DEFAULT 0,
84 p_pending_adj OUT NOCOPY NUMBER
85 );
86 --
87 END ARP_CUSTOMER_AGING;