APPS.OE_ORDER_PRICE_PVT dependencies on OE_LINE_UTIL

Line 473: OE_LINE_UTIL.query_rows(p_line_id=>p_line_id

469: IF l_debug_level > 0 THEN
470: oe_debug_pub.add( 'G_RECURSION_MODE:'||OE_GLOBALS.G_RECURSION_MODE ) ;
471: END IF;
472: IF (QP_UTIL.GET_QP_STATUS = 'I' OR OE_GLOBALS.G_RECURSION_MODE <> FND_API.G_TRUE) THEN
473: OE_LINE_UTIL.query_rows(p_line_id=>p_line_id
474: , p_header_id => p_header_id
475: , x_line_tbl => x_line_tbl
476: );
477: IF l_debug_level > 0 THEN

Line 478: oe_debug_pub.add( ' X_LINE_TBL COUNT FROM OE_LINE_UTIL.QUERY_ROWS:'||X_LINE_TBL.COUNT ) ;

474: , p_header_id => p_header_id
475: , x_line_tbl => x_line_tbl
476: );
477: IF l_debug_level > 0 THEN
478: oe_debug_pub.add( ' X_LINE_TBL COUNT FROM OE_LINE_UTIL.QUERY_ROWS:'||X_LINE_TBL.COUNT ) ;
479: END IF;
480: --commented for the FP bug 3335024
481: /*
482: --bug 3289322, pl/sql error when count is zero

Line 2527: OE_Line_Util.Version_Audit_Process(p_x_line_rec => l_line_rec,

2523: , x_return_status => l_return_status
2524: );
2525:
2526: -- Adding code to log versioning/audit request
2527: OE_Line_Util.Version_Audit_Process(p_x_line_rec => l_line_rec,
2528: p_old_line_rec => l_old_line_rec);
2529:
2530: -- bug 3554060
2531: l_line_rec.change_reason := l_old_change_reason;

Line 5512: l_item_type_code := oe_line_util.Get_Return_Item_Type_Code(p_Line_rec);

5508: p_pricing_events ='SHIP' Then
5509: l_req_line_rec.PRICE_FLAG := 'N';
5510: End If;
5511:
5512: l_item_type_code := oe_line_util.Get_Return_Item_Type_Code(p_Line_rec);
5513: -- Do not fetch the price for Configuration items and Included Items
5514: If l_item_type_code in( 'CONFIG','INCLUDED')
5515: Then
5516:

Line 5583: IF oe_line_util.dual_uom_control -- INVCONV Process_Characteristics

5579: IF l_debug_level > 0 THEN
5580: oe_debug_pub.add('l_fulfilled_qty:'|| l_fulfilled_qty);
5581: END IF;
5582:
5583: IF oe_line_util.dual_uom_control -- INVCONV Process_Characteristics
5584: (p_line_rec.inventory_item_id
5585: ,p_line_rec.ship_from_org_id
5586: ,l_item_rec) THEN
5587:

Line 5618: l_ref_line_rec := OE_line_UTIL.Query_Row(p_line_rec.reference_line_id);

5614: END IF; --16206165 CW
5615:
5616: --16206165 CW start
5617: IF p_line_rec.reference_line_id is NOT NULL THEN
5618: l_ref_line_rec := OE_line_UTIL.Query_Row(p_line_rec.reference_line_id);
5619: END IF;
5620:
5621: IF p_line_rec.fulfillment_base IS NOT NULL OR l_ref_line_rec.fulfillment_base IS NOT NULL THEN
5622:

Line 5623: l_catch_weight_pricing := oe_line_util.is_catch_weight(p_Line_rec);

5619: END IF;
5620:
5621: IF p_line_rec.fulfillment_base IS NOT NULL OR l_ref_line_rec.fulfillment_base IS NOT NULL THEN
5622:
5623: l_catch_weight_pricing := oe_line_util.is_catch_weight(p_Line_rec);
5624:
5625: IF l_catch_weight_pricing = 'S' THEN
5626:
5627: IF p_line_rec.shipped_quantity2 IS NOT NULL THEN

Line 6461: --If oe_line_util.Get_Return_Item_Type_Code(l_Line_Tbl(line_Tbl_Index)) <> 'CONFIG' Then

6457:
6458: line_Tbl_Index := l_Line_Tbl.First;
6459: While line_Tbl_Index is not null loop
6460: -- Do not price the config items
6461: --If oe_line_util.Get_Return_Item_Type_Code(l_Line_Tbl(line_Tbl_Index)) <> 'CONFIG' Then
6462:
6463: -- Added to check if Agreement is Active for Bug#2740845
6464: If l_line_tbl(line_Tbl_Index).agreement_id is not null Then
6465: BEGIN

Line 8290: l_line_rec := OE_line_UTIL.Query_Row(p_line_id=> px_Line_Tbl(1).line_id);

8286:
8287:
8288: BEGIN
8289:
8290: l_line_rec := OE_line_UTIL.Query_Row(p_line_id=> px_Line_Tbl(1).line_id);
8291:
8292: IF nvl(l_line_rec.booked_flag, 'N') = 'Y' THEN
8293: l_current_event := 1; /* current event is booking or higher */
8294: END IF;