APPS.HZ_CREDIT_REQUEST_PVT dependencies on OE_CREDIT_CHECK_UTIL

Line 20: G_debug_flag VARCHAR2(1) := NVL( OE_CREDIT_CHECK_UTIL.check_debug_flag ,'N') ;

16: ----------------------
17: -- PRIVATE VARIABLES
18: ----------------------
19: ---added for bug#8617023 start
20: G_debug_flag VARCHAR2(1) := NVL( OE_CREDIT_CHECK_UTIL.check_debug_flag ,'N') ;
21: G_hdr_hold_released VARCHAR2(1) := 'N' ;
22: ---added for bug#8617023 end
23:
24: ---------------------------

Line 41: P_SYSTEM_PARAMETER_REC IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type ,

37:
38: PROCEDURE Release_Order_CC_Hold ( p_header_id IN NUMBER ,
39: p_order_number IN NUMBER ,
40: p_calling_action IN VARCHAR2 DEFAULT 'BOOKING',
41: P_SYSTEM_PARAMETER_REC IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type ,
42: p_user_id IN NUMBER, --parameter added
43: x_cc_result_out OUT NOCOPY VARCHAR2 )
44: IS
45: l_hold_entity_id NUMBER := p_header_id;

Line 290: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type;

286: )
287: RETURN VARCHAR2
288: IS
289: l_key VARCHAR2(240);
290: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type;
291: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
292: l_credit_check_rule_id NUMBER;
293: l_limit_currency AR_CMGT_CREDIT_REQUESTS.limit_currency%TYPE;
294: l_trx_amount NUMBER;

Line 309: l_conversion_status OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE ;

305:
306: l_new_amount NUMBER;
307:
308: l_cc_result_out VARCHAR2(30);
309: l_conversion_status OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE ;
310: l_msg_count NUMBER;
311: l_msg_data VARCHAR2(2000);
312: l_return_status VARCHAR2(30);
313: l_credit_request_id NUMBER;

Line 469: OE_CREDIT_CHECK_UTIL.GET_credit_check_rule

465: WHERE hold_id = 1;
466: --15884319 end
467:
468: --Populate credit check rule record
469: OE_CREDIT_CHECK_UTIL.GET_credit_check_rule
470: ( p_header_id => l_source_column1
471: , p_credit_check_rule_id => l_credit_check_rule_id
472: , x_credit_check_rules_rec => l_credit_check_rule_rec
473: );

Line 478: OE_CREDIT_CHECK_UTIL.GET_transaction_amount

474:
475: -- for order level hold we will call
476: IF l_source_column3 = 'ORDER' THEN
477: -- Get new transactional amount
478: OE_CREDIT_CHECK_UTIL.GET_transaction_amount
479: ( p_header_id => l_source_column1
480: , p_transaction_curr_code => l_trx_currency
481: , p_credit_check_rule_rec => l_credit_check_rule_rec
482: , p_system_parameter_rec => NULL

Line 533: OE_CREDIT_CHECK_UTIL.GET_transaction_amount

529: IF nvl(l_site_use_id,-99) > 0 THEN
530: --Get new transactional amount for this bill to site..
531: --Bug 4377933: If customer_id is passed as NULL,then this API returns the transaction
532: --amount for site..
533: OE_CREDIT_CHECK_UTIL.GET_transaction_amount
534: ( p_header_id => l_source_column1
535: , p_transaction_curr_code => l_trx_currency
536: , p_credit_check_rule_rec => l_credit_check_rule_rec
537: , p_system_parameter_rec => NULL

Line 585: OE_CREDIT_CHECK_UTIL.GET_transaction_amount

581: END LOOP;
582: END IF;
583: --ELSE --If the order goes on hold using customer credit limits --13987649
584: ELSIF nvl(l_cust_account_id,-99) > 0 THEN --13987649
585: OE_CREDIT_CHECK_UTIL.GET_transaction_amount
586: ( p_header_id => l_source_column1
587: , p_transaction_curr_code => l_trx_currency
588: , p_credit_check_rule_rec => l_credit_check_rule_rec
589: , p_system_parameter_rec => NULL

Line 637: OE_CREDIT_CHECK_UTIL.GET_transaction_amount

633: --13987649 Start
634: ELSIF nvl(l_party_id,-99) > 0 THEN
635: oe_debug_pub.add('OEXCRRQB Line Level, Party ID= '||l_party_id||' -Orig Chk Level- '||l_credit_check_rule_rec.credit_check_level_code);
636: l_credit_check_rule_rec.credit_check_level_code := 'ORDER';
637: OE_CREDIT_CHECK_UTIL.GET_transaction_amount
638: ( p_header_id => l_source_column1
639: , p_transaction_curr_code => l_trx_currency
640: , p_credit_check_rule_rec => l_credit_check_rule_rec
641: , p_system_parameter_rec => NULL