594:
595:
596: IF p_adjustment_level = 'HEADER' THEN
597: oe_debug_pub.add('RETRO:QUERY Order level adjustment');
598: OE_Line_Adj_Util.Query_Rows(p_header_Id => l_query_header_id
599: ,x_Line_Adj_Tbl => x_Line_Adj_Tbl);
600: ELSE
601: oe_debug_pub.add('RETRO:QUERY line level adjustment');
602: OE_Line_Adj_Util.Query_Rows(p_line_Id => l_query_line_id
598: OE_Line_Adj_Util.Query_Rows(p_header_Id => l_query_header_id
599: ,x_Line_Adj_Tbl => x_Line_Adj_Tbl);
600: ELSE
601: oe_debug_pub.add('RETRO:QUERY line level adjustment');
602: OE_Line_Adj_Util.Query_Rows(p_line_Id => l_query_line_id
603: ,x_Line_Adj_Tbl => x_Line_Adj_Tbl);
604: END IF;
605:
606: Exception
756: SELECT Oe_Price_Adjustments_S.Nextval
757: INTO l_line_adj_tbl(i).price_adjustment_id
758: FROM dual;
759:
760: OE_LINE_ADJ_UTIL.Insert_Row(l_line_adj_tbl(i));
761: END IF; --end check for 'DIS', 'PBH' and 'SUR'
762: END IF;
763:
764: close retro_inv_list_line_id;