136: -- From the above fetch, it is possible that lot_status_id is NULL in which
137: -- case get the default lot status id for the organization item.
138:
139: if (x_Status <> 'E') AND (lot_status_id is null) then
140: INV_MATERIAL_STATUS_GRP.get_lot_serial_status_control(
141: p_organization_id => p_org_id
142: , p_inventory_item_id => p_item_id
143: , x_return_status => l_return_status
144: , x_msg_count => l_msg_count
217: -- From the above fetch, it is possible that serial_status_id is NULL in which
218: -- case get the default serial status id for the organization item.
219:
220: if (x_Status <> 'E') AND (serial_status_id is null) then
221: INV_MATERIAL_STATUS_GRP.get_lot_serial_status_control(
222: p_organization_id => p_org_id
223: , p_inventory_item_id => p_item_id
224: , x_return_status => l_return_status
225: , x_msg_count => l_msg_count