396: BEGIN
397:
398: Select header_id
399: into l_header_id
400: from oe_order_headers_all
401: where order_number = p_order_number AND
402: order_type_id IN (select tl.transaction_type_id
403: from oe_transaction_types_tl tl,
404: oe_transaction_types_all ta