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