1 PACKAGE OE_Credit_Exposure_PUB AUTHID CURRENT_USER AS
2 -- $Header: OEXPCRXS.pls 120.0 2005/06/01 00:53:39 appldev noship $
3 --------------------
4 -- TYPE DECLARATIONS
5 --------------------
6
7 ------------
8 -- CONSTANTS
9 ------------
10
11 -------------------
12 -- PUBLIC VARIABLES
13 -------------------
14 ---------------------------
15 -- PROCEDURES AND FUNCTIONS
16 ---------------------------
17
18 ----------------------------------------------------------------
19 -- This procedure returns the total exposure and also the
20 -- individual balance for OM and AR
21 -- based on the credit check rule
22 -- It is an overloaded Get_customer_exposure API
23
24 -- This will replace Get_customer_exposure for all new
25 -- references. The original method Get_customer_exposure
26 -- will continue to remain for backward compatibility
27 ----------------------------------------------------------------
28 PROCEDURE Get_customer_exposure
29 ( p_party_id IN NUMBER
30 , p_customer_id IN NUMBER
31 , p_site_id IN NUMBER
32 , p_limit_curr_code IN VARCHAR2
33 , p_credit_check_rule_id IN NUMBER
34 , x_total_exposure OUT NOCOPY /* file.sql.39 change */ NUMBER
35 , x_order_hold_amount OUT NOCOPY /* file.sql.39 change */ NUMBER
36 , x_order_amount OUT NOCOPY /* file.sql.39 change */ NUMBER
37 , x_ar_amount OUT NOCOPY /* file.sql.39 change */ NUMBER
38 , x_external_amount OUT NOCOPY /* file.sql.39 change */ NUMBER
39 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
40 );
41
42
43 END OE_Credit_Exposure_PUB;