5002:
5003: --RT}
5004: OE_Version_History_Util.Query_Rows
5005: ( p_line_id => l_line_id
5006: , p_version_number => OE_ORDER_COPY_UTIL.G_LN_VER_NUMBER
5007: , p_phase_change_flag => OE_ORDER_COPY_UTIL.G_LN_PHASE_CHANGE_FLAG
5008: , x_Line_Adj_Tbl => l_Line_Adj_Tbl);
5009:
5010: If l_debug_level > 0 Then
5003: --RT}
5004: OE_Version_History_Util.Query_Rows
5005: ( p_line_id => l_line_id
5006: , p_version_number => OE_ORDER_COPY_UTIL.G_LN_VER_NUMBER
5007: , p_phase_change_flag => OE_ORDER_COPY_UTIL.G_LN_PHASE_CHANGE_FLAG
5008: , x_Line_Adj_Tbl => l_Line_Adj_Tbl);
5009:
5010: If l_debug_level > 0 Then
5011: oe_debug_pub.add(' input line id to retro api:'||p_line_id||' output line id:'|| l_line_id);
5031: --RT}
5032:
5033: OE_Version_History_Util.Query_Rows
5034: ( p_header_id => l_header_id
5035: , p_version_number => OE_ORDER_COPY_UTIL.G_LN_VER_NUMBER
5036: , p_phase_change_flag => OE_ORDER_COPY_UTIL.G_LN_PHASE_CHANGE_FLAG
5037: , x_Line_Adj_Tbl => l_Line_Adj_Tbl);
5038:
5039: If l_debug_level > 0 Then
5032:
5033: OE_Version_History_Util.Query_Rows
5034: ( p_header_id => l_header_id
5035: , p_version_number => OE_ORDER_COPY_UTIL.G_LN_VER_NUMBER
5036: , p_phase_change_flag => OE_ORDER_COPY_UTIL.G_LN_PHASE_CHANGE_FLAG
5037: , x_Line_Adj_Tbl => l_Line_Adj_Tbl);
5038:
5039: If l_debug_level > 0 Then
5040: oe_debug_pub.add(' input Header id to retro api:'||p_header_id||' output Header id:'|| l_header_id);
5388: ,p_retrobill_request_id=>p_retrobill_request_id);
5389: --RT});
5390: --RT{
5391: IF nvl(p_mode,'xx-') = 'RETROBILL' THEN
5392: OE_ORDER_COPY_UTIL.G_ORDER_LEVEL_COPY :=0;
5393: END IF;
5394: --RT}
5395: -- Append Header level adjustments only if the order is different
5396: /* Modified the following if condition to fix the bug 2170086 */
5398: oe_debug_pub.add('pviprana: p_to_header_id'||p_to_header_id);
5399: oe_debug_pub.add('pviprana: p_from_line_id'||p_from_line_id);
5400: oe_debug_pub.add('pviprana: p_to_line_id'||p_to_line_id);
5401: If p_from_Header_id <> p_to_Header_id and
5402: OE_ORDER_COPY_UTIL.G_ORDER_LEVEL_COPY = 0 then
5403: --bug3392650 passing an extra parameter p_key_line_id if the mode is 'RETROBILL' so that l_ulp is obtained properly in
5404: --append_adjustment_lines when the order level modifier is being converted to line level.
5405: IF nvl(p_mode,'xx-') = 'RETROBILL' THEN
5406: Append_Adjustment_Lines(