APPS.OE_CREDIT_INTERFACE_UTIL dependencies on OE_CREDIT_CHECK_UTIL

Line 24: G_DEBUG_FLAG VARCHAR2(1) := NVL(oe_credit_check_util.check_debug_flag , 'N' ) ;

20: --| Aug-01-2006 Initial creation |
21: --+=======================================================================+
22:
23: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_CREDIT_INTERFACE_UTIL';
24: G_DEBUG_FLAG VARCHAR2(1) := NVL(oe_credit_check_util.check_debug_flag , 'N' ) ;
25:
26: --===============================================================================
27: -- PROCEDURE : Get_exposure_amount
28: -- Comments : Return the overall exposure amount in RA_INTERFACE_LINES_ALL table

Line 34: , p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

30: PROCEDURE Get_exposure_amount
31: ( p_header_id IN NUMBER
32: , p_customer_id IN NUMBER
33: , p_site_use_id IN NUMBER
34: , p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
35: , p_system_parameter_rec IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
36: , p_credit_level IN VARCHAR2
37: , p_limit_curr_code IN VARCHAR2
38: , p_usage_curr IN OE_CREDIT_CHECK_UTIL.curr_tbl_type

Line 35: , p_system_parameter_rec IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type

31: ( p_header_id IN NUMBER
32: , p_customer_id IN NUMBER
33: , p_site_use_id IN NUMBER
34: , p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
35: , p_system_parameter_rec IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
36: , p_credit_level IN VARCHAR2
37: , p_limit_curr_code IN VARCHAR2
38: , p_usage_curr IN OE_CREDIT_CHECK_UTIL.curr_tbl_type
39: , p_global_exposure_flag IN VARCHAR2 := 'N'

Line 38: , p_usage_curr IN OE_CREDIT_CHECK_UTIL.curr_tbl_type

34: , p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
35: , p_system_parameter_rec IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
36: , p_credit_level IN VARCHAR2
37: , p_limit_curr_code IN VARCHAR2
38: , p_usage_curr IN OE_CREDIT_CHECK_UTIL.curr_tbl_type
39: , p_global_exposure_flag IN VARCHAR2 := 'N'
40: , x_exposure_amount OUT NOCOPY NUMBER
41: , x_conversion_status OUT NOCOPY OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE
42: , x_return_status OUT NOCOPY VARCHAR2

Line 41: , x_conversion_status OUT NOCOPY OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE

37: , p_limit_curr_code IN VARCHAR2
38: , p_usage_curr IN OE_CREDIT_CHECK_UTIL.curr_tbl_type
39: , p_global_exposure_flag IN VARCHAR2 := 'N'
40: , x_exposure_amount OUT NOCOPY NUMBER
41: , x_conversion_status OUT NOCOPY OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE
42: , x_return_status OUT NOCOPY VARCHAR2
43: )
44: IS
45:

Line 55: l_org_id NUMBER := OE_CREDIT_CHECK_UTIL.G_ORG_ID ;

51: l_freight_charges_flag VARCHAR2(1) := NVL(p_credit_check_rule_rec.incl_freight_charges_flag,'N') ;
52: l_include_returns_flag VARCHAR2(1) := NVL(p_credit_check_rule_rec.include_returns_flag,'N');
53: l_include_uninvoiced_flag VARCHAR2(1) := NVL(p_credit_check_rule_rec.uninvoiced_orders_flag,'N');
54:
55: l_org_id NUMBER := OE_CREDIT_CHECK_UTIL.G_ORG_ID ;
56:
57: l_total_exposure NUMBER := 0 ;
58:
59: l_total_on_order NUMBER := 0 ;

Line 878: OE_Credit_Engine_GRP.GL_currency := OE_CREDIT_CHECK_UTIL.GET_GL_currency ;

874: IF OE_Credit_Engine_GRP.GL_currency IS NULL
875: THEN
876: OE_DEBUG_PUB.ADD(' Call GET_GL_currency ');
877:
878: OE_Credit_Engine_GRP.GL_currency := OE_CREDIT_CHECK_UTIL.GET_GL_currency ;
879:
880: OE_DEBUG_PUB.ADD(' GL_CURRENCY after = ' || OE_Credit_Engine_GRP.GL_currency );
881: END IF;
882:

Line 884: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

880: OE_DEBUG_PUB.ADD(' GL_CURRENCY after = ' || OE_Credit_Engine_GRP.GL_currency );
881: END IF;
882:
883: l_limit_total_exposure :=
884: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
885: ( p_amount => l_usage_total_exposure
886: , p_transactional_currency => p_usage_curr(i).usage_curr_code
887: , p_limit_currency => p_limit_curr_code
888: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency