151: , p_site_use_id IN NUMBER
152: , p_party_id IN NUMBER := NULL
153: , p_header_id IN NUMBER
154: , p_credit_check_rule_rec IN
155: OE_CREDIT_CHECK_UTIL.oe_credit_rules_rec_type
156: , p_system_parameters_rec IN
157: OE_CREDIT_CHECK_UTIL.oe_systems_param_rec_type
158: , p_limit_curr_code IN
159: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
153: , p_header_id IN NUMBER
154: , p_credit_check_rule_rec IN
155: OE_CREDIT_CHECK_UTIL.oe_credit_rules_rec_type
156: , p_system_parameters_rec IN
157: OE_CREDIT_CHECK_UTIL.oe_systems_param_rec_type
158: , p_limit_curr_code IN
159: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
160: , p_usage_curr_tbl IN OE_CREDIT_CHECK_UTIL.curr_tbl_type
161: , p_include_all_flag IN VARCHAR2
156: , p_system_parameters_rec IN
157: OE_CREDIT_CHECK_UTIL.oe_systems_param_rec_type
158: , p_limit_curr_code IN
159: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
160: , p_usage_curr_tbl IN OE_CREDIT_CHECK_UTIL.curr_tbl_type
161: , p_include_all_flag IN VARCHAR2
162: , p_global_exposure_flag IN VARCHAR2 := 'N'
163: , p_need_exposure_details IN VARCHAR2 := 'N'
164: , x_total_exposure OUT NOCOPY NUMBER
165: , x_order_amount OUT NOCOPY NUMBER
166: , x_order_hold_amount OUT NOCOPY NUMBER
167: , x_ar_amount OUT NOCOPY NUMBER
168: , x_return_status OUT NOCOPY VARCHAR2
169: , x_error_curr_tbl OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type
170: );
171:
172:
173:
175: ( p_customer_id IN NUMBER
176: , p_site_use_id IN NUMBER
177: , p_party_id IN NUMBER
178: , p_credit_check_rule_rec IN
179: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
180: , p_credit_level IN VARCHAR2
181: , p_usage_curr IN oe_credit_check_util.curr_tbl_type
182: , p_include_all_flag IN VARCHAR2
183: , p_global_exposure_flag IN VARCHAR2 := 'N'
177: , p_party_id IN NUMBER
178: , p_credit_check_rule_rec IN
179: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
180: , p_credit_level IN VARCHAR2
181: , p_usage_curr IN oe_credit_check_util.curr_tbl_type
182: , p_include_all_flag IN VARCHAR2
183: , p_global_exposure_flag IN VARCHAR2 := 'N'
184: , p_org_id IN NUMBER
185: , x_exist_flag OUT NOCOPY VARCHAR2