4342: *********************************************************************************************************************************/
4343: PROCEDURE Get_Line_Adjustments
4344: (
4345: p_line_rec IN OE_Order_Pub.Line_Rec_Type
4346: ,x_line_adjustments OUT NOCOPY OE_Header_Adj_Util.Line_Adjustments_Tab_Type
4347: )
4348: IS
4349: --
4350: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4348: IS
4349: --
4350: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4351: --
4352: l_adjustments_tbl OE_Header_Adj_Util.Line_Adjustments_Tab_Type;
4353: l_adj_rec OE_Header_Adj_Util.Line_Adjustments_Rec_Type;
4354: l_header_id NUMBER;
4355: l_line_id NUMBER;
4356:
4349: --
4350: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4351: --
4352: l_adjustments_tbl OE_Header_Adj_Util.Line_Adjustments_Tab_Type;
4353: l_adj_rec OE_Header_Adj_Util.Line_Adjustments_Rec_Type;
4354: l_header_id NUMBER;
4355: l_line_id NUMBER;
4356:
4357: BEGIN
4356:
4357: BEGIN
4358:
4359: IF l_debug_level > 0 THEN
4360: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.GET_LINE_ADJUSTMENTS' , 1 ) ;
4361: END IF;
4362:
4363: IF(p_line_rec.retrobill_request_id = 0) THEN
4364: l_header_id := p_line_rec.header_id;
4372: oe_debug_pub.add('HEADER ID:'||l_header_id);
4373: oe_debug_pub.add('LINE ID:'||l_line_id);
4374: END IF;
4375:
4376: OE_Header_Adj_Util.Get_Line_Adjustments
4377: (p_header_id => l_header_id
4378: ,p_line_id => l_line_id
4379: ,x_line_adjustments => l_adjustments_tbl);
4380:
4409:
4410: END IF;
4411:
4412: IF l_debug_level > 0 THEN
4413: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.GET_LINE_ADJUSTMENTS' , 1 ) ;
4414: END IF;
4415:
4416: END Get_Line_Adjustments;
4417: