[Home] [Help]
PACKAGE: APPS.OE_CREDIT_INTERFACE_UTIL
Source
1 PACKAGE OE_CREDIT_INTERFACE_UTIL AUTHID CURRENT_USER AS
2 -- $Header: OEXUCERS.pls 120.1.12010000.1 2008/07/25 07:55:08 appldev ship $
3 --+=======================================================================+
4 --| Copyright (c) 2000 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| OEXUCERS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Package Spec of OE_CREDIT_INTERFACE_UTIL |
13 --| |
14 --| PROCEDURE LIST |
15 --| Get_Exposure_Amount |
16 --| |
17 --| HISTORY |
18 --| Aug-01-2006 Initial Creation |
19 --|=======================================================================+
20
21 --===============================================================================
22 -- PROCEDURE : Get_exposure_amount
23 -- Comments : Return the overall exposure amount in RA_INTERFACE_LINES_ALL table
24 --===============================================================================
25 PROCEDURE Get_exposure_amount
26 ( p_header_id IN NUMBER
27 , p_customer_id IN NUMBER
28 , p_site_use_id IN NUMBER
29 , p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
30 , p_system_parameter_rec IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
31 , p_credit_level IN VARCHAR2
32 , p_limit_curr_code IN VARCHAR2
33 , p_usage_curr IN OE_CREDIT_CHECK_UTIL.curr_tbl_type
34 , p_global_exposure_flag IN VARCHAR2 := 'N'
35 , x_exposure_amount OUT NOCOPY NUMBER
36 , x_conversion_status OUT NOCOPY OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE
37 , x_return_status OUT NOCOPY VARCHAR2
38 ) ;
39
40 END OE_CREDIT_INTERFACE_UTIL ;