APPS.HZ_CREDIT_REQUEST_PVT dependencies on OE_CREDIT_CHECK_UTIL

Line 35: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type;

31: )
32: RETURN VARCHAR2
33: IS
34: l_key VARCHAR2(240);
35: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type;
36: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
37: l_credit_check_rule_id NUMBER;
38: l_limit_currency AR_CMGT_CREDIT_REQUESTS.limit_currency%TYPE;
39: l_trx_amount NUMBER;

Line 51: l_conversion_status OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE ;

47:
48: l_new_amount NUMBER;
49:
50: l_cc_result_out VARCHAR2(30);
51: l_conversion_status OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE ;
52: l_msg_count NUMBER;
53: l_msg_data VARCHAR2(2000);
54: l_return_status VARCHAR2(30);
55: l_credit_request_id NUMBER;

Line 168: OE_CREDIT_CHECK_UTIL.GET_credit_check_rule

164: MO_GLOBAL.set_policy_context('S', l_source_org_id);
165: --MO_GLOBAL.INIT('ONT');
166:
167: --Populate credit check rule record
168: OE_CREDIT_CHECK_UTIL.GET_credit_check_rule
169: ( p_header_id => l_source_column1
170: , p_credit_check_rule_id => l_credit_check_rule_id
171: , x_credit_check_rules_rec => l_credit_check_rule_rec
172: );

Line 177: OE_CREDIT_CHECK_UTIL.GET_transaction_amount

173:
174: -- for order level hold we will call
175: IF l_source_column3 = 'ORDER' THEN
176: -- Get new transactional amount
177: OE_CREDIT_CHECK_UTIL.GET_transaction_amount
178: ( p_header_id => l_source_column1
179: , p_transaction_curr_code => l_trx_currency
180: , p_credit_check_rule_rec => l_credit_check_rule_rec
181: , p_system_parameter_rec => NULL

Line 220: OE_CREDIT_CHECK_UTIL.GET_transaction_amount

216: IF nvl(l_site_use_id,-99) > 0 THEN
217: --Get new transactional amount for this bill to site..
218: --Bug 4377933: If customer_id is passed as NULL,then this API returns the transaction
219: --amount for site..
220: OE_CREDIT_CHECK_UTIL.GET_transaction_amount
221: ( p_header_id => l_source_column1
222: , p_transaction_curr_code => l_trx_currency
223: , p_credit_check_rule_rec => l_credit_check_rule_rec
224: , p_system_parameter_rec => NULL

Line 258: OE_CREDIT_CHECK_UTIL.GET_transaction_amount

254: );
255: END LOOP;
256: END IF;
257: ELSE --If the order goes on hold using customer credit limits
258: OE_CREDIT_CHECK_UTIL.GET_transaction_amount
259: ( p_header_id => l_source_column1
260: , p_transaction_curr_code => l_trx_currency
261: , p_credit_check_rule_rec => l_credit_check_rule_rec
262: , p_system_parameter_rec => NULL