DBA Data[Home] [Help]

APPS.ONT_FREIGHT_UTIL dependencies on QP_PREQ_GRP

Line 42: l_Price_Control_rec QP_PREQ_GRP.control_record_type;

38: l_dummy Varchar2(30);
39: l_inv_interfaced_flag Varchar2(1);
40: l_oe_interfaced_flag Varchar2(1);
41: j Number;
42: l_Price_Control_rec QP_PREQ_GRP.control_record_type;
43: l_return_status VARCHAR2(5);
44: l_x_line_tbl oe_order_pub.line_tbl_type;
45: l_pricing_status_code VARCHAR2(15);
46:

Line 455: l_Price_Control_Rec.calculate_flag := QP_PREQ_GRP.G_SEARCH_N_CALCULATE;

451: Simulating pricing engine call to make sure pricing engine returns this freight charge modifier
452: **********************************************************************************************/
453: DBMS_DEBUG('Testing if pricing engine returns this modifier');
454: l_Price_Control_Rec.pricing_event := 'SHIP';
455: l_Price_Control_Rec.calculate_flag := QP_PREQ_GRP.G_SEARCH_N_CALCULATE;
456: l_Price_Control_Rec.Simulation_Flag := 'N';
457: oe_order_Adj_pvt.Price_line(X_Return_Status => l_Return_Status
458: ,p_header_id => l_line_rec.header_id
459: ,p_Request_Type_code=> 'ONT'

Line 469: If l_pricing_status_code <> QP_PREQ_GRP.G_STATUS_NEW Then

465: into l_pricing_status_code
466: From qp_preq_ldets_tmp
467: Where created_from_list_line_id = l_list_line_info.list_line_id;
468:
469: If l_pricing_status_code <> QP_PREQ_GRP.G_STATUS_NEW Then
470: DBMS_DEBUG('Error: Oracle Pricing did not find this modifier line:'||l_list_line_info.list_line_id);
471: DBMS_DEBUG(' : Pricing status code from pricing engine is:'||l_pricing_status_code);
472: Else
473: DBMS_DEBUG('Passed');