77: BEGIN
78:
79: SELECT sales_order_id
80: INTO l_demand_source_header_id 81: FROM mtl_sales_orders mso 82: WHERE segment1 = To_Char(x_order_number)
83: AND segment2 = x_order_type
84: AND segment3 = FND_PROFILE.Value_Specific('SO_SOURCE_CODE');
85: