175: -- Update the line type and the line number of existing
176: -- lines if they are from blanket or requisition.
177: update pon_item_prices_interface p1
178: set line_type = (select tl.line_type
179: from po_line_types_tl tl,
180: pon_auction_item_prices_all pal
181: where p1.batch_id = p_batch_id
182: and p1.action = g_update_action
183: and pal.auction_header_id = p1.auction_header_id