The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT set_status INTO l_set_status
FROM oe_sets
WHERE set_id = p_initial_line_rec.ship_set_id
AND set_type = 'SHIP_SET';
l_rowtype_rec.AUTO_SELECTED_QUANTITY := FND_API.G_MISS_NUM;
l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
l_rowtype_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
x_rowtype_rec.AUTO_SELECTED_QUANTITY := p_line_rec.AUTO_SELECTED_QUANTITY;
x_rowtype_rec.LAST_UPDATED_BY := p_line_rec.LAST_UPDATED_BY;
x_rowtype_rec.LAST_UPDATE_DATE := p_line_rec.LAST_UPDATE_DATE;
x_rowtype_rec.LAST_UPDATE_LOGIN := p_line_rec.LAST_UPDATE_LOGIN;
x_rowtype_rec.PROGRAM_UPDATE_DATE := p_line_rec.PROGRAM_UPDATE_DATE;
x_api_rec.AUTO_SELECTED_QUANTITY := p_record.AUTO_SELECTED_QUANTITY;
x_api_rec.LAST_UPDATED_BY := p_record.LAST_UPDATED_BY;
x_api_rec.LAST_UPDATE_DATE := p_record.LAST_UPDATE_DATE;
x_api_rec.LAST_UPDATE_LOGIN := p_record.LAST_UPDATE_LOGIN;
x_api_rec.PROGRAM_UPDATE_DATE := p_record.PROGRAM_UPDATE_DATE;
OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'N';